private void search_history_Click(object sender, EventArgs e)
{
purchase p = new purchase();
List <purchaseDanju> ps = new List <purchaseDanju>();
try
{
Console.Write(Convert.ToDateTime(dateTimePicker2.Text));
if (textBox2.Text == "请输入单据号" || 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));
ps = p.selectdate(Convert.ToDateTime(dateTimePicker2.Text), Convert.ToDateTime(dateTimePicker3.Text), 1);
foreach (purchaseDanju p1 in ps)
{
employ e1 = new employ();
employeedao edao = new employeedao();
e1 = edao.selectid(p1.Emploee_id);
supplier s1 = new supplier();
supplierdao sdao = new supplierdao();
s1 = sdao.selectnumber(p1.Supplier_number);
dt.Rows.Add(p1.Date, p1.Danju, s1.Supplier_name, p1.Money, e1.Employee_name, p1.Remark);
}
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, 1);
foreach (purchaseDanju p1 in ps)
{
employ e1 = new employ();
employeedao edao = new employeedao();
e1 = edao.selectid(p1.Emploee_id);
supplier s1 = new supplier();
supplierdao sdao = new supplierdao();
s1 = sdao.selectnumber(p1.Supplier_number);
dt.Rows.Add(p1.Date, p1.Danju, s1.Supplier_name, p1.Money, e1.Employee_name, p1.Remark);
}
dataGridView2.DataSource = dt;
}
}
catch (SystemException)
{
MessageBox.Show("操作有误");
}
}
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;
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text == "输入工号" || textBox1.Text == "")
{
DataGridView data = new DataGridView();
employeedao p = new employeedao();
List <employ> rs = new List <employ>();
rs = p.find_all1();
Console.Write(rs);
int i = 0;
DataSet ds = new DataSet();
DataTable dt = new DataTable("Table_New");
dt.Columns.Add("工号", typeof(string));
dt.Columns.Add("姓名", typeof(string));
dt.Columns.Add("联系电话", typeof(String));
foreach (employ r1 in rs)
{
dt.Rows.Add(r1.Employee_number, r1.Employee_name, r1.Phone);
i++;
}
dataGridView1.DataSource = dt;
}
else
{
DataGridView data = new DataGridView();
employeedao p = new employeedao();
employ r1 = p.selectid(textBox1.Text);
Console.Write(textBox1.Text);
if (r1 == null)
{
MessageBox.Show("不存在此人");
}
else
{
DataSet ds = new DataSet();
DataTable dt = new DataTable("Table_New");
dt.Columns.Add("工号", typeof(string));
dt.Columns.Add("姓名", typeof(string));
dt.Columns.Add("联系电话", typeof(String));
dt.Rows.Add(r1.Employee_number, r1.Employee_name, r1.Phone);
dataGridView1.DataSource = dt;
}
}
}
catch (SystemException)
{
MessageBox.Show("操作有误");
}
}
