| 12345678910111213 | [INFO] 2015-12-08 11:39:17 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDictionaryInfoDao(BasicDao.java:194): queryDictionaryInfoDao sql------------------- select * from DICTIONARY t where 1=1   and t.dictype ='noticeType'[]  [INFO] 2015-12-08 11:39:19 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryArticleList(BasicDao.java:1286): Select a.* from B_ARTICLE a where 1=1  and ((a.CreateDate <str_to_date('2015-12-09','%Y-%m-%d') and a.CreateDate>= str_to_date('2015-12-08','%Y-%m-%d')) or ( a.lastmodify <str_to_date('2015-12-09','%Y-%m-%d') and a.lastmodify >=str_to_date('2015-12-08','%Y-%m-%d'))) order by a.lastmodify desc,a.createdate desc[]  [INFO] 2015-12-08 11:39:39 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDictionaryInfoDao(BasicDao.java:194): queryDictionaryInfoDao sql------------------- select * from DICTIONARY t where 1=1   and t.dictype ='noticeType'[]  [INFO] 2015-12-08 11:40:10 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDictionaryInfoDao(BasicDao.java:194): queryDictionaryInfoDao sql------------------- select * from DICTIONARY t where 1=1   and t.dictype ='noticeType'[]  [INFO] 2015-12-08 11:40:12 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDictionaryInfoDao(BasicDao.java:194): queryDictionaryInfoDao sql------------------- select * from DICTIONARY t where 1=1   and t.dictype ='noticeType'[]  [INFO] 2015-12-08 11:40:26 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDeptDao(BasicDao.java:268): ------------------------------------Select * from B_DEPT where 1=1 and isshow =1  and hosId= '1023577' and deptCode='0130ks' order by ordercol []  [INFO] 2015-12-08 11:40:26 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDoctorDeptDao(BasicDao.java:295): queryDoctorDeptDao depNameSql --------------- Select * from B_DEPT where 1=1 and isshow =1 and deptcode='0130ks'[]  [INFO] 2015-12-08 11:40:26 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDoctorDao(BasicDao.java:374): queryDoctorDao sql debug::::::::::::::::::: Select b.*,c.deptname from B_DOCTOR b left join B_DEPT c on b.deptcode = c.deptcode where 1=1  and b.deptCode='0130ks'and b.hosid='1023577' order by b.ordercol []  [ERROR] 2015-12-08 11:40:26 >> [A-deal-110] com.yihu.hos.service.basic.AbsBasicService.queryDoctor(AbsBasicService.java:507): java.sql.SQLException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause Query: select count(1) from  B_DOCTOR b where 1=1  and b.deptCode='0130ks'and b.hosid='1023577' order by b.ordercol  Parameters: []  [ERROR] 2015-12-08 11:40:26 >> [A-deal-110] com.yihu.hos.service.basic.AbsBasicService.QueryDoctor(AbsBasicService.java:449): com.yihu.hos.exception.BusinessException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause Query: select count(1) from  B_DOCTOR b where 1=1  and b.deptCode='0130ks'and b.hosid='1023577' order by b.ordercol  Parameters: []  [INFO] 2015-12-08 11:48:22 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDictionaryInfoDao(BasicDao.java:194): queryDictionaryInfoDao sql------------------- select * from DICTIONARY t where 1=1   and t.dictype ='noticeType'[]  [INFO] 2015-12-08 11:48:24 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDictionaryInfoDao(BasicDao.java:194): queryDictionaryInfoDao sql------------------- select * from DICTIONARY t where 1=1   and t.dictype ='noticeType'[]  [INFO] 2015-12-08 11:48:26 >> [A-deal-110] com.yihu.hos.dao.BasicDao.queryDictionaryInfoDao(BasicDao.java:194): queryDictionaryInfoDao sql------------------- select * from DICTIONARY t where 1=1   and t.dictype ='noticeType'[]  
 |