199 Generate CSV Files 02(自定义需要获取的列)

黄健华Yeah

于 2024-05-22 18:10:35 发布

阅读量280

点赞数 7

分类专栏： ASP.NET Core 8.0 文章标签：服务器数据库 asp.net windows c# sql

本文链接：https://blog.csdn.net/KevinHuang2088/article/details/139126381

版权

ASP.NET Core 8.0 专栏收录该内容

289 篇文章 0 订阅

订阅专栏

示例

改造PersonService.cs中的GetPersonsCSV()

public async Task<MemoryStream> GetPersonsCSV()
{
    MemoryStream memoryStream = new MemoryStream();
    StreamWriter streamWriter = new StreamWriter(memoryStream);

    CsvConfiguration csvConfiguration = new CsvConfiguration(CultureInfo.InvariantCulture);

    CsvWriter csvWriter = new CsvWriter(streamWriter, csvConfiguration, true);

    csvWriter.WriteField(nameof(PersonResponse.PersonName));
    csvWriter.WriteField(nameof(PersonResponse.Email));
    csvWriter.WriteField(nameof(PersonResponse.DateOfBirth));
    csvWriter.WriteField(nameof(PersonResponse.Age));
    csvWriter.WriteField(nameof(PersonResponse.Gender));
    csvWriter.WriteField(nameof(PersonResponse.Country));
    csvWriter.WriteField(nameof(PersonResponse.Address));
    csvWriter.WriteField(nameof(PersonResponse.ReceiveNewsLetters));
    await csvWriter.NextRecordAsync();

    List<PersonResponse> persons = await _db.Persons.Include(p => p.Country)
        .Select(p => p.ToPersonResponse()).ToListAsync();
    
    foreach(PersonResponse person in persons)
    {
        csvWriter.WriteField(person.PersonName);
        csvWriter.WriteField(person.Email);
        if (person.DateOfBirth.HasValue)
        {
            csvWriter.WriteField(person.DateOfBirth.Value.ToString("yyyy-MM-dd"));
        }
        else
        {
            csvWriter.WriteField("");
        }
        csvWriter.WriteField(person.Age);
        csvWriter.WriteField(person.Gender);
        csvWriter.WriteField(person.Country);
        csvWriter.WriteField(person.Address);
        csvWriter.WriteField(person.ReceiveNewsLetters);
        await csvWriter.NextRecordAsync();
        await csvWriter.FlushAsync();
    }

    memoryStream.Position = 0; 
    return memoryStream;
}

Gitee获取源码：

https://gitee.com/huang_jianhua0101/asp.-net-core-8.git