Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r30447 -r30448 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 30447) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 30448) @@ -14702,9 +14702,9 @@ } String fdioValueSql = null;//查询fdio.Value时加上序号,解决报表排序问题 if(dbConnection.isOracle()){ - fdioValueSql = ",fdio.orderNumber || 'P+' || fdio.value value"; + fdioValueSql = ",case when fdio.orderNumber<10 then '0' || fdio.orderNumber || 'P+' || fdio.value else fdio.orderNumber || 'P+' || fdio.value end value"; }else{ - fdioValueSql = ",CONVERT(varchar(10), fdio.orderNumber) + 'P+' + fdio.value value"; + fdioValueSql = ",case when fdio.orderNumber<10 then '0' + CONVERT(varchar(10), fdio.orderNumber) + 'P+' + fdio.value else CONVERT(varchar(10), fdio.orderNumber) + 'P+' + fdio.value end value"; } String extraQueryForResponsibilityPart = null; String extraJoinForResponsibilityPart = null;