editmeeting.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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();