/// <summary>
/// 数据分页
/// </summary>
/// <param name="context">HttpContext</param>
/// <param name="getDataFactory">委托，顺位输入参数：1.用于指定一屏显示的条数，需开启分页器;2.用于指定从哪一条数据开始显示到表格中去，3.排序列索引;4.升序还是降序，返回DataTablePageResult</param>
/// 时间：2016-04-19 16:35
/// 备注：
public static void ExecutePageQuery <T>(this HttpContext context, Func <int, int, int, string, DataTablePageResult> getDataFactory)
where T : class
{
int _iDisplayLength = context.Request["iDisplayLength"].ToInt32OrDefault(10); //用于指定一屏显示的条数，需开启分页器
int _iDisplayStart = context.Request["iDisplayStart"].ToInt32OrDefault(0); //用于指定从哪一条数据开始显示到表格中去
int _iSortCol = context.Request["iSortCol_0"].ToInt32OrDefault(0); //排序列索引
string _iSortDir = context.Request["sSortDir_0"].ToStringOrDefault("desc"); //升序还是降序
DataTablePageResult _result = getDataFactory(_iDisplayLength, _iDisplayStart, _iSortCol, _iSortDir);
if (_result.ExecuteState != HttpStatusCode.OK)
{
_result.iTotalDisplayRecords = 0;
_result.iTotalRecords = 0;
_result.aaData = new List <T>();
}
context.CreateResponse(_result, AjaxResultType.Success, string.Empty);
}
public void ProcessRequest(HttpContext context)
{
string _actionType = context.Request.Params["action"].ToStringOrDefault("UnKown");
if (_actionType.CompareIgnoreCase("getLocationList"))
{
int _pageIndex = context.Request.Params["PageIndex"].ToInt32OrDefault(1),
_pageSize = context.Request.Params["PageSize"].ToInt32OrDefault(10);
SqlServerDataOperator _helper = new SqlServerDataOperator(@"Server=YANZHIWEI-IT-PC\SQLEXPRESS;database=Northwind;user id=sa;Password=sasa");
PagedList <Order> _pageResult = _helper.ExecutePageQuery <Order>("[Orders]", "*", "OrderID", OrderType.Desc, string.Empty, _pageSize, _pageIndex);
AjaxResult _result = new AjaxResult(string.Empty, AjaxResultType.Success, _pageResult);
string _json = SerializeHelper.JsonSerialize(new JsonPagedList <Order>(_pageResult)).ParseJsonDateTime();
context.Response.Write(_json);
}
else if (_actionType.CompareIgnoreCase("exportLocationExcel"))
{
SqlServerDataOperator _helper = new SqlServerDataOperator(@"Server=YANZHIWEI-IT-PC\SQLEXPRESS;database=JooWMS;user id=sa;Password=sasa");
PagedList <Location> _pageResult = _helper.ExecutePageQuery <Location>("[Location]", "*", "ID", OrderType.Desc, string.Empty, 10, 1);
DataTable _result = GeneralMapper.ToDataTable <Location>(_pageResult, new string[4] {
"LocalNum", "LocalBarCode", "LocalName", "StorageNum"
});
string _filePath = context.Server.MapPath("~/UploadFiles/");
if (!Directory.Exists(_filePath))
{
Directory.CreateDirectory(_filePath);
}
string _filename = string.Format("库位管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss"));
NPOIExcel.ToExcel(_result, "库位管理", "库位", Path.Combine(_filePath, _filename));
context.CreateResponse(("/UploadFiles/" + _filename).Escape(), AjaxResultType.Success, string.Empty);
}
else
{
context.ExecutePageQuery <Person>((pageLength, pageIndex, orderIndex, orderBy) =>
{
var persons = GetPersons();
Func <Person, object> order = p =>
{
if (orderIndex == 0)
{
return(p.Id);
}
return(p.Name);
};
if ("desc" == orderBy)
{
persons = persons.OrderByDescending(order);
}
else
{
persons = persons.OrderBy(order);
}
//错误测试
//DataTablePageResult result = new DataTablePageResult();
//result.ExecuteMessage = "测试错误";
//result.ExecuteState = HttpStatusCode.BadGateway;
//正确测试
DataTablePageResult result = new DataTablePageResult();
result.iTotalDisplayRecords = persons.Count();
List <Person> _personList = new List <Person>();
result.iTotalRecords = persons.Count();
result.aaData = persons.Skip(pageIndex).Take(pageLength);
result.ExecuteState = HttpStatusCode.OK;
return(result);
});
// // Those parameters are sent by the plugin
// var iDisplayLength = int.Parse(context.Request["iDisplayLength"]);
// var iDisplayStart = int.Parse(context.Request["iDisplayStart"]);
// var iSortCol = int.Parse(context.Request["iSortCol_0"]);
// var iSortDir = context.Request["sSortDir_0"];
// // Fetch the data from a repository (in my case in-memory)
// var persons = GetPersons();
// // Define an order function based on the iSortCol parameter
// Func<Person, object> order = p =>
// {
// if (iSortCol == 0)
// {
// return p.Id;
// }
// return p.Name;
// };
// // Define the order direction based on the iSortDir parameter
// if ("desc" == iSortDir)
// {
// persons = persons.OrderByDescending(order);
// }
// else
// {
// persons = persons.OrderBy(order);
// }
// // prepare an anonymous object for JSON serialization
// var result = new
// {
// iTotalRecords = persons.Count(),
// iTotalDisplayRecords = persons.Count(),
// aaData = persons
// .Skip(iDisplayStart)
// .Take(iDisplayLength)
// };
// //var serializer = new JavaScriptSerializer();
//// var json = SerializationHelper.JsonSerialize(result);// serializer.Serialize(result);
// context.CreateResponse(result, System.Net.HttpStatusCode.OK);
// //context.Response.ContentType = "application/json";
// //context.Response.Write(json);
}
}
