C#内存表数据透视表生成

最新推荐文章于 2023-12-03 21:52:01 发布

qq_42678477

最新推荐文章于 2023-12-03 21:52:01 发布

阅读量573

点赞数

CC 4.0 BY-SA版权

分类专栏： C#

本文链接：https://blog.csdn.net/qq_42678477/article/details/104776784

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace GT
{
    /// <summary>
    /// 内存表透视表生成器 2020.3.10
    /// 调用方法new PivotTableGenerator(dt, "dq,xz,cw","fl","sl", "dq=地区,xz=小组,cw=财务").CreatePivotTable();
    /// </summary>
    public class PivotTableGenerator
    {

        private DataTable _source;
        private DataTable _result;

        string[] _fields;
        string _valueFileld;
        string _pivotField;
        private string _fieldRenameString;

        /// <summary>
        /// 内存表透视表生成器 构造方式
        /// 调用方法new PivotTableGenerator(dt, "dq,xz,cw","fl","sl", "dq=地区,xz=小组,cw=财务").CreatePivotTable();
        /// </summary>
        /// <param name="source"></param>
        /// <param name="fields">如</param>
        /// <param name=