private void LoadLastStockTaking() { StockTakingBIZ stkBiz = new StockTakingBIZ(); StockTakingDTO stkDTO = stkBiz.LoadLastStockTaking(); if (stkDTO != null) { this.txtLastRemark.Text = stkDTO.REMARK; this.dtpLastSTKDate.DateValue = stkDTO.STOCK_TAKING_DATE; this.txtLastPreProcessBy.Text = stkDTO.PRE_PROCESS_BY + " - " + stkDTO.PRE_PROCESS_NAME; } }
public void ClearImportStockTaking() { StockTakingBIZ biz = new StockTakingBIZ(); if (biz.DoAdjustInventory()) { ErrorItem err = new ErrorItem(null, TKPMessages.eValidate.VLM0181.ToString()); throw new BusinessException(err); } biz.ClearImportStockTaking(Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine); }
private void SaveData() { if (m_ParentSheet == null) { return; } int iBox = txtNumberOfBox.Int == 0 ? 1 : txtNumberOfBox.Int; for (int box = 0; box < iBox; box++) { NZString strPackNo = new NZString(); if (string.Empty.Equals(txtPackNo.Text.Trim())) { StockTakingBIZ biz = new StockTakingBIZ(); strPackNo = biz.GeneratePackNo(); } else { strPackNo = new NZString(txtPackNo, txtPackNo.Text); } for (int i = 0; i < shtView.RowCount; i++) { m_ParentSheet.RowCount = m_ParentSheet.RowCount + 1; //m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.STOCK_TAKING_ID].Value = string.Empty; //m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.EFFECT_INVENTORY_FLAG].Value = false; //m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.COUNTING_ID].Value = string.Empty; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.ITEM_CD].Value = txtMasterNo.Text.Trim(); //m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.BTN_ITEM_CD].Value = null; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.SHORT_NAME].Value = txtPartNo.Text.Trim(); m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.CUST_NAME].Value = txtItemDesc.Text.Trim(); m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.LOC_CD].Value = m_Location; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.LOT_NO].Value = shtView.Cells[i, (int)eColView.LOT_NO].Value; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.EXTERNAL_LOT_NO].Value = shtView.Cells[i, (int)eColView.EXTERNAL_LOT_NO].Value; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.PACK_NO].Value = strPackNo.StrongValue; //txtPackNo.Text.Trim(); m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.FG_NO].Value = txtFGNo.Text.Trim(); //txtPackNo.Text.Trim(); m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.SYSTEM_QTY].Value = 0; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.COUNT_QTY].Value = shtView.Cells[i, (int)eColView.QTY].Value; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.DIFF_QTY].Value = shtView.Cells[i, (int)eColView.QTY].Value; //m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.ADJUSTED_FLAG].Value = 0; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.MANUAL_ADD_FLAG].Value = 1; //m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.TAG_NO].Value = string.Empty; //m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.REMARK].Value = string.Empty; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.ROW_STATUS].Value = (int)STK030_StockTakingEntry.eRowStatus.ADD; m_ParentSheet.Cells[m_ParentSheet.RowCount - 1, (int)STK030_StockTakingEntry.eColView.TAG_NO].Value = this.txtTagNo.Text.Trim(); } } }
private ErrorItem CheckCanRunProcess() { try { // modify on 30/oct // fix to support in case run closing period before end of month //// get year month //InventoryPeriodBIZ bizPeriod = new InventoryPeriodBIZ(); //InventoryPeriodDTO dtoPeriod = bizPeriod.LoadCurrentPeriod(); //if (!dtoPeriod.YEAR_MONTH.StrongValue.Equals(Convert.ToDateTime(dtpLastSTKDate.DateValue).ToString("yyyyMM"))) //{ // return new ErrorItem(null, TKPMessages.eValidate.VLM0075.ToString()); //} if (cboProcess.SelectedIndex == -1) { return(new ErrorItem(null, TKPMessages.eValidate.VLM0087.ToString())); } StockTakingBIZ bizStockTaking = new StockTakingBIZ(); StockTakingDTO dtoStockTaking = new StockTakingDTO(); dtoStockTaking.STOCK_TAKING_DATE = Convert.ToDateTime(dtpLastSTKDate.DateValue); dtoStockTaking.LOCATION_CODE = Convert.ToString(this.cboProcess.SelectedValue); bool bRunUpdateProcess = bizStockTaking.CheckLocationRunUpdateProcess(dtoStockTaking); if (bRunUpdateProcess) { return(new ErrorItem(null, TKPMessages.eValidate.VLM0090.ToString(), new object[] { Convert.ToString(this.cboProcess.SelectedValue) })); } bool bCompleteInputData = bizStockTaking.CheckCompleteInputData(dtoStockTaking); if (bCompleteInputData == false) { return(new ErrorItem(null, TKPMessages.eValidate.VLM0091.ToString(), new object[] { Convert.ToString(this.cboProcess.SelectedValue) })); } } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } return(null); }
private void LoadCurrentStockTakingData() { StockTakingBIZ stkBiz = new StockTakingBIZ(); StockTakingDTO stkDTO = stkBiz.LoadLastStockTaking(); if (stkDTO != null) { this.txtRemark.Text = stkDTO.REMARK; this.dtStockTakingDate.DateValue = stkDTO.STOCK_TAKING_DATE; this.txtPreProcessBy.Text = stkDTO.PRE_PROCESS_BY + " - " + stkDTO.PRE_PROCESS_NAME; } else { MessageDialog.ShowBusiness(this , new EVOFramework.Message(TKPMessages.eValidate.VLM0086.ToString())); } }
private void btnRun_Click(object sender, EventArgs e) { try { ErrorItem err = CheckCanRunProcess(); if (err != null) { MessageDialog.ShowBusiness(this, err.Message); return; } StockTakingDTO dtoStockTaking = new StockTakingDTO(); dtoStockTaking.STOCK_TAKING_DATE = Convert.ToDateTime(dtpLastSTKDate.DateValue); dtoStockTaking.YEAR_MONTH = txtYearMonth.Text; dtoStockTaking.LOCATION_CODE = Convert.ToString(cboProcess.SelectedValue); StockTakingBIZ bizStockTaking = new StockTakingBIZ(); string strTextEffectInventory = bizStockTaking.GetTextEffectInventory(dtoStockTaking); MessageDialogResult dr = MessageDialog.ShowConfirmation(this, new Message(SystemMaintenance.Messages.eConfirm.CFM9009.ToString(), new object[] { strTextEffectInventory }).MessageDescription, MessageDialogButtons.YesNo); if (dr == MessageDialogResult.Yes) { if (RunProcess()) { MessageDialog.ShowBusiness(this, Message.LoadMessage(SystemMaintenance.Messages.eInformation.INF9003.ToString())); } this.cboProcess.SelectedIndex = -1; LoadCurrentStockTakingData(); } } catch (ValidateException ex) { MessageDialog.ShowBusiness(this, ex.ErrorResults[0].Message); } catch (BusinessException ex) { MessageDialog.ShowBusiness(this, ex.Error.Message); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }
//dtoImportList = data in import file public bool ImportStockTakingTemp(string FilePath, int TotalColumn, List <ImportStockTakingDTO> ImportDataList) { StockTakingBIZ biz = new StockTakingBIZ(); biz.InsertStockTakingTemp(ImportDataList); List <ImportStockTakingDTO> errorList = biz.ValidateStockTakingTemp(Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine); if (errorList == null || errorList.Count == 0) { biz.UpdateStockTaking(Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine); return(true); } WriteErrorToExcelFile(FilePath, TotalColumn + 1, errorList); return(false); }
private void LoadCurrentStockTakingData() { StockTakingBIZ stkBiz = new StockTakingBIZ(); StockTakingDTO stkDTO = stkBiz.LoadLastStockTaking(); if (stkDTO != null) { this.dtpLastSTKDate.DateValue = stkDTO.STOCK_TAKING_DATE; this.txtLastPreProcessBy.Text = stkDTO.PRE_PROCESS_BY + " - " + stkDTO.PRE_PROCESS_NAME; this.txtYearMonth.Text = stkDTO.YEAR_MONTH; CtrlUtil.EnabledControl(true, btnLocation, btnRun, cboProcess); } else { CtrlUtil.EnabledControl(false, btnLocation, btnRun, cboProcess); MessageDialog.ShowBusiness(this , new EVOFramework.Message(TKPMessages.eValidate.VLM0086.ToString())); } }
private bool RunProcess() { try { StockTakingBIZ biz = new StockTakingBIZ(); StockTakingDTO stk = new StockTakingDTO(); stk.STOCK_TAKING_DATE = Convert.ToDateTime(dtpLastSTKDate.DateValue); stk.YEAR_MONTH = txtYearMonth.Text; stk.LOCATION_CODE = Convert.ToString(cboProcess.SelectedValue); biz.RunStockTakingUpdateProcess(stk); return(true); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } return(false); }
private bool RunProcess() { try { StockTakingBIZ biz = new StockTakingBIZ(); StockTakingDTO stk = new StockTakingDTO(); stk.STOCK_TAKING_DATE = Convert.ToDateTime(dtpStockTakingDate.Value); stk.REMARK = txtRemark.Text; stk.YEAR_MONTH = txtYearMonth.Text; biz.RunStockTakingPreProcess(stk); return(true); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); picWaiting.Visible = false; } return(false); }
private void LoadCurrentStockTakingData() { InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriod(); //DateTime currentYearMonth = new DateTime( // Convert.ToInt32(dto.YEAR_MONTH.StrongValue.Substring(0, 4)), // Convert.ToInt32(dto.YEAR_MONTH.StrongValue.Substring(4, 2)), // 1); txtYearMonth.Text = dto.YEAR_MONTH; dtpStockTakingDate.Value = DateTime.Today; StockTakingBIZ stkBiz = new StockTakingBIZ(); StockTakingDTO stkDTO = stkBiz.LoadLastStockTaking(); if (stkDTO != null) { this.txtLastRemark.Text = stkDTO.REMARK; this.dtpLastSTKDate.DateValue = stkDTO.STOCK_TAKING_DATE; this.txtLastPreProcessBy.Text = stkDTO.PRE_PROCESS_BY + " - " + stkDTO.PRE_PROCESS_NAME; } //CommonLib.CtrlUtil.EnabledControl(false, txtInfo, dtInventoryMonth); }
private void btnRun_Click(object sender, EventArgs e) { try { ErrorItem err = CheckCanRunProcess(); if (err != null) { MessageDialog.ShowBusiness(this, err.Message); return; } //if (dtInventoryMonth.DateValue != null) //{ // // check exist in inventory period // InventoryPeriodBIZ bizPeriod = new InventoryPeriodBIZ(); // NZString YearMonth = new NZString(null, Convert.ToDateTime(dtInventoryMonth.DateValue).ToString("yyyyMM")); // if (!bizPeriod.Exist(YearMonth)) // { // MessageDialog.ShowBusiness(this, // Message.LoadMessage( // TKPMessages.eValidate.VLM0045.ToString())); // return; // } //} ////MessageDialog.ShowBusiness(this, //// Message.LoadMessage( //// TKPMessages.eValidate.VLM0020.ToString())); MessageDialogResult dr = MessageDialog.ShowConfirmation(this, new Message(SystemMaintenance.Messages.eConfirm.CFM9008.ToString()).MessageDescription); if (dr == MessageDialogResult.Yes) { StockTakingBIZ biz = new StockTakingBIZ(); StockTakingDTO stk = new StockTakingDTO(); stk.STOCK_TAKING_DATE = Convert.ToDateTime(dtpStockTakingDate.Value); stk.REMARK = txtRemark.Text; stk.YEAR_MONTH = txtYearMonth.Text; bool bAlreadyRunPreProcess = biz.CheckExistsStockTaking(stk); if (bAlreadyRunPreProcess) { MessageDialogResult drExistStockTaking = MessageDialog.ShowConfirmation(this, new Message(SystemMaintenance.Messages.eConfirm.CFM9010.ToString() , new object[] { stk.STOCK_TAKING_DATE.ToString(Common.CurrentUserInfomation.DateFormatString) } ).MessageDescription ); if (drExistStockTaking != MessageDialogResult.Yes) { return; } } picWaiting.Visible = true; try { if (RunProcess()) { picWaiting.Visible = false; MessageDialog.ShowBusiness(this, Message.LoadMessage(SystemMaintenance.Messages.eInformation.INF9003.ToString())); } //Modify on 20 oct 2010 //Disable run button after run process complete //To prevent user execute process again, otherwise user close and open this screen again this.btnRun.Enabled = false; } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } finally { picWaiting.Visible = false; } LoadCurrentStockTakingData(); } } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }