private void HotelInfoBind() { int HotelID = int.Parse(Request.QueryString["HotelID"].ToString()); HotelInfoBLL _HotelInfoBLL = new HotelInfoBLL(); DataTable HotelDT = _HotelInfoBLL.GetHotelInfoByHtlID(HotelID); this.txtHotelName.Text = HotelDT.Rows[0]["HotelName"].ToString(); this.txtHotelName.Enabled = false; this.txtHotelStar.Text = HotelDT.Rows[0]["Star"].ToString(); this.TxtHotelLoc.Text = HotelDT.Rows[0]["Locate"].ToString(); this.TxtHotelNum.Text = HotelDT.Rows[0]["PhoneNum"].ToString(); this.TxtHtlService.Text = HotelDT.Rows[0]["HotelService"].ToString(); this.TxtHotelIntroduce.Text = HotelDT.Rows[0]["HotelIntroduction"].ToString(); this.TxtResScrvice.Text = HotelDT.Rows[0]["RestaurantDevice"].ToString(); this.txtIdrService.Text = HotelDT.Rows[0]["IndoorService"].ToString(); if (float.Parse(HotelDT.Rows[0]["SLongitude"].ToString().Substring(0, 6)) != 0.0f) { this.txtHotelLgt.Text = HotelDT.Rows[0]["SLongitude"].ToString(); } if (float.Parse(HotelDT.Rows[0]["Slatitude"].ToString().Substring(0, 6)) != 0.0f) { this.txtHotelLgt.Text = HotelDT.Rows[0]["SLongitude"].ToString(); } }
private void HtlBind(int CityID) { //绑定酒店 HotelInfoBLL _HotelInfoBLL = new HotelInfoBLL(); DataTable HtlDT = _HotelInfoBLL.GetHtlInfoByCtyID(CityID); this.DropDownHotel.Items.Clear(); this.DropDownHotel.DataSource = HtlDT; this.DropDownHotel.DataTextField = "HotelName"; this.DropDownHotel.DataValueField = "HotelID"; this.DropDownHotel.DataBind(); }
protected void btEdit_Click(object sender, EventArgs e) { HotelInfoBLL _HotelInfoBLL = new HotelInfoBLL(); HotelInfo _HotelInfo = new HotelInfo(); _HotelInfo.CityID = int.Parse(Request.QueryString["CityID"].ToString()); _HotelInfo.HotelName = txtHotelName.Text.Trim(); _HotelInfo.Local = TxtHotelLoc.Text.Trim(); _HotelInfo.PhoneNum = TxtHotelNum.Text.Trim(); _HotelInfo.HotelService = TxtHtlService.Text.Trim(); _HotelInfo.HotelIntroduction = TxtHotelIntroduce.Text.Trim(); _HotelInfo.RestaurantDevice = TxtResScrvice.Text.Trim(); _HotelInfo.IndoorService = txtIdrService.Text.Trim(); if (txtHotelLgt.Text.Trim() != "") { _HotelInfo.SLongitude = float.Parse(txtHotelLgt.Text.Trim().ToString()); } else { _HotelInfo.SLongitude = 0.0f; } if (txtHotelLat.Text.Trim() != "") { _HotelInfo.Slatitude = float.Parse(txtHotelLat.Text.Trim().ToString()); } else { _HotelInfo.Slatitude = 0.0f; } if (txtHotelStar.Text != "") { _HotelInfo.Star = int.Parse(txtHotelStar.Text.Trim()); } else { _HotelInfo.Star = 0; } int PageStart = int.Parse(Request.QueryString["PageStart"].ToString()); int CityID = int.Parse(Request.QueryString["CityID"].ToString()); if (_HotelInfoBLL.UpdHotelInfo(CityID, _HotelInfo)) { Response.Write("<script language='javascript'>"); Response.Write("alert('更改成功');"); Response.Write("document.location.href='HotelInfoList.aspx?PageStart=" + PageStart.ToString() + "&CityID=" + CityID.ToString() + "';"); Response.Write("</script>"); } }
/// <summary> /// 更新酒店看了又看 /// </summary> public bool UpdHotelSeeAndSee() { List <SeeCount> list = new List <SeeCount>(); HotelInfoBLL _HotelInfoBLL = new HotelInfoBLL(); ClickLogBLL _ClickLogBLL = new ClickLogBLL(); DataTable HotelDT = _HotelInfoBLL.GetHtlInfoByCtyID(1); for (int k = 0; k < HotelDT.Rows.Count; k++) { int CurrentHtlID = int.Parse(HotelDT.Rows[k]["HotelID"].ToString()); list.Clear(); //1.查询出所有酒店信息 并加入链表 for (int i = 0; i < HotelDT.Rows.Count; i++) { SeeCount _SeeCount = new SeeCount(); _SeeCount.KeyName = HotelDT.Rows[i]["HotelName"].ToString(); _SeeCount.KeyID = int.Parse(HotelDT.Rows[i]["HotelID"].ToString()); list.Add(_SeeCount); } //2.查询出看了当前酒店用户IP DataTable ViewerIPDT = _ClickLogBLL.GetSeeHotelIDPeople(CurrentHtlID); List <String> IPList = new List <String>(); for (int j = 0; j < ViewerIPDT.Rows.Count; j++) { if (!IPList.Contains(ViewerIPDT.Rows[j]["IP"].ToString())) { IPList.Add(ViewerIPDT.Rows[j]["IP"].ToString()); } } //3.查询出当前IP 看过的酒店 并统计次数 for (int l = 0; l < IPList.Count; l++) { DataTable CurrentHtlDT = _ClickLogBLL.GetAllOneSee(IPList[l], "酒店"); //将景点合并 List <int> HtlList = new List <int>(); for (int m = 0; m < CurrentHtlDT.Rows.Count; m++) { if (!HtlList.Contains(int.Parse(CurrentHtlDT.Rows[m]["ContentFlag"].ToString()))) { HtlList.Add(int.Parse(CurrentHtlDT.Rows[m]["ContentFlag"].ToString())); } } for (int p = 0; p < HtlList.Count; p++) { for (int n = 0; n < list.Count; n++) { if (list[n].KeyID == HtlList[p]) { list[n].Count++; } } } } //4.先删除当前景点ID再根据次数排序 for (int a = 0; a < list.Count; a++) { if (list[a].KeyID == CurrentHtlID) { list.RemoveAt(a); } } //先根据景点ID删除该景点的看了又看 然后按次序执行插入 _LookAnotherBLL.DelByIDType(CurrentHtlID, "酒店"); ; for (int v = 0; v < 1; v++) { LookAnotherInfo _LookAnotherInfo = new LookAnotherInfo(); _LookAnotherInfo.KeyID = CurrentHtlID; _LookAnotherInfo.AnotherLookID = list[v].KeyID; _LookAnotherInfo.GoalType = "酒店"; _LookAnotherBLL.AddLookAnother(_LookAnotherInfo); } } return(true); }
//根据酒店子类型ID删除子类型 protected void deleteThis() { int CityID = int.Parse(Request.QueryString["CityID"].ToString()); int PageStart = int.Parse(Request.QueryString["PageStart"].ToString()); try { Array delWitch = rqid.Split('|'); bool isTrue = false; bool isPicTrue = false; for (int i = 0; i < delWitch.Length - 1; i++) { int delid = Convert.ToInt32(delWitch.GetValue(i)); PicInfoBLL _PicInfoBLL = new PicInfoBLL(); HotelInfoBLL _HotelInfoBLL = new HotelInfoBLL(); HtlTypeBLL _HtlTypeBLL = new HtlTypeBLL(); HtlTypeDetailBLL _HtlTypeDetailBLL = new HtlTypeDetailBLL(); // DataTable HtlTypeDT = _HtlTypeBLL.GetHtlTypeByID(delid); DataTable HtlPicDT = _PicInfoBLL.GetPicByHtlID(delid); if (HtlTypeDT.Rows.Count == 0) { if (_HotelInfoBLL.DelHotelByHotelID(delid)) { isTrue = true; } else { isTrue = false; } } else { //删除子类型 for (int j = 0; j < HtlTypeDT.Rows.Count; j++) { int HtlType = int.Parse(HtlTypeDT.Rows[j]["ID"].ToString());//房型类型 int DetailTypeCount = _HtlTypeDetailBLL.GetHtlDetailCountByID(HtlType); if (DetailTypeCount > 0) { if (_HtlTypeDetailBLL.DelHotelTypeDetailByTypeID(HtlType)) { isTrue = true; } else { isTrue = false; break; } } else { isTrue = true; } } if (isTrue == false) { break; } //删除房型信息,酒店信息 if (_HtlTypeBLL.DelHtlTypeByHtlID(delid) && _HotelInfoBLL.DelHotelByHotelID(delid)) { isTrue = true; } else { isTrue = false; } } //删除图片信息 HtlPicDT = _PicInfoBLL.GetPicByHtlID(delid); for (int k = 0; k < HtlPicDT.Rows.Count; k++) { int PicID = int.Parse(HtlPicDT.Rows[k]["PicID"].ToString()); if (_PicInfoBLL.DelPicByID(PicID) && _PicInfoBLL.DelHtlPicByID(PicID)) { isPicTrue = true; } else { isPicTrue = false; break; } } if (isTrue == false || isPicTrue == false) { break; } } if (!(isTrue == false || isPicTrue == false)) { Response.Write("<script language='javascript'>"); Response.Write("alert('删除成功!');"); Response.Write("document.location.href='HotelInfoList.aspx?CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } else { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='HotelInfoList.aspx?CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } } catch { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='HotelInfoList.aspx?CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } }