default.aspx.cs

asp.net 2.0的教务管理软件源码

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;

public partial class Start : System.Web.UI.Page
{
    LoginInfo My;
    string myName;
    protected void Page_Load(object sender, EventArgs e)
    {
        My = new LoginInfo(Session["LoginID"]);
        if(My.LoginID == 0) Response.Redirect("~/Signin.aspx");

        if (My.IsAdmin()) litSuper.Text = "超级";

        String sql = "SELECT * FROM v_Employee WHERE em_ID=" + My.LoginID;

        DataTable dt = DBExec.ExecDataTable(sql);

        myName = dt.Rows[0]["pe_Name"].ToString();

        lblManager.Text = myName;
        lblDuty.Text = dt.Rows[0]["职务"].ToString();
        lblLastLogin.Text = dt.Rows[0]["em_LastLogin"].ToString();

        lblWait.Text = DBExec.ExecGetInt("SELECT COUNT(st_ID) FROM J_Student WHERE st_JoinDate IS NULL").ToString();
        lblReading.Text = DBExec.ExecGetInt("SELECT COUNT(st_ID) FROM J_Student WHERE st_JoinDate IS NOT NULL AND st_GraduateDate IS NULL").ToString();
        lblGraduated.Text = DBExec.ExecGetInt("SELECT COUNT(st_ID) FROM J_Student WHERE st_GraduateDate IS NOT NULL").ToString();

       lblSumFee.Text = DBExec.ExecGetInt("SELECT SUM(st_RealPay) FROM J_Student WHERE dbo.f_PowerOnStudent(st_ID,"+My.LoginID+")>0").ToString();
      lblSumMonth.Text = DBExec.ExecGetInt("SELECT SUM(st_RealPay) FROM J_Student WHERE dbo.f_PowerOnStudent(st_ID,"+My.LoginID+")>0 AND DATEDIFF(m,st_JoinDate,getDate())=0").ToString();
    }
}