ZhiHuiQiCe/FangCangZhiNeng.git

			@@ -84,95 +84,239 @@
			/// </summary>
			/// <param name="request"></param>
			/// <returns></returns>
			public ApiResponse<Dt_Inventory> OrderFeedback(EdiOrderCallbackRequest request)
			//public ApiResponse<Dt_Inventory> OrderFeedback(EdiOrderCallbackRequest request)
			//{
			// try
			// {
			// if (request == null \|\| request.details == null \|\| !request.details.Any())
			// {
			// return new ApiResponse<Dt_Inventory> { code = "500", msg = "è¯·æ±åæ°æ æ" };
			// }
			// BaseDal.Db.Ado.BeginTran();//å¼å¯äºå¡
			// foreach (var detail in request.details)
			// {
			// // åæ¥åºåæ¯å¦åå¨ï¼æç§äº§åç¼å·åæ¹æ¬¡æ¥å¯»æ¾ï¼
			// var entity = BaseDal.Db.Queryable<Dt_Inventory>()
			// .First(x => x.Goods_no == detail.productCode && x.Batch_num == detail.batchNo);
			// //å°éåä¸çæ°éè¿è¡ç´¯å
			// // å®å¨è½¬æ¢

			// //æ£å¸¸åºå¥åº
			// decimal orderQty = detail.orderDetails?.Sum(x => decimal.TryParse(x.quantity, out var q) ? q : 0) ?? 0;
			// //çç¹çäº
			// decimal diffQty = detail.stocktakingDetails?.Sum(x => Convert.ToDecimal(x.differenceQuantity)) ?? 0;
			// if (entity == null)
			// {
			// // å¦æä¸åå¨ï¼æ°å»ºä¸æ¡
			// entity = new Dt_Inventory
			// {
			// Goods_no = detail.productCode ?? detail.productName,
			// Reservoirarea = "é»è®¤åºåº",
			// Batch_num = detail.batchNo,
			// //ä¸å¡åºå
			// Business_qty = 0,
			// //å®éåºå
			// Actual_qty = 0
			// };
			// }

			// switch (request.orderType)
			// {
			// case "1": // å¥åº
			// entity.Business_qty += orderQty;
			// entity.Actual_qty += orderQty;
			// break;

			// case "2": // åºåº
			// entity.Business_qty -= orderQty;
			// entity.Actual_qty -= orderQty;
			// if (entity.Business_qty < 0) entity.Business_qty = 0; // å¯éï¼é²æ¢è´æ°
			// if (entity.Actual_qty < 0) entity.Actual_qty = 0;
			// break;

			// case "3": // çç¹
			// if (detail.stocktakingDetails != null && detail.stocktakingDetails.Any())
			// {
			// foreach (var stock in detail.stocktakingDetails)
			// {
			// //æ¯æ¬¡é½åªæ¿ä¸æ¡æç»ä¸çæ°é
			// decimal diff = Convert.ToDecimal(stock.differenceQuantity);
			// if (stock.IsProfit == "1") // çç
			// {
			// entity.Business_qty += diff;//å¦æççäºå¤äºï¼å°±å°ä¸å¡æ°é+ï¼çäºåç¸å
			// entity.PalletCode = stock.palletCode;
			// }
			// else // çäº
			// {
			// entity.Business_qty -= diff;
			// entity.PalletCode = stock.palletCode;
			// }
			// }
			// }
			// break;
			// }

			// // ä¿åæ°æ®
			// if (entity.Id == 0) // æ°å»º
			// BaseDal.Db.Insertable(entity).ExecuteCommand();
			// else // æ´æ°
			// BaseDal.Db.Updateable(entity).ExecuteCommand();
			// }
			// BaseDal.Db.Ado.CommitTran(); // æäº¤äºå¡
			// return new ApiResponse<Dt_Inventory> { code = "0", msg = "æå" };
			// }
			// catch (Exception ex)
			// {
			// BaseDal.Db.Ado.RollbackTran();//åæ»äºå¡
			// return new ApiResponse<Dt_Inventory> { code = "500", msg = ex.Message };
			// }
			//}


			public ApiResponse<Dt_InventoryInfo> OrderFeedback(EdiOrderCallbackRequest request)
			{
			try
			{
			if (request == null \|\| request.details == null \|\| !request.details.Any())
			{
			return new ApiResponse<Dt_Inventory> { code = "500", msg = "è¯·æ±åæ°æ æ" };
			return new ApiResponse<Dt_InventoryInfo> { code = "500", msg = "è¯·æ±åæ°æ æ" };
			}
			BaseDal.Db.Ado.BeginTran();//å¼å¯äºå¡

			BaseDal.Db.Ado.BeginTran(); // å¼å¯äºå¡

			foreach (var detail in request.details)
			{
			// åæ¥åºåæ¯å¦åå¨ï¼æç§äº§åç¼å·åæ¹æ¬¡æ¥å¯»æ¾ï¼
			var entity = BaseDal.Db.Queryable<Dt_Inventory>()
			.First(x => x.Goods_no == detail.productCode && x.Batch_num == detail.batchNo);
			//å°éåä¸çæ°éè¿è¡ç´¯å
			// å®å¨è½¬æ¢
			// å¥åºæ°éï¼èªå¨åæ£ï¼
			decimal orderQty = detail.orderDetails?
			.Sum(x => decimal.TryParse(x.quantity, out var q) ? Math.Abs(q) : 0)
			?? 0;

			//æ£å¸¸åºå¥åº
			decimal orderQty = detail.orderDetails?.Sum(x => decimal.TryParse(x.quantity, out var q) ? q : 0) ?? 0;
			//çç¹çäº
			decimal diffQty = detail.stocktakingDetails?.Sum(x => Convert.ToDecimal(x.differenceQuantity)) ?? 0;
			// çç¹å·®å¼æ°
			decimal diffQty = detail.stocktakingDetails?
			.Sum(x => Convert.ToDecimal(x.differenceQuantity))
			?? 0;

			// æ¥è¯¢ç°æåºåæç»
			var entity = BaseDal.Db.Queryable<Dt_InventoryInfo>()
			.First(x => x.MaterielCode == detail.productCode && x.BatchNo == detail.batchNo);

			if (entity == null)
			{
			// å¦æä¸åå¨ï¼æ°å»ºä¸æ¡
			entity = new Dt_Inventory
			//ä¸åå¨åæ°å»ºåºåæç»è®°å½
			entity = new Dt_InventoryInfo
			{
			Goods_no = detail.productCode ?? detail.productName,
			Reservoirarea = "é»è®¤åºåº",
			Batch_num = detail.batchNo,
			//ä¸å¡åºå
			Business_qty = 0,
			//å®éåºå
			Actual_qty = 0
			PalletCode = detail.orderDetails?.FirstOrDefault()?.palletCode ?? "",
			WarehouseCode = 1.ToString(), // é»è®¤åºæ¿ç¼å·
			LocationCode = "",
			StockStatus = 1, // ç«åºåºå®ä¸º 1
			MaterielCode = detail.productCode ?? detail.productName,
			MaterielName = detail.productName ?? "",
			MaterielSpec = detail.productSpecifications ?? "",
			BatchNo = detail.batchNo,
			StockQuantity = 0,
			OutboundQuantity = 0,
			SupplyQuantity = 0,
			InDate = DateTime.Now,
			ProductionDate = detail.finishDate.ToString("yyyy-MM-dd"),
			ShelfLife = 0,
			ValidityPeriod = "",
			Remark = "WCSåä¼ åå»º"
			};
			}

			// æ¹æ¬¡è¡¨è®°å½ï¼ç¨äºæ±æ»ï¼
			var batch = BaseDal.Db.Queryable<Dt_Inventory_Batch>()
			.First(x => x.MaterielCode == detail.productCode && x.BatchNo == detail.batchNo);

			if (batch == null)
			{
			batch = new Dt_Inventory_Batch
			{
			MaterielCode = detail.productCode ?? detail.productName,
			MaterielName = detail.productName ?? "",
			MaterielSpec = detail.productSpecifications ?? "",
			BatchNo = detail.batchNo,
			StockQuantity = 0,
			OutboundQuantity = 0,
			SupplyQuantity = 0,
			ERPStockQuantity = 0,
			Status = false,
			ProductionDate = detail.finishDate.ToString("yyyy-MM-dd"),
			ValidityPeriod = DateTime.Now.AddYears(1).ToString("yyyy-MM-dd"),
			Remark = "èªå¨åå»º"
			};
			}

			switch (request.orderType)
			{
			case "1": // å¥åº
			entity.Business_qty += orderQty;
			entity.Actual_qty += orderQty;
			entity.StockQuantity += orderQty;
			entity.InDate = DateTime.Now;
			entity.Remark = "å¥åºååä¼ ";

			batch.StockQuantity += orderQty;
			batch.Remark = "å¥åºååä¼ ";
			break;

			case "2": // åºåº
			entity.Business_qty -= orderQty;
			entity.Actual_qty -= orderQty;
			if (entity.Business_qty < 0) entity.Business_qty = 0; // å¯éï¼é²æ¢è´æ°
			if (entity.Actual_qty < 0) entity.Actual_qty = 0;
			entity.OutboundQuantity += orderQty;
			entity.StockQuantity -= orderQty;
			if (entity.StockQuantity < 0) entity.StockQuantity = 0;
			entity.Remark = "åºåºååä¼ ";

			batch.OutboundQuantity += orderQty;
			batch.StockQuantity -= orderQty;
			if (batch.StockQuantity < 0) batch.StockQuantity = 0;
			batch.Remark = "åºåºååä¼ ";
			break;

			case "3": // çç¹
			case "3": //çç¹
			if (detail.stocktakingDetails != null && detail.stocktakingDetails.Any())
			{
			foreach (var stock in detail.stocktakingDetails)
			{
			//æ¯æ¬¡é½åªæ¿ä¸æ¡æç»ä¸çæ°é
			decimal diff = Convert.ToDecimal(stock.differenceQuantity);
			if (stock.IsProfit == "1") // çç
			{
			entity.Business_qty += diff;//å¦æççäºå¤äºï¼å°±å°ä¸å¡æ°é+ï¼çäºåç¸å
			entity.PalletCode = stock.palletCode;
			entity.SupplyQuantity += Math.Abs(diff);
			batch.SupplyQuantity += Math.Abs(diff);
			}
			else // çäº
			{
			entity.Business_qty -= diff;
			entity.PalletCode = stock.palletCode;
			entity.SupplyQuantity -= Math.Abs(diff);
			batch.SupplyQuantity -= Math.Abs(diff);
			if (entity.SupplyQuantity < 0) entity.SupplyQuantity = 0;
			if (batch.SupplyQuantity < 0) batch.SupplyQuantity = 0;
			}
			entity.PalletCode = stock.palletCode;
			entity.Remark = "çç¹ååä¼ ";
			batch.Remark = "çç¹ååä¼ ";
			}
			}
			break;
			}

			// ä¿åæ°æ®
			if (entity.Id == 0) // æ°å»º
			//ä¿åå°æ°æ®åº
			if (entity.Id == 0)
			BaseDal.Db.Insertable(entity).ExecuteCommand();
			else // æ´æ°
			else
			BaseDal.Db.Updateable(entity).ExecuteCommand();

			if (batch.Id == 0)
			BaseDal.Db.Insertable(batch).ExecuteCommand();
			else
			BaseDal.Db.Updateable(batch).ExecuteCommand();
			}
			BaseDal.Db.Ado.CommitTran(); // æäº¤äºå¡
			return new ApiResponse<Dt_Inventory> { code = "0", msg = "æå" };

			BaseDal.Db.Ado.CommitTran();
			return new ApiResponse<Dt_InventoryInfo> { code = "0", msg = "æå" };
			}
			catch (Exception ex)
			{
			BaseDal.Db.Ado.RollbackTran();//åæ»äºå¡
			return new ApiResponse<Dt_Inventory> { code = "500", msg = ex.Message };
			BaseDal.Db.Ado.RollbackTran();
			return new ApiResponse<Dt_InventoryInfo> { code = "500", msg = ex.Message };
			}
			}