private void InitializaLOVData() { try { //for post type using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { List <PostType> lstPostType = inDataBll.PostTypeList(); if (lstPostType != null) { lstPostType.Insert(0, new PostType { SEQ_NO = string.Empty, NAME = "(All)" }); this.luePostType.Properties.DataSource = lstPostType; //set defautl this.luePostType.EditValue = "NEW"; } } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
private void GetResultUploadRevisionb() { DataTable dtbResult; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { dtbResult = inDataBll.GetResultUploadRevision(this._SEQ_NO, this._USER_ID); } this.grdRetUpRevision.DataSource = dtbResult; this.dntRetUpRevision.DataSource = dtbResult; } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
private void FGAdjustInInterfacePostData() { try { //ICollection<string> files; DataTable dtbPosted = null; string selectPath = string.Empty; string resultMsg = string.Empty; DialogResult result = this.fdbSelectFilePath.ShowDialog(this); if (result == DialogResult.OK) { selectPath = this.fdbSelectFilePath.SelectedPath; try { using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { resultMsg = inDataBll.GetPostData("INTERFACE_PACK.IF_IN_ADJ_LIST", string.Empty, null, selectPath, ((frmMainMenu)this.ParentForm).UserID, out dtbPosted); } /* * if (files.Count > 0) * { * //copy to server * UiUtility.CopyFilesToServer(files); * * this.OpenPath(files); * * //Refresh screen * this.btnRefresh.PerformClick(); * } * else * { * XtraMessageBox.Show(this, "Post Data has Problem!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1); * } * */ } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
private void GetRevisionLastUpdate() { try { string result = string.Empty; using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { result = inDataBll.GetRevisionLastUpdate(); } this.txtRevisionLastUpdate.Text = result; } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
private void FgAssemblyInterfaceData(string posttype, string wh_id, string productNo, string postRef, DateTime?fromDate, DateTime?toDate, DateTime?stkfDate, DateTime?stktDate) { try { base.ExecutionStart(); base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { this.dtbAssemblyInfData = inDataBll.IfInAssemblyList(posttype, wh_id, productNo, postRef, fromDate, toDate, stkfDate, stktDate, ((frmMainMenu)this.ParentForm).UserID); } if (this.dtbAssemblyInfData != null) { this.ConditionsColumnView(this.grdAsmIn); } this.grdAsmIn.DataSource = this.dtbAssemblyInfData; this.dntQryStkAsOn.DataSource = this.dtbAssemblyInfData; this.grdPostedData.DataSource = null; //check enable button this.CheckEnablePostData("[DATA_TYPE] = 'NEW'"); base.ExecutionStop(); } catch (Exception ex) { base.FinishedProcessing(); this.grdAsmIn.DataSource = null; this.dntQryStkAsOn.DataSource = null; XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { ((frmMainMenu)this.ParentForm).ExecuteTime.Caption = base.ExecuteTime; base.FinishedProcessing(); } }
private void InitializaLOVData() { try { //for post type using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { List <PostType> lstPostType = inDataBll.PostTypeList(); if (lstPostType != null) { lstPostType.Insert(0, new PostType { SEQ_NO = string.Empty, NAME = "(All)" }); this.luePostType.Properties.DataSource = lstPostType; //set defautl this.luePostType.EditValue = "NEW"; } List <Warehouse> lstWH = inDataBll.GetWarehouse(); if (lstWH != null) { lstWH.Insert(0, new Warehouse { SEQ_NO = string.Empty, NAME = "(All)" }); this.lueWarehouse.Properties.DataSource = lstWH; } } using (ProductionTypeBLL pdtBll = new ProductionTypeBLL()) { this.grvAsmIn_rps_PRODUCTION_TYPE.DataSource = pdtBll.GetProductionTypeList(); } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
private void UploadRevision(string userid) { DataTable dtbBomData; string fullFilename, pathFile, filename; string connectionString, queryString; using (OpenFileDialog fdlg = new OpenFileDialog { Title = "Open BOM. Revision File", InitialDirectory = @"My Documents:\", Filter = "New Excel files (*.csv)|*.csv|BOM. File (*.csv)|*.csv", FilterIndex = 2, RestoreDirectory = true }) { if (fdlg.ShowDialog() == DialogResult.OK) { if (!string.IsNullOrEmpty(fdlg.FileName)) { fullFilename = fdlg.FileName; FileInfo fi = new FileInfo(fullFilename); pathFile = fi.DirectoryName; filename = fi.Name; } else { fullFilename = string.Empty; pathFile = string.Empty; filename = string.Empty; } } else { fullFilename = string.Empty; pathFile = string.Empty; filename = string.Empty; } } if (!string.IsNullOrEmpty(fullFilename) && !string.IsNullOrEmpty(filename)) { try { StreamReader StrWer = File.OpenText(fullFilename); ICollection <string> values = new Collection <string>(); while (StrWer.EndOfStream == false) { values.Add(StrWer.ReadLine()); } string seq = string.Empty; using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { seq = inDataBll.UploadRevision(filename, userid, values); } if (!string.IsNullOrEmpty(seq)) { using (frmPopResultUpRevision fResultRevision = new frmPopResultUpRevision { SEQ_NO = seq, USER_ID = userid }) { UiUtility.ShowPopupForm(fResultRevision, this, true); } } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } } }
private void FGAssemblyInterfacePostData(DataTable dtbSelect) { try { //ICollection<string> files; DataTable dtbPosted = null; string selectPath = string.Empty; string fullfilename = string.Empty; DialogResult result = this.fdbSelectFilePath.ShowDialog(this); if (result == DialogResult.OK) { selectPath = this.fdbSelectFilePath.SelectedPath; try { using (InterfaceDataBLL inDataBll = new InterfaceDataBLL()) { inDataBll.GetPostData("INTERFACE_PACK.IF_IN_ASEMBLY_LIST", string.Empty, dtbSelect, selectPath, ((frmMainMenu)this.ParentForm).UserID, out dtbPosted); } if (dtbPosted != null) { // //get last update revision this.GetRevisionLastUpdate(); this.BindingPostedData(dtbPosted, selectPath, out fullfilename); UiUtility.CopyFilesToServer(new Collection <string>() { fullfilename }); this.OpenExcelFile(fullfilename); this.btnRefresh.PerformClick(); } //if (files.Count > 0) //{ // //get last update revision // this.GetRevisionLastUpdate(); // //copy to server // UiUtility.CopyFilesToServer(files); // this.OpenPath(files); // //Refresh screen // this.btnRefresh.PerformClick(); //} } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }