Index: ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/consumptivematerial/action/ConsumptiveMaterialContainerAction.java =================================================================== diff -u -r34055 -r34057 --- ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/consumptivematerial/action/ConsumptiveMaterialContainerAction.java (.../ConsumptiveMaterialContainerAction.java) (revision 34055) +++ ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/consumptivematerial/action/ConsumptiveMaterialContainerAction.java (.../ConsumptiveMaterialContainerAction.java) (revision 34057) @@ -377,7 +377,7 @@ int pageSize = StrutsParamUtils.getPraramValue("pageSize", 20); String dateSql = ""; if(StringUtils.isNotBlank(startDate) && StringUtils.isNotBlank(endDate)){ - dateSql = " and " + dateQueryAdapter.strDateAreasql("po.operationDateTime", startDate, endDate, true); + dateSql = " and " + dateQueryAdapter.dateAreaSql("po.operationDateTime", startDate, endDate, true); } String typeSql = ""; if(DatabaseUtil.isPoIdValid(consumptiveMaterialTypeId)){