Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
Wms/WMS.BLL/SysServer/ExceptionServer.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
Wms/WMS.BLL/BllSoServer/ExportNoticeServer.cs
@@ -2887,7 +2887,15 @@ // 出库总表 状态改为部分分配 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(); // 库存明细表 状态修改为异常锁定 锁定数量修改为托盘上数量 @@ -2901,7 +2909,7 @@ // 库存总表 锁定数量=当前锁定数量 + (库存明细托盘上数量-库存明细托盘上已锁定的数量) 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(); // 拣货明细表 删除 Wms/WMS.BLL/SysServer/ExceptionServer.cs
@@ -228,6 +228,7 @@ { //储位表, 将储位标志Flag修改为:0:正常 storageLocat.Flag = "0"; storageLocat.Status = "1"; storageLocat.UpdateUser = tabledto.UpdateUser; storageLocat.UpdateTime = time; @@ -240,7 +241,7 @@ Db.Updateable(stockDetail).UpdateColumns(it => new { it.LockQty, it.Status, it.UpdateUser, it.UpdateTime }).ExecuteCommand(); //库存总表,修改锁定数量LockQty=锁定数量-托盘数量 stock.LockQty = Convert.ToInt32(stock.LockQty - stockDetail.Qty); stock.LockQty = Convert.ToDecimal(stock.LockQty - stockDetail.Qty); stock.UpdateUser = tabledto.UpdateUser; stock.UpdateTime = time;