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