/// <summary>
/// 获取待完成上架工单
/// </summary>
/// <returns></returns>
public List <ReplenishOrderDto> GetReplenishOrderDto(BasePageDataApo pageDataApo, out int totalCount)
{
totalCount = 0;
List <ReplenishOrderDto> data;
//查询语句
var queryable = Db.Queryable <ReplenishOrder, ReplenishSubOrder, ReplenishSubOrderdtl>((ro, rso, rsod) => new object[] {
JoinType.Left, rso.replenish_order_code == ro.code,
JoinType.Left, rso.id == rsod.replenish_sub_orderid
})
.GroupBy((ro, rso) => ro.code)
.Where((ro, rso, rsod) => rsod.status == (int)RPOStatusType.待完成)
.OrderBy((ro, rso) => ro.create_time, OrderByType.Desc)
.Select((ro, rso, rsod) => new ReplenishOrderDto
{
id = ro.id,
code = ro.code,
status = ro.status,
distribute_time = ro.create_time,
not_picked_goods_num = SqlFunc.AggregateCount(rsod.id)
});
//如果小于0，默认查全部
if (pageDataApo.PageSize > 0)
{
data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount);
}
else
{
data = queryable.ToList();
totalCount = data.Count();
}
return(data);
}
public BasePageDataDto <PickingSubOrderDto> GetPickingSubOrderDto(BasePageDataApo basePageDataApo)
{
return(new BasePageDataDto <PickingSubOrderDto>()
{
PageIndex = basePageDataApo.PageIndex,
PageSize = basePageDataApo.PageSize,
Data = pickingDal.GetPickingSubOrderDto(basePageDataApo, out int totalCount).Where(item => item.picked_goods_num > 0).ToList(),
TotalCount = totalCount
});
public BasePageDataDto <ReplenishSubOrderDto> GetReplenishSubOrderDto(BasePageDataApo basePageDataApo)
{
return(new BasePageDataDto <ReplenishSubOrderDto>()
{
PageIndex = basePageDataApo.PageIndex,
PageSize = basePageDataApo.PageSize,
Data = replenishDal.GetReplenishSubOrderDto(basePageDataApo, out int totalCount).Where(item => item.not_picked_goods_num > 0).ToList(),
//Data = replenishDal.GetReplenishSubOrderDto(basePageDataApo, out int totalCount).ToList(),
TotalCount = totalCount
});
public List <ReplenishSubOrderDto> GetReplenishSubOrderDto(BasePageDataApo pageDataApo, out int totalCount)
{
totalCount = 0;
List <ReplenishSubOrderDto> data;
//查询语句
var queryable = Db.Queryable <ReplenishSubOrder, ReplenishOrder>((rso, ro) => new object[] {
JoinType.Left, rso.replenish_order_code == ro.code
})
.Where((rso, ro) => (rso.status == (int)RSOStatusType.待上架 || rso.status == (int)RSOStatusType.部分上架))
.OrderBy(rso => rso.create_time, OrderByType.Desc)
.Select((rso, ro) => new ReplenishSubOrderDto
{
id = rso.id,
code = rso.code,
replenish_order_code = rso.replenish_order_code,
create_time = rso.create_time,
status = rso.status,
distribute_time = ro.create_time,
position = rso.position,
not_picked_goods_num = SqlFunc.Subqueryable <ReplenishSubOrderdtl>()
.Where(itsub => itsub.replenish_sub_orderid == rso.id && itsub.status == (int)RPOStatusType.待完成)
.Count()
});
//如果小于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 <PickingSubOrderDto> GetPickingSubOrderDto(BasePageDataApo pageDataApo, out int totalCount)
{
totalCount = 0;
List <PickingSubOrderDto> data;
//查询语句
var queryable = Db.Queryable <PickingSubOrder, PickingOrder>((pso, po) => new object[] {
JoinType.Left, pso.picking_order_code == po.code
})
.Where((pso, po) => (pso.status == (int)PSOStatusType.待拣货 || pso.status == (int)PSOStatusType.部分拣货))
.OrderBy(pso => pso.create_time, OrderByType.Desc)
.Select((pso, po) => new PickingSubOrderDto
{
id = pso.id,
code = pso.code,
picking_order_code = pso.picking_order_code,
create_time = pso.create_time,
status = pso.status,
distribute_time = po.create_time,
position = pso.position,
picked_goods_num = SqlFunc.Subqueryable <PickingSubOrderdtl>()
.Where(itsub => itsub.picking_sub_orderid == pso.id && itsub.status == (int)RPOStatusType.待完成)
.Count()
});
//如果小于0，默认查全部
if (pageDataApo.PageSize > 0)
{
data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount);
}
else
{
data = queryable.ToList();
totalCount = data.Count();
}
return(data);
}
