## 問題：退租辦理里面什么都沒有？ ## 原因：退款科目沒有對應的反向科目。  ## 誤退房后如何恢復？ ## 答案 ``` 1.還原主訂單正常狀態 也可以where MJOrderid=2481 update MJOrder set istuidate=null,orderstatus=0 where edNumber='RZ-20180824-001' 2.更新字訂單 正常狀態 update MJOrderDetail set orderstatus=0 where MJOrderid=2481 3.更新房間正常狀態 update MJRooms set state='租賃中',add_time='2018-08-24 10:42:56.040',up_time='2018-08-24 10:42:56.040',exp_time='2018-09-23 00:00:00.000',usernames='施澤權,易林豐',userids=0,usermobiles='18787136723,13888897885',orderstart_time='2018-08-24 00:00:00.000',orderend_time='2018-09-23 00:00:00.000',zuqi=1,jzrs=2,OrderId=2481,nextpaydate='2018-09-18 00:00:00.000' where roomnumber='6307' and keyid=853 ``` ## 退租時所有填成0如何更正 ``` update MJFinanceDetail set sumMoney=-1000 where keyid=44713 update MJFinanceDetail set sumMoney=-63 where keyid=44716 update MJFinanceMain set shifub=-1063,total=-1063,payment=-1063 where KeyId=13887 ```  ## 問題：刪除重開的房間 先刪除訂單主表，訂單明細表;再刪除財務主表、財務明細表 ``` delete FROM [bds257174606_db].[dbo].[MJOrder] where edNumber='RZ-20190118-003' delete FROM [bds257174606_db].[dbo].[MJOrderDetail] where edNumber='RZ-20190118-003' delete FROM [bds257174606_db].[dbo].[MJFinanceMain] where edNumber='RZ-20190118-003' delete FROM [bds257174606_db].[dbo].[MJFinanceDetail] where edNumber='RZ-20190118-003' ``` ## 更新房間狀態 ``` update [bds257174606_db].[dbo].[MJRooms] set state='空閑' where roomnumber='6315' and keyid=291 ``` ## 恢復6359刪除標記 ``` update [bds257174606_db].[dbo].[MJRooms] set isdel=0 where vestid=186 and roomnumber='6359' ```