《c#图书管理系统源代码档.doc》由会员分享，可在线阅读，更多相关《c#图书管理系统源代码档.doc（59页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、学校的图书馆管理系统，这个是一个很实用的系统，相信很多做软件编程的都做过这个例子。下面这个是我的一个学生今年的毕业设计课题，做的不错，在学校的毕业设计中得到了优等，拿到省里面去评比了。1.登陆界面主要代码：public partial class LoginForm : Form public static string uacc; public static string upsw; public static string uname; public static string usex; public static string upart; public static string u
2、right; public LoginForm() InitializeComponent(); private void loginbtn_Click(object sender, EventArgs e) if (this.useracctxt.Text.Trim() = & this.pswtxt.Text = ) MessageBox.Show(请输入您的用户名和密码！, 提示！); return; try string sql; sql = select * from tb_user where uacc= + this.useracctxt.Text + and upsw= + t
3、his.pswtxt.Text + ; OleDbDataReader dr = DBHelp.OleReader(sql); dr.Read(); if (dr.HasRows) uacc = this.useracctxt.Text; upsw = this.pswtxt.Text; uname = druname.ToString(); usex = drusex.ToString(); upart = drupart.ToString(); uright = druright.ToString(); MainForm af = new MainForm(this); this.Hide
4、(); this.useracctxt.Clear(); this.pswtxt.Clear(); af.Show(); else MessageBox.Show(账号或密码错误！, 提示！); this.useracctxt.Clear(); this.pswtxt.Clear(); this.useracctxt.Focus(); catch (Exception) MessageBox.Show(数据库无法连接！, 警告！); private void cancelbtn_Click(object sender, EventArgs e) Application.Exit(); priv
5、ate void LoginForm_Closing(object sender, FormClosingEventArgs e) Application.Exit(); 2.主界面（图较小，自己可以拉大点）主要代码就不写了，很简单。3.权限设置主要代码：public partial class RightSet : Form public RightSet() InitializeComponent(); private void RightSet_Load(object sender, EventArgs e) this.rightbox.SelectedIndex = 0; /this.
6、treeright.ExpandAll(); Fill(); private void okbtn_Click(object sender, EventArgs e) if (this.txtnum.Text = string.Empty) MessageBox.Show(请输入最大借阅图书数量！, 提示！); return; if (this.txtday.Text = string.Empty) MessageBox.Show(请输入最大借阅图书时间！, 提示！); return; if (this.txtcost.Text = string.Empty) MessageBox.Show(
7、请输入借书押金金额！, 提示！); return; if (this.txtfine.Text = string.Empty) MessageBox.Show(请输入超期罚款金额！, 提示！); return; if (this.txttim.Text = string.Empty) MessageBox.Show(请输入图书遗失罚款倍数！, 提示！); return; ArrayList arr = new ArrayList(); foreach (TreeNode nodes in this.treeright.Nodes) if (nodes.Checked) arr.Add(1);
8、else arr.Add(0); foreach(TreeNode node in nodes.Nodes) if (node.Checked) arr.Add(1); else arr.Add(0); string a=new string11; for (int i = 0; i arr.Count; i+) if (arri.ToString().Trim() = 1) ai = yes; else ai = no; string sql = string.Empty; sql += select * from tb_right where uright= + this.rightbox
9、.Text + ; DataTable dt = DBHelp.ExeOleCommand(sql); bool b = false; while (dt.Rows.Count != 0) b = true; break; string sql1; if (b) sql1 = update tb_right set ; sql1 += maxbook= + this.txtnum.Text + ,; sql1 += maxdate= + this.txtday.Text + ,; sql1 += rcost= + this.txtcost.Text + ,; sql1 += rfine= +
10、this.txtfine.Text + ,; sql1 += rtim= + this.txttim.Text + ,; sql1 += rbm= + a0 + ,; sql1 += rum= + a1 + ,; sql1 += rrm= + a2 + ,; sql1 += rborm= + a3 + ,; sql1 += ris= + a4 + ,; sql1 += rbis= + a5 + ,; sql1 += ruis= + a6 + ,; sql1 += rboris= + a7 + ,; sql1 += rblp= + a8 + ,; sql1 += rbl= + a9 + ,; s
11、ql1 += rlp= + a10 + ; sql1 += where uright= + this.rightbox.Text + ; else sql1 = insert into tb_right(uright,maxbook,maxdate,rcost,rfine,rtim,rbm,rum,rrm,rborm,ris,rbis,ruis,rboris,rblp,rbl,rlp); sql1 += values( + this.rightbox.Text + , + this.txtnum.Text + , + this.txtday.Text + , + this.txtcost.Te
12、xt + , + this.txtfine.Text + , + this.txttim.Text + , + a0 + , + a1 + , + a2 + , + a3 + , + a4 + , + a5 + , + a6 + , + a7 + , + a8 + , + a9 + , + a10 + ); DataTable dt1 = DBHelp.ExeOleCommand(sql1); Fill(); private void Fill() string sql; sql = select rid as ID号,uright as 用户身份, maxbook as 最大借书数量,max
13、date as 最大借阅时间,rcost as 押金,rfine as 超期罚率,rtim as 遗失赔率,rbm as 图书管理,rum as 用户管理,rrm as 权限管理,rborm as 借阅管理,ris as 信息查询,rbis as 图书信息查询,ruis as 用户信息查询,rboris as 借阅历史查询,rblp as 图书挂失处理,rbl as 图书挂失,rlp as 挂失处理 from tb_right; DataTable dt = DBHelp.ExeOleCommand(sql); this.dataGridView1.DataSource = dt; priva
14、te void cell_click(object sender, DataGridViewCellEventArgs e) this.rightbox.Text = this.dataGridView11, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtnum.Text = this.dataGridView12, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtday.Text = this.d
15、ataGridView13, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtcost.Text = this.dataGridView14, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtfine.Text = this.dataGridView15, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txt
16、tim.Text = this.dataGridView16, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); ArrayList list = new ArrayList(); string sql = select * from tb_right where uright= + this.rightbox.Text + ; DataTable dt = DBHelp.ExeOleCommand(sql); if (dt.Rows.Count != 0) for (int i = 0; i 11; i+) li
17、st.Add(dt.Rows07+i.ToString(); ArrayList arr = new ArrayList(); foreach (TreeNode nodes in this.treeright.Nodes) arr.Add(nodes); foreach(TreeNode node in nodes.Nodes) arr.Add(node); for (int i = 0; i list.Count; i+) if (listi.ToString() = yes) (TreeNode)arri).Checked = true; else (TreeNode)arri).Che
18、cked = false; 4.权限修改主要代码：public partial class UserRight : Form public UserRight() InitializeComponent(); private void btncancel_Click(object sender, EventArgs e) this.Close(); private void UserRight_Load(object sender, EventArgs e) this.checkbox.SelectedIndex = 0; this.partbox.SelectedIndex = 0; pri
19、vate void Fill() if (this.checkbox.Text = ) MessageBox.Show(请选择要使用的查询字段！, 提示！); return; if (this.partbox.Text = ) MessageBox.Show(请选择用户所在的部门！, 提示！); return; string sql = string.Empty; sql += select uid as ID号,uacc as 帐号,uname as 姓名,usex as 性别,upart as 部门,utelphone as 移动电话,uphone as 固定电话,udate as 注册日
20、期,uright as 权限 from tb_user; if (this.checktxt.Text != ) string c = this.checkbox.SelectedIndex.ToString(); switch (c) case 0:/用户帐号 if (this.checktxt.Text != string.Empty) sql += where uacc like % + this.checktxt.Text + %; break; case 1:/用户姓名 if (this.checktxt.Text != string.Empty) sql += where unam
21、e like % + this.checktxt.Text + %; break; default: break; if (this.partbox.SelectedIndex.ToString() != 0) sql += and upart= + this.partbox.Text + ; else if (this.partbox.SelectedIndex.ToString() != 0) sql += where upart= + this.partbox.Text + ; sql += order by uacc asc; DataTable dt = DBHelp.ExeOleC
22、ommand(sql); this.dataGridView1.DataSource = dt; private void checkbtn_Click(object sender, EventArgs e) Fill(); private void cell_click(object sender, DataGridViewCellEventArgs e) this.txtuacc.Text = this.dataGridView11, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtname.
23、Text = this.dataGridView12, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtsex.Text = this.dataGridView13, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtpart.Text = this.dataGridView14, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim
24、(); this.txttel.Text = this.dataGridView15, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtphone.Text = this.dataGridView16, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtdate.Text = this.dataGridView17, this.dataGridView1.CurrentCell.RowIndex.Val
25、ue.ToString().Trim(); this.txtright.Text = this.dataGridView18, this.dataGridView1.CurrentCell.RowIndex.Value.ToString().Trim(); this.txtright.Enabled = true; private void btnchange_Click(object sender, EventArgs e) if (this.txtuacc.Text = ) MessageBox.Show(执行操作前，请先在下表选择要修改的用户！, 提示！); return; Dialog
26、Result res; res=MessageBox.Show(您确定要修改该用户吗？, 提示！, MessageBoxButtons.YesNo); if (res = DialogResult.Yes) string sql = string.Empty; sql += update tb_user set uright=+this.txtright.Text+; sql += where uacc=+this.txtuacc.Text+; DataTable dt = DBHelp.ExeOleCommand(sql); MessageBox.Show(修改成功！,恭喜！); Fill(
27、); 5.添加图书信息主要代码：public partial class NewBook : Form public NewBook() InitializeComponent(); private void retbtn_Click(object sender, EventArgs e) this.Hide(); private void savebtn_Click(object sender, EventArgs e) if (this.booknotxt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.bookname
28、txt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.classtxt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.isbntxt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.bookcosttxt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.bookwritertxt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.bookpubtxt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.numtxt.Text = ) MessageBox.Show(请输入图书的信息！, 提示！); return; if (this.notetxt.Text =