~tjx/XB_MES_API.git

			@@ -26,9 +26,9 @@

			// 优化点1: 使用原生SQL ROW_NUMBER()在数据库端完成去重和排序
			var rackingTaskSql = @"
			SELECT ITEM_BARCODE AS ItemBarcode, PALLETCODE AS PalletCode, CODE AS Code
			SELECT ITEM_BARCODE AS ItemBarcode, PALLETCODE AS PalletCode, CODE AS Code, TASKTYPE AS TaskType
			FROM (
			SELECT ITEM_BARCODE, PALLETCODE, CODE,
			SELECT ITEM_BARCODE, PALLETCODE, CODE, TASKTYPE,
			ROW_NUMBER() OVER (PARTITION BY ITEM_BARCODE ORDER BY ID DESC) AS RN
			FROM XB_RACKING_TASK_SYXT_LOG
			WHERE ITEM_BARCODE IS NOT NULL AND (CODE IS NULL OR CODE != '500')
			@@ -230,10 +230,16 @@

			rackingTaskDict.TryGetValue(barcodeToMatch, out var rackingTask);

			string stockStatus = "进入立库的路上";
			if (rackingTask?.Code != null)
			string stockStatus;
			if (rackingTask?.TaskType == "立库出库请求")
			{
			stockStatus = rackingTask.Code == "200" ? "已在立库中" : "进入立库的路上";
			// 出库请求：Code=200表示已出库，Code=null表示出库路上
			stockStatus = rackingTask.Code == "200" ? "已出立库" : "出立库路上";
			}
			else
			{
			// 回库请求（默认）：Code=200表示已在立库中，Code=null表示进入立库的路上
			stockStatus = rackingTask?.Code == "200" ? "已在立库中" : "进入立库的路上";
			}

			return new
			@@ -443,6 +449,7 @@
			public string ItemBarcode { get; set; }
			public string PalletCode { get; set; }
			public string Code { get; set; }
			public string TaskType { get; set; }
			}

			/// <summary>
			@@ -489,6 +496,20 @@
			.Select(x => new { x.PalletCode, x.WidthType })
			.First();

			// 检查是否存在未完成的任务（基于PalletCode，Code为null）
			if (!string.IsNullOrEmpty(rackingTaskInfo?.PalletCode))
			{
			var pendingTask = Db.Queryable<XbRackingTaskSyxtLog>()
			.Where(x => x.PalletCode == rackingTaskInfo.PalletCode && x.Code == null)
			.OrderByDescending(x => x.Id)
			.First();

			if (pendingTask != null)
			{
			throw new Exception($"托盘编号 {rackingTaskInfo.PalletCode} 已存在未完成的立库任务，请等待任务完成后再操作。");
			}
			}

			try
			{
			// 1. 查询该条码对应的库存信息，按物料和批号汇总