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