//using CRM.Core.DTO;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;
using System.IO;
using System.Linq;
using System.Text;
using WX.CRM.BLL.Base;
using WX.CRM.Common;
using WX.CRM.DAL;
using WX.CRM.IBLL.Util;
using WX.CRM.Model.Entity;
using WX.CRM.Model.Enum;

namespace WX.CRM.BLL.Util
{
    /// <summary>
    /// 缓存BL
    /// </summary>
    public class CACHE_BL : ICACHE_Q
    {
        #region excel数据导入字典

        /// <summary>
        /// excel数据导入字典
        /// </summary>
        /// <returns></returns>
        public List<BAS_EXCELIMPORTDICT> GetList_ExcelImportDict(EnumExcelDataType excelDataType)
        {
            var list = GetList_ExcelImportDict();
            var typeid = excelDataType.ToString();
            list = list.Where(m => m.TYPEID.Equals(typeid)).OrderBy(m => m.SORTID).ToList();
            //foreach (var item in list)
            //{
            //    item.ColumnIndex = -1;
            //}
            return list;
        }

        /// <summary>
        /// excel数据导入字典
        /// </summary>
        /// <returns></returns>
        public List<BAS_EXCELIMPORTDICT> GetList_ExcelImportDict(EnumExcelDataType excelDataType, decimal isNew)
        {
            var list = GetList_ExcelImportDict();
            var typeid = excelDataType.ToString();
            list = list.Where(m => m.TYPEID.Equals(typeid)).Where(m => m.ISNEW == isNew).OrderBy(m => m.SORTID).ToList();
            //foreach (var item in list)
            //{
            //    item.ColumnIndex = -1;
            //}
            return list;
        }

        public List<BAS_EXCELIMPORTDICT> GetList_ExcelImportDict()
        {
            string cacheKey = "cache_excelImportDict_getList";
            List<BAS_EXCELIMPORTDICT> list;
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<BAS_EXCELIMPORTDICT>>(cacheKey);
            else
                using (var db = new crmContext())
                {
                    list = db.BAS_EXCELIMPORTDICT.ToList();
                    CacheHelper.Set(cacheKey, list);
                }
            return list;
        }

        #endregion excel数据导入字典

        #region excel数据导入类型

        /// <summary>
        /// 获取excel数据导入类型
        /// </summary>
        /// <param name="excelDataType">数据导入类型</param>
        /// <returns></returns>
        public BAS_EXCELIMPORTTYPE GetModel_ExcelImportType(EnumExcelDataType excelDataType)
        {
            //string cacheKey = "cache_excelImportType_getList";
            //List<BAS_EXCELIMPORTTYPE> list;
            //if (CacheHelper.Exists(cacheKey))
            //    list = CacheHelper.Get<List<BAS_EXCELIMPORTTYPE>>(cacheKey);
            //else
            //    using (var db = new qhContext())
            //    {
            //        list = db.BAS_EXCELIMPORTTYPE.ToList();
            //        CacheHelper.Set(cacheKey, list);
            //    }
            //string typeid = excelDataType.ToString();
            //return list.FirstOrDefault(m => m.TYPECODE.Equals(typeid));
            var list = GetList_ExcelImportType();
            var typeid = excelDataType.ToString();
            return list.FirstOrDefault(p => p.TYPECODE.Equals(typeid));
        }

        /// <summary>
        /// 获取excel数据导入类型列表
        /// </summary>
        /// <returns></returns>
        public List<BAS_EXCELIMPORTTYPE> GetList_ExcelImportType()
        {
            string cacheKey = "cache_excelImportType_getList";
            List<BAS_EXCELIMPORTTYPE> list;
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<BAS_EXCELIMPORTTYPE>>(cacheKey);
            else
                using (var db = new crmContext())
                {
                    list = db.BAS_EXCELIMPORTTYPE.ToList();
                    CacheHelper.Set(cacheKey, list);
                }
            return list;
        }

        #endregion excel数据导入类型

        #region 工单样式列表

