public object GetDetails(int page, int rows, string orderID, string orderDate, string customerCode, string customerName, string deliverLineCode)
{
if (orderDate == string.Empty || orderDate == null)
{
orderDate = DateTime.Now.ToString("yyyyMMdd");
}
else
{
orderDate = Convert.ToDateTime(orderDate).ToString("yyyyMMdd");
}
IQueryable <SortOrder> SortOrderQuery = SortOrderSearchRepository.GetQueryable();
var SortOrderSearch = SortOrderQuery.Where(i => i.OrderDate.Contains(orderDate) &&
i.OrderID.Contains(orderID) &&
i.CustomerCode.Contains(customerCode) &&
i.CustomerName.Contains(customerName) &&
i.DeliverLineCode.Contains(deliverLineCode))
.OrderBy(i => i.OrderID);
int total = SortOrderSearch.Count();
var SortOrder = SortOrderSearch.Skip((page - 1) * rows).Take(rows);
var sortOrder = SortOrder.ToArray().Select(s => new
{
s.OrderID,
OrderDate = Convert.ToInt32(s.OrderDate) / 10000 + "-" + (Convert.ToInt32(s.OrderDate) % 10000 / 100 > 10 ? "" : "0") + Convert.ToInt32(s.OrderDate) % 10000 / 100 + "-" + (Convert.ToInt32(s.OrderDate) % 100 > 10 ? "" : "0") + Convert.ToInt32(s.OrderDate) % 100,
OrderType = s.OrderType == "1" ? "普通客户": "大客户",
s.CustomerCode,
s.CustomerName,
s.QuantitySum,
s.DetailNum,
s.DeliverLine.DeliverLineName
});
return(new { total, rows = sortOrder.ToArray() });
}
public object GetDetails(int page, int rows, string OrderID, string OrderDate)
{
IQueryable <SortOrder> SortOrderQuery = SortOrderSearchRepository.GetQueryable();
var SortOrderSearch = SortOrderQuery.Where(i => i.OrderID.Contains(OrderID)).OrderBy(i => i.OrderID).AsEnumerable().Select(i => new
{
i.OrderID,
i.OrderDate,
i.OrderType,
i.CustomerCode,
i.CustomerName,
i.QuantitySum,
i.DetailNum
});
int total = SortOrderSearch.Count();
SortOrderSearch = SortOrderSearch.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = SortOrderSearch.ToArray() });
}
