| | |
|---|
| | | /// <param name="lotNo">批次</param> |
|---|
| | | /// <param name="status">库存状态</param> |
|---|
| | | /// <param name="inspectStatus">质检状态</param> |
|---|
| | | /// <param name="wareHouseNo">所属仓库</param> |
|---|
| | | /// <param name="areaNo">所属区域</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public async Task<List<MateDataStockDto>> GetDataStockList(string selectType, string skuNo, string skuName, string ownerNo, |
|---|
| | | string ownerName, string lotNo, string status, string inspectStatus) |
|---|
| | | string ownerName, string lotNo, string status, string inspectStatus, string wareHouseNo, string areaNo) |
|---|
| | | { |
|---|
| | | Expression<Func<DataStockDetail, bool>> item = Expressionable.Create<DataStockDetail>() |
|---|
| | | .AndIF(!string.IsNullOrEmpty(skuNo), a => a.SkuNo.Contains(skuNo)) |
|---|
| | |
|---|
| | | .AndIF(!string.IsNullOrEmpty(lotNo), a => a.LotNo.Contains(lotNo)) |
|---|
| | | .AndIF(!string.IsNullOrEmpty(status), a => a.Status == status) |
|---|
| | | .AndIF(!string.IsNullOrEmpty(inspectStatus), a => a.InspectStatus == inspectStatus) |
|---|
| | | .AndIF(!string.IsNullOrEmpty(wareHouseNo), a => a.WareHouseNo == wareHouseNo) |
|---|
| | | .AndIF(!string.IsNullOrEmpty(areaNo), a => a.AreaNo == areaNo) |
|---|
| | | .And(a => a.IsDel == "0") |
|---|
| | | .ToExpression();//注意 这一句 不能少 |
|---|
| | | |
|---|
