One order search dynamic sql statement生成位置
One order search dynamic sql statement生成位置
版权声明：本文为博主原创文章，遵循 CC 4.0 by-sa 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://jerry.blog.csdn.net/article/details/100046822
line 30负责根据ui传入的search parameter生成动态的sql statement
example1：
所以我们得知One order的search，最终是通过OPEN SQL到如下table里查找：CRM_ORDER_INDEX
one order 框架根据UI 输入的search条件，自动拼出的SQL语句如下： CRMD_ORDER_INDEX~PARTNER_NO IN (‘0000014896’, ‘0000014966’, ‘0000015022’, ‘0000015207’, ‘0000015280’, ‘0000015354’, ‘0000171054’, ‘0004001871’, ‘0004002734’, ‘0004003421’, ‘0004005516’, ‘0004005978’, ‘0004008407’, ‘0004020212’, ‘0004020253’, ‘0004026606’, ‘0004031140’, ‘0004031234’, ‘0004036138’, ‘0004036139’, ‘0004036152’, ‘0004036693’, ‘0004036742’, ‘0004036818’, ‘0004036820’, ‘0004037112’, ‘0004037514’, ‘0004037846’, ‘0004049461’, ‘0004052335’, ‘0004102791’, ‘DESAIJ’, ‘FWI_EMPL’, ‘GILG’, ‘GRAEBERM’) AND