update SterilizationRecord set biologicalMonitoringStatus='未做' where biologicalMonitoringEndDate is null; update SterilizationRecord set biologicalMonitoringStatus='进行中' where biologicalMonitoringEndDate>=GETDATE(); update SterilizationRecord set biologicalMonitoringStatus='已结束' where biologicalMonitoringEndDate<=GETDATE() and monitorChecker is null; update SterilizationRecord set biologicalMonitoringStatus='已确认' where biologicalMonitoringEndDate<=GETDATE() and monitorChecker is not null;