public MSTypeModel(COPR16Entities dbModel) { db = dbModel; this.UNIT_LIST = new List <SelectListItem>(); this.FILES_LIST = new List <SelectListItem>(); this.OPT_LIST = new List <SelectListItem>(); foreach (var row in db.COPR16_UNITS_MSTR.Where(l => l.FLGACT.Value == true)) { UNIT_LIST.Add(new SelectListItem { Text = row.UNIT_NAME, Value = row.UNIT_ID }); } foreach (var row in db.COPR16_FILES_MSTR.Where(l => l.FLGACT.Value == true)) { FILES_LIST.Add(new SelectListItem { Text = row.FILE_NAME, Value = row.FILE_ID }); } foreach (var row in db.COPR16_OPTIONVAL_MSTR.Where(l => l.FLGACT.Value == true)) { OPT_LIST.Add(new SelectListItem { Text = row.OPTION_NAME, Value = row.OPTION_ID }); } }
public MachineListModel(COPR16Entities dbModel) { db = dbModel; this.MANTYPE_LIST = new List <SelectListItem>(); foreach (var row in db.COPR16_MANCTYPE_MSTR.Where(l => l.FLGACT == true)) { MANTYPE_LIST.Add(new SelectListItem { Text = row.MTYPE_ID + " " + row.MTYPE_NAME, Value = row.MTYPE_ID }); } }
public ReturnTypeModel(COPR16Entities dbModel) { db = dbModel; this.MSTYPE_LIST = new List <SelectListItem>(); this.cOPR16_RTDT_MSTR = new COPR16_RTDT_MSTR(); foreach (var row in db.COPR16_MEASURETYPE_MSTR.Where(l => l.FLGACT == true)) { MSTYPE_LIST.Add(new SelectListItem { Text = row.MSTYPE_NAME, Value = row.MSTYPE_ID }); } }
public FileModel(COPR16Entities dbModel) { db = dbModel; this.FTYPE_LIST = new List <SelectListItem>(); foreach (var row in db.COPR16_FTYPE_MSTR.Where(l => l.FLGACT == true)) { FTYPE_LIST.Add(new SelectListItem { Text = row.FT_NAME, Value = row.FT_ID }); } }
public void getResultModel(COPR16Entities dbModel, string COPR_ID, string SEQ_NO) { cOPR16_COPRUNNING_RT = dbModel.COPR16_COPRUNNING_RT.Where(l => l.COPR_ID.Equals(COPR_ID) && l.SEQ_NO.Equals(SEQ_NO)).FirstOrDefault(); cOPR16_RTDT_MSTR = dbModel.COPR16_RTDT_MSTR.Where(l => l.RTTYPE_ID.Equals(cOPR16_COPRUNNING_RT.RETURNTYPE_ID)).FirstOrDefault(); cOPR16_MEASURETYPE_MSTR = dbModel.COPR16_MEASURETYPE_MSTR.Where(l => l.MSTYPE_ID.Equals(cOPR16_RTDT_MSTR.MSTYPE_ID)).FirstOrDefault(); if (cOPR16_MEASURETYPE_MSTR.OPTION_UNIT == true) { isOptionList = true; cOPR16_OPTDTVALUE_MSTR_List = new List <COPR16_OPTDTVALUE_MSTR>(); cOPR16_OPTDTVALUE_MSTR_List = dbModel.COPR16_OPTDTVALUE_MSTR.Where(l => l.OPTION_ID.Equals(cOPR16_MEASURETYPE_MSTR.OPT_ID)).ToList(); } else { isOptionList = false; } }
public ItemsModel(COPR16Entities dbModel) { db = dbModel; this.FG_LIST = new List <SelectListItem>(); this.FGTYPE_LIST = new List <SelectListItem>(); this.BRAND_LIST = new List <SelectListItem>(); this.MODEL_LIST = new List <SelectListItem>(); this.LINE_LIST = new List <SelectListItem>(); this.POSITION_LIST = new List <SelectListItem>(); foreach (var row in db.COPR16_FG_MSTR.Where(l => l.FLGACT == true)) { FG_LIST.Add(new SelectListItem { Text = row.FG_NO, Value = row.FG_NO }); } foreach (var row in db.COPR16_BRAND_MSTR.Where(l => l.FLGACT == true)) { BRAND_LIST.Add(new SelectListItem { Text = row.BRAND_ID, Value = row.BRAND_ID }); } foreach (var row in db.COPR16_MODEL_MSTR.Where(l => l.FLGACT == true)) { MODEL_LIST.Add(new SelectListItem { Text = row.MODEL_ID, Value = row.MODEL_ID }); } foreach (var row in db.COPR16_LINE_MSTR.Where(l => l.FLGACT == true)) { LINE_LIST.Add(new SelectListItem { Text = row.LINE_ID, Value = row.LINE_ID }); } foreach (var row in db.COPR16_POSITION_MSTR.Where(l => l.FLGACT == true)) { POSITION_LIST.Add(new SelectListItem { Text = row.POS_ID, Value = row.POS_ID }); } foreach (var row in db.COPR16_FGTYPE_MSTR.Where(l => l.FLGACT == true)) { FGTYPE_LIST.Add(new SelectListItem { Text = row.FGT_ID, Value = row.FGT_ID }); } }
public ProcessStepsModel(COPR16Entities dbModel) { db = dbModel; this.MCTYPE_LIST = new List <SelectListItem>(); this.RTV_LIST = new List <SelectListItem>(); foreach (var row in db.COPR16_MANCTYPE_MSTR.Where(l => l.FLGACT == true)) { MCTYPE_LIST.Add(new SelectListItem { Text = row.MTYPE_ID + ":" + row.MTYPE_NAME, Value = row.MTYPE_ID }); } foreach (var row in db.COPR16_RETURNTYPE_MSTR.Where(l => l.FLGACT == true)) { RTV_LIST.Add(new SelectListItem { Text = row.RTYPE_ID + ":" + row.RTYPE_NAME, Value = row.RTYPE_ID }); } }
public MachineTypeModel(COPR16Entities dbModel) { db = dbModel; this.RTYPE_LIST = new List <SelectListItem>(); this.FGT_LIST = new List <SelectListItem>(); foreach (var row in db.COPR16_RETURNTYPE_MSTR.Where(l => l.FLGACT == true)) { RTYPE_LIST.Add(new SelectListItem { Text = row.RTYPE_NAME, Value = row.RTYPE_ID }); } foreach (var row in db.COPR16_FGTYPE_MSTR.Where(l => l.FLGACT == true)) { FGT_LIST.Add(new SelectListItem { Text = row.FGT_NAME, Value = row.FGT_ID }); } }
public ProcessModel(COPR16Entities dbModel) { db = dbModel; this.PROC_LIST = new List <SelectListItem>(); this.REG_LIST = new List <SelectListItem>(); foreach (var row in db.COPR16_PROC_MSTR.Where(l => l.FLGACT == true)) { PROC_LIST.Add(new SelectListItem { Text = row.PROC_NAME, Value = row.PROC_ID }); } foreach (var row in db.COPR16_STDREG_MSTR.Where(l => l.FLGACT == true)) { REG_LIST.Add(new SelectListItem { Text = row.STDREG_NAME, Value = row.STDREG_ID }); } }
public HandheldModel(COPR16Entities dbModel) { db = dbModel; localCopsModel = new CopRunningModel(db); //this.WRK_LIST = new List<SelectListItem>(); //this.MODEL_LIST = new List<SelectListItem>(); //this.POSITION_LIST = new List<SelectListItem>(); //this.PROC_LIST = new List<SelectListItem>(); //foreach (var row in db.COPR16_WORKFLOW.Where(l => l.FLGACT == true)) //{ // WRK_LIST.Add(new SelectListItem { Text = row.WRK_NAME, Value = row.WRK_ID }); //} //foreach (var row in db.COPR16_MODEL_MSTR.Where(l => l.FLGACT == true)) //{ // MODEL_LIST.Add(new SelectListItem { Text = row.MODEL_DESC, Value = row.MODEL_ID }); //} //foreach (var row in db.COPR16_POSITION_MSTR.Where(l => l.FLGACT == true)) //{ // POSITION_LIST.Add(new SelectListItem { Text = row.POS_DESC, Value = row.POS_ID }); //} //foreach (var row in db.COPR16_PROC_MSTR.Where(l => l.FLGACT == true)) //{ // PROC_LIST.Add(new SelectListItem { Text = row.PROC_NAME, Value = row.PROC_ID }); //} statusList = new List <SelectListItem>(); if (this.localCopsModel == null) { this.localCopsModel = new CopRunningModel(db); } foreach (var item in this.localCopsModel.STATUS_LIST) { statusList.Add(new SelectListItem { Text = item.text, Value = item.value }); } }
public OptionsModel(COPR16Entities dbModel) { db = dbModel; details = new OptionDetailsModel(); }
public CopRunningModel(COPR16Entities dbModel) { db = dbModel; SPC_YEAR = new List <SelectListItem>(); SPC_MODEL_LIST = new List <SelectListItem>(); this.WRK_LIST = new List <SelectListItem>(); this.MODEL_LIST = new List <SelectListItem>(); this.LINE_LIST = new List <SelectListItem>(); this.POSITION_LIST = new List <SelectListItem>(); this.PROC_LIST = new List <SelectListItem>(); this.PROC_LIST_Short = new List <SelectListItem>(); this.STATUS_LIST = new List <cop_status>(); statusList = new List <SelectListItem>(); STDREG = new List <SelectListItem>(); foreach (var row in db.COPR16_STDREG_MSTR.Where(l => l.FLGACT == true)) { STDREG.Add(new SelectListItem { Text = row.STDREG_NAME, Value = row.STDREG_ID }); } foreach (var row in db.COPR16_WORKFLOW.Where(l => l.FLGACT == true)) { WRK_LIST.Add(new SelectListItem { Text = row.WRK_NAME, Value = row.WRK_ID }); } foreach (var row in db.COPR16_MODEL_MSTR.Where(l => l.FLGACT == true)) { MODEL_LIST.Add(new SelectListItem { Text = row.MODEL_DESC, Value = row.MODEL_ID }); } foreach (var row in db.COPR16_LINE_MSTR.Where(l => l.FLGACT == true)) { LINE_LIST.Add(new SelectListItem { Text = row.LINE_DESC, Value = row.LINE_ID }); } foreach (var row in db.COPR16_POSITION_MSTR.Where(l => l.FLGACT == true)) { POSITION_LIST.Add(new SelectListItem { Text = row.POS_DESC, Value = row.POS_ID }); } foreach (var row in db.COPR16_PROC_MSTR.Where(l => l.FLGACT == true)) { PROC_LIST.Add(new SelectListItem { Text = row.PROC_NAME, Value = row.PROC_ID }); } foreach (var row in db.COPR16_PROC_MSTR.Where(l => l.FLGACT == true)) { PROC_LIST_Short.Add(new SelectListItem { Text = row.PROC_NAME, Value = row.PROC_ID }); } statusList.Add(new SelectListItem { Text = "--ALL--", Value = "ALL" }); this.STATUS_LIST.Add(new cop_status { text = "NEW", value = "NEW", step_status = false, job_status = true, color = "#" }); this.STATUS_LIST.Add(new cop_status { text = "READY", value = "READY", step_status = false, job_status = true, color = "#5cb85c" }); this.STATUS_LIST.Add(new cop_status { text = "WAIT", value = "WAIT", step_status = true, job_status = true, color = "#ffe764" }); this.STATUS_LIST.Add(new cop_status { text = "QUEUE", value = "QUEUE", step_status = true, job_status = false, color = "#ffe764" }); this.STATUS_LIST.Add(new cop_status { text = "TESTING", value = "TESTING", step_status = true, job_status = true, color = "#15aaf6", fcolor = "#ffffff" }); this.STATUS_LIST.Add(new cop_status { text = "ABORT", value = "ABORT", step_status = true, job_status = false, color = "#d9534f" }); this.STATUS_LIST.Add(new cop_status { text = "RE-TEST", value = "RE-TEST", step_status = true, job_status = false, color = "#15aaf6" }); this.STATUS_LIST.Add(new cop_status { text = "FINISHED", value = "FINISHED", step_status = true, job_status = false, color = "#42dc95" }); this.STATUS_LIST.Add(new cop_status { text = "COMPLETED", value = "COMPLETED", step_status = false, job_status = true, color = "#42dc95" }); this.STATUS_LIST.Add(new cop_status { text = "CANCELED", value = "CANCELED", step_status = false, job_status = true, color = "#d9534f" }); this.STATUS_LIST.Add(new cop_status { text = "APPROVED", value = "APPROVED", step_status = false, job_status = true, color = "#42dc00" }); foreach (var item in STATUS_LIST) { statusList.Add(new SelectListItem { Text = item.text, Value = item.value }); } }
public FileImportGlock(COPR16Entities dataCtx) { db = dataCtx; }
public FileImportModel(COPR16Entities dataCtx) { db = dataCtx; }
public ItemMatchModel(COPR16Entities dbModel) { db = dbModel; }
public ImportModels(COPR16Entities dataCtx) { db = dataCtx; }