WebAPI/Controllers/BaseSet/Gy_GroupController.cs
@@ -42,12 +42,12 @@ if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere, "h_v_GroupList"); ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere+ " order by HItemID ", "h_v_GroupList"); } else { string sql1 = "select * from h_v_GroupList where 1 = 1 "; string sql = sql1 + sWhere; string sql = sql1 + sWhere+ " order by HItemID "; ds = oCN.RunProcReturn(sql, "h_v_GroupList"); } if (ds == null || ds.Tables[0].Rows.Count == 0)