logininfo.cs

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

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// 取得登录信息
/// </summary>
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
public class LoginInfo
{
    private int loginID;
	public LoginInfo(int SessionID)
	{
        loginID = SessionID;
    }

    public LoginInfo(object SessionID)
    {
        if (SessionID == null || Convert.ToString(SessionID) == "")
            loginID = 0;
        else
            loginID = Convert.ToInt32(SessionID);

    }
    //取得登录ＩＤ
    public int LoginID
    {
        get { return loginID; }
    }

    //取得登录名
    public string LoginName
    {
        get
        {
            DataTable dt = DBExec.ExecDataTable("SELECT pe_Name FROM v_Employee WHERE em_ID=" + loginID);
            return dt.Rows[0][0].ToString();
         //   HttpContext.Current.Response.Redirect
        }
    }

    public bool IsAdmin()
    {
        return DBExec.ExecGetInt("SELECT dbo.f_PowerOnClass(1," + loginID + ")") >= 1;
    }
    //判断loginID的老师对studentID的学生有什么样的访问权 0-不能访问 1-只读 2以上-可修改
    public int PowerOnStudent(int studentID)
    {
        return DBExec.ExecGetInt("SELECT dbo.f_PowerOnStudent("+studentID+", "+loginID+")");
    }

    //判断loginID的老师对classID的班级有什么样的访问权 0-不能访问 1-是直接领导 2以上 - 是上级领导
    public int PowerOnClass(int classID)
    {
        return DBExec.ExecGetInt("SELECT dbo.f_PowerOnClass(" + classID + "," + loginID + ")");
    }
}