/// <summary> /// 通过对象删除记录 /// </summary> /// <param name="item"></param> /// <returns></returns> public bool Del( TbSysUserRole item) { bool res = false; using (var connection = DataBase.GetOpenConnection()) { res = connection.Delete< TbSysUserRole>(item); } return res; }
/// <summary> /// 通过ID删除记录 /// </summary> /// <param name="id">需要删除的对象的ID</param> /// <returns></returns> public bool Del(int id) { bool res = false; TbSysUserRole item = new TbSysUserRole(); using (var connection = DataBase.GetOpenConnection()) { item = GetByID(id); res = connection.Delete<TbSysUserRole>(item); } return res; }
/// <summary> /// 同时对user和userRole进行添加 /// </summary> /// <param name="item1"></param> /// <param name="RoleIds"></param> /// <returns></returns> public int AddUserAndUserRole(TbSysUser User, string RoleIds) { try { string SRoleNames = ""; //用于保存拥有的角色 string[] IRoleIds = RoleIds.Split(new char[] { ',' });//拆分角色Id; TbSysUserRole UserRole = new TbSysUserRole();//userRole添加的对象 foreach (var ID in IRoleIds) { UserRole.IRoleId = int.Parse(ID); SRoleNames = srDao.GetByID(int.Parse(ID)).SRoleName + "," + SRoleNames; } //清除多余的分隔符',' SRoleNames = SRoleNames.Substring(0, SRoleNames.Length - 1); User.SRoleName = SRoleNames; User.SPassword = Utitil.MD5(User.SPassword); //对用户的密码在客户端进行MD5加密 User.SOtherPassword = Utitil.MD5(User.SOtherPassword); User.DCreateDate = DateTime.Now;//创建时间 User.DLastLoginDate = DateTime.Now;//默认最后登录时间为创建时间 suDao.Insert(User);//插入 UserRole.IUserId = User.Id; foreach (string id in IRoleIds) { UserRole.IRoleId = int.Parse(id); sysUserRoleDao.Insert(UserRole); } return 0; } catch (Exception ex) { return 0; } }
/// <summary> /// 插入一个对象 /// </summary> /// <param name="item">需要插入的对象</param> /// <returns></returns> public int Insert(TbSysUserRole item) { int id = 0; using (var connection = DataBase.GetOpenConnection()) { id = (int)connection.Insert<TbSysUserRole>(item); } return id; }
/// <summary> /// 更新用户角色 /// </summary> /// <param name="item"></param> /// <param name="RoleIds"></param> /// <returns></returns> public int PutUserAndUserRole(TbSysUser item, string RoleIds) { try { TbSysUser tempuser = new SysUserDAO().GetByID(item.Id); if (tempuser != null) { item.DCreateDate = tempuser.DCreateDate; //更新时不更新用户的创建时间 } //在对密码进行加密前先验证客户端传过来的密码是否非空 if (!String.IsNullOrEmpty(item.SPassword)) { item.SPassword = Utitil.MD5(item.SPassword); //对密码进行md5加密 //使用了更新密码功能 LogWriter.Default.WriteWarning("使用了管理员更新密码功能,ip:" + Utitil.getIP() + ",更改的用户名" + item.SUserName + ",当前用户id:" + SysUserInfo.GetUserID()); } else { item.SPassword = tempuser.SPassword; //在未更改密码的情况下,使用原密码 } if (!String.IsNullOrEmpty(item.SOtherPassword)) { item.SOtherPassword = Utitil.MD5(item.SOtherPassword); //对密码进行md5加密 //使用了更新密码功能 LogWriter.Default.WriteWarning("使用了管理员更新第二密码功能,ip:" + Utitil.getIP() + ",更改的用户名" + item.SUserName + ",当前用户id:" + SysUserInfo.GetUserID()); } else { item.SOtherPassword = tempuser.SOtherPassword; //在未更改密码的情况下,使用原密码 } if (!string.IsNullOrEmpty(RoleIds)) { string[] IRoleIds; string SRoleName = ""; IRoleIds = RoleIds.Split(new char[] { ',' });//拆分角色Id; TbSysUserRole UserRole = new TbSysUserRole();//userRole添加的对象 UserRole.IUserId = item.Id; IList<TbSysUserRole> OldUserRole = sysUserRoleDao.GetByPage("IUserId =" + item.Id, 0, int.MaxValue);//找到以前拥有的所有角色 if (OldUserRole.Count > 0) { sysUserRoleDao.Del(OldUserRole); //通过对象集的方法删除 } //添加user新的角色 foreach (string id in IRoleIds) { UserRole.IRoleId = int.Parse(id); SRoleName = srDao.GetByID(int.Parse(id)).SRoleName + "," + SRoleName;//拼装角色字符串 if (sysUserRoleDao.Insert(UserRole) == 0) return 0;//添加失败 } SRoleName = SRoleName.Substring(0, SRoleName.Length - 1); item.SRoleName = SRoleName; } suDao.Update(item); return 1; } catch (Exception ex) { return 0; } }