protected virtual dynamic GetInstanceList(SelectTransaction <T> selecttrcn)
{
var size = GetPageSize();
List <T> list = selecttrcn.SelectAll(size.PageSize * (size.PageIndex - 1), size.PageSize * size.PageIndex + 1);//查询出结果
return(new { List = list, Count = selecttrcn.SelectRowsCount() });
}
/// <summary>
/// 获得查询结果
/// </summary>
/// <param name="selecttrcn"></param>
/// <returns></returns>
protected override dynamic GetInstanceList(SelectTransaction <T> selecttrcn)
{
var size = GetPageSize();
//组合查询语句
string where = GetSearchWhere();
InitParams();
if (param.Count > 0)
{
foreach (var p in param)
{
if (p.Value.Length > 0)
{
where += string.Format(" AND {0}='{1}' ", p.Key, p.Value);
}
else
{
where += string.Format(" AND {0}", p.Key);
}
}
}
List <T> list = selecttrcn.SelectAll(where, size.PageSize * (size.PageIndex - 1), size.PageSize * size.PageIndex + 1);//查询出结果
return(new { Draw = size.Draw, recordsTotal = selecttrcn.SelectRowsCount(), recordsFiltered = selecttrcn.SelectRowsCount(where), List = list });
}
protected virtual dynamic GetInstanceList(SelectTransaction <T> selecttrcn)
{
var size = GetPageSize();
List <T> list = selecttrcn.SelectAll(size.PageSize * (size.PageIndex - 1), size.PageSize * size.PageIndex + 1);//查询出结果
return(new { Draw = size.Draw, recordsTotal = selecttrcn.SelectRowsCount(), recordsFiltered = selecttrcn.SelectRowsCount(), List = list });
}