private void gridPalletView_MouseUp(object sender, MouseEventArgs e) { if (e.Button.ToString() == "Right") { SetPallatData x = gridPalletView.GetFocusedRow() as SetPallatData; bbiDeletePallet.Enabled = true; bbiPrintCarton.Enabled = true; bbiDeletePallet.Caption = $"Delete {x.ShipPlNo}"; if (x.PlOutNo != "") { bbiDeletePallet.Enabled = false; } if (x.ShipPlNo.IndexOf("P") >= 0) { bbiPrintCarton.Enabled = false; } List <SetPallatData> obj = gridPalletControl.DataSource as List <SetPallatData>; bool xinv = false; obj.ForEach(j => { if (j.NewInvoice) { xinv = true; } }); bbiNewInvoice.Enabled = xinv; popupMenu2.ShowPopup(new Point(MousePosition.X, MousePosition.Y)); } else { popupMenu2.HidePopup(); } }
public bool InsertPalletToPackingDetailAll(SetPallatData obj, string plno) { int i = obj.CtnQty + 1; string ysql = $"SELECT FTICKETNO FROM (" + $"SELECT FTICKETNO FROM TXP_ISSPACKDETAIL\n" + $"WHERE SHIPPLNO IS NULL AND ISSUINGKEY = '{obj.RefNo}' AND PONO = '{obj.OrderNo}' AND PARTNO = '{obj.PartNo}' ORDER BY FTICKETNO)" + $"WHERE rownum < {i}"; Console.WriteLine(ysql); DataSet d = new ConnDB().GetFill(ysql); int x = 0; foreach (DataRow j in d.Tables[0].Rows) { string sql = $"UPDATE TXP_ISSPACKDETAIL SET SHIPPLNO = '{plno.ToUpper()}' WHERE FTICKETNO='{j["fticketno"].ToString()}' AND ISSUINGKEY = '{obj.RefNo}'"; new ConnDB().ExcuteSQL(sql); string upsql = $"SELECT count(*) PLTOTAL FROM TXP_ISSPACKDETAIL l WHERE ISSUINGKEY = '{obj.RefNo}' AND SHIPPLNO = '{plno}'"; DataSet dr = new ConnDB().GetFill(upsql); foreach (DataRow r in dr.Tables[0].Rows) { x += int.Parse(r["pltotal"].ToString()); } if (obj.Factory == "AW") { if (plno.IndexOf("C") >= 0) { x = 2; } } } return(new ConnDB().ExcuteSQL($"UPDATE TXP_ISSPALLET set PLTOTAL ='{x}' WHERE ISSUINGKEY = '{obj.RefNo}' AND PALLETNO = '{plno}'")); }
private void bbiResetQty_ItemClick(object sender, ItemClickEventArgs e) { SetPallatData obj = gridPartView.GetFocusedRow() as SetPallatData; gridPartView.SetFocusedRowCellValue("Ctn", (obj.Ctn + obj.CtnQty)); gridPartView.SetFocusedRowCellValue("CtnQty", 0); }
private void bbiSetCarton_ItemClick(object sender, ItemClickEventArgs e) { SetPallatData obj = gridPartView.GetFocusedRow() as SetPallatData; if (obj.Factory == "AW") { DialogResult r = XtraMessageBox.Show($"คุณต้องการที่จะ Set Carton({obj.PName}) นี้ใช่หรือไม่?", "ข้อความแจ้งเตือน", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { List <SetPallatData> list = gridPartControl.DataSource as List <SetPallatData>; string plno = new SetPalletControllers().GetLastCarton(list[0]); int x = 0; while (x < list.Count) { if (list[x].CtnQty > 0) { if (ReloadCartonSet(list[x], plno)) { InsertPalletToPackingDetailAll(list[x], plno); } } x++; } } Reload(); } else { if (obj.CtnQty <= 0) { DialogResult r = XtraMessageBox.Show($"คุณต้องการที่จะ Set Carton({obj.PName}) นี้ใช่หรือไม่?", "ข้อความแจ้งเตือน", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { obj.CtnQty += 1; int x = obj.Ctn -= 1; if (obj.CtnQty > 0) { string plno = new SetPalletControllers().GetLastCarton(obj.RefNo); if (ReloadCartonSet(obj, plno)) { InsertPalletToPackingDetailAll(obj, plno); if (x > 0) { gridPartView.SetFocusedRowCellValue("Ctn", x); gridPartView.SetFocusedRowCellValue("CtnQty", 0); } else { gridPartView.DeleteSelectedRows(); } gridPartView.UpdateCurrentRow(); gridPartView.UpdateTotalSummary(); } } } } } }
private void bbisendToPallet_ItemClick(object sender, ItemClickEventArgs e) { SetPallatData obj = gridPartView.GetFocusedRow() as SetPallatData; SetPalletAddToForm frm = new SetPalletAddToForm(obj); frm.ShowDialog(); Reload(); }
public SetPalletAddToForm(SetPallatData obj) { InitializeComponent(); ob = obj; List <SetPallatData> list = new SetPalletControllers().GetPartListCompletedDetail(ob.RefNo); list.ForEach(i => { cbPalletObj.Properties.Items.Add(i.ShipPlNo); }); }
private void bbiPrintCarton_ItemClick(object sender, ItemClickEventArgs e) { SetPallatData obj = gridPalletView.GetFocusedRow() as SetPallatData; bool x = new InvoiceControllers().PrintWireLabelQR(obj.RefNo, obj.ShipPlNo); if (x) { XtraMessageBox.Show("ปริ้นข้อมูลเสร็จแล้ว", "ข้อความแจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void InsertPalletToPackingDetailAll(SetPallatData obj, string plno) { //int i = obj.CtnQty + 1; //string xsql = $"SELECT * FROM TXP_ISSPACKDETAIL \n" + // $"WHERE SHIPPLNO IS NULL AND ISSUINGKEY = '{obj.RefNo}' AND PONO = '{obj.OrderNo}' AND PARTNO = '{obj.PartNo}' AND ROWNUM < {i}"; //Console.WriteLine(xsql); //string sql = $"UPDATE TXP_ISSPACKDETAIL SET SHIPPLNO = '{plno.ToUpper()}'\n" + // $"WHERE SHIPPLNO IS NULL AND ISSUINGKEY = '{obj.RefNo}' AND PONO = '{obj.OrderNo}' AND PARTNO = '{obj.PartNo}' AND ROWNUM < {i}"; //new ConnDB().ExcuteSQL(sql); new SetPlControllers().InsertPalletToPackingDetailAll(obj, plno); //new SetPalletControllers().CheckPalletSetSeq(obj.RefNo); }
private void gridPalletView_Click(object sender, EventArgs e) { gridPalleteDetailControl.DataSource = null; try { SetPallatData x = gridPalletView.GetFocusedRow() as SetPallatData; gridPalleteDetailControl.DataSource = new SetPalletControllers().GetPallatePartList(x); } catch (Exception) { } }
private void bbiSetPallet_ItemClick(object sender, ItemClickEventArgs e) { List <SetPallatData> list = gridPartControl.DataSource as List <SetPallatData>; List <SetPallatData> ob = new List <SetPallatData>(); List <SetPallatData> n = new List <SetPallatData>(); SetPallatData obj = new SetPallatData(); int x = 0; foreach (var r in list) { if (r.CtnQty > 0) { x += r.CtnQty; obj = r; n.Add(r); if (r.Ctn > 0) { ob.Add(r); } } else { ob.Add(r); } } if (x > 0) { if (obj != null) { string plno = ReloadPlSet(obj, x); foreach (var j in n) { InsertPalletToPackingDetailAll(j, plno); } int ix = 1; ob.ForEach(i => { i.Id = ix; i.CtnQty = 0; ix++; }); gridPartControl.DataSource = ob; } } else { XtraMessageBox.Show("กรุณาระบุจำนวนที่ต้องการด้วย", "ข้อความแจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error); } Reload(); }
public List <SetPalletListData> GetPallatePartList(SetPallatData x) { List <SetPalletListData> obj = new List <SetPalletListData>(); string sql = $"SELECT * FROM TBT_PALLETVIEWER p WHERE p.ISSUINGKEY = '{x.RefNo}' AND p.SHIPPLNO = '{x.ShipPlNo}' ORDER BY p.FTICKETNO"; if (x.PlOutNo != "") { sql = $"SELECT * FROM TBT_PALLETVIEWRPLOUT p WHERE p.ISSUINGKEY = '{x.RefNo}' AND p.ploutno = '{x.PlOutNo}' ORDER BY p.FTICKETNO"; } DataSet dr = new ConnDB().GetFill(sql); foreach (DataRow r in dr.Tables[0].Rows) { obj.Add(new SetPalletListData() { Id = obj.Count + 1, Factory = r["factory"].ToString(), ShipType = r["shiptype"].ToString(), ZName = r["zname"].ToString(), EtdDte = DateTime.Parse(r["etddte"].ToString()), AffCode = r["affcode"].ToString(), CustCode = r["custcode"].ToString(), CustName = r["custname"].ToString(), CombInv = r["combinv"].ToString(), RefInv = r["refinvoice"].ToString(), RefNo = r["issuingkey"].ToString(), OrderNo = r["orderno"].ToString(), PName = r["pname"].ToString(), ShipPlNo = r["shipplno"].ToString(), PlOutNo = r["ploutno"].ToString(), PlSize = r["plsize"].ToString(), PartNo = r["partno"].ToString(), PartName = r["partname"].ToString(), FTicket = r["fticketno"].ToString(), SerialNo = r["ctnsn"].ToString(), LotNo = r["lotno"].ToString(), Qty = int.Parse(r["orderqty"].ToString()), StdPack = int.Parse(r["stdpack"].ToString()), Ctn = int.Parse(r["ctn"].ToString()), PrePareCtn = int.Parse(r["preparectn"].ToString()), ShCtn = int.Parse(r["shctn"].ToString()), WaitCtn = int.Parse(r["waitctn"].ToString()), ITem = int.Parse(r["item"].ToString()), Status = int.Parse(r["ploutsts"].ToString()), }); } return(obj); }
string ReloadPlSet(SetPallatData obj, int p) { if (p > 0) { obj.PlSize = null; string plno = null; if (obj.Factory == "INJ") { plno = new SetPalletControllers().GetLastPallet(obj.RefNo); obj.PlSize = new GreeterFunction().GetPlSize(obj.PlSize, p); } else { plno = new SetPalletControllers().GetLastPallet(obj); obj.PlSize = new GreeterFunction().GetPalletWireSize(p); } string sql = $"SELECT * FROM TXP_ISSPALLET l WHERE l.ISSUINGKEY = '{obj.RefNo}' AND l.PALLETNO = '{plno}'"; string w = "0"; string ll = "0"; string hh = "0"; if (obj.PlSize != "MIX") { w = obj.PlSize.Substring(0, obj.PlSize.IndexOf("x")); string l = obj.PlSize.Substring(w.Length + 1); ll = obj.PlSize.Substring(w.Length + 1, l.IndexOf("x")); string h = obj.PlSize.Substring(ll.Length + 2); hh = h.Substring(h.IndexOf("x") + 1); } DataSet dr = new ConnDB().GetFill(sql); if (dr.Tables[0].Rows.Count < 1) { string ins = $"INSERT INTO TXP_ISSPALLET(FACTORY, ISSUINGKEY, PALLETNO, PLTYPE, PLOUTSTS, UPDDTE, SYSDTE, PLTOTAL, BOOKED,PLWIDE,PLLENG,PLHIGHT)\n" + $"VALUES('{StaticFunctionData.Factory}', '{obj.RefNo}', '{plno}', '{obj.PlSize}', 0, current_timestamp, current_timestamp, {p}, '0', '{w}', '{ll}' ,'{hh}')"; new ConnDB().ExcuteSQL(ins); } npl.Clear(); npl = new SetPalletControllers().GetPartListCompletedDetail(inv); gridPalletControl.BeginUpdate(); gridPalletControl.DataSource = npl; gridPalletControl.EndUpdate(); return(plno); } return(null); }
public string GetLastPallet(SetPallatData obj) { string ssql = $"SELECT count(*) ctn FROM TXP_ISSPALLET l " + $"INNER JOIN TXP_ISSTRANSENT e ON l.ISSUINGKEY = e.ISSUINGKEY " + $"WHERE e.FACTORY = '{obj.Factory}' AND " + $"e.ETDDTE = TO_DATE('{obj.EtdDte.ToString("dd/MM/yyyy")}', 'dd/MM/yyyy') AND " + $"e.CUSTNAME = '{obj.CustName}' AND " + $"PALLETNO LIKE '1P%' \n" + $" ORDER BY PALLETNO DESC"; DataSet dr = new ConnDB().GetFill(ssql); if (dr.Tables[0].Rows.Count > 0) { return($"1P{(int.Parse(dr.Tables[0].Rows[0]["ctn"].ToString()) + 1).ToString("D3")}"); } return($"1P{(1).ToString("D3")}"); }
public bool UpdatePallet(SetPallatData obj) { bool x = false; string ssql = $"SELECT PLOUTSTS status FROM TXP_ISSPALLET WHERE ISSUINGKEY = '{obj.RefNo}' AND PALLETNO = '{obj.ShipPlNo}' AND BOOKED = 0"; DataSet dr = new ConnDB().GetFill(ssql); if (dr.Tables.Count > 0) { if (dr.Tables[0].Rows[0]["status"].ToString() == "0") { string sql = $"DELETE TXP_ISSPALLET l WHERE l.ISSUINGKEY = '{obj.RefNo}' AND l.PALLETNO = '{obj.ShipPlNo}'"; new ConnDB().ExcuteSQL($"UPDATE TXP_ISSPACKDETAIL d SET d.SHIPPLNO = '',d.CTNSN='',d.ploutno='' WHERE d.ISSUINGKEY ='{obj.RefNo}' AND d.SHIPPLNO = '{obj.ShipPlNo}'"); x = new ConnDB().ExcuteSQL(sql); } } return(x); }
public bool UpdatePalletSize(SetPallatData obj) { string w = "0"; string l = "0"; string h = "0"; if (obj.PlSize.ToUpper().IndexOf("X") >= 0) { w = obj.PlSize.ToUpper().Substring(0, obj.PlSize.ToUpper().IndexOf("X")); l = obj.PlSize.ToUpper().Substring(obj.PlSize.ToUpper().IndexOf("X") + 1); l = l.Substring(0, l.IndexOf("X")); h = obj.PlSize.ToUpper().Substring((w.Length + l.Length) + 2); } string sql = $"UPDATE TXP_ISSPALLET l SET l.PLTYPE='{obj.PlSize.ToUpper()}',PLWIDE={w},PLLENG={l},PLHIGHT={h} WHERE l.ISSUINGKEY = '{obj.RefNo}' AND l.PALLETNO = '{obj.ShipPlNo}'"; return(new ConnDB().ExcuteSQL(sql)); }
bool ReloadCartonSet(SetPallatData obj, string plno) { string sql = $"SELECT * FROM TXP_ISSPALLET l WHERE l.ISSUINGKEY = '{obj.RefNo}' AND l.PALLETNO = '{plno}'"; DataSet dr = new ConnDB().GetFill(sql); if (dr.Tables[0].Rows.Count < 1) { string ins = $"INSERT INTO TXP_ISSPALLET(FACTORY, ISSUINGKEY, PALLETNO, PLTYPE, PLOUTSTS, UPDDTE, SYSDTE, PLTOTAL, BOOKED,PLWIDE,PLLENG,PLHIGHT)\n" + $"VALUES('{StaticFunctionData.Factory}', '{obj.RefNo}', '{plno}', 'BOX', 0, current_timestamp, current_timestamp, 1, '0', '0', '0' ,'0')"; new ConnDB().ExcuteSQL(ins); } npl = new SetPalletControllers().GetPartListCompletedDetail(inv); gridPalletControl.BeginUpdate(); gridPalletControl.DataSource = npl; gridPalletControl.EndUpdate(); return(true); }
private void bbiDeletePallet_ItemClick(object sender, ItemClickEventArgs e) { SetPallatData x = gridPalletView.GetFocusedRow() as SetPallatData; DialogResult r = XtraMessageBox.Show($"คุณต้องการที่จะลบพาเลท {x.ShipPlNo} ใช่หรือไม่?", "ข้อความแจ้งเตือน", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { if (new SetPalletControllers().UpdatePallet(x)) { XtraMessageBox.Show("บันทึกข้อมูลเสร็จแล้ว"); } else { XtraMessageBox.Show("เกิดข้อผิดพลาดในการบันทึกข้อมูล", "ข้อความแจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error); } } Reload(); }
private void gridPalletView_DoubleClick(object sender, EventArgs e) { SetPallatData x = gridPalletView.GetFocusedRow() as SetPallatData; var pl = XtraInputBox.Show("แก้ไขข้อมูลประเภทพาเลท", "ข้อความแจ้งเตือน", x.PlSize); if (pl != "") { x.PlSize = pl; if (new SetPalletControllers().UpdatePalletSize(x)) { XtraMessageBox.Show("บันทึกข้อมูลเสร็จแล้ว"); gridPalleteDetailControl.DataSource = new SetPalletControllers().GetPallatePartList(x); } else { XtraMessageBox.Show("เกิดข้อผิดพลาดในการบันทึกข้อมูล", "ข้อความแจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//void InsertPalletToPackingDetail(SetPallatData obj, string plno) //{ // string sql = $"UPDATE TXP_ISSPACKDETAIL SET SHIPPLNO = '{plno}'\n"+ // $"WHERE SHIPPLNO IS NULL AND ISSUINGKEY = '{obj.RefNo}' AND PONO = '{obj.OrderNo}' AND PARTNO = '{obj.PartNo}' AND ROWNUM< 2"; // new ConnDB().ExcuteSQL(sql); //} private void gridPartView_DoubleClick(object sender, EventArgs e) { try { SetPallatData obj = gridPartView.GetFocusedRow() as SetPallatData; int p = 0; if (obj.Ctn > 0) { var x = XtraInputBox.Show("กรุณาระบุจำนวนต่อ 1 พาเลท", "XPW Alert!", $"{obj.Ctn}"); if (x != "") { p = int.Parse(x); if (p > 0) { if (obj.Ctn < p) { XtraMessageBox.Show("กรุณาระบุจำนวนให้ถูกต้องด้วย", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } gridPartView.SetFocusedRowCellValue("Ctn", (obj.Ctn - p)); gridPartView.SetFocusedRowCellValue("CtnQty", (obj.CtnQty + p)); } } } else { XtraMessageBox.Show("ไม่สามารถดำเนินการต่อได้\nเนื่องจากจำนวนเป็น 0", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error); } gridPartView.UpdateCurrentRow(); gridPartView.UpdateSummary(); } catch (Exception) { XtraMessageBox.Show("ไม่สามารถดำเนินการต่อได้\nกรุณาตรวจสอบความข้อมูลด้วย", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }