图书管理系统结题报告

..**学院计算机科学系实训项目结题报告项目名称图书管理系统课程名称C#Winform程序设计实践专业软件技术班级软件121项目组编号项目经理**实训时间2014.1.3项目经理填写成员,实训成绩由教师填写：成员******个人成绩项目组总成绩教师签名项目需求概要：计算机技术的迅猛发展,特别是随着网络技术的出现标志着信息时代已经来临。信息化浪潮、网络革命在给社会带来冲击的同时,也使图书馆业务受到了强烈的冲击,图书馆传统的管理和服务方式已不能适应读者对日益增长的文献信息的需求,建设图书馆信息网络系统,是图书馆现代化建设的客观要求。建设以计算机为核心的图书馆信息网络,实现图书馆管理和服务的自动化,更好地为科技工作服务,是图书馆发展的必由之路。随着图书馆规模的不断扩大,图书数量也相应的增加,有关图书的各种信息量也成倍增加,面对着庞大的信息量,传统的人工方式管理会导致图书馆管理上的混乱,人力与物力过多浪费,图书馆管理费用的增加,从而使图书馆的负担过重,影响整个图书馆的运作和控制管理,因此,必须制定一套合理、有效,规范和实用的图书管理系统,对图书资料进行集中统一的管理变得非常有必要。所以,图书管理系统的制作是急迫的和必须的。项目计划：将项目分为5个模块：数据库的设计界面的设计第一个任务：日常操作：图书归还图书借出借阅情况第二个任务：资料管理添加书籍修改书籍删除书籍查询书籍第三个任务：用户管理用户查询用户修改用户删除用户增加项目详细设计：程序清单：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查询图书具体设计简介：操作流程数据库设计：界面的设计：13个界面3、第一个任务：日常操作：图书归还图书借出3、第三个任务：用户管理用户查询用户修改用户删除用户增加详细设计登陆：主界面：实现,图书管理,用户管理,图书借阅,图书归还,修改用户密码等界面的跳转借阅书籍：先查询读者的信息,再根据读者额的相关信息做图书的借阅：读者信息：图书借阅：privatevoidbutton1_Click<objectsender,EventArgse>{StringBuilderbuilder=newStringBuilder<>;builder.Append<"select*fromBookstorewherebookidlike'"+tbbooksid.Text.ToString<>.Trim<>+"'">;dgvBooksINfor.AutoGenerateColumns=false;SqlConnectionsc1=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;SqlDataAdaptersda1=newSqlDataAdapter<builder.ToString<>,sc1>;dsbook=newDataSet<>;sda1.Fill<dsbook>;bsbook=newBindingSource<dsbook,"Table">;//renovate<>;if<tbname.Text=="">{MessageBox.Show<"请?先è选?择?读á者?,?然?后ó再ù增?加ó图?书酣?">;return;}if<tbbooksid.Text=="">{MessageBox.Show<"请?选?择?图?书酣?","系μ统?提示?">;return;}//手?动ˉ添加ó行Dbsbook=newBindingSource<dsbook,"Table">;DataRowViewdrv=<DataRowView>bsbook.Current;if<Convert.ToInt32<drv["count"]><1>//判断是否能够借出{MessageBox.Show<"图书酣库存不足,暂时骸不能借è出！","系统提示">;return;}if<tbrentnum.Text.ToString<>=="0">//根据当獭前用户判断用户的可借本数簓{MessageBox.Show<"当獭前用户的可借本数簓达到最大洙值","系统提示">;return;}DataGridViewRowrow=newDataGridViewRow<>;DataGridViewCheckBoxCellcb1=newDataGridViewCheckBoxCell<>;cb1.Value=false;row.Cells.Add<cb1>;DataGridViewTextBoxCelltb2=newDataGridViewTextBoxCell<>;tb2.Value=drv["bookid"].ToString<>;row.Cells.Add<tb2>;DataGridViewTextBoxCelltb3=newDataGridViewTextBoxCell<>;tb3.Value=drv["name"].ToString<>;row.Cells.Add<tb3>;DataGridViewTextBoxCelltb4=newDataGridViewTextBoxCell<>;tb4.Value=drv["ISBN"].ToString<>;row.Cells.Add<tb4>;DataGridViewTextBoxCelltb5=newDataGridViewTextBoxCell<>;tb5.Value=drv["className"].ToString<>;row.Cells.Add<tb5>;DataGridViewTextBoxCelltb6=newDataGridViewTextBoxCell<>;tb6.Value=DateTime.Now.ToLongDateString<>;row.Cells.Add<tb6>;DataGridViewTextBoxCelltb7=newDataGridViewTextBoxCell<>;tb7.Value=DateTime.Now.AddDays<Convert.ToInt32<tbrentTime.Text.Trim<>>>;row.Cells.Add<tb7>;DataGridViewTextBoxCelltb_8=newDataGridViewTextBoxCell<>;tb_8.Value=drv["price"].ToString<>;row.Cells.Add<tb_8>;dgvBooksINfor.Rows.Add<row>;drv["count"]=Convert.ToInt32<drv["count"]>-1;//count--;}图书归还：图书借阅情况查询：privatevoidbtnfindid_Click<objectsender,EventArgse>{tbid.Clear<>;tbname.Clear<>;tbreadtype.Clear<>;tbtype.Clear<>;dgvBooksINfor.Rows.Clear<>;StringBuilderbuilder=newStringBuilder<>;builder.Append<"select*fromReaderswhereidlike'"+tbreadid.Text.ToString<>.Trim<>+"'oridlike'%"+tbreadid.Text.ToString<>.Trim<>+"%'">;dgvBooksINfor.AutoGenerateColumns=false;SqlConnectionsc=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;SqlDataAdaptersda=newSqlDataAdapter<builder.ToString<>,sc>;dsRead=newDataSet<>;sda.Fill<dsRead>;bsread=newBindingSource<dsRead,"Table">;tbid.DataBindings.Add<"Text",bsread,"id">;tbname.DataBindings.Add<"Text",bsread,"name">;tbreadtype.DataBindings.Add<"Text",bsread,"readTYpe">;tbtype.DataBindings.Add<"Text",bsread,"type">;//tbreadid.Clear<>;//ReturnBooks<>;StringBuilderbuilder1=newStringBuilder<>;builder1.Append<"select*fromBorrowBookswherereadIdlike'"+tbreadid.Text.ToString<>.Trim<>+"'orderbyborrowTimeasc">;//orderbyborrowTimeascdgvBooksINfor.AutoGenerateColumns=false;SqlConnectionsc2=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;SqlDataAdaptersda1=newSqlDataAdapter<builder1.ToString<>,sc2>;dsbook=newDataSet<>;sda1.Fill<dsbook>;图书借阅归还：privatevoidbtreturnbooks_Click<objectsender,EventArgse>{if<tbtype.Text=="挂骸||tbtype.Text=="冻结á">{MessageBox.Show<"读者已经-"+tbtype.Text+",不能进行归还","系统提示?">;return;}foreach<DataGridViewRowrowindgvBooksINfor.Rows>{//DataGridViewCheckBoxCellcb=<DataGridViewCheckBoxCell>row.Cells[0];if<row.Cells[0]!=null&&Convert.ToBoolean<row.Cells[0].Value>==true>{//数簓据Y库a中D的?已?连?接ó问ê题琣的?编括写′SqlConnectionscinsert=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;scinsert.Open<>;SqlCommandscmdinsert=newSqlCommand<"updateBookstoresetcount=count+1wherebookid='"+row.Cells[1].Value.ToString<>+"'",scinsert>;scmdinsert.ExecuteNonQuery<>;scinsert.Close<>;}MessageBox.Show<"归还成é功！","系统提示">;}}书籍管理：修改书籍、添加书籍、删除书籍、查询书籍、书籍类型的树状图privatevoidbt_DB_addbook_Click<objectsender,EventArgse>//增?加ó图?书酣{frmAddBooksfrm=newfrmAddBooks<dsRead,dr,sdaRead,tableBookType>;frm.Show<>;}privatevoidbt_DB_deletebook_Click<objectsender,EventArgse>//删?除y图?书酣{if<dgvReadManage.SelectedRows.Count==0>{//return;MessageBox.Show<"请?您ú选?择?要癮删?除y的?行D再ù进?行D操ù作痢！?","系μ统?提示?">;}for<inti=0;i<this.dgvReadManage.SelectedRows.Count;i++>{this.dgvReadManage.Rows.Remove<this.dgvReadManage.SelectedRows[i]>;}sdaRead.Update<dsRead>;dsRead.AcceptChanges<>;MessageBox.Show<"保馈存?成é功|！?","系μ统?提示?">;}privatevoidbt_DB_updatebook_Click<objectsender,EventArgse>//修T改?图?书酣{if<dgvReadManage.SelectedRows.Count==0>{MessageBox.Show<"请?选?中D要癮修T改?的?行D后ó在ú进?行D修T改?！?">;return;}DataGridViewRowdgvrow=dgvReadManage.SelectedRows[0];stringid1=dgvrow.Cells[1].Value.ToString<>.Trim<>;DataRow[]dr=dsRead.Tables[0].Select<"bookid='"+id1+"'">;frmUpdateBooksfrm=newfrmUpdateBooks<dsRead,tableBookType,dr[0]>;frm.Show<>;bs=newBindingSource<dsRead,"Table">;}privatevoidbt_DB_findbook_Click<objectsender,EventArgse>//查é询ˉ图?书酣{frmfindBooksfr=newfrmfindBooks<dsRead>;fr.Show<>;}privatevoidbt_DB_exit_Click<objectsender,EventArgse>{frmMainfrm=newfrmMain<user>;frm.Show<>;this.Close<>;}privatevoidfrmBookManage_Load<objectsender,EventArgse>{//dgvReadManage的填充SqlConnectionsc=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;sdaRead=newSqlDataAdapter<"select*fromBookstore",sc>;SqlCommandBuilderscb=newSqlCommandBuilder<sdaRead>;dsRead=newDataSet<>;sdaRead.Fill<dsRead>;dgvReadManage.AutoGenerateColumns=false;dgvReadManage.DataSource=dsRead.Tables[0];//获取书酣籍列表括SqlDataAdaptersdrBookType=newSqlDataAdapter<"select*fromBooksType",sc>;tableBookType=newDataTable<>;sdrBookType.Fill<tableBookType>;dgvReadManage.AutoGenerateColumns=false;dgvReadManage.DataSource=dsRead.Tables[0].DefaultView;if<!TV_Bookstype.Nodes.ContainsKey<"所ù有瓺书酣籍?">>{TreeNoderoot=newTreeNode<"所ù有瓺书酣籍?">;root.Name="所ù有瓺书酣籍?";root.Tag="-1";TV_Bookstype.Nodes.Add<root>;foreach<DataRowrowintableBookType.Rows>{TreeNodetn=newTreeNode<row["name"].ToString<>.Trim<>>;tn.Name=row["name"].ToString<>.Trim<>;tn.Tag=row["id"].ToString<>;if<!root.Nodes.ContainsKey<tn.Name>>{root.Nodes.Add<tn>;}}TV_Bookstype.ExpandAll<>;TV_Bookstype.HideSelection=false;TV_Bookstype.SelectedNode=TV_Bookstype.Nodes[0];}}privatevoiddgvReadManage_DataBindingComplete<objectsender,DataGridViewBindingCompleteEventArgse>{if<this.dgvReadManage.Rows.Count!=0>{for<inti=0;i<this.dgvReadManage.Rows.Count;>{this.dgvReadManage.Rows[i].DefaultCellStyle.BackColor=System.Drawing.Color.FromArgb<111,222,233>;i+=2;}}?}书籍类型的树状图〔鼠标双击privatevoidTV_Bookstype_NodeMouseDoubleClick<objectsender,TreeNodeMouseClickEventArgse>{TreeNodeclickedNode=e.Node;SqlConnectionsc=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;sdaRead=newSqlDataAdapter<"selectnamefromBookstorewhereclassNumber='"+clickedNode.Tag.ToString<>+"'",sc>;DataSetds=newDataSet<>;sdaRead.Fill<ds>;foreach<DataRowrowinds.Tables[0].Rows>{TreeNodetn=newTreeNode<row["name"].ToString<>.Trim<>>;tn.Name=row["name"].ToString<>.Trim<>;tn.Tag="0";if<!clickedNode.Nodes.ContainsKey<tn.Name>>{clickedNode.Nodes.Add<tn>;}}}privatevoidTV_Bookstype_AfterSelect<objectsender,TreeViewEventArgse>{if<e.Node.Tag.ToString<>=="-1">{dsRead.Tables[0].DefaultView.RowFilter="";}else{dsRead.Tables[0].DefaultView.RowFilter="classNumber='".ToString<>+"'";}}privatevoidbtundistype_Click<objectsender,EventArgse>{TV_Bookstype.Hide<>;}privatevoidbtdispalytype_Click<objectsender,EventArgse>{TV_Bookstype.Show<>;}privatevoiddgvReadManage_DoubleClick<objectsender,EventArgse>{}添加书籍publicpartialclassfrmAddBooks:Form{publicfrmBookManagefrm1=null;privateSqlDataAdaptersda;privateDataSetdsRead;privateDataRowdr;privateDataTabletableBookType;publicfrmAddBooks<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<>;}privatevoidbtnagain_Click<objectsender,EventArgse>{if<tbbookid.Text==""&&tbname.Text=="">{MessageBox.Show<"请?您ú填?写′完整?信?息￠","系μ统?提示?">;}DataRowdrRead=dsRead.Tables[0].NewRow<>;//if<opfpicture.FileName!="">//{//StreamstreamPhoto=opfpicture.OpenFile<>;//byte[]bytePhoto=newbyte[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>;SqlConnectionsc=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;sc.Open<>;SqlCommandscmd=newSqlCommand<"select*fromBookstorewhereid='"+tbbookid.Text.Trim<>+"'",sc>;SqlDataReadersdr=scmd.ExecuteReader<CommandBehavior.CloseConnection>;booluserExist=sdr.HasRows;sdr.Close<>;sc.Close<>;if<userExist>{MessageBox.Show<"此?书酣号?名?已?存?在ú！?请?您ú重?新?输?入?！?","系μ统?提示?">;return;}MessageBox.Show<"添加ó成é功|","系μ统?提示?">;sda.Update<dsRead>;dsRead.AcceptChanges<>;MessageBox.Show<"保馈存?成é功|！?">;}privatevoidfrmAddBooks_Load<objectsender,EventArgse>{cbclassNum.DataSource=tableBookType;cbclassNum.DisplayMember="name";cbclassNum.ValueMember="id";}privatevoidbtADD_Click<objectsender,EventArgse>{//frmpublishfrm=newfrmpublish<>;//frm.Show<>;}privatevoidbtnquit_Click<objectsender,EventArgse>{this.Close<>;}privatevoidbtnsave_Click<objectsender,EventArgse>{sda.Update<dsRead>;dsRead.AcceptChanges<>;MessageBox.Show<"保馈存?成é功|！?">;this.Close<>;}}修改书籍publicpartialclassfrmUpdateBooks:Form{privateDataTabletableBookType;privateDataSetdsRead;privateDataRowdr;//privateBindingSourcebs;publicfrmUpdateBooks<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<>;}privatevoidbtnagain_Click<objectsender,EventArgse>{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,MessageBoxIcon.Information>;}privatevoidbtnquit_Click<objectsender,EventArgse>{this.Close<>;}}查询书籍publicpartialclassfrmfindBooks:Form{privateDataSetdsRead;privateBindingSourcebs;publicfrmfindBooks<DataSet_dsRead>{InitializeComponent<>;dsRead=_dsRead;}privatevoidbtnAdd_Click<objectsender,EventArgse>{if<lvBookS.SelectedItems.Count==0>{return;}DataGridViewRowdgvrow=newDataGridViewRow<>;if<dgvTiaoJian.Rows.Count!=0>{DataGridViewComboBoxCellcb1=newDataGridViewComboBoxCell<>;cb1.Items.Add<"并￠且ò">;cb1.Items.Add<"或ò者?">;dgvrow.Cells.Add<cb1>;}else{DataGridViewTextBoxCelltb1=newDataGridViewTextBoxCell<>;tb1.Value="无T";dgvrow.Cells.Add<tb1>;}DataGridViewTextBoxCelltb2=newDataGridViewTextBoxCell<>;ListViewItemlvI=lvBookS.SelectedItems[0];tb2.Value=lvI.Text;tb2.Tag=lvI.Tag;dgvrow.Cells.Add<tb2>;lvBookS.Items.Remove<lvI>;dgvTiaoJian.Rows.Add<dgvrow>;}privatevoidbtndel_Click<objectsender,EventArgse>{if<dgvTiaoJian.Rows.Count!=0>{DataGridViewRowrow=dgvTiaoJian.CurrentRow;dgvTiaoJian.Rows.Remove<row>;ListViewItemlvI=newListViewItem<row.Cells[1].Value.ToString<>>;lvI.Tag=row.Cells[1].Tag;lvBookS.Items.Add<lvI>;}elsereturn;}privatevoidbtnfind_Click<objectsender,EventArgse>{StringBuilderbuilder=newStringBuilder<>;builder.Append<"select*fromBookstorewhere">;foreach<DataGridViewRowdgvrowindgvTiaoJian.Rows>{if<dgvrow.Cells[0].Value.ToString<>!="无T">{if<dgvrow.Cells[0].Value.ToString<>=="或ò者?">{builder.Append<"or">;}elsebuilder.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<>+"%'">;}elseif<dgvrow.Cells[2].Value.ToString<>=="一?定¨">{builder.Append<"='"+dgvrow.Cells[3].Value.ToString<>+"'">;}}catch<Exceptionex>{MessageBox.Show<ex+"请?您ú选?择?条?件t","系μ统?提示?">;}}dgvReadManage.AutoGenerateColumns=false;SqlConnectionsc=newSqlConnection<"datasource=<local>;initialcatalog=BMS;integratedsecurity=true">;SqlDataAdaptersda=newSqlDataAdapter<builder.ToString<>,sc>;DataSetds=newDataSet<>;sda.Fill<ds>;bs=newBindingSource<ds,"Table">;dgvReadManage.DataSource=bs;}privatevoidbtnquit_Click<objectsender,EventArgse>{this.Close<>;}用户管理：用户查询：publicpartialclassfrmAddReader:Form{privateDataSetdsread;privateBindingSourcebsreadtype;privateUsersuser;publicfrmAddReader<DataSet_dsread,Users_user,BindingSource_bsreadtype>{InitializeComponent<>;user=_user;dsread=_dsread;bsreadtype=_bsreadtype;}privatevoidAddReader_Load<objectsender,EventArgse>{CBRType.DataSource=bsreadtype;CBRType.DisplayMember="type";}privatevoidbutton2_Click<objectsender,EventArgse>{DataRowdr=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<>;}privatevoidbutton3_Click<objectsender,EventArgse>{//this.Close<>;}}用户查询：publicpartialclassfrmQueryReader:Form{privateDataSetdsread;privateDataSetdsreadtype;privateUsersuser;publicfrmQueryReader<DataSet_ds,Users_user,DataSet_dsreadtype>{InitializeComponent<>;user=_user;dsread=_ds;dsreadtype=_dsreadtype;}privatevoidfrmQueryReader_Load<objectsender,EventArgse>{dataGridView1.DataSource=dsread;dataGridView1.DataMember="Table";dataGridView1.AutoGenerateColumns=false;dataGridView1.DataSource=dsread.Tables[0].DefaultView;}privatevoidtextBox9_KeyUp<objectsender,KeyEventArgse>{dsread.Tables[0].DefaultView.RowFilter="idlike'"+textBox9.Text+"%'oridlike'%"+textBox9.Text+"'oridlike'%"+textBox9.Text+"%'";}privatevoidtextBox2_KeyUp<objectsender,KeyEventArgse>{dsread.Tables[0].DefaultView.RowFilter="namelike'"+textBox2.Text+"%'ornamelike'%"+textBox2.Text+"'ornamelike'%"+textBox2.Text+"%'";}用户修改：publicpartialclassfrmUpdateReader:Form{privateDataSetdsread;privateDataSetdsreadtype;privateDataRowdr;privateUsersuser;privateBindingSourcebsreadtype;publicfrmUpdateReader<DataSet_dsread,DataRow_dr,Users_user,BindingSource_bsreadtype>{InitializeComponent<>;dr=_dr;user=_user;dsread=_dsread;bsreadtype=_bsreadtype;if<dr["sex"].ToString<>=="男D"||dr["sex"].ToString<>=="女?">rbn.Checked=true;elserbnv.Checked=true;tbRID.Text=dr["id"].ToString<>;tbRname.Text=dr["name"].ToString<>;CBRType.Text=dr["ReadId"].ToString<>;tbZT.Text=dr["type"].ToString<>;tbphone.Text=dr["phone"].ToString<>;tbEAddress.Text=dr["Email"].ToString<>;tbPAddress.Text=dr["homeAddress"].ToString<>;tbBZ.Text=dr["remark"].ToString<>;MessageBox.Show<tbRname.Text+"修T改?成é功|！?","",MessageBoxButtons.YesNo,MessageBoxIcon.Information>;}privatevoidfrmUpdateReader_Load<objectsender,EventArgse>{CBRType.DataSource=bsreadtype;CBRType.DisplayMember="type";}privatevoidtbRID_TextChanged<objectsender,EventArgse>{}privatevoidbutton2_Click<objectsender,EventArgse>{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<>;}privatevoidbutton1_Click<objectsender,EventArgse>{this.Close<>;}}用户注销与挂失：publicpartialclassfrmoperation:Form{privateUsersuser;privateBindingSourcebsreader;privateDataSetdsreader;publicfrmoperation<Users_user>{InitializeComponent<>;user=_user;}privatevoidbtfind_Click<objectsender,EventArgse>{//tbreadid.Clear<>;//tbid.Clear<>;//tbname.Clear<>;//tbphone.Clear<>;//tbsex.Clear<>;//tbtype.Clear<>;tbid.DataBindings.Add<"Text",bsreader,"id">;tbname.DataBindings.Add<"Text",bsreader,"name">;tbphone.DataBindings.Add<"Text",bsreader,"phone">;tbsex.DataBindings.Add<"Text",bsreader,"sex">;tbtype.DataBindings.Add<"Text",bsreader,"type">;cbnowtype.DataSource=bsreader;cbnowtype.DisplayMember="type";}privatevoidfrmoperation_Load<objectsender,EventArgse