图书管理系统结题报告

** 学院计算机科学系实训项目结题报告项目名称图书管理系统课程名称C# Winform 程序设计实践专业软件技术班级软件121 项目组编号项目经理**实训时间2014.1.3项目经理填写成员，实训成绩由教师填写：项目详细设计：1.程序清单：11个界面设计frmBookAdd.cs 书籍添加frmReturnBooks.cs 归还书籍frmBorrowBooks.cs 借出书籍frmChangePassword.cs 密码修改frmBookManage.cs 书籍管理frmReaderManage.cs 用户管理frmLogin.cs 登陆frmMain.cs 主界面frmAddReader.cs 添加用户frmoperation.cs 用户管理（注销与挂失）frmUpdateBooks.cs 图书修改frmQueryReader.cs 查询用户frmfindBooks.cs 查询图书具体设计简介：操作流程1、数据库设计：2、界面的设计：13个界面3、第一个任务：日常操作：E、图书归还F、图书借出3、第三个任务：用户管理G、用户查询H、用户修改I、用户删除J、用户增加详细设计登陆：主界面：实现，图书管理，用户管理，图书借阅，图书归还，修改用户密码等界面的跳转借阅书籍：先查询读者的信息，再根据读者额的相关信息做图书的借阅：读者信息：图书借阅：private void button1_Click(object sender, EventArgs e){StringBuilder builder = new StringBuilder();builder.Append("select * from Bookstore where bookid like'"+ tbbooksid.Text.ToString().Trim() + "'");dgvBooksINfor.AutoGenerateColumns = false;SqlConnection sc1 = new SqlConnection("data source=(local);initial catalog=BMS;integrated security=true");SqlDataAdapter sda1 = new SqlDataAdapter(builder.ToString(), sc1);dsbook = new DataSet();sda1.Fill(dsbook);bsbook = new BindingSource(dsbook, "Table");//renovate();if (tbname.Text == ""){MessageBox.Show("请?先è选?择?读á者?，?然?后ó再ù增?加ó图?书酣?");return;}if (tbbooksid.Text == ""){MessageBox.Show("请?选?择?图?书酣?", "系μ统?提示?");return;}//手?动ˉ添加ó行Dbsbook = new BindingSource(dsbook, "Table");DataRowView drv = (DataRowView)bsbook.Current;if (Convert.ToInt32(drv["count"]) < 1)//判断是否能够借出{MessageBox.Show("图书酣库存不足，暂时骸不能借è出！", "系统提示");return;}if (tbrentnum.Text.ToString()=="0")//根据当獭前用户判断用户的可借本数簓{MessageBox.Show("当獭前用户的可借本数簓达到最大洙值", "系统提示");return;}DataGridViewRow row = new DataGridViewRow();DataGridViewCheckBoxCell cb1 = new DataGridViewCheckBoxCell();cb1.Value = false;//数簓据Y库a中D的?已?连?接ó问ê题琣的?编括写′SqlConnection scinsert = new SqlConnection("data source=(local);initial catalog=BMS;integrated security=true");scinsert.Open();SqlCommand scmdinsert = new SqlCommand("update Bookstore set count=count+1 where bookid='"+row.Cells[1].Value.ToString()+"'", scinsert);scmdinsert.ExecuteNonQuery();scinsert.Close();}MessageBox.Show("归还成é功！", "系统提示");}}书籍管理：修改书籍、添加书籍、删除书籍、查询书籍、书籍类型的树状图private void bt_DB_addbook_Click(object sender, EventArgs e)//增?加ó图?书酣{frmAddBooks frm = new frmAddBooks(dsRead, dr, sdaRead, tableBookType);frm.Show();}private void bt_DB_deletebook_Click(object sender, EventArgs e)//删?除y图?书酣{if (dgvReadManage.SelectedRows.Count == 0){//return;MessageBox.Show("请?您ú选?择?要癮删?除y的?行D再ù进?行D操ù作痢！?","系μ统?提示?");}for (int i = 0; i < this.dgvReadManage.SelectedRows.Count; i++){this.dgvReadManage.Rows.Remove(this.dgvReadManage.SelectedRows[i]);}sdaRead.Update(dsRead);dsRead.AcceptChanges();MessageBox.Show("保馈存?成é功|！?","系μ统?提示?");}private void bt_DB_updatebook_Click(object sender, EventArgs e)//修T改?图?书酣 {if (dgvReadManage.SelectedRows.Count == 0){MessageBox.Show("请?选?中D要癮修T改?的?行D后ó在ú进?行D修T改?！?");return;}DataGridViewRow dgvrow = dgvReadManage.SelectedRows[0];string id1 = dgvrow.Cells[1].Value.ToString().Trim();DataRow[] dr = dsRead.Tables[0].Select("bookid='" + id1 + "'");frmUpdateBooks frm = new frmUpdateBooks(dsRead,tableBookType,dr[0]);frm.Show();bs = new BindingSource(dsRead, "Table");}private void bt_DB_findbook_Click(object sender, EventArgs e)//查é询ˉ图?书酣 {frmfindBooks fr = new frmfindBooks(dsRead);fr.Show();}private void bt_DB_exit_Click(object sender, EventArgs e){frmMain frm = new frmMain(user);frm.Show();this.Close();}private void frmBookManage_Load(object sender, EventArgs e){//dgvReadManage的填充SqlConnection sc = new SqlConnection("data source=(local);initial catalog=BMS;integrated security=true"); sdaRead = new SqlDataAdapter("select * from Bookstore", sc);SqlCommandBuilder scb = new SqlCommandBuilder(sdaRead);dsRead = new DataSet();sdaRead.Fill(dsRead);dgvReadManage.AutoGenerateColumns = false;dgvReadManage.DataSource = dsRead.Tables[0];}添加书籍public partial class frmAddBooks : Form{public frmBookManage frm1 = null;private SqlDataAdapter sda;private DataSet dsRead;private DataRow dr;private DataTable tableBookType;public frmAddBooks(DataSet_dsRead, DataRow_dr, SqlDataAdapter_sda, DataTable _tableBookType){InitializeComponent();dsRead = _dsRead;dr = _dr;sda = _sda;tableBookType = _tableBookType;tbnZC.Text = "1";//tbpublish.Text = dr["name"].ToString();//tbnAddress.Text = dr["address"].ToString();}private void btnagain_Click(object sender, EventArgs e){if (tbbookid.Text == "" && tbname.Text == ""){MessageBox.Show("请?您ú填?写′完整?信?息￠", "系μ统?提示?");}DataRow drRead = dsRead.Tables[0].NewRow();//if (opfpicture.FileName != "")//{// Stream streamPhoto = opfpicture.OpenFile();// byte[] bytePhoto = new byte[streamPhoto.Length];// streamPhoto.Read(bytePhoto, 0, bytePhoto.Length);// drRead["photo"] = bytePhoto;//}drRead["bookid"] = tbbookid.Text;drRead["ISBN"] = tbISBN.Text;drRead["name"] = tbname.Text;drRead["classNumber"] = cbclassNum.SelectedValue;//drRead["className"] = cbclassNum.SelectedValue;drRead["writer"] = btnwriter.Text;drRead["price"] = btnprice.Text;drRead["publishTime"] = DateTime.Now.ToString();drRead["enterTime"] = DateTime.Now.ToString();drRead["batch"] = tbnZC.Text;drRead["content"] = tbcontent.Text;drRead["remarks"] = tbremarks.Text;drRead["page"] = tbpage.Text;drRead["language"] = tblanguage.Text;drRead["present"] = tbgift.Text;drRead["findNum"] = cbclassNum.SelectedIndex + "/" + tbnZC.Text;drRead["count"] = tbcount.Text;drRead["publishing"] = tbpublish.Text;drRead["publishingaddress"] = tbnAddress.Text;dsRead.Tables[0].Rows.Add(drRead);SqlConnection sc = new SqlConnection("data source=(local);initial catalog=BMS;integrated security=true");sc.Open();SqlCommand scmd = new SqlCommand("select * from Bookstore where id='"+ tbbookid.Text.Trim() + "'", sc);SqlDataReader sdr = scmd.ExecuteReader(CommandBehavior.CloseConnection);bool userExist = sdr.HasRows;sdr.Close();sc.Close();if (userExist){MessageBox.Show("此?书酣号?名?已?存?在ú！?请?您ú重?新?输?入?！?","系μ统?提示?");return;}MessageBox.Show("添加ó成é功|","系μ统?提示?");public partial class frmUpdateBooks : Form{private DataTable tableBookType;private DataSet dsRead;private DataRow dr;//private BindingSource bs;public frmUpdateBooks(DataSet _dsRead,DataTable _tableBookType,DataRow _dr) {InitializeComponent();tableBookType = _tableBookType;dsRead = _dsRead;dr = _dr;tbbookid.Text = dr["bookid"].ToString();tbISBN.Text = dr["ISBN"].ToString();tbname.Text = dr["name"].ToString();tbprice.Text = dr["price"].ToString();tbpublish.Text = dr["publishing"].ToString();tbwriter.Text = dr["writer"].ToString();tbnAddress.Text = dr["publishingaddress"].ToString();tbcount.Text = dr["count"].ToString();tbgift.Text = dr["present"].ToString();tbcontent.Text = dr["content"].ToString();tbremarks.Text = dr["remarks"].ToString();tbpage.Text = dr["page"].ToString();tblanguage.Text = dr["language"].ToString();dtentertime.Text = dr["enterTime"].ToString();dtpublishtime.Text = dr["publishTime"].ToString();cbclassNum.Text = dr["className"].ToString();}private void btnagain_Click(object sender, EventArgs e){dr["bookid"] = tbbookid.Text;dr["ISBN"]=tbISBN.Text;dr["name"]=tbname.Text;dr["price"]=tbprice.Text;dr["publishing"]=tbpublish.Text;dr["writer"]=tbwriter.Text;dr["publishingaddress"]=tbnAddress.Text;dr["count"]=tbcount.Text;dr["present"]=tbgift.Text;dr["content"]=tbcontent.Text;dr["remarks"]=tbremarks.Text;dr["page"]=tbpage.Text;dr["language"]=tblanguage.Text;dr["enterTime"]=dtentertime.Text;dr["publishTime"]=dtpublishtime.Text;dr["className"] = cbclassNum.Text;MessageBox.Show("修T改?成é功|！?", "系μ统?提示?", MessageBoxButtons.YesNo, rmation);}private void btnquit_Click(object sender, EventArgs e){this.Close();}}查询书籍public partial class frmfindBooks : Form{private DataSet dsRead;private BindingSource bs;public frmfindBooks(DataSet _dsRead){InitializeComponent();dsRead = _dsRead;}private void btnAdd_Click(object sender, EventArgs e){if (lvBookS.SelectedItems.Count == 0){return;}DataGridViewRow dgvrow = new DataGridViewRow();if (dgvTiaoJian.Rows.Count != 0){DataGridViewComboBoxCell cb1 = new DataGridViewComboBoxCell(); cb1.Items.Add("并￠且ò");cb1.Items.Add("或ò者?");dgvrow.Cells.Add(cb1);}else{DataGridViewTextBoxCell tb1 = new DataGridViewTextBoxCell(); tb1.Value = "无T";dgvrow.Cells.Add(tb1);}DataGridViewTextBoxCell tb2 = new DataGridViewTextBoxCell();ListViewItem lvI = lvBookS.SelectedItems[0];tb2.Value = lvI.Text;tb2.Tag = lvI.Tag;dgvrow.Cells.Add(tb2);lvBookS.Items.Remove(lvI);dgvTiaoJian.Rows.Add(dgvrow);}private void btndel_Click(object sender, EventArgs e){if (dgvTiaoJian.Rows.Count != 0){DataGridViewRow row = dgvTiaoJian.CurrentRow;dgvTiaoJian.Rows.Remove(row);ListViewItem lvI = new ListViewItem(row.Cells[1].Value.ToString());lvI.Tag = row.Cells[1].Tag;lvBookS.Items.Add(lvI);}elsereturn;}private void btnfind_Click(object sender, EventArgs e){StringBuilder builder = new StringBuilder();builder.Append("select * from Bookstore where ");foreach (DataGridViewRow dgvrow in dgvTiaoJian.Rows){if (dgvrow.Cells[0].Value.ToString() != "无T"){if (dgvrow.Cells[0].Value.ToString() == "或ò者?"){builder.Append(" or ");}else builder.Append(" and ");}//条?件t连?接óbuilder.Append(" " + dgvrow.Cells[1].Tag.ToString() + " ");//列名?称?try{if (dgvrow.Cells[2].Value.ToString() == "好?像?"){builder.Append(" like '%" + dgvrow.Cells[3].Value.ToString() + "%'");}else if (dgvrow.Cells[2].Value.ToString() == "一?定¨"){builder.Append(" = '" + dgvrow.Cells[3].Value.ToString() + "'");}}catch (Exception ex){MessageBox.Show(ex + "请?您ú选?择?条?件t","系μ统?提示?");}}dgvReadManage.AutoGenerateColumns = false;SqlConnection sc = new SqlConnection("data source=(local);initial catalog=BMS;integrated security=true");SqlDataAdapter sda = new SqlDataAdapter(builder.ToString(), sc);DataSet ds = new DataSet();sda.Fill(ds);bs = new BindingSource(ds,"Table");dgvReadManage.DataSource = bs;}private void btnquit_Click(object sender, EventArgs e){this.Close();}用户管理：用户查询：public partial class frmAddReader : Form{private DataSet dsread;private BindingSource bsreadtype;private Users user;public frmAddReader(DataSet _dsread, Users _user, BindingSource _bsreadtype) {InitializeComponent();user = _user;dsread = _dsread;bsreadtype = _bsreadtype;}private void AddReader_Load(object sender, EventArgs e){CBRType.DataSource = bsreadtype;CBRType.DisplayMember = "type";}private void button2_Click(object sender, EventArgs e){DataRow dr =dsread.Tables[0].NewRow();dr["id"] = tbRID.Text;dr["name"] = tbRname.Text;dr["sex"] = rbn.Checked ? "男D" : "女?";dr["readTYpe"] = CBRType.Text;dr["type"] = tbZT.Text;dr["phone"] = tbphone.Text;dr["Email"] = tbEAddress.Text;dr["homeAddress"] = tbPAddress.Text;dr["remark"] = tbBZ.Text;dr["type"] = comboBox1.SelectedValue;dsread.Tables[0].Rows.Add(dr);tbRID.Clear();tbRname.Clear();tbZT.Clear();tbphone.Clear();tbPAddress.Clear();tbEAddress.Clear();}private void button3_Click(object sender, EventArgs e){//this.Close();}}用户查询：public partial class frmQueryReader : Form{private DataSet dsread;private DataSet dsreadtype;private Users user;public frmQueryReader(DataSet _ds, Users _user, DataSet _dsreadtype) {InitializeComponent();user = _user;dsread = _ds;dsreadtype = _dsreadtype;}private void frmQueryReader_Load(object sender, EventArgs e){dataGridView1.DataSource = dsread;dataGridView1.DataMember = "Table";dataGridView1.AutoGenerateColumns = false;dataGridView1.DataSource = dsread.Tables[0].DefaultView;}private void textBox9_KeyUp(object sender, KeyEventArgs e){dsread.Tables[0].DefaultView.RowFilter = "id like '"+ textBox9.Text + "%'or id like '%" + textBox9.Text + "'or id like '%" + textBox9.Text + "%'";}private void textBox2_KeyUp(object sender, KeyEventArgs e){dsread.Tables[0].DefaultView.RowFilter = "name like '"+ textBox2.Text + "%'or name like '%" + textBox2.Text + "'or name like '%" + textBox2.Text + "%'";}用户修改：public partial class frmUpdateReader : Formprivate void button2_Click(object sender, EventArgs e) {dr["id"] = tbRID.Text;dr["name"] = tbRname.Text;dr["sex"] = rbn.Checked ? "男D" : "女?";dr["ReadId"] = CBRType.Text;dr["type"] = tbZT.Text;dr["phone"] = tbphone.Text;dr["Email"] = tbEAddress.Text;dr["homeAddress"] = tbPAddress.Text;dr["remark"] = tbBZ.Text;dsread.Tables[0].Rows.Add(dr);tbRID.Clear();tbRname.Clear();tbZT.Clear();tbphone.Clear();tbPAddress.Clear();tbEAddress.Clear();}private void button1_Click(object sender, EventArgs e) {this.Close();}}用户注销与挂失：public partial class frmoperation : Form{private Users user;{SqlConnection sc = new SqlConnection("data source=(local);initial catalog=BMS;integrated security=true");sc.Open();SqlCommand scmdEdit = new SqlCommand("update Readers set type='"+ "挂ò失骸?+ "'where id='" + tbreadid.Text.ToString().Trim() + "'", sc);scmdEdit.ExecuteNonQuery();sc.Close();MessageBox.Show("挂ò失骸成é功|！?");}else if (chZX.Checked == true){SqlConnection sc = new SqlConnection("data source=(local);initial catalog=PIMS;integrated security=true");sc.Open();SqlCommand scmdEdit = new SqlCommand("delete from Readers where（辍eaders.Sno=select *from Readers where id='" + tbreadid.Text.ToString().Trim() + "')", sc);scmdEdit.ExecuteNonQuery();sc.Close();MessageBox.Show("注痢销ú成é功|！?");}elsereturn;}}下表由项目组成员填写项目进度报告项目名称：图书管理系统负责人：**指导教师意见：指导教师签名：。