[F-18729]9.0.6.0 查询命令自动建构的查询语句出错了

收藏

本帖最后由飞天于 2023-12-1 15:06 编辑

SQL参数P10/P11/P12/P13/P14, 都有相应的值，但SQL语句总是取了P1的值
在不同的程序中都发现的这个问题，只要参数超过10个，从第10个起总是取P1的值

"SqlItem": {
      "Sql": "select  a.[CGUID] as C0,a.[ID] as C1,a.[CDESCRIPTION] as C2,a.[CTYPE] as C3,a.[CSAE] as C4,a.[CWINDING] as C5,a.[CPMG] as C6,a.[CIP] as C7,a.[CSYSTEM] as C8,a.[CREGREASABLE] as C9,a.[CTEMPDST] as C10,a.[CTEMPDHOUSING] as C11,a.[CR791] as C12,a.[CAVR] as C13,a.[CHEATER] as C14,a.[CCT] as C15,a.[CIDSHAFT] as C16,a.[CTBOX] as C17,a.[CGlandBox] as C18,a.[CR726] as C19,a.[CTerminalBox] as C20,a.[CCenterHigh] as C21,a.[CDirection] as C22,a.[CInsulatingBearing] as C23,a.[CConnection] as C24,a.[CDT] as C25,a.[CMT] as C26,a.[CBalancingLevl] as C27,a.[CAdapter] as C28,a.[CPotentiometer] as C29,a.[CDripProof] as C30,a.[CAirFilter] as C31,a.[CManualRegulation] as C32,a.[CVTransformer] as C33,a.[CPFAdjustment] as C34 from [dbo].[zz_Com_Product] as a Where a.[CTYPE] = \"LSA 46.3L11\" AND a.[CWINDING] = \"J 6/4\" AND a.[CSAE] = \"0-14\" AND a.[CDirection] = \"NO\" AND a.[CAdapter] = \"NO\" AND a.[CTerminalBox] = \"NO\" AND a.[CBalancingLevl] = \"G2.5\" AND a.[CSYSTEM] = \"System 1\" AND a.[CIP] = \"IP23\" AND a.[CCenterHigh] = \"280\" AND a.[CPotentiometer] = \"NO\" AND a.[CVTransformer] = \"NO\" AND a.[CTBOX] = \"Cables exit on the left side(Standard)\" AND a.[CCT] = \"NO\" AND a.[CPMG] = \"NO\" AND a.[CPFAdjustment] = \"NO\" AND a.[CMetalNameplate] = \"NO\" AND a.[CHEATER] = \"NO\" AND a.[CDripProof] = \"NO\" AND a.[CConnection] = \"STD;(D);(A);\" AND a.[CAVR] = \"J 6/4\"0 AND a.[CR791] = \"NO\" AND a.[CR726] = \"NO\" AND a.[CInsulatingBearing] = \"NO\" AND a.[CREGREASABLE] = \"NO\" AND a.[CAirFilter] = \"NO\" AND a.[CManualRegulation] = \"NO\" AND a.[CTEMPDST] = \"NO\" AND a.[CTEMPDHOUSING] = \"NO\" AND a.[CIDSHAFT] = \"NO\" AND a.[CNewOther] = \"J 6/4\"1 AND a.[CGlandBox] = \"J 6/4\"2 AND a.[CMT] = \"J 6/4\"3 AND a.[CDT] = \"J 6/4\"4  ORDER BY a.[CGUID] ASC",
      "OriginalSql": "select  a.[CGUID] as C0,a.[ID] as C1,a.[CDESCRIPTION] as C2,a.[CTYPE] as C3,a.[CSAE] as C4,a.[CWINDING] as C5,a.[CPMG] as C6,a.[CIP] as C7,a.[CSYSTEM] as C8,a.[CREGREASABLE] as C9,a.[CTEMPDST] as C10,a.[CTEMPDHOUSING] as C11,a.[CR791] as C12,a.[CAVR] as C13,a.[CHEATER] as C14,a.[CCT] as C15,a.[CIDSHAFT] as C16,a.[CTBOX] as C17,a.[CGlandBox] as C18,a.[CR726] as C19,a.[CTerminalBox] as C20,a.[CCenterHigh] as C21,a.[CDirection] as C22,a.[CInsulatingBearing] as C23,a.[CConnection] as C24,a.[CDT] as C25,a.[CMT] as C26,a.[CBalancingLevl] as C27,a.[CAdapter] as C28,a.[CPotentiometer] as C29,a.[CDripProof] as C30,a.[CAirFilter] as C31,a.[CManualRegulation] as C32,a.[CVTransformer] as C33,a.[CPFAdjustment] as C34 from [dbo].[zz_Com_Product] as a Where a.[CTYPE] = @p0 AND a.[CWINDING] = @p1 AND a.[CSAE] = @p2 AND a.[CDirection] = @p3 AND a.[CAdapter] = @p3 AND a.[CTerminalBox] = @p3 AND a.[CBalancingLevl] = @p4 AND a.[CSYSTEM] = @p5 AND a.[CIP] = @p6 AND a.[CCenterHigh] = @p7 AND a.[CPotentiometer] = @p3 AND a.[CVTransformer] = @p3 AND a.[CTBOX] = @p8 AND a.[CCT] = @p3 AND a.[CPMG] = @p3 AND a.[CPFAdjustment] = @p3 AND a.[CMetalNameplate] = @p3 AND a.[CHEATER] = @p3 AND a.[CDripProof] = @p3 AND a.[CConnection] = @p9 AND a.[CAVR] = @p10 AND a.[CR791] = @p3 AND a.[CR726] = @p3 AND a.[CInsulatingBearing] = @p3 AND a.[CREGREASABLE] = @p3 AND a.[CAirFilter] = @p3 AND a.[CManualRegulation] = @p3 AND a.[CTEMPDST] = @p3 AND a.[CTEMPDHOUSING] = @p3 AND a.[CIDSHAFT] = @p3 AND a.[CNewOther] = @p11 AND a.[CGlandBox] = @p12 AND a.[CMT] = @p13 AND a.[CDT] = @p14  ORDER BY a.[CGUID] ASC",
      "SqlParams": [
         {
            "Name": "@p0",
            "Value": "LSA 46.3L11"
         },
         {
            "Name": "@p1",
            "Value": "J 6/4"
         },
         {
            "Name": "@p2",
            "Value": "0-14"
         },
         {
            "Name": "@p3",
            "Value": "NO"
         },
         {
            "Name": "@p4",
            "Value": "G2.5"
         },
         {
            "Name": "@p5",
            "Value": "System 1"
         },
         {
            "Name": "@p6",
            "Value": "IP23"
         },
         {
            "Name": "@p7",
            "Value": "280"
         },
         {
            "Name": "@p8",
            "Value": "Cables exit on the left side(Standard)"
         },
         {
            "Name": "@p9",
            "Value": "STD;(D);(A);"
         },
         {
            "Name": "@p10",
            "Value": "D350"
         },
         {
            "Name": "@p11",
            "Value": "test"
         },
         {
            "Name": "@p12",
            "Value": "testgb"
         },
         {
            "Name": "@p13",
            "Value": "testmd"
         },
         {
            "Name": "@p14",
            "Value": "testdt"
         }
      ],
      "Duration": "17.4158ms"
}