Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java =================================================================== diff -u -r16274 -r16284 --- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 16274) +++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/dwr/table/SterilizationRecordTableManager.java (.../SterilizationRecordTableManager.java) (revision 16284) @@ -151,7 +151,7 @@ String needFinishConfirm = sqlWhereParamMap.get("needFinishConfirm"); String comfirmSql = ""; if(StringUtils.isNotBlank(needFinishConfirm)){ - comfirmSql = " or po.isSituationComfirm = 0 "; + comfirmSql = " or po.isSituationComfirm = 0 or po.isSituationComfirm is null "; } sql += " and ((po.startDate between " + dateQueryAdapter.dateAdapter(out_beginTime) + " and "