/// <summary> /// 根据id删除用户组权限信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public static bool DeleteGroupPermissionInfo(Guid id) { bool ret = false; IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IGroupPermission dp = DataProvider.DbGroupPermissionDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; ret = dp.DeleteGroupPermissionInfo(cmd, id); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("DeleteGroupPermissionInfo()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(ret); }
/// <summary> /// 获取用户组权限列表 /// </summary> /// <param name="gid">用户组编号</param> /// <returns></returns> public static List <GroupPermission> GetGroupPermissionInfoByGid(Guid gid) { List <GroupPermission> list = new List <GroupPermission>(); IDbConnection conn = null; IDbCommand cmd = null; IDbTransaction trans = null; try { IGroupPermission dp = DataProvider.DbGroupPermissionDP; conn = DbConnOperation.CreateMySqlConnection(); cmd = conn.CreateCommand(); conn.Open(); trans = conn.BeginTransaction(); cmd.Transaction = trans; list = dp.GetGroupPermissionInfoByGid(cmd, gid); trans.Commit(); } catch (Exception ex) { if (trans != null) { trans.Rollback(); } log.Error(string.Format("GetGroupPermissionInfoByGid()出错,错误信息如下:{0}", ex.Message)); } finally { if (conn != null) { conn.Close(); } } return(list); }