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;
}
}
}
