/// <summary>
/// 获取角色列表
/// </summary>
public PagedList <BsRole> GetPagingList(RoleQueryRequeest requeest)
{
requeest.Tables = "agent_bsrole br";
requeest.Tablefields = "br.*";
requeest.OrderBy = "br.SysNo desc";
//数据
var selectorRow = DBContext.Select <BsRole>(requeest.Tablefields).From(requeest.Tables);
BuildSelectRow(selectorRow, requeest);
var rows = selectorRow.QueryMany();
//总数
var selectorCount = DBContext.Select <int>("count(0)").From(requeest.Tables);
BuildSelectCount(selectorCount, requeest);
var totalCount = selectorCount.QuerySingle();
var list = new PagedList <BsRole> {
TData = rows,
TotalCount = totalCount,
};
//设置索引
if (requeest.CurrentPageIndex.HasValue)
{
list.CurrentPageIndex = requeest.CurrentPageIndex.Value;
}
return(list);
}
/// <summary>
/// 获取角色列表
/// </summary>
public PagedList <BsRole> GetPaging(RoleQueryRequeest requeest)
{
requeest.Tables = "agent_bsrole br";
requeest.Tablefields = "br.*";
requeest.OrderBy = "br.SysNo desc";
var row = DBContext.Select <BsRole>(requeest.Tablefields).From(requeest.Tables);
var count = DBContext.Select <int>("count(0)").From(requeest.Tables);
//条件查询委托
Action <string, string, object> setWhere = (@where, name, value) =>
{
row.AndWhere(where).Parameter(name, value);
count.AndWhere(where).Parameter(name, value);
};
if (requeest.Status.HasValue)
{
setWhere("br.Status=@Status", "Status", requeest.Status);
}
var list = new PagedList <BsRole>
{
TData = row.Paging(requeest.CurrentPageIndex.GetHashCode(), requeest.PageSize.GetHashCode()).OrderBy(requeest.OrderBy).QueryMany(),
CurrentPageIndex = requeest.CurrentPageIndex.GetHashCode(),
TotalCount = count.QuerySingle(),
};
return(list);
}
/// <summary>
/// 构造总数查询条件
/// </summary>
private static void BuildSelectCount <T>(ISelectBuilder <T> selector, RoleQueryRequeest requeest)
{
if (requeest.Status.HasValue)
{
selector.AndWhere("br.Status=@Status").Parameter("Status", requeest.Status);
}
}
/// <summary>
/// 获取角色列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>角色列表</returns>
public IList <BsRole> GetList(RoleQueryRequeest request)
{
var data = DBContext.Select <BsRole>("r.*").From("Agent_BsRole r");
//条件查询委托
Action <string, string, object> setWhere = (@where, name, value) => data.AndWhere(@where).Parameter(name, value);
if (request.Status.HasValue)
{
setWhere("r.Status = @Status", "Status", request.Status.Value);
}
return(data.QueryMany());
}
/// <summary>
/// 构造数据查询条件
/// </summary>
private static void BuildSelectRow <T>(ISelectBuilder <T> selector, RoleQueryRequeest requeest)
{
if (requeest.Status.HasValue)
{
selector.AndWhere("br.Status=@Status").Parameter("Status", requeest.Status);
}
if (!string.IsNullOrEmpty(requeest.OrderBy))
{
selector.OrderBy(requeest.OrderBy);
}
if (requeest.CurrentPageIndex.HasValue && requeest.PageSize.HasValue)
{
selector.Paging(requeest.CurrentPageIndex.Value, requeest.PageSize.Value);
}
}
/// <summary>
/// 获取角色列表
/// </summary>
public PagedList <BsRole> GetPaging(RoleQueryRequeest requeest)
{
var result = Using <IBsRole>().GetPaging(requeest);
return(result);
}
