Plugins/UserSelect.aspx.cs

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

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

using System;
using System.Data;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Text;
using EKETEAM.Data;
using EKETEAM.FrameWork;

namespace eFrameWork.Plugins
{
    public partial class UserSelect : System.Web.UI.Page
    {        
        public string obj = eParameters.QueryString("obj");
        protected void Page_Load(object sender, EventArgs e)
        {
            litBody.Text = getTree("");
        }
        private string getTree(string ParentID)
        {
            string siteid = eBase.getSiteID();// eConfig.SiteID();
            StringBuilder sb = new StringBuilder();



            string sql = "select OrganizationalID,ParentID,MC,Code from Organizationals where DelTag=0";
            sql += (ParentID.Length == 0 ? " and ParentID IS NULL" : " and ParentID='" + ParentID + "'");
            sql += " and " + (siteid.Length > 0 ? "(SiteID=0 or SiteID='" + siteid + "')" : "SiteID=0");
            sql += " Order by PX,addTime";
            DataTable tb = eBase.DataBase.getDataTable(sql);
            //eBase.PrintDataTable(tb);

            if (ParentID.Length == 0)
            {
                sb.Append("<ul id=\"etree\" class=\"etree\" PID=\"NULL\">\r\n");
            }
            else
            {
                sb.Append("<ul PID=\"" + ParentID + "\">\r\n");
            }
            foreach (DataRow dr in tb.Rows)
            {
                #region 循环部门
                string ct = eBase.DataBase.getValue("select count(*) from  Organizationals where SiteID='" + siteid + "' and DelTag=0 and ParentID='" + dr["OrganizationalID"].ToString() + "'");
                sql = "select count(1) from a_eke_sysUsers where code like '" + dr["code"].ToString() + "%' and len(xm)>0 and Active=1 and deltag=0";
                string userct = eBase.UserInfoDB.getValue(sql);
                if (ct == "0" && userct == "0") continue;


                sb.Append("<li oncont3extmenu=\"return false;\" dataid=\"" + dr["OrganizationalID"].ToString() + "\" ");
                sb.Append(" class=\"\">");
                sb.Append("<div oncont3extmenu=\"return false;\">");
                sb.Append("<a href=\"javascript:;\" onclick=\"setUsers(this)\" oncontextmenu=\"return false;\">");
                sb.Append( dr["MC"].ToString() );
                sb.Append( "</a>"); // (" + ct + ")
                sb.Append("</div>");
                if (userct != "0")
                {