图书管理系统源码(C#版)

登录界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebook{publicpartialclasslogin:Form{publicstringpassword;//用来存储密码publiclogin(){InitializeComponent();}privatevoidbutton2_Click(objectsender,EventArgse){Application.Exit();}privateboolyanzhengshuru(){password=textBox3.Text;if(Typename.Text.Trim()==""){MessageBox.Show("请选择登录类型","登录提示",MessageBoxButtons.OK,MessageBoxIcon.Information);Typename.Focus();returnfalse;}elseif(loginid.Text.Trim()==""){MessageBox.Show("请输入用户名","登录提示",MessageBoxButtons.OK,MessageBoxIcon.Information);loginid.Focus();returnfalse;}elseif(password==""){MessageBox.Show("请输入密码","登录提示",MessageBoxButtons.OK,MessageBoxIcon.Information);textBox3.Focus();returnfalse;}else{returntrue;}}privatevoidbutton1_Click(objectsender,EventArgse){userhelper.adminid=loginid.Text;//用户账号password=textBox3.Text;//用户密码if(yanzhengshuru()){if(Typename.Text.Trim()=="管理员"){stringsql=string.Format("Selectcount(*)fromadminwhereadminId='{0}'andadminpass='{1}'",loginid.Text,password);try{SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);Dbhelper.connection.Open();intcount=(int)command.ExecuteScalar();if(count<1){MessageBox.Show("用户或密码不存在！");//result=false;}else{adminadmin=newadmin();admin.Show();}}catch(Exceptionex){MessageBox.Show("操作数据库出错！");Console.WriteLine(ex.Message);}finally{Dbhelper.connection.Close();}}if(Typename.Text.Trim()=="借阅者"){userhelper.readerid=Convert.ToString(loginid.Text);stringsql=string.Format("Selectcount(*)fromreaderwherereaderId='{0}'andreaderpass='{1}'",userhelper.readerid,textBox3.Text);try{//创立Command对象SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);//翻开数据库连接Dbhelper.connection.Open();//验证是否为合法用户intcount=(int)command.ExecuteScalar();if(count<1){MessageBox.Show("用户或密码不存在！");//result=false;}else{readerreader=newreader();reader.Show();}}catch(Exceptionex){MessageBox.Show("操作数据库出错！");Console.WriteLine(ex.Message);//result=false;}finally{//关闭数据库连接Dbhelper.connection.Close();}}}}privatevoidlogin_Load(objectsender,EventArgse){}}}读者界面;usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.Sql;usingSystem.Data.SqlClient;namespacebook{publicpartialclassreader:Form{publicreader(){InitializeComponent();}privatevoidbutton3_Click(objectsender,EventArgse){stringid=Convert.ToString(textBox1.Text);if(id!=userhelper.readerid){MessageBox.Show("输入账号与登陆账号不相同，请重新输入","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);textBox1.Text="";textBox1.Focus();}elsetry{stringsql=string.Format("updatereadersetislost='{0}'wherereaderid='{1}'",'是',id);Dbhelper.connection.Open();SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);intresult=command.ExecuteNonQuery();if(result<1){MessageBox.Show("修改失败");}elseMessageBox.Show("挂失成功");}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}privatevoidtoolStripButton3_Click(objectsender,EventArgse){groupBox1.Visible=false;groupBox2.Visible=true;}privatevoidtoolStripButton4_Click(objectsender,EventArgse){groupBox1.Visible=true;groupBox2.Visible=false;}privatevoidbutton5_Click(objectsender,EventArgse){textBox2.Text="";textBox4.Text="";textBox5.Text="";}privatevoidForm1_Load(objectsender,EventArgse){toolStrip1.Text=string.Format("学生：{0}",userhelper.readerid);}privatevoidbutton4_Click(objectsender,EventArgse){stringid=Convert.ToString(textBox2.Text);if(id!=userhelper.readerid){MessageBox.Show("输入账号与登陆账号不相同，请重新输入","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);textBox1.Text="";textBox1.Focus();}elseif(textBox4.Text!=textBox5.Text){MessageBox.Show("两次密码输入不同");}elsetry{stringsql=string.Format("updatereadersetreaderpass='{0}'wherereaderid='{1}'",textBox4.Text,id);Dbhelper.connection.Open();SqlCommandcommand=newSqlCommand(sql,Dbhelper.connection);intresult=command.ExecuteNonQuery();if(result<1){MessageBox.Show("修改失败");}elseMessageBox.Show("修改成功");}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}privatevoidtoolStripButton6_Click(objectsender,EventArgse){addreaderaddreader=newaddreader();addreader=newaddreader();}privatevoidtoolStripButton1_Click(objectsender,EventArgse){readsearchbooksearchbook=newreadsearchbook();searchbook.Show();}privatevoidtoolStripButton2_Click(objectsender,EventArgse){borrowa=newborrow();a.Show();}privatevoidtoolStripButton5_Click(objectsender,EventArgse){readerseacherinfoa=newreaderseacherinfo();a.Show();}privatevoid图书查询ToolStripMenuItem1_Click(objectsender,EventArgse){readsearchbooka=newreadsearchbook();a.Show();this.Close();}privatevoid结束查询ToolStripMenuItem_Click(objectsender,EventArgse){borrowa=newborrow();a.Show();this.Close();}privatevoid修改密码ToolStripMenuItem_Click(objectsender,EventArgse){groupBox1.Visible=false;groupBox2.Visible=true;}privatevoid挂失ToolStripMenuItem_Click(objectsender,EventArgse){groupBox1.Visible=true;groupBox2.Visible=false;}privatevoid退出ToolStripMenuItem_Click(objectsender,EventArgse){this.Close();}privatevoidbutton2_Click(objectsender,EventArgse){Application.Exit();}}}管理员界面;usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespacebook{publicpartialclassadmin:Form{publicadmin(){InitializeComponent();}privatevoid退出ToolStripMenuItem_Click(objectsender,EventArgse){this.Close();}privatevoidadmin_Load(objectsender,EventArgse){toolStrip1.Text=string.Format("管理员：{}登录",userhelper.adminid);}privatevoidtoolStripButton4_Click(objectsender,EventArgse)//录入学生信息{addreaderaddreader=newaddreader();addreader.Show();this.Close();}privatevoid借书信息ToolStripMenuItem_Click(objectsender,EventArgse){adminborrowa=newadminborrow();a.Show();}privatevoid还书信息ToolStripMenuItem_Click(objectsender,EventArgse){adminborrowa=newadminborrow();a.Show();}privatevoid添加图书ToolStripMenuItem_Click(objectsender,EventArgse){addbooka=newaddbook();a.Show();}privatevoid删除图书ToolStripMenuItem_Click(objectsender,EventArgse){adminearchbooka=newadminearchbook();a.Show();}privatevoid查询图书ToolStripMenuItem_Click(objectsender,EventArgse){adminearchbooka=newadminearchbook();a.Show();}privatevoid查询出版社信息ToolStripMenuItem_Click(objectsender,EventArgse){publishera=newpublisher();a.Show();this.Close();}privatevoid修改出版社信息ToolStripMenuItem_Click(objectsender,EventArgse){publishera=newpublisher();a.Show();this.Close();}privatevoid查询学生借阅信息ToolStripMenuItem_Click(objectsender,EventArgse){adminborrowa=newadminborrow();a.Show();}privatevoidtoolStripButton6_Click_1(objectsender,EventArgse)//借书信息{booksborrowa=newbooksborrow();a.Show();}privatevoid添加ToolStripMenuItem_Click(objectsender,EventArgse){readerinfoa=newreaderinfo();a.Show();}privatevoid删除ToolStripMenuItem_Click(objectsender,EventArgse){deletereadera=newdeletereader();a.Show();}}}添加图书信息界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebook{publicpartialclassaddbook:Form{publicaddbook(){InitializeComponent();}privatevoidaddbook_Load(objectsender,EventArgse){try{stringsql1="selectbooktypenamefrombooktype";SqlCommandcommand=newSqlCommand(sql1,Dbhelper.connection);Dbhelper.connection.Open();SqlDataReaderdatareader=command.ExecuteReader();stringtypename="";while(datareader.Read()){typename=(string)datareader[0];comboBox2.Items.Add(typename);}datareader.Close();stringsql2="selectpublishernamefrompublisher";SqlCommandcommand1=newSqlCommand(sql2,Dbhelper.connection);//Dbhelper.connection.Open();SqlDataReaderdatareader1=command1.ExecuteReader();stringpublishername="";while(datareader1.Read()){publishername=(string)datareader1[0];//MessageBox.Show(publishername);comboBox1.Items.Add(publishername);}datareader1.Close();}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}privatevoidbutton2_Click(objectsender,EventArgse){textBox1.Text=null;textBox2.Text=null;textBox4.Text=null;comboBox2.Text=null;comboBox1.Text=null;}privatestringtypdid(stringa){stringid="";stringsqltypeid=string.Format("selectbooktypeidfrombooktypewherebooktypename='{0}'",a);try{SqlCommandcommand=newSqlCommand(sqltypeid,Dbhelper.connection);Dbhelper.connection.Open();id=Convert.ToString(command.ExecuteScalar());}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}returnid;}privatestringpublisheid(stringa){stringid="";stringsqlpublisheid=string.Format("selectpublisheridfrompublisherwherepublishername='{0}'",a);try{SqlCommandcommand=newSqlCommand(sqlpublisheid,Dbhelper.connection);Dbhelper.connection.Open();id=Convert.ToString(command.ExecuteScalar());}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}returnid;}privatevoidbutton1_Click(objectsender,EventArgse){stringname=textBox1.Text;stringwritter=textBox2.Text;stringpublisher=comboBox1.Text;stringtype=comboBox2.Text;stringprice=textBox4.Text;//stringid=textBox5.Text;stringtypeid=typdid(type);stringpublisherid=publisheid(publisher);stringbianhao=textBox3.Text;try{if(bianhao!=""&&name!=""&&writter!=""&&publisher!=""&&type!=""&&price!=""){Dbhelper.connection.Open();stringsql=string.Format("insertintobook(BOOKID,bookname,bookwritter,publisherid,booktypeid,bookprice)values('{0}','{1}','{2}','{3}','{4}',{5})",bianhao,name,writter,publisherid,typeid,price);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();if(ab!=0){MessageBox.Show("保存成功","保存");}else{MessageBox.Show("添加失败");return;}}elseif(name==""||writter==""||publisher==""||type==""||price==""){MessageBox.Show("请输入所有信息","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);}}catch//(exceptionex){MessageBox.Show("操作数据库出错","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);}finally{Dbhelper.connection.Close();}}privatevoidbutton3_Click(objectsender,EventArgse){this.Close();}}}添加读者信息界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebook{publicpartialclassaddreader:Form{publicaddreader(){InitializeComponent();}//退出窗口privatevoidbutton3_Click(objectsender,EventArgse){//Application.Exit();this.Close();}//去除所有内容privatevoidbutton1_Click(objectsender,EventArgse){textBox1.Text=null;textBox2.Text=null;textBox4.Text=null;textBox3.Text=null;textBox5.Text=null;comboBox1.Text=null;comboBox2.Text=null;}privatevoidbutton2_Click(objectsender,EventArgse){//连接数据库//定义变量stringname=textBox1.Text;stringage=textBox2.Text;stringsex=comboBox1.Text;stringstudentId=textBox3.Text;stringdept=textBox4.Text;stringzhuanye=textBox5.Text;stringmaxnumber=comboBox2.Text;stringpass=textBox6.Text;try{if(name!=""&&age!=""&&sex!=""&&studentId!=""&&dept!=""&&zhuanye!=""&&maxnumber!=""&&pass!=""){Dbhelper.connection.Open();stringsql=string.Format("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,Dbhelper.connection);intab=commmand.ExecuteNonQuery();if(ab!=0){MessageBox.Show("保存成功","保存");}else{MessageBox.Show("添加失败");return;}}elseif(name==""||age==""||sex==""||studentId==""||dept==""||zhuanye==""||maxnumber==""){MessageBox.Show("请输入所有学生信息","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);}}catch//(exceptionex){MessageBox.Show("操作数据库出错","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);//Console.WriteLine(ex);}finally{Dbhelper.connection.Close();}}privatevoidbutton4_Click(objectsender,EventArgse){readerinfoa=newreaderinfo();a.Show();}}}查询图书界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingms;usingSystem.Data.SqlClient;namespacebook{publicpartialclassadminborrow:Form{privateDataSetdataset=newDataSet();privateSqlDataAdapterdataadapter;publicadminborrow(){InitializeComponent();}privatevoidbutton2_Click(objectsender,EventArgse){if(comboBox1.Text=="个人"){try{stringid=textBox1.Text;stringsql=string.Format("selectreaderid,bookid,borrowtime,returntime,outtimefromborrowwherereaderid='{0}'",id);dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,"borrow");dataGridView1.DataSource=dataset.Tables["borrow"];}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}else{try{stringid=textBox1.Text;stringsql=string.Format("selectreaderid,bookid,borrowtime,returntime,outtimefromborrow");dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,"borrow");dataGridView1.DataSource=dataset.Tables["borrow"];}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}}privatevoidbutton1_Click(objectsender,EventArgse){groupBox1.Visible=true;}privatevoidbutton3_Click(objectsender,EventArgse){dataset.Tables["borrow"].Clear();}privatevoidbutton4_Click(objectsender,EventArgse){stringrid=textBox2.Text;stringbid=textBox3.Text;try{if(rid!=""&&bid!=""){Dbhelper.connection.Open();stringsql=string.Format("updateborrowsetreturntime=getdate(),outtime='已还'wherereaderid='{0}'andbookid='{1}'andouttime='否'",rid,bid);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();stringsql1=string.Format("updatebooksetifborrow='否'wherebookid={0}",bid);SqlCommandco=newSqlCommand(sql1,Dbhelper.connection);intc=co.ExecuteNonQuery();if(ab!=0&&c!=0){MessageBox.Show("还书成功","保存");}else{MessageBox.Show("还书失败");return;}}elseif(rid==""||bid==""){MessageBox.Show("请输入所有信息","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);}}catch//(exceptionex){MessageBox.Show("操作数据库出错","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);//Console.WriteLine(ex);}finally{Dbhelper.connection.Close();}}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebook{publicpartialclassadminearchbook:Form{privateDataSetdataset=newDataSet();privateSqlDataAdapterdataadapter;publicadminearchbook(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){try{stringsql;if(comboBox1.Text=="书名"){sql=string.Format("selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publishername,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandbookname='{0}'",textBox1.Text);}elseif(comboBox1.Text=="作者"){sql=string.Format("selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publishername,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandbookwritterlike'%{0}%'",textBox1.Text);}elseif(comboBox1.Text=="出版社"){sql=string.Format("selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publishername,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandbookTypeNamelike'%{0}%'",textBox1.Text);}elseif(comboBox1.Text=="类别"){sql=string.Format("selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publishername,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisheridandpublisherNamelike'%{0}%'",textBox1.Text);}else{sql="selectbookid,bookname,bookwritter,booktype.booktypename,bookprice,booktype.flow,publisher.publishername,ifborrowfrombook,booktype,publisherwherebook.booktypeid=booktype.booktypeidandbook.publisherid=publisher.publisherid";}dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,"book");dataGridView1.DataSource=dataset.Tables["book"];}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}privatevoidcomboBox1_SelectedIndexChanged(objectsender,EventArgse){if(comboBox1.Text=="书名"){label2.Visible=true;label3.Visible=false;label4.Visible=false;label5.Visible=false;}elseif(comboBox1.Text=="作者"){label2.Visible=false;label3.Visible=true;label4.Visible=false;label5.Visible=false;}elseif(comboBox1.Text=="出版社"){label2.Visible=false;label3.Visible=false;label4.Visible=true;label5.Visible=false;}elseif(comboBox1.Text=="类别"){label2.Visible=false;label3.Visible=false;label4.Visible=false;label5.Visible=true;}else{label2.Visible=false;label3.Visible=false;label4.Visible=false;label5.Visible=false;}}privatevoidbutton2_Click(objectsender,EventArgse){dataset.Tables["book"].Clear();//dataadapter.Fill(dataset,"book");}privatevoidbutton3_Click_1(objectsender,EventArgse){if(textBox2.Text!=""){try{Dbhelper.connection.Open();stringsql1=string.Format("deletefromborrowwherebookid='{0}'",textBox2.Text);SqlCommandcon=newSqlCommand(sql1,Dbhelper.connection);intc=con.ExecuteNonQuery();stringsql=string.Format("deletefrombookwherebookid='{0}'",textBox2.Text);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();if(c!=0&&ab!=0){MessageBox.Show("删除成功","保存");}else{MessageBox.Show("删除失败");return;}}catch(Exceptionex){MessageBox.Show(ex.ToString());}finally{Dbhelper.connection.Close();}}else{MessageBox.Show("请输入图书编号！");}}}}借书界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebook{publicpartialclassbooksborrow:Form{publicbooksborrow(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){stringrid=textBox1.Text;stringbid=textBox2.Text;try{if(rid!=""&&bid!=""){Dbhelper.connection.Open();stringsql=string.Format("insertintoborrow(readerid,bookid)values('{0}','{1}')",rid,bid);SqlCommandcommmand=newSqlCommand(sql,Dbhelper.connection);intab=commmand.ExecuteNonQuery();stringsql1=string.Format("updatebooksetifborrow='是'wherebookid={0}",bid);SqlCommandco=newSqlCommand(sql1,Dbhelper.connection);intc=co.ExecuteNonQuery();if(ab!=0&&c!=0){MessageBox.Show("借阅成功","保存");}else{MessageBox.Show("添加失败");return;}}elseif(rid==""||bid==""){MessageBox.Show("请输入所有信息","错误",MessageBoxButtons.OK,MessageBoxIcon.Error);}}catch//(exceptionex){MessageBox.Show("操作数据库出错","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);//Console.WriteLine(ex);}finally{Dbhelper.connection.Close();}}privatevoidbutton2_Click(objectsender,EventArgse){this.Close();}}}usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebook{publicpartialclassborrow:Form{privateDataSetdataset=newDataSet();privateSqlDataAdapterdataadapter;publicborrow(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){try{stringid=textBox1.Text;stringsql=string.Format("selectborrow.readerid,readername,borrow.bookid,bookname,borrowtime,returntime,outtimefromborrow,reader,bookwherebook.bookid=borrow.bookidandborrow.readerid=reader.readeridandreader.readerid='{0}'",id);dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,"borrow");dataGridView1.DataSource=dataset.Tables["borrow"];}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}}}删除借书信息界面：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacebook{publicpartialclassdeletereader:Form{privateDataSetdataset=newDataSet();privateSqlDataAdapterdataadapter;publicdeletereader(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){try{stringid=textBox1.Text;stringsql="select*fromreader";dataadapter=newSqlDataAdapter(sql,Dbhelper.connection);dataadapter.Fill(dataset,"reader");dataGridView1.DataSource=dataset.Tables["reader"];}catch{MessageBox.Show("error");}finally{Dbhelper.connection.Close();}}privatevoidbutton2_Click(objectsender,EventArgse){if(textBox1.Text!=""){try{Dbhelper.connection.Open();stringsql1=string.Format("deletefromborrowwh