JC34WMS.git - Gitblit

			@@ -28,17 +28,1666 @@
			{
			private static readonly SqlSugarScope Db = DataContext.Db;

			// 获取单据列表
			public List<ArrivalNoticeDto> GetArrivalNotices(ArrivalNoticeVm model)
			#region JC34

			/// <summary>
			/// 绑定托盘贴标物料
			/// </summary>
			/// <param name="model"></param>
			/// <param name="userId"></param>
			/// <exception cref="Exception"></exception>
			public void BindPalletPasteCode(PdaPalletBindVm model, int userId)
			{
			try
			{
			#region 判断
			//0：成品入库 1：采购入库 3：退货入库 4：车间余料入库 8：生产退料入库


			if (string.IsNullOrEmpty(model.AsnNo))
			{
			throw new Exception("单据号不可为空!");
			}
			if (model.AsnDetailId == null \|\| model.AsnDetailId == 0)
			{
			throw new Exception("物料-批次不可为空!");
			}
			if (string.IsNullOrEmpty(model.PalletNo))
			{
			throw new Exception("托盘号不可为空!");
			}
			//根据单据号获取入库单总单
			var notice = Db.Queryable<BllArrivalNotice>().First(a => a.IsDel == "0" && a.ASNNo == model.AsnNo);
			if (notice.Status != "0" && notice.Status != "1" && notice.Status != "2")
			{
			throw new Exception("该单据已关单!");
			}
			if (string.IsNullOrEmpty(model.LotNo))
			{
			throw new Exception("物料-批次不可为空!");
			}
			else
			{
			//从物料名称-批次中取出批次
			int indexOfDash = model.LotNo.IndexOf("-");
			if (indexOfDash != -1)
			{
			model.LotNo = model.LotNo.Substring(indexOfDash + 1);
			}
			else
			{
			throw new Exception("物料-批次不可为空!");
			}
			}

			//判断箱码信息
			if (string.IsNullOrEmpty(model.BoxNo))
			{
			throw new Exception("箱码信息不可为空!");
			}
			//是否连续组托 0：否 1：是
			if (model.IsContinue == "1")
			{
			if (string.IsNullOrWhiteSpace(model.TailBoxNo))
			{
			throw new Exception("开启连续组托时，尾箱码信息不可为空!");
			}
			}

			//托盘信息是否存在
			var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (pallet == null)
			{
			throw new Exception("未查询到托盘信息，请核实！");
			}
			//验证入库单明细是否存在
			var detail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.Id == model.AsnDetailId && m.ASNNo == model.AsnNo && m.LotNo.Contains(model.LotNo));
			if (detail == null)
			{
			throw new Exception("当前物料及批次与单据无关联，请核实!");
			}
			//判断托盘是否在库外
			var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (stockDetail != null && !string.IsNullOrEmpty(stockDetail.WareHouseNo))
			{
			throw new Exception("该托盘已有储位信息，不可组托，请核实！");
			}

			#endregion

			//开启事务
			Db.BeginTran();
			//当前时间
			var comTime = DateTime.Now;

			#region 包装

			var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == detail.SkuNo);
			var pack = Db.Queryable<SysPackag>().First(m => m.IsDel == "0" && m.PackagNo == detail.PackagNo);

			var pNum = 0;//托盘物品数量
			var bNum = 0;//箱码物品数量

			if (pack == null)
			{
			throw new Exception("获取物料包装信息失败，请核实!");
			}
			if (pack.L5Num.HasValue)
			{
			pNum = (int)pack.L5Num;
			bNum = (int)pack.L4Num;
			}
			else if (pack.L4Num.HasValue)
			{
			pNum = (int)pack.L4Num;
			bNum = (int)pack.L3Num;
			}
			else if (pack.L3Num.HasValue)
			{
			pNum = (int)pack.L3Num;
			bNum = (int)pack.L2Num;
			}
			else if (pack.L2Num.HasValue)
			{
			pNum = (int)pack.L2Num;
			bNum = (int)pack.L1Num;
			}
			else if (pack.L1Num.HasValue)
			{
			pNum = (int)pack.L1Num;
			bNum = (int)pack.L1Num;
			}
			if (pNum == 0 \|\| bNum == 0)
			{
			throw new Exception($"绑定失败，{detail.SkuNo}物品包装未找到！");
			}

			#endregion

			#region 验证是否允许立库同托盘不同物料入库或同托盘同物料不同批次入库
			var palletBind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNNo == model.AsnNo && m.PalletNo == model.PalletNo && m.ASNDetailNo != model.AsnDetailId);
			if (palletBind != null)
			{
			var box = Db.Queryable<BllBoxInfo>().First(m => m.IsDel == "0" && m.BindNo == palletBind.Id && m.BitBoxMark == "0");
			if (box != null && (box.SkuNo != detail.SkuNo \|\| !detail.LotNo.Contains(box.LotNo)))
			{
			var funSetting = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetNo == "Fun045");
			if (funSetting == null \|\| funSetting.IsEnable == "OFF")
			{
			throw new Exception($"不允许立库同托盘不同物料入库或同托盘不同批次入库！");
			}
			}
			}
			#endregion

			#region 箱码信息
			var msgStr = $"箱号为{model.BoxNo}";
			var boxInfoList = new List<BllBoxInfo>();

			//首箱
			var boxInfo = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BoxNo == model.BoxNo).ToList();
			if (boxInfo.Count == 0)
			{
			throw new Exception("箱码信息不存在!");
			}
			boxInfoList.AddRange(boxInfo);
			//是否连续组托
			if (model.IsContinue == "1")
			{
			//尾箱
			var boxInfo2 = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BoxNo == model.TailBoxNo).ToList();
			if (boxInfo2.Count == 0)
			{
			throw new Exception("尾箱码信息不存在!");
			}
			boxInfoList.AddRange(boxInfo2);
			var sql = $"select * from BllBoxInfo where IsDel = '0' and boxNo>'{model.BoxNo}' and boxNo<'{model.TailBoxNo}'; ";
			var list = Db.Ado.SqlQuery<BllBoxInfo>(sql);
			boxInfoList.AddRange(list);
			msgStr += $"尾箱号为{model.TailBoxNo}";
			}
			//绑定箱总数量
			//model.SkuQty = boxInfoList.Sum(s => s.Qty);
			//和选择的批次同批次的箱码信息
			var sameBoxInfoList = boxInfoList.Where(w => w.LotNo == model.LotNo && w.Status == "0").ToList();
			//和选择的批次不同批次的箱码信息（拼箱批次）
			var notBoxInfoList = boxInfoList.Where(w => w.LotNo != model.LotNo).ToList();
			#endregion

			if (sameBoxInfoList.Count <= 0)
			{
			throw new Exception("箱码信息不存在!");
			}
			else
			{
			#region 托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == model.AsnDetailId && m.PalletNo == model.PalletNo && m.LotNo == model.LotNo);
			var bindId = 0;
			if (bind == null)
			{
			bind = new BllPalletBind
			{
			ASNNo = model.AsnNo,
			ASNDetailNo = (int)model.AsnDetailId,
			PalletNo = model.PalletNo,
			PalletNo2 = "",
			PalletNo3 = "",
			Qty = model.SkuQty,//不包含拼箱中非同批次数量
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = model.LotNo,
			LotText = detail.LotText,
			SupplierLot = detail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,
			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			bind.Qty += model.SkuQty;
			}

			#endregion

			#region 库存明细和质检信息
			//获取该批次最终质检结果
			BllQualityInspect quality = new BllQualityInspect();
			//判断是否为退货入库单
			if (notice.Type == "3")
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.ASNNo == detail.ASNNo && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			else
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			var tags = "0";
			if (notice.Type == "3" \|\| notice.Type == "4")
			{
			tags = "1";
			}

			// 判断库存明细是否已有此托盘信息
			var sd1 = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.ASNDetailNo == bind.ASNDetailNo && m.PalletNo == model.PalletNo);
			var sdId1 = 0;
			if (sd1 != null)
			{
			sdId1 = sd1.Id;
			// 库存已存在更新数据
			sd1.Qty = bind.Qty;
			sd1.CompleteTime = comTime;
			sd1.UpdateUser = userId;
			sd1.UpdateTime = comTime;

			Db.Updateable(sd1).ExecuteCommand();
			}
			else
			{
			// 库存不存在插入数据
			sd1 = new DataStockDetail()
			{
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			SupplierLot = bind.SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = bind.ASNNo,
			ASNDetailNo = bind.ASNDetailNo,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = tags,
			CompleteTime = comTime,
			ProductionTime = bind.ProductionTime,
			ExpirationTime = bind.ExpirationTime,
			Status = "0",
			InspectMark = bind.InspectMark,
			InspectStatus = sku.IsInspect,
			BitPalletMark = bind.BitPalletMark,
			PackagNo = detail.PackagNo, //liudl 由sku的包装编号变为入库单明细的包装编码
			IsBale = bind.IsBale,
			IsBelt = bind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};

			//维护库存明细货主/供应商信息 //0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")
			{
			sd1.OwnerNo = notice.CustomerNo;//货主编码
			sd1.OwnerName = notice.CustomerName;//货主名称
			}
			else if (notice.Type == "1" \|\| notice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = notice.CustomerNo;//供应商编码
			sd1.SupplierName = notice.CustomerName;//供应商名称
			}
			if (quality != null)
			{
			//修改合格不合格数量
			if (quality.IsQualified == "1") //合格
			{
			//增加合格数量
			quality.PassQty += bind.Qty;
			sd1.InspectStatus = "1";
			}
			else if (quality.IsQualified == "0") //不合格
			{
			//增加不合格数量
			quality.FailQty += bind.Qty;
			sd1.InspectStatus = "2";
			}
			Db.Updateable(quality).ExecuteCommand(); //修改质检信息
			}
			//添加库存明细
			sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			}
			#endregion

			// 更改箱支关系表
			decimal factQty = 0.00m;//托盘总数量
			var isSample = "0";//是否取样
			var sampleQty = 0m;//取样数量

			//标签组托
			var boxGroup = sameBoxInfoList.GroupBy(m => m.BoxNo).ToList();
			foreach (var g in boxGroup)
			{
			decimal boxFullQty = 0;//箱内总数量
			foreach (var box in g)
			{
			if (box.BindNo != null && box.BindNo != 0)
			{
			continue;
			}
			//箱内物料批次与单据明细不符合
			if (box.SkuNo != detail.SkuNo \|\| box.LotNo != model.LotNo)
			{
			throw new Exception($"-1:{box.BoxNo}箱内物料及批次与单据不一致，请核实!");
			}

			box.ASNNo = model.AsnNo;
			box.ASNDetailNo = model.AsnDetailId;
			box.BindNo = bindId;
			box.PalletNo = model.PalletNo;
			box.Status = "2";
			//box.InspectMark = model.IsSample; //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//box.SamplingQty = 0; //取样数量后期业务开发时接口传值需添加对应字段判断
			box.CompleteTime = comTime;
			box.UpdateTime = comTime;
			box.UpdateUser = userId;

			//box.Qty = box.Qty;
			//box.BitBoxMark = box.Qty == box.FullQty ? "0" : "1";

			factQty += box.Qty;
			boxFullQty += box.Qty;
			if (box.InspectMark == "1") //判断是否取样
			{
			isSample = "1";
			sampleQty += (decimal)box.SamplingQty;
			}

			#region 库存箱码明细
			var box2 = new DataBoxInfo()
			{
			StockDetailId = sdId1,
			BindNo = bind.Id,
			BoxNo = box.BoxNo,
			BoxNo2 = box.BoxNo2,
			BoxNo3 = box.BoxNo3,
			PalletNo = box.PalletNo,
			PalletNo2 = box.PalletNo2,
			PalletNo3 = box.PalletNo3,
			Qty = box.Qty,
			FullQty = box.FullQty,
			Status = "2",//0：未组托 1：已组托 2：已入库 3：已出库 4:已分配 5：已拣货
			LotNo = box.LotNo,
			LotText = box.LotText,
			SkuNo = box.SkuNo,
			SkuName = box.SkuName,
			Standard = sku.Standard,
			ProductionTime = box.ProductionTime,
			SupplierLot = box.SupplierLot,
			InspectStatus = sku.IsInspect,
			InspectMark = box.InspectMark,
			BitBoxMark = box.BitBoxMark,
			ExpirationTime = box.ExpirationTime,

			CreateUser = 0,
			CreateTime = comTime
			};
			//添加库存箱码明细
			Db.Insertable(box2).ExecuteCommand();
			#endregion
			}
			if (boxFullQty > bNum)
			{
			throw new Exception($"绑定失败，{g.Key}箱码绑定数量大于该物品包装数量！");
			}
			}
			//更改箱支关系表信息
			Db.Updateable(boxInfoList).ExecuteCommand();

			// 更新托盘绑定表
			bind.Qty += factQty;

			if (bind.FullQty < bind.Qty)
			{
			throw new Exception("托盘绑定数量已超出该物料包装数量");
			}

			if (bind.FullQty == bind.Qty)
			{
			bind.BitPalletMark = "0";
			sd1.BitPalletMark = "0";
			}
			if (bind.Qty > pNum)
			{
			throw new Exception($"绑定失败，{bind.PalletNo}托盘绑定数量大于该物品托盘包装数量！");
			}

			if (isSample == "1")
			{
			bind.InspectMark = "1";
			bind.SamplingQty = bind.SamplingQty == null ? sampleQty : bind.SamplingQty + sampleQty;
			}
			Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();

			#region 入库单及明细
			detail.FactQty += factQty;//已组数量
			detail.CompleteQty += factQty;//完成数量
			if (isSample == "1") //后期业务开发时接口传值改为判断是否取样
			{
			detail.IsSampling = "1";
			}
			detail.Status = "1";//0：等待执行 1：正在执行 2：执行完成
			if (detail.CompleteQty >= detail.Qty)
			{
			detail.Status = "2";
			detail.CompleteTime = comTime;
			}
			detail.UpdateUser = userId;
			detail.UpdateTime = comTime;
			//更新入库单明细
			Db.Updateable(detail).ExecuteCommand();

			notice.UpdateUser = userId;
			notice.UpdateTime = comTime;
			if (notice.Status == "0")
			{
			notice.Status = "1";
			}
			var asnDetailNum = Db.Queryable<BllArrivalNoticeDetail>().Count(m => m.IsDel == "0" && m.ASNNo == detail.ASNNo && m.Status != "2");
			if (asnDetailNum == 0)
			{
			notice.Status = "2";//执行完成
			notice.CompleteTime = comTime;//完成时间
			}
			//更新入库单
			Db.Updateable(notice).ExecuteCommand();
			#endregion

			#region 库存明细
			sd1.Qty = bind.Qty;
			//更改库存明细数量
			Db.Updateable(sd1).Where(m => m.Id == sdId1).ExecuteCommand();
			#endregion

			#region 库存
			var dataStock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo);
			if (dataStock != null)
			{
			dataStock.Qty += factQty;

			if (bind.InspectMark == "1")
			{
			dataStock.IsSampling = bind.InspectMark;
			}
			Db.Updateable(dataStock).ExecuteCommand();
			}
			else
			{
			var stock = new DataStock()
			{
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			IsSampling = bind.InspectMark,
			IsDel = "0",
			CreateUser = userId,
			CreateTime = comTime
			};
			//维护库存货主信息
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			stock.OwnerNo = notice.CustomerNo;//货主编码
			stock.OwnerName = notice.CustomerName;//货主名称
			}
			Db.Insertable(stock).ExecuteCommand();
			}
			#endregion

			#region 质检请验
			if ((notice.Type == "1" \|\| notice.Type == "4" \|\| notice.Type == "5") && sku.IsInspect != "1")
			{
			var qualityRequest = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo && m.SupplierLot == bind.SupplierLot);
			if (qualityRequest == null)
			{
			string qcNo = new Common().GetMaxNo("QC");
			qualityRequest = new BllQualityInspectionRequest();
			qualityRequest.QcNo = qcNo;
			qualityRequest.Status = "0";
			qualityRequest.SkuNo = sku.SkuNo;
			qualityRequest.SkuName = sku.SkuName;
			qualityRequest.LotNo = bind.LotNo;
			qualityRequest.SupplierLot = bind.SupplierLot;
			qualityRequest.Qty = detail.Qty;
			qualityRequest.SamplingQty = 0;
			qualityRequest.ASNNo = detail.ASNNo;
			qualityRequest.CreateUser = userId;
			qualityRequest.CreateTime = comTime;
			//添加质检请验单
			Db.Insertable(qualityRequest).ExecuteCommand();
			}
			}
			#endregion
			}

			//拼箱
			if (notBoxInfoList.Count > 0)
			{
			var gbox = notBoxInfoList.GroupBy(g => g.BoxNo).ToList();
			if (gbox.Count > 1)
			{
			throw new Exception("一个托盘上只能有1个拼箱!");
			}
			gbox = notBoxInfoList.GroupBy(g => g.LotNo).ToList();
			if (gbox.Count > 1)
			{
			throw new Exception("一个箱内最多能有2个不同批次物料!");
			}
			var pinBoxNo = notBoxInfoList[0].BoxNo;//拼箱箱码
			var pinBoxLotNo = notBoxInfoList[0].LotNo;//拼箱批次号
			//拼箱数量(和选择的批次不同批次的箱码数量)
			decimal pinBoxQty = notBoxInfoList.Sum(s => s.Qty);

			var dataBoxList = Db.Queryable<DataBoxInfo>().Where(w => w.IsDel == "0" && w.BoxNo == pinBoxNo && w.LotNo == pinBoxLotNo).ToList();
			if (dataBoxList.Count > 0)//已有库存
			{
			//原托盘绑定信息
			var oldPalletBind = Db.Queryable<BllPalletBind>().First(w => w.Id == notBoxInfoList[0].BindNo);
			//原入库单明细
			var oldAsnDetail = Db.Queryable<BllArrivalNoticeDetail>().First(w => w.Id == oldPalletBind.ASNDetailNo);
			//原入库单
			var oldAsnNotice = Db.Queryable<BllArrivalNotice>().First(w => w.ASNNo == oldAsnDetail.ASNNo);
			#region 托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == oldAsnDetail.Id && m.PalletNo == model.PalletNo);
			var bindId = 0;
			if (bind == null)
			{
			bind = new BllPalletBind
			{
			ASNNo = oldAsnDetail.ASNNo,
			ASNDetailNo = oldAsnDetail.Id,
			PalletNo = model.PalletNo,
			PalletNo2 = "",
			PalletNo3 = "",
			Qty = 0,
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = pinBoxLotNo,
			LotText = oldAsnDetail.LotText,
			SupplierLot = oldAsnDetail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,
			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			bind.Qty += pinBoxQty;

			Db.Updateable(bind).ExecuteCommand();
			}
			#endregion

			// 插入库存明细数据
			var sd1 = new DataStockDetail()
			{
			LotNo = pinBoxLotNo,
			LotText = notBoxInfoList[0].LotText,
			SupplierLot = notBoxInfoList[0].SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = pinBoxQty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = oldPalletBind.ASNNo,
			ASNDetailNo = oldPalletBind.ASNDetailNo,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = "0",
			CompleteTime = comTime,
			ProductionTime = oldPalletBind.ProductionTime,
			ExpirationTime = oldPalletBind.ExpirationTime,
			Status = "0",
			InspectMark = oldPalletBind.InspectMark,
			InspectStatus = sku.IsInspect,
			BitPalletMark = oldPalletBind.BitPalletMark,
			PackagNo = oldAsnDetail.PackagNo,
			IsBale = oldPalletBind.IsBale,
			IsBelt = oldPalletBind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};
			//维护库存明细货主/供应商信息
			if (oldAsnNotice.Type == "0" \|\| oldAsnNotice.Type == "2" \|\| oldAsnNotice.Type == "4" \|\| oldAsnNotice.Type == "6" \|\| oldAsnNotice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			sd1.OwnerNo = oldAsnNotice.CustomerNo;//货主编码
			sd1.OwnerName = oldAsnNotice.CustomerName;//货主名称
			}
			else if (oldAsnNotice.Type == "1" \|\| oldAsnNotice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = oldAsnNotice.CustomerNo;//供应商编码
			sd1.SupplierName = oldAsnNotice.CustomerName;//供应商名称
			}
			//添加库存明细
			var sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			foreach (var item in dataBoxList)
			{
			item.StockDetailId = sdId1;//库存明细id
			item.BindNo = bind.Id;//托盘绑定id
			}
			//更新库存箱支明细表
			Db.Updateable(dataBoxList).ExecuteCommand();

			//托盘解绑信息
			var palletUnbind = Db.Queryable<BllPalletUnbind>().First(w => w.IsDel == "0" && w.UpbindPalletNo == oldPalletBind.PalletNo && w.BoxNo == pinBoxNo);
			if (palletUnbind == null)
			{
			throw new Exception("拼箱的托盘解绑信息不存在!");
			}
			palletUnbind.BindPalletNo = model.PalletNo;//绑定托盘号
			palletUnbind.UpdateTime = comTime;
			palletUnbind.UpdateUser = userId;
			//更新托盘解绑绑定表信息
			Db.Updateable(palletUnbind).ExecuteCommand();
			}
			else
			{
			string sql = $@"SELECT detail.* FROM BllArrivalNoticeDetail as detail
			JOIN BllArrivalNotice as notice ON detail.ASNNo=notice.ASNNo
			WHERE notice.IsDel='0'
			AND ( notice.Status=0 or notice.Status=1 )
			AND detail.IsDel='0'
			AND detail.LotNo='{pinBoxLotNo}'
			AND detail.SkuNo='{sku.SkuNo}'
			ORDER BY detail.CreateTime ";
			//找到拼箱内其他批次所属入库单明细
			var arrDetail = Db.Ado.SqlQuery<BllArrivalNoticeDetail>(sql).FirstOrDefault();
			if (arrDetail == null)
			{
			throw new Exception("拼箱内物料所属入库单明细不存在!");
			}
			//找到拼箱内其他批次所属入库单
			var arrNotice = Db.Queryable<BllArrivalNotice>().First(w => w.IsDel == "0" && w.ASNNo == arrDetail.ASNNo);
			if (arrNotice == null)
			{
			throw new Exception("拼箱内物料所属入库单不存在!");
			}
			#region 托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == arrDetail.Id && m.PalletNo == model.PalletNo);
			var bindId = 0;
			if (bind == null)
			{
			bind = new BllPalletBind
			{
			ASNNo = arrDetail.ASNNo,
			ASNDetailNo = arrDetail.Id,
			PalletNo = model.PalletNo,
			PalletNo2 = "",
			PalletNo3 = "",
			Qty = 0,
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = pinBoxLotNo,
			LotText = arrDetail.LotText,
			SupplierLot = arrDetail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,
			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			}
			#endregion

			#region 库存明细和质检信息
			//获取该批次最终质检结果
			BllQualityInspect quality = new BllQualityInspect();
			//判断是否为退货入库单
			if (arrNotice.Type == "3")
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.ASNNo == arrDetail.ASNNo && a.SkuNo == arrDetail.SkuNo && a.LotNo == arrDetail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			else
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.SkuNo == arrDetail.SkuNo && a.LotNo == arrDetail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			var tags = "0";
			if (arrNotice.Type == "3" \|\| arrNotice.Type == "4")
			{
			tags = "1";
			}

			// 判断库存明细是否已有此托盘信息
			var sd1 = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.ASNDetailNo == arrDetail.Id && m.PalletNo == model.PalletNo);
			var sdId1 = 0;
			if (sd1 != null)
			{
			sdId1 = sd1.Id;
			// 库存已存在更新数据
			sd1.Qty = bind.Qty;
			sd1.CompleteTime = comTime;
			sd1.UpdateUser = userId;
			sd1.UpdateTime = comTime;

			Db.Updateable(sd1).ExecuteCommand();
			}
			else
			{
			// 库存不存在插入数据
			sd1 = new DataStockDetail()
			{
			LotNo = pinBoxLotNo,
			LotText = notBoxInfoList[0].LotText,
			SupplierLot = bind.SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = arrDetail.ASNNo,
			ASNDetailNo = arrDetail.Id,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = tags,
			CompleteTime = comTime,
			ProductionTime = bind.ProductionTime,
			ExpirationTime = bind.ExpirationTime,
			Status = "0",
			InspectMark = bind.InspectMark,
			InspectStatus = sku.IsInspect,
			BitPalletMark = bind.BitPalletMark,
			PackagNo = arrDetail.PackagNo, //liudl 由sku的包装编号变为入库单明细的包装编码
			IsBale = bind.IsBale,
			IsBelt = bind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};

			//维护库存明细货主/供应商信息
			if (arrNotice.Type == "0" \|\| arrNotice.Type == "2" \|\| arrNotice.Type == "4" \|\| arrNotice.Type == "6" \|\| arrNotice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			sd1.OwnerNo = arrNotice.CustomerNo;//货主编码
			sd1.OwnerName = arrNotice.CustomerName;//货主名称
			}
			else if (arrNotice.Type == "1" \|\| arrNotice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = arrNotice.CustomerNo;//供应商编码
			sd1.SupplierName = arrNotice.CustomerName;//供应商名称
			}
			if (quality != null)
			{
			//修改合格不合格数量
			if (quality.IsQualified == "1") //合格
			{
			//增加合格数量
			quality.PassQty += bind.Qty;
			sd1.InspectStatus = "1";
			}
			else if (quality.IsQualified == "0") //不合格
			{
			//增加不合格数量
			quality.FailQty += bind.Qty;
			sd1.InspectStatus = "2";
			}
			Db.Updateable(quality).ExecuteCommand(); //修改质检信息
			}
			//添加库存明细
			sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			}
			#endregion

			// 更改箱支关系表
			decimal factQty = 0.00m;//托盘总数量
			var isSample = "0";//是否取样
			var sampleQty = 0m;//取样数量

			//标签组托
			var boxGroup = notBoxInfoList.GroupBy(m => m.BoxNo).ToList();
			foreach (var g in boxGroup)
			{
			decimal boxFullQty = 0;//箱内总数量
			foreach (var box in g)
			{
			if (box.BindNo != null && box.BindNo != 0)
			{
			continue;
			}
			//箱内物料批次与单据明细不符合
			if (box.SkuNo != arrDetail.SkuNo \|\| box.LotNo != arrDetail.LotNo)
			{
			throw new Exception($"-1:{box.BoxNo}箱内物料及批次与单据不一致，请核实!");
			}

			box.ASNNo = arrDetail.ASNNo;
			box.ASNDetailNo = arrDetail.Id;
			box.BindNo = bindId;
			box.PalletNo = model.PalletNo;
			box.Status = "2";
			//box.InspectMark = model.IsSample; //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//box.SamplingQty = 0; //取样数量后期业务开发时接口传值需添加对应字段判断
			box.CompleteTime = comTime;
			box.UpdateTime = comTime;
			box.UpdateUser = userId;

			//box.Qty = box.Qty;
			//box.BitBoxMark = box.Qty == box.FullQty ? "0" : "1";

			factQty += box.Qty;
			boxFullQty += box.Qty;
			if (box.InspectMark == "1") //判断是否取样
			{
			isSample = "1";
			sampleQty += (decimal)box.SamplingQty;
			}

			#region 库存箱码明细
			var box2 = new DataBoxInfo()
			{
			StockDetailId = sdId1,
			BindNo = bind.Id,
			BoxNo = box.BoxNo,
			BoxNo2 = box.BoxNo2,
			BoxNo3 = box.BoxNo3,
			PalletNo = box.PalletNo,
			PalletNo2 = box.PalletNo2,
			PalletNo3 = box.PalletNo3,
			Qty = box.Qty,
			FullQty = box.FullQty,
			Status = "2",//0：未组托 1：已组托 2：已入库 3：已出库 4:已分配 5：已拣货
			LotNo = box.LotNo,
			LotText = box.LotText,
			SkuNo = box.SkuNo,
			SkuName = box.SkuName,
			Standard = sku.Standard,
			ProductionTime = box.ProductionTime,
			SupplierLot = box.SupplierLot,
			InspectStatus = sku.IsInspect,
			InspectMark = box.InspectMark,
			BitBoxMark = box.BitBoxMark,
			ExpirationTime = box.ExpirationTime,

			CreateUser = 0,
			CreateTime = comTime
			};
			//添加库存箱码明细
			Db.Insertable(box2).ExecuteCommand();
			#endregion
			}
			if (boxFullQty > bNum)
			{
			throw new Exception($"绑定失败，{g.Key}箱码绑定数量大于该物品包装数量！");
			}
			}
			//更改箱支关系表信息
			Db.Updateable(boxInfoList).ExecuteCommand();

			// 更新托盘绑定表
			bind.Qty += factQty;

			if (bind.FullQty < bind.Qty)
			{
			throw new Exception("托盘绑定数量已超出该物料包装数量");
			}

			if (bind.FullQty == bind.Qty)
			{
			bind.BitPalletMark = "0";
			sd1.BitPalletMark = "0";
			}
			if (bind.Qty > pNum)
			{
			throw new Exception($"绑定失败，{bind.PalletNo}托盘绑定数量大于该物品托盘包装数量！");
			}

			if (isSample == "1")
			{
			bind.InspectMark = "1";
			bind.SamplingQty = bind.SamplingQty == null ? sampleQty : bind.SamplingQty + sampleQty;
			}
			Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();

			#region 入库单及明细
			arrDetail.FactQty += factQty;//已组数量
			arrDetail.CompleteQty += factQty;//完成数量
			if (isSample == "1") //后期业务开发时接口传值改为判断是否取样
			{
			arrDetail.IsSampling = "1";
			}
			arrDetail.Status = "1";//0：等待执行 1：正在执行 2：执行完成
			if (arrDetail.CompleteQty >= arrDetail.Qty)
			{
			arrDetail.Status = "2";
			arrDetail.CompleteTime = comTime;
			}
			arrDetail.UpdateUser = userId;
			arrDetail.UpdateTime = comTime;
			//更新入库单明细
			Db.Updateable(arrDetail).ExecuteCommand();

			arrNotice.UpdateUser = userId;
			arrNotice.UpdateTime = comTime;
			if (arrNotice.Status == "0")
			{
			arrNotice.Status = "1";
			}
			var asnDetailNum = Db.Queryable<BllArrivalNoticeDetail>().Count(m => m.IsDel == "0" && m.ASNNo == arrDetail.ASNNo && m.Status != "2");
			if (asnDetailNum == 0)
			{
			arrNotice.Status = "2";//执行完成
			arrNotice.CompleteTime = comTime;//完成时间
			}
			//更新入库单
			Db.Updateable(arrNotice).ExecuteCommand();
			#endregion

			#region 库存明细
			sd1.Qty = bind.Qty;
			//更改库存明细数量
			Db.Updateable(sd1).Where(m => m.Id == sdId1).ExecuteCommand();
			#endregion

			#region 库存
			var dataStock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo);
			if (dataStock != null)
			{
			dataStock.Qty += factQty;

			if (bind.InspectMark == "1")
			{
			dataStock.IsSampling = bind.InspectMark;
			}
			Db.Updateable(dataStock).ExecuteCommand();
			}
			else
			{
			var stock = new DataStock()
			{
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			IsSampling = bind.InspectMark,
			IsDel = "0",
			CreateUser = userId,
			CreateTime = comTime
			};
			//维护库存货主信息
			if (arrNotice.Type == "0" \|\| arrNotice.Type == "2" \|\| arrNotice.Type == "4" \|\| arrNotice.Type == "6" \|\| arrNotice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			stock.OwnerNo = notice.CustomerNo;//货主编码
			stock.OwnerName = notice.CustomerName;//货主名称
			}
			Db.Insertable(stock).ExecuteCommand();
			}
			#endregion

			#region 质检请验
			if ((arrNotice.Type == "1" \|\| arrNotice.Type == "4" \|\| arrNotice.Type == "5") && sku.IsInspect != "1")
			{
			var qualityRequest = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo && m.SupplierLot == bind.SupplierLot);
			if (qualityRequest == null)
			{
			string qcNo = new Common().GetMaxNo("QC");
			qualityRequest = new BllQualityInspectionRequest();
			qualityRequest.QcNo = qcNo;
			qualityRequest.Status = "0";
			qualityRequest.SkuNo = sku.SkuNo;
			qualityRequest.SkuName = sku.SkuName;
			qualityRequest.LotNo = bind.LotNo;
			qualityRequest.SupplierLot = bind.SupplierLot;
			qualityRequest.Qty = arrDetail.Qty;
			qualityRequest.SamplingQty = 0;
			qualityRequest.ASNNo = arrDetail.ASNNo;
			qualityRequest.CreateUser = userId;
			qualityRequest.CreateTime = comTime;
			//添加质检请验单
			Db.Insertable(qualityRequest).ExecuteCommand();
			}
			}
			#endregion
			}
			}
			// 更改托盘使用状态
			var sqlStr = $"update SysPallets set Status = '1' where PalletNo = '{model.PalletNo}';";
			//添加托盘记录表数据
			sqlStr += $"insert into LogPalletTrack values('{model.PalletNo}','{model.AsnNo}','组盘','0',getDate(),{userId},NULL,NULL);";
			Db.Ado.ExecuteCommand(sqlStr);
			new OperationASNServer().AddLogOperationAsn("PDA模块", "托盘绑定", model.AsnNo, "添加", $"添加了托盘码为：{model.PalletNo}、{msgStr}的组盘信息", userId);

			//提交事务
			Db.CommitTran();
			}
			catch (Exception e)
			{
			//回滚事务
			Db.RollbackTran();
			throw new Exception(e.Message);
			}
			}

			/// <summary>
			/// 绑定托盘不贴标物料
			/// </summary>
			/// <param name="model"></param>
			/// <param name="userId"></param>
			/// <exception cref="Exception"></exception>
			public void BindPalletNoPasteCode(PdaPalletBindVm model, int userId)
			{
			try
			{
			#region 判断

			//0：成品入库 1：采购入库 3：退货入库 4：车间余料入库 8：生产退料入库


			if (string.IsNullOrEmpty(model.AsnNo))
			{
			throw new Exception("单据号不可为空!");
			}
			if (model.AsnDetailId == null \|\| model.AsnDetailId == 0)
			{
			throw new Exception("物料不可为空!");
			}
			if (string.IsNullOrEmpty(model.PalletNo))
			{
			throw new Exception("托盘号不可为空!");
			}
			if (model.SkuQty < 0)
			{
			throw new Exception("物料数量不能小于0!");
			}
			//根据单据号获取入库单总单
			var notice = Db.Queryable<BllArrivalNotice>().First(a => a.IsDel == "0" && a.ASNNo == model.AsnNo);
			if (notice.Status != "0" && notice.Status != "1" && notice.Status != "2")
			{
			throw new Exception("该单据已关单!");
			}

			if (string.IsNullOrEmpty(model.LotNo))
			{
			throw new Exception("物料批次不为空!");
			}
			else
			{
			//从物料名称-批次中取出批次
			int indexOfDash = model.LotNo.IndexOf("-");
			if (indexOfDash != -1)
			{
			model.LotNo = model.LotNo.Substring(indexOfDash + 1);
			}
			else
			{
			throw new Exception("物料批次不可为空!");
			}
			}

			//托盘是否存在
			var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (pallet == null)
			{
			throw new Exception("未查询到托盘信息，请核实！");
			}
			// 验证入库单明细是否存在
			var detail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.Id == model.AsnDetailId && m.ASNNo == model.AsnNo && m.LotNo.Contains(model.LotNo));
			if (detail == null)
			{
			throw new Exception("当前物料及批次与单据无关联，请核实!");
			}
			//判断托盘是否在库外
			var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (stockDetail != null && !string.IsNullOrEmpty(stockDetail.WareHouseNo))
			{
			throw new Exception("该托盘已有储位信息，请核实！");
			}
			if (stockDetail != null && (stockDetail.SkuNo != detail.SkuNo \|\| stockDetail.LotNo != model.LotNo))
			{
			throw new Exception("该托盘在库存已有其它物料批次信息，请核实！");
			}

			#endregion

			#region 包装

			var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == detail.SkuNo);
			var pack = Db.Queryable<SysPackag>().First(m => m.IsDel == "0" && m.PackagNo == detail.PackagNo); // liudl 由Sku包装编号变更为入库单明细包装编号

			var pNum = 0;//托盘物品数量
			var bNum = 0;//箱码物品数量

			if (pack == null)
			{
			throw new Exception("获取物料包装失败，请核实!");
			}
			if (pack.L5Num.HasValue)
			{
			pNum = (int)pack.L5Num;
			bNum = (int)pack.L4Num;
			}
			else if (pack.L4Num.HasValue)
			{
			pNum = (int)pack.L4Num;
			bNum = (int)pack.L3Num;
			}
			else if (pack.L3Num.HasValue)
			{
			pNum = (int)pack.L3Num;
			bNum = (int)pack.L2Num;
			}
			else if (pack.L2Num.HasValue)
			{
			pNum = (int)pack.L2Num;
			bNum = (int)pack.L1Num;
			}
			else if (pack.L1Num.HasValue)
			{
			pNum = (int)pack.L1Num;
			bNum = (int)pack.L1Num;
			}
			if (pNum == 0 \|\| bNum == 0)
			{
			throw new Exception($"绑定失败，{detail.SkuNo}物品包装未找到！");
			}

			#endregion

			#region 验证是否允许立库同托盘不同物料入库或同托盘同物料不同批次入库
			//var palletBind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNNo == model.AsnNo && m.PalletNo == model.PalletNo && m.ASNDetailNo != model.AsnDetailId);
			//if (palletBind != null)
			//{
			// var box = Db.Queryable<BllBoxInfo>().First(m => m.IsDel == "0" && m.BindNo == palletBind.Id && m.BitBoxMark == "0");
			// if (box != null && (box.SkuNo != detail.SkuNo \|\| !detail.LotNo.Contains(box.LotNo)))
			// {
			// var funSetting = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetNo == "Fun045");
			// if (funSetting == null \|\| funSetting.IsEnable == "OFF")
			// {
			// throw new Exception($"不允许立库同托盘不同物料入库或同托盘不同批次入库！");
			// }
			// }
			//}
			#endregion

			var comTime = DateTime.Now;

			#region 组托信息

			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == model.AsnDetailId && m.PalletNo == model.PalletNo);
			var bindId = 0;
			if (bind == null)
			{
			DateTime? pTime = null;//生产日期
			DateTime? eTime = null;//失效日期
			if (!string.IsNullOrWhiteSpace(detail.Lot1))
			{
			pTime = DateTime.Parse(detail.Lot1);
			}
			if (!string.IsNullOrWhiteSpace(detail.Lot2))
			{
			eTime = DateTime.Parse(detail.Lot2);
			}


			bind = new BllPalletBind
			{
			ASNNo = model.AsnNo,
			ASNDetailNo = (int)model.AsnDetailId,
			PalletNo = model.PalletNo,

			Qty = model.SkuQty,
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = model.LotNo,
			LotText = detail.LotText,
			SupplierLot = detail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			ProductionTime = pTime,
			ExpirationTime = eTime,
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,

			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			bind.Qty += model.SkuQty;
			}
			if (bind.Qty < 0)
			{
			throw new Exception("组托数量不能小于0");
			}

			#endregion

			#region 库存明细
			//获取该批次最终质检结果
			BllQualityInspect quality = new BllQualityInspect();
			//判断是否为退货入库单
			if (notice.Type == "3")
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.ASNNo == detail.ASNNo && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			else
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			var tags = "0";
			if (notice.Type == "3" \|\| notice.Type == "4")
			{
			tags = "1";
			}

			// 判断库存明细是否已有此托盘信息
			var sd1 = Db.Queryable<DataStockDetail>()
			.First(m => m.IsDel == "0" && m.ASNDetailNo == bind.ASNDetailNo && m.PalletNo == model.PalletNo && m.LotNo == bind.LotNo);
			var sdId1 = 0;
			if (sd1 != null)
			{
			sdId1 = sd1.Id;
			// 库存已存在更新数据
			sd1.Qty = bind.Qty;
			sd1.CompleteTime = comTime;
			sd1.UpdateUser = userId;
			sd1.UpdateTime = comTime;

			Db.Updateable(sd1).ExecuteCommand(); //修改质检信息
			}
			else
			{
			string inspectStatusStr = "0";
			if (sku.IsInspect == "1")
			{
			inspectStatusStr = "1";
			}

			// 库存不存在插入数据
			sd1 = new DataStockDetail()
			{
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			SupplierLot = bind.SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = bind.ASNNo,
			ASNDetailNo = bind.ASNDetailNo,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = tags,
			CompleteTime = comTime,
			ProductionTime = bind.ProductionTime,
			ExpirationTime = bind.ExpirationTime,
			Status = "0",
			InspectMark = bind.InspectMark,
			InspectStatus = inspectStatusStr,
			BitPalletMark = bind.BitPalletMark,
			PackagNo = detail.PackagNo, //liudl 由sku的包装编号变为入库单明细的包装编码
			IsBale = bind.IsBale,
			IsBelt = bind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};

			//维护库存明细货主/供应商信息 //0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")
			{
			sd1.OwnerNo = notice.CustomerNo;//货主编码
			sd1.OwnerName = notice.CustomerName;//货主名称
			}
			else if (notice.Type == "1" \|\| notice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = notice.CustomerNo;//供应商编码
			sd1.SupplierName = notice.CustomerName;//供应商名称
			}
			if (quality != null)
			{
			//修改合格不合格数量
			if (quality.IsQualified == "1") //合格
			{
			//增加合格数量
			quality.PassQty += bind.Qty;
			sd1.InspectStatus = "1";
			}
			else if (quality.IsQualified == "0") //不合格
			{
			//增加不合格数量
			quality.FailQty += bind.Qty;
			sd1.InspectStatus = "2";
			}
			Db.Updateable(quality).ExecuteCommand(); //修改质检信息
			}
			//添加库存明细
			sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			}
			#endregion



			#region 更改组托信息

			var isSample = "0";//是否取样
			var sampleQty = 0m;//取样数量


			//if (bind.FullQty < bind.Qty && isTextTable == 0)
			if (bind.FullQty < bind.Qty)
			{
			throw new Exception("托盘绑定数量已超出该物料包装数量");
			}

			if (bind.FullQty == bind.Qty)
			{
			bind.BitPalletMark = "0";
			sd1.BitPalletMark = "0";
			}
			//if (bind.Qty > pNum && isTextTable == 0)
			if (bind.Qty > pNum)
			{
			throw new Exception($"绑定失败，{bind.PalletNo}托盘绑定数量大于该物品托盘包装数量！");
			}

			if (isSample == "1")
			{
			bind.InspectMark = "1";
			bind.SamplingQty = bind.SamplingQty == null ? sampleQty : bind.SamplingQty + sampleQty;
			}
			Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();

			#endregion

			#region 入库单及明细
			decimal addQty = model.SkuQty;

			detail.FactQty += addQty;//已组数量
			detail.CompleteQty += addQty;//完成数量
			if (isSample == "1") //后期业务开发时接口传值改为判断是否取样
			{
			detail.IsSampling = "1";
			}
			detail.Status = "1";//0：等待执行 1：正在执行 2：执行完成
			if (detail.CompleteQty >= detail.Qty)
			{
			detail.Status = "2";
			detail.CompleteTime = comTime;
			}
			detail.UpdateUser = userId;
			detail.UpdateTime = comTime;
			//更新入库单明细
			Db.Updateable(detail).ExecuteCommand();

			notice.UpdateUser = userId;
			notice.UpdateTime = comTime;
			if (notice.Status == "0")
			{
			notice.Status = "1";
			}
			var asnDetailNum = Db.Queryable<BllArrivalNoticeDetail>()
			.Count(m => m.IsDel == "0" && m.ASNNo == detail.ASNNo && m.Status != "2");
			if (asnDetailNum == 0)
			{
			notice.Status = "2";
			notice.CompleteTime = comTime;//完成时间
			}
			//更新入库单
			Db.Updateable(notice).ExecuteCommand();
			#endregion

			#region 库存明细
			sd1.Qty = bind.Qty;
			//更改库存明细数量
			Db.Updateable(sd1).Where(m => m.Id == sdId1).ExecuteCommand();
			#endregion

			#region 库存
			var dataStock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo);
			if (dataStock != null)
			{
			dataStock.Qty += model.SkuQty;


			if (bind.InspectMark == "1")
			{
			dataStock.IsSampling = bind.InspectMark;
			}
			Db.Updateable(dataStock).ExecuteCommand();
			}
			else
			{
			var stock = new DataStock()
			{
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			IsSampling = bind.InspectMark,
			IsDel = "0",
			CreateUser = userId,
			CreateTime = comTime
			};
			//维护库存货主信息
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			stock.OwnerNo = notice.CustomerNo;//货主编码
			stock.OwnerName = notice.CustomerName;//货主名称
			}
			Db.Insertable(stock).ExecuteCommand();
			}
			#endregion

			#region 质检请验
			if ((notice.Type == "1" \|\| notice.Type == "4" \|\| notice.Type == "5") && sku.IsInspect != "1")
			{
			var qualityRequest = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo && m.SupplierLot == bind.SupplierLot);
			if (qualityRequest == null)
			{
			string qcNo = new Common().GetMaxNo("QC");
			qualityRequest = new BllQualityInspectionRequest();
			qualityRequest.QcNo = qcNo;
			qualityRequest.Status = "0";
			qualityRequest.SkuNo = sku.SkuNo;
			qualityRequest.SkuName = sku.SkuName;
			qualityRequest.LotNo = bind.LotNo;
			qualityRequest.SupplierLot = bind.SupplierLot;
			qualityRequest.Qty = detail.Qty;
			qualityRequest.SamplingQty = 0;
			qualityRequest.ASNNo = detail.ASNNo;
			qualityRequest.CreateUser = userId;
			qualityRequest.CreateTime = comTime;
			//添加质检请验单
			Db.Insertable(qualityRequest).ExecuteCommand();
			}
			}
			#endregion

			// 更改托盘使用状态
			var sqlStr = $"update SysPallets set Status = '1' where PalletNo = '{model.PalletNo}';";
			//添加托盘记录表数据
			sqlStr += $"insert into LogPalletTrack values('{model.PalletNo}','{model.AsnNo}','组盘','0',getDate(),{userId},NULL,NULL);";
			Db.Ado.ExecuteCommand(sqlStr);
			new OperationASNServer().AddLogOperationAsn("PDA模块", "托盘绑定", model.AsnNo, "添加", $"添加了托盘码为：{model.PalletNo}的组盘信息", userId);
			}
			catch (Exception e)
			{
			throw new Exception(e.Message);
			}
			}

			/// <summary>
			/// 获取需要贴标签的入库单单据号集合
			/// </summary>
			/// <returns></returns>
			public List<string> GetPasteAsnNoStrList()
			{
			try
			{
			var item = Expressionable.Create<BllArrivalNoticeDetail>()
			.AndIF(true, it => it.IsDel == "0")
			.ToExpression();//注意这一句不能少

			var modelList = Db.Queryable<BllArrivalNoticeDetail>().Where(item)
			.LeftJoin<BllArrivalNotice>((tb1, tb2) => tb1.ASNNo == tb2.ASNNo && tb2.IsDel == "0" && (tb1.Status == "0" \|\| tb1.Status == "1"))
			.LeftJoin<SysMaterials>((tb1, tb2, tb3) => tb1.SkuNo == tb3.SkuNo && tb3.IsDel == "0" && tb3.IsPasteCode == "1")
			.Select((tb1, tb2, tb3) => tb1.ASNNo).Distinct().ToList();

			return modelList;
			}
			catch (Exception e)
			{
			throw new Exception(e.Message);
			}
			}
			/// <summary>
			/// 获取不需要贴标签的入库单单据号集合
			/// </summary>
			/// <returns></returns>
			public List<string> GetNoPasteAsnNoStrList()
			{
			try
			{
			var item = Expressionable.Create<BllArrivalNoticeDetail>()
			.AndIF(true, it => it.IsDel == "0")
			.ToExpression();//注意这一句不能少

			var modelList = Db.Queryable<BllArrivalNoticeDetail>().Where(item)
			.LeftJoin<BllArrivalNotice>((tb1, tb2) => tb1.ASNNo == tb2.ASNNo && tb2.IsDel == "0" && (tb2.Status == "0" \|\| tb2.Status == "1"))
			.LeftJoin<SysMaterials>((tb1, tb2, tb3) => tb1.SkuNo == tb3.SkuNo && tb3.IsDel == "0" && tb3.IsPasteCode == "0")
			.Select((tb1, tb2, tb3) => tb1.ASNNo).Distinct().ToList();

			return modelList;
			}
			catch (Exception e)
			{
			throw new Exception(e.Message);
			}
			}

			/// <summary>
			/// 根据单据号获取单据明细列表
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public List<ArrivalNoticeDetailDto> GetBindArrivalNoticeDetails(ArrivalNoticeVm model)
			{
			string sqlString = string.Empty;
			try
			{
			// 未关单的单据
			sqlString = $"select * from BllArrivalNotice where Type in ({model.Type}) and Status != '3' and Status != '4' and IsDel='0' order by CreateTime;";
			var modelList = Db.Ado.SqlQuery<ArrivalNoticeDto>(sqlString);
			sqlString = $"select * from BllArrivalNoticeDetail where ASNNo = '{model.ASNNo}' and isdel='0' order by CreateTime;";
			var modelList = Db.Ado.SqlQuery<ArrivalNoticeDetailDto>(sqlString);
			List<ArrivalNoticeDetailDto> noticeList = new List<ArrivalNoticeDetailDto>();
			foreach (var item in modelList)
			{
			if (string.IsNullOrEmpty(item.LotNo))
			{
			noticeList.Add(item);
			}
			else
			{
			string[] LotNoList = item.LotNo.Split(';');
			foreach (var item2 in LotNoList)
			{
			ArrivalNoticeDetailDto entry = new ArrivalNoticeDetailDto()
			{
			Id = item.Id,
			ASNNo = item.ASNNo,
			CompleteQty = item.CompleteQty,
			CompleteTime = item.CompleteTime,
			CreateTime = item.CreateTime,
			Qty = item.Qty,
			FactQty = item.FactQty,
			LotNo = item2,
			Money = item.Money,
			PackagNo = item.PackagNo,
			PackagName = item.PackagName,
			Status = item.Status,
			SkuNo = item.SkuNo,
			SkuName = item.SkuName,
			};

			return modelList;

			noticeList.Add(entry);
			}
			}
			}
			List<ArrivalNoticeDetailDto> list = new List<ArrivalNoticeDetailDto>();
			foreach (var item in noticeList)
			{
			string str = BySkuNoGetPackInfo(item.SkuNo);
			if (str == "贴标")
			{
			list.Add(item);
			}
			}

			return list;
			}
			catch (Exception ex)
			{
			@@ -46,24 +1695,11 @@
			}
			}

			//根据入库单号获取入库总单信息
			public List<BllArrivalNotice> GetArrivalNotice(ArrivalNoticeVm model)
			{
			string sqlString = string.Empty;
			try
			{
			sqlString = $"select * from BllArrivalNotice where ASNNo = '{model.ASNNo}' and isdel='0' ";
			var modelList = Db.Ado.SqlQuery<BllArrivalNotice>(sqlString);

			return modelList;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}

			// 根据单据号获取单据明细列表
			/// <summary>
			/// 根据单据号获取单据明细列表
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public List<ArrivalNoticeDetailDto> GetArrivalNoticeDetails(ArrivalNoticeVm model)
			{
			string sqlString = string.Empty;
			@@ -90,7 +1726,11 @@
			}
			}

			// 根据单据明细ID获取明细详情
			/// <summary>
			/// 根据单据明细ID获取明细详情
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public ArrivalNoticeDetailDto GetArrivalNoticeDetail(ArrivalNoticeDetailVm model)
			{
			string sqlString = string.Empty;
			@@ -129,6 +1769,142 @@
			throw ex;
			}
			}

			/// <summary>
			/// 根据箱码获取标签箱码信息
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public List<BoxInfoDto> GetBindBoxInfos(BoxInfoVm model)
			{
			try
			{
			if (string.IsNullOrEmpty(model.BoxNo))
			{
			throw new Exception("请扫描外箱条码!");
			}
			string sqlString = $@"SELECT
			ASNNo,
			BoxNo,
			SkuNo,
			SkuName,
			LotNo,
			BitBoxMark,
			SUM(Qty) as Qty
			FROM BllBoxInfo
			WHERE IsDel = '0'
			AND Status='0'
			AND BoxNo = '{model.BoxNo}'
			GROUP BY ASNNo,BoxNo,SkuNo,SkuName,LotNo,BitBoxMark; ";
			var models = Db.Ado.SqlQuery<BoxInfoDto>(sqlString);

			if (models.Count == 0)
			{
			throw new Exception("箱码信息不存在!");
			}

			return models;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}

			/// <summary>
			/// 根据箱码向追溯系统请求标签箱码信息
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public List<BoxInfoDto> GetFMBindBoxInfos(string boxno)
			{
			try
			{
			#region 箱码请求接口，正式系统放开
			/*var jsonData = JsonConvert.SerializeObject(boxno);

			var response = HttpHelper.DoPost(url, jsonData, "箱码信息请求", "FM");

			var obj = JsonConvert.DeserializeObject<ErpModel>(response);//解析返回数据
			if (obj.Success != 0)
			{
			throw new Exception("请求失败" + obj.Message);
			}*/
			#endregion
			string sqlString = $@"SELECT
			ASNNo,
			BoxNo,
			SkuNo,
			SkuName,
			LotNo,
			BitBoxMark,
			SUM(Qty) as Qty
			FROM BllBoxInfo
			WHERE IsDel = '0'
			AND Status='0'
			AND BoxNo = '{boxno}'
			GROUP BY ASNNo,BoxNo,SkuNo,SkuName,LotNo,BitBoxMark; ";
			var models = Db.Ado.SqlQuery<BoxInfoDto>(sqlString); // response

			if (models.Count == 0)
			{
			throw new Exception("箱码信息不存在!");
			}

			return models;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}


			#endregion







			// 获取单据列表
			public List<ArrivalNoticeDto> GetArrivalNotices(ArrivalNoticeVm model)
			{
			string sqlString = string.Empty;
			try
			{
			// 未关单的单据
			sqlString = $"select * from BllArrivalNotice where Type in ({model.Type}) and Status != '3' and Status != '4' and IsDel='0' order by CreateTime;";
			var modelList = Db.Ado.SqlQuery<ArrivalNoticeDto>(sqlString);

			return modelList;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}

			//根据入库单号获取入库总单信息
			public List<BllArrivalNotice> GetArrivalNotice(ArrivalNoticeVm model)
			{
			string sqlString = string.Empty;
			try
			{
			sqlString = $"select * from BllArrivalNotice where ASNNo = '{model.ASNNo}' and isdel='0' ";
			var modelList = Db.Ado.SqlQuery<BllArrivalNotice>(sqlString);

			return modelList;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}




			/// <summary>
			/// 验证托盘是否存在
			@@ -1884,156 +3660,9 @@
			}

			#region 产品组托
			/// <summary>
			/// 根据箱码获取标签箱码信息
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public List<BoxInfoDto> GetBindBoxInfos(BoxInfoVm model)
			{
			try
			{
			if (string.IsNullOrEmpty(model.BoxNo))
			{
			throw new Exception("请扫描外箱条码!");
			}
			string sqlString = $@"SELECT
			ASNNo,
			BoxNo,
			SkuNo,
			SkuName,
			LotNo,
			BitBoxMark,
			SUM(Qty) as Qty
			FROM BllBoxInfo
			WHERE IsDel = '0'
			AND Status='0'
			AND BoxNo = '{model.BoxNo}'
			GROUP BY ASNNo,BoxNo,SkuNo,SkuName,LotNo,BitBoxMark; ";
			var models = Db.Ado.SqlQuery<BoxInfoDto>(sqlString);


			if (models.Count == 0 )
			{
			throw new Exception("箱码信息不存在!");
			}

			return models;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}

			/// <summary>
			/// 根据箱码向追溯系统请求标签箱码信息
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public List<BoxInfoDto> GetFMBindBoxInfos(string boxno)
			{
			try
			{
			#region 箱码请求接口，正式系统放开
			/*var jsonData = JsonConvert.SerializeObject(boxno);

			var response = HttpHelper.DoPost(url, jsonData, "箱码信息请求", "FM");

			var obj = JsonConvert.DeserializeObject<ErpModel>(response);//解析返回数据
			if (obj.Success != 0)
			{
			throw new Exception("请求失败" + obj.Message);
			}*/
			#endregion
			string sqlString = $@"SELECT
			ASNNo,
			BoxNo,
			SkuNo,
			SkuName,
			LotNo,
			BitBoxMark,
			SUM(Qty) as Qty
			FROM BllBoxInfo
			WHERE IsDel = '0'
			AND Status='0'
			AND BoxNo = '{boxno}'
			GROUP BY ASNNo,BoxNo,SkuNo,SkuName,LotNo,BitBoxMark; ";
			var models = Db.Ado.SqlQuery<BoxInfoDto>(sqlString); // response

			if (models.Count == 0)
			{
			throw new Exception("箱码信息不存在!");
			}

			return models;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}

			// 根据单据号获取单据明细列表
			public List<ArrivalNoticeDetailDto> GetBindArrivalNoticeDetails(ArrivalNoticeVm model)
			{
			string sqlString = string.Empty;
			try
			{
			sqlString = $"select * from BllArrivalNoticeDetail where ASNNo = '{model.ASNNo}' and isdel='0' order by CreateTime;";
			var modelList = Db.Ado.SqlQuery<ArrivalNoticeDetailDto>(sqlString);
			List<ArrivalNoticeDetailDto> noticeList = new List<ArrivalNoticeDetailDto>();
			foreach (var item in modelList)
			{
			if (string.IsNullOrEmpty(item.LotNo))
			{
			noticeList.Add(item);
			}
			else
			{
			string[] LotNoList = item.LotNo.Split(';');
			foreach (var item2 in LotNoList)
			{
			ArrivalNoticeDetailDto entry = new ArrivalNoticeDetailDto()
			{
			Id = item.Id,
			ASNNo = item.ASNNo,
			CompleteQty = item.CompleteQty,
			CompleteTime = item.CompleteTime,
			CreateTime = item.CreateTime,
			Qty = item.Qty,
			FactQty = item.FactQty,
			LotNo = item2,
			Money = item.Money,
			PackagNo = item.PackagNo,
			PackagName = item.PackagName,
			Status = item.Status,
			SkuNo = item.SkuNo,
			SkuName = item.SkuName,
			};


			noticeList.Add(entry);
			}
			}
			}
			List<ArrivalNoticeDetailDto> list = new List<ArrivalNoticeDetailDto>();
			foreach (var item in noticeList)
			{
			string str = BySkuNoGetPackInfo(item.SkuNo);
			if (str == "贴标")
			{
			list.Add(item);
			}
			}

			return list;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}


			//根据物料获取是否存在包装信息
			public string BySkuNoGetPackInfo(string skuNo)
			{
			@@ -3416,1545 +5045,7 @@
			}
			}

			//JC26绑定托盘贴标物料
			public void BindPalletPasteCode(PdaPalletBindVm model, int userId)
			{
			try
			{
			#region 判断
			//0：成品入库 1：采购入库 3：退货入库 4：车间余料入库 5：其它入库 6：代储入库
			var TypeLot = "5, 6";

			if (string.IsNullOrEmpty(model.AsnNo))
			{
			throw new Exception("单据号不可为空!");
			}
			if (model.AsnDetailId == null \|\| model.AsnDetailId == 0)
			{
			throw new Exception("物料不可为空!");
			}
			if (string.IsNullOrEmpty(model.PalletNo))
			{
			throw new Exception("托盘号不可为空!");
			}
			//根据单据号获取入库单总单
			var notice = Db.Queryable<BllArrivalNotice>().First(a => a.IsDel == "0" && a.ASNNo == model.AsnNo);
			if (notice.Status != "0" && notice.Status != "1" && notice.Status != "2")
			{
			throw new Exception("该单据已关单!");
			}

			if (string.IsNullOrEmpty(model.LotNo))
			{
			throw new Exception("物料不为空!");
			}
			else
			{
			//从物料名称-批次中取出批次
			int indexOfDash = model.LotNo.IndexOf("-");
			if (indexOfDash != -1)
			{
			model.LotNo = model.LotNo.Substring(indexOfDash + 1);
			}
			else
			{
			throw new Exception("物料批次不可为空!");
			}
			}

			//判断箱码信息
			if (string.IsNullOrEmpty(model.BoxNo))
			{
			throw new Exception("箱码信息不可为空!");
			}
			//是否连续组托 0：否 1：是
			if (model.IsContinue == "1")
			{
			if (string.IsNullOrWhiteSpace(model.TailBoxNo))
			{
			throw new Exception("开启连续组托时，尾箱码信息不可为空!");
			}
			}

			//托盘信息是否存在
			var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (pallet == null)
			{
			throw new Exception("未查询到托盘信息，请核实！");
			}
			//验证入库单明细是否存在
			var detail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.Id == model.AsnDetailId && m.ASNNo == model.AsnNo && m.LotNo.Contains(model.LotNo));
			if (detail == null)
			{
			throw new Exception("当前物料及批次与单据无关联，请核实!");
			}
			//判断托盘是否在库外
			var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (stockDetail != null && !string.IsNullOrEmpty(stockDetail.WareHouseNo))
			{
			throw new Exception("该托盘已有储位信息，请核实！");
			}
			/*if (stockDetail != null && stockDetail.SkuNo != detail.SkuNo)
			{
			throw new Exception("该托盘在库存已有其它物料信息，请核实！");
			}*/
			#endregion

			//开启事务
			Db.BeginTran();
			//当前时间
			var comTime = DateTime.Now;

			#region 包装
			var package = Db.Queryable<SysPackag>().Where(m => m.IsDel == "0");
			var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == detail.SkuNo);
			var pack = package.First(m => m.IsDel == "0" && m.PackagNo == detail.PackagNo); // liudl 由Sku包装编号变更为入库单明细包装编号

			var pNum = 0;//托盘物品数量
			var bNum = 0;//箱码物品数量

			if (pack == null)
			{
			throw new Exception("获取物料包装失败，请核实!");
			}
			if (pack.L5Num.HasValue)
			{
			pNum = (int)pack.L5Num;
			bNum = (int)pack.L4Num;
			}
			else if (pack.L4Num.HasValue)
			{
			pNum = (int)pack.L4Num;
			bNum = (int)pack.L3Num;
			}
			else if (pack.L3Num.HasValue)
			{
			pNum = (int)pack.L3Num;
			bNum = (int)pack.L2Num;
			}
			else if (pack.L2Num.HasValue)
			{
			pNum = (int)pack.L2Num;
			bNum = (int)pack.L1Num;
			}
			else if (pack.L1Num.HasValue)
			{
			pNum = (int)pack.L1Num;
			bNum = (int)pack.L1Num;
			}
			if (pNum == 0 \|\| bNum == 0)
			{
			throw new Exception($"绑定失败，{detail.SkuNo}物品包装未找到！");
			}

			#endregion

			#region 验证是否允许立库同托盘不同物料入库或同托盘同物料不同批次入库
			var palletBind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNNo == model.AsnNo && m.PalletNo == model.PalletNo && m.ASNDetailNo != model.AsnDetailId);
			if (palletBind != null)
			{
			var box = Db.Queryable<BllBoxInfo>().First(m => m.IsDel == "0" && m.BindNo == palletBind.Id && m.BitBoxMark == "0");
			if (box != null && (box.SkuNo != detail.SkuNo \|\| !detail.LotNo.Contains(box.LotNo)))
			{
			var funSetting = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetNo == "Fun045");
			if (funSetting == null \|\| funSetting.IsEnable == "OFF")
			{
			throw new Exception($"不允许立库同托盘不同物料入库或同托盘不同批次入库！");
			}
			}
			}
			#endregion

			#region 箱码信息
			var msgStr = $"箱号为{model.BoxNo}";
			var boxInfoList = new List<BllBoxInfo>();

			//首箱
			var boxInfo = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BoxNo == model.BoxNo).ToList();
			if (boxInfo.Count == 0)
			{
			throw new Exception("箱码信息不存在!");
			}
			boxInfoList.AddRange(boxInfo);
			//是否连续组托
			if (model.IsContinue == "1")
			{
			//尾箱
			var boxInfo2 = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BoxNo == model.TailBoxNo).ToList();
			if (boxInfo2.Count == 0)
			{
			throw new Exception("尾箱码信息不存在!");
			}
			boxInfoList.AddRange(boxInfo2);
			var sql = $"select * from BllBoxInfo where IsDel = '0' and boxNo>'{model.BoxNo}' and boxNo<'{model.TailBoxNo}'; ";
			var list = Db.Ado.SqlQuery<BllBoxInfo>(sql);
			boxInfoList.AddRange(list);
			msgStr += $"尾箱号为{model.TailBoxNo}";
			}
			//绑定箱总数量
			//model.SkuQty = boxInfoList.Sum(s => s.Qty);
			//和选择的批次同批次的箱码信息
			var sameBoxInfoList = boxInfoList.Where(w => w.LotNo == model.LotNo && w.Status == "0").ToList();
			//和选择的批次不同批次的箱码信息（拼箱批次）
			var notBoxInfoList = boxInfoList.Where(w => w.LotNo != model.LotNo).ToList();
			#endregion

			if (sameBoxInfoList.Count <= 0)
			{
			throw new Exception("箱码信息不存在!");
			}
			else
			{
			#region 托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == model.AsnDetailId && m.PalletNo == model.PalletNo);
			var bindId = 0;
			if (bind == null)
			{
			bind = new BllPalletBind
			{
			ASNNo = model.AsnNo,
			ASNDetailNo = (int)model.AsnDetailId,
			PalletNo = model.PalletNo,
			PalletNo2 = "",
			PalletNo3 = "",
			Qty = model.SkuQty,//不包含拼箱中非同批次数量
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = model.LotNo,
			LotText = detail.LotText,
			SupplierLot = detail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,
			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			bind.Qty += model.SkuQty;
			}
			/*if (bind.Qty < 0)
			{
			throw new Exception("组盘数量不能小于0");
			}*/
			#endregion

			#region 库存明细和质检信息
			//获取该批次最终质检结果
			BllQualityInspect quality = new BllQualityInspect();
			//判断是否为退货入库单
			if (notice.Type == "3")
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.ASNNo == detail.ASNNo && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			else
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			var tags = "0";
			if (notice.Type == "3" \|\| notice.Type == "4")
			{
			tags = "1";
			}

			// 判断库存明细是否已有此托盘信息
			var sd1 = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.ASNDetailNo == bind.ASNDetailNo && m.PalletNo == model.PalletNo);
			var sdId1 = 0;
			if (sd1 != null)
			{
			sdId1 = sd1.Id;
			// 库存已存在更新数据
			sd1.Qty = bind.Qty;
			sd1.CompleteTime = comTime;
			sd1.UpdateUser = userId;
			sd1.UpdateTime = comTime;

			Db.Updateable(sd1).ExecuteCommand();
			}
			else
			{
			// 库存不存在插入数据
			sd1 = new DataStockDetail()
			{
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			SupplierLot = bind.SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = bind.ASNNo,
			ASNDetailNo = bind.ASNDetailNo,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = tags,
			CompleteTime = comTime,
			ProductionTime = bind.ProductionTime,
			ExpirationTime = bind.ExpirationTime,
			Status = "0",
			InspectMark = bind.InspectMark,
			InspectStatus = sku.IsInspect,
			BitPalletMark = bind.BitPalletMark,
			PackagNo = detail.PackagNo, //liudl 由sku的包装编号变为入库单明细的包装编码
			IsBale = bind.IsBale,
			IsBelt = bind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};

			//维护库存明细货主/供应商信息
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			sd1.OwnerNo = notice.CustomerNo;//货主编码
			sd1.OwnerName = notice.CustomerName;//货主名称
			}
			else if (notice.Type == "1" \|\| notice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = notice.CustomerNo;//供应商编码
			sd1.SupplierName = notice.CustomerName;//供应商名称
			}
			if (quality != null)
			{
			//修改合格不合格数量
			if (quality.IsQualified == "1") //合格
			{
			//增加合格数量
			quality.PassQty += bind.Qty;
			sd1.InspectStatus = "1";
			}
			else if (quality.IsQualified == "0") //不合格
			{
			//增加不合格数量
			quality.FailQty += bind.Qty;
			sd1.InspectStatus = "2";
			}
			Db.Updateable(quality).ExecuteCommand(); //修改质检信息
			}
			//添加库存明细
			sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			}
			#endregion

			// 更改箱支关系表
			decimal factQty = 0.00m;//托盘总数量
			var isSample = "0";//是否取样
			var sampleQty = 0m;//取样数量

			//标签组托
			var boxGroup = sameBoxInfoList.GroupBy(m => m.BoxNo).ToList();
			foreach (var g in boxGroup)
			{
			decimal boxFullQty = 0;//箱内总数量
			foreach (var box in g)
			{
			if (box.BindNo != null && box.BindNo != 0)
			{
			continue;
			}
			//箱内物料批次与单据明细不符合
			if (box.SkuNo != detail.SkuNo \|\| box.LotNo != model.LotNo)
			{
			throw new Exception($"-1:{box.BoxNo}箱内物料及批次与单据不一致，请核实!");
			}

			box.ASNNo = model.AsnNo;
			box.ASNDetailNo = model.AsnDetailId;
			box.BindNo = bindId;
			box.PalletNo = model.PalletNo;
			box.Status = "2";
			//box.InspectMark = model.IsSample; //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//box.SamplingQty = 0; //取样数量后期业务开发时接口传值需添加对应字段判断
			box.CompleteTime = comTime;
			box.UpdateTime = comTime;
			box.UpdateUser = userId;

			//box.Qty = box.Qty;
			//box.BitBoxMark = box.Qty == box.FullQty ? "0" : "1";

			factQty += box.Qty;
			boxFullQty += box.Qty;
			if (box.InspectMark == "1") //判断是否取样
			{
			isSample = "1";
			sampleQty += (decimal)box.SamplingQty;
			}

			#region 库存箱码明细
			var box2 = new DataBoxInfo()
			{
			StockDetailId = sdId1,
			BindNo = bind.Id,
			BoxNo = box.BoxNo,
			BoxNo2 = box.BoxNo2,
			BoxNo3 = box.BoxNo3,
			PalletNo = box.PalletNo,
			PalletNo2 = box.PalletNo2,
			PalletNo3 = box.PalletNo3,
			Qty = box.Qty,
			FullQty = box.FullQty,
			Status = "2",//0：未组托 1：已组托 2：已入库 3：已出库 4:已分配 5：已拣货
			LotNo = box.LotNo,
			LotText = box.LotText,
			SkuNo = box.SkuNo,
			SkuName = box.SkuName,
			Standard = sku.Standard,
			ProductionTime = box.ProductionTime,
			SupplierLot = box.SupplierLot,
			InspectStatus = sku.IsInspect,
			InspectMark = box.InspectMark,
			BitBoxMark = box.BitBoxMark,
			ExpirationTime = box.ExpirationTime,

			CreateUser = 0,
			CreateTime = comTime
			};
			//添加库存箱码明细
			Db.Insertable(box2).ExecuteCommand();
			#endregion
			}
			if (boxFullQty > bNum)
			{
			throw new Exception($"绑定失败，{g.Key}箱码绑定数量大于该物品包装数量！");
			}
			}
			//更改箱支关系表信息
			Db.Updateable(boxInfoList).ExecuteCommand();

			// 更新托盘绑定表
			bind.Qty += factQty;

			if (bind.FullQty < bind.Qty)
			{
			throw new Exception("托盘绑定数量已超出该物料包装数量");
			}

			if (bind.FullQty == bind.Qty)
			{
			bind.BitPalletMark = "0";
			sd1.BitPalletMark = "0";
			}
			if (bind.Qty > pNum)
			{
			throw new Exception($"绑定失败，{bind.PalletNo}托盘绑定数量大于该物品托盘包装数量！");
			}

			if (isSample == "1")
			{
			bind.InspectMark = "1";
			bind.SamplingQty = bind.SamplingQty == null ? sampleQty : bind.SamplingQty + sampleQty;
			}
			Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();

			#region 入库单及明细
			detail.FactQty += factQty;//已组数量
			detail.CompleteQty += factQty;//完成数量
			if (isSample == "1") //后期业务开发时接口传值改为判断是否取样
			{
			detail.IsSampling = "1";
			}
			detail.Status = "1";//0：等待执行 1：正在执行 2：执行完成
			if (detail.CompleteQty >= detail.Qty)
			{
			detail.Status = "2";
			detail.CompleteTime = comTime;
			}
			detail.UpdateUser = userId;
			detail.UpdateTime = comTime;
			//更新入库单明细
			Db.Updateable(detail).ExecuteCommand();

			notice.UpdateUser = userId;
			notice.UpdateTime = comTime;
			if (notice.Status == "0")
			{
			notice.Status = "1";
			}
			var asnDetailNum = Db.Queryable<BllArrivalNoticeDetail>().Count(m => m.IsDel == "0" && m.ASNNo == detail.ASNNo && m.Status != "2");
			if (asnDetailNum == 0)
			{
			notice.Status = "2";//执行完成
			notice.CompleteTime = comTime;//完成时间
			}
			//更新入库单
			Db.Updateable(notice).ExecuteCommand();
			#endregion

			#region 库存明细
			sd1.Qty = bind.Qty;
			//更改库存明细数量
			Db.Updateable(sd1).Where(m => m.Id == sdId1).ExecuteCommand();
			#endregion

			#region 库存
			var dataStock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo);
			if (dataStock != null)
			{
			dataStock.Qty += factQty;

			if (bind.InspectMark == "1")
			{
			dataStock.IsSampling = bind.InspectMark;
			}
			Db.Updateable(dataStock).ExecuteCommand();
			}
			else
			{
			var stock = new DataStock()
			{
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			IsSampling = bind.InspectMark,
			IsDel = "0",
			CreateUser = userId,
			CreateTime = comTime
			};
			//维护库存货主信息
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			stock.OwnerNo = notice.CustomerNo;//货主编码
			stock.OwnerName = notice.CustomerName;//货主名称
			}
			Db.Insertable(stock).ExecuteCommand();
			}
			#endregion

			#region 质检请验
			if ((notice.Type == "1" \|\| notice.Type == "4" \|\| notice.Type == "5") && sku.IsInspect != "1")
			{
			var qualityRequest = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo && m.SupplierLot == bind.SupplierLot);
			if (qualityRequest == null)
			{
			string qcNo = new Common().GetMaxNo("QC");
			qualityRequest = new BllQualityInspectionRequest();
			qualityRequest.QcNo = qcNo;
			qualityRequest.Status = "0";
			qualityRequest.SkuNo = sku.SkuNo;
			qualityRequest.SkuName = sku.SkuName;
			qualityRequest.LotNo = bind.LotNo;
			qualityRequest.SupplierLot = bind.SupplierLot;
			qualityRequest.Qty = detail.Qty;
			qualityRequest.SamplingQty = 0;
			qualityRequest.ASNNo = detail.ASNNo;
			qualityRequest.CreateUser = userId;
			qualityRequest.CreateTime = comTime;
			//添加质检请验单
			Db.Insertable(qualityRequest).ExecuteCommand();
			}
			}
			#endregion
			}
			//拼箱
			if (notBoxInfoList.Count > 0)
			{
			var gbox = notBoxInfoList.GroupBy(g => g.BoxNo).ToList();
			if (gbox.Count > 1)
			{
			throw new Exception("一个托盘上只能有1个拼箱!");
			}
			gbox = notBoxInfoList.GroupBy(g => g.LotNo).ToList();
			if (gbox.Count > 1)
			{
			throw new Exception("一个箱内最多能有2个不同批次物料!");
			}
			var pinBoxNo = notBoxInfoList[0].BoxNo;//拼箱箱码
			var pinBoxLotNo = notBoxInfoList[0].LotNo;//拼箱批次号
			//拼箱数量(和选择的批次不同批次的箱码数量)
			decimal pinBoxQty = notBoxInfoList.Sum(s => s.Qty);

			var dataBoxList = Db.Queryable<DataBoxInfo>().Where(w => w.IsDel == "0" && w.BoxNo == pinBoxNo && w.LotNo == pinBoxLotNo).ToList();
			if (dataBoxList.Count > 0)//已有库存
			{
			//原托盘绑定信息
			var oldPalletBind = Db.Queryable<BllPalletBind>().First(w => w.Id == notBoxInfoList[0].BindNo);
			//原入库单明细
			var oldAsnDetail = Db.Queryable<BllArrivalNoticeDetail>().First(w => w.Id == oldPalletBind.ASNDetailNo);
			//原入库单
			var oldAsnNotice = Db.Queryable<BllArrivalNotice>().First(w => w.ASNNo == oldAsnDetail.ASNNo);
			#region 托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == oldAsnDetail.Id && m.PalletNo == model.PalletNo);
			var bindId = 0;
			if (bind == null)
			{
			bind = new BllPalletBind
			{
			ASNNo = oldAsnDetail.ASNNo,
			ASNDetailNo = oldAsnDetail.Id,
			PalletNo = model.PalletNo,
			PalletNo2 = "",
			PalletNo3 = "",
			Qty = 0,
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = pinBoxLotNo,
			LotText = oldAsnDetail.LotText,
			SupplierLot = oldAsnDetail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,
			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			bind.Qty += pinBoxQty;

			Db.Updateable(bind).ExecuteCommand();
			}
			#endregion

			// 插入库存明细数据
			var sd1 = new DataStockDetail()
			{
			LotNo = pinBoxLotNo,
			LotText = notBoxInfoList[0].LotText,
			SupplierLot = notBoxInfoList[0].SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = pinBoxQty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = oldPalletBind.ASNNo,
			ASNDetailNo = oldPalletBind.ASNDetailNo,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = "0",
			CompleteTime = comTime,
			ProductionTime = oldPalletBind.ProductionTime,
			ExpirationTime = oldPalletBind.ExpirationTime,
			Status = "0",
			InspectMark = oldPalletBind.InspectMark,
			InspectStatus = sku.IsInspect,
			BitPalletMark = oldPalletBind.BitPalletMark,
			PackagNo = oldAsnDetail.PackagNo,
			IsBale = oldPalletBind.IsBale,
			IsBelt = oldPalletBind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};
			//维护库存明细货主/供应商信息
			if (oldAsnNotice.Type == "0" \|\| oldAsnNotice.Type == "2" \|\| oldAsnNotice.Type == "4" \|\| oldAsnNotice.Type == "6" \|\| oldAsnNotice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			sd1.OwnerNo = oldAsnNotice.CustomerNo;//货主编码
			sd1.OwnerName = oldAsnNotice.CustomerName;//货主名称
			}
			else if (oldAsnNotice.Type == "1" \|\| oldAsnNotice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = oldAsnNotice.CustomerNo;//供应商编码
			sd1.SupplierName = oldAsnNotice.CustomerName;//供应商名称
			}
			//添加库存明细
			var sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			foreach (var item in dataBoxList)
			{
			item.StockDetailId = sdId1;//库存明细id
			item.BindNo = bind.Id;//托盘绑定id
			}
			//更新库存箱支明细表
			Db.Updateable(dataBoxList).ExecuteCommand();

			//托盘解绑信息
			var palletUnbind = Db.Queryable<BllPalletUnbind>().First(w => w.IsDel == "0" && w.UpbindPalletNo == oldPalletBind.PalletNo && w.BoxNo == pinBoxNo);
			if (palletUnbind == null)
			{
			throw new Exception("拼箱的托盘解绑信息不存在!");
			}
			palletUnbind.BindPalletNo = model.PalletNo;//绑定托盘号
			palletUnbind.UpdateTime = comTime;
			palletUnbind.UpdateUser = userId;
			//更新托盘解绑绑定表信息
			Db.Updateable(palletUnbind).ExecuteCommand();
			}
			else
			{
			string sql = $@"SELECT detail.* FROM BllArrivalNoticeDetail as detail
			JOIN BllArrivalNotice as notice ON detail.ASNNo=notice.ASNNo
			WHERE notice.IsDel='0'
			AND ( notice.Status=0 or notice.Status=1 )
			AND detail.IsDel='0'
			AND detail.LotNo='{pinBoxLotNo}'
			AND detail.SkuNo='{sku.SkuNo}'
			ORDER BY detail.CreateTime ";
			//找到拼箱内其他批次所属入库单明细
			var arrDetail = Db.Ado.SqlQuery<BllArrivalNoticeDetail>(sql).FirstOrDefault();
			if (arrDetail == null)
			{
			throw new Exception("拼箱内物料所属入库单明细不存在!");
			}
			//找到拼箱内其他批次所属入库单
			var arrNotice = Db.Queryable<BllArrivalNotice>().First(w => w.IsDel == "0" && w.ASNNo == arrDetail.ASNNo);
			if (arrNotice == null)
			{
			throw new Exception("拼箱内物料所属入库单不存在!");
			}
			#region 托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == arrDetail.Id && m.PalletNo == model.PalletNo);
			var bindId = 0;
			if (bind == null)
			{
			bind = new BllPalletBind
			{
			ASNNo = arrDetail.ASNNo,
			ASNDetailNo = arrDetail.Id,
			PalletNo = model.PalletNo,
			PalletNo2 = "",
			PalletNo3 = "",
			Qty = 0,
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = pinBoxLotNo,
			LotText = arrDetail.LotText,
			SupplierLot = arrDetail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,
			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			}
			#endregion

			#region 库存明细和质检信息
			//获取该批次最终质检结果
			BllQualityInspect quality = new BllQualityInspect();
			//判断是否为退货入库单
			if (arrNotice.Type == "3")
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.ASNNo == arrDetail.ASNNo && a.SkuNo == arrDetail.SkuNo && a.LotNo == arrDetail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			else
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.SkuNo == arrDetail.SkuNo && a.LotNo == arrDetail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			var tags = "0";
			if (arrNotice.Type == "3" \|\| arrNotice.Type == "4")
			{
			tags = "1";
			}

			// 判断库存明细是否已有此托盘信息
			var sd1 = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.ASNDetailNo == arrDetail.Id && m.PalletNo == model.PalletNo);
			var sdId1 = 0;
			if (sd1 != null)
			{
			sdId1 = sd1.Id;
			// 库存已存在更新数据
			sd1.Qty = bind.Qty;
			sd1.CompleteTime = comTime;
			sd1.UpdateUser = userId;
			sd1.UpdateTime = comTime;

			Db.Updateable(sd1).ExecuteCommand();
			}
			else
			{
			// 库存不存在插入数据
			sd1 = new DataStockDetail()
			{
			LotNo = pinBoxLotNo,
			LotText = notBoxInfoList[0].LotText,
			SupplierLot = bind.SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = arrDetail.ASNNo,
			ASNDetailNo = arrDetail.Id,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = tags,
			CompleteTime = comTime,
			ProductionTime = bind.ProductionTime,
			ExpirationTime = bind.ExpirationTime,
			Status = "0",
			InspectMark = bind.InspectMark,
			InspectStatus = sku.IsInspect,
			BitPalletMark = bind.BitPalletMark,
			PackagNo = arrDetail.PackagNo, //liudl 由sku的包装编号变为入库单明细的包装编码
			IsBale = bind.IsBale,
			IsBelt = bind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};

			//维护库存明细货主/供应商信息
			if (arrNotice.Type == "0" \|\| arrNotice.Type == "2" \|\| arrNotice.Type == "4" \|\| arrNotice.Type == "6" \|\| arrNotice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			sd1.OwnerNo = arrNotice.CustomerNo;//货主编码
			sd1.OwnerName = arrNotice.CustomerName;//货主名称
			}
			else if (arrNotice.Type == "1" \|\| arrNotice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = arrNotice.CustomerNo;//供应商编码
			sd1.SupplierName = arrNotice.CustomerName;//供应商名称
			}
			if (quality != null)
			{
			//修改合格不合格数量
			if (quality.IsQualified == "1") //合格
			{
			//增加合格数量
			quality.PassQty += bind.Qty;
			sd1.InspectStatus = "1";
			}
			else if (quality.IsQualified == "0") //不合格
			{
			//增加不合格数量
			quality.FailQty += bind.Qty;
			sd1.InspectStatus = "2";
			}
			Db.Updateable(quality).ExecuteCommand(); //修改质检信息
			}
			//添加库存明细
			sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			}
			#endregion

			// 更改箱支关系表
			decimal factQty = 0.00m;//托盘总数量
			var isSample = "0";//是否取样
			var sampleQty = 0m;//取样数量

			//标签组托
			var boxGroup = notBoxInfoList.GroupBy(m => m.BoxNo).ToList();
			foreach (var g in boxGroup)
			{
			decimal boxFullQty = 0;//箱内总数量
			foreach (var box in g)
			{
			if (box.BindNo != null && box.BindNo != 0)
			{
			continue;
			}
			//箱内物料批次与单据明细不符合
			if (box.SkuNo != arrDetail.SkuNo \|\| box.LotNo != arrDetail.LotNo)
			{
			throw new Exception($"-1:{box.BoxNo}箱内物料及批次与单据不一致，请核实!");
			}

			box.ASNNo = arrDetail.ASNNo;
			box.ASNDetailNo = arrDetail.Id;
			box.BindNo = bindId;
			box.PalletNo = model.PalletNo;
			box.Status = "2";
			//box.InspectMark = model.IsSample; //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//box.SamplingQty = 0; //取样数量后期业务开发时接口传值需添加对应字段判断
			box.CompleteTime = comTime;
			box.UpdateTime = comTime;
			box.UpdateUser = userId;

			//box.Qty = box.Qty;
			//box.BitBoxMark = box.Qty == box.FullQty ? "0" : "1";

			factQty += box.Qty;
			boxFullQty += box.Qty;
			if (box.InspectMark == "1") //判断是否取样
			{
			isSample = "1";
			sampleQty += (decimal)box.SamplingQty;
			}

			#region 库存箱码明细
			var box2 = new DataBoxInfo()
			{
			StockDetailId = sdId1,
			BindNo = bind.Id,
			BoxNo = box.BoxNo,
			BoxNo2 = box.BoxNo2,
			BoxNo3 = box.BoxNo3,
			PalletNo = box.PalletNo,
			PalletNo2 = box.PalletNo2,
			PalletNo3 = box.PalletNo3,
			Qty = box.Qty,
			FullQty = box.FullQty,
			Status = "2",//0：未组托 1：已组托 2：已入库 3：已出库 4:已分配 5：已拣货
			LotNo = box.LotNo,
			LotText = box.LotText,
			SkuNo = box.SkuNo,
			SkuName = box.SkuName,
			Standard = sku.Standard,
			ProductionTime = box.ProductionTime,
			SupplierLot = box.SupplierLot,
			InspectStatus = sku.IsInspect,
			InspectMark = box.InspectMark,
			BitBoxMark = box.BitBoxMark,
			ExpirationTime = box.ExpirationTime,

			CreateUser = 0,
			CreateTime = comTime
			};
			//添加库存箱码明细
			Db.Insertable(box2).ExecuteCommand();
			#endregion
			}
			if (boxFullQty > bNum)
			{
			throw new Exception($"绑定失败，{g.Key}箱码绑定数量大于该物品包装数量！");
			}
			}
			//更改箱支关系表信息
			Db.Updateable(boxInfoList).ExecuteCommand();

			// 更新托盘绑定表
			bind.Qty += factQty;

			if (bind.FullQty < bind.Qty)
			{
			throw new Exception("托盘绑定数量已超出该物料包装数量");
			}

			if (bind.FullQty == bind.Qty)
			{
			bind.BitPalletMark = "0";
			sd1.BitPalletMark = "0";
			}
			if (bind.Qty > pNum)
			{
			throw new Exception($"绑定失败，{bind.PalletNo}托盘绑定数量大于该物品托盘包装数量！");
			}

			if (isSample == "1")
			{
			bind.InspectMark = "1";
			bind.SamplingQty = bind.SamplingQty == null ? sampleQty : bind.SamplingQty + sampleQty;
			}
			Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();

			#region 入库单及明细
			arrDetail.FactQty += factQty;//已组数量
			arrDetail.CompleteQty += factQty;//完成数量
			if (isSample == "1") //后期业务开发时接口传值改为判断是否取样
			{
			arrDetail.IsSampling = "1";
			}
			arrDetail.Status = "1";//0：等待执行 1：正在执行 2：执行完成
			if (arrDetail.CompleteQty >= arrDetail.Qty)
			{
			arrDetail.Status = "2";
			arrDetail.CompleteTime = comTime;
			}
			arrDetail.UpdateUser = userId;
			arrDetail.UpdateTime = comTime;
			//更新入库单明细
			Db.Updateable(arrDetail).ExecuteCommand();

			arrNotice.UpdateUser = userId;
			arrNotice.UpdateTime = comTime;
			if (arrNotice.Status == "0")
			{
			arrNotice.Status = "1";
			}
			var asnDetailNum = Db.Queryable<BllArrivalNoticeDetail>().Count(m => m.IsDel == "0" && m.ASNNo == arrDetail.ASNNo && m.Status != "2");
			if (asnDetailNum == 0)
			{
			arrNotice.Status = "2";//执行完成
			arrNotice.CompleteTime = comTime;//完成时间
			}
			//更新入库单
			Db.Updateable(arrNotice).ExecuteCommand();
			#endregion

			#region 库存明细
			sd1.Qty = bind.Qty;
			//更改库存明细数量
			Db.Updateable(sd1).Where(m => m.Id == sdId1).ExecuteCommand();
			#endregion

			#region 库存
			var dataStock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo);
			if (dataStock != null)
			{
			dataStock.Qty += factQty;

			if (bind.InspectMark == "1")
			{
			dataStock.IsSampling = bind.InspectMark;
			}
			Db.Updateable(dataStock).ExecuteCommand();
			}
			else
			{
			var stock = new DataStock()
			{
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			IsSampling = bind.InspectMark,
			IsDel = "0",
			CreateUser = userId,
			CreateTime = comTime
			};
			//维护库存货主信息
			if (arrNotice.Type == "0" \|\| arrNotice.Type == "2" \|\| arrNotice.Type == "4" \|\| arrNotice.Type == "6" \|\| arrNotice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			stock.OwnerNo = notice.CustomerNo;//货主编码
			stock.OwnerName = notice.CustomerName;//货主名称
			}
			Db.Insertable(stock).ExecuteCommand();
			}
			#endregion

			#region 质检请验
			if ((arrNotice.Type == "1" \|\| arrNotice.Type == "4" \|\| arrNotice.Type == "5") && sku.IsInspect != "1")
			{
			var qualityRequest = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo && m.SupplierLot == bind.SupplierLot);
			if (qualityRequest == null)
			{
			string qcNo = new Common().GetMaxNo("QC");
			qualityRequest = new BllQualityInspectionRequest();
			qualityRequest.QcNo = qcNo;
			qualityRequest.Status = "0";
			qualityRequest.SkuNo = sku.SkuNo;
			qualityRequest.SkuName = sku.SkuName;
			qualityRequest.LotNo = bind.LotNo;
			qualityRequest.SupplierLot = bind.SupplierLot;
			qualityRequest.Qty = arrDetail.Qty;
			qualityRequest.SamplingQty = 0;
			qualityRequest.ASNNo = arrDetail.ASNNo;
			qualityRequest.CreateUser = userId;
			qualityRequest.CreateTime = comTime;
			//添加质检请验单
			Db.Insertable(qualityRequest).ExecuteCommand();
			}
			}
			#endregion
			}
			}
			// 更改托盘使用状态
			var sqlStr = $"update SysPallets set Status = '1' where PalletNo = '{model.PalletNo}';";
			//添加托盘记录表数据
			sqlStr += $"insert into LogPalletTrack values('{model.PalletNo}','{model.AsnNo}','组盘','0',getDate(),{userId},NULL,NULL);";
			Db.Ado.ExecuteCommand(sqlStr);
			new OperationASNServer().AddLogOperationAsn("PDA模块", "托盘绑定", model.AsnNo, "添加", $"添加了托盘码为：{model.PalletNo}、{msgStr}的组盘信息", userId);

			//提交事务
			Db.CommitTran();
			}
			catch (Exception e)
			{
			//回滚事务
			Db.RollbackTran();
			throw new Exception(e.Message);
			}
			}

			//JC26绑定托盘不贴标物料
			public void BindPalletNoPasteCode(PdaPalletBindVm model, int userId)
			{

			#region 判断

			//0：成品入库 1：采购入库 3：退货入库 4：车间余料入库 5：其它入库 6：代储入库
			var TypeLot = "5, 6";

			if (string.IsNullOrEmpty(model.AsnNo))
			{
			throw new Exception("单据号不可为空!");
			}
			if (model.AsnDetailId == null \|\| model.AsnDetailId == 0)
			{
			throw new Exception("物料不可为空!");
			}
			if (string.IsNullOrEmpty(model.PalletNo))
			{
			throw new Exception("托盘号不可为空!");
			}
			if (model.SkuQty < 0)
			{
			throw new Exception("物料数量不能小于0!");
			}
			//根据单据号获取入库单总单
			var notice = Db.Queryable<BllArrivalNotice>().First(a => a.IsDel == "0" && a.ASNNo == model.AsnNo);
			if (notice.Status != "0" && notice.Status != "1" && notice.Status != "2")
			{
			throw new Exception("该单据已关单!");
			}

			if (string.IsNullOrEmpty(model.LotNo))
			{
			throw new Exception("物料批次不为空!");
			}
			else
			{
			//从物料名称-批次中取出批次
			int indexOfDash = model.LotNo.IndexOf("-");
			if (indexOfDash != -1)
			{
			model.LotNo = model.LotNo.Substring(indexOfDash + 1);
			}
			else
			{
			if (!TypeLot.Contains(notice.Type))
			{
			throw new Exception("物料批次不可为空!");
			}

			model.LotNo = "";
			}
			}

			//int isTextTable = model.TableType;
			#endregion

			var comTime = DateTime.Now;

			//托盘是否存在
			var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (pallet == null)
			{
			throw new Exception("未查询到托盘信息，请核实！");
			}
			// 验证入库单明细是否存在
			var detail = Db.Queryable<BllArrivalNoticeDetail>().First(m => m.IsDel == "0" && m.Id == model.AsnDetailId && m.ASNNo == model.AsnNo && m.LotNo.Contains(model.LotNo));
			if (detail == null)
			{
			throw new Exception("当前物料及批次与单据无关联，请核实!");
			}
			//判断托盘是否在库外
			var stockDetail = Db.Queryable<DataStockDetail>().First(m => m.IsDel == "0" && m.PalletNo == model.PalletNo);
			if (stockDetail != null && !string.IsNullOrEmpty(stockDetail.WareHouseNo))
			{
			throw new Exception("该托盘已有储位信息，请核实！");
			}
			if (stockDetail != null && (stockDetail.SkuNo != detail.SkuNo \|\| stockDetail.LotNo != model.LotNo))
			{
			throw new Exception("该托盘在库存已有其它物料批次信息，请核实！");
			}

			#region 包装
			var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == detail.SkuNo);
			var pack = Db.Queryable<SysPackag>().First(m => m.IsDel == "0" && m.PackagNo == detail.PackagNo); // liudl 由Sku包装编号变更为入库单明细包装编号

			var pNum = 0;//托盘物品数量
			var bNum = 0;//箱码物品数量

			if (pack == null)
			{
			throw new Exception("获取物料包装失败，请核实!");
			}
			if (pack.L5Num.HasValue)
			{
			pNum = (int)pack.L5Num;
			bNum = (int)pack.L4Num;
			}
			else if (pack.L4Num.HasValue)
			{
			pNum = (int)pack.L4Num;
			bNum = (int)pack.L3Num;
			}
			else if (pack.L3Num.HasValue)
			{
			pNum = (int)pack.L3Num;
			bNum = (int)pack.L2Num;
			}
			else if (pack.L2Num.HasValue)
			{
			pNum = (int)pack.L2Num;
			bNum = (int)pack.L1Num;
			}
			else if (pack.L1Num.HasValue)
			{
			pNum = (int)pack.L1Num;
			bNum = (int)pack.L1Num;
			}
			if (pNum == 0 \|\| bNum == 0)
			{
			throw new Exception($"绑定失败，{detail.SkuNo}物品包装未找到！");
			}

			#endregion

			#region 验证是否允许立库同托盘不同物料入库或同托盘同物料不同批次入库
			var palletBind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNNo == model.AsnNo && m.PalletNo == model.PalletNo && m.ASNDetailNo != model.AsnDetailId);
			if (palletBind != null)
			{
			var box = Db.Queryable<BllBoxInfo>().First(m => m.IsDel == "0" && m.BindNo == palletBind.Id && m.BitBoxMark == "0");
			if (box != null && (box.SkuNo != detail.SkuNo \|\| !detail.LotNo.Contains(box.LotNo)))
			{
			var funSetting = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetNo == "Fun045");
			if (funSetting == null \|\| funSetting.IsEnable == "OFF")
			{
			throw new Exception($"不允许立库同托盘不同物料入库或同托盘不同批次入库！");
			}
			}
			}
			#endregion
			//liudl && m.Status != "2" 组盘既入库完成无需根据托盘状态判断
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.ASNDetailNo == model.AsnDetailId && m.PalletNo == model.PalletNo);
			var bindId = 0;
			if (bind == null)
			{
			DateTime? pTime = null;
			DateTime? eTime = null;
			if (!string.IsNullOrWhiteSpace(detail.Lot1))
			{
			pTime = DateTime.Parse(detail.Lot1);
			}
			if (!string.IsNullOrWhiteSpace(detail.Lot2))
			{
			eTime = DateTime.Parse(detail.Lot2);
			}


			bind = new BllPalletBind
			{
			ASNNo = model.AsnNo,
			ASNDetailNo = (int)model.AsnDetailId,
			PalletNo = model.PalletNo,

			Qty = model.SkuQty,
			FullQty = pNum,
			Status = "2",//入库完成
			Type = "0",
			LotNo = model.LotNo,
			LotText = detail.LotText,
			SupplierLot = detail.SupplierLot,
			//InspectMark = model.IsSample, //是否取样托盘后期业务开发时接口传值需添加对应字段判断
			//SamplingQty = 0, //取样数量后期业务开发时接口传值需添加对应字段判断
			ProductionTime = pTime,
			ExpirationTime = eTime,
			BitPalletMark = "1",
			IsBale = "0",
			IsBelt = "0",
			CreateUser = userId,
			Demo = model.Demo,

			};
			// 插入托盘绑定表
			bindId = Db.Insertable(bind).ExecuteReturnIdentity();
			}
			else
			{
			bindId = bind.Id;
			bind.Qty += model.SkuQty;
			}
			if (bind.Qty < 0)
			{
			throw new Exception("组盘数量不能小于0");
			}

			#region 库存明细
			//获取该批次最终质检结果
			BllQualityInspect quality = new BllQualityInspect();
			//判断是否为退货入库单
			if (notice.Type == "3")
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.ASNNo == detail.ASNNo && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			else
			{
			quality = Db.Queryable<BllQualityInspect>().Where(a => a.IsDel == "0" && a.SkuNo == detail.SkuNo && a.LotNo == detail.LotNo).OrderByDescending(a => a.CreateTime).First();
			}
			var tags = "0";
			if (notice.Type == "3" \|\| notice.Type == "4")
			{
			tags = "1";
			}

			// 判断库存明细是否已有此托盘信息
			var sd1 = Db.Queryable<DataStockDetail>()
			.First(m => m.IsDel == "0" && m.ASNDetailNo == bind.ASNDetailNo && m.PalletNo == model.PalletNo && m.LotNo == bind.LotNo);
			var sdId1 = 0;
			if (sd1 != null)
			{
			sdId1 = sd1.Id;
			// 库存已存在更新数据
			sd1.Qty = bind.Qty;
			sd1.CompleteTime = comTime;
			sd1.UpdateUser = userId;
			sd1.UpdateTime = comTime;

			Db.Updateable(sd1).ExecuteCommand(); //修改质检信息
			}
			else
			{
			string inspectStatusStr = "0";
			if (sku.IsInspect == "1")
			{
			inspectStatusStr = "1";
			}

			// 库存不存在插入数据
			sd1 = new DataStockDetail()
			{
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			SupplierLot = bind.SupplierLot,
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			InspectQty = 0,
			ASNNo = bind.ASNNo,
			ASNDetailNo = bind.ASNDetailNo,
			WareHouseNo = "",//所属仓库
			RoadwayNo = "",//所属巷道
			AreaNo = "",//所属区域
			LocatNo = "",//储位地址
			PalletNo = bind.PalletNo,
			PalletNo2 = bind.PalletNo2,
			PalletNo3 = bind.PalletNo3,
			PalletTags = tags,
			CompleteTime = comTime,
			ProductionTime = bind.ProductionTime,
			ExpirationTime = bind.ExpirationTime,
			Status = "0",
			InspectMark = bind.InspectMark,
			InspectStatus = inspectStatusStr,
			BitPalletMark = bind.BitPalletMark,
			PackagNo = detail.PackagNo, //liudl 由sku的包装编号变为入库单明细的包装编码
			IsBale = bind.IsBale,
			IsBelt = bind.IsBelt,

			IsDel = "0",
			CreateUser = 0,
			CreateTime = comTime
			};

			//维护库存明细货主/供应商信息
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			sd1.OwnerNo = notice.CustomerNo;//货主编码
			sd1.OwnerName = notice.CustomerName;//货主名称
			}
			else if (notice.Type == "1" \|\| notice.Type == "5")//1:采购入库,2:其它入库
			{
			sd1.SupplierNo = notice.CustomerNo;//供应商编码
			sd1.SupplierName = notice.CustomerName;//供应商名称
			}
			if (quality != null)
			{
			//修改合格不合格数量
			if (quality.IsQualified == "1") //合格
			{
			//增加合格数量
			quality.PassQty += bind.Qty;
			sd1.InspectStatus = "1";
			}
			else if (quality.IsQualified == "0") //不合格
			{
			//增加不合格数量
			quality.FailQty += bind.Qty;
			sd1.InspectStatus = "2";
			}
			Db.Updateable(quality).ExecuteCommand(); //修改质检信息
			}
			//添加库存明细
			sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
			}
			#endregion



			// 更改箱支关系表

			var isSample = "0";//是否取样
			var sampleQty = 0m;//取样数量


			//if (bind.FullQty < bind.Qty && isTextTable == 0)
			if (bind.FullQty < bind.Qty)
			{
			throw new Exception("托盘绑定数量已超出该物料包装数量");
			}

			if (bind.FullQty == bind.Qty)
			{
			bind.BitPalletMark = "0";
			sd1.BitPalletMark = "0";
			}
			//if (bind.Qty > pNum && isTextTable == 0)
			if (bind.Qty > pNum)
			{
			throw new Exception($"绑定失败，{bind.PalletNo}托盘绑定数量大于该物品托盘包装数量！");
			}

			if (isSample == "1")
			{
			bind.InspectMark = "1";
			bind.SamplingQty = bind.SamplingQty == null ? sampleQty : bind.SamplingQty + sampleQty;
			}
			Db.Updateable(bind).Where(m => m.Id == bindId).ExecuteCommand();

			#region 入库单及明细
			decimal addQty = model.SkuQty;

			detail.FactQty += addQty;//已组数量
			detail.CompleteQty += addQty;//完成数量
			if (isSample == "1") //后期业务开发时接口传值改为判断是否取样
			{
			detail.IsSampling = "1";
			}
			detail.Status = "1";//0：等待执行 1：正在执行 2：执行完成
			if (detail.CompleteQty >= detail.Qty)
			{
			detail.Status = "2";
			detail.CompleteTime = comTime;
			}
			detail.UpdateUser = userId;
			detail.UpdateTime = comTime;
			//更新入库单明细
			Db.Updateable(detail).ExecuteCommand();

			notice.UpdateUser = userId;
			notice.UpdateTime = comTime;
			if (notice.Status == "0")
			{
			notice.Status = "1";
			}
			var asnDetailNum = Db.Queryable<BllArrivalNoticeDetail>()
			.Count(m => m.IsDel == "0" && m.ASNNo == detail.ASNNo && m.Status != "2");
			if (asnDetailNum == 0)
			{
			notice.Status = "2";
			notice.CompleteTime = comTime;//完成时间
			}
			//更新入库单
			Db.Updateable(notice).ExecuteCommand();
			#endregion

			#region 库存明细
			sd1.Qty = bind.Qty;
			//更改库存明细数量
			Db.Updateable(sd1).Where(m => m.Id == sdId1).ExecuteCommand();
			#endregion

			#region 库存
			var dataStock = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo);
			if (dataStock != null)
			{
			dataStock.Qty += model.SkuQty;


			if (bind.InspectMark == "1")
			{
			dataStock.IsSampling = bind.InspectMark;
			}
			Db.Updateable(dataStock).ExecuteCommand();
			}
			else
			{
			var stock = new DataStock()
			{
			SkuNo = sku.SkuNo,
			SkuName = sku.SkuName,
			Standard = sku.Standard,
			LotNo = bind.LotNo,
			LotText = bind.LotText,
			Qty = bind.Qty,
			LockQty = 0,
			FrozenQty = 0,
			IsSampling = bind.InspectMark,
			IsDel = "0",
			CreateUser = userId,
			CreateTime = comTime
			};
			//维护库存货主信息
			if (notice.Type == "0" \|\| notice.Type == "2" \|\| notice.Type == "4" \|\| notice.Type == "6" \|\| notice.Type == "7")//0:成品入库，2:中间品入库,4:车间余料入库,6:代储入库,7:寄存入库
			{
			stock.OwnerNo = notice.CustomerNo;//货主编码
			stock.OwnerName = notice.CustomerName;//货主名称
			}
			Db.Insertable(stock).ExecuteCommand();
			}
			#endregion

			#region 质检请验
			if ((notice.Type == "1" \|\| notice.Type == "4" \|\| notice.Type == "5") && sku.IsInspect != "1")
			{
			var qualityRequest = Db.Queryable<BllQualityInspectionRequest>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo && m.LotNo == bind.LotNo && m.SupplierLot == bind.SupplierLot);
			if (qualityRequest == null)
			{
			string qcNo = new Common().GetMaxNo("QC");
			qualityRequest = new BllQualityInspectionRequest();
			qualityRequest.QcNo = qcNo;
			qualityRequest.Status = "0";
			qualityRequest.SkuNo = sku.SkuNo;
			qualityRequest.SkuName = sku.SkuName;
			qualityRequest.LotNo = bind.LotNo;
			qualityRequest.SupplierLot = bind.SupplierLot;
			qualityRequest.Qty = detail.Qty;
			qualityRequest.SamplingQty = 0;
			qualityRequest.ASNNo = detail.ASNNo;
			qualityRequest.CreateUser = userId;
			qualityRequest.CreateTime = comTime;
			//添加质检请验单
			Db.Insertable(qualityRequest).ExecuteCommand();
			}
			}
			#endregion

			// 更改托盘使用状态
			var sqlStr = $"update SysPallets set Status = '1' where PalletNo = '{model.PalletNo}';";
			//添加托盘记录表数据
			sqlStr += $"insert into LogPalletTrack values('{model.PalletNo}','{model.AsnNo}','组盘','0',getDate(),{userId},NULL,NULL);";
			Db.Ado.ExecuteCommand(sqlStr);
			new OperationASNServer().AddLogOperationAsn("PDA模块", "托盘绑定", model.AsnNo, "添加", $"添加了托盘码为：{model.PalletNo}的组盘信息", userId);
			}


			#endregion