/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool Add(Esmart_Sys_Department_User model) { var engine = PermissionDb.CreateEngine(); engine.Esmart_Sys_Department_User.Add(model); engine.SaveChanges(); RightLogDb.AddLog(new Esmart_Right_Log { CreateBy = model.CreateId, CreateTime = model.CreateTime, EventType = "add", OprTbName = "Esmart_Sys_Department_User", OprUserId = model.CreateId, OptDescription = string.Format("用户:{0}添加了部门关系用户,用户ID:{1},部门ID:{2}", model.CreateId, model.UserId, model.DeparentId), Remark = Newtonsoft.Json.JsonConvert.SerializeObject(model) }); CommonAction.ClearCache(); return(true); }
public int CreateUserWithDepartmentId(Esmart_Sys_Users user, int departMentId) { if (user.UserID == 0) { user.CreateTime = DateTime.Now; UserManagerDb.Add(user); } Esmart_Sys_Department_User departUser = new Esmart_Sys_Department_User { DeparentId = departMentId, UserId = user.UserID, CreateTime = DateTime.Now, CreateId = user.CreateId }; DepartmentUserDbAction.Add(departUser); CommonAction.ClearCache(user.UserID); return(user.UserID); }
public static int ChangeDepartmentOfUser(List <int> userIds, int newDepartmentId, int createId) { var engine = PermissionDb.CreateEngine(); if (!engine.Esmart_Sys_Departments.Any(n => n.DeparentId == newDepartmentId)) { throw new TpoBaseException("调入部门已不存在,请刷新后重试"); } List <Esmart_Sys_Department_User> delDepartUser = new List <Esmart_Sys_Department_User>(), addDepartUser = new List <Esmart_Sys_Department_User>(); foreach (var userId in userIds) { if (!engine.Esmart_Sys_Users.Any(n => n.UserID == userId)) { throw new TpoBaseException("用户已不存在,请刷新后重试"); } var depUsers = engine.Esmart_Sys_Department_User.Where(n => n.UserId == userId).ToArray(); engine.Esmart_Sys_Department_User.RemoveRange(depUsers); delDepartUser.AddRange(depUsers); var newModel = new Esmart_Sys_Department_User { UserId = userId, DeparentId = newDepartmentId, CreateId = createId, CreateTime = DateTime.Now }; engine.Esmart_Sys_Department_User.Add(newModel); addDepartUser.Add(newModel); } RightLogDb.AddLog(new Esmart_Right_Log { CreateBy = createId, CreateTime = DateTime.Now, EventType = "add&delete", OprTbName = "Esmart_Sys_Department_User", OprUserId = createId, OptDescription = string.Format("用户:{0}更新了部门用户关系,更新的用户ID:{1},原部门ID{2},新部门ID:{3}", createId, string.Join(",", userIds), string.Join(",", delDepartUser.Select(s => s.DeparentId)), string.Join(",", addDepartUser.Select(s => s.DeparentId))), Remark = Newtonsoft.Json.JsonConvert.SerializeObject(delDepartUser) + ";" + Newtonsoft.Json.JsonConvert.SerializeObject(addDepartUser) }); var result = engine.SaveChanges(); CommonAction.ClearCache(); return(result); }