| | |
|---|
| | | BoxNo = obj.Data.BoxNo, |
|---|
| | | BoxNo2 = box.BoxNo2, |
|---|
| | | BoxNo3 = box2.BoxNo3, |
|---|
| | | Qty = obj.Data.Qty, |
|---|
| | | Qty = 1,//obj.Data.Qty, |
|---|
| | | BitBoxMark = obj.Data.BitBoxMark, |
|---|
| | | |
|---|
| | | ASNNo = "", |
|---|
| | |
|---|
| | | SkuNo = sku.SkuNo, |
|---|
| | | SkuName = sku.SkuName, |
|---|
| | | LotNo = box2.LotNo, |
|---|
| | | LotText = obj.Data.LotNoBoxNum, |
|---|
| | | LotText = "", |
|---|
| | | ProductionTime = DateTime.Parse(box2.ProductionTime), |
|---|
| | | ExpirationTime = DateTime.Parse(box2.ExpirationTime), |
|---|
| | | //CompleteTime = "", |
|---|
| | |
|---|
| | | CreateTime = comTime |
|---|
| | | }; |
|---|
| | | |
|---|
| | | //看要绑定的托盘在库存明细是否有储位信息 |
|---|
| | | string locatNoSql = $@"select LocatNo from DataStockDetail where PalletNo='{palletNo}' and isnull(LocatNo,'')!='' group by LocatNo"; |
|---|
| | | string locatNoStr = Db.Ado.GetString(locatNoSql); |
|---|
| | | sd1.LocatNo = string.IsNullOrWhiteSpace(locatNoStr) ? "" : locatNoStr; |
|---|
| | | |
|---|
| | | //添加库存明细 |
|---|
| | | sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity(); |
|---|
| | | } |
|---|
