| | |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import com.yc.action.grid.GridUtils; |
| | | import org.springframework.jdbc.support.rowset.SqlRowSet; |
| | | import org.springframework.stereotype.Service; |
| | | import com.yc.layoutIcon.entity.GroupEntity; |
| | |
| | | public List<Map<String, Object>> getMeunlist(String usercode, int meunId) throws Exception { |
| | | try { |
| | | String sql="select u.menuid,u.menuname,u.sortby,u.formid,u.formtype,u.parentmenu,u.actived," |
| | | + "u.largimagepath,(case when a.menuid is null then 0 else 1 end) as checked " |
| | | + "from usermenu('"+usercode.replace("'", "")+"') u left join _sysWebMenuAccess a " |
| | | + "on a.menuid=u.menuid and a.UserCode='"+usercode+"' where u.parentmenu="+meunId; |
| | | + "u.largimagepath,case when isnull(a.usercode,'') <> '' then isnull(a.ishide,0) else 1 end as ishide " |
| | | + "from usermenu("+ GridUtils.prossSqlParm(usercode)+") u left join _sysWebMenuAccess a " |
| | | + "on a.menuid=u.menuid and a.UserCode="+GridUtils.prossSqlParm(usercode)+" where u.parentmenu="+meunId; |
| | | return super.jdbcTemplate.queryForList(sql); |
| | | } catch (Exception e) { |
| | | throw e; |