/// <summary>
/// 根据条件查询数据库,并返回DataTable集合(用于分页数据显示)
/// </summary>
/// <param name="condition">查询的条件</param>
/// <param name="pagerInfo">分页实体</param>
/// <param name="fieldToSort">排序字段</param>
/// <param name="desc">是否降序</param>
/// <returns>指定DataTable的集合</returns>
public virtual DataTable FindToDataTableWithPager2(string condition, ref PagerInfo pagerInfo, string fieldToSort, bool desc)
{
var action = "FindToDataTableWithPager2";
string url = GetTokenUrl(action) + string.Format("&fieldToSort={0}&desc={1}&condition={2}", fieldToSort.UrlEncode(), desc, condition.UrlEncode());
var postData = pagerInfo.ToJson();
DataTable result = new DataTable();
PageTableList list = JsonHelper <PageTableList> .ConvertJson(url, postData);
if (list != null)
{
pagerInfo.RecordCount = list.total_count;//修改总记录数
result = list.list;
}
return(result);
}
/// <summary>
/// 根据条件，从视图里面获取记录
/// </summary>
/// <param name="viewName">视图名称</param>
/// <param name="condition">查询条件</param>
/// <param name="sortField">排序字段</param>
/// <param name="isDescending">是否为降序</param>
/// <param name="pagerInfo">分页条件</param>
/// <returns></returns>
public virtual DataTable FindByViewWithPager(string viewName, string condition, string sortField, bool isDescending, PagerInfo pagerInfo)
{
var action = "FindByViewWithPager";
string url = GetTokenUrl(action) + string.Format("&viewName={0}&condition={1}&sortField={2}&isDescending={3}", viewName.UrlEncode(), condition.UrlEncode(), sortField.UrlEncode(), isDescending);
var postData = pagerInfo.ToJson();
DataTable result = new DataTable();
PageTableList list = JsonHelper <PageTableList> .ConvertJson(url, postData);
if (list != null)
{
pagerInfo.RecordCount = list.total_count;//修改总记录数
result = list.list;
}
return(result);
}
/// <summary>
/// 根据分页条件，返回DataSet对象
/// </summary>
/// <param name="pagerInfo">分页条件</param>
/// <returns></returns>
public virtual DataTable GetAllToDataTableWithPager(ref PagerInfo pagerInfo)
{
var action = "GetAllToDataTableWithPager";
string url = GetTokenUrl(action);
var postData = pagerInfo.ToJson();
DataTable result = new DataTable();
PageTableList list = JsonHelper <PageTableList> .ConvertJson(url, postData);
if (list != null)
{
pagerInfo.RecordCount = list.total_count;//修改总记录数
result = list.list;
}
return(result);
}