From 6482b2e564a9d1d612efce0347bb1988e3ec94af Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 22 十二月 2025 14:13:10 +0800
Subject: [PATCH] 华远 PNL布局增加字段镜像类型 HMirrorType 激光割获取Mapping数据优化
---
WebAPI/Controllers/华远datamapping/HY_DataMappingController.cs | 9 ++-------
1 files changed, 2 insertions(+), 7 deletions(-)
diff --git "a/WebAPI/Controllers/\345\215\216\350\277\234datamapping/HY_DataMappingController.cs" "b/WebAPI/Controllers/\345\215\216\350\277\234datamapping/HY_DataMappingController.cs"
index 30f6587..fae70cd 100644
--- "a/WebAPI/Controllers/\345\215\216\350\277\234datamapping/HY_DataMappingController.cs"
+++ "b/WebAPI/Controllers/\345\215\216\350\277\234datamapping/HY_DataMappingController.cs"
@@ -1255,13 +1255,8 @@
string HSetNo = HBarCode.Substring(HBarCode.Length - 2, 2);
//鏍规嵁PNL鏉＄爜缂栧彿銆乻et鍙凤紝浠嶱NL妫�楠屼俊鎭〃涓幏鍙杝et瀵瑰簲鐨勬楠屼俊鎭�
- string sql = "" +
- "select distinct * from (" +
- //"select HBarCode,HPCSNo from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
- //"union " +
- "select HBarCode,HPCSNo from QC_CheckNote_PNL_Temp where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +
- ") as a";
- ds = oCN.RunProcReturn(sql, "QC_CheckNote_PNL_Temp");
+ string sql = "exec h_p_Gy_GetMappingData_JiGuangGe '" + HBarCode_PNL + "','" + HSetNo + "'";
+ ds = oCN.RunProcReturn(sql, "h_p_Gy_GetMappingData_JiGuangGe");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
--
Gitblit v1.9.1