private void gridPalleteDetailView_MouseUp(object sender, MouseEventArgs e) { List <SetPalletListData> o = gridPalleteDetailControl.DataSource as List <SetPalletListData>; if (o.Count > 0) { try { if (e.Button.ToString() == "Right") { SetPalletListData obj = gridPalleteDetailView.GetFocusedRow() as SetPalletListData; bbiDelPartDetail.Caption = $"Delete {obj.FTicket}"; bbiPrintCarton.Caption = $"Print Carton({obj.ShipPlNo})"; popupMenu3.ShowPopup(new Point(MousePosition.X, MousePosition.Y)); } else { popupMenu3.HidePopup(); } } catch (Exception) { } } }
public bool UpdateSetPallet(SetPalletListData obj) { string sql = $"UPDATE TXP_ISSPACKDETAIL d SET d.SHIPPLNO = '' WHERE d.FTICKETNO = '{obj.FTicket}'"; new ConnDB().ExcuteSQL(sql); string upsql = $"SELECT count(*) PLTOTAL FROM TXP_ISSPACKDETAIL l WHERE ISSUINGKEY = '{obj.RefNo}' AND SHIPPLNO = '{obj.ShipPlNo}'"; int x = 0; DataSet dr = new ConnDB().GetFill(upsql); foreach (DataRow r in dr.Tables[0].Rows) { x += int.Parse(r["pltotal"].ToString()); } return(new ConnDB().ExcuteSQL($"UPDATE TXP_ISSPALLET set PLTOTAL ='{x}' WHERE ISSUINGKEY = '{obj.RefNo}' AND PALLETNO = '{obj.ShipPlNo}'")); }
private void bbiDelPartDetail_ItemClick(object sender, ItemClickEventArgs e) { SetPalletListData obj = gridPalleteDetailView.GetFocusedRow() as SetPalletListData; DialogResult r = XtraMessageBox.Show($"ยืนยันคำสั่งลบ {obj.FTicket} ข้อมูล", "", MessageBoxButtons.YesNo, MessageBoxIcon.Error); if (r == DialogResult.Yes) { if (new SetPlControllers().UpdateSetPallet(obj)) { gridPalleteDetailView.DeleteSelectedRows(); gridPalleteDetailView.UpdateCurrentRow(); gridPalleteDetailView.UpdateTotalSummary(); npl = new SetPalletControllers().GetPartListCompletedDetail(inv); gridPalletControl.BeginUpdate(); gridPalletControl.DataSource = npl; gridPalletControl.EndUpdate(); List <SetPallatData> list = new SetPalletControllers().GetPartListDetail(inv); gridPartControl.DataSource = list; } } }