public ActionResult Edit(int id) { HR_PractiseCerts form = null; List <ComboItem> Corp = null, certType = null, bUsed = null, CustID = null; using (var db = new SysContext()) { Corp = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='HtCorp'")).ToList(); certType = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='zhengshutype'")).ToList(); bUsed = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='yw'")).ToList(); CustID = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='yw'")).ToList(); } using (var db = new LUOLAI1401Context()) { form = db.HR_PractiseCerts.Find(id); } ViewBag.RowState = 2; if (form == null) { ViewBag.RowState = 1; form = new HR_PractiseCerts { FID = id }; } return(View(new { form = form, dataSource = new { Corp, certType, bUsed, CustID } })); }
public ActionResult Edit3(HR_PractiseCerts hr) { using (var db = new LUOLAI1401Context()) { var oldhr = db.HR_PractiseCerts.FirstOrDefault(s => s.FID == hr.FID); if (oldhr != null) { oldhr.Scan1 = hr.Scan1; oldhr.Scan2 = hr.Scan2; oldhr.Scan3 = hr.Scan3; oldhr.Scan4 = hr.Scan4; } db.SaveChanges(); } return(Content("<script>alert('更新成功');window.close();</script>")); //return Content("<script>alert('更新成功');location='" + Url.Action("Practisecert", "Rols") + "'</script>"); }