public ActionResult UserDepartment(UserDepartmentModel model) { var result = new Result(); try { if (string.IsNullOrEmpty(model.UserIds)) { result.Msg = "UserId不能为空"; return(Json(result)); } if (string.IsNullOrEmpty(model.DepartmentIds)) { result.Msg = "DepartmentId不能为空"; return(Json(result)); } var isScussce = new UserDepartmentBLL().Create(model); if (isScussce) { result.Msg = "设置成功!"; result.Success = true; } else { result.Msg = "设置失败!"; } return(Json(result)); } catch (Exception ex) { result.Msg = string.Format("设置失败!{0}", ex.Message); return(Json(result)); } }
public HandleResponse <UserDepartmentKey> RemoveUserDepartment(int userId, int departmentId) { HandleResponse <UserDepartmentKey> rm = new HandleResponse <UserDepartmentKey>(); UserDepartmentModel ud = new UserDepartmentModel() { UserId = userId, DeparmentId = departmentId }; try { _UserDepartment.Remove(ud); rm.Success = true; rm.Message = "删除数据成功"; rm.Key = new UserDepartmentKey { UserId = ud.UserId, DepartmentId = ud.DeparmentId }; } catch (Exception ex) { rm.Success = false; rm.Message = "删除数据失败" + ex.Message; } return(rm); }
public HandleResponse <UserDepartmentKey> AddUserDepartment(UserDepartmentAddViewModel req) { HandleResponse <UserDepartmentKey> rm = new HandleResponse <UserDepartmentKey>(); //bool b =await IsExist(a => a.UserId == req.UserId && a.DeparmentId == req.DepartmentId); //if (b) //{ // rm.Success = false; // rm.Message = "该用户已分配在该部门,请勿重复操作"; // return rm; //} UserDepartmentModel ud = new UserDepartmentModel() { UserId = req.UserId, DeparmentId = req.DepartmentId }; try { _UserDepartment.Add(ud); rm.Success = true; rm.Message = "添加数据成功"; rm.Key = new UserDepartmentKey { UserId = ud.UserId, DepartmentId = ud.DeparmentId }; } catch (Exception ex) { rm.Success = false; rm.Message = "添加数据失败" + ex.Message; } return(rm); }
/// <summary> /// 设置用户部门(批量设置) /// </summary> /// <param name="userIds">用户主键,多个用逗号隔开</param> /// <param name="depIds">部门id,多个用逗号隔开</param> public bool SetDepartmentBatch(string userIds, string depIds) { List <UserDepartmentModel> dep_addList = new List <UserDepartmentModel>(); //需要插入部门的sql语句集合 List <UserDepartmentModel> dep_deleteList = new List <UserDepartmentModel>(); //需要删除部门的sql语句集合 string[] str_userid = userIds.Trim(',').Split(','); string[] str_dep = depIds.Trim(',').Split(','); UserDepartmentModel userdepdelete = null; UserDepartmentModel userdepadd = null; for (int i = 0; i < str_userid.Length; i++) { //批量设置先删除当前用户的所有部门 userdepdelete = new UserDepartmentModel(); userdepdelete.UserId = Convert.ToInt32(str_userid[i]); dep_deleteList.Add(userdepdelete); if (!string.IsNullOrEmpty(depIds)) { //再添加设置的部门 for (int j = 0; j < str_dep.Length; j++) { userdepadd = new UserDepartmentModel(); userdepadd.UserId = Convert.ToInt32(str_userid[i]); userdepadd.DepartmentId = Convert.ToInt32(str_dep[j]); dep_addList.Add(userdepadd); } } } return(dal.SetDepartmentBatch(dep_addList, dep_deleteList)); }
/// <summary> /// 添加用户部门 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Create(UserDepartmentModel model) { try { var userIds = model.UserIds.Split(','); var departmentIds = model.DepartmentIds.Split(','); foreach (var item in userIds) { var gid = Guid.Parse(item); var user = userDal.Find(gid); if (user == null) { throw new Exception("无法识别用户ID"); } else { var isScussce = dal.DelByUserId(gid); if (!isScussce) { throw new Exception("出现程序错误,请联系管理员!"); } } } foreach (var uid in userIds) { var userId = Guid.Parse(uid); foreach (var did in departmentIds) { var departmentId = Guid.Parse(did); var userDepartment = new UserDepartment { Id = Guid.NewGuid(), UserId = userId, DepartmentId = departmentId }; var result = dal.Create(userDepartment); if (result == null) { throw new Exception("循环添加出现程序错误,请联系管理员!"); } } } return(true); } catch (Exception) { throw new Exception("出现程序错误,请联系管理员!"); } }
/// <summary> /// 设置用户部门(单个用户) /// </summary> /// <param name="userId">用户主键</param> /// <param name="depIds">部门id,多个用逗号隔开</param> public bool SetDepartmentSingle(int userId, string depIds) { DataTable dt_user_dep_old = new DepartmentBLL().GetDepartmentByUserId(userId); //用户之前拥有的部门 List <UserDepartmentModel> dep_addList = new List <UserDepartmentModel>(); //需要插入部门的sql语句集合 List <UserDepartmentModel> dep_deleteList = new List <UserDepartmentModel>(); //需要删除部门的sql语句集合 string[] str_dep = depIds.Trim(',').Split(','); //传过来用户勾选的部门(有去勾的也有新勾选的) UserDepartmentModel userdepdelete = null; UserDepartmentModel userdepadd = null; for (int i = 0; i < dt_user_dep_old.Rows.Count; i++) { //等于-1说明用户去掉勾选了某个部门 需要删除 if (Array.IndexOf(str_dep, dt_user_dep_old.Rows[i]["departmentid"].ToString()) == -1) { userdepdelete = new UserDepartmentModel(); userdepdelete.DepartmentId = Convert.ToInt32(dt_user_dep_old.Rows[i]["departmentid"].ToString()); userdepdelete.UserId = userId; dep_deleteList.Add(userdepdelete); } } if (!string.IsNullOrEmpty(depIds)) { for (int j = 0; j < str_dep.Length; j++) { //等于0那么原来的部门没有 是用户新勾选的 if (dt_user_dep_old.Select("departmentid = '" + str_dep[j] + "'").Length == 0) { userdepadd = new UserDepartmentModel(); userdepadd.UserId = userId; userdepadd.DepartmentId = Convert.ToInt32(str_dep[j]); dep_addList.Add(userdepadd); } } } if (dep_addList.Count == 0 && dep_deleteList.Count == 0) { return(true); } else { return(dal.SetDepartmentSingle(dep_addList, dep_deleteList)); } }
// // GET: /UserDepartment/ public ActionResult Index() { var user = Session["User"] as DB.user; if (user == null) { return(RedirectToAction("Index", "Home")); } var model = new UserDepartmentModel(); arrangeBaseModel(model, user); var result = Operations.GetUsersOfManager(user); model.Department = new Department(user.department); model.Users = result.ReturnValue.Select(x => new User(x) { IsInMyDepartment = x.Department_Id == user.Department_Id }).ToList(); return(View(model)); }