test

最新推荐文章于 2024-08-26 08:12:22 发布

落落的天堂

最新推荐文章于 2024-08-26 08:12:22 发布

阅读量433

点赞数

CC 4.0 BY-SA版权

分类专栏： java 文章标签： java Java JAVA js验证非法字符编程

本文链接：https://blog.youkuaiyun.com/linwei_hello/article/details/8494389

java 专栏收录该内容

52 篇文章

订阅专栏

public DataPackage listChannelOperator(ChannelForm channelForm, int pageNo,
           int pageSize) {
       StringBuffer hql = new StringBuffer();
       //设置过滤条件【主操作员只能获取当前渠道下的普通操作员信息】
       hql.append("select e.nodeName, r.realm, e.businessAddress, w.account, w.name, w.timeCreated, w.email, w.contactPhone, w.state, w.operId FROM CfOperatorEx e, CfOperatorW w, RealmW r where w.operId = e.operId and r.realmId = w.realmId and w.operHeadFlag = 2 and w.channelId = " + channelForm.getParentChannelId());

       if (channelForm.getChannelName() != null && !"".equals(channelForm.getChannelName())) {
           hql.append(" and e.nodeName like '%").append(channelForm.getNodeName()).append("%'");

       }
       if (channelForm.getStartTime() != null && !"".equals(channelForm.getStartTime()) ) {
           hql.append(" and w.timeCreated >= to_date('").append(channelForm.getStartTime()).append(" 00:00:00','yyyy-mm-dd HH24:MI:SS')");

       }
       if (channelForm.getEndTime() != null && !"".equals(channelForm.getEndTime()) ) {
           hql.append(" and w.timeCreated <= to_date('").append(channelForm.getEndTime()).append(" 23:59:59','yyyy-mm-dd HH24:MI:SS ')");

       }

       DataPackage channelUserInfoList = queryPagination(hql.toString(),
               pageNo, pageSize);

       return channelUserInfoList;

}