c-图书管理系统源代码大全

1.登陆界面主要代码:publicpartialclassl-oginFormForm{pub1icstaticstringuacc；pub1icstaticstringupsw：pub1icstaticstringuname；publicstaticstringusex；pub1icstaticstringupart；publicstaticstringuright；pub1icLoginForm(){InitializeComponent()；}privatevoidloginbtn_Click(objectsender,EventArgse){if(this.useracctxt.Text.Trim()==""&&this.pswtxt.Text=="り{MessageBox.Show("请输入您的用户名和密码!"提示!")；return；)try(stringsql；sql=Mselect*fromtb_userwhereuacc:'"+this.useracctxt.Text+"'andupsw=,H+this.pswtxt.Text+M'"；OleDbDataReaderdr=I)B1le1p.01eReader(sql)；dr.ReadO；if(dr.HasRows)uacc=this,useracctxt.Text!upsw=this,pswtxt.TextIuname=dr["uname"].ToString()Jusex=drl^usex',].ToString()；upart=drl'upart'J.ToStringO；uright=dr["uright"].ToString()；MainFormaf=newMainForm(this)；this.HideO；this.useracctxt.ClearO；this.pswtxt.ClearO；af.ShowO；}else(MessageBox.Show(H账号或密码错误い,”提示!*')；this.useracctxt.ClearO；this.pswtxt.Clear()；this.useracctxt.FocusO；})catch(Exception)(：.Show("数据咋无法连接!”.“警3!”)：)}privatevoidcancelbtn_Click(objectsender,EventArgse){Application.Exit()1}privatevoidLoginForm_Closing(objectsender,FormClosingEventArgse)(App1ication.Exit()；2.主界面（图较小,自己可以拉大点）主要代码就不写了,很简单。3.权限设置SEE权限设置主要代码:pub1icpartialclassRightSet:Formpub1icRightSet0(InitializeComponent()；privatevoidRightSet_Load(objectsender,Event.Argse)(this.rightbox.Selectedlndex=0；//this.treeright.ExpandAl1()；FillO；}privatevoidokbtn_Click(objectsender,EventArgse)(if(this.txtnum.Text==string.Empty){NessageBox.Show("请输入最大借阅图书数量!"，”提示!り;return；}if(this.txtday.Text==string.Empty)MessaqeBox.Show（"请输入最大借阅图书时间!"，"提示!"）；return；if(this.txtcost.Text==string.Empty)MessageBox.Show("请输入借竹押金金额!”，"提示!り;return；)if(this.txtfine.Text==string.Empty)(McssageBox.Sho孤”请输入超期罚款金额!"，”提示!り;return；}if(this.txttim.Text==string.Empty){McssageIk)x.Show(H请输入图书遗失罚款倍数!”，”提示!”)；return；)ArrayListarr=newArrayList()；foreach(TreeNodenodesinthis.treeright.Nodes){if(nodes.Checked){arr.Add(”ゴ)；}else{arr.Add("。り;}foreach(T「ゼeNodenodeinnodes.Nodes)(if(node.Checked){arr.AddCT1)；)else{arr.Add(”〇り;string[]a=newstring[ll]；for(inti=0；i<arr.Count；i++)if(arr[i].ToStringO.TrimO=r,l")a[i]="yes"；elsea[i]noa[i]nostringsql=string.Empty;sql+="select*fromtb_rightwhereuright=*"+this.rightbox.Text+***;DataTabledt=DBHelp.ExeOleCommand(sql);boolb=false;while(dt.Rows.Count!=0)b=true;break;stringsqll;if(b)sqll=Mupdatetb_rightset”;sqll+="maxbook=*M+this.txtnum.Text+";sqll+="maxdate-'"+this.txtday.Text"rcost=*"+this.txtcost.Text"rfine='M+this.txtfine.Textnrtim=*"+this.txttim.Textn,,n;sqllMrbm='"+a[0]+rumrum：sqllsqllrrm=+a[2]+”3sqll"rborm='"+a[3]+w,.sqllsqllsqll"ruis=*"+a[6]+sqll+="rboris=*M+a(7]+sqll+="rblp=,"+a[8]+sqllsqll+="rbl='”+a[9]+"Isqll"rlp=*"+a[10]+sqll+="whereuright=*"+this.rightbox.Text+sqllelsesqll="insertintotb_right(uright,maxbook,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+"',1"+this.txttim.Text+ +a[0]+"r,'"+a[l]+"1,•"+a[2]+",,**+a[3]+ «+a[4]++a[5]+n,, +a[6]+",,•"+a[7]+w,,r"+a[8]+ +a[9]+ +a[10]+",)DataTabledt1=DBHelp.ExeOleCommand(sqll);FillO；)privatevoidFill()(stringsql;sql«"selectridasID号,urightas用户身份，maxbookas最大借区数量，maxdateas最大借阅时间,rcostas押金,rfineas超期罚率,rtimas遗失赔率,rbmas图书管理,rumas用户管理,rrmas权限管理,rbormas借阅管理,risas信息查询,rbisas图书信息査询,ruisas用户信息査询,rborisas借阅历史件i旬,rblpas图Iく挂失处理,rblas图书挂失,ripas挂失处理fromtb_right";DataTabledt=-3Help.ExeOleCommand(sql);this.dataGridViewl.DataSource=dt;}privatevoidcell_click(objectsender,DataGridViewCellEventArgse)(this.rightbox.Text"this,dataGridViewl[1,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim();this.txtnum.Text=this.dataGridViewl[2,this.dataGridViewl.Currentcell.Rowindex].Value.T©String().Trim();this.txtday.Text=this.dataGridViewl[3,this.dataGridViewl.Currentcell.Rowindex].Value.ToStringO.TrimO;this.txtcost.Text=this.dataGridViewl[4,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();this.txtfine.Text=this.dataGridViewl[5,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();this.txttim.Text■this.dataGridViewl[6,this.dataGridViewl.CurrentCell.Rowindex].Value.ToStringO.Trim();ArrayListlist=newArrayList();stringsql="select*fromtb_rightwhereuright='"+DBHelp.ExeOleCommand(sql);this.rightbox.Text+DBHelp.ExeOleCommand(sql);if(dt.Rows.Count!=0)for(inti=0;i<11;i++){list.Add(dt.Rows[0][7+i].ToStringO);}ArrayListarr=newArrayList();foreach(TreeNodenodesinthis.treeright.Nodes)(arr.Add(nodes);foreach(TreeNodenodeinnodes.Nodes)(arr.Add(node);)}for(inti=0;i<list.Count;i++)(if(list[i].ToStringO=="yes")(((TreeNode)arr[i]).Checked=true;)else{{(TreeNode)arr(i]).Checked=false;)4.权限修改主要代码:pub1icpartialclassUserRight:Form{publicUserRight()(InitializeComponentO；privatevoidbtncancel_Click(objectsender,EventArgse)this.Close()；}privatevoidUserRight_Load(objectsender,EventArgse)(this.checkbox.Se1ectedIndex=0；this.partbox.Selectedlndex=0；privatevoidFi110if(this.if(this.checkbox.TextMessageBox.Show("请选择要使用的査询字段!","提示!）；return；if(this.partbox.Text=="りMessaged.ShowC请选择用户所在的部门!ヽ”提示!り;return；)stringsql=string.Empty；sql+=MselectuidasID号,uaccas帐号,unameas姓名,usexas性别,upartas部H,uteIphoneas移动电话,uphoneas固定电话，udateas注册日期,urightas权限fromtb_usern；if(this.checktxt.Text!="n){stringc=this,checkbox.Se1ectedIndex.ToString()；switch(c)(case"〇”:〃用户帐号if(this.checktxt.Text!=string.Empty){sql+="whereuacc1ike+this.checktxt.Text+"%'"；}break；case"1":〃用户姓名if(this.checktxt.Text!=string.Empty)(sql+="whereuname1ike+this.checktxt.Text+"%'"；}break；default：break；}if(this,partbox.SelectedIndex.ToStringO!="0"){sql+="andupart二’"+this.partbox.Text+"1"；})elseif(this.partbox.Selectedlndex.ToStringO!="0”)

sql+="whereupart=*"+this.partbox.Text+sql+="orderbyuaccasc"；DataTablcdt=DBHelp.ExeO1eCommand(sql)；this.dataGridViewl.DalaSource=dt；)privatevoidcheckbtn_C1ick(objectsender,EventArgse){FillO；privatevoidcell_click(objectsender.DataGridViewtc11EventArgse)(this.txtuacc.Text=this.dataGridViewl[l,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim()；this.txtname.Text=this.dataGridViewl[2,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim()；this.txtsex.Text=this.dataGridViewl[3,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().TrimO；this.txtpart.Text=this.dataGridViewl[4,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim()；this.txttel.Text=this.dataGridViewl[5,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToStringO.TrimO；this.txtphone.Text=this.dataGridViewl[6,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().TrimO；this.txtdate.Text=this.dataGridViewl[7,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().TrimO；this.txtright.Text=this.dataGridViewl[8,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToStringO.TrimO；this.txtright.Enabled=true；}privatevoidbtnchange_Click(objectsender,EventArgse){if(this,txtuacc.Text=="りMessageBox.ShowC,执行操作前,请先在下表选择要修改的用户!"，”提示!り;return；)DialogResultres；resHessageBoヽ.Show("您确定要修改该用户吗?”，“提示!”，meBoxButions.YesNo)；if(res==DialogResult.Yes){stringsql=string.Empty；sql+="updatetb_userseturight=*"+this.txtright.Text+"sql+="whereuacc=*"+this.txtuacc.Text+w,M；DataTabledt=DBHelp.ExeO1eCommand(sql)；MessageBox.Show("修改成功!"，“恭喜!”);FillO；5.添加图书信息主要代码:pub1icpartialclassNewBook:Form{pubIicNewBook()(InitializeComponent0；privatevoidretbtn_Click(objectsender,EventArgse)this.HideO；}privatevoidsavebtn_Click(objectsender,EventArgse)if(this.booknotxt.Text=="り{MessageBox.Show(H请输入图书的信息!”，”提示!り;return；)if(this,booknametxt.Text=="り(MessageBox.ShowC,请输入图抄的信息!”，”捉小!り;return；)if(this.classtxt.Text=="り{Messヨ5」いX.Show("请输入图Iリ的储息!”，"提小!り;return；)if(this,isbntxt.Text=="り{Messa浜Boヽ.Show("请输入图书的信息!”，”提示!り;return；}if(this,bookcosttxt.Text=="り{Messa^e^)x.Show("请输入图，的信一息!"，”提小!り;return；}if(this.bookwritertxt,Text=="り{MessagcBox.ShowC请输入国I泄信息!"，”提示!り;return；)if(this.bookpubtxt.Text="り{MessageBox.ShowC,请输入图书的信息!”，”提示!り;return；if(this.numtxt,Text=="りMessageBox.Show("请输入I冬I3的餡息I"，"捉小!り;return；}if(this.notetxt.Text=="りMessaguBox.Show("请输入图书的信息!\"提示!り;return；}//stringPat3=-4eO(Hhi9fa5]+$”;〃全为汉字//stringpat4=©"人([Wu4600Tu9fa5]+|[A-Za-z]+)$";〃汉字或字母//stringpat5=@M[Wu4e00-W'u9fa5]{2,4}$”;〃两到四位汉字stringpatl=@"人(呪[-]*){9}[呢xX]$"；//图书的ISBN号格式X-XXXX-XXXX-X或X-XXX-XXXXX-X(X为数字,以图归实际ISBN号为准)stringpat2=@”ぺ+?[1-9][0-9]*$”;〃正整数stringpat3=ゼ人(01[卜9][〇一9]*)(.[〇-9]{2})?$”;〃双精度浮点数boolml=Program.match(this.isbntxt.Text,patl)；boolm2=Program.match(this.numtxt.Text,pat2)；boolm3=Program.match(this.bookcosttxt.Text,pat3)；if(!ml)(VessageBox.Show("图书的ISBN号格式为X-XXXX-XXXX-X或X-XXX-XXXXX-X(X为数字,以图书实际ISBN号为准)!"，"提示!」)；this.isbntxt.Text=””；return；)if(!m2){MessageBox.Show(n图书购买数量应为大于〇的整数!”，”提示!")；this.numtxt.Text=""；return；)if(!m3){MessageBox.Show(H图书价格应为XX.XX元!”，”提示!”)；this.bookcosttxt.Text="M；return；}intnum；num=Convert.Tolnt32(this.numtxt.Text)；for(inti=1,k=Convert.Tolnt32(this.booknotxt.Text)!i<=num；i++,k++)stringsql；sql="insertintotb_book(bno.bname.bclass.bisbn.bcost.adder,adddate.bauthor,bpub.bstate.bnote)1'+"values。"+k.ToString()+"*,'"+this.booknametxt.Text+M','"+this.classtxt.Text+"*,+this.isbntxt.Text+"ヽ’"+this,bookcosttxt.Text+ +LoginForm.uname+"*,'"+DateTime.Now.ToStringO+"1,'"+this,bookwritertxt.Text+"二’+this,bookpubtxt.Text+"'，’在库+this.notetxt.Text+DataTabledt=DBHclp.ExeO1eCommand(sql)；)MessageBox.ShowC注册成功!","恭喜!")；this.HideO；)privatevoidrebtn_Click(objectsender,EventArgse)(this.isbntxt.Clear()；ClearsO；privatevoidClearsO{this.booknametxt.Clear()；//this,isbntxt.Clear。;this.bookcosttxt.Clear()；this.bookwritertxt.Clear()；this.bookpubtxt.Clear。;this.notetxt.Clear()；this.numtxt.Clear()；)privatevoidNewBookJx)ad(objectsender,EventArgse){/*stringsql；sql="selectbnofromtb_bookorderbybnoasc"；DataTabledt=DBHe1p.ExeO1eCommand(sql)；for(inti=0,k=10000001；i<1；i++,k++)for(intj=0；j<dt.Rows.Count；j++)if(dt.Rows[j][0].ToString().Trim().Equals(k.ToStringO))k++；this.booknotxt.Items.Add(k.ToStringO)；this.booknotxt.SelectedIndex=0；this.classtxt.Selectedlndex=0；stringsql；sql="selecttop1bnofromtb_bookorderbybnodesc"；DataTabledt=DBHelp.ExeO1eCommand(sql)；intk；for(inti=0；i<1；i++){if(dt.Rows[0][0].ToString()="り(k=10000001；elseTolnt32(dt.Rows[0][0].ToString())；k++；}this.booknotxt.Items.Add(k.ToString())；)this.booknotxt.Selectedlndex=0；this.classtxt.Selectedlndex=0；}privatevoidfindbtn_Click(objectsender,EventArgse){if(this.isbntxt.Text==MH){MessaguBox.Show("请输入图书的ISBN号!二”提示!り;return；)stringsql；sql="select*fromtb_bookwherebisbn=’"+this.isbntxt.Text+OleDbDataReaderdr=DBHelp.01eReader(sq1)；dr.ReadO；if(drJIasRows)this.booknametxt.Text=dr["bnameH].ToString().Trim()；this.classtxt.Text=dr["be1ass"].ToString().Trim()；this.bookcosttxt.Text=dr["bcostM].ToString().Trim()；this.bookwritertxt.Text=dr["bauthorH].ToString().TrimO；this.bookpubtxt.Text=dr["bpub"].ToString().Trim()；this.notetxt.Text=dr[Mbnote"].ToString().TrimO；MessageBox.Show("找到匹配图书信息,自动填充基本信息,请填充余ド信息!"，”提示!)；this.numtxt.Enabled=true；)else{ClearsO；MessageBox.Show("未找到匹配图书信息!“，"提示!")；this.booknotxt.Enabled=true；this.booknametxt.Enabled=true；this.classtxt.Enabled=true；this.bookcosttxt.Enabled=true；this.bookwritertxt.Enabled=true；this.bookpubtxt.Enab1ed=true；this.numtxt.Enabled=true；this.notetxt.Enabled=true；6.图书信息管理S0Eわ图书信息管理图书信息表主要代码:publicpartialclass丨卜)(ホリ［:Formpub1icI3ookManage()InitializeComponentO；stringbookisbn；privatevoidBookManage_Load(objectsender,EventArgse){this.checkbox.Se1ectedIndex=0；this.classbox.Selectedlndex=0；Iprivatevoidcheckbtn_C1ick(objectsender,EventArgse){FillGridO；}privatevoidcell_click(objectsender,DataGrid\'iewCc11EventArgse)FilllnfoO；privatevoidnobtn_Click(objectsender,EventArgse)this.CloseO!}privatevoidokbtn_Click(objectsender,EventArgse)(if(txt.Text==string.Empty){MessageBox.Show("执行操作前,请先选择图书!”，”提示!")；return；)〃修改同ISBN图书信息stringsq!2=string.Empty；sql2+="updatetb_booksetbisbn:’"+this.isbntxt.Text+"'ヵname二'"+txt.Text+"'.bclass二'"+this,classtxt.Text+,bcost="+this.costtxt.Text+”,bauthor二'"+this.writertxt.Text+"*,bpub='"+this.pubtxt.Text+”'adder二'"+this.addertxt.Text+'",bnote=,"+this,notetxt.Text+"'"；sql2+二"wherebisbn二'"+this.bookisbn+"'"；DataTabledt2二DBHe1p.ExeO1eConnand(sq12))stringsql5=string.Empty；sq15+二"updatetb_borrowsetbname='"+txt.Text+M'.bisbn二’"+this.isbntxt.Text+"；sql5+="wherebisbn二'"+this.bookisbn+"'"；DataTabledt5二DBHc1p.ExeO1eCommand(sq15)；MessageBox.Show("该类图书信息修改成功!"，"提示!")；this.checktxt.Text二FillGridO；FilllnfoO；)privatevoidFi1IGrid()if(this.checkbox.Textニニstring.Empty)MessageBox.Show（"请输入你要使用的检索条件ー,”提示!"）；return；MessageBox.Show("请输入你要查找的图书类型!二”提示!り;return；)stringsql=string.Empty；sql+="selectbidasID号,bnoas图书编号,bnameas图〃名称,bauthoras作者,belassas类别,bisbnasISBN号,bcostas价格,bpubas出版社,adderas记录员,adddateas入库日期,bnoteas内容简介,bstateas状态fromtb_bookM；if(this.checktxt.Text!="り(stringc=this,checkbox.Se1ectedIndex.ToString()；switch(c){case"〇”:〃图书名称if(this.checktxt.Text!=string.Empty){sql+=Hwherebnamelike'%”+this.checktxt.Text+”力”；)break；case”ビ:〃图书编号if(this.checktxt.Text!=string.Empty)(sql+="wherebnolike,%"+this.checktxt.Text+"%*"；)break；case“2”:〃作者if(this.checktxt.Text!=string.Empty)(sql+=”wherebauthor1ike'%”+this.checktxt.Text+"%'"；}break；case”3"：//isbn号if(this.checktxt.Text!=string.Empty)sql+="wherebisbn1ike'%"+this.checktxt.Text+"%break；case"4”:〃出版社sql+="wherebpublike*%n+this.checktxt.Text+"%}break;default:break;}if(this.classbox.Selectedlndex.ToString()!="0")(sql+="andbclass=1"+this.classbox.Text+"*";)}else(if(this.classbox.Selectedlndex.ToString()!="0")(sql+="wherebclass=1"+this.classbox.Text+"*",}}sql+="orderbybnoasc";DataTabledt=：BHelp.ExeOleCommand(sql);this.dataGridViewl.Datasource=dt;}privatevoidFillinfo()(this.Iabel3.Text=this.dataGridViewl[1,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();this.isbntxt.Text=this.dataGridViewl[5Zthis.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim();txt.Text■this.dataGridViewl[2,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim();this.classtxt.Text"this.dataGridViewl[4,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim();this.costtxt.Text=this.dataGridViewl[6,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().TrimO;this.writertxt.Text=this.dataGridViewl[3,this.dataGridViewl.CurrentCell.Rowindex].Value.ToStringO.TrimO;this.pubtxt.Text=this.dataGridViewl[7,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToStringO.TrimO；this.addertxt.Text=this.dataGridViewl[8,this,dataGridViewl.CurrentCel1.RowIndex].Value.ToStringO.TrimO；this.notetxt.Text=this.dataGridViewl[10,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim()；this.isbntxt.Enabled=true；txt.Enabled=true；this.classtxt.Enabled=true；this.costtxt.Enabled=true；this.writertxt.Enabled=true；this.pubtxt.Enabled=true；this.notetxt.Enabled=true；this.bookisbn=this.isbntxt.Text；7.用户信息添加主要代码:publicpartialclassRegisterForm:Formpub1icRegisterForm()InitializeComponent()；}privatevoidregbtn_Click(objectsender,EventArgse)if(this.usernametxt.Text==string.Empty)Message惰)'.Show("请输入用丿、姓"!","提示!）；return；McssageIk)x.Show(H请输入用户性别!"，”提示!り;return；)if(this.partcob.Text==string.Empty){MessageBox.Show(H请输入用户所在部门!二"提示!リ;return；}if(this.telphonetxt.Text==string.Empty)(MessageBox.ShowC,请输入用户移动电话!”，”提示!り;return；)if(this.phonetxt.Text=string.Empty){MessageBox.Show(H请输入用户固定电话!","提示!り;return；)stringpatl=¢"A[0-9]{8,11}$"；boolml=Program.match(this.telphonetxt.Text,patl)；boolm2=Program.match(this.phonetxt.Text,patl)；if(!ml){胞骐/Box.Show(”电话号码为8到U位的正的数!”，”提示!り;return；)if(!m2){McssageIk)x.Show(H电话号码为8到11位的正整数!"，”提示!”)；return；stringsq=string.Empty!sq+=Hselect*fromtb_user"；sq+="whereuname='"+this.usernametxt.Text+r,*andupart='"+this.partcob.Text+"andutelphone="'+this.telphonetxt.Text+Mr；DataTabled=DBHe1p.ExeO1eCommand(sq)；boolb=false；while(d.Rows.Count==0)(b=true；break；}if(b){stringsql=string.Empty；sql+="insertintotb_user(uacc.upsw.uname,usex,upart.utelphone,uphone,udate.uright)H；sql+="values。"+this.useracctxt.Text+ +this.pswtxt.Text+"+this.usernametxt.Text+"r,+this.sextxt.Text+"',*"+this.partcob.Text+"',1"+this.telphonetxt.Text+"*,*"+this.phonetxt.Text+",,1"+DateTimc.Now.ToString()+"+this.rightbox.Text+"')"；DataTabledt=DBHeIp.ExeOleCommand(sql)；MessageBox.Show("新用户添加成功!",M恭喜!")；this.HideO；)else{MessageBox.Show("该用户已存在!"，”提示!")；this.usernametxt.Text=""；this.telphonetxt.Text=""；this.phonetxt.Text=""；1privatevoidcancelbtn_Click(objectsender,EventArgse){this.Close()；privatevoidRegisterForm_Load(objectsender,EventArgse)stringsql；sql=Hselecttop1uaccfromtb_userorderbyuaccdesc”；DataTabledt=DBHelp.ExeO1eCommand(sql)；intk;for(inti=0;i<1;i++)|if(dt.Rows[0][0].ToStringO==nn)(k=60000001;)elsek=Convert,Tolnt32(dt.Rows[0][0].ToString());k++;)this.useracctxt.Items.Add(k.ToString());}this.useracctxt.Selectedlndex=0;this.sextxt.Selectedlndex=0;this.partcob.Selectedlndex=0;this.pswtxt.Text=M123456";8.用户信息管理主要代码:pub1icpartialclassUserList:Form{publicUserList0{InitializeComponentO；)privatevoidUserList_Load(objectsender,EventArgse){this.checkbox.Se1ectedIndex=0；this.partbox.Selectedlndex=0；this.classbox.Selectedlndex=0；}privatevoidFi11(){if(this.checkbox.Text="り{McssageBox.Show("请选择要使用的杏询字段!"，”提示!り;return；)if(this.partbox.Text=="**){MessageBox.Show("请选择用户所在的部门!"，”提示!り;return；)if(this,classbox.Text="り(MessageBox.Show("请选择用户的类型!エ”提示!り;return；)stringsql=string.Empty；sql+="selectuidas11)号,uaccas帐号,unameas姓名,usexas性别,upartas部f],uteIphoneas移动电话,uphoneas固定电话,udateas注册日期,urightas权限fromtb_user"；//if(this.classbox.Seiectedlndex.ToString()!="0")//{//sql+="whereuright='M+this.c1assbox.Text+//}if(this.checktxt.Text!=stringc=this.checkbox.Selectedlndex.ToString();switch(c)(case”〇”:〃用户帐号if(this.checktxt.Text!=string.Empty)(sql+=Mwhereuacclike*%"+this.checktxt.Text+"%'}break;case"1"://用户姓名if(this.checktxt.Text!=string.Empty)(sql+="whereunamelike'%**+this.checktxt.Text+"%)break;default:break;}if(this.classbox.Selectedlndex.ToString()!="0")(sql+="anduright=*"+this.classbox.Text+"*";}if(this.partbox.Selectedlndex.ToString()!="0")(sql+="andupart='"+this.partbox.Text+"*";)}else(//sql+="whereupart=1"+this.partbox.Text+"*";if(this.classbox.Selectedlndex.ToString()!="0"&&this.partbox.Selectedlndex.ToString()!=”0")(sql+="whereuright=**+this.classbox.Text+"'w;sql+="andupart=*"+this.partbox.Text+"*";}elseif(this.classbox.Selectedlndex.ToString()=="0"&&this.partbox.Selectedlndex.ToString()!=”〇”)sql+="whereupart=*n+this.partbox.Text+)elseif(this.classbox.Selectedlndex.ToString()!="〇"&&this.partbox.Selectedlndex.ToString()=="0")(sql+="whereuright=1"+this.classbox.Text+}sql+=norderbyuaccasc";DataTabledt■DBHelp.ExeOleCommand(sql);this.dataGridViewl.DataSource=dt;}privatevoidcheckbtn_Click(objectsender,EventArgse)(FillO；)privatevoidcell_Click(objectsender,DataGridViewCellEventArgse){this.txtuacc.Text=this.dataGridViewl[1,this.dataGridViewl.Currentcell.Rowindex].Value.ToString().Trim();this.txtname.Text=this.dataGridViewl[2,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();this.txtsex.Text■this.dataGridViewl[3,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim();this.txtpart.Text=this.dataGridViewl[4,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();this.txttel.Text=this.dataGridViewl[5,this.dataGridViewl.CurrentCell.Rowindex].Value.ToStringO.TrimO;this.txtphone.Text=this.dataGridViewl[6,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();this.txtdate.Text■this.dataGridViewl[1,this.dataGridViewl.CurrentCel1.Rowindex].Value.ToString().Trim();this.txtright.Text=this.dataGridViewl[8,this.dataGridViewl.CurrentCell.Rowindex].Value.ToString().Trim();stringsql1="selectmaxbook,maxdatefromtb_rightwhereuright=1n+this.txtright.Text+OleDbDataReaderdrlDBHelp.OleReader(sqll);drl.Read();this.txtmaxbook.Text=dr1["maxbook"].ToString().Trim()；this.txtmaxdate.Text=drl["maxdate"].ToString().Trim()；stringsql2=string.Empty;〃已借图•数量sql2+="selectcount(*)asbornumfromtb_borrow"；sql2+="whereuacc=**'+this.txtuacc.Text+sql2+="andborstate〇’已还‘andborstate〇’丢失OleDbDataReaderdr2=DBHelp.01eReader(sq12)；dr2.Read()；this.txtbooknum.Text=dr2["bornum"].ToString().Trim()；inta=Convert.Tolnt32(this.txtmaxdate.Text)；stringsql3=string.Empty;〃到期图书数量sql3+="selectcount(*)asbornumfromtb_borrow"；sql3+=Mwhereuacc='"+this.txtuacc.Text+"'"；sql3+=Mandborstate〇,已还‘"；sql3+="andbordate<#"+DateTime.Now.AddDays(-a)+"ギ;OleDbDataReaderdr3=DBHe1p.01eReader(sq13)；dr3.Read()；this.txtbookout.Text=dr3["bornum"].ToString().Trim()；privatevoidcancel_Click(objectsender,EventArgse)(this.Close()；}privatevoidbtndel_Click(objectsender,EventArgse){if(this.txtuacc.Text==""){MessageI3ox.Show("执行操作前,请先在ド表选择要删除的用户!"，”提示!")；return；)DialogResultres；resdessageBox.Show("您确定要删除该用户吗?”，"提示!”，MessageBoxButtons.YesNo)；if(res==DialogResult.Yes)stringsql=string.Empty；sql+="select*fromtb_borrow"；sql+="whereuacc='M+this.txtuacc.Text+"'Msql+="andborstate〇’己还OleDbDataReaderdr=DBHeIp.01eReader(sq1)；dr.ReadOiif(dr.HasRows){Messaged.Show(H该用户尚有图书未还,无法删除!エ”提示!り;)else(if(this.txtuacc.Text==LoginForm.uacc)(MessageBox.Show(M对不起,自己无法删除自己!"，“提示!”)；)else{stringsq12=string.Empty；sql2+='*selecturightfromtb_userM；sq12+=Hwhereuacc=''*+this.txtuacc.Text+"'”；DataTabledt2=DBHe1p.ExeO1eCommand(sq12)；stringxxx=dt2.Rows[0][0].ToString()；if(xxx==”超级管理员”)(McssageBox.Show("该用户为超级管理员,无法删除!”，”提示!”)；}else(stringstr=string.Empty；str+="deletefromtb_userwhereuacc=’”+this.txtuacc.Text+”'DataTabledt=DBHe1p.ExeO1eCommand(str)；MessageBox.ShowC该用户已删除!”，”提示!”）；FillO；9.图书挂失主要代码:pub1icpartialclassBookLost:Formpub1icBookLost()InitializeComponent()；privatevoidFiHBookO(strings=string.Empty；s+="select*fromtb.book"；s+="wherebno='M+this.notxt.Text+OleDbDataReaderdr=DBHelp.OleReader(s)；dr.ReadO；if(dr.HasRows)(txt.Text=dr["bnameM].ToStringO.TrimO；this.classtxt.Text=dr["belass"].ToString().Trim()；this,isbntxt.Text=dr["bisbnM].ToStringO.TrimO；this.costtxt.Text=dr["bcostM].ToString().Trim()；this.writertxt.Text=dr["bauthor"].ToString().Trim()；this.pubtxt.Text=dr[Mbpub"].ToString().Trim()；this.addertxt.Text=dr["adder"].ToString().Trim()；this.adddatetxt.Text=dr["adddate"].ToString().Trim()；this.bstatetxt.Text=dr["bstate"].ToStringO.TrimO；this.notetxt.Text=dr[nbnote"].ToStringO.TrimOielseMessageBox.Show(r,未找到该书!”，"提示!")；ClearsO；))privatevoidClearsO{this.notxt.Text=""；txt.Text="this.classtxt.Text=this.isbntxt.Text="this,costtxt.Text=11"；this.writertxt.Text=this.pubtxt.Text=""；this.addertxt.Text=this.adddatetxt.Text="this.bstatetxt.Text=""；this.notetxt.Text=""；}privatevoidcheckbookbtn_Click(objectsender,EventArgse){if(this.notxt.Text==string.Empty)(MessageBox.ShowCi疗输入图行的编り!"，"提示!")；return；)Fi1lBook()；}privatevoidcancel_Click(objectsender,EventArgse)(this.CloseO；}privatevoidbtnok_Click(objectsendertEventArgse)if(txt.Text=="りMessageBox.Sh5V（"请点击放大镜获取图书信息!"，"提示!"）；return；if(this.bstatetxt.Text=="在库"){Mess叫。ル\.Show，本次挂失失败,该书并未借出!","提示!")：Clears。;)elseif(this.bstatetxt.Text=="借出"){stringsql1=string.Empty；sql1+="updatetb_booksetbstate=‘挂失‘"；sql1+='*wherebno=1*'+this.notxt.Text+"'"；DataTabledtl=DBHe1p.ExeO1eCommand(sq11)；stringsql2=string.Empty；sq12+="updatetb_borrowsetborsiate=‘挂失‘”；sq12+="wherebno二'"+this.notxt.Text+"'andborstate二‘未还'"；DataTabledt2二DBHelp.Exe01eCommand(sql2)；FillBookO；Messagelk)x.Show("挂失操作成功"，"提示!り;)elseif(this.bstatetxt.Textニニ"挂失"){MessageBox.ShowC,本次挂失失败,挂失处理已经被执行过了!","提示!")；Clears()；)elseif(this.bstatetxt.Textニニ"丢失"){MessageBox.ShowC*'本次挂失失败,该书已经确认丢失!","提示!り;Clears()；10.挂失处理主要代码:pub1icpartialclassl>ostPro:Form{pub1icLostPro()(InitializeComponent()；IprivatevoidFi110(if(this.checkbox.Text=string.Empty){MessageBox.ShowC,请输入你要使用的检索条件!”，”提示!り;return；)if(this.classbox.Text=string.Empty)(MessageBox.ShowC请输入你要査找的图书类型!n,"提示!")；return；stringsql=string.Empty；sql+=HselectbidasID号,bnoas图书编号,bnameas图书名称,bauthoras作者,belassas类别,bisbnasISBN号,bcostas价格,bpubas出版社,adderas记录员，adddateas入库日期,bnoteas内容简介,bstateas状态fromtb_book"；

sql+="wherebstateメ挂失’”；stringc=this,checkbox.Se1ectedIndex.ToString()；stringx=this,c1assbox.SeiectedIndex.ToStringC)Iswitch(c)case”〇”：//图柠名称if(this.checktxt.Text!=string.Empty)(sql+="andbnamelike,%"+this.checktxt.Text+"%}break;case"1"://图书编号if(this.checktxt.Text!=string.Empty)(sql+="andbnolike*%"+this.checktxt.Text+"%*r)break;case"2":〃作者if(this.checktxt.Text!=string.Empty)sql+=Mandbauthorlike, +this.checktxt.Text+n%}break;case”3"://isbn号if(this.checktxt.Text!=string.Empty)(sql+="andbisbnlike*%"+this.checktxt.Text+"%*w;}break;case”4"：//出版社if(this.checktxt.Text!=string.Empty)(sql+="andbpublike*%"+this.checktxt.Text+)break;default:)break;if((x!=”〇”)sql+=nan