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()));
}
