文档介绍：该【图书管理系统源码C#版 】是由【学然后知不足】上传分享，文档一共【12】页，该文档可以免费在线阅读，需要了解更多关于【图书管理系统源码C#版 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。Revisedat2pmonDecember25,2020.
图书管理系统源码C#版
登录界面:
usingSystem;
using
using;
using;
using;
using;
using
using
namespacebook
{
publicpartialclasslogin:Form
{
publicstringpassword;oString;
stringsql=("Selectcount(*)fromreaderwherereaderId='{0}'andreaderpass='{1}'",,;
try
{
ext;
stringwritter=;
stringpublisher=;
stringtype=;
stringprice=;
how("请输入所有信息","错误",,);
}
}
catchext;
stringage=;
stringsex=;
stringstudentId=;
stringdept=;
stringzhuanye=;
stringmaxnumber=;
stringpass=;
try
{
if(name!=""&&age!=""&&sex!=""&&studentId!=""&&dept!=""&&zhuanye!=""&&maxnumber!=""&&pass!="")
{
stringsql=("insertintoreader(readerid,readerpass,readername,readersex,readerage,readerdept,readerzhuanye,maxnumber)values('{0}','{1}','{2}','{3}',{4},'{5}','{6}',{7})"
,studentId,pass,name,sex,age,dept,zhuanye,maxnumber);
SqlCommandcommmand=newSqlCommand(sql,);
intab=();
if(ab!=0)
{
("保存成功","保存");
}
else
{
("添加失败");
return;}
}
elseif(name==""||age==""||sex==""||studentId==""||dept==""||zhuanye==""||maxnumber=="")
{
("请输入所有学生信息","错误",,);
}
}
catchlear();
}
privatevoidbutton4_Click(objectsender,EventArgse)
{
stringrid=;
stringbid=;
try
{
if(rid!=""&&bid!="")
{
stringsql=("updateborrowsetreturntime=getdate(),outtime='已还'wherereaderid='{0}'andbookid='{1}'andouttime='否'",rid,bid);
SqlCommandcommmand=newSqlCommand(sql,;
intab=();
stringsql1=("updatebooksetifborrow='否'wherebookid={0}",bid);
SqlCommandco=newSqlCommand(sql1,);
intc=();
if(ab!=0&&c!=0)
{
("还书成功","保存");
}
else
{
("还书失败");
return;
}
}
elseif(rid==""||bid=="")
{
("请输入所有信息","错误",,;
}
}
catchlear();
qlClient;
namespacebook
{
publicpartialclassdeletereader:Form
{
privateDataSetdataset=newDataSet();
privateSqlDataAdapterdataadapter;
publicdeletereader()
{
InitializeComponent();
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
try
{
stringid=;
stringsql="select*fromreader";
dataadapter=newSqlDataAdapter(sql,;
(dataset,"reader");
=["reader"];
}
catch
{
("error");
}
finally
{
}
}
privatevoidbutton2_Click(objectsender,EventArgse)
{
if!="")
{
try
{
stringsql1=("deletefromborrowwherereaderid='{0}'",;
SqlCommandcon=newSqlCommand(sql1,;
intc=();
stringsql=("deletefromreaderwherereaderid='{0}'",;
SqlCommandcommmand=newSqlCommand(sql,;
intab=();
if(ab!=0&&c!=0)
{
("删除成功","保存");
}
else
{
("删除失败");
return;
}
}
catch(Exceptionex)
{
());
}
finally
{
}
}
else
{
("请输入借阅证号码!");
}
}
privatevoidbutton3_Click(objectsender,EventArgse)
{
["reader"].Clear();
lear();
}
privatevoidbutton4_Click(objectsender,EventArgse)
{
try
{
stringsql="select*frompublisher";
dataadapter=newSqlDataAdapter(sql,;
(dataset,"publisher");
=["publisher"];
}
catch
{
("error");
}
finally
{
}
}
}
}
读者信息界面:usingSystem;
using
using;
using;
using;
using;
using
using
namespacebook
{
publicpartialclassreaderinfo:Form
{
privateDataSetdataset=newDataSet();
privateSqlDataAdapterdataadapter;
publicreaderinfo()
{
InitializeComponent();
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
try{
stringid=;
stringsql=("select*fromreaderwherereaderid='{0}'",id);
dataadapter=newSqlDataAdapter(sql,;
(dataset,"reader");
=["reader"];
}
catch
{
("error");
}
finally
{
}
}
privatevoidtextBox1_TextChanged(objectsender,EventArgse)
{
}
privatevoidlabel1_Click(objectsender,EventArgse)
{
}
}
}
读者借书信息界面:
usingSystem;
using
using;
using;
using;
using;
using
using
namespacebook
{
publicpartialclassreaderseacherinfo:Form
{
privateDataSetdataset=newDataSet();
privateSqlDataAdapterdataadapter;
publicreaderseacherinfo()
{
InitializeComponent();
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
stringid=;
if(id!=
{
("输入密码有误,你没有权限查看其他人的信息");
}
else
{
try
{
stringsql=("select*fromreaderwherereaderid='{0}'",id);
dataadapter=newSqlDataAdapter(sql,;
(dataset,"reader");
=["reader"];
}
catch
{
("error");
}
finally
{
}
}
}
}
}
读者选择借书类型界面:
usingSystem;
using
using;
using;
using;
using;
using
using
namespacebook
{
publicpartialclassreadsearchbook:Form
{
privateDataSetdataset=newDataSet();
privateSqlDataAdapterdataadapter;
publicreadsearchbook()
{
InitializeComponent();
}
privatevoidsearchbook_Load(objectsender,EventArgse)
{
}
privatevoidbutton1_Click(objectsender,EventArgse)
{
try
{
stringsql;
if=="书名")
{
sql=
("selectbookid,bookname,bookwritter,,bookprice,,,ifborrowfrombook,booktype,publisherwhere=and=andbookname='{0}'",;
}
elseif=="作者")
{
sql=
("selectbookid,bookname,bookwritter,,bookprice,,,ifborrowfrombook,booktype,publisherwhere=and=andbookwritterlike'%{0}%'",;
}
elseif=="出版社")
{
sql=
("selectbookid,bookname,bookwritter,,bookprice,,,ifborrowfrombook,booktype,publisherwhere=and=andbookTypeNamelike'%{0}%'",;
}
elseif=="类别")
{
sql=
("selectbookid,bookname,bookwritter,,bookprice,,,ifborrowfrombook,booktype,publisherwhere=and=andpublisherNamelike'%{0}%'",;
}
else
{
sql=
"selectbookid,bookname,bookwritter,,bookprice,,,ifborrowfrombook,booktype,publisherwhere=and=";
}
dataadapter=newSqlDataAdapter(sql,;
(dataset,"book");
=["book"];
}
catch
{
("error");
}
finally
{
}
}
privatevoidcomboBox1_SelectedIndexChanged(objectsender,EventArgse)
{
if=="书名")
{
=true;
=false;
=false;
=false;
}
elseif=="作者")
{
=false;
=true;
=false;
=false;
}
elseif=="出版社")
{
=false;
=false;
=true;
=false;
}
else
{
=false;
=false;
=false;
=true;
}
}
}
}
查询读者借书是否超期:
usingSystem;
using
using;
using;
using;
using;
using
using
namespacebook
{