public ActionResult Edit(int id)
        {
            fw_Objection     form = null;
            List <ComboItem> Objectionstatus = null, otherstatus = null, IsContinue = null, objState = null, isShow = null, IsAgreed = null, IsOnJudge = null;

            using (var db = new SysContext())
            {
                Objectionstatus = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='HandleState'")).ToList();
                otherstatus     = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='OtherState'")).ToList();
                IsContinue      = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='YN'")).ToList();
                objState        = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='YN'")).ToList();
                isShow          = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='YN'")).ToList();
                IsAgreed        = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='JJResult'")).ToList();
                IsOnJudge       = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='YN'")).ToList();
            }
            using (var db = new LUOLAI1401Context())
            {
                form = db.fw_Objection.Find(id);
            }
            ViewBag.RowState = 2;
            if (form == null)
            {
                ViewBag.RowState = 1;
                form             = new fw_Objection
                {
                    objectionid = id
                };
            }
            return(View(new { form = form, dataSource = new { Objectionstatus, otherstatus, IsContinue, objState, isShow, IsAgreed, IsOnJudge } }));
        }
Exemple #2
0
        public ActionResult Edit(int id)
        {
            fw_Objection form = null;

            using (var db = new LUOLAI1401Context())
            {
                form = db.fw_Objection.Find(id);
            }
            ViewBag.RowState = 2;
            if (form == null)
            {
                ViewBag.RowState = 1;
                form             = new fw_Objection
                {
                    objectionid = id
                };
            }
            return(View(new { form = form, dataSource = new {  } }));
        }