private void LoadData(NZDateTime from, NZDateTime to) { m_dtAllData = m_controller.LoadMovePartList(from, to); shtMovePartList.RowCount = 0; shtMovePartList.DataSource = null; FindDataFromMemory(); }
private void LoadData(NZDateTime dtPeriod, string keyFilter) { try { //== Start to search data. InventoryOnhandController ctlInvent = new InventoryOnhandController(); //== 20091203 Add by Teerayt S. //NZString yearMonth = GetLatestYearMonthInInvOnhand(); NZString yearMonth = dtMonth.Value.Value.ToString("yyyyMM").ToNZString(); //== 20091203 End Add by Teerayt S. //List<InventorySummaryViewDTO> dtoView = ctlInvent.LoadInventorySummary(yearMonth); //m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView); m_dtAllData = ctlInvent.LoadInventorySummary(yearMonth); FindDataFromMemory(keyFilter); CtrlUtil.SpreadUpdateColumnSorting(shtInventorySummary); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }
public RPT010_PREVIEW(DataTable ReportData, NZDateTime BeginDate, NZDateTime EndDate) { InitializeComponent(); m_dt = ReportData; m_BeginDate = BeginDate; m_EndDate = EndDate; }
public DataTable LoadCustomerOrderList(NZDateTime DateBegin, NZDateTime DateEnd, NZInt filterType, bool IncludeOldData) { DataTable dt = null; Database db = m_db; DataRequest req = new DataRequest("S_TRN180_LoadCustomerOrderList"); req.CommandType = CommandType.StoredProcedure; req.Parameters.Add("@PERIOD_BEGIN_DATE", DataType.DateTime, CheckNull(DateBegin.StrongValue.Date)); req.Parameters.Add("@PERIOD_END_DATE", DataType.DateTime, CheckNull(DateEnd.StrongValue.Date)); req.Parameters.Add("@FILTER_TYPE", DataType.Int32, filterType.StrongValue); if (!IncludeOldData) { req.Parameters.Add("@OLD_DATA", DataType.Int16, 0); //not include old value } DataSet ds = db.ExecuteDataSet(req); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0]; } return(dt); }
private bool SaveData() { try { InventoryPeriodController ctlInv = new InventoryPeriodController(); NZString YearMonth = new NZString(null, dtInventoryMonth.Value.Value.ToString("yyyyMM")); NZDateTime PeriodBegin = new NZDateTime(null, dtPeriodFrom.Value); NZDateTime PeriodEnd = new NZDateTime(null, dtPeriodTo.Value); ctlInv.UpdatePeriod(YearMonth, PeriodBegin, PeriodEnd); return(true); } 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(); } catch (Exception err) { MessageDialog.ShowBusiness(this, err.Message); } return(false); }
public ErrorItem CheckWorkResultDate(NZDateTime date) { if (date.IsNull) { return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0046.ToString())); } InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriod(); if (dto == null) { return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0047.ToString())); } // edit by tar // AddMonths(1) to period end date if (date.StrongValue.Date.CompareTo(dto.PERIOD_BEGIN_DATE.StrongValue.Date) < 0 || date.StrongValue.Date.CompareTo(dto.PERIOD_END_DATE.StrongValue.AddMonths(1).Date) > 0) { return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0047.ToString())); } return(null); }
/// <summary> /// Check exists the specified key. /// </summary> public bool Exist(Database database, NZString CUSTOMER_CD, NZDateTime DUE_DATE, NZString ITEM_CD) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(TmpDemandOrderDTO)); sb.AppendLine(" SELECT TOP 1 1 "); sb.AppendLine(" FROM " + tableName); sb.AppendLine(" WHERE "); sb.AppendLine(" " + TmpDemandOrderDTO.eColumns.CUSTOMER_CD + "=:CUSTOMER_CD"); sb.AppendLine(" AND " + TmpDemandOrderDTO.eColumns.DUE_DATE + "=:DUE_DATE"); sb.AppendLine(" AND " + TmpDemandOrderDTO.eColumns.ITEM_CD + "=:ITEM_CD"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("CUSTOMER_CD", DataType.NVarChar, CUSTOMER_CD.Value); req.Parameters.Add("DUE_DATE", DataType.DateTime, DUE_DATE.Value); req.Parameters.Add("ITEM_CD", DataType.NVarChar, ITEM_CD.Value); #endregion return(db.ExecuteQuery(req).Rows.Count > 0); }
private void LoadData(NZDateTime from, NZDateTime to) { if (dtPeriodBegin.NZValue.IsNull || dtPeriodEnd.NZValue.IsNull) { if (dtPeriodBegin.NZValue.IsNull && dtPeriodEnd.NZValue.IsNull) { MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date begin and Delivery date end" })); } else if (dtPeriodBegin.NZValue.IsNull) { MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date begin" })); } else { MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date end" })); } return; } DataTable dt = m_controller.Load_ReturnProductionList(from, to, false); //DataTable dt = DTOUtility.ConvertListToDataTable(list); m_dtAllData = dt; shtReturnProductList.RowCount = 0; shtReturnProductList.DataSource = null; FindDataFromMemory(); //shtReturnProductList.DataSource = m_dtAllData; CtrlUtil.SpreadUpdateColumnSorting(shtReturnProductList); }
private void LoadData(NZDateTime dtDateFrom, string keyFilter) { try { if (dtDateFrom.IsNull) { shtInventorySummary.RowCount = 0; MessageDialog.ShowBusiness(this, EVOFramework.Message.LoadMessage(TKPMessages.eValidate.VLM0224.ToString())); return; } //== Start to search data. SalesSummaryController ctlInvent = new SalesSummaryController(); //== 20091203 Add by Teerayt S. //NZString yearMonth = GetLatestYearMonthInInvOnhand(); //== 20091203 End Add by Teerayt S. //List<InventorySummaryViewDTO> dtoView = ctlInvent.LoadInventorySummary(yearMonth); //m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView); m_dtAllData = ctlInvent.LoadSalesSummary(dtDateBegin.NZValue); FindDataFromMemory(keyFilter); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }
private void LoadData(NZDateTime dtDateFrom, NZDateTime dtDateTo, string keyFilter) { try { //== Start to search data. SalesSummaryController ctlInvent = new SalesSummaryController(); //== 20091203 Add by Teerayt S. //NZString yearMonth = GetLatestYearMonthInInvOnhand(); //== 20091203 End Add by Teerayt S. //List<InventorySummaryViewDTO> dtoView = ctlInvent.LoadInventorySummary(yearMonth); //m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView); m_dtAllData = ctlInvent.LoadSalesSummary(dtDateBegin.NZValue, dtDateEnd.NZValue); FindDataFromMemory(keyFilter); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } }
private void GeneratePO(NZDateTime dtmFrom, NZDateTime dtmTo, NZString strItemCDFrom, NZString strItemCDTo, NZString strLocCDFrom, NZString strLocCDTo, NZInt iPOInterval) { Database db = null; TmpPurchaseOrderDAO dao = null; try { db = Common.CurrentDatabase; db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); dao = new TmpPurchaseOrderDAO(db); dao.GeneratePO(null, dtmFrom, dtmTo, strItemCDFrom, strItemCDTo, strLocCDFrom, strLocCDTo, Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine, iPOInterval); db.Commit(); } catch (Exception) { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
private void fpView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) { if (shtViewHeader.RowCount <= 0) { return; } NZString strMRPNo = new NZString(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.MRPNo].Value); NZString strItemCD = new NZString(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.ItemCD].Value); NZString strLocCD = new NZString(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.OrderLocCD].Value); NZInt iRevision = new NZInt(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.Revision].Value); DateTime dtm = new DateTime(dtpStartDate.Value.Value.Year, dtpStartDate.Value.Value.Month, 1); NZDateTime dtmPeriodFrom = new NZDateTime(null, (dtm)); MRPBIZ biz = new MRPBIZ(); NZDateTime dtmPeriodTo = biz.GetMaxMRPDate(); MRP030_MRPMaintenance MRP030 = new MRP030_MRPMaintenance(strMRPNo, iRevision, strItemCD, strLocCD, dtmPeriodFrom, dtmPeriodTo); if (MRP030.ShowDialog(null) == DialogResult.OK) { //Load New Data if (!(string.Empty.Equals(txtMRPNo.Text))) { LoadData(txtMRPNo.Text.Trim()); } } }
public ErrorItem CheckIssueDate(NZDateTime IssueDate) { if (IssueDate.IsNull) { return(new ErrorItem(IssueDate.Owner, TKPMessages.eValidate.VLM0031.ToString())); } InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); //NZString YearMonth = new NZString(IssueDate.Owner, IssueDate.StrongValue.ToString("yyyyMM")); InventoryPeriodDTO dto = biz.LoadCurrentPeriod(); if (dto == null) { return(new ErrorItem(IssueDate.Owner, TKPMessages.eValidate.VLM0032.ToString())); } // edit by tar // AddMonths(1) to period end date if (dto.PERIOD_BEGIN_DATE.StrongValue.Date > IssueDate.StrongValue.Date || dto.PERIOD_END_DATE.StrongValue.AddMonths(1).Date < IssueDate.StrongValue.Date) { return(new ErrorItem(IssueDate.Owner, TKPMessages.eValidate.VLM0032.ToString())); } return(null); }
private void fpView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) { if (shtInventorySummary.Rows.Count == 0) { return; } if (shtInventorySummary.ActiveRowIndex < 0) { return; } int ActiveRow = shtInventorySummary.ActiveRowIndex; //NZString YearMonth = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.YEAR_MONTH].Value); //NZString LocationCD = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.LOCATION].Value); //NZString ItemCD = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.ITEM_CODE].Value); //NZString LotNo = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.LOT_NO].Value); //NZString ItemType = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.ITEM_CLS].Value); //NZInt QueryType = new NZInt(null, shtView.Cells[ActiveRow, (int)eColView.QUERY_TYPE].Value); NZDateTime BeginDate = new NZDateTime(null, dtMonth.Value); // Validate period date before show inventory movement //InventoryOnhandInquiryValidator validator = new InventoryOnhandInquiryValidator(); //INV020_InventoryMovementInquiry frmInventoryMovementInquiry = new INV020_InventoryMovementInquiry( // YearMonth, LocationCD, ItemCD, LotNo, BeginDate, EndDate, ItemType, QueryType); //frmInventoryMovementInquiry.ShowDialog(); }
public List <DeliveryViewDTO> Load_OrderMaintenance(NZDateTime DateBegin , NZDateTime DateEnd , NZString CustomerCd , NZString Currency , NZString SlipNo , bool IncludeOldData) { Database db = m_db; DataRequest req = new DataRequest("S_TRN120_OrderMaintenance_Load"); req.CommandType = CommandType.StoredProcedure; req.Parameters.Add("@PERIOD_BEGIN_DATE", DataType.DateTime, CheckNull(DateBegin.StrongValue.Date)); req.Parameters.Add("@PERIOD_END_DATE", DataType.DateTime, CheckNull(DateEnd.StrongValue.Date)); req.Parameters.Add("@CUSTOMER_CD", DataType.NVarChar, CheckNull(CustomerCd.StrongValue)); req.Parameters.Add("@CURRENCY", DataType.NVarChar, CheckNull(Currency.StrongValue)); if (!SlipNo.IsNull) { req.Parameters.Add("@SLIP_NO", DataType.NVarChar, CheckNull(SlipNo.StrongValue)); } ; //not include old value if (!IncludeOldData) { req.Parameters.Add("@OLD_DATA", DataType.Int16, 0); //not include old value } return(db.ExecuteForList <DeliveryViewDTO>(req)); }
public DataTable LoadSalesSummary(Database database, NZDateTime dtDateFrom) { DataTable dtRet = null; Database db = UseDatabase(database); //StringBuilder sb = new StringBuilder(); DataRequest req = new DataRequest(); req.CommandType = CommandType.StoredProcedure; req.CommandText = "S_SUM020_SalesSummaryReport"; req.Parameters.Add("@pDtm_YearMonth", DataType.DateTime, dtDateFrom.Value); DataSet ds = db.ExecuteDataSet(req); if (ds != null && ds.Tables.Count > 0) { dtRet = ds.Tables[0]; } return(dtRet); }
/// <summary> /// /// </summary> /// <param name="yearMonth"></param> /// <param name="locationCD"></param> /// <param name="itemCD"></param> /// <param name="lotNo"></param> /// <param name="periodBeginDate"></param> /// <param name="periodEndDate"></param> public INV020_InventoryMovementInquiry(NZString yearMonth, NZString locationCD, NZString itemCD, NZString lotNo, NZString packNo, NZDateTime periodBeginDate, NZDateTime periodEndDate, NZInt QueryType) { InitializeComponent(); m_yearMonth = yearMonth; m_wareHouseCode = locationCD; m_itemCode = itemCD; m_lotNo = lotNo; m_packNo = packNo; m_periodBeginDate = periodBeginDate; m_periodEndDate = periodEndDate; m_QueryType = QueryType; ItemDTO dtoItem = m_bizItem.LoadItem(itemCD); txtUnitMeasure.Text = string.Empty; if (dtoItem != null) { //ClassListDTO dtoClassList = m_bizClassList.LoadByPK((NZString)DataDefine.UM_CLS, dtoItem.INV_UM_CLS); //if (dtoClassList != null) //{ // txtUnitMeasure.Text = String.Format("{0}{1}{2}", dtoItem.INV_UM_CLS.Value, Common.COMBOBOX_SEPERATOR_SYMBOL, dtoClassList.CLS_DESC.Value); //} } //InitializeScreen(); }
public ErrorItem CheckPackingDate(NZDateTime PackingDate) { if (PackingDate.IsNull) { return(new ErrorItem(PackingDate.Owner, TKPMessages.eValidate.VLM0187.ToString())); } return(null); }
public ErrorItem CheckEmptyStartEffeciveDate(NZDateTime StartEffiveDate) { if (StartEffiveDate.IsNull) { return(new ErrorItem(StartEffiveDate.Owner, TKPMessages.eValidate.VLM0167.ToString())); } return(null); }
public ErrorItem CheckUnpackingDate(NZDateTime UnpackingDate) { if (UnpackingDate.IsNull) { return(new ErrorItem(UnpackingDate.Owner, TKPMessages.eValidate.VLM0216.ToString())); } return(null); }
public ReceivingEntryUIDM() { m_RECEIVE_DATE = new NZDateTime(null, CommonLib.Common.GetDatabaseDateTime()); InventoryTransactionViewDTO dto = new InventoryTransactionViewDTO(); dto.CreateDataTableSchema(out m_dtView); }
public ErrorItem CheckEmptyMoveDate(NZDateTime MoveDate) { if (MoveDate.IsNull) { return(new ErrorItem(MoveDate.Owner, TKPMessages.eValidate.VLM0171.ToString())); } return(null); }
/// <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); }
public ErrorItem CheckEmptyBeginDate(NZDateTime date) { if (date.IsNull) { return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0021.ToString())); } return(null); }
public ErrorItem CheckBetweenDate(NZDateTime fromDate, NZDateTime toDate) { if (toDate.StrongValue.Date.CompareTo(fromDate.StrongValue.Date) < 0) { return(new ErrorItem(toDate.Owner, TKPMessages.eValidate.VLM0023.ToString())); } return(null); }
public MultiWorkResultEntryUIDM() { m_workResultDate = new NZDateTime(null, CommonLib.Common.GetDatabaseDateTime()); m_TRAN_SUB_CLS = (NZString)DataDefine.eTRAN_SUB_CLS.WR.ToString(); MultiWorkResultEntryViewDTO dto = new MultiWorkResultEntryViewDTO(); dto.CreateDataTableSchema(out m_dataView); }
public ErrorItem CheckEmptyPeriodEndDate(NZDateTime PeriodEndDate) { if (PeriodEndDate.IsNull) { return(new ErrorItem(PeriodEndDate.Owner, TKPMessages.eValidate.VLM0022.ToString())); } return(null); }
public DataTable LoadGeneratePO(NZDateTime dtmFrom, NZDateTime dtmTo, NZString strItemCDFrom, NZString strItemCDTo, NZString strLocCDFrom, NZString strLocCDTo, NZInt iPOInterval) { GeneratePO(dtmFrom, dtmTo, strItemCDFrom, strItemCDTo, strLocCDFrom, strLocCDTo, iPOInterval); TmpPurchaseOrderDAO dao = new TmpPurchaseOrderDAO(Common.CurrentDatabase); DataTable dt = dao.LoadTmpGeneratePO(null, Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine); return(dt); }
public ErrorItem CheckEmptyAdjustDate(NZDateTime adjustDate) { if (adjustDate.IsNull) { return(new ErrorItem(adjustDate.Owner, TKPMessages.eValidate.VLM0033.ToString())); } return(null); }
public ErrorItem CheckPeriodBeginToEndDate(NZDateTime PeriodBeginDate, NZDateTime PeriodEndDate) { if (PeriodBeginDate.StrongValue > PeriodEndDate.StrongValue) { return(new ErrorItem(PeriodEndDate.Owner, TKPMessages.eValidate.VLM0023.ToString())); } return(null); }