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