迁出业主费用删除

select * from TBL_Estate_RoomInfomation where SerialNumber = ‘高科新花园/新1号楼/1单元/073室’

15307375-D6E7-42D9-A07D-DAD3A0A98A07

select * from TBL_Consumer_JoinInfo where RoomID = ‘6C713370-0B97-49B8-8471-87E314EF269D’ and isMove =1

BE26BCE1-03D7-4C93-A9EE-8BF36E95A150

select * from TBL_Consumer_BaseInformation where ID = ‘B93F1C58-07FD-4639-8062-1ED0600A1731’

delete from TBL_Charge_CostingInfo where RoomID = ‘6C713370-0B97-49B8-8471-87E314EF269D’
and ConsumerID = ‘B93F1C58-07FD-4639-8062-1ED0600A1731’ and FeeBalance > 0