protected void Page_Load(object sender, EventArgs e)
{
string sql = "select top 1 * from Place where Places='北京'";
PlaceInfoBLL bll = new PlaceInfoBLL();
int id = Convert.ToInt32(bll.GetPlaceID(sql));
//Label1.Text = id.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
PlaceInfoBLL bll = new PlaceInfoBLL();
int id = int.Parse(Context.Request["id"].ToString());
string sql = "select top 6 * from PlaceInfo where PlaceID=" + id;
DataSet ds = bll.getPlaceInfo(sql);
DataList1.DataSource = ds.Tables[0];
DataList1.DataBind();
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
string sql = "select top 1 * from Place where Places='" + DropDownList1.SelectedItem.Text.ToString().Trim() + "'";
PlaceInfoBLL bll = new PlaceInfoBLL();
int id = int.Parse(bll.GetPlaceID(sql).ToString().Trim());
//string title = Context.Request["title"].ToString().Trim();
//string txtintroduction = Context.Request["txtintroduction"].ToString().Trim();
string Introduce = Context.Request["introduce"].ToString().Trim();
string dir = "";
//try
//{
if (Directory.Exists(Server.MapPath("images/place/" + DropDownList1.SelectedItem.Text)) == false)
{
//创建用户的文件夹
Directory.CreateDirectory(Server.MapPath("images/place/" + DropDownList1.SelectedItem.Text));
}
if (FileUpload2.HasFile)
{
dir = Server.MapPath("/images/place/" + DropDownList1.SelectedItem.Text + "/");
if (File.Exists(dir + FileUpload2.FileName))
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('文件已存在!')", true);
return;
}
FileUpload2.SaveAs(dir + FileUpload2.FileName);
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('请选择要上传的文件!')", true);
return;
}
placeInfo p = new placeInfo();
p.PlaceID = id;
p.Image = "/place/" + DropDownList1.SelectedItem.Text + "/" + FileUpload2.FileName;
p.Title = title.Text;
p.Introduction = txtintroduction.Text;
p.Introduce = Introduce;
bll.AddPlaceInfo(p);
Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('数据提交成功!')", true);
//title.Text = "";
//txtintroduction.Text = "";
//Editor.Text = "";
//}
//catch (Exception ee)
//{
// Page.ClientScript.RegisterStartupScript(GetType(), "", "alert('数据提交失败!')", true);
//}
}