guestbookedit.aspx.cs

学生寝室管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class guestbookedit : System.Web.UI.Page
{
    SqlCommand cmd, cmd2;
    SqlConnection cn;
    SqlDataAdapter da1,da;
    DataSet ds1 = new DataSet();
    DataSet ds= new DataSet();
    DataTable mytable1 = new DataTable();
    DataTable mytable = new DataTable();
    string strsql, strsql2,strsql1;
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Labusername.Text = Convert.ToString(Session["username"]);
        int userid = Convert.ToInt32(Session["userid"]);
        cn = sqldata.createcon();
        cn.Open();
        strsql2 = "select count(*)from users where userid='"+userid +"'";
        cmd2 = new SqlCommand(strsql2, cn);
        int count = Convert.ToInt32(cmd2.ExecuteScalar());
        if (count > 0)
        {
            Response.Write("<script language='javascript'>alert('您的身份是＂寝室长＂,欢迎进入该页面！^_^');</script>");
        }
        else
        {
            Response.Write("<script language='javascript'>alert('非常抱歉！您不是＂寝室长＂,不能进入该页面！^_^');window.location.href='guestbook.aspx'</script>");
        }

        if (!this.IsPostBack)
        {

            this.txttilte.Focus();
            int i;
            ArrayList n, m;
            n = new ArrayList();
            m = new ArrayList();
            for (i = 0; i <= 49; i++)
            {
                n.Add(i.ToString());
            }
            this.face1.DataSource = n;
            this.face1.DataBind();

            for (i = 0; i <= 85; i++)
            {
                m.Add(i.ToString());
            }
            this.face.DataSource = m;
            this.face.DataBind();

            int id = Convert.ToInt32(Request.QueryString["id"]);

            cn = sqldata.createcon();
            cn.Open();
            strsql2 = "select*from guestbook where id=" + id;
            da1 = new SqlDataAdapter(strsql2, cn);
            da1.Fill(ds1);
            mytable = ds1.Tables[(0)];
            this.txtcontent.Text = Convert.ToString(mytable.Rows[0]["reply"]);
            this.txttilte.Text = Convert.ToString(mytable.Rows[0]["title"]);
            this.Labusername.Text = Convert.ToString(mytable.Rows[0]["username"]);
            this.Labsex.Text = Convert.ToString(mytable.Rows[0]["usersex"]);
            this.Labshenfen.Text = Convert.ToString(mytable.Rows[0]["usershenfen"]);
            this.Labxiname.Text = Convert.ToString(mytable.Rows[0]["userxiname"]);
            this.Labzhuanye.Text = Convert.ToString(mytable.Rows[0]["userzhuanye"]);
            this.Labentertime.Text = Convert.ToString(mytable.Rows[0]["entertime"]);
            this.Labemail.Text = Convert.ToString(mytable.Rows[0]["useremail"]);
            this.Labaddress.Text = Convert.ToString(mytable.Rows[0]["useraddress"]);
            this.Labclassname.Text = Convert.ToString(mytable.Rows[0]["classname"]);



            cn.Close();
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.txttilte.Focus();
        this.txtcontent.Text = "";
        this.txttilte.Text = "";
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (this.IsValid)
        {

            cn = sqldata.createcon();
            cn.Open();
            strsql = "insert into guestbook(username,userface,usershenfen,usersex,useraddress,useremail,entertime,userxiname,userzhuanye,classname,img,title,content)values('" + this.Labusername.Text.ToString() + "','" + this.face.SelectedItem.Value.ToString() + "','" + this.Labshenfen.Text + "','" + this.Labsex.Text + "','" + this.Labaddress.Text + "','" + this.Labemail.Text + "','" + this.Labentertime.Text + "','" + this.Labxiname.Text.ToString() + "','" + this.Labzhuanye.Text.ToString() + "','" + this.Labclassname.Text.ToString() + "','" + this.face1.SelectedItem.Value.ToString() + "','" + this.txttilte.Text.ToString().Trim() + "','" + this.txtcontent.Text.ToString().Trim() + "')";
            cmd = new SqlCommand(strsql, cn);
            cmd.ExecuteNonQuery();

            cn.Close();
            this.labmessage.Text = "编辑成功";
            this.HyperLink1.Visible = true;
        }
    }
    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        string title = args.Value;
        cn = sqldata.createcon();
        cn.Open();
        strsql2 = "select count(*)from guestbook where title='" + title + "'";
        cmd2 = new SqlCommand(strsql2, cn);
        int count = Convert.ToInt32(cmd2.ExecuteScalar());
        if (count > 0)
        {
            args.IsValid = false;
        }
        else
        {
            args.IsValid = true;
        }
        cn.Close();
    }
}