/// <summary> /// 查询最终订单状态(供应商) /// </summary> /// <returns></returns> public static OrderInfoEntity orderQueryByOrderNum(OrderInfoEntity OrderInfoEntity) { OrderInfoDBEntity dbParm = (OrderInfoEntity.OrderInfoDBEntity.Count > 0) ? OrderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); string DataString = "{\"orderNum\":\"" + dbParm.FOG_ORDER_NUM + "\"}"; string HotelPrRoomPlanUrl = JsonRequestURLBuilder.orderQueryByOrderNumV2(); CallWebPage callWebPage = new CallWebPage(); string strHotelPrRoomPlan = callWebPage.CallWebByURL(HotelPrRoomPlanUrl, DataString); JObject oHotelPrRoomPlan = JObject.Parse(strHotelPrRoomPlan); if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(oHotelPrRoomPlan, "message").Trim('"'))) { OrderInfoEntity.ErrorMSG = oHotelPrRoomPlan.SelectToken("result").SelectToken("statusDesc").ToString().Trim('"') + "(" + oHotelPrRoomPlan.SelectToken("result").SelectToken("statusOriginal").ToString().Trim('"') + ")";//最终状态(状态描述) OrderInfoEntity.Result = 1; } else { OrderInfoEntity.ErrorMSG = ""; OrderInfoEntity.Result = 2; } return OrderInfoEntity; }
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 static OrderInfoEntity BindOrderApproveList(OrderInfoEntity orderInfoEntity) { orderInfoEntity.LogMessages.MsgType = MessageType.INFO; orderInfoEntity.LogMessages.Content = _nameSpaceClass + "BindOrderApproveList"; LoggerHelper.LogWriter(orderInfoEntity.LogMessages); try { return OrderInfoDA.BindOrderApproveList(orderInfoEntity); } catch (Exception ex) { orderInfoEntity.LogMessages.MsgType = MessageType.ERROR; orderInfoEntity.LogMessages.Content = _nameSpaceClass + "BindOrderApproveList Error: " + ex.Message; LoggerHelper.LogWriter(orderInfoEntity.LogMessages); throw ex; } }
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(); }
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 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); } }
public static int InsertOrderActionHistoryList(OrderInfoEntity OrderEntity) { if (OrderEntity.OrderInfoDBEntity.Count == 0) { return 0; } OrderInfoDBEntity dbParm = (OrderEntity.OrderInfoDBEntity.Count > 0) ? OrderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("InsertOrderActionHistoryList"); cmd.SetParameterValue("@FGID", dbParm.ORDER_NUM); cmd.SetParameterValue("@EVENTTYPE", dbParm.EventType); cmd.SetParameterValue("@ACTIONID", dbParm.ActionID); cmd.SetParameterValue("@ODSTATUS", dbParm.OdStatus); cmd.SetParameterValue("@REMARK", dbParm.REMARK); cmd.SetParameterValue("@CANNEL", dbParm.CANNEL); cmd.SetParameterValue("@INROOMID", dbParm.InRoomID); cmd.SetParameterValue("@APPROVEID", dbParm.ApproveId); cmd.SetParameterValue("@USERID", (OrderEntity.LogMessages != null) ? OrderEntity.LogMessages.Userid : ""); cmd.SetParameterValue("@ISDBAPPROVE", dbParm.IsDbApprove); cmd.ExecuteNonQuery(); return 1; }
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); }
public static OrderInfoEntity CommonCitySelect(OrderInfoEntity orderInfoEntity) { orderInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderInfo", "t_lm_b_citylist", true); return orderInfoEntity; }
public static OrderInfoEntity OrderApprovedReport(OrderInfoEntity orderInfoEntity) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); OracleParameter[] lmparm ={ new OracleParameter("StartDate",OracleType.VarChar), new OracleParameter("EndDate",OracleType.VarChar), new OracleParameter("CITYID",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.StartDate)) { lmparm[0].Value = DBNull.Value; } else { lmparm[0].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { lmparm[1].Value = DBNull.Value; } else { lmparm[1].Value = dbParm.EndDate; } if (String.IsNullOrEmpty(dbParm.CITY_ID)) { lmparm[2].Value = DBNull.Value; } else { lmparm[2].Value = dbParm.CITY_ID; } orderInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderInfo", "t_lm_order_approved_report", true, lmparm); return orderInfoEntity; }
public static OrderInfoEntity InsertOrderActionHisList(OrderInfoEntity orderInfoEntity, string Result) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("InsertOrderActionHisList"); cmd.SetParameterValue("@EVENTTYPE", dbParm.EventType); cmd.SetParameterValue("@FOGORDERNUM", dbParm.FOG_ORDER_NUM); cmd.SetParameterValue("@ACTIONID", dbParm.ActionID); cmd.SetParameterValue("@STATUS", dbParm.BOOK_STATUS); cmd.SetParameterValue("@REMARK", dbParm.REMARK); cmd.SetParameterValue("@CANNEL", dbParm.CanelReson); cmd.SetParameterValue("@EVENTUSER", dbParm.USER_ID); cmd.SetParameterValue("@APPROVEID", dbParm.ApproveId); cmd.SetParameterValue("@ROOMID", dbParm.ROOM_TYPE_CODE); cmd.SetParameterValue("@OPERATERESULT", Result); cmd.SetParameterValue("@ISDBAPPROVE", dbParm.IsDbApprove); orderInfoEntity.Result = cmd.ExecuteNonQuery(); return orderInfoEntity; }
/// <summary> /// 订单详情页 离店状态 获取房间号 /// </summary> /// <param name="orderInfoEntity"></param> /// <returns></returns> public static OrderInfoEntity GetRoomNumber(OrderInfoEntity orderInfoEntity) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetRoomNumber"); cmd.SetParameterValue("@FOGID", dbParm.EventType); orderInfoEntity.QueryResult = cmd.ExecuteDataSet(); return orderInfoEntity; }
/// <summary> /// 退款列表 /// </summary> /// <param name="orderInfoEntity"></param> /// <returns></returns> public static OrderInfoEntity GetRefundOrderList(OrderInfoEntity orderInfoEntity) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); OracleParameter[] lmparm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("SALES",OracleType.VarChar), new OracleParameter("FOGORDERNUM",OracleType.VarChar), new OracleParameter("StartDate",OracleType.VarChar), new OracleParameter("EndDate",OracleType.VarChar), new OracleParameter("PAYSTATUS",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HOTEL_ID)) { lmparm[0].Value = DBNull.Value; } else { lmparm[0].Value = dbParm.HOTEL_ID; } if (String.IsNullOrEmpty(dbParm.UserID)) { lmparm[1].Value = DBNull.Value; } else { lmparm[1].Value = dbParm.UserID; } if (String.IsNullOrEmpty(dbParm.FOG_ORDER_NUM)) { lmparm[2].Value = DBNull.Value; } else { lmparm[2].Value = dbParm.FOG_ORDER_NUM; } if (String.IsNullOrEmpty(dbParm.StartDate)) { lmparm[3].Value = DBNull.Value; } else { lmparm[3].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { lmparm[4].Value = DBNull.Value; } else { lmparm[4].Value = dbParm.EndDate; } if (String.IsNullOrEmpty(dbParm.PAY_STATUS)) { lmparm[5].Value = DBNull.Value; } else { lmparm[5].Value = dbParm.PAY_STATUS; } orderInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderInfo", "t_lm_order_by_order_refund", true, lmparm); return orderInfoEntity; }
public static OrderInfoEntity GetOrderListNum(OrderInfoEntity orderInfoEntity) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetOrderListNum"); cmd.SetParameterValue("@EVENTTYPE", dbParm.EventType); cmd.SetParameterValue("@StartDate", dbParm.StartDate); cmd.SetParameterValue("@EndDate", dbParm.EndDate); orderInfoEntity.QueryResult = cmd.ExecuteDataSet(); return orderInfoEntity; }
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(); }
public static OrderInfoEntity BindOrderList(OrderInfoEntity orderEntity) { OracleParameter[] parm ={ new OracleParameter("HOTEL_ID",OracleType.VarChar), new OracleParameter("HOTEL_NAME",OracleType.VarChar), new OracleParameter("CITY_ID",OracleType.VarChar), new OracleParameter("StartDate",OracleType.VarChar), new OracleParameter("EndDate",OracleType.VarChar), new OracleParameter("BOOK_STATUS",OracleType.VarChar), new OracleParameter("PAY_STATUS",OracleType.VarChar), new OracleParameter("FOG_ORDER_NUM",OracleType.VarChar) }; OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); if (String.IsNullOrEmpty(dbParm.HOTEL_ID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HOTEL_ID; } if (String.IsNullOrEmpty(dbParm.HOTEL_NAME)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.HOTEL_NAME; } if (String.IsNullOrEmpty(dbParm.CITY_ID)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.CITY_ID; } if (String.IsNullOrEmpty(dbParm.StartDate)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.EndDate; } if (String.IsNullOrEmpty(dbParm.BOOK_STATUS)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = dbParm.BOOK_STATUS; } if (String.IsNullOrEmpty(dbParm.PAY_STATUS)) { parm[6].Value = DBNull.Value; } else { parm[6].Value = dbParm.PAY_STATUS; } if (String.IsNullOrEmpty(dbParm.FOG_ORDER_NUM)) { parm[7].Value = DBNull.Value; } else { parm[7].Value = dbParm.FOG_ORDER_NUM; } orderEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderInfo", "t_lm_orderinfo_select", true, parm); return orderEntity; }
public static OrderInfoEntity ChkOrderLock(OrderInfoEntity orderEntity) { //OracleParameter[] parm ={ // new OracleParameter("ORDERID",OracleType.VarChar) // }; //OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); //if (String.IsNullOrEmpty(dbParm.OrderID)) //{ // parm[0].Value = DBNull.Value; //} //else //{ // parm[0].Value = dbParm.OrderID; //} //orderEntity.QueryResult = DbManager.Query("OrderInfo", "t_lm_orderappromginfo_chkOrderLock", false, parm); //return orderEntity; OracleParameter[] parm ={ new OracleParameter("ORDERID",OracleType.VarChar) }; OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); if (String.IsNullOrEmpty(dbParm.OrderID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.OrderID; } DataSet dsResult = HotelVp.Common.DBUtility.DbManager.Query("OrderInfo", "t_lm_order_operation_check", true, parm); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { if ("2".Equals(dsResult.Tables[0].Rows[0]["status"].ToString().Trim()) && !orderEntity.LogMessages.Userid.Equals(dsResult.Tables[0].Rows[0]["ope_user"].ToString().Trim())) { orderEntity.Result = 1; } else { orderEntity.Result = 0; } } else { orderEntity.Result = 0; } return orderEntity; }
public static OrderInfoEntity OrderOperateStatus(OrderInfoEntity orderInfoEntity) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); OracleParameter[] lmparm ={ new OracleParameter("FOGORDERNUM",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.FOG_ORDER_NUM)) { lmparm[0].Value = DBNull.Value; } else { lmparm[0].Value = dbParm.FOG_ORDER_NUM; } orderInfoEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("OrderInfo", "t_lm_order_by_operatestatus", true, lmparm); return orderInfoEntity; }
public static OrderInfoEntity GetApprovedUserListByCheck(OrderInfoEntity orderInfoEntity) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("GetApprovedUserListByCheck"); cmd.SetParameterValue("@EVENTTYPE", dbParm.EventType); if (string.IsNullOrEmpty(dbParm.CONTACT_NAME)) { cmd.SetParameterValue("@EVENTUSER", DBNull.Value); } else { cmd.SetParameterValue("@EVENTUSER", dbParm.CONTACT_NAME); } cmd.SetParameterValue("@StartDate", dbParm.StartDate); cmd.SetParameterValue("@EndDate", dbParm.EndDate); orderInfoEntity.QueryResult = cmd.ExecuteDataSet(); return orderInfoEntity; }
public static OrderInfoEntity UnLockOrderConfirm(OrderInfoEntity orderInfoEntity) { OrderInfoDBEntity dbParm = (orderInfoEntity.OrderInfoDBEntity.Count > 0) ? orderInfoEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); OracleParameter[] lmparm ={ new OracleParameter("ORDERID",OracleType.VarChar), new OracleParameter("OPEUSER",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.OrderID)) { lmparm[0].Value = DBNull.Value; } else { lmparm[0].Value = dbParm.OrderID; } lmparm[1].Value = orderInfoEntity.LogMessages.Userid; orderInfoEntity.Result = HotelVp.Common.DBUtility.DbManager.ExecuteSql("OrderInfo", "t_lm_order_cof_unlock", lmparm); return orderInfoEntity; }
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; } }
public static OrderInfoEntity BindOrderApproveFaxList(OrderInfoEntity orderEntity) { OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); DataSet dsResult = new DataSet(); if ("1".Equals(dbParm.SqlType)) { OracleParameter[] parm ={ new OracleParameter("OrderID",OracleType.VarChar), new OracleParameter("FaxNum",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.OrderID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.OrderID; } if (String.IsNullOrEmpty(dbParm.FaxNum)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.FaxNum; } string SQLString = HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderappromginfo_fax_select_order"); SQLString = SQLString + "order by t.fog_order_num " + dbParm.SortID + ", t.hotel_name"; dsResult = DbHelperOra.Query(SQLString, false, parm); } else if ("2".Equals(dbParm.SqlType)) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("OutSDate",OracleType.VarChar), new OracleParameter("OutEDate",OracleType.VarChar), new OracleParameter("OrderID",OracleType.VarChar), new OracleParameter("AuditStatus",OracleType.VarChar), new OracleParameter("CITYID",OracleType.VarChar), new OracleParameter("TRADEAREAID",OracleType.VarChar), new OracleParameter("FaxNum",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelID; } if (String.IsNullOrEmpty(dbParm.StartDate)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.EndDate; } if (String.IsNullOrEmpty(dbParm.OrderID)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.OrderID; } if (String.IsNullOrEmpty(dbParm.AuditStatus)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.AuditStatus; } if (String.IsNullOrEmpty(dbParm.City)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = dbParm.City; } if (String.IsNullOrEmpty(dbParm.Bussiness)) { parm[6].Value = DBNull.Value; } else { parm[6].Value = dbParm.Bussiness; } if (String.IsNullOrEmpty(dbParm.FaxNum)) { parm[7].Value = DBNull.Value; } else { parm[7].Value = dbParm.FaxNum; } string SQLString = HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderappromginfo_fax_select_hotel"); SQLString = SQLString + "order by t.fog_order_num " + dbParm.SortID + ", t.hotel_name"; dsResult = DbHelperOra.Query(SQLString, false, parm); } else { OracleParameter[] parm ={ new OracleParameter("HotelID",OracleType.VarChar), new OracleParameter("OutSDate",OracleType.VarChar), new OracleParameter("OutEDate",OracleType.VarChar), new OracleParameter("OrderID",OracleType.VarChar), new OracleParameter("AuditStatus",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelID; } if (String.IsNullOrEmpty(dbParm.StartDate)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.EndDate; } if (String.IsNullOrEmpty(dbParm.OrderID)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.OrderID; } if (String.IsNullOrEmpty(dbParm.AuditStatus)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.AuditStatus; } string SQLString = HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderappromginfo_fax_select"); SQLString = SQLString + "order by t.fog_order_num " + dbParm.SortID + ", t.hotel_name"; dsResult = DbHelperOra.Query(SQLString, false, parm); } #region 过滤复审 if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { 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"; } DataSet dsOrders = new DataSet(); for (int i = dsResult.Tables[0].Rows.Count - 1; i >= 0; i--) { if ("未审核".Equals(dsResult.Tables[0].Rows[i]["ORDERST"].ToString())) { if (!String.IsNullOrEmpty(dsResult.Tables[0].Rows[i]["HVPNM"].ToString())) { dsResult.Tables[0].Rows[i]["HVPNM"] = GetSalesNUm(dsResult.Tables[0].Rows[i]["HVPNM"].ToString()); } continue; } if (!String.IsNullOrEmpty(ADStatsBack)) { DataCommand cmd = DataCommandManager.GetDataCommand("ChkApproveOrderList"); cmd.SetParameterValue("@ORDERID", dsResult.Tables[0].Rows[i]["ORDERID"].ToString()); dsOrders = cmd.ExecuteDataSet(); if (dsOrders.Tables.Count == 0 || dsOrders.Tables[0].Rows.Count == 0) { dsResult.Tables[0].Rows.RemoveAt(i); continue; } else { if ("离店".Equals(dsOrders.Tables[0].Rows[0]["OD_STATUS"].ToString())) { if (!(!String.IsNullOrEmpty(LDStatus) && LDdbAppr.Equals(dsOrders.Tables[0].Rows[0]["ISDBAPPROVE"].ToString()))) { dsResult.Tables[0].Rows.RemoveAt(i); continue; } } else if ("No-Show".Equals(dsOrders.Tables[0].Rows[0]["OD_STATUS"].ToString())) { if (!(!String.IsNullOrEmpty(NSStatus) && NSdbAppr.Equals(dsOrders.Tables[0].Rows[0]["ISDBAPPROVE"].ToString()))) { dsResult.Tables[0].Rows.RemoveAt(i); continue; } } else { dsResult.Tables[0].Rows.RemoveAt(i); continue; } } } if (!String.IsNullOrEmpty(dsResult.Tables[0].Rows[i]["HVPNM"].ToString())) { dsResult.Tables[0].Rows[i]["HVPNM"] = GetSalesNUm(dsResult.Tables[0].Rows[i]["HVPNM"].ToString()); } } } #endregion orderEntity.QueryResult = dsResult; return orderEntity; }
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; } }
public static OrderInfoEntity BindOrderApproveFaxPrint(OrderInfoEntity orderEntity) { OracleParameter[] parm ={ new OracleParameter("HotelID",OracleType.VarChar), new OracleParameter("OrderList",OracleType.VarChar) }; OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelID; } ArrayList alList = new ArrayList(); alList = dbParm.OrderList; string strList = ""; foreach (string strSN in alList) { strList = strList + strSN + ","; } if (alList.Count == 0) { parm[1].Value = DBNull.Value; } else { parm[1].Value = strList; } DataSet dsResult = DbManager.Query("OrderInfo", "t_lm_orderappromginfo_fax_print_select", false, parm); dsResult.Tables[0].TableName = "PRINT"; OracleParameter[] htparm ={ new OracleParameter("HotelID",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HotelID)) { htparm[0].Value = DBNull.Value; } else { htparm[0].Value = dbParm.HotelID; } DataTable dtHotelEx = new DataTable(); dtHotelEx = DbManager.Query("OrderInfo", "t_lm_hotelex_print_select", false, htparm).Tables[0].Copy(); dtHotelEx.TableName = "HLEX"; DataTable dtUsersInfo = new DataTable(); DataCommand cmd = DataCommandManager.GetDataCommand("GetCmsSysUsersInfo"); cmd.SetParameterValue("@UserAccount", orderEntity.LogMessages.Userid); dtUsersInfo = cmd.ExecuteDataSet().Tables[0].Copy(); dtUsersInfo.TableName = "UsersInfo"; dsResult.Tables.Add(dtHotelEx); dsResult.Tables.Add(dtUsersInfo); orderEntity.QueryResult = dsResult; return orderEntity; }
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 OrderInfoEntity BindOrderApprovePrint(OrderInfoEntity orderEntity) { OracleParameter[] parm ={ new OracleParameter("HotelID",OracleType.VarChar), new OracleParameter("StartDate",OracleType.VarChar), new OracleParameter("EndDate",OracleType.VarChar), new OracleParameter("OrderID",OracleType.VarChar), new OracleParameter("AuditStatus",OracleType.VarChar) }; OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelID; } if (String.IsNullOrEmpty(dbParm.StartDate)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.EndDate; } if (String.IsNullOrEmpty(dbParm.OrderID)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.OrderID; } if (String.IsNullOrEmpty(dbParm.AuditStatus)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.AuditStatus; } DataSet dsResult = DbManager.Query("OrderInfo", "t_lm_orderappromginfo_print_select", false, parm); dsResult.Tables[0].TableName = "PRINT"; OracleParameter[] htparm ={ new OracleParameter("HotelID",OracleType.VarChar), new OracleParameter("StartDate",OracleType.VarChar), new OracleParameter("EndDate",OracleType.VarChar), new OracleParameter("OrderID",OracleType.VarChar), new OracleParameter("AuditStatus",OracleType.VarChar) }; if (String.IsNullOrEmpty(dbParm.HotelID)) { htparm[0].Value = DBNull.Value; } else { htparm[0].Value = dbParm.HotelID; } DataTable dtHotelEx = new DataTable(); dtHotelEx = DbManager.Query("OrderInfo", "t_lm_hotelex_print_select", false, htparm).Tables[0].Copy(); dtHotelEx.TableName = "HLEX"; DataTable dtUsersInfo = new DataTable(); DataCommand cmd = DataCommandManager.GetDataCommand("GetCmsSysUsersInfo"); cmd.SetParameterValue("@UserAccount", orderEntity.LogMessages.Userid); dtUsersInfo = cmd.ExecuteDataSet().Tables[0].Copy(); dtUsersInfo.TableName = "UsersInfo"; dsResult.Tables.Add(dtHotelEx); dsResult.Tables.Add(dtUsersInfo); orderEntity.QueryResult = dsResult; return orderEntity; }
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); }
public static OrderInfoEntity BindOrderConfirmList(OrderInfoEntity orderEntity) { OracleParameter[] parm ={ new OracleParameter("CityID",OracleType.VarChar), new OracleParameter("CStatus",OracleType.VarChar), new OracleParameter("FStatus",OracleType.VarChar), new OracleParameter("HotelConfirm",OracleType.VarChar), new OracleParameter("HotelID",OracleType.VarChar), new OracleParameter("UserID",OracleType.VarChar), new OracleParameter("OrderID",OracleType.VarChar), new OracleParameter("FollowUp",OracleType.VarChar), new OracleParameter("StartDate",OracleType.VarChar), new OracleParameter("EndDate",OracleType.VarChar), new OracleParameter("FaxSNumber",OracleType.VarChar), new OracleParameter("FaxENumber",OracleType.VarChar), new OracleParameter("BStatusOther",OracleType.VarChar), new OracleParameter("PriceCode",OracleType.VarChar), new OracleParameter("BStatus",OracleType.VarChar) }; OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); if (String.IsNullOrEmpty(dbParm.CityID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.CityID; } if (String.IsNullOrEmpty(dbParm.CStatus)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = ("3".Equals(dbParm.CStatus)) ? "" : dbParm.CStatus; } if (String.IsNullOrEmpty(dbParm.FStatus)) { parm[2].Value = DBNull.Value; parm[10].Value = DBNull.Value; parm[11].Value = DBNull.Value; } else { parm[2].Value = dbParm.FStatus; parm[10].Value = DBNull.Value; parm[11].Value = DBNull.Value; //if ("4".Equals(dbParm.FStatus)) //{ // parm[2].Value = "1"; // parm[10].Value = "2"; // parm[11].Value = DBNull.Value; //} //else if ("1".Equals(dbParm.FStatus)) //{ // parm[2].Value = dbParm.FStatus; // parm[10].Value = "0"; // parm[11].Value = "1"; //} //else //{ // parm[2].Value = dbParm.FStatus; // parm[10].Value = DBNull.Value; // parm[11].Value = DBNull.Value; //} } if (String.IsNullOrEmpty(dbParm.HotelConfirm)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.HotelConfirm; } if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.HotelID; } if (String.IsNullOrEmpty(dbParm.UserID)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = dbParm.UserID; } if (String.IsNullOrEmpty(dbParm.OrderID)) { parm[6].Value = DBNull.Value; } else { parm[6].Value = dbParm.OrderID; } if ("3".Equals(dbParm.CStatus)) { parm[7].Value = "1"; } else { parm[7].Value = DBNull.Value; } if (String.IsNullOrEmpty(dbParm.StartDate)) { parm[8].Value = DBNull.Value; } else { parm[8].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { parm[9].Value = DBNull.Value; } else { parm[9].Value = dbParm.EndDate; } if (String.IsNullOrEmpty(dbParm.BOOK_STATUS_OTHER)) { parm[12].Value = DBNull.Value; } else { parm[12].Value = dbParm.BOOK_STATUS_OTHER; } if (String.IsNullOrEmpty(dbParm.PRICE_CODE)) { parm[13].Value = DBNull.Value; } else { parm[13].Value = dbParm.PRICE_CODE; } if (String.IsNullOrEmpty(dbParm.BOOK_STATUS)) { parm[14].Value = DBNull.Value; } else { parm[14].Value = dbParm.BOOK_STATUS; } //string SQLString = ("1".Equals(dbParm.SType)) ? HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderconfirminfo_select_init") : HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderconfirminfo_select"); string SQLString = ("1".Equals(dbParm.SType)) ? HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderconfirminfo_select_init_all") : HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderconfirminfo_select_all"); if (String.IsNullOrEmpty(dbParm.SortID)) { SQLString = SQLString + "order by t.price_code asc,t.create_time asc, toc.fax_status asc"; } else { SQLString = SQLString + "order by t.price_code asc,toc.order_id " + dbParm.SortID; } orderEntity.QueryResult = DbHelperOra.Query(SQLString, false, parm);//HotelVp.Common.DBUtility.DbManager.Query("OrderInfo", "t_lm_orderconfirminfo_select",true, parm); return orderEntity; }
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); }
public static OrderInfoEntity BindOrderConfirmManagerList(OrderInfoEntity orderEntity) { OracleParameter[] parm ={ new OracleParameter("CityID",OracleType.VarChar), new OracleParameter("FGStatus",OracleType.VarChar), new OracleParameter("HotelID",OracleType.VarChar), new OracleParameter("UserID",OracleType.VarChar), new OracleParameter("OrderID",OracleType.VarChar), new OracleParameter("StartDate",OracleType.VarChar), new OracleParameter("EndDate",OracleType.VarChar) }; OrderInfoDBEntity dbParm = (orderEntity.OrderInfoDBEntity.Count > 0) ? orderEntity.OrderInfoDBEntity[0] : new OrderInfoDBEntity(); if (String.IsNullOrEmpty(dbParm.CityID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.CityID; } if (String.IsNullOrEmpty(dbParm.FGStatus)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.FGStatus; } if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.HotelID; } if (String.IsNullOrEmpty(dbParm.UserID)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.UserID; } if (String.IsNullOrEmpty(dbParm.OrderID)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.OrderID; } if (String.IsNullOrEmpty(dbParm.StartDate)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = dbParm.StartDate; } if (String.IsNullOrEmpty(dbParm.EndDate)) { parm[6].Value = DBNull.Value; } else { parm[6].Value = dbParm.EndDate; } string SQLString = HotelVp.Common.DBUtility.XmlSqlAnalyze.GotSqlTextFromXml("OrderInfo", "t_lm_orderconfirmmginfo_select"); SQLString = SQLString + "order by t.fog_order_num " + dbParm.SortID + ", t.hotel_name"; DataSet dsResult = DbHelperOra.Query(SQLString, false, parm); if (dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++) { if (!String.IsNullOrEmpty(dsResult.Tables[0].Rows[i]["HVPNM"].ToString())) { dsResult.Tables[0].Rows[i]["HVPNM"] = GetSalesNUm(dsResult.Tables[0].Rows[i]["HVPNM"].ToString()); } } } orderEntity.QueryResult = dsResult; return orderEntity; }