private void search_history_Click(object sender, EventArgs e)
{
sale p = new sale();
List <saleDanju> ps = new List <saleDanju>();
Console.Write(Convert.ToDateTime(dateTimePicker2.Text));
if (textBox2.Text == "")
{
DataTable dt = new DataTable("teble");
dt.Columns.Add("订单日期", typeof(string));
dt.Columns.Add("单据编号", typeof(string));
dt.Columns.Add("客户", typeof(String));
dt.Columns.Add("总金额", typeof(double));
dt.Columns.Add("操作人", typeof(String));
dt.Columns.Add("备注", typeof(String));
Console.Write("11");
ps = p.selectdate(Convert.ToDateTime(dateTimePicker2.Text), Convert.ToDateTime(dateTimePicker3.Text));
Console.Write("12");
foreach (saleDanju p1 in ps)
{
employ e1 = new employ();
employeedao edao = new employeedao();
e1 = edao.selectid(p1.Emploee_id);
customer s1 = new customer();
customerdao sdao = new customerdao();
s1 = sdao.selectnumber(p1.Customer_number);
dt.Rows.Add(p1.Date, p1.Danju, s1.Customer_name, p1.Money, e1.Employee_name, p1.Remark);
Console.WriteLine(p1.Customer_number + "谢谢");
}
dataGridView2.DataSource = dt;
}
else
{
DataTable dt = new DataTable("teble");
dt.Columns.Add("订单日期", typeof(string));
dt.Columns.Add("单据编号", typeof(string));
dt.Columns.Add("顾客", typeof(String));
dt.Columns.Add("总金额", typeof(double));
dt.Columns.Add("操作人", typeof(String));
dt.Columns.Add("备注", typeof(String));
ps = p.selectdateAndNum_Supp(textBox2.Text);
foreach (saleDanju p1 in ps)
{
employ e1 = new employ();
employeedao edao = new employeedao();
e1 = edao.selectid(p1.Emploee_id);
customer s1 = new customer();
customerdao sdao = new customerdao();
s1 = sdao.selectnumber(p1.Customer_number);
dt.Rows.Add(p1.Date, p1.Danju, s1.Customer_name, p1.Money, e1.Employee_name, p1.Remark);
}
dataGridView2.DataSource = dt;
}
}
