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'[]
|