采购模块查询部分

wtt

2024-09-10 0d9ec09fd8434339c9c222a4a9eadb7700271744

 WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs

@@ -40,7 +40,8 @@
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                string sql1 = string.Format(@"select * from h_v_IF_ORGANIZATIONSList where 组织名称='" + Organization + "'");
                //string sql1 = string.Format(@"select * from h_v_IF_ORGANIZATIONSList where 组织名称='" + Organization + "'");
                string sql1 = string.Format(@"select * from h_v_IF_ORGANIZATIONSList where 1=1 ");
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn(sql1 + sWhere + " order by 组织代码 ", "h_v_IF_ORGANIZATIONSList");