fix:运营端——C端人员管理——列表展示了企业联系人的信息

sunpengfei

2025-08-14 57183ac3ea6571aff6583a214a95eb5af4d4a2f7

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
using Furion;
using Furion.HttpRemote;
using MiniExcelLibs;
using MiniExcelLibs.Attributes;
using MiniExcelLibs.OpenXml;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
 
namespace FlexJobApi.Core
{
    /// <summary>
    /// Excel工具
    /// </summary>
    public static class ExcelUtils
    {
        public static async Task<List<T>> ImportExcelFromOSS<T>(this string url)
            where T : class, new()
        {
            var config = new OpenXmlConfiguration();
            var xmlDoc = await XmlDocUtils.GetXmlDocAsync();
            config.DynamicColumns = typeof(T).GetProperties().Select(it =>
            {
                var column = new DynamicExcelColumn(it.Name)
                {
                    Name = it.GetXmlDocMemberAsync(xmlDoc).Result.Summary,
                    Ignore = it.GetCustomAttribute<JsonIgnoreAttribute>() != null
                };
                return column;
            }).ToArray();
            url = AliyunOSSUtils.GetUrl(url);
            var stream = await App.GetRequiredService<IHttpRemoteService>().GetAsStreamAsync(url);
 
            var query = await MiniExcel.QueryAsync<T>(stream, configuration: config);
            return query.ToList();
        }
 
        public static async Task<string> ExportExcelToOSS<T>(this List<T> models, string scene, string filename)
            where T : class, new()
        {
            var xmlDoc = await XmlDocUtils.GetXmlDocAsync();
            var config = new OpenXmlConfiguration();
            config.TableStyles = TableStyles.None;
            config.AutoFilter = false;
            config.FastMode = true;
            config.EnableAutoWidth = true;
            config.StyleOptions = new OpenXmlStyleOptions
            {
                WrapCellContents = false
            };
            config.FreezeRowCount = 0;
 
            config.DynamicColumns = typeof(T).GetProperties().Select(it =>
            {
                var propertyType = it.PropertyType;
                if (propertyType.IsGenericType && propertyType.GetGenericTypeDefinition() == typeof(Nullable<>))
                {
                    propertyType = propertyType.GetGenericArguments()[0];
                }
                var column = new DynamicExcelColumn(it.Name)
                {
                    Name = it.GetXmlDocMemberAsync(xmlDoc).Result.Summary,
                    Ignore = it.GetCustomAttribute<JsonIgnoreAttribute>() != null,
                    CustomFormatter = v =>
                    {
                        if (propertyType.IsEnum)
                        {
                            var models = EnumUtils.GetModel(propertyType).Result;
                            var enumValue = (int)v;
                            var model = models.Items.FirstOrDefault(i => i.Value == enumValue);
                            return model?.Description;
                        }
                        return v;
                    },
                };
                if (propertyType == typeof(DateTime))
                {
                    column.Format = "yyyy-MM-dd HH:mm:ss";
                }
                return column;
            }).ToArray();
            var stream = new MemoryStream();
            await MiniExcel.SaveAsAsync(stream, models, configuration: config);
            stream.Seek(0, SeekOrigin.Begin);
            return AliyunOSSUtils.Upload(scene, stream, filename);
        }
    }
}