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

此文档收集于网络，如有侵权，请联系网站删除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 lastSQL = ; 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 = ; 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(); 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 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 = 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 = ; customername.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) /将窗体的任务栏隐藏 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, EventArgs e) if (butAlter.Text = 修改) butAlter.Text = 更新; oldcustomerID = customerID.Text; customerID.ReadOnly = false; customername.ReadOnly = false; customerinfo.ReadOnly = false; customeraddress.ReadOnly = false; 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.Enabled = 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.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; CUSTOMERNAME = 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.Enabled = 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 = 添加) 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 = false; 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.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 = ) MessageBox.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 + , + 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.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 = true; 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 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.ExecuteSQL(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 where 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) sql.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 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() InitializeComponent(); 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 = 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 = ; customername.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) /将窗体的任务栏隐藏 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(obje