图书管理系统内附源代码.docx
- 文档编号:10234452
- 上传时间:2023-02-09
- 格式:DOCX
- 页数:85
- 大小:217.71KB
图书管理系统内附源代码.docx
《图书管理系统内附源代码.docx》由会员分享,可在线阅读,更多相关《图书管理系统内附源代码.docx(85页珍藏版)》请在冰豆网上搜索。
图书管理系统内附源代码
本人是一个初学者,2个月前学习C#,学习过程中遇到过许多困难无法独立解决,现在做成了第一个系统:
图书管理系统,各项功能均能顺利实现,因为知道很多初学者和我一样苦无求学之道,现在将部分主要源码上传,希望能得到高手的指点。
下面就是该系统的主要功能及代码:
1.登陆界面
主要代码:
publicpartialclassLoginForm:
Form{
publicstaticstringuacc;
publicstaticstringupsw;
publicstaticstringuname;
publicstaticstringusex;
publicstaticstringupart;
publicstaticstringuright;
publicLoginForm()
{
InitializeComponent();
}
privatevoidloginbtn_Click(objectsender,EventArgse)
{
if(this.useracctxt.Text.Trim()==""&&this.pswtxt.Text=="")
{
MessageBox.Show("请输入您的用户名和密码!
","提示!
");
return;
}
try
{
stringsql;
sql="select*fromtb_userwhereuacc='"+this.useracctxt.Text+"'andupsw='"+this.pswtxt.Text+"'";
OleDbDataReaderdr=DBHelp.OleReader(sql);
dr.Read();
if(dr.HasRows)
{
uacc=this.useracctxt.Text;
upsw=this.pswtxt.Text;
uname=dr["uname"].ToString();
usex=dr["usex"].ToString();
upart=dr["upart"].ToString();
uright=dr["uright"].ToString();
MainFormaf=newMainForm(this);
this.Hide();
this.useracctxt.Clear();
this.pswtxt.Clear();
af.Show();
}
else
{
MessageBox.Show("账号或密码错误!
","提示!
");
this.useracctxt.Clear();
this.pswtxt.Clear();
this.useracctxt.Focus();
}
}
catch(Exception)
{
MessageBox.Show("数据库无法连接!
","警告!
");
}
}
privatevoidcancelbtn_Click(objectsender,EventArgse)
{
Application.Exit();
}
privatevoidLoginForm_Closing(objectsender,FormClosingEventArgse)
{
Application.Exit();
}
}
2.主界面(图较小,自己可以拉大点)
主要代码就不写了,很简单。
3.权限设置
主要代码:
publicpartialclassRightSet:
Form
{
publicRightSet()
{
InitializeComponent();
}
privatevoidRightSet_Load(objectsender,EventArgse)
{
this.rightbox.SelectedIndex=0;
//this.treeright.ExpandAll();
Fill();
}
privatevoidokbtn_Click(objectsender,EventArgse)
{
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)
{
MessageBox.Show("请输入超期罚款金额!
","提示!
");
return;
}
if(this.txttim.Text==string.Empty)
{
MessageBox.Show("请输入图书遗失罚款倍数!
","提示!
");
return;
}
ArrayListarr=newArrayList();
foreach(TreeNodenodesinthis.treeright.Nodes)
{
if(nodes.Checked)
{
arr.Add("1");
}
else
{
arr.Add("0");
}
foreach(TreeNodenodeinnodes.Nodes)
{
if(node.Checked)
{
arr.Add("1");
}
else
{
arr.Add("0");
}
}
}
string[]a=newstring[11];
for(inti=0;i { if(arr[i].ToString().Trim()=="1") { a[i]="yes"; } else { a[i]="no"; } } stringsql=string.Empty; sql+="select*fromtb_rightwhereuright='"+this.rightbox.Text+"'"; DataTabledt=DBHelp.ExeOleCommand(sql); boolb=false; while(dt.Rows.Count! =0) { b=true; break; } stringsql1; if(b) { sql1="updatetb_rightset"; sql1+="maxbook='"+this.txtnum.Text+"',"; sql1+="maxdate='"+this.txtday.Text+"',"; sql1+="rcost='"+this.txtcost.Text+"',"; sql1+="rfine='"+this.txtfine.Text+"',"; sql1+="rtim='"+this.txttim.Text+"',"; sql1+="rbm='"+a[0]+"',"; sql1+="rum='"+a[1]+"',"; sql1+="rrm='"+a[2]+"',"; sql1+="rborm='"+a[3]+"',"; sql1+="ris='"+a[4]+"',"; sql1+="rbis='"+a[5]+"',"; sql1+="ruis='"+a[6]+"',"; sql1+="rboris='"+a[7]+"',"; sql1+="rblp='"+a[8]+"',"; sql1+="rbl='"+a[9]+"',"; sql1+="rlp='"+a[10]+"'"; sql1+="whereuright='"+this.rightbox.Text+"'"; } else { sql1="insertintotb_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.Text+"','"+this.txtfine.Text+"','"+this.txttim.Text+"','"+a[0]+"','"+a[1]+"','"+a[2]+"','"+a[3]+"','"+a[4]+"','"+a[5]+"','"+a[6]+"','"+a[7]+"','"+a[8]+"','"+a[9]+"','"+a[10]+"')"; } DataTabledt1=DBHelp.ExeOleCommand(sql1); Fill(); } privatevoidFill() { stringsql; sql="selectridasID号,urightas用户身份,maxbookas最大借书数量,maxdateas最大借阅时间,rcostas押金,rfineas超期罚率,rtimas遗失赔率,rbmas图书管理,rumas用户管理,rrmas权限管理,rbormas借阅管理,risas信息查询,rbisas图书信息查询,ruisas用户信息查询,rborisas借阅历史查询,rblpas图书挂失处理,rblas图书挂失,rlpas挂失处理fromtb_right"; DataTabledt=DBHelp.ExeOleCommand(sql); this.dataGridView1.DataSource=dt; } privatevoidcell_click(objectsender,DataGridViewCellEventArgse) { this.rightbox.Text=this.dataGridView1[1,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtnum.Text=this.dataGridView1[2,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtday.Text=this.dataGridView1[3,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtcost.Text=this.dataGridView1[4,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtfine.Text=this.dataGridView1[5,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txttim.Text=this.dataGridView1[6,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); ArrayListlist=newArrayList(); stringsql="select*fromtb_rightwhereuright='"+this.rightbox.Text+"'"; DataTabledt=DBHelp.ExeOleCommand(sql); if(dt.Rows.Count! =0) { for(inti=0;i<11;i++) { list.Add(dt.Rows[0][7+i].ToString()); } ArrayListarr=newArrayList(); foreach(TreeNodenodesinthis.treeright.Nodes) { arr.Add(nodes); foreach(TreeNodenodeinnodes.Nodes) { arr.Add(node); } } for(inti=0;i { if(list[i].ToString()=="yes") { ((TreeNode)arr[i]).Checked=true; } else { ((TreeNode)arr[i]).Checked=false; } } } } 4.权限修改 主要代码: publicpartialclassUserRight: Form { publicUserRight() { InitializeComponent(); } privatevoidbtncancel_Click(objectsender,EventArgse) { this.Close(); } privatevoidUserRight_Load(objectsender,EventArgse) { this.checkbox.SelectedIndex=0; this.partbox.SelectedIndex=0; } privatevoidFill() { if(this.checkbox.Text=="") { MessageBox.Show("请选择要使用的查询字段! ","提示! "); return; } if(this.partbox.Text=="") { MessageBox.Show("请选择用户所在的部门! ","提示! "); return; } stringsql=string.Empty; sql+="selectuidasID号,uaccas帐号,unameas姓名,usexas性别,upartas部门,utelphoneas移动电话,uphoneas固定电话,udateas注册日期,urightas权限fromtb_user"; if(this.checktxt.Text! ="") { stringc=this.checkbox.SelectedIndex.ToString(); switch(c) { case"0": //用户帐号 if(this.checktxt.Text! =string.Empty) { sql+="whereuacclike'%"+this.checktxt.Text+"%'"; } break; case"1": //用户姓名 if(this.checktxt.Text! =string.Empty) { sql+="whereunamelike'%"+this.checktxt.Text+"%'"; } break; default: break; } if(this.partbox.SelectedIndex.ToString()! ="0") { sql+="andupart='"+this.partbox.Text+"'"; } } else { if(this.partbox.SelectedIndex.ToString()! ="0") { sql+="whereupart='"+this.partbox.Text+"'"; } } sql+="orderbyuaccasc"; DataTabledt=DBHelp.ExeOleCommand(sql); this.dataGridView1.DataSource=dt; } privatevoidcheckbtn_Click(objectsender,EventArgse) { Fill(); } privatevoidcell_click(objectsender,DataGridViewCellEventArgse) { this.txtuacc.Text=this.dataGridView1[1,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtname.Text=this.dataGridView1[2,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtsex.Text=this.dataGridView1[3,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtpart.Text=this.dataGridView1[4,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txttel.Text=this.dataGridView1[5,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtphone.Text=this.dataGridView1[6,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtdate.Text=this.dataGridView1[7,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtright.Text=this.dataGridView1[8,this.dataGridView1.CurrentCell.RowIndex].Value.ToString().Trim(); this.txtright.Enabled=true; } privatevoidbtnchange_Click(objectsender,EventArgse) { if(this.txtuacc.Text=="") { MessageBox.Show("执行操作前,请先在下表选择要修改的用户! ","提示! "); return; } DialogResultres; res=MessageBox.Show("您确定要修改该用户吗? ","提示! ",MessageBoxButtons.YesNo); if(res==DialogResult.Yes) { stringsql=string.Empty; sql+="updatetb_userseturight='"+this.txtright.Text+"'"; sql+="whereuacc='"+this.txtuacc.Text+"'"; DataTabledt=DBHelp.ExeOleCommand(sql); MessageBox.Show("修改成功! ","恭喜! "); Fill(); } } } 5.添加图书信息 主要代码: publicpartialclassNewBook: Form { publicNewBook() { InitializeComponent(); } privatevoidretbtn_Click(objectsender,EventArgse) { this.Hide(); } privatevoidsavebtn_Click(objectsender,EventArgse) { if(this.booknotxt.Text=="") { MessageBox.Show("请输入图书的信息! ","提示! "); return; } if(this.booknametxt.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("请输入图书的信息! ","提示!
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 图书 管理 系统 源代码