DataTable比较特殊的处理

[qq_24567365]

现在有个比较特殊的需求需要处理，本人lambda学的差，不知道怎么处理，希望大神能提供代码解决下，是这样的，有个如图所示的DataTable，然后我模拟了一批数据，然后有一个方法有三个参数，当Source是3或者6的时候，Type列才有值，值要么为1，要么为2，然后又对应的ID列，（Source是3或者6这是一个特殊的情况）实际场景就是数据是从两个表取出来的，当Source为3或者为6时，当Type为1取得ID值就是A表的值，当Type为2的时候取的就是B表的值，所以才这样，然后根据Source将ID列合并为一行，用逗号拼接，我现在模拟了字典dic1，dic2,然后就是不知道怎么从DataTable通过lambda或者Linq实现到字典的这个过程，现在字典加的是模拟数据，实际肯定是从Datatable里取得，但是不知道怎么实现,想了很久都实现不了，希望大神能代码帮助下，我的C币就剩9个了，续费的话太贵了，还请大神们能指导下

 
            DataTable da = new DataTable();
            da.Columns.Add("ID", typeof(System.Int32));
            da.Columns.Add("Source", typeof(System.Int32));
            da.Columns.Add("Type", typeof(System.Int32));

            DataRow dr = da.NewRow();
            da.Rows.Add(1001, 1, null);
            da.Rows.Add(1002, 1, null);
            da.Rows.Add(1003, 1, null);
            da.Rows.Add(1004, 2, null);
            da.Rows.Add(1005, 2, null);
            da.Rows.Add(1006, 3, 1);
            da.Rows.Add(1007, 3, 2);
            da.Rows.Add(1008, 3, 2);
            da.Rows.Add(1009, 6, 1);
            da.Rows.Add(1010, 6, 2);
            da.Rows.Add(1011, 6, 1);

            Dictionary<int, string> dic1 = new Dictionary<int, string>();
            dic1.Add(1,"1001,1002,1003");
            dic1.Add(2,"1004,1005");

            Dictionary<int, Dictionary<int,string> > dic2 = new Dictionary<int, Dictionary<int, string>>();

            Dictionary<int, string> dic3 = new Dictionary<int, string>();
            Dictionary<int, string> dic4 = new Dictionary<int, string>();
            dic3.Add(1, "1006");
            dic3.Add(2, "1007,1008");

            dic4.Add(1, "1009,1011");
            dic4.Add(2, "1010");

            dic2.Add(3, dic3);
            dic2.Add(6, dic4);

            foreach (KeyValuePair<int,string> item in dic1)
            {
                Test(item.Key, item.Value, 0); 
            }
            foreach (KeyValuePair<int, Dictionary<int, string>> item in dic2)
            {
                foreach(KeyValuePair<int, string> temp in item.Value)
                {
                    Test(item.Key, temp.Value, temp.Key);
                }
            } 
            public void Test(int source,string id,int type)
            {

            }
          

[xuzuning]

你花了很多心思做了很多说明，但并未说道要点上
比如你说有 A表、B表，但模拟数据只有一个 DataTable，如果是合并后的数据，那么再提及 A表、B表 和 Type 那只能混淆自己的思路，而作茧自缚
你贴出了测试代码，但并不能运行，所以也很难推测出你需要的结果
姑且猜一把

            DataTable da = new DataTable();
            da.Columns.Add("ID", typeof(System.Int32));
            da.Columns.Add("Source", typeof(System.Int32));
            da.Columns.Add("Type", typeof(System.Int32));

            DataRow dr = da.NewRow();
            da.Rows.Add(1001, 1, null);
            da.Rows.Add(1002, 1, null);
            da.Rows.Add(1003, 1, null);
            da.Rows.Add(1004, 2, null);
            da.Rows.Add(1005, 2, null);
            da.Rows.Add(1012, 7, null);
            da.Rows.Add(1013, 7, null);
            da.Rows.Add(1006, 3, 1);
            da.Rows.Add(1007, 3, 2);
            da.Rows.Add(1008, 3, 2);
            da.Rows.Add(1009, 6, 1);
            da.Rows.Add(1010, 6, 2);
            da.Rows.Add(1011, 6, 1);

            var a = da.AsEnumerable().Where(x =>(int)x["Source"] == 3).Select(x=>new {Id=(int)x["Id"], Source=(int)x["Source"],Type=(int)x["Type"]});
            foreach (var x in a) Console.WriteLine(x);
 

