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());
}
}
}
private void LoadDetailSummary(string strMRP_NO, string strITEM_CD, string strLOC_CD)
{
MRPBIZ biz = new MRPBIZ();
DataTable dt = biz.LoadMRPDetailSummaryByMonth(strMRP_NO, strITEM_CD, strLOC_CD);
ClearSpread(shtViewDetail);
shtViewDetail.ColumnCount = 0;
shtViewDetail.DataSource = dt;
if (shtViewDetail.Columns.Count > 0)
{
SpreadVisibleColumn(false, shtViewDetail, (int)eDetail.ItemCD, (int)eDetail.OrderLocCD, (int)eDetail.RecordNo);
}
}
private void LoadData(NZDateTime dtmFrom, NZDateTime dtmTo)
{
MRPBIZ biz = new MRPBIZ();
DataTable dt = biz.LoadMRPList(dtmFrom, dtmTo);
m_dtAllData = dt;
shtView.DataSource = m_dtAllData;
ClearSpread();
FindDataFromMemory();
//shtView.DataSource = m_dtAllData;
CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
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 LoadData(string strMRP_NO)
{
txtMRPNo.Text = strMRP_NO;
MRPBIZ biz = new MRPBIZ();
DataTable dt = biz.LoadSimalateMRPHeader(strMRP_NO);
shtViewHeader.DataSource = dt;
if (dt.Rows.Count > 0)
{
shtViewHeader.ActiveRowIndex = 0;
LoadDetailSummary(strMRP_NO, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.ItemCD].Value.ToString(), shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.OrderLocCD].Value.ToString());
}
}
public MRP020_MRPList()
{
InitializeComponent();
InitializeScreen();
//InventoryPeriodBIZ biz = new InventoryPeriodBIZ();
//InventoryPeriodDTO dto = biz.LoadCurrentPeriodWithQueryRange();
//dtPeriodBegin.NZValue = dto.PERIOD_BEGIN_DATE;
//dtPeriodEnd.NZValue = dto.PERIOD_END_DATE;
DateTime dtmDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
NZDateTime dtmDateFrom = (NZDateTime)dtmDate;
MRPBIZ biz = new MRPBIZ();
NZDateTime dtmDateTo = biz.GetMaxMRPDate();
dtPeriodBegin.Value = dtmDateFrom;
dtPeriodEnd.Value = dtmDateTo;
LoadData(dtmDateFrom, dtmDateTo);
}
private void SetDefaultControl()
{
MRPBIZ bizMRP = new MRPBIZ();
ProcessBIZ bizProcess = new ProcessBIZ();
//set start date
dtpStartDate.Format = Common.CurrentUserInfomation.DateFormatString;
dtpLastSimulateDate.Format = Common.CurrentUserInfomation.DateFormatString;
dtpStartDate.Value = bizMRP.GetDefaultStartDate();
//txtRecoverDay.Text = bizMRP.GetDefaultRecoverDuration().ToString();
//Load last simulate time
ProcessDTO dtoProcess = bizProcess.LoadLastProcess(CONST_STR_PROCESS_NAME);
if (dtoProcess != null)
{
txtLastMRPNo.Text = dtoProcess.PROCESS_NO.ToString();
dtpLastSimulateDate.Value = (DateTime)dtoProcess.PROCESS_DATE.Value;
}
}
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);
}
