private void BandData(string hotelID, string outSDate, string outEDate, string orderStatus, string orderID) { lbFaxDate.Text = DateTime.Now.ToString(); lbFrom.Text = UserSession.Current.UserDspName; OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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.HotelID = hotelID; orderinfoEntity.StartDate = outSDate; orderinfoEntity.EndDate = outEDate; orderinfoEntity.OrderID = orderID; orderinfoEntity.AuditStatus = orderStatus; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.BindOrderApprovePrint(_orderInfoEntity).QueryResult; //gridViewCSList.DataSource = dsResult.Tables["PRINT"].DefaultView; //gridViewCSList.DataKeyNames = new string[] { "ORDROOM" };//主键 //gridViewCSList.DataBind(); SerOrderList(dsResult); if (dsResult.Tables["HLEX"].Rows.Count > 0) { lbHotelID.Text = String.Format("酒店名称:{0}(ID:{1})", dsResult.Tables["HLEX"].Rows[0]["prop_name_zh"].ToString(), dsResult.Tables["HLEX"].Rows[0]["hotel_id"].ToString()); string strTo = dsResult.Tables["HLEX"].Rows[0]["linkman"].ToString(); string strTelTo = dsResult.Tables["HLEX"].Rows[0]["linktel"].ToString(); string strFaxTo = dsResult.Tables["HLEX"].Rows[0]["linkfax"].ToString(); int iHour = DateTime.Now.Hour; lbTo.Text = (strTo.Split('|').Length >= iHour) ? strTo.Split('|')[iHour].ToString() : ""; lbTelTo.Text = (strTelTo.Split('|').Length >= iHour) ? strTelTo.Split('|')[iHour].ToString() : ""; lbFaxTo.Text = (strFaxTo.Split('|').Length >= iHour) ? strFaxTo.Split('|')[iHour].ToString() : ""; } else { lbHotelID.Text = ""; lbTo.Text = ""; lbTelTo.Text = ""; lbFaxTo.Text = ""; //lbTelFrom.Text = ""; //lbFaxFrom.Text = ""; } if (dsResult.Tables["UsersInfo"].Rows.Count > 0) { lbTelFrom.Text = dsResult.Tables["UsersInfo"].Rows[0]["User_Tel"].ToString(); } else { lbTelFrom.Text = ""; } }
public DataTable GetRefundOrderList(string hotelID, string sales, string startDate, string endDate, string orderNum, string payStatus) { _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.HOTEL_ID = hotelID; orderinfoEntity.UserID = sales; orderinfoEntity.StartDate = startDate; orderinfoEntity.EndDate = endDate; orderinfoEntity.FOG_ORDER_NUM = orderNum; orderinfoEntity.PAY_STATUS = payStatus; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.GetRefundOrderList(_orderInfoEntity).QueryResult.Tables[0]; return dtResult; }
/// <summary> /// 查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnlock_Click(object sender, EventArgs e) { string fogOrderNum = this.txtFogOrderNum.Text.Trim(); ViewState["HidFogOrderNum"] = this.txtFogOrderNum.Text.Trim(); _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.FOG_ORDER_NUM = fogOrderNum; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.OrderOperateStatus(_orderInfoEntity).QueryResult.Tables[0]; //如果是LMBAR的价格代码 直接跳过 提示不能改状态 if (dtResult != null && dtResult.Rows.Count > 0) { //if (dtResult.Rows[0]["PRICE_CODE"].ToString().Trim().Equals("LMBAR")) //{ // ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnCompleteStyle();", true); // ScriptManager.RegisterStartupScript(this.UpdatePanel5, this.GetType(), "alertScript", "alert('预付订单不能修改订单状态!');", true); // return; //} this.txtHotelName.Text = dtResult.Rows[0]["HOTEL_NAME"].ToString(); this.txtPriceCode.Text = dtResult.Rows[0]["PRICE_CODE"].ToString(); spanPriceCode.InnerHtml = dtResult.Rows[0]["PRICE_CODE"].ToString(); this.txtLoginMobile.Text = dtResult.Rows[0]["LOGIN_MOBILE"].ToString(); this.txtCreateTime.Text = dtResult.Rows[0]["CREATE_TIME"].ToString(); this.txtGuestNames.Text = dtResult.Rows[0]["GUEST_NAMES"].ToString(); this.txtVender.Text = dtResult.Rows[0]["vendor"].ToString(); this.txtRoomName.Text = dtResult.Rows[0]["ROOM_TYPE_NAME"].ToString(); this.txtBookTotalPrice.Text = dtResult.Rows[0]["BOOK_TOTAL_PRICE"].ToString(); string IN_DATE = dtResult.Rows[0]["IN_DATE"].ToString() == "" ? "" : DateTime.Parse(dtResult.Rows[0]["IN_DATE"].ToString()).ToShortDateString(); string OUT_DATE = dtResult.Rows[0]["OUT_DATE"].ToString() == "" ? "" : DateTime.Parse(dtResult.Rows[0]["OUT_DATE"].ToString()).ToShortDateString(); this.txtINOrOutDate.Text = IN_DATE + "--" + OUT_DATE; this.txtPromotionAmount.Text = dtResult.Rows[0]["PROMOTION_AMOUNT"].ToString(); if (!dtResult.Rows[0]["PRICE_CODE"].ToString().Trim().Equals("LMBAR")) { this.lblHVPStatus.Text = ReturnBookStatusOther(dtResult.Rows[0]["book_status_other"].ToString()); } else { if (dropStatus.Items.FindByValue("18") == null) dropStatus.Items.Add(new ListItem("已完成", "18"));//特别标记 this.lblHVPStatus.Text = ReturnBookStatus(dtResult.Rows[0]["book_status"].ToString()); } this.lblVendorStatus.Text = GetVenderStatus(fogOrderNum); GetOperateHis(dtResult.Rows[0]["order_num"].ToString()); this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "loadlowButton", "lowButton();", true); } else { this.txtHotelName.Text = ""; this.txtPriceCode.Text = ""; this.txtLoginMobile.Text = ""; this.txtCreateTime.Text = ""; this.txtGuestNames.Text = ""; this.txtVender.Text = ""; this.txtRoomName.Text = ""; this.txtBookTotalPrice.Text = ""; this.txtINOrOutDate.Text = ""; this.txtPromotionAmount.Text = ""; } this.UpdatePanel1.Update(); //this.UpdatePanel2.Update(); //this.UpdatePanel3.Update(); this.UpdatePanel6.Update(); ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updateScript", "BtnCompleteStyle();", true); }
private void ResetOrderConfirmListGrid() { OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); string strOrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); string strfaxNum = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxNum"].ToString())) ? null : ViewState["FaxNum"].ToString(); if (!String.IsNullOrEmpty(strOrderID) || !String.IsNullOrEmpty(strfaxNum)) { orderinfoEntity.OrderID = strOrderID; orderinfoEntity.FaxNum = strfaxNum; orderinfoEntity.SqlType = "1"; } else if (!String.IsNullOrEmpty(hidSelectCity.Value) || !String.IsNullOrEmpty(hidSelectHotel.Value) || !String.IsNullOrEmpty(hidSelectBussiness.Value)) { orderinfoEntity.City = hidSelectCity.Value == "" ? "" : hidSelectCity.Value.Substring((hidSelectCity.Value.IndexOf('[') + 1), (hidSelectCity.Value.IndexOf(']') - 1)); //"";//城市ID //orderinfoEntity.HotelID = hidSelectHotel.Value == "" ? "" : hidSelectHotel.Value.Substring((hidSelectHotel.Value.IndexOf('[') + 1), (hidSelectHotel.Value.IndexOf(']') - 1));//"";//酒店ID orderinfoEntity.Bussiness = hidSelectBussiness.Value == "" ? "" : hidSelectBussiness.Value.Substring((hidSelectBussiness.Value.IndexOf('[') + 1), (hidSelectBussiness.Value.IndexOf(']') - 1));//"";//商圈ID orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); orderinfoEntity.OrderID = strOrderID; orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); orderinfoEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); orderinfoEntity.FaxNum = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxNum"].ToString())) ? null : ViewState["FaxNum"].ToString(); //orderinfoEntity.FaxStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxStatus"].ToString())) ? null : ViewState["FaxStatus"].ToString(); orderinfoEntity.SqlType = "2"; } else { orderinfoEntity.OrderID = strOrderID; orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); orderinfoEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); //orderinfoEntity.FaxStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxStatus"].ToString())) ? null : ViewState["FaxStatus"].ToString(); orderinfoEntity.SqlType = "3"; } //orderinfoEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); //orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); //orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); //orderinfoEntity.OrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); //orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); //orderinfoEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.BindOrderApproveFaxList(_orderInfoEntity).QueryResult; if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { dvGridMessage.InnerHtml = "无审核订单"; } else { dvGridMessage.InnerHtml = ""; if (dsResult.Tables[0].Select("ORDERST='未审核'").Length == 0) { for (int i = 0; i < gridHotelList.Rows.Count; i++) { //首先判断是否是数据行 if (gridHotelList.Rows[i].RowType == DataControlRowType.DataRow && gridHotelList.DataKeys[i].Values[0].ToString().Equals(orderinfoEntity.HotelID)) { gridHotelList.Rows[i].BackColor = System.Drawing.ColorTranslator.FromHtml("#70A88C"); gridHotelList.Rows[i].Attributes.Add("onMouseOver", "t=this.style.backgroundColor;this.style.backgroundColor='#ebebce';"); gridHotelList.Rows[i].Attributes.Add("onMouseOut", "this.style.backgroundColor=t;"); //gridHotelList.Rows[i].Cells[0].Attributes.Add("bgcolor", "#70A88C"); //gridHotelList.Rows[i].Cells[1].Attributes.Add("bgcolor", "#70A88C"); //gridHotelList.Rows[i].Cells[0].Attributes.Add("onMouseOver", "t=this.style.backgroundColor;this.style.backgroundColor='#ebebce';c=this.parentNode.parentNode.childNodes[" + i + "].childNodes[1].style.backgroundColor;this.parentNode.parentNode.childNodes[" + i + "].childNodes[1].style.backgroundColor='#ebebce';"); //gridHotelList.Rows[i].Cells[0].Attributes.Add("onMouseOut", "this.style.backgroundColor=t;this.parentNode.parentNode.childNodes[" + i + "].childNodes[1].style.backgroundColor=c;"); //gridHotelList.Rows[i].Cells[1].Attributes.Add("onMouseOver", "t=this.style.backgroundColor;this.style.backgroundColor='#ebebce';c=this.parentNode.parentNode.childNodes[" + i + "].childNodes[0].style.backgroundColor;this.parentNode.parentNode.childNodes[" + i + "].childNodes[0].style.backgroundColor='#ebebce';"); //gridHotelList.Rows[i].Cells[1].Attributes.Add("onMouseOut", "this.style.backgroundColor=t;this.parentNode.parentNode.childNodes[" + i + "].childNodes[0].style.backgroundColor=c;"); } } } } gridViewCSList.Attributes.Add("style", "word-break:break-all;word-wrap:break-word"); gridViewCSList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSList.DataKeyNames = new string[] { "ORDERID" };//主键 gridViewCSList.DataBind(); }
protected void btnSet_Click(object sender, EventArgs e) { detailMessageContent.InnerHtml = ""; if (String.IsNullOrEmpty(hidOrderID.Value.Trim())) { dvErrorInfo.InnerHtml = GetLocalResourceObject("ErrorMessage").ToString(); //detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorMessage").ToString(); return; } if (!String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim()) && (StringUtility.Text_Length(txtBOOK_REMARK.Text.ToString().Trim()) > 250)) { dvErrorInfo.InnerHtml = GetLocalResourceObject("ErrorRemark").ToString(); //detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorRemark").ToString(); return; } _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = hidOrderID.Value; _lmSystemLogEntity.OrderBookStatus = ddpOrderStatus.SelectedValue.Trim(); _lmSystemLogEntity.CanelReson = ddpCanelReson.SelectedValue.Trim(); _lmSystemLogEntity.BookRemark = txtBOOK_REMARK.Text.Trim(); _lmSystemLogEntity.FollowUp = (chkFollowUp.Checked) ? "1" : "0"; int iResult = LmSystemLogBP.SaveOrderOperation(_lmSystemLogEntity); _commonEntity.LogMessages = _lmSystemLogEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单操作-保存"; commonDBEntity.Event_ID = hidHotelID.Value + "-" + _lmSystemLogEntity.FogOrderID; string conTent = GetLocalResourceObject("EventSaveMessage").ToString(); conTent = string.Format(conTent, _lmSystemLogEntity.FogOrderID, _lmSystemLogEntity.OrderBookStatus, _lmSystemLogEntity.BookRemark, _lmSystemLogEntity.CanelReson, _lmSystemLogEntity.FollowUp); commonDBEntity.Event_Content = conTent; if (iResult == 1) { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateSuccess").ToString(); //detailMessageContent.InnerHtml = GetLocalResourceObject("UpdateSuccess").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateSuccess").ToString(); } else if (iResult == 2) { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateLockErr").ToString(); //detailMessageContent.InnerHtml = GetLocalResourceObject("UpdateLockErr").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateLockErr").ToString(); } else { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError").ToString(); //detailMessageContent.InnerHtml = GetLocalResourceObject("UpdateError").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateError").ToString(); } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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 = "订单确认"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = SetActionTypeVal(ddpOrderStatus.SelectedValue.Trim()); orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.ActionID = ""; orderinfoEntity.CANNEL = ("9".Equals(ddpOrderStatus.SelectedValue.Trim())) ? ddpCanelReson.SelectedValue.Trim() : ""; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); lbMemo1.Text = SetMemoVal(_lmSystemLogEntity.FogOrderID); RestControlVal(); }
public static LmSystemLogEntity SaveConfirmOrderList(LmSystemLogEntity lmSystemLogEntity) { lmSystemLogEntity.LogMessages.MsgType = MessageType.INFO; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveConfirmOrderList"; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); try { if (!LmSystemLogDA.ChkOrderOperationLock(lmSystemLogEntity)) { lmSystemLogEntity.Result = 2; lmSystemLogEntity.ErrorMSG = "保存失败。订单:" + lmSystemLogEntity.FogOrderID + "已被其他人锁定,请稍后再试!"; return lmSystemLogEntity; } string[] ODList = lmSystemLogEntity.OrderList.TrimEnd(',').Split(','); string[] ODDetail; string strOdStatus = string.Empty; LmSystemLogEntity lmEntity = new LmSystemLogEntity(); lmEntity.LogMessages = new LogMessage(); lmEntity.LogMessages = lmSystemLogEntity.LogMessages; string strResult = string.Empty; string allMSG = string.Empty; int iCount = ODList.Length; foreach (string tempOD in ODList) { strResult = ""; ODDetail = tempOD.Split('_'); lmEntity.FogOrderID = ODDetail[0].Trim(); if (!LmSystemLogDA.ChkOrderOperationLock(lmEntity)) { lmSystemLogEntity.ErrorMSG += lmEntity.FogOrderID + ","; iCount = iCount - 1; continue; } if (!"2".Equals(ODDetail[1].Trim())) { lmEntity.OrderBookStatus = ("1".Equals(ODDetail[1].Trim())) ? "6" : "7";//CC确认 CC取消 lmEntity.OrderBookStatusOther = ("1".Equals(ODDetail[1].Trim())) ? "4" : "9"; lmEntity.CanelReson = ("0".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; lmEntity.BookRemark = ODDetail[3].Trim(); lmEntity.FollowUp = ("true".Equals(ODDetail[4].Trim())) ? "1" : "0"; lmEntity.ActionID = ("1".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; strResult = LmSystemLogBP.SaveOrderListInterFace(lmEntity); allMSG += strResult; iCount = (String.IsNullOrEmpty(strResult)) ? iCount : iCount - 1; } if (String.IsNullOrEmpty(strResult.Trim())) { if ("1".Equals(ODDetail[1].Trim())) { strOdStatus = "可入住"; } else if ("0".Equals(ODDetail[1].Trim())) { strOdStatus = "CC取消"; } else if ("2".Equals(ODDetail[1].Trim())) { strOdStatus = "备注"; } OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _orderInfoEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _orderInfoEntity.LogMessages = lmSystemLogEntity.LogMessages; _orderInfoEntity.OrderInfoDBEntity = new List<OrderInfoDBEntity>(); OrderInfoDBEntity orderinfoEntity = new OrderInfoDBEntity(); orderinfoEntity.EventType = "订单确认"; orderinfoEntity.ORDER_NUM = ODDetail[0].Trim(); orderinfoEntity.OdStatus = strOdStatus; orderinfoEntity.REMARK = (!"2".Equals(ODDetail[1].Trim())) ? ODDetail[3].Trim() : ODDetail[2].Trim(); orderinfoEntity.ActionID = ("1".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; orderinfoEntity.CANNEL = ("0".Equals(ODDetail[1].Trim())) ? ODDetail[2].Trim() : ""; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); } } if (!String.IsNullOrEmpty(lmSystemLogEntity.ErrorMSG) || !String.IsNullOrEmpty(allMSG.Trim())) { lmSystemLogEntity.Result = 3; lmSystemLogEntity.ErrorMSG = ((iCount > 0) ? "其他订单保存成功。" : "保存失败。") + allMSG.Trim() + ((!String.IsNullOrEmpty(lmSystemLogEntity.ErrorMSG)) ? ("订单:" + lmSystemLogEntity.ErrorMSG.TrimEnd(',') + " 被其他人锁定,请稍后再试!") : ""); } else { lmSystemLogEntity.Result = 1; } return lmSystemLogEntity; } catch (Exception ex) { lmSystemLogEntity.LogMessages.MsgType = MessageType.ERROR; lmSystemLogEntity.LogMessages.Content = _nameSpaceClass + "SaveConfirmOrderList Error: " + ex.Message + lmSystemLogEntity.OrderList; LoggerHelper.LogWriter(lmSystemLogEntity.LogMessages); throw ex; } }
//获取初审订单数 private DataTable GetOrderListNum(string sales, string startDate, string endDate) { _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.CONTACT_NAME = sales; orderinfoEntity.EventType = "订单审核"; orderinfoEntity.StartDate = startDate; orderinfoEntity.EndDate = endDate; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.GetFirstAppOrders(_orderInfoEntity).QueryResult.Tables[0]; return dtResult; }
//根据离店时间 订单城市 获取订单列表 public DataTable GetOrderList(string startDate, string endDate, string cityID) { _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.StartDate = startDate; orderinfoEntity.EndDate = endDate; orderinfoEntity.CITY_ID = cityID; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.OrderApprovedReport(_orderInfoEntity).QueryResult.Tables[0]; return dtResult; }
/// <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="fogOrderNum"></param> /// <returns></returns> public string GetVenderStatus(string fogOrderNum) { _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.FOG_ORDER_NUM = fogOrderNum; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); string Result = OrderInfoBP.orderQueryByOrderNum(_orderInfoEntity).ErrorMSG; return Result; }
private DataSet getHotelData() { //string sql = string.Empty; //if (ViewState["condition"] != null) //{ // sql = "select FOG_ORDER_NUM,CITY_ID,HOTEL_ID,HOTEL_NAME,ROOM_TYPE_NAME,IN_DATE,GUEST_NAMES,CONTACT_NAME,CONTACT_TEL,BOOK_STATUS,PAY_STATUS,BOOK_SOURCE,BOOK_PRICE,BOOK_ROOM_NUM,BOOK_TOTAL_PRICE,TICKET_AMOUNT,TICKET_USERCODE,TICKET_AMOUNT,TICKET_COUNT,CREATE_TIME,LOGIN_MOBILE from T_LM_ORDER where 1=1 " + ViewState["condition"].ToString(); //} //else //{ // sql = "select FOG_ORDER_NUM,CITY_ID,HOTEL_ID,HOTEL_NAME,ROOM_TYPE_NAME,IN_DATE,GUEST_NAMES,CONTACT_NAME,CONTACT_TEL,BOOK_STATUS,PAY_STATUS,BOOK_SOURCE,BOOK_PRICE,BOOK_ROOM_NUM,BOOK_TOTAL_PRICE,TICKET_AMOUNT,TICKET_USERCODE,TICKET_AMOUNT,TICKET_COUNT,CREATE_TIME,LOGIN_MOBILE from T_LM_ORDER"; //} //DataSet ds = HotelVp.Common.DBUtility.DbHelperOra.Query(sql); //return ds; _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 orderInfoDBEntity = new OrderInfoDBEntity(); orderInfoDBEntity.HOTEL_ID = ViewState["HOTEL_ID"].ToString(); orderInfoDBEntity.HOTEL_NAME = ViewState["HOTEL_NAME"].ToString(); orderInfoDBEntity.CITY_ID = ViewState["CITY_ID"].ToString(); orderInfoDBEntity.StartDate = ViewState["StartDate"].ToString(); orderInfoDBEntity.EndDate = ViewState["EndDate"].ToString(); orderInfoDBEntity.BOOK_STATUS = ViewState["BOOK_STATUS"].ToString(); orderInfoDBEntity.PAY_STATUS = ViewState["PAY_STATUS"].ToString(); orderInfoDBEntity.FOG_ORDER_NUM = ViewState["FOG_ORDER_NUM"].ToString(); _orderinfoEntity.OrderInfoDBEntity.Add(orderInfoDBEntity); DataSet dsResult = OrderInfoBP.BindOrderList(_orderinfoEntity).QueryResult; return dsResult; }
private string GetRoomNumber(string orderNum) { _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.FOG_ORDER_NUM = orderNum; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.GetCheckAppNSOrders(_orderInfoEntity).QueryResult.Tables[0]; return dtResult != null && dtResult.Rows.Count > 0 ? dtResult.Rows[0]["ROOM_ID"].ToString() : ""; }
/// <summary> /// 确认修改 (修改借口 sql日志) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOk_Click(object sender, EventArgs e) { //接口 _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 = "订单状态操作"; orderinfoEntity.FOG_ORDER_NUM = ViewState["HidFogOrderNum"].ToString(); orderinfoEntity.ActionID = "";//订单确认ID if (txtPriceCode.Text == "LMBAR") { //<option value="8">离店</option> //<option value="5">No-Show</option> //<option value="9">CC取消</option> this.dropStatus.Items[dropStatus.SelectedIndex].Value.Replace("9", "7").Replace("8", "9").Replace("5", "10").Replace("18", "8"); if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "9") orderinfoEntity.BOOK_STATUS_OTHER = "7"; if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "8") orderinfoEntity.BOOK_STATUS_OTHER = "5"; if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "5") orderinfoEntity.BOOK_STATUS_OTHER = "10"; if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "18") orderinfoEntity.BOOK_STATUS_OTHER = "8"; } else { orderinfoEntity.BOOK_STATUS_OTHER = this.dropStatus.Items[dropStatus.SelectedIndex].Value; } orderinfoEntity.TICKET_AMOUNT = this.ddlReturnTicket.Items[ddlReturnTicket.SelectedIndex].Value; orderinfoEntity.REMARK = this.txtRemark.InnerText;//备注 if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "9") { orderinfoEntity.CanelReson = ddpCanelReson.SelectedValue;//CC取消原因 } else if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "8") { orderinfoEntity.ApproveId = txtAffirmNum.Text;//离店 确认号 orderinfoEntity.ROOM_TYPE_CODE = txtINRoomNum.Text; //离店 房间号 } else if (this.dropStatus.Items[dropStatus.SelectedIndex].Value == "5") { orderinfoEntity.CanelReson = ddpNoShow.SelectedValue;//No-Show 原因 } orderinfoEntity.USER_ID = UserSession.Current.UserAccount; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); string Result = OrderInfoBP.updateIssueOrder(_orderInfoEntity).ErrorMSG; // sql库 int i = OrderInfoBP.InsertOrderActionHisList(_orderInfoEntity, Result).Result; GetOperateHis(ViewState["HidFogOrderNum"].ToString()); btnlock_Click(null, null); this.dropStatus.SelectedIndex = 0; this.txtRemark.InnerHtml = ""; ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "updateScript", "BtnCompleteStyle();", true); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "alertScript", "alert('" + Result + "!');", true); }
private void SetUnHotellock() { if (!String.IsNullOrEmpty(hidUnlockHotelID.Value)) { _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.HOTEL_ID = hidUnlockHotelID.Value.Trim(); _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); int iResut = OrderInfoBP.UnLockHotelOrderConfirm(_orderInfoEntity).Result; _commonEntity.LogMessages = _orderInfoEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单确认-解锁"; commonDBEntity.Event_ID = hidUnlockHotelID.Value.Trim(); string conTent = GetLocalResourceObject("EventUnHotelLockMessage").ToString(); conTent = string.Format(conTent, hidUnlockHotelID.Value.Trim(), _orderInfoEntity.LogMessages.Username); commonDBEntity.Event_Content = conTent; commonDBEntity.Event_Result = GetLocalResourceObject("UpdateUnLockSuccess").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); //BindOrderConfirmListGrid(); } }
protected void btnAddRemark_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim()) && (StringUtility.Text_Length(txtBOOK_REMARK.Text.ToString().Trim()) > 250)) { detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorRemark").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } if ("8".Equals(hidActionType.Value) && String.IsNullOrEmpty(txtInRoomID.Text.Trim())) { detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorAction").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = hidOrderID.Value; _lmSystemLogEntity.OrderBookStatus = hidActionType.Value; _lmSystemLogEntity.CanelReson = ddpNoShow.SelectedValue; _lmSystemLogEntity.BookRemark = txtBOOK_REMARK.Text.Trim(); _lmSystemLogEntity.ApproveId = txtActionID.Text.Trim(); _lmSystemLogEntity.InRoomID = txtInRoomID.Text.Trim(); int iResult = LmSystemLogBP.SaveOrderOpeRemarkList(_lmSystemLogEntity).Result; _commonEntity.LogMessages = _lmSystemLogEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单审核-保存"; commonDBEntity.Event_ID = hidOrderID.Value; string conTent = GetLocalResourceObject("EventSaveMessage").ToString(); conTent = string.Format(conTent, _lmSystemLogEntity.FogOrderID, _lmSystemLogEntity.OrderBookStatus, _lmSystemLogEntity.BookRemark, _lmSystemLogEntity.InRoomID, _lmSystemLogEntity.ApproveId, _lmSystemLogEntity.CanelReson); commonDBEntity.Event_Content = conTent; if (iResult == 1) { string strMsg = ""; if ("5".Equals(hidActionType.Value)) { strMsg = GetLocalResourceObject("UpdateSuccess12").ToString(); } else if ("8".Equals(hidActionType.Value)) { strMsg = GetLocalResourceObject("UpdateSuccess11").ToString(); } commonDBEntity.Event_Result = strMsg; messageContent.InnerHtml = strMsg; ResetOrderConfirmListGrid(); } else if (iResult == 0) { commonDBEntity.Event_Result = GetLocalResourceObject("WarningMessage").ToString(); detailMessageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); } else { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError1").ToString(); messageContent.InnerHtml = GetLocalResourceObject("UpdateError1").ToString(); } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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 = "订单审核"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = SetActionTypeVal(hidActionType.Value); orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.CANNEL = ("8".Equals(hidActionType.Value)) ? "" : ddpNoShow.SelectedValue; orderinfoEntity.ApproveId = ("5".Equals(hidActionType.Value)) ? "" : txtActionID.Text.Trim(); orderinfoEntity.InRoomID = ("5".Equals(hidActionType.Value)) ? "" : txtInRoomID.Text.Trim(); orderinfoEntity.IsDbApprove = (chkDbApprove.Checked) ? "1" : "0"; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeCloseList()", true); }
//根据审核人员 获取复审 订单列表 public DataTable GetApprovedOrderListByCheck(string startDate, string endDate) { _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 = "订单审核"; orderinfoEntity.StartDate = startDate; orderinfoEntity.EndDate = endDate; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.GetApprovedOrderListByCheck(_orderInfoEntity).QueryResult.Tables[0]; return dtResult; }
private void BindOrderConfirmListGrid() { messageContent.InnerHtml = ""; OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); orderinfoEntity.OrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.BindOrderApproveList(_orderInfoEntity).QueryResult; gridViewCSList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSList.DataKeyNames = new string[] { "ORDERID" };//主键 gridViewCSList.DataBind(); if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { dvGridMessage.InnerHtml = "无审核订单"; } else { dvGridMessage.InnerHtml = ""; } gridViewCSList.Attributes.Add("style", "word-break:break-all;word-wrap:break-word"); GetBasicOrderAprInfo(orderinfoEntity.HotelID); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "BtnCompleteStyle();", true); //this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }
//获取订单详情 计算见间夜数 public DataTable OrderApprovedByOrderDetails(string orders) { _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.FOG_ORDER_NUM = orders; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.OrderApprovedByOrderDetails(_orderInfoEntity).QueryResult.Tables[0]; return dtResult; }
private void ResetOrderConfirmListGrid() { OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); orderinfoEntity.OrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.BindOrderApproveList(_orderInfoEntity).QueryResult; if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { dvGridMessage.InnerHtml = "无审核订单"; } else { dvGridMessage.InnerHtml = ""; } gridViewCSList.Attributes.Add("style", "word-break:break-all;word-wrap:break-word"); gridViewCSList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSList.DataKeyNames = new string[] { "ORDERID" };//主键 gridViewCSList.DataBind(); }
// 获取所有订单审核人员 private DataTable GetSales(string startDate, string endDate) { //WebAutoCompleteBP webBP = new WebAutoCompleteBP(); //DataTable dtSales = webBP.GetWebCompleteList("approveduser", "", "").Tables[0]; //return dtSales; _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 = "订单审核"; orderinfoEntity.StartDate = startDate; orderinfoEntity.EndDate = endDate; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataTable dtResult = OrderInfoBP.GetApprovedUserListByCheck(_orderInfoEntity).QueryResult.Tables[0]; return dtResult; }
protected void btnSet_Click(object sender, EventArgs e) { dvErrorInfo.InnerHtml = ""; imgAlert.Src = ""; string strOrderBookStatus = string.Empty; if (String.IsNullOrEmpty(hidOrderID.Value.Trim())) { imgAlert.Src = "../../Styles/images/err.png"; dvImg.Style.Add("margin-left", "100px"); dvErrorInfo.InnerHtml = GetLocalResourceObject("ErrorMessage").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "setScript", "invokeOpenList()", true); return; } if (String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim())) { imgAlert.Src = "../../Styles/images/err.png"; dvImg.Style.Add("margin-left", "100px"); dvErrorInfo.InnerHtml = GetLocalResourceObject("ErrorEmptyRemark").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "setScript", "invokeOpenList()", true); return; } if (!String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim()) && (StringUtility.Text_Length(txtBOOK_REMARK.Text.ToString().Trim()) > 250)) { imgAlert.Src = "../../Styles/images/err.png"; dvImg.Style.Add("margin-left", "10px"); dvErrorInfo.InnerHtml = GetLocalResourceObject("ErrorRemark").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "setScript", "invokeOpenList()", true); return; } if (rdbCofRe.Checked) { trComfIn.Style.Add("display", "none"); trCanlReson.Style.Add("display", "none"); imgAlert.Src = "../../Styles/images/suc.png"; dvImg.Style.Add("margin-left", "100px"); dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateReSuccess").ToString(); OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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 = "订单确认"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = "备注"; orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.ActionID = ""; orderinfoEntity.CANNEL = ""; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "setScript", "invokeOpenListAj()", true); return; } else { if (!"LMBAR".Equals(hidPriceCode.Value.ToUpper())) { if (rdbCofIn.Checked) { strOrderBookStatus = "4"; } else if (rdbCofCal.Checked) { strOrderBookStatus = "9"; } else { strOrderBookStatus = "4"; } } else { strOrderBookStatus = "4"; } if ("LMBAR".Equals(hidPriceCode.Value.ToUpper())) { trComfIn.Style.Add("display", "none"); trCanlReson.Style.Add("display", ""); } else if (!"LMBAR".Equals(hidPriceCode.Value.ToUpper()) && "9".Equals(strOrderBookStatus)) { trComfIn.Style.Add("display", "none"); trCanlReson.Style.Add("display", ""); } else { trComfIn.Style.Add("display", ""); trCanlReson.Style.Add("display", "none"); } } _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = hidOrderID.Value; _lmSystemLogEntity.OrderBookStatus = strOrderBookStatus; _lmSystemLogEntity.CanelReson = ddpCanelReson.SelectedValue.Trim(); _lmSystemLogEntity.BookRemark = txtBOOK_REMARK.Text.Trim(); _lmSystemLogEntity.FollowUp = (chkFollowUp.Checked) ? "1" : "0"; _lmSystemLogEntity.ActionID = (!"LMBAR".Equals(hidPriceCode.Value.ToUpper())) ? txtCofNum.Text.Trim() : ""; int iResult = LmSystemLogBP.SaveOrderOperation(_lmSystemLogEntity); _commonEntity.LogMessages = _lmSystemLogEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单确认-保存"; commonDBEntity.Event_ID = hidHotelID.Value + "-" + _lmSystemLogEntity.FogOrderID; string conTent = GetLocalResourceObject("EventSaveMessage").ToString(); conTent = string.Format(conTent, _lmSystemLogEntity.FogOrderID, _lmSystemLogEntity.OrderBookStatus, _lmSystemLogEntity.BookRemark, _lmSystemLogEntity.CanelReson, _lmSystemLogEntity.FollowUp); commonDBEntity.Event_Content = conTent; if (iResult == 1) { imgAlert.Src = "../../Styles/images/suc.png"; dvImg.Style.Add("margin-left", "100px"); commonDBEntity.Event_Result = GetLocalResourceObject("UpdateSuccess").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateSuccess").ToString(); OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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 = "订单确认"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = SetActionTypeVal(strOrderBookStatus); orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.ActionID = (!"LMBAR".Equals(hidPriceCode.Value.ToUpper())) ? txtCofNum.Text.Trim() : ""; orderinfoEntity.CANNEL = ("9".Equals(strOrderBookStatus) || ("LMBAR".Equals(hidPriceCode.Value.ToUpper()) && "4".Equals(strOrderBookStatus))) ? ddpCanelReson.SelectedValue.Trim() : ""; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); RestControlVal(); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "setScript", "invokeOpenListAj()", true); } else if (iResult == 2) { imgAlert.Src = "../../Styles/images/err.png"; commonDBEntity.Event_Result = GetLocalResourceObject("UpdateLockErr").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateLockErr").ToString(); dvImg.Style.Add("margin-left", "30px"); } else { imgAlert.Src = "../../Styles/images/err.png"; dvImg.Style.Add("margin-left", "100px"); commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError").ToString(); dvErrorInfo.InnerHtml = GetLocalResourceObject("UpdateError").ToString(); } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "setScript", "invokeOpenList()", true); }
private void UnLockOrderConfirm(string orderID) { if (!String.IsNullOrEmpty(orderID)) { OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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.OrderID = orderID; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); int iResut = OrderInfoBP.UnLockOrderConfirm(_orderInfoEntity).Result; _commonEntity.LogMessages = _orderInfoEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单操作-解锁"; commonDBEntity.Event_ID = hidHotelID.Value; string conTent = GetLocalResourceObject("EventUnLockOrderMessage").ToString(); conTent = string.Format(conTent, orderID, _orderInfoEntity.LogMessages.Username); commonDBEntity.Event_Content = conTent; commonDBEntity.Event_Result = GetLocalResourceObject("UpdateUnLockOrderSuccess").ToString(); _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); } }
private void BindOrderConfirmListGrid() { _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.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString(); orderinfoEntity.SortID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SortID"].ToString())) ? null : ViewState["SortID"].ToString(); orderinfoEntity.CStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CStatus"].ToString())) ? null : ViewState["CStatus"].ToString(); orderinfoEntity.FStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FStatus"].ToString())) ? null : ViewState["FStatus"].ToString(); orderinfoEntity.HotelConfirm = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelConfirm"].ToString())) ? null : ViewState["HotelConfirm"].ToString(); orderinfoEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); orderinfoEntity.UserID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["UserID"].ToString())) ? null : ViewState["UserID"].ToString(); orderinfoEntity.OrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDate"].ToString())) ? null : ViewState["StartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDate"].ToString())) ? null : ViewState["EndDate"].ToString(); orderinfoEntity.BOOK_STATUS_OTHER = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BStatusOther"].ToString())) ? null : ViewState["BStatusOther"].ToString(); orderinfoEntity.PRICE_CODE = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["PriceCode"].ToString())) ? null : ViewState["PriceCode"].ToString();//价格代码 orderinfoEntity.BOOK_STATUS = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["BStatus"].ToString())) ? null : ViewState["BStatus"].ToString();//预付状态 orderinfoEntity.SType = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["InitFlag"].ToString())) ? null : ViewState["InitFlag"].ToString(); //if (String.IsNullOrEmpty(orderinfoEntity.HotelConfirm) && (String.IsNullOrEmpty(orderinfoEntity.HotelID) && String.IsNullOrEmpty(orderinfoEntity.UserID) && String.IsNullOrEmpty(orderinfoEntity.OrderID))) //{ // orderinfoEntity.HotelConfirm = "0"; // orderinfoEntity.SType = "1"; //} _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.BindOrderConfirmList(_orderInfoEntity).QueryResult; gridViewCSList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSList.DataKeyNames = new string[] { "ORDECTIME", "BOOKSTATUS", "REDDIS", "ORDERID" };//主键 gridViewCSList.DataBind(); string strCreatTime = ""; string strBookStatus = ""; string strSysDTime = ""; DateTime dtTemp = DateTime.Now; DateTime dtTempCt = DateTime.Now; for (int i = 0; i < gridViewCSList.Rows.Count; i++) { //首先判断是否是数据行 if (gridViewCSList.Rows[i].RowType == DataControlRowType.DataRow) { strCreatTime = gridViewCSList.DataKeys[i].Values[0].ToString(); strBookStatus = gridViewCSList.DataKeys[i].Values[1].ToString(); strSysDTime = gridViewCSList.DataKeys[i].Values[2].ToString(); if (String.IsNullOrEmpty(strCreatTime)) { continue; } dtTempCt = DateTime.Parse(strCreatTime); dtTemp = DateTime.Parse(strSysDTime).AddMinutes(-15); if ((dtTemp > dtTempCt) && ("1".Equals(strBookStatus))) { gridViewCSList.Rows[i].Cells[0].Attributes.Add("bgcolor", "#FF6666"); } } } UpdatePanel2.Update(); //ViewState["StartDate"] = ""; //ViewState["EndDate"] = ""; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }
public static bool chkDApproveData(HotelInfoEntity hotelInfoEntity, DataRow drRow) { HotelInfoDBEntity dbParm = (hotelInfoEntity.HotelInfoDBEntity.Count > 0) ? hotelInfoEntity.HotelInfoDBEntity[0] : new HotelInfoDBEntity(); string LDStatus = string.Empty; string NSStatus = string.Empty; string LDdbAppr = string.Empty; string NSdbAppr = string.Empty; string ADStatsBack = (String.IsNullOrEmpty(dbParm.ADStatsBack)) ? "" : dbParm.ADStatsBack; if (ADStatsBack.Contains("1") || ADStatsBack.Contains("3")) { LDStatus = "离店"; } if (ADStatsBack.Contains("2") || ADStatsBack.Contains("4")) { NSStatus = "No-Show"; } if (ADStatsBack.Contains("1")) { LDdbAppr = "0"; } else if (ADStatsBack.Contains("3")) { LDdbAppr = "1"; } if (ADStatsBack.Contains("2")) { NSdbAppr = "0"; } else if (ADStatsBack.Contains("4")) { NSdbAppr = "1"; } OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _orderInfoEntity.OrderInfoDBEntity = new List<OrderInfoDBEntity>(); OrderInfoDBEntity orderinfoEntity = new OrderInfoDBEntity(); orderinfoEntity.HotelID = drRow["prop"].ToString(); orderinfoEntity.OutDate = dbParm.OutDate; orderinfoEntity.OrderID = dbParm.OrderID; orderinfoEntity.AuditStatus = dbParm.AuditStatus; orderinfoEntity.ADStatsBack = dbParm.ADStatsBack; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsOrders = OrderInfoDA.BindOrderApproveFaxList(_orderInfoEntity).QueryResult; DataSet dsResult = new DataSet(); for (int i = dsOrders.Tables[0].Rows.Count - 1; i >= 0; i--) { if ("未审核".Equals(dsOrders.Tables[0].Rows[i]["ORDERST"].ToString())) { continue; } if (!String.IsNullOrEmpty(ADStatsBack)) { DataCommand cmd = DataCommandManager.GetDataCommand("ChkApproveOrderList"); cmd.SetParameterValue("@ORDERID", dsOrders.Tables[0].Rows[i]["ORDERID"].ToString()); dsResult = cmd.ExecuteDataSet(); if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { dsOrders.Tables[0].Rows.RemoveAt(i); } else { if ("离店".Equals(dsResult.Tables[0].Rows[0]["OD_STATUS"].ToString())) { if (!(!String.IsNullOrEmpty(LDStatus) && LDdbAppr.Equals(dsResult.Tables[0].Rows[0]["ISDBAPPROVE"].ToString()))) { dsOrders.Tables[0].Rows.RemoveAt(i); } } else if ("No-Show".Equals(dsResult.Tables[0].Rows[0]["OD_STATUS"].ToString())) { if (!(!String.IsNullOrEmpty(NSStatus) && NSdbAppr.Equals(dsResult.Tables[0].Rows[0]["ISDBAPPROVE"].ToString()))) { dsOrders.Tables[0].Rows.RemoveAt(i); } } else { dsOrders.Tables[0].Rows.RemoveAt(i); } } } } if (dsOrders.Tables.Count > 0 && dsOrders.Tables[0].Rows.Count > 0) { return true; } else { return false; } }
private bool ChkOrderLock(string strHotelID) { OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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.OrderID = hidOrderID.Value; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); int iResult = OrderInfoBP.ChkOrderLock(_orderInfoEntity).Result; if (iResult == 1) { return true; } else { return false; } }
private void BindOrderConfirmListGrid() { messageContent.InnerHtml = ""; OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); string strOrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); string strfaxNum = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxNum"].ToString())) ? null : ViewState["FaxNum"].ToString(); if (!String.IsNullOrEmpty(strOrderID) || !String.IsNullOrEmpty(strfaxNum)) { orderinfoEntity.OrderID = strOrderID; orderinfoEntity.FaxNum = strfaxNum; orderinfoEntity.SqlType = "1"; } else if (!String.IsNullOrEmpty(hidSelectCity.Value) || !String.IsNullOrEmpty(hidSelectHotel.Value) || !String.IsNullOrEmpty(hidSelectBussiness.Value)) { orderinfoEntity.City = hidSelectCity.Value == "" ? "" : hidSelectCity.Value.Substring((hidSelectCity.Value.IndexOf('[') + 1), (hidSelectCity.Value.IndexOf(']') - 1)); //"";//城市ID //orderinfoEntity.HotelID = hidSelectHotel.Value == "" ? "" : hidSelectHotel.Value.Substring((hidSelectHotel.Value.IndexOf('[') + 1), (hidSelectHotel.Value.IndexOf(']') - 1));//"";//酒店ID orderinfoEntity.Bussiness = hidSelectBussiness.Value == "" ? "" : hidSelectBussiness.Value.Substring((hidSelectBussiness.Value.IndexOf('[') + 1), (hidSelectBussiness.Value.IndexOf(']') - 1));//"";//商圈ID orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); orderinfoEntity.OrderID = strOrderID; orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); orderinfoEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); orderinfoEntity.FaxNum = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxNum"].ToString())) ? null : ViewState["FaxNum"].ToString(); //orderinfoEntity.FaxStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxStatus"].ToString())) ? null : ViewState["FaxStatus"].ToString(); orderinfoEntity.SqlType = "2"; } else { orderinfoEntity.OrderID = strOrderID; orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); orderinfoEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); //orderinfoEntity.FaxStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FaxStatus"].ToString())) ? null : ViewState["FaxStatus"].ToString(); orderinfoEntity.SqlType = "3"; } //orderinfoEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); //orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutStartDate"].ToString())) ? null : ViewState["OutStartDate"].ToString(); //orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OutEndDate"].ToString())) ? null : ViewState["OutEndDate"].ToString(); //orderinfoEntity.OrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); //orderinfoEntity.AuditStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["AuditStatus"].ToString())) ? null : ViewState["AuditStatus"].ToString(); //orderinfoEntity.ADStatsBack = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["ADStatsBack"].ToString())) ? null : ViewState["ADStatsBack"].ToString(); _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.BindOrderApproveFaxList(_orderInfoEntity).QueryResult; gridViewCSList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSList.DataKeyNames = new string[] { "ORDERID" };//主键 gridViewCSList.DataBind(); if (dsResult.Tables.Count == 0 || dsResult.Tables[0].Rows.Count == 0) { dvGridMessage.InnerHtml = "无审核订单"; } else { dvGridMessage.InnerHtml = ""; } gridViewCSList.Attributes.Add("style", "word-break:break-all;word-wrap:break-word"); GetBasicOrderAprInfo(orderinfoEntity.HotelID); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "BtnCompleteStyle();", true); //this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }
private DataSet GetCityListData() { _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.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.CommonCitySelect(_orderInfoEntity).QueryResult; if (dsResult.Tables.Count > 0) { dsResult.Tables[0].Columns["CITY_ID"].ColumnName = "CT_STATUS"; dsResult.Tables[0].Columns["NAME_CN"].ColumnName = "CT_TEXT"; DataRow dr0 = dsResult.Tables[0].NewRow(); dr0["CT_STATUS"] = ""; dr0["CT_TEXT"] = "不限制"; dsResult.Tables[0].Rows.InsertAt(dr0, 0); } return dsResult; }
protected void btnAddRemark_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim()) && (StringUtility.Text_Length(txtBOOK_REMARK.Text.ToString().Trim()) > 250)) { detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorRemark").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } if ("8".Equals(hidActionType.Value) && String.IsNullOrEmpty(txtInRoomID.Text.Trim())) { detailMessageContent.InnerHtml = GetLocalResourceObject("ErrorAction").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } if (String.IsNullOrEmpty(hidActionType.Value)) { if (String.IsNullOrEmpty(txtBOOK_REMARK.Text.Trim())) { detailMessageContent.InnerHtml = GetLocalResourceObject("EmpryRemark").ToString(); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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 = "订单审核"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = SetActionTypeVal(hidActionType.Value); orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.CANNEL = ""; orderinfoEntity.ApproveId = ""; orderinfoEntity.InRoomID = ""; orderinfoEntity.IsDbApprove = "1"; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); messageContent.InnerHtml = GetLocalResourceObject("RemarkSuccess").ToString(); } else { LmSystemLogEntity _lmSystemLogEntity = new LmSystemLogEntity(); _lmSystemLogEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _lmSystemLogEntity.LogMessages.Userid = UserSession.Current.UserAccount; _lmSystemLogEntity.LogMessages.Username = UserSession.Current.UserDspName; _lmSystemLogEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _lmSystemLogEntity.FogOrderID = hidOrderID.Value; _lmSystemLogEntity.OrderBookStatus = hidActionType.Value; _lmSystemLogEntity.CanelReson = ddpNoShow.SelectedValue; _lmSystemLogEntity.BookRemark = txtBOOK_REMARK.Text.Trim(); _lmSystemLogEntity.ApproveId = txtActionID.Text.Trim(); _lmSystemLogEntity.InRoomID = txtInRoomID.Text.Trim(); _lmSystemLogEntity.IsDbApprove = "1";// (chkDbApprove.Checked) ? "1" : "0"; _lmSystemLogEntity = LmSystemLogBP.SaveOrderOpeRemarkList(_lmSystemLogEntity); int iResult = _lmSystemLogEntity.Result; _commonEntity.LogMessages = _lmSystemLogEntity.LogMessages; _commonEntity.CommonDBEntity = new List<CommonDBEntity>(); CommonDBEntity commonDBEntity = new CommonDBEntity(); commonDBEntity.Event_Type = "订单审核-保存"; commonDBEntity.Event_ID = hidOrderID.Value; string conTent = GetLocalResourceObject("EventSaveMessage").ToString(); conTent = string.Format(conTent, _lmSystemLogEntity.FogOrderID, _lmSystemLogEntity.OrderBookStatus, _lmSystemLogEntity.BookRemark, _lmSystemLogEntity.InRoomID, _lmSystemLogEntity.ApproveId, _lmSystemLogEntity.CanelReson); commonDBEntity.Event_Content = conTent; if (iResult == 1) { OrderInfoEntity _orderInfoEntity = new OrderInfoEntity(); _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 = "订单审核"; orderinfoEntity.ORDER_NUM = hidOrderID.Value; orderinfoEntity.OdStatus = SetActionTypeVal(hidActionType.Value); orderinfoEntity.REMARK = txtBOOK_REMARK.Text.Trim(); orderinfoEntity.CANNEL = ("8".Equals(hidActionType.Value)) ? "" : ddpNoShow.SelectedValue; orderinfoEntity.ApproveId = ("5".Equals(hidActionType.Value)) ? "" : txtActionID.Text.Trim(); orderinfoEntity.InRoomID = ("5".Equals(hidActionType.Value)) ? "" : txtInRoomID.Text.Trim(); orderinfoEntity.IsDbApprove = "1";//(chkDbApprove.Checked) ? "1" : "0"; _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); CommonBP.InsertOrderActionHistoryList(_orderInfoEntity); string strMsg = ""; if ("5".Equals(hidActionType.Value)) { strMsg = GetLocalResourceObject("UpdateSuccess12").ToString(); } else if ("8".Equals(hidActionType.Value)) { strMsg = GetLocalResourceObject("UpdateSuccess11").ToString(); } commonDBEntity.Event_Result = strMsg; messageContent.InnerHtml = strMsg; ResetOrderConfirmListGrid(); } else if (iResult == 0) { commonDBEntity.Event_Result = GetLocalResourceObject("WarningMessage").ToString(); detailMessageContent.InnerHtml = GetLocalResourceObject("WarningMessage").ToString(); } else if (iResult == 2) { commonDBEntity.Event_Result = _lmSystemLogEntity.ErrorMSG; detailMessageContent.InnerHtml = _lmSystemLogEntity.ErrorMSG; ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeOpenList()", true); return; } else { commonDBEntity.Event_Result = GetLocalResourceObject("UpdateError").ToString(); messageContent.InnerHtml = GetLocalResourceObject("UpdateError").ToString(); } _commonEntity.CommonDBEntity.Add(commonDBEntity); CommonBP.InsertEventHistory(_commonEntity); } gridHotelList.SelectedIndex = int.Parse(this.HidSelIndex.Value); string PROP = gridHotelList.DataKeys[int.Parse(this.HidSelIndex.Value)].Values[0].ToString(); int UADCUN = 0; int ADCUN = 0; int BCUN = 0; for (int i = 0; i < gridHotelList.Rows.Count; i++) { //首先判断是否是数据行 if (gridHotelList.Rows[i].RowType == DataControlRowType.DataRow) { UADCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[4].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[4].ToString()); ADCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[5].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[5].ToString()); BCUN = (String.IsNullOrEmpty(gridHotelList.DataKeys[i].Values[6].ToString())) ? 0 : int.Parse(gridHotelList.DataKeys[i].Values[6].ToString()); if (UADCUN == ADCUN) { gridHotelList.Rows[i].BackColor = System.Drawing.ColorTranslator.FromHtml("#70A88C"); } else if (BCUN > 0) { gridHotelList.Rows[i].BackColor = System.Drawing.ColorTranslator.FromHtml("#94FB92"); } gridHotelList.Rows[i].Attributes.Add("onMouseOver", "t=this.style.backgroundColor;this.style.backgroundColor='#ebebce';"); gridHotelList.Rows[i].Attributes.Add("onMouseOut", "this.style.backgroundColor=t;"); } } gridHotelList.Rows[gridHotelList.SelectedIndex].BackColor = System.Drawing.ColorTranslator.FromHtml("#FFCC66"); ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "setScript", "invokeCloseList()", true); }
private void BindOrderConfirmListGrid() { _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.CityID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["CityID"].ToString())) ? null : ViewState["CityID"].ToString(); orderinfoEntity.SortID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["SortID"].ToString())) ? null : ViewState["SortID"].ToString(); orderinfoEntity.FGStatus = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["FGStatus"].ToString())) ? null : ViewState["FGStatus"].ToString(); orderinfoEntity.HotelID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString(); orderinfoEntity.UserID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["UserID"].ToString())) ? null : ViewState["UserID"].ToString(); orderinfoEntity.OrderID = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["OrderID"].ToString())) ? null : ViewState["OrderID"].ToString(); orderinfoEntity.StartDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["StartDate"].ToString())) ? null : ViewState["StartDate"].ToString(); orderinfoEntity.EndDate = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["EndDate"].ToString())) ? null : ViewState["EndDate"].ToString(); _orderInfoEntity.OrderInfoDBEntity.Add(orderinfoEntity); DataSet dsResult = OrderInfoBP.BindOrderConfirmManagerList(_orderInfoEntity).QueryResult; gridViewCSList.DataSource = dsResult.Tables[0].DefaultView; gridViewCSList.DataKeyNames = new string[] { "ORDERID" };//主键 gridViewCSList.DataBind(); //string strCreatTime = ""; //string strBookStatus = ""; //string strSysDTime = ""; //DateTime dtTemp = DateTime.Now; //DateTime dtTempCt = DateTime.Now; //for (int i = 0; i < gridViewCSList.Rows.Count; i++) //{ // //首先判断是否是数据行 // if (gridViewCSList.Rows[i].RowType == DataControlRowType.DataRow) // { // strCreatTime = gridViewCSList.DataKeys[i].Values[0].ToString(); // strBookStatus = gridViewCSList.DataKeys[i].Values[1].ToString(); // strSysDTime = gridViewCSList.DataKeys[i].Values[2].ToString(); // if (String.IsNullOrEmpty(strCreatTime)) // { // continue; // } // dtTempCt = DateTime.Parse(strCreatTime); // dtTemp = DateTime.Parse(strSysDTime).AddMinutes(-30); // if ((dtTemp > dtTempCt) && ("1".Equals(strBookStatus))) // { // gridViewCSList.Rows[i].Cells[0].Attributes.Add("bgcolor", "#FF6666"); // } // } //} //ViewState["StartDate"] = ""; //ViewState["EndDate"] = ""; this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "BtnCompleteStyle();", true); }