修改

whyclxw

2020-11-10 378761c11fbbda4f5cb47c6a2e4651db38492ca0

修改

 DyEnvir_system/src/com/fgkj/dao/impl/User_logImpl.java

@@ -104,6 +104,7 @@
        }else{
            sql=baseSql+sqlT;
        }
		
        //设备类型 
        String sql_devT=" and uSystemType=? ";
        String sql_devF=" and uSystemType!=? ";
@@ -112,12 +113,20 @@
        }else{
            sql+=sql_devT;
        }
        //设备类型 
        String sql_userT=" and uid=? ";
        String sql_userF=" and uid!=? ";
        if(ulog.getuId()==0){
            sql+=sql_userF;
        }else{
            sql+=sql_userT;
        }
        String endsql = "   ORDER BY uOprateDay DESC ";
        sql= sql+endsql;
        String limitSql=" limit ?,? ";
        sql+=limitSql;
        //System.out.println(sql);
        List<User_log> list = DAOHelper.executeQueryLimit(sql, conn, new Object[]{ulog.getuOprateDay(),ulog.getuOprateDay1(),ulog.getuOprateType(),ulog.getuSystemType(),(ulog.getPage().getPageCurr() - 1)* ulog.getPage().getPageSize(),
        List<User_log> list = DAOHelper.executeQueryLimit(sql, conn, new Object[]{ulog.getuOprateDay(),ulog.getuOprateDay1(),ulog.getuOprateType(),ulog.getuSystemType(),ulog.getuId(),(ulog.getPage().getPageCurr() - 1)* ulog.getPage().getPageSize(),
                        ulog.getPage().getPageSize()
          },new CallBack() {