@Override
public List<ElecUser> findByCondition(ElecUser user) {
// TODO Auto-generated method stub
StringBuffer ss=new StringBuffer();
List<Object> plist=new ArrayList<Object>();
//姓名
if(StringUtils.isNotBlank(user.getUserName())){
ss.append(" and t.userName like ? ");
plist.add("%"+user.getUserName()+"%");
}
//所属单位
if(StringUtils.isNotBlank(user.getJctID())){
ss.append(" and t.jctID=? ");
plist.add(user.getJctID());
}
//开始时间
if(user.getOnDutyDateBegin()!=null){
ss.append(" and t.onDutyDate>? ");
plist.add(user.getOnDutyDateBegin());
}
//结束时间
if(user.getOnDutyDateEnd()!=null){
ss.append(" and t.onDutyDate<? ");
plist.add(user.getOnDutyDateEnd());
}
//按照入职时间排序,正序
Map<String, String> oderMap=new LinkedHashMap<String, String>();
oderMap.put("t.onDutyDate","asc");
List<ElecUser> ulist = elecUserDao.findByConditionNoPage(ss.toString(), plist.toArray(), oderMap);
this.trans(ulist);
return ulist;
}
public List<ElecUser> findByCondition(ElecUser user) {
// TODO Auto-generated method stub
StringBuffer ss=new StringBuffer();
List<Object> plist=new ArrayList<Object>();
//姓名
if(StringUtils.isNotBlank(user.getUserName())){
ss.append(" and t.userName like ? ");
plist.add("%"+user.getUserName()+"%");
}
//所属单位
if(StringUtils.isNotBlank(user.getJctID())){
ss.append(" and t.jctID=? ");
plist.add(user.getJctID());
}
//开始时间
if(user.getOnDutyDateBegin()!=null){
ss.append(" and t.onDutyDate>? ");
plist.add(user.getOnDutyDateBegin());
}
//结束时间
if(user.getOnDutyDateEnd()!=null){
ss.append(" and t.onDutyDate<? ");
plist.add(user.getOnDutyDateEnd());
}
//按照入职时间排序,正序
Map<String, String> oderMap=new LinkedHashMap<String, String>();
oderMap.put("t.onDutyDate","asc");
List<ElecUser> ulist = elecUserDao.findByConditionNoPage(ss.toString(), plist.toArray(), oderMap);
this.trans(ulist);
return ulist;
}