public ActionResult Login([Bind(Include = "LoginId,LoginPwd")]LoginUser user) { if (!ModelState.IsValid) { return View(user); } using (var cxt = new OASysModelContainer()) { var u = cxt.User.SingleOrDefault(us => us.LoginId.Equals(user.LoginId)); if (u != null && u.LoginPwd == user.LoginPwd) { if (u.StateId!=1) { ModelState.AddModelError("UserValidate", "用户已冻结,无法登录"); return View(user); } FormsAuthentication.SetAuthCookie(u.LoginId.ToString(), true); u.Branch = cxt.Branch.SingleOrDefault(b => b.BranchId == u.BranchId); Session["UserValidate"] = u; return RedirectToAction("Index", "Home"); } else { ModelState.AddModelError("UserValidate", "用户名或密码不正确"); return View(user); } } }
public static User GetFullUser(this IPrincipal User) { if (User==null) { return null; } if (User.Identity==null) { return null; } var name = User.Identity.Name; if (name == null) { return null; } else { int u; if (!int.TryParse(name, out u)) { return null; } using (var cxt = new OASysModelContainer()) { return cxt.User.SingleOrDefault(us => us.UserId == u); } } }
public ActionResult Noti() { using (var context = new OASysModelContainer()) { var noty = from n in context.Notification select n; return PartialView("NotiFy",noty); } }
public ActionResult PermEdit(int roleId) { using (var cxt = new OASysModelContainer()) { var data = cxt.UserRole.SingleOrDefault(r => r.RoleId == roleId); return PartialView(data); } }
public ActionResult ReCycleIndex() { using (var cxt = new OASysModelContainer()) { var data = cxt.File.Where(f => f.IsRecycled); return PartialView(data.ToList()); } }
public ActionResult AddSeal() { using (var context = new OASysModelContainer()) { var sel = from n in context.DictSub where n.Dict.DictType == 1 select n; ViewBag.Zhang = new SelectList(sel, "DictSubId", "DictSubName", "---请选择---"); return PartialView("Seal"); } }
public static bool ExistName(this UserRole userRole) { bool flag = false; using (var cxt = new OASysModelContainer()) { flag = cxt.UserRole.Where(r => r.RoleName.ToLower().Equals(userRole.RoleName.ToLower())).Count() > 0; } return flag; }
public ActionResult OrganManaIndex() { using (var cxt = new OASys.Models.OASysModelContainer()) { var data = cxt.Branch.ToList(); data.ForEach(d => d.Organ = cxt.Organ.Where(o => o.OrganId == d.OrganId).SingleOrDefault()); return PartialView(data); } }
public static User GetUserById(this int userId) { using (var cxt = new OASysModelContainer()) { var user = cxt.User.SingleOrDefault(u => u.UserId == userId); if (user==null) { return null; } user.Branch = cxt.Branch.SingleOrDefault(b => b.BranchId == user.BranchId); if (user.Branch!=null) { user.Branch.Organ = cxt.Organ.SingleOrDefault(o=>o.OrganId==user.Branch.OrganId); } //user.UserRole = cxt.UserRole.SingleOrDefault(r=>r.RoleId==user.UserRoleId); //user.Job = cxt.Job.SingleOrDefault(j=>j.JobId==user.JobId); //user.Sex = cxt.Sex.SingleOrDefault(s => s.SexId == user.SexId); return user; } }
public ActionResult RoleNameExists(string roleName) { string str; using (var cxt = new OASysModelContainer()) { var flag = cxt.UserRole.Where(r=>r.RoleName.ToLower().Equals(roleName.ToLower())).Count() > 0 ; if (flag) { str = "角色名已存在"; } else { str = "角色名可用"; } } return Content(str); }
public static void LoadRole(this User user) { using (var cxt = new OASysModelContainer()) { user.UserRole = cxt.UserRole.SingleOrDefault(r => r.RoleId == user.UserRoleId); } }
public static bool SysConfig(this User user, bool enable) { user.LoadRole(); var ur = user.UserRole; SystemRole sr = (SystemRole)ur.SystemRole; var flag = sr.HasFlag(SystemRole.SysConfig); if (enable) { if (flag) { return true; } else { sr = sr | SystemRole.SysConfig; } } else { if (flag) { sr = (SystemRole)(sr - SystemRole.SysConfig); } else { return true; } } using (var cxt = new OASysModelContainer()) { user.LoadRole(); cxt.UserRole.Attach(ur); ur.SystemRole = (int)sr; return cxt.SaveChanges() > 0; } }
public ActionResult CheSelect() { using (var contxt = new OASysModelContainer()) { var che = from n in contxt.Car select n; return PartialView("Che", che); } }
public ActionResult PermEdit([Bind(Exclude = "SystemRole,DesktopRole")]Perm perm) { ActionResult ar; User user; if (!UserVal(out ar,out user)) { return ar; } var permFlag = user.HasPermManage(); if (!permFlag) { return Content("修改失败,权限不足"); } if (perm.SystemRole == -1 || perm.DesktopRole == -1) { return Content("修改失败,检测到非法提交"); } bool flag; using (var cxt = new OASysModelContainer()) { var role = cxt.UserRole.SingleOrDefault(r => r.RoleId == perm.RoleId); role.SystemRole = perm.SystemRole; role.DesktopRole = perm.DesktopRole; flag = cxt.SaveChanges() > 0; } if (flag) { return Content("修改成功"); } else { return Content("修改失败"); } }
public ActionResult UserLoginIdExists(string loginId) { string str; using (var cxt = new OASysModelContainer()) { var flag = cxt.User.Where(u => u.LoginId.ToLower().Equals(loginId.ToLower())).Count() > 0; if (flag) { str = "登录名已存在"; } else { str = "登录名可用"; } } return Content(str); }
public ActionResult EditChe(int id) { using (var context = new OASysModelContainer()) { var cher = from n in context.Car where n.CarId == id select n; return PartialView("EditChe", cher.SingleOrDefault()); } }
public ActionResult UserEdit(int userId) { var user = userId.GetUserById(); if (user==null) { return Content("该用户不存在"); } using (var cxt = new OASysModelContainer()) { ViewBag.Branches = new SelectList(cxt.Branch.ToList(), dataValueField: "BranchId", dataTextField: "BranchName"); ViewBag.Organs = new SelectList(cxt.Organ.ToList(), dataValueField: "OrganId", dataTextField: "OrganName"); ViewBag.Roles = new SelectList(cxt.UserRole.ToList(), dataValueField: "RoleId", dataTextField: "RoleName"); ViewBag.Jobs = new SelectList(cxt.Job.ToList(), dataValueField: "JobId", dataTextField: "JobName"); } return PartialView(user); }
public ActionResult UserAdd(User user) { ActionResult ar; User currentUser; if (!UserVal(out ar, out currentUser)) { return ar; } var flag = currentUser.HasRoleManage(); if (!flag) { return Content("添加失败,权限不足"); } using (var cxt = new OASysModelContainer()) { var exist = cxt.User.Where(u => u.LoginId.ToLower().Equals(user.LoginId.ToLower())).Count() > 0; if (exist) { return Content("添加失败,登录名重复"); } } user.Address = "未录入"; user.Email = "未录入"; user.Telephone = "未录入"; user.Phone = "未录入"; var add = user.Add(); if (add) { return Content("添加成功"); } else { return Content("添加失败"); } }
public ActionResult SelectMeetingRoom(string uName, string rName, DateTime? sTime, DateTime? eTime, int? DictSubId) { using (var context = new OASysModelContainer()) { var MeetingRoom = from n in context.MeetingRoomOrder select n; if (DictSubId.HasValue) { MeetingRoom = from n in MeetingRoom where n.DictSubId == DictSubId.Value select n; } if (sTime.HasValue) { MeetingRoom = from n in MeetingRoom where n.StartTime == sTime.Value select n; } if (eTime.HasValue) { MeetingRoom = from n in MeetingRoom where n.EndTime == eTime.Value select n; } if (!string.IsNullOrWhiteSpace(uName)) { MeetingRoom = from n in MeetingRoom where n.OrderUser.UserName.Contains(uName.Trim()) select n; } if (!string.IsNullOrWhiteSpace(rName)) { MeetingRoom = from n in MeetingRoom where n.OrderRoom.RoomName.Contains(rName.Trim()) select n; } return Json(MeetingRoom); } }
public ActionResult XdMetroom() { using (var context = new OASysModelContainer()) { var sel = from n in context.DictSub where n.Dict.DictType == 2 select n; ViewBag.Zhang = new SelectList(sel, "DictSubId", "DictSubName", "---选择会议类型---"); return PartialView("XdMer"); } }
public ActionResult RoleManaIndex() { using (var cxt = new OASys.Models.OASysModelContainer()) { return PartialView(cxt.UserRole.ToArray()); } }
public ActionResult selectNoTi(int id) { using (var context = new OASysModelContainer()) { var sql = from n in context.Notification where n.NotifyId == id select n; return PartialView("SelectNoTi"); } }
public ActionResult UserAdd() { using (var cxt = new OASysModelContainer()) { ViewBag.Branches = new SelectList(cxt.Branch.ToList(), dataValueField: "BranchId", dataTextField: "BranchName"); ViewBag.Organs = new SelectList(cxt.Organ.ToList(), dataValueField: "OrganId", dataTextField: "OrganName"); ViewBag.Roles = new SelectList(cxt.UserRole.ToList(), dataValueField: "RoleId", dataTextField: "RoleName"); ViewBag.Jobs = new SelectList(cxt.Job.ToList(), dataValueField: "JobId", dataTextField: "JobName"); } return PartialView(); }