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 button1_Click(object sender, EventArgs e)
{
int count = this.dataGridView1.Rows.Count;
IList <Remain> remains = new List <Remain>();
for (int i = 0; i < count - 1; i++)
{
Remain remain = new Remain();
Console.WriteLine(i);
remain.Cangkuname = this.dataGridView1.Rows[i].Cells[0].Value.ToString();
remain.Productname = this.dataGridView1.Rows[i].Cells[1].Value.ToString();
remain.Remainnum = Convert.ToInt32(this.dataGridView1.Rows[i].Cells[2].Value.ToString());
remains.Add(remain);
}
Memange_service myservice = new Memange_service();
int result = myservice.addRemain(remains);
this.Close();
if (result != 0)
{
MessageBox.Show("添加成功！");
}
else
{
MessageBox.Show("添加失败，请检查原因！");
}
}
public IList <Remain> getAllRemainInfos()
{
IList <Remain> list = new List <Remain>();
String sql = "select * from remain_state";
MySqlDataReader reader = helper.GetReader(sql);
while (reader.Read())
{
Remain remain = new Remain();
remain.Remainnum = (int)reader["remain"];
int cangkuid = (int)reader["cangku_id"];
int productid = (int)reader["product_id"];
MySqlDataReader reader1 = helper.GetReader("select storehouse_name from storehouse where storehouse_id = '" + cangkuid + "'");
if (reader1.Read())
{
remain.Cangkuname = reader1["storehouse_name"].ToString();
}
MySqlDataReader reader2 = helper.GetReader("select product_name from product where product_id = '" + productid + "'");
if (reader2.Read())
{
remain.Productname = reader2["product_name"].ToString();
}
list.Add(remain);
}
return(list);
}
public void CalculateTest(double firstValue, double secondValue, double expected)
{
var calculator = new Remain();
var actualResult = calculator.Calculate(firstValue, secondValue);
Assert.AreEqual(expected, actualResult);
}
public int addRemain(Remain remain)
{
int result = 0;
String sql = "insert into remain_state(cangku_id,product_id,remain) values('" + remain.Cangkuname + "','" + remain.Productname + "','" + remain.Remainnum + "')";
result = helper.ExecuteCommand(sql);
return(result);
}
public void WhenX13Y4_ShouldResult3(
[Values(13)] double x,
[Values(4)] double y
)
{
var operation = new Remain(x, y);
Assert.AreEqual(1, operation.Operate());
}
public int updateRemain(Remain remain)
{
String pro_id = remain.Productname;
String sql = "update remain_state set remain='" + remain.Remainnum + "' where product_id='" + pro_id + "'";
int result = helper.ExecuteCommand(sql);
return(result);
}
public void WhenX1Y0_ShouldThrowDivideByZero(
[Values(1)] double x,
[Values(0)] double y
)
{
var operation = new Remain(x, y);
Assert.Throws <DivideByZeroException>(() => { var result = operation.Operate(); });
}
private void CalQty()
{
try
{
if (RadioButtonList1.SelectedValue == "รับสินค้าทั้งหมด")
{
txtNewDelQty.Text = (Convert.ToInt32(lblQty.Text) - Convert.ToInt32(lblRecieveQty.Text)).ToString();
int TotalQtr = Convert.ToInt32(lblQty.Text);
int DelQty = Convert.ToInt32(lblRecieveQty.Text);
int NewDel = Convert.ToInt32(txtNewDelQty.Text);
int Remain;
Remain = (TotalQtr - DelQty) - NewDel;
lblRemainedRecieve.Text = Remain.ToString();
}
else if (RadioButtonList1.SelectedValue == "รับสินค้าบางส่วน")
{
if (Convert.ToInt32(txtNewDelQty.Text) >= ((Convert.ToInt32(lblQty.Text) - Convert.ToInt32(lblRecieveQty.Text))))
{
MessageBox.Show("จำนวนสินค้าควรมีค่าน้อยกว่า " + ((Convert.ToInt32(lblQty.Text) - Convert.ToInt32(lblRecieveQty.Text)) + " ชิ้น"));
}
else
{
int TotalQtr = Convert.ToInt32(lblQty.Text);
int DelQty = Convert.ToInt32(lblRecieveQty.Text);
int NewDel = Convert.ToInt32(txtNewDelQty.Text);
int Remain;
Remain = (TotalQtr - DelQty) - NewDel;
lblRemainedRecieve.Text = Remain.ToString();
}
}
else
{
if (Convert.ToInt32(txtNewDelQty.Text) < ((Convert.ToInt32(lblQty.Text) - Convert.ToInt32(lblRecieveQty.Text))))
{
MessageBox.Show("จำนวนสินค้าควรมีค่ามากกว่า " + ((Convert.ToInt32(lblQty.Text) - Convert.ToInt32(lblRecieveQty.Text)) + " ชิ้น"));
}
else
{
int TotalQtr = Convert.ToInt32(lblQty.Text);
int DelQty = Convert.ToInt32(lblRecieveQty.Text);
int NewDel = Convert.ToInt32(txtNewDelQty.Text);
int Remain;
Remain = (TotalQtr - DelQty) - NewDel;
lblRemainedRecieve.Text = Remain.ToString();
}
}
}
catch
{
MessageBox.Show("กรุณากรอกจำนวนการรับสินค้าให้ถูกต้อง");
}
}
private void dataGridView1_CellValueChanged(
object sender, DataGridViewCellEventArgs e)
{
Console.WriteLine(e.RowIndex + "--------" + e.ColumnIndex);
Remain remain = new Remain();
if (e.RowIndex >= 0)
{
remain.Cangkuname = this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
remain.Productname = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
remain.Remainnum = Convert.ToInt32(this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
WitchToUpdate.Add(remain);
}
}
private void CalQty()
{
try
{
double TotalQtr = Convert.ToDouble(lblQty.Text);
double DelQty = Convert.ToDouble(lblDelQty.Text);
double NewDel = Convert.ToDouble(txtNewDelQty.Text);
double Remain;
Remain = (TotalQtr - DelQty) - NewDel;
lblRemainDel.Text = Remain.ToString();
}
catch
{
MessageBox.Show("กรุณากรอกจำนวนการส่งสินค้าให้ถูกต้อง");
}
}
private void button2_Click(object sender, EventArgs e)
{
Memange_service menageservice = new Memange_service();
IList <Remain> list = menageservice.getAllRemainInfos();
this.dataGridView1.Rows.Clear();
for (int i = 0; i < list.Count; i++)
{
Remain remain = list[i];
String[] row = { remain.Cangkuname, remain.Productname, remain.Remainnum.ToString() };
this.dataGridView1.Rows.Add(row);
}
}
//查询。。。
private void button1_Click(object sender, EventArgs e)
{
String cangku_id = this.cangku_id_text.Text;
String product_id = this.pro_id_text.Text;
IList <Remain> remains = null;
Memange_service service = new Memange_service();
if (product_id.Length != 0 && cangku_id.Length != 0)//11
{
String sql = "select * from remain_state where cangku_id='" + cangku_id + "' and product_id='" + product_id + "'";
remains = service.getRemains(sql);
}
else if (product_id.Length != 0 && cangku_id.Length == 0)//10
{
String sql = "select * from remain_state where product_id='" + product_id + "'";
remains = service.getRemains(sql);
}
else if (product_id.Length == 0 && cangku_id.Length != 0)//01
{
String sql = "select * from remain_state where cangku_id='" + cangku_id + "'";
remains = service.getRemains(sql);
}
else//00
{
MessageBox.Show("请选择查询方式！");
}
if (remains != null)
{
this.dataGridView1.Rows.Clear();
for (int i = 0; i < remains.Count; i++)
{
Remain remain = remains[i];
String[] row = { remain.Cangkuname, remain.Productname, remain.Remainnum.ToString() };
this.dataGridView1.Rows.Add(row);
}
}
}
//修改。。。。
private void update_kucun_Click(object sender, EventArgs e)
{
Memange_service service = new Memange_service();
int count = WitchToUpdate.Count;
IList <String> errorList = new List <String>();
for (int i = 0; i < count; i++)
{
String id = service.getProIdByName(WitchToUpdate[0].Productname);
Remain remain = new Remain();
remain.Productname = id;
remain.Remainnum = WitchToUpdate[0].Remainnum;
remain.Cangkuname = WitchToUpdate[0].Cangkuname;
int result = service.updateRemain(remain);
WitchToUpdate.RemoveAt(0);
if (result == 0)
{
errorList.Add(WitchToUpdate[i].Productname);
}
}
if (errorList.Count != 0)
{
String note = "";
for (int j = 0; j < errorList.Count; j++)
{
note += errorList[j] + "修改失败!\n";
}
MessageBox.Show(note);
}
else
{
MessageBox.Show("修改成功！");
initalData();
}
}
private void button9_Click(object sender, EventArgs e)
{
Product_service pro_ser = new Product_service();
Memange_service me_ser = new Memange_service();
Outku_service out_ser = new Outku_service();
IList <Outku> WhatToInKus = new List <Outku>();
// 出库之前先检查库存是否有这种产品，要是没有，出库失败，要是有，添加出库单，然后修改库存表
for (int i = 0; i < WhatToInKu.Count / 3; i++)
{
Outku outku = new Outku();
// inku.In_id = WhatToInKu[3 * i + 0];
//获取产品ID
String id = pro_ser.getIdByName(WhatToInKu[3 * i + 0]);
if (id.Length == 0)
{
//插入产品及库存
MessageBox.Show("仓库中不存在" + WhatToInKu[3 * i + 0]);
return;
}
else
{
//修改库存表
Remain remain = new Remain();
remain.Cangkuname = WhatToInKu[3 * i + 1];
Console.WriteLine(me_ser.getRemainNum(pro_ser.getIdByName(WhatToInKu[3 * i + 0])));
Console.WriteLine(Convert.ToInt32(WhatToInKu[3 * i + 2]));
remain.Remainnum = me_ser.getRemainNum(pro_ser.getIdByName(WhatToInKu[3 * i + 0])) - Convert.ToInt32(WhatToInKu[3 * i + 2]);
Console.WriteLine(remain.Remainnum);
remain.Productname = pro_ser.getIdByName(WhatToInKu[3 * i + 0]);
me_ser.updateRemain(remain);
}
outku.Pro_id = pro_ser.getIdByName(WhatToInKu[3 * i + 0]);
outku.Out_time = DateTime.Now.Date.ToShortDateString();
outku.Cangku_id = WhatToInKu[3 * i + 1];
outku.Out_num = Convert.ToInt32(WhatToInKu[3 * i + 2]);
WhatToInKus.Add(outku);
}
int result = out_ser.outKu(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);
}
}
//添加入库
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);
}
}
protected void GridView3_SelectedIndexChanged(object sender, EventArgs e)
{
lblJobItemID.Text = GridView2.SelectedRow.Cells[0].Text;
lblRawID.Text = GridView3.SelectedRow.Cells[1].Text;
lblRawName.Text = GridView3.SelectedRow.Cells[2].Text;
lblTotalQty.Text = GridView3.SelectedRow.Cells[5].Text;
lblUnit1.Text = GridView3.SelectedRow.Cells[6].Text;
lblUnit2.Text = GridView3.SelectedRow.Cells[6].Text;
lblUnit3.Text = GridView3.SelectedRow.Cells[6].Text;
lblUnit4.Text = GridView3.SelectedRow.Cells[6].Text;
lblUnit5.Text = GridView3.SelectedRow.Cells[6].Text;
lblUnit6.Text = GridView3.SelectedRow.Cells[6].Text;
txtWithdrawQty.Text = "0.00";
lblDate.Text = DateTime.Now.Date.ToString("dd/MM/yyyy");
string findWithdrawQty = "Select SUM(MatWithdrawQty) AS SumWithdrawMat FROM MaterialWithdrawals WHERE JobItemID = '" + GridView2.SelectedRow.Cells[0].Text + "' AND JobItemMatID = '" + GridView3.SelectedRow.Cells[0].Text + "';";
DataTable dt = dbconn.QueryExecuteScalar(findWithdrawQty);
try
{
if (Convert.ToDouble(GridView3.SelectedRow.Cells[5].Text) > Convert.ToDouble(dt.Rows[0]["SumWithdrawMat"]))
{
txtWithdrawQty.Text = "0.00";
txtWithdrawQty.Enabled = false;
lblWithdrawQty.Text = dt.Rows[0]["SumWithdrawMat"].ToString();
}
else if (Convert.ToDouble(GridView3.SelectedRow.Cells[5].Text) == Convert.ToDouble(dt.Rows[0]["SumWithdrawMat"]))
{
txtWithdrawQty.Enabled = false;
lblWithdrawQty.Text = Convert.ToDouble(dt.Rows[0]["SumWithdrawMat"]).ToString();
}
else
{
txtWithdrawQty.Enabled = true;
lblWithdrawQty.Text = Convert.ToDouble(dt.Rows[0]["SumWithdrawMat"]).ToString();
}
}
catch
{
lblWithdrawQty.Text = "0.00";
}
double RequireQty = Convert.ToDouble(lblTotalQty.Text);
double WithdrawQty = Convert.ToDouble(lblWithdrawQty.Text);
double Remain;
Remain = RequireQty - WithdrawQty;
lblRemainQty.Text = Remain.ToString("#,###.00");
if (Remain >= 0)
{
RadioButtonList1.SelectedValue = "ยังเบิกสินค้ายังไม่ครบ";
}
else
{
RadioButtonList1.SelectedValue = "เบิกสินค้าครบแล้ว";
}
if (RadioButtonList1.SelectedValue == "เบิกสินค้าครบแล้ว")
{
txtWithdrawQty.Text = "0.00";
txtWithdrawQty.Enabled = false;
}
else
{
txtWithdrawQty.Enabled = true;
}
string Stock = "SELECT * FROM RawMaterials WHERE RawID = '" + GridView3.SelectedRow.Cells[0].Text + "';";
DataTable dtStock = dbconn.QueryExecuteScalar(Stock);
try
{
string stockQty = dtStock.Rows[0]["RawQty"].ToString();
lblStock.Text = stockQty;
}
catch
{
lblStock.Text = "0.00";
}
}
