1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class index : System.Web.UI.Page
14...{
15    private const string sql = "insert into messages values(@UserName,@Title,@Content,getdate())";
16    private const string userName = "@UserName";
17    private const string title = "@Title";
18    private const string content = "@Content";
19    protected void Page_Load(object sender, EventArgs e)
20    ...{
21        SqlDataReader reader = SqlHelp.getSqlDataReader(SqlHelp.con, CommandType.Text, "select count(*) from login", null);
22        if (reader.Read())
23        ...{
24            this.lblCount.Text = reader[0].ToString();
25        }
26        reader.Close();
27        this.txtUserName.Text = this.User.Identity.Name;
28    }
29    private SqlParameter[] getparam()
30    ...{
31        SqlParameter[] param = SqlHelp.GetCachedParameters(sql);
32        if (param == null)
33        ...{
34            param = new SqlParameter[] ...{ new SqlParameter(userName,SqlDbType.VarChar,20),new SqlParameter(title,SqlDbType.VarChar,50),new SqlParameter(content,SqlDbType.VarChar,8000)};
35            SqlHelp.CacheParameters(sql, param);
36        }
37        return param;
38    }
39    private bool insertleave(string username,string title,string content)
40    ...{
41        SqlParameter[] param = getparam();
42        param[0].Value = username;
43        param[1].Value = title;
44        param[2].Value = content;
45        bool flag = Convert.ToBoolean(SqlHelp.getExecuteNonQuery(SqlHelp.con,CommandType.Text,sql,param));
46        return flag;
47        
48    }
49    protected void btnLeave_Click(object sender, EventArgs e)
50    ...{
51        if (Page.IsValid)
52        ...{
53            string userName = this.txtUserName.Text.Trim();
54            string title = this.txtTopic.Text.Trim();
55            string content = this.txtLeave.Text.Trim();
56            if (insertleave(userName,title,content))
57            ...{
58
59                Response.Redirect("Messages.aspx");
60            }
61        }
62    }
63}
64