JC34WMS.git - Gitblit

			@@ -6,6 +6,7 @@
			using System.Collections.Generic;
			using System.Linq;
			using System.Text;
			using Utility.Tools;
			using WMS.BLL.Logic;
			using WMS.BLL.LogServer;
			using WMS.DAL;
			@@ -30,10 +31,10 @@
			/// </summary>
			/// <param name="palletNo"></param>
			/// <param name="houseNo"></param>
			/// <param name="roadwayNo"></param>
			/// <param name="ceng"></param>
			/// <returns></returns>
			/// <exception cref="Exception"></exception>
			public OutCommandDto RequestLocation(string palletNo, string houseNo)
			public OutCommandDto RequestLocation(string palletNo, string houseNo,string ceng)
			{
			try
			{
			@@ -242,7 +243,7 @@
			areaList.Add(item);
			}

			locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "");
			locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "",ceng);


			#endregion
			@@ -1140,9 +1141,8 @@
			}
			}


			/// <summary>
			/// 移库任务完成JC34
			/// 移库单的移库任务完成JC34 兼容AGV小车移库
			/// </summary>
			/// <param name="taskNo"></param>
			/// <param name="userId"></param>
			@@ -1191,7 +1191,7 @@
			if (userId != 0)
			{
			//添加操作日志记录
			var k = new OperationASNServer().AddLogOperationAsn("入库作业", "入库日志", taskNo, "完成", $"点击完成按钮、完成任务号为：{taskNo}的任务", userId);
			var k = new OperationASNServer().AddLogOperationAsn("库内作业", "库内日志", taskNo, "完成", $"点击完成按钮、完成任务号为：{taskNo}的任务", userId);
			}

			foreach (var item in stockDetail)
			@@ -1245,6 +1245,425 @@
			}
			}

			/// <summary>
			/// 出库单的移库任务，JC34 货架托盘下架
			/// </summary>
			/// <param name="taskNo">任务号</param>
			/// <param name="userId">操作人</param>
			/// <exception cref="Exception"></exception>
			public void ExMoveSuccess(string taskNo, int userId)
			{
			try
			{
			//当前任务信息
			var task = Db.Queryable<LogTask>().First(m => m.TaskNo == taskNo && m.IsDel == "0");
			if (task == null)
			{
			throw new Exception($"未查询到任务号为：‘{taskNo}’的任务信息");
			}
			if (task.Status == "2")
			{
			throw new Exception("当前任务已完成");
			}
			Db.BeginTran();
			//库存中当前托盘的信息
			var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.PalletNo == task.PalletNo).ToList();
			//当前任务中的目标储位信息
			//当前任务中的原储位
			var locate = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == task.StartLocat);
			if (locate == null)
			{
			throw new Exception($"WMS系统中没有该{task.StartLocat}储位对应的信息");
			}
			var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == task.EndLocat);
			if (locate2 == null)
			{
			throw new Exception($"WMS系统中没有该{task.EndLocat}储位对应的信息");
			}
			//平库中储位集合
			var pingKuLocate = Db.Queryable<SysStorageLocat>().Where(m => m.WareHouseNo == "W04" && m.IsDel == "0").ToList();
			var pingKuList = pingKuLocate.Select(m => m.LocatNo).ToList();
			try
			{

			//task.Status = "5";//任务状态
			////判断起始目标位置都是平库
			//if (pingKuList.Contains(task.StartLocat) && pingKuList.Contains(task.EndLocat))
			//{
			task.Status = "2";
			//}

			task.IsSend = 0;
			task.IsCancel = 0;
			task.IsFinish = 0;
			task.FinishDate = DateTime.Now;//完成时间
			Db.Updateable(task).ExecuteCommand();

			#region 修改储位状态

			if (!pingKuList.Contains(task.StartLocat))
			{
			//原储位改为空储位 0
			locate.Status = "0";
			Db.Updateable(locate).ExecuteCommand();
			}


			//目标储位改为有货物 1
			locate2.Status = "1";
			Db.Updateable(locate2).ExecuteCommand();

			foreach (var item in stockDetail)
			{
			item.WareHouseNo = locate2.WareHouseNo;
			item.AreaNo = locate2.AreaNo;
			item.RoadwayNo = locate2.RoadwayNo;
			item.LocatNo = locate2.LocatNo;
			}
			Db.Updateable(stockDetail).ExecuteCommand();



			#endregion

			Db.CommitTran();
			}
			catch (Exception ex)
			{
			Db.RollbackTran();
			throw new Exception(ex.Message);
			}
			}
			catch (Exception ex)
			{
			throw new Exception("完成反馈失败：" + ex.Message);
			}
			}



			/// <summary>
			/// PDA下发出库
			/// </summary>
			/// <param name="soNo"></param>
			/// <param name="detailId"></param>
			/// <param name="outMode"></param>
			/// <param name="userId"></param>
			/// <param name="url"></param>
			/// <param name="str"></param>
			/// <returns></returns>
			/// <exception cref="Exception"></exception>
			public List<OutCommandDto> IssueOutHouseLk(string soNo, string detailId,string outMode, int userId, string url, out string str)
			{
			try
			{
			var outDto1 = new List<OutCommandDto>(); //出库数据的集合（深度为1的储位）
			//记录错误信息的集合 //1:当前要出库的储位正在移出、2 出库的托盘储位信息错误(在储位表中未查询到)、3储位损坏不能出库、4 要出库的托盘正在入库


			var com = new Common();
			var notice = Db.Queryable<BllExportNotice>().First(m => m.SONo == soNo && m.IsDel == "0");
			if (notice == null)
			{
			throw new Exception($"未找到{soNo}出库单信息");
			}
			if (notice.WareHouseNo != "W02")
			{
			throw new Exception("仓库号错误");
			}
			var intDetailId = int.Parse(detailId);
			if (intDetailId <=0)
			{
			throw new Exception("选择的出库单明细参数错误");
			}
			//所有要出库的出库分配信息(未下发的信息和待拣货的信息)
			var item = Db.Queryable<BllExportAllot>().First(a => a.IsDel == "0" && a.SONo == soNo && a.SODetailNo == intDetailId && a.Status == "0" );
			if (item == null) //判断是否有需要下发的出库流水
			{
			throw new Exception("当前出库单据无需要下发的托盘");
			}

			#region 集合

			//要出库的明细集合
			var outStockDetail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == item.PalletNo).ToList();
			//物料编码表
			var skuList = Db.Queryable<SysMaterials>().Where(w => w.IsDel == "0");
			//包装表
			var packagList = Db.Queryable<SysPackag>().Where(w => w.IsDel == "0");
			Db.BeginTran();
			try
			{
			List<LogTask> logTaskList = new List<LogTask>();//此次出库任务集合，为应对同托盘不同物料出库
			var i = 0;
			str = string.Empty;
			var outLocatelist1 = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.AreaNo == "B02" && m.Flag == "0").ToList();
			var outLocatelist2 = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.AreaNo == "B05" && m.Flag == "0").ToList();
			//循环分配的信息生成出库任务

			var outModeLocate = outMode;

			var taskNoStr = "";

			// 储位号
			var locateNo = outStockDetail.First(m => m.PalletNo == item.PalletNo).LocatNo;

			#region 判断

			//判断托盘是否在库内
			if (string.IsNullOrWhiteSpace(locateNo)) //库外
			{
			//判断托盘是否在入库中
			var imBl = com.GetImTask(item.PalletNo);
			if (imBl != null)
			{
			str = "要出库的托盘正在入库";
			return outDto1;
			}
			//判断是否是已经出过库又回库
			if (item.Status == "0")
			{
			//如果不在仓库内，当前分配信息直接更新出库完成
			item.Status = "2";//状态
			item.OutMode = outModeLocate;//出库口
			Db.Updateable(item).ExecuteCommand();
			var noticeDetail = Db.Queryable<BllExportNoticeDetail>().First(m => m.IsDel == "0" && m.Id == item.SODetailNo);
			if (noticeDetail != null) //更新出库单据的下发数量
			{
			noticeDetail.FactQty += item.Qty;
			Db.Updateable(noticeDetail).ExecuteCommand();
			}

			//var notice2 = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == item.SONo);
			if (notice.Status == "0" \|\| notice.Status == "1" \|\| notice.Status == "2")
			{
			var detailList = Db.Queryable<BllExportNoticeDetail>().Where(m => m.IsDel == "0" && m.SONo == item.SONo).ToList();
			if (detailList.Count(m => m.Qty >= m.AllotQty) > 0)
			{
			notice.Status = "3"; //变更状态为正在执行
			Db.Updateable(notice).ExecuteCommand();
			}
			}
			str = "要出库的托盘已在库外";
			return outDto1;
			}
			str = "要出库的托盘正在入库";
			return outDto1;
			}

			var locate = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == locateNo && m.IsDel == "0");//当前出库的储位信息
			if (locate == null)
			{
			str = "出库的托盘储位信息错误(在储位表中未查询到)";
			return outDto1;
			}
			//判断储位标志是否为损坏
			if (locate.Flag == "2")
			{
			str = "储位损坏不能出库";
			return outDto1;
			}
			if (locate.WareHouseNo != "W02")
			{
			str = "托盘不在货架库上";
			return outDto1;
			}
			var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == outModeLocate && m.IsDel == "0");//当前出库的目标储位信息
			if (locate2 == null)
			{
			str = "出库的托盘储位信息错误(在储位表中未查询到)";
			return outDto1;
			}
			else if (locate2.Status != "0")
			{
			str = "目标储位状态不是空储位";
			return outDto1;
			}
			#endregion

			if (locate.Status == "1") //有物品
			{
			#region 添加出库任务

			var taskNo = new Common().GetMaxNo("TK");
			var exTask = new LogTask //出库任务
			{
			TaskNo = taskNo,
			Sender = "WMS",
			Receiver = "WCS",
			IsSuccess = 0, //是否下发成功 0失败 1成功

			StartLocat = locate.LocatNo,//起始位置
			EndLocat = outModeLocate,//目标位置
			PalletNo = item.PalletNo,//托盘码
			IsSend = 1,//是否可再次下发
			IsCancel = 1,//是否可取消
			IsFinish = 1,//是否可完成
			Type = "1",//任务类型 0 入库任务 1 出库任务 2 移库任务
			Status = "0",//任务状态0：等待执行1正在执行2执行完成
			OrderType = "1",//0 入库单 1 出库单 2 盘点单 3 移库单
			Msg = "从" + locate.LocatNo + "到" + outModeLocate + "的出库任务", //关键信息
			};
			Db.Insertable(exTask).ExecuteCommand();
			logTaskList.Add(exTask);

			outDto1.Add(new OutCommandDto()
			{
			TaskNo = exTask.TaskNo, // 任务号
			TaskType = "1",// 任务类型 (出库)0入 1出 2移

			PalletNo = item.PalletNo,//托盘号
			StartLocate = locate.LocatNo, // 起始位置
			StartRoadway = locate.RoadwayNo,//其实巷道
			EndLocate = outModeLocate, // 目标位置

			Order = 999,
			Type = PLCTypeEnum.AGV

			});
			taskNoStr = exTask.TaskNo;

			#endregion

			#region 改变数据
			if (item.Status == "0")//判断托盘是否下发过
			{
			var noticeDetail = Db.Queryable<BllExportNoticeDetail>().First(m => m.IsDel == "0" && m.Id == item.SODetailNo);
			if (noticeDetail != null) //更新出库单据的下发数量
			{
			noticeDetail.FactQty += item.Qty;
			Db.Updateable(noticeDetail).ExecuteCommand();
			}

			//var notice2 = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == item.SONo);
			if (notice.Status == "0" \|\| notice.Status == "1" \|\| notice.Status == "2")
			{
			var detailList = Db.Queryable<BllExportNoticeDetail>().Where(m => m.IsDel == "0" && m.SONo == item.SONo).ToList();
			if (detailList.Count(m => m.Qty >= m.AllotQty) > 0)
			{
			notice.Status = "3"; //变更状态为正在执行
			Db.Updateable(notice).ExecuteCommand();
			}
			}
			}
			locate.Status = "3"; //要出库的储位改变状态正在出库
			Db.Updateable(locate).ExecuteCommand();
			var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == outModeLocate && m.IsDel == "0");//当前出库的目标储位信息
			locate2.Status = "4";
			Db.Updateable(locate2).ExecuteCommand();

			item.TaskNo = taskNoStr; // 出库分配信息中更新任务号
			item.Status = "1"; // 出库分配信息状态改为正在执行
			//item.UnstackingMode = unstackingMode2;//拆垛方式
			item.OutMode = outModeLocate;//出库口
			//item.LoadingAddre = unstackingMode2 == "0" ? loadingAddre : "";//装车口
			Db.Updateable(item).ExecuteCommand();

			#endregion

			}
			else if (locate.Status == "3") //出库中
			{
			#region 改变数据
			//判断是否是已经出过库又回库（状态为待拣货的 1）
			if (item.Status == "0")
			{
			var noticeDetail = Db.Queryable<BllExportNoticeDetail>().First(m => m.IsDel == "0" && m.Id == item.SODetailNo);
			if (noticeDetail != null) //更新出库单据的下发数量
			{
			noticeDetail.FactQty += item.Qty;
			Db.Updateable(noticeDetail).ExecuteCommand();
			}

			//var notice2 = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == item.SONo);
			if (notice.Status == "0" \|\| notice.Status == "1" \|\| notice.Status == "2")
			{
			var detailList = Db.Queryable<BllExportNoticeDetail>().Where(m => m.IsDel == "0" && m.SONo == item.SONo).ToList();
			if (detailList.Count(m => m.Qty >= m.AllotQty) > 0)
			{
			notice.Status = "3"; //变更状态为正在执行
			Db.Updateable(notice).ExecuteCommand();
			}
			}
			}
			var taskNo = Db.Queryable<LogTask>().First(m => m.OrderType == "1" && m.TaskNo != item.TaskNo && m.Status == "1" && m.PalletNo == item.PalletNo);
			if (taskNo == null)
			{
			taskNo = logTaskList.FirstOrDefault(m => m.PalletNo == item.PalletNo);//当前有同托盘不同物料出库
			}
			if (taskNo == null)
			{
			throw new Exception($"托盘号：{item.PalletNo},出库异常");
			}
			item.TaskNo = taskNo.TaskNo;
			item.Status = "1"; // 出库分配信息状态改为正在执行
			item.OutMode = item.OutMode;//出库口
			//item.UnstackingMode = unstackingMode2;//拆垛模式
			Db.Updateable(item).ExecuteCommand();

			#endregion
			}
			else if (locate.Status == "5") //移出中
			{
			str = "当前要出库的储位正在移出";
			return outDto1;
			}


			//添加操作日志记录
			var k = new OperationSOServer().AddLogOperationSo("PDA模块", "下发出库", soNo, "出库", $"点击出库按钮出库单号为：{soNo}的出库单", userId);
			Db.CommitTran();

			if (outDto1.Count > 0)
			{
			// 正式运行程序放开
			var list2 = outDto1.Select(m => m.TaskNo).ToList();
			var jsonData = JsonConvert.SerializeObject(outDto1);
			string response = "";

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

			//解析返回数据
			var wcsModel = JsonConvert.DeserializeObject<WcsModel2>(response);
			if (wcsModel.code == 200)
			{
			//更改任务的发送返回时间//
			new TaskServer().EditTaskIssueOk(list2, time1, time2);
			str = "下发成功";
			}
			else
			{
			new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.message);
			throw new Exception(wcsModel.message);
			}
			}
			catch (Exception ex)
			{
			throw new Exception(ex.Message);
			}

			}

			return outDto1;
			}
			catch (Exception e)
			{
			Db.RollbackTran();
			throw new Exception(e.Message);
			}


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


			#region MyRegion