JC24WMS.git - Gitblit

			@@ -264,7 +264,7 @@
			.AndIF(!string.IsNullOrWhiteSpace(model.ProductionTime), it => it.ProductionTime >= Convert.ToDateTime(model.ProductionTime))
			.AndIF(!string.IsNullOrWhiteSpace(model.InspectMark), it => it.InspectMark == model.InspectMark.Trim())
			.AndIF(!string.IsNullOrWhiteSpace(model.BitBoxMark), it => it.BitBoxMark == model.BitBoxMark.Trim())
			.AndIF(!string.IsNullOrWhiteSpace(model.Origin), it => it.Origin == model.Origin.Trim())
			.AndIF(!string.IsNullOrWhiteSpace(model.Origin), it => model.Origin.Trim().Contains(it.Origin))
			.And(m => m.SkuNo != "100099" && m.IsDel == "0" && m.Status == "0")
			.ToExpression();//注意这一句不能少
			var total = 0;
			@@ -412,10 +412,10 @@
			.AndIF(!string.IsNullOrWhiteSpace(model.SkuNo), it => it.SkuNo.Contains(model.SkuNo.Trim()))
			.AndIF(!string.IsNullOrWhiteSpace(model.LotNo), it => it.LotNo.Contains(model.LotNo.Trim()))
			.AndIF(!string.IsNullOrWhiteSpace(model.SupplierLot), it => it.SupplierLot.Contains(model.SupplierLot.Trim()))
			.AndIF(!string.IsNullOrWhiteSpace(model.Status), it => it.Status == model.SupplierLot)
			.AndIF(!string.IsNullOrWhiteSpace(model.Status), it => it.Status == model.Status)
			.AndIF(!string.IsNullOrWhiteSpace(model.ProductionTime), it => it.ProductionTime >= Convert.ToDateTime(model.ProductionTime))
			.AndIF(!string.IsNullOrWhiteSpace(model.ProductionTime), it => it.ProductionTime <= Convert.ToDateTime(model.ProductionTime).AddDays(1))
			.And(it => it.IsDel == "0")
			.And(it => it.IsDel == "0" && it.Origin == "WMS生成")
			.ToExpression();

			var total = 0;
			@@ -529,7 +529,7 @@
			}

			//获取标签信息(生成标签)
			public List<BoxInfoDto> AddLabelBoxReturn(int imId, string isReset, decimal arriveQty, string productionTime, string expirationTime, string storeTime, int userId)
			public List<BllBoxInfo> AddLabelBox(int imId, string isReset, decimal arriveQty, string productionTime, string expirationTime, string storeTime,string supplierLot, int userId)
			{
			try
			{
			@@ -576,7 +576,7 @@
			packStr += "-" + pack.L5Num + "/" + pack.L5Name;
			}
			//标签表
			var label = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.ASNDetailNo == imId).ToList();
			var label = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.Origin == "WMS生成").ToList();


			#endregion
			@@ -586,40 +586,14 @@
			var bNum = 0;//箱物品数量
			var zNum = 0;//支物品数量
			var packLevel = 0;
			var isGo = true;

			if (pack.L5Num.HasValue)
			{
			if (pack.L5Name != "托")
			{
			isGo = false;
			packLevel = 5;
			bNum = Convert.ToInt32(pack.L5Num);
			}
			}
			if (pack.L4Num.HasValue && isGo)
			{
			if (pack.L4Name != "托")
			{
			isGo = false;
			packLevel = 4;
			bNum = Convert.ToInt32(pack.L4Num);
			}
			}
			if (pack.L3Num.HasValue && isGo)
			{
			if (pack.L4Name != "托")
			{
			isGo = false;
			packLevel = 3;
			bNum = Convert.ToInt32(pack.L3Num);
			}
			}

			if (pack.L2Num.HasValue)
			{
			packLevel = 2;
			bNum = Convert.ToInt32(pack.L2Num);

			if (pack.L2Name != "托")
			{
			packLevel = 2;
			bNum = Convert.ToInt32(pack.L2Num);
			}
			}
			if (pack.L1Num.HasValue)
			{
			@@ -631,36 +605,44 @@
			zNum = Convert.ToInt32(pack.L1Num);
			}

			if (packLevel <= 1)//包装等级小于1，按照1级标签打印
			if (packLevel < 1)//包装等级小于1，按照1级标签打印
			{
			packLevel = 1;
			throw new Exception("包装信息有误，小于一级");
			}

			#endregion
			var modelList = new List<BllBoxInfo>();

			var addLotNo = "";
			if (arriveQty <= 0)
			{
			throw new Exception("到货数量不能小于等于0!");
			}
			Db.BeginTran();
			if (packLevel == 1)
			{
			#region 一级包装

			// 根据用户输入的箱数量计算需要的条码数
			var labQty = label.Sum(m => m.Qty);
			var qty = asnList.Qty - labQty;//当前单据剩余需要打印的物料数量(不是标签数量)
			if (qty <= 0)
			{
			throw new Exception("当前单据物料标签已打印完毕，如有需要请补打");
			}
			//var labQty = label.Sum(m => m.Qty);
			//var qty = asnList.Qty - labQty;//当前单据剩余需要打印的物料数量(不是标签数量)
			//if (qty <= 0)
			//{
			// throw new Exception("当前单据物料标签已打印完毕，如有需要请补打");
			//}

			#region 到货数量

			if (arriveQty - qty > 0)
			{
			throw new Exception("到货数量大于未打标签数量，请重新输入到货数量并核实!");
			}
			else
			{
			qty = arriveQty;
			}

			//if (arriveQty - qty > 0)
			//{
			// throw new Exception("到货数量大于未打标签数量，请重新输入到货数量并核实!");
			//}
			//else
			//{
			// qty = arriveQty;
			//}

			var qty = arriveQty;
			#endregion

			int labelNum = 1; //生产条码数量
			@@ -679,23 +661,39 @@
			string maxBoxCode = ""; //箱码号
			// 生成自编批号
			string toDayTime = DateTime.Now.ToString("yyyyMMdd");


			var maxLotNo = label.Max(a => a.LotNo);
			var maxBoxNo = label.Max(a => a.BoxNo);

			if (isReset == "0")
			{

			maxLotNoStr = maxLotNo;
			maxBoxCode = maxBoxNo;
			if (string.IsNullOrWhiteSpace(maxLotNoStr))
			//判断单据是否是余料退回单
			if (asn.Type == "4")
			{
			maxLotNoStr = toDayTime.Substring(2, 6) + "0001";
			maxLotNoStr = asnList.LotNo;
			maxBoxCode = label.Where(m=>m.LotNo == maxLotNoStr).Max(a => a.BoxNo);
			if (string.IsNullOrWhiteSpace(maxLotNoStr))
			{
			throw new Exception("车间余料退回单据批次不能为空");
			}
			}
			else
			{
			var labelCount = label.Where(m => m.ASNDetailNo == imId).ToList();
			if (labelCount.Count <= 0)
			{
			throw new Exception("当前单据明细还未生成标签，请选择重置批次选项为‘是’；");
			}
			maxLotNoStr = labelCount.Max(a => a.LotNo);

			if (string.IsNullOrWhiteSpace(maxLotNoStr))
			{
			maxLotNoStr = toDayTime.Substring(2, 6) + "0001";
			}
			maxBoxCode = label.Where(m => m.LotNo == maxLotNoStr).Max(a => a.BoxNo);
			}

			}
			else
			{
			var maxCode = Db.Queryable<BllLabelBoxNo>().Max(a => a.LotNo); // 获取今天最大批次号
			var maxCode = Db.Queryable<BllBoxInfo>().Where(m=>m.Origin == "WMS生成").Max(a => a.LotNo); // 获取今天最大批次号
			if (string.IsNullOrWhiteSpace(maxCode))
			{
			maxLotNoStr = toDayTime.Substring(2, 6) + "0001";
			@@ -716,9 +714,10 @@
			}
			}

			addLotNo = maxLotNoStr;
			#endregion




			for (int i = 1; i <= labelNum; i++)
			{
			@@ -742,14 +741,14 @@
			}

			//获取箱码
			if (maxBoxCode == "")
			if (string.IsNullOrWhiteSpace(maxBoxCode))
			{
			var str = maxLotNoStr + "000001"; //批号+ 流水 2302010001000001
			var str = "B"+maxLotNoStr + "000001"; //批号+ 流水 2302010001000001
			maxBoxCode = str;
			}
			else
			{
			maxBoxCode = maxBoxCode.Substring(0, 10) + (int.Parse(maxBoxCode.Substring(10, 6)) + 1).ToString().PadLeft(6, '0');
			maxBoxCode = maxBoxCode.Substring(0, 11) + (int.Parse(maxBoxCode.Substring(11, 6)) + 1).ToString().PadLeft(6, '0');
			}

			// 将条码保存到原料条码表
			@@ -766,7 +765,7 @@
			LotNo = maxLotNoStr,
			Standard = asnList.Standard,
			PackageStandard = packStr,
			SupplierLot = asnList.SupplierLot,
			SupplierLot = supplierLot,
			InspectMark = "0",
			BitBoxMark = bNum > boxQty ? "1":"0",
			InspectStatus = "",
			@@ -791,25 +790,27 @@
			#region 二级包装

			// 根据用户输入的箱数量计算需要的条码数
			var labQty = label.Sum(m => m.Qty);
			var qty2 = asnList.Qty - labQty;
			if (qty2 <= 0)
			{
			throw new Exception("当前单据物料标签已打印完毕，如有需要请补打");
			}
			//var labQty = label.Sum(m => m.Qty);
			//var qty2 = asnList.Qty - labQty;
			//if (qty2 <= 0)
			//{
			// throw new Exception("当前单据物料标签已打印完毕，如有需要请补打");
			//}

			#region 增加到货数量

			if (arriveQty - qty2 > 0)
			{
			throw new Exception("到货数量大于未打标签数量，请重新输入到货数量!");
			}
			else
			{
			qty2 = arriveQty;
			}
			//if (arriveQty - qty2 > 0)
			//{
			// throw new Exception("到货数量大于未打标签数量，请重新输入到货数量!");
			//}
			//else
			//{
			// qty2 = arriveQty;
			//}
			#endregion


			var qty2 = arriveQty;
			int labelNum2 = 1; //生产箱条码数量

			labelNum2 = int.Parse(Math.Ceiling(qty2 / bNum).ToString());
			@@ -828,20 +829,38 @@
			string toDayTime2 = DateTime.Now.ToString("yyyyMMdd");
			if (isReset == "0")
			{
			var maxCode = label.Max(a => a.LotNo);
			var boxCode1 = label.Max(a => a.BoxNo);//箱号
			var boxCode2 = label.Max(a => a.BoxNo3);//支号
			maxCodestr2 = maxCode;
			maxboxcode2 = boxCode1;
			maxboxcode3 = boxCode2;
			if (string.IsNullOrWhiteSpace(maxCodestr2))
			//判断单据是否是余料退回单
			if (asn.Type == "4")
			{
			maxCodestr2 = toDayTime2.Substring(2, 6) + "0001";
			maxCodestr2 = asnList.LotNo;
			maxboxcode2 = label.Where(m => m.LotNo == maxCodestr2).Max(a => a.BoxNo);
			maxboxcode3 = label.Where(m => m.LotNo == maxCodestr2).Max(a => a.BoxNo3);//支号
			if (string.IsNullOrWhiteSpace(maxCodestr2))
			{
			throw new Exception("车间余料退回单据批次不能为空");
			}
			}
			else
			{
			var labelCount = label.Where(m => m.ASNDetailNo == imId).ToList();
			if (labelCount.Count <= 0)
			{
			throw new Exception("当前单据明细还未生成标签，请选择重置批次选项为‘是’；");
			}
			maxCodestr2 = labelCount.Max(a => a.LotNo); ;

			if (string.IsNullOrWhiteSpace(maxCodestr2))
			{
			maxCodestr2 = toDayTime2.Substring(2, 6) + "0001";
			}
			maxboxcode2 = label.Where(m => m.LotNo == maxCodestr2).Max(a => a.BoxNo);//箱号;
			maxboxcode3 = label.Where(m => m.LotNo == maxCodestr2).Max(a => a.BoxNo3);//支号;
			}

			}
			else
			{
			var maxCode = Db.Queryable<BllLabelBoxNo>().Max(a => a.LotNo); // 获取今天最大批次号
			var maxCode = Db.Queryable<BllBoxInfo>().Where(m => m.Origin == "WMS生成").Max(a => a.LotNo); // 获取今天最大批次号
			if (string.IsNullOrWhiteSpace(maxCode))
			{
			maxCodestr2 = toDayTime2.Substring(2, 6) + "0001";
			@@ -862,21 +881,41 @@
			}
			}

			addLotNo = maxCodestr2;
			#endregion




			for (int i = 1; i <= labelNum2; i++)//箱码标签
			{

			//获取箱码
			if (maxboxcode2 == "")
			//箱内数量
			decimal boxQty = 0;
			if (i == labelNum2)
			{
			maxboxcode2 = maxCodestr2 + "000001"; // 箱号批号+第几箱
			// 最后一个条码
			var s = bNum * (i - 1);
			if (bNum > qty2 - s)
			{
			boxQty = qty2 - s;// 数量
			}
			else
			{
			boxQty = bNum;// 数量
			}
			}
			else
			{
			maxboxcode2 = maxboxcode2.Substring(0, 10) + (int.Parse(maxboxcode2.Substring(10, 6)) + 1).ToString().PadLeft(6, '0');
			boxQty = bNum; // 数量
			}

			//获取箱码
			if (string.IsNullOrWhiteSpace(maxboxcode2))
			{
			maxboxcode2 = "B"+maxCodestr2 + "000001"; // 箱号批号+第几箱
			}
			else
			{
			maxboxcode2 = maxboxcode2.Substring(0, 11) + (int.Parse(maxboxcode2.Substring(11, 6)) + 1).ToString().PadLeft(6, '0');
			}
			//获取箱内支标签数量
			if (i == labelNum2)
			@@ -888,6 +927,12 @@
			if (isGo2)
			{
			break;
			}
			var s = bNum * (i - 1);
			var s2 = zNum * (j - 1);
			if (zNum >= qty2 - s - s2)
			{
			isGo2 = true;
			}
			sl++;
			}
			@@ -908,14 +953,17 @@
			}
			}

			if (maxboxcode3 == "")
			if (string.IsNullOrWhiteSpace(maxboxcode3))
			{
			maxboxcode3 = maxCodestr2 + "0001"; // 支号批号+第几箱
			maxboxcode3 = "Z"+maxCodestr2 + "0001"; // 支号批号+第几箱
			}
			else
			{
			maxboxcode3 = maxboxcode3.Substring(0, 28) + (int.Parse(maxboxcode3.Substring(28, 4)) + 1).ToString().PadLeft(4, '0');
			maxboxcode3 = maxboxcode3.Substring(0, 11) + (int.Parse(maxboxcode3.Substring(11, 4)) + 1).ToString().PadLeft(4, '0');
			}

			var ssss = d.ToString("0");
			var sss = int.Parse(ssss);

			// 将条码保存到原料条码表
			var labelModel = new BllBoxInfo()
			@@ -924,7 +972,7 @@
			ASNDetailNo = asnList.Id,
			BoxNo = maxboxcode2,
			BoxNo3 = maxboxcode3,
			Qty = int.Parse(d.ToString()),
			Qty = sss,
			FullQty = bNum,
			Status = "0",
			SkuNo = asnList.SkuNo,
			@@ -934,7 +982,7 @@
			PackageStandard = packStr,
			SupplierLot = asnList.SupplierLot,
			InspectMark = "0",
			BitBoxMark = bNum > d ? "1" : "0",
			BitBoxMark = bNum > boxQty ? "1" : "0",
			InspectStatus = "0",

			ProductionTime = DateTime.Parse(productionTime),
			@@ -955,11 +1003,589 @@

			#endregion
			}

			//return labelModel;
			if (string.IsNullOrWhiteSpace(asnList.LotNo))
			{
			asnList.LotNo = addLotNo;
			Db.Updateable(asnList).ExecuteCommand();
			}
			else
			{
			if (!asnList.LotNo.Contains(addLotNo))
			{
			asnList.LotNo += ";" + addLotNo;
			Db.Updateable(asnList).ExecuteCommand();
			}
			}
			Db.CommitTran();
			return modelList;


			throw new NotImplementedException();
			//throw new NotImplementedException();
			}
			catch (Exception e)
			{
			Db.RollbackTran();
			throw new Exception(e.Message);
			}
			}

			// 补打标签
			public List<BoxInfoDto> GetBuDaLabelList(string boxNo, string endBoxNo, string boxNo2, string endBoxNo2, string type, int userId)
			{
			try
			{
			//打印数据集合
			var printList = new List<BoxInfoDto>();

			List<BoxInfoDto> printModelList = new List<BoxInfoDto>();
			//List<WmsLabelPrintLog> printlog = new List<WmsLabelPrintLog>();
			//标签表数据信息
			var list = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.Origin == "WMS生成").ToList();

			#region MyRegion

			switch (type)
			{
			case "1":
			if (string.IsNullOrWhiteSpace(endBoxNo))
			{
			#region 单个箱码标签

			if (string.IsNullOrWhiteSpace(boxNo))
			{
			throw new Exception($"起始箱码不能为空");
			}
			var dataList = list.Where(m => m.BoxNo == boxNo);
			var data = list.FirstOrDefault(m => m.BoxNo == boxNo);
			if (data == null)
			{
			throw new Exception($"未查询到{boxNo}信息");
			}
			// 物料条码信息赋值
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = data.SkuNo;
			model.SkuName = data.SkuName;
			model.LotNo = data.LotNo; //批次
			model.SupplierLot = data.SupplierLot; // 原厂批号
			model.Standard = data.Standard; // 规格/型号
			model.PackageStandard = data.PackageStandard; // 包装规格

			model.ExpirationTime = data.ExpirationTime; // 有效期至
			model.StoreTime = data.StoreTime; // 储存期至

			model.Qty = dataList.Sum(m=>m.Qty);// 数量

			model.BoxNo = data.BoxNo; // 箱号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo,160, 40,false);

			// 添加到list集合
			printModelList.Add(model);

			//添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = data.LabelStream;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);
			#endregion
			}
			else
			{
			#region 多个箱码标签开始-结束
			if (string.IsNullOrWhiteSpace(boxNo))
			{
			throw new Exception("起始箱码不能为空");
			}
			var sql = $@"select * from BllBoxInfo where IsDel = '0' and Origin = 'WMS生成' and BoxNo >='{boxNo}' and BoxNo <= '{endBoxNo}'";
			var data2 = Db.Ado.SqlQuery<BllBoxInfo>(sql);
			var data3 = data2.GroupBy(m => m.BoxNo).Select(m => m.Key).OrderBy(m => m).ToList();
			if (data3.Count == 0)
			{
			throw new Exception($"未查询到{boxNo}-{endBoxNo}中信息");
			}

			var i = 0;
			foreach (var item in data3)
			{
			var data1 = data2.Where(m => m.BoxNo == item);
			var data = data2.FirstOrDefault(m => m.BoxNo == item);
			if (data == null)
			{
			throw new Exception($"未查询到{item}信息");
			}
			// 物料条码信息赋值
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = data.SkuNo;
			model.SkuName = data.SkuName;
			model.LotNo = data.LotNo; //批次
			model.SupplierLot = data.SupplierLot; // 原厂批号
			model.Standard = data.Standard; // 规格/型号
			model.PackageStandard = data.PackageStandard; // 包装规格

			model.ExpirationTime = data.ExpirationTime; // 有效期至
			model.StoreTime = data.StoreTime; // 储存期至

			model.Qty = data1.Sum(m => m.Qty);// 数量

			model.BoxNo = data.BoxNo; // 箱号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);
			i++;
			////添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = data.LabelStream;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);
			if (i >= 100)
			{
			break;
			}
			}

			#endregion
			}
			break;
			case "2":
			if (string.IsNullOrWhiteSpace(endBoxNo2))
			{
			#region 单个支码标签

			if (string.IsNullOrWhiteSpace(boxNo2))
			{
			throw new Exception($"起始支码不能为空");
			}
			var data = list.FirstOrDefault(m => m.BoxNo3 == boxNo2);
			if (data == null)
			{
			throw new Exception($"未查询到{boxNo2}信息");
			}
			// 物料条码信息赋值
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = data.SkuNo;
			model.SkuName = data.SkuName;
			model.LotNo = data.LotNo; //批次
			model.SupplierLot = data.SupplierLot; // 原厂批号
			model.Standard = data.Standard; // 规格/型号
			model.PackageStandard = data.PackageStandard; // 包装规格

			model.ExpirationTime = data.ExpirationTime; // 有效期至
			model.StoreTime = data.StoreTime; // 储存期至

			model.Qty = data.Qty;// 数量

			model.BoxNo = data.BoxNo3; // 支号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);

			////添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = data.BoxCode1;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);

			#endregion
			}
			else
			{
			#region 多个支码标签开始-结束

			if (string.IsNullOrWhiteSpace(boxNo2))
			{
			throw new Exception("起始支码不能为空");
			}

			var sql = $@"select * from BllBoxInfo where IsDel = '0' and Origin = 'WMS生成' and BoxNo3 >='{boxNo2}' and BoxNo3 <= '{endBoxNo2}'";
			var data2 = Db.Ado.SqlQuery<BllBoxInfo>(sql);

			if (data2.Count == 0)
			{
			throw new Exception($"未查询到{boxNo2}-{endBoxNo2}中信息");
			}

			var i = 0;
			foreach (var data in data2)
			{
			// 物料条码信息赋值
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = data.SkuNo;
			model.SkuName = data.SkuName;
			model.LotNo = data.LotNo; //批次
			model.SupplierLot = data.SupplierLot; // 原厂批号
			model.Standard = data.Standard; // 规格/型号
			model.PackageStandard = data.PackageStandard; // 包装规格

			model.ExpirationTime = data.ExpirationTime; // 有效期至
			model.StoreTime = data.StoreTime; // 储存期至

			model.Qty = data.Qty;// 数量

			model.BoxNo = data.BoxNo3; // 箱号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);
			i++;
			////添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = data.BoxCode1;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);
			if (i >= 100)
			{
			break;
			}
			}

			#endregion
			}
			break;
			case "3":
			if (string.IsNullOrWhiteSpace(endBoxNo))
			{
			if (string.IsNullOrWhiteSpace(boxNo))
			{
			throw new Exception("起始箱码不能为空");
			}
			#region 箱码和箱码内的支码

			if (!string.IsNullOrWhiteSpace(boxNo2))
			{
			if (string.IsNullOrWhiteSpace(endBoxNo2)) //单个支码和箱码
			{
			#region 单个支码和箱码

			var dataList = list.Where(m => m.BoxNo == boxNo);
			var data = list.FirstOrDefault(m => m.BoxNo3 == boxNo2);
			if (data == null)
			{
			throw new Exception($"未查询到{boxNo2}信息");
			}

			if (data.BoxNo != boxNo)//判断箱码是否相同
			{
			throw new Exception($"当前支码不是箱码内");
			}


			// 物料条码信息赋值箱码
			BoxInfoDto model1 = new BoxInfoDto();
			model1.SkuNo = data.SkuNo;
			model1.SkuName = data.SkuName;
			model1.LotNo = data.LotNo; //批次
			model1.SupplierLot = data.SupplierLot; // 原厂批号
			model1.Standard = data.Standard; // 规格/型号
			model1.PackageStandard = data.PackageStandard; // 包装规格

			model1.ExpirationTime = data.ExpirationTime; // 有效期至
			model1.StoreTime = data.StoreTime; // 储存期至
			model1.Qty = dataList.Sum(m=>m.Qty);// 数量
			model1.BoxNo = data.BoxNo; // 箱号

			model1.ImgStr = BarcodeHelper.GetCodeBarBase64(model1.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model1);

			// 物料条码信息赋值支码
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = data.SkuNo;
			model.SkuName = data.SkuName;
			model.LotNo = data.LotNo; //批次
			model.SupplierLot = data.SupplierLot; // 原厂批号
			model.Standard = data.Standard; // 规格/型号
			model.PackageStandard = data.PackageStandard; // 包装规格

			model.ExpirationTime = data.ExpirationTime; // 有效期至
			model.StoreTime = data.StoreTime; // 储存期至
			model.Qty = data.Qty;// 数量
			model.BoxNo = data.BoxNo3; // 支号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);
			////添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = data.BoxCode1;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);
			#endregion
			}
			else//一箱内某几个支码
			{
			#region 单个箱码和多个支码

			var sql = $@"select * from BllBoxInfo where IsDel = '0' and Origin = 'WMS生成' and BoxNo3 >='{boxNo2}' and BoxNo3 <= '{endBoxNo2}'";
			var data2 = Db.Ado.SqlQuery<BllBoxInfo>(sql);

			if (data2.Count == 0)
			{
			throw new Exception($"未查询到{boxNo2}-{endBoxNo2}中信息");
			}

			if (data2.Count(m => m.BoxNo != boxNo) > 0)
			{
			throw new Exception($"{boxNo2}-{endBoxNo2}中信息有不属于{boxNo}箱码内的");
			}

			var data = list.Where(m => m.BoxNo == boxNo);
			var boxData = data2.FirstOrDefault();
			// 物料条码信息赋值
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = boxData.SkuNo;
			model.SkuName = boxData.SkuName;
			model.LotNo = boxData.LotNo; //批次
			model.SupplierLot = boxData.SupplierLot; // 原厂批号
			model.Standard = boxData.Standard; // 规格/型号
			model.PackageStandard = boxData.PackageStandard; // 包装规格

			model.ExpirationTime = boxData.ExpirationTime; // 有效期至
			model.StoreTime = boxData.StoreTime; // 储存期至
			model.Qty = data.Sum(m => m.Qty); // 数量
			model.BoxNo = boxData.BoxNo; // 支号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);

			var i = 0;
			foreach (var item in data2)
			{
			// 物料条码信息赋值
			BoxInfoDto model1 = new BoxInfoDto();
			model1.SkuNo = item.SkuNo;
			model1.SkuName = item.SkuName;
			model1.LotNo = item.LotNo; //批次
			model1.SupplierLot = item.SupplierLot; // 原厂批号
			model1.Standard = item.Standard; // 规格/型号
			model1.PackageStandard = item.PackageStandard; // 包装规格

			model1.ExpirationTime = item.ExpirationTime; // 有效期至
			model1.StoreTime = item.StoreTime; // 储存期至
			model1.Qty = item.Qty;// 数量
			model1.BoxNo = item.BoxNo3; // 支号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model1.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);
			i++;
			////添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = item.BoxCode1;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);
			if (i >= 100)
			{
			break;
			}
			}

			#endregion
			}
			}
			else //整箱支码和一个箱码
			{
			#region 整箱支码和一个箱码

			var data = list.Where(m => m.BoxNo == boxNo).ToList();
			var boxData = data.FirstOrDefault();
			if (boxData == null)
			{
			throw new Exception($"未查询到{boxNo}箱码信息");
			}
			// 物料条码信息赋值
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = boxData.SkuNo;
			model.SkuName = boxData.SkuName;
			model.LotNo = boxData.LotNo; //批次
			model.SupplierLot = boxData.SupplierLot; // 原厂批号
			model.Standard = boxData.Standard; // 规格/型号
			model.PackageStandard = boxData.PackageStandard; // 包装规格

			model.ExpirationTime = boxData.ExpirationTime; // 有效期至
			model.StoreTime = boxData.StoreTime; // 储存期至
			model.Qty = data.Sum(m => m.Qty); // 数量
			model.BoxNo = boxData.BoxNo; // 支号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);

			if (data.Count(m => !string.IsNullOrWhiteSpace(m.BoxNo3)) > 0) //判断是否有支码
			{
			var i = 0;
			foreach (var item in data)
			{
			// 物料条码信息赋值
			BoxInfoDto model1 = new BoxInfoDto();
			model1.SkuNo = item.SkuNo;
			model1.SkuName = item.SkuName;
			model1.LotNo = item.LotNo; //批次
			model1.SupplierLot = item.SupplierLot; // 原厂批号
			model1.Standard = item.Standard; // 规格/型号
			model1.PackageStandard = item.PackageStandard; // 包装规格

			model1.ExpirationTime = item.ExpirationTime; // 有效期至
			model1.StoreTime = item.StoreTime; // 储存期至
			model1.Qty = item.Qty; // 数量
			model1.BoxNo = item.BoxNo3; // 支号

			model1.ImgStr = BarcodeHelper.GetCodeBarBase64(model1.BoxNo, 160, 40, false);


			// 添加到list集合
			printModelList.Add(model1);
			i++;
			////添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = item.BoxCode1;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);
			if (i >= 100)
			{
			break;
			}
			}
			}
			else
			{
			throw new Exception("当前箱内没有支码");
			}
			#endregion
			}
			#endregion
			}
			else
			{
			if (string.IsNullOrWhiteSpace(boxNo))
			{
			throw new Exception("起始箱码不能为空");
			}

			#region 多个箱码和内支码

			var sql = $@"select * from BllBoxInfo where IsDel = '0' and Origin = 'WMS生成' and BoxNo >='{boxNo}' and BoxNo <= '{endBoxNo}'";
			var data2 = Db.Ado.SqlQuery<BllBoxInfo>(sql);
			var data3 = data2.GroupBy(m => m.BoxNo).Select(m => m.Key).OrderBy(m => m).ToList();
			if (data3.Count == 0)
			{
			throw new Exception($"未查询到{boxNo}-{endBoxNo}中信息");
			}
			var i = 0;
			var j = 0;
			foreach (var demo in data3)
			{
			var data = list.Where(m => m.BoxNo == demo).ToList();
			var boxData = data.FirstOrDefault();
			if (boxData == null)
			{
			throw new Exception($"未查询到{demo}箱码信息");
			}
			// 物料条码信息赋值
			BoxInfoDto model = new BoxInfoDto();
			model.SkuNo = boxData.SkuNo;
			model.SkuName = boxData.SkuName;
			model.LotNo = boxData.LotNo; //批次
			model.SupplierLot = boxData.SupplierLot; // 原厂批号
			model.Standard = boxData.Standard; // 规格/型号
			model.PackageStandard = boxData.PackageStandard; // 包装规格

			model.ExpirationTime = boxData.ExpirationTime; // 有效期至
			model.StoreTime = boxData.StoreTime; // 储存期至
			model.Qty = data.Sum(m => m.Qty); // 数量
			model.BoxNo = boxData.BoxNo; // 支号

			model.ImgStr = BarcodeHelper.GetCodeBarBase64(model.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model);

			j++;
			if (j >= 100)
			{
			break;
			}
			if (data.Count(m => !string.IsNullOrWhiteSpace(m.BoxNo3)) > 0) //判断是否有支码
			{
			foreach (var item in data.OrderBy(m => m.BoxNo3).ToList())
			{
			// 物料条码信息赋值
			BoxInfoDto model1 = new BoxInfoDto();
			model1.SkuNo = item.SkuNo;
			model1.SkuName = item.SkuName;
			model1.LotNo = item.LotNo; //批次
			model1.SupplierLot = item.SupplierLot; // 原厂批号
			model1.Standard = item.Standard; // 规格/型号
			model1.PackageStandard = item.PackageStandard; // 包装规格

			model1.ExpirationTime = item.ExpirationTime; // 有效期至
			model1.StoreTime = item.StoreTime; // 储存期至
			model1.Qty = item.Qty;// 数量
			model1.BoxNo = item.BoxNo3; // 支号

			model1.ImgStr = BarcodeHelper.GetCodeBarBase64(model1.BoxNo, 160, 40, false);

			// 添加到list集合
			printModelList.Add(model1);
			i++;
			////添加打印记录
			//WmsLabelPrintLog log = new WmsLabelPrintLog();
			//log.BoxCode = item.BoxCode1;
			//log.CreateTime = DateTime.Now;
			//log.Demo = Demo;
			//log.Isdel = 0;
			//log.CreateUser = userId;
			//printlog.Add(log);
			if (i >= 100)
			{
			break;
			}
			}
			}

			}

			#endregion
			}
			break;
			default:
			throw new Exception("请选择补打类型");
			}

			#endregion

			return printModelList;
			}
			catch (Exception e)
			{
			@@ -967,6 +1593,138 @@
			}
			}

			//根据入库单号过去单据下所有批次号
			public List<string> GetLotNoListByAsn(string asnNo)
			{
			try
			{
			var data = new List<string>();
			var asnList = Db.Queryable<BllArrivalNoticeDetail>().Where(m => m.IsDel == "0" && m.ASNNo == asnNo).ToList();
			if (asnList.Count == 0)
			{
			throw new Exception("未查询到该单据号的信息");
			}

			foreach (var item in asnList)
			{
			if (string.IsNullOrWhiteSpace(item.LotNo))
			{
			continue;
			}

			var strList = item.LotNo.Split(";");
			foreach (var str in strList)
			{
			if (string.IsNullOrWhiteSpace(str))
			{
			continue;
			}
			data.Add(str);
			}
			}

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

			//删除单据下单个或多个批次的标签
			public void DelLabelByAsnNo(string asnNo,string lotNo, int userId)
			{
			try
			{
			var asnList = Db.Queryable<BllArrivalNoticeDetail>().Where(m => m.IsDel == "0" && m.ASNNo == asnNo).ToList();
			if (asnList.Count == 0)
			{
			throw new Exception("未查询到该单据号的信息");
			}

			Db.BeginTran();

			//批次为空：当前单据下所有批次的标签全部删除；有批次：伤处当前单据下当前批次的标签
			if (string.IsNullOrWhiteSpace(lotNo)) //删除全部标签
			{
			var labelList = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.ASNNo == asnNo).ToList();
			if (labelList.Count(m => m.Status != "0") >= 1)
			{
			throw new Exception("当前单据批次的标签已有已使用，不能删除");
			}

			foreach (var item in asnList)
			{
			if (string.IsNullOrWhiteSpace(item.LotNo))
			{
			continue;
			}

			item.LotNo = "";
			Db.Updateable(item).ExecuteCommand();

			}
			Db.Deleteable(labelList).ExecuteCommand();
			}
			else //删除固定批次标签
			{
			var labelList = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.ASNNo == asnNo && m.LotNo == lotNo).ToList();
			if (labelList.Count(m=>m.Status != "0") >= 1 )
			{
			throw new Exception("当前单据批次的标签已有已使用，不能删除");
			}

			foreach (var item in asnList)
			{
			if (string.IsNullOrWhiteSpace(item.LotNo) \|\| item.LotNo!=lotNo)
			{
			continue;
			}

			var strList = item.LotNo.Split(";");
			var updateLotNo = "";
			foreach (var str in strList)
			{
			if (string.IsNullOrWhiteSpace(str) \|\| str == lotNo)
			{
			continue;
			}

			if (string.IsNullOrWhiteSpace(updateLotNo))
			{
			updateLotNo = str;
			}
			else
			{
			updateLotNo += ";" + str;
			}

			}

			item.LotNo = updateLotNo;
			Db.Updateable(item).ExecuteCommand();

			}
			Db.Deleteable(labelList).ExecuteCommand();
			}

			Db.CommitTran();

			var msg = $"删除了单据号：{asnNo}";
			if (!string.IsNullOrWhiteSpace(lotNo))
			{
			msg += $"、批次号：{lotNo}";
			}
			msg += "的标签信息";

			new OperationASNServer().AddLogOperationAsn("入库作业", "物料标签", asnNo, "删除", msg, userId);
			}
			catch (Exception e)
			{
			Db.RollbackTran();
			throw new Exception(e.Message);
			}
			}

			}
			}