图书管理系统C++源代码精选.docVIP

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 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()); } } else { listBox1.Text = ; listBox2.Text = ; listBox3.Text = ; MessageBox.Show(无符合查询条件的结果!, 提示); } } private void Form_BuyAndSale_Load(object sender, EventArgs e) { //将窗体的任务栏隐藏 this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; sql = new SQL(Form_load .connectionString ); sql.ExecuteSQL(select * from ts_tushuxiaoshou); show(); 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.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 + );