        /// <summary>
        /// 工单样式列表
        /// </summary>
        /// <returns></returns>
        public List<ORD_MEMOSTYLE> GetList_MemoStyle()
        {
            string cacheKey = "cache_MemoStyle_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<ORD_MEMOSTYLE>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<ORD_MEMOSTYLE> list = db.ORD_MEMOSTYLE.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 工单样式列表

        #region 获取通用数据小类（通过 Model.Enum.ComType查询）

        /// <summary>
        /// 获取通用数据小类
        /// </summary>
        /// <param name="type">Model.Enum.ComType</param>
        /// <returns></returns>
        public List<BAS_SUBCOMTYPE> GetList_SubComType(WX.CRM.Model.Enum.ComType type)
        {
            //string cacheKey1 = "cache_ComType_getList";
            string cacheKey2 = "cache_SubComType_getList";
            //List<Model.Entity.BAS_COMTYPE> comTypeList;
            List<WX.CRM.Model.Entity.BAS_SUBCOMTYPE> subComtypeList;
            //if (CacheHelper.Exists(cacheKey1))
            //    comTypeList = CacheHelper.Get<List<Model.Entity.BAS_COMTYPE>>(cacheKey1);
            //else
            //{
            //    using (Model.Entity.crmContext db = new Model.Entity.crmContext())
            //    {
            //        comTypeList = db.BAS_COMTYPE.ToList();
            //        CacheHelper.Set(cacheKey1, comTypeList);
            //    }
            //}
            if (CacheHelper.Exists(cacheKey2))
                subComtypeList = CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_SUBCOMTYPE>>(cacheKey2);
            else
            {
                using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
                {
                    subComtypeList = db.BAS_SUBCOMTYPE.ToList();
                    CacheHelper.Set(cacheKey2, subComtypeList);
                }
            }
            return subComtypeList.Where(m => m.TYPECODE == type.ToString()).OrderBy(m => m.SUBTYPECODE).ToList();
        }

        public List<BAS_SUBCOMTYPE> GetList_SubComType(string typeCode)
        {
            //string cacheKey1 = "cache_ComType_getList";
            string cacheKey2 = "cache_SubComType_getList";
            //List<Model.Entity.BAS_COMTYPE> comTypeList
            List<WX.CRM.Model.Entity.BAS_SUBCOMTYPE> subComtypeList;
            //if (CacheHelper.Exists(cacheKey1))
            //    comTypeList = CacheHelper.Get<List<Model.Entity.BAS_COMTYPE>>(cacheKey1);
            //else
            //{
            //    using (Model.Entity.crmContext db = new Model.Entity.crmContext())
            //    {
            //        comTypeList = db.BAS_COMTYPE.ToList();
            //        CacheHelper.Set(cacheKey1, comTypeList);
            //    }
            //}
            if (CacheHelper.Exists(cacheKey2))
                subComtypeList = CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_SUBCOMTYPE>>(cacheKey2);
            else
            {
                using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
                {
                    subComtypeList = db.BAS_SUBCOMTYPE.ToList();
                    CacheHelper.Set(cacheKey2, subComtypeList);
                }
            }
            if (!string.IsNullOrWhiteSpace(typeCode))
            {
                return subComtypeList.Where(m => m.TYPECODE == typeCode).ToList();
            }
            return subComtypeList;
        }

        #endregion 获取通用数据小类（通过 Model.Enum.ComType查询）

        #region 角色查询

        /// <summary>
        /// 获取工单小类信息
        /// </summary>
        /// <returns></returns>
        public List<BAS_ROLE> GetList_Role()
        {
            string cacheKey = "cache_Role_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_ROLE>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<BAS_ROLE> list = db.BAS_ROLE.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        /// <summary>
        /// 获取角色编码
        /// </summary>
        /// <param name="roleIds">角色ID数组</param>
        /// <returns></returns>
        public string Get_RoleCodes(decimal[] roleIds)
        {
            List<BAS_ROLE> roleList = GetList_Role().Where(m => roleIds.Contains(m.ROLEID)).ToList();
            StringBuilder codes = new StringBuilder();
            foreach (BAS_ROLE role in roleList)
            {
                codes.AppendFormat("[{0}]", role.CODE);
            }
            return codes.ToString();
        }

        public List<BAS_INNERUSERROLE> GetUserRole()
        {
            var key = "cache_User_Role";
            if (CacheHelper.Exists(key))
                return CacheHelper.Get<List<BAS_INNERUSERROLE>>(key);
            using (var db = new crmContext())
            {
                var list = db.BAS_INNERUSERROLE.ToList();
                CacheHelper.Set(key, list);
                return list;
            }
        }

        /// <summary>
        /// 特殊权限表
        /// </summary>
        /// <returns></returns>
        public List<BAS_RIGHT_LEVEL> GetRightLevel()
        {
            var key = "cache_BAS_RIGHT_LEVEL";
            if (CacheHelper.Exists(key))
                return CacheHelper.Get<List<BAS_RIGHT_LEVEL>>(key);
            using (var db = new crmContext())
            {
                var list = db.BAS_RIGHT_LEVEL.ToList();
                CacheHelper.Set(key, list);
                return list;
            }
        }

        /// <summary>
        /// 特殊权限详细表
        /// </summary>
        /// <returns></returns>
        public List<BAS_RIGHT_LEVEL_DETAIL> GetRightLevelDetail()
        {
            var key = "cache_BAS_RIGHT_LEVEL_DETAIL";
            if (CacheHelper.Exists(key))
                return CacheHelper.Get<List<BAS_RIGHT_LEVEL_DETAIL>>(key);
            using (var db = new crmContext())
            {
                var list = db.BAS_RIGHT_LEVEL_DETAIL.ToList();
                CacheHelper.Set(key, list);
                return list;
            }
        }

        #endregion 角色查询

        #region 获取工单小类信息 （只查询可显示）

        /// <summary>
        /// 获取工单小类信息 （只查询可显示）
        /// </summary>
        /// <returns></returns>
        public List<ORD_MEMOSUBTYPE> GetList_MemoSubType(int type = 1)
        {
            string cacheKey = "cache_MemoSubType_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.ORD_MEMOSUBTYPE>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<ORD_MEMOSUBTYPE> list = null;
                if (type == 0)
                    list = db.ORD_MEMOSUBTYPE.OrderBy(m => m.CTIME).ToList<ORD_MEMOSUBTYPE>();
                else
                    list = db.ORD_MEMOSUBTYPE.Where(m => m.ISSHOW == 1).OrderBy(m => m.CTIME).ToList<ORD_MEMOSUBTYPE>();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取工单小类信息 （只查询可显示）

        #region 获取工单大类（只查询可显示）

        /// <summary>
        /// 获取工单大类（只查询可显示）
        /// </summary>
        /// <returns></returns>
        public List<ORD_MEMOTYPE> GetList_MemoType(int type = 1)
        {
            string cacheKey = "cache_MemoType_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.ORD_MEMOTYPE>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<ORD_MEMOTYPE> list = null;
                if (type == 0)
                    list = db.ORD_MEMOTYPE.OrderBy(m => m.CTIME).ToList<ORD_MEMOTYPE>();
                else
                    list = db.ORD_MEMOTYPE.OrderBy(m => m.CTIME).Where(m => m.ISSHOW == 1).ToList<ORD_MEMOTYPE>();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取工单大类（只查询可显示）

        #region 根据Model.Enum.Parameter 获取参数value

        public string GetValue_Parameter(string key)
        {
            string cacheKey = "cache_Parameter_getList";
            List<WX.CRM.Model.Entity.BAS_PARAMETER> modelist;
            if (CacheHelper.Exists(cacheKey))
                modelist = CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_PARAMETER>>(cacheKey);
            else
            {
                using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
                {
                    modelist = db.BAS_PARAMETER.ToList();
                    CacheHelper.Set(cacheKey, modelist);
                }
            }
            WX.CRM.Model.Entity.BAS_PARAMETER model = modelist.FirstOrDefault(m => m.PARAKEY == key);
            if (model == null)
                return "";
            return model.PARAVALUE;
        }

        /// <summary>
        /// 根据Model.Enum.Parameter 获取参数value
        /// </summary>
        /// <returns></returns>
        public string GetValue_Parameter(WX.CRM.Model.Enum.Parameter key)
        {
            string cacheKey = "cache_Parameter_getList";
            List<WX.CRM.Model.Entity.BAS_PARAMETER> modelist;
            if (CacheHelper.Exists(cacheKey))
                modelist = CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_PARAMETER>>(cacheKey);
            else
            {
                using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
                {
                    modelist = db.BAS_PARAMETER.ToList();
                    CacheHelper.Set(cacheKey, modelist);
                }
            }
            WX.CRM.Model.Entity.BAS_PARAMETER sysConfig = modelist.FirstOrDefault(m => m.PARAKEY == "Sys_Environment_DeptCode");
            WX.CRM.Model.Entity.BAS_PARAMETER model = modelist.FirstOrDefault(m => m.PARAKEY == key.ToString() && m.DEPTCDOE == sysConfig.PARAVALUE);
            if (model == null)
                model = modelist.FirstOrDefault(m => m.PARAKEY == key.ToString() && (m.DEPTCDOE == "" || m.DEPTCDOE == null));
            if (model == null)
                return "";
            return model.PARAVALUE;
        }

        /// <summary>
        /// 根据系统参数分类获取系统参数列表
        /// </summary>
        /// <param name="type">系统参数分类</param>
        /// <returns></returns>
        public List<BAS_PARAMETER> GetList_Parameter(WX.CRM.Model.Enum.ParameterGroup type)
        {
            string cacheKey = "cache_Parameter_getList";
            List<WX.CRM.Model.Entity.BAS_PARAMETER> modelist;
            if (CacheHelper.Exists(cacheKey))
                modelist = CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_PARAMETER>>(cacheKey);
            else
            {
                using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
                {
                    modelist = db.BAS_PARAMETER.ToList();
                    CacheHelper.Set(cacheKey, modelist);
                }
            }
            List<WX.CRM.Model.Entity.BAS_PARAMETER> list = modelist.Where(m => m.GROUPID.Trim() == type.ToString().Trim()).ToList();
            return list;
        }

        /// <summary>
        /// 根据参数分类和参数值获取参数名
        /// </summary>
        /// <param name="paravalue">参数值</param>
        /// <param name="type">参数分类</param>
        /// <returns></returns>
        public string GetParaNameByParavalue(string paravalue, ParameterGroup type)
        {
            string cacheKey = "cache_Parameter_getParaNameByParavalue";
            List<BAS_PARAMETER> modelist;
            if (CacheHelper.Exists(cacheKey))
                modelist = CacheHelper.Get<List<BAS_PARAMETER>>(cacheKey);
            else
            {
                using (crmContext db = new crmContext())
                {
                    modelist = db.BAS_PARAMETER.ToList();
                    CacheHelper.Set(cacheKey, modelist);
                }
            }
            string sss = paravalue.Trim();
            BAS_PARAMETER model = modelist.FirstOrDefault(m => m.PARAVALUE == sss && m.GROUPID == type.ToString());
            if (model == null)
                return "";
            return model.PARANAME;
        }

        #endregion 根据Model.Enum.Parameter 获取参数value

        #region 获取公司业务列表

        /// <summary>
        /// 获取公司业务列表
        /// </summary>
        /// <returns></returns>
        public List<WX.CRM.Model.Entity.BAS_BUSINESS> GetList_Business()
        {
            string cacheKey = "cache_Business_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_BUSINESS>>(cacheKey);
            using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
            {
                var list = db.BAS_BUSINESS.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取公司业务列表

        #region 获取内部公司列表 cache_Company_getList

        /// <summary>
        /// 获取公司列表
        /// </summary>
        /// <returns></returns>
        public List<WX.CRM.Model.Entity.BAS_COMPANY> GetList_innerCompany()
        {
            string cacheKey = "cache_Company_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_COMPANY>>(cacheKey);
            using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
            {
                List<WX.CRM.Model.Entity.BAS_COMPANY> list = db.BAS_COMPANY.Where(m => m.ISOUTERAGENT == 0).OrderBy(m => m.CTIME).ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取内部公司列表 cache_Company_getList

        #region 获取销售组树形 cache_InnerGroup_getTreeList

        /// <summary>
        /// 获取销售组树形
        /// </summary>
        /// <returns></returns>
        public object GetTreeList_InnerGroup_Old()
        {
            string cacheKey = "cache_InnerGroup_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<WX.CRM.Model.Entity.BAS_COMPANY> companyList = db.BAS_COMPANY.OrderBy(m => m.CTIME).ToList();
                List<WX.CRM.Model.Entity.BAS_SALESDEPARTMENT> salesDeptList = db.BAS_SALESDEPARTMENT.OrderBy(m => m.CREATIONDATE).ToList();
                List<WX.CRM.Model.Entity.BAS_INNERGROUP> innerGroupList = db.BAS_INNERGROUP.OrderBy(m => m.CTIME).ToList();
                List<object> obj = new List<object>();
                List<object> childObj = null;
                List<object> groupObj = null;
                int i = 0;
                int j = 0;
                foreach (WX.CRM.Model.Entity.BAS_COMPANY model in companyList)
                {
                    childObj = new List<object>();
                    j = 0;
                    foreach (WX.CRM.Model.Entity.BAS_SALESDEPARTMENT saleDpt in salesDeptList.Where(m => m.COMPANYID == model.COMPANYID))
                    {
                        groupObj = new List<object>();
                        foreach (WX.CRM.Model.Entity.BAS_INNERGROUP inGrp in innerGroupList.Where(x => x.SALEDEPTID == saleDpt.SALEDEPTID))
                        {
                            groupObj.Add(new { id = inGrp.GID, text = inGrp.GNAME, attributes = inGrp.DEPTID, iconCls = "icon-redmini" });
                        }
                        childObj.Add(new { id = "sale_" + saleDpt.SALEDEPTID, state = (groupObj.Count == 0 || j == 0 ? "open" : "closed"), text = saleDpt.DEPTNAME, children = groupObj.Count == 0 ? null : groupObj });
                        j++;
                    }
                    obj.Add(new { id = "com_" + model.COMPANYID, state = (childObj.Count == 0 || i == 0 ? "open" : "closed"), text = model.COMPANYNAME, children = childObj.Count == 0 ? null : childObj });
                    i++;
                }
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        /// <summary>
        /// 获取新销售组树形 1 全部 2 业务部门 3 其他部门
        /// </summary>
        /// <returns></returns>
        public object GetTreeList_InnerGroup(bool hasUser = false, string filter = "")
        {
            string cacheKey = $"cache_InnerGroup_getTreeList{hasUser}{filter}";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            List<object> objList = new List<object>();
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<WX.CRM.Model.Entity.BAS_SALESDEPARTMENT> salesDeptList = db.BAS_SALESDEPARTMENT.Where(n => n.IS_DELETED != 1).ToList();
                List<WX.CRM.Model.Entity.BAS_INNERGROUP> innerGroupList = db.BAS_INNERGROUP.Where(n => n.IS_DELETED != 1).ToList();
                List<BAS_INNERUSER> innerUserList = db.BAS_INNERUSER.ToList();
                List<BAS_INNERUSERGROUP> userDeptList = db.BAS_INNERUSERGROUP.ToList();
                var firstNodeList = salesDeptList.Where(n => n.DEPARTMENT_PARENTID == 0 || n.DEPARTMENT_PARENTID == null).ToList();
                var i = 0;
                foreach (var saleDpt in firstNodeList)
                {
                    var obj = new DropModel
                    {
                        id = "sale_" + saleDpt.SALEDEPTID,
                        state = "open",
                        text = saleDpt.DEPTNAME,
                        children = null,
                        isspecial = saleDpt.IS_PROFESSION,
                        iconCls = "icon-deptmini",
                        relateId = saleDpt.DEPARTMENT_ID,
                        orginId = saleDpt.SALEDEPTID,
                        filterId = new List<decimal> { saleDpt.SALEDEPTID },
                        type = 1
                    };
                    BuildChildNode(innerUserList, userDeptList, salesDeptList, innerGroupList, obj, i++, hasUser, filter);
                    objList.Add(obj);
                }
                if (!string.IsNullOrWhiteSpace(filter))
                {
                    List<decimal> filterIdList = new List<decimal>();
                    filterIdList.AddRange(innerUserList.Where(n => n.EID.ToString().Contains(filter) || n.UNAME.Contains(filter)).Select(n => n.PKID));
                    filterIdList.AddRange(salesDeptList.Where(n => n.DEPTNAME.ToString().Contains(filter)).Select(n => n.SALEDEPTID));
                    filterIdList.AddRange(innerGroupList.Where(n => n.GNAME.ToString().Contains(filter)).Select(n => n.GID));
                    foreach (var item in objList)
                    {
                        BuildFilterTree((DropModel)item, filterIdList);
                    }
                }
                //CacheHelper.Set(cacheKey, objList);
                return objList;
            }
        }

        public void BuildFilterTree(DropModel qobject, List<decimal> filterIdList)
        {
            var childRen = qobject.children;
            if (childRen == null)
            {
                return;
            }
            List<DropModel> child = new List<DropModel>();
            foreach (var c in childRen)
            {
                var isCantain = false;
                foreach (var filter in filterIdList)
                {
                    if (c.filterId.Contains(filter))
                    {
                        isCantain = true;
                        break;
                    }
                }
                if (isCantain)
                {
                    qobject.state = "open";
                    child.Add(c);
                    BuildFilterTree(c, filterIdList);
                }
            }
            qobject.children = child;
        }

        /// <summary>
        /// 递归 构建 树形结构 todo 要是数据不合法可能会有死循环出现
        /// </summary>
        /// <param name="salesDeptList"></param>
        /// <param name="innerGroupList"></param>
        /// <param name="qobject"></param>
        /// <param name="deptId"></param>
        /// <param name="i"></param>
        public static void BuildChildNode(List<BAS_INNERUSER> innerUserList, List<BAS_INNERUSERGROUP> userDeptList, List<BAS_SALESDEPARTMENT> salesDeptList,
            List<BAS_INNERGROUP> innerGroupList, DropModel qobject, int i, bool hasUser, string filter)
        {
            if (qobject.relateId == null)
            {
                return;
            }
            var childList = salesDeptList.Where(n => n.DEPARTMENT_PARENTID == qobject.relateId).OrderBy(n => n.DEPARTMENT_SORT).ToList();
            //if (i == 0 && qobject.id.Contains("sale_"))
            //{
            //    qobject.state = "open";
            //}
            if (i == 0 || i == 1)
            {
                qobject.state = "open";
            }
            var j = 0;
            foreach (var c in childList)
            {
                if (qobject.children == null)
                {
                    qobject.children = new List<DropModel>();
                }
                var cObject = new DropModel
                {
                    id = "sale_" + c.SALEDEPTID,
                    state = "closed",
                    text = c.DEPTNAME,
                    iconCls = "icon-otherdeptmini",
                    children = null,
                    isspecial = c.IS_PROFESSION,
                    relateId = c.DEPARTMENT_ID,
                    orginId = c.SALEDEPTID,
                    filterId = new List<decimal> { c.SALEDEPTID },
                    type = 1
                };

                BuildChildNode(innerUserList, userDeptList, salesDeptList, innerGroupList, cObject, j++, hasUser, filter);
                qobject.children.Add(cObject);
            }
            var groupList = innerGroupList.Where(n => n.SALEDEPTID == Convert.ToDecimal(qobject.id.Replace("sale_", ""))).OrderBy(n => n.DEPARTMENT_SORT).ToList();
            List<DropModel> gchildList = new List<DropModel>();
            foreach (var g in groupList)
            {
                if (qobject.children == null)
                {
                    qobject.children = new List<DropModel>();
                }
                var id = g.GID.ToString();
                if (hasUser)
                {
                    id = "sale_" + g.GID;
                }
                var cObject = new DropModel
                {
                    id = id,
                    text = g.GNAME,
                    state = "closed",
                    attributes = g.DEPTID.ToString(),
                    iconCls = "icon-groupmini",
                    isspecial = g.IS_PROFESSION,
                    orginId = g.GID,
                    relateId = g.GID,
                    filterId = new List<decimal> { g.GID },
                    type = 2
                };
                if (hasUser)
                {
                    BuildUserList(innerUserList, userDeptList, g.GID, cObject);
                }
                if (cObject.children == null || cObject.children.Count() == 0)
                {
                    cObject.state = null;
                }
                qobject.children.Add(cObject);
            }
            if (qobject.children != null)
            {
                var specialList = qobject.children.Where(n => n.isspecial == null || n.isspecial == 1 || n.isspecial == 3).ToList();
                var commonList = qobject.children.Where(n => (n.isspecial != null && n.isspecial == 0) || n.isspecial == 3).ToList();
                if (commonList.Count > 0)
                {
                    qobject.isspecial = 0;
                }
                if (specialList.Count > 0)
                {
                    qobject.isspecial = 1;
                }
                if (commonList.Count > 0 && specialList.Count > 0)
                {
                    qobject.isspecial = 3;
                }
            }
            if (qobject.isspecial > 0 && qobject.type == 1)
            {
                qobject.iconCls = "icon-deptmini";
            }
            if (hasUser)
            {
                BuildUserList(innerUserList, userDeptList, Convert.ToDecimal(qobject.id.Replace("sale_", "")), qobject);
            }
            if (qobject.children != null)
            {
                qobject.children = qobject.children.OrderByDescending(n => n.isspecial).ToList();
                var childFilter = qobject.children.Select(n => n.filterId).ToList();
                foreach (var f in childFilter)
                {
                    qobject.filterId.AddRange(f);
                }
            }
            else
            {
                qobject.state = "open";
            }
            if (qobject.children == null || qobject.children.Count() == 0)
            {
                qobject.state = null;
            }
        }

        private static void BuildUserList(List<BAS_INNERUSER> innerUserList, List<BAS_INNERUSERGROUP> userDeptList, decimal? deptId, DropModel qobject)
        {
            var res = new List<DropModel>();
            var employeeIds = userDeptList.Where(n => (n.DEPTID == deptId && n.GID == null) || n.GID == deptId).Select(n => n.INNERUSERID).ToList();
            var childUserList = innerUserList.Where(x => x.EMPLOYEE_ID != null && employeeIds.Contains(x.PKID)).ToList();
            foreach (var u in childUserList)
            {
                var cObject = new DropModel
                {
                    id = u.PKID.ToString(),
                    text = u.UNAME,
                    iconCls = "icon-usermini",
                    children = null,
                    orginId = u.PKID,
                    filterId = new List<decimal> { u.PKID },
                    type = 3
                };
                res.Add(cObject);
            }
            if (res.Count > 0)
            {
                if (qobject.children == null)
                {
                    qobject.children = new List<DropModel>();
                }
                qobject.children.AddRange(res);
                qobject.filterId.AddRange(qobject.children.Select(n => n.orginId).ToList());
            }
        }

        #endregion 获取销售组树形 cache_InnerGroup_getTreeList

        #region 获取销售组树形(只显示销售组) cache_InnerGroup_getTreeList

        /// <summary>
        /// 获取销售组树形（去除系统组和隐藏组）
        /// </summary>
        /// <returns></returns>
        public object GetTreeListIsSale_InnerGroup()
        {
            string cacheKey = "cache_InnerGroupIsSale_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                WX.CRM.Model.Entity.BAS_COMPANY companyList = db.BAS_COMPANY.OrderBy(m => m.COMPANYID).FirstOrDefault();
                List<WX.CRM.Model.Entity.BAS_SALESDEPARTMENT> salesDeptList = db.BAS_SALESDEPARTMENT.ToList();
                List<WX.CRM.Model.Entity.BAS_INNERGROUP> innerGroupList = db.BAS_INNERGROUP.Where(m => m.ISSALEDEPT == 1).ToList();
                List<object> obj = new List<object>();
                List<object> childObj = null;
                List<object> groupObj = null;
                int i = 0;
                int j = 0;

                childObj = new List<object>();
                j = 0;
                foreach (WX.CRM.Model.Entity.BAS_SALESDEPARTMENT saleDpt in salesDeptList.Where(m => m.COMPANYID == companyList.COMPANYID))
                {
                    groupObj = new List<object>();
                    foreach (WX.CRM.Model.Entity.BAS_INNERGROUP inGrp in innerGroupList.Where(x => x.SALEDEPTID == saleDpt.SALEDEPTID))
                    {
                        groupObj.Add(new { id = inGrp.GID, text = inGrp.GNAME, attributes = inGrp.DEPTID, iconCls = "icon-redmini" });
                    }
                    childObj.Add(new { id = "sale_" + saleDpt.SALEDEPTID, state = (groupObj.Count == 0 || j == 0 ? "open" : "closed"), text = saleDpt.DEPTNAME, children = groupObj.Count == 0 ? null : groupObj });
                    j++;
                }
                obj.Add(new { id = "com_" + companyList.COMPANYID, state = (childObj.Count == 0 || i == 0 ? "open" : "closed"), text = companyList.COMPANYNAME, children = childObj.Count == 0 ? null : childObj });
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        #endregion 获取销售组树形(只显示销售组) cache_InnerGroup_getTreeList

        #region 获取销售部树形结构  cache_saleDepartMent_getTreeList
        /// <summary>
        /// 旧的层级关系
        /// </summary>
        /// <returns></returns>

        public object GetTreeList_saleDepartMent_Old()
        {
            string cacheKey = "cache_saleDepartMent_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<BAS_COMPANY> companyList = db.BAS_COMPANY.ToList();
                List<BAS_SALESDEPARTMENT> salesDeptList = db.BAS_SALESDEPARTMENT.ToList();
                List<object> obj = new List<object>();
                foreach (BAS_COMPANY model in companyList)
                {
                    obj.Add(new { id = "-" + model.COMPANYID, text = model.COMPANYNAME, children = GetTreeChildList_old(salesDeptList, model.COMPANYID) });
                }
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        private List<object> GetTreeChildList_old(List<BAS_SALESDEPARTMENT> salesDeptList, decimal companyId)
        {
            List<object> obj = new List<object>();
            foreach (BAS_SALESDEPARTMENT model in salesDeptList.Where(m => m.COMPANYID == companyId))
            {
                obj.Add(new { id = model.SALEDEPTID, text = model.DEPTNAME });
            }
            return obj;
        }

        /// <summary>
        /// 新树形结构
        /// </summary>
        /// <returns></returns>
        public object GetTreeList_saleDepartMent()
        {
            string cacheKey = "cache_saleDepartMent_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<BAS_SALESDEPARTMENT> salesDeptList = db.BAS_SALESDEPARTMENT.Where(n => n.IS_DELETED != 1).ToList();
                var companyList = salesDeptList.Where(n => n.DEPARTMENT_PARENTID == 0 || n.DEPARTMENT_PARENTID == null).ToList();
                List<object> obj = new List<object>();
                foreach (BAS_SALESDEPARTMENT model in companyList)
                {
                    obj.Add(new { id = "-" + model.SALEDEPTID, text = model.DEPTNAME, children = GetTreeChildList(salesDeptList, model.DEPARTMENT_ID) });
                }
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        private List<object> GetTreeChildList(List<BAS_SALESDEPARTMENT> salesDeptList, decimal? companyId)
        {
            List<object> obj = new List<object>();
            if (companyId == null)
            {
                return obj;
            }
            foreach (BAS_SALESDEPARTMENT model in salesDeptList.Where(m => m.DEPARTMENT_PARENTID == companyId))
            {
                obj.Add(new { id = model.SALEDEPTID, text = model.DEPTNAME, children = GetTreeChildList(salesDeptList, model.DEPARTMENT_ID) });
            }
            return obj;
        }

        public Dictionary<decimal?, string> BuildDepartMentShowText(List<decimal?> deptIdList)
        {
            deptIdList = deptIdList.Where(n => n.HasValue).Distinct().ToList();
            Dictionary<decimal?, string> result = new Dictionary<decimal?, string>();
            using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
            {
                List<WX.CRM.Model.Entity.BAS_SALESDEPARTMENT> salesDeptList = db.BAS_SALESDEPARTMENT.Where(n => n.IS_DELETED != 1).ToList();
                foreach (var deptId in deptIdList)
                {
                    var res = BuildParentDepartMentShow(deptId, salesDeptList, "");
                    result.Add(deptId, res.Trim('/'));
                }
                return result;
            }
        }

        public string BuildParentDepartMentShow(decimal? depetId, List<WX.CRM.Model.Entity.BAS_SALESDEPARTMENT> salesDeptList, string str)
        {
            if (depetId == null)
            {
                return str;
            }
            var parentDept = salesDeptList.Where(n => n.DEPARTMENT_ID == depetId).FirstOrDefault();
            if (parentDept != null)
            {
                str = $"{parentDept.DEPTNAME}/{str}";
                return BuildParentDepartMentShow(parentDept.DEPARTMENT_PARENTID, salesDeptList, str);
            }
            return str;
        }

        #endregion 获取销售部树形结构  cache_saleDepartMent_getTreeList

        #region 获取tree数据列表  cache_innerDepartment_getTreeList

        /// <summary>
        /// 获取tree数据列表(type可以传空，默认折叠部分节点，传1不折叠)
        /// </summary>
        /// <returns></returns>
        public object GetTreeList_innerDepartment(string type)
        {
            string cacheKey = "cache_innerDepartment_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);

            using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
            {
                List<WX.CRM.Model.Entity.BAS_INNERDEPARTMENT> innerDepartment = db.BAS_INNERDEPARTMENT.ToList();
                List<object> obj = new List<object>();
                obj.Add(new { id = 0, text = "公司部门", children = GetTreeChildList(type, innerDepartment, 0) });
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        /// <summary>
        /// 获取子节点
        /// </summary>
        /// <param name="innerDepartment"></param>
        /// <param name="parentId"></param>
        /// <returns></returns>
        private object GetTreeChildList(string type, List<WX.CRM.Model.Entity.BAS_INNERDEPARTMENT> innerDepartment, decimal parentId)
        {
            List<object> obj = null;
            object childObj = null;
            object grandchildObj = null;
            int i = 0;
            bool isClosed = true;
            if (!string.IsNullOrWhiteSpace(type) && type == "1")
            {
                isClosed = false;
            }

            foreach (WX.CRM.Model.Entity.BAS_INNERDEPARTMENT model in innerDepartment.FindAll(m => m.PARENTID == parentId))
            {
                if (obj == null)
                    obj = new List<object>();
                grandchildObj = GetTreeChildList(type, innerDepartment, model.DEPTID);
                if (grandchildObj != null)
                    childObj = new { id = model.DEPTID, state = i == 0 ? "open" : "closed", text = model.DEPTNAME, children = grandchildObj };
                else
                    childObj = new { id = model.DEPTID, text = model.DEPTNAME, children = grandchildObj };
                obj.Add(childObj);
                if (isClosed)
                    i++;
            }
            return obj;
        }

        #endregion 获取tree数据列表  cache_innerDepartment_getTreeList

        #region 获取部门信息

        /// <summary>
        /// 获取部门信息
        /// </summary>
        /// <returns></returns>
        public Dictionary<decimal, string> GetDictionary_InnerDepartMent()
        {
            string cacheKey = "cache_InnerDepartMent_getDic";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<Dictionary<decimal, string>>(cacheKey);
            using (WX.CRM.Model.Entity.crmContext db = new crmContext())
            {
                List<BAS_INNERDEPARTMENT> list = db.BAS_INNERDEPARTMENT.ToList();
                Dictionary<decimal, string> dic = new Dictionary<decimal, string>();
                foreach (var model in list)
                {
                    dic.Add(model.DEPTID, model.DEPTNAME);
                }
                CacheHelper.Set(cacheKey, dic);
                return dic;
            }
        }

        #endregion 获取部门信息

        #region 获取tree数据列表(包括了挂在部门里面的销售组) cache_DeptGroup_getTreeList

        /// <summary>
        /// 获取tree数据列表
        /// </summary>
        /// <returns></returns>
        public object GetDeptGroupTreeList_DeptGroup()
        {
            string cacheKey = "cache_DeptGroup_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
            {
                List<WX.CRM.Model.Entity.BAS_INNERDEPARTMENT> innerDepartment = db.BAS_INNERDEPARTMENT.ToList();
                List<WX.CRM.Model.Entity.BAS_INNERGROUP> innerGroup = db.BAS_INNERGROUP.ToList();
                List<object> obj = new List<object>();
                obj.Add(new { id = 0, text = "公司部门", children = GetDeptGroupTreeChildList(innerDepartment, innerGroup, 0) });
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        /// <summary>
        /// 获取子节点
        /// </summary>
        /// <param name="innerDepartment"></param>
        /// <param name="parentId"></param>
        /// <returns></returns>
        private object GetDeptGroupTreeChildList(List<WX.CRM.Model.Entity.BAS_INNERDEPARTMENT> innerDepartment, List<WX.CRM.Model.Entity.BAS_INNERGROUP> innerGroup, decimal parentId)
        {
            List<object> obj = null;
            object childObj = null;
            object grandchildObj = null;
            int i = 0;
            foreach (WX.CRM.Model.Entity.BAS_INNERDEPARTMENT model in innerDepartment.FindAll(m => m.PARENTID == parentId))
            {
                if (obj == null)
                    obj = new List<object>();
                grandchildObj = GetDeptGroupTreeChildList(innerDepartment, innerGroup, model.DEPTID);
                if (grandchildObj != null)
                    childObj = new { id = model.DEPTID, state = i == 0 ? "open" : "closed", text = model.DEPTNAME, children = grandchildObj };
                else
                    childObj = new { id = model.DEPTID, text = model.DEPTNAME, children = grandchildObj };
                obj.Add(childObj);
                i++;
            }
            foreach (WX.CRM.Model.Entity.BAS_INNERGROUP model in innerGroup.FindAll(m => m.DEPTID == parentId))
            {
                if (obj == null)
                    obj = new List<object>();
                obj.Add(new { id = "g_" + model.SALEDEPTID, text = model.GNAME, iconCls = "icon-redmini" });
            }
            return obj;
        }

        #endregion 获取tree数据列表(包括了挂在部门里面的销售组) cache_DeptGroup_getTreeList

        #region 获取短信类型

        public List<SMS_MSGTYPE> GetSmsTypeList()
        {
            string cacheKey = "cache_smsTypeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<SMS_MSGTYPE>>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<SMS_MSGTYPE> msgType = db.SMS_MSGTYPE.ToList();
                CacheHelper.Set(cacheKey, msgType);
                return msgType;
            }
        }

        /// <summary>
        /// 获取短信类型 树形
        /// </summary>
        /// <returns></returns>
        public object GetSmsTypeTreeList()
        {
            string cacheKey = "cache_smsType_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<SMS_MSGTYPE> msgType = db.SMS_MSGTYPE.ToList();
                List<SMS_MSGSUBTYPE> msgSubType = db.SMS_MSGSUBTYPE.ToList();
                var obj = new List<object>();
                foreach (var model in msgType)
                {
                    obj.Add(new { id = "-" + model.TYPECODE, text = model.TYPENAME, children = GetSmsTypeTreeChildList(msgSubType, model.TYPECODE) });
                }
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        /// <summary>
        /// 获取短信crm短信类型  树形（根据短信大类）
        /// </summary>
        /// <param name="typeCode">短信大类</param>
        /// <returns></returns>
        public object GetSmsCrmTreeList()
        {
            string cacheKey = "cache_smsCrmType_getTreeList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<object>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<SMS_MSGTYPE> msgType = db.SMS_MSGTYPE.Where(m => m.TYPECODE == "CRMSMS0001").ToList();
                List<SMS_MSGSUBTYPE> msgSubType = db.SMS_MSGSUBTYPE.ToList();
                var obj = new List<object>();
                foreach (var model in msgType)
                {
                    obj.Add(new { id = "-" + model.TYPECODE, text = model.TYPENAME, children = GetSmsTypeTreeChildList(msgSubType, model.TYPECODE) });
                }
                CacheHelper.Set(cacheKey, obj);
                return obj;
            }
        }

        private List<object> GetSmsTypeTreeChildList(List<SMS_MSGSUBTYPE> msgSubType, string parentId)
        {
            var obj = new List<object>();
            foreach (var model in msgSubType.Where(m => m.TYPECODE == parentId))
            {
                obj.Add(new { id = model.SUBTYPEID, typeCode = model.TYPECODE, subTypeCode = model.SUBTYPECODE, text = model.SUBTYPENAME });
            }
            return obj;
        }

        #endregion 获取短信类型

        #region 员工

        public Dictionary<decimal, string> GetList_Inneruser()
        {
            string cacheKey = "cache_Inneruser_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<Dictionary<decimal, string>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                Dictionary<decimal, string> dic = new Dictionary<decimal, string>();
                List<BAS_INNERUSER> list = db.BAS_INNERUSER.ToList();
                foreach (var item in list)
                {
                    dic.Add(item.PKID, item.EID.ToString() + "-" + item.UNAME);
                }
                CacheHelper.Set(cacheKey, dic);
                return dic;
            }
        }

        public List<BAS_INNERUSER> GetUserList()
        {
            var cacheKey = "cache_user_list";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_INNERUSER>>(cacheKey);
            using (var db = new crmContext())
            {
                var list = db.BAS_INNERUSER.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        public IList<IDictionary<string, object>> GetUserNameAndIdList()
        {
            IList<IDictionary<string, object>> res = new List<IDictionary<string, object>>();
            var cacheKey = "cache_select_showbox_list";
            if (!CacheHelper.TryGet(cacheKey, ref res))
            {
                res = new List<IDictionary<string, object>>();
                using (var db = new crmContext())
                {
                    var list = db.BAS_INNERUSER.ToList();
                    foreach (var item in list)
                    {
                        IDictionary<string, object> r = new Dictionary<string, object>();
                        r.Add("uname", item.UNAME);
                        r.Add("eid", item.EID);
                        res.Add(r);
                    }
                    CacheHelper.Set(cacheKey, res);
                }
            }
            return res;
        }

        #endregion 员工
        #region 组

        public List<BAS_INNERGROUP> GetGroupList()
        {
            var cacheKey = "cache_group_list";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_INNERGROUP>>(cacheKey);
            using (var db = new crmContext())
            {
                var list = db.BAS_INNERGROUP.OrderBy(m => m.CTIME).ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 组
        #region 员工组关系

        /// <summary>
        /// 员工组关系
        /// </summary>
        /// <returns></returns>
        public List<BAS_INNERUSERGROUP> GetList_InnerUserGroup()
        {
            string cacheKey = "cache_InnerUserGroup_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_INNERUSERGROUP>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<BAS_INNERUSERGROUP> list = db.BAS_INNERUSERGROUP.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        /// <summary>
        /// 根据 组获取员工ID
        /// </summary>
        /// <param name="groups"></param>
        /// <returns></returns>
        public string GetUserIds_ByGorups(string groups)
        {
            List<BAS_INNERUSERGROUP> list = null;
            if (string.IsNullOrWhiteSpace(groups))
                list = GetList_InnerUserGroup();//group为空返回所有
            else
            {
                decimal[] groupdIds = OperationUtil.ConvertToDecimal(groups.Trim().Split(','));
                list = GetList_InnerUserGroup().Where(m => groupdIds.Contains(m.GID.Value)).ToList();
            }

            string ids = "-1";
            foreach (var item in list)
            {
                ids += "," + item.INNERUSERID;
            }
            return ids;
        }

        #endregion 员工组关系

        #region 销售部列表

        public List<BAS_SALESDEPARTMENT> GetList_SalesDepartMent()
        {
            string cacheKey = "cache_SalesDepartMent_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_SALESDEPARTMENT>>(cacheKey);
            using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
            {
                var list = db.BAS_SALESDEPARTMENT.OrderBy(m => m.CREATIONDATE).ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 销售部列表

        #region 菜单缓存

        /// <summary>
        /// 菜单缓存
        /// </summary>
        /// <returns></returns>
        public List<BAS_LEFTMEMU> GetList_LeftMemu()
        {
            string cacheKey = "cache_LeftMemu_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_LEFTMEMU>>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                var list = db.BAS_LEFTMEMU.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        /// <summary>
        /// 模块导航菜单缓存
        /// </summary>
        /// <returns></returns>
        public List<BAS_MODULEMENU> GetList_ModuleMenu()
        {
            string cacheKey = "cache_ModuleMenu_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_MODULEMENU>>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                var list = db.BAS_MODULEMENU.OrderBy(m => m.SORTID).ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 菜单缓存

        #region 获取软件活动信息

        /// <summary>
        /// 获取软件活动信息
        /// </summary>
        /// <returns></returns>
        public List<SOFT_ACTIVE> GetList_SoftProduct()
        {
            string cacheKey = "cache_softproduct_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.SOFT_ACTIVE>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<SOFT_ACTIVE> list = db.SOFT_ACTIVE.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取软件活动信息

        #region 桌面信息缓存

        /// <summary>
        /// 获取最新开户信息（五分钟过期）
        /// </summary>
        /// <param name="userId">根据用户来存储</param>
        /// <returns></returns>
        public List<CSVR_MSGOPENACCOUNT> GetNewOpenAccountList(decimal userId)
        {
            string cacheKey = "cache_msgOpenAccountList" + userId.ToString();
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<CSVR_MSGOPENACCOUNT>>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<CSVR_MSGOPENACCOUNT> list = db.CSVR_MSGOPENACCOUNT.Where(m => m.SALESID == userId).OrderByDescending(m => m.CTIME).Take(10).ToList();

                CacheHelper.Set(cacheKey, list, DateTime.Now.AddMinutes(5), false);
                return list;
            }
        }

        /// <summary>
        /// 获取最近通话记录（五分钟过期）
        /// </summary>
        /// <param name="eid">用户工号</param>
        /// <returns></returns>
        public List<CSVR_CALLINLOG> GetCallInLogList(decimal eid)
        {
            string cacheKey = "cache_callInLogList" + eid.ToString();
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<CSVR_CALLINLOG>>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<CSVR_CALLINLOG> list = db.CSVR_CALLINLOG.Where(m => m.SALESEID == eid).OrderByDescending(m => m.CTIME).Take(10).ToList();
                CacheHelper.Set(cacheKey, list, DateTime.Now.AddMinutes(5), false);
                return list;
            }
        }

        /// <summary>
        /// 获取最近通话记录（五分钟过期）
        /// </summary>
        /// <param name="eid">用户工号</param>
        /// <returns></returns>
        public List<CSVR_TODAYRECORD> GetCallLogList(decimal eid)
        {
            string cacheKey = "cache_callLogList" + eid.ToString();
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<CSVR_TODAYRECORD>>(cacheKey);
            using (var db = new WX.CRM.Model.Entity.crmContext())
            {
                List<CSVR_TODAYRECORD> list = db.CSVR_TODAYRECORD.Where(m => m.SALESEID == eid).OrderByDescending(m => m.CTIME).Take(10).ToList();
                CacheHelper.Set(cacheKey, list, DateTime.Now.AddMinutes(5), false);
                return list;
            }
        }

        #endregion 桌面信息缓存

        #region l2 产品

        public List<L2Soft_ProductDetail> GetProductDetail()
        {
            string cacheKey = "cache_L2SoftProduct_getList";
            List<L2Soft_ProductDetail> list;
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<L2Soft_ProductDetail>>(cacheKey);
            else
                using (crmContext db = new crmContext())
                {
                    var queryData = (from a in db.L2_SOFT_BIGPRODUCT
                                     select new L2Soft_ProductDetail()
                                     {
                                         PRODUCTID = a.PRODUCTID,
                                         PRODUCTCODE = a.PRODUCTCODE,
                                         PRODUCTNAME = a.PRODUCTNAME,
                                         ISDISABLED = a.ISDISABLED,
                                         USECLIENT = a.USECLIENT,
                                         GROUPID = a.GROUPID,
                                         softProduct = (from b in db.L2_SOFT_PRODUCT
                                                        where b.BIGPRODUCTID == a.PRODUCTID
                                                        select new L2Soft_Product()
                                                        {
                                                            PRODUCTID = b.PRODUCTID,
                                                            PRODUCTCODE = b.PRODUCTCODE,
                                                            PRODUCTNAME = b.PRODUCTNAME,
                                                            PRICE = b.PRICE,
                                                            DAYS = b.DAYS,
                                                            ISDISABLED = b.ISDISABLED,
                                                            softModule = (from c in db.L2_SOFT_PRODUCTMODULE
                                                                          join d
                                                                              in db.L2_SOFT_MODULE on c.MODULEID equals d.MODULEID
                                                                          where c.PRODUCTID == b.PRODUCTID
                                                                          select new L2Soft_Module()
                                                                          {
                                                                              MODULEID = d.MODULEID,
                                                                              MODULENAME = d.MODULENAME,
                                                                              DEFAULTDAYS = d.DEFAULTDAYS
                                                                          })
                                                        })
                                     }
                           );
                    list = queryData.ToList();
                }
            return list;
        }

        /// <summary>
        /// L2产品大类
        /// </summary>
        /// <returns></returns>
        public List<L2_SOFT_BIGPRODUCT> GetBigProductList()
        {
            List<L2_SOFT_BIGPRODUCT> list;
            string cacheKey = "cache_L2SoftBigProduct_getList";
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<L2_SOFT_BIGPRODUCT>>(cacheKey);
            else
                using (var contex = new Model.Entity.crmContext())
                {
                    list = contex.L2_SOFT_BIGPRODUCT.ToList();
                }
            return list;
        }

        /// <summary>
        /// L2产品小类
        /// </summary>
        /// <returns></returns>
        public List<L2_SOFT_PRODUCT> GetSProductList()
        {
            List<L2_SOFT_PRODUCT> list;
            string cacheKey = "cache_L2SoftSProduct_getList";
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<L2_SOFT_PRODUCT>>(cacheKey);
            else
                using (var contex = new Model.Entity.crmContext())
                {
                    list = contex.L2_SOFT_PRODUCT.ToList();
                }
            return list;
        }

        public List<SOFT_MODULE> GetAllModule()
        {
            List<SOFT_MODULE> list;
            string cacheKey = "cache_L2SoftModel_getList";
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<SOFT_MODULE>>(cacheKey);
            else
                using (var contex = new Model.Entity.crmContext())
                {
                    list = contex.SOFT_MODULE.ToList();
                }
            return list;
        }

        #endregion l2 产品

        #region 录音分类

        public List<CSVR_RECORDTYPE> GetList_RecordType()
        {
            List<CSVR_RECORDTYPE> list;
            string cacheKey = "cache_RecordType_getList";
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<CSVR_RECORDTYPE>>(cacheKey);
            else
                using (var contex = new WX.CRM.Model.Entity.crmContext())
                {
                    list = contex.CSVR_RECORDTYPE.ToList();
                }
            return list;
        }

        #endregion 录音分类

        #region 获取资源类型

        public IList<RES_RESOURCETYPE> GetResourceType()
        {
            var cacheKey = "cache_resourcetype_getlist";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<RES_RESOURCETYPE>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                var list = db.RES_RESOURCETYPE.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取资源类型

        #region 获取资源活动信息

        /// <summary>
        /// 获取软件活动信息
        /// </summary>
        /// <returns></returns>
        public List<RES_ACTIVITY> GetList_ResActivity()
        {
            string cacheKey = "cache_resactivity_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<WX.CRM.Model.Entity.RES_ACTIVITY>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<RES_ACTIVITY> list = db.RES_ACTIVITY.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取资源活动信息
        #region 房间

        public List<WX.CRM.Model.Entity.BAS_ROOM> GetRoomList()
        {
            string cacheKey = "cache_Room_getList";
            List<WX.CRM.Model.Entity.BAS_ROOM> modelist;
            if (CacheHelper.Exists(cacheKey))
                modelist = CacheHelper.Get<List<WX.CRM.Model.Entity.BAS_ROOM>>(cacheKey);
            else
            {
                using (WX.CRM.Model.Entity.crmContext db = new WX.CRM.Model.Entity.crmContext())
                {
                    modelist = db.BAS_ROOM.ToList();
                    CacheHelper.Set(cacheKey, modelist);
                }
            }
            return modelist;
        }

        #endregion 房间

        public List<CSVR_CALLOUTPARA> GetList_CallOutPara()
        {
            List<CSVR_CALLOUTPARA> list;
            string cacheKey = "cache_GetList_CallOutPara";
            if (CacheHelper.Exists(cacheKey))
                list = CacheHelper.Get<List<CSVR_CALLOUTPARA>>(cacheKey);
            else
                using (var contex = new WX.CRM.Model.Entity.crmContext())
                {
                    list = contex.CSVR_CALLOUTPARA.ToList();
                    CacheHelper.Set(cacheKey, list);
                }
            return list;
        }

        #region 获取主管信息

        public IList<BAS_GROUPLEADER> GetGroupleaders()
        {
            string cacheKey = "cache_Groupleader_list";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_GROUPLEADER>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<BAS_GROUPLEADER> list = new BAS_GROUPLEADER_BL().GetList(string.Empty, string.Empty);
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取主管信息

        #region 获取部门经理ID

        public decimal GetDeptManager(decimal gid)
        {
            var roles = GetList_Role();
            var BMZG = roles.FirstOrDefault(p => p.CODE == "BMZG");
            if (BMZG == null)
                return 0;
            var userRole = GetUserRole().Where(p => p.ROLEID == BMZG.ROLEID);
            var userGroup = GetList_InnerUserGroup().FirstOrDefault(p => userRole.Select(m => m.INNERUSERID).Contains(p.INNERUSERID) && p.GID == gid);
            if (userGroup == null)
                return 0;
            return userGroup.INNERUSERID;
        }

        #endregion 获取部门经理ID

        #region 获取actionlogconfig信息

        public IList<BAS_ACTIONLOGCONFIG> GetActionLogConfig()
        {
            string cacheKey = "cache_actionlogconfig_list";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_ACTIONLOGCONFIG>>(cacheKey);
            using (var db = new crmContext())
            {
                var list = new BAS_ACTIONLOGCONFIG_BL().GetList();
                CacheHelper.Set(cacheKey, list);
                return list.ToList();
            }
        }

        #endregion 获取actionlogconfig信息

        #region 获取期货产品信息

        /// <summary>
        /// 获取产品信息
        /// </summary>
        /// <returns></returns>
        public List<QH_PRODUCT> GetList_QH_Product()
        {
            string cacheKey = "cache_QH_product_getList";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<Model.Entity.QH_PRODUCT>>(cacheKey);
            using (crmContext db = new crmContext())
            {
                List<QH_PRODUCT> list = db.QH_PRODUCT.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion 获取期货产品信息

        #region

        public Dictionary<decimal, decimal> GetResSalesgroup()
        {
            var cacheKey = "cache_Res_SalesGroup";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<Dictionary<decimal, decimal>>(cacheKey);
            using (var db = new crmContext())
            {
                var arr = new List<decimal>() { 1493850899, 1617255440 };
                var list = db.RES_SALESGROUP_DETAIL.Where(p => arr.Contains(p.GROUPID)).ToDictionary(p => p.INNERUSERID, p => p.GROUPID);
                return list;
            }
        }

        #endregion

        #region 省

        public List<BAS_PROVINCE> GetProvince()
        {
            var cacheKey = "cache_Province";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_PROVINCE>>(cacheKey);
            using (var db = new crmContext())
            {
                var list = db.BAS_PROVINCE.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion

        #region 市

        public List<BAS_CITY> GetCity()
        {
            var cacheKey = "cache_City";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_CITY>>(cacheKey);
            using (var db = new crmContext())
            {
                var list = db.BAS_CITY.ToList();
                CacheHelper.Set(cacheKey, list);
                return list;
            }
        }

        #endregion

        public Dictionary<int, string> GetAiHgrecordStatusnameKV()
        {
            Dictionary<int, string> Ai_hgrecord_statusnameKV = new Dictionary<int, string>();
            Ai_hgrecord_statusnameKV.Add(-1, "忽略不做AI外呼");
            Ai_hgrecord_statusnameKV.Add(0, "尚未进行AI外呼");
            Ai_hgrecord_statusnameKV.Add(1, "等待AI外呼");
            Ai_hgrecord_statusnameKV.Add(2, "AI外呼需人工介入");
            Ai_hgrecord_statusnameKV.Add(5, "AI外呼成功");
            Ai_hgrecord_statusnameKV.Add(4, "电子回访成功");
            Ai_hgrecord_statusnameKV.Add(9, "人工回访成功");
            return Ai_hgrecord_statusnameKV;
        }

        public List<AI_CallTaskConfigDto> GetAiConfig()
        {
            var cacheKey = "AiCallConfig";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<AI_CallTaskConfigDto>>(cacheKey);
            return new List<AI_CallTaskConfigDto>();
        }

        public List<BAS_INNERUSER> GetAllCrmUser()
        {
            var cacheKey = "AllCrmUser";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<List<BAS_INNERUSER>>(cacheKey);
            List<BAS_INNERUSER> res = new List<BAS_INNERUSER>();
            var conn = new OracleConnection(OracleHelper.AYCRMConn);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            try
            {
                using (var trans = conn.BeginTransaction())
                {
                    var parms = new List<OracleParameter>()
                    {
                         new OracleParameter() { ParameterName = "v_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output },
                    };
                    DataTable ds = OracleHelper.DataQueray(trans, CommandType.StoredProcedure, "PACK_USER.BuildAllCrmUser", parms.ToArray()).Tables[0];
                    trans.Commit();
                    List<string> extuserids = new List<string>();
                    foreach (DataRow item in ds.Rows)
                    {
                        res.Add(new BAS_INNERUSER
                        {
                            PKID = Convert.ToDecimal(item["pkid"]),
                            UNAME = item["uname"].ToString(),
                            EID = Convert.ToDecimal(item["eid"])
                        });
                    }
                    CacheHelper.Set(cacheKey, res, DateTime.Now.AddMinutes(30), false);
                    return res;
                }
            }
            catch (Exception ex)
            {
                LogHelper.Error(ex);
                return res;
            }
            finally
            {
                conn.Close();
            }
        }

        #region 手机号新加密

        public string GetPhonePublicKey()
        {
            var cacheKey = "PhonePublicKey";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<string>(cacheKey);
            else
            {
                var phoneSetting = GetValue_Parameter("phoneSetting");
                var set = JsonConvert.DeserializeObject<PhoneSetting>(phoneSetting);
                // 读取PEM文件
                string pemFilePath = $"{AppDomain.CurrentDomain.BaseDirectory}/{set.publicKey}";
                string pemContent = File.ReadAllText(pemFilePath);
                MSecurityHelper sHelper = new MSecurityHelper();
                var publicKey = sHelper.PemToXml(pemContent, false);
                CacheHelper.Set(cacheKey, publicKey);
                return publicKey;
            }
        }

        public string GetPhonePrivateKey()
        {
            var cacheKey = "PhonePrivateKey";
            if (CacheHelper.Exists(cacheKey))
                return CacheHelper.Get<string>(cacheKey);
            else
            {
                var phoneSetting = GetValue_Parameter("phoneSetting");
                var set = JsonConvert.DeserializeObject<PhoneSetting>(phoneSetting);
                // 读取PEM文件
                string pemFilePath = $"{AppDomain.CurrentDomain.BaseDirectory}/{set.privateKey}";
                string pemContent = File.ReadAllText(pemFilePath);
                MSecurityHelper sHelper = new MSecurityHelper();
                var publicKey = sHelper.PemToXml(pemContent, true);
                CacheHelper.Set(cacheKey, publicKey);
                return publicKey;
            }
        }

        public string GetUMid(string phone)
        {
            try
            {
                var phoneSetting = GetValue_Parameter("phoneSetting");
                if (!string.IsNullOrWhiteSpace(phoneSetting))
                {
                    var set = JsonConvert.DeserializeObject<PhoneSetting>(phoneSetting);
                    MSecurityHelper sHelper = new MSecurityHelper();
                    phone = phone.TrimStart('0').Replace(" ", "");
                    var jsonbody = new
                    {
                        name = set.key,
                        mobile = phone
                    };
                    var publickey = GetPhonePublicKey();
                    var privatekey = GetPhonePrivateKey();
                    var content = sHelper.content(jsonbody.ToJson(), publickey); //解密操作
                    var sign = sHelper.sign(content, privatekey);
                    var headers = new Dictionary<string, string>();
                    headers.Add("content", content);
                    headers.Add("sign", sign);
                    var postdata = new
                    {
                        name = set.key,
                        content = content,
                        sign = sign
                    };
                    var url = $"{set.url.Trim('/')}/encrypt";
                    //需要做成配置
                    LogHelper.Info($"开始请求接口{postdata.ToJson()}");
                    var urlResult = Utility.PostAjaxData(url, postdata.ToJson(), headers, Encoding.UTF8);
                    var signdata = JsonConvert.DeserializeObject<SignReturnData>(urlResult);
                    var resultdata = sHelper.decyptSign(signdata.sign, signdata.content, publickey, privatekey);
                    LogHelper.Info($"解密手机号得到{resultdata}");
                    var middata = JsonConvert.DeserializeObject<MidData>(resultdata);
                    if (middata != null && middata.code == 200)
                    {
                        return middata.data;
                    }
                    else
                    {
                        throw new Exception($"获取新的手机号失败Middata{resultdata}");
                    }
                }
                else
                {
                    throw new Exception($"获取新的手机号失败没有配置");
                }
            }
            catch (Exception ex)
            {
                LogHelper.Error($"获取新的手机号失败{ex.Message}");
                throw ex;
            }
        }

        public string GetPhone(string umid)
        {
            try
            {
                var phoneSetting = GetValue_Parameter("phoneSetting");
                if (!string.IsNullOrWhiteSpace(phoneSetting))
                {
                    var set = JsonConvert.DeserializeObject<PhoneSetting>(phoneSetting);
                    MSecurityHelper sHelper = new MSecurityHelper();
                    var jsonbody = new
                    {
                        name = set.key,
                        key = umid
                    };
                    var publickey = GetPhonePublicKey();
                    var privatekey = GetPhonePrivateKey();
                    var content = sHelper.content(jsonbody.ToJson(), publickey); //解密操作
                    var sign = sHelper.sign(content, privatekey);
                    var headers = new Dictionary<string, string>();
                    headers.Add("content", content);
                    headers.Add("sign", sign);
                    var postdata = new
                    {
                        name = set.key,
                        content = content,
                        sign = sign
                    };
                    var url = $"{set.url.Trim('/')}/decrypt";
                    //需要做成配置
                    LogHelper.Info($"开始请求接口{postdata.ToJson()}");
                    var urlResult = Utility.PostAjaxData(url, postdata.ToJson(), headers, Encoding.UTF8);
                    var signdata = JsonConvert.DeserializeObject<SignReturnData>(urlResult);
                    var resultdata = sHelper.decyptSign(signdata.sign, signdata.content, publickey, privatekey);
                    LogHelper.Info($"解密手机号得到{resultdata}");
                    var middata = JsonConvert.DeserializeObject<MidData>(resultdata);
                    if (middata != null && middata.code == 200)
                    {
                        return middata.data;
                    }
                    else
                    {
                        throw new Exception($"获取新的手机号失败Middata{resultdata}");
                    }
                }
                else
                {
                    throw new Exception($"获取新的手机号失败没有配置");
                }
            }
            catch (Exception ex)
            {
                LogHelper.Error($"获取新的手机号失败{ex.Message}");
                throw ex;
            }
        }

        #endregion
    }

    /// <summary>
    /// 下拉列表构建
    /// </summary>
    public class DropModel
    {
        public string id { get; set; }
        public string state { get; set; }
        public string text { get; set; }
        public string attributes { get; set; }
        public string iconCls { get; set; }

        /// <summary>
        /// 是否特殊 1 为专业部门 0为其他部门 3同为专业部门和其他部门
        /// </summary>
        public decimal? isspecial { get; set; }

        /// <summary>
        /// db Id
        /// </summary>
        public decimal orginId { get; set; }

        /// <summary>
        /// 下级Id
        /// </summary>
        public List<decimal> filterId { get; set; } = new List<decimal>();

        /// <summary>
        /// 关联id
        /// </summary>
        public decimal? relateId { get; set; }

        /// <summary>
        /// 1 部门 2 销售组 3 人员
        /// </summary>
        public decimal type { get; set; } = 1;

        public List<DropModel> children { get; set; }
    }

    #region 手机号加解密

    public class PhoneSetting
    {
        public string key { get; set; }
        public string url { get; set; }
        public string publicKey { get; set; }
        public string privateKey { get; set; }
    }

    #endregion

}