private void RollBackDocument(List <RollBackDocument> lstRollBackDoc) { try { string result = string.Empty; using (ShippingOrderBLL shipingOrdBll = new ShippingOrderBLL()) { if (this._TYPE.Equals("L")) { result = shipingOrdBll.RollBackLoading(lstRollBackDoc, this._USER_ID); } else { result = shipingOrdBll.RollBackPicking(lstRollBackDoc, this._USER_ID); } } if (result.Equals("OK")) { DialogResult = DialogResult.OK; } } catch (Exception ex) { } }
//private void UpdatePrintOutgoing(List<PartialTicket> lstTicket) //{ // try // { // string result = string.Empty; // using (PrintPartialTicketBLL printParTickBll = new PrintPartialTicketBLL()) // { // printParTickBll.UpdatePartialTicketPrint(lstTicket, "System"); // } // } // catch (Exception ex) // { // XtraMessageBox.Show(this, ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); // } //} private void GetDetailsOnPalletPrint() { try { List <string> lstPallet; using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { lstPallet = shipOrdBll.GetAutoPrintPallet(UiUtility.WH_ID); } if (lstPallet != null) { if (lstPallet.Count > 0) { string messaage = String.Join(",", lstPallet.ToArray()); this.notifyIcon.ShowBalloon("Print Pallet", string.Format("Pallet : {0}", messaage), NotifyIconEx.NotifyInfoFlags.Info, 5); this.AutoPrintPalletLabel(lstPallet); } } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
//private void ExportDocument(eExportType expType) //{ // try // { // GridExportController gridController = new GridExportController(this.grdQryDetail.Views[0]); // switch (expType) // { // case eExportType.html: // gridController.ExportToHTML(this.FileName_Detail + ".html", "HTML Document", "HTML Files|*.html"); // break; // case eExportType.pdf: // gridController.ExportToPDF(this.FileName_Detail + ".pdf", "PDF Document", "PDF Files|*.pdf"); // break; // case eExportType.rtf: // gridController.ExportToRTF(this.FileName_Detail + ".rtf", "RTF Document", "RTF Files|*.rtf"); // break; // case eExportType.txt: // gridController.ExportToTEXT(this.FileName_Detail + ".txt", "Text Document", "Text Files|*.txt"); // break; // case eExportType.xls: // gridController.ExportToXLS(this.FileName_Detail + ".xls", "Microsoft Excel Document", "Microsoft Excel|*.xls"); // break; // case eExportType.xlsx: // gridController.ExportToXLSX(this.FileName_Detail + ".xlsx", "Microsoft Excel 2007 Document", "Microsoft Excel|*.xlsx"); // break; // default: // break; // } // } // catch (Exception ex) // { // XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); // } //} private void Query_Detail_Info() { //TimeSpan executionTime = new TimeSpan(); try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); DataTable dtbStkAsOnDtl = null; using (ShippingOrderBLL shipingOrdBll = new ShippingOrderBLL()) { dtbStkAsOnDtl = shipingOrdBll.ShowPickingDetail(this._SO_NO, this._PROD_SEQ_NO, this._TYPE); //executionTime = queryBll.ExecutionTime; } this.picSelect.ClearSelection(); this.grdQryDetail.DataSource = dtbStkAsOnDtl; this.dntPickingDtl.DataSource = dtbStkAsOnDtl; this.btnRollBack.Enabled = (dtbStkAsOnDtl.Rows.Count > 0); } catch (Exception ex) { base.FinishedProcessing(); this.grdQryDetail.DataSource = null; XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); //((frmMainMenu)this.ParentForm).ExecuteTime.Caption = "Execute Time: " + UiUtility.TimeSpanInWords(executionTime); } }
private void ShippingOrder_GetProductList_Search(string search) { List <Product> lstPrd = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { lstPrd = shipOrdBll.LovProductList(this._WH_ID, this._PARTY_ID, this._PO_NO, search); } this.grdProduct.DataSource = lstPrd; } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
private void Shipping_GetSalesOrderList_Search(string search) { List <Document> lstDocument = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ShippingOrderBLL shippingBll = new ShippingOrderBLL()) { lstDocument = shippingBll.LovDocumentSalesList(this._PARTY_ID, search); } this.grdDocument.DataSource = lstDocument; } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
private void UploadSalesOrderSage50() { try { string resultMsg = string.Empty; using (ShippingOrderBLL shippingBll = new ShippingOrderBLL()) { resultMsg = shippingBll.UploadSalesOrder_SAGE50(this.dtCSVdata, this.USER_ID); } if (resultMsg == "OK") { NotifierResult.Show("Upload CSV Complete", "Result", 50, 1000, 50, NotifyType.Safe); } else { XtraMessageBox.Show(this, resultMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
//for Shipping Order public void ShippingOrder_GetProductList() { List <Product> lstPrd = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { lstPrd = shipOrdBll.LovProductList(this._WH_ID, this._PARTY_ID, this._PO_NO, string.Empty); } this.grdProduct.DataSource = lstPrd; } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { GridView view = (GridView)this.grdProduct.Views[0]; view.Columns["FREE_STOCK"].Visible = true; base.FinishedProcessing(); } }
private void AutoPrintDetailsOnPallet(List <string> lstPallet) { try { DataSet ds; using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { ds = shipOrdBll.PrintDetailsOnPalletReport(lstPallet, UiUtility.WH_ID, "system"); } RPT_PALLET_DETAIL rpt = new RPT_PALLET_DETAIL(); rpt.DataSource = ds; //rpt.Parameters["paramUserPrint"].Value = "System"; rpt.Print(); } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { } }
private string DeletePicking(GridView view, int rowSelect, string pickno, int lineno) { if (view == null || view.SelectedRowsCount == 0) { return(string.Empty); } string resultMsg = string.Empty; view.BeginSort(); try { //string pickNo = view.GetRowCellValue(rowSelect, "PICK_NO").ToString(); //int lineNo = Convert.ToInt32(view.GetRowCellValue(rowSelect, "LINE_NO"), NumberFormatInfo.CurrentInfo); using (ShippingOrderBLL soBll = new ShippingOrderBLL()) { resultMsg = soBll.DeletePickingHDR(pickno, lineno, this.USER_ID); } if (resultMsg.Equals("OK")) { view.DeleteRow(rowSelect); } } catch (Exception ex) { resultMsg = ex.Message; } finally { view.EndSort(); } return(resultMsg); }
private void btnSave_Click(object sender, EventArgs e) { string resultMsg = string.Empty; GridView view = this.grdPickingList.Views[0] as GridView; List <PickingDtl> lstPicking = null; try { lstPicking = new List <PickingDtl>(); int flag = 0; for (int i = 0; i < view.RowCount; i++) { flag = Convert.ToInt32(view.GetRowCellValue(i, "FLAG"), NumberFormatInfo.CurrentInfo); if (flag.Equals(1)) { lstPicking.Add((PickingDtl)view.GetRow(i)); } } if (lstPicking.Count > 0) { using (ShippingOrderBLL soBll = new ShippingOrderBLL()) { resultMsg = soBll.UpdatePickingHDR(lstPicking, this.USER_ID); } if (resultMsg.Equals("OK")) { NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe); } else { NotifierResult.Show(resultMsg, "Error", 100, 1000, 0, NotifyType.Warning); } } else { NotifierResult.Show("No Data Update", "Result", 50, 1000, 50, NotifyType.Warning); } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { this.FormState = eFormState.ReadOnly; } }
private int GetPickedQty(string pickno, int lineno) { int result = 0; try { using (ShippingOrderBLL soBll = new ShippingOrderBLL()) { result = soBll.GetPickedQty(pickno, lineno); } } catch (Exception ex) { throw ex; } return(result); }
private void GetPickingList() { List <PickingDtl> lstPicking = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { lstPicking = shipOrdBll.GetPickingList(this.SO_NO, this.WH_ID); } this.grdPickingList.DataSource = lstPicking; this.dntPickingList.DataSource = lstPicking; if (lstPicking != null) { if (lstPicking.Count > 0) { this.ConditionsColumnView(this.grdPickingList); //lstPicking[0]. } //default check all this.picSelect.SelectAll(); } } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
private void InitializaLOVData() { try { using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { List <Warehouse> lstWH = shipOrdBll.GetWarehouse(); if (lstWH != null) { this.grvSO_HDR_rps_WH.DataSource = lstWH; } List <Packaging> lstPackaging = shipOrdBll.GetPackaging(); if (lstPackaging != null) { this.grvSO_DTL_rps_luePACKAGING.DataSource = lstPackaging; } } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
public void InsertShippingOrder() { string result = string.Empty; ShippingOrder shippingOrd; try { #region "Shipping Order Header" var lstShippingOrd = this.grdSO_HDR.DataSource as List <ShippingOrder>; shippingOrd = lstShippingOrd[0]; #endregion #region "Shipping Order Detail" DataTable dtbShippingDtl = this.grdSO_DTL.DataSource as DataTable; var drSelect = dtbShippingDtl.Select("[PROD_SEQ_NO] IS NOT NULL", "[LINE_NO]"); ShippingOrderDtl shpOrdDtl; foreach (DataRow dr in drSelect) { shpOrdDtl = new ShippingOrderDtl(); shpOrdDtl.SO_NO = dr["SO_NO"].ToString(); shpOrdDtl.LINE_NO = Convert.ToInt32(dr["LINE_NO"], NumberFormatInfo.CurrentInfo); shpOrdDtl.PROD_SEQ_NO = dr["PROD_SEQ_NO"].ToString(); shpOrdDtl.UNIT_ID = dr["UNIT_ID"].ToString(); shpOrdDtl.PACKAGING = dr["PACKAGING"].ToString(); shpOrdDtl.QTY = Convert.ToInt32(dr["QTY"], NumberFormatInfo.CurrentInfo); shpOrdDtl.UNIT_PRICE = (dr["UNIT_PRICE"] as decimal?) ?? 0.0M; //shpOrdDtl.UNIT_PRICE = Convert.ToDecimal(dr["UNIT_PRICE"], NumberFormatInfo.CurrentInfo); shpOrdDtl.REMARK = dr["REMARK"].ToString(); shpOrdDtl.PO_NO = dr["PO_NO"].ToString(); shpOrdDtl.REC_STAT = true; shippingOrd.AddItem(shpOrdDtl); } #endregion using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { result = shipOrdBll.InsertShippingOrder(ref shippingOrd, this.USER_ID); } if (result.Equals("OK")) { NotifierResult.Show("Insert Complete", "Result", 50, 1000, 50, NotifyType.Safe); this._SO_NO = shippingOrd.SO_NO; DialogResult = DialogResult.OK; } else { NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning); DialogResult = DialogResult.Cancel; } } catch (Exception ex) { this.Cursor = Cursors.Default; NotifierResult.Show(ex.Message, "Error", 100, 1000, 0, NotifyType.Warning); } finally { this.Cursor = Cursors.Default; } }
private void GetUploadSO() { List <ShippingOrder> lstShipOrd = null; DataTable dtbShipDtl = null; int dupCount = 0; try { //base.ExecutionStart(); //base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data", this); using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { lstShipOrd = shipOrdBll.GetUploadSO_HDR(); dtbShipDtl = shipOrdBll.GetUploadSO_DTL(); } this.grdSO_HDR.DataSource = lstShipOrd; if (dtbShipDtl != null) { dupCount = this.CheckDuplicated(ref dtbShipDtl); } this.grdSO_DTL.DataSource = dtbShipDtl; this.ConditionsColumnView(this.grdSO_DTL); base.FinishedProcessing(); if (lstShipOrd != null) { if (lstShipOrd.Count == 1) { //check W/H var wh = this.grvSO_HDR.GetRowCellDisplayText(0, "WH_ID"); if (string.IsNullOrEmpty(wh)) { string message = string.Format("'{0}' W/H not Matching!!", lstShipOrd[0].WH_ID); this.btnSave.Enabled = false; XtraMessageBox.Show(this, message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //check ETA date var shippingOrd = from sp in lstShipOrd where (!sp.ETA.HasValue) select sp; if (shippingOrd.Any()) { string message = string.Format("{0} Shipping Order has no ETD.!!", shippingOrd.Count()); this.btnSave.Enabled = false; XtraMessageBox.Show(this, message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { this.btnSave.Enabled = false; XtraMessageBox.Show(this, "Shipping Order Header Incorrect!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } if (dtbShipDtl != null) { var rows = from row in dtbShipDtl.AsEnumerable() where string.IsNullOrEmpty(row.Field <string>("PROD_SEQ_NO")) select row; if (rows.Any()) { this.lblMismatch.Visible = true; string message = string.Format("{0} Products not matching!!", rows.Count()); this.btnSave.Enabled = false; XtraMessageBox.Show(this, message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } var rowEmpty = from row in dtbShipDtl.AsEnumerable() where string.IsNullOrEmpty(row.Field <string>("PO_NO")) select row; if (rowEmpty.Any()) { this.lblPOEmpty.Visible = true; string message = string.Format("{0} Records has Empty PO#!!", rowEmpty.Count()); this.btnSave.Enabled = false; XtraMessageBox.Show(this, message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } if (dupCount > 0) { this.lblDuplicate.Visible = true; string message = string.Format("{0} Duplicate Product# and PO# Record!!", dupCount); this.btnSave.Enabled = false; XtraMessageBox.Show(this, message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //base.ExecutionStop(); } catch (Exception ex) { //base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { //((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime; } }
private void UploadExcelFileToTemp() { string resultMsg = string.Empty; string filename = string.Empty; string connectionString = string.Empty; using (OpenFileDialog fdlg = new OpenFileDialog { Title = "Open Shipping Order Data File", InitialDirectory = @"My Documents:\", Filter = "New Excel files (*.xlsx)|*.xlsx|Excel files (*.xls)|*.xls", FilterIndex = 2, RestoreDirectory = true }) { if (fdlg.ShowDialog() == DialogResult.OK) { filename = fdlg.FileName; //clear temp data using (ShippingOrderBLL soBll = new ShippingOrderBLL()) { soBll.ClearTempUploadSo(); } } else { filename = string.Empty; } } if (filename != string.Empty) { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); switch (Path.GetExtension(filename).ToLower()) { case ".xls": connectionString = string.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;""", filename); break; case ".xlsx": connectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1;""", filename); break; default: break; } try { using (OleDbConnection con = new OleDbConnection(connectionString)) { con.Open(); string sheetname = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Rows[0]["TABLE_NAME"].ToString(); string query = string.Format(UiUtility.UPLOAD_SO_QUERY, sheetname); OleDbDataAdapter da = new OleDbDataAdapter(query, con); using (DataTable dtbTempUpload = new DataTable()) { da.Fill(dtbTempUpload); if (dtbTempUpload != null) { using (ShippingOrderBLL soBll = new ShippingOrderBLL()) { resultMsg = soBll.UploadSOToTemp(dtbTempUpload); } } } } if (resultMsg.Equals("OK")) { this.GetUploadSO(); } } catch (OleDbException odex) { base.FinishedProcessing(); XtraMessageBox.Show(odex.Message); } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(ex.Message); } finally { base.FinishedProcessing(); } } }
private void PrintPickingList(string soNo, List <PickingDtl> lstPicking) { ShippingOrder soHDR = null; try { base.BeginProcessing("Begin Load Report...", "Please Waiting for Loading Report"); DataSet ds; using (ShippingOrderBLL shipOrdBll = new ShippingOrderBLL()) { ds = shipOrdBll.PrintPickingListReport(soNo, lstPicking, string.Empty); soHDR = shipOrdBll.GetShippingOrder(soNo); } ReportViewer viewer = new ReportViewer(); viewer.AutoCloseAfterPrint = true; RPT_PICKING_LIST rpt = new RPT_PICKING_LIST(); //RPT_PICKING_LIST_REPORT rpt = new RPT_PICKING_LIST_REPORT(); rpt.DataSource = ds; rpt.Parameters["paramUserPrint"].Value = this.USER_ID; rpt.CreateDocument(); if (soHDR.PARTY_ID == "PST008") { RPT_PICKING_LIST rpt2 = new RPT_PICKING_LIST(); rpt2.DataSource = ds; rpt2.CreateDocument(); for (int i = 0; i < rpt2.Pages.Count; i++) { rpt2.Pages[i].AssignWatermark(CreateTextWatermark("COPY")); } // rpt.Pages.AddRange(rpt2.Pages); int minPageCount = Math.Min(rpt.Pages.Count, rpt2.Pages.Count); for (int i = 0; i < minPageCount; i++) { rpt.Pages.Insert(i * 2 + 1, rpt2.Pages[i]); } if (rpt2.Pages.Count != minPageCount) { for (int i = minPageCount; i < rpt2.Pages.Count; i++) { rpt.Pages.Add(rpt2.Pages[i]); } } } viewer.SetReport(rpt); base.FinishedProcessing(); viewer.ShowDialog(); } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }