update recyclingdamageitem set linkType = (select r.linktype from recyclingdamagerecord r where r.id = recyclingdamageitem.recyclingdamagerecord_id), damageOfPeople = (select r.damageofpeople from recyclingdamagerecord r where r.id = recyclingdamageitem.recyclingdamagerecord_id), depart = (select r.depart from recyclingdamagerecord r where r.id = recyclingdamageitem.recyclingdamagerecord_id), departCoding = (select r.departcoding from recyclingdamagerecord r where r.id = recyclingdamageitem.recyclingdamagerecord_id), time = (select r.time from recyclingdamagerecord r where r.id = recyclingdamageitem.recyclingdamagerecord_id), handleDepartCode = (select r.additionalDeptCode from recyclingdamagerecord r where r.id = recyclingdamageitem.recyclingdamagerecord_id); update recyclingdamageitem set status = '已补充' where amount = additionalAmount; update recyclingdamageitem set status = '未补充' where additionalAmount = 0; update recyclingdamageitem set status = '部分补充' where additionalAmount > 0 and additionalAmount < amount;