private void gridPalletView_DoubleClick(object sender, EventArgs e) { if (bbiContainer.EditValue.ToString() == "") { XtraMessageBox.Show("กรุณาระบุเลขที่ CONTAINER ด้วย", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error); bbiContainer.Focus(); return; } else if (bbiSealNo.EditValue.ToString() == "") { XtraMessageBox.Show("กรุณาระบุเลขที่ SEALNO ด้วย", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error); bbiSealNo.Focus(); return; } else { string txt = bbiSealNo.EditValue.ToString().ToUpper(); bbiSealNo.EditValue = txt; BookingInvoicePallet pl = gridPalletView.GetFocusedRow() as BookingInvoicePallet; pl.conno = bbiContainer.EditValue.ToString().ToUpper(); pl.sealno = txt; cpl.Add(pl); int x = 1; cpl.ForEach(i => { i.id = x; x++; }); if (UpdatePallet(pl, 6)) { UpdateContainer(pl); } gridSlPlControl.BeginUpdate(); gridSlPlControl.DataSource = cpl; gridSlPlControl.EndUpdate(); List <BookingInvoicePallet> obj = gridPalletControl.DataSource as List <BookingInvoicePallet>; obj.Remove(pl); x = 1; obj.ForEach(i => { i.id = x; x++; }); gridPalletControl.BeginUpdate(); gridPalletControl.DataSource = obj; gridPalletControl.EndUpdate(); ReloadContainer(); } }
private void gridSlPlView_DoubleClick(object sender, EventArgs e) { BookingInvoicePallet p = gridSlPlView.GetFocusedRow() as BookingInvoicePallet; if (p.plstatus > 3) { XtraMessageBox.Show($"ไม่สามารถลบข้อมูลนี้ได้\nเนื่องจากถูก LOAD เรียบร้อยแล้ว", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { DialogResult r = XtraMessageBox.Show($"คุณต้องการที่จะนำ {p.plno} ออกใช่หรือไม่?", "XPW Alert!", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { List <BookingInvoicePallet> pl = gridPalletControl.DataSource as List <BookingInvoicePallet>; pl.Add(p); int x = 1; pl.ForEach(i => { i.id = x; x++; }); gridPalletControl.BeginUpdate(); gridPalletControl.DataSource = pl; gridPalletControl.EndUpdate(); List <BookingInvoicePallet> px = gridSlPlControl.DataSource as List <BookingInvoicePallet>; if (UpdatePallet(p, 0)) { px.Remove(p); x = 1; px.ForEach(i => { i.id = x; x++; }); gridSlPlControl.BeginUpdate(); gridSlPlControl.DataSource = px; gridSlPlControl.EndUpdate(); } } } ReloadContainer(); }
void UpdateContainer(BookingInvoicePallet pl) { try { string sql = $"select * from txp_loadcontainer where containerno = '{bbiContainer.EditValue.ToString().ToUpper()}'"; DateTime d = DateTime.Parse(bbiRelDate.EditValue.ToString()); string txttime = $"{d.ToString("dd/MM/yyyy")} {bbiRelTimer.EditValue.ToString().Substring(10, 9).Trim()}"; DateTime dx = DateTime.Parse(bbiEtd.EditValue.ToString()); string containersize = "20F"; if (bbi4oFt.Checked) { containersize = "40F"; } DataSet dr = new ConnDB().GetFill(sql); string sqlupdate = $"update txp_loadcontainer set etddte=to_date('{dx.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY')," + $"sealno='{bbiSealNo.EditValue.ToString().ToUpper()}',containersize='{containersize}'," + $"receivedte=to_date('{d.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY')," + $"releasedte=to_date('{txttime}', 'DD/MM/YYYY HH24:MI:SS'),upddte=sysdate\n" + $"where containerno='{bbiContainer.EditValue.ToString().ToUpper()}'"; if (dr.Tables[0].Rows.Count <= 0) { sqlupdate = "insert into txp_loadcontainer(containerno,custname,etddte,sealno,containersize,receivedte,releasedte,sysdte,upddte) \n" + "values \n" + $"('{bbiContainer.EditValue.ToString().ToUpper()}', " + $"'{pl.custname.Trim().ToUpper()}', " + $"to_date('{dx.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY'), '{bbiSealNo.EditValue.ToString().ToUpper()}', " + $"'{containersize}', to_date('{d.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY'), " + $"to_date('{txttime}', 'DD/MM/YYYY HH24:MI:SS'), sysdate, sysdate)"; } new ConnDB().ExcuteSQL(sqlupdate); new ConnDB().ExcuteSQL($"UPDATE TXP_LOADPALLET SET CONTAINERNO = '{bbiContainer.EditValue.ToString().ToUpper()}' WHERE PLOUTNO = '{pl.ploutno}'"); } catch (Exception ex) { GreeterFunction.Logs(ex.Message); } }
bool UpdatePallet(BookingInvoicePallet pl, int sl) { string sql = $"SELECT * FROM TXP_LOADINVOICE i WHERE ISSUINGKEY = '{pl.issuekey}' AND CONTAINERNO = '{bbiContainer.EditValue.ToString().ToUpper()}'"; Console.WriteLine(sql); DataSet dr = new ConnDB().GetFill(sql); string sql_isspl = $"UPDATE txp_isspallet l SET l.booked = {sl},l.CONTAINERNO = '{bbiContainer.EditValue.ToString().ToUpper()}',l.custname = '{pl.custname.Trim().ToUpper()}' " + $"WHERE l.issuingkey = '{pl.issuekey}' AND l.palletno = '{pl.plno}'"; if (sl == 6) { if (dr.Tables[0].Rows.Count <= 0) { DateTime dx = DateTime.Parse(bbiEtd.EditValue.ToString()); string fac = "AW"; if (pl.issuekey.Substring(0, 1) == "I") { fac = "INJ"; } string sql_loadinvoice = "insert into txp_loadinvoice(issuingkey,custname,etddte,factory,containerno,sysdte,upddte) \n" + "values \n" + $"('{pl.issuekey}', '{bbiCustomer.EditValue.ToString().Trim().ToUpper()}', " + $"to_date('{dx.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY'), " + $"'{fac}', '{bbiContainer.EditValue.ToString().ToUpper()}', sysdate,sysdate)"; new ConnDB().ExcuteSQL(sql_loadinvoice); } } else { sql_isspl = $"UPDATE txp_isspallet l SET l.booked = {sl},l.CONTAINERNO = '',l.custname = '' " + $"WHERE l.issuingkey = '{pl.issuekey}' AND l.palletno = '{pl.plno}'"; new ConnDB().ExcuteSQL($"UPDATE TXP_LOADPALLET SET CONTAINERNO = '' WHERE PLOUTNO = '{pl.ploutno}'"); } new ConnDB().ExcuteSQL(sql_isspl); return(true); }
public bool AddBooking(BookingInvoicePallet obj) { return(true); }