//เพิ่มอวนเกิน
private void AddOverNet()
{
//ตรวจสอบรายการตรวจสินค้าซ้ำ
foreach (CheckProduct item in EditCheckList)
{
if (item.PProductId == strPProductId)
{
MessageBox.Show("ไม่สามารถบันทึกรายการซ้ำได้");
return;
}
}
//เพิ่มอวนเกินลงใน dgvDetailCheck
CheckProduct cp2 = new CheckProduct();
cp2.PProductId = strPProductId;
cp2.PProductName = strPProductName;
cp2.QuantityPProduct = (Convert.ToInt16(txtQuantity.Text.ToString().Trim()));
cp2.QuantityCompleteNet = 0;
cp2.QuantityWrongNet = 0;
//cp2.Minus_Plus = 0;
cp2.PalletId = SendPalletId;
cp2.ReceiveTypeId = 1; //อวนเกิน
//cp2.ReceiveTypeName = GetReceiveTypeName(2);
//cp2.IsReceiveNormal = false;//ถ้า false รับอวนเกิน
EditCheckList.Add(cp2);
dgvDetailCheck.DataSource = null;
dgvDetailCheck.DataSource = EditCheckList;
//ใส่ข้อมูลลงใน WrongNetList เมื่อมีการเพิ่มอวนเกิน
foreach (WrongNetType item in WrongTypeList)
{
WrongNetType wn = new WrongNetType();
wn.PProductId = strPProductId;
wn.WrongNetTypeId = item.WrongNetTypeId;
wn.WrongNetTypeName = item.WrongNetTypeName;
wn.QuantityWrongNet = 0;
WrongNetList.Add(wn);
}
txtPProduct.Visible = false;
txtQuantity.Visible = false;
lblPProduc.Visible = false;
lblQuantity.Visible = false;
btnAddNetOk.Visible = false;
}
//แสดงรายการอวนผิด
private void ShowWrongNet()
{
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("Select PProductId, WrongNetTypeId, Quantity ");
sb.Append("from CheckProduct_WrongNet ");
sb.Append("Where CheckingId = \'");
sb.Append(SendCheckingId);
sb.Append("\'");
string sqlWrongNet = sb.ToString();
dtWrongNet = new DataTable();
com = new SqlCommand();
com.Parameters.Clear();
com.CommandText = sqlWrongNet;
com.CommandType = CommandType.Text;
com.Connection = Conn;
dr = com.ExecuteReader();
if (dr.HasRows)
{
dtWrongNet.Load(dr);
EnumerableRowCollection erc = dtWrongNet.AsEnumerable();
foreach (DataRow row in erc)
{
string Id = row["PProductId"].ToString().Trim();
int Quantity = Convert.ToInt16(row["Quantity"].ToString().Trim());
int WrongTypeId = Convert.ToInt16(row["WrongNetTypeId"].ToString().Trim());
int index = WrongNetList.FindIndex(w => w.PProductId == Id && w.WrongNetTypeId == WrongTypeId);
if (index >= 0)
{
WrongNetType wt = new WrongNetType();
wt.PProductId = WrongNetList[index].PProductId;
wt.WrongNetTypeId = WrongNetList[index].WrongNetTypeId;
wt.WrongNetTypeName = WrongNetList[index].WrongNetTypeName;
wt.QuantityWrongNet = Quantity;
WrongNetList[index] = wt;
}
}
}
dr.Close();
var qry = from list in WrongNetList
where list.PProductId == strPProductId
select list;
List<WrongNetType> TempWrongNetList = qry.OrderBy(o => o.WrongNetTypeId).ToList();
dgvWrongNetType.DataSource = null;
dgvWrongNetType.DataSource = TempWrongNetList;
}
//list ทีเก็บรายการลักษณะอวนเสีย
private void GetWrongTypeList()
{
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("SELECT WrongNetTypeId, WrongNetTypeName ");
sb.Append("FROM WrongNetType");
string sqlWrongNet = sb.ToString();
dtWrongNet = new DataTable();
com = new SqlCommand();
com.Parameters.Clear();
com.CommandText = sqlWrongNet;
com.CommandType = CommandType.Text;
com.Connection = Conn;
dr = com.ExecuteReader();
if (dr.HasRows)
{
dtWrongNet.Load(dr);
int CountResult = dtWrongNet.Rows.Count;
EnumerableRowCollection erc = dtWrongNet.AsEnumerable();
foreach (DataRow row in erc)
{
WrongNetType wn = new WrongNetType();
wn.PProductId = strPProductId;
wn.WrongNetTypeId = Convert.ToInt16(row["WrongNetTypeId"].ToString());
wn.WrongNetTypeName = row["WrongNetTypeName"].ToString().Trim();
WrongTypeList.Add(wn);
}
}
dr.Close();
}
private void EditProductCheck_Load(object sender, EventArgs e)
{
string strConn;
strConn = DBConnString.strConn;
Conn = new SqlConnection();
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
Conn.ConnectionString = strConn;
Conn.Open();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("Select CheckProduct_Head.CheckDate, ");
sb.Append("EMPLOYER.EmployerName, ");
sb.Append("CheckProduct_Head.PalletId, ");
sb.Append("CheckProduct_Head.CheckStatusId ");
sb.Append("From ProductionReceive_Head INNER JOIN ");
sb.Append("EMPLOYER ON ProductionReceive_Head.EmployeeId = EMPLOYER.EmployerId INNER JOIN ");
sb.Append("ProductionReceive_Detail ON ProductionReceive_Head.ReceiveHeadId = ProductionReceive_Detail.ReceiveHeadId INNER JOIN ");
sb.Append("CheckProduct_Head ON ProductionReceive_Head.ReceiveHeadId = CheckProduct_Head.ReceiveHeadId ");
sb.Append("Where CheckProduct_Head.CheckingId = \'");
sb.Append(SendCheckingId);
sb.Append("\'");
string sqlName = sb.ToString();
com = new SqlCommand(sqlName, Conn);
da = new SqlDataAdapter(com);
ds = new DataSet();
da.Fill(ds, "EditCheck");
txtEmployee.Text = ds.Tables["EditCheck"].Rows[0]["EmployerName"].ToString();
txtPallet.Text = ds.Tables["EditCheck"].Rows[0]["PalletId"].ToString();
dtpCheckDate.Value = Convert.ToDateTime(ds.Tables["EditCheck"].Rows[0]["CheckDate"].ToString());
lblCheckingId.Text = SendCheckingId.ToString();
if (Convert.ToInt16(ds.Tables["EditCheck"].Rows[0]["CheckStatusId"].ToString()) == 1)
{
rdoNotFinish.Checked = true;
}
else
{
rdofinish.Checked = true;
}
EditCheckDetail();
GetWrongTypeList();
//ใส่ข้อมูลลงใน list รายการอวนผิด
WrongNetList.Clear();
foreach (CheckProduct item in EditCheckList)
{
foreach (WrongNetType itemWrong in WrongTypeList)
{
WrongNetType wn = new WrongNetType();
wn.PProductId = item.PProductId;
wn.WrongNetTypeId = itemWrong.WrongNetTypeId;
wn.WrongNetTypeName = itemWrong.WrongNetTypeName;
wn.QuantityWrongNet = 0;
WrongNetList.Add(wn);
}
}
userId = clsCash.sUserIdLogin; //รหัสพนักงานผู้ใช้ระบบ
}
private void btnWrongOk_Click(object sender, EventArgs e)
{
int SumWrongNet = WrongNetList.Where(s => s.PProductId == strPProductId).Sum(s => s.QuantityWrongNet);
int IndexList = EditCheckList.FindIndex(p => p.PProductId == strPProductId);
//Update จำนวนอวนผิดใน dgvDetailCheck
CheckProduct cp = new CheckProduct();
cp.PProductId = EditCheckList[IndexList].PProductId;
cp.PProductName = EditCheckList[IndexList].PProductName;
cp.QuantityPProduct = EditCheckList[IndexList].QuantityPProduct;
cp.TotalQuantityCompleteNet = EditCheckList[IndexList].TotalQuantityCompleteNet;
cp.TotalQuantityWrongNet = EditCheckList[IndexList].TotalQuantityWrongNet;
cp.QuantityCompleteNet = EditCheckList[IndexList].QuantityCompleteNet;
cp.QuantityWrongNet = SumWrongNet;
//cp.Minus_Plus = EditCheckList[IndexList].Minus_Plus;
//cp.PalletId = EditCheckList[IndexList].PalletId;
//cp.ReceiveTypeId = EditCheckList[IndexList].ReceiveTypeId;
//cp.ReceiveTypeName = EditCheckList[IndexList].ReceiveTypeName;
//cp.ReceiveDetailId = CheckList[IndexList].ReceiveDetailId;
//cp.IsReceiveNormal = CheckList[IndexList].IsReceiveNormal;
EditCheckList[IndexList] = cp;
dgvDetailCheck.DataSource = null;
dgvDetailCheck.DataSource = EditCheckList;
SetDgvCheckDetailHeader();
// update จำนวนอวนผิดใน WrongNetList
foreach (DataGridViewRow row in dgvWrongNetType.Rows)
{
int intWrongNetTypeId = Convert.ToInt16(row.Cells[0].Value.ToString());
int indexWrongNet = WrongNetList.FindIndex(w => w.PProductId == strPProductId && w.WrongNetTypeId == intWrongNetTypeId);
WrongNetType wn = new WrongNetType();
wn.PProductId = WrongNetList[indexWrongNet].PProductId;
wn.WrongNetTypeId = WrongNetList[indexWrongNet].WrongNetTypeId;
wn.WrongNetTypeName = WrongNetList[indexWrongNet].WrongNetTypeName;
wn.QuantityWrongNet = Convert.ToInt16(row.Cells[2].Value.ToString().Trim());
WrongNetList[indexWrongNet] = wn;
}
pnlWrongNetType.Visible = false;
}
private void frmEditRepairProductCheck_Load(object sender, EventArgs e)
{
string strConn;
strConn = DBConnString.strConn;
Conn = new SqlConnection();
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
Conn.ConnectionString = strConn;
Conn.Open();
HeadEditCheckRepair();
EditCheckRepairDetail();
GetWrongTypeList();
//ใส่ข้อมูลลงใน list รายการอวนผิด
WrongNetList.Clear();
foreach (CheckProduct item in EditCheckList)
{
foreach (WrongNetType itemWrong in WrongTypeList)
{
WrongNetType wn = new WrongNetType();
wn.PProductId = item.PProductId;
wn.WrongNetTypeId = itemWrong.WrongNetTypeId;
wn.WrongNetTypeName = itemWrong.WrongNetTypeName;
wn.QuantityWrongNet = 0;
WrongNetList.Add(wn);
}
}
userId = clsCash.sUserIdLogin; //รหัสพนักงานผู้ใช้ระบบ
}
