private ErrorItem CheckCanRunProcess() { try { // get year month InventoryPeriodBIZ bizPeriod = new InventoryPeriodBIZ(); InventoryPeriodDTO dtoPeriod = bizPeriod.LoadCurrentPeriod(); if (!dtoPeriod.YEAR_MONTH.StrongValue.Equals(Convert.ToDateTime(dtpStockTakingDate.Value).ToString("yyyyMM"))) { return(new ErrorItem(null, TKPMessages.eValidate.VLM0084.ToString(), new[] { "" })); } if (Convert.ToDateTime(dtpLastSTKDate.DateValue) > Convert.ToDateTime(dtpStockTakingDate.Value)) { return(new ErrorItem(null, TKPMessages.eValidate.VLM0084.ToString(), new[] { "" })); } } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } return(null); }
private void InitializeScreen() { InitializeSpread(); InitialFormat(); //txt.KeyPress += CommonLib.CtrlUtil.SetRestrictKeyInput; //txtSearch.KeyPress += CommonLib.CtrlUtil.SetRestrictKeyInput; //txtSearch.TextChanged += CommonLib.CtrlUtil.FilterRestrictChar; dtPeriodBegin.KeyPress += CtrlUtil.SetNextControl; dtPeriodEnd.KeyPress += CtrlUtil.SetNextControl; dtPeriodBegin.Format = Common.CurrentUserInfomation.DateFormatString; dtPeriodEnd.Format = Common.CurrentUserInfomation.DateFormatString; CtrlUtil.EnabledControl(false, txtAmount, txtAmountTHB, txtQty); InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriodWithQueryRange(); if (dto != null) { dtPeriodBegin.Value = dto.PERIOD_BEGIN_DATE.StrongValue; dtPeriodEnd.Value = dto.PERIOD_END_DATE.StrongValue; } }
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); }
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> /// Update record by using the table's primary key. /// </summary> /// <param name="database"></param> /// <param name="data">Data which to update.</param> /// <param name="oldYEAR_MONTH">Old Key #1</param> /// <returns></returns> public int UpdateWithPK(Database database, InventoryPeriodDTO data, NZString oldYEAR_MONTH) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + InventoryPeriodDTO.eColumns.YEAR_MONTH + "=:YEAR_MONTH"); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.PERIOD_BEGIN_DATE + "=:PERIOD_BEGIN_DATE"); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.PERIOD_END_DATE + "=:PERIOD_END_DATE"); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + InventoryPeriodDTO.eColumns.YEAR_MONTH + "=:oldYEAR_MONTH"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("YEAR_MONTH", DataType.NVarChar, data.YEAR_MONTH.Value); req.Parameters.Add("PERIOD_BEGIN_DATE", DataType.DateTime, data.PERIOD_BEGIN_DATE.Value); req.Parameters.Add("PERIOD_END_DATE", DataType.DateTime, data.PERIOD_END_DATE.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); req.Parameters.Add("oldYEAR_MONTH", DataType.NVarChar, oldYEAR_MONTH.Value); #endregion return(db.ExecuteNonQuery(req)); }
private void InitialScreen() { InitailSpread(); InitialComboBox(); tsbNew.Visible = false; tsSeperator1.Visible = false; //txtSearch.KeyPress += CommonLib.CtrlUtil.SetRestrictKeyInput; //txtSearch.KeyUp += CommonLib.CtrlUtil.FilterRestrictChar; dtPeriodBegin.Format = Common.CurrentUserInfomation.DateFormatString; dtPeriodEnd.Format = Common.CurrentUserInfomation.DateFormatString; //NZString YearMonth = new NZString(null, Common.GetDatabaseDateTime().ToString("yyyyMM")); InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriod(); if (dto != null) { dtPeriodBegin.Value = dto.PERIOD_BEGIN_DATE.StrongValue; dtPeriodEnd.Value = dto.PERIOD_END_DATE.StrongValue; } LoadData(); dtPeriodBegin.Focus(); }
private void InitialScreen() { picWaiting.Visible = false; switch (CommonLib.Common.CurrentUserInfomation.DateFormat) { case eDateFormat.DMY: case eDateFormat.MDY: dtInventoryMonth.Format = "MM/yyyy"; break; case eDateFormat.YMD: dtInventoryMonth.Format = "yyyy/MM"; break; } 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); dtInventoryMonth.DateValue = currentYearMonth; CommonLib.CtrlUtil.EnabledControl(false, txtInfo, dtInventoryMonth); }
private void LoadDefaultPeriod() { InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriod(); dtMonth.NZValue = dto.PERIOD_BEGIN_DATE; }
private void LoadDefaultPeriod() { InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriodWithQueryRange(); dtPeriodBegin.NZValue = dto.PERIOD_BEGIN_DATE; dtPeriodEnd.NZValue = dto.PERIOD_END_DATE; }
private void LoadItemData(string keyFilter) { //set ให้ show column ทั้งหมด shtView.Columns[0, shtView.Columns.Count - 1].Visible = true; InventoryPeriodBIZ inventoryPeriodBIZ = new InventoryPeriodBIZ(); InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodBIZ.LoadCurrentPeriod(); DataTable dt = null; InventoryBIZ inventoryBIZ = new InventoryBIZ(); if (m_searchType == eSearchType.All) { dt = inventoryBIZ.LoadAllLotNo(inventoryPeriodDTO.YEAR_MONTH); shtView.Columns[(int)eColView.ON_HAND_QTY].Visible = false; } else if (m_searchType == eSearchType.DependOnItemAndLocation) { dt = inventoryBIZ.LoadAllLotNoByItemAndLocation(inventoryPeriodDTO.YEAR_MONTH, m_itemCode, m_locationCode); } else { dt = inventoryBIZ.LoadAllLotNo(inventoryPeriodDTO.YEAR_MONTH); shtView.Columns[(int)eColView.ON_HAND_QTY].Visible = false; } DataTable dtView = dt.Clone(); if (keyFilter != string.Empty) { // string filterString = string.Format(@" // {1} LIKE '%{0}%' // OR {2} LIKE '%{0}%' // ", keyFilter, eColView.LOT_NO, eColView.PACK_NO); string filterString = FilterStringUtil.GetFilterstring(dtView, keyFilter); //get only the rows you want DataRow[] results = dt.Select(filterString); //populate new destination table foreach (DataRow dr in results) { dtView.ImportRow(dr); } } else { foreach (DataRow dr in dt.Rows) { dtView.ImportRow(dr); } } fpView.DataSource = dtView; }
/// <summary> /// Check exist before manipulate data. If found record will update data. Otherwise insert new data. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNewOrUpdate(Database database, InventoryPeriodDTO data) { Database db = UseDatabase(database); if (Exist(database, data.YEAR_MONTH)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
public int UpdatePeriod(InventoryPeriodDTO dto) { // check exist before add new InventoryPeriodValidator val = new InventoryPeriodValidator(); val.ValidateBeforeSaveUpdate(dto); InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase); List <InventoryPeriodDTO> dtoInvPeriodList = dao.LoadAll(null, true); return(dao.UpdateWithPK(null, dto, dtoInvPeriodList[0].YEAR_MONTH)); }
public ErrorItem CheckCurrentPeriod(NZString YearMonth) { InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriod(); if (dto.YEAR_MONTH.StrongValue != YearMonth.StrongValue) { return(new ErrorItem(null, TKPMessages.eValidate.VLM0078.ToString())); } return(null); }
private NZString GetYearMonth(DateTime?dtDate) { InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadPeriodByDate(new NZDateTime(null, dtDate.Value)); if (dto == null) { return(new NZString(null, dtDate.Value.ToString("yyyyMM"))); } return(dto.YEAR_MONTH); }
private void TRN010_Load(object sender, EventArgs e) { InitializeScreen(); InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriodWithQueryRange(); dtPeriodBegin.NZValue = dto.PERIOD_BEGIN_DATE; dtPeriodEnd.NZValue = dto.PERIOD_END_DATE; LoadData(dto.PERIOD_BEGIN_DATE, dto.PERIOD_END_DATE); }
public AdjustmentEntryUIDM ConvertDTOToUIDM(InventoryTransactionDTO dto) { AdjustmentEntryUIDM model = new AdjustmentEntryUIDM(); model.TransactionID = dto.TRANS_ID; model.AdjustNo = dto.SLIP_NO; model.AdjustDate = dto.TRANS_DATE; model.AdjustType = dto.IN_OUT_CLS; model.ItemCode = dto.ITEM_CD; model.StoredLoc = dto.LOC_CD; model.LotNo = dto.LOT_NO; model.PackNo = dto.PACK_NO; model.FGNo = dto.FG_NO; model.ExternalLotNo = dto.EXTERNAL_LOT_NO; model.AdjustWeight = dto.WEIGHT; model.AdjustQty = dto.QTY; model.Remark = dto.REMARK; model.ReasonCode = dto.TRAN_SUB_CLS; //== Get Item Description. ItemBIZ biz = new ItemBIZ(); ItemDTO itemDTO = biz.LoadItem(dto.ITEM_CD); model.ItemDesc = itemDTO.SHORT_NAME; //-- Get Customer Name DealingBIZ bizCust = new DealingBIZ(); DealingDTO dtoCust = bizCust.LoadLocation(itemDTO.CUSTOMER_CD); model.CustomerName = dtoCust.LOC_DESC; //== Get OnHand. InventoryBIZ inventoryBIZ = new InventoryBIZ(); InventoryPeriodBIZ inventoryPeriodBIZ = new InventoryPeriodBIZ(); InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodBIZ.LoadCurrentPeriod(); InventoryOnhandDTO inventoryOnhandDTO = inventoryBIZ.LoadInventoryOnHandByDate(inventoryPeriodDTO.YEAR_MONTH, dto.TRANS_DATE, dto.ITEM_CD, dto.LOC_CD, dto.LOT_NO, dto.PACK_NO); if (inventoryOnhandDTO == null) { model.OnHandQty.Value = 0; } else { model.OnHandQty = inventoryOnhandDTO.ON_HAND_QTY; } return(model); }
private void RollingStart(eMonthlyCloseProcess ProcessType) { try { NZString YearMonth = Convert.ToDateTime(dtInventoryMonth.DateValue).ToString("yyyyMM").ToNZString(); InventoryPeriodValidator val = new InventoryPeriodValidator(); //val.CheckBeforeRunProcess(ProcessType); ErrorItem err = val.CheckBeforeRunClosingProcess(ProcessType, YearMonth); if (err != null) { MessageDialogResult cf = MessageDialog.ShowConfirmation(this, EVOFramework.Message.LoadMessage(TKPMessages.eValidate.VLM0076.ToString()).MessageDescription, MessageDialogButtons.YesNo); if (cf != MessageDialogResult.Yes) { return; } } MessageDialogResult dr = MessageDialog.ShowConfirmation(this, new EVOFramework.Message(TKPMessages.eConfirm.CFM0005.ToString()).MessageDescription, MessageDialogButtons.YesNo); if (dr == MessageDialogResult.Yes) { if (RunProcess(ProcessType)) { MessageDialog.ShowBusiness(this, EVOFramework.Message.LoadMessage(SystemMaintenance.Messages.eInformation.INF9003.ToString())); } 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); dtInventoryMonth.DateValue = currentYearMonth; } } 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); } }
/// <summary> /// check ว่ามีการทำ inventory move หรือยัง /// </summary> /// <returns></returns> public ErrorItem CheckInventoryCurrentPeriod() { InventoryPeriodBIZ bizInventoryPeriod = new InventoryPeriodBIZ(); InventoryPeriodDTO dtoInventoryPeriod = bizInventoryPeriod.LoadCurrentPeriod(); if (IsInDateRange(dtoInventoryPeriod.PERIOD_BEGIN_DATE.StrongValue, dtoInventoryPeriod.PERIOD_END_DATE.StrongValue , CommonLib.Common.GetDatabaseDateTime())) { return(null); } return(new ErrorItem(null, SystemMaintenance.Messages.eInformation.INF9005.ToString())); //return false; }
/// <summary> /// Check if date is between date range of current period? /// </summary> /// <param name="checkDate"></param> /// <returns></returns> public ErrorItem DateIsInCurrentPeriod(DateTime checkDate) { InventoryPeriodBIZ bizInventoryPeriod = new InventoryPeriodBIZ(); InventoryPeriodDTO dtoInventoryPeriod = bizInventoryPeriod.LoadCurrentPeriod(); if (dtoInventoryPeriod.PERIOD_BEGIN_DATE.StrongValue > checkDate.Date || dtoInventoryPeriod.PERIOD_END_DATE.StrongValue.AddMonths(1).Date < checkDate.Date) { //return new ErrorItem(null, Message.LoadMessage(TKPMessages.eValidate.VLM0075.ToString()).MessageDescription); return(new ErrorItem(null, TKPMessages.eValidate.VLM0075.ToString())); } //IsInDateRange(dtoInventoryPeriod.PERIOD_BEGIN_DATE.StrongValue, // dtoInventoryPeriod.PERIOD_END_DATE.StrongValue.AddMonths(1) // , checkDate) return(null); }
/// <summary> /// Load lookup for lot number by item and location code /// If these lot no has no onhand qty will be supressed. /// </summary> /// <param name="ItemCD"></param> /// <param name="LocationCD"></param> /// <returns></returns> public LookupData LoadLookupLotNo(NZString ItemCD, NZString LocationCD, NZString YearMonth) { InventoryOnhandDAO dao = new InventoryOnhandDAO(CommonLib.Common.CurrentDatabase); InventoryPeriodBIZ inventoryPeriodBIZ = new InventoryPeriodBIZ(); InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodBIZ.LoadCurrentPeriod(); List <InventoryOnhandDTO> listOnhand = dao.LoadLotNoWithHasOnhandQty(null, YearMonth, inventoryPeriodDTO.YEAR_MONTH, ItemCD, LocationCD); DataTable dt = DTOUtility.ConvertListToDataTable(listOnhand); LookupData lookupData = new LookupData(dt, InventoryOnhandDTO.eColumns.LOT_NO.ToString(), InventoryOnhandDTO.eColumns.LOT_NO.ToString()); return(lookupData); }
internal int UpdatePeriod(NZString YearMonth, NZDateTime PeriodBegin, NZDateTime PeriodEnd) { InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = new InventoryPeriodDTO(); dto.YEAR_MONTH = YearMonth; dto.PERIOD_BEGIN_DATE = PeriodBegin; dto.PERIOD_END_DATE = PeriodEnd; dto.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dto.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dto.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dto.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; return(biz.UpdatePeriod(dto)); }
//public ErrorItem CheckInputLot(NZString itemCode, NZString lotNo) { // ItemBIZ biz = new ItemBIZ(); // ItemDTO dto = biz.LoadItem(itemCode); // switch (DataDefine.ConvertValue2Enum<DataDefine.eLOT_CONTROL_CLS>(dto.LOT_CONTROL_CLS.StrongValue)) { // case DataDefine.eLOT_CONTROL_CLS.No: // if (!lotNo.IsNull || lotNo.StrongValue != string.Empty) { // return new ErrorItem(lotNo.Owner, TKPMessages.eValidate.VLM0065.ToString()); // } // break; // case DataDefine.eLOT_CONTROL_CLS.Yes: // if (lotNo.IsNull || lotNo.StrongValue.Trim() == String.Empty) { // return new ErrorItem(lotNo.Owner, TKPMessages.eValidate.VLM0050.ToString(), new object[] { itemCode.StrongValue }); // } // break; // } // return null; //} #endregion public ErrorItem CheckAdjustDateIsInCurrentPeriod(NZDateTime adjustDate) { InventoryPeriodDAO inventoryPeriodDAO = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase); InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodDAO.LoadCurrentYearMonth(null); if (inventoryPeriodDTO == null) { return(new ErrorItem(adjustDate.Owner, TKPMessages.eValidate.VLM0034.ToString())); } if (inventoryPeriodDTO.PERIOD_BEGIN_DATE.StrongValue.Date > adjustDate.StrongValue.Date || inventoryPeriodDTO.PERIOD_END_DATE.StrongValue.AddMonths(1).Date < adjustDate.StrongValue.Date) { return(new ErrorItem(adjustDate.Owner, TKPMessages.eValidate.VLM0034.ToString())); } return(null); }
/// <summary> /// Explosion BOM for retrieve list child items of specific ITEM_CD on level one. /// </summary> /// <param name="ITEM_CD">Parent Item Code which want to explosion child BOM.</param> /// <param name="ORDER_LOC">Location of order.</param> /// <param name="QTY">Quantity of work result.</param> /// <returns>List of WorkResultEntryViewDTO</returns> public List <WorkResultEntryViewDTO> LoadConsumptionListByExplosionBOM(Database database, NZString ITEM_CD, NZString ORDER_LOC, NZDecimal QTY) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); InventoryPeriodDAO periodDao = new InventoryPeriodDAO(db); InventoryPeriodDTO periodDto = periodDao.LoadCurrentYearMonth(null); #region SQL Statement //sb.AppendLine(" SELECT T.*, T.REQUEST_QTY " + WorkResultEntryViewDTO.eColumns.CONSUMPTION_QTY); //sb.AppendLine(" FROM ( "); //sb.AppendLine(" SELECT "); //sb.AppendLine(" T_BOM.LOWER_ITEM_CD " + WorkResultEntryViewDTO.eColumns.ITEM_CD); //sb.AppendLine(" ,L_ITM.LOT_CONTROL_CLS " + WorkResultEntryViewDTO.eColumns.LOT_CONTROL_CLS); //sb.AppendLine(" ,:ORDER_LOC LOC_CD "); //sb.AppendLine(" ,NULL " + WorkResultEntryViewDTO.eColumns.LOT_NO); //sb.AppendLine(" ,ISNULL(STK.ON_HAND_QTY, 0) " + WorkResultEntryViewDTO.eColumns.ON_HAND_QTY); //sb.AppendLine(" ,(T_BOM.LOWER_QTY / T_BOM.UPPER_QTY) * :WO_QTY " + WorkResultEntryViewDTO.eColumns.REQUEST_QTY); ////sb.AppendLine(" ,T_BOM.LOWER_QTY " + WorkResultEntryViewDTO.eColumns.LOWER_QTY); ////sb.AppendLine(" ,T_BOM.UPPER_QTY " + WorkResultEntryViewDTO.eColumns.UPPER_QTY); //sb.AppendLine(" ,L_ITM.INV_UM_CLS INV_UM_CLS"); //sb.AppendLine(" ,T_BOM." + WorkResultEntryViewDTO.eColumns.CHILD_ORDER_LOC_CD.ToString() + " " + WorkResultEntryViewDTO.eColumns.CHILD_ORDER_LOC_CD); //sb.AppendLine(" FROM "); //sb.AppendLine(" FNC_GET_BOM_EXPLOSION( :ITEM_CD, 0, '', '~') T_BOM"); //sb.AppendLine(" INNER JOIN TB_ITEM_MS L_ITM"); //sb.AppendLine(" ON L_ITM.ITEM_CD = T_BOM.LOWER_ITEM_CD"); //sb.AppendLine(" LEFT JOIN TB_INV_ONHAND_TR STK"); //sb.AppendLine(" ON STK.ITEM_CD = T_BOM.LOWER_ITEM_CD"); //sb.AppendLine(" AND STK.LOC_CD = :ORDER_LOC"); //sb.AppendLine(" AND ISNULL(STK.LOT_NO, '') = '' "); //sb.AppendLine(" AND STK.YEAR_MONTH=:YEAR_MONTH "); //sb.AppendLine(" WHERE T_BOM.LEVEL = 1"); //sb.AppendLine(" ) T "); //sb.AppendLine(" ORDER BY T.ITEM_CD"); #endregion DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("ITEM_CD", DataType.NVarChar, ITEM_CD.Value); req.Parameters.Add("ORDER_LOC", DataType.NVarChar, ORDER_LOC.Value); req.Parameters.Add("WO_QTY", DataType.Number, QTY.Value); req.Parameters.Add("YEAR_MONTH", DataType.NVarChar, periodDto.YEAR_MONTH.Value); return(db.ExecuteForList <WorkResultEntryViewDTO>(req)); }
private void PUR010_Load(object sender, EventArgs e) { InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriodWithQueryRange(); dtPeriodBegin.NZValue = dto.PERIOD_BEGIN_DATE; dtPeriodEnd.NZValue = dto.PERIOD_END_DATE; dtPeriodBegin.Format = Common.CurrentUserInfomation.DateFormatString; dtPeriodEnd.Format = Common.CurrentUserInfomation.DateFormatString; shtView.Columns[(int)eColumn.DUE_DATE].CellType = CtrlUtil.CreateDateTimeCellType(); shtView.Columns[(int)eColumn.PO_DATE].CellType = CtrlUtil.CreateDateTimeCellType(); this.m_dtShown = m_BizPurchaseOrder.LoadPurchaseOrderDByPONo(Convert.ToDateTime(dtPeriodBegin.Value), Convert.ToDateTime(dtPeriodEnd.Value)); ShowSheet(this.m_dtShown); SetSpreadBGColor(); SetContextMenu(); }
/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, InventoryPeriodDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + InventoryPeriodDTO.eColumns.YEAR_MONTH); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.PERIOD_BEGIN_DATE); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.PERIOD_END_DATE); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.CRT_BY); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.UPD_BY); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + InventoryPeriodDTO.eColumns.UPD_MACHINE); sb.AppendLine(") VALUES("); sb.AppendLine(" :YEAR_MONTH"); sb.AppendLine(" ,:PERIOD_BEGIN_DATE"); sb.AppendLine(" ,:PERIOD_END_DATE"); sb.AppendLine(" ,:CRT_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:CRT_MACHINE"); sb.AppendLine(" ,:UPD_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:UPD_MACHINE"); sb.AppendLine(" )"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("YEAR_MONTH", DataType.NVarChar, data.YEAR_MONTH.Value); req.Parameters.Add("PERIOD_BEGIN_DATE", DataType.DateTime, data.PERIOD_BEGIN_DATE.Value); req.Parameters.Add("PERIOD_END_DATE", DataType.DateTime, data.PERIOD_END_DATE.Value); req.Parameters.Add("CRT_BY", DataType.NVarChar, data.CRT_BY.Value); req.Parameters.Add("CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); #endregion return(db.ExecuteNonQuery(req)); }
public List <MultiWorkResultEntryViewDTO> LoadChildItemToInputMultiWorkResult(Database database, NZString ITEM_CD, NZString ORDER_LOC, NZString LOT_NO, DataDefine.eTRAN_SUB_CLS workResultType) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); InventoryPeriodDAO periodDao = new InventoryPeriodDAO(db); InventoryPeriodDTO periodDto = periodDao.LoadCurrentYearMonth(null); #region SQL Statement sb.AppendLine(@"select stk.LOT_NO, stk.ON_HAND_QTY "); sb.AppendLine(@"from TB_INV_ONHAND_TR stk"); sb.AppendLine(@"where (STK.LOC_CD = :ORDER_LOC)"); sb.AppendLine(@"and (STK.YEAR_MONTH = :YEAR_MONTH)"); sb.AppendLine(@"and (STK.ITEM_CD = :ITEM_CD)"); sb.AppendLine(@"and (STK.ON_HAND_QTY > 0)"); sb.AppendLine(@"and (STK.LOT_NO like :LOT_NO + '%' or :LOT_NO is null)"); if (workResultType == DataDefine.eTRAN_SUB_CLS.WR) { sb.AppendLine(@"and (STK.LOT_NO not like '%#R')"); //work result หา lot ปกติ } else if (workResultType == DataDefine.eTRAN_SUB_CLS.RW) { sb.AppendLine(@"and (STK.LOT_NO like '%#R')"); //rework หา lot ที่เป็น reserve } else { throw new NotSupportedException(); } #endregion DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("ITEM_CD", DataType.NVarChar, ITEM_CD.Value); req.Parameters.Add("ORDER_LOC", DataType.NVarChar, ORDER_LOC.Value); req.Parameters.Add("YEAR_MONTH", DataType.NVarChar, periodDto.YEAR_MONTH.Value); req.Parameters.Add("LOT_NO", DataType.VarChar, LOT_NO.Value); return(db.ExecuteForList <MultiWorkResultEntryViewDTO>(req)); }
private void InitializeScreen() { InitializeSpread(); //txtSearch.KeyPress += CommonLib.CtrlUtil.SetRestrictKeyInput; //txtSearch.KeyUp += CommonLib.CtrlUtil.FilterRestrictChar; dtPeriodBegin.KeyPress += CtrlUtil.SetNextControl; dtPeriodEnd.KeyPress += CtrlUtil.SetNextControl; dtPeriodBegin.Format = Common.CurrentUserInfomation.DateFormatString; dtPeriodEnd.Format = Common.CurrentUserInfomation.DateFormatString; InventoryPeriodBIZ biz = new InventoryPeriodBIZ(); InventoryPeriodDTO dto = biz.LoadCurrentPeriodWithQueryRange(); dtPeriodBegin.NZValue = dto.PERIOD_BEGIN_DATE; dtPeriodEnd.NZValue = dto.PERIOD_END_DATE; LoadData(dto.PERIOD_BEGIN_DATE, dto.PERIOD_END_DATE); }
public void ValidateBeforeSaveUpdate(InventoryPeriodDTO dtoInven) { ValidateException validateException = new ValidateException(); ErrorItem errorItem = null; #region mandatory check errorItem = CheckEmptyYearMonth(dtoInven.YEAR_MONTH); if (errorItem != null) { validateException.AddError(errorItem); } errorItem = CheckEmptyPeriodBeginDate(dtoInven.PERIOD_BEGIN_DATE); if (errorItem != null) { validateException.AddError(errorItem); } errorItem = CheckEmptyPeriodEndDate(dtoInven.PERIOD_END_DATE); if (errorItem != null) { validateException.AddError(errorItem); } errorItem = CheckPeriodBeginToEndDate(dtoInven.PERIOD_BEGIN_DATE, dtoInven.PERIOD_END_DATE); if (errorItem != null) { validateException.AddError(errorItem); } validateException.ThrowIfHasError(); //BusinessException businessException = CheckInventPeriod(dtoInven.YEAR_MONTH); //if (businessException != null) //{ // throw businessException; //} #endregion }
/// <summary> /// Check empty and not in current period. /// </summary> /// <param name="date"></param> /// <returns></returns> public ErrorItem CheckReceiveDate(NZDateTime date) { if (date.IsNull) { return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0041.ToString())); } // Check in using period. InventoryPeriodBIZ inventoryPeriodBIZ = new InventoryPeriodBIZ(); InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodBIZ.LoadCurrentPeriod(); InventoryPeriodValidator inventoryPeriodValidator = new InventoryPeriodValidator(); // fix by tar // AddMonths(1) to period end date if (date.StrongValue.Date < inventoryPeriodDTO.PERIOD_BEGIN_DATE.StrongValue.Date || date.StrongValue.Date > inventoryPeriodDTO.PERIOD_END_DATE.StrongValue.AddMonths(1).Date) { return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0042.ToString())); } return(null); }
public int UpdateInventoryPeriod(Database database, InventoryPeriodDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); sb.AppendLine(" update TB_INV_PERIOD_MS "); sb.AppendLine(" set YEAR_MONTH = :pYEAR_MONTH "); sb.AppendLine(" ,PERIOD_BEGIN_DATE = :pPERIOD_BEGIN_DATE "); sb.AppendLine(" ,PERIOD_END_DATE = :pPERIOD_END_DATE "); sb.AppendLine(" ,UPD_BY =:pUPD_BY "); sb.AppendLine(" ,UPD_DATE = getdate() "); sb.AppendLine(" ,UPD_MACHINE = :pUPD_MACHINE; "); DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("pYEAR_MONTH", DataType.NVarChar, data.YEAR_MONTH.Value); req.Parameters.Add("pPERIOD_BEGIN_DATE", DataType.DateTime, data.PERIOD_BEGIN_DATE.Value); req.Parameters.Add("pPERIOD_END_DATE", DataType.DateTime, data.PERIOD_END_DATE.Value); req.Parameters.Add("pUPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("pUPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); return(db.ExecuteNonQuery(req)); }