select count(distinct bill_id) as num, count(entity_id) as detailnum, status_code, menu_id, (select menu_name from sys_menu sm where sm.menu_id = swmr.menu_id and sm.enabled = 1) menu_name, sys_id, module_id, (select module_name from sys_module smo where smo.module_id = swmr.module_id and smo.enabled = 1) module_name from (select task.bill_id bill_id, task.entity_id entity_id, task.status_code, (select max(menu_id) from sys_role_menu_module srmm where task.rg_code = srmm.rg_code and task.set_year = srmm.set_year and module.module_id = srmm.module_id and role.role_id = srmm.role_id ) as menu_id, sr.user_sys_id as sys_id, module.module_id from sys_wf_current_item task, sys_wf_module_node module, sys_wf_role_node role, sys_role sr where task.node_id = role.node_id and role.role_id = :1 and module.node_id = task.node_id and sr.role_id=role.role_id and task.rg_code = :2 and task.set_year=:3 and task.rg_code=module.rg_code and task.set_year=module.set_year and task.rg_code=role.rg_code and task.set_year=role.set_year and exists(select 1 from sys_role se where se.role_id = role.role_id and se.user_sys_id<>'002') ) swmr group by menu_id, status_code, module_id, sys_id
现在运行报什么错误？
字段汰多看起了有点乱，具体报什么错误呢？
把报的错误贴上来才好帮你解决，字段太多有点乱！
role.role_id = :1 and module.node_id = task.node_id and sr.role_id=role.role_id and task.rg_code = :2 and task.set_year=:3
改为
role.role_id =1 and module.node_id = task.node_id and sr.role_id=role.role_id and task.rg_code = 2 and task.set_year=3