update TousseDefinition set tousseAmount=1,workLoadStatisticalMethod='按包' where tousseType in('外来器械包','外来器械拆分小包'); update TousseInstance set statisticsAmount=1 where tousseDefinition_id in (select tousseDefinition_id from TousseDefinition where tousseType in ('外来器械包','外来器械拆分小包')) and statisticsAmount<>1;