private BindingList <InvoiceMasterData> GetMasterWeek(int b, int en)
{
DateTime d = DateTime.Parse(bbiEtd.EditValue.ToString());
BindingList <InvoiceMasterData> list = new InvoiceControllers().GetInvoiceWeek(d, b, en) as BindingList <InvoiceMasterData>;
return(list);
}
private void bbiPrintAllShipingLabel_ItemClick(object sender, ItemClickEventArgs e)
{
DialogResult r = XtraMessageBox.Show("คุณต้องการที่จะปริ้น Shipping Label ใช่หรือไม่", "ยืนยันคำสั่ง", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (r == DialogResult.Yes)
{
bool checkinv = new InvoiceControllers().CheckInvoiceStatus(ob.RefInv);
if (checkinv)
{
List <InvoiceBodyData> obj = gridControl.DataSource as List <InvoiceBodyData>;
SplashScreenManager.ShowDefaultWaitForm();
int i = 0;
while (i < obj.Count)
{
InvoiceBodyData j = obj[i];
bool plabel = new InvoiceControllers().PrintFTicket(j.RefInv, j.PartNo, j.OrderNo, j.StartFticket, j.StartFticket.ToString());
if (plabel)
{
i++;
}
}
XtraMessageBox.Show("ปริ้นข้อมูลเสร็จแล้ว");
}
else
{
XtraMessageBox.Show("กรุณาทำการยืนยัน Invoice ก่อน", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
void ReloadData()
{
List <PalletData> obj = new InvoiceControllers().GetPalletDetail(invno);
gridControl.DataSource = obj;
bsiRecordsCount.Caption = "RECORDS : " + obj.Count;
}
void ReloadGridControl()
{
this.Invoke(new MethodInvoker(delegate {
List <InvoiceData> obj = new InvoiceControllers().GetInvoiceData(DateTime.Parse(bbiEtd.EditValue.ToString()));
gridControl.DataSource = obj;
bsiRecordsCount.Caption = "RECORDS : " + obj.Count;
}));
}
void ReloadData()
{
SplashScreenManager.ShowDefaultWaitForm();
chorderdate = false;
this.Text = StaticFunctionData.JobListTilte;
groupControl2.Text = StaticFunctionData.JobListInformation;
bbiPlConfirm.Caption = StaticFunctionData.JoblistConfirmInv;
bbiPrintJobList.Caption = StaticFunctionData.JoblistPrintJobList;
bbiShippingList.Caption = StaticFunctionData.JoblistShippingList;
bbiShipingPart.Caption = StaticFunctionData.JoblistShippingListByPart;
bbiShippingAll.Caption = StaticFunctionData.JoblistShippingListByAll;
bbiPalletList.Caption = StaticFunctionData.JoblistPalletList;
bbiSplitPart.Caption = StaticFunctionData.JoblistSplitPart;
bbiSetMultiLot.Caption = StaticFunctionData.JoblistSetMultiLot;
bbiPartShort.Caption = StaticFunctionData.JoblistPartShort;
bbiEditOrder.Caption = StaticFunctionData.JoblistEditOrder;
bbiReviseOrder.Caption = StaticFunctionData.JoblistOrderHold;
bbiCancelOrder.Caption = StaticFunctionData.JoblistOrderCancel;
bbiAddShorting.Caption = StaticFunctionData.JoblistPartShort;
bbiConfirmShort.Caption = StaticFunctionData.JoblistOrderShorting;
bbiFactory.EditValue = ob.Factory;
bbiShip.EditValue = ob.Ship;
bbiZone.EditValue = ob.Zname;
bbiOrderBy.EditValue = ob.Ord;
bbiInv.EditValue = ob.Invoice;
bbiRefInv.EditValue = ob.RefInv;
bbiAff.EditValue = ob.Affcode;
bbiCustCode.EditValue = ob.Bishpc;
bbiCustName.EditValue = ob.Custname;
bbiEtd.EditValue = ob.Etddte;
txtNote1.EditValue = ob.Note1;
txtNote2.EditValue = ob.Note2;
bbiNote3.EditValue = ob.Note3;
txtZoneCode.EditValue = ob.ZCode;
bbiConTypeCaption.EditValue = ob.ContainerType;
bbiEtd.Enabled = StaticFunctionData.enable_etd;
bbiShip.Enabled = StaticFunctionData.enable_ship;
txtNote1.Enabled = StaticFunctionData.enable_note1;
txtNote2.Enabled = StaticFunctionData.enable_note2;
bbiNote3.Enabled = StaticFunctionData.enable_note3;
bbiConTypeCaption.Enabled = StaticFunctionData.enable_container;
bbiNewOrder.Enabled = false;
bbiConfirmShort.Enabled = false;
bbiSplitInvoice.Caption = "";
List <InvoiceBodyData> obj = new InvoiceControllers().GetInvoiceBody(ob);
gridControl.DataSource = obj;
bsiRecordsCount.Caption = "RECORDS : " + obj.Count;
SplashScreenManager.CloseDefaultWaitForm();
if (shlist.Count > 0)
{
bbiConfirmShort.Enabled = true;
}
}
DateTime SaveShorting()
{
DateTime ndte = DateTime.Now;
//bool c = false;
//DialogResult r = XtraMessageBox.Show("คุณต้องการที่จะสร้าง Invoice ใหม่เลยหรืไม่?", "ข้อความแจ้งเตือน", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
//if (r == DialogResult.Yes)
//{
// c = true;
//}
//else
//{
// c = false;
//}
SplashScreenManager.ShowDefaultWaitForm();
try
{
int i = 0;
List <string> ord = new List <string>();
while (i < shlist.Count)
{
var ob = shlist[i];
//update issbody
string refinv = ob.RefInv;
string orderno = ob.OrderNo;
string partno = ob.PartNo;
int shctn = ob.ShCtn;
ord.Add(orderno);
ndte = new InvoiceControllers().GetNextInvoiceDate(refinv);
//update body
int tctn = ob.BalCtn - ob.ShCtn;
while (tctn < ob.BalCtn)
{
tctn++;
string updetail = $"UPDATE TXP_ISSPACKDETAIL d SET d.ISSUINGSTATUS=1,d.UPDDTE=SYSDATE WHERE d.ISSUINGKEY = '{refinv}' AND d.PONO = '{orderno}' AND d.PARTNO = '{partno}' AND d.ITEM = '{tctn}'";
new ConnDB().ExcuteSQL(updetail);
}
//string upbody = $"UPDATE TXP_ISSTRANSBODY b SET b.ORDERQTY={(ob.BalCtn - ob.ShCtn)}*b.STDPACK,b.SHORDERQTY={shctn}*b.STDPACK,b.UPDDTE = sysdate WHERE b.ISSUINGKEY = '{refinv}' AND b.PONO = '{orderno}' AND b.PARTNO = '{partno}'";
string upbody = $"UPDATE TXP_ISSTRANSBODY b SET b.SHORDERQTY={shctn}*b.STDPACK,b.UPDDTE = sysdate WHERE b.ISSUINGKEY = '{refinv}' AND b.PONO = '{orderno}' AND b.PARTNO = '{partno}'";
string uporder = $"UPDATE TXP_ORDERPLAN p SET etdtap=to_date('{ndte.ToString("ddMMyyyy")}', 'ddMMyyyy'),p.CURINV='',p.BALQTY={shctn}*p.BISTDP,p.ORDERSTATUS=3,p.UPDDTE=SYSDATE WHERE p.CURINV = '{refinv}' AND p.ORDERID = '{orderno}' AND p.PARTNO = '{partno}'";
new ConnDB().ExcuteSQL(upbody);
new ConnDB().ExcuteSQL(uporder);
i++;
}
//if (c)
//{
//}
shlist.Clear();
}
catch (Exception)
{
}
SplashScreenManager.CloseDefaultWaitForm();
return(ndte);
}
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 bbiPrintCartonShippingLabel_ItemClick(object sender, ItemClickEventArgs e)
{
var pl = gridView.GetFocusedRowCellValue("PlNo");
bool x = new InvoiceControllers().PrintWireLabelQR(invno, pl.ToString());
if (x)
{
XtraMessageBox.Show("ปริ้นข้อมูลเสร็จแล้ว", "ข้อความแจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
void WritingShort(int type)
{
List <PartShortData> list = new InvoiceControllers().GetShortData(7, type);
//List<SummaryData> obj = new InvoiceControllers().GetDataSource();
if (list.Count <= 0)
{
XtraMessageBox.Show("ไม่พบข้อมูล", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void bbiJobCardOnly_ItemClick(object sender, ItemClickEventArgs e)
{
bool checkinv = new InvoiceControllers().CheckInvoiceStatus(ob.RefInv);
SplashScreenManager.ShowDefaultWaitForm();
if (checkinv)
{
List <FTicketData> f = gridControl.DataSource as List <FTicketData>;
List <FTicketData> list = new List <FTicketData>();
var x = f.OrderByDescending(j => j.PrintFTicket).ToList();
int i = 0;
while (i < x.Count)
{
FTicketData o = x[i];
if (o.Status < StaticFunctionData.StatusFTicket)
{
if (o.PrintFTicket)
{
Console.WriteLine(o);
list.Add(o);
//bool plabel = new InvoiceControllers().PrintFTicket(ob.RefInv, o.PartNo, o.OrderNo, o.Seq, o.Seq.ToString());
//bool plabel = new InvoiceControllers().PrintFTicket(ob.RefInv, o.FTicketNo, o.Id.ToString());
//if (plabel)
//{
// //XtraMessageBox.Show("ปริ้นข้อมูลเสร็จแล้ว");
// //this.Close();
//}
}
}
//else
//{
// XtraMessageBox.Show("Label นี้ปริ้น/จัดเตรียมไปแล้ว", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
i++;
}
bool plabel = new InvoiceControllers().PrintFTicket(ob.RefInv, list);
if (plabel)
{
XtraMessageBox.Show("ปริ้นข้อมูลเสร็จแล้ว");
}
}
else
{
XtraMessageBox.Show("กรุณาทำการยืนยัน Invoice ก่อน", "XPW Alert!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch (Exception)
{
}
}
void ReloadData()
{
SplashScreenManager.ShowDefaultWaitForm();
if (stload)
{
List <InvoiceData> obj = new InvoiceControllers().GetInvoiceData(DateTime.Parse(bbiEtd.EditValue.ToString()));
gridControl.DataSource = obj;
bsiRecordsCount.Caption = "RECORDS : " + obj.Count;
}
AfterFormLoad();
//GetToWeek();
//GetForwardWeek();
stload = false;
SplashScreenManager.CloseDefaultWaitForm();
}
private void gridForwardView_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
SplashScreenManager.ShowDefaultWaitForm();
var etd = gridForwardView.GetFocusedRowCellValue("Etd").ToString();
//bbiEtd.EditValue = DateTime.Parse(etd);
List <InvoiceData> obj = new InvoiceControllers().GetInvoiceData(DateTime.Parse(etd), e.Column.FieldName.ToString().ToUpper());
gridControl.DataSource = obj;
bsiRecordsCount.Caption = "RECORDS : " + obj.Count;
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch (Exception)
{
}
}
catch (Exception)
{
}
}
