public async Task <FileResult> ExportExcel(string Level = "", string Name = "",
string Business = "", string Store = "", string RegTimeFrom = "", string RegTimeTo = "")
{
string where = string.Empty;
where += _comAppService.GetWhere();
if (!string.IsNullOrEmpty(Level))
{
where += $" and levelId={Level}";
}
if (!string.IsNullOrEmpty(Name))
{
where += $" and (FullName like'%{Name}%' or WeChatName like '%{Name}%')";
}
if (!string.IsNullOrEmpty(Business))
{
where += $" and m.BusinessId={Business}";
}
if (!string.IsNullOrEmpty(Store))
{
where += $" and m.ChainStoreId={Store}";
}
if (!string.IsNullOrEmpty(RegTimeFrom))
{
where += $" and RegTime>='{RegTimeFrom} 00:00:00'";
}
if (!string.IsNullOrEmpty(RegTimeTo))
{
where += $" and RegTime<='{RegTimeTo} 23:59:59'";
}
MemoryStream ms = await _AppService.ExportToExcel(where);
return(File(ms.ToArray(), "application/vnd.ms-excel", "" + L("MemberList") + ".xlsx"));
}
