masterpage.master.cs

OA系统,数据库为SQLSever 。net c#

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 MasterPage : System.Web.UI.MasterPage
{
    WebService webService = new WebService();
    protected void Page_Load(object sender, EventArgs e)
    {
        TreeNode newNode;
        if (!Page.IsPostBack)
        {
            if (Session["UserLevel"].ToString() == "总经理")
            {
                newNode = new TreeNode("撰写决策草案");
                newNode.NavigateUrl = "~/CompanyDecision/CD_Add.aspx";
                this.TreeView1.Nodes[0].ChildNodes.Add(newNode);
                newNode = new TreeNode("修改决策草案");
                newNode.NavigateUrl = "~/CompanyDecision/CD_List3.aspx";
                this.TreeView1.Nodes[0].ChildNodes.Add(newNode);
                newNode = new TreeNode("审核决策草案");
                newNode.NavigateUrl = "~/CompanyDecision/CD_List2.aspx";
                this.TreeView1.Nodes[0].ChildNodes.Add(newNode);
                this.TreeView1.Nodes[1].ChildNodes[0].NavigateUrl = "~/DepartmentDecision/DD_ListAll.aspx";
                this.TreeView1.Nodes[2].ChildNodes[0].NavigateUrl = "~/ClientInfo/Client_ListAll.aspx";
                this.TreeView1.Nodes[3].ChildNodes[0].NavigateUrl = "~/OrderInfo/Order_ListAll.aspx";
            }
            if (Session["UserLevel"].ToString() == "副总经理")
            {
                newNode = new TreeNode("撰写决策草案");
                newNode.NavigateUrl = "~/CompanyDecision/CD_Add.aspx";
                this.TreeView1.Nodes[0].ChildNodes.Add(newNode);
                newNode = new TreeNode("修改决策草案");
                newNode.NavigateUrl = "~/CompanyDecision/CD_List3.aspx";
                this.TreeView1.Nodes[0].ChildNodes.Add(newNode);
                this.TreeView1.Nodes[1].ChildNodes[0].NavigateUrl = "~/DepartmentDecision/DD_ListAll.aspx";
                this.TreeView1.Nodes[2].ChildNodes[0].NavigateUrl = "~/ClientInfo/Client_ListAll.aspx";
                this.TreeView1.Nodes[3].ChildNodes[0].NavigateUrl = "~/OrderInfo/Order_ListAll.aspx";
            }
            if (Session["UserLevel"].ToString() == "部门经理")
            {
                newNode = new TreeNode("撰写决策草案");
                newNode.NavigateUrl = "~/DepartmentDecision/DD_Add.aspx";
                this.TreeView1.Nodes[1].ChildNodes.Add(newNode);
                newNode = new TreeNode("审核决策草案");
                newNode.NavigateUrl = "~/DepartmentDecision/DD_List2.aspx";
                this.TreeView1.Nodes[1].ChildNodes.Add(newNode);
                newNode = new TreeNode("修改决策草案");
                newNode.NavigateUrl = "~/DepartmentDecision/DD_List3.aspx";
                this.TreeView1.Nodes[1].ChildNodes.Add(newNode);
                newNode = new TreeNode("添加新客户");
                newNode.NavigateUrl = "~/ClientInfo/Client_Add.aspx";
                this.TreeView1.Nodes[2].ChildNodes.Add(newNode);
                newNode = new TreeNode("审核新客户");
                newNode.NavigateUrl = "~/ClientInfo/Client_List2.aspx";
                this.TreeView1.Nodes[2].ChildNodes.Add(newNode);
                newNode = new TreeNode("修改客户信息");
                newNode.NavigateUrl = "~/ClientInfo/Client_List3.aspx";
                this.TreeView1.Nodes[2].ChildNodes.Add(newNode);
                newNode = new TreeNode("添加新订单");
                newNode.NavigateUrl = "~/OrderInfo/Order_Add.aspx";
                this.TreeView1.Nodes[3].ChildNodes.Add(newNode);
            }
            if (Session["UserLevel"].ToString() == "职员")
            {
                newNode = new TreeNode("添加新客户");
                newNode.NavigateUrl = "~/ClientInfo/Client_Add.aspx";
                this.TreeView1.Nodes[2].ChildNodes.Add(newNode);
                newNode = new TreeNode("修改客户信息");
                newNode.NavigateUrl = "~/ClientInfo/Client_List3.aspx";
                this.TreeView1.Nodes[2].ChildNodes.Add(newNode); 
                newNode = new TreeNode("添加新订单");
                newNode.NavigateUrl = "~/OrderInfo/Order_Add.aspx";
                this.TreeView1.Nodes[3].ChildNodes.Add(newNode);
            }
        }
        string strSql = "Select Person_RealName,Person_Sex from z_Person where Person_ID='"+Session["UserID"].ToString()+"';";
        DataTable table = webService.ExcuteSelect(strSql);
        string strMsg = "欢迎您的到来，"+table.Rows[0]["Person_RealName"].ToString();
        if (table.Rows[0]["Person_Sex"].ToString() == "False")
            strMsg += "先生！";
        else
            strMsg += "女士！";
        strMsg += "  今天日期是：" + DateTime.Now.Year + "年" + DateTime.Now.Month + "月" + DateTime.Now.Day + "日";
        this.lblPersonInfo.Text = strMsg;
    }
}