protected void btnPost_Click(object sender, EventArgs e)
{
if (txtComment.Text == "")
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('内容不能为空')", true);
return;
}
else
{
string strConn = WebConfigurationManager.ConnectionStrings["dmtucaoConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(strConn);
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [comment] ([comment],[date],[user],[type],[it]) values(@comment,@date,@user,@type,@it)", con);
cmd.Parameters.AddWithValue("@comment", txtComment.Text);
cmd.Parameters.AddWithValue("@date", DateTime.Now);
if ((bool)Session["pass"])
{
cmd.Parameters.AddWithValue("@user", Session["NickName"].ToString());
}
else
{
cmd.Parameters.AddWithValue("@user", "_guest");
}
cmd.Parameters.AddWithValue("@type", Convert.ToByte(ddlType.SelectedValue));
cmd.Parameters.AddWithValue("@it", Convert.ToInt32(PageIndex.Value));
int count = cmd.ExecuteNonQuery();
if (1 == count)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('评论成功')", true);
CommentTable.DataBind();
SqlCommand read = new SqlCommand("UPDATE [ImageText] SET [danmaku]=@danmaku WHERE [it]=@it", con);
read.Parameters.AddWithValue("@danmaku", CommentTable.Rows.Count.ToString());
read.Parameters.AddWithValue("@it", Context.Request["it"]);
read.ExecuteNonQuery();
}
else
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('评论失败，请重试')", true);
}
cmd = null;
con.Close();
con = null;
return;
}
}
protected void Timer1_Tick(object sender, EventArgs e)
{
CommentTable.DataBind();
}