/// <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)); }