protected void btnUpload_Click(object sender, EventArgs e)
{
if (Session["LogonUser"] == null)
{
Response.Write("<script>alert('请先登录');</script>");
//Response.Redirect("Logon.aspx");
}
else
{
int TopicID = int.Parse(Request["TopicID"].ToString());
string strCommentContent = this.txtContent.Text;
string UserName1 = Session["LogonUser"].ToString();//重新获得用户名
string strConn = "server=pc.hstc.cn;database=dhd2015112026;uid=2015112026;pwd=19950522;";
string strSql = "INSERT INTO Comment ( TopicID,TopicName,UserName,CommentContent) VALUES ( N'" + TopicID + "', N'" + TopicName + "',N'" + UserName1 + "',N'" + strCommentContent + "')";
SqlConnection cn = new SqlConnection(strConn);
cn.Open();
SqlCommand cmd = new SqlCommand(strSql, cn);
cmd.ExecuteNonQuery();
Response.Write("<script>alert('评论成功');</script>");
this.txtContent.Text = "";
int TopicID1 = int.Parse(Request["TopicID"].ToString());
CommentDataContext ctx = new CommentDataContext();
var query = from b in ctx.Comment
where b.TopicID == TopicID1
select new { b.UserName, b.CommentContent };
this.gdvOCC.DataSource = query;
this.gdvOCC.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["TopicID"] == null)
{
Response.Write("<script>alert('不能从该页面进入，正在返回首页');</script>");
Response.Redirect("index.aspx");
return;
}
else
{
int TopicID = int.Parse(Request["TopicID"].ToString());
string strConn = "server=pc.hstc.cn;database=dhd2015112026;uid=2015112026;pwd=19950522;";
string strSqlTopicContent = "SELECT TopicContent,TopicName,UserName FROM TopicInfo WHERE (TopicID= N'" + TopicID + "')";
SqlConnection cn = new SqlConnection(strConn);
cn.Open();
SqlCommand cmd = new SqlCommand(strSqlTopicContent, cn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
TopicContent = dtr["TopicContent"].ToString();
TopicName = dtr["TopicName"].ToString();
UserName = dtr["UserName"].ToString();
dtr.Close();
}
int TopicID1 = int.Parse(Request["TopicID"].ToString());
CommentDataContext ctx = new CommentDataContext();
var query = from b in ctx.Comment
where b.TopicID == TopicID1
select new { b.UserName, b.CommentContent };
this.gdvOCC.DataSource = query;
this.gdvOCC.DataBind();
}