private void EnterDataBind()
{
int EntertainmentID = int.Parse(Request.QueryString["EntertainmentID"].ToString());
EntertainmentBLL _EntertainmentBLL = new EntertainmentBLL();
DataTable EnterDT = _EntertainmentBLL.GetEnterInfoByID(EntertainmentID);
this.TxtLoc.Text = EnterDT.Rows[0]["Local"].ToString();
this.txtPhoneNum.Text = EnterDT.Rows[0]["PhoneNum"].ToString();
this.TxtIntroduce.Text = EnterDT.Rows[0]["Introduction"].ToString();
this.TxtOpenTime.Text = EnterDT.Rows[0]["OpenTime"].ToString();
this.txtEntertainName.Text = EnterDT.Rows[0]["EntertainmentName"].ToString();
this.txtEntertainName.Enabled = false;
if (float.Parse(EnterDT.Rows[0]["SLongitude"].ToString()) != 0.0f)
{
this.txtEntertainLgt.Text = EnterDT.Rows[0]["SLongitude"].ToString();
}
else
{
this.txtEntertainLgt.Text = "";
}
if (float.Parse(EnterDT.Rows[0]["Slatitude"].ToString()) != 0.0f)
{
this.txtEntertainLgt.Text = EnterDT.Rows[0]["Slatitude"].ToString();
}
else
{
this.txtEntertainLgt.Text = "";
}
}
protected void SaveBooks()
{
if (!txtBooks.Text.Equals(""))
{
EntertainmentBO objEntertainment = new EntertainmentBO();
objEntertainment.Name = txtBooks.Text;
objEntertainment.UserId = Userid;
if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtBooks.Text + Global.PICTURE_EXTENSION_JPG)))
{
objEntertainment.Image = txtBooks.Text + ".jpg";
}
else if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtBooks.Text + ".png")))
{
objEntertainment.Image = txtBooks.Text + ".png";
}
else
{
objEntertainment.Image = "DefaultBooks.png";
}
objEntertainment.Type = Global.BOOKS;
EntertainmentBLL.insertEntertainment(objEntertainment);
txtBooks.Text = "";
LoadDataListBooks();
}
}
protected void SaveGame()
{
if (!txtGame.Text.Equals(""))
{
EntertainmentBO objEntertainment = new EntertainmentBO();
objEntertainment.Name = txtGame.Text;
objEntertainment.UserId = Userid;
if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtGame.Text + ".jpg")))
{
objEntertainment.Image = txtGame.Text + ".jpg";
}
else if (System.IO.File.Exists(Server.MapPath("../../Resources/images/ProfileIcons/" + txtGame.Text + ".png")))
{
objEntertainment.Image = txtGame.Text + ".png";
}
else
{
objEntertainment.Image = "DefaultGame.png";
}
objEntertainment.Type = Global.GAME;
EntertainmentBLL.insertEntertainment(objEntertainment);
txtGame.Text = "";
LoadDataListGame();
}
}
protected void DropDownEntertainment_SelectedIndexChanged(object sender, EventArgs e)
{
EntertainmentID = int.Parse(this.DropDownEntertainment.SelectedValue);
EntertainmentBLL _EntertainmentBLL = new EntertainmentBLL();
CityID = _EntertainmentBLL.GetCityIDByEnterID(EntertainmentID);
this.DrpDownCity.SelectedValue = CityID.ToString();
}
protected void LoadDataListAthelete()
{
DListAthelete.DataSource = EntertainmentBLL.getEntertainmentTop(Global.ATHELETE, Userid);
DListAthelete.DataBind();
if (DListAthelete.Items.Count <= 0)
{
lblAthelete.Visible = false;
DListAthelete.Visible = false;
}
}
protected void LoadDataListTeam()
{
DListTeam.DataSource = EntertainmentBLL.getEntertainmentTop(Global.TEAM, Userid);
DListTeam.DataBind();
if (DListTeam.Items.Count <= 0)
{
lblTeam.Visible = false;
DListTeam.Visible = false;
}
}
protected void LoadDataListSports()
{
DListSports.DataSource = EntertainmentBLL.getEntertainmentTop(Global.SPORTS, Userid);
DListSports.DataBind();
if (DListSports.Items.Count <= 0)
{
lblSports.Visible = false;
DListSports.Visible = false;
}
}
protected void LoadDataListGame()
{
DListGame.DataSource = EntertainmentBLL.getEntertainmentTop(Global.GAME, Userid);
DListGame.DataBind();
if (DListGame.Items.Count <= 0)
{
lblGame.Visible = false;
DListGame.Visible = false;
}
}
protected void LoadDataListTelevision()
{
DListTelevision.DataSource = EntertainmentBLL.getEntertainmentTop(Global.TELEVISION, Userid);
DListTelevision.DataBind();
if (DListTelevision.Items.Count <= 0)
{
lblTelevision.Visible = false;
DListTelevision.Visible = false;
}
}
protected void LoadDataListMusic()
{
DListMusic.DataSource = EntertainmentBLL.getEntertainmentTop(Global.MUSIC, Userid);
DListMusic.DataBind();
if (DListMusic.Items.Count <= 0)
{
lblMusic.Visible = false;
DListMusic.Visible = false;
}
}
private void EntertainmentBind(int CityID)
{
EntertainmentBLL _EntertainmentBLL = new EntertainmentBLL();
DataTable EnterDT = _EntertainmentBLL.GetCityEntertainment(CityID);
this.DropDownEntertainment.Items.Clear();
this.DropDownEntertainment.DataSource = EnterDT;
this.DropDownEntertainment.DataTextField = "EntertainmentName";
this.DropDownEntertainment.DataValueField = "EntertainmentID";
this.DropDownEntertainment.DataBind();
}
protected void btEdit_Click(object sender, EventArgs e)
{
EntertainmentBLL _EntertainmentBLL = new EntertainmentBLL();
EntertainmentInfo _EntertainmentInfo = new EntertainmentInfo();
_EntertainmentInfo.Local = this.TxtLoc.Text.Trim();
_EntertainmentInfo.PhoneNum = this.txtPhoneNum.Text.Trim();
_EntertainmentInfo.Introduction = this.TxtIntroduce.Text.Trim();
_EntertainmentInfo.OpenTime = this.TxtOpenTime.Text.Trim();
_EntertainmentInfo.CityID = int.Parse(Request.QueryString["CityID"].ToString());
_EntertainmentInfo.EntertainmentName = this.txtEntertainName.Text.Trim();
if (this.txtEntertainLgt.Text.Trim() != "")
{
_EntertainmentInfo.SLongitude = float.Parse(txtEntertainLgt.Text.Trim().ToString());
}
else
{
_EntertainmentInfo.SLongitude = 0.0f;
}
if (this.txtEntertainLat.Text.Trim() != "")
{
_EntertainmentInfo.Slatitude = float.Parse(txtEntertainLat.Text.Trim().ToString());
}
else
{
_EntertainmentInfo.Slatitude = 0.0f;
}
int CityID = int.Parse(Request.QueryString["CityID"].ToString());
int EntertainmentID = int.Parse(Request.QueryString["EntertainmentID"].ToString());
int PageStart = int.Parse(Request.QueryString["PageStart"].ToString());
if (_EntertainmentBLL.UpdEnterInfo(EntertainmentID, _EntertainmentInfo))
{
Response.Write("<script language='javascript'>");
Response.Write("alert('添加成功');");
Response.Write("document.location.href='EntertainmentList.aspx?&CityID=" + CityID.ToString() + "&PageStart=" + PageStart.ToString() + "';");
Response.Write("</script>");
}
}
protected void LoadDataListGame()
{
DListGame.DataSource = EntertainmentBLL.getEntertainmentTop(Global.GAME, Userid);
DListGame.DataBind();
}
protected void LoadDataListMovie()
{
DListMovie.DataSource = EntertainmentBLL.getEntertainmentTop(Global.MOVIE, Userid);
DListMovie.DataBind();
}
protected void LoadDataListTelevision()
{
DListTelevision.DataSource = EntertainmentBLL.getEntertainmentTop(Global.TELEVISION, Userid);
DListTelevision.DataBind();
}
protected void LoadDataListMusic()
{
DListMusic.DataSource = EntertainmentBLL.getEntertainmentTop(Global.MUSIC, Userid);
DListMusic.DataBind();
}
protected void LoadDataListBooks()
{
DListBooks.DataSource = EntertainmentBLL.getEntertainmentTop(Global.BOOKS, Userid);
DListBooks.DataBind();
}
protected void DListGame_SelectedIndexChanged(object sender, EventArgs e)
{
EntertainmentBLL.deleteEntertainment(DListGame.DataKeys[DListGame.SelectedIndex].ToString());
LoadDataListGame();
}
protected void LoadDataListAthelete()
{
DListAthelete.DataSource = EntertainmentBLL.getEntertainmentTop(Global.ATHELETE, Userid);
DListAthelete.DataBind();
}
protected void LoadDataListTeam()
{
DListTeam.DataSource = EntertainmentBLL.getEntertainmentTop(Global.TEAM, Userid);
DListTeam.DataBind();
}
//根据娱乐场所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>");
}
}
protected void LoadDataListSports()
{
DListSports.DataSource = EntertainmentBLL.getEntertainmentTop(Global.SPORTS, Userid);
DListSports.DataBind();
}
