public void SimulateMRP(ProcessDTO dtoProcess, GenerateMRPDTO dtoGen) { Database db = null; try { db = Common.CurrentDatabase; db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); ProcessDAO dao = new ProcessDAO(db); dao.SimulateMRP(null, dtoProcess.PROCESS_NO, dtoGen); db.Commit(); } catch (Exception) { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
private void btnSourceOrder_Click(object sender, EventArgs e) { MRPBIZ bizMRP = new MRPBIZ(); GenerateMRPDTO dtoMRP = new GenerateMRPDTO(); dtoMRP.START_DATE = (NZDateTime)dtpStartDate.Value; dtoMRP.RECOVER_DURATION = (NZInt)bizMRP.GetDefaultRecoverDuration(); dtoMRP.ITEM_FLAG = (NZBoolean)chkItemFlag.Checked; dtoMRP.ITEM_CD_FROM = (NZString)txtItemCodeFrom.Text.Trim(); dtoMRP.ITEM_CD_TO = (NZString)txtItemCodeTo.Text.Trim(); MRP011_SourceOrder MRP011 = new MRP011_SourceOrder(dtoMRP); MRP011.ShowDialog(this); }
private void InitialData(GenerateMRPDTO dto) { ClearControl(); txtStartDate.Text = ((DateTime)dto.START_DATE.Value).ToString(Common.CurrentUserInfomation.DateFormatString); txtItemFrom.Text = dto.ITEM_CD_FROM; txtItemTo.Text = dto.ITEM_CD_TO; DemandOrderBIZ biz = new DemandOrderBIZ(); DataTable dt = biz.LoadSourceOrderSummaryEachMonth(dto); if (dt != null && dt.Rows.Count > 0) { BindData(dt); } }
public DataTable LoadSourceOrderSummaryEachMonth(Database database, GenerateMRPDTO dto, string strDateFormat) { Database db = UseDatabase(database); DataRequest req = new DataRequest(); req.CommandText = "S_MRP010_LoadSourceOrderSumByMonth"; req.CommandType = CommandType.StoredProcedure; req.Parameters.Add("@pDtm_StartDate", DataType.DateTime, dto.START_DATE.Value); if (dto.ITEM_FLAG) { req.Parameters.Add("@pVar_ItemCodeFrom", DataType.NVarChar, dto.ITEM_CD_FROM.Value); req.Parameters.Add("@pVar_ItemCodeTo", DataType.NVarChar, dto.ITEM_CD_TO.Value); } req.Parameters.Add("@pVar_DATE_FORMAT", DataType.NVarChar, strDateFormat); return(db.ExecuteQuery(req)); }
public int SimulateMRP(Database database, string strMRP_NO, GenerateMRPDTO dto) { Database db = UseDatabase(database); DataRequest req = new DataRequest(); req.CommandText = "S_MRP010_SimulateMRP"; req.CommandType = CommandType.StoredProcedure; req.Parameters.Add("@pVar_MRP_NO", DataType.NVarChar, strMRP_NO); req.Parameters.Add("@pDtm_START_DATE", DataType.DateTime, dto.START_DATE.Value); req.Parameters.Add("@pINT_RECOVER_DURATION", DataType.Int32, dto.RECOVER_DURATION.Value); if (dto.ITEM_FLAG) { req.Parameters.Add("@pVar_ITEM_CD_FROM", DataType.NVarChar, dto.ITEM_CD_FROM.Value); req.Parameters.Add("@pVar_ITEM_CD_TO", DataType.NVarChar, dto.ITEM_CD_TO.Value); } req.Parameters.Add("@pVar_USER_CD", DataType.NVarChar, dto.USER_CD.Value); req.Parameters.Add("@pVar_MACHINE", DataType.NVarChar, dto.MACHINE.Value); return(db.ExecuteNonQuery(req)); }
private bool RunProcess() { MRPBIZ bizMRP = new MRPBIZ(); ProcessDTO dtoProcess = new ProcessDTO(); dtoProcess.PROCESS_NO = (NZString)m_strMRPNo; dtoProcess.PROCESS_TYPE = (NZString)CONST_STR_PROCESS_NAME; dtoProcess.STATUS = (NZString)"S"; dtoProcess.DESCRIPTION = (NZString)txtRemark.Text.Trim(); dtoProcess.START_PRCS_TIME = (NZDateTime)DateTime.Now; dtoProcess.END_PRCS_TIME = null; dtoProcess.FILTER_TIMESTAMP = (NZDateTime)DateTime.Now; dtoProcess.FILE_NAME = null; dtoProcess.MD5SUM = null; dtoProcess.IS_CANCEL = (NZDecimal)0; dtoProcess.CANCEL_DATE = null; dtoProcess.CANCEL_BY = null; dtoProcess.CANCEL_MACHINE = null; dtoProcess.PROCESS_DATE = (NZDateTime)DateTime.Now.Date; dtoProcess.PROCESS_BY = (NZString)Common.CurrentUserInfomation.UserCD; dtoProcess.PROCESS_MACHINE = (NZString)Common.CurrentUserInfomation.Machine; dtoProcess.RESERVE1 = null; dtoProcess.RESERVE2 = null; GenerateMRPDTO dtoMRP = new GenerateMRPDTO(); dtoMRP.START_DATE = (NZDateTime)dtpStartDate.Value; dtoMRP.RECOVER_DURATION = (NZInt)bizMRP.GetDefaultRecoverDuration(); dtoMRP.ITEM_FLAG = (NZBoolean)chkItemFlag.Checked; dtoMRP.ITEM_CD_FROM = (NZString)txtItemCodeFrom.Text.Trim(); dtoMRP.ITEM_CD_TO = (NZString)txtItemCodeTo.Text.Trim(); dtoMRP.USER_CD = Common.CurrentUserInfomation.UserCD; dtoMRP.MACHINE = Common.CurrentUserInfomation.Machine; bizMRP.SimulateMRP(dtoProcess, dtoMRP); return(true); }
public void SimulateMRP(ProcessDTO dtoProcess, GenerateMRPDTO dtoGen) { //Database db = null; ProcessBIZ bizProcess = null; try { CheckBeforeSimulate(); bizProcess = new ProcessBIZ(); //Insert Process Transaction bizProcess.InsertTransaction(dtoProcess); //MRP Simulate Process bizProcess.SimulateMRP(dtoProcess, dtoGen); //Update Process Transaction dtoProcess.END_PRCS_TIME = DateTime.Now.ToNZDateTime(); dtoProcess.STATUS = (NZString)"F"; //Finish Normal bizProcess.UpdateFinishTime(dtoProcess); } catch (Exception) { //db.Rollback(); //Update Process Transaction //dtoProcess.END_PRCS_TIME = DateTime.Now.ToNZDateTime(); dtoProcess.STATUS = (NZString)"E"; //Terminate bizProcess.UpdateFinishTime(dtoProcess); throw; } //finally //{ // if (db.DBConnectionState == ConnectionState.Open) // db.Close(); //} }
public MRP011_SourceOrder(GenerateMRPDTO param) : this() { InitialData(param); }
public DataTable LoadSourceOrderSummaryEachMonth(GenerateMRPDTO dto) { DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadSourceOrderSummaryEachMonth(null, dto, Common.CurrentUserInfomation.DateFormat.ToString())); }