private void BindPartnerListGrid()
{
_orderFeedbackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_orderFeedbackEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_orderFeedbackEntity.LogMessages.Username = UserSession.Current.UserDspName;
_orderFeedbackEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_orderFeedbackEntity.orderFeedbackDBEntity = new List<OrderFeedbackDBEntity>();
OrderFeedbackDBEntity orderinfoEntity = new OrderFeedbackDBEntity();
orderinfoEntity.OrderNum = ViewState["OrderNum"].ToString();
orderinfoEntity.CreateTimeStart = ViewState["CreateTimeStart"].ToString();
orderinfoEntity.CreateTimeEnd = ViewState["CreateTimeEnd"].ToString();
orderinfoEntity.UpdateTimeStart = ViewState["UpdateTimeStart"].ToString();
orderinfoEntity.UpdateTimeEnd = ViewState["UpdateTimeEnd"].ToString();
orderinfoEntity.IsProcess = ViewState["IsProcess"].ToString();
_orderFeedbackEntity.orderFeedbackDBEntity.Add(orderinfoEntity);
DataSet dsResult = OrderFeedbackBP.BindOrderFeedBackList(_orderFeedbackEntity).QueryResult;
gridViewCSList.DataSource = dsResult.Tables[0].DefaultView;
gridViewCSList.DataKeyNames = new string[] { "ORDER_NUM" };//主键
gridViewCSList.DataBind();
}
protected void btnDetails_Click(object sender, EventArgs e)
{
_orderFeedbackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_orderFeedbackEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_orderFeedbackEntity.LogMessages.Username = UserSession.Current.UserDspName;
_orderFeedbackEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_orderFeedbackEntity.orderFeedbackDBEntity = new List<OrderFeedbackDBEntity>();
OrderFeedbackDBEntity orderinfoEntity = new OrderFeedbackDBEntity();
orderinfoEntity.OrderNum = this.hidOrderNum.Value;
this.lblOrderNum.Text = this.hidOrderNum.Value;
_orderFeedbackEntity.orderFeedbackDBEntity.Add(orderinfoEntity);
DataSet dsResult = OrderFeedbackBP.BindOrderDetailsByOrderNum(_orderFeedbackEntity).QueryResult;
if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0)
{
this.lblHotelName.Text = dsResult.Tables[0].Rows[0]["HOTEL_NAME"].ToString();//预定酒店
this.lblPriceCode.Text = dsResult.Tables[0].Rows[0]["PRICE_CODE"].ToString();//价格代码
this.lblHotelLinkMan.Text = dsResult.Tables[0].Rows[0]["sales_account"].ToString();//酒店负责销售
this.lblPhone.Text = dsResult.Tables[0].Rows[0]["LOGIN_MOBILE"].ToString();//预订人号码
this.lblCreateTime.Text = dsResult.Tables[0].Rows[0]["CREATE_TIME"].ToString();//订单创建日期
this.lblHotelLinkTel.Text = GetUserTel(dsResult.Tables[0].Rows[0]["sales_account"].ToString());//酒店销售电话
this.lblGuestName.Text = dsResult.Tables[0].Rows[0]["GUEST_NAMES"].ToString();//入住人姓名
this.lblVendor.Text = dsResult.Tables[0].Rows[0]["vendor"].ToString();//酒店供应商
if (dsResult.Tables[0].Rows[0]["OrderAffirmLinkTel"].ToString() != "" && dsResult.Tables[0].Rows[0]["OrderAffirmLinkTel"].ToString().Split('|').Length >= 23)
{
this.lblhotelTel.Text = dsResult.Tables[0].Rows[0]["OrderAffirmLinkTel"].ToString().Split('|')[System.DateTime.Now.Hour];//酒店电话
}
else
{
this.lblhotelTel.Text = "";
}
this.lblRoomName.Text = dsResult.Tables[0].Rows[0]["ROOM_TYPE_NAME"].ToString();//房型名称
this.lblBookTotalPrice.Text = dsResult.Tables[0].Rows[0]["BOOK_TOTAL_PRICE"].ToString();//订单总金额
if (dsResult.Tables[0].Rows[0]["OrderVerifyLinkTel"].ToString() != "" && dsResult.Tables[0].Rows[0]["OrderVerifyLinkTel"].ToString().Split('|').Length >= 23)
{
this.lblReviewTel.Text = dsResult.Tables[0].Rows[0]["OrderVerifyLinkTel"].ToString().Split('|')[System.DateTime.Now.Hour];//审核电话
}
else
{
this.lblReviewTel.Text = "";
}
string IN_DATE = dsResult.Tables[0].Rows[0]["IN_DATE"].ToString() == "" ? "" : DateTime.Parse(dsResult.Tables[0].Rows[0]["IN_DATE"].ToString()).ToShortDateString();
string OUT_DATE = dsResult.Tables[0].Rows[0]["OUT_DATE"].ToString() == "" ? "" : DateTime.Parse(dsResult.Tables[0].Rows[0]["OUT_DATE"].ToString()).ToShortDateString();
this.lblInOrOutDate.Text = IN_DATE + "--" + OUT_DATE; //入住 - 离店
this.lblTicketCode.Text = dsResult.Tables[0].Rows[0]["PROMOTION_AMOUNT"].ToString();//返现券金额
this.hidBookStatusOther.Value = dsResult.Tables[0].Rows[0]["book_status_other"].ToString();
this.lblBookStatusOther.Text = dsResult.Tables[0].Rows[0]["book_status_other"].ToString().Replace("0", "新建").Replace("1", "预订成功等待确认").Replace("2", "新建入fog失败").Replace("3", "用户取消").Replace("4", "可入住已确认").Replace("5", "NO-SHOW").Replace("6", "已完成").Replace("7", "审核中").Replace("8", "离店").Replace("9", "CC取消"); //当前HVP状态
this.lblVendorStatus.Text = GetVenderStatus(this.hidOrderNum.Value);//当前供应商状态
this.lblNSRoomNum.Text = this.hidContent.Value;//用户申诉房号
this.txtINRoomNum.Text = this.hidContent.Value;
}
else
{
this.lblHotelName.Text = "";//预定酒店
this.lblPriceCode.Text = "";//价格代码
this.lblHotelLinkMan.Text = "";//酒店负责销售
this.lblPhone.Text = "";//预订人号码
this.lblCreateTime.Text = "";//订单创建日期
this.lblHotelLinkTel.Text = "";//酒店销售电话
this.lblGuestName.Text = "";//入住人姓名
this.lblVendor.Text = "";//酒店供应商
this.lblhotelTel.Text = "";//酒店电话
this.lblRoomName.Text = "";//房型名称
this.lblBookTotalPrice.Text = "";//订单总金额
this.lblReviewTel.Text = "";//审核电话
this.lblInOrOutDate.Text = "";//入住 - 离店
this.lblTicketCode.Text = "";//返现券金额
this.lblRoomName.Text = "";//当前HVP状态
this.lblBookTotalPrice.Text = "";//当前供应商状态
this.lblReviewTel.Text = "";//用户申诉房号
}
ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "setScript", "invokeOpenList()", true);
}
/// <summary>
/// 确认修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnVerifyUpdate_Click(object sender, EventArgs e)
{
_orderFeedbackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_orderFeedbackEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_orderFeedbackEntity.LogMessages.Username = UserSession.Current.UserDspName;
_orderFeedbackEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_orderFeedbackEntity.orderFeedbackDBEntity = new List<OrderFeedbackDBEntity>();
OrderFeedbackDBEntity orderFeedbackDBEntity = new OrderFeedbackDBEntity();
//接口
_orderInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_orderInfoEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_orderInfoEntity.LogMessages.Username = UserSession.Current.UserDspName;
_orderInfoEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_orderInfoEntity.OrderInfoDBEntity = new List<OrderInfoDBEntity>();
OrderInfoDBEntity orderinfoEntity = new OrderInfoDBEntity();
//orderinfoEntity.EventType = "NS订单申诉";
orderinfoEntity.FOG_ORDER_NUM = this.hidOrderNum.Value;
orderinfoEntity.BOOK_STATUS = this.dropStatus.Items[dropStatus.SelectedIndex].Text;
orderinfoEntity.BOOK_STATUS_OTHER = this.dropStatus.Items[dropStatus.SelectedIndex].Value;
orderinfoEntity.REMARK = this.txtRemark.InnerText;//备注
if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "8")//离店
{
orderinfoEntity.ApproveId = txtAffirmNum.Text;//离店 确认号
orderinfoEntity.ROOM_TYPE_CODE = txtINRoomNum.Text; //离店 房间号
orderinfoEntity.EventType = "订单审核";
}
else if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "5")//No-Show
{
orderinfoEntity.EventType = "订单审核";
orderinfoEntity.CanelReson = ddpNoShow.SelectedValue;//No-Show 原因
}
else if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "3")//用户取消
{
orderinfoEntity.EventType = "订单确认";
}
else if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "9")//CC取消
{
orderinfoEntity.EventType = "订单确认";
orderinfoEntity.CanelReson = ddpCanelReson.SelectedValue;//CC取消原因
}
else
{
orderinfoEntity.EventType = "订单审核";
orderinfoEntity.BOOK_STATUS = this.hidBookStatusOther.Value;
orderinfoEntity.BOOK_STATUS_OTHER = this.lblBookStatusOther.Text;
orderinfoEntity.REMARK = "确认不修改" + this.txtRemark.InnerText;//备注
}
orderinfoEntity.IsDbApprove = "1";
orderinfoEntity.USER_ID = UserSession.Current.UserAccount;
_orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity);
_orderInfoEntity = OrderInfoBP.updateIssueOrder(_orderInfoEntity);
string Result = _orderInfoEntity.Result.ToString();
string ErrMSG = _orderInfoEntity.ErrorMSG;
// sql库
int i = OrderInfoBP.InsertOrderActionHisList(_orderInfoEntity, _orderInfoEntity.ErrorMSG).Result;
if (Result != "1")
{
btnDetails_Click(null, null);
ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "alertScript", "alert('" + ErrMSG + "!');", true);
return;
}
else
{
orderFeedbackDBEntity.OrderNum = this.hidOrderNum.Value;
orderFeedbackDBEntity.IsProcess = "1";//已处理
orderFeedbackDBEntity.OperatorZH1 = UserSession.Current.UserAccount;//处理人
orderFeedbackDBEntity.UpdateTimeStart = System.DateTime.Now.ToString().Replace("/", "-");
orderFeedbackDBEntity.Content = this.dropStatus.Items[dropStatus.SelectedIndex].Value;
_orderFeedbackEntity.orderFeedbackDBEntity.Add(orderFeedbackDBEntity);
OrderFeedbackBP.UpdateOrderFeedBack(_orderFeedbackEntity);
ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeCloseList()", true);
btnSearch_Click(null, null);
ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "alertMsg", "alert('操作成功!');", true);
}
}
/// <summary>
/// 获取酒店销售人员 电话
/// </summary>
/// <param name="userAccount"></param>
/// <returns></returns>
public string GetUserTel(string userAccount)
{
_orderFeedbackEntity.LogMessages = new HotelVp.Common.Logger.LogMessage();
_orderFeedbackEntity.LogMessages.Userid = UserSession.Current.UserAccount;
_orderFeedbackEntity.LogMessages.Username = UserSession.Current.UserDspName;
_orderFeedbackEntity.LogMessages.IpAddress = UserSession.Current.UserIP;
_orderFeedbackEntity.orderFeedbackDBEntity = new List<OrderFeedbackDBEntity>();
OrderFeedbackDBEntity orderinfoEntity = new OrderFeedbackDBEntity();
_orderFeedbackEntity.orderFeedbackDBEntity.Add(orderinfoEntity);
string Result = OrderFeedbackBP.GetUserTel(_orderFeedbackEntity, userAccount);
return Result;
}