private void initalData()
{
Memange_service myservice = new Memange_service();
InKu_service inservice = new InKu_service();
Outku_service outservice = new Outku_service();
IList <Remain> remainlist = myservice.getAllRemainInfos();
IList <InKu> inkulist = inservice.getAllInkus();
IList <Outku> outkulist = outservice.getAllOutkus();
this.dataGridView1.Rows.Clear();
this.inku_datagridview.Rows.Clear();
this.dataGridView2.Rows.Clear();
for (int i = 0; i < remainlist.Count; i++)
{
Remain remain = remainlist[i];
String[] row = { remain.Cangkuname, remain.Productname, remain.Remainnum.ToString() };
this.dataGridView1.Rows.Add(row);
}
for (int j = 0; j < inkulist.Count; j++)
{
InKu inku = inkulist[j];
String[] row1 = { inku.In_id, inku.Pro_id, inku.In_time, inku.Cangku_id, inku.In_num.ToString() };
this.inku_datagridview.Rows.Add(row1);
}
for (int k = 0; k < outkulist.Count; k++)
{
Outku outku = outkulist[k];
String[] row2 = { outku.Out_id, outku.Pro_id, outku.Out_time, outku.Cangku_id, outku.Out_num.ToString() };
this.dataGridView2.Rows.Add(row2);
}
}
//显示所有
private void button5_Click(object sender, EventArgs e)
{
InKu_service in_ser = new InKu_service();
IList <InKu> list = in_ser.getAllInkus();
this.inku_datagridview.Rows.Clear();
int count = list.Count;
for (int i = 0; i < count; i++)
{
InKu inku = list[i];
String[] row = { inku.In_id, inku.Pro_id, inku.In_time, inku.Cangku_id, inku.In_num.ToString() };
this.inku_datagridview.Rows.Add(row);
}
}
//查询
private void search_in_Click(object sender, EventArgs e)
{
InKu_service in_ser = new InKu_service();
String cangkuid = this.textBox3.Text;
IList <InKu> list = in_ser.getInkusByCangkuid(cangkuid);
this.inku_datagridview.Rows.Clear();
int count = list.Count;
for (int i = 0; i < count; i++)
{
InKu inku = list[i];
String[] row = { inku.In_id, inku.Pro_id, inku.In_time, inku.Cangku_id, inku.In_num.ToString() };
this.inku_datagridview.Rows.Add(row);
}
}
public IList <InKu> getInkusByCangkuid(String cangkuid)
{
IList <InKu> list = new List <InKu>();
String sql = "select * from in_table where storehouse_id='" + cangkuid + "'";
MySqlDataReader reader = helper.GetReader(sql);
Product_service pro_ser = new Product_service();
while (reader.Read())
{
InKu inku = new InKu();
inku.In_id = reader["idin_table"].ToString();
inku.Pro_id = reader["in_product"].ToString();
inku.In_time = reader["in_time"].ToString();
inku.In_num = Convert.ToInt32(reader["in_num"].ToString());
inku.Cangku_id = reader["storehouse_id"].ToString();
list.Add(inku);
}
return(list);
}
//添加入库
private void add_in_Click(object sender, EventArgs e)
{
Product_service pro_ser = new Product_service();
Memange_service me_ser = new Memange_service();
InKu_service in_ser = new InKu_service();
IList <InKu> WhatToInKus = new List <InKu>();
//添加之前先检查库存是否有这种产品，要是没有，就添加，同时插入产品表，以及库存表，要是没有，添加，然后修改库存表
for (int i = 0; i < WhatToInKu.Count / 3; i++)
{
InKu inku = new InKu();
// inku.In_id = WhatToInKu[3 * i + 0];
//获取产品ID
String id = pro_ser.getIdByName(WhatToInKu[3 * i + 0]);
if (id.Length == 0)
{
//插入产品及库存
pro_ser.addProduct(WhatToInKu[3 * i + 0]);
Remain remain = new Remain();
remain.Cangkuname = WhatToInKu[3 * i + 1];
remain.Remainnum = Convert.ToInt32(WhatToInKu[3 * i + 2]);
remain.Productname = pro_ser.getIdByName(WhatToInKu[3 * i + 0]);
int k = me_ser.addRemain(remain);//插入库存表
Console.WriteLine(k + "[][][][][][][]");
}
else
{
//修改库存表
Remain remain = new Remain();
remain.Cangkuname = WhatToInKu[3 * i + 1];
remain.Remainnum = Convert.ToInt32(WhatToInKu[3 * i + 2]) + me_ser.getRemainNum(pro_ser.getIdByName(WhatToInKu[3 * i + 0]));
remain.Productname = pro_ser.getIdByName(WhatToInKu[3 * i + 0]);
me_ser.updateRemain(remain);
}
inku.Pro_id = pro_ser.getIdByName(WhatToInKu[3 * i + 0]);
inku.In_time = DateTime.Now.Date.ToShortDateString();
inku.Cangku_id = WhatToInKu[3 * i + 1];
inku.In_num = Convert.ToInt32(WhatToInKu[3 * i + 2]);
WhatToInKus.Add(inku);
}
int result = in_ser.addKu(WhatToInKus);
if (result != 0)
{
MessageBox.Show("添加成功！");
initalData();
}
else
{
MessageBox.Show("添加失败！");
}
int count = WhatToInKu.Count;
for (int i = count - 1; i >= 0; i--)
{
WhatToInKu.RemoveAt(i);
}
}