#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>");
}
}