{ Id = 1006, Source = 3, Type = 1 }
{ Id = 1007, Source = 3, Type = 2 }
{ Id = 1008, Source = 3, Type = 2 }

再 Console.WriteLine(string.Join(",", a.Select(x=>x.Id)));
得 1006,1007,1008
其实，你只需给出原始的数据和期望的结果，自然就会有人给你算法的

[qq_24567365]

熬夜稍微搞了下，但是代码看上去太low了，也没时间优化，太困了，有没有大神有更好的办法

 DataTable da = new DataTable();
            da.Columns.Add("ID", typeof(System.Int32));
            da.Columns.Add("Source", typeof(System.Int32));
            da.Columns.Add("Type", typeof(System.Int32));

            DataRow dr = da.NewRow();
            da.Rows.Add(1001, 1, null);
            da.Rows.Add(1002, 1, null);
            da.Rows.Add(1003, 1, null);
            da.Rows.Add(1004, 2, null);
            da.Rows.Add(1005, 2, null);
            da.Rows.Add(1012, 7, null);
            da.Rows.Add(1013, 7, null);
            da.Rows.Add(1006, 3, 1);
            da.Rows.Add(1007, 3, 2);
            da.Rows.Add(1008, 3, 2);
            da.Rows.Add(1009, 6, 1);
            da.Rows.Add(1010, 6, 2);
            da.Rows.Add(1011, 6, 1);

            Dictionary<int, string> dic1 = new Dictionary<int, string>();
            Dictionary<int, Dictionary<int, string>> dic2 = new Dictionary<int, Dictionary<int, string>>();

            Dictionary<int, string> dic3 = new Dictionary<int, string>();
            Dictionary<int, string> dic4 = new Dictionary<int, string>();
            var dd=da.AsEnumerable().Where(x => Convert.ToInt32(x["Source"]) != 3 && Convert.ToInt32(x["Source"]) != 6).GroupBy(p => new { ID = p["ID"], Source = p["Source"], Type = p["Type"] });
            var dd2 = da.AsEnumerable().Where(x => Convert.ToInt32(x["Source"]) == 3 ||  Convert.ToInt32(x["Source"]) == 6).GroupBy(p => new { ID = p["ID"], Source = p["Source"], Type = p["Type"] });
            string id1 = string.Empty;
            string id2 = string.Empty;
            string id4 = string.Empty;
            string id7 = string.Empty;
            string id31 = string.Empty;
            string id32 = string.Empty;
            string id61 = string.Empty;
            string id62 = string.Empty;
            int count1=dd.Where(x => Convert.ToInt32(x.Key.Source) == 1).Count();
            int count2 = dd.Where(x => Convert.ToInt32(x.Key.Source) == 2).Count();
            int count4 = dd.Where(x => Convert.ToInt32(x.Key.Source) == 4).Count();
            int count7 = dd.Where(x => Convert.ToInt32(x.Key.Source) == 7).Count();

            int count31= dd2.Where(x => Convert.ToInt32(x.Key.Source) == 3&& Convert.ToInt32(x.Key.Type)==1).Count();
            int count32 = dd2.Where(x => Convert.ToInt32(x.Key.Source) == 3 && Convert.ToInt32(x.Key.Type) == 2).Count();
            int count61= dd2.Where(x => Convert.ToInt32(x.Key.Source) == 6 && Convert.ToInt32(x.Key.Type) == 1).Count();
            int count62 = dd2.Where(x => Convert.ToInt32(x.Key.Source) == 6 && Convert.ToInt32(x.Key.Type) == 2).Count();
            int num1 = 0;
            int num2 = 0;
            int num4 = 0;
            int num7 = 0;
            int num31 = 0;
            int num32 = 0;
            int num61 = 0;
            int num62 = 0;
            foreach (var g in dd)
            {
                
                if (Convert.ToInt32(g.Key.Source) == 1)
                {
                    id1 += g.Key.ID + ",";
                    num1++;
                }
                if (id1.Length > 0&&num1==count1)
                {
                    dic1.Add(Convert.ToInt32(g.Key.Source), id1.Trim(','));
                    num1 = 0;
                }
                if (Convert.ToInt32(g.Key.Source) == 2)
                {
                    id2 += g.Key.ID + ",";
                    num2++;
                }
                if (id2.Length > 0 && num2 == count2)
                {
                    dic1.Add(Convert.ToInt32(g.Key.Source), id2.Trim(','));
                    num2 = 0;
                }
                if (Convert.ToInt32(g.Key.Source) == 4)
                {
                    id4 += g.Key.ID + ",";
                    num4++;
                }
                if (id4.Length > 0 && num4 == count4)
                {
                    dic1.Add(Convert.ToInt32(g.Key.Source), id4.Trim(','));
                    num4 = 0;
                }
                if (Convert.ToInt32(g.Key.Source) == 7)
                {
                    id7 += g.Key.ID + ",";
                    num7++;
                }
                if (id7.Length > 0 && num7 == count7)
                {
                    dic1.Add(Convert.ToInt32(g.Key.Source), id7.Trim(','));
                }
               

            }

            foreach(var k in dd2)
            {
                if (Convert.ToInt32(k.Key.Source) == 3)
                {
                    if(Convert.ToInt32(k.Key.Type) == 1)
                    {
                        id31 += k.Key.ID + ",";
                        num31++;
                    }
                    else if (Convert.ToInt32(k.Key.Type) == 2)
                    {
                        id32 += k.Key.ID + ",";
                        num32++;
                    }
                    
                }
                if (id31.Length > 0 && num31 == count31&& Convert.ToInt32(k.Key.Source) == 3 && Convert.ToInt32(k.Key.Type)==1)
                {
                    dic3.Add(1, id31.Trim(','));
                }
                if (id32.Length > 0 && num32 == count32 && Convert.ToInt32(k.Key.Source) == 3 && Convert.ToInt32(k.Key.Type) == 2)
                {
                    dic3.Add(2, id32.Trim(','));
                }
                if (Convert.ToInt32(k.Key.Source) == 6)
                {
                    if (Convert.ToInt32(k.Key.Type) == 1)
                    {
                        id61 += k.Key.ID + ",";
                        num61++;
                    }
                    else if(Convert.ToInt32(k.Key.Type) == 2)
                    {
                        id62 += k.Key.ID + ",";
                        num62++;
                    }
                       
                }
                if (id61.Length > 0 && num61 == count61 && Convert.ToInt32(k.Key.Source) == 6 && Convert.ToInt32(k.Key.Type) == 1)
                {
                    dic4.Add(1, id61.Trim(','));
                }
                if (id62.Length > 0 && num62 == count62 && Convert.ToInt32(k.Key.Source) == 6 && Convert.ToInt32(k.Key.Type) == 2)
                {
                    dic4.Add(2, id62.Trim(','));
                }
            }

            if(dic3.Count()>0)
            {
                dic2.Add(3, dic3);
            }
            if (dic4.Count() > 0)
            {
                dic2.Add(6, dic4);
            }


            foreach (KeyValuePair<int,string> item in dic1)
            {
                Test(item.Key, item.Value, 0); 
            }
            foreach (KeyValuePair<int, Dictionary<int, string>> item in dic2)
            {
                foreach(KeyValuePair<int, string> temp in item.Value)
                {
                    Test(item.Key, temp.Value, temp.Key);
                }
            }

[qq_24567365]

测试代码不能运行？