/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public async Task <JqGridModel <RolesModel> > GetList(RolesParam param)
{
string sql = "select Roles.* {0} from Roles {1} where 1=1 {2} {3}";
string orderBy = " ORDER BY Id ";
string where = string.Empty;
string join = "";
string select = "";
//条件
if (!string.IsNullOrEmpty(param.SearchKey))
{
where += string.Format(" and( RoleName like '%{0}%')", param.SearchKey);
}
//排序
if (!string.IsNullOrEmpty(param.sidx) && !string.IsNullOrEmpty(param.sord))
{
orderBy = string.Format(" order by {0} {1} ", param.sidx, param.sord);
}
sql = string.Format(sql, select, join, where, orderBy);
var list = await rolesRepository.FindListPager <RolesModel>(sql, param);
return(list);
}
