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; }