<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                ## 問題:退租辦理里面什么都沒有? ## 原因:退款科目沒有對應的反向科目。 ![](https://box.kancloud.cn/b3a529680e8968586293cd3f92c9a438_1702x903.JPG) ## 誤退房后如何恢復? ## 答案 ``` 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 ``` ![](https://box.kancloud.cn/e8fd349a2093811229b417b83c612132_920x657.png) ## 問題:刪除重開的房間 先刪除訂單主表,訂單明細表;再刪除財務主表、財務明細表 ``` 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' ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看