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