/// <summary>
        /// 获取列表
        /// </summary>
        public (IEnumerable <EmailBccAccountEntity>, int) GetList(string address, string group, int pageindex, int pagesize)
        {
            Dictionary <string, object> dic = new Dictionary <string, object>();

            if (!string.IsNullOrWhiteSpace(address))
            {
                dic["EmailBccAccountAddress"] = address;
            }
            if (!string.IsNullOrWhiteSpace(group))
            {
                EmailBccAccountCategoryRepository repository = new EmailBccAccountCategoryRepository();
                var idList = repository.GetIDList(group).Select(i => i.ID);
                if (idList == null || idList.Count() <= 0)
                {
                    return(new List <EmailBccAccountEntity>(), 0);
                }
                dic["EmailBccAccountCategoryID"] = string.Join("','", idList);
            }
            if (pageindex >= 0)
            {
                dic["StartIndex"] = pageindex <= 1 ? 0 : (pageindex - 1) * pagesize;
            }
            if (pagesize > 0)
            {
                dic["SelectCount"] = pagesize;
            }
            var list = SQLHelperFactory.Instance.QueryMultipleByPage <EmailBccAccountEntity>("Select_emailbccaccount_ListByPage", dic, out int total);

            return(list, total);
        }
        /// <summary>
        /// 获取列表
        /// </summary>
        public List <dynamic> GetBccEmailListByExport(string address, string group)
        {
            Dictionary <string, object> dic = new Dictionary <string, object>();

            if (!string.IsNullOrWhiteSpace(address))
            {
                dic["EmailBccAccountAddress"] = address;
            }
            if (!string.IsNullOrWhiteSpace(group))
            {
                EmailBccAccountCategoryRepository repository = new EmailBccAccountCategoryRepository();
                var idList = repository.GetIDList(group).Select(i => i.ID);
                if (idList == null || idList.Count() <= 0)
                {
                    return(null);
                }
                dic["EmailBccAccountCategoryID"] = string.Join("','", idList);
            }
            return(SQLHelperFactory.Instance.QueryForList("Select_emailbccaccount_by_export", dic));
        }