Data_Control/Tree_Control.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Data_Access;

namespace Data_Control
{
    public  class Tree_Control:EquipmentDBConnection 
    {
        /// <summary>
        /// 根据登录用户权限显示主界面左侧的树状菜单
        /// </summary>
        /// <param name="popedom">登录用户权限</param>
        /// <param name="superUser">用户是否为超级管理员标志</param>
        /// <returns>树状菜单</returns>
        public string TreeLoad(string popedom, string superUser)
        {     
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                conn.Open();
                string strSQL = string.Empty;
                if (superUser == "1")
                { strSQL = "select * from SystemTree order by DepartmentID asc"; }
                else
                {
                    if (popedom == "1,0")
                    {
                        strSQL = "select * from SystemTree where Remark<>'3' order by DepartmentID asc";
                    }
                    if (popedom == "1")
                    {
                        strSQL = "select * from SystemTree where Remark='1' or Remark='2'";
                    }
                    if (popedom == "1")
                    {
                        strSQL = "select * from SystemTree where Remark='1' or Remark='2'";
                    }
                    if (popedom == "0")
                    {
                        strSQL = "select * from SystemTree where Remark='0' or Remark='2'";
                    }
                }
               
                SqlCommand cmd = new SqlCommand(strSQL ,conn );
                SqlDataReader Rs = cmd.ExecuteReader();
                //Rs = my.ExecuteCreateReader(my.ExeCommand(strSQL));
                string arr_tree = "<DIV class=deeptree>";
                arr_tree += "<script language=javascript>";
                arr_tree += "var a=new TreeView(\'a\',\'main\');";
                while (Rs.Read() == true)
                {
                    arr_tree += "a.add(" + Rs["DepartmentID"] + "," + Rs["ParentID"] + ",\"" + Rs["DepartmentName"].ToString() + "\",\"" + Rs["Url_Add"] + "\");";
                }
                arr_tree += "document.write(a);";
                arr_tree += "a.expandAll();";
                arr_tree += "</script>";
                arr_tree += "</DIV>";
                Rs.Close();