//根据商场图片ID删除商场图片 protected void deleteThis() { int CityID = int.Parse(Request.QueryString["CityID"].ToString()); int MallID = int.Parse(Request.QueryString["MallID"].ToString()); try { Array delWitch = rqid.Split('|'); bool isTrue = false; for (int i = 0; i < delWitch.Length - 1; i++) { int delid = Convert.ToInt32(delWitch.GetValue(i)); PicInfoBLL _PicInfoBLL = new PicInfoBLL(); if (_PicInfoBLL.DelMallPic(delid) && _PicInfoBLL.DelPicByID(delid)) { isTrue = true; } else { isTrue = false; } if (isTrue == false) { break; } } if (!(isTrue == false)) { Response.Write("<script language='javascript'>"); Response.Write("alert('删除成功!');"); Response.Write("document.location.href='MallPicList.aspx?CityID=" + CityID.ToString() + "&MallID=" + MallID.ToString() + "';"); Response.Write("</script>"); } else { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='MallPicList.aspx?CityID=" + CityID.ToString() + "&MallID=" + MallID.ToString() + "';"); Response.Write("</script>"); } } catch { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='MallPicList.aspx?CityID=" + CityID.ToString() + "&MallID=" + MallID.ToString() + "';"); Response.Write("</script>"); } }
//根据市ID删除市信息 protected void deleteThis() { try { Array delWitch = rqid.Split('|'); bool isTrue = false; for (int i = 0; i < delWitch.Length - 1; i++) { int delid = Convert.ToInt32(delWitch.GetValue(i)); PicInfoBLL _PicInfoBLL = new PicInfoBLL(); if (_PicInfoBLL.DelCityPicByID(delid) && _PicInfoBLL.DelPicByID(delid)) { isTrue = true; } else { isTrue = false; } if (isTrue == false) { break; } } if (!(isTrue == false)) { Response.Write("<script language='javascript'>"); Response.Write("alert('删除成功!');"); Response.Write("document.location.href='CityPicList.aspx';"); Response.Write("</script>"); } else { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='CityPicList.aspx';"); Response.Write("</script>"); } } catch { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='CityPicList.aspx';"); Response.Write("</script>"); } }
//根据娱乐场所ID删除娱乐场所信息 protected void deleteThis() { int CityID = int.Parse(Request.QueryString["CityID"].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)); EntertainmentBLL _EntertainmentBLL = new EntertainmentBLL(); PicInfoBLL _PicInfoBLL = new PicInfoBLL(); if (_EntertainmentBLL.DelEnterInfo(delid)) { isTrue = true; DataTable EnterPicDT = _PicInfoBLL.GetEnterPicByEnterID(delid); if (EnterPicDT.Rows.Count > 0) { for (int j = 0; j < EnterPicDT.Rows.Count; j++) { int tempPicID = int.Parse(EnterPicDT.Rows[j]["PicID"].ToString()); if (_PicInfoBLL.DelEntetPicByID(tempPicID) && _PicInfoBLL.DelPicByID(tempPicID)) { isPicTrue = true; } else { isPicTrue = false; break; } } } else { isPicTrue = true; } } else { isTrue = false; } if (isTrue == false || isPicTrue == false) { break; } } if (!(isTrue == false || isPicTrue == false)) { Response.Write("<script language='javascript'>"); Response.Write("alert('删除成功!');"); Response.Write("document.location.href='EntertainmentList.aspx?CityID=" + CityID.ToString() + "';"); Response.Write("</script>"); } else { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='EntertainmentList.aspx?CityID" + CityID.ToString() + "';"); Response.Write("</script>"); } } catch { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='EntertainmentList.aspx?CityID" + CityID.ToString() + "';"); Response.Write("</script>"); } }
//根据餐馆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 isResPicTrue = false; bool IsFoodTrue = false; bool IsFoodPicTrue = false; for (int i = 0; i < delWitch.Length - 1; i++) { int delid = Convert.ToInt32(delWitch.GetValue(i)); RestaurantInfoBLL _ResBLL = new RestaurantInfoBLL(); if (_ResBLL.DelResInfo(delid)) { isTrue = true; } else { isTrue = false; } if (isTrue == false) { break; } //删除菜单 DataTable FoodDT = _ResBLL.GetResFood(delid); if (FoodDT.Rows.Count > 0) { for (int j = 0; j < FoodDT.Rows.Count; j++) { int FoodID = int.Parse(FoodDT.Rows[j]["FoodID"].ToString()); if (_ResBLL.DelFoodByFoodID(FoodID)) { IsFoodTrue = true; } else { IsFoodTrue = false; break; } } } else { IsFoodTrue = true; } if (IsFoodTrue == false) { break; } PicInfoBLL _PicInfoBLL = new PicInfoBLL(); //删除菜图片(考虑为0的情况) if (FoodDT.Rows.Count > 0) { //删除每个菜的图片 for (int k = 0; k < FoodDT.Rows.Count; k++) { int FoodTempID = int.Parse(FoodDT.Rows[k]["FoodID"].ToString()); DataTable FoodPicDT = _PicInfoBLL.GetFoodPicByFID(FoodTempID); if (FoodPicDT.Rows.Count > 0) { for (int l = 0; l < FoodPicDT.Rows.Count; l++) { int TempPicID = int.Parse(FoodPicDT.Rows[l]["PicID"].ToString()); if (_PicInfoBLL.DelFoodPicByPicID(TempPicID) && _PicInfoBLL.DelPicByID(TempPicID)) { IsFoodPicTrue = true; } else { IsFoodPicTrue = false; break; } } } else { IsFoodPicTrue = true; } if (IsFoodPicTrue == false) { break; } } } else { IsFoodPicTrue = true; } if (IsFoodPicTrue == false) { break; } //删除餐馆图片(考虑为0的情况) DataTable ResPicDT = _PicInfoBLL.GetResPicByID(delid); if (ResPicDT.Rows.Count > 0) { for (int m = 0; m < ResPicDT.Rows.Count; m++) { int TempResPic = int.Parse(ResPicDT.Rows[m]["PicID"].ToString()); if (_PicInfoBLL.DelResPicByPicID(TempResPic) && _PicInfoBLL.DelPicByID(TempResPic)) { isResPicTrue = true; } else { isResPicTrue = false; break; } } } else { isResPicTrue = true; } if (isResPicTrue == false) { break; } } if (!(isTrue == false || IsFoodTrue == false || IsFoodPicTrue == false || isResPicTrue == false)) { Response.Write("<script language='javascript'>"); Response.Write("alert('删除成功!');"); Response.Write("document.location.href='ResInfoList.aspx?CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } else { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='ResInfoList.aspx?CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } } catch { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='ResInfoList.aspx?CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } }
//根据市ID删除市信息 protected void deleteThis() { 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)); SceneryInfoBLL _SceneryInfoBLL = new SceneryInfoBLL(); PicInfoBLL _PicInfoBLL = new PicInfoBLL(); STypeBLL _STypeBLL = new STypeBLL(); DataTable ScePicDT; if (_SceneryInfoBLL.DelScenery(delid)) { if (_STypeBLL.GetSceTypeCount(delid) > 0) { if (_STypeBLL.DelSType(delid)) { isTrue = true; } } else { isTrue = true; } //加入删除图片信息 ScePicDT = _PicInfoBLL.GetPicBySceID(delid); if (ScePicDT.Rows.Count > 0) { for (int j = 0; j < ScePicDT.Rows.Count; j++) { int PicTempID = int.Parse(ScePicDT.Rows[j]["PicID"].ToString()); if (_PicInfoBLL.DelPicByID(PicTempID) && _PicInfoBLL.DelScePicByID(PicTempID)) { isPicTrue = true; } else { isPicTrue = false; break; } } } else { isPicTrue = true; } } else { isTrue = false; } if (isTrue == false || isPicTrue == false) { break; } } if (!(isTrue == false || isPicTrue == false)) { Response.Write("<script language='javascript'>"); Response.Write("alert('删除成功!');"); Response.Write("document.location.href='SceneryInfoList.aspx';"); Response.Write("</script>"); } else { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='SceneryInfoList.aspx';"); Response.Write("</script>"); } } catch { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='SceneryInfoList.aspx';"); Response.Write("</script>"); } }
protected void btAdd_Click(object sender, EventArgs e) { int MallID = int.Parse(Request.QueryString["MallID"].ToString()); int CityID = int.Parse(Request.QueryString["CityID"].ToString()); try { string imgUrl = ""; if (this.txtImgUrl.FileName.Trim() != "") { _UpLoadFile.FilePath = @"..\..\..\UpLoadPics\"; _UpLoadFile.HtmlKey = "txtImgUrl"; HttpFileCollection updFiles = HttpContext.Current.Request.Files; string PictureName = this.txtPicName.Text.ToString(); _UpLoadFile.ExecUploadFile(updFiles);//执行上传 ArrayList fileArr = (ArrayList)_UpLoadFile.Result[0]; if (fileArr[0].ToString() == "1") { return; } if (fileArr[0].ToString() == "2") { Response.Write("<script language='javascript'>"); Response.Write("alert('图片重名!');"); Response.Write("</script>"); return; } if (fileArr[0].ToString() == "3") { Response.Write("<script language='javascript'>"); Response.Write("alert('图片格式不正确!');"); Response.Write("</script>"); return; } else { imgUrl = fileArr[0].ToString(); PicInfoBLL _PicInfoBLL = new PicInfoBLL(); //根据市ID向图片表中插入一张图片 PicInfo _PicInfo = new PicInfo(); _PicInfo.PictureName = this.txtPicName.Text.Trim(); _PicInfo.PicPath = imgUrl; _PicInfo.Introduction = ""; _PicInfo.UpLoadTime = DateTime.Now; if (_PicInfoBLL.AddPic(_PicInfo)) { int PicID = _PicInfoBLL.GetPicID(this.txtPicName.Text.Trim(), _PicInfo.UpLoadTime); //根据市ID向市图片表中插入一张图片 if (_PicInfoBLL.AddMallPic(MallID, PicID)) { Response.Write("<script language='javascript'>"); //"CityInfoDel.aspx?CityID=" + delWitch; Response.Write("alert('图片添加成功');"); Response.Write("document.location.href='MallPicList.aspx?MallID=" + MallID.ToString() + "&CityID=" + CityID.ToString() + "'"); Response.Write("</script>"); } } } } } catch (Exception ex) { Response.Write("<script language='javascript'>"); Response.Write("alert('添加失败!');"); Response.Write("document.location.href='EntertainmentList.aspx?MallID=" + MallID.ToString() + "&CityID" + CityID.ToString() + "'"); Response.Write("</script>"); } }
//根据美食ID删除美食信息 protected void deleteThis() { int CityID = int.Parse(Request.QueryString["CityID"].ToString()); int PageStart = int.Parse(Request.QueryString["PageStart"].ToString()); String RestaurantName = Request.QueryString["RestaurantName"].ToString(); int RestaurantID = int.Parse(Request.QueryString["RestaurantID"].ToString()); try { Array delWitch = rqid.Split('|'); bool isPicTrue = false; bool isTrue = false; for (int i = 0; i < delWitch.Length - 1; i++) { int delid = Convert.ToInt32(delWitch.GetValue(i)); RestaurantInfoBLL _ResBLL = new RestaurantInfoBLL(); PicInfoBLL _PicInfoBLL = new PicInfoBLL(); if (_ResBLL.DelFoodByFoodID(delid)) { isTrue = true; } else { isTrue = false; } if (isTrue == false) { break; } //删除美食图片 DataTable FoodDT = _PicInfoBLL.GetFoodPicByFID(delid); if (FoodDT.Rows.Count > 0) { for (int j = 0; j < FoodDT.Rows.Count; j++) { int PicTempID = int.Parse(FoodDT.Rows[j]["PicID"].ToString()); if (_PicInfoBLL.DelFoodPicByPicID(PicTempID) && _PicInfoBLL.DelPicByID(PicTempID)) { isPicTrue = true; } else { isPicTrue = false; break; } } } else { isPicTrue = true; } if (isPicTrue == false) { break; } } if (!(isTrue == false || isPicTrue == false)) { Response.Write("<script language='javascript'>"); Response.Write("alert('删除成功!');"); Response.Write("document.location.href='RestaurantFoodList.aspx?RestaurantID=" + RestaurantID.ToString() + "&RestaurantName=" + RestaurantName + "&CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } else { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='RestaurantFoodList.aspx?RestaurantID=" + RestaurantID.ToString() + "&RestaurantName=" + RestaurantName + "&CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } } catch { Response.Write("<script language='javascript'>"); Response.Write("alert('删除失败!');"); Response.Write("document.location.href='RestaurantFoodList.aspx?RestaurantID=" + RestaurantID.ToString() + "&RestaurantName=" + RestaurantName + "&CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';"); Response.Write("</script>"); } }
//根据酒店子类型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>"); } }