private NZDecimal GetOnHandQty() { NZDecimal dOnHandQty = new NZDecimal(); try { IssueByItemUIDM uidm = dmcIssueByItem.SaveData(new IssueByItemUIDM()); if (uidm.ITEM_CD.IsNull || uidm.FROM_LOC_CD.IsNull) { return(new NZDecimal()); } IssueConsumptionController ctlIssue = new IssueConsumptionController(); dOnHandQty = ctlIssue.GetOnHandQty(uidm); if (dOnHandQty.IsNull) { return(new NZDecimal()); } return(dOnHandQty); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } return(new NZDecimal()); }
private void OpenIssueScreen(bool CanEdit) { int activeRow = shtView.ActiveRowIndex; IssueByItemUIDM uidm = new IssueByItemUIDM(); uidm.TRANS_ID.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_NO].Text; uidm.REF_NO.Value = shtView.Cells[activeRow, (int)eColView.REF_NO].Text; uidm.ITEM_CD.Value = shtView.Cells[activeRow, (int)eColView.PART_NO].Text; uidm.ITEM_DESC.Value = shtView.Cells[activeRow, (int)eColView.PART_NAME].Text; uidm.FROM_LOC_CD.Value = shtView.Cells[activeRow, (int)eColView.FROM_LOC].Text; uidm.TO_LOC_CD.Value = shtView.Cells[activeRow, (int)eColView.TO_LOC].Text; uidm.LOT_NO.Value = shtView.Cells[activeRow, (int)eColView.LOT_NO].Text; // uidm.ONHAND_QTY.Value = shtView.Cells[activeRow, (int) eColView.TRANS_ID].Text; uidm.QTY.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_QTY].Text; uidm.REMARK.Value = shtView.Cells[activeRow, (int)eColView.REMARK].Text; uidm.TRANS_DATE.Value = Convert.ToDateTime(shtView.Cells[activeRow, (int)eColView.ISSUE_DATE].Value); uidm.TRANS_CLS.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_TYPE].Text; uidm.REF_SLIP_NO.Value = shtView.Cells[activeRow, (int)eColView.REF_SLIP_NO].Text; uidm.REF_SLIP_NO2.Value = shtView.Cells[activeRow, (int)eColView.REF_SLIP_NO2].Text; uidm.FOR_CUSTOMER.Value = shtView.Cells[activeRow, (int)eColView.FOR_CUSTOMER].Text; uidm.FOR_MACHINE.Value = shtView.Cells[activeRow, (int)eColView.FOR_MACHINE].Text; uidm.TRAN_SUB_CLS.Value = shtView.Cells[activeRow, (int)eColView.TRAN_SUB_CLS].Text; TRN140 frmTRN140 = new TRN140(uidm, CanEdit); frmTRN140.ShowDialog(); }
internal NZDecimal GetOnHandQty(IssueByItemUIDM uidmIssue) { InventoryBIZ bizInv = new InventoryBIZ(); ActualOnhandViewDTO dtoInvOnHand; dtoInvOnHand = bizInv.LoadActualInventoryOnHand(uidmIssue.ITEM_CD, uidmIssue.FROM_LOC_CD, uidmIssue.LOT_NO); if (dtoInvOnHand != null) { return(dtoInvOnHand.ONHAND_QTY); } return(new NZDecimal()); }
public TRN140(IssueByItemUIDM uidm, bool CanEdit) { InitializeComponent(); if (CanEdit) { m_Mode = eSaveMode.UPDATE; } else { m_Mode = eSaveMode.VIEW; } m_uidm = uidm; }
internal NZDecimal GetOnHandQty(IssueByItemUIDM uidmIssue) { InventoryBIZ bizInv = new InventoryBIZ(); ActualOnhandViewDTO dtoInvOnHand; //InventoryPeriodBIZ bizPeriod = new InventoryPeriodBIZ(); //NZString YearMonth = bizPeriod.LoadCurrentPeriod().YEAR_MONTH; //new NZString(null, CommonLib.Common.GetDatabaseDateTime().ToString("yyyyMM")); //InventoryPeriodDTO dtoPeriod = bizPeriod.LoadCurrentPeriod(); //if (dtoPeriod == null) return new NZDecimal(); dtoInvOnHand = bizInv.LoadActualInventoryOnHand(uidmIssue.ITEM_CD, uidmIssue.FROM_LOC_CD, uidmIssue.LOT_NO); if (dtoInvOnHand != null) { return(dtoInvOnHand.ONHAND_QTY); } return(new NZDecimal()); }
private bool SaveData() { try { IssueConsumptionController ctlIssue = new IssueConsumptionController(); IssueByItemUIDM uidmIssue = dmcIssueByItem.SaveData(new IssueByItemUIDM()); switch (m_Mode) { case eSaveMode.ADD: ctlIssue.SaveAddIssue(uidmIssue); break; case eSaveMode.UPDATE: uidmIssue.REF_NO.Value = m_REF_NO; uidmIssue.LOT_NO.Value = txtLotNo.Text; ctlIssue.SaveUpdateIssue(uidmIssue); break; } return(true); } catch (ValidateException err) { for (int i = 0; i < err.ErrorResults.Count; i++) { MessageDialog.ShowBusiness(this, err.ErrorResults[i].Message.MessageDescription); err.ErrorResults[i].FocusOnControl(); } } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message.MessageDescription); err.Error.FocusOnControl(); } catch (Exception ex) { MessageDialog.ShowBusiness(this, ex.Message); } return(false); }
internal void SaveAddIssue(IssueByItemUIDM uidmIssue) { List <InventoryTransactionDTO> dtoInvTrnsList = new List <InventoryTransactionDTO>(); InventoryTransactionDTO dtoInvTrns; // = new InventoryTransactionDTO(); InventoryBIZ bizInv = new InventoryBIZ(); //20100311 add by pichet CommonLib.Common.CurrentDatabase.KeepConnection = true; CommonLib.Common.CurrentDatabase.BeginTransaction(IsolationLevel.Serializable); //20100311 end add #region Add New Trans Record RunningNumberBIZ bizRunning = new RunningNumberBIZ(); NZString TransID = bizRunning.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR")); NZString RefID = bizRunning.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR")); NZString ConsumptionID = bizRunning.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR")); // up dtoInvTrns = new InventoryTransactionDTO(); dtoInvTrns.TRANS_ID = TransID; dtoInvTrns.REF_NO = RefID; dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD; dtoInvTrns.LOC_CD = uidmIssue.FROM_LOC_CD; dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO; dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE; if (dtoInvTrns.TRANS_DATE.IsNull) { dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); } dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString(); dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out); dtoInvTrns.QTY = uidmIssue.QTY; dtoInvTrns.REMARK = uidmIssue.REMARK; dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue); dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO; dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2; dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS; dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER; dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE; dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString(); dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString(); dtoInvTrnsList.Add(dtoInvTrns); // down dtoInvTrns = new InventoryTransactionDTO(); dtoInvTrns.TRANS_ID = RefID; dtoInvTrns.REF_NO = TransID; dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD; dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD; dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO; dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE; if (dtoInvTrns.TRANS_DATE.IsNull) { dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); } dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString(); dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.In); dtoInvTrns.QTY = uidmIssue.QTY; dtoInvTrns.REMARK = uidmIssue.REMARK; dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue); dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO; dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2; dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS; dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER; dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE; dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString(); dtoInvTrnsList.Add(dtoInvTrns); // consumption dtoInvTrns = new InventoryTransactionDTO(); dtoInvTrns.TRANS_ID = ConsumptionID; dtoInvTrns.REF_NO = TransID; dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD; dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD; dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO; dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE; if (dtoInvTrns.TRANS_DATE.IsNull) { dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); } dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Consumption).ToNZString(); dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out); dtoInvTrns.QTY = uidmIssue.QTY; dtoInvTrns.REMARK = uidmIssue.REMARK; dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue); dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO; dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2; //dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS; dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER; dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE; dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString(); dtoInvTrnsList.Add(dtoInvTrns); #endregion try { // REWRITE UPDATE STOCK ONHAND METHOD // CHANGE TO USE THE COMMON FUNCTION bizInv.AddInventoryTransactions(CommonLib.Common.CurrentDatabase, dtoInvTrnsList, false); CommonLib.Common.CurrentDatabase.Commit(); } catch (Exception ex) { CommonLib.Common.CurrentDatabase.Rollback(); throw; } finally { if (CommonLib.Common.CurrentDatabase.DBConnectionState == ConnectionState.Open) { CommonLib.Common.CurrentDatabase.Close(); } } }
internal void SaveUpdateIssue(IssueByItemUIDM uidmIssue) { List <InventoryTransactionDTO> dtoInvTrnsList = new List <InventoryTransactionDTO>(); InventoryTransactionDTO dtoInvTrns; // = new InventoryTransactionDTO(); InventoryBIZ bizInv = new InventoryBIZ(); //20100311 add by pichet CommonLib.Common.CurrentDatabase.KeepConnection = true; CommonLib.Common.CurrentDatabase.BeginTransaction(IsolationLevel.Serializable); //20100311 end add #region Add New Trans Record // up dtoInvTrns = new InventoryTransactionDTO(); dtoInvTrns.TRANS_ID = uidmIssue.TRANS_ID; dtoInvTrns.REF_NO = uidmIssue.REF_NO; dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD; dtoInvTrns.LOC_CD = uidmIssue.FROM_LOC_CD; dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO; dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE; if (dtoInvTrns.TRANS_DATE.IsNull) { dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); } dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString(); dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out); dtoInvTrns.QTY = uidmIssue.QTY; dtoInvTrns.REMARK = uidmIssue.REMARK; dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue); dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO; dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2; dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS; dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER; dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE; dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString(); dtoInvTrnsList.Add(dtoInvTrns); // down dtoInvTrns = new InventoryTransactionDTO(); dtoInvTrns.TRANS_ID = uidmIssue.REF_NO; dtoInvTrns.REF_NO = uidmIssue.TRANS_ID; dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD; dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD; dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO; dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE; if (dtoInvTrns.TRANS_DATE.IsNull) { dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); } dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issue_Consumption).ToNZString(); dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.In); dtoInvTrns.QTY = uidmIssue.QTY; dtoInvTrns.REMARK = uidmIssue.REMARK; dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue); dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO; dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2; dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS; dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER; dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE; dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString(); dtoInvTrnsList.Add(dtoInvTrns); // consumption dtoInvTrns = new InventoryTransactionDTO(); dtoInvTrns.TRANS_ID = GetConsumptionTransID(uidmIssue.TRANS_ID);//uidmIssue.REF_NO; dtoInvTrns.REF_NO = uidmIssue.TRANS_ID; dtoInvTrns.ITEM_CD = uidmIssue.ITEM_CD; dtoInvTrns.LOC_CD = uidmIssue.TO_LOC_CD; dtoInvTrns.LOT_NO = uidmIssue.LOT_NO.StrongValue.Trim() == string.Empty ? new NZString() : uidmIssue.LOT_NO; dtoInvTrns.TRANS_DATE = uidmIssue.TRANS_DATE; if (dtoInvTrns.TRANS_DATE.IsNull) { dtoInvTrns.TRANS_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); } dtoInvTrns.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Consumption).ToNZString(); dtoInvTrns.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out); dtoInvTrns.QTY = uidmIssue.QTY; dtoInvTrns.REMARK = uidmIssue.REMARK; dtoInvTrns.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.CRT_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoInvTrns.UPD_DATE.Value = CommonLib.Common.GetDatabaseDateTime(); dtoInvTrns.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoInvTrns.REF_SLIP_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue); dtoInvTrns.REF_SLIP_NO = uidmIssue.REF_SLIP_NO; dtoInvTrns.REF_SLIP_NO2 = uidmIssue.REF_SLIP_NO2; //dtoInvTrns.TRAN_SUB_CLS = uidmIssue.TRAN_SUB_CLS; dtoInvTrns.FOR_CUSTOMER = uidmIssue.FOR_CUSTOMER; dtoInvTrns.FOR_MACHINE = uidmIssue.FOR_MACHINE; dtoInvTrns.SCREEN_TYPE = DataDefine.ScreenType.IssueConsumption.ToNZString(); dtoInvTrnsList.Add(dtoInvTrns); #endregion #region Update OnHand Stock #endregion try { bizInv.UpdateInventoryTransactions(CommonLib.Common.CurrentDatabase, dtoInvTrnsList);//, dtoInvOnHandList); CommonLib.Common.CurrentDatabase.Commit(); } catch (Exception err) { CommonLib.Common.CurrentDatabase.Rollback(); throw; } finally { if (CommonLib.Common.CurrentDatabase.DBConnectionState == ConnectionState.Open) { CommonLib.Common.CurrentDatabase.Close(); } } }