ZhiHuiQiCe/FangCangZhiNeng.git

			@@ -3,8 +3,11 @@
			using System.Linq;
			using System.Text;
			using System.Threading.Tasks;
			using WIDESEA_Common;
			using WIDESEA_Common.OrderEnum;
			using WIDESEA_Common.StockEnum;
			using WIDESEA_Common.TaskEnum;
			using WIDESEA_Common.WareHouseEnum;
			using WIDESEA_Core;
			using WIDESEA_Core.Enums;
			using WIDESEA_Core.Helper;
			@@ -27,23 +30,37 @@
			try
			{
			List<Dt_DeliveryOrder> deliveryOrders = new List<Dt_DeliveryOrder>();
			List<Dt_SupplyTask> supplyTasks = new List<Dt_SupplyTask>();
			//List<Dt_SupplyTask> supplyTasks = new List<Dt_SupplyTask>();
			List<Dt_SupplyTask> supplyTasks1 = new List<Dt_SupplyTask>();
			List<Dt_InventoryInfo> _InventoryInfos = new List<Dt_InventoryInfo>();
			List<Dt_Inventory_Batch> inventory_Batches = _inventory_BatchServices.Repository.QueryData(x => keys.Contains(x.Id));
			foreach (var item in inventory_Batches)
			{
			var supplyTasks = _supplyTaskService.Repository.QueryData(x => x.MaterielCode == item.MaterielCode && x.BatchNo == item.BatchNo && x.TaskStatus == SupplyStatusEnum.NewCheck.ObjToInt()).ToList();
			if (item.SupplyQuantity != 0) throw new Exception($"ç©æç¼å·ã{item.MaterielCode}ãæ¹æ¬¡å·ã{item.BatchNo}ãå·²åå¨çç¹å·®å¼!");
			if (supplyTasks.Count > 0) throw new Exception($"ç©æç¼å·ã{item.MaterielCode}ãæ¹æ¬¡å·ã{item.BatchNo}ãå·²åå¨çç¹ä»»å¡ï¼è¯·åå®æå½åçç¹ä»»å¡");
			supplyTasks = _supplyTaskService.Repository.QueryData(x => x.MaterielCode == item.MaterielCode && x.BatchNo == item.BatchNo && x.TaskStatus == SupplyStatusEnum.NewOut.ObjToInt()).ToList();
			if (supplyTasks.Count > 0) throw new Exception($"ç©æç¼å·ã{item.MaterielCode}ãæ¹æ¬¡å·ã{item.BatchNo}ãå·²åå¨åºåºä»»å¡ï¼è¯·åå®æå½ååºåºä»»å¡");
			List<Dt_InventoryInfo> inventoryInfos = _inventoryInfoService.Repository.QueryData(x => item.MaterielCode == x.MaterielCode && x.BatchNo == item.BatchNo);
			if (inventoryInfos.Count > 0)
			{
			foreach (var items in inventoryInfos.GroupBy(x => x.WarehouseCode))
			{
			Dt_DeliveryOrder deliveryOrder = new Dt_DeliveryOrder()
			Dt_DeliveryOrder? deliveryOrder = deliveryOrders.Where(x => x.Warehouse_no == items.Key).FirstOrDefault();
			bool isNull = false;
			if (deliveryOrder == null)
			{
			Out_no = item.MaterielCode + "_" + item.BatchNo,
			Out_type = "3",
			OutStatus = "æ°å»º",
			Warehouse_no = items.Key,
			Details = new List<Dt_DeliveryOrderDetail>()
			};
			isNull = true;
			deliveryOrder = new Dt_DeliveryOrder()
			{
			//Out_no = item.MaterielCode + "_" + item.BatchNo,
			Out_no = $"PD{items.Key}{DateTime.Now.ToString("yyMMddHHmmss")}",
			Out_type = "20",
			OutStatus = "æ°å»º",
			Warehouse_no = items.Key,
			Details = new List<Dt_DeliveryOrderDetail>()
			};
			}
			var Status = items.Key == "001" ? 0 : 2;//å¤ææ¯å¦ä¸ºç«åºåºå
			Dt_DeliveryOrderDetail deliveryOrderDetail = new Dt_DeliveryOrderDetail()
			{
			@@ -58,38 +75,42 @@
			Reservoirarea = items.Key
			};
			deliveryOrder.Details.Add(deliveryOrderDetail);
			deliveryOrders.Add(deliveryOrder);
			if (isNull) deliveryOrders.Add(deliveryOrder);
			#region åå»ºçç¹ä»»å¡
			if (items.Key != "001")
			foreach (var inventory in items)
			{
			foreach (var inventory in items)
			Dt_SupplyTask supplyTask = new Dt_SupplyTask()
			{
			Dt_SupplyTask supplyTask = new Dt_SupplyTask()
			{
			WarehouseCode = inventory.WarehouseCode,
			TaskStatus = SupplyStatusEnum.NewCheck.ObjToInt(),
			BatchNo = inventory.BatchNo,
			MaterielName = inventory.MaterielName,
			MaterielCode = inventory.MaterielCode,
			MaterielSpec = inventory.MaterielSpec,
			TaskType = TaskTypeEnum.OutInventory.ObjToInt(),
			CreateDate = DateTime.Now,
			Creater = App.User.UserName,
			LocationCode = inventory.LocationCode,
			OrderNo = deliveryOrder.Out_no,
			StockQuantity = inventory.StockQuantity,
			SupplyQuantity = 0,
			Remark = "çç¹"
			};
			supplyTasks.Add(supplyTask);
			}
			WarehouseCode = inventory.WarehouseCode,
			TaskStatus = SupplyStatusEnum.NewCheck.ObjToInt(),
			BatchNo = inventory.BatchNo,
			MaterielName = inventory.MaterielName,
			MaterielCode = inventory.MaterielCode,
			MaterielSpec = inventory.MaterielSpec,
			TaskType = TaskTypeEnum.OutInventory.ObjToInt(),
			CreateDate = DateTime.Now,
			Creater = App.User.UserName,
			LocationCode = inventory.LocationCode,
			OrderNo = deliveryOrder.Out_no,
			StockQuantity = inventory.StockQuantity,
			SupplyQuantity = 0,
			Remark = "çç¹"
			};
			supplyTasks1.Add(supplyTask);
			_InventoryInfos.Add(inventory);
			}
			//}
			#endregion
			}
			}
			}
			_InventoryInfos.ForEach(x =>
			{
			x.StockStatus = StockStatusEmun.çç¹éå®.ObjToInt();
			});
			_unitOfWorkManage.BeginTran();
			_supplyTaskService.AddData(supplyTasks);
			_inventoryInfoService.UpdateData(_InventoryInfos);
			_supplyTaskService.AddData(supplyTasks1);
			BaseDal.Db.InsertNav(deliveryOrders)
			.Include(x => x.Details)
			.ExecuteCommand();
			@@ -104,9 +125,6 @@
			return content;
			}
			#endregion




			#region æ¥è¯¢çç¹åä¿¡æ¯
			/// <summary>
			@@ -125,11 +143,11 @@
			List<Dt_DeliveryOrder> dt_ReceiveOrders = new List<Dt_DeliveryOrder>();
			if (string.IsNullOrEmpty(orderNo))
			{
			dt_ReceiveOrders = Db.Queryable<Dt_DeliveryOrder>().Where(x => (x.OutStatus == "æ°å»º" \|\| x.OutStatus == "å¼å§") && x.Warehouse_no == warehouseCode && x.Out_type == "3").Includes(x => x.Details).OrderByDescending(x => x.CreateDate).ToPageList(pageNo, 5);
			dt_ReceiveOrders = Db.Queryable<Dt_DeliveryOrder>().Where(x => (x.OutStatus == "æ°å»º" \|\| x.OutStatus == "å¼å§") && x.Warehouse_no == warehouseCode && x.Out_type == "20").Includes(x => x.Details).OrderByDescending(x => x.CreateDate).ToPageList(pageNo, 5);
			}
			else
			{
			dt_ReceiveOrders = Db.Queryable<Dt_DeliveryOrder>().Where(x => (x.Out_no.Contains(orderNo) \|\| x.Client_no.Contains(orderNo)) && (x.OutStatus == "æ°å»º" \|\| x.OutStatus == "å¼å§") && x.Out_type == "3" && x.Warehouse_no == warehouseCode).OrderByDescending(x => x.CreateDate).Includes(x => x.Details).ToPageList(pageNo, 5);
			dt_ReceiveOrders = Db.Queryable<Dt_DeliveryOrder>().Where(x => (x.Out_no.Contains(orderNo) \|\| x.Client_no.Contains(orderNo)) && (x.OutStatus == "æ°å»º" \|\| x.OutStatus == "å¼å§") && x.Out_type == "20" && x.Warehouse_no == warehouseCode).OrderByDescending(x => x.CreateDate).Includes(x => x.Details).ToPageList(pageNo, 5);
			}

			content.OK(data: dt_ReceiveOrders);
			@@ -142,6 +160,7 @@
			return content;
			}
			#endregion

			#region æ¥æ¾çç¹/åºåºä»»å¡
			/// <summary>
			/// æ¥æ¾çç¹/åºåºä»»å¡
			@@ -163,11 +182,11 @@
			if (string.IsNullOrEmpty(LocationCode))
			{
			supplyTasks = Db.Queryable<Dt_SupplyTask>().Where(x => x.TaskStatus == TaskStatus && x.OrderNo == orderNo && x.WarehouseCode == warehouseCode).ToPageList(pageNo, 5);
			}
			}
			else
			{
			supplyTasks = Db.Queryable<Dt_SupplyTask>().Where(x => x.TaskStatus == TaskStatus && x.OrderNo == orderNo && x.WarehouseCode == warehouseCode && x.LocationCode.Contains(LocationCode)).ToPageList(pageNo, 5);
			}
			}
			content.OK(data: supplyTasks);
			}
			catch (Exception ex)
			@@ -178,6 +197,7 @@
			}

			#endregion

			#region å®æçç¹ä»»å¡
			public WebResponseContent CheckFinish(SaveModel saveModel)
			{
			@@ -191,63 +211,161 @@
			if (supplyTask == null) throw new Exception("å½åçç¹ä»»å¡å·²å®æ");
			if (supplyTask.LocationCode != LocationCode) throw new Exception($"å½åçç¹è´§ä½ã{LocationCode}ãä¸ä»»å¡åéè´§ä½ä¸å¹é");
			supplyTask.SupplyQuantity = qty;
			content = CheckTaskFinish(supplyTask, LocationCode);
			}
			catch (Exception ex)
			{
			content.Error(ex.Message);
			}
			return content;
			}
			#endregion

			#region çç¹ä»»å¡å®æ,å¹³åºåç«åº
			public WebResponseContent CheckTaskFinish(Dt_SupplyTask supplyTask, string LocationCode = null)
			{
			WebResponseContent content = new WebResponseContent();
			try
			{
			supplyTask.TaskStatus = SupplyStatusEnum.CheckFinish.ObjToInt();
			Dt_DeliveryOrder cabinOrder = BaseDal.Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == supplyTask.OrderNo && x.Warehouse_no == supplyTask.WarehouseCode && x.Out_type == "3").Includes(x => x.Details).First();
			Dt_DeliveryOrder cabinOrder = BaseDal.Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == supplyTask.OrderNo && x.Warehouse_no == supplyTask.WarehouseCode && x.Out_type == "20").Includes(x => x.Details).First();
			if (cabinOrder == null) return WebResponseContent.Instance.Error($"çç¹åå·²å®æ");
			Dt_DeliveryOrderDetail cabinOrderDetail = cabinOrder.Details.Where(x => x.Batch_num == supplyTask.BatchNo && x.Reservoirarea == supplyTask.WarehouseCode && x.Goods_no == supplyTask.MaterielCode).First();
			if (cabinOrderDetail == null) return WebResponseContent.Instance.Error($"çç¹åæç»å·²å®æ");
			Dt_MaterielInfo materielInfo = _basicService.MaterielInfoService.Repository.QueryFirst(x => x.MaterielCode == cabinOrderDetail.Goods_no);
			Dt_MaterielInfo materielInfo = _materielInfoService.Repository.QueryFirst(x => x.MaterielCode == cabinOrderDetail.Goods_no);
			if (materielInfo == null) return WebResponseContent.Instance.Error($"è¯·ç»´æ¤ç©æç¼å·ã{cabinOrderDetail.Goods_no}ãçç©æä¿¡æ¯");
			cabinOrderDetail.Order_Outqty += supplyTask.SupplyQuantity;
			if (cabinOrderDetail.Order_Outqty > cabinOrderDetail.Order_qty)
			return WebResponseContent.Instance.Error($"å®çæ°éä¸å¯è¶åºè´¦é¢æ°é");
			#region å¹³åºçç¹åªè½åºç°æ´ç®±å·®å¼
			if (supplyTask.WarehouseCode == WarehouseEnum.å¤§ä»¶åº.ObjToInt().ToString("000") && materielInfo.MaterielSourceType != MaterielSourceTypeEnum.PurchasePart)
			{
			var Qty = supplyTask.SupplyQuantity % materielInfo.BoxQty;
			if (Qty != 0) return WebResponseContent.Instance.Error($"å¤§ä»¶åºåºåä¸ºæ´ç®±ï¼çç¹æ°éä¸è½åå¨æ£ä»¶");
			}
			#endregion

			#region å¤çåºåºåï¼è´§ä½ï¼åºåï¼åºåæ¹æ¬¡ä¿¡æ¯
			_unitOfWorkManage.BeginTran();

			#region åºåºå
			#region ä¿®æ¹çç¹å
			cabinOrder.OutStatus = "å¼å§";
			cabinOrderDetail.OotDetailStatus = "å¼å§";
			if (cabinOrderDetail.Order_Outqty == cabinOrderDetail.Order_qty)
			{
			cabinOrderDetail.OotDetailStatus = "å·²å®æ";
			_deliveryOrderDetailServices.Repository.DeleteAndMoveIntoHty(cabinOrderDetail, OperateTypeEnum.èªå¨å®æ);
			}
			else
			{
			_deliveryOrderDetailServices.Repository.UpdateData(cabinOrderDetail);
			}
			var cabinOrder1 = BaseDal.Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == cabinOrder.Out_no && x.Out_type == "3").Includes(x => x.Details).First();
			if (cabinOrder1.Details == null \|\| cabinOrder1.Details.Count < 1) cabinOrder.OutStatus = "å·²å®æ";
			if (cabinOrder.OutStatus == "å·²å®æ")
			Repository.DeleteAndMoveIntoHty(cabinOrder, OperateTypeEnum.èªå¨å®æ);
			else
			Repository.UpdateData(cabinOrder);
			#endregion

			#region åºå
			Dt_InventoryInfo inventoryInfo = _inventoryInfoService.Repository.QueryFirst(x => x.BatchNo == cabinOrderDetail.Batch_num && x.MaterielCode == cabinOrderDetail.Goods_no && x.LocationCode == LocationCode);
			if (inventoryInfo == null) return WebResponseContent.Instance.Error($"æªæ¾å°è´§ä½ã{LocationCode}ãçåºåä¿¡æ¯");
			inventoryInfo.StockQuantity = supplyTask.SupplyQuantity;
			_inventoryInfoService.UpdateData(inventoryInfo);
			#endregion

			#region ä»»å¡è®°å½
			_supplyTaskService.UpdateData(supplyTask);
			#endregion

			#region åºåæ¹æ¬¡
			Dt_Inventory_Batch inventory_Batch = _inventory_BatchServices.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo && x.MaterielCode == inventoryInfo.MaterielCode);
			if (inventory_Batch != null)
			List<Dt_Inventory_Batch> inventory_Batchs = _inventory_BatchServices.Repository.QueryData(x => cabinOrder.Details.Select(x => x.Goods_no).Contains(x.MaterielCode));
			List<Dt_InventoryInfo> inventoryInfos = _inventoryInfoService.Repository.QueryData(x => cabinOrder.Details.Select(x => x.Goods_no).Contains(x.MaterielCode) && x.WarehouseCode == supplyTask.WarehouseCode && x.StockStatus == StockStatusEmun.çç¹éå®.ObjToInt());
			Dt_InventoryInfo? inventoryInfo = new();
			List<Dt_InventoryInfo> inventoryInfosDel = new List<Dt_InventoryInfo>();
			if (supplyTask.WarehouseCode != WarehouseEnum.ç«åº.ObjToInt().ToString("000"))
			{
			inventory_Batch.SupplyQuantity += supplyTask.SupplyQuantity;
			_inventory_BatchServices.UpdateData(inventory_Batch);
			inventoryInfo = inventoryInfos.FirstOrDefault(x => x.BatchNo == cabinOrderDetail.Batch_num && x.MaterielCode == cabinOrderDetail.Goods_no && x.LocationCode == supplyTask.LocationCode);
			if (inventoryInfo == null) return WebResponseContent.Instance.Error($"æªæ¾å°è´§ä½ã{LocationCode}ãçåºåä¿¡æ¯");
			}
			else
			{
			inventoryInfo = inventoryInfos.FirstOrDefault(x => x.BatchNo == cabinOrderDetail.Batch_num && x.MaterielCode == cabinOrderDetail.Goods_no);
			}
			if (inventoryInfo == null) return WebResponseContent.Instance.Error($"æªæ¾å°ç«åºçåºåä¿¡æ¯");
			inventoryInfo.SupplyQuantity = supplyTask.SupplyQuantity - inventoryInfo.StockQuantity;
			#endregion

			List<Dt_SupplyTask> supplyTasks = _supplyTaskService.Repository.QueryData(x => x.OrderNo == supplyTask.OrderNo && x.TaskStatus == SupplyStatusEnum.NewCheck.ObjToInt() && x.TaskId != supplyTask.TaskId).ToList();//æ¥æ¾å½åçç¹åççç¹ä»»å¡
			if (!supplyTasks.Where(x => cabinOrderDetail.Goods_no == x.MaterielCode && x.BatchNo == cabinOrderDetail.Batch_num).Any())
			cabinOrderDetail.OotDetailStatus = "å·²å®æ";
			#region å¤æå½åçç¹åä»»å¡æ¯å¦å¨é¨å®æ
			if (supplyTasks.Count < 1)
			{
			#region å¤çå½åç©ææ¹æ¬¡çåºååæ¹æ¬¡ä¿¡æ¯
			Dt_Inventory_Batch inventory_Batch = inventory_Batchs.First(x => x.BatchNo == inventoryInfo.BatchNo && x.MaterielCode == inventoryInfo.MaterielCode);
			var SupplyQuantitys = inventoryInfos.Where(x => x.BatchNo == inventoryInfo.BatchNo && x.MaterielCode == inventoryInfo.MaterielCode).Sum(x => x.SupplyQuantity);
			if (SupplyQuantitys == 0)
			{
			foreach (var item in inventoryInfos.Where(x => x.BatchNo == inventoryInfo.BatchNo && x.MaterielCode == inventoryInfo.MaterielCode))
			{
			item.StockQuantity += item.SupplyQuantity;
			if (item.StockQuantity <= 0)
			{
			inventoryInfosDel.Add(item);
			continue;
			}
			item.AvailableQuantity = item.StockQuantity;
			item.SupplyQuantity = 0;
			item.StockStatus = StockStatusEmun.å¥åºå®æ.ObjToInt();
			}
			//inventoryInfo.StockQuantity += inventoryInfo.SupplyQuantity;
			//if (inventoryInfo.StockQuantity <= 0)
			//{
			// inventoryInfosDel.Add(inventoryInfo);
			// inventoryInfo = null;
			//}
			//else
			//{
			// inventoryInfo.AvailableQuantity = inventoryInfo.StockQuantity;
			// inventoryInfo.SupplyQuantity = 0;
			// inventoryInfo.StockStatus = StockStatusEmun.å¥åºå®æ.ObjToInt();
			//}
			}
			else
			{
			inventory_Batch.SupplyQuantity += SupplyQuantitys;
			}
			#endregion

			#region å¤çå¶ä»åºåæ¹æ¬¡ååºå
			foreach (var detail in cabinOrder.Details.Where(x => x.Id != cabinOrderDetail.Id))
			{
			SupplyQuantitys = inventoryInfos.Where(x => x.BatchNo == detail.Batch_num && x.MaterielCode == detail.Goods_no).Sum(x => x.SupplyQuantity);//è®¡ç®çç¹æ»æ°
			inventory_Batch = inventory_Batchs.First(x => x.BatchNo == detail.Batch_num && x.MaterielCode == detail.Goods_no);
			#region åºåæ¹æ¬¡
			if (SupplyQuantitys == 0)
			{
			foreach (var item in inventoryInfos.Where(x => x.BatchNo == detail.Batch_num && x.MaterielCode == detail.Goods_no))
			{
			item.StockQuantity += item.SupplyQuantity;
			if (item.StockQuantity <= 0)
			{
			inventoryInfosDel.Add(item);
			continue;
			}
			item.AvailableQuantity = item.StockQuantity;
			item.SupplyQuantity = 0;
			item.StockStatus = StockStatusEmun.å¥åºå®æ.ObjToInt();
			}
			}
			else
			{
			inventory_Batch.SupplyQuantity += SupplyQuantitys;
			}
			#endregion
			}
			#endregion
			}
			#endregion
			_unitOfWorkManage.BeginTran();
			#region å¤ççç¹å
			if (supplyTasks.Count < 1)
			{
			#region å®æçç¹å
			cabinOrder.OutStatus = "å·²å®æ";
			cabinOrder.Details.ForEach(x =>
			{
			x.OotDetailStatus = "å·²å®æ";
			});
			_deliveryOrderDetailServices.Repository.DeleteAndMoveIntoHty(cabinOrder.Details, OperateTypeEnum.èªå¨å®æ);
			cabinOrder.Details = null;
			BaseDal.DeleteAndMoveIntoHty(cabinOrder, OperateTypeEnum.èªå¨å®æ);

			_unitOfWorkManage.CommitTran();
			#endregion
			}
			else
			{
			BaseDal.UpdateData(cabinOrder);
			_deliveryOrderDetailServices.Repository.UpdateData(cabinOrderDetail);
			}
			#endregion

			//_inventoryInfoService.UpdateData(inventoryInfo);
			_supplyTaskService.Repository.DeleteAndMoveIntoHty(supplyTask, OperateTypeEnum.èªå¨å®æ);
			_inventoryInfoService.UpdateData(inventoryInfos);
			if (inventoryInfosDel.Count > 0) _inventoryInfoService.DeleteData(inventoryInfosDel);
			_inventory_BatchServices.UpdateData(inventory_Batchs);
			_unitOfWorkManage.CommitTran();
			content.OK();
			}
			catch (Exception ex)