package cn.ksource.web.facade.fpry; import cn.ksource.core.dao.BaseDao; import cn.ksource.core.util.ConvertUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; import java.util.Map; @Service public class FpryFacadeImpl implements FpryFacade { @Autowired private BaseDao baseDao; @SuppressWarnings("rawtypes") @Override public List getLyRy(Map param) { String sql=""; sql="SELECT A.*,C.ZSXM USER_NAME FROM ac_user_ref_role A,GG_USER C WHERE A.YHBH=C.ID AND C.ZT=1"; List list=baseDao.queryForList(sql, param); return list; } @Override public List getRole(Map param) { String sql="SELECT * FROM AC_ROLE WHERE STATE=1 "; List list=baseDao.queryForList(sql, param); return list; } }