private void button2_Click(object sender, EventArgs e) { string d1 = dateTimePicker1.Value.Date.ToShortDateString(); string d2 = dateTimePicker2.Value.Date.ToShortDateString(); ClassSqlConnect sale = new ClassSqlConnect(); string salItems; salItems = ("SALR" + d1 + "," + d2 + " "); DataSet ds = sale.ViewSelect(salItems); this.dataGridView1.DataSource = ds; this.dataGridView1.DataMember = "SALER"; salItems = ("SALE" + d1 + "," + d2 + " "); ds = sale.ViewSelect(salItems); this.dataGridView3.DataSource = ds; this.dataGridView3.DataMember = "PRODUCT"; sale.Close(); }
//库存清算按钮事件 private void button2_Click(object sender, EventArgs e) { ClassSqlConnect check = new ClassSqlConnect(); string cekItems; cekItems = ("STOR"); DataSet ds = check.ViewSelect(cekItems); this.dataGridView3.DataSource = ds; this.dataGridView3.DataMember = "STORE"; check.Close(); }
//产品成本选项卡查询按钮事件 private void button6_Click(object sender, EventArgs e) { string d1 = dateTimePicker3.Value.Date.ToShortDateString(); string d2 = dateTimePicker4.Value.Date.ToShortDateString(); ClassSqlConnect saler = new ClassSqlConnect(); string salItems; salItems = ("COST" + d1 + "," + d2 + " "); DataSet ds = saler.ViewSelect(salItems); this.dataGridView2.DataSource = ds; this.dataGridView2.DataMember = "COST"; saler.Close(); }
//按商品统计按钮事件 private void button6_Click(object sender, EventArgs e) { string d1 = dateTimePicker1.Value.Date.ToShortDateString(); string d2 = dateTimePicker2.Value.Date.ToShortDateString(); ClassSqlConnect product = new ClassSqlConnect(); string proItems; proItems = ("SALE" + d1 + "," + d2 + " "); DataSet ds = product.ViewSelect(proItems); this.dataGridView2.DataSource = ds; this.dataGridView2.DataMember = "PRODUCT"; product.Close(); }