| | |
| | | #endregion |
| | | |
| | | break; |
| | | case "0": |
| | | case "0": |
| | | var noticeDetail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.Id == item.ASNDetailNo); |
| | | if (noticeDetail == null) |
| | | { |
| | | throw new Exception("未查询到托盘绑定的入库单明细信息"); |
| | | } |
| | | var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == noticeDetail.ASNNo); |
| | | if (notice == null) |
| | | { |
| | | throw new Exception("未查询到托盘绑定的入库单信息"); |
| | | } |
| | | string ownerNo = notice.CustomerNo;//货主编码 |
| | | string ownerName = notice.CustomerName;//货主名称 |
| | | |
| | | var sku1 = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == noticeDetail.SkuNo); |
| | | string isinspect = "0"; |
| | |
| | | { |
| | | LotNo = item.LotNo, |
| | | LotText = noticeDetail.LotText, |
| | | SupplierLot = noticeDetail.SupplierLot, |
| | | SupplierLot = noticeDetail.SupplierLot, |
| | | SkuNo = noticeDetail.SkuNo, |
| | | SkuName = noticeDetail.SkuName, |
| | | Standard = noticeDetail.Standard, |
| | |
| | | PackagNo = noticeDetail.PackagNo, |
| | | IsBale = item.IsBale, |
| | | IsBelt = item.IsBelt, |
| | | |
| | | OwnerNo = ownerNo, |
| | | OwnerName = ownerName, |
| | | |
| | | IsDel = "0", |
| | | CreateUser = 0, |
| | |
| | | LockQty = 0, |
| | | FrozenQty = 0, |
| | | |
| | | OwnerNo = ownerNo, |
| | | OwnerName = ownerName, |
| | | |
| | | IsDel = "0", |
| | | CreateUser = userId, |
| | | CreateTime = comTime |
| | |
| | | var asnDetailNum = Db.Queryable<BllArrivalNoticeDetail>() |
| | | .Count(m => m.IsDel == "0" && m.ASNNo == noticeDetail.ASNNo && m.Status != "2"); |
| | | if (asnDetailNum == 0) |
| | | { |
| | | var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == noticeDetail.ASNNo); |
| | | { |
| | | notice.Status = "2"; |
| | | notice.CompleteTime = comTime; |
| | | Db.Updateable(notice).ExecuteCommand(); |