c# DataTable合并相同条件的行数据

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Collections;
using System.Data;


namespace ConsoleApp1
{
    class Program
    {

        public static DataTable dt = new DataTable();

        public static DataTable tabTemp = new DataTable();
        public static DataRow drTemp = null;


        static void Main(string[] args)
        {

            dt.Columns.Add("a", typeof(String));
            dt.Columns.Add("b", typeof(String));
            dt.Columns.Add("c", typeof(String));
            dt.Columns.Add("d", typeof(String));

            DataRow dr = null;
            dr = dt.NewRow();
            dr[0] = "1";
            dr[1] = "1";
            dr[2] = "1";
            dr[3] = "1";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr[0] = "1";
            dr[1] = "2";
            dr[2] = "2";
            dr[3] = "2";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr[0] = "1";
            dr[1] = "3";
            dr[2] = "3";
            dr[3] = "3";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr[0] = "2";
            dr[1] = "1";
            dr[2] = "1";
            dr[3] = "1";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr[0] = "2";
            dr[1] = "1";
            dr[2] = "1";
            dr[3] = "1";
            dt.Rows.Add(dr);
            dr = dt.NewRow();
            dr[0] = "3";
            dr[1] = "1";
            dr[2] = "1";
            dr[3] = "1";
            dt.Rows.Add(dr);
            Console.WriteLine(dt.Columns[0].ColumnName + " " + dt.Columns[1].ColumnName + " " + dt.Columns[2].ColumnName + " " + dt.Columns[3].ColumnName + " ");
            for (int l = 0; l < dt.Rows.Count; l++)
            {
                Console.WriteLine(dt.Rows[l][0].ToString() + " " + dt.Rows[l][1].ToString() + " " + dt.Rows[l][2].ToString() + " " + dt.Rows[l][3].ToString() + " ");
            }

            //
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                tabTemp.Columns.Add(dt.Columns[j].ColumnName, dt.Columns[j].DataType);
            }

            FindComValue();

            Console.WriteLine(tabTemp.Columns[0].ColumnName + " " + tabTemp.Columns[1].ColumnName + " " + tabTemp.Columns[2].ColumnName + " " + tabTemp.Columns[3].ColumnName + " ");
            for (int k = 0; k < tabTemp.Rows.Count; k++)
            {
                Console.WriteLine(tabTemp.Rows[k][0].ToString() + " " + tabTemp.Rows[k][1].ToString() + " " + tabTemp.Rows[k][2].ToString() + " " + tabTemp.Rows[k][3].ToString() + " ");
            }
            Console.Read();


        }




        static void FindComValue()
        {
            if (dt.Rows.Count > 0)
            {
                string row1 = dt.Rows[0][0].ToString();//取表的第一行第一列
                DataRow[] drr = dt.Select("a=" + row1);
                drTemp = tabTemp.NewRow();//临时新的行
                foreach (DataRow row in drr)
                {
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        if (i != 0)
                        {
                            if (drTemp[i].ToString().Trim() == "")
                                drTemp[i] = "0";
                            drTemp[i] = Convert.ToString(Convert.ToDouble(drTemp[i].ToString()) + Convert.ToDouble(row[i].ToString()));//合并每一列的数据
                        }
                        else
                        {
                            drTemp[i] = row[i].ToString();//添加第一列，不需要相加
                        }
                    }
                    dt.Rows.Remove(row);//清除此类的行
                }
                tabTemp.Rows.Add(drTemp);//添加临时新的行数据
                FindComValue();
            }
        }








    }
}