public bool SetUserRole(int userId, List <int> selectRoleIds) { //查询出当前设置角色的用户 var user = CurrentDbSession.UserDal.LoadEntities(u => u.Id == userId).FirstOrDefault(); //如果用户之前已经有了角色。先把之前的角色都清空掉。 if (user != null) { user.Role.Clear();//EF内部处理了两个集合的变化。 //e.g start set{1,2,3} and final set{1,2,4} //要从第一个集合删除3,第二个集合加上4.这个过程比较复杂。 //可以像上面那样处理,另一种处理就是清空用户原有的角色,把所有新的final set角色id加给用户 //把用户已有的角色查询出来。 var allRoles = CurrentDbSession.RoleDal.LoadEntities(r => selectRoleIds.Contains(r.Id)).ToList(); foreach (var roleInfo in allRoles) { user.Role.Add(roleInfo); } //foreach (int roleId in selectRoleIds) //{ // var roleInfo =DbSession.RoleDal.LoadEntities(r => r.Id == roleId).FirstOrDefault(); // user.Role.Add(roleInfo); //} } return(CurrentDbSession.SaveChanges() > 0); }
//public IDbSession CurrentDbSession //{ // get // { // //return new DbSession();//暂时 // return DbSessionFactory.GetCurrentDbSession(); // } //} //protected IDbSession CurrentDbSession;//当前类或者是子类 //protected BaseService() //{ // //CurrentDbSession = DbSessionFactory.GetCurrentDbSession(); // SetCurrentDal();//构造函数里面调用了 抽象方法:SetCurrentDal //} public T Add(T entity) { CurrentDal.Add(entity); CurrentDbSession.SaveChanges(); return(entity); //return CurrentDbSession.UserDal.Add(entity); }
public bool DeleteUserInfoList(List <int> list) { var userInfoList = CurrentDal.LoadEntities(u => list.Contains(u.ID)); foreach (var userInfo in userInfoList) { CurrentDal.DeleteEntities(userInfo); } return(CurrentDbSession.SaveChanges()); }
//public override void SetCurrentDal() //{ // CurrentDal = CurrentDbSession.UserInfoDal; //} /// <summary> /// 批量删除多条用户数据 /// </summary> /// <param name="list"></param> /// <returns></returns> public bool DeleteEntities(List <int> list) { var userInfoList = CurrentDbSession.UserInfoDal.LoadEntities(o => list.Contains(o.Id)); foreach (var userInfo in userInfoList) { userInfo.StateFlag = 1; //CurrentDbSession.UserInfoDal.DeleteEntity(userInfo); } return(CurrentDbSession.SaveChanged()); }
/// <summary> /// /// </summary> /// <param name="roleId"></param> /// <param name="list">被选中的权限ID</param> /// <returns></returns> public bool SetRoleActionInfo(int roleId, List <int> list) { var roleInfo = this.CurrentDbSession.RoleInfoDal.LoadEntities(u => u.ID == roleId).FirstOrDefault(); if (roleInfo != null) { roleInfo.ActionInfo.Clear(); foreach (var actionID in list) { var actionInfo = this.CurrentDbSession.ActionInfoDal.LoadEntities(u => u.ID == actionID).FirstOrDefault(); roleInfo.ActionInfo.Add(actionInfo); } } return(CurrentDbSession.SaveChanges()); }
public bool ClearUserActionInfo(int actionId, int userId) { var userActionInfo = this.CurrentDbSession.R_UserInfo_ActionInfoDal.LoadEntities(u => u.ActionInfoID == actionId && u.UserInfoID == userId).FirstOrDefault(); if (userActionInfo != null) { this.CurrentDbSession.R_UserInfo_ActionInfoDal.DeleteEntities(userActionInfo); } else { return(false); } return(CurrentDbSession.SaveChanges()); }
public bool SetUserRoleInfo(int userId, List <int> roleIdList) { //找到userID的用户,再通过roleIDList将用户的角色改了(添加或者删除) var userinfo = this.CurrentDal.LoadEntities(u => u.ID == userId).FirstOrDefault(); if (userinfo != null) { userinfo.RoleInfo.Clear(); foreach (var roleId in roleIdList) { var role = this.CurrentDbSession.RoleInfoDal.LoadEntities(u => u.ID == roleId).FirstOrDefault(); userinfo.RoleInfo.Add(role); } } return(CurrentDbSession.SaveChanges()); }
/// <summary> /// 为角色分配权限 /// </summary> /// <param name="roleId">角色编号</param> /// <param name="actionIdList">权限编号列表</param> /// <returns></returns> public bool SetRoleActionInfo(int roleId, List <int> actionIdList) { //获取角色信息. var role = CurrentDbSession.RoleDal.LoadEntities(r => r.Id == roleId).FirstOrDefault(); if (role != null) { role.ActionInfo.Clear(); foreach (int actionId in actionIdList) { var actionInfo = CurrentDbSession.ActionInfoDal.LoadEntities(a => a.Id == actionId).FirstOrDefault(); role.ActionInfo.Add(actionInfo); } return(CurrentDbSession.SaveChanges() > 0); } return(false); }
public bool SetUserActionInfo(int actionId, int userId, bool isPass) { //判断userId以前是否有了该actionId,如果有了只需要修改isPass状态,否则插入。 var r_userInfo_actionInfo = CurrentDbSession.R_User_ActionInfoDal.LoadEntities(a => a.ActionInfoId == actionId && a.UserId == userId).FirstOrDefault(); if (r_userInfo_actionInfo == null) { R_User_ActionInfo userInfoActionInfo = new R_User_ActionInfo(); userInfoActionInfo.ActionInfoId = actionId; userInfoActionInfo.UserId = userId; userInfoActionInfo.IsPass = isPass; CurrentDbSession.R_User_ActionInfoDal.Add(userInfoActionInfo); } else { r_userInfo_actionInfo.IsPass = isPass; CurrentDbSession.R_User_ActionInfoDal.Update(r_userInfo_actionInfo); } return(CurrentDbSession.SaveChanges() > 0); }
/// <summary> /// 为用户分配角色 /// </summary> /// <param name="userId">用户编号</param> /// <param name="roleIdList">要分配的角色的编号</param> /// <returns></returns> public bool SetUserRoleInfo(int userId, List <int> roleIdList) { bool isSuccess = false; var userInfo = CurrentDbSession.UserInfoDal.LoadEntities(o => o.Id == userId).FirstOrDefault(); if (userInfo != null) { userInfo.RoleInfo_UserInfo.Clear(); foreach (int roleId in roleIdList) { var roleInfo = CurrentDbSession.RoleInfoDal.LoadEntities(o => o.Id == roleId).FirstOrDefault(); RoleInfo_UserInfo roleInfo_UserInfo = new RoleInfo_UserInfo(); roleInfo_UserInfo.RoleInfoId = roleInfo.Id; roleInfo_UserInfo.UserInfoId = userId; userInfo.RoleInfo_UserInfo.Add(roleInfo_UserInfo); } isSuccess = CurrentDbSession.SaveChanged(); } return(isSuccess); }
/// <summary> /// 完成用户权限的分配 /// </summary> /// <param name="actionId"></param> /// <param name="userId"></param> /// <param name="isPass"></param> /// <returns></returns> public bool SetUserActionInfo(int actionId, int userId, bool isPass) { //判断userId以前是否有了该actionId,如果有了只需要修改isPass状态,否则插入。 var UserInfo_ActionInfo = CurrentDbSession.UserInfo_ActionInfoDal.LoadEntities(o => o.ActionInfoId == actionId && o.UserInfoId == userId).FirstOrDefault(); if (UserInfo_ActionInfo == null) { UserInfo_ActionInfo userInfo_ActionInfo = new UserInfo_ActionInfo(); userInfo_ActionInfo.ActionInfoId = actionId; userInfo_ActionInfo.UserInfoId = userId; userInfo_ActionInfo.IsPass = isPass; CurrentDbSession.UserInfo_ActionInfoDal.AddEntity(userInfo_ActionInfo); } else { UserInfo_ActionInfo.IsPass = isPass; CurrentDbSession.UserInfo_ActionInfoDal.EditEntity(UserInfo_ActionInfo); } return(CurrentDbSession.SaveChanged()); }
//最不能用的。纯菜鸟 //RoleDal dal =new RoleDal(); //一般鸟 //private IRoleDal dal = new Guanghui.OA.EFDAL.RoleDal(); //private IRoleDal dal = new Guanghui.OA.ADONETDAL.RoleDal(); //鸟: //private IRoleDal dal = DalFactory.GetRoleDal();//走了抽象工厂了。 //private IRoleDal dal; //private IDbSession dbSession; //public RoleService() //{ // dbSession = DbSessionFactory.GetCurrentDbSession(); // dal= dbSession.RoleDal; //} ////依赖注入。Spring.Net //public Role Add(Role Role) //{ // //一个业务方法,一般都会操作多个表。 // dal.Add(Role); // dbSession.SaveChanges(); // dal.Delete(Role); // dal.Update(Role); // dbSession.SaveChanges(); // return Role; //} #endregion #region 批量删除 public int DeleteRoles(IList <int> ids) { //foreach (var id in ids) //{ // var role = DbSession.RoleDal.LoadEntities(u => u.Id == id).FirstOrDefault(); // if (role != null) // { // role.DelFlag = (short)Guanghui.OA.Model.Enum.DelFlagEnum.Deleted; // } //} //return DbSession.SaveChanges(); var roles = CurrentDbSession.RoleDal.LoadEntities(u => ids.Contains(u.Id)); foreach (var role in roles) { //role.DelFlag = (short)Guanghui.OA.Model.Enum.DelFlagEnum.Deleted; //DbSession.RoleDal.Delete(role); } return(CurrentDbSession.SaveChanges()); }
//最不能用的。纯菜鸟 //UserDal dal =new UserDal(); //一般鸟 //private IUserDal dal = new Guanghui.OA.EFDAL.UserDal(); //private IUserDal dal = new Guanghui.OA.ADONETDAL.UserDal(); //鸟: //private IUserDal dal = DalFactory.GetUserDal();//走了抽象工厂了。 //private IUserDal dal; //private IDbSession dbSession; //public UserService() //{ // dbSession = DbSessionFactory.GetCurrentDbSession(); // dal= dbSession.UserDal; //} ////依赖注入。Spring.Net //public User Add(User user) //{ // //一个业务方法,一般都会操作多个表。 // dal.Add(user); // dbSession.SaveChanges(); // dal.Delete(user); // dal.Update(user); // dbSession.SaveChanges(); // return user; //} #endregion #region 批量删除 public int DeleteUsers(IList <int> ids) { //foreach (var id in ids) //{ // var user = DbSession.UserDal.LoadEntities(u => u.Id == id).FirstOrDefault(); // if (user != null) // { // user.DelFlag = (short)Guanghui.OA.Model.Enum.DelFlagEnum.Deleted; // } //} //return DbSession.SaveChanges(); var userList = CurrentDbSession.UserDal.LoadEntities(u => ids.Contains(u.Id)); foreach (var user in userList) { //DbSession.UserDal.Delete(user); user.DelFlag = (short)Guanghui.OA.Model.Enum.DelFlagEnum.Deleted; } return(CurrentDbSession.SaveChanges()); }
/// <summary> /// 为角色分配权限 /// </summary> /// <param name="roleId">角色编号</param> /// <param name="actionIdList">权限编号列表</param> /// <returns></returns> public bool SetRoleActionInfo(int roleId, List <int> actionIdList) { bool isSuccess = false; //获取角色信息. var roleInfo = CurrentDbSession.RoleInfoDal.LoadEntities(o => o.Id == roleId).FirstOrDefault(); if (roleInfo != null) { roleInfo.RoleInfo_ActionInfo.Clear(); foreach (int actionId in actionIdList) { var actionInfo = CurrentDbSession.ActionInfoDal.LoadEntities(o => o.Id == actionId).FirstOrDefault(); RoleInfo_ActionInfo roleInfo_ActionInfo = new RoleInfo_ActionInfo(); roleInfo_ActionInfo.ActionInfoId = actionInfo.Id; roleInfo_ActionInfo.RoleInfoId = roleId; roleInfo.RoleInfo_ActionInfo.Add(roleInfo_ActionInfo); } isSuccess = CurrentDbSession.SaveChanged(); } return(isSuccess); }
/// <summary> /// 实现radio按钮的禁止允许 /// </summary> /// <param name="actionId">权限编号</param> /// <param name="userId">用户编号</param> /// <param name="isPass"></param> /// <returns></returns> public bool SetUserActionInfo(int actionId, int userId, bool isPass) { //var userInfo = this.CurrentDbSession.UserInfoDal.LoadEntities(u=>u.ID==userId).FirstOrDefault(); //var isExt = (from a in userInfo.R_UserInfo_ActionInfo // where a.ActionInfoID == actionId // select a).FirstOrDefault(); var isExt = this.CurrentDbSession.R_UserInfo_ActionInfoDal.LoadEntities(u => u.UserInfoID == userId && u.ActionInfoID == actionId).FirstOrDefault(); if (isExt != null) { isExt.IsPass = isPass; this.CurrentDbSession.R_UserInfo_ActionInfoDal.EditEntities(isExt); } else { R_UserInfo_ActionInfo r_UserInfo_ActionInfo = new R_UserInfo_ActionInfo(); r_UserInfo_ActionInfo.ActionInfoID = actionId; r_UserInfo_ActionInfo.UserInfoID = userId; r_UserInfo_ActionInfo.IsPass = isPass; this.CurrentDbSession.R_UserInfo_ActionInfoDal.AddEntities(r_UserInfo_ActionInfo); } return(CurrentDbSession.SaveChanges()); }
/// <summary> /// 添加数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool AddEntity(T entity) { CurrentDal.AddEntity(entity); return(CurrentDbSession.SaveChanged()); }
public bool Insert(T Model) { CurrentDal.Insert(Model); return(CurrentDbSession.SaveChange()); }
public bool Delete(T Model) { CurrentDal.Delete(Model); return(CurrentDbSession.SaveChange()); }
public bool Update(T entity) { CurrentDal.Update(entity); return(CurrentDbSession.SaveChanges() > 0); }
public void Dispose() { CurrentDbSession.Dispose(); }
/// <summary> /// 更新 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool EditEntity(T entity) { CurrentDal.EditEntity(entity); return(CurrentDbSession.SaveChanges()); }
/// <summary> /// 删除 /// </summary> /// <param name="entity"></param> /// <returns></returns> public bool DeleteEntity(T entity) { CurrentDal.DeleteEntity(entity); return(CurrentDbSession.SaveChanges()); }
/// <summary> /// 删除 /// </summary> /// <typeparam name="M"></typeparam> /// <param name="entity"></param> /// <returns></returns> public bool DeleteEntity<M>(M entity) where M : class, new() { CurrentDal.DeleteEntity(entity); return CurrentDbSession.SaveChanged(); }
/// <summary> /// 添加数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public T AddEntity(T entity) { CurrentDal.AddEntity(entity); CurrentDbSession.SaveChanges(); return(entity); }
/// <summary> /// 更新 /// </summary> /// <typeparam name="M"></typeparam> /// <param name="entity"></param> /// <returns></returns> public bool EditEntity <M>(M entity) where M : class, new() { CurrentDal.EditEntity(entity); return(CurrentDbSession.SaveChanged()); }