ShuangHui_API/codegit/CallCenterApi/CallCenterAp.../CallCenterAp.../Controllers/DepartmentCo...

using CallCenter.Utility;
using CallCenterApi.DB;
using CallCenterApi.Interface.Controllers.Base;
using CallCenterApi.Interface.Models.Input;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace CallCenterApi.Interface.Controllers
{
    [Authority]
    public class DepartmentController : BaseController
    {
        private BLL.T_Sys_Department departmentBLL = new BLL.T_Sys_Department();
    
        /// <summary>
        /// 获取部门列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetAllList()
        {
            if (Request.IsAuthenticated)
            {
                //int userId = CurrentUser.UserData.F_UserId;
                //Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(userId);
                string where = "F_State='1'";
                //if (!string.IsNullOrEmpty(userModel.groupcode))
                //{
                //    where += " and F_GroupCode = '" + userModel.groupcode + "'";
                //}

                DataTable dt = departmentBLL.GetList(0, where, " F_Sort asc").Tables[0];
                return Success("加载成功", dt);
            }
            return NoToken("未知错误，请重新登录");
        }
        /// <summary>
        /// 获取大区列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetDepartmentList(int pId = 1, int F_Layer = 1)
        {
            if (Request.IsAuthenticated)
            {
                DataTable dt = new DataTable();
                string where = " ";
                where = " isnull(F_DeptId,0) = '" + 1 + "' and F_State = 1" ;
                dt = new BLL.T_Sys_Department().GetList(0, where, " F_Sort asc").Tables[0];
               List<Model.TreeModel> modelList = BindAreaTree(dt, "0", 1);
                return Success("加载成功", modelList);
            }
            return NoToken("未知错误，请重新登录");
        }
        /// <summary>
        /// 获取大区列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetCusAreaList(string keyword, int pId = 1,int F_Layer=1)
        {
            if (Request.IsAuthenticated)
            {
                DataTable dt = new DataTable();
                string where = "isnull(F_ParentId, 1) = '" + pId + "' ";
               if (!string .IsNullOrEmpty (keyword))
                {
                    where += "and  F_DeptName like '%" + keyword.Trim () + "%'";
                }
               where += " and F_State = 1 and F_Layer = "+ F_Layer;
                dt = new BLL.T_Sys_Department().GetList(0, where, " F_Sort asc").Tables[0];
                return Success("加载成功", dt);
            }
                return NoToken("未知错误，请重新登录");
        }
        public ActionResult GetSubordinate()
        {
            if (Request.IsAuthenticated)
            {
                DataTable dt = new DataTable();
                string where = " ";
                //if (!string.IsNullOrEmpty(userModel.groupcode))
                //{
                //    where += " and F_GroupCode = '" + userModel.groupcode + "'";
                //}
                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = new BLL .T_Sys_UserAccount ().GetModel(userId);
                int pId = 1;
                if (userModel != null)
                    pId = userModel.F_DeptId;
                if (pId == 1)
                    where = "isnull(F_ParentId, 1) = '" + pId + "' and F_State = 1 and F_Layer = 1";
                else
                    where = "F_DeptId=" + pId;
                dt = new BLL.T_Sys_Department().GetList(0, where, " F_Sort asc").Tables[0];

                List<Model.TreeModel> modelList = BindAreaTree(dt, "0");

                if (modelList != null)
                {
                    if (modelList.Count > 0)
                        return Success("加载成功", modelList);
                }
                return Error("加载失败");
            }
            return NoToken("未知错误，请重新登录");
        }
        private BLL.T_Sys_UserAccount userBLL = new BLL.T_Sys_UserAccount();
        private BLL.T_Sys_RoleInfo rolebll = new BLL.T_Sys_RoleInfo();
        public ActionResult GetAPPAreaList(int pId = 1)
        {
            if (Request.IsAuthenticated)
            {

                DataTable dt = new DataTable();
                string where = " ";
                if (pId == 1)
                    where = "isnull(F_ParentId, 1) = '" + pId + "' and F_State = 1 and F_Layer = 1";
                else
                    where = "F_DeptId=" + pId;
                dt = new BLL.T_Sys_Department().GetList(0, where, " F_Sort asc").Tables[0];

                List<Model.TreeModel> modelList = BindAreaTree(dt, "0");
                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = userBLL.GetModel(userId);
                Model.T_Sys_RoleInfo ro = rolebll.GetModel(userModel.F_RoleId);
                if (ro.F_RoleCode == "CLZY")
                {
                    Model.TreeModel model = new Model.TreeModel();
                    string currentID = "0";//当前功能ID
                    model.id = currentID;
                    model.IconCls = "";//图标
                    model.text = "双汇集团";
                    List<Model.TreeModel> modelList1 = new List<Model.TreeModel>();
                    Model.TreeModel model1 = new Model.TreeModel();
                    model1.id = currentID;
                    model1.IconCls = "";//图标
                    model1.text = "管理区域";
                    modelList1.Add(model1);
                    model.children = modelList1;
                    modelList.Add(model);
                }
                modelList.Sort((a, c) => a.id.CompareTo(c.id));
                if (modelList != null)
                {
                    if (modelList.Count > 0)
                        return Success("加载成功", modelList);
                }
                return Error("加载失败");
            }
            return NoToken("未知错误，请重新登录");
        }
        /// <summary>
        /// 获取大区列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetAreaList(int pId = 1)
        {
            if (Request.IsAuthenticated)
            {
              
                DataTable dt = new DataTable();
                string where = " ";
                if (pId == 1)
                    where = "isnull(F_ParentId, 1) = '" + pId + "' and F_State = 1 and F_Layer = 1";
               else
                    where = "F_DeptId="+ pId;
                dt = new BLL.T_Sys_Department().GetList(0, where, " F_Sort asc").Tables[0];
               
                List<Model.TreeModel> modelList = BindAreaTree(dt, "0");
                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = userBLL.GetModel(userId);
                Model.T_Sys_RoleInfo ro = rolebll.GetModel(userModel.F_RoleId);
                if (ro.F_RoleCode == "CLZY")
                {
                    Model.TreeModel model = new Model.TreeModel();
                    string currentID = "0";//当前功能ID
                    model.id = currentID;
                    model.IconCls = "";//图标
                    model.text = "双汇集团";
                    List<Model.TreeModel> modelList1 = new List<Model.TreeModel>();
                    Model.TreeModel model1 = new Model.TreeModel();
                    model1.id = currentID;
                    model1.IconCls = "";//图标
                    model1.text = "管理区域";
                    modelList1.Add(model1);
                    model.children = modelList1;
                    modelList.Add(model);
                }
                modelList.Sort((a, c) => a.id.CompareTo(c.id));
                if (modelList != null)
                {
                    if (modelList.Count > 0)
                        return Success("加载成功", modelList);
                }
                return Error("加载失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        /// <summary>
        /// tree  树形部门
        /// </summary>
        /// <param name="tab"></param>
        /// <param name="parentid"></param>
        /// <returns></returns>
        private List<Model.TreeModel> BindAreaTree(DataTable tab, string parentid,int pid=0)
        {
            DataTable tab2 = new DataTable();

            if (tab != null && tab.Rows.Count > 0)
            {
                List<Model.T_Sys_Department> categorylist = new BLL.T_Sys_Department().DataTableToList(tab);
                List<Model.TreeModel> modelList = new List<Model.TreeModel>(categorylist.Count);
                for (int i = 0; i < categorylist.Count; i++)
                {
                    Model.TreeModel model = new Model.TreeModel();
                    string currentID = categorylist[i].F_DeptId.ToString();//当前功能ID
                    model.id = currentID;
                    model.IconCls = "";//图标
                    model.text = categorylist[i].F_DeptName;
                    if (pid==1)
                    {
                              tab2 = new BLL.T_Sys_Department().GetList("F_ParentId=" + currentID + " and F_State=1    and F_Layer = 1 order by f_sort").Tables[0];
                    }
                    else
                    {
                        tab2 = new BLL.T_Sys_Department().GetList("F_ParentId=" + currentID + " and F_State=1 order by f_sort").Tables[0];
                    }
                  
                    if (tab2 != null && tab2.Rows.Count > 0)
                    {
                        model.children = BindBreaTree(tab2, currentID, pid);
                    }
                    modelList.Add(model);
                }
                return modelList;

            }
            else
            {
                return null;
            }

        }
        /// <summary>
        /// tree  树形部门
        /// </summary>
        /// <param name="tab"></param>
        /// <param name="parentid"></param>
        /// <returns></returns>
        private List<Model.TreeModel> BindBreaTree(DataTable tab, string parentid,int pid=0)
        {
            DataTable tab2 = new DataTable();

            if (tab != null && tab.Rows.Count > 0)
            {
                List<Model.T_Sys_Department> categorylist = new BLL.T_Sys_Department().DataTableToList(tab);
                List<Model.TreeModel> modelList = new List<Model.TreeModel>(categorylist.Count);
                for (int i = 0; i < categorylist.Count; i++)
                {
                    Model.TreeModel model = new Model.TreeModel();
                    string currentID = categorylist[i].F_DeptId.ToString();//当前功能ID
                    model.id = currentID;
                    model.IconCls = "";//图标
                    model.text = categorylist[i].F_DeptName;
                    tab2 = new BLL.T_Sys_Department().GetList("F_ParentId=" + currentID + " and F_State=1 order by f_sort").Tables[0];
                    if (pid >0)
                    {
                        if (tab2 != null && tab2.Rows.Count > 0)
                        {
                            model.children = BindBreaTree(tab2, currentID, 0);
                        }
                    }
                    modelList.Add(model);
                }
                return modelList;

            }
            else
            {
                return null;
            }

        }
        /// <summary>
        /// 获取部门
        /// </summary>
        /// <param name="deptId"></param>
        /// <returns></returns>
        public ActionResult GetDept(int deptId = 0)
        {
            if (Request.IsAuthenticated)
            {
                BLL.T_Sys_Department dBLL = new BLL.T_Sys_Department();
                Model.T_Sys_Department dModel = dBLL.GetModel(deptId);
                if (dModel != null)
                    return Success("获取部门信息成功", new
                    {
                        deptid = dModel.F_DeptId,
                        depname = dModel.F_DeptName,
                        sort = dModel.F_Sort,
                        parentid = dModel.F_ParentId,
                        parentname = dModel.F_ParentName,
                        layer= dModel.F_Layer 
                    });
                return Error("获取部门信息失败");
            }
            return NoToken("未知错误，请重新登录");
        }
        /// <summary>
        /// 获取部门
        /// </summary>
        /// <param name="deptId"></param>
        /// <returns></returns>
        public ActionResult GetwhereDept()
        {
            if (Request.IsAuthenticated)
            {
                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(userId);
                int deptId = 0;
                if (userModel!=null )
                {
                    deptId = userModel.F_DeptId;
                }
                BLL.T_Sys_Department dBLL = new BLL.T_Sys_Department();
                Model.T_Sys_Department dModel = dBLL.GetModel(deptId);
                if (dModel != null)
                    return Success("获取部门信息成功", new
                    {
                        deptid = dModel.F_DeptId,
                        depname = dModel.F_DeptName,
                        sort = dModel.F_Sort,
                        F_Layer = dModel.F_Layer,
                       parentid = dModel.F_ParentId,
                        parentname = dModel.F_ParentName
                    });
                return Error("获取部门信息失败");
            }
            return NoToken("未知错误，请重新登录");
        }
        /// <summary>
        /// 添加部门
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult AddDept(DepartmentInput input)
        {
            
            if (Request.IsAuthenticated)
            {
                //int userId = CurrentUser.UserData.F_UserId;
                //Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(userId);

                string pcode = "";
                Model.T_Sys_Department dModel = new Model.T_Sys_Department();
                dModel.F_ParentId = input.PId;
                if (input.PId != 0)
                {
                    Model.T_Sys_Department pdModel = departmentBLL.GetModel(input.PId);
                    if (pdModel != null)
                    {
                        pcode = dModel.F_ParentCode = pdModel.F_DeptCode;  
                        if (pdModel.F_Layer ==1)
                            dModel.F_Layer = 2;
                        else if (pdModel.F_Layer == 2)
                            dModel.F_Layer = 3;
                        dModel.F_ParentName = pdModel.F_DeptName;
                    }
                }
                dModel.F_Sort = input.Sort;
                dModel.F_DeptName = input.DeptName;
                dModel.F_State = 1;
                dModel.F_Layer = input.F_Layer;
                //dModel.F_GroupCode = userModel.groupcode;
                int id = departmentBLL.Add(dModel);
                if (id> 0)
                {
                    departmentBLL.UpdateDeptCode(pcode + id.ToString() + "|", id);
                    return Success("添加成功");
                }
                else
                    return Success("添加失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        /// <summary>
        /// 编辑部门
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        [HttpPost]
        public ActionResult EditDept(DepartmentInput input)
        {
            if (Request.IsAuthenticated)
            {
                if (input.DeptId <= 0)
                    return Error("请选择要编辑的部门");
                BLL.T_Sys_Department dBLL = new BLL.T_Sys_Department();
                Model.T_Sys_Department dModel = dBLL.GetModel(input.DeptId);
                if (dModel == null)
                    return Error("获取信息失败");

                dModel.F_ParentId = input.PId;
                if (input.PId != 0)
                {
                    Model.T_Sys_Department pdModel = departmentBLL.GetModel(input.PId);
                    if (pdModel != null)
                    {
                        dModel.F_ParentCode = pdModel.F_DeptCode;
                        dModel.F_DeptCode = pdModel.F_DeptCode + input.DeptId.ToString() + "|";
                        if (pdModel.F_Layer == 1)
                            dModel.F_Layer = 2;
                        else if (pdModel.F_Layer == 2)
                            dModel.F_Layer = 3;
                        dModel.F_ParentName = pdModel.F_DeptName;
                    }
                }
                dModel.F_Sort = input.Sort;
                dModel.F_DeptName = input.DeptName;
                dModel.F_Layer = input.F_Layer;
                if (dBLL.Update(dModel))
                    return Success("编辑成功");
                return Error("编辑失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        /// <summary>
        /// 删除部门
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public ActionResult DelDept(string[] ids)
        {
            if (Request.IsAuthenticated)
            {
                if (ids == null || ids.Length <= 0)
                    return Error("请选择要删除的部门");

                var idStr = string.Join(",", ids);
                if (string.IsNullOrEmpty(idStr.Trim()))
                    return Error("请选择要删除的部门");

                if (departmentBLL.DeleteList(idStr))
                    return Success("删除成功");
                return Error("删除失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        /// <summary>
        /// 获取部门列表
        /// </summary>
        /// <returns></returns>
        public ActionResult GetDeptList(int pId = 0)
        {
            if (Request.IsAuthenticated)
            {
                int userId = CurrentUser.UserData.F_UserId;
                Model.T_Sys_UserAccount userModel = new BLL.T_Sys_UserAccount().GetModel(userId);
            
                if (userModel != null)
                    pId = userModel.F_DeptId;
                Model.T_Sys_RoleInfo ro = rolebll.GetModel(userModel.F_RoleId);
                string where = "";
                DataTable dt = new DataTable();
                if (ro != null)
                {
                    if (ro.F_RoleCode == "CLZY")
                        pId=1;
                    else if (ro.F_RoleCode == "ZR")
                        pId = 1;
                    else if (ro.F_RoleCode == "XTGLY")
                        pId = 1;
                }
                if (pId == 2)
                {
                    where = "(isnull(F_DeptId,0)='" + pId + "'or F_Layer=1 ) and F_State=1";
                }
                else if (pId == 421)
                {
                    where = "isnull(F_DeptId,0)='" + 1+ "'and F_State=1";
                 } 
                else
                {
                     where = " isnull(F_DeptId,0)='" + pId + "' and F_State=1 ";
                }

                //if (!string.IsNullOrEmpty(userModel.groupcode))
                //{
                //    where += " and F_GroupCode = '" + userModel.groupcode + "'";
                //}
                if (pId == 0)
                {
                    var strList = RedisHelper.StringGet("ZTreeList_Shuanghui");
                    if (strList != null)
                    {
                        return Success("加载成功", strList.ToString().ToObject<List<Model.TreeModel>>());
                    }
                }
                dt = new BLL.T_Sys_Department().GetList(0, where, " F_Sort asc").Tables[0];
                List<Model.TreeModel> modelList = BindTree(dt, "0");
                if (pId == 0)
                {
                    RedisHelper.StringSet("ZTreeList_Shuanghui", modelList.ToJson());
                }
                if (modelList != null)
                {
                    if (modelList.Count > 0)
                        return Success("加载成功", modelList);
                }
                return Error("加载失败");
            }
            return NoToken("未知错误，请重新登录");
        }

        /// <summary>
        /// tree  树形部门
        /// </summary>
        /// <param name="tab"></param>
        /// <param name="parentid"></param>
        /// <returns></returns>
        private List<Model.TreeModel> BindTree(DataTable tab, string parentid)
        {
            DataTable tab2 = new DataTable();

            if (tab != null && tab.Rows.Count > 0)
            {
                List<Model.T_Sys_Department> categorylist = new BLL.T_Sys_Department().DataTableToList(tab);
                List<Model.TreeModel> modelList = new List<Model.TreeModel>(categorylist.Count);
                for (int i = 0; i < categorylist.Count; i++)
                {
                    Model.TreeModel model = new Model.TreeModel();
                    string currentID = categorylist[i].F_DeptId.ToString();//当前功能ID
                    model.id = currentID;
                    model.IconCls = "";//图标
                    model.text = categorylist[i].F_DeptName;
                    tab2 = new BLL.T_Sys_Department().GetList("F_ParentId=" + currentID + " and F_State=1 order by f_sort").Tables[0];
                    if (tab2 != null && tab2.Rows.Count > 0)
                    {
                        model.children = BindTree(tab2, currentID);
                    }
                    modelList.Add(model);
                }
                return modelList;

            }
            else
            {
                return null;
            }

        }
    }
}