后台:酒店客服订单管理.把订单编号：1290939 从取消状态恢复确认有房状态(待发单状态)

D:\AllSVN\hwlyAll\hwly\Official\DTcms.DAL\Order\D_OrderInfo.cs

--全部(客服酒店)
Select a.id,mark,orderStatus,a.Payment,Demand, jd_name,a.Jd_phone,dpjj,cbPrice,Integral, a.MobileNum,yPrice, Paymentstatus, Receivablesamount,Specifiedprice, endtime,Aside, Rename, a.userid, a.nrid, jd_type, names, phone, num1, num2, num3, hdnum1, hdnum2, hdnum3, a.AddTime, startTime, zhk, ToTime,Ordersamount,supplieruserid,a.updatetime,b.IsRefund,b.RefundMoney,b.TrueRefundMoney,b.SuccessStatus 
From ZL_OrderInfo a left join TX_OrderOperate b on a.id= b.oid 
Where  convert(varchar(1),Internalrecords)=2   
--待付款(客服酒店)
Select a.id,mark,orderStatus,a.Payment,Demand, jd_name,a.Jd_phone,dpjj,cbPrice,Integral, a.MobileNum,yPrice, Paymentstatus, Receivablesamount,Specifiedprice, endtime,Aside, Rename, a.userid, a.nrid, jd_type, names, phone, num1, num2, num3, hdnum1, hdnum2, hdnum3, a.AddTime, startTime, zhk, ToTime,Ordersamount,supplieruserid,a.updatetime,b.IsRefund,b.RefundMoney,b.TrueRefundMoney,b.SuccessStatus 
From ZL_OrderInfo a left join TX_OrderOperate b on a.id= b.oid 
Where  convert(varchar(1),Internalrecords)=2  and (convert(varchar(4),orderStatus) = 1010)  
--待确定(客服酒店)
Select a.id,mark,orderStatus,a.Payment,Demand, jd_name,a.Jd_phone,dpjj,cbPrice,Integral, a.MobileNum,yPrice, Paymentstatus, Receivablesamount,Specifiedprice, endtime,Aside, Rename, a.userid, a.nrid, jd_type, names, phone, num1, num2, num3, hdnum1, hdnum2, hdnum3, a.AddTime, startTime, zhk, ToTime,Ordersamount,supplieruserid,a.updatetime,b.IsRefund,b.RefundMoney,b.TrueRefundMoney,b.SuccessStatus 
From ZL_OrderInfo a 
left join TX_OrderOperate b on a.id= b.oid 
Where  convert(varchar(1),Internalrecords)=2  and (convert(varchar(4),orderStatus) = 1000)  

--待发单(客服酒店)
Select a.id,mark,orderStatus,a.Payment,Demand, jd_name,a.Jd_phone,dpjj,cbPrice,Integral, a.MobileNum,yPrice, Paymentstatus, Receivablesamount,Specifiedprice, endtime,Aside, Rename, a.userid, a.nrid, jd_type, names, phone, num1, num2, num3, hdnum1, hdnum2, hdnum3, a.AddTime, startTime, zhk, ToTime,Ordersamount,supplieruserid,a.updatetime,b.IsRefund,b.RefundMoney,b.TrueRefundMoney,b.SuccessStatus 
From ZL_OrderInfo a left join TX_OrderOperate b on a.id= b.oid 
Where  convert(varchar(1),Internalrecords)=2  and (convert(varchar(4),orderStatus) = 1020)  
and a.id=1290939

--成功预订(客服酒店)
Select a.id,mark,orderStatus,a.Payment,Demand, jd_name,a.Jd_phone,dpjj,cbPrice,Integral, a.MobileNum,yPrice, Paymentstatus, Receivablesamount,Specifiedprice, endtime,Aside, Rename, a.userid, a.nrid, jd_type, names, phone, num1, num2, num3, hdnum1, hdnum2, hdnum3, a.AddTime, startTime, zhk, ToTime,Ordersamount,supplieruserid,a.updatetime,b.IsRefund,b.RefundMoney,b.TrueRefundMoney,b.SuccessStatus 
From ZL_OrderInfo a left join TX_OrderOperate b on a.id= b.oid 
Where  convert(varchar(1),Internalrecords)=2  and (convert(varchar(4),orderStatus) = 1030) 
and a.id=1290939
--需要退款(客服酒店)
Select a.id,mark,orderStatus,a.Payment,Demand, jd_name,a.Jd_phone,dpjj,cbPrice,Integral, a.MobileNum,yPrice, Paymentstatus, Receivablesamount,Specifiedprice, endtime,Aside, Rename, a.userid, a.nrid, jd_type, names, phone, num1, num2, num3, hdnum1, hdnum2, hdnum3, a.AddTime, startTime, zhk, ToTime,Ordersamount,supplieruserid,a.updatetime,b.IsRefund,b.RefundMoney,b.TrueRefundMoney,b.SuccessStatus 
From ZL_OrderInfo a left join TX_OrderOperate b on a.id= b.oid 
Where  convert(varchar(1),Internalrecords)=2  and  IsRefund=1  
--已取消(客服酒店)
Select a.id,mark,orderStatus,a.Payment,Demand, jd_name,a.Jd_phone,dpjj,cbPrice,Integral, a.MobileNum,yPrice, Paymentstatus, Receivablesamount,Specifiedprice, endtime,Aside, Rename, a.userid, a.nrid, jd_type, names, phone, num1, num2, num3, hdnum1, hdnum2, hdnum3, a.AddTime, startTime, zhk, ToTime,Ordersamount,supplieruserid,a.updatetime,b.IsRefund,b.RefundMoney,b.TrueRefundMoney,b.SuccessStatus 
From ZL_OrderInfo a left join TX_OrderOperate b on a.id= b.oid 
Where  convert(varchar(1),Internalrecords)=2  and (convert(varchar(4),orderStatus) =1090)  
and a.id=1290939

--订单编号:1290939 帮我恢复个酒店订单,恢复到确认有房里面
select  OrderStatus,*
from ZL_OrderInfo
where id=1290939

update ZL_OrderInfo
set orderStatus=1020
where id=1290939