package com.shlanbao.tzsc.pms.sys.user.service.impl;
|
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.SchStatFaultDaoI;
|
import com.shlanbao.tzsc.base.dao.SysUserDaoI;
|
import com.shlanbao.tzsc.base.mapping.SchStatFault;
|
import com.shlanbao.tzsc.base.mapping.SysModelPermis;
|
import com.shlanbao.tzsc.base.mapping.SysUser;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.sys.user.beans.UserBean;
|
import com.shlanbao.tzsc.pms.sys.user.service.UserServiceI;
|
import com.shlanbao.tzsc.pms.sys.user.service.schStatFaultServiceI;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.MD5Util;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
/**
|
* 用户管理业务实现类
|
* @author Leejean
|
* @create 2014年9月16日上午10:43:37
|
*/
|
@Service
|
public class schStatFaultServiceImpl extends BaseService implements schStatFaultServiceI{
|
@Autowired
|
private SchStatFaultDaoI schStatDao;
|
|
@Override
|
public List<?> getSchStatFault() {
|
// TODO Auto-generated method stub
|
StringBuffer sb =new StringBuffer();
|
sb.append(" SELECT * FROM ( SELECT scf.*, ROWNUM AS rowno FROM ( ");
|
sb.append(" SELECT NAME,SUM (s. TIME) TIME,SUM (s. TIMES) TIMES,SUM (s.FLAG) flag ");
|
sb.append(" FROM SCH_STAT_FAULT s where status=0 GROUP BY s. NAME ORDER BY time DESC ) scf ");
|
sb.append("WHERE ROWNUM <= '5') table_alias WHERE table_alias.rowno >= '1'");
|
return schStatDao.queryBySql(sb.toString());
|
}
|
|
|
}
|
