WebAPI/Controllers/»ªÔ¶datamapping/HY_DataMappingController.cs
@@ -1255,6 +1255,8 @@ string HSetNo = HBarCode.Substring(HBarCode.Length - 2, 2); //æ ¹æ®PNLæ¡ç ç¼å·ãsetå·ï¼ä»PNLæ£éªä¿¡æ¯è¡¨ä¸è·åset对åºçæ£éªä¿¡æ¯ //string sql = "exec h_p_Gy_GetMappingData_JiGuangGe '" + HBarCode_PNL + "','" + HSetNo + "'"; //ds = oCN.RunProcReturn(sql, "h_p_Gy_GetMappingData_JiGuangGe"); string sql = "" + "select distinct * from (" + //"select HBarCode,HPCSNo from QC_CheckNote_PNL_His where HBarCode = '" + HBarCode_PNL + "' and HSetNo = '" + HSetNo + "' " +