?//文件名:Login.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;
//該源碼下載自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

using System.Data.SqlClient; 
public partial class System_Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void Login1_LoggedIn(object sender, EventArgs e)
    {
        Session["MyUserName"] = this.Login1.UserName;
        System.Text.StringBuilder MyForbidString = new System.Text.StringBuilder();
        MyForbidString.Append("禁止操作權限：A1A2A3A4A5A6A7B1B2C1C2D1D2D3D4E1E2E3");
        string MyConnectionString = ConfigurationManager.ConnectionStrings["MyPersonnelDBConnectionString"].ConnectionString; ;
        string MySQL = "Select * From 操作用戶 Where 用戶名稱='" + this.Login1.UserName + "'";
        SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnectionString);
        DataTable MyTable = new DataTable();
        MyAdapter.Fill(MyTable);
        if (MyTable.Rows.Count > 0)
        {
            if ((int)MyTable.Rows[0]["人事管理之員工基本檔案"] == 1)
            {
                MyForbidString.Replace("A1", "是");
            }
            if ((int)MyTable.Rows[0]["人事管理之員工家庭成員"] == 1)
            {
                MyForbidString.Replace("A2", "是");

            }
            if ((int)MyTable.Rows[0]["人事管理之員工工作簡歷"] == 1)
            {
                MyForbidString.Replace("A3", "是");
            }
            if ((int)MyTable.Rows[0]["人事管理之員工獎懲記錄"] == 1)
            {
                MyForbidString.Replace("A4", "是");
            }
            if ((int)MyTable.Rows[0]["人事管理之員工培訓記錄"] == 1)
            {
                MyForbidString.Replace("A5", "是");
            }
            if ((int)MyTable.Rows[0]["人事管理之員工工作業(yè)績"] == 1)
            {
                MyForbidString.Replace("A6", "是");
            }
            if ((int)MyTable.Rows[0]["人事管理之員工離職管理"] == 1)
            {
                MyForbidString.Replace("A7", "是");
            }
            if ((int)MyTable.Rows[0]["考勤管理之月度部門考勤"] == 1)
            {
                MyForbidString.Replace("B1", "是");
            }
            if ((int)MyTable.Rows[0]["考勤管理之年度個人考勤"] == 1)
            {
                MyForbidString.Replace("B2", "是");
            }
            if ((int)MyTable.Rows[0]["工資管理之月度工資核算"] == 1)
            {
                MyForbidString.Replace("C1", "是");
            }
            if ((int)MyTable.Rows[0]["工資管理之月度工資發(fā)放"] == 1)
            {
                MyForbidString.Replace("C2", "是");
            }
            if ((int)MyTable.Rows[0]["查詢管理之查詢個人檔案"] == 1)
            {
                MyForbidString.Replace("D1", "是");
            }
            if ((int)MyTable.Rows[0]["查詢管理之查詢部門檔案"] == 1)
            {
                MyForbidString.Replace("D2", "是");
            }
            if ((int)MyTable.Rows[0]["查詢管理之查詢考勤信息"] == 1)
            {
                MyForbidString.Replace("D3", "是");
            }
            if ((int)MyTable.Rows[0]["查詢管理之查詢工資信息"] == 1)
            {
                MyForbidString.Replace("D4", "是");
            }
            if ((int)MyTable.Rows[0]["系統(tǒng)管理之分配用戶權限"] == 1)
            {
                MyForbidString.Replace("E1", "是");
            }
            if ((int)MyTable.Rows[0]["系統(tǒng)管理之公司信息設置"] == 1)
            {
                MyForbidString.Replace("E2", "是");
            }
            if ((int)MyTable.Rows[0]["系統(tǒng)管理之公司部門設置"] == 1)
            {
                MyForbidString.Replace("E3", "是");
            }
            Session["MyForbid"] = MyForbidString;
        }
    }
}