JC34WMS.git - Gitblit

			@@ -1806,249 +1806,6 @@
			}

			/// <summary>
			/// 下发入库申请储位任务（下发==》AGV小车）
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public void IssueAsnTask(OutCommandDto model,string url)
			{
			try
			{

			// 将任务发送至AGV 正式运行程序放开
			var jsonData = JsonConvert.SerializeObject(model);
			string response = "";

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

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

			//}
			//if (wcsModel.StatusCode == -1)
			//{
			// new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.Msg);
			// throw new Exception(wcsModel.Msg);
			//}
			}
			catch (Exception ex)
			{
			throw new Exception(ex.Message);
			}
			}
			catch (Exception)
			{
			throw;
			}
			}

			#endregion

			#region 指定储位
			//指定储位数据源（正常的空储位）
			public List<LocatDto> GetLocateList(string houseNo, string roadwayNo, string row, string column, string layer,
			string locateNo, string stockDetailId, int page, int limit, out int count)
			{
			try
			{
			//获取库存明细
			var DetailSkuNo = Db.Queryable<DataStockDetail>().Where(a => a.Id == int.Parse(stockDetailId)
			&& a.IsDel == "0").Select(a => a.SkuNo).First();
			//获取物料
			var skuCategoryNo = Db.Queryable<SysMaterials>().Where(a => a.IsDel == "0" && a.SkuNo == DetailSkuNo)
			.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))
			.AndIF(!string.IsNullOrWhiteSpace(column), m => m.Column == int.Parse(column))
			.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 => categoryAreaNo.Contains(m.AreaNo))
			.ToExpression();//注意这一句不能少
			var total = 0;
			var list = Db.Queryable<SysStorageLocat>().Where(item).OrderByDescending(a => a.Depth).OrderBy(a => a.Column)
			.Select(a => new LocatDto()
			{
			Id = a.Id,
			RoadwayNo = a.RoadwayNo,
			LocatNo = a.LocatNo,
			Row = a.Row,
			Column = a.Column,
			Layer = a.Layer,
			Depth = a.Depth,
			Status = a.Status
			}).ToOffsetPage(page, limit, ref total);
			count = total;

			return list;

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

			//保存指定的储位
			public void SaveAppointSlot(int bindId, int locateId, int userId)
			{
			try
			{
			//托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.Id == bindId);
			if (bind == null)
			{
			throw new Exception("未查询到托盘绑定的信息");
			}
			if (bind.Status != "0")
			{
			throw new Exception("该托盘绑定的信息状态不是等待执行，不能指定储位，请核实！");
			}
			//储位
			var locate = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.Id == locateId);
			if (locate == null)
			{
			throw new Exception("未查询到储位的信息");
			}
			if (locate.Status != "0" \|\| locate.Flag != "0")
			{
			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)
			{
			var boxInfo = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BindNo == item);
			if (boxInfo.Count(m => m.BitBoxMark == "1") > 0)
			{
			throw new Exception($"{bind.PalletNo}托盘上有零箱，请入零箱库！");
			}
			}
			Db.BeginTran();
			try
			{
			var time = DateTime.Now;
			//判断托盘绑定信息是否已有指定储位
			if (!string.IsNullOrWhiteSpace(bind.LocatNo))
			{
			var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.LocatNo == bind.LocatNo);
			locate2.Status = "0";
			Db.Updateable(locate2).ExecuteCommand();
			}
			//获取同托盘的托盘绑定信息
			var bindList = Db.Queryable<BllPalletBind>()
			.Where(m => m.IsDel == "0" && m.PalletNo == bind.PalletNo && m.Status == "0").ToList();
			if (bindList.Count > 0)
			{
			foreach (var b in bindList)
			{
			b.LocatNo = locate.LocatNo;
			b.WareHouseNo = locate.WareHouseNo;
			b.RoadwayNo = locate.RoadwayNo;
			b.UpdateTime = time;
			b.UpdateUser = userId;
			}

			Db.Updateable(bindList).ExecuteCommand();
			}
			//修改指定的储位
			bind.LocatNo = locate.LocatNo;
			bind.WareHouseNo = locate.WareHouseNo;
			bind.RoadwayNo = locate.RoadwayNo;
			bind.UpdateTime = time;
			bind.UpdateUser = userId;
			locate.Status = "2";
			Db.Updateable(bind).ExecuteCommand();
			Db.Updateable(locate).ExecuteCommand();

			new OperationASNServer().AddLogOperationAsn("入库作业", "托盘绑定", bind.PalletNo, "编辑", $"指定了储位：{locate.LocatNo}、单据号：{bind.ASNNo}、托盘码：{bind.PalletNo}的信息", userId);
			Db.CommitTran();
			}
			catch (Exception e)
			{
			Db.RollbackTran();
			throw new Exception(e.Message);
			}

			}
			catch (Exception e)
			{
			throw new Exception(e.Message);
			}
			}
			#endregion


			#region 申请储位、巷道任务完成、取消


			/// <summary>
			/// 申请巷道(密集库)
			/// </summary>
			/// <param name="palletNo"></param>
			@@ -2398,6 +2155,651 @@
			throw new Exception(e.Message);
			}
			}

			/// <summary>
			/// 1 申请储位 2 申请巷道后再申请储位储位
			/// </summary>
			/// <param name="palletNo"></param>
			/// <param name="houseNo"></param>
			/// <param name="roadwayNo"></param>
			/// <returns></returns>
			/// <exception cref="Exception"></exception>
			public OutCommandDto RequestMiJiLocation(string palletNo, string houseNo, string roadwayNo)
			{
			try
			{
			//验证托盘条码是否为空
			if (string.IsNullOrEmpty(palletNo))
			{
			throw new Exception("请输入要申请的托盘条码");
			}
			//验证所属仓库是否为空
			if (string.IsNullOrEmpty(houseNo))
			{
			throw new Exception("请选择所属仓库");
			}
			//验证是否为平库入库
			if (houseNo == "W02")
			{
			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管理，不可入库！");

			#region

			//查询托盘绑定信息(状态为等待入库的)
			var palletBindList = Db.Queryable<BllPalletBind>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo && (m.Status == "0" \|\| m.Status == "1")).ToList();
			var haveLocate = palletBindList.FirstOrDefault(m => !string.IsNullOrWhiteSpace(m.LocatNo));

			var skuList = Db.Queryable<SysMaterials>().Where(m => m.IsDel == "0").ToList();
			//物料类别信息
			var skuCategoryList = Db.Queryable<SysMaterialCategory>().Where(m => m.IsDel == "0").ToList();

			var skuNo = ""; //入库物料
			var isAddTask = true; //是否添加新任务
			var oldTaskNo = ""; //旧任务号
			var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.PalletNo == palletNo).ToList();
			if (palletBindList.Count >= 1) //正常入库
			{
			var palletBind = palletBindList.FirstOrDefault(m => m.Status == "1");
			if (palletBind != null)
			{
			var beingTask = Db.Queryable<LogTask>().First(m => m.IsDel == "0" && m.TaskNo == palletBind.TaskNo);
			if (beingTask == null)
			{
			throw new Exception("该托盘正在入库，但未查询到任务信息");
			}
			if (!string.IsNullOrWhiteSpace(beingTask.EndLocat))
			{
			comDto = new OutCommandDto()
			{
			PalletNo = palletNo,//托盘号
			StartRoadway = beingTask.StartRoadway, // 起始巷道
			StartLocate = "", // 起始位置
			EndLocate = beingTask.EndLocat, // 目标位置
			EndRoadway = beingTask.EndRoadway, // 目标巷道
			TaskNo = beingTask.TaskNo, // 任务号
			TaskType = "0",// 任务类型 (出库)
			OutMode = "", //目标地址
			Order = 1
			};
			if (beingTask.IsSuccess == 0)
			{
			beingTask.IsSuccess = 1;
			Db.Updateable(beingTask).ExecuteCommand();
			}
			return comDto;
			}
			else
			{
			if (string.IsNullOrWhiteSpace(roadwayNo))
			{
			roadwayNo = beingTask.EndRoadway;
			}
			isAddTask = false;
			oldTaskNo = beingTask.TaskNo;
			}
			}
			if (haveLocate != null)
			{
			isHaveLocateNo = true; //已有指定储位
			}

			if (palletBindList.First().Type == "0") //物料托入库
			{
			//判断是否绑定单据及单据状态是否正常
			foreach (var item in palletBindList)
			{
			var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == item.ASNNo);
			if (notice == null)
			{
			throw new Exception("托盘存在物料未绑定入库单，不可入库！");
			}
			if (notice.Status == "3")
			{
			throw new Exception($"入库单{item.ASNNo}已关闭，不可入库！");
			}
			}

			//获取物料存放区域
			var noticeDetail = Db.Queryable<BllArrivalNoticeDetail>().First(m =>
			m.IsDel == "0" && m.Id == palletBindList.First().ASNDetailNo);
			if (noticeDetail == null)
			{
			throw new Exception("托盘存在物料未绑定入库单明细，不可入库");
			}

			skuNo = noticeDetail.SkuNo;

			}
			else if (palletBindList.First().Type == "1")//空托盘
			{
			skuNo = "100099";
			}
			}
			else //回流入库
			{
			if (stockDetail.Count == 0)
			{
			throw new Exception($"{palletNo}托盘条码不具有箱码信息，不可入库！");
			}
			if (stockDetail.Count(m => !string.IsNullOrWhiteSpace(m.LocatNo)) > 0)
			{
			throw new Exception("当前托盘已在库内，请核实");
			}
			skuNo = stockDetail.First().SkuNo;

			var beingTask = Db.Queryable<LogTask>().First(m => m.IsDel == "0"
			&& (m.Status == "0" \|\| m.Status == "1") && m.PalletNo == palletNo && m.Type == "0");
			if (beingTask != null)
			{
			if (!string.IsNullOrWhiteSpace(beingTask.EndLocat))
			{
			comDto = new OutCommandDto()
			{
			PalletNo = palletNo,//托盘号
			StartRoadway = beingTask.StartRoadway, // 起始巷道
			StartLocate = "", // 起始位置
			EndLocate = beingTask.EndLocat, // 目标位置
			EndRoadway = beingTask.EndRoadway, // 目标巷道
			TaskNo = beingTask.TaskNo, // 任务号
			TaskType = "0",// 任务类型 (出库)
			OutMode = "", //目标地址
			Order = 1
			};
			if (beingTask.IsSuccess == 0)
			{
			beingTask.IsSuccess = 1;
			beingTask.Status = "1";
			Db.Updateable(beingTask).ExecuteCommand();
			}
			return comDto;
			}
			else
			{
			if (string.IsNullOrWhiteSpace(roadwayNo))
			{
			roadwayNo = beingTask.EndRoadway;
			}
			isAddTask = false;
			oldTaskNo = beingTask.TaskNo;
			}
			}

			//获取对应回库规则
			var function = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetName == "托盘回库验证" && 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);

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

			var allotLocate = new AllotLocation();

			#region 申请储位

			SysStorageLocat locate;
			if (isHaveLocateNo) //指定储位
			{
			locate = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == haveLocate.LocatNo);
			}
			else
			{
			var sku = skuList.FirstOrDefault(m => m.SkuNo == skuNo);
			if (sku == null)
			{
			throw new Exception("物料信息中未查询到入库单明细包含的物料信息，不可入库");
			}
			//判断物料是否含有类别信息
			if (string.IsNullOrWhiteSpace(sku.CategoryNo))
			{
			throw new Exception($"物料：{sku.SkuNo}未查询到类别信息");
			}

			var skuCategory = skuCategoryList.FirstOrDefault(m => m.CategoryNo == sku.CategoryNo);
			if (skuCategory == null)
			{
			throw new Exception($"未在类别信息中查询到物料：{sku.SkuNo}包含的类别");
			}

			var areaStr = skuCategory.AreaNo.Split(",");
			var areaList = new List<string>();
			foreach (var item in areaStr)
			{
			areaList.Add(item);
			}

			locate = allotLocate.GetMiJiSuiTableLocate(roadwayNo, areaList);
			}

			#endregion

			Db.BeginTran();
			try
			{

			if (isAddTask) // 正常入库
			{
			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 = locate.LocatNo,//目标位置
			EndRoadway = locate.RoadwayNo, // 目标巷道
			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 = "入库口到=>>" + locate.LocatNo + "的入库任务", //关键信息

			};
			Db.Insertable(exTask).ExecuteCommand();
			var asnNo = "";
			// 添加托盘绑定表托盘入库任务号 liudl
			foreach (DataStockDetail stockModel in stockDetail)
			{
			var bindModel = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.Status == "2"
			&& m.PalletNo == stockModel.PalletNo && m.ASNNo == stockModel.ASNNo && m.ASNDetailNo == stockModel.ASNDetailNo);
			if (bindModel != null && string.IsNullOrWhiteSpace(bindModel.TaskNo))
			{
			bindModel.TaskNo = taskNo;
			bindModel.WareHouseNo = locate.WareHouseNo;
			bindModel.RoadwayNo = locate.RoadwayNo;
			bindModel.LocatNo = locate.LocatNo;
			Db.Updateable(bindModel).ExecuteCommand();
			asnNo = stockModel.ASNNo;
			}
			}
			foreach (DataStockDetail stockModel in stockDetail)
			{
			//添加托盘上架记录
			var upShelf = new BllPalletUpShelf()
			{
			TaskNo = exTask.TaskNo,
			TraceNo = asnNo,
			PalletNo = palletNo,
			SkuNo = stockModel.SkuNo,
			SkuName = stockModel.SkuName,
			LotNo = stockModel.LotNo,
			Status = "1",

			WareHouseNo = houseNo,
			RoadwayNo = locate.RoadwayNo,
			AreaNo = locate.AreaNo,
			LocatNo = locate.LocatNo,

			CreateUser = 0,
			};
			Db.Insertable(upShelf).ExecuteCommand();
			}

			oldTaskNo = taskNo;
			}
			else
			{
			var oldTask = Db.Queryable<LogTask>().First(m => m.IsDel == "0" && m.TaskNo == oldTaskNo);
			oldTask.EndLocat = locate.LocatNo;
			oldTask.EndRoadway = locate.RoadwayNo;
			if (oldTask.IsSuccess == 0)
			{
			oldTask.IsSuccess = 1;
			oldTask.Status = "1";
			}
			Db.Updateable(oldTask).ExecuteCommand();


			var bindModelList = Db.Queryable<BllPalletBind>().Where(m => m.IsDel == "0" && m.Status == "2"
			&& m.PalletNo == oldTask.PalletNo && m.TaskNo == oldTaskNo).ToList();
			foreach (var bindModel in bindModelList)
			{
			if (string.IsNullOrWhiteSpace(bindModel.LocatNo))
			{
			bindModel.TaskNo = oldTask.TaskNo;
			bindModel.WareHouseNo = locate.WareHouseNo;
			bindModel.RoadwayNo = locate.RoadwayNo;
			bindModel.LocatNo = locate.LocatNo;
			Db.Updateable(bindModel).ExecuteCommand();

			}
			}
			//更改上架信息
			var upShelfList = Db.Queryable<BllPalletUpShelf>().Where(m => m.IsDel == "0" && m.TaskNo == oldTask.TaskNo && m.PalletNo == palletNo).ToList();
			foreach (var upShelf in upShelfList)
			{
			upShelf.WareHouseNo = locate.WareHouseNo;
			upShelf.RoadwayNo = locate.RoadwayNo;
			upShelf.LocatNo = locate.LocatNo;
			upShelf.Status = "1";
			Db.Updateable(upShelf).ExecuteCommand();

			}


			}

			locate.Status = "2";
			Db.Updateable(locate).ExecuteCommand();
			if (palletBindList.Count >= 1)
			{
			foreach (var item in palletBindList)
			{
			item.Status = "1";
			item.WareHouseNo = locate.WareHouseNo;
			item.RoadwayNo = locate.RoadwayNo;
			item.LocatNo = locate.LocatNo;
			item.TaskNo = oldTaskNo;
			}
			Db.Updateable(palletBindList).ExecuteCommand();
			}
			Db.CommitTran();
			comDto = new OutCommandDto()
			{
			PalletNo = palletNo,//托盘号
			StartRoadway = "",
			StartLocate = "", // 起始位置
			EndLocate = locate.LocatNo, // 目标位置
			EndRoadway = locate.RoadwayNo, // 目标巷道
			TaskNo = oldTaskNo, // 任务号
			TaskType = "0",// 任务类型 (出库)
			OutMode = "", //目标地址
			Order = 1
			};

			}
			catch (Exception ex)
			{
			Db.RollbackTran();
			throw new Exception(ex.Message);
			}
			#endregion


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

			/// <summary>
			/// 下发入库申请储位任务（下发==》AGV小车）
			/// </summary>
			/// <param name="model"></param>
			/// <returns></returns>
			public void IssueAsnTask(OutCommandDto model,string url)
			{
			try
			{

			// 将任务发送至AGV 正式运行程序放开
			var jsonData = JsonConvert.SerializeObject(model);
			string response = "";

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

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

			//}
			//if (wcsModel.StatusCode == -1)
			//{
			// new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.Msg);
			// throw new Exception(wcsModel.Msg);
			//}
			}
			catch (Exception ex)
			{
			throw new Exception(ex.Message);
			}
			}
			catch (Exception)
			{
			throw;
			}
			}

			#endregion

			#region 指定储位
			//指定储位数据源（正常的空储位）
			public List<LocatDto> GetLocateList(string houseNo, string roadwayNo, string row, string column, string layer,
			string locateNo, string stockDetailId, int page, int limit, out int count)
			{
			try
			{
			//获取库存明细
			var DetailSkuNo = Db.Queryable<DataStockDetail>().Where(a => a.Id == int.Parse(stockDetailId)
			&& a.IsDel == "0").Select(a => a.SkuNo).First();
			//获取物料
			var skuCategoryNo = Db.Queryable<SysMaterials>().Where(a => a.IsDel == "0" && a.SkuNo == DetailSkuNo)
			.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))
			.AndIF(!string.IsNullOrWhiteSpace(column), m => m.Column == int.Parse(column))
			.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 => categoryAreaNo.Contains(m.AreaNo))
			.ToExpression();//注意这一句不能少
			var total = 0;
			var list = Db.Queryable<SysStorageLocat>().Where(item).OrderByDescending(a => a.Depth).OrderBy(a => a.Column)
			.Select(a => new LocatDto()
			{
			Id = a.Id,
			RoadwayNo = a.RoadwayNo,
			LocatNo = a.LocatNo,
			Row = a.Row,
			Column = a.Column,
			Layer = a.Layer,
			Depth = a.Depth,
			Status = a.Status
			}).ToOffsetPage(page, limit, ref total);
			count = total;

			return list;

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

			//保存指定的储位
			public void SaveAppointSlot(int bindId, int locateId, int userId)
			{
			try
			{
			//托盘绑定信息
			var bind = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.Id == bindId);
			if (bind == null)
			{
			throw new Exception("未查询到托盘绑定的信息");
			}
			if (bind.Status != "0")
			{
			throw new Exception("该托盘绑定的信息状态不是等待执行，不能指定储位，请核实！");
			}
			//储位
			var locate = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.Id == locateId);
			if (locate == null)
			{
			throw new Exception("未查询到储位的信息");
			}
			if (locate.Status != "0" \|\| locate.Flag != "0")
			{
			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)
			{
			var boxInfo = Db.Queryable<BllBoxInfo>().Where(m => m.IsDel == "0" && m.BindNo == item);
			if (boxInfo.Count(m => m.BitBoxMark == "1") > 0)
			{
			throw new Exception($"{bind.PalletNo}托盘上有零箱，请入零箱库！");
			}
			}
			Db.BeginTran();
			try
			{
			var time = DateTime.Now;
			//判断托盘绑定信息是否已有指定储位
			if (!string.IsNullOrWhiteSpace(bind.LocatNo))
			{
			var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.LocatNo == bind.LocatNo);
			locate2.Status = "0";
			Db.Updateable(locate2).ExecuteCommand();
			}
			//获取同托盘的托盘绑定信息
			var bindList = Db.Queryable<BllPalletBind>()
			.Where(m => m.IsDel == "0" && m.PalletNo == bind.PalletNo && m.Status == "0").ToList();
			if (bindList.Count > 0)
			{
			foreach (var b in bindList)
			{
			b.LocatNo = locate.LocatNo;
			b.WareHouseNo = locate.WareHouseNo;
			b.RoadwayNo = locate.RoadwayNo;
			b.UpdateTime = time;
			b.UpdateUser = userId;
			}

			Db.Updateable(bindList).ExecuteCommand();
			}
			//修改指定的储位
			bind.LocatNo = locate.LocatNo;
			bind.WareHouseNo = locate.WareHouseNo;
			bind.RoadwayNo = locate.RoadwayNo;
			bind.UpdateTime = time;
			bind.UpdateUser = userId;
			locate.Status = "2";
			Db.Updateable(bind).ExecuteCommand();
			Db.Updateable(locate).ExecuteCommand();

			new OperationASNServer().AddLogOperationAsn("入库作业", "托盘绑定", bind.PalletNo, "编辑", $"指定了储位：{locate.LocatNo}、单据号：{bind.ASNNo}、托盘码：{bind.PalletNo}的信息", userId);
			Db.CommitTran();
			}
			catch (Exception e)
			{
			Db.RollbackTran();
			throw new Exception(e.Message);
			}

			}
			catch (Exception e)
			{
			throw new Exception(e.Message);
			}
			}
			#endregion


			#region 申请储位、巷道任务完成、取消



			/// <summary>
			/// 申请巷道（立体库）
			@@ -2880,406 +3282,6 @@
			}
			}

			/// <summary>
			/// 1 申请储位 2 申请巷道后再申请储位储位
			/// </summary>
			/// <param name="palletNo"></param>
			/// <param name="houseNo"></param>
			/// <param name="roadwayNo"></param>
			/// <returns></returns>
			/// <exception cref="Exception"></exception>
			public OutCommandDto RequestLocation(string palletNo, string houseNo, string roadwayNo)
			{
			try
			{
			//验证托盘条码是否为空
			if (string.IsNullOrEmpty(palletNo))
			{
			throw new Exception("请输入要申请的托盘条码");
			}
			//验证所属仓库是否为空
			if (string.IsNullOrEmpty(houseNo))
			{
			throw new Exception("请选择所属仓库");
			}
			//验证是否为平库入库
			if (houseNo == "W02")
			{
			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管理，不可入库！");

			#region

			//查询托盘绑定信息(状态为等待入库的)
			var palletBindList = Db.Queryable<BllPalletBind>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo && (m.Status == "0" \|\| m.Status == "1")).ToList();
			var haveLocate = palletBindList.FirstOrDefault(m => !string.IsNullOrWhiteSpace(m.LocatNo));

			var skuList = Db.Queryable<SysMaterials>().Where(m => m.IsDel == "0").ToList();
			//物料类别信息
			var skuCategoryList = Db.Queryable<SysMaterialCategory>().Where(m => m.IsDel == "0").ToList();

			var skuNo = ""; //入库物料
			var isAddTask = true; //是否添加新任务
			var oldTaskNo = ""; //旧任务号
			var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.PalletNo == palletNo).ToList();
			if (palletBindList.Count >= 1) //正常入库
			{
			var palletBind = palletBindList.FirstOrDefault(m => m.Status == "1");
			if (palletBind != null)
			{
			var beingTask = Db.Queryable<LogTask>().First(m => m.IsDel == "0" && m.TaskNo == palletBind.TaskNo);
			if (beingTask == null)
			{
			throw new Exception("该托盘正在入库，但未查询到任务信息");
			}
			if (!string.IsNullOrWhiteSpace(beingTask.EndLocat))
			{
			comDto = new OutCommandDto()
			{
			PalletNo = palletNo,//托盘号
			StartRoadway = beingTask.StartRoadway, // 起始巷道
			StartLocate = "", // 起始位置
			EndLocate = beingTask.EndLocat, // 目标位置
			EndRoadway = beingTask.EndRoadway, // 目标巷道
			TaskNo = beingTask.TaskNo, // 任务号
			TaskType = "0",// 任务类型 (出库)
			OutMode = "", //目标地址
			Order = 1
			};
			if (beingTask.IsSuccess == 0)
			{
			beingTask.IsSuccess = 1;
			Db.Updateable(beingTask).ExecuteCommand();
			}
			return comDto;
			}
			else
			{
			if (string.IsNullOrWhiteSpace(roadwayNo))
			{
			roadwayNo = beingTask.EndRoadway;
			}
			isAddTask = false;
			oldTaskNo = beingTask.TaskNo;
			}
			}
			if (haveLocate != null)
			{
			isHaveLocateNo = true; //已有指定储位
			}

			if (palletBindList.First().Type == "0") //物料托入库
			{
			//判断是否绑定单据及单据状态是否正常
			foreach (var item in palletBindList)
			{
			var notice = Db.Queryable<BllArrivalNotice>().First(m => m.IsDel == "0" && m.ASNNo == item.ASNNo);
			if (notice == null)
			{
			throw new Exception("托盘存在物料未绑定入库单，不可入库！");
			}
			if (notice.Status == "3")
			{
			throw new Exception($"入库单{item.ASNNo}已关闭，不可入库！");
			}
			}

			//获取物料存放区域
			var noticeDetail = Db.Queryable<BllArrivalNoticeDetail>().First(m =>
			m.IsDel == "0" && m.Id == palletBindList.First().ASNDetailNo);
			if (noticeDetail == null)
			{
			throw new Exception("托盘存在物料未绑定入库单明细，不可入库");
			}

			skuNo = noticeDetail.SkuNo;

			}
			else if (palletBindList.First().Type == "1")//空托盘
			{
			skuNo = "100099";
			}
			}
			else //回流入库
			{
			if (stockDetail.Count == 0)
			{
			throw new Exception($"{palletNo}托盘条码不具有箱码信息，不可入库！");
			}
			if (stockDetail.Count(m => !string.IsNullOrWhiteSpace(m.LocatNo)) > 0)
			{
			throw new Exception("当前托盘已在库内，请核实");
			}
			skuNo = stockDetail.First().SkuNo;

			var beingTask = Db.Queryable<LogTask>().First(m => m.IsDel == "0"
			&& (m.Status == "0" \|\| m.Status == "1") && m.PalletNo == palletNo && m.Type == "0");
			if (beingTask != null)
			{
			if (!string.IsNullOrWhiteSpace(beingTask.EndLocat))
			{
			comDto = new OutCommandDto()
			{
			PalletNo = palletNo,//托盘号
			StartRoadway = beingTask.StartRoadway, // 起始巷道
			StartLocate = "", // 起始位置
			EndLocate = beingTask.EndLocat, // 目标位置
			EndRoadway = beingTask.EndRoadway, // 目标巷道
			TaskNo = beingTask.TaskNo, // 任务号
			TaskType = "0",// 任务类型 (出库)
			OutMode = "", //目标地址
			Order = 1
			};
			if (beingTask.IsSuccess == 0)
			{
			beingTask.IsSuccess = 1;
			beingTask.Status = "1";
			Db.Updateable(beingTask).ExecuteCommand();
			}
			return comDto;
			}
			else
			{
			if (string.IsNullOrWhiteSpace(roadwayNo))
			{
			roadwayNo = beingTask.EndRoadway;
			}
			isAddTask = false;
			oldTaskNo = beingTask.TaskNo;
			}
			}

			//获取对应回库规则
			var function = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetName == "托盘回库验证" && 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);

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

			var allotLocate = new AllotLocation();

			#region 申请储位

			SysStorageLocat locate;
			if (isHaveLocateNo) //指定储位
			{
			locate = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == haveLocate.LocatNo);
			}
			else
			{
			var sku = skuList.FirstOrDefault(m => m.SkuNo == skuNo);
			if (sku == null)
			{
			throw new Exception("物料信息中未查询到入库单明细包含的物料信息，不可入库");
			}
			//判断物料是否含有类别信息
			if (string.IsNullOrWhiteSpace(sku.CategoryNo))
			{
			throw new Exception($"物料：{sku.SkuNo}未查询到类别信息");
			}

			var skuCategory = skuCategoryList.FirstOrDefault(m => m.CategoryNo == sku.CategoryNo);
			if (skuCategory == null)
			{
			throw new Exception($"未在类别信息中查询到物料：{sku.SkuNo}包含的类别");
			}

			var areaStr = skuCategory.AreaNo.Split(",");
			var areaList = new List<string>();
			foreach (var item in areaStr)
			{
			areaList.Add(item);
			}

			locate = allotLocate.GetSuiTableLocate(houseNo, areaList, roadwayNo);
			}

			#endregion

			Db.BeginTran();
			try
			{

			if (isAddTask) // 正常入库
			{
			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 = locate.LocatNo,//目标位置
			EndRoadway = locate.RoadwayNo, // 目标巷道
			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 = "入库口到=>>" + locate.LocatNo + "的入库任务", //关键信息

			};
			Db.Insertable(exTask).ExecuteCommand();
			var asnNo = "";
			// 添加托盘绑定表托盘入库任务号 liudl
			foreach (DataStockDetail stockModel in stockDetail)
			{
			var bindModel = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.Status == "2"
			&& m.PalletNo == stockModel.PalletNo && m.ASNNo == stockModel.ASNNo && m.ASNDetailNo == stockModel.ASNDetailNo);
			if (bindModel != null && string.IsNullOrWhiteSpace(bindModel.TaskNo))
			{
			bindModel.TaskNo = taskNo;
			bindModel.WareHouseNo = locate.WareHouseNo;
			bindModel.RoadwayNo = locate.RoadwayNo;
			bindModel.LocatNo = locate.LocatNo;
			Db.Updateable(bindModel).ExecuteCommand();
			asnNo = stockModel.ASNNo;
			}
			}
			foreach (DataStockDetail stockModel in stockDetail)
			{
			//添加托盘上架记录
			var upShelf = new BllPalletUpShelf()
			{
			TaskNo = exTask.TaskNo,
			TraceNo = asnNo,
			PalletNo = palletNo,
			SkuNo = stockModel.SkuNo,
			SkuName = stockModel.SkuName,
			LotNo = stockModel.LotNo,
			Status = "1",

			WareHouseNo = houseNo,
			RoadwayNo = locate.RoadwayNo,
			AreaNo = locate.AreaNo,
			LocatNo = locate.LocatNo,

			CreateUser = 0,
			};
			Db.Insertable(upShelf).ExecuteCommand();
			}

			oldTaskNo = taskNo;
			}
			else
			{
			var oldTask = Db.Queryable<LogTask>().First(m => m.IsDel == "0" && m.TaskNo == oldTaskNo);
			oldTask.EndLocat = locate.LocatNo;
			oldTask.EndRoadway = locate.RoadwayNo;
			if (oldTask.IsSuccess == 0)
			{
			oldTask.IsSuccess = 1;
			oldTask.Status = "1";
			}
			Db.Updateable(oldTask).ExecuteCommand();


			var bindModelList = Db.Queryable<BllPalletBind>().Where(m => m.IsDel == "0" && m.Status == "2"
			&& m.PalletNo == oldTask.PalletNo && m.TaskNo == oldTaskNo).ToList();
			foreach (var bindModel in bindModelList)
			{
			if (string.IsNullOrWhiteSpace(bindModel.LocatNo))
			{
			bindModel.TaskNo = oldTask.TaskNo;
			bindModel.WareHouseNo = locate.WareHouseNo;
			bindModel.RoadwayNo = locate.RoadwayNo;
			bindModel.LocatNo = locate.LocatNo;
			Db.Updateable(bindModel).ExecuteCommand();

			}
			}
			//更改上架信息
			var upShelfList = Db.Queryable<BllPalletUpShelf>().Where(m => m.IsDel == "0" && m.TaskNo == oldTask.TaskNo && m.PalletNo == palletNo).ToList();
			foreach (var upShelf in upShelfList)
			{
			upShelf.WareHouseNo = locate.WareHouseNo;
			upShelf.RoadwayNo = locate.RoadwayNo;
			upShelf.LocatNo = locate.LocatNo;
			upShelf.Status = "1";
			Db.Updateable(upShelf).ExecuteCommand();

			}


			}

			locate.Status = "2";
			Db.Updateable(locate).ExecuteCommand();
			if (palletBindList.Count >= 1)
			{
			foreach (var item in palletBindList)
			{
			item.Status = "1";
			item.WareHouseNo = locate.WareHouseNo;
			item.RoadwayNo = locate.RoadwayNo;
			item.LocatNo = locate.LocatNo;
			item.TaskNo = oldTaskNo;
			}
			Db.Updateable(palletBindList).ExecuteCommand();
			}
			Db.CommitTran();
			comDto = new OutCommandDto()
			{
			PalletNo = palletNo,//托盘号
			StartRoadway = "",
			StartLocate = "", // 起始位置
			EndLocate = locate.LocatNo, // 目标位置
			EndRoadway = locate.RoadwayNo, // 目标巷道
			TaskNo = oldTaskNo, // 任务号
			TaskType = "0",// 任务类型 (出库)
			OutMode = "", //目标地址
			Order = 1
			};

			}
			catch (Exception ex)
			{
			Db.RollbackTran();
			throw new Exception(ex.Message);
			}
			#endregion


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

			/// <summary>
			/// 入库完成(wcs反馈、wms手动完成)