public static SCS_Teacher Get_TeacherInfo(int id)
{
try
{
SCS_Teacher sCS_Teacher = new SCS_Teacher();
var result1 = db.SCS_Teacher.Where(c => c.职工号.Equals(id)).Distinct();
if (result1.Count() > 0)
{
foreach (var r in result1)
{
//view_Userinfo.驾驶证号码 = r.驾驶证号码;
sCS_Teacher.职工号 = r.职工号;
sCS_Teacher.姓名 = r.姓名;
sCS_Teacher.手机号码 = r.手机号码;
sCS_Teacher.邮箱 = r.邮箱;
sCS_Teacher.办公地址 = r.办公地址;
}
}
return(sCS_Teacher);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult DeleteConfirmed(int id)
{
SCS_Teacher sCS_Teacher = db.SCS_Teacher.Find(id);
db.SCS_Teacher.Remove(sCS_Teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,姓名,职工号,手机号码,邮箱,办公地址")] SCS_Teacher sCS_Teacher)
{
if (ModelState.IsValid)
{
db.Entry(sCS_Teacher).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sCS_Teacher));
}
public ActionResult Create([Bind(Include = "id,姓名,职工号,手机号码,邮箱,办公地址")] SCS_Teacher sCS_Teacher)
{
if (ModelState.IsValid)
{
db.SCS_Teacher.Add(sCS_Teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sCS_Teacher));
}
public JsonResult Revise(string name, int tel, string Email, string Office)
{
SCS_Teacher sCS_Teacher = db.SCS_Teacher.Where(c => c.职工号.Equals(Convert.ToInt32(Session["id"]))).FirstOrDefault();
sCS_Teacher.姓名 = name;
sCS_Teacher.手机号码 = tel;
sCS_Teacher.邮箱 = Email;
sCS_Teacher.办公地址 = Office;
db.SCS_Teacher.Add(sCS_Teacher);
db.SaveChanges();
return(Json(true));
}
// GET: TeacherInfo/SCS_Teacher/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SCS_Teacher sCS_Teacher = db.SCS_Teacher.Find(id);
if (sCS_Teacher == null)
{
return(HttpNotFound());
}
return(View(sCS_Teacher));
}
public JsonResult GetMessage()
{
SCS_Teacher user = new SCS_Teacher();
return(Json(TeacherInfoController.Get_TeacherInfo(Convert.ToInt32(Session["id"]))));
}
