userinfo.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 userinfo : System.Web.UI.Page
{
    ArrayList year, month, day, year1;
    int i;
  
    SqlConnection  cn;
    SqlDataAdapter  da;
   SqlCommand  cmd, cmd1, cmd2, cmd3;
    SqlDataReader  dr1, dr2, dr, dr3,dr4;
    string strcon, strsql, strsql1, strsql2, strsql3, strsql4;
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Label1.Text = this.txtname.Text.ToString();
        if (!Page.IsPostBack)
        {
            year1 = new ArrayList();
            year = new ArrayList();
            month = new ArrayList();
            day = new ArrayList();

            for (i = 1999; i <= 2007; i++)
                year1.Add(i.ToString());
            for (i = 1945; i <= 2007; i++)
                year.Add(i.ToString());
            for (i = 1; i <= 12; i++)
                month.Add(i.ToString());
            for (i = 1; i <= 31; i++)
                day.Add(i.ToString());

            ddlyear.DataSource = year;
            ddlyear.DataBind();

            ddlmonth.DataSource = month;
            ddlmonth.DataBind();

            ddlday.DataSource = day;
            ddlday.DataBind();

            this.DropDownList1.DataSource = year1;
            this.DropDownList1.DataBind();

            this.DropDownList2.DataSource = month;
            this.DropDownList2.DataBind();

            this.DropDownList3.DataSource = day;
            this.DropDownList3.DataBind();


            this.txtname.Text = Convert.ToString(Session["username"]);
         
            this.txtage.Text = Convert.ToString(Session ["userage"]);
            this.txtaddress.Text = Convert.ToString(Session["useraddress"]);
            this.txtuserphone.Text = Convert.ToString(Session["homephone"]);
            this.txtuserid.Text = Convert.ToString(Session["userid"]);
            this.txtuseremail.Text = Convert.ToString(Session["useremail"]);
            this.txthomeshenfen.Text = Convert.ToString(Session ["shenfen"]);
            this.txtzhuanye.Text = Convert.ToString(Session["userzhuanye"]);
            this.txtclassname.Text = Convert.ToString(Session["classname"]);
            this.txtteacher.Text = Convert.ToString(Session["teacher"]);
            cn = sqldata.createcon();
            cn.Open();
            strsql = "select ximing from ximing ";
            cmd = new SqlCommand (strsql, cn);
            dr4 = cmd.ExecuteReader();
            this.ddlximing.DataSource = dr4;
            this.ddlximing.DataTextField = "ximing";
            this.ddlximing.DataBind();

            dr4.Close();
            cn.Close();

            this.ddlximing.Items.Add("请选择您的系名");
            this.ddlximing.SelectedIndex = this.ddlximing.Items.Count - 1;
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            this.Panel1.Visible = false;
            this.Panel2.Visible = true;
            cn = sqldata.createcon();
            cn.Open();
            strsql = "update users set username='" + this.txtname.Text.ToString().Trim () + "',userpwd='" + this.txtuserpwd.Text.ToString().Trim () + "',usersex='" + this.ddlsex.SelectedItem.Value.ToString() + "',userage='" + this.txtage.Text.ToString().Trim () + "',userminzu='" + this.ddlminzu.SelectedItem.Value.ToString() + "',userbirthday='" + ddlyear.SelectedItem.Value.ToString() + "-" + ddlmonth.SelectedItem.Value.ToString() + "-" + ddlday.SelectedItem.Value.ToString() + "',useraddress='" + this.txtaddress.Text.ToString().Trim () + "',homephone='" + this.txtuserphone.Text.ToString().Trim () + "',useremail='" + txtuseremail.Text.ToString().Trim () + "',enterdate='" + this.DropDownList1.SelectedItem.Value.ToString() + "-" + this.DropDownList2.SelectedItem.Value.ToString() + "-" + this.DropDownList3 .SelectedItem .Value .ToString ()+ "',userdepartment='" + this.ddlximing.SelectedItem.Value.ToString() + "',userzhuanye='" + txtzhuanye.Text.ToString().Trim () + "',classname='" + txtclassname.Text.ToString().Trim () + "',teacher='" + txtteacher.Text.ToString().Trim () + "' where userid='" + Convert.ToString(Session["userid"]) + "'";
            cmd = new SqlCommand (strsql, cn);
            cmd.ExecuteNonQuery  ();
            cn.Close();
        }
    }
    protected void ddlmonth_SelectedIndexChanged(object sender, EventArgs e)
    {
        int[] numbers = { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
        if ((Convert.ToInt32(ddlyear.SelectedItem.Text.ToString()) % 4) == 0)
            numbers[1] = 29;

        day = new ArrayList();
        for (i = 1; i <= numbers[Convert.ToInt32(ddlmonth.SelectedItem.Text.ToString()) - 1]; i++)
            day.Add(i.ToString());
        ddlday.DataSource = day;
        ddlday.DataBind();
    }
   
    protected void Button3_Click1(object sender, EventArgs e)
    {
       
            
            cn = sqldata.createcon();
            cn.Open();
            strsql1 = "update home set homesex='" + ddlhomesex.SelectedItem.Value.ToString() + "',homeflood='" + this.ddlflood.SelectedItem.Value.ToString() + "',homehao='" + txthomehaoma.Text.ToString().Trim() + "',homecount='" + ddlhomecount.SelectedItem.Value.ToString() + "',homephone='" + txthomephone.Text.ToString().Trim () + "' where uid='" + this.txtuserid.Text.ToString()+ "'";
            cmd1 = new SqlCommand(strsql1, cn);
            cmd1.ExecuteNonQuery();
            this.Panel2.Visible = false;
            this.Panel3.Visible = true;
            cn.Close();
    }
    protected void Button2_Click1(object sender, EventArgs e)
    {

        this.Panel2.Visible = false;
        this.Panel1.Visible = true;
    }
}