editmeeting.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 editmeeting : System.Web.UI.Page
{
    ArrayList year, month, day, hour, m;
    int i;
    SqlConnection cn;
    DataTable mytable = new DataTable();
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            int id = int.Parse(Request .QueryString ["id"]);
            cn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["cn"]);
            cn.Open();
            SqlCommand cmd = new SqlCommand("select * from userinfo", cn);
            SqlDataReader dr = cmd.ExecuteReader();
            this.CheckBoxList1.DataSource = dr;
            this.CheckBoxList1.DataTextField = "username";
            this.CheckBoxList1.DataBind();
            dr.Close();
            SqlCommand cmd1 = new SqlCommand("select * from userinfo",cn);
            SqlDataReader dr1 = cmd1.ExecuteReader();
            this.RadioButtonList1.DataSource = dr1;
            this.RadioButtonList1.DataTextField = "username";
            this.RadioButtonList1.DataBind();
            dr1.Close();
            SqlDataAdapter  da =new SqlDataAdapter ("select * from meeting where id="+id,cn);
            da.Fill(ds ,"meeting");
            mytable = ds.Tables["meeting"];
            this.RadioButtonList1.Text  = Convert.ToString(mytable.Rows[0]["organizer"]);
            this.txtname.Text = Convert.ToString(mytable .Rows[0]["name"]);
            this.txtnote.Text = Convert.ToString(mytable .Rows[0]["content"]);
            this.txtorganizenote.Text = Convert.ToString(mytable.Rows[0]["organizernote"]);
            this.txtperson.Text = Convert.ToString(mytable .Rows[0]["person"]);
            this.ddlattr.SelectedItem.Text = Convert.ToString(mytable.Rows[0]["attr"]);
            this.ddlroompos.Text = Convert.ToString(mytable.Rows[0]["addr"]);
            this.CheckBoxList1.Text  = Convert.ToString(mytable .Rows [0]["person"]);
            this.txtrecord.Text = Convert.ToString(mytable .Rows [0]["record"]);
            if (Convert.ToString(mytable.Rows[0]["attr"]) == "待审批" && Convert.ToString(Session["role"]) == "普通用户")
            {
                this.Button2.Enabled = false;
            }
            else if (Convert.ToString(mytable.Rows[0]["attr"]) == "待审批" && Convert.ToString(Session["role"]) == "管理员")
            {
                this.Button2.Enabled = true;
            }
            cn.Close();
            year = new ArrayList();
            month = new ArrayList();
            day = new ArrayList();
            hour = new ArrayList();
            m = new ArrayList();

            for (i = 2000; i <= 2100; 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());
            for (i = 1; i <= 24; i++)
                hour.Add(i.ToString());
            for (i = 00; i <= 59; i++)
                m.Add(i.ToString());

            ddlyear.DataSource = year;
            ddlyear.DataBind();
            ddlyear.Text = System.DateTime.Now.Year.ToString();
            DropDownList1.Text = System.DateTime.Now.Year.ToString();

            ddlmonth.DataSource = month;
            ddlmonth.DataBind();
            ddlmonth.Text = System.DateTime.Now.Month.ToString();
            DropDownList2.Text = System.DateTime.Now.Month.ToString();

            ddlday.DataSource = day;
            ddlday.DataBind();
            ddlday.Text = System.DateTime.Now.Day.ToString();
            DropDownList3.Text = System.DateTime.Now.Day.ToString();

            ddlhour.DataSource = hour;
            ddlhour.DataBind();
            ddlhour.Text = System.DateTime.Now.Hour.ToString();
            DropDownList4.Text = System.DateTime.Now.Hour.ToString();
            ddlm.DataSource = m;
            ddlm.DataBind();
            ddlm.Text = System.DateTime.Now.Minute.ToString();

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

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

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

            this.DropDownList4.DataSource = hour;
            this.DropDownList4.DataBind();
            this.DropDownList5.DataSource = m;
            this.DropDownList5.DataBind();
            DropDownList5.Text = System.DateTime.Now.Minute.ToString();

        }

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.Label1.Text = "";
        int id = int.Parse(Request.QueryString["id"]);
        if (Page.IsValid)
        {
            for (int i = 0; i <= CheckBoxList1.Items.Count - 1; i++)
            {
                if (this.CheckBoxList1.Items[i].Selected)
                {
                    this.Label1.Text += this.CheckBoxList1.Items[i].Text.ToString() + ",";
                }
            }
            try
            {
                cn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["cn"]);
                cn.Open();
                SqlCommand cmd = new SqlCommand("update meeting set name='" + this.txtname.Text.ToString().Trim() + "',attr='"+this.ddlattr .SelectedItem .Value .ToString ()+"',addr='" + this.ddlroompos.SelectedItem.Value.ToString() + "',record='"+this.txtrecord .Text .Trim ()+"',begintime='" + this.ddlyear.SelectedItem.Value.ToString() + "-" + this.ddlmonth.SelectedItem.Value.ToString() + "-" + this.ddlday.SelectedItem.Value + "  " + this.ddlhour.SelectedItem.Value.ToString() + "-" + this.ddlm.SelectedItem.Value.ToString() + "',endtime='" + this.DropDownList1.SelectedItem.Value.ToString() + "-" + this.DropDownList2.SelectedItem.Value.ToString() + "-" + this.DropDownList3.SelectedItem.Value.ToString() + "  " + this.DropDownList4.SelectedItem.Value.ToString() + "-" + this.DropDownList5.SelectedItem.Value.ToString() + "',person='" + this.Label1.Text.Trim() + "',builder='" + Convert.ToString(Session["username"]) + "',organizer='" + this.RadioButtonList1.SelectedItem.Value.ToString() + "',organizernote='"+this.txtorganizenote .Text .Trim ()+"',content='" + this.txtnote.Text.Trim() + "'where id="+id, cn);
                cmd.ExecuteNonQuery();
                this.HyperLink1.Visible = true;
                this.Labmessage.Text = "修改会议成功";

            }
            catch
            {
                this.Labmessage.Text = "服务器忙，请一会在试！";
            }
            finally
            {
                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 DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
        int[] numbers = { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
        if ((Convert.ToInt32(this.DropDownList1.SelectedItem.Text.ToString()) % 4) == 0)
            numbers[1] = 29;

        day = new ArrayList();
        for (i = 1; i <= numbers[Convert.ToInt32(this.DropDownList2.SelectedItem.Text.ToString()) - 1]; i++)
            day.Add(i.ToString());
        this.DropDownList3.DataSource = day;
        this.DropDownList3.DataBind();

    }
}