| | |
| | | .And(m => m.AreaNo.Contains(categoryAreaNo)) |
| | | .ToExpression();//注意 这一句 不能少 |
| | | var total = 0; |
| | | var list = Db.Queryable<SysStorageLocat>().Where(item) |
| | | var list = Db.Queryable<SysStorageLocat>().Where(item).OrderByDescending(a=>a.Depth).OrderBy(a=>a.Column) |
| | | .Select(a => new LocatDto() |
| | | { |
| | | Id = a.Id, |
| | |
| | | throw new Exception($"{palletNo}托盘条码不具有箱码信息,不可入库!"); |
| | | } |
| | | skuNo = stockDetail.First().SkuNo; |
| | | //else |
| | | //{ |
| | | // //判断是否有零箱 |
| | | // var detailIdList = stockDetail.Select(m => m.Id).ToList(); |
| | | // var dataBoxInfo = Db.Queryable<DataBoxInfo>().Where(m => detailIdList.Contains(m.StockDetailId)).ToList(); |
| | | // if (dataBoxInfo.Count(m => m.BitBoxMark == "1")>0) |
| | | // { |
| | | // throw new Exception($"{palletNo}托盘上有零箱,不可入库!"); |
| | | // } |
| | | if (!string.IsNullOrWhiteSpace(stockDetail.First().WareHouseNo)) |
| | | { |
| | | if (stockDetail.First().WareHouseNo == "W01")//立库 |
| | | { |
| | | throw new Exception($"{palletNo}托盘上在立库中有库存储位信息,请核实!"); |
| | | } |
| | | |
| | | //} |
| | | if (stockDetail.First().WareHouseNo == "W02")//平库 |
| | | { |
| | | var locatePingKu = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == stockDetail.First().LocatNo); |
| | | if (locatePingKu != null) |
| | | { |
| | | locatePingKu.Status = "0"; |
| | | Db.Updateable(locatePingKu).ExecuteCommand(); |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | //获取对应回库规则 |
| | |
| | | IsBelt = item.IsBelt, |
| | | Demo = item.Demo, |
| | | |
| | | OwnerNo = ownerNo, |
| | | OwnerName = ownerName, |
| | | |
| | | IsDel = "0", |
| | | CreateUser = 0, |
| | | CreateTime = comTime |
| | | }; |
| | | //维护库存明细货主/供应商信息 |
| | | if (notice.Type == "0" || notice.Type == "2" || notice.Type == "4" || notice.Type == "6" || notice.Type == "7")//0:成品入库,2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库 |
| | | { |
| | | sd.OwnerNo = notice.CustomerNo;//货主编码 |
| | | sd.OwnerName = notice.CustomerName;//货主名称 |
| | | } |
| | | else if (notice.Type == "1" || notice.Type == "5")//1:采购入库,2:其它入库 |
| | | { |
| | | sd.SupplierNo= notice.CustomerNo;//供应商编码 |
| | | sd.SupplierName = notice.CustomerName;//供应商名称 |
| | | } |
| | | |
| | | //if (quality.Count() > 0) |
| | | //{ |
| | |
| | | LockQty = 0, |
| | | FrozenQty = 0, |
| | | |
| | | OwnerNo = ownerNo, |
| | | OwnerName = ownerName, |
| | | |
| | | IsDel = "0", |
| | | CreateUser = userId, |
| | | CreateTime = comTime |
| | | }; |
| | | //维护库存货主信息 |
| | | if (notice.Type == "0" || notice.Type == "2" || notice.Type == "4" || notice.Type == "6" || notice.Type == "7")//0:成品入库,2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库 |
| | | { |
| | | stock.OwnerNo = notice.CustomerNo;//货主编码 |
| | | stock.OwnerName = notice.CustomerName;//货主名称 |
| | | } |
| | | Db.Insertable(stock).ExecuteCommand(); |
| | | } |
| | | #endregion |