Esempio n. 1
0
        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
                });
            }
        }
Esempio n. 2
0
 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
         });
     }
 }