业主迁出删除收费标准

业主迁出删除收费标准

select * from TBL_Estate_RoomInfomation where SerialNumber like ‘套户名称’

B1D5CE8D-4E65-4897-A405-0252505EADE1

select * from TBL_Consumer_JoinInfo where RoomID = '57B8A792-A5D1-444E-8B03-11336568CF40’and IsMove = 1

ownerid= 3A79C186-80E5-4D97-B33B-4B4EE9F364D8 D72E2F75-03EC-4FD5-A6C0-29FB18E82B73

select * from TBL_Charge_StandarInfoAllot where ConsumerID =‘D72E2F75-03EC-4FD5-A6C0-29FB18E82B73’

delete TBL_Charge_StandarInfoAllot where ConsumerID =‘D72E2F75-03EC-4FD5-A6C0-29FB18E82B73’