/// <summary>
/// 查询供应商采购单列表
/// </summary>
/// <param name="model">搜索实体对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-3</remarks>
public JsonResult PurchaseOrderList(SearchPurchaseOrderDetailsModel model)
{
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
var list = _purchaseOrderDetailsService.Select(model, ACultureHelper.GetLanguageID);
var data = new { rows = list.Data, total = list.Data.TotalCount };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 供应商采购单明细分布查询
/// </summary>
/// <param name="model">输入查询参数对象</param>
/// <param name="languageID">语言Id</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-9-8</remarks>
public ResultModel Select(SearchPurchaseOrderDetailsModel model, int languageID)
{
var purchaseOrderDetails = _database.Db.PurchaseOrderDetails;
var orderDetailslang = _database.Db.OrderDetails_lang;
var purchaseOrder = _database.Db.PurchaseOrder;
#region 查询参数条件
//查询参数条件
var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
//商品名称
if (!string.IsNullOrEmpty(model.ProductName))
{
whereParam = new SimpleExpression(whereParam, orderDetailslang.ProductName.Like("%" + model.ProductName + "%"), SimpleExpressionType.And);
}
#endregion
var query = purchaseOrderDetails.All().
Join(orderDetailslang).On(orderDetailslang.OrderDetailsID == purchaseOrderDetails.OrderDetailsID).
Select(
purchaseOrderDetails.OrderDetailsID,
purchaseOrderDetails.PurchaseOrderId,
purchaseOrderDetails.ProductId,
purchaseOrderDetails.CostPrice,
purchaseOrderDetails.SalesPrice,
purchaseOrderDetails.Quantity,
purchaseOrderDetails.returnedQty,
purchaseOrderDetails.RealQty,
(purchaseOrderDetails.CostPrice * purchaseOrderDetails.Quantity).As("Subtotal"),
purchaseOrderDetails.SkuName,
orderDetailslang.ProductName
).Where(whereParam).
Where(orderDetailslang.LanguageID == languageID && purchaseOrderDetails.PurchaseOrderId == model.PurchaseOrderId).OrderByOrderDetailsID();
var result = new ResultModel()
{
Data = new SimpleDataPagedList <PurchaseOrderDetailsModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
