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