图书管理系统C++源代码

1、using system;using system.collections.generic;using system.componentmodel;using system.data;using system.drawing;using system.text;using system.windows.forms;namespace windowsapplication1 public partial class form_buyandsale : form public form_buyandsale() initializecomponent(); sql sql; string last

2、sql = ; public void show() listbox1.items.clear(); listbox2.items.clear(); listbox3.items.clear(); if (sql.rows.getlength(0) != 0) for (int i = 0; i + min + and saledate + min + and saledate + min + and saledate + min + and saledate int.parse(max.text) messagebox.show(最小值应小于或等于最大值!, 提示); min.text =

3、; max.text = ; return; sql.executesql(select * from ts_tushuxiaoshou where salequantity between + min.text + and + max.text); show(); lastsql = select * from ts_tushuxiaoshou where salequantity between + min.text + and + max.text; private void button1_click(object sender, eventargs e) this.close();

4、using system;using system.collections.generic;using system.componentmodel;using system.data;using system.drawing;using system.text;using system.windows.forms;namespace windowsapplication1 public partial class form_customer : form public form_customer() initializecomponent(); sql sql; string oldcusto

5、merid = ; public static string customerid = ; public static string customername = ; public void show() if (sql.rows.getlength(0) != 0) customerid.text = sql.rowssql.getpos(), 0.tostring(); customername.text = sql.rowssql.getpos(), 1.tostring(); customerinfo.text = sql.rowssql.getpos(), 2.tostring();

6、 customeraddress.text = sql.rowssql.getpos(), 3.tostring(); customertelephone.text = sql.rowssql.getpos(), 4.tostring(); customersex.text = sql.rowssql.getpos(), 5.tostring(); customeremail.text = sql.rowssql.getpos(), 6.tostring(); else customerid.text = ; customername.text = ; customerinfo.text =

7、; customeraddress.text = ; customertelephone.text = ; customersex.text = ; customeremail.text = ; messagebox.show(无符合查询条件的结果!, 提示); customerid = customerid.text; customername = customername.text; private void form_customer_load(object sender, eventargs e) /将窗体的任务栏隐藏 this.formborderstyle = system.win

8、dows.forms.formborderstyle.none; sql = new sql(form_load .connectionstring ); sql.executesql(select * from ts_kehu order by customerid); show(); private void addorder_click(object sender, eventargs e) if (customerid.text != ) form_customer_addorder child = new form_customer_addorder(); child.showdia

9、log(); else messagebox.show(请先选择一个客户!, 提示); private void butalter_click(object sender, eventargs e) if (butalter.text = 修改) butalter.text = 更新; oldcustomerid = customerid.text; customerid.readonly = false; customername.readonly = false; customerinfo.readonly = false; customeraddress.readonly = false

10、; customertelephone.readonly = false; customersex.readonly = false; customeremail.readonly = false; butadd.enabled = false; butdelete.enabled = false; butfirst.enabled = false; butprev.enabled = false; butnext.enabled = false; butlast.enabled = false; butsearch.enabled = false; butlookoverorders.ena

11、bled = false; butshowall.enabled = false; addorder.enabled = false; else if (sql.executesql(update ts_kehu set customerid= + customerid.text + ,customername= + customername.text + ,customerinfo= + customerinfo.text + ,customeraddress= + customeraddress.text + ,customertelephone= + customertelephone.

12、text + ,customersex= + customersex.text + ,customeremail= + customeremail.text + where customerid= + oldcustomerid + ) = false | sql.executesql(update ts_kehudingdan set customerid= + customerid.text + where customerid= + oldcustomerid + ) = false) show(); else customerid = customerid.text; customer

13、name = customername.text; customerid.readonly = true; customername.readonly = true; customerinfo.readonly = true; customeraddress.readonly = true; customertelephone.readonly = true; customersex.readonly = true; customeremail.readonly = true; butalter.text = 修改; butadd.enabled = true; butdelete.enabl

14、ed = true; butfirst.enabled = true; butprev.enabled = true; butnext.enabled = true; butlast.enabled = true; butsearch.enabled = true; butlookoverorders.enabled = true; addorder.enabled = true; butshowall.enabled = true; private void butadd_click(object sender, eventargs e) try if (butadd.text = 添加)

15、butadd.text = 提交; customerid.text = ; customername.text = ; customerinfo.text = ; customeraddress.text = ; customertelephone.text = ; customersex.text = ; customeremail.text = ; customerid.readonly = false; customername.readonly = false; customerinfo.readonly = false; customeraddress.readonly = fals

16、e; customertelephone.readonly = false; customersex.readonly = false; customeremail.readonly = false; butalter.enabled = false; butdelete.enabled = false; butfirst.enabled = false; butprev.enabled = false; butnext.enabled = false; butlast.enabled = false; butsearch.enabled = false; butlookoverorders.

17、enabled = false; addorder.enabled = false; butshowall.enabled = false; else if (this.customeraddress.text = ) messagebox.show(请输入完整信息！); else if (this.customeremail.text = ) messagebox.show(请输入完整信息！); else if (this.customerid.text = ) messagebox.show(请输入完整信息); else if (this.customerinfo.text = ) mes

18、sagebox.show(请输入完整信息!); else if (this.customername.text = ) messagebox.show(请输入完整信息!); else if (this.customersex.text = ) messagebox.show(请输入完整信息!); else if (sql.executesql(insert into ts_kehu values( + customerid.text + , + customername.text + , + customerinfo.text + , + customeraddress.text + , +

19、customertelephone.text + , + customersex.text + , + customeremail.text + ) = false) show(); else customerid = customerid.text; customername = customername.text; customerid.readonly = true; customername.readonly = true; customerinfo.readonly = true; customeraddress.readonly = true; customertelephone.

20、readonly = true; customersex.readonly = true; customeremail.readonly = true; butadd.text = 添加; butalter.enabled = true; butdelete.enabled = true; butfirst.enabled = true; butprev.enabled = true; butnext.enabled = true; butlast.enabled = true; butsearch.enabled = true; butlookoverorders.enabled = tru

21、e; addorder.enabled = true; butshowall.enabled = true; catch (exception e1) messagebox.show(e1.message); private void butdelete_click(object sender, eventargs e) sql.executesql(delete from ts_kehu where customerid= + customerid.text + ); show(); private void butshowall_click(object sender, eventargs

22、 e) sql.executesql(select * from ts_kehu order by customerid); show(); private void butsearch_click(object sender, eventargs e) if (combobox1.text = 客户名称) if (combobox2.text = 精确) sql.executesql(select * from ts_kehu where customername= + textforsearch.text + order by customerid); show(); else sql.e

23、xecutesql(select * from ts_kehu where customername like % + textforsearch.text + % order by customerid); show(); else if (combobox2.text = 精确) sql.executesql(select * from ts_kehu where customeremail= + textforsearch.text + order by customerid); show(); else sql.executesql(select * from ts_kehu wher

24、e customeremail like % + textforsearch.text + % order by customerid); show(); private void butfirst_click(object sender, eventargs e) sql.pointtofirst(); show(); private void butprev_click(object sender, eventargs e) sql.pointtoprev(); show(); private void butnext_click(object sender, eventargs e) s

25、ql.pointtonext(); show(); private void butlast_click(object sender, eventargs e) sql.pointtolast(); show(); private void butlookoverorders_click(object sender, eventargs e) form_customer_lookoverorders child = new form_customer_lookoverorders(); child.showdialog(); private void button1_click(object

26、sender, eventargs e) this.close(); using system;using system.collections.generic;using system.componentmodel;using system.data;using system.drawing;using system.text;using system.windows.forms;namespace windowsapplication1 public partial class form_customer : form public form_customer() initializeco

27、mponent(); sql sql; string oldcustomerid = ; public static string customerid = ; public static string customername = ; public void show() if (sql.rows.getlength(0) != 0) customerid.text = sql.rowssql.getpos(), 0.tostring(); customername.text = sql.rowssql.getpos(), 1.tostring(); customerinfo.text =

28、sql.rowssql.getpos(), 2.tostring(); customeraddress.text = sql.rowssql.getpos(), 3.tostring(); customertelephone.text = sql.rowssql.getpos(), 4.tostring(); customersex.text = sql.rowssql.getpos(), 5.tostring(); customeremail.text = sql.rowssql.getpos(), 6.tostring(); else customerid.text = ; custome

29、rname.text = ; customerinfo.text = ; customeraddress.text = ; customertelephone.text = ; customersex.text = ; customeremail.text = ; messagebox.show(无符合查询条件的结果!, 提示); customerid = customerid.text; customername = customername.text; private void form_customer_load(object sender, eventargs e) /将窗体的任务栏隐

30、藏 this.formborderstyle = system.windows.forms.formborderstyle.none; sql = new sql(form_load .connectionstring ); sql.executesql(select * from ts_kehu order by customerid); show(); private void addorder_click(object sender, eventargs e) if (customerid.text != ) form_customer_addorder child = new form_customer_addorder(); child.showdialog(); else messagebox.show(请先选择一个客户!, 提示); private void butalter_click(object sender,