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("操作有误"); } }