private void client_suoyin_Load(object sender, EventArgs e) { customerdao s = new customerdao(); List <customer> ss = new List <customer>(); ss = s.find_all(); Console.Write(ss); 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.Columns.Add("地址", typeof(string)); int i = 0; foreach (customer s1 in ss) { dt.Rows.Add(s1.Customer_number, s1.Customer_name, s1.Phone, s1.Address); i++; } dataGridView1.DataSource = dt; foreach (DataGridViewColumn co in dataGridView1.Columns) { if (co.Index != 0) { co.ReadOnly = true; } } data = dataGridView1; }
private void button1_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable("teble"); dt.Columns.Add("销售日期", typeof(string)); dt.Columns.Add("单据号", typeof(string)); dt.Columns.Add("客户", typeof(String)); dt.Columns.Add("商品编号", typeof(string)); dt.Columns.Add("商品名称", typeof(string)); dt.Columns.Add("单位", typeof(string)); dt.Columns.Add("单价", typeof(double)); dt.Columns.Add("数量", typeof(double)); dt.Columns.Add("销售金额", typeof(double)); dt.Columns.Add("备注", typeof(String)); sale p = new sale(); List <sale_good> ps = new List <sale_good>(); if (comboBox1.Text == "" && textBox1.Text == "") { ps = p.selectMaterial_date(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text)); } if (comboBox1.Text == "" && textBox1.Text != "") { ps = p.selectMaterial_dateandrname(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text), textBox1.Text); } if (comboBox1.Text != "" && textBox1.Text == "") { string[] suppliername = comboBox1.Text.Split(' '); ps = p.selectMaterial_dateandsnumber(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text), suppliername[0]); } if (comboBox1.Text != "" && textBox1.Text != "") { string[] suppliername = comboBox1.Text.Split(' '); ps = p.selectMaterial_dateandrnameandsupplier(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text), suppliername[0], textBox1.Text); } foreach (sale_good p1 in ps) { Console.Write(p1.Danju_id + "姚雅丽呀"); good r1 = new good(); gooddao rdao = new gooddao(); r1 = rdao.selectNumber(p1.Good_number); customer s1 = new customer(); customerdao sdao = new customerdao(); s1 = sdao.selectnumber(p1.Customernumber); dt.Rows.Add(p1.Dan_date, p1.Danju_id, s1.Customer_name, r1.Good_number, r1.Good_name, p1.Unit, p1.Price, p1.Count, p1.Money, p1.Remark); } dataGridView1.DataSource = dt; double money = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { money += Convert.ToDouble(dataGridView1.Rows[i].Cells[8].Value); } label6.Text = money.ToString(); } catch (SystemException) { MessageBox.Show("操作不当"); } }
private void ShoukuanSchedule_Load(object sender, EventArgs e) { customerdao cdao = new customerdao(); List <customer> cc = new List <customer>(); cc = cdao.find_all(); foreach (customer c in cc) { comboBox1.Items.Add(c.Customer_number + " " + c.Customer_name); } }
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 saleDetail_Load(object sender, EventArgs e) { customerdao sdao = new customerdao(); List <customer> ss = new List <customer>(); ss = sdao.find_all(); foreach (customer s in ss) { comboBox1.Items.Add(s.Customer_number + " " + s.Customer_name); Console.WriteLine("加油"); } label6.Text = "0"; }
private void button1_Click(object sender, EventArgs e) { try { DataTable dt = new DataTable("table"); dt.Columns.Add("收款日期", typeof(string)); dt.Columns.Add("单据号", typeof(string)); dt.Columns.Add("收款金额", typeof(string)); dt.Columns.Add("结算方式", typeof(string)); dt.Columns.Add("备注", typeof(string)); dt.Columns.Add("客户", typeof(string)); ZijinDao p = new ZijinDao(); List <Shoukuan> ps = new List <Shoukuan>(); if (comboBox1.Text == "") { ps = p.selectGet_date(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text)); Console.Write("寇肖萌"); } if (comboBox1.Text != "") { string[] suppliername = comboBox1.Text.Split(' '); ps = p.selectGet_dateandkehuname(Convert.ToDateTime(dateTimePicker1.Text), Convert.ToDateTime(dateTimePicker2.Text), suppliername[0]); } foreach (Shoukuan shou in ps) { customer c1 = new customer(); customerdao cdao = new customerdao(); Console.WriteLine(shou.Get_suppliernumber); c1 = cdao.selectnumber(shou.Get_suppliernumber); Console.WriteLine(shou.Get_money); Console.WriteLine(shou.Get_way); Console.WriteLine(shou.Mark); Console.WriteLine(c1.Customer_name); Console.WriteLine(shou.Date); Console.WriteLine(shou.Get_danjuid); dt.Rows.Add(shou.Date, shou.Get_danjuid, shou.Get_money, shou.Get_way, shou.Mark, c1.Customer_name); } dataGridView1.DataSource = dt; } catch (SystemException) { MessageBox.Show("操作不当"); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "输入编号/名称") { customerdao p = new customerdao(); List <customer> rs = new List <customer>(); 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.Columns.Add("地址", typeof(string)); customer s1 = new customer(); dt.Rows.Add(s1.Customer_number, s1.Customer_name, s1.Phone, s1.Address); dataGridView1.DataSource = dt; } else if (textBox1.Text != "输入编号/名称") { customerdao p = new customerdao(); List <customer> rs = new List <customer>(); rs = p.selectNumberOrName(textBox1.Text); Console.Write(rs); 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.Columns.Add("地址", typeof(string)); int i = 0; foreach (customer s1 in rs) { dt.Rows.Add(s1.Customer_number, s1.Customer_name, s1.Phone, s1.Address); i++; } dataGridView1.DataSource = dt; } data = dataGridView1; }