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