default.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 _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            string admin = "管理员";
            string user = "普通用户";
            string username = Convert.ToString(Session ["username"]);
            SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["cn"]);
            cn.Open();
            SqlCommand cmd = new SqlCommand("select count(*) from userinfo where role='" +admin+"'", cn);
            this.Labadmincount.Text = Convert.ToString(cmd.ExecuteScalar ());
            SqlCommand cmd1 = new SqlCommand("select count(*) from userinfo where role='"+user+"'", cn);
            this.Labusercount .Text = Convert.ToString(cmd1.ExecuteScalar());
            SqlCommand cmd2 = new SqlCommand("select count(*) from room", cn);
            this.Labroomcount.Text = Convert.ToString(cmd2.ExecuteScalar());
            SqlCommand cmd3 = new SqlCommand("select count(*) from meeting", cn);
            this.Labmeetingcount .Text = Convert.ToString(cmd3.ExecuteScalar());
            SqlCommand cmd4 = new SqlCommand("select count(*) from meeting where builder='" +Convert .ToString (Session ["username"])+"'", cn);
            this.Labmymeetingcount .Text = Convert.ToString(cmd4.ExecuteScalar());
            SqlCommand cmd5 = new SqlCommand("select count(*) from meeting where person like'%" +username+"%'", cn);
            this.Labmyjionmeetingcount .Text = Convert.ToString(cmd5.ExecuteScalar());
            SqlCommand cmd6 = new SqlCommand("select count(*) from userinfo where attr='在线'", cn);
            this.Labonlinecount.Text = Convert.ToString(cmd6.ExecuteScalar());

            SqlCommand cmd7 = new SqlCommand("select count(*) from meeting where attr='待审批'", cn);
            this.Label1 .Text = Convert.ToString(cmd7.ExecuteScalar());
            SqlCommand cmd8 = new SqlCommand("select count(*) from meeting where attr='已审批'", cn);
            this.Label2.Text = Convert.ToString(cmd8.ExecuteScalar());
            SqlCommand cmd9= new SqlCommand("select count(*) from meeting where attr='已完成'", cn);
            this.Label3.Text = Convert.ToString(cmd9.ExecuteScalar());
            SqlCommand cmd10 = new SqlCommand("select count(*) from userinfo", cn);
            this.Labcount.Text = Convert.ToString(cmd10.ExecuteScalar());
            SqlCommand cmd11 = new SqlCommand("select count(*) from message where touser='"+Convert.ToString (Session ["username"])+"'", cn);
            this.Labmessagecount .Text = Convert.ToString(cmd11.ExecuteScalar());
            this.PopupWin1.Message = "欢迎您！" + Session["username"] + "<br>" + "身&nbsp;份：" + Session["role"] + "<br>" + "上站次数：" + Session["loginnum"] + "<br>" + "最近访问：" + Session["loginouttime"] + "<br>" + "注册时间：" + Session["entertime"] + "<br>";

            cn.Close ();
        }
    }
}