protected void Page_Load(object sender, EventArgs e) { string str = ""; if (Convert.ToString(Session["u_emaile"]) == str) { (Master.FindControl("lab_denglu") as Button).Text = "登录"; (Master.FindControl("lab_loginoff") as Button).Visible = false; } else { //把用户登录后session 交给登录按钮 (Master.FindControl("lab_denglu") as Button).Text = Convert.ToString(Session["u_emaile"]); (Master.FindControl("lab_loginoff") as Button).Visible = true; (Master.FindControl("lab_loginoff") as Button).Text = "注销"; string u_id = Request.QueryString["u_id"]; //从评论表中获取u_id Session["u_id"] = u_id; //将u_id保存在session中 //通过u_id获取游记作者 Travel.Model.Tab_discuss discuss = new Travel.Model.Tab_discuss(); discuss.U_emaileA = Travel.BLL.DiscussBusiness.GetDiscussById(Convert.ToInt32(Session["u_id"])).U_emaileA; //将游记作者保存在seeion中 Session["u_emaile"] = discuss.U_emaileA; //通过作者获取游记标题 Travel.Model.Tab_article article = new Travel.Model.Tab_article(); article.T_title = Travel.BLL.ArticleBusiness.GetArticleByEmaile(Convert.ToString(Session["u_emaile"])).T_title; //将游记标题保存在session中 Session["t_title"] = article.T_title; } }
/// <summary> /// 我的评论删除 /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void DataList4_ItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName == "delete") { string u_id = e.CommandArgument.ToString(); Session["u_id"] = u_id; Travel.Model.Tab_user tab_user = new Travel.Model.Tab_user(); Travel.Model.Tab_discuss tab_discuss = new Travel.Model.Tab_discuss(); //通过Session获取用户emaile tab_user.U_emaile = Travel.BLL.UserBusiness.GetUserByEmaile(Session["u_emaile"].ToString()).U_emaile; //通过Session获取用户的 u_discuss //tab_discuss.U_discuss = Travel.BLL.DiscussBusiness.GetDiscussByEmaileB(Session["u_emaile"].ToString()).U_discuss; tab_discuss.U_discuss = Travel.BLL.DiscussBusiness.GetDiscussById(Convert.ToInt32(Session["u_id"])).U_discuss; //调用数据库里的删除评论的存储过程 if (Travel.BLL.DiscussBusiness.DeleteDiscuss(tab_user.U_emaile, tab_discuss.U_discuss)) { Page.ClientScript.RegisterStartupScript(this.GetType(), "info", "<script>alert('删除评论成功!')</script>"); Response.AddHeader("Refresh", "0"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "info", "<script>alert('删除评论失败!')</script>"); } this.MultiView1.ActiveViewIndex = 3; } }
/// <summary> /// 创建评论 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_sure_Click(object sender, EventArgs e) { string discuss = neirong.Text.Trim();//获取评论的内容 Travel.Model.Tab_article tab_article = new Travel.Model.Tab_article(); Travel.Model.Tab_discuss tab_discuss = new Travel.Model.Tab_discuss(); tab_discuss.U_discuss = discuss; tab_discuss.U_emaileA = Travel.BLL.ArticleBusiness.GetArctileById(Convert.ToInt32(Session["u_id"])).U_emaile; tab_discuss.U_emaileB = Convert.ToString(Session["u_emaile"]); tab_discuss.UploadTime = DateTime.Now;//获取当前时间 if (string.IsNullOrEmpty(tab_discuss.U_emaileB)) { Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('请先登录!')</script>"); //跳转到指定界面 Response.Redirect("Login.aspx"); } else { if (string.IsNullOrEmpty(discuss)) { Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('请先填写完整数据!')</script>"); } else { if (Travel.BLL.DiscussBusiness.AddDiscuss(tab_discuss)) { Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('评论成功!')</script>"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "info", "<script>alert('请重新尝试!')</script>"); } } } }