JC24WMS.git - Gitblit

			@@ -114,8 +114,19 @@
			{
			try
			{
			Expression<Func<BllBoxInfo, bool>> item1 = Expressionable.Create<BllBoxInfo>()
			.AndIF(!string.IsNullOrWhiteSpace(model.ASNNo), it => it.ASNNo.Contains(model.ASNNo.Trim()))
			.AndIF(!string.IsNullOrWhiteSpace(model.PalletNo), it => it.PalletNo.Contains(model.PalletNo.Trim()))
			.AndIF(!string.IsNullOrWhiteSpace(model.LotNo), it => it.LotNo.Contains(model.LotNo.Trim()))
			.AndIF(!string.IsNullOrWhiteSpace(model.SkuNo), it => it.SkuNo.Contains(model.SkuNo.Trim()))
			.AndIF(!string.IsNullOrWhiteSpace(model.SkuName), it => it.SkuName.Contains(model.SkuName.Trim()))
			.AndIF((model.BindNo != 0 && !string.IsNullOrWhiteSpace(model.BindNo.ToString())), it => it.BindNo == model.BindNo)
			.And(m => m.IsDel == "0")
			.ToExpression();

			var total = 0;
			var data = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BindNo == model.BindNo)
			DbHelper<BllBoxInfo> helper = new DbHelper<BllBoxInfo>(Db);
			var data = helper.GetAllWhereAsync(item1).Where(m => m.IsDel == "0")
			.LeftJoin<BllPalletBind>((a, b) => a.BindNo == b.Id)
			.GroupBy((a, b) => new
			{
			@@ -380,7 +391,8 @@
			Db.Updateable(boxInfos).ExecuteCommand();

			//修改托盘绑定信息
			bind.Qty -= qty;
			bind.Qty -= qty; // 数量变更
			bind.BitPalletMark = "1"; // 零托标记变更

			if (bind.Qty == 0)
			{
			@@ -524,7 +536,7 @@
			{
			OrderNo = notice.ASNNo,
			PalletNo = bind.PalletNo,
			Msg = info == null ? $"物料：{noticeDetail.SkuNo}、批次：{noticeDetail.LotNo};": $"物料：{info.SkuNo}、批次：{info.LotNo};",
			Msg = info == null ? $"物料：{noticeDetail.SkuNo}、批次：{noticeDetail.LotNo};" : $"物料：{info.SkuNo}、批次：{info.LotNo};",
			Reason = reason,
			Status = "0",
			Opinion = "",
			@@ -551,10 +563,24 @@

			#region 指定储位
			//指定储位数据源（正常的空储位）
			public List<LocatDto> GetLocateList(string houseNo, string roadwayNo, string row, string column, string layer, string locateNo, int page, int limit, out int count)
			public List<LocatDto> GetLocateList(string houseNo, string roadwayNo, string row, string column, string layer,
			string locateNo, string BindId, int page, int limit, out int count)
			{
			try
			{
			//获取托盘绑定
			var bindASNDetailNo = Db.Queryable<BllPalletBind>().Where(a => a.IsDel == "0" && a.Status == "0"
			&& a.Id == int.Parse(BindId)).Select(a => a.ASNDetailNo).First();
			//获取单据明细
			var noticeDetailSkuNo = Db.Queryable<BllArrivalNoticeDetail>().Where(a => a.Id == bindASNDetailNo
			&& a.IsDel == "0").Select(a => a.SkuNo).First();
			//获取物料
			var skuCategoryNo = Db.Queryable<SysMaterials>().Where(a => a.IsDel == "0" && a.SkuNo == noticeDetailSkuNo)
			.Select(a => a.CategoryNo).First();
			//获取物料对应区域
			var categoryAreaNo = Db.Queryable<SysMaterialCategory>().Where(a => a.IsDel == "0" && a.CategoryNo == skuCategoryNo)
			.Select(a => a.AreaNo).First();

			Expression<Func<SysStorageLocat, bool>> item = Expressionable.Create<SysStorageLocat>()
			.AndIF(!string.IsNullOrWhiteSpace(roadwayNo), m => m.RoadwayNo == roadwayNo)
			.AndIF(!string.IsNullOrWhiteSpace(row), m => m.Row == int.Parse(row))
			@@ -562,9 +588,10 @@
			.AndIF(!string.IsNullOrWhiteSpace(layer), m => m.Layer == int.Parse(layer))
			.AndIF(!string.IsNullOrWhiteSpace(locateNo), m => m.LocatNo.Contains(locateNo))
			.And(m => m.IsDel == "0" && m.Status == "0" && m.Flag == "0" && m.WareHouseNo == houseNo)
			.And(m => m.AreaNo.Contains(categoryAreaNo))
			.ToExpression();//注意这一句不能少
			var total = 0;
			var list = Db.Queryable<SysStorageLocat>().Where(item)
			var list = Db.Queryable<SysStorageLocat>().Where(item).OrderByDescending(a => a.Depth).OrderBy(a => a.Column)
			.Select(a => new LocatDto()
			{
			Id = a.Id,
			@@ -573,6 +600,7 @@
			Row = a.Row,
			Column = a.Column,
			Layer = a.Layer,
			Depth = a.Depth,
			Status = a.Status
			}).ToOffsetPage(page, limit, ref total);
			count = total;
			@@ -611,6 +639,59 @@
			{
			throw new Exception("该储位状态不是空储位或标志不是正常的");
			}



			//判断当前托盘是否存在绑定信息
			if (!string.IsNullOrWhiteSpace(bind.LocatNo))
			{
			//分割已绑储位与新储位
			//已绑储位
			var bindRow = bind.LocatNo.Substring(0, 2);
			var bindColumn = bind.LocatNo.Substring(2, 2);
			var bindLayer = bind.LocatNo.Substring(4, 2);
			var bindDepth = bind.LocatNo.Substring(6, 2);
			//新储位
			var Row = locate.LocatNo.Substring(0, 2);
			var Column = locate.LocatNo.Substring(2, 2);
			var Layer = locate.LocatNo.Substring(4, 2);
			var Depth = locate.LocatNo.Substring(6, 2);

			if (bindDepth == "02")
			{
			//判断排列层是否相同
			if (bindRow == Row && bindColumn == Column && bindLayer == Layer)
			{
			throw new Exception("同储位深度2不可向深度1切换！");
			}
			}
			}
			else
			{
			//若是深度1的则判断深度2是否为空储位
			if (locate.Depth == "01")
			{
			var locateDepth = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.Row == locate.Row && a.Column == locate.Column && a.Layer == locate.Layer && a.Depth == "02");
			if (locateDepth != null)
			{
			if (locateDepth.Status != "1")
			{
			throw new Exception("该储位深度2不是有物品，不可绑定");
			}
			}
			}
			//判断是否为深度2的若为深度2 则获取深度1储位判断是否为空储位
			if (locate.Depth == "02")
			{
			var locateDepth = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.Row == locate.Row && a.Column == locate.Column && a.Layer == locate.Layer && a.Depth == "01");
			if (locateDepth.Status != "0" \|\| locateDepth.Flag == "2")
			{
			throw new Exception("该储位深度1不是空储位或标志不是正常的");
			}
			}
			}


			var bindIdList = Db.Queryable<BllPalletBind>().Where(m => m.IsDel == "0" && m.PalletNo == bind.PalletNo && m.Status != "2").Select(m => m.Id).ToList();
			//判断是否有零箱
			foreach (var item in bindIdList)
			@@ -680,6 +761,7 @@
			{
			try
			{
			#region 验证托盘合法性
			//验证托盘条码是否为空
			if (string.IsNullOrEmpty(palletNo))
			{
			@@ -696,17 +778,17 @@
			throw new Exception("平库请使用PDA手持进行平库入库");
			}

			OutCommandDto comDto;//返回wcs的入库命令
			var isHaveLocateNo = false; //托盘绑定信息中是否已有指定储位

			var stock = Db.Queryable<SysPallets>().First(a => a.PalletNo == palletNo);//托盘信息

			//判断托盘条码是否有效
			if (stock == null)
			{
			throw new Exception("托盘条码不受WMS管理，不可入库！");
			}
			#endregion


			OutCommandDto comDto;//返回wcs的入库命令
			var isHaveLocateNo = false; // 是否已有指定储位
			#region

			//查询托盘绑定信息(状态为等待入库的)
			@@ -748,6 +830,8 @@
			isHaveLocateNo = true; //已有指定储位
			}


			// 验证是否关联单据，获取托盘上存放的物料
			if (palletBindList.First().Type == "0") //物料托入库
			{
			//判断是否绑定单据及单据状态是否正常
			@@ -758,7 +842,7 @@
			{
			throw new Exception("托盘存在物料未绑定入库单，不可入库！");
			}
			if (notice.Status == "3")
			if (notice.Status == "3" \|\| notice.Status == "4")
			{
			throw new Exception($"入库单{item.ASNNo}已关闭，不可入库！");
			}
			@@ -790,29 +874,23 @@
			skuNo = stockDetail.First().SkuNo;

			//获取对应回库规则
			var function = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetName == "托盘回库验证" && a.IsEnable == "NO");
			var function = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetNo == "Fun041" && a.IsEnable == "NO");
			#region 托盘回库规则

			if (function != null)
			{
			//拣货完成后允许托盘回库
			if (function.SetValue == "CompletePick")
			{
			var allot = Db.Queryable<BllExportAllot>().First(a => a.IsDel == "0" && a.LotNo == stockDetail[0].LotNo && a.PalletNo == palletNo && a.SkuNo == stockDetail[0].SkuNo);
			var allot = Db.Queryable<BllExportAllot>().First(a => a.IsDel == "0" && a.LotNo == stockDetail[0].LotNo && a.PalletNo == palletNo && a.SkuNo == stockDetail[0].SkuNo);

			//验证拣货明细是否存在
			if (allot != null)
			//验证拣货明细是否存在
			if (allot != null)
			{
			//验证当前托盘拣货信息是否已完成
			if (allot.Status != "5")
			{
			//验证当前托盘拣货信息是否已完成
			if (allot.Status != "5")
			{
			throw new Exception("当前托盘拣货信息未完成，请完成后回库！");
			}
			throw new Exception("当前托盘拣货信息未完成，请完成后回库！");
			}
			}
			}


			#endregion
			}

			@@ -820,6 +898,7 @@

			SysStorageLocat locate;

			#region 根据sku确认区域划分
			var sku = skuList.FirstOrDefault(m => m.SkuNo == skuNo);
			if (sku == null)
			{
			@@ -862,22 +941,49 @@
			}
			}
			var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo))
			.GroupBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList();
			.GroupBy(m => m.RoadwayNo).OrderBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList();

			SysRoadwayUseLog useLog = Db.Ado.SqlQuerySingle<SysRoadwayUseLog>("select Top(1) * from SysRoadwayUseLog where IsDel=0 order by CreateTime desc"); //巷道最后一次使用记录
			SysRoadwayUseLog useLog = Db.Queryable<SysRoadwayUseLog>().Where(m => m.IsDel == "0" && roadList.Contains(m.RoadwayNo)).OrderByDescending(l => l.Id).First(); //巷道最后一次使用记录
			#endregion

			var bindNum = Db.Queryable<BllPalletBind>()
			.Where(m => m.IsDel == "0" && m.Status == "0" && !string.IsNullOrWhiteSpace(m.RoadwayNo))
			.GroupBy(m => m.PalletNo).Select(m => m.PalletNo).Count();

			#region 确定巷道排序
			List<string> roadList2 = new List<string>();
			List<string> roadSmall = new List<string>();
			List<string> roadLarge = new List<string>();
			if (useLog != null)
			{
			roadList2.Add(useLog.RoadwayNo);
			foreach (var r in roadList)
			{
			if (r == useLog.RoadwayNo)
			{
			continue;
			}
			//如果结果为0，则说明两个字符串相等；
			//如果结果小于0，则说明第一个字符串小于第二个字符串；
			//如果结果大于0，则说明第一个字符串大于第二个字符串。
			var bol = String.CompareOrdinal(r, useLog.RoadwayNo);
			if (bol < 0)
			{
			roadSmall.Add(r);
			}
			if (bol > 0)
			{
			roadLarge.Add(r);
			}
			}
			roadList2.AddRange(roadLarge);
			roadList2.AddRange(roadSmall);
			}

			roadList = roadList2;
			#endregion


			var roadNo = "";
			if (laneAllot == 0)//跳巷道平均分配
			{
			//如果同级巷道有多条则查上次位置日志
			if (roadList.Count > 1)
			{
			useLog = Db.Queryable<SysRoadwayUseLog>().OrderByDescending(l => l.Id).First();
			}
			//取各巷道所有排第一个合适位
			foreach (var l in roadList)
			{
			@@ -888,7 +994,11 @@
			}

			var locateCount = Db.Queryable<SysStorageLocat>()
			.Where(m => m.Status == "0" && m.Flag == "0" && areaList.Contains(m.AreaNo)).Count();
			.Where(m => m.Status == "0" && m.Flag == "0" && areaList.Contains(m.AreaNo) && m.RoadwayNo == l).Count();

			var bindNum = Db.Queryable<BllPalletBind>()
			.Where(m => m.IsDel == "0" && m.Status == "0" && m.RoadwayNo == l)
			.GroupBy(m => m.PalletNo).Select(m => m.PalletNo).Count();
			if (locateCount - bindNum > 0)
			{
			roadNo = l;
			@@ -905,7 +1015,16 @@
			{
			if (useLog != null)
			{
			roadNo = useLog.RoadwayNo;
			var locateCount = Db.Queryable<SysStorageLocat>()
			.Where(m => m.Status == "0" && m.Flag == "0" && areaList.Contains(m.AreaNo) && m.RoadwayNo == useLog.RoadwayNo).Count();

			var bindNum = Db.Queryable<BllPalletBind>()
			.Where(m => m.IsDel == "0" && m.Status == "0" && m.RoadwayNo == useLog.RoadwayNo)
			.GroupBy(m => m.PalletNo).Select(m => m.PalletNo).Count();
			if (locateCount - bindNum > 0)
			{
			roadNo = useLog.RoadwayNo;
			}
			}
			}
			}
			@@ -913,7 +1032,18 @@
			{
			foreach (var item in roadList)
			{
			roadNo = item;
			var locateCount = Db.Queryable<SysStorageLocat>()
			.Where(m => m.Status == "0" && m.Flag == "0" && areaList.Contains(m.AreaNo) && m.RoadwayNo == item).Count();

			var bindNum = Db.Queryable<BllPalletBind>()
			.Where(m => m.IsDel == "0" && m.Status == "0" && m.RoadwayNo == item)
			.GroupBy(m => m.PalletNo).Select(m => m.PalletNo).Count();

			if (locateCount - bindNum > 0)
			{
			roadNo = item;
			}
			//当前巷有位置则退出
			if (roadNo != null)
			{
			break;
			@@ -929,19 +1059,43 @@
			Db.BeginTran();
			try
			{
			if (roadNo != null)
			//添加巷道使用记录
			var log = new SysRoadwayUseLog
			{
			//添加巷道使用记录
			var log = new SysRoadwayUseLog
			{
			RoadwayNo = roadNo,
			WareHouseNo = houseNo,
			Row = 0,
			Column = 0,
			Layer = 0,
			};
			Db.Insertable(log).ExecuteCommand();
			}
			RoadwayNo = roadNo,
			WareHouseNo = houseNo,
			Row = 0,
			Column = 0,
			Layer = 0,
			};
			Db.Insertable(log).ExecuteCommand();

			// 添加入库日志记录
			var taskNo = new Common().GetMaxNo("TK");
			var exTask = new LogTask //入库任务
			{
			TaskNo = taskNo,
			Sender = "WMS",
			Receiver = "WCS",
			IsSuccess = 1, //是否下发成功 0失败 1成功
			SendDate = DateTime.Now, //发送时间
			BackDate = DateTime.Now, //返回时间
			StartRoadway = "", // 起始巷道
			StartLocat = "",//起始位置
			EndLocat = "",//目标位置
			EndRoadway = roadNo, // 目标巷道
			PalletNo = palletNo,//托盘码
			IsSend = 1,//是否可再次下发
			IsCancel = 1,//是否可取消
			IsFinish = 1,//是否可完成
			Type = "0",//任务类型 0 入库任务 1 出库任务 2 移库任务
			Status = "1",//任务状态0：等待执行1正在执行2执行完成
			OrderType = "0",//0 入库单 1 出库单 2 盘点单 3 移库单
			Msg = "入库口到=>>" + roadNo + "巷道的入库任务", //关键信息

			};
			Db.Insertable(exTask).ExecuteCommand();


			if (palletBindList.Count >= 1)
			{
			@@ -954,6 +1108,7 @@
			Db.Updateable(palletBindList).ExecuteCommand();
			}
			Db.CommitTran();

			comDto = new OutCommandDto()
			{
			PalletNo = palletNo,//托盘号
			@@ -961,12 +1116,11 @@
			StartLocate = "", // 起始位置
			EndLocate = "", // 目标位置
			EndRoadway = roadNo, // 目标巷道
			TaskNo = "", // 任务号
			TaskType = "0",// 任务类型 (出库)
			TaskNo = taskNo, // 任务号
			TaskType = "0",// 任务类型:入库任务
			OutMode = "", //目标地址
			Order = 1
			};

			}
			catch (Exception ex)
			{
			@@ -975,7 +1129,7 @@
			}
			#endregion

			return null;
			return comDto;
			}
			catch (Exception e)
			{
			@@ -1105,17 +1259,23 @@
			throw new Exception($"{palletNo}托盘条码不具有箱码信息，不可入库！");
			}
			skuNo = stockDetail.First().SkuNo;
			//else
			//{
			// //判断是否有零箱
			// var detailIdList = stockDetail.Select(m => m.Id).ToList();
			// var dataBoxInfo = Db.Queryable<DataBoxInfo>().Where(m => detailIdList.Contains(m.StockDetailId)).ToList();
			// if (dataBoxInfo.Count(m => m.BitBoxMark == "1")>0)
			// {
			// throw new Exception($"{palletNo}托盘上有零箱，不可入库！");
			// }
			if (!string.IsNullOrWhiteSpace(stockDetail.First().WareHouseNo))
			{
			if (stockDetail.First().WareHouseNo == "W01")//立库
			{
			throw new Exception($"{palletNo}托盘上在立库中有库存储位信息，请核实！");
			}

			//}
			if (stockDetail.First().WareHouseNo == "W02")//平库
			{
			var locatePingKu = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == stockDetail.First().LocatNo);
			if (locatePingKu != null)
			{
			locatePingKu.Status = "0";
			Db.Updateable(locatePingKu).ExecuteCommand();
			}
			}
			}


			//获取对应回库规则
			@@ -1455,6 +1615,13 @@
			{
			throw new Exception("未查询到托盘绑定的入库单明细信息");
			}
			var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == noticeDetail.ASNNo);
			if (notice == null)
			{
			throw new Exception("未查询到托盘绑定的入库单信息");
			}
			string ownerNo = notice.CustomerNo;//货主编码
			string ownerName = notice.CustomerName;//货主名称

			var sku1 = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == noticeDetail.SkuNo);
			string isinspect = "0";
			@@ -1465,7 +1632,17 @@
			}

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

			#region 库存明细
			var sd = new DataStockDetail()
			{
			@@ -1499,29 +1676,41 @@
			PackagNo = noticeDetail.PackagNo,
			IsBale = item.IsBale,
			IsBelt = item.IsBelt,
			Demo = item.Demo,

			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:寄存入库
			{
			sd.OwnerNo = notice.CustomerNo;//货主编码
			sd.OwnerName = notice.CustomerName;//货主名称
			}
			else if (notice.Type == "1" \|\| notice.Type == "5")//1:采购入库,2:其它入库
			{
			sd.SupplierNo = notice.CustomerNo;//供应商编码
			sd.SupplierName = notice.CustomerName;//供应商名称
			}

			//if (quality.Count() > 0)
			//{
			// //修改合格不合格数量
			// if (quality[0].IsQualified == "1") //合格
			// {
			// //增加合格数量
			// quality[0].PassQty += item.Qty;
			// sd.InspectStatus = "1";
			// }
			// else if (quality[0].IsQualified == "0") //不合格
			// {
			// //增加不合格数量
			// quality[0].FailQty += item.Qty;
			// sd.InspectStatus = "2";
			// }
			// Db.Updateable(quality[0]).ExecuteCommand(); //修改质检信息
			//}
			if (quality != null)
			{
			//修改合格不合格数量
			if (quality.IsQualified == "1") //合格
			{
			//增加合格数量
			quality.PassQty += item.Qty;
			sd.InspectStatus = "1";
			}
			else if (quality.IsQualified == "0") //不合格
			{
			//增加不合格数量
			quality.FailQty += item.Qty;
			sd.InspectStatus = "2";
			}
			Db.Updateable(quality).ExecuteCommand(); //修改质检信息
			}

			var sdId = Db.Insertable(sd).ExecuteReturnIdentity(); //新增库存明细信息

			@@ -1592,6 +1781,12 @@
			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
			@@ -1610,7 +1805,6 @@
			.Count(m => m.IsDel == "0" && m.ASNNo == noticeDetail.ASNNo && m.Status != "2");
			if (asnDetailNum == 0)
			{
			var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == noticeDetail.ASNNo);
			notice.Status = "2";
			notice.CompleteTime = comTime;
			Db.Updateable(notice).ExecuteCommand();