One order search dynamic sql statement生成位置
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
要获取更多Jerry的原创文章,请关注公众号"汪子熙":