JC24WMS.git - Gitblit

			@@ -41,7 +41,7 @@
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public bool ErpAddExportNotice(SoInfo model)
			public void HttpAddExportNotice(SoInfo model)
			{
			try
			{
			@@ -139,8 +139,8 @@
			}
			else
			{
			stocks = stockList.Where(m=> m.SkuNo == d.SkuNo && !string.IsNullOrWhiteSpace(m.LotNo)).OrderBy(s => s.LotNo).ToList();

			stocks = stockList.Where(m => m.SkuNo == d.SkuNo && !string.IsNullOrWhiteSpace(m.LotNo)).OrderBy(s => s.LotNo).ToList();

			foreach (var demo in stocks)
			{
			if (q1 >= d.Qty)
			@@ -148,7 +148,7 @@
			continue;
			}
			var q2 = demo.Qty - demo.LockQty - demo.FrozenQty;


			if (q2 > d.Qty - q1)
			{
			q1 += d.Qty - q1;
			@@ -157,9 +157,9 @@
			else
			{
			q1 += q2;
			dic.Add(demo.Id,q2);
			dic.Add(demo.Id, q2);
			}


			}
			if (d.Qty >= q1)
			{
			@@ -185,7 +185,7 @@
			throw new Exception($"总库存中出库物料信息:{d.SkuNo} 库存数量不足");
			}
			}


			foreach (var s in dic)
			{
			var st = stockList.First(a => a.Id == s.Key);
			@@ -214,19 +214,19 @@
			CreateUser = 0,
			};
			list.Add(item);


			st.LockQty += s.Value;//锁定数量
			var i = Db.Updateable(st).UpdateColumns(it => new { it.LockQty })
			.ExecuteCommand();
			}


			}
			var notice = new BllExportNotice()
			{
			SONo = billNo,
			Type = model.SoType,
			Status = "0",
			Origin = "WMS",
			Origin = model.Origin,
			CustomerNo = model.Customer,
			CustomerName = customer.CustomerName,
			LogisticsId = logisticsId,
			@@ -242,12 +242,10 @@

			if (n <= 0 \|\| m <= 0)
			{
			Db.RollbackTran();
			return false;
			throw new Exception("入库单或明细添加保存失败");
			}
			Db.CommitTran();
			return true;


			}
			catch (Exception ex)
			{
			@@ -259,7 +257,6 @@
			}
			catch (Exception ex)
			{
			Db.RollbackTran();
			throw new Exception(ex.Message);
			}
			}
			@@ -363,31 +360,31 @@
			.LeftJoin<SysUserInfor>((a, b, c, d, e) => a.CheckUser == e.Id)
			.Select((a, b, c, d, e) => new ExportNoticeDto()
			{
			Id = a.Id,
			SONo = a.SONo,
			Type = a.Type,
			Status = a.Status,
			Origin = a.Origin,
			CustomerNo = a.CustomerNo,
			CustomerName = a.CustomerName,
			LotNo = a.LotNo,
			LotText = a.LotText,
			SupplierLot = a.SupplierLot,
			LogisticsId = a.LogisticsId,
			//Id = a.Id,
			//SONo = a.SONo,
			//Type = a.Type,
			//Status = a.Status,
			//Origin = a.Origin,
			//CustomerNo = a.CustomerNo,
			//CustomerName = a.CustomerName,
			//LotNo = a.LotNo,
			//LotText = a.LotText,
			//SupplierLot = a.SupplierLot,
			//LogisticsId = a.LogisticsId,
			LogisticsName = b.CarrierName,
			IsWave = a.IsWave,
			WaveNo = a.WaveNo,
			IsDespatch = a.IsDespatch,
			Demo = a.Demo,
			//IsWave = a.IsWave,
			//WaveNo = a.WaveNo,
			//IsDespatch = a.IsDespatch,
			//Demo = a.Demo,

			CreateUserName = c.RealName,
			UpdateUserName = c.RealName,
			CreateTime = a.CreateTime,
			UpdateTime = a.UpdateTime,
			//CreateTime = a.CreateTime,
			//UpdateTime = a.UpdateTime,

			CheckUserName = e.RealName,
			CheckTime = a.CheckTime
			})
			//CheckTime = a.CheckTime
			},true)
			.OrderByDescending(a => a.CreateTime)
			.ToOffsetPage(page, limit, ref total);
			count = total;
			@@ -436,16 +433,16 @@
			inspectStatus = "0";
			break;
			case "4"://不合格品出库
			skuType = "(0,1,2,3)";
			skuType = "(0,1,2,3,4)";
			inspectStatus = "2";
			break;
			case "5"://中间品出库
			skuType = "(4)";
			inspectStatus = "0,1";
			inspectStatus = "1";
			break;
			case "6"://代储出库
			skuType = "(0,1,2,3)";
			inspectStatus = "0,1";
			skuType = "(0,1,2,3,4)";
			inspectStatus = "0,1,2";
			break;
			case "8"://寄存出库
			skuType = "(0,1,2,3)";
			@@ -462,7 +459,7 @@
			throw new Exception("未查到对应出库类型的物料");
			}

			if (type!="8")
			if (type != "8")
			{
			skuList = skuList.Where(m => m != "100088").ToList();
			}
			@@ -478,6 +475,7 @@
			.AndIF(!string.IsNullOrWhiteSpace(inspectStatus), it => inspectStatus.Contains(it.InspectStatus))
			.And(m => skuList.Contains(m.SkuNo))
			.AndIF(type == "6", m => m.OwnerNo == ownerNo)//代储出库需要关联货主
			.AndIF(type != "6", m=> string.IsNullOrWhiteSpace(m.OwnerNo))
			.AndIF(!string.IsNullOrWhiteSpace(msg), it => (it.SkuNo.Contains(msg) \|\| it.SkuName.Contains(msg) \|\| it.LotNo.Contains(msg)))
			.And(it => (it.Qty - it.LockQty - it.FrozenQty) > 0)
			.And(it => (it.Status == "0" \|\| it.Status == "1"))
			@@ -506,7 +504,8 @@
			SkuName = it.SkuName,
			LotNo = it.LotNo,
			Standard = it.Standard,
			Qty = type == "4" ? it.Qty : it.Qty - it.LockQty - it.FrozenQty
			//Qty = type == "4" ? it.Qty : it.Qty - it.LockQty - it.FrozenQty,
			Qty = it.Qty - it.LockQty - it.FrozenQty,

			}).ToList();

			@@ -644,7 +643,7 @@
			//}
			//if (d.Qty >= q1)
			//{
			stocks = stockList.Where(s => s.SkuNo == d.SkuNo && string.IsNullOrWhiteSpace(s.LotNo)).ToList();
			stocks = stockList.Where(s => s.SkuNo == d.SkuNo && string.IsNullOrWhiteSpace(s.LotNo)).ToList();
			// if (stocks.Count == 0)
			// {
			// throw new Exception($"总库存中出库物料信息:{d.SkuNo}库存数量不足");
			@@ -666,7 +665,7 @@
			// throw new Exception($"总库存中出库物料信息:{d.SkuNo} 库存数量不足");
			//}
			}


			var item = new BllExportNoticeDetail()
			{
			SONo = billNo,
			@@ -693,7 +692,7 @@
			};
			list.Add(item);



			stocks.First().LockQty += d.Qty;//锁定数量
			var i = Db.Updateable(stocks.First()).UpdateColumns(it => new { it.LockQty })
			.ExecuteCommand();
			@@ -2162,6 +2161,10 @@
			{
			str += "3.要出库的托盘正在入库、";
			}
			if (string.IsNullOrWhiteSpace(str))
			{
			str += "托盘可执行，无需下发出库任务";
			}
			if (outDto1.Count > 0)
			{
			// 正式运行程序放开
			@@ -2171,23 +2174,23 @@

			try
			{
			//var time1 = DateTime.Now;//发送时间 .ToString("yyyy-MM-dd HH:mm:ss")
			//response = HttpHelper.DoPost(url, jsonData, "下发给WCS出库命令", "WCS");
			//var time2 = DateTime.Now;//返回时间 .ToString("yyyy-MM-dd HH:mm:ss")
			var time1 = DateTime.Now;//发送时间 .ToString("yyyy-MM-dd HH:mm:ss")
			response = HttpHelper.DoPost(url, jsonData, "下发给WCS出库命令", "WCS");
			var time2 = DateTime.Now;//返回时间 .ToString("yyyy-MM-dd HH:mm:ss")

			//////解析返回数据
			//var wcsModel = JsonConvert.DeserializeObject<WcsModel>(response);
			//if (wcsModel.StatusCode == 0)
			//{
			// //更改任务的发送返回时间//
			// new TaskServer().EditTaskIssueOk(list2, time1, time2);
			// str += "下发成功";
			//}
			//if (wcsModel.StatusCode == -1)
			//{
			// new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.Msg);
			// throw new Exception(wcsModel.Msg);
			//}
			var wcsModel = JsonConvert.DeserializeObject<WcsModel>(response);
			if (wcsModel.StatusCode == 0)
			{
			//更改任务的发送返回时间//
			new TaskServer().EditTaskIssueOk(list2, time1, time2);
			str += "下发成功";
			}
			if (wcsModel.StatusCode == -1)
			{
			new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.Msg);
			throw new Exception(wcsModel.Msg);
			}
			}
			catch (Exception ex)
			{
			@@ -2454,7 +2457,7 @@


			//重新下发出库任务
			public OutCommandDto AgainSendSoTask(string taskNo, int userId, string url)
			public OutCommandDto AgainSendSoTask(string taskNo, string Receiver, int userId, string url)
			{
			try
			{
			@@ -2505,22 +2508,42 @@
			{
			//程序正式发布后放开
			var time1 = DateTime.Now;//发送时间 .ToString("yyyy-MM-dd HH:mm:ss")
			var response = HttpHelper.DoPost(url, jsonData, "下发给WCS出库命令", "WCS");
			var response = HttpHelper.DoPost(url, jsonData, Receiver == "WCS" ? "下发给WCS出库命令" : "下发给AGV出库命令", "WCS");
			var time2 = DateTime.Now;//返回时间 .ToString("yyyy-MM-dd HH:mm:ss")

			////解析返回数据
			var wcsModel = JsonConvert.DeserializeObject<WcsModel>(response);
			if (wcsModel.StatusCode == 0)
			if (Receiver == "WCS")
			{
			//更改任务的发送返回时间//
			new TaskServer().EditTaskIssueOk(list, time1, time2);
			////解析返回数据
			var wcsModel = JsonConvert.DeserializeObject<WcsModel>(response);
			if (wcsModel.StatusCode == 0)
			{
			//更改任务的发送返回时间//
			new TaskServer().EditTaskIssueOk(list, time1, time2);

			}
			if (wcsModel.StatusCode == -1)
			{
			new TaskServer().EditTaskIssueNo(list, time1, time2, wcsModel.Msg);
			throw new Exception($"wcs返回状态异常：{wcsModel.Msg}");
			}
			}
			if (wcsModel.StatusCode == -1)
			else if (Receiver == "AGV")
			{
			new TaskServer().EditTaskIssueNo(list, time1, time2, wcsModel.Msg);
			throw new Exception($"wcs返回状态异常：{wcsModel.Msg}");
			////解析返回数据
			var agvModel = JsonConvert.DeserializeObject<OutCommanAgvDto>(response);
			if (agvModel.Code == "0")
			{
			//更改任务的发送返回时间//
			new TaskServer().EditTaskIssueOk(list, time1, time2);

			}
			if (agvModel.Code == "1")
			{
			new TaskServer().EditTaskIssueNo(list, time1, time2, agvModel.Message);
			throw new Exception($"agv返回状态异常：{agvModel.Message}");
			}
			}

			}
			catch (Exception ex)
			{
			@@ -2548,6 +2571,38 @@
			{
			throw new Exception("未查询到任务信息");
			}
			//获取对应库位信息
			var startlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.StartLocat);
			if (startlocat == null)
			{
			throw new Exception("未查询到储位信息");
			}
			startlocat.Status = "0";//修改分配信息状态
			//获取储位信息
			var locat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.StartLocat);
			//获取移库任d务对应目标储位信息
			SysStorageLocat endlocat = new SysStorageLocat();
			if (task.Type == "2")
			{
			endlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.EndLocat);
			if (endlocat == null)
			{
			throw new Exception("未查询到目标储位信息");
			}
			}
			if (locat == null)
			{
			Db.RollbackTran();
			throw new Exception("未查询到储位信息，请核实！");
			}
			locat.Status = "1"; //有物品
			Db.Updateable(locat).ExecuteCommand();
			if (endlocat != null)
			{
			endlocat.Status = "0"; //空储位 0
			Db.Updateable(endlocat).ExecuteCommand();
			}

			//修改任务
			task.IsSuccess = 1;
			task.IsSend = 0;
			@@ -2571,31 +2626,6 @@

			noticeDetail.FactQty -= item.Qty; //修改出库单明细的下架数量
			Db.Updateable(noticeDetail).ExecuteCommand();

			//获取储位信息
			var locat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.StartLocat);
			//获取移库任务对应目标储位信息
			SysStorageLocat endlocat = new SysStorageLocat();
			if (task.Type == "2")
			{
			endlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W03" && a.LocatNo == task.EndLocat);
			if (endlocat == null)
			{
			throw new Exception("未查询到目标储位信息");
			}
			}
			if (locat == null)
			{
			Db.RollbackTran();
			throw new Exception("未查询到储位信息，请核实！");
			}
			locat.Status = "1"; //有物品
			Db.Updateable(locat).ExecuteCommand();
			if (endlocat != null)
			{
			endlocat.Status = "0"; //空储位 0
			Db.Updateable(endlocat).ExecuteCommand();
			}

			if (noticeDetail.FactQty == 0)
			{
			@@ -2838,7 +2868,7 @@
			}
			else
			{
			stockDetail = stockDetail.Where(m => m.SkuNo == detail.SkuNo && m.IsDel == "0").ToList(); //&& string.IsNullOrWhiteSpace(m.LotNo)
			stockDetail = stockDetail.Where(m => m.SkuNo == detail.SkuNo && m.IsDel == "0" && string.IsNullOrWhiteSpace(m.LotNo)).ToList(); //
			}

			if (stockDetail.Count < 1)
			@@ -2846,11 +2876,11 @@
			throw new Exception("库存不足,无可出库库存");
			}
			//0:成品出库、1:领料出库、2:抽检出库、3：物料取样出库、4:不合格品出库、5:中间品出库、6:代储出库、7:其他出库、8:寄存出库
			if (notice.Type == "0" \|\| notice.Type == "1" )//成品、原辅料出库
			if (notice.Type == "0" \|\| notice.Type == "1")//成品、原辅料出库
			{
			stockDetail = stockDetail.Where(m => m.InspectStatus == "1").ToList();
			}
			else if (notice.Type == "3" )//取样出库
			else if (notice.Type == "3")//取样出库
			{
			stockDetail = stockDetail.Where(m => m.InspectStatus == "0").ToList();
			}
			@@ -2861,46 +2891,48 @@
			else if (notice.Type == "4")//不合格出库
			{
			stockDetail = stockDetail.Where(m => m.InspectStatus == "2").ToList();
			}
			}

			#region 包装信息

			var pack = packList.FirstOrDefault(p => p.PackagNo == detail.PackagNo);
			if (pack == null)
			{
			throw new Exception("未查询到物料包装");
			}
			var pNum = 0;//托盘物品数量
			var bNum = 0;//箱物品数量
			if (pack.L5Num.HasValue)
			if (pack != null)
			{
			pNum = Convert.ToInt32(pack.L5Num);
			bNum = Convert.ToInt32(pack.L4Num);
			//throw new Exception("未查询到物料包装");
			if (pack.L5Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L5Num);
			bNum = Convert.ToInt32(pack.L4Num);
			}
			else if (pack.L4Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L4Num);
			bNum = Convert.ToInt32(pack.L3Num);
			}
			else if (pack.L3Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L3Num);
			bNum = Convert.ToInt32(pack.L2Num);
			}
			else if (pack.L2Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L2Num);
			bNum = Convert.ToInt32(pack.L1Num);
			}
			else if (pack.L1Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L1Num);
			bNum = Convert.ToInt32(pack.L1Num);
			}
			}
			else if (pack.L4Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L4Num);
			bNum = Convert.ToInt32(pack.L3Num);
			}
			else if (pack.L3Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L3Num);
			bNum = Convert.ToInt32(pack.L2Num);
			}
			else if (pack.L2Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L2Num);
			bNum = Convert.ToInt32(pack.L1Num);
			}
			else if (pack.L1Num.HasValue)
			{
			pNum = Convert.ToInt32(pack.L1Num);
			bNum = Convert.ToInt32(pack.L1Num);
			}
			if (pNum == 0)
			{
			throw new Exception("未查询到物料包装托箱关系信息");
			}


			//if (pNum == 0)
			//{
			// throw new Exception("未查询到物料包装托箱关系信息");
			//}
			#endregion
			//取合适库存商品
			Dictionary<int, decimal> stockQtyDic = new Dictionary<int, decimal>();//托出库物品数
			@@ -3115,7 +3147,7 @@
			// {
			// d.LotNo = "";
			// }


			//}
			}
			notice.Status = "0";
			@@ -3185,26 +3217,63 @@
			{
			throw new Exception("获取失败，未找到指定出库单！");
			}
			if (detail.Status != "0" && detail.Status != "1" && detail.AllotQty >= detail.Qty)
			{
			throw new Exception("获取失败，出库单状态不是等待执行或分配中！");
			}
			if (detail.AllotQty >= detail.Qty)
			{
			throw new Exception("获取失败，出库单已分配完成!");
			}

			var notice = Db.Queryable<BllExportNotice>().First(a => a.SONo == detail.SONo);
			if (notice == null)
			{
			throw new Exception("获取失败，未找到指定出库单!");
			}
			if (notice.Status == "3" && detail.AllotQty >= detail.Qty \|\| notice.Status == "4" \|\| notice.Status == "5")
			if (notice.Type != "1" && notice.Type != "2" && notice.Type != "3")
			{
			throw new Exception("获取失败，出库单状态不允许!");
			if (detail.Status != "0" && detail.Status != "1" && detail.AllotQty >= detail.Qty)
			{
			throw new Exception("获取失败，出库单状态不是等待执行或分配中！");
			}
			if (detail.AllotQty >= detail.Qty)
			{
			throw new Exception("获取失败，出库单已分配完成!");
			}

			if (notice.Status == "3" && detail.AllotQty >= detail.Qty \|\| notice.Status == "4" \|\| notice.Status == "5")
			{
			throw new Exception("获取失败，出库单状态不允许!");
			}
			}
			string inspectStatus = string.Empty;
			switch (notice.Type)//0：原料 1：包材 2：成品 3：耗材 4：半成品
			{
			case "0"://成品出库
			inspectStatus = "1";
			break;
			case "1"://领料出库
			inspectStatus = "1";
			break;
			case "2"://抽检出库
			inspectStatus = "0,1,2";
			break;
			case "3"://物料取样出库
			inspectStatus = "0";
			break;
			case "4"://不合格品出库
			inspectStatus = "2";
			break;
			case "5"://中间品出库
			inspectStatus = "1";
			break;
			case "6"://代储出库
			inspectStatus = "0,1,2";
			break;
			case "8"://寄存出库
			inspectStatus = "0,1";
			break;
			default: //其它出库
			inspectStatus = "0,1";
			break;
			}
			#endregion

			Expression<Func<DataStockDetail, bool>> item = Expressionable.Create<DataStockDetail>()
			.AndIF(!string.IsNullOrWhiteSpace(inspectStatus), m => inspectStatus.Contains(m.InspectStatus))
			.AndIF(!string.IsNullOrWhiteSpace(houseNo), m => m.WareHouseNo == houseNo)
			.AndIF(!string.IsNullOrWhiteSpace(roadwayNo), m => m.RoadwayNo == roadwayNo)
			.AndIF(!string.IsNullOrWhiteSpace(locateNo), m => m.LocatNo == locateNo)
			@@ -3252,29 +3321,36 @@
			{
			throw new Exception("操作失败，未找到指定出库单详情！");
			}
			if (detail.AllotQty >= detail.Qty \|\| (detail.Status != "0" && detail.Status != "1"))
			{
			throw new Exception("操作失败，出库单已分配完成！");
			}
			var notice = Db.Queryable<BllExportNotice>().First(a => a.IsDel == "0" && a.SONo == detail.SONo);
			if (notice == null)
			{
			throw new Exception("操作失败，未找到指定出库单！");
			}
			if (notice.Status == "3" && detail.AllotQty >= detail.Qty \|\| notice.Status == "4" \|\| notice.Status == "5")
			if (notice.Type != "1" && notice.Type != "2" && notice.Type !="3")
			{
			throw new Exception("操作失败，出库单已分配完成！");
			if (detail.AllotQty >= detail.Qty \|\| (detail.Status != "0" && detail.Status != "1"))
			{
			throw new Exception("操作失败，出库单已分配完成！");
			}

			if (notice.Status == "3" && detail.AllotQty >= detail.Qty \|\| notice.Status == "4" \|\| notice.Status == "5")
			{
			throw new Exception("操作失败，出库单已分配完成！");
			}

			//单据明细需要的出库数量
			var needQty = detail.Qty - detail.AllotQty;
			//分配的出库数量
			var outQty = model.StockList.Select(s => s.Qty).ToList().Sum();
			if (outQty != needQty)
			{
			throw new Exception("操作失败，出库数量与计划数量不一致！");
			}
			}

			#endregion

			//单据明细需要的出库数量
			var needQty = detail.Qty - detail.AllotQty;
			//分配的出库数量
			var outQty = model.StockList.Select(s => s.Qty).ToList().Sum();
			if (outQty != needQty)
			{
			throw new Exception("操作失败，出库数量与计划数量不一致！");
			}

			var stockIds = model.StockList.Select(a => a.StockId).ToList();
			//库存明细
			var stockList = Db.Queryable<DataStockDetail>().Where(a => stockIds.Contains(a.Id)).ToList();
			@@ -3283,10 +3359,10 @@
			var allots = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.SODetailNo == detail.Id && m.Status == "0").ToList();

			//库存总表
			//var stockz = Db.Queryable<DataStock>().First(d => d.IsDel == "0" && d.SkuNo == detail.SkuNo && d.LotNo == detail.LotNo);
			var stockz = Db.Queryable<DataStock>().First(d => d.IsDel == "0" && d.SkuNo == detail.SkuNo && d.LotNo == detail.LotNo);

			var allotList = new List<BllExportAllot>();
			var outQtys = 0;
			decimal outQtys = 0;
			foreach (var st in model.StockList)
			{
			var stock = stockList.First(a => a.Id == st.StockId);
			@@ -3320,7 +3396,7 @@
			IsBelt = stock.IsBelt,
			Qty = st.Qty,
			CompleteQty = 0,
			Status = "0",
			Status = notice.Status == "4"? "2":"0",
			LogisticsId = notice.LogisticsId,
			IsAdvance = "0",
			OutMode = "",//出库口
			@@ -3335,15 +3411,16 @@
			bl.Qty += st.Qty;
			Db.Updateable(bl).ExecuteCommand();
			}


			//库存明细
			stock.LockQty += st.Qty;
			stock.Status = stock.LockQty == stock.Qty ? "2" : "1";

			//库存总表
			//stockz.LockQty += st.Qty;
			//Db.Updateable(stockz).ExecuteCommand();

			if (detail.AllotQty+ st.Qty > detail.Qty)
			{
			//库存总表
			stockz.LockQty += (decimal)detail.AllotQty + st.Qty - detail.Qty;
			Db.Updateable(stockz).ExecuteCommand();
			}

			Db.Updateable(stock).UpdateColumns(it => new { it.LockQty, it.Status }).ExecuteCommand();
			outQtys += st.Qty;