public ActionResult ExitLogin() { var user = (from u in medc.ps_user where u.id == int.Parse(Session["userid"].ToString()) select u).FirstOrDefault(); //添加数据 ps_logs logs = new ps_logs() { userCode = user.userCode, userName = user.userName, operateDateTime = DateTime.Now, operateInfo = "退出系统" }; bool b = true; try { medc.SubmitChanges(); } catch (Exception) { b = false; } return(Json(b, JsonRequestBehavior.AllowGet)); }
//验证登录 public ActionResult CheckLogin() { //获得用户名和密码 string userid = Request.Params["userid"]; string userpwd = Request.Params["userpwd"]; MyElectrCheck_DBDataContext medc = new MyElectrCheck_DBDataContext(); var result = (from u in medc.ps_user where u.userCode == userid && u.userPassword == userpwd select u).FirstOrDefault(); string b = "false"; if (result != null) { if (result.userStatus == 1) { b = "true"; Session["userid"] = result.id; Session["userCode"] = result.userCode; Session["roleid"] = result.roleId; //修改数据 result.lastLoginTime = DateTime.Now; result.lastUpdateTime = DateTime.Now; try { medc.SubmitChanges(); } catch (Exception) { b = "false"; } if (b == "true") { //添加logo日志 ps_logs logs = new ps_logs() { userCode = result.userCode, userName = result.userName, operateInfo = "登录系统", operateDateTime = DateTime.Now }; medc.ps_logs.InsertOnSubmit(logs); //保存数据 medc.SubmitChanges(); } } else { b = "freeze"; } } return(Json(b)); }
//修改用户信息的action public ActionResult UpdUser() { int id = int.Parse(Request.Params["uid"]); string userid = Request.Params["userid"]; string username = Request.Params["username"]; string userpwd = Request.Params["userpwd"]; string roleid = Request.Params["roleid"]; DateTime overdate = Convert.ToDateTime(Request.Params["overdate"]); DateTime outdate = Convert.ToDateTime(Request.Params["outdate"]); int status = int.Parse(Request.Params["status"]); var role = (from r in medc.ps_role where r.roleName == roleid select r).FirstOrDefault(); var user = (from u in medc.ps_user where u.id == id select u).FirstOrDefault(); //获得session中保存的值 int usersid = int.Parse(Session["userid"].ToString()); var pu = (from u in medc.ps_user where u.id == usersid select u).FirstOrDefault(); //修改数据 user.userCode = userid; user.userName = username; user.userPassword = userpwd; user.roleId = role.id; user.entryDate = overdate; user.dimissionDate = outdate; user.userStatus = status; bool b = true; try { //保存数据 medc.SubmitChanges(); ps_logs logs = new ps_logs() { userCode = pu.userCode, userName = pu.userName, operateInfo = "修改用户信息", operateDateTime = DateTime.Now }; medc.ps_logs.InsertOnSubmit(logs); medc.SubmitChanges(); } catch (Exception) { b = false; } return(Json(b)); }
//添加角色信息 public ActionResult AddRole() { string roleid = Request.Params["roleid"]; string rolename = Request.Params["rolename"]; int status = int.Parse(Request.Params["status"]); MyElectrCheck_DBDataContext medc = new MyElectrCheck_DBDataContext(); //获得session中保存的值 int id = int.Parse(Session["userid"].ToString()); var user = (from u in medc.ps_user where u.id == id select u).FirstOrDefault(); //创建实体类对象 ps_role role = new ps_role() { id = roleid, roleName = rolename, creationTime = DateTime.Now, createdBy = user.userCode, lastUpdateTime = DateTime.Now, isStart = status }; bool b = true; //添加到数据库 medc.ps_role.InsertOnSubmit(role); try { //保存数据 medc.SubmitChanges(); ps_logs logs = new ps_logs() { userCode = user.userCode, userName = user.userName, operateInfo = "添加角色信息", operateDateTime = DateTime.Now }; medc.ps_logs.InsertOnSubmit(logs); medc.SubmitChanges(); } catch (Exception) { b = false; } return(Json(b)); }
//删除数据 public ActionResult DelData() { string rid = Request.Params["roleid"]; MyElectrCheck_DBDataContext medc = new MyElectrCheck_DBDataContext(); //获得session中保存的值 int id = int.Parse(Session["userid"].ToString()); var user = (from u in medc.ps_user where u.id == id select u).FirstOrDefault(); var role = (from u in medc.ps_role where u.id == rid select u).FirstOrDefault(); bool b = true; medc.ps_role.DeleteOnSubmit(role); try { medc.SubmitChanges(); ps_logs logs = new ps_logs() { userCode = user.userCode, userName = user.userName, operateInfo = "删除角色信息", operateDateTime = DateTime.Now }; medc.ps_logs.InsertOnSubmit(logs); medc.SubmitChanges(); } catch (Exception) { b = false; } return(Json(b)); }
public ActionResult DelData() { int id = int.Parse(Request.Params["userid"]); var user = (from u in medc.ps_user where u.id == id select u).FirstOrDefault(); //获得session中保存的值 int usersid = int.Parse(Session["userid"].ToString()); var pu = (from u in medc.ps_user where u.id == usersid select u).FirstOrDefault(); //删除对象 medc.ps_user.DeleteOnSubmit(user); bool b = true; try { medc.SubmitChanges(); ps_logs logs = new ps_logs() { userCode = pu.userCode, userName = pu.userName, operateInfo = "删除用户信息", operateDateTime = DateTime.Now }; medc.ps_logs.InsertOnSubmit(logs); medc.SubmitChanges(); } catch (Exception) { b = false; } return(Json(b)); }
//添加用户信息 public ActionResult AddUser() { string userid = Request.Params["userid"]; string username = Request.Params["username"]; string userpwd = Request.Params["userpwd"]; string roleid = Request.Params["roleid"]; DateTime?overdate = null; if (Request.Params["overdate"] != "") { overdate = Convert.ToDateTime(Request.Params["overdate"]); } DateTime?outdate = null; if (Request.Params["overdate"] != "") { overdate = Convert.ToDateTime(Request.Params["overdate"]); } int status = int.Parse(Request.Params["status"]); //获取session中的值 //获得session中保存的值 int id = int.Parse(Session["userid"].ToString()); var pu = (from u in medc.ps_user where u.id == id select u).FirstOrDefault(); ps_user user = new ps_user() { userCode = userid, userName = username, userPassword = userpwd, sex = null, age = null, entryDate = overdate, dimissionDate = outdate, phoneTel = null, email = null, creationTime = DateTime.Now, lastLoginTime = DateTime.Now, createdBy = pu.userCode, lastUpdateTime = DateTime.Now, userStatus = status, roleId = roleid }; //添加到数据库 medc.ps_user.InsertOnSubmit(user); bool b = true; try { medc.SubmitChanges(); ps_logs logs = new ps_logs() { userCode = pu.userCode, userName = pu.userName, operateInfo = "添加用户信息", operateDateTime = DateTime.Now }; medc.ps_logs.InsertOnSubmit(logs); medc.SubmitChanges(); } catch (Exception) { b = false; } return(Json(b)); }