public IEnumerable <UserRoleEntity> GetPageList(Pagination pagination, string queryJson)
{
var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_UserRole where 1=1");
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyword = queryParam["keyword"].ToString();
//switch (condition)
//{
// case "EnCode": //岗位编号
// sql.Append(" and (charindex(@0,EnCode)>0)", keyword);
// break;
// case "FullName": //岗位名称
// sql.Append(" and (charindex(@0,FullName)>0)", keyword);
// break;
// default:
// break;
//}
}
if (!string.IsNullOrWhiteSpace(pagination.sidx))
{
sql.OrderBy(new object[] { pagination.sidx + " " + pagination.sord });
}
var currentpage = Base_UserRole.Page(pagination.page, pagination.rows, sql);
//数据对象
var pageList = currentpage.Items;
//分页对象
pagination.records = Converter.ParseInt32(currentpage.TotalItems);
return(EntityConvertTools.CopyToList <Base_UserRole, UserRoleEntity>(pageList.ToList()));
}
