《Visual C# NET案例教程》课件第12章

第12章图书管理系统开发实例

12.1图书管理系统简介12.2图书管理系统主要模块12.3安装程序制作12.4习题图书管理系统广泛应用于学校、企业、事业等单位，提供包括读者信息管理、图书信息管理、用户信息管理、借还书、报表显示和综合查询等功能。图书管理系统的功能如图12-1所示。12.1图书管理系统简介图12-1系统功能模块图12.2.1公用类

公用类的代码如下：12.2图书管理系统主要模块usingSystem;

usingSystem.Collections.Generic;

usingSystem.Text;

usingSystem.Data;

usingSystem.Data.SqlClient;

usingSystem.Windows.Forms;

namespaceBook

{

classCommon

{

//清空容器控件container(如groupbox、panel控件)里的编辑框

publicstaticvoidclear(Controlcontainer)

{foreach(Controlctrincontainer.Controls)

{

if(ctrisTextBox)

{

(ctrasTextBox).Text="";

}

}

}

//使控件容器内的所有控件disable

publicstaticvoiddisableControl(Controlcontainer)

{

foreach(Controlctrincontainer.Controls)

{if(!(ctrisLabel))

ctr.Enabled=false;

}

}

//使控件容器内的所有控件enable

publicstaticvoidenableControl(Controlcontainer)

{

foreach(Controlctrincontainer.Controls)

{

if(!(ctrisLabel))

ctr.Enabled=true;

}

}

publicstaticvoidIsDigit(KeyPressEventArgse)//判断按下的是否为数字键

{

if((e.KeyChar!=8&&!char.IsDigit(e.KeyChar))&&e.KeyChar!=13)

{

MessageBox.Show("请输入数字");

e.Handled=true;

}

}

//功能：验证用户是否合法

//参数userName;用户名pwd;口令

//合法用户返回true，否则返回false

publicstaticboolvalidate(StringuserName,Stringpwd)

{

stringsql="selectPWDfromuserswhereusername=@userName";

SqlParameter[]param=newSqlParameter[1];

param[0]=newSqlParameter("@userName",SqlDbType.VarChar);

param[0].Value=userName;

DBHelperhelper=newDBHelper();

SqlDataReaderreader=helper.GetReader(sql,param);

try

{

if(reader.Read()&&reader.GetString(0)==pwd)

{

returntrue;

}

else

{

returnfalse;

}

}

finally

{

reader.Close();

}

}

}

}12.2.2系统主窗体

系统采用MDI窗体界面，主窗体界面如图12-2所示。图12-2系统主窗体主窗体的代码如下：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Drawing;

usingSystem.Text;

usingSystem.Windows.Forms;

namespaceBook

