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