#region 添加评论 /// <summary> /// 添加评论 /// </summary> /// <param name="c"></param> /// <returns></returns> public bool Insert(CommentModel c) { bool flag = false; string sql = "insert into comment(content,userip,newsid) values(@content,@userip,@newsid)"; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@content",c.Content), new SqlParameter("@userip",c.Userip), new SqlParameter("@newsid",c.Newsid) }; int ins = sqlhelper.ExecuteNonQuery(sql,para,CommandType.Text); if (ins>0) { flag = true; } return flag; } #endregion
<asp:TextBox ID="txtCode" runat="server" CssClass="txtcode" ValidationGroup="ccc" ></asp:TextBox> <asp:RequiredFieldValidator ValidationGroup="ccc" ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtCode" ErrorMessage="请输入验证码" Text="*"></asp:RequiredFieldValidator> <asp:Button ID="Btnsub" runat="server" Text="确定" Width="59px" οnclick="Btnsub_Click" ValidationGroup="ccc" /> <asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="true" ShowSummary="false" ValidationGroup="ccc" />
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string newsid = Request.QueryString["newsid"]; NewsBLL nb = new NewsBLL(); newsModel nm = new NewsBLL().SelectNew(newsid); Lbltitle.Text = nm.Title; Lblcontent.Text = nm.Content; Lblcreatetime.Text = nm.Createtime; //绑定评论 DataTable dt=new CommentBLL().SelectComment(newsid); if (dt.Rows.Count ==0) { //无新闻就显示 empdata.Visible = true; } else { //有新闻就不显示 empdata.Visible = false; repComment.DataSource = dt; repComment.DataBind(); } } }
//添加按钮; protected void Btnsub_Click(object sender, EventArgs e) { //判断验证码是否正确; string txtcode = txtCode.Text.Trim().ToString().ToUpper(); //转成大写; string right = Session["Code"].ToString(); if (txtcode != right) { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('验证码输入错误！');</script>"); return; } //添加进数据库 string content = txtcomment.Text.Trim(); string userip = Request.ServerVariables["REMOTE_ADDR"]; //获取客户端的ip; string newsid = Request.QueryString["newsid"]; CommentModel cm = new CommentModel(content,userip,newsid); bool b = new CommentBLL().Insert(cm); if (b) { txtCode.Text = ""; txtcomment.Text = ""; //隐藏"该新闻暂时无评论!" empdata.Visible = false; //绑定评论 repComment.DataSource = new CommentBLL().SelectComment(newsid); repComment.DataBind(); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('评论添加失败！');</script>");
} }
