/// <summary>
/// Get the store result in jquery data table format, return the DataTable Result with paging and sorting.
/// </summary>
/// <param name="dtParams">Jquery Data Table Parameter</param>
/// <param name="queryInventory">Query Store Object</param>
/// <returns>the DataTable Result with paging and sorting</returns>
public DTResult <Store> GetStoreDataTableResult(DTParams dtParams, Store queryStore)
{
var queryList = GetStoreQueryList(queryStore);
int count = queryList.Count();
var data = new List <Store>();
string sortOrder = "";
if ((dtParams == null) || (dtParams.SortOrder == null))
{ // 如果不是从界面进来的，是接口来的，就没有dtParams
dtParams.Start = 0;
dtParams.Length = count;
dtParams.Order = null;
sortOrder = "ID";
}
else
{
for (int i = 0; i < dtParams.Order.Length; i++)
{
var order = dtParams.Order[i].Column;
var sort = dtParams.Order[i].Dir;
var thenByStr = dtParams.Columns[order].Data.Replace("Layout", "");
sortOrder += thenByStr + " " + sort + ",";
}
sortOrder = sortOrder.Substring(0, sortOrder.Length - 1);
}
data = queryList.OrderBy(sortOrder).Skip(dtParams.Start).Take(dtParams.Length).ToList();
DTResult <Store> result = new DTResult <Store>
{
flag = SUCCESS, // return call flag
message = "Call Success", // return call message
draw = dtParams.Draw, // how many time it have been call for this method
data = data, // the data of datatable
recordsFiltered = count, // records filter count
recordsTotal = count // total records count
};
return(result);
}
/// <summary>
/// Get the store list result in jquery data table JSON format, return the DataTable Result with paging and sorting.
/// </summary>
/// <param name="dtParams">Jquery Data Table Parameter</param>
/// <param name="queryInventory">Query Store Object</param>
/// <returns>JSON: DataTable Result with paging and sorting</returns>
public JsonNetResult GetStoreDataTableJson(DTParams dtParams, Store queryStore)
{
DTResult <Store> storeDataTableResult = storeService.GetStoreDataTableResult(dtParams, queryStore);
return(new JsonNetResult(storeDataTableResult));
}
/// <summary>
/// Get the delivery list result in jquery data table JSON format, return the DataTable Result with paging and sorting.
/// </summary>
/// <param name="dtParams">Jquery Data Table Parameter</param>
/// <param name="queryInventory">Query Delivery Object</param>
/// <returns>JSON: DataTable Result with paging and sorting</returns>
public JsonNetResult GetDeliveryDataTableJson(DTParams dtParams, Delivery queryDelivery)
{
DTResult <Delivery> deliveryDataTableResult = deliveryService.GetDeliveryDataTableResult(dtParams, queryDelivery);
return(new JsonNetResult(deliveryDataTableResult));
}
/// <summary>
/// Get the mapRule list result in jquery data table JSON format, return the DataTable Result with paging and sorting.
/// </summary>
/// <param name="dtParams">Jquery Data Table Parameter</param>
/// <param name="queryInventory">Query Inventory Object</param>
/// <returns>JSON: DataTable Result with paging and sorting</returns>
public JsonNetResult GetMapRuleDataTableJson(DTParams dtParams, MapRule queryMapRule)
{
DTResult <MapRule> mapRuleDataTableResult = mapRuleService.GetMapRuleDataTableResult(dtParams, queryMapRule);
return(new JsonNetResult(mapRuleDataTableResult));
}
/// <summary>
/// Get the inventory list result in jquery data table JSON format, return the DataTable Result with paging and sorting.
/// </summary>
/// <param name="dtParams">Jquery Data Table Parameter</param>
/// <param name="queryInventory">Query Inventory Object</param>
/// <returns>JSON: DataTable Result with paging and sorting</returns>
public JsonNetResult GetInventoryDataTableJson(DTParams dtParams, Inventory queryInventory)
{
DTResult <Inventory> inventoryDataTableResult = inventoryService.GetInventoryDataTableResult(dtParams, queryInventory);
return(new JsonNetResult(inventoryDataTableResult));
}
/// <summary>
/// Get the carrier list result in jquery data table JSON format, return the DataTable Result with paging and sorting.
/// </summary>
/// <param name="dtParams">Jquery Data Table Parameter</param>
/// <param name="queryInventory">Query Carrier Object</param>
/// <returns>JSON: DataTable Result with paging and sorting</returns>
public JsonNetResult GetCarrierDataTableJson(DTParams dtParams, Carrier queryCarrier)
{
DTResult <Carrier> carrierDataTableResult = carrierService.GetCarrierDataTableResult(dtParams, queryCarrier);
return(new JsonNetResult(carrierDataTableResult));
}
