| | |
| | | |
| | | // 出库总表 状态改为部分分配 |
| | | var noticeModel = Db.Queryable<BllExportNotice>().First(m => m.SONo == noticeDetailModel.SONo && m.IsDel == "0"); |
| | | noticeModel.Status = "1"; |
| | | if (noticeDetailModel.AllotQty<=0) |
| | | { |
| | | noticeModel.Status = "0"; |
| | | } |
| | | else |
| | | { |
| | | noticeModel.Status = "1"; |
| | | } |
| | | |
| | | Db.Updateable(noticeModel).ExecuteCommand(); |
| | | |
| | | // 库存明细表 状态修改为异常锁定 锁定数量修改为托盘上数量 |
| | |
| | | |
| | | // 库存总表 锁定数量=当前锁定数量 + (库存明细托盘上数量-库存明细托盘上已锁定的数量) |
| | | var stockModel = Db.Queryable<DataStock>().First(m => m.LotNo == stockDetailModel.LotNo && m.SkuNo == stockDetailModel.SkuNo && m.IsDel == "0"); |
| | | stockModel.LockQty = stockModel.LockQty + (int)(stockDetailModel.Qty - lockQty); |
| | | stockModel.LockQty = stockModel.LockQty + (decimal)(stockDetailModel.Qty - lockQty); |
| | | Db.Updateable(stockModel).ExecuteCommand(); |
| | | |
| | | // 拣货明细表 删除 |
| | |
| | | foreach (var item in detailList) |
| | | { |
| | | totalQty += item.Qty; |
| | | totalAllotQty += Convert.ToInt32(item.AllotQty); |
| | | totalAllotQty += Convert.ToDecimal(item.AllotQty); |
| | | } |
| | | |
| | | if (totalAllotQty >= totalQty) |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取拆垛分拣主扫箱码出库 |
| | | /// 拆垛分拣主扫箱码出库 |
| | | /// </summary> |
| | | /// <param name="model">拆垛托盘号和WCS任务号</param> |
| | | /// <returns>拆垛托盘信息</returns> |
| | | /// <param name="model">箱号</param> |
| | | /// <returns>出库分拣口</returns> |
| | | public string BoxInfoExportWcs(string boxno) |
| | | { |
| | | try |
| | |
| | | //修改出库单信息 |
| | | Db.Updateable(notice).ExecuteCommand(); |
| | | |
| | | return ""; |
| | | return allot.LoadingAddre; |
| | | } |
| | | catch (Exception e) |
| | | { |