不对函数加``,解决sum(*),Count(1)等不能使用的问题

390620652 · 390620652 · commit 850afe09990b · 2024-03-06T16:47:42.000+08:00
diff --git a/APIJSON.NET/APIJSON.Data/SelectTable.cs b/APIJSON.NET/APIJSON.Data/SelectTable.cs
@@ -140,7 +140,7 @@ public virtual JObject QuerySingle(JObject queryObj, string nodeName = "infos")
             {
                 ExecFunc(resultObj, item);
             }
-            else if (key.Equals("total@"))
+            else if (key.Equals("total@")|| key.Equals("total"))
             {
                 resultObj.Add("total", total);
             }
@@ -196,7 +196,7 @@ public virtual JObject Query(JObject queryObj)
             {
                 ExecFunc(resultObj, item);
             }
-            else if (key.Equals("total@"))
+            else if (key.Equals("total@")|| key.Equals("total"))
             {
                 resultObj.Add("total", total);
             }
@@ -535,6 +535,11 @@ private void ProcessColumn(string subtable, string selectrole, JObject values, I
                     }
                     str.Append(ziduan[0] + " as `" + ReplaceSQLChar(ziduan[1]) + "`,");
                 }
+                //不对函数加``,解决sum(*),Count(1)等不能使用的问题
+                else if (ziduan[0].Contains('('))
+                {
+                    str.Append(ziduan[0] + ",");
+                }
                 else
                     str.Append("`" + ziduan[0] + "`" + ",");
 

Original file line number	Diff line number	Diff line change
`@@ -140,7 +140,7 @@ public virtual JObject QuerySingle(JObject queryObj, string nodeName = "infos")`
`140`	`140`	`{`
`141`	`141`	`ExecFunc(resultObj, item);`
`142`	`142`	`}`
`143`		`- else if (key.Equals("total@"))`
	`143`	`+ else if (key.Equals("total@")\|\| key.Equals("total"))`
`144`	`144`	`{`
`145`	`145`	`resultObj.Add("total", total);`
`146`	`146`	`}`
`@@ -196,7 +196,7 @@ public virtual JObject Query(JObject queryObj)`
`196`	`196`	`{`
`197`	`197`	`ExecFunc(resultObj, item);`
`198`	`198`	`}`
`199`		`- else if (key.Equals("total@"))`
	`199`	`+ else if (key.Equals("total@")\|\| key.Equals("total"))`
`200`	`200`	`{`
`201`	`201`	`resultObj.Add("total", total);`
`202`	`202`	`}`
`@@ -535,6 +535,11 @@ private void ProcessColumn(string subtable, string selectrole, JObject values, I`
`535`	`535`	`}`
`536`	`536`	str.Append(ziduan[0] + " as `" + ReplaceSQLChar(ziduan[1]) + "`,");
`537`	`537`	`}`
	`538`	+ //不对函数加``,解决sum(*),Count(1)等不能使用的问题
	`539`	`+ else if (ziduan[0].Contains('('))`
	`540`	`+ {`
	`541`	`+ str.Append(ziduan[0] + ",");`
	`542`	`+ }`
`538`	`543`	`else`
`539`	`544`	str.Append("`" + ziduan[0] + "`" + ",");
`540`	`545`