public static void InsertHotelEXHistory(HotelInfoEXEntity hotelinfoexEntity) { HotelInfoEXDBEntity dbParm = (hotelinfoexEntity.HotelInfoEXDBEntity.Count > 0) ? hotelinfoexEntity.HotelInfoEXDBEntity[0] : new HotelInfoEXDBEntity(); DataCommand cmd = DataCommandManager.GetDataCommand("InsertHotelEX"); cmd.SetParameterValue("@HOTELID", dbParm.HotelID); cmd.SetParameterValue("@TYPE", dbParm.Type); cmd.SetParameterValue("@STATUS", dbParm.Status); cmd.SetParameterValue("@LINKMAN", dbParm.LinkMan); cmd.SetParameterValue("@LINKTEL", dbParm.LinkTel); cmd.SetParameterValue("@LINKFAX", dbParm.LinkFax); cmd.SetParameterValue("@LINKMAIL", dbParm.LinkMail); cmd.SetParameterValue("@EXTIME", dbParm.ExTime); cmd.SetParameterValue("@EXMODE", dbParm.ExMode); cmd.SetParameterValue("@REMARK", dbParm.Remark); cmd.SetParameterValue("@OPEUSER", dbParm.CreateUser); cmd.ExecuteNonQuery(); //int nid = (int)cmd.GetParameterValue("@PlanID"); //return planID; }
protected void btnUpdateLink_Click(object sender, EventArgs e) { HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); string hotelId = (ViewState.Count == 0 || String.IsNullOrEmpty(ViewState["HotelID"].ToString())) ? null : ViewState["HotelID"].ToString();//酒店ID if (String.IsNullOrEmpty(hotelId)) { messageContent.InnerHtml = "酒店联系信息保存失败,请选择酒店!"; ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "grLayout();", true); return; } //日间9点-18点 夜间 19点-8点 string OrderVerifyTime = rdOrderVerifyTimeDay.Checked == true ? "000000000111111111100000" : "111111111000000000011111";//日/夜审 string OrderVerifyType = rdOrderVerifyTypeFax.Checked == true ? "1" : "2";//审核方式 string rdOrderVerifyLinkMan = txtOrderVerifyLinkMan.Text;//审核联系人 string rdOrderVerifyLinkTel = txtOrderVerifyLinkTel.Text;//审核联系电话 string rdOrderVerifyLinkFax = txtOrderVerifyLinkFax.Text;//审核联系传真 string rdOrderVerifyRemark = this.txtOrderVerifyRemark.Value;//审核备注 hotelInfoEXDBEntity.HotelID = hotelId; hotelInfoEXDBEntity.Type = "3"; StringBuilder OrderVerifyLinkMan = new StringBuilder(); for (int i = 0; i < OrderVerifyTime.Length; i++) { if (OrderVerifyTime[i].ToString() == "1") { OrderVerifyLinkMan.Append(txtOrderVerifyLinkMan.Text + "|"); } else { OrderVerifyLinkMan.Append("|"); } } StringBuilder OrderVerifyLinkTel = new StringBuilder(); for (int i = 0; i < OrderVerifyTime.Length; i++) { if (OrderVerifyTime[i].ToString() == "1") { OrderVerifyLinkTel.Append(txtOrderVerifyLinkTel.Text + "|"); } else { OrderVerifyLinkTel.Append("|"); } } StringBuilder OrderVerifyLinkFax = new StringBuilder(); for (int i = 0; i < OrderVerifyTime.Length; i++) { if (OrderVerifyTime[i].ToString() == "1") { OrderVerifyLinkFax.Append(txtOrderVerifyLinkFax.Text + "|"); } else { OrderVerifyLinkFax.Append("|"); } } hotelInfoEXDBEntity.LinkMan = (OrderVerifyLinkMan.ToString().Length > 0) ? OrderVerifyLinkMan.ToString().Substring(0, OrderVerifyLinkMan.Length - 1) : OrderVerifyLinkMan.ToString(); hotelInfoEXDBEntity.LinkTel = (OrderVerifyLinkTel.ToString().Length > 0) ? OrderVerifyLinkTel.ToString().Substring(0, OrderVerifyLinkTel.Length - 1) : OrderVerifyLinkTel.ToString(); hotelInfoEXDBEntity.LinkFax = (OrderVerifyLinkFax.ToString().Length > 0) ? OrderVerifyLinkFax.ToString().Substring(0, OrderVerifyLinkFax.Length - 1) : OrderVerifyLinkFax.ToString(); hotelInfoEXDBEntity.Remark = rdOrderVerifyRemark; hotelInfoEXDBEntity.ExTime = OrderVerifyTime; hotelInfoEXDBEntity.ExMode = OrderVerifyType; hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserDspName; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserDspName; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); HotelInfoEXBP.SaveHotelInfoEX(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); _hotelinfoEXEntity.HotelInfoEXDBEntity.Clear(); messageContent.InnerHtml = "酒店联系信息保存成功!"; ScriptManager.RegisterStartupScript(this.UpdatePanel4, this.GetType(), "keyalert", "BtnCompleteStyle();", true); }
public static int InsertHotelInfoEX(HotelInfoEXEntity hotelinfoexEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("TYPE",OracleType.VarChar), new OracleParameter("LINKMAN",OracleType.VarChar), new OracleParameter("LINKTEL",OracleType.VarChar), new OracleParameter("LINKMAIL",OracleType.VarChar), new OracleParameter("LINKFAX",OracleType.VarChar), new OracleParameter("REMARK",OracleType.VarChar), new OracleParameter("EXTIME",OracleType.VarChar), new OracleParameter("EXMODE",OracleType.VarChar), new OracleParameter("CREATEUSER",OracleType.VarChar), new OracleParameter("STATUS",OracleType.VarChar), }; HotelInfoEXDBEntity dbParm = (hotelinfoexEntity.HotelInfoEXDBEntity.Count > 0) ? hotelinfoexEntity.HotelInfoEXDBEntity[0] : new HotelInfoEXDBEntity(); if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.HotelID; } if (String.IsNullOrEmpty(dbParm.Type)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.Type; } if (String.IsNullOrEmpty(dbParm.LinkMan)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.LinkMan; } if (String.IsNullOrEmpty(dbParm.LinkTel)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.LinkTel; } if (String.IsNullOrEmpty(dbParm.LinkMail)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.LinkMail; } if (String.IsNullOrEmpty(dbParm.LinkFax)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = dbParm.LinkFax; } if (String.IsNullOrEmpty(dbParm.Remark)) { parm[6].Value = DBNull.Value; } else { parm[6].Value = dbParm.Remark; } if (String.IsNullOrEmpty(dbParm.ExTime)) { parm[7].Value = DBNull.Value; } else { parm[7].Value = dbParm.ExTime; } if (String.IsNullOrEmpty(dbParm.ExMode)) { parm[8].Value = DBNull.Value; } else { parm[8].Value = dbParm.ExMode; } if (String.IsNullOrEmpty(dbParm.CreateUser)) { parm[9].Value = DBNull.Value; } else { parm[9].Value = dbParm.CreateUser; } if (String.IsNullOrEmpty(dbParm.Status)) { parm[10].Value = DBNull.Value; } else { parm[10].Value = dbParm.Status; } int i = DbManager.ExecuteSql("HotelInfoEX", "t_lm_hotel_ex_insert", parm); return i; }
public static int UpdateHotelInfoEXByConsultRoom(HotelInfoEXEntity hotelinfoexEntity) { OracleParameter[] parm ={ new OracleParameter("REMARK",OracleType.VarChar), new OracleParameter("UPDATEUSER",OracleType.VarChar), new OracleParameter("HOTELID",OracleType.VarChar), new OracleParameter("TYPE",OracleType.VarChar), new OracleParameter("LINKMAN",OracleType.VarChar), new OracleParameter("LINKTEL",OracleType.VarChar) }; HotelInfoEXDBEntity dbParm = (hotelinfoexEntity.HotelInfoEXDBEntity.Count > 0) ? hotelinfoexEntity.HotelInfoEXDBEntity[0] : new HotelInfoEXDBEntity(); if (String.IsNullOrEmpty(dbParm.Remark)) { parm[0].Value = DBNull.Value; } else { parm[0].Value = dbParm.Remark; } if (String.IsNullOrEmpty(dbParm.UpdateUser)) { parm[1].Value = DBNull.Value; } else { parm[1].Value = dbParm.UpdateUser; } if (String.IsNullOrEmpty(dbParm.HotelID)) { parm[2].Value = DBNull.Value; } else { parm[2].Value = dbParm.HotelID; } if (String.IsNullOrEmpty(dbParm.Type)) { parm[3].Value = DBNull.Value; } else { parm[3].Value = dbParm.Type; } if (String.IsNullOrEmpty(dbParm.LinkMan)) { parm[4].Value = DBNull.Value; } else { parm[4].Value = dbParm.LinkMan; } if (String.IsNullOrEmpty(dbParm.LinkTel)) { parm[5].Value = DBNull.Value; } else { parm[5].Value = dbParm.LinkTel; } int i = DbManager.ExecuteSql("HotelInfoEX", "t_lm_hotel_ex_update_by_consultroom", parm); return i; }
public static HotelInfoEXEntity SelectHotelInfoEX(HotelInfoEXEntity hotelinfoexEntity) { OracleParameter[] parm ={ new OracleParameter("HOTELID",OracleType.VarChar) }; HotelInfoEXDBEntity dbParm = (hotelinfoexEntity.HotelInfoEXDBEntity.Count > 0) ? hotelinfoexEntity.HotelInfoEXDBEntity[0] : new HotelInfoEXDBEntity(); parm[0].Value = dbParm.HotelID; hotelinfoexEntity.QueryResult = HotelVp.Common.DBUtility.DbManager.Query("HotelInfoEX", "t_lm_hotel_ex_select_byhotelid", true, parm); return hotelinfoexEntity; }
/// <summary> /// 从HotelEx 获取询房信息 --- Oracle /// </summary> /// <returns></returns> public DataRow GetHotelExInfo() { HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); hotelInfoEXDBEntity.HotelID = this.HidPid.Value;//酒店ID _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); DataSet dsResult = HotelInfoEXBP.SelectHotelInfoEX(_hotelinfoEXEntity).QueryResult; if (dsResult.Tables[0] != null && dsResult.Tables[0].Rows.Count > 0) { DataRow[] rows = dsResult.Tables[0].Select("type='" + 1 + "'"); if (rows.Length > 0) { //this.EXHotelInfo.Value = "1"; //this.EXLinkFax.Value = rows[0]["LinkFax"].ToString(); //this.EXExTime.Value = rows[0]["EX_Time"].ToString(); //this.EXExMode.Value = rows[0]["EX_Mode"].ToString(); ViewState["EXHotelInfo"] = "1"; ViewState["EXLinkFax"] = rows[0]["LinkFax"].ToString(); ViewState["EXExTime"] = rows[0]["EX_Time"].ToString(); ViewState["EXExMode"] = rows[0]["EX_Mode"].ToString(); return rows[0]; } else { //this.EXHotelInfo.Value = "0"; //this.EXLinkFax.Value = ""; //this.EXExTime.Value = ""; //this.EXExMode.Value = ""; ViewState["EXHotelInfo"] = "0"; ViewState["EXLinkFax"] = ""; ViewState["EXExTime"] = ""; ViewState["EXExMode"] = ""; return null; } } else { //this.EXHotelInfo.Value = "0"; //this.EXLinkFax.Value = ""; //this.EXExTime.Value = ""; //this.EXExMode.Value = ""; ViewState["EXHotelInfo"] = "0"; ViewState["EXLinkFax"] = ""; ViewState["EXExTime"] = ""; ViewState["EXExMode"] = ""; return null; } }
/// <summary> /// 修改备注 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnEditEXInfo_Click(object sender, EventArgs e) { GetHotelExInfo(); HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); StringBuilder QueryRoomLinkMan = new StringBuilder(); for (int i = 0; i < 23; i++) { QueryRoomLinkMan.Append(this.HotelEXLinkMan_txt.Text.TrimStart('(').TrimEnd(')') + "|"); //查房联系人 } StringBuilder QueryRoomLinkTel = new StringBuilder(); for (int i = 0; i < 23; i++) { QueryRoomLinkTel.Append(this.HotelEXLinkTel_txt.Text.TrimStart('(').TrimEnd(')') + "|");//查房联系电话 } if (ViewState["EXHotelInfo"].ToString() != "0") { #region hotelInfoEXDBEntity.HotelID = this.HidPid.Value;//酒店ID hotelInfoEXDBEntity.Type = "1"; hotelInfoEXDBEntity.LinkMan = QueryRoomLinkMan.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkTel = QueryRoomLinkTel.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkFax = ViewState["EXLinkFax"].ToString(); hotelInfoEXDBEntity.Remark = this.HotelEXLinkRemark_txt.InnerHtml; hotelInfoEXDBEntity.ExTime = ViewState["EXExTime"].ToString(); hotelInfoEXDBEntity.ExMode = ViewState["EXExMode"].ToString(); hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserAccount; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserAccount; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); HotelInfoEXBP.UpdateHotelInfoEXByConsultRoom(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); #endregion } else { #region hotelInfoEXDBEntity.HotelID = this.HidPid.Value; hotelInfoEXDBEntity.Type = "1"; hotelInfoEXDBEntity.LinkMan = QueryRoomLinkMan.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkTel = QueryRoomLinkTel.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkFax = ""; hotelInfoEXDBEntity.Remark = this.HotelEXLinkRemark_txt.InnerHtml; hotelInfoEXDBEntity.ExTime = "111110000000000000111111"; hotelInfoEXDBEntity.ExMode = "1"; hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserAccount; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserAccount; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); #endregion } this.HotelEXLinkMan_span.Text = this.HotelEXLinkMan_txt.Text; this.HotelEXLinkMan_txt.Text = this.HotelEXLinkMan_txt.Text; this.HotelEXLinkTel_span.Text = this.HotelEXLinkTel_txt.Text; this.HotelEXLinkTel_txt.Text = this.HotelEXLinkTel_txt.Text; this.HotelEXLinkRemark_span.InnerHtml = this.HotelEXLinkRemark_txt.InnerHtml; this.HotelEXLinkRemark_txt.InnerHtml = this.HotelEXLinkRemark_txt.InnerHtml; this.btnClearLock.Attributes["style"] = "display:''"; this.SPANHotelEXLinkRemark.Attributes["style"] = "display:''"; this.btnEditRemark.Attributes.Add("style", "display:none"); this.TXTotelEXLinkRemark.Attributes.Add("style", "display:none"); this.UpdatePanel8.Update(); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "keyEditRemark", "BtnCompleteStyle();", true); }
public static string EditEXInfoDetails(string hotelID, string linkman, string linktel, string remark) { try { DataRow rows = GetHotelExInfo(hotelID); HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); StringBuilder QueryRoomLinkMan = new StringBuilder(); for (int i = 0; i <= 23; i++) { QueryRoomLinkMan.Append(linkman.TrimStart('(').TrimEnd(')') + "|"); //查房联系人 } StringBuilder QueryRoomLinkTel = new StringBuilder(); for (int i = 0; i <= 23; i++) { QueryRoomLinkTel.Append(linktel.TrimStart('(').TrimEnd(')') + "|");//查房联系电话 } if (rows != null) { #region hotelInfoEXDBEntity.HotelID = hotelID;//酒店ID hotelInfoEXDBEntity.Type = "1"; hotelInfoEXDBEntity.LinkMan = QueryRoomLinkMan.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkTel = QueryRoomLinkTel.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkFax = rows["LinkFax"].ToString(); hotelInfoEXDBEntity.Remark = remark; hotelInfoEXDBEntity.ExTime = rows["EX_Time"].ToString(); hotelInfoEXDBEntity.ExMode = rows["EX_Mode"].ToString(); hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserAccount; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserAccount; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); HotelInfoEXBP.UpdateHotelInfoEXByConsultRoom(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); #endregion } else { #region hotelInfoEXDBEntity.HotelID = hotelID; hotelInfoEXDBEntity.Type = "1"; hotelInfoEXDBEntity.LinkMan = QueryRoomLinkMan.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkTel = QueryRoomLinkTel.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkFax = ""; hotelInfoEXDBEntity.Remark = remark; hotelInfoEXDBEntity.ExTime = "111110000000000000111111"; hotelInfoEXDBEntity.ExMode = "1"; hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserAccount; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserAccount; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); #endregion } return "{\"message\":\"success\",\"code\":200}"; } catch (Exception ex) { return "{\"message\":\"fail\",\"code\":-1}"; } }
/// <summary> /// 从HotelEx 获取询房信息 --- Oracle /// </summary> /// <returns></returns> public static DataRow GetHotelExInfo(string hotelID) { HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); hotelInfoEXDBEntity.HotelID = hotelID;//酒店ID _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); DataSet dsResult = HotelInfoEXBP.SelectHotelInfoEX(_hotelinfoEXEntity).QueryResult; if (dsResult.Tables[0] != null && dsResult.Tables[0].Rows.Count > 0) { DataRow[] rows = dsResult.Tables[0].Select("type='" + 1 + "'"); if (rows.Length > 0) { return rows[0]; } else { return null; } } else { return null; } }
public void BindHotelEXInfo() { if (!String.IsNullOrEmpty(hidHotelID.Value)) { string strHotel = hidSaveHotelID.Value; MessageContent.InnerHtml = ""; if (!strHotel.Contains("[") || !strHotel.Contains("]") || String.IsNullOrEmpty(strHotel)) { ReSetControlVal(); MessageContent.InnerHtml = GetLocalResourceObject("SelectError").ToString(); return; } HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); hotelInfoEXDBEntity.HotelID = hidHotelID.Value;//酒店ID _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); DataSet dsResult = HotelInfoEXBP.SelectHotelInfoEX(_hotelinfoEXEntity).QueryResult; #region 房控查询联系方式 DataRow[] dtQueryRoom = dsResult.Tables[0].Select("type='" + 1 + "'"); if (dtQueryRoom.Length > 0) { //查房频率 if (dtQueryRoom[0]["Ex_Mode"].ToString() == "1") { this.rdEveryDay.Checked = true; this.rdTwoDay.Checked = false; this.rdEver.Checked = false; } else if (dtQueryRoom[0]["Ex_Mode"].ToString() == "2") { this.rdEveryDay.Checked = false; this.rdTwoDay.Checked = true; this.rdEver.Checked = false; } else { this.rdEveryDay.Checked = false; this.rdTwoDay.Checked = false; this.rdEver.Checked = true; } //上线时间 111110000000000000111111 if (dtQueryRoom[0]["Ex_Time"].ToString() == "111110000000001111111111") { this.rdOnLine14.Checked = true; this.rdOnLine18.Checked = false; } else { this.rdOnLine14.Checked = false; this.rdOnLine18.Checked = true; } //查询联系人 this.txtQueryRoomLinkMan.Text = dtQueryRoom[0]["LINKMAN"].ToString() == "" ? "" : dtQueryRoom[0]["LINKMAN"].ToString().Split('|')[0].ToString(); //查房联系电话 this.txtQueryRoomLinkTel.Text = dtQueryRoom[0]["LINKTEL"].ToString() == "" ? "" : dtQueryRoom[0]["LINKTEL"].ToString().Split('|')[0].ToString(); //查房传真 this.txtQueryRoomLinkFax.Text = dtQueryRoom[0]["LINKFAX"].ToString() == "" ? "" : dtQueryRoom[0]["LINKFAX"].ToString().Split('|')[0].ToString(); //查房备注 this.txtQueryRoomRemark.InnerHtml = dtQueryRoom[0]["REMARK"].ToString(); } #endregion #region 订单确认方式 DataRow[] dtOrderAffirm = dsResult.Tables[0].Select("type='" + 2 + "'"); if (dtOrderAffirm.Length > 0) { //日间传真 this.txtOrderAffirmDayLinkFax.Text = dtOrderAffirm[0]["LINKFAX"].ToString() == "" ? "" : dtOrderAffirm[0]["LINKFAX"].ToString().Split('|')[9].ToString(); //日间联系人 this.txtOrderAffirmDayLinkMan.Text = dtOrderAffirm[0]["LINKMAN"].ToString() == "" ? "" : dtOrderAffirm[0]["LINKMAN"].ToString().Split('|')[9].ToString(); //日间联系电话 this.txtOrderAffirmDayLinkTel.Text = dtOrderAffirm[0]["LINKTEL"].ToString() == "" ? "" : dtOrderAffirm[0]["LINKTEL"].ToString().Split('|')[9].ToString(); //夜间传真 this.txtOrderAffirmNightLinkFax.Text = dtOrderAffirm[0]["LINKFAX"].ToString() == "" ? "" : dtOrderAffirm[0]["LINKFAX"].ToString().Split('|')[19].ToString(); //夜间联系人 this.txtOrderAffirmNightLinkMan.Text = dtOrderAffirm[0]["LINKMAN"].ToString() == "" ? "" : dtOrderAffirm[0]["LINKMAN"].ToString().Split('|')[19].ToString(); //夜间联系电话 this.txtOrderAffirmNightLinkTel.Text = dtOrderAffirm[0]["LINKTEL"].ToString() == "" ? "" : dtOrderAffirm[0]["LINKTEL"].ToString().Split('|')[19].ToString(); //订单确认备注 this.txtOrderAffirmRemark.InnerHtml = dtOrderAffirm[0]["REMARK"].ToString(); } #endregion #region 订单审核方式 DataRow[] dtOrderVerify = dsResult.Tables[0].Select("type='" + 3 + "'"); if (dtOrderVerify.Length > 0) { //日/夜审 if (dtOrderVerify[0]["Ex_Mode"].ToString() == "1") { this.rdOrderVerifyTypeFax.Checked = true; this.rdOrderVerifyTypeTel.Checked = false; } else { this.rdOrderVerifyTypeFax.Checked = false; this.rdOrderVerifyTypeTel.Checked = true; } //审核方式 if (dtOrderVerify[0]["Ex_Time"].ToString() == "000000000111111111100000") { this.rdOrderVerifyTimeDay.Checked = true; this.rdOrderVerifyTimeNight.Checked = false; } else { this.rdOrderVerifyTimeDay.Checked = false; this.rdOrderVerifyTimeNight.Checked = true; } if (dtOrderVerify[0]["Ex_Time"].ToString() == "000000000111111111100000") { //审核联系人 this.rdOrderVerifyLinkMan.Text = dtOrderVerify[0]["LINKMAN"].ToString() == "" ? "" : dtOrderVerify[0]["LINKMAN"].ToString().Split('|')[10].ToString(); //审核联系电话 this.rdOrderVerifyLinkTel.Text = dtOrderVerify[0]["LINKTEL"].ToString() == "" ? "" : dtOrderVerify[0]["LINKTEL"].ToString().Split('|')[10].ToString(); //审核联系传真 this.rdOrderVerifyLinkFax.Text = dtOrderVerify[0]["LINKFAX"].ToString() == "" ? "" : dtOrderVerify[0]["LINKFAX"].ToString().Split('|')[10].ToString(); //日间9点-18点 夜间 19点-8点 //string OrderVerifyTime = this.rdOrderVerifyTimeDay.Checked == true ? "000000000111111111100000" : "111111111000000000011111";//日/夜审 } else { //审核联系人 this.rdOrderVerifyLinkMan.Text = dtOrderVerify[0]["LINKMAN"].ToString() == "" ? "" : dtOrderVerify[0]["LINKMAN"].ToString().Split('|')[0].ToString(); //审核联系电话 this.rdOrderVerifyLinkTel.Text = dtOrderVerify[0]["LINKTEL"].ToString() == "" ? "" : dtOrderVerify[0]["LINKTEL"].ToString().Split('|')[0].ToString(); //审核联系传真 this.rdOrderVerifyLinkFax.Text = dtOrderVerify[0]["LINKFAX"].ToString() == "" ? "" : dtOrderVerify[0]["LINKFAX"].ToString().Split('|')[0].ToString(); } //审核备注 this.rdOrderVerifyRemark.InnerHtml = dtOrderVerify[0]["REMARK"].ToString(); } #endregion } }
public void SaveHotelExecuteInfo() { MessageContent.InnerHtml = ""; if (!String.IsNullOrEmpty(hidHotelID.Value)) { string strHotel = hidSaveHotelID.Value; MessageContent.InnerHtml = ""; if (!strHotel.Contains("[") || !strHotel.Contains("]") || String.IsNullOrEmpty(strHotel)) { ReSetControlVal(); MessageContent.InnerHtml = GetLocalResourceObject("SelectError").ToString(); return; } #region if (string.IsNullOrEmpty(this.txtQueryRoomLinkMan.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "房控查询联系方式-查房联系人不能为空!"; return; } if (string.IsNullOrEmpty(this.txtQueryRoomLinkTel.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "房控查询联系方式-查房联系电话不能为空!"; return; } #endregion #region if (string.IsNullOrEmpty(this.txtOrderAffirmDayLinkMan.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "订单确认方式-日间联系人不能为空!"; return; } if (string.IsNullOrEmpty(this.txtOrderAffirmDayLinkTel.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "订单确认方式-日间联系电话不能为空!"; return; } if (string.IsNullOrEmpty(this.txtOrderAffirmNightLinkMan.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "订单确认方式-夜间联系人不能为空!"; return; } if (string.IsNullOrEmpty(this.txtOrderAffirmNightLinkTel.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "订单确认方式-夜间联系电话不能为空!"; return; } #endregion #region if (string.IsNullOrEmpty(this.rdOrderVerifyLinkMan.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "订单审核方式-审核联系人不能为空!"; return; } if (rdOrderVerifyTypeFax.Checked) { if (string.IsNullOrEmpty(this.rdOrderVerifyLinkFax.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "订单审核方式-审核联系传真不能为空!"; return; } } else { if (string.IsNullOrEmpty(this.rdOrderVerifyLinkTel.Text)) { ReSetControlVal(); MessageContent.InnerHtml = "订单审核方式-审核联系电话不能为空!"; return; } } #endregion if (!chkDaveValVaild()) { ReSetControlVal(); MessageContent.InnerHtml = GetLocalResourceObject("UpdateError911").ToString(); return; } try { DataTable dtResultNum = GetHotelExNum(); HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); string hotelId = hidHotelID.Value;//酒店ID #region 房控查询联系方式 string QueryRoomRate = "";//查房频率 1每天:2两天一次:3永不询房 if (this.rdEveryDay.Checked) { QueryRoomRate = "1"; } else if (this.rdTwoDay.Checked) { QueryRoomRate = "2"; } else { QueryRoomRate = "3"; } string OnLine = this.rdOnLine14.Checked == true ? "111110000000001111111111" : "111110000000000000111111";//上线时间 14点 18点 StringBuilder QueryRoomLinkMan = new StringBuilder(); for (int i = 0; i <= 23; i++) { QueryRoomLinkMan.Append(this.txtQueryRoomLinkMan.Text + "|"); //查房联系人 this.txtQueryRoomLinkMan.Text; } StringBuilder QueryRoomLinkTel = new StringBuilder(); for (int i = 0; i <= 23; i++) { QueryRoomLinkTel.Append(this.txtQueryRoomLinkTel.Text + "|");//查房联系电话 this.txtQueryRoomLinkTel.Text; } StringBuilder QueryRoomLinkFax = new StringBuilder(); for (int i = 0; i <= 23; i++) { QueryRoomLinkFax.Append(this.txtQueryRoomLinkFax.Text + "|");//查房联系传真 this.txtQueryRoomLinkFax.Text; } string QueryRoomRemark = this.txtQueryRoomRemark.Value;//查房备注 hotelInfoEXDBEntity.HotelID = hotelId; hotelInfoEXDBEntity.Type = "1"; //hotelInfoEXDBEntity.LinkMan = QueryRoomLinkMan.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkTel = QueryRoomLinkTel.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkFax = QueryRoomLinkFax.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkMan = (QueryRoomLinkMan.ToString().Length > 0) ? QueryRoomLinkMan.ToString().Substring(0, QueryRoomLinkMan.Length - 1) : QueryRoomLinkMan.ToString(); hotelInfoEXDBEntity.LinkTel = (QueryRoomLinkTel.ToString().Length > 0) ? QueryRoomLinkTel.ToString().Substring(0, QueryRoomLinkTel.Length - 1) : QueryRoomLinkTel.ToString(); hotelInfoEXDBEntity.LinkFax = (QueryRoomLinkFax.ToString().Length > 0) ? QueryRoomLinkFax.ToString().Substring(0, QueryRoomLinkFax.Length - 1) : QueryRoomLinkFax.ToString(); hotelInfoEXDBEntity.Remark = QueryRoomRemark; hotelInfoEXDBEntity.ExTime = OnLine; hotelInfoEXDBEntity.ExMode = QueryRoomRate; hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserDspName; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserDspName; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); DataRow[] dtQueryRoom = dtResultNum.Select("type='" + 1 + "'"); if (dtQueryRoom.Length > 0) { HotelInfoEXBP.UpdateHotelInfoEX(_hotelinfoEXEntity); } else { HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); } //int result1 = HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); //int result1 = HotelInfoEXBP.UpdateHotelInfoEX(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); _hotelinfoEXEntity.HotelInfoEXDBEntity.Clear(); #endregion #region 订单确认方式 //日间9点-18点 夜间 19点-8点 StringBuilder OrderAffirmLinkFax = new StringBuilder(); string OrderAffirmDayLinkFax = this.txtOrderAffirmDayLinkFax.Text;//日间传真 string OrderAffirmNightLinkFax = this.txtOrderAffirmNightLinkFax.Text;//夜间传真 for (int i = 0; i <= 23; i++) { if (i >= 9 && i <= 18) { OrderAffirmLinkFax.Append(this.txtOrderAffirmDayLinkFax.Text + "|"); } else { OrderAffirmLinkFax.Append(this.txtOrderAffirmNightLinkFax.Text + "|"); } } StringBuilder OrderAffirmLinkMan = new StringBuilder(); string OrderAffirmDayLinkMan = this.txtOrderAffirmDayLinkMan.Text;//日间联系人 string OrderAffirmNightLinkMan = this.txtOrderAffirmNightLinkMan.Text;//夜间联系人 for (int i = 0; i <= 23; i++) { if (i >= 9 && i <= 18) { OrderAffirmLinkMan.Append(this.txtOrderAffirmDayLinkMan.Text + "|"); } else { OrderAffirmLinkMan.Append(this.txtOrderAffirmNightLinkMan.Text + "|"); } } StringBuilder OrderAffirmLinkTel = new StringBuilder(); string OrderAffirmDayLinkTel = this.txtOrderAffirmDayLinkTel.Text;//日间联系电话 string OrderAffirmNightLinkTel = this.txtOrderAffirmNightLinkTel.Text;//夜间联系电话 for (int i = 0; i <= 23; i++) { if (i >= 9 && i <= 18) { OrderAffirmLinkTel.Append(this.txtOrderAffirmDayLinkTel.Text + "|"); } else { OrderAffirmLinkTel.Append(this.txtOrderAffirmNightLinkTel.Text + "|"); } } string OrderAffirmRemark = this.txtOrderAffirmRemark.Value;//订单确认备注 hotelInfoEXDBEntity.HotelID = hotelId; hotelInfoEXDBEntity.Type = "2"; //hotelInfoEXDBEntity.LinkMan = OrderAffirmLinkMan.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkTel = OrderAffirmLinkTel.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkFax = OrderAffirmLinkFax.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkMan = (OrderAffirmLinkMan.ToString().Length > 0) ? OrderAffirmLinkMan.ToString().Substring(0, OrderAffirmLinkMan.Length - 1) : OrderAffirmLinkMan.ToString(); hotelInfoEXDBEntity.LinkTel = (OrderAffirmLinkTel.ToString().Length > 0) ? OrderAffirmLinkTel.ToString().Substring(0, OrderAffirmLinkTel.Length - 1) : OrderAffirmLinkTel.ToString(); hotelInfoEXDBEntity.LinkFax = (OrderAffirmLinkFax.ToString().Length > 0) ? OrderAffirmLinkFax.ToString().Substring(0, OrderAffirmLinkFax.Length - 1) : OrderAffirmLinkFax.ToString(); hotelInfoEXDBEntity.Remark = QueryRoomRemark; hotelInfoEXDBEntity.ExTime = "111111111111111111111111"; hotelInfoEXDBEntity.ExMode = ""; hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserDspName; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserDspName; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); DataRow[] dtOrderAffirm = dtResultNum.Select("type='" + 2 + "'"); if (dtOrderAffirm.Length > 0) { HotelInfoEXBP.UpdateHotelInfoEX(_hotelinfoEXEntity); } else { HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); } //int result2 = HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); //int result2 = HotelInfoEXBP.UpdateHotelInfoEX(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); _hotelinfoEXEntity.HotelInfoEXDBEntity.Clear(); #endregion #region 订单审核方式 //日间9点-18点 夜间 19点-8点 string OrderVerifyTime = this.rdOrderVerifyTimeDay.Checked == true ? "000000000111111111100000" : "111111111000000000011111";//日/夜审 string OrderVerifyType = this.rdOrderVerifyTypeFax.Checked == true ? "1" : "2";//审核方式 string rdOrderVerifyLinkMan = this.rdOrderVerifyLinkMan.Text;//审核联系人 string rdOrderVerifyLinkTel = this.rdOrderVerifyLinkTel.Text;//审核联系电话 string rdOrderVerifyLinkFax = this.rdOrderVerifyLinkFax.Text;//审核联系传真 string rdOrderVerifyRemark = this.rdOrderVerifyRemark.Value;//审核备注 hotelInfoEXDBEntity.HotelID = hotelId; hotelInfoEXDBEntity.Type = "3"; StringBuilder OrderVerifyLinkMan = new StringBuilder(); for (int i = 0; i < OrderVerifyTime.Length; i++) { if (OrderVerifyTime[i].ToString() == "1") { OrderVerifyLinkMan.Append(this.rdOrderVerifyLinkMan.Text + "|"); } else { OrderVerifyLinkMan.Append("|"); } } StringBuilder OrderVerifyLinkTel = new StringBuilder(); for (int i = 0; i < OrderVerifyTime.Length; i++) { if (OrderVerifyTime[i].ToString() == "1") { OrderVerifyLinkTel.Append(this.rdOrderVerifyLinkTel.Text + "|"); } else { OrderVerifyLinkTel.Append("|"); } } StringBuilder OrderVerifyLinkFax = new StringBuilder(); for (int i = 0; i < OrderVerifyTime.Length; i++) { if (OrderVerifyTime[i].ToString() == "1") { OrderVerifyLinkFax.Append(this.rdOrderVerifyLinkFax.Text + "|"); } else { OrderVerifyLinkFax.Append("|"); } } //hotelInfoEXDBEntity.LinkMan = OrderVerifyLinkMan.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkTel = OrderVerifyLinkTel.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkFax = OrderVerifyLinkFax.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkMan = (OrderVerifyLinkMan.ToString().Length > 0) ? OrderVerifyLinkMan.ToString().Substring(0, OrderVerifyLinkMan.Length - 1) : OrderVerifyLinkMan.ToString(); hotelInfoEXDBEntity.LinkTel = (OrderVerifyLinkTel.ToString().Length > 0) ? OrderVerifyLinkTel.ToString().Substring(0, OrderVerifyLinkTel.Length - 1) : OrderVerifyLinkTel.ToString(); hotelInfoEXDBEntity.LinkFax = (OrderVerifyLinkFax.ToString().Length > 0) ? OrderVerifyLinkFax.ToString().Substring(0, OrderVerifyLinkFax.Length - 1) : OrderVerifyLinkFax.ToString(); hotelInfoEXDBEntity.Remark = rdOrderVerifyRemark; hotelInfoEXDBEntity.ExTime = OrderVerifyTime; hotelInfoEXDBEntity.ExMode = OrderVerifyType; hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserDspName; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserDspName; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); DataRow[] dtOrderVerify = dtResultNum.Select("type='" + 3 + "'"); if (dtOrderVerify.Length > 0) { HotelInfoEXBP.UpdateHotelInfoEX(_hotelinfoEXEntity); } else { HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); } //int result3 = HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); //int result3 = HotelInfoEXBP.UpdateHotelInfoEX(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); _hotelinfoEXEntity.HotelInfoEXDBEntity.Clear(); MessageContent.InnerHtml = "酒店执行信息保存成功!"; #endregion } catch (Exception ex) { MessageContent.InnerHtml = "酒店执行信息保存失败!"; } } else { SetSelectHotelControl(); } }
public DataTable GetHotelExNum() { HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); hotelInfoEXDBEntity.HotelID = hidHotelID.Value;//酒店ID _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); DataSet dsResult = HotelInfoEXBP.SelectHotelInfoEX(_hotelinfoEXEntity).QueryResult; return dsResult.Tables[0]; }
/// <summary> /// 修改备注 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnEditRemark_Click(object sender, EventArgs e) { GetHotelExInfo(); System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "\r\nLM联系人(btnAlertLink_Click)--修改计划EX信息--开始--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); StringBuilder QueryRoomLinkMan = new StringBuilder(); for (int i = 0; i <= 23; i++) { QueryRoomLinkMan.Append(this.HotelEXLinkMan_txt.Text.TrimStart('(').TrimEnd(')') + "|"); //查房联系人 } StringBuilder QueryRoomLinkTel = new StringBuilder(); for (int i = 0; i <= 23; i++) { QueryRoomLinkTel.Append(this.HotelEXLinkTel_txt.Text.TrimStart('(').TrimEnd(')') + "|");//查房联系电话 } if (this.EXHotelInfo.Value != "0") { System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "LM联系人(btnAlertLink_Click)--修改计划EX信息--EXHotelInfo.Value==0(Update)--开始--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); #region hotelInfoEXDBEntity.HotelID = this.HidPid.Value;//酒店ID hotelInfoEXDBEntity.Type = "1"; //hotelInfoEXDBEntity.LinkMan = QueryRoomLinkMan.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkTel = QueryRoomLinkTel.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkMan = (QueryRoomLinkMan.ToString().Length > 0) ? QueryRoomLinkMan.ToString().Substring(0, QueryRoomLinkMan.Length - 1) : QueryRoomLinkMan.ToString(); hotelInfoEXDBEntity.LinkTel = (QueryRoomLinkTel.ToString().Length > 0) ? QueryRoomLinkTel.ToString().Substring(0, QueryRoomLinkTel.Length - 1) : QueryRoomLinkTel.ToString(); hotelInfoEXDBEntity.LinkFax = this.EXLinkFax.Value.ToString(); hotelInfoEXDBEntity.Remark = this.HotelEXLinkRemark_txt.InnerHtml; hotelInfoEXDBEntity.ExTime = this.EXExTime.Value.ToString(); hotelInfoEXDBEntity.ExMode = this.EXExMode.Value.ToString(); hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserAccount; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserAccount; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); HotelInfoEXBP.UpdateHotelInfoEXByConsultRoom(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); #endregion System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "LM联系人(btnAlertLink_Click)--修改计划EX信息--EXHotelInfo.Value==0(Insert)--结束--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); } else { System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "LM联系人(btnAlertLink_Click)--修改计划EX信息--EXHotelInfo.Value==0(Insert)--开始--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); #region hotelInfoEXDBEntity.HotelID = this.HidPid.Value; hotelInfoEXDBEntity.Type = "1"; //hotelInfoEXDBEntity.LinkMan = QueryRoomLinkMan.ToString().TrimEnd('|'); //hotelInfoEXDBEntity.LinkTel = QueryRoomLinkTel.ToString().TrimEnd('|'); hotelInfoEXDBEntity.LinkMan = (QueryRoomLinkMan.ToString().Length > 0) ? QueryRoomLinkMan.ToString().Substring(0, QueryRoomLinkMan.Length - 1) : QueryRoomLinkMan.ToString(); hotelInfoEXDBEntity.LinkTel = (QueryRoomLinkTel.ToString().Length > 0) ? QueryRoomLinkTel.ToString().Substring(0, QueryRoomLinkTel.Length - 1) : QueryRoomLinkTel.ToString(); hotelInfoEXDBEntity.LinkFax = ""; hotelInfoEXDBEntity.Remark = this.HotelEXLinkRemark_txt.InnerHtml; hotelInfoEXDBEntity.ExTime = "111110000000000000111111"; hotelInfoEXDBEntity.ExMode = "1"; hotelInfoEXDBEntity.Status = "1"; hotelInfoEXDBEntity.CreateUser = UserSession.Current.UserAccount; hotelInfoEXDBEntity.UpdateUser = UserSession.Current.UserAccount; _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); HotelInfoEXBP.InsertHotelInfoEX(_hotelinfoEXEntity); HotelInfoEXBP.InsertHotelEXHistory(_hotelinfoEXEntity); #endregion System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "LM联系人(btnAlertLink_Click)--修改计划EX信息--EXHotelInfo.Value==0(Insert)--结束--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); } this.HotelEXLinkMan_span.Text = this.HotelEXLinkMan_txt.Text; this.HotelEXLinkMan_txt.Text = this.HotelEXLinkMan_txt.Text; this.HotelEXLinkTel_span.Text = this.HotelEXLinkTel_txt.Text; this.HotelEXLinkTel_txt.Text = this.HotelEXLinkTel_txt.Text; this.HotelEXLinkRemark_span.InnerHtml = this.HotelEXLinkRemark_txt.InnerHtml; this.HotelEXLinkRemark_txt.InnerHtml = this.HotelEXLinkRemark_txt.InnerHtml; this.btnClearLock.Attributes["style"] = "display:''"; this.SPANHotelEXLinkRemark.Attributes["style"] = "display:''"; this.btnEditRemark.Attributes.Add("style", "display:none"); this.TXTotelEXLinkRemark.Attributes.Add("style", "display:none"); this.UpdatePanel8.Update(); ScriptManager.RegisterStartupScript(this.UpdatePanel6, this.GetType(), "keyEditRemark", "BtnCompleteStyle();", true); System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "LM联系人(btnAlertLink_Click)--修改计划EX信息--结束--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); }
/// <summary> /// 从HotelEx 获取询房信息 --- Oracle /// </summary> /// <returns></returns> public DataRow GetHotelExInfo() { HotelInfoEXEntity _hotelinfoEXEntity = new HotelInfoEXEntity(); _hotelinfoEXEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _hotelinfoEXEntity.LogMessages.Userid = UserSession.Current.UserAccount; _hotelinfoEXEntity.LogMessages.Username = UserSession.Current.UserDspName; _hotelinfoEXEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _hotelinfoEXEntity.HotelInfoEXDBEntity = new List<HotelInfoEXDBEntity>(); HotelInfoEXDBEntity hotelInfoEXDBEntity = new HotelInfoEXDBEntity(); hotelInfoEXDBEntity.HotelID = this.HidPid.Value;//酒店ID _hotelinfoEXEntity.HotelInfoEXDBEntity.Add(hotelInfoEXDBEntity); System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "\r\n从HotelEx 获取询房信息--Oracle(GetHotelExInfo)--开始--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); DataSet dsResult = HotelInfoEXBP.SelectHotelInfoEX(_hotelinfoEXEntity).QueryResult; System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt", "从HotelEx 获取询房信息--Oracle(GetHotelExInfo)--结束--时间:" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312")); if (dsResult.Tables[0] != null && dsResult.Tables[0].Rows.Count > 0) { DataRow[] rows = dsResult.Tables[0].Select("type='" + 1 + "'"); if (rows.Length > 0) { this.EXHotelInfo.Value = "1"; this.EXLinkFax.Value = rows[0]["LinkFax"].ToString(); this.EXExTime.Value = rows[0]["EX_Time"].ToString(); this.EXExMode.Value = rows[0]["EX_Mode"].ToString(); return rows[0]; } else { this.EXHotelInfo.Value = "0"; this.EXLinkFax.Value = ""; this.EXExTime.Value = ""; this.EXExMode.Value = ""; return null; } } else { this.EXHotelInfo.Value = "0"; this.EXLinkFax.Value = ""; this.EXExTime.Value = ""; this.EXExMode.Value = ""; return null; } }