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