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