圖書管理系統(tǒng)C++源代碼

《圖書管理系統(tǒng)C++源代碼》由會員分享，可在線閱讀，更多相關(guān)《圖書管理系統(tǒng)C++源代碼（50頁珍藏版）》請在裝配圖網(wǎng)上搜索。

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()

2、 { InitializeComponent(); } SQL sql; string lastSQL = ""; public void show() { listBox1.Items.Clear(); listBox2.Items.Clear(); listBox3.Items.Clear(); if (sql.rows.GetLength(0) != 0

3、) { for (int i = 0; i < sql.rows.GetLength(0); i++) { listBox1.Items.Add(sql.rows[i, 0].ToString()); listBox2.Items.Add(sql.rows[i, 1].ToString()); listBox3.Items.Add(sql.rows[i, 2].ToString

4、()); } } else { listBox1.Text = ""; listBox2.Text = ""; listBox3.Text = ""; MessageBox.Show("無符合查詢條件的結(jié)果!", "提示"); } } private void Form_BuyAndS

5、ale_Load(object sender, EventArgs e) { //將窗體的任務(wù)欄隱藏 this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; sql = new SQL(Form_load .connectionString ); sql.ExecuteSQL("select * from ts_tushuxiaoshou"); show();

6、 lastSQL = "select * from ts_tushuxiaoshou "; } private void butThisQuarter_Click(object sender, EventArgs e) { int month = System.DateTime.Now.Month; int space = (3 - month % 3) % 3; string min = System.DateTime.Now.Year.

7、ToString() + STR.add0(Convert.ToString(month + space - 2)) + "00"; string max = System.DateTime.Now.Year.ToString() + STR.add0(Convert.ToString(month + space)) + "99"; sql.ExecuteSQL("select * from ts_tushuxiaoshou where saledate>" + min + " and saledate<" + max + "");

8、 show(); lastSQL = "select * from ts_tushuxiaoshou where saledate>" + min + " and saledate<" + max + ""; } private void butThisYear_Click(object sender, EventArgs e) { string min = System.DateTime.Now.Year.ToString() + "0000";

9、 string max = System.DateTime.Now.Year.ToString() + "9999"; sql.ExecuteSQL("select * from ts_tushuxiaoshou where saledate>" + min + " and saledate<" + max + ""); show(); lastSQL = "select * from ts_tushuxiaoshou where saledate>" + min + " and saledate<" + max

10、 + ""; } private void butAll_Click(object sender, EventArgs e) { sql.ExecuteSQL("select * from ts_tushuxiaoshou"); show(); lastSQL = "select * from ts_tushuxiaoshou "; } private void butSearch_Click(object sender

11、, EventArgs e) { try { int.Parse(Min.Text); int.Parse(Max.Text); } catch { MessageBox.Show("數(shù)值格式不正確!"); Min.Text = ""; Max.Text = "";

12、 return; } if (int.Parse(Min.Text) > int.Parse(Max.Text)) { MessageBox.Show("最小值應(yīng)小于或等于最大值!", "提示"); Min.Text = ""; Max.Text = ""; return; } sql.ExecuteSQL("se

13、lect * 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, EventA

14、rgs 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 pa

15、rtial class Form_Customer : Form { public Form_Customer() { InitializeComponent(); } SQL sql; string oldcustomerID = ""; public static string CUSTOMERID = ""; public static string CUSTOMERNAME = ""; public vo

16、id show() { if (sql.rows.GetLength(0) != 0) { customerID.Text = sql.rows[sql.getPos(), 0].ToString(); customername.Text = sql.rows[sql.getPos(), 1].ToString(); customerinfo.Text = sql.rows[sql.getPos(), 2].ToString

17、(); customeraddress.Text = sql.rows[sql.getPos(), 3].ToString(); customertelephone.Text = sql.rows[sql.getPos(), 4].ToString(); customersex.Text = sql.rows[sql.getPos(), 5].ToString(); customeremail.Text = sql.rows[sql.getPos(), 6].

18、ToString(); } else { customerID.Text = ""; customername.Text = ""; customerinfo.Text = ""; customeraddress.Text = ""; customertelephone.Text = ""; customersex.

19、Text = ""; customeremail.Text = ""; MessageBox.Show("無符合查詢條件的結(jié)果!", "提示"); } CUSTOMERID = customerID.Text; CUSTOMERNAME = customername.Text; } private void Form_Customer_Load(object sender, EventArgs e)

20、 { //將窗體的任務(wù)欄隱藏 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 AddO

21、rder_Click(object sender, EventArgs e) { if (customerID.Text != "") { Form_Customer_AddOrder child = new Form_Customer_AddOrder(); child.ShowDialog(); } else { MessageBox.Show

22、("請先選擇一個客戶!", "提示"); } } private void butAlter_Click(object sender, EventArgs e) { if (butAlter.Text == "修改") { butAlter.Text = "更新"; oldcustomerID = customerID.Text; customerID.Rea

23、dOnly = false; customername.ReadOnly = false; customerinfo.ReadOnly = false; customeraddress.ReadOnly = false; customertelephone.ReadOnly = false; customersex.ReadOnly = false; customeremail.ReadOnl

24、y = false; butAdd.Enabled = false; butDelete.Enabled = false; butFirst.Enabled = false; butPrev.Enabled = false; butNext.Enabled = false; butLast.Enabled = false; butSearch.Enable

25、d = false; butLookOverOrders.Enabled = false; butShowAll.Enabled = false; AddOrder.Enabled = false; } else { if (sql.ExecuteSQL("update ts_kehu set customerID=" + customerID.Text

26、 + ",customername=" + customername.Text + ",customerinfo=" + customerinfo.Text + ",customeraddress=" + customeraddress.Text + ",customertelephone=" + customertelephone.Text + ",customersex=" + customersex.Text

27、 + ",customeremail=" + customeremail.Text + " where customerID=" + oldcustomerID + "") == false || sql.ExecuteSQL("update ts_kehudingdan set customerID=" + customerID.Text + " where customerID=" + oldcustomerID + "")

28、 == false) { show(); } else { CUSTOMERID = customerID.Text; CUSTOMERNAME = customername.Text; } customerID.ReadOnly

29、 = true; customername.ReadOnly = true; customerinfo.ReadOnly = true; customeraddress.ReadOnly = true; customertelephone.ReadOnly = true; customersex.ReadOnly = true; customeremail.ReadOnly = true;

30、 butAlter.Text = "修改"; butAdd.Enabled = true; butDelete.Enabled = true; butFirst.Enabled = true; butPrev.Enabled = true; butNext.Enabled = true; butLast.Enabled = true;

31、 butSearch.Enabled = true; butLookOverOrders.Enabled = true; AddOrder.Enabled = true; butShowAll.Enabled = true; } } private void butAdd_Click(object sender, EventArgs e) { try

32、{ if (butAdd.Text == "添加") { butAdd.Text = "提交"; customerID.Text = ""; customername.Text = ""; customerinfo.Text = ""; customeraddress.Text = "";

33、 customertelephone.Text = ""; customersex.Text = ""; customeremail.Text = ""; customerID.ReadOnly = false; customername.ReadOnly = false; customerinfo.ReadOnly = false;

34、customeraddress.ReadOnly = false; customertelephone.ReadOnly = false; customersex.ReadOnly = false; customeremail.ReadOnly = false; butAlter.Enabled = false; butDelete.Enabled = false;

35、 butFirst.Enabled = false; butPrev.Enabled = false; butNext.Enabled = false; butLast.Enabled = false; butSearch.Enabled = false; butLookOverOrders.Enabled = false;

36、 AddOrder.Enabled = false; butShowAll.Enabled = false; } else { if (this.customeraddress.Text == "") { MessageBox.Show("請輸入完整信息！"); }

37、 else if (this.customeremail.Text == "") { MessageBox.Show("請輸入完整信息！"); } else if (this.customerID.Text == "") { MessageBox.Show("請輸入完整信息");

38、 } else if (this.customerinfo.Text == "") { MessageBox.Show("請輸入完整信息!"); } else if (this.customername.Text == "") { MessageBox.Show("請輸

39、入完整信息!"); } else if (this.customersex.Text == "") { MessageBox.Show("請輸入完整信息!"); } else { if (sql.ExecuteSQL("insert into ts

40、_kehu values(" + customerID.Text + "," + customername.Text + "," + customerinfo.Text + "," + customeraddress.Text + "," + customertelephone.Text + "," + customersex.Text + "," + customeremail.Text + ")")

41、 == false) { show(); } else { CUSTOMERID = customerID.Text; CUSTOMERNAME = customername.Text;

42、 } } customerID.ReadOnly = true; customername.ReadOnly = true; customerinfo.ReadOnly = true; customeraddress.ReadOnly = true; customertelephone.ReadOn

43、ly = true; customersex.ReadOnly = true; customeremail.ReadOnly = true; butAdd.Text = "添加"; butAlter.Enabled = true; butDelete.Enabled = true; butFirst.Enabled = true;

44、 butPrev.Enabled = true; butNext.Enabled = true; butLast.Enabled = true; butSearch.Enabled = true; butLookOverOrders.Enabled = true; AddOrder.Enabled = true; b

45、utShowAll.Enabled = true; } } catch (Exception e1) { MessageBox.Show(e1.Message); } } private void butDelete_Click(object sender, EventArgs e) { sql.ExecuteSQL("delete from

46、 ts_kehu where customerID=" + customerID.Text + ""); show(); } private void butShowAll_Click(object sender, EventArgs e) { sql.ExecuteSQL("select * from ts_kehu order by customerID"); show(); } private void butSe

47、arch_Click(object sender, EventArgs e) { if (comboBox1.Text == "客戶名稱") { if (comboBox2.Text == "精確") { sql.ExecuteSQL("select * from ts_kehu where customername=" + textForSearch.Text + " order by customerID");

48、 show(); } else { sql.ExecuteSQL("select * from ts_kehu where customername like %" + textForSearch.Text + "% order by customerID"); show(); } }

49、else { if (comboBox2.Text == "精確") { sql.ExecuteSQL("select * from ts_kehu where customeremail=" + textForSearch.Text + " order by customerID"); show(); } else

50、{ sql.ExecuteSQL("select * from ts_kehu where customeremail like %" + textForSearch.Text + "% order by customerID"); show(); } } } private void butFirst_Click(object sender, EventArgs e) {

51、 sql.pointToFirst(); show(); } private void butPrev_Click(object sender, EventArgs e) { sql.pointToPrev(); show(); } private void butNext_Click(object sender, EventArgs e) { sql.pointToNex

52、t(); show(); } private void butLast_Click(object sender, EventArgs e) { sql.pointToLast(); show(); } private void butLookOverOrders_Click(object sender, EventArgs e) { Form_Customer_LookOver

53、Orders child = new Form_Customer_LookOverOrders(); child.ShowDialog(); } private void button1_Click(object sender, EventArgs e) { this.Close(); } } } using System; using System.Collections.Gen

54、eric; 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();

55、 } SQL sql; string oldcustomerID = ""; public static string CUSTOMERID = ""; public static string CUSTOMERNAME = ""; public void show() { if (sql.rows.GetLength(0) != 0) { customerID.Text = sql.ro

56、ws[sql.getPos(), 0].ToString(); customername.Text = sql.rows[sql.getPos(), 1].ToString(); customerinfo.Text = sql.rows[sql.getPos(), 2].ToString(); customeraddress.Text = sql.rows[sql.getPos(), 3].ToString(); customertelephone.Text

57、= sql.rows[sql.getPos(), 4].ToString(); customersex.Text = sql.rows[sql.getPos(), 5].ToString(); customeremail.Text = sql.rows[sql.getPos(), 6].ToString(); } else { customerID.Text = ""; custom

58、ername.Text = ""; customerinfo.Text = ""; customeraddress.Text = ""; customertelephone.Text = ""; customersex.Text = ""; customeremail.Text = ""; MessageBox.Show("無符合查詢條件的結(jié)果!", "提示"); }

59、 CUSTOMERID = customerID.Text; CUSTOMERNAME = customername.Text; } private void Form_Customer_Load(object sender, EventArgs e) { //將窗體的任務(wù)欄隱藏 this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; s

60、ql = 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 != "") {

61、Form_Customer_AddOrder child = new Form_Customer_AddOrder(); child.ShowDialog(); } else { MessageBox.Show("請先選擇一個客戶!", "提示"); } } private void butAlter_Click(object sender, EventArgs e)

62、 { if (butAlter.Text == "修改") { butAlter.Text = "更新"; oldcustomerID = customerID.Text; customerID.ReadOnly = false; customername.ReadOnly = false; customerinfo.ReadOnly = false;

63、 customeraddress.ReadOnly = false; customertelephone.ReadOnly = false; customersex.ReadOnly = false; customeremail.ReadOnly = false; butAdd.Enabled = false; butDelete.Enabled = false; butFirs

64、t.Enabled = false; butPrev.Enabled = false; butNext.Enabled = false; butLast.Enabled = false; butSearch.Enabled = false; butLookOverOrders.Enabled = false; butShowAll.Enabled = false;

65、 AddOrder.Enabled = false; } else { if (sql.ExecuteSQL("update ts_kehu set customerID=" + customerID.Text + ",customername=" + customername.Text + ",customerinfo=" + customerinfo.Text

66、 + ",customeraddress=" + customeraddress.Text + ",customertelephone=" + customertelephone.Text + ",customersex=" + customersex.Text + ",customeremail=" + customeremail.Text + " where customerID=" + oldcustomerID + "") == false || sql.ExecuteSQL("update ts_kehudingdan set customerID=" + customerID.Text