/// <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);
}
