Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r18374 -r18382 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18374) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 18382) @@ -12663,8 +12663,7 @@ // formName, materialName, tousseName, monitoringType); String whereSql = buildDeviceMaintenaceWhereSQL(startDay, endDay, querySupplyRoom, deviceMaintenanceName); - String dataSql = dateQueryAdapter.dateToVarchar1("dmci.maintenanceTime"); - //CONVERT(varchar(10), qmi.dateTime, 120) to_char(qmi.dateTime, 'yyyy-MM-dd') + String dataSql = dateQueryAdapter.dateToVarchar3("dmci.maintenanceTime"); String sql = " select " + dataSql + " dateStr," + " fd.formName formName,dmci.projectName projectName,dmci.id dmciId,fi.createUserName createUserName," + " fdi.name fdiName, fdi.orderNumber orderNum,fdio.value,fiov.id " Index: forgon-core/src/main/java/com/forgon/databaseadapter/service/DateQueryAdapter.java =================================================================== diff -u -r17493 -r18382 --- forgon-core/src/main/java/com/forgon/databaseadapter/service/DateQueryAdapter.java (.../DateQueryAdapter.java) (revision 17493) +++ forgon-core/src/main/java/com/forgon/databaseadapter/service/DateQueryAdapter.java (.../DateQueryAdapter.java) (revision 18382) @@ -189,6 +189,23 @@ return ""; } /** + * 时间类型转换成字符串,取年月日时分 + * @param property + * @return + */ + public String dateToVarchar3(String property) { + if (StringUtils.isNotBlank(property)) { + if (dbConnection.isSqlServer()) { + return "CONVERT(varchar(16),"+property+",120)"; + } else if (dbConnection.isOracle()) { + return "to_char("+property+",'yyyy-mm-dd HH24:MI')"; + } else if (dbConnection.isMySQL()) { + return property ; + } + } + return ""; + } + /** * 替换sql查询条件的日期 * * @param date Index: ssts-web/src/main/webapp/jasperRtp/deviceMaintenanceCusReport.jasper =================================================================== diff -u -r18380 -r18382 Binary files differ Index: ssts-web/src/main/webapp/jasperRtp/deviceMaintenanceCusReport.jrxml =================================================================== diff -u -r18380 -r18382 --- ssts-web/src/main/webapp/jasperRtp/deviceMaintenanceCusReport.jrxml (.../deviceMaintenanceCusReport.jrxml) (revision 18380) +++ ssts-web/src/main/webapp/jasperRtp/deviceMaintenanceCusReport.jrxml (.../deviceMaintenanceCusReport.jrxml) (revision 18382) @@ -121,7 +121,7 @@ - + Index: ssts-web/src/main/java/com/forgon/disinfectsystem/devicemaintenancecus/devicemaintenancecusins/service/DeviceMaintenanceCusInsManagerImpl.java =================================================================== diff -u -r18380 -r18382 --- ssts-web/src/main/java/com/forgon/disinfectsystem/devicemaintenancecus/devicemaintenancecusins/service/DeviceMaintenanceCusInsManagerImpl.java (.../DeviceMaintenanceCusInsManagerImpl.java) (revision 18380) +++ ssts-web/src/main/java/com/forgon/disinfectsystem/devicemaintenancecus/devicemaintenancecusins/service/DeviceMaintenanceCusInsManagerImpl.java (.../DeviceMaintenanceCusInsManagerImpl.java) (revision 18382) @@ -131,9 +131,11 @@ String maintenanceTimeStr = requestParams.get("maintenanceTime"); String createDateStr = requestParams.get("createDate"); Date date = sdf.parse(maintenanceTimeStr); - Date createDate = sdf.parse(createDateStr); dmInstance.setMaintenanceTime(date); - dmInstance.setCreateDate(createDate); + if(StringUtils.isNotBlank(createDateStr) && createDateStr.length() > 14){ + Date createDate = sdf.parse(createDateStr); + dmInstance.setCreateDate(createDate); + } dmInstance.setRegistrant(dmInstance.getCreateUserName()); dmInstance.setDeviceName(requestParams.get("formName"));