c#图书管理系统源代码.docx

主要代码:pub 1ic partialclass :nl-orm : l-'onn publicstaticstring uacc;publicstaticstring upsw;publicstaticstring uname;publicstaticstring usex;publicstaticstring upart;publi cstaticstring uright;public LoginFormOInitializeComponent();1.登陆界面private void loginbtn Click (object sender, EvcntArgs e)if (this, useracctxt. Text. TrimO && this, pswtxt. Text =return;try(string sql;sql = "select * from tb user where uacc=，" + this, useracctxt. Text + and upsw=，+ this, pswtxt. Text +;OleDbDatdReader dr = DBIIelp. OleReader(sql);dr. Read 0 ;if (dr. HasRows)(uacc = this.useracctxt. Text;upsw = this.pswtxt. Text;uname = dr"uname". ToStringO ;usex = dr"usex". ToStringO ;upart = dr"upart". ToStringO ;uright = dr*uright*. ToStringO ;MainForm af = new MainForm(this);this. Hide();this, useracctxt. Clear 0;this, pswtxt. Clear();af. Show ();)else(MessageBox.Show (“账号或密码错误!"提示!");this. useracctxt. Clear ();this, pswtxt. Clear ();this, useracctxt. Focus 0;)catch (Except ion)(VessageBox. Show ("数据库无法连接!"，"警告!”)；)private void cancelbtn_Click(object sender, EventArgs e)(Application. Exit();private void LoginForm_Closing(object sender, l;orm(JosingEventArgs e)Appli ceil ion. Exit ();)2 .主界面(图较小,自己可以拉大点)主要代码就不写了,很简单。3 .权限设置主要代码:public partial class RightSet : Formpublic RightSet0(InitializeComponent();)e)private void RightSet_Load(object sender,(this, rightbox. Selectedlndex = 0;/this, treeright. ExpandAl 1 ();FillO;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（”请输入借书押金金额！","提示!"）； return;if (this, txtfine. Text = string. Empty)McssageBox.Show（"请输入超期罚款金额!，”提示!"）； return;if (this, txttim. Textstring. Empty)MessageBox.Show("请输入图书遗失罚款倍数!"，”提示!;return;I i st arr = new0 ;foreach (TreeXode nodes in this.treeright. Nodes)if (nodes. Checked)arr. Add("l");elsearr. Add("0");foreach(TreeNode node in nodes. Nodes)i f (node. Checked)arr. Add ("1");elsearr. Add ("0”);string a=new stringl1;for (int i = 0; i < arr. Count; i+)if (arri. ToStringO. TrimO = T)ai = "yes”;elseai = "nostring sql = string. Empty：sql += "select * from tb_right where urighl=+ this, rightbox. Text +DataTable dt = DBHeIp. ExeOleCommand(sql)： bool b = false;while (dt. Rows. Count != 0)b = true;break;string sqll;if (b)sql1 = "update tb_right set "sql1+="maxbook=+ thi s. txtnum.Text +sql1+="maxdate=+ this, txtday. Text +sql 1+="rcost=+this, txtcost. Text +sql 1+=*rfine=，*+this, txtfine. Text +sqll += *rtim=+ this, txttim. Text +sqll += "rbm='"+ a0 + sqll += "rum=' " + al +sqll += "rrm=，" + a2 +sqll += "rborm=' " + a3sqll += "ris='"+ a4 +sqll += "rbis=，* + a5 + *',"sqll += "ruis=, " + a6 + "',"：sqll += *rboris=* * + a7 +sqll += "rblp= " + a8sqll += "rbl=' " + a 9 +sqll += "rip='"+ a10 +"sqll +二"where uright=' " + this.rightbox. Text +;)else(sql! 二 insert intotb_right (uright, raaxbook, maxdate, rcost, rfine, rtim, rbm, rum, rrm, rborm, ris, rbis, ruis, rboris, rblp ,rbl,rlp)"sqll + 二values(' " + this, rightbox. Text +,+ this, txtnum. Text +,+this, txtday. Text + *',' * + this, txtcost. Text + *',' " + this, txtfine. Text +" +this, txttim. Text +a0+ al+ a2a3 +" + a4 + a5+ a6+ a7+ a8a9+ a10 + "')DataTable dtl = DBHelp. ExeOleCommand(sqll);FillO;private void Fill ()string sql;sql = "select rid as ID 号，uright as 用户身份,max book as 最大借书数鼠,maxdate as 最大借阅时间,rcost as押金,rfineas超期罚率,rtim as遗失赔率,rbm as图书管理,rum as用户管理,门'm as权限管理,rborm as借阅管理，ris as信息查询,rbis as图书信息查询,ruis as用户信息查询,rborisas借阅历史査询,rblp as图书挂失处理,rbl as图书挂失,rip as挂失处理from tb_right*;DataTable dt = DBHe1p. ExeOleCommand(sql);this. dataGridViewl. DataSource = dt;private void cell_click(object sender, DataGridViewCe11EventArgs e)this, rightbox. Text = this. dataGridViewl 1, this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToStringO. TrimO ;this, txtnum. Text = this. dataGridViewl2,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToStringO. TrimO ;this, txtday.Text = this. dataGridViewl3,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToStringO. TrimO ;this, txtcost. Text = this. dataGridViewl4,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToStringO. TrimO ;this, txtfine. Text = this. dataGridViewl5,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToStringO. TrimO ;this, txttim. Text = this. dataGridViewl6,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToStringO. TrimO ;ArrayList list = new ArrayList();string sql = "select * from tb_right where uright二 + this, rightbox. Text +DataTable dt = DBHelp. ExeOleConunand(sql);if (dt. Rows. Count != 0)for (int i = 0; i < 11; i+)1 ist. Add(dt. Rows0 7+i. ToStringO);ArrayList arr = new ArrayLi st ();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. ToStringO = "yes")(T)(?eNode)arri). Checked = true;else(TreeNode)arri). Checked = false;4 .权限修改主要代码:public partial class UserRight : Form(public UserRight0(InitializeComponent();private void btncancel_Click(object sender, EventArgs e)(this. CloseO;)private void UserRight Load(object sender, EventArgs e)(thi s.checkbox. Seiectedlndex = 0;this, partbox. Selectedlndex = 0;private void Fill ()if (this, checkbox. Text =VcssageBox. Show（"请选择要使用的査询字段!”，"提示!”）； return;if (this, part box. Text =)MessageBox.Show（"请选择用户所在的部门！"，"提示!”）； return;string sql = string. Empty;sql += "sei ect ui d as 11) uacc as 帐号,unamc as 姓名，usex as 性别,upart as 部f J, uteIphone as 移动电话，uphone as 固定电话,udate as 注册 II 期,uright as 权限 from tb user"if (this, checktxt. Text !="")string c = this, checkbox. Selectedlndex. ToStringO ;switch (c)(case "”:用户帐号if (this, checktxt. Text != string. Empty)(sql += " where uacc 1 ike * %" + this, checktxt. Text + "%")break;case "1":用户姓名if (this, checktxt. Text != string. Empty)(sql += " where uname like * %" + this.checktxt. Text + "%* *)break;default:break;if (this, partbox. Selectedlndex. ToStringO != "0")sql += " and upart='"+ this, partbox. Text + ")else(if (this, partbox. Selected Index. ToStringO != "0")(sql += " where upart=+ thi s. partbox. Text +)sql += " order by uacc asc"DataTable dt = DBHelp. ExeOleCommand(sql);this. dataGridViewl. DataSource = dt;pri vate voi d checkbtn_Click (object sender, Invent Args e)FillO;private void cel l_c lick (object sender, Da t tiGi, i dV i ewCe 11 E ent A s e)this, txtuacc. Text = this. dataGridViewll, this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToString(). TrimO ;this, txtname. Text = this. dataGridViewl2,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToString(). TrimO ;this, txtsex. Text = this. dataGridViewl 3,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToString(). TrimO ;this, txtpart. Text = this. dataGridViewl4,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToString(). TrimO ;this, txttel. Text = this. dataGridViewl 5,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToString(). TrimO ;this, txtphone. Text = this. dataGridViewl 6,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToString0. TrimO ;this, txtdate. Text = this. dataGridViewl7,this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToString(). TrimO ;this, txtright. Text = this. dataGridViewl 8, this. dataGridViewl. CurrentCel 1. Rowindex. Value. ToStringO. TrimO ;this, txtright.Enabled = true;if (this, txtuacc. Text =MessageBox. Show（"执行操作前,请先在下表选择要修改的用户!* "提示!”）;return;DialogResult res;res二山Show("您确定要修改该用丿、吗?"，"提小!"，.iif (res = DialogResult.Yes)(string sql = string. Empty;sql +="update tb_user set uright= +this. txtright. Text+ ;sql += * where uacc二'"+this. txtuacc. Text+ ;DcitaTable dt = DBHelp. ExeOleCommand (sql);Mes sage Box. Show ("修改成功!"，"恭喜!")；FillO;5 .添加图书信息主要代码:public partial class NewBook : Formpublic 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 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 ="")MessagcBox. Show ("请输入图书的信息!","提示!;return：)if (this, bookpubtxt. Text =)(MessageBox. Show ("请输入图书的信息!”，"提示!")； return;if (this, numtxt. Text =)(MessagcBox. Show("请输入图书的信息!","提示！”)； return：)if (this, notetxt. Text ="")(MessageBox. Show("请输入图书的信息！"，"提示!")； return;/string pat3 =u4e00-u9fa5+$” ;/全为汉字/string pat4 =(u4e00-u9fa5+ A-Za-z+)$”;汉字或字母/string pat5 =u4e00-u9fa5 2, 4 $”;两到四位汉字string patl =(d-*) 9 dxX$”;图书的ISBN号格式X-XXXX-XXXX-X或X-XH-XXXH-X (X为数字,以图书实际ISBN号为准)string pat2 =+?1-9 9*$”;正整数string pat3 = "(0 1-9 0-9*) (. 0-9 2)?$”;双精度浮点数bool ml = Program, match (this, isbntxt. Text, patl);bool m2 = Progriun. match (this, numtxt. Text, pat2);bool m3 = Program, match (this, book cost txt. Text, pat3);if (!ml)(McssageBcx.Show("图"的ISBN号格式为X-XXXX-XXXX-X或X-XXX-XXXXX-X (X为数字,以 图书实际ISBN号为准)！"，"提示!”)；this, isbntxt. Text = *"return;)if (!m2)MessageBox.Show（"图书购买数量应为大于的整数!","提示!"）;this, numtxt. Text return;if (!m3)MessageBox. Show ("图书价格应为 XX. XX 元!”,"提示!”)；this, bookcosttxt. Text = return;int num;num = Convert. Tolnt32(this, numtxt. Text);for (int i = 1, k = Convert. Tolnt32 (this, booknotxt. Text); i <= num; i+, k+)string sql;sql = " insert intotb_book (bno, bname, bclass, bisbn, bcost, adder, adddate, bauthor, bpub, bstate, bnote)”+ "values (* * + k. ToString0 +,+ this, booknametxt. Text +" +this, classtxt. Text + "',+ this, isbntxt. Text +,+ this, bookcosttxt. Text +,+Log in Form, uname +,+ Dat eTime. Now. ToString () +，"+ this, bookwritertxt. Text +this, bookpubtxt. Text + "'，'在库，'"+ thi s. notetxt. Text + "')"L，dt = DBIIc I p. ExeOleCommand (sql);MessageBox.Show ("注册成功!",“恭喜! ");this. Hide();private void rebtn_Click(object sender, EventArgs e)this, isbntxt. Clear0 ;Clears ();private void Clears 0thi s. book name txt. Cl ear ();/this, isbntxt. ClearO ;this, bookcosttxt. ClearO ;this. bookwritertxt. ClearO ;this, bookpubtxt. Clear 0;this, notetxt. ClearO;thi s. numtxt. Clear ();private void NewBook Load(object sender, EventArgs e)/*string sql;sql = "select bno from tbbook order by bno asc"DataTable dt = DBHelp. ExeOleCommand(sql);for (int i = 0, k = 10000001; i < 1; i+, k+)(for (int j = 0; j < dt. Rows. Count; j+)(if (dt. Rowstj 0. ToStringO. Trim(). Equals(k. ToStringO) k+;)this, booknotxt. Items. Add(k. ToStringO);this, booknotxt. Selectedlndex = 0;this, classtxt. Selectedlndex = 0;string sql;sql = "select top 1 bno from tb book order by bno desc"DataTable dt = DBHelp. ExeOleCommand(sql);int k;for (int i = 0; i < 1; i+)if (dt. Rows 0 0. ToStringO = *)(k = 10000001;else(k = Convert. Tolnt32 (dt. Rows 0 0. ToString();k+;)this, booknotxt. Items. Add(k. ToStringO);this, booknotxt. Selectedlndex = 0;this, classtxt. SelectedIndex = 0;private void findbtn_Click(object sender, EventArgs e)if (this, isbntxt. Text =MessageBox.Show请输入图书的:SBN号!”,"提示!");return;string sql;sql = "select * from tb_book where bisbn=，" + this, isbntxt. Text +OleDbDataReader dr = DBHelp. OleReader(sql);dr. Read 0 ;i f (dr. HasRows)this, bookname txt. Text = dr*bname". ToStringO. Trim();thi s. classtxt. Text = dr "be lass". ToStringO. TrimO ;this, bookcosttxt. Text = dr*bcost". ToStringO. TrimO ;this, bookwritertxt. Text = dr"bauthor". ToStringO. TrimO ;this. bookpubtxt. Text = dr"bpub". ToStringO. TrimO ;this, notetxt. Text = dr*bnote". ToStringO. TrimO ;eB .Show("找到匹配闇行信息,自动填充基本信息,请填充余卜信息! ”,"提示!;this, numtxt. Enabled = true;else（ClearsO;MessageBox. Show （"未找到匹配图书信息!”,"提示!"）;this, booknotxt. Enabled = true;this, bookname txt. Enabled = true;this, classtxt. Enabled = true;this, bookcosttxt. Enabled = true;this, bookwritertxt. Enabled = true;this, bookpubtxt.Enabled = true;this, numtxt. Enabled = true;this, notetxt. Enabled = true;6 .图书信息管理主要代码:public partial class BookManage : Formpublic BookManage()InitializeComponent();string bookisbn;private void BookManage Load(object sender, EventArgs e)this, checkbox. Selectedlndex = 0;this, classbox. Selectedlndex = 0;private void checkbtn_Click (object sender, liventArgs e)FillGridO;private void cel l_c lick (object sender, Da t tiGi, i dV i ewCe 11 E ent A s e)FilllnfoO;private void nobtn_Click(object sender, EventArgs e)this. CloseO;private void okbtn_Click(object sender, EventArgs e)if (this, nametxt. Text = string. Empty)MessageBox.Show("执行操作前,请先选择图书! "提示!;return;修改同ISBN图书信息string sql2= string. Empty;sql2 += update tb book set bisbn:+ this.isbntxt.Text +,bname=十this, nametxt. Text + *, bclass=, * + this, classtxt. Text + *, bcost=* + this, costtxt. Text + ”,baulhor ='"+ this, writertxt. Text +, bpub二+ this, pubtxt. Text +, adder=+this, addertxt. Text +, bnote=' " + this, notetxt. Text +sql2 += " where bisbn二+ this.bookisbn +DataTable dt2 = DBHelp. Exe01eCommand(sql2);string sql5 = string. Empty;sql5 += "update tb borrow set bname= + this, nametxt. Text +, bisbn =+this, isbntxt.zText +;sql5 += " where bisbn:'"+ this, bookisbn + *'DataTable dt5 = DBHelp. Exe01eCommand(sql5);MessageBox.Show("该类图书信息修改成功!"，"提示!")；this, checktxt. Text 二 ;FillGridO;FilllnfoO;pri vate void Fi UGridOif (this, checkbox. Text = string. Empty)MessageBox.Show（"请输入你要使用的检索条件!”，"提示!”）； return;if (this, classbox. Text = string. Empty)MessageBox.Show（"请输入你要查找的图书类型！","提示!”）； return;string sql = string. Empty;sql += "select bid as ID号,bno as 图书编号，bname as 图书名称,bauthor as 作者, bclass as 类别，bi sbn as ISBN号,bcost