ZhiHuiQiCe/FangCangZhiNeng.git

			@@ -101,7 +101,7 @@
			{
			return new ApiResponse<Dt_InventoryInfo> { code = "500", msg = "è¯·æ±åæ°æ æ" };
			}

			var reslut = WarehouseEnum.ç«åº.ObjToInt().ToString("000");
			// 2ï¸â£ å¼å¯äºå¡
			BaseDal.Db.Ado.BeginTran();
			foreach (var detail in request.details)
			@@ -122,154 +122,260 @@
			case "1": //å¥åº
			{
			#region å¤çå¥åºè®¢å
			var reslut = WarehouseEnum.ç«åº.ObjToInt().ToString("000");
			Dt_CabinOrder cabinOrder = Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == request.orderNo && x.Warehouse_no ==reslut).Includes(x => x.Details).First();
			//Dt_CabinOrder cabinOrder = Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == request.orderNo && x.Warehouse_no == "001").Includes(x => x.Details).First();
			if (cabinOrder == null \|\| cabinOrder.OdrderStatus == "å·²å®æ")
			throw new Exception($"å¥åºåå·²å®æ");
			Dt_CabinOrderDetail cabinOrderDetail = cabinOrder.Details.Where(x => x.Goods_no == detail.productCode && x.Batch_num == detail.batchNo && x.Status == 1).First();
			if (cabinOrderDetail == null \|\| cabinOrderDetail.OrderDetailStatus == "å·²å®æ")
			throw new Exception($"å¥åºåæç»å·²å®æ");
			cabinOrderDetail.Order_Inqty += orderQty;
			if (cabinOrderDetail.Order_Inqty > cabinOrderDetail.Order_qty)
			throw new Exception($"å¥åºæ°éä¸å¯è¶åºåæ®æ°é");
			cabinOrder.OdrderStatus = "å¼å§";
			cabinOrderDetail.OrderDetailStatus = "å¼å§";
			if (cabinOrderDetail.Order_Inqty == cabinOrderDetail.Order_qty)
			cabinOrderDetail.OrderDetailStatus = "å·²å®æ";
			BaseDal.Db.Updateable(cabinOrderDetail).ExecuteCommand();
			var cabinOrder1 = BaseDal.Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == cabinOrder.Order_no && x.Warehouse_no == reslut).Includes(x => x.Details).First();
			if (!cabinOrder1.Details.Where(x => x.OrderDetailStatus != "å·²å®æ").Any())
			cabinOrder.OdrderStatus = "å·²å®æ";
			BaseDal.Db.Updateable(cabinOrder).ExecuteCommand();
			#endregion

			#region åå»ºåºåä¿¡æ¯
			// 5ï¸â£ æ¥è¯¢åºåè¯¦æ
			var inventoryInfo = BaseDal.Db.Queryable<Dt_InventoryInfo>()
			.First(x => x.MaterielCode == cabinOrderDetail.Goods_no && x.BatchNo == cabinOrderDetail.Batch_num && x.LocationCode == "ç«åº");
			if (inventoryInfo != null)
			Dt_CabinOrder cabinOrder = Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == request.orderNo && x.Warehouse_no == reslut).Includes(x => x.Details).First();
			#region å¤ææ¯å¦ä¸ºççå¥åºå
			if (cabinOrder.Order_type == "5")
			{
			inventoryInfo.StockQuantity += orderQty;
			inventoryInfo.AvailableQuantity += orderQty;
			inventoryInfo.InDate = DateTime.Now;
			BaseDal.Db.Updateable(inventoryInfo).ExecuteCommand();
			}
			else
			{
			inventoryInfo = new Dt_InventoryInfo
			foreach (var item in cabinOrder.Details)
			{
			PalletCode = detail.orderDetails?.FirstOrDefault()?.palletCode ?? "",
			WarehouseCode = "001",
			LocationCode = "ç«åº",
			StockStatus = StockStatusEmun.å¥åºå®æ.ObjToInt(),
			MaterielCode = goods.MaterielCode,
			MaterielName = goods.MaterielName,
			MaterielSpec = goods.MaterielSpec,
			BatchNo = detail.batchNo,
			StockQuantity = orderQty,
			OutboundQuantity = 0,
			SupplyQuantity = 0,
			AvailableQuantity = orderQty,
			InDate = DateTime.Now,
			ProductionDate = detail.finishDate.ToString("yyyy-MM-dd"),
			ShelfLife = 0,
			ValidityPeriod = cabinOrderDetail.Exp_date,
			Remark = "WCSåä¼ åå»º"
			};
			BaseDal.Db.Insertable(inventoryInfo).ExecuteCommand();
			Dt_InventoryInfo inventoryInfo = BaseDal.Db.Queryable<Dt_InventoryInfo>()
			.First(x => x.MaterielCode == item.Goods_no && x.BatchNo == item.Batch_num && x.LocationCode == reslut);
			var qty = inventoryInfo.SupplyQuantity - inventoryInfo.StockQuantity;
			if (orderQty != qty)
			throw new Exception($"ççå¥åºæ°éä¸ä¸è´,ä¸ä¼ æ°éã{orderQty}ã,åºåççæ°éã{qty}ã");
			inventoryInfo.StockQuantity = inventoryInfo.SupplyQuantity;
			inventoryInfo.SupplyQuantity = 0;
			inventoryInfo.StockStatus = StockStatusEmun.å¥åºå®æ.ObjToInt();
			#region æ·»å ççå¥åºä»»å¡
			Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty()
			{
			WarehouseCode = inventoryInfo.WarehouseCode,
			OperateType = OperateTypeEnum.èªå¨å®æ.ToString(),
			InsertTime = DateTime.Now,
			TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(),
			BatchNo = inventoryInfo.BatchNo,
			MaterielName = inventoryInfo.MaterielName,
			MaterielCode = inventoryInfo.MaterielCode,
			MaterielSpec = inventoryInfo.MaterielSpec,
			TaskType = TaskTypeEnum.ChenckIn.ObjToInt(),
			CreateDate = DateTime.Now,
			Creater = App.User.UserName,
			LocationCode = inventoryInfo.LocationCode,
			OrderNo = cabinOrder.Order_no,
			StockQuantity = orderQty,
			SupplyQuantity = 0,
			Remark = "ççå¥åº"
			};
			#endregion
			var inventory_Batch = BaseDal.Db.Queryable<Dt_Inventory_Batch>()
			.First(x => x.MaterielCode == inventoryInfo.MaterielCode && x.BatchNo == inventoryInfo.BatchNo);
			inventory_Batch.StockQuantity = inventory_Batch.SupplyQuantity;
			inventory_Batch.SupplyQuantity = 0;
			item.OrderDetailStatus = "å·²å®æ";
			BaseDal.Db.Updateable(item).ExecuteCommand();
			BaseDal.Db.Updateable(inventoryInfo).ExecuteCommand();
			BaseDal.Db.Updateable(inventory_Batch).ExecuteCommand();
			BaseDal.Db.Insertable(supplyTask_Hty).ExecuteCommand();
			}
			var cabinOrder1 = BaseDal.Db.Queryable<Dt_CabinOrder>().Where(x => x.Id == cabinOrder.Id).Includes(x => x.Details).First();
			if (!cabinOrder1.Details.Where(x => x.OrderDetailStatus != "å·²å®æ").Any())
			cabinOrder.OdrderStatus = "å·²å®æ";
			BaseDal.Db.Updateable(cabinOrder).ExecuteCommand();
			}
			#endregion

			#region åå»ºåºåæ¹æ¬¡ä¿¡æ¯
			// 6ï¸â£ æ¥è¯¢åºåæ¹æ¬¡ä¿¡æ¯
			var inventory_Batch = BaseDal.Db.Queryable<Dt_Inventory_Batch>()
			.First(x => x.MaterielCode == inventoryInfo.MaterielCode && x.BatchNo == inventoryInfo.BatchNo);

			if (inventory_Batch != null)
			{
			inventory_Batch.StockQuantity += orderQty;
			inventory_Batch.AvailableQuantity += orderQty;
			BaseDal.Db.Updateable(inventory_Batch).ExecuteCommand();
			}
			else
			{
			inventory_Batch = new Dt_Inventory_Batch
			if (cabinOrder == null \|\| cabinOrder.OdrderStatus == "å·²å®æ")
			throw new Exception($"å¥åºåå·²å®æ");
			Dt_CabinOrderDetail cabinOrderDetail = cabinOrder.Details.Where(x => x.Goods_no == detail.productCode && x.Batch_num == detail.batchNo && x.Status == 1).First();
			if (cabinOrderDetail == null \|\| cabinOrderDetail.OrderDetailStatus == "å·²å®æ")
			throw new Exception($"å¥åºåæç»å·²å®æ");
			cabinOrderDetail.Order_Inqty += orderQty;
			if (cabinOrderDetail.Order_Inqty > cabinOrderDetail.Order_qty)
			throw new Exception($"å¥åºæ°éä¸å¯è¶åºåæ®æ°é");
			cabinOrder.OdrderStatus = "å¼å§";
			cabinOrderDetail.OrderDetailStatus = "å¼å§";
			if (cabinOrderDetail.Order_Inqty == cabinOrderDetail.Order_qty)
			cabinOrderDetail.OrderDetailStatus = "å·²å®æ";
			BaseDal.Db.Updateable(cabinOrderDetail).ExecuteCommand();
			var cabinOrder1 = BaseDal.Db.Queryable<Dt_CabinOrder>().Where(x => x.Order_no == cabinOrder.Order_no && x.Warehouse_no == reslut).Includes(x => x.Details).First();
			if (!cabinOrder1.Details.Where(x => x.OrderDetailStatus != "å·²å®æ").Any())
			cabinOrder.OdrderStatus = "å·²å®æ";
			BaseDal.Db.Updateable(cabinOrder).ExecuteCommand();
			#endregion

			#region åå»ºåºåä¿¡æ¯
			// 5ï¸â£ æ¥è¯¢åºåè¯¦æ
			var inventoryInfo = BaseDal.Db.Queryable<Dt_InventoryInfo>()
			.First(x => x.MaterielCode == cabinOrderDetail.Goods_no && x.BatchNo == cabinOrderDetail.Batch_num && x.LocationCode == "ç«åº");
			if (inventoryInfo != null)
			{
			MaterielCode = inventoryInfo.MaterielCode,
			MaterielName = inventoryInfo.MaterielName,
			MaterielSpec = inventoryInfo.MaterielSpec,
			inventoryInfo.StockQuantity += orderQty;
			inventoryInfo.AvailableQuantity += orderQty;
			inventoryInfo.InDate = DateTime.Now;
			BaseDal.Db.Updateable(inventoryInfo).ExecuteCommand();
			}
			else
			{
			inventoryInfo = new Dt_InventoryInfo
			{
			PalletCode = detail.orderDetails?.FirstOrDefault()?.palletCode ?? "",
			WarehouseCode = "001",
			LocationCode = "ç«åº",
			StockStatus = StockStatusEmun.å¥åºå®æ.ObjToInt(),
			MaterielCode = goods.MaterielCode,
			MaterielName = goods.MaterielName,
			MaterielSpec = goods.MaterielSpec,
			BatchNo = detail.batchNo,
			StockQuantity = orderQty,
			OutboundQuantity = 0,
			SupplyQuantity = 0,
			AvailableQuantity = orderQty,
			InDate = DateTime.Now,
			ProductionDate = detail.finishDate.ToString("yyyy-MM-dd"),
			ShelfLife = 0,
			ValidityPeriod = cabinOrderDetail.Exp_date,
			Remark = "WCSåä¼ åå»º"
			};
			BaseDal.Db.Insertable(inventoryInfo).ExecuteCommand();
			}
			#endregion

			#region åå»ºåºåæ¹æ¬¡ä¿¡æ¯
			// 6ï¸â£ æ¥è¯¢åºåæ¹æ¬¡ä¿¡æ¯
			var inventory_Batch = BaseDal.Db.Queryable<Dt_Inventory_Batch>()
			.First(x => x.MaterielCode == inventoryInfo.MaterielCode && x.BatchNo == inventoryInfo.BatchNo);

			if (inventory_Batch != null)
			{
			inventory_Batch.StockQuantity += orderQty;
			inventory_Batch.AvailableQuantity += orderQty;
			BaseDal.Db.Updateable(inventory_Batch).ExecuteCommand();
			}
			else
			{
			inventory_Batch = new Dt_Inventory_Batch
			{
			MaterielCode = inventoryInfo.MaterielCode,
			MaterielName = inventoryInfo.MaterielName,
			MaterielSpec = inventoryInfo.MaterielSpec,
			BatchNo = inventoryInfo.BatchNo,
			StockQuantity = inventoryInfo.StockQuantity,
			OutboundQuantity = inventoryInfo.OutboundQuantity,
			AvailableQuantity = inventoryInfo.AvailableQuantity,
			SupplyQuantity = inventoryInfo.SupplyQuantity,
			ERPStockQuantity = 0,
			Status = false,
			ProductionDate = detail.finishDate.ToString("yyyy-MM-dd"),
			ValidityPeriod = inventoryInfo.ValidityPeriod,
			Remark = "èªå¨åå»º"
			};
			BaseDal.Db.Insertable(inventory_Batch).ExecuteCommand();
			}
			#endregion

			#region æ·»å å¥åºä»»å¡åå²
			Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty()
			{
			WarehouseCode = inventoryInfo.WarehouseCode,
			TaskNum = cabinOrderDetail.Id,
			OperateType = OperateTypeEnum.èªå¨å®æ.ToString(),
			InsertTime = DateTime.Now,
			TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(),
			BatchNo = inventoryInfo.BatchNo,
			StockQuantity = inventoryInfo.StockQuantity,
			OutboundQuantity = inventoryInfo.OutboundQuantity,
			AvailableQuantity = inventoryInfo.AvailableQuantity,
			SupplyQuantity = inventoryInfo.SupplyQuantity,
			ERPStockQuantity = 0,
			Status = false,
			ProductionDate = detail.finishDate.ToString("yyyy-MM-dd"),
			ValidityPeriod = inventoryInfo.ValidityPeriod,
			Remark = "èªå¨åå»º"
			MaterielName = inventoryInfo.MaterielName,
			MaterielCode = inventoryInfo.MaterielCode,
			MaterielSpec = inventoryInfo.MaterielSpec,
			TaskType = cabinOrder.Order_type == "1" ? TaskTypeEnum.In.ObjToInt() : TaskTypeEnum.OutReturn.ObjToInt(),
			CreateDate = DateTime.Now,
			Creater = App.User.UserName,
			LocationCode = inventoryInfo.LocationCode,
			OrderNo = cabinOrder.Order_no,
			StockQuantity = orderQty,
			SupplyQuantity = 0,
			Remark = "å¥åº"
			};
			BaseDal.Db.Insertable(inventory_Batch).ExecuteCommand();
			BaseDal.Db.Insertable(supplyTask_Hty).ExecuteCommand();
			#endregion
			}
			#endregion

			#region æ·»å å¥åºä»»å¡åå²
			Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty()
			{
			WarehouseCode = inventoryInfo.WarehouseCode,
			TaskNum = cabinOrderDetail.Id,
			OperateType = OperateTypeEnum.èªå¨å®æ.ToString(),
			InsertTime = DateTime.Now,
			TaskStatus = SupplyStatusEnum.InFinish.ObjToInt(),
			BatchNo = inventoryInfo.BatchNo,
			MaterielName = inventoryInfo.MaterielName,
			MaterielCode = inventoryInfo.MaterielCode,
			MaterielSpec = inventoryInfo.MaterielSpec,
			TaskType = TaskTypeEnum.InPick.ObjToInt(),
			CreateDate = DateTime.Now,
			Creater = App.User.UserName,
			LocationCode = inventoryInfo.LocationCode,
			OrderNo = cabinOrder.Order_no,
			StockQuantity = orderQty,
			SupplyQuantity = 0,
			Remark = "å¥åº"
			};
			BaseDal.Db.Insertable(supplyTask_Hty).ExecuteCommand();
			#endregion

			//UpdateInboundOrderDetailStatus(request.orderNo, detail.batchNo, detail.productCode);
			break;
			}
			case "2":
			#region æ¾åºåºä»»å¡
			Dt_SupplyTask supplyTask = Db.Queryable<Dt_SupplyTask>().Where(x => x.MaterielCode == detail.productCode && x.BatchNo == detail.batchNo && x.OrderNo == request.orderNo && x.WarehouseCode == WarehouseEnum.ç«åº.ObjToInt().ToString("000") && x.TaskStatus == SupplyStatusEnum.NewOut.ObjToInt()).First();
			if (supplyTask == null) throw new Exception($"æªæ¾å°è®¢åå·ã{request.orderNo}ãç©æç¼å·ã{detail.productCode}ãçåºåºä»»å¡");
			#endregion

			#region å¤çåºåºåãåºåä¿¡æ¯ãåºåºä»»å¡ãè°æ¨ä»»å¡
			_deliveryOrderServices.OutTaskFinish(supplyTask);
			#endregion
			break;
			case "2":
			{
			Dt_DeliveryOrder cabinOrder = Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Out_no == request.orderNo && x.Warehouse_no == reslut).Includes(x => x.Details).First();
			if (cabinOrder.Out_type == "6")
			{
			foreach (var item in cabinOrder.Details)
			{
			Dt_InventoryInfo inventoryInfo = BaseDal.Db.Queryable<Dt_InventoryInfo>()
			.First(x => x.MaterielCode == item.Goods_no && x.BatchNo == item.Batch_num && x.LocationCode == reslut);
			var qty = inventoryInfo.StockQuantity - inventoryInfo.SupplyQuantity;
			if (orderQty != qty)
			throw new Exception($"çäºåºåºæ°éä¸ä¸è´,ä¸ä¼ æ°éã{orderQty}ã,åºåçäºæ°éã{qty}ã");
			inventoryInfo.StockQuantity = inventoryInfo.SupplyQuantity;
			inventoryInfo.SupplyQuantity = 0;
			inventoryInfo.StockStatus = StockStatusEmun.å¥åºå®æ.ObjToInt();
			#region æ·»å çäºåºåºä»»å¡
			Dt_SupplyTask_Hty supplyTask_Hty = new Dt_SupplyTask_Hty()
			{
			WarehouseCode = inventoryInfo.WarehouseCode,
			OperateType = OperateTypeEnum.èªå¨å®æ.ToString(),
			InsertTime = DateTime.Now,
			TaskStatus = SupplyStatusEnum.OutFinish.ObjToInt(),
			BatchNo = inventoryInfo.BatchNo,
			MaterielName = inventoryInfo.MaterielName,
			MaterielCode = inventoryInfo.MaterielCode,
			MaterielSpec = inventoryInfo.MaterielSpec,
			TaskType = TaskTypeEnum.ChenckOut.ObjToInt(),
			CreateDate = DateTime.Now,
			Creater = App.User.UserName,
			LocationCode = inventoryInfo.LocationCode,
			OrderNo = cabinOrder.Out_no,
			StockQuantity = orderQty,
			SupplyQuantity = 0,
			Remark = "çäºåºåº"
			};
			#endregion
			var inventory_Batch = BaseDal.Db.Queryable<Dt_Inventory_Batch>()
			.First(x => x.MaterielCode == inventoryInfo.MaterielCode && x.BatchNo == inventoryInfo.BatchNo);
			inventory_Batch.StockQuantity = inventory_Batch.SupplyQuantity;
			inventory_Batch.SupplyQuantity = 0;
			item.OotDetailStatus = "å·²å®æ";
			BaseDal.Db.Updateable(item).ExecuteCommand();
			BaseDal.Db.Updateable(inventoryInfo).ExecuteCommand();
			BaseDal.Db.Updateable(inventory_Batch).ExecuteCommand();
			BaseDal.Db.Insertable(supplyTask_Hty).ExecuteCommand();
			}
			var cabinOrder1 = BaseDal.Db.Queryable<Dt_DeliveryOrder>().Where(x => x.Id == cabinOrder.Id).Includes(x => x.Details).First();
			if (!cabinOrder1.Details.Where(x => x.OotDetailStatus != "å·²å®æ").Any())
			cabinOrder.OutStatus = "å·²å®æ";
			BaseDal.Db.Updateable(cabinOrder).ExecuteCommand();
			}
			else
			{
			#region æ¾åºåºä»»å¡
			Dt_SupplyTask supplyTask = Db.Queryable<Dt_SupplyTask>().Where(x => x.MaterielCode == detail.productCode && x.BatchNo == detail.batchNo && x.OrderNo == request.orderNo && x.WarehouseCode == reslut && x.TaskStatus == SupplyStatusEnum.NewOut.ObjToInt()).First();
			if (supplyTask == null) throw new Exception($"æªæ¾å°è®¢åå·ã{request.orderNo}ãç©æç¼å·ã{detail.productCode}ãçåºåºä»»å¡");
			if (supplyTask.StockQuantity != orderQty) throw new Exception($"è®¢åå·ã{request.orderNo}ãç©æç¼å·ã{detail.productCode}ãçåºåºæ°éä¸åºåºä»»å¡æ°éä¸ç¸ç");
			#endregion

			#region å¤çåºåºåãåºåä¿¡æ¯ãåºåºä»»å¡ãè°æ¨ä»»å¡
			_deliveryOrderServices.OutTaskFinish(supplyTask);
			#endregion
			}
			}
			break;
			case "3": // çç¹
			decimal diff = detail.ea ?? 0; // å·®å¼æ°
			int flag = detail.isLossOrProfit ?? 3; // 1=çäº, 2=çç, 3=çä¸
			if (flag == 1) // çäº
			{
			//åºåæ°-å·®å¼æ°=çäº
			//batch.SupplyQuantity += (batch.StockQuantity - diff);
			//batch.Remark = "çç¹ååä¼ - çäº";
			}
			else if (flag == 2) // çç
			{
			//åºåæ°+å·®å¼æ°=çç
			//batch.SupplyQuantity += (batch.StockQuantity + diff);
			//batch.Remark = "çç¹ååä¼ - çç";
			}
			else // çä¸
			{
			//batch.Remark = "çç¹ååä¼ - çä¸";
			var WarehouseLK = WarehouseEnum.ç«åº.ObjToInt().ToString("000");
			#region æ¾çç¹ä»»å¡
			Dt_SupplyTask supplyTask = Db.Queryable<Dt_SupplyTask>().Where(x => x.MaterielCode == detail.productCode && x.BatchNo == detail.batchNo && x.OrderNo == request.orderNo && x.WarehouseCode == WarehouseLK && x.TaskStatus == SupplyStatusEnum.NewCheck.ObjToInt()).First();
			if (supplyTask == null) throw new Exception($"æªæ¾å°è®¢åå·ã{request.orderNo}ãç©æç¼å·ã{detail.productCode}ãççç¹ä»»å¡");
			#endregion
			if (detail.isLossOrProfit == 1) // çäº
			{
			supplyTask.SupplyQuantity = supplyTask.StockQuantity - detail.ea;
			}
			else if (detail.isLossOrProfit == 2) // çç
			{
			supplyTask.SupplyQuantity = supplyTask.StockQuantity + detail.ea;
			}
			else // çä¸
			{
			supplyTask.SupplyQuantity = supplyTask.StockQuantity;
			}
			_deliveryOrderServices.CheckTaskFinish(supplyTask);
			}
			break;
			}