One order search dynamic sql statement生成位置

line 30负责根据ui传入的search parameter生成动态的sql statement

One order search dynamic sql statement生成位置

example1:

One order search dynamic sql statement生成位置

所以我们得知One order的search,最终是通过OPEN SQL到如下table里查找:CRM_ORDER_INDEX

One order search dynamic sql statement生成位置

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