public IEnumerable <SysRole> GetRoles(string userId)
{
var p = new DynamicParameters();
p.Add("UserId", userId.Trim());
return(UserRoleRepository.GetListByTable <SysRole>(Constant.SqlTableUserAndRoleJoin, "r.SysId,r.RoleDesc,r.RoleName,r.RecordStatus", string.Format("ur.{1}={0}{1}", Constant.SqlReplaceParameterPrefix, "UserId"), p));
}
public IEnumerable <SysPrivilege> GetPrivilege(string userId)
{
var p = new DynamicParameters();
p.Add(Constant.ColumnSysId, userId.Trim());
p.Add(Constant.ColumnSysPrivilegePrivilegeMaster, (int)PrivilegeMaster.User);
return
(UserRoleRepository.GetListByTable <SysPrivilege>(
Constant.SqlTableUserPrivilegeJoin, Constant.SqlFieldsPrivilegeJoin
,
string.Format("p.{0} = {2}{0} and u.{1}={2}{1}", Constant.ColumnSysPrivilegePrivilegeMaster, Constant.ColumnSysId, Constant.SqlReplaceParameterPrefix), p));
}