Merge remote-tracking branch 'origin/master'
| | |
| | | // filter += " and "+dataFilter;
|
| | | // }
|
| | | // }
|
| | | if(!BaseUtil.dataTableIsEmpty(fs.getSubDataTable("systemSeniorQueryString"))){
|
| | | filter = filter + " and " + queryFilterService.getQueryFilter(fs);
|
| | | }
|
| | | DataTableEntity dt = baseDao.listTable(CmnConst.APP_GZRYCCSPB,filter,null,null,null,fs.getInteger(CmnConst.PAGESIZE),fs.getInteger(CmnConst.CPAGE));
|
| | | baseDao.loadPromptData(dt);
|
| | | return dt;
|
| | |
| | | sql.append("\n a.org_level_type "); |
| | | sql.append("\n FROM "); |
| | | sql.append("\n product_sys_org_levels a "); |
| | | sql.append("\n join product_sys_org_levels b on b.org_level_status=0 "); |
| | | sql.append("\n and (a.org_level_code_parent=b.org_level_code OR (a.org_level_code_parent is null or a.org_level_code_parent=''))"); |
| | | sql.append("\n LEFT JOIN product_sys_org_levels b on b.org_level_status=0 "); |
| | | sql.append("\n and (a.org_level_code_parent=b.org_level_code )"); |
| | | sql.append("\n where a.org_level_status=0 "); |
| | | |
| | | Object[] params = null; |