/// <summary>
/// 获取待完成拣货商品列表(通过总的拣货单)
/// </summary>
/// <returns></returns>
public List <PickingSubOrderdtlDto> GetPickingOrderdtlDto(PickingSubOrderdtlApo pageDataApo, out int totalCount)
{
totalCount = 0;
List <PickingSubOrderdtlDto> data;
//查询语句
var queryable = Db.Queryable <PickingSubOrderdtl, PickingSubOrder>((psod, pso) => new object[] {
JoinType.Left, psod.picking_sub_orderid == pso.id
})
.Where((psod, pso) => psod.status == (int)RPOStatusType.待完成 && pso.picking_order_code == pageDataApo.picking_order_code)
.OrderBy((psod, pso) => psod.birth_date, OrderByType.Desc)
.Select <PickingSubOrderdtlDto>();
//如果小于0，默认查全部
if (pageDataApo.PageSize > 0)
{
data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount);
}
else
{
data = queryable.ToList();
totalCount = data.Count();
}
return(data);
}
public List <PickingSubOrderdtlDto> GetPickingSubOrderdtlDto(PickingSubOrderdtlApo pageDataApo, out int totalCount)
{
totalCount = 0;
List <PickingSubOrderdtlDto> data;
//查询语句
var queryable = Db.Queryable <PickingSubOrderdtl>()
.Where(it => it.status == 0 && it.picking_sub_orderid == pageDataApo.picking_sub_orderid)
.OrderBy(it => it.birth_date, OrderByType.Desc)
.Select <PickingSubOrderdtlDto>();
//如果小于0，默认查全部
if (pageDataApo.PageSize > 0)
{
data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount);
}
else
{
data = queryable.ToList();
totalCount = data.Count();
}
return(data);
}
