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