[计算机软件及应用]图书管理系统_c语言源代码

一个图书馆的管理系统，用C做的，VISUALSTUDIO2008编写的。代码经测试全部实现，暂时未发现什么BUG，在年纪的评比中得到了第一名的成绩。下面把这些代码分享给你们，希望能对你们有所帮助。1登陆界面主要代码PUBLICPARTIALCLASSLOGINFORMFORMPUBLICSTATICSTRINGUACCPUBLICSTATICSTRINGUPSWPUBLICSTATICSTRINGUNAMEPUBLICSTATICSTRINGUSEXPUBLICSTATICSTRINGUPARTPUBLICSTATICSTRINGURIGHTPUBLICLOGINFORMINITIALIZECOMPONENTPRIVATEVOIDLOGINBTN_CLICKOBJECTSENDER,EVENTARGSEIFTHISUSERACCTXTTEXTTRIM“RETURNTRYSTRINGSQLSQL“SELECTFROMTB_USERWHEREUACC“THISUSERACCTXTTEXT“ANDUPSW“THISPSWTXTTEXT“WWWFEIPIN100COM“OLEDBDATAREADERDRDBHELPOLEREADERSQLDRREADIFDRHASROWSUACCTHISUSERACCTXTTEXTUPSWTHISPSWTXTTEXTUNAMEDR“UNAME“TOSTRINGUSEXDR“USEX“TOSTRINGUPARTDR“UPART“TOSTRINGURIGHTDR“URIGHT“TOSTRINGMAINFORMAFNEWMAINFORMTHISTHISHIDETHISUSERACCTXTCLEARTHISPSWTXTCLEARAFSHOWELSEMESSAGEBOXSHOW“账号或密码错误“,“提示“THISUSERACCTXTCLEARTHISPSWTXTCLEARTHISUSERACCTXTFOCUSCATCHEXCEPTIONMESSAGEBOXSHOW“数据库无法连接“,“警告“PRIVATEVOIDCANCELBTN_CLICKOBJECTSENDER,EVENTARGSEAPPLICATIONEXITPRIVATEVOIDLOGINFORM_CLOSINGOBJECTSENDER,FORMCLOSINGEVENTARGSEAPPLICATIONEXIT2主界面（图较小，自己可以拉大点）主要代码就不写了，很简单。3权限设置主要代码PUBLICPARTIALCLASSRIGHTSETFORMPUBLICRIGHTSETINITIALIZECOMPONENTPRIVATEVOIDRIGHTSET_LOADOBJECTSENDER,EVENTARGSETHISRIGHTBOXSELECTEDINDEX0/THISTREERIGHTEXPANDALLFILLPRIVATEVOIDOKBTN_CLICKOBJECTSENDER,EVENTARGSEIFTHISTXTNUMTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入最大借阅图书数量“,“提示“RETURNIFTHISTXTDAYTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入最大借阅图书时间“,“提示“RETURNIFTHISTXTCOSTTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入借书押金金额“,“提示“RETURNIFTHISTXTFINETEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入超期罚款金额“,“提示“RETURNIFTHISTXTTIMTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入图书遗失罚款倍数“,“提示“RETURNARRAYLISTARRNEWARRAYLISTFOREACHTREENODENODESINTHISTREERIGHTNODESIFNODESCHECKEDARRADD“1“ELSEARRADD“0“FOREACHTREENODENODEINNODESNODESIFNODECHECKEDARRADD“1“ELSEARRADD“0“STRINGANEWSTRING11FORINTI0I已还ANDBORSTATE丢失“OLEDBDATAREADERDR2DBHELPOLEREADERSQL2DR2READTHISTXTBOOKNUMTEXTDR2“BORNUM“TOSTRINGTRIMINTACONVERTTOINT32THISTXTMAXDATETEXTSTRINGSQL3STRINGEMPTY/到期图书数量SQL3“SELECTCOUNTASBORNUMFROMTB_BORROW“SQL3“WHEREUACC“THISTXTUACCTEXT“SQL3“ANDBORSTATE已还“SQL3“ANDBORDATE已还“OLEDBDATAREADERDRDBHELPOLEREADERSQLDRREADIFDRHASROWSMESSAGEBOXSHOW“该用户尚有图书未还，无法删除“,“提示“ELSEIFTHISTXTUACCTEXTLOGINFORMUACCMESSAGEBOXSHOW“对不起，自己无法删除自己“,“提示“ELSESTRINGSQL2STRINGEMPTYSQL2“SELECTURIGHTFROMTB_USER“SQL2“WHEREUACC“THISTXTUACCTEXT“DATATABLEDT2DBHELPEXEOLECOMMANDSQL2STRINGXXXDT2ROWS00TOSTRINGIFXXX“超级管理员“MESSAGEBOXSHOW“该用户为超级管理员，无法删除“,“提示“ELSESTRINGSTRSTRINGEMPTYSTR“DELETEFROMTB_USERWHEREUACC“THISTXTUACCTEXT“DATATABLEDTDBHELPEXEOLECOMMANDSTRMESSAGEBOXSHOW“该用户已删除“,“提示“FILL9图书挂失主要代码PUBLICPARTIALCLASSBOOKLOSTFORMPUBLICBOOKLOSTINITIALIZECOMPONENTPRIVATEVOIDFILLBOOKSTRINGSSTRINGEMPTYS“SELECTFROMTB_BOOK“S“WHEREBNO“THISNOTXTTEXT“OLEDBDATAREADERDRDBHELPOLEREADERSDRREADIFDRHASROWSTHISNAMETXTTEXTDR“BNAME“TOSTRINGTRIMTHISCLASSTXTTEXTDR“BCLASS“TOSTRINGTRIMTHISISBNTXTTEXTDR“BISBN“TOSTRINGTRIMTHISCOSTTXTTEXTDR“BCOST“TOSTRINGTRIMTHISWRITERTXTTEXTDR“BAUTHOR“TOSTRINGTRIMTHISPUBTXTTEXTDR“BPUB“TOSTRINGTRIMTHISADDERTXTTEXTDR“ADDER“TOSTRINGTRIMTHISADDDATETXTTEXTDR“ADDDATE“TOSTRINGTRIMTHISBSTATETXTTEXTDR“BSTATE“TOSTRINGTRIMTHISNOTETXTTEXTDR“BNOTE“TOSTRINGTRIMELSEMESSAGEBOXSHOW“未找到该书“,“提示“CLEARSPRIVATEVOIDCLEARSTHISNOTXTTEXT“THISNAMETXTTEXT“THISCLASSTXTTEXT“THISISBNTXTTEXT“THISCOSTTXTTEXT“THISWRITERTXTTEXT“THISPUBTXTTEXT“THISADDERTXTTEXT“THISADDDATETXTTEXT“THISBSTATETXTTEXT“THISNOTETXTTEXT“PRIVATEVOIDCHECKBOOKBTN_CLICKOBJECTSENDER,EVENTARGSEIFTHISNOTXTTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入图书的编号“,“提示“RETURNFILLBOOKPRIVATEVOIDCANCEL_CLICKOBJECTSENDER,EVENTARGSETHISCLOSEPRIVATEVOIDBTNOK_CLICKOBJECTSENDER,EVENTARGSEIFTHISNAMETXTTEXT“MESSAGEBOXSHOW“请点击放大镜获取图书信息“,“提示“RETURNIFTHISBSTATETXTTEXT“在库“MESSAGEBOXSHOW“本次挂失失败，该书并未借出“,“提示“CLEARSELSEIFTHISBSTATETXTTEXT“借出“STRINGSQL1STRINGEMPTYSQL1“UPDATETB_BOOKSETBSTATE挂失“SQL1“WHEREBNO“THISNOTXTTEXT“DATATABLEDT1DBHELPEXEOLECOMMANDSQL1STRINGSQL2STRINGEMPTYSQL2“UPDATETB_BORROWSETBORSTATE挂失“SQL2“WHEREBNO“THISNOTXTTEXT“ANDBORSTATE未还“DATATABLEDT2DBHELPEXEOLECOMMANDSQL2FILLBOOKMESSAGEBOXSHOW“挂失操作成功“,“提示“ELSEIFTHISBSTATETXTTEXT“挂失“MESSAGEBOXSHOW“本次挂失失败，挂失处理已经被执行过了“,“提示“CLEARSELSEIFTHISBSTATETXTTEXT“丢失“MESSAGEBOXSHOW“本次挂失失败，该书已经确认丢失“,“提示“CLEARS10挂失处理主要代码PUBLICPARTIALCLASSLOSTPROFORMPUBLICLOSTPROINITIALIZECOMPONENTPRIVATEVOIDFILLIFTHISCHECKBOXTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入你要使用的检索条件“,“提示“RETURNIFTHISCLASSBOXTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入你要查找的图书类型“,“提示“RETURNSTRINGSQLSTRINGEMPTYSQL“SELECTBIDASID号,BNOAS图书编号,BNAMEAS图书名称,BAUTHORAS作者,BCLASSAS类别,BISBNASISBN号,BCOSTAS价格,BPUBAS出版社,ADDERAS记录员,ADDDATEAS入库日期,BNOTEAS内容简介,BSTATEAS状态FROMTB_BOOK“SQL“WHEREBSTATE挂失“STRINGCTHISCHECKBOXSELECTEDINDEXTOSTRINGSTRINGXTHISCLASSBOXSELECTEDINDEXTOSTRINGIFTHISCHECKTXTTEXT“SWITCHCCASE“0“/图书名称IFTHISCHECKTXTTEXTSTRINGEMPTYSQL“ANDBNAMELIKE“THISCHECKTXTTEXT“BREAKCASE“1“/图书编号IFTHISCHECKTXTTEXTSTRINGEMPTYSQL“ANDBNOLIKE“THISCHECKTXTTEXT“BREAKCASE“2“/作者IFTHISCHECKTXTTEXTSTRINGEMPTYSQL“ANDBAUTHORLIKE“THISCHECKTXTTEXT“BREAKCASE“3“/ISBN号IFTHISCHECKTXTTEXTSTRINGEMPTYSQL“ANDBISBNLIKE“THISCHECKTXTTEXT“BREAKCASE“4“/出版社IFTHISCHECKTXTTEXTSTRINGEMPTYSQL“ANDBPUBLIKE“THISCHECKTXTTEXT“BREAKDEFAULTBREAKIFX“0“SQL“ANDBCLASS“THISCLASSBOXTEXT“ELSEIFX“0“SQL“ANDBCLASS“THISCLASSBOXTEXT“DATATABLEDTDBHELPEXEOLECOMMANDSQLTHISDATAGRIDVIEW1DATASOURCEDTPRIVATEVOIDCHECKBTN_CLICKOBJECTSENDER,EVENTARGSEFILLPRIVATEVOIDLOSTPRO_LOADOBJECTSENDER,EVENTARGSETHISCHECKBOXSELECTEDINDEX0THISCLASSBOXSELECTEDINDEX0THISLABEL2TEXT“THISLABEL3TEXT“PRIVATEVOIDCELL_CLICKOBJECTSENDER,DATAGRIDVIEWCELLEVENTARGSETHISISBNTXTTEXTTHISDATAGRIDVIEW15,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISNOTXTTEXTTHISDATAGRIDVIEW11,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISNAMETXTTEXTTHISDATAGRIDVIEW12,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISCLASSTXTTEXTTHISDATAGRIDVIEW14,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISCOSTTXTTEXTTHISDATAGRIDVIEW16,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISWRITERTXTTEXTTHISDATAGRIDVIEW13,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISPUBTXTTEXTTHISDATAGRIDVIEW17,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISADDERTXTTEXTTHISDATAGRIDVIEW18,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISADDDATETXTTEXTTHISDATAGRIDVIEW19,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISBSTATETXTTEXTTHISDATAGRIDVIEW111,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMSTRINGSQLSTRINGEMPTYSQL“SELECTFROMTB_BORROW“SQL“WHEREBNO“THISNOTXTTEXT“ANDBORSTATE挂失“OLEDBDATAREADERDRDBHELPOLEREADERSQLDRREADIFDRHASROWSSTRINGUACCDR“UACC“TOSTRINGTRIM/用户帐号STRINGUNAMEDR“UNAME“TOSTRINGTRIM/用户姓名THISLABEL2TEXT“帐号“UACC“姓名“UNAMETHISLABEL3TEXT“该用户应缴罚款“ELSETHISLABEL2TEXT“THISLABEL3TEXT“PRIVATEVOIDBTNCANCEL_CLICKOBJECTSENDER,EVENTARGSETHISCLOSEPRIVATEVOIDBTNOK_CLICKOBJECTSENDER,EVENTARGSEIFTHISNOTXTTEXT“MESSAGEBOXSHOW“执行操作前，请先选择图书“,“提示“RETURNDIALOGRESULTRESULTRESULTMESSAGEBOXSHOW“确认本书丢失“,“提示“,MESSAGEBOXBUTTONSYESNOIFRESULTDIALOGRESULTYESIFTHISBSTATETXTTEXT“丢失“MESSAGEBOXSHOW“操作失败，该图书已经是丢失状态了“,“提示“RETURNIFTHISBSTATETXTTEXT“挂失“STRINGSQLSTRINGEMPTYSQL“SELECTFROMTB_BORROW“SQL“WHEREBNO“THISNOTXTTEXT“ANDBORSTATE挂失“OLEDBDATAREADERDRDBHELPOLEREADERSQLDRREADIFDRHASROWSSTRINGUACCDR“UACC“TOSTRINGTRIM/用户帐号STRINGUNAMEDR“UNAME“TOSTRINGTRIM/用户姓名STRINGSQL1STRINGEMPTYSQL1“SELECTFROMTB_USER“SQL1“WHEREUACC“UACC“OLEDBDATAREADERDR1DBHELPOLEREADERSQL1DR1READSTRINGRIGDR1“URIGHT“TOSTRINGTRIM/用户权限STRINGSQL2STRINGEMPTYSQL2“SELECTRTIMFROMTB_RIGHT“SQL2“WHEREURIGHT“RIG“OLEDBDATAREADERDR2DBHELPOLEREADERSQL2DR2READSTRINGTIMDR2“RTIM“TOSTRINGTRIM/罚款倍数INTTCONVERTTOINT32TIMSTRINGBCOSTTHISCOSTTXTTEXT/图书价格DOUBLECCONVERTTODOUBLEBCOSTDOUBLESUMTCSTRINGSSCONVERTTOSTRINGSUMTHISLABEL2TEXT“帐号“UACC“姓名“UNAMETHISLABEL3TEXT“该用户应缴罚款“SS“元“STRINGSQL3STRINGEMPTYSQL3“SELECTBRCOSTFROMTB_BORROW“SQL3“WHEREBNO“THISNOTXTTEXT“ANDBORSTATE挂失“OLEDBDATAREADERDR3DBHELPOLEREADERSQL3DR3READSTRINGRCOSTDR3“BRCOST“TOSTRINGTRIM/押金/STRINGSTR1STRINGEMPTYSTR1“UPDATETB_BOOKSETBSTATE丢失“STR1“WHEREBNO“THISNOTXTTEXT“DATATABLEDTS1DBHELPEXEOLECOMMANDSTR1STRINGSTR2STRINGEMPTYSTR2“UPDATETB_BORROWSETBRCOST0,BORSTATE丢失“STR2“WHEREBNO“THISNOTXTTEXT“ANDBORSTATE挂失“DATATABLEDTS2DBHELPEXEOLECOMMANDSTR2FILLBCLEARMESSAGEBOXSHOW“操作成功,归还押金“RCOST“元,应缴罚款“SS“元“,“提示“/ELSE/STRINGSTRSTRINGEMPTY/STR“UPDATETB_BOOKSETBSTATE丢失“/STR“WHEREBNO“THISNOTXTTEXT“/DATATABLEDTSDBHELPEXEOLECOMMANDSTR/FILL/BCLEAR/MESSAGEBOXSHOW“操作成功“,“提示“/ELSEMESSAGEBOXSHOW“操作失败，该书并未挂失“,“提示“PRIVATEVOIDBCLEARTHISISBNTXTTEXT“THISNOTXTTEXT“THISNAMETXTTEXT“THISCLASSTXTTEXT“THISCOSTTXTTEXT“THISWRITERTXTTEXT“THISPUBTXTTEXT“THISADDERTXTTEXT“THISADDDATETXTTEXT“THISBSTATETXTTEXT“11借阅历史查询主要代码PUBLICPARTIALCLASSBORROWFRAMEFORMPUBLICBORROWFRAMEINITIALIZECOMPONENTPRIVATEVOIDBORROWFRAME_LOADOBJECTSENDER,EVENTARGSETHISBOXCHECKSELECTEDINDEX0THISBOXSTATESELECTEDINDEX0PRIVATEVOIDBTNCHECK_CLICKOBJECTSENDER,EVENTARGSEFILLPRIVATEVOIDFILLSTRINGSQLSTRINGEMPTYSQL“SELECTBORIDASID号,UACCAS用户帐号,UNAMEAS用户姓名,BNOAS图书编号,BNAMEAS图书名称,BISBNASISBN号,BRCOSTAS押金,BORDATEAS借书日期,RETDATEAS还书日期,BORSTATEAS状态,BRECORDERAS借阅记录员FROMTB_BORROW“STRINGMTHISBOXCHECKSELECTEDINDEXTOSTRINGSTRINGNTHISBOXSTATESELECTEDINDEXTOSTRINGIFTHISTXTCHECKTEXTTRIM“SWITCHN/CASE“0“/全部借阅信息CASE“1“/未还图书信息SQL“WHEREBORSTATE已还“BREAKCASE“2“/已还图书信息SQL“WHEREBORSTATE已还“BREAKCASE“3“/挂失图书信息SQL“WHEREBORSTATE挂失“BREAKCASE“4“/丢失图书信息SQL“WHEREBORSTATE丢失“BREAKDEFAULTBREAKELSESWITCHMCASE“0“/用户帐号SQL“WHEREUACCLIKE“THISTXTCHECKTEXT“BREAKCASE“1“/用户姓名SQL“WHEREUNAMELIKE“THISTXTCHECKTEXT“BREAKCASE“2“/图书编号SQL“WHEREBNOLIKE“THISTXTCHECKTEXT“BREAKCASE“3“/图书名称SQL“WHEREBNAMELIKE“THISTXTCHECKTEXT“BREAKDEFAULTBREAKSWITCHNCASE“1“/未还图书信息SQL“ANDBORSTATE已还“BREAKCASE“2“/已还图书信息SQL“ANDBORSTATE已还“BREAKCASE“3“/挂失图书信息SQL“ANDBORSTATE挂失“BREAKCASE“4“/丢失图书信息SQL“ANDBORSTATE丢失“BREAKDEFAULTBREAKDATATABLEDTDBHELPEXEOLECOMMANDSQLTHISDATAGRIDVIEW1DATASOURCEDTPRIVATEVOIDCANCEL_CLICKOBJECTSENDER,EVENTARGSETHISCLOSEPRIVATEVOIDCELL_CLICKOBJECTSENDER,DATAGRIDVIEWCELLEVENTARGSE/用户信息THISTXTUACCTEXTTHISDATAGRIDVIEW11,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISTXTUNAMETEXTTHISDATAGRIDVIEW12,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMSTRINGSQL1STRINGEMPTYSQL1“SELECTUSEX,UPART,URIGHTFROMTB_USER“SQL1“WHEREUACC“THISTXTUACCTEXT“OLEDBDATAREADERDR1DBHELPOLEREADERSQL1DR1READIFDR1HASROWSTHISTXTUSEXTEXTDR1“USEX“TOSTRINGTRIMTHISTXTUPARTTEXTDR1“UPART“TOSTRINGTRIMTHISTXTURIGHTTEXTDR1“URIGHT“TOSTRINGTRIMSTRINGSQL2STRINGEMPTY/未还图书SQL2“SELECTCOUNTASBORNUMFROMTB_BORROW“SQL2“WHEREUACC“THISTXTUACCTEXT“SQL2“ANDBORSTATE已还ANDBORSTATE丢失“OLEDBDATAREADERDR2DBHELPOLEREADERSQL2DR2READIFDR2HASROWSTHISTXTNORETTEXTDR2“BORNUM“TOSTRINGTRIMSTRINGSQL3STRINGEMPTY/遗失图书SQL3“SELECTCOUNTASBORNUMFROMTB_BORROW“SQL3“WHEREUACC“THISTXTUACCTEXT“SQL3“ANDBORSTATE丢失“OLEDBDATAREADERDR3DBHELPOLEREADERSQL3DR3READIFDR3HASROWSTHISTXTLOSTTEXTDR3“BORNUM“TOSTRINGTRIMSTRINGMAXDATE/最大权限STRINGSQL4STRINGEMPTYSQL4“SELECTMAXDATEFROMTB_RIGHT“SQL4“WHEREURIGHT“THISTXTURIGHTTEXT“OLEDBDATAREADERDR4DBHELPOLEREADERSQL4DR4READ/IFDR4HASROWS/MAXDATEDR4“MAXDATE“TOSTRINGTRIM/RETURNMAXDATE/INTMAXCONVERTTOINT32MAXDATESTRINGSQL5STRINGEMPTY/到期图书SQL5SQL2SQL5“ANDBORDATE已还ANDBORSTATE丢失“OLEDBDATAREADERDR1DBHELPOLEREADERSQL1DR1READTHISHAVNUMTXTTEXTDR1“BORNUM“TOSTRINGTRIMSTRINGSQL2STRINGEMPTY/最大借阅权限SQL2“SELECTMAXBOOK,MAXDATE,RCOSTFROMTB_RIGHT“SQL2“WHEREURIGHT“THISTXTRIGHTTEXT“OLEDBDATAREADERDR2DBHELPOLEREADERSQL2DR2READIFDR2HASROWSTHISTXTMAXBOOKTEXTDR2“MAXBOOK“TOSTRINGTRIMTHISTXTMAXDATETEXTDR2“MAXDATE“TOSTRINGTRIMTHISLABCOSTTEXTDR2“RCOST“TOSTRINGTRIM/STRINGSQL3STRINGEMPTY/到期图书数量/DATETIMENOWADDDAYS30/当前日期减去借书期限大于借书日期，即为逾期INTACONVERTTOINT32THISTXTMAXDATETEXTSTRINGSQL3STRINGEMPTY/到期图书数量SQL3SQL1SQL3“ANDBORDATE丢失“OLEDBDATAREADERDR1DBHELPOLEREADERSQL1DR1READSTRINGSQL2STRINGEMPTY/可借数目SQL2“SELECTCOUNTASBNUMFROMTB_BOOK“SQL2“WHEREBISBN“THISISBNTXTTEXT“SQL2“ANDBSTATE在库“OLEDBDATAREADERDR2DBHELPOLEREADERSQL2DR2READTHISNUMTXTTEXTDR1“BNUM“TOSTRINGTRIMTHISCANNUMTXTTEXTDR2“BNUM“TOSTRINGTRIMELSEMESSAGEBOXSHOW“未找到该书或该书已借出“,“提示“THISNAMETXTTEXT“THISCLASSTXTTEXT“THISISBNTXTTEXT“THISCOSTTXTTEXT“THISWRITERTXTTEXT“THISPUBTXTTEXT“THISADDERTXTTEXT“THISADDDATETXTTEXT“THISBSTATETXTTEXT“THISNOTETXTTEXT“THISNUMTXTTEXT“THISCANNUMTXTTEXT“PRIVATEVOIDCHECKBTN_CLICKOBJECTSENDER,EVENTARGSEIFTHISUSERACCTXTTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入用户的帐号“,“提示“RETURNFILLUSERPRIVATEVOIDCHECKBOOKBTN_CLICKOBJECTSENDER,EVENTARGSEIFTHISNOTXTTEXTSTRINGEMPTYMESSAGEBOXSHOW“请输入图书的编号“,“提示“RETURNFILLBOOKPRIVATEVOIDCANCEL_CLICKOBJECTSENDER,EVENTARGSETHISCLOSEPRIVATEVOIDBORROWBTN_CLICKOBJECTSENDER,EVENTARGSEIFTHISUSERNAMETXTTEXTSTRINGEMPTY|THISNAMETXTTEXTSTRINGEMPTYMESSAGEBOXSHOW“请选择用户或图书“,“提示“RETURNDIALOGRESULTRESULTRESULTMESSAGEBOXSHOW“确认借阅本书“,“借书提示“,MESSAGEBOXBUTTONSYESNOIFRESULTDIALOGRESULTYES/验证用户的借阅权限INTACONVERTTOINT32THISHAVNUMTXTTEXTINTBCONVERTTOINT32THISTXTMAXBOOKTEXTINTCCONVERTTOINT32THISCANRETTXTTEXTIFABMESSAGEBOXSHOW“对不起该用户最多可借“THISTXTMAXBOOKTEXT“本书“,“提示“RETURNIFC0MESSAGEBOXSHOW“对不起该用户有“THISCANRETTXTTEXT“本书超期未还“,“提示“RETURNSTRINGSTRXSTRINGEMPTYSTRX“SELECTCOUNTASNUMFROMTB_BORROW“STRX“WHEREUACC“THISUSERACCTXTTEXT“ANDBORSTATE挂失“OLEDBDATAREADERDXDBHELPOLEREADERSTRXDXREADSTRINGNXDX“NUM“TOSTRINGTRIMINTXXCONVERTTOINT32NXIFXX0MESSAGEBOXSHOW“对不起该用户有“NX“本书挂失未还“,“提示“RETURN/STRINGSQLSTRINGEMPTYSQL“SELECTFROMTB_BOOKWHEREBNO“THISNOTXTTEXT“ANDBSTATE在库“DATATABLEDTDBHELPEXEOLECOMMANDSQLBOOLXFALSEWHILEDTROWSCOUNT0XTRUEBREAKIFXSTRINGSQL1STRINGEMPTYSQL1“UPDATETB_BOOKSETBSTATE借出WHEREBNO“THISNOTXTTEXT“ANDBNAME“THISNAMETXTTEXT“STRINGSQL2STRINGEMPTYSQL2“INSERTINTOTB_BORROWUACC,UNAME,BNO,BNAME,BISBN,BRCOST,BORDATE,RETDATE,BORSTATE,BRECORDER“SQL2“VALUES“THISUSERACCTXTTEXT“,“THISUSERNAMETXTTEXT“,“THISNOTXTTEXT“,“THISNAMETXTTEXT“,“THISISBNTXTTEXT“,“THISLABCOSTTEXT“,“DATETIMENOWTOSTRING“,NULL,未还,“LOGINFORMUNAME“DATATABLEDT1DBHELPEXEOLECOMMANDSQL1DATATABLEDT2DBHELPEXEOLECOMMANDSQL2MESSAGEBOXSHOW“借书成功请付押金“THISLABCOSTTEXT“元“,“恭喜“FILLUSER/FILLBOOKTHISNAMETXTTEXT“THISCLASSTXTTEXT“THISISBNTXTTEXT“THISCOSTTXTTEXT“THISWRITERTXTTEXT“THISPUBTXTTEXT“THISADDERTXTTEXT“THISADDDATETXTTEXT“THISBSTATETXTTEXT“THISNOTETXTTEXT“THISNUMTXTTEXT“THISCANNUMTXTTEXT“ELSEMESSAGEBOXSHOW“未找到该书或该书已借出“,“提示“THISNAMETXTTEXT“THISCLASSTXTTEXT“THISISBNTXTTEXT“THISCOSTTXTTEXT“THISWRITERTXTTEXT“THISPUBTXTTEXT“THISADDERTXTTEXT“THISADDDATETXTTEXT“THISBSTATETXTTEXT“THISNOTETXTTEXT“THISNUMTXTTEXT“THISCANNUMTXTTEXT“PRIVATEVOIDNOWBORROW_CLICKOBJECTSENDER,EVENTARGSESTRINGSQLSTRINGEMPTYSQL“SELECTBORIDAS借阅编号,UACCAS用户帐号,UNAMEAS用户姓名,BNOAS图书编号,BNAMEAS图书名称,BISBNASISBN号,BRCOSTAS押金,BORDATEAS借书日期,BORSTATEAS状态,BRECORDERAS记录员FROMTB_BORROW“SQL“WHEREBORSTATE已还“DATATABLEDTDBHELPEXEOLECOMMANDSQLTHISDATAGRIDVIEW1DATASOURCEDT13还书处理主要代码PUBLICPARTIALCLASSBOOKRETURNFORMPUBLICBOOKRETURNINITIALIZECOMPONENTPRIVATEVOIDBOOKRETURN_LOADOBJECTSENDER,EVENTARGSETHISBOXCHECKSELECTEDINDEX0THISBOXSTATESELECTEDINDEX0PRIVATEVOIDBTNCHECK_CLICKOBJECTSENDER,EVENTARGSEFILLPRIVATEVOIDCELL_CLICKOBJECTSENDER,DATAGRIDVIEWCELLEVENTARGSE/用户信息THISTXTUACCTEXTTHISDATAGRIDVIEW11,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMTHISTXTUNAMETEXTTHISDATAGRIDVIEW12,THISDATAGRIDVIEW1CURRENTCELLROWINDEXVALUETOSTRINGTRIMSTRINGSQL1STRINGEMPTYSQL1“SELECTUSEX,UPART,URIGHTFROMTB_USER“SQL1“WHEREUACC“THISTXTUACCTEXT“OLEDBDATAREADERDR1DBHELPOLEREADERSQL1DR1READIFDR1HASROWSTHISTXTUSEXTEXTDR1“USEX“TOSTRINGTRIMTHISTXTUPARTTEXTDR1“UPART“TOSTRINGTRIMTHISTXTURIGHTTEXTDR1“URIGHT“TOSTRINGTRIMSTRINGSQL2STRINGEMPTY/未还图书SQL2“SELECTCOUNTASBORNUMFROMTB_BORROW“SQL2“WHEREUACC“THISTXTUACCTEXT“SQL2“ANDBORSTATE已还ANDBORSTATE丢失“OLEDBDATAREADERDR2DBHELPOLEREADERSQL2DR2READIFDR2HASROWSTHISTXTNORETTEXTDR2“BORNUM“TOSTRINGTRIMSTRINGSQL3STRINGEMPTY/遗失图书SQL3“SELECTCOUNTASBORNUMFROMTB_BORROW“SQL3“WHEREUACC“THISTXTUACCTEXT“SQL3“ANDBORSTATE丢失“OLEDBDATAREADERDR3DBHELPOLEREADERSQL3DR3READIFDR3HASROWSTHISTXTLOSTTEXTDR3“BORNUM“TOSTRINGTRIMSTRINGMAXDATE/最大权限STRINGSQL4STRINGEMPTYSQL4“SELECTMAXDATEFROMTB_RIGHT“SQL4“WHEREURIGHT“THISTXTURIGHTTEXT“OLEDBDATAREADERDR4DBHELPOLEREADERSQL4DR4READ/IFDR4HASROWS/MAXDATEDR4“MAXDATE“TOSTRINGTRIM/RETURNMAXDATE/INTMAXCONVERTTOINT32MAXDATESTRINGSQL5STRINGEMPTY/到期图书SQL5SQL2SQL5“ANDBORDATE已还“OLEDBDATAREADERDR2DBHELPOLEREADERSTR2DR2READSTRINGDATEDR2“BORDATE“TOSTRINGTRIMDATETIMENCONVERTTODATETIMEDATE/借书日期IFDATETIMENOWADDDAYSMNDATETIMED1NEWDATETIMED1DATETIMENOWDATETIMED2NTIMESPANTSNEWTIMESPAND1TICKSD2TICKSSTRINGDAYCONVERTTOSTRINGTSDAYS/逾期天数THISTXTOUTDAYTEXTDAYTHISTXTOUTCOSTTEXTDR1“RFINE“TOSTRINGTRIMDOUBLEXCONVERTTODOUBLETHISTXTOUTDAYTEXTDOUBLEYCONVERTTODOUBLETHISTXTOUTCOSTTEXTDOUBLEZXYTHISTXTPCOSTTEXTCONVERTTOSTRINGZMESSAGEBOXSHOW“该书已超期,请按超期信息缴费“,“提示“RETURNBOOKELSERETURNBOOKELSEMESSAGEBOXSHOW“还书失败，该书在库中“,“提示“PRIVATEVOIDRETURNBOOKSTRINGSTRSTRINGEMPTYSTR“SELECTBRCOSTFROMTB_BORROW“STR“WHEREBNO“THISTXTBNOTEXT“ANDBORSTATE已还“OLEDBDATAREADERDRDBHELPOLEREADERSTRDRREADSTRINGXXDR“BRCOST“TOSTRINGTRIMST