/// <summary>
/// 返回分页数据
/// Created:20170330(ChengMengjia)
/// </summary>
/// <param name="QueryHead"></param>
/// <param name="QueryBody"></param>
/// <param name="qlist"></param>
/// <returns></returns>
public static GridData GetGridData(int PageIndex, int PageSize, string QueryHead, string QueryBody, List <QueryField> qlist)
{
GridData result = new GridData();
result.count = 0;
result.data = new DataTable();
string sql = "select count(1) n " + QueryBody;
DataSet ds = ExecuteDataset(sql, qlist);
if (ds != null && ds.Tables.Count > 0)
{
result.count = int.Parse(ds.Tables[0].Rows[0]["n"].ToString());
sql = QueryHead + QueryBody;
DataTable dt = NHHelper.ExecutePageDataTable(sql, qlist, PageSize, PageIndex);
if (dt != null)
{
dt.Columns.Add("RowNo");
int i = 1;
if (PageIndex >= 1)
{
i += (PageIndex - 1) * PageSize;
}
foreach (DataRow row in dt.Rows)
{
row["RowNo"] = i;
i++;
}
}
result.data = dt;
}
return(result);
}