BLL/AchieveBLL/DepartmentBLL.cs

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

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

using AchieveDALFactory;
using AchieveEntity;
using AchieveInterfaceDAL;
using System.Data;
using System.Text;

namespace AchieveBLL
{
    public class DepartmentBLL
    {
        private IDepartmentDAL dal = DALFactory.GetDepartmentDAL();

        /// <summary>
        /// 根据用户id获取用户部门
        /// </summary>
        public DataTable GetDepartmentByUserId(int id)
        {
            return dal.GetDepartmentByUserId(id);
        }

        /// <summary>
        /// 根据条件获取部门
        /// </summary>
        public string GetAllDepartment(string where)
        {
            DataTable dt = dal.GetAllDepartment(where);
            StringBuilder str = new StringBuilder();
            if (dt.Rows.Count > 0)
            {
                str.Append(Recursion(dt, 0));
                str = str.Remove(str.Length - 2, 2);
            }
            return str.ToString();
        }

        //递归方法
        private string Recursion(DataTable dt, object parentId)
        {
            StringBuilder sbJson = new StringBuilder();
            DataRow[] rows = dt.Select("ParentId = " + parentId);
            if (rows.Length > 0)
            {
                sbJson.Append("[");
                for (int i = 0; i < rows.Length; i++)
                {
                    string childString = Recursion(dt, rows[i]["id"]);
                    if (!string.IsNullOrEmpty(childString))
                    {
                        //comboTree必须设置【id】和【text】，一个是id一个是显示值
                        sbJson.Append("{\"id\":\"" + rows[i]["Id"].ToString() + "\",\"ParentId\":\"" + rows[i]["ParentId"].ToString() + "\",\"Sort\":\"" + rows[i]["Sort"].ToString() + "\",\"UpdateBy\":\"" + rows[i]["UpdateBy"].ToString() + "\",\"UpdateTime\":\"" + rows[i]["UpdateTime"].ToString() + "\",\"text\":\"" + rows[i]["DepartmentName"].ToString() + "\",\"children\":");
                        sbJson.Append(childString);
                    }
                    else
                        sbJson.Append("{\"id\":\"" + rows[i]["Id"].ToString() + "\",\"ParentId\":\"" + rows[i]["ParentId"].ToString() + "\",\"Sort\":\"" + rows[i]["Sort"].ToString() + "\",\"UpdateBy\":\"" + rows[i]["UpdateBy"].ToString() + "\",\"UpdateTime\":\"" + rows[i]["UpdateTime"].ToString() + "\",\"text\":\"" + rows[i]["DepartmentName"].ToString() + "\"},");
                }
                sbJson.Remove(sbJson.Length - 1, 1);
                sbJson.Append("]},");
            }
            return sbJson.ToString();
        }