adminnoticsedit.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 adminnoticsedit : System.Web.UI.Page
{
    SqlCommand cmd, cmd1,cmd2;
    SqlConnection cn;
    SqlDataReader dr, dr1;
    SqlDataAdapter da, da1;
    DataSet ds = new DataSet();
    DataSet ds1 = new DataSet();
    DataTable mytable = new DataTable();
    string strsql, strsql1, strsql2;
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Label4.Text = this.DropDownList1.SelectedItem.Value.ToString();
        if (!this.IsPostBack)
        {

            if (Session["adminname"] == null)
            {
                Response.Redirect("index.aspx");
            }
            else
            {
                this.Label1.Text = Convert.ToString(Request.QueryString["id"]);
                int id = int.Parse(Request.QueryString["id"]);
                cn = sqldata.createcon();
                cn.Open();
                strsql = "select *from tongzhi where id=" + id;
                da = new SqlDataAdapter(strsql, cn);
                da.Fill(ds);
                mytable = ds.Tables[(0)];
                this.txtusername.Text = Convert.ToString(mytable.Rows[0]["username"]);
                this.content.Text = Convert.ToString(mytable.Rows[0]["content"]);
                this.Label4.Text = Convert.ToString(mytable.Rows[0]["show"]);
            }

        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (this.IsValid)
        {
     
            int id = int.Parse(Request.QueryString["id"]);
            cn = sqldata.createcon();
            cn.Open();
    
                int num1 = Convert.ToInt32(this.Label4.Text);
                strsql1 = "update tongzhi set content='" + this.content.Text.ToString().Trim() + "',show='" + num1 + "'  where id= " + id;
                cmd = new SqlCommand(strsql1, cn);
                cmd.ExecuteNonQuery();
                cn.Close();
                this.Label2.Text = "更新成功";
                this.HyperLink1.Visible = true;
            }
        
    }
    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        string content = args.Value;
        cn = sqldata.createcon();
        cn.Open();
        strsql2 = "select count(*)from tongzhi where content='" + content + "'";
        cmd2 = new SqlCommand(strsql2, cn);
        int count = Convert.ToInt32(cmd2.ExecuteScalar());
        if (count > 0)
        {
            args.IsValid = false;
        }
        else
        {
            args.IsValid = true;
        }
        cn.Close();
    }
}