/// <summary> /// 根据id删除用户角色信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool DeleteUserRoleInfo(Guid id) { bool ret = false; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IUserRole dp = DataProvider.DbUserRoleDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; ret = dp.DeleteUserRoleInfo(cmd, id); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("DeleteUserRoleInfo()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(ret); }
/// <summary> /// 新增或更新用户权限信息 /// </summary> /// <param name="info"></param> /// <param name="mode"></param> /// <returns></returns> public static bool AddOrUpdateUserPermissionInfo(UserPermission info, EnumAddOrUpdate mode) { bool ret = false; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IUserPermission dp = DataProvider.DbUserPermissionDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; ret = dp.AddOrUpdateUserPermissionInfo(cmd, info, mode); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("AddOrUpdateUserPermissionInfo()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(ret); }
/// <summary> /// 根据uid获取用户角色信息 /// </summary> /// <param name="uid"></param> /// <returns></returns> public static List <UserRole> GetUserRoleInfoByUid(Guid uid) { List <UserRole> list = new List <UserRole>(); IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IUserRole dp = DataProvider.DbUserRoleDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; list = dp.GetUserRoleByUid(cmd, uid); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("GetUserRoleByUid()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(list); }
/// <summary> /// 根据id获取用户权限信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static UserPermission GetUserPermissionInfoById(Guid id) { UserPermission info = null; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IUserPermission dp = DataProvider.DbUserPermissionDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; info = dp.GetUserPermissionInfoById(cmd, id); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("GetUserPermissionInfoById()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(info); }
/// <summary> /// 获取权限列表 /// </summary> /// <param name="fields"></param> /// <param name="whereCondition"></param> /// <param name="startIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <PermissionInfo> GetPermissionInfoPageList(string fields, string whereCondition, int startIndex, int pageSize) { List <PermissionInfo> list = new List <PermissionInfo>(); IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IPermission dp = DataProvider.DbPermissionDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; list = dp.GetPermissionInfoPageList(cmd, fields, whereCondition, startIndex, pageSize); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("GetPermissionInfoPageList()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(list); }
/// <summary> /// 根据name获取角色信息 /// </summary> /// <param name="name">name</param> /// <returns></returns> public RoleInfo GetRoleInfoByName(string name) { RoleInfo info = null; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IRole dp = DataProvider.DbRoleDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; info = dp.GetRoleInfoByName(cmd, name); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("GetRoleInfoByName()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(info); }
/// <summary> /// 用户组信息分页获取 /// </summary> /// <param name="fields">字段</param> /// <param name="whereCondition">where条件</param> /// <param name="startIndex">开始下标</param> /// <param name="pageSize">页面大小</param> /// <returns></returns> public static List <GroupInfo> GetGroupInfoPageList(string fields, string whereCondition, string orderby, string limit) { List <GroupInfo> list = new List <GroupInfo>(); IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IGroup dp = DataProvider.DbGroupDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; list = dp.GetGroupInfoPageList(cmd, fields, whereCondition, orderby, limit); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("GetGroupInfoPageList()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(list); }
/// <summary> /// 根据name获取用户登录信息 /// </summary> /// <param name="name"></param> /// <returns></returns> public static UserLogin GetUserLoginInfoByName(string name) { UserLogin info = null; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IUserLogin dp = DataProvider.DbUserLoginDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); info = dp.GetUserLoginInfoByName(cmd, name); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } } finally { if (conn != null) { conn.Close(); } } return(info); }