protected void Button1_Click(object sender, EventArgs e)
{
if (Session["user_name"] != null)
{
try
{
discussion dis = new discussion();
dis.user_id = int.Parse(Session["user_id"].ToString());
dis.dis_cont = myEditor.InnerText;
dis.dis_title = title.Text.Trim();
dis.pub_time = DateTime.Now;
int result = DiscussionManager.InsertDiscussion(dis);
if (result >= 1)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('讨论贴发表成功！');</script>");
}
}
catch
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('发布失败！请仔细检查');</script>");
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('请登录之后再发帖！'); </script>");
Response.Redirect("login1.aspx");
}
}
public int InsertDiscussion(discussion discussion)
{
string sql = "insert into discussion(user_id,dis_cont,dis_title,pub_time) values(@user_id,@dis_cont,@dis_title,@pub_time)";
SqlParameter[] sp =
{
new SqlParameter("@user_id", discussion.user_id),
new SqlParameter("@dis_cont", discussion.dis_cont),
new SqlParameter("@dis_title", discussion.dis_title),
new SqlParameter("@pub_time", discussion.pub_time),
};
return(DBHelper.GetExcuteNonQuery(sql, sp));
}
public void show(TextAsset data)
{
currentStatus = discussionStatus.running;
conversation = JsonUtility.FromJson <discussion>(data.text);
conversation.setIndex(0);
for (int i = 0; i < transform.childCount; i++)
{
transform.GetChild(i).gameObject.SetActive(true);
}
currentStatus = discussionStatus.running;
line currentLine = conversation.stepDiscussion();
displayLine(currentLine);
}
public static int InsertDiscussion(discussion discussion)
{
return(idiscussion.InsertDiscussion(discussion));
}
