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