private void DeletePO() { int iActive = shtView.ActiveRowIndex; List <PurchaseOrderDDTO> dDTOPurchaseOrderList = new List <PurchaseOrderDDTO>(); ValidateException.ThrowErrorItem( PurchaseOrderEntryValidation.CheckEmptyString( (NZString)Convert.ToString(shtView.Cells[iActive, (int)eColumn.PO_LINE].Value), Messages.eValidate.VLM0142)); dDTOPurchaseOrderList.Add(new PurchaseOrderDDTO { PO_NO = (NZString)Convert.ToString(shtView.Cells[iActive, (int)eColumn.PO_NO].Value), PO_LINE = (NZDecimal)Convert.ToDecimal(shtView.Cells[iActive, (int)eColumn.PO_LINE].Value), RECEIVE_QTY = (NZDecimal)Convert.ToDecimal(shtView.Cells[iActive, (int)eColumn.RECEIVE_QTY].Value), ITEM_CD = (NZString)Convert.ToString(shtView.Cells[iActive, (int)eColumn.ITEM_CD].Value), DUE_DATE = (NZDateTime)Convert.ToDateTime(shtView.Cells[iActive, (int)eColumn.DUE_DATE].Value) }); new PurchaseOrderBIZ().DeletePOLine(GeneratePurchaseOrderHDTO(), dDTOPurchaseOrderList); MessageDialog.ShowInformation(this, "Information", new EVOFramework.Message(Messages.eInformation.INF9003.ToString()).MessageDescription); OnRefresh(); }
private void GenerateTmpDemandOrderDTOList(List <TmpDemandOrderDTO> dtoDemandOrderList) { DateTime dtmSelect = Convert.ToDateTime(dtpDemand.Value); for (int iRow = 0; iRow < shtView.Rows.Count; iRow++) { #region validation ValidateException.ThrowErrorItem( PurchaseOrderEntryValidation.CheckEmptyString((NZString)Convert.ToString(shtView.Cells[iRow, (int)eColumn.ITEM_DESC].Value), Messages.eValidate.VLM0129)); #endregion for (int iColumn = (int)eColumn.Day1; iColumn < DateTime.DaysInMonth(dtmSelect.Year, dtmSelect.Month) + (int)eColumn.Day1; iColumn++) { TmpDemandOrderDTO dtoTmpDemandOrder = new TmpDemandOrderDTO { CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD, CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine, CRT_DATE = (NZDateTime)DateTime.UtcNow, CUSTOMER_CD = (NZString)txtCusCD.Text, DUE_DATE = (NZDateTime)(new DateTime(dtmSelect.Year, dtmSelect.Month, (iColumn - 2))), ITEM_CD = (NZString)Convert.ToString(shtView.Cells[iRow, (int)eColumn.ITEM_CD].Value.ToString()), ITEM_DESC = (NZString)Convert.ToString(shtView.Cells[iRow, (int)eColumn.ITEM_DESC].Value), ORDER_QTY = (NZDecimal)(Convert.ToDecimal(shtView.Cells[iRow, iColumn].Value)), ORDER_TYPE = null, YEAR_MONTH = (NZDateTime)dtpDemand.Value, }; if (dtoTmpDemandOrder.ORDER_QTY > 0) { dtoDemandOrderList.Add(dtoTmpDemandOrder); } } } }
/// <summary> /// Generate PO Header. /// </summary> /// <param name="strPONo">PO No of PO Header.</param> /// <returns>PO Header</returns> private PurchaseOrderHDTO GeneratePurchaseOrderHDTO(NZString strPONo) { NZDateTime dtmPO = new NZDateTime(dtmPODate, dtmPODate.Value); NZString strSupplierCD = new NZString(cboSupplierCode, cboSupplierCode.SelectedValue); NZString strDeliveryTo = chkOurFactory.Checked ? new NZString(cboDelivery, cboDelivery.Text) : new NZString(cboDelivery, cboDelivery.SelectedValue); NZString strCurrency = new NZString(cboCurrency, cboCurrency.SelectedValue); NZString strVatRate = new NZString(txtVatRate, txtVatRate.Text); string strVatType = (Convert.ToInt32(strVatRate) > 0) ? "02" : "01"; #region validation ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckDateTimeValue(dtmPO, Messages.eValidate.VLM0116)); ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString(strSupplierCD, Messages.eValidate.VLM0118)); if (!chkOurFactory.Checked) { ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString((NZString)strDeliveryTo, Messages.eValidate.VLM0119)); } ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString((NZString)strCurrency, Messages.eValidate.VLM0121)); if (this.m_ScreenStateEnum == eScreenState.Add) { ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckPurchaseOrderItem((NZInt)shtView.Rows.Count)); } #endregion PurchaseOrderHDTO hDTO = new PurchaseOrderHDTO { CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD, CRT_DATE = (NZDateTime)DateTime.UtcNow, CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine, UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD, UPD_DATE = (NZDateTime)DateTime.UtcNow, UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine, PO_NO = strPONo, PO_DATE = (NZDateTime)dtmPO, IS_ACTIVE = (NZBoolean)m_bIsActived, //(NZBoolean)((m_iPOStatus == 1) ? true : false), PO_TYPE = (NZString)"01", //(NZString)(cboPOType.SelectedValue.ToString()), IS_EXPORT = (NZBoolean)false, //(NZBoolean)chkExport.Checked, ADDRESS = (NZString)"", // (NZString)txtAddress.Text, SUPPLIER_CD = (NZString)strSupplierCD, DELIVERY_TO = (NZString)strDeliveryTo, TERM_OF_PAYMENT = (NZString)(Convert.ToString(cboTermOfPayment.SelectedValue)), STATUS = (NZString)"0", VAT_TYPE = (NZString)strVatType, VAT_RATE = (NZDecimal)Convert.ToDecimal(strVatRate), CURRENCY = (NZString)(cboCurrency.SelectedValue.ToString()), REMARK = (NZString)txtRemark.Text, }; return(hDTO); }
/// <summary> /// Check PO Details, there cannot has the same ItemCode, DueDate and UnitPrice. /// </summary> /// <returns>ErrorItem if Has Dupplication.</returns> private ErrorItem ValidateDupplicateItem() { int iRow = shtView.ActiveRowIndex; if (shtView.Cells[iRow, (int)eColumn.ITEM_CD].Value == null || shtView.Cells[iRow, (int)eColumn.DUE_DATE].Value == null || shtView.Cells[iRow, (int)eColumn.UNIT_PRICE].Value == null) { return(null); } PurchaseOrderDDTO dDTOChk = new PurchaseOrderDDTO { ITEM_CD = (NZString)Convert.ToString(shtView.Cells[iRow, (int)eColumn.ITEM_CD].Value), DUE_DATE = (NZDateTime)Convert.ToDateTime(shtView.Cells[iRow, (int)eColumn.DUE_DATE].Value), UNIT_PRICE = (NZDecimal)Convert.ToDecimal(shtView.Cells[iRow, (int)eColumn.UNIT_PRICE].Value) }; List <PurchaseOrderDDTO> dDTOPOList = new List <PurchaseOrderDDTO>(); for (int i = 0; i < shtView.Rows.Count; i++) { if (shtView.Cells[i, (int)eColumn.ITEM_CD].Value == null || shtView.Cells[i, (int)eColumn.DUE_DATE].Value == null || shtView.Cells[i, (int)eColumn.UNIT_PRICE].Value == null) { continue; } if (i != iRow) { PurchaseOrderDDTO dDTOTmp = new PurchaseOrderDDTO { ITEM_CD = (NZString)Convert.ToString(shtView.Cells[i, (int)eColumn.ITEM_CD].Value), DUE_DATE = (NZDateTime)Convert.ToDateTime(shtView.Cells[i, (int)eColumn.DUE_DATE].Value), UNIT_PRICE = (NZDecimal)Convert.ToDecimal(shtView.Cells[i, (int)eColumn.UNIT_PRICE].Value) }; dDTOPOList.Add(dDTOTmp); } } ErrorItem errItem = PurchaseOrderEntryValidation.CheckDupItemByDTO(dDTOChk, dDTOPOList); if (errItem != null) { shtView.Cells[shtView.ActiveRowIndex, shtView.ActiveColumnIndex].Value = null; } return(errItem); }
private void LoadItemDesc(int iRow) { try { #region validateion List <string> strItemCDList = new List <string>(); for (int i = 0; i < shtView.Rows.Count; i++) { if (i != iRow) { strItemCDList.Add(Convert.ToString(shtView.Cells[i, (int)eColumn.ITEM_CD].Value)); } } ErrorItem errItem = PurchaseOrderEntryValidation.CheckDupItem (new NZString(null, shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_CD].Value), strItemCDList); if (errItem != null) { shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_CD].Value = string.Empty; shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_DESC].Value = string.Empty; ValidateException.ThrowErrorItem(errItem); } #endregion ItemBIZ bizItem = new ItemBIZ(); ItemDTO dtoItem = bizItem.LoadItem((NZString)Convert.ToString(shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_CD].Value)); if (dtoItem != null) { shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_DESC].Value = Convert.ToString(dtoItem.ITEM_DESC); } else { shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_DESC].Value = string.Empty; } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message); err.Error.FocusOnControl(); } catch (ValidateException err) { MessageDialog.ShowBusiness(this, err.ErrorResults[0].Message); err.ErrorResults[0].FocusOnControl(); } }
private void fpView_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) { try { eItemType[] itemTypeEnum = { eItemType.All }; ItemFindDialog dialog = new ItemFindDialog(eSqlOperator.Equal, itemTypeEnum); dialog.ShowDialog(this); if (dialog.IsSelected) { #region validateion int iRow = shtView.ActiveRowIndex; List <string> strItemCDList = new List <string>(); for (int i = 0; i < shtView.Rows.Count; i++) { if (i != iRow) { strItemCDList.Add(Convert.ToString(shtView.Cells[i, (int)eColumn.ITEM_CD].Value)); } } ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckDupItem(dialog.SelectedItem.ITEM_CD, strItemCDList)); #endregion shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_CD].Value = dialog.SelectedItem.ITEM_CD.ToString(); shtView.Cells[shtView.ActiveRowIndex, (int)eColumn.ITEM_DESC].Value = dialog.SelectedItem.ITEM_DESC.ToString(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message); err.Error.FocusOnControl(); } catch (ValidateException err) { MessageDialog.ShowBusiness(this, err.ErrorResults[0].Message); err.ErrorResults[0].FocusOnControl(); } }
/// <summary> /// Validate Value of rows in SpreadSheet. /// </summary> private void ValidateAllRows() { for (int iRow = 0; iRow < shtView.RowCount; iRow++) { NZString strItemCD = new NZString(null, shtView.Cells[iRow, (int)eColumn.ITEM_CD].Value, null); NZString strItemDesc = new NZString(null, shtView.Cells[iRow, (int)eColumn.ITEM_DESC].Value, null); NZDateTime dtmRequireDate = new NZDateTime(null, shtView.Cells[iRow, (int)eColumn.DUE_DATE].Value, null); NZDecimal decUnitPrice = new NZDecimal(null, shtView.Cells[iRow, (int)eColumn.UNIT_PRICE].Value, null); NZDecimal decQty = new NZDecimal(null, shtView.Cells[iRow, (int)eColumn.PO_QTY].Value, null); NZString strUnit = new NZString(null, shtView.Cells[iRow, (int)eColumn.UNIT].Value, null); NZDecimal decAmount = new NZDecimal(null, shtView.Cells[iRow, (int)eColumn.AMOUNT].Value, null); NZDecimal decReceiveQty = new NZDecimal(null, shtView.Cells[iRow, (int)eColumn.RECEIVE_QTY].Value, 0); NZString strStatus = new NZString(null, shtView.Cells[iRow, (int)eColumn.STATUS].Value, null); #region Validateion before Generate DDTO ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString(strItemDesc, Messages.eValidate.VLM0129)); ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckDateTimeValue(dtmRequireDate, Messages.eValidate.VLM0130)); ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckDecimalValue(decUnitPrice, Messages.eValidate.VLM0131)); ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString(strUnit, Messages.eValidate.VLM0133)); ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckDecimalValue(decQty, Messages.eValidate.VLM0132)); ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString(strStatus, Messages.eValidate.VLM0137)); #endregion } }