{

publicpartialclassFrmMain:Form

{

publicstaticstringuserName;

publicstaticstringpassword;publicFrmMain()

{

InitializeComponent();

}

privatevoid读者信息ToolStripMenuItem_Click(objectsender,EventArgse)

{

if(!isExist("FrmReader"))

{

FrmReaderfrm=newFrmReader();

frm.MdiParent=this;

frm.Show();

}}

privatevoid图书信息ToolStripMenuItem_Click(objectsender,EventArgse)

{

if(!isExist("FrmBook"))

{

FrmBookfrm=newFrmBook();

frm.MdiParent=this;

frm.Show();

}

}

privatevoid借书ToolStripMenuItem_Click(objectsender,EventArgse)

{if(!isExist("FrmBorrow"))

{

FrmBorrowfrm=newFrmBorrow();

frm.MdiParent=this;

frm.Show();

}

}

privatevoid还书ToolStripMenuItem_Click(objectsender,EventArgse)

{

if(!isExist("FrmReturn"))

{

FrmReturnfrm=newFrmReturn();

frm.MdiParent=this;

frm.Show();}

}

privatevoidfrmMain_Load(objectsender,EventArgse)

{

tssLabel1.Text="当前用户："+userName;

}

boolisExist(stringfrmName)//判断名为frmName的窗体是否已存在

{

foreach(FormfrminMdiChildren)

{

if(frm.Name==frmName)

{

frm.BringToFront(); //把窗体放到前面显示

returntrue;}

}

returnfalse;

}

privatevoid水平平铺ToolStripMenuItem_Click(objectsender,EventArgse)

{

LayoutMdi(MdiLayout.TileHorizontal);

}

privatevoid垂直平铺ToolStripMenuItem_Click(objectsender,EventArgse)

{

LayoutMdi(MdiLayout.TileVertical);}

privatevoid层叠ToolStripMenuItem_Click(objectsender,EventArgse)

{

LayoutMdi(MdiLayout.Cascade);

}

privatevoid关闭当前窗口ToolStripMenuItem1_Click(objectsender,EventArgse)

{

ActiveMdiChild.Close();

}

privatevoid全部关闭ToolStripMenuItem1_Click(objectsender,EventArgse){

foreach(FormfrminMdiChildren)

{

frm.Close();

}

}

privatevoid修改口令ToolStripMenuItem_Click(objectsender,EventArgse)

{

FrmChangePWDfrmChangePWD=newFrmChangePWD();

frmChangePWD.ShowDialog();

}

privatevoid图书类别维护ToolStripMenuItem_Click(objectsender,EventArgse){

FrmReaderTypefrmReaderType=newFrmReaderType();

frmReaderType.ShowDialog();

}

privatevoid备份ToolStripMenuItem_Click(objectsender,EventArgse)

{

FrmBackupfrm=newFrmBackup();

frm.ShowDialog();

}

privatevoid借阅排行ToolStripMenuItem_Click(objectsender,EventArgse)

{

FrmBorrowSortfrm=newFrmBorrowSort();

frm.ShowDialog();

}

privatevoid恢复ToolStripMenuItem_Click(objectsender,EventArgse)

{

FrmRestorefrm=newFrmRestore();

frm.ShowDialog();

}

privatevoid关于ToolStripMenuItem_Click(objectsender,EventArgse)

{

FrmAboutfrm=newFrmAbout();

frm.ShowDialog();

}

privatevoid超期书ToolStripMenuItem_Click(objectsender,EventArgse)

{

FrmExpiredfrm=newFrmExpired();

frm.ShowDialog();

}

}

}12.2.3用户登录

用户登录模块提供用户的登录功能，窗体如图12-3所示。图12-3用户登录单击“登录”按钮的代码如下：

privatevoidbtnLogin_Click(objectsender,EventArgse)

{

stringsql="select口令from用户表where用户名=@userName";

SqlParameter[]param=newSqlParameter[]{newSqlParameter

("@userName",SqlDbType.VarChar)};

param[0].Value=txtUserName.Text;

DBHelperhelper=newDBHelper();

SqlDataReaderreader=helper.GetReader(sql,param);

try

{

if(reader.Read()&&reader["口令"].ToString()==txtPWD.Text)

{FrmMain.userName=txtUserName.Text;//用静态变量保存用户名

FrmMain.password=txtPWD.Text; //用静态变量保存口令

this.DialogResult=DialogResult.OK; //关闭窗口，并返回DialogResult.OK

}

else

{

MessageBox.Show("登录失败！");

}

}

finally

{

reader.Close();

}

}登录窗体在系统启动时创建，启动文件Program.cs的代码如下：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.Windows.Forms;

namespaceBook

{

staticclassProgram

{

///<summary>

///应用程序的主入口点

///</summary>

[STAThread]

staticvoidMain(){

Application.EnableVisualStyles();

Application.SetCompatibleTextRenderingDefault(false);

FrmLoginfrm=newFrmLogin();

DialogResultresult=frm.ShowDialog();

//在显示主窗体前打开登录窗体根据返回值判断登录是否成功

if(result==DialogResult.OK) //登录成功

Application.Run(newFrmMain()); //创建主窗体

}

}

}12.2.4读者信息维护

读者信息模块提供对读者信息的增加、删除与修改功能。读者信息窗体界面如图12-4所示。图12-4读者信息读者信息窗体的主要代码如下：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Data.SqlClient;

usingSystem.Drawing;

usingSystem.Text;

usingSystem.Windows.Forms;

namespaceBook

{

publicpartialclassFrmReader:Form

{

stringflag="";stringsql="";

publicFrmReader()

{

InitializeComponent();

}

privatevoidFrmReader_Load(objectsender,EventArgse)

{

tsbCancel.Enabled=false;

tsbSave.Enabled=false;

cbxSex.Items.Add("男");

cbxSex.Items.Add("女");

DBHelperdbHelp=newDBHelper();cbxType.DataSource=dbHelp.GetDataSet("SELECT*FROM读者类别表").Tables[0];

cbxType.DisplayMember="读者类别名";

cbxType.ValueMember="读者类别编号";

bind();

Common.disableControl(panel1);

}

//绑定数据到dataGridView1

voidbind()

{

DBHelperdbHelp=newDBHelper();

dataGridView1.AutoGenerateColumns=true;

if(sql=="")dataGridView1.DataSource=dbHelp.GetDataSet("select*fromv_reader").Tables[0];

else

{

SqlParameter[]param=newSqlParameter[]{newSqlParameter("@name","%"+textBox1.Text+"%")};

dataGridView1.DataSource=dbHelp.GetDataSet(sql,param).Tables[0];

}

if(dataGridView1.RowCount>0)

fill();

}

//单击“增加”按钮privatevoidtsbAdd_Click(objectsender,EventArgse)

{

tsbAdd.Enabled=false;

tsbEdit.Enabled=false;

tsbDelete.Enabled=false;

tsbCancel.Enabled=true;

tsbSave.Enabled=true;

dataGridView1.Enabled=false;

dataGridView1.ForeColor=Color.Gray;

Common.enableControl(panel1);

Common.clear(panel1);

flag="add";

}

//单击“删除”按钮privatevoidtsbDelete_Click(objectsender,EventArgse)

{

DBHelperdbHelp=newDBHelper();

dbHelp.ExecuteCommand("delete读者表where读者编号="+dataGridView1.CurrentRow.Cells["读者编号"].Value.ToString());

bind();

}

//单击“编辑”按钮

privatevoidtsbEdit_Click(objectsender,EventArgse)

{

tsbAdd.Enabled=false;

tsbEdit.Enabled=false;

tsbDelete.Enabled=false;

tsbCancel.Enabled=true;tsbSave.Enabled=true;

dataGridView1.Enabled=false;

dataGridView1.ForeColor=Color.Gray;

Common.enableControl(panel1);

flag="edit";

}

//单击“取消”按钮

privatevoidtsbCancel_Click(objectsender,EventArgse)

{

tsbAdd.Enabled=true;

tsbEdit.Enabled=true;

tsbDelete.Enabled=true;

tsbCancel.Enabled=false;tsbSave.Enabled=false;

dataGridView1.Enabled=true;

dataGridView1.ForeColor=Color.Black;

Common.disableControl(panel1);

fill();

flag="";

}

//单击“保存”按钮

privatevoidtsbSave_Click(objectsender,EventArgse)

{

stringsql;

DBHelperdbHelp=newDBHelper();

if(flag=="add")

{sql="INSERTINTO读者表(借书证号,姓名,性别,部门,读者类别编号)

VALUES(@card,@name,@sex,@depart,@readerTypeNO)";

SqlParameter[]param=newSqlParameter[]{

newSqlParameter("card",txtCard.Text),

newSqlParameter("name",txtName.Text),

newSqlParameter("sex",cbxSex.Text),

 newSqlParameter("name",txtName.Text),

 newSqlParameter("depart",txtDepart.Text),

 newSqlParameter("readerTypeNO",cbxType.

SelectedValue)

};

dbHelp.ExecuteCommand(SQL,param);MessageBox.Show("成功增加一条记录");

bind();

Common.clear(panel1);

}

elseif(flag=="edit")

{

sql="UPDATE读者表SET借书证号=@card,姓名=@readerName,性别=@sex,部门=@depart,读者类别编号=@readerTypeNOWHERE读者编号=@readerNO";

SqlParameter[]param=newSqlParameter[]{

newSqlParameter("card",txtCard.Text),

newSqlParameter("readerName",txtName.Text),

newSqlParameter("sex",cbxSex.Text),newSqlParameter("name",txtName.Text),

newSqlParameter("depart",txtDepart.Text),

newSqlParameter("readerTypeNO",cbxType.

SelectedValue),

newSqlParameter("readerNO",dataGridView1.

CurrentRow.Cells["读者编号"].Value.ToString()

)

};

dbHelp.ExecuteCommand(SQL,param);

MessageBox.Show("记录修改成功!");

bind();

tsbCancel_Click(null,null);

}

}//用dataGridView1中当前行的内容填充各相应的编辑框

voidfill()

{

//txtCard.Text=dataGridView1.CurrentRow.Cells["借书证号"].Value.ToString();

txtCard.Text=dataGridView1.CurrentRow.Cells[1].Value.ToString();

//txtName.Text=dataGridView1.CurrentRow.Cells["姓名"].Value.ToString();

txtName.Text=dataGridView1.CurrentRow.Cells[2].Value.ToString();

cbxSex.SelectedIndex=cbxSex.Items.IndexOf(dataGridView1.CurrentRow.Cells["性别"].Value.ToString());

txtDepart.Text=dataGridView1.CurrentRow.Cells["部门"].Value.ToString();

cbxType.SelectedValue=dataGridView1.CurrentRow.Cells["读者类别编号"].Value.ToString();

}

//单击dataGridView1的单元格

privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse)

{

fill();

}

//单击“查找”按钮

privatevoidbtnSearch_Click(objectsender,EventArgse)

{

sql="select*fromv_readerwhere姓名like@name";

bind();

}

}

}12.2.5图书信息维护

图书信息维护模块提供对图书信息的增加、删除与修改功能。图书信息维护窗体界面如图12-5所示。图12-5图书信息维护图书信息维护窗体的代码如下：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Data.SqlClient;

usingSystem.Drawing;

usingSystem.Text;

usingSystem.Windows.Forms;

namespaceBook

{

publicpartialclassFrmBook:Form

{stringflag="";//状态标志，值取edit与add分别表示当前为编辑与增加状态

stringsql="";

publicFrmBook()

{

InitializeComponent();

}

privatevoidFrmBook_Load(objectsender,EventArgse)

{

tsbCancel.Enabled=false;

tsbSave.Enabled=false;

comboBox1.Items.Clear();

comboBox1.Items.Add("按书名");comboBox1.Items.Add("按作者");

comboBox1.SelectedIndex=0;

panel3.BringToFront();

bind();

disableControl();

}

voidbind()

{

DBHelperdbHelp=newDBHelper();

dataGridView1.AutoGenerateColumns=true;

if(sql=="")

dataGridView1.DataSource=dbHelp.GetDataSet("select*from图书表").Tables[0];else

{

SqlParameter[]param=newSqlParameter[]{newSqlParameter("@key","%"+textBox1.Text+"%")};

dataGridView1.DataSource=dbHelp.GetDataSet(sql,param).Tables[0];

}

if(dataGridView1.RowCount>0)

fill();

}

privatevoidtsbAdd_Click(objectsender,EventArgse)

{

tsbAdd.Enabled=false;tsbEdit.Enabled=false;

tsbDelete.Enabled=false;

tsbCancel.Enabled=true;

tsbSave.Enabled=true;

dataGridView1.Enabled=false;

dataGridView1.ForeColor=Color.Gray;

Common.enableControl(panel1);

Common.clear(panel1);

flag="add";

}

privatevoiddisableControl()

{

foreach(Controlctrinpanel1.Controls)

{if(!(ctrisLabel))

ctr.Enabled=false;

}

}

privatevoidtsbDelete_Click(objectsender,EventArgse)

{

try

{

if(MessageBox.Show("确定要删除该图书吗？","提示",MessageBoxButtons.

OKCancel,MessageBoxIcon.Question)==DialogResult.OK)

{DBHelperdbHelp=newDBHelper();

dbHelp.ExecuteCommand("delete图书表where图书编号="CurrentRow.Cells["图书编号"].Value.ToString());

bind();

MessageBox.Show("删除数据成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);

}

}

catch(Exceptionex)

{

MessageBox.Show(ex.Message,"提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Information);

}

}

privatevoidtsbEdit_Click(objectsender,EventArgse)

{

tsbAdd.Enabled=false;

tsbEdit.Enabled=false;

tsbDelete.Enabled=false;

tsbCancel.Enabled=true;

tsbSave.Enabled=true;

dataGridView1.Enabled=false;

dataGridView1.ForeColor=Color.Gray;

Common.enableControl(panel1);

flag="edit";}

privatevoidtsbCancel_Click(objectsender,EventArgse)

{

tsbAdd.Enabled=true;

tsbEdit.Enabled=true;

tsbDelete.Enabled=true;

tsbCancel.Enabled=false;

tsbSave.Enabled=false;

dataGridView1.Enabled=true;

dataGridView1.ForeColor=Color.Black;

disableControl();

fill();

flag="";

}privatevoidtsbSave_Click(objectsender,EventArgse)

{

stringsql;

DBHelperdbHelp=newDBHelper();

if(flag=="add")

{

sql="INSERTINTO图书表(ISBN,书名,作者,价格,出版社,出版日期,库存数)

VALUES(@isbn,@bookName,@author,@price,@publisher,@pubDate,@qty)";

SqlParameter[]param=newSqlParameter[]{

newSqlParameter("isbn",txtISBN.Text),newSqlParameter("bookName",txtBookName.Text),

newSqlParameter("author",txtAuthor.Text),

newSqlParameter("price",txtPrice.Text),

newSqlParameter("publisher",txtPublisher),

newSqlParameter("pubDate",datePublisher.Value),

newSqlParameter("qty",txtQty.Text)};

dbHelp.ExecuteCommand(sql,param);

MessageBox.Show("成功增加一条记录");

bind();

Common.clear(panel1);

}

elseif(flag=="edit")

{sql="UPDATE图书表SETISBN=@isbn,书名=@bookName,

作者=@author,价格=@price,出版社=@publisher,出版日期

=@pubDate,库存数=@qtyWHERE图书编号

=@bookNO";

SqlParameter[]param=newSqlParameter[]{

newSqlParameter("isbn",txtISBN.Text),

newSqlParameter("bookName",txtBookName.Text),

newSqlParameter("author",txtAuthor.Text),

newSqlParameter("price",txtPrice.Text),

newSqlParameter("publisher",txtPublisher.Text),

newSqlParameter("pubDate",datePublisher.Value),

newSqlParameter("qty",txtQty.Text),

newSqlParameter("bookNO",dataGridView1.

CurrentRow.Cells["图书编号"].Value.ToString())};

dbHelp.ExecuteCommand(sql,param);

MessageBox.Show("记录修改成功!");

bind();

tsbCancel_Click(null,null);

}

}

voidfill()

{

txtISBN.Text=dataGridView1.CurrentRow.Cells["ISBN"].Value.ToString();txtBookName.Text=dataGridView1.CurrentRow.Cells["书名"].Value.ToString();

txtAuthor.Text=dataGridView1.CurrentRow.Cells["作者"].Value.ToString();

txtPrice.Text=dataGridView1.CurrentRow.Cells["价格"].Value.ToString();

txtPublisher.Text=dataGridView1.CurrentRow.Cells["出版社"].Value.ToString();

datePublisher.Value=Convert.ToDateTime(dataGridView1.CurrentRow.Cells

["出版日期"].Value.ToString());

txtQty.Text=dataGridView1.CurrentRow.Cells["库存数"].Value.ToString();}

privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse)

{

fill();

}

privatevoidbtnSearch_Click(objectsender,EventArgse)

{

sql="SELECT*FROM图书表where{0}like@key";

if(comboBox1.Text=="按书名")

{

sql=string.Format(sql,"书名");

}

else{

sql=string.Format(sql,"作者");

}

bind();

}

privatevoidtxtQty_KeyPress(objectsender,KeyPressEventArgse)

{

Common.IsDigit(e);

}

privatevoidtsbClose_Click(objectsender,EventArgse)

{

Close();

}

}

}12.2.6修改口令

修改口令模块提供口令的修改功能，窗体如图12-6所示。图12-6修改口令修改口令窗体的主要代码如下：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Data.SqlClient;

usingSystem.Drawing;

usingSystem.Text;

usingSystem.Windows.Forms;

namespaceBook

{

publicpartialclassFrmChangePWD:Form

{publicFrmChangePWD()

{

InitializeComponent();

}

privatevoidbutton1_Click(objectsender,EventArgse)

{

}

privatevoidbtnModify_Click(objectsender,EventArgse)

{

if(txtNewPWD1.Text!=txtNewPWD2.Text)

{

MessageBox.Show("两次口令不一致！");

return;

}stringsql="select口令from用户表where用户名=@userName";

SqlParameter[]param=newSqlParameter[]{newSqlParameter

("@userName",FrmMain.userName)};

DBHelperhelper=newDBHelper();

SqlDataReaderreader=helper.GetReader(sql,param);

try

{

if(!reader.Read()||reader["口令"].ToString()!=txtOldPWD.Text)

{

MessageBox.Show("原口令错误！");

return;

}

}

finally

{

reader.Close();

}

sql="update用户表set口令=@PWDwhere用户名=@userName";

param=newSqlParameter[]{

newSqlParameter("@PWD",txtNewPWD1.Text),

newSqlParameter("@userName",FrmMain.userName)

};

intret=helper.ExecuteCommand(sql,param);

if(ret>0){

MessageBox.Show("修改成功！");

}

else

{

MessageBox.Show("修改失败！");

}

}

privatevoidbtnCancel_Click(objectsender,EventArgse)

{

}

}

}12.2.7借书管理

借书管理模块提供图书借阅功能，窗体界面如图12-7所示。图12-7借书管理借书管理窗体的代码如下:

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Data.SqlClient;

usingSystem.Drawing;

usingSystem.Text;

usingSystem.Windows.Forms;

namespaceBook

{

publicpartialclassFrmBorrow:Form

{

publicFrmBorrow(){

InitializeComponent();

}

privatevoidgroupBox2_Enter(objectsender,EventArgse)

{

}

privatevoidFrmBorrow_Load(objectsender,EventArgse)

{

//初始化界面

txtReaderName.Enabled=false;

txtDepart.Enabled=false;

txtSex.Enabled=false;

txtReaderType.Enabled=false;//---------

txtBookName.Enabled=false;

txtAuthor.Enabled=false;

txtPublisher.Enabled=false;

txtPrice.Enabled=false;

datePublisher.Enabled=false;

//-----------

txtReaderName.BackColor=SystemColors.Info;

txtDepart.BackColor=SystemColors.Info;

txtSex.BackColor=SystemColors.Info;

txtReaderType.BackColor=SystemColors.Info;

//---------

txtBookName.BackColor=SystemColors.Info;txtAuthor.BackColor=SystemColors.Info;

txtPublisher.BackColor=SystemColors.Info;

txtPrice.BackColor=SystemColors.Info;

datePublisher.BackColor=SystemColors.Info;

dataGridView1.AllowUserToAddRows=false;

dataGridView1.ReadOnly=true;

}

privatevoidtxtCard_KeyDown(objectsender,KeyEventArgse)

{

//按下回车键时根据借书证号填充读者信息

if(e.KeyCode==Keys.Enter)

{

stringsql="select*fromv_readerwhere借书证号=@cardID";SqlParameter[]param=newSqlParameter[]{newSqlParameter("@cardID",txtCard.Text)};

DBHelperdbHelp=newDBHelper();

DataTabledt=dbHelp.GetDataSet(sql,param).Tables[0];

if(dt.Rows.Count>0)

{

txtReaderName.Text=dt.Rows[0]["姓名"].ToString();

txtDepart.Text=dt.Rows[0]["部门"].ToString();

txtSex.Text=dt.Rows[0]["性别"].ToString();

txtReaderType.Text=dt.Rows[0]["读者类别名"].ToString();

bind(txtCard.Text);

}

else

{

txtCard.Focus();

MessageBox.Show("无此读者");

}

}

}

//绑定显示已借信息

privatevoidbind(stringcardID)