JC23WMS-2.git - Gitblit

			@@ -45,7 +45,7 @@
			throw new Exception("设备编码不可为空");
			}
			//通过设备号查找到所属设备（区域）
			var deviceInfo = Db.Queryable<SysStorageArea>().First(w => w.IsDel == "0" && w.DeviceCode == model.Location);
			var deviceInfo = Db.Queryable<SysStorageArea>().First(w => w.IsDel == "0" && w.DeviceCode.Contains(model.Location));
			if (deviceInfo == null)
			{
			throw new Exception("设备信息不存在");
			@@ -71,7 +71,7 @@
			case "0"://接料设备叫净桶
			{
			//叫桶目标储位地址信息
			endLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo);
			endLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo && w.Column == 1);
			if (endLoction == null)
			{
			throw new Exception("叫桶设备目标储位信息不存在");
			@@ -79,12 +79,28 @@
			//查找到该车间净桶区
			List<string> areaNoList = Db.Queryable<SysStorageArea>().Where(w => w.IsDel == "0" && w.Status == "0" && w.Type == "0" && w.WareHouseNo == houseNo).Select(s => s.AreaNo).ToList();
			//查找净桶
			pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "0" && w.Status == "0"
			&& areaNoList.Contains(w.AreaNo)).OrderByDescending(o => o.CreateTime).First();
			if (houseNo == "M03")//大单体车间净桶是绑定接料设备的
			{
			pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "0" && w.Status == "0"
			&& areaNoList.Contains(w.AreaNo) && w.UDF1 == deviceInfo.DeviceCode).OrderBy(o => o.UpdateTime).First();
			}
			else
			{
			pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "0" && w.Status == "0"
			&& areaNoList.Contains(w.AreaNo)).OrderBy(o => o.UpdateTime).First();
			}

			if (pallet == null)
			{
			throw new Exception("暂无净桶可分配");
			}
			//分配桶后判断该桶外侧储位是否需要移库
			bool yikuResult = YikuTask(pallet.PalletNo, url);
			if (!yikuResult)
			{
			throw new Exception("移库失败");
			}

			pallet.Status = "2";//分配状态 0:待分配，1：部分分配， 2:已分配
			//更新桶库存明细
			Db.Updateable(pallet).ExecuteCommand();
			@@ -95,7 +111,7 @@
			case "1"://混料设备叫料桶（混料）
			{
			//叫桶目标储位地址信息
			endLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo);
			endLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo && w.Column == 1);
			if (endLoction == null)
			{
			throw new Exception("叫桶设备目标储位信息不存在");
			@@ -109,11 +125,18 @@
			List<string> areaNoList2 = Db.Queryable<SysStorageArea>().Where(w => w.IsDel == "0" && w.Status == "0" && w.Type == "1" && w.WareHouseNo == houseNo).Select(s => s.AreaNo).ToList();
			//查找库存中是否有可用的此批次的混料桶
			pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "1" && w.Status == "0" && w.LotNo == model.LotNo
			&& areaNoList2.Contains(w.AreaNo)).OrderByDescending(o => o.CompleteTime).First();
			&& areaNoList2.Contains(w.AreaNo)).OrderBy(o => o.UpdateTime).First();
			if (pallet == null)
			{
			throw new Exception("暂无混料桶可分配");
			}
			//分配桶后判断该桶外侧储位是否需要移库
			bool yikuResult = YikuTask(pallet.PalletNo, url);
			if (!yikuResult)
			{
			throw new Exception("移库失败");
			}

			pallet.Status = "2";//分配状态 0:待分配，1：部分分配， 2:已分配
			//更新桶库存明细
			Db.Updateable(pallet).ExecuteCommand();
			@@ -126,7 +149,7 @@
			if (houseNo == "M04")//除了喷干车间下料口都是2个储位（投料储位、投完料储位）
			{
			//叫桶目标储位地址信息
			endLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo);
			endLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo && w.Column == 1);
			}
			else
			{
			@@ -143,7 +166,7 @@
			throw new Exception("批次号为空！");
			}
			//查找是否有此批次出库单明细
			var soNoticeDetail = Db.Queryable<BllExportNoticeDetail>().Where(w => w.IsDel == "0" && w.LotNo == model.LotNo).OrderBy(o => o.CreateTime).First();
			/*var soNoticeDetail = Db.Queryable<BllExportNoticeDetail>().Where(w => w.IsDel == "0" && w.LotNo == model.LotNo).OrderBy(o => o.CreateTime).First();
			if (soNoticeDetail == null)
			{
			throw new Exception("该批次没有对应的出库单明细");
			@@ -158,17 +181,24 @@
			soNotice.Status = "3";//正在执行
			soNotice.UpdateTime = DateTime.Now;
			//更新出库单
			Db.Updateable(soNotice).ExecuteCommand();
			Db.Updateable(soNotice).ExecuteCommand();*/

			//查找到该车间半成品区
			List<string> areaNoList3 = Db.Queryable<SysStorageArea>().Where(w => w.IsDel == "0" && w.Status == "0" && w.Type == "2" && w.WareHouseNo == houseNo).Select(s => s.AreaNo).ToList();
			//查找库存中是否有此批次的合格下料桶
			pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "2" && w.Status == "0" && w.LotNo == model.LotNo && w.InspectStatus == "1"
			&& areaNoList3.Contains(w.AreaNo)).OrderByDescending(o => o.CompleteTime).First();
			&& areaNoList3.Contains(w.AreaNo)).OrderBy(o => o.UpdateTime).First();
			if (pallet == null)
			{
			throw new Exception("暂无下料桶可分配");
			}
			//分配桶后判断该桶外侧储位是否需要移库
			bool yikuResult = YikuTask(pallet.PalletNo, url);
			if (!yikuResult)
			{
			throw new Exception("移库失败");
			}

			pallet.Status = "2";//分配状态 0:待分配，1：部分分配， 2:已分配
			//更新桶库存明细
			Db.Updateable(pallet).ExecuteCommand();
			@@ -186,8 +216,23 @@
			}
			//查找到该车间脏桶区
			List<string> areaNoList4 = Db.Queryable<SysStorageArea>().Where(w => w.IsDel == "0" && w.Status == "0" && w.Type == "3" && w.WareHouseNo == houseNo).Select(s => s.AreaNo).ToList();
			List<DataStockDetail> palletList = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "3" && w.Status == "0"
			&& areaNoList4.Contains(w.AreaNo)).OrderByDescending(o => o.CompleteTime).ToList();

			List<DataStockDetail> palletList = new List<DataStockDetail>();
			if (houseNo == "M01")
			{
			palletList = Db.Queryable<DataStockDetail>()
			.LeftJoin<SysStorageLocat>((d, l) => d.LocatNo == l.LocatNo)
			.Where(d => d.WareHouseNo == houseNo && d.PalletStatus == "3" && d.Status == "0" && areaNoList4.Contains(d.AreaNo))
			.OrderBy((d, l) => l.Row)
			.OrderBy((d, l) => l.Column)
			.ToList();
			}
			else
			{
			palletList = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "3" && w.Status == "0"
			&& areaNoList4.Contains(w.AreaNo)).OrderBy(o => o.UpdateTime).ToList();
			}

			if (palletList.Count <= 0)
			{
			throw new Exception("暂无脏桶可分配");
			@@ -230,7 +275,7 @@
			#endregion

			item.Status = "2";//分配状态 0:待分配，1：部分分配， 2:已分配
			//更新桶库存明细
			//更新桶库存明细
			Db.Updateable(item).ExecuteCommand();
			//起始储位地址信息
			var startLoction2 = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == item.LocatNo);
			@@ -247,9 +292,9 @@
			Receiver = "RCS",
			//IsSuccess = 1, //是否下发成功 0失败 1成功
			SendDate = DateTime.Now, //发送时间
			//BackDate = DateTime.Now, //返回时间
			//BackDate = DateTime.Now, //返回时间
			StartLocat = item.LocatNo,//起始位置
			EndLocat = model.Location,//目标位置
			EndLocat = endLoction.LocatNo,//目标位置
			PalletNo = item.PalletNo,//托盘码
			IsSend = 1,//是否可再次下发
			IsCancel = 1,//是否可取消
			@@ -259,13 +304,14 @@
			Status = "0",//任务状态0：等待执行1正在执行2执行完成
			NoticeDetailNo = int.Parse(noticeNo),
			Msg = taskMsg, //关键信息
			LotNo = item.LotNo//批次号
			};
			//组织下发小车任务信息
			var task2 = new TaskDetial
			{
			Taskno = taskNo,//任务号
			Startport = item.LocatNo,
			Endport = model.Location,
			Endport = model.Location,//endLoction.LocatNo,
			Pallno = item.PalletNo,
			Crtype = "1",//叫桶
			WareHouseNo = houseNo
			@@ -322,7 +368,7 @@
			SendDate = DateTime.Now, //发送时间
			//BackDate = DateTime.Now, //返回时间
			StartLocat = pallet.LocatNo,//起始位置
			EndLocat = model.Location,//目标位置
			EndLocat = endLoction.LocatNo,//目标位置
			PalletNo = pallet.PalletNo,//托盘码
			IsSend = 1,//是否可再次下发
			IsCancel = 1,//是否可取消
			@@ -332,6 +378,7 @@
			Status = "0",//任务状态0：等待执行1正在执行2执行完成
			NoticeDetailNo = int.Parse(noticeNo),
			Msg = taskMsg, //关键信息
			LotNo = pallet.LotNo//批次号
			};

			//组织下发小车任务信息
			@@ -339,7 +386,7 @@
			{
			Taskno = taskNo,//任务号
			Startport = pallet.LocatNo,//起始位置
			Endport = model.Location,//目标位置
			Endport = model.Location,//endLoction.LocatNo,//目标位置
			Pallno = pallet.PalletNo,//桶号
			Crtype = "1",//叫桶
			WareHouseNo = houseNo//车间编码
			@@ -392,43 +439,49 @@
			try
			{
			string taskMsg = "";
			//查找该桶有没有正在执行的任务
			var tasking = Db.Queryable<LogTask>().First(w => w.IsDel == "0" && w.Status == "1" && w.PalletNo == model.PalletNo);
			if (tasking != null)
			{
			throw new Exception($"该桶有正在执行的任务，PalletNo:{model.PalletNo}");
			}

			//通过设备号查找到所属设备（区域）
			var deviceInfo = Db.Queryable<SysStorageArea>().First(w => w.IsDel == "0" && w.DeviceCode == model.Location);
			var deviceInfo = Db.Queryable<SysStorageArea>().First(w => w.IsDel == "0" && w.DeviceCode.Contains(model.Location));
			if (deviceInfo == null)
			{
			throw new Exception("设备信息不存在");
			}
			var houseNo = deviceInfo.WareHouseNo;//申请储位设备所在车间编号
			//申请储位设备所在车间编号
			var houseNo = deviceInfo.WareHouseNo;
			//设备所在储位信息（起始储位）
			var deviceLocatInfo = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo);
			if (deviceLocatInfo == null)
			{
			throw new Exception($"未查询到该设备所在储位信息，Location:{model.Location}");
			}

			var noticeno = "0";//出入库单据明细ID
			var deviceLocatInfo = new SysStorageLocat();
			//出入库单据明细ID
			var noticeno = "0";
			//目标储位信息
			var loction = new SysStorageLocat();
			//桶库存信息
			var palletInfo = Db.Queryable<DataStockDetail>().First(w => w.IsDel == "0" && w.PalletNo == model.PalletNo);
			if (palletInfo == null)
			{
			throw new Exception($"未查询到该桶的库存信息，PalletNo:{model.PalletNo}");
			}
			var palletInfo = new DataStockDetail();

			var storageLocat = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.Status == "0");
			//开启事务
			Db.BeginTran();

			SysStorageLocat loction = new SysStorageLocat();//目标储位信息
			switch (model.Type)
			{
			case "3"://清洗设备申请储位（净桶申请储位）
			{
			//设备放桶储位信息（原始叫桶目标储位）
			var deviceLocatInfo2 = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo && w.Column == 1);// Column=1 清洗储位，Column=2 清洗完料储位
			if (deviceLocatInfo2 == null)
			{
			throw new Exception($"未查询到该设备所在储位信息，Location:{model.Location}");
			}
			//查找桶库存信息
			palletInfo = Db.Queryable<DataStockDetail>().Where(w => w.IsDel == "0" && w.WareHouseNo == deviceLocatInfo2.WareHouseNo && w.AreaNo == deviceLocatInfo2.AreaNo && w.LocatNo == deviceLocatInfo2.LocatNo).OrderBy(o => o.UpdateTime).First();
			if (palletInfo == null)
			{
			throw new Exception($"未查询到该设备上桶的库存信息");
			}
			//查找该桶有没有正在执行的任务
			var tasking = Db.Queryable<LogTask>().First(w => w.IsDel == "0" && w.Status == "1" && w.PalletNo == palletInfo.PalletNo);
			if (tasking != null)
			{
			throw new Exception($"该桶有正在执行的任务，PalletNo:{palletInfo.PalletNo}");
			}

			//设备所在储位信息（起始储位）
			deviceLocatInfo = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo && w.Column == 2);// Column=1 清洗储位，Column=2 清洗完料储位
			if (deviceLocatInfo == null)
			@@ -453,6 +506,23 @@
			{
			throw new Exception($"未查询到该设备所在储位信息，Location:{model.Location}");
			}
			//查找桶库存信息
			palletInfo = Db.Queryable<DataStockDetail>().Where(w => w.IsDel == "0" && w.WareHouseNo == deviceLocatInfo.WareHouseNo && w.AreaNo == deviceLocatInfo.AreaNo && w.LocatNo == deviceLocatInfo.LocatNo).OrderBy(o => o.UpdateTime).First();
			if (palletInfo == null)
			{
			throw new Exception($"未查询到该设备上桶的库存信息");
			}
			palletInfo.LotNo = model.LotNo;//批次号
			//更新桶库存信息
			Db.Updateable(palletInfo).ExecuteCommand();

			//查找该桶有没有正在执行的任务
			var tasking = Db.Queryable<LogTask>().First(w => w.IsDel == "0" && w.Status == "1" && w.PalletNo == palletInfo.PalletNo);
			if (tasking != null)
			{
			throw new Exception($"该桶有正在执行的任务，PalletNo:{palletInfo.PalletNo}");
			}

			//判断是否有批次号
			if (string.IsNullOrWhiteSpace(model.LotNo))
			{
			@@ -464,9 +534,7 @@
			{
			throw new Exception("该车间预混区暂无空余储位");
			}
			palletInfo.LotNo = model.LotNo;//批次号
			//更新桶库存信息
			Db.Updateable(palletInfo).ExecuteCommand();


			taskMsg = "接料设备（预混料桶）申请储位任务";
			}
			@@ -479,13 +547,26 @@
			{
			throw new Exception($"未查询到该设备所在储位信息，Location:{model.Location}");
			}
			//查找桶库存信息
			palletInfo = Db.Queryable<DataStockDetail>().Where(w => w.IsDel == "0" && w.WareHouseNo == deviceLocatInfo.WareHouseNo && w.AreaNo == deviceLocatInfo.AreaNo && w.LocatNo == deviceLocatInfo.LocatNo).OrderBy(o => o.UpdateTime).First();
			if (palletInfo == null)
			{
			throw new Exception($"未查询到该设备上桶的库存信息");
			}
			//查找该桶有没有正在执行的任务
			var tasking = Db.Queryable<LogTask>().First(w => w.IsDel == "0" && w.Status == "1" && w.PalletNo == palletInfo.PalletNo);
			if (tasking != null)
			{
			throw new Exception($"该桶有正在执行的任务，PalletNo:{palletInfo.PalletNo}");
			}

			//判断是否有批次号
			if (string.IsNullOrWhiteSpace(model.LotNo))
			{
			throw new Exception("批次号为空！");
			}
			//校验此批次是否有入库单
			var noticeDetail = Db.Queryable<BllArrivalNoticeDetail>().Where(w => w.IsDel == "0" && w.Status == "0" && w.LotNo == model.LotNo).OrderByDescending(o => o.CreateTime).First();
			/*var noticeDetail = Db.Queryable<BllArrivalNoticeDetail>().Where(w => w.IsDel == "0" && w.Status == "0" && w.LotNo == model.LotNo).OrderByDescending(o => o.CreateTime).First();
			if (noticeDetail == null)
			{
			throw new Exception("该批次没有对应的入库单明细");
			@@ -498,8 +579,8 @@
			throw new Exception("该批次没有对应的入库单");
			}
			notice.Status = "1";//正在执行
			//更新入库单状态
			Db.Updateable(notice).ExecuteCommand();
			//更新入库单状态
			Db.Updateable(notice).ExecuteCommand();*/

			//查找到该车间半成品区
			loction = GetLocatModel(houseNo, "2");
			@@ -513,10 +594,28 @@
			break;
			case "2"://下料设备申请储位（脏桶申请储位）
			{
			//设备放桶储位信息（原始叫桶目标储位）
			var deviceLocatInfo2 = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo && w.Column == 1);// Column=1 投料储位，Column=2 投完料储位
			if (deviceLocatInfo2 == null)
			{
			throw new Exception($"未查询到该设备所在储位信息，Location:{model.Location}");
			}
			//查找桶库存信息
			palletInfo = Db.Queryable<DataStockDetail>().Where(w => w.IsDel == "0" && w.WareHouseNo == deviceLocatInfo2.WareHouseNo && w.AreaNo == deviceLocatInfo2.AreaNo && w.LocatNo == deviceLocatInfo2.LocatNo).OrderBy(o => o.UpdateTime).First();
			if (palletInfo == null)
			{
			throw new Exception($"未查询到该设备上桶的库存信息");
			}
			//查找该桶有没有正在执行的任务
			var tasking = Db.Queryable<LogTask>().First(w => w.IsDel == "0" && w.Status == "1" && w.PalletNo == palletInfo.PalletNo);
			if (tasking != null)
			{
			throw new Exception($"该桶有正在执行的任务，PalletNo:{palletInfo.PalletNo}");
			}
			if (houseNo == "M04")//除了喷干车间下料口都是2个储位（投料储位、投完料储位）
			{
			//设备所在储位信息（起始储位）
			deviceLocatInfo = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo);
			deviceLocatInfo = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.WareHouseNo == houseNo && w.AreaNo == deviceInfo.AreaNo && w.Column == 1);
			}
			else
			{
			@@ -549,9 +648,9 @@
			//IsSuccess = 1, //是否下发成功 0失败 1成功
			SendDate = DateTime.Now, //发送时间
			//BackDate = DateTime.Now, //返回时间
			StartLocat = model.Location,//起始位置
			StartLocat = deviceLocatInfo.LocatNo,//起始位置
			EndLocat = loction.LocatNo,//目标位置
			PalletNo = model.PalletNo,//桶号
			PalletNo = palletInfo.PalletNo,//桶号
			IsSend = 1,//是否可再次下发
			IsCancel = 1,//是否可取消
			IsFinish = 1,//是否可完成
			@@ -560,13 +659,14 @@
			Status = "0",//任务状态0：等待执行1正在执行2执行完成
			NoticeDetailNo = int.Parse(noticeno),
			Msg = taskMsg, //关键信息
			LotNo = palletInfo.LotNo//批次号
			};
			var task = new TaskDetial
			{
			Taskno = taskNo,//任务号
			Startport = model.Location,
			Endport = loction.LocatNo,
			Pallno = model.PalletNo,
			Startport = model.Location,//deviceLocatInfo.LocatNo,//起始位置
			Endport = loction.LocatNo,//目标位置
			Pallno = palletInfo.PalletNo,
			Crtype = "0",//入库
			WareHouseNo = houseNo
			};
			@@ -620,10 +720,10 @@
			//查找储位
			var loctionModel = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.Status == "0" && w.Flag == "0" && w.WareHouseNo == houseNo && areaNoList.Contains(w.AreaNo))
			.OrderBy(o => o.Row).OrderByDescending(o => o.Column).First();
			if (loctionModel == null)
			{
			throw new Exception("该车间净桶区暂无空余储位");
			}
			//if (loctionModel == null)
			//{
			// throw new Exception("该车间净桶区暂无空余储位");
			//}
			return loctionModel;
			}
			catch (Exception ex)
			@@ -807,7 +907,8 @@
			stockDetail.WareHouseNo = endLocatInfo.WareHouseNo;//所属仓库
			stockDetail.RoadwayNo = endLocatInfo.RoadwayNo;//所属巷道
			stockDetail.AreaNo = endLocatInfo.AreaNo;//所属区域
			stockDetail.LocatNo = endLocatInfo.LocatNo;//储位地址
			stockDetail.LocatNo = endLocatInfo.LocatNo;//储位地址
			stockDetail.UpdateTime = DateTime.Now;//更新时间
			if (endAreaInfo.Type == "0")//洁净区
			{
			stockDetail.PalletStatus = "0";
			@@ -1188,5 +1289,159 @@
			return result;
			#endregion
			}

			/// <summary>
			/// 分配桶后判断该桶外侧储位是否需要移库
			/// </summary>
			/// <param name="palletNo"></param>
			/// <param name="url"></param>
			/// <returns></returns>
			/// <exception cref="Exception"></exception>
			private bool YikuTask(string palletNo,string url)
			{
			try
			{
			//分配桶的库存信息
			var palletInfo = Db.Queryable<DataStockDetail>().First(w => w.IsDel == "0" && w.PalletNo == palletNo);
			if (palletInfo == null)
			{
			throw new Exception("未查询到分配桶的库存信息");
			}
			//判断分配的桶有没有正在执行的任务（移库中）
			var taskIng= Db.Queryable<LogTask>().First(w => w.IsDel == "0" && (w.Status == "0" \|\| w.Status == "1") && w.PalletNo == palletNo);
			if (taskIng != null)
			{
			throw new Exception("分配的桶有正在执行的任务，请稍后再试");
			}
			//分配桶的储位信息
			var locatInfo = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == palletInfo.LocatNo);
			if (locatInfo == null)
			{
			throw new Exception("未查询到分配桶所在的储位信息");
			}

			//判断该储位是否是内侧储位
			if (!string.IsNullOrEmpty(locatInfo.AisleOne))
			{
			//判断外侧储位是否有桶
			var palletInfoYi = Db.Queryable<DataStockDetail>().First(w => w.IsDel == "0" && w.LocatNo == locatInfo.AisleOne);
			if (palletInfoYi != null)
			{
			//判断要移库的桶是否被分配
			if (palletInfoYi.Status != "0")
			{
			throw new Exception("要移库的桶已被分配，请稍后再试");
			}
			//判断要移库的桶是否有正在执行的任务
			var taskInfo = Db.Queryable<LogTask>().First(w => w.IsDel == "0" && (w.Status == "0" \|\| w.Status == "1") && w.PalletNo == palletInfoYi.PalletNo);
			if (taskInfo != null)
			{
			throw new Exception("要移库的桶有正在执行的任务，请稍后再试");
			}
			#region#给要移库的桶分配新储位
			var locatInfoNew = new SysStorageLocat();
			//优先分配内侧储位
			var locatListNei = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.Status == "0" && !string.IsNullOrEmpty(w.AisleOne) && w.WareHouseNo == palletInfoYi.WareHouseNo && w.AreaNo == palletInfoYi.AreaNo).ToList();
			foreach (var item in locatListNei)
			{
			//判断该内侧储位的外侧储位是否有桶
			var detailWai = Db.Queryable<DataStockDetail>().First(w => w.IsDel == "0" && w.LocatNo == item.AisleOne);
			if (detailWai != null)
			{
			continue;
			}
			locatInfoNew = item;
			break;
			}
			if (locatInfoNew == null)
			{
			//没有内侧储位，再查找外侧储位
			var locatListWai = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.Status == "0" && string.IsNullOrEmpty(w.AisleOne) && w.WareHouseNo == palletInfoYi.WareHouseNo && w.AreaNo == palletInfoYi.AreaNo).OrderBy(o => o.Row).ToList();
			foreach (var item in locatListWai)
			{
			//判断该储位的内侧储位是否有正在执行的任务
			var locatItemNei = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.AisleOne == item.LocatNo);
			if (locatItemNei != null && locatItemNei.Status != "0")
			{
			continue;
			}
			locatInfoNew = item;
			break;
			}
			}
			if (locatInfoNew == null)
			{
			throw new Exception("没有空余的空储位进行移库");
			}
			#endregion

			//给下车下发移库任务
			var taskNo = new Common().GetMaxNo("TK");//任务号
			//任务信息
			var logTaskEntry = new LogTask
			{
			TaskNo = taskNo,
			Sender = "WMS",
			Receiver = "RCS",
			//IsSuccess = 1, //是否下发成功 0失败 1成功
			SendDate = DateTime.Now, //发送时间
			//BackDate = DateTime.Now, //返回时间
			StartLocat = palletInfoYi.LocatNo,//起始位置
			EndLocat = locatInfoNew.LocatNo,//目标位置
			PalletNo = palletInfoYi.PalletNo,//托盘码
			IsSend = 1,//是否可再次下发
			IsCancel = 1,//是否可取消
			IsFinish = 1,//是否可完成
			Type = "1",//任务类型 0 入库任务 1 出库任务 2 移库任务
			OrderType = "3",//单据类型 0 入库 1 出库 3移库
			Status = "0",//任务状态0：等待执行1正在执行2执行完成
			NoticeDetailNo = 0,
			Msg = $"将桶{palletInfoYi.PalletNo}从{palletInfoYi.LocatNo}移到{locatInfoNew.LocatNo}", //关键信息
			LotNo = ""//批次号
			};

			//组织下发小车任务信息
			var task = new TaskDetial
			{
			Taskno = taskNo,//任务号
			Startport = palletInfoYi.LocatNo,//起始位置
			Endport = locatInfoNew.LocatNo,//endLoction.LocatNo,//目标位置
			Pallno = palletInfoYi.PalletNo,//桶号
			Crtype = "1",//叫桶
			WareHouseNo = palletInfoYi.WareHouseNo//车间编码
			};
			//给下车下发任务
			logTaskEntry.SendDate = DateTime.Now;//发送时间
			var agvResult = CreateTaskForAgv(task, url);
			if (agvResult)//成功
			{
			//请求成功修改任务表相应字段状态
			logTaskEntry.IsSuccess = 1;
			logTaskEntry.IsSend = 0;
			//logTaskEntry.IsCancel = 0;
			logTaskEntry.BackDate = DateTime.Now;
			logTaskEntry.Status = "1";//正在执行
			Db.Insertable(logTaskEntry).ExecuteCommand();


			locatInfo.Status = "5";//移出中
			Db.Updateable(locatInfo).ExecuteCommand();

			locatInfoNew.Status = "4";//移入中
			Db.Updateable(locatInfoNew).ExecuteCommand();
			}
			else//失败
			{
			throw new Exception($"给小车下发移库任务失败，桶号：{palletInfoYi.PalletNo}");
			}
			}
			}
			return true;
			}
			catch (Exception e)
			{
			throw new Exception(e.Message);
			}
			}
			}
			}