using System;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using System.Collections.Generic;

using System.Linq;

public class Program

{

    public static void Main()

    {

        var json = "{\"RESULT\":[{\"SPRefId\":\"00001\",\"AcctId\":\"053580003075\",\"Detail\":[{\"TXDATE\":\"20150803\",\"TIME\":\"131100\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"583.12\",\"TXBALS\":\"\",\"TXBAL\":\"2775869.49\",\"REMARK1\":\"033580017318    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150805\",\"TIME\":\"131100\",\"BRANCH\":\"053\",\"SUMMY\":\"MLI\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"31591.09\",\"TXBALS\":\"\",\"TXBAL\":\"2807460.58\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"保費\"},{\"TXDATE\":\"20150805\",\"TIME\":\"131100\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"3385.00\",\"TXBALS\":\"\",\"TXBAL\":\"2810845.58\",\"REMARK1\":\"R222789427\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150806\",\"TIME\":\"133359\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"4948.12\",\"TXBALS\":\"\",\"TXBAL\":\"2805897.46\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150810\",\"TIME\":\"133359\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"21204.00\",\"TXBALS\":\"\",\"TXBAL\":\"2827101.46\",\"REMARK1\":\"R103301376\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150811\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"7790.00\",\"TXBALS\":\"\",\"TXBAL\":\"2819311.46\",\"REMARK1\":\"044580002983    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150812\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"285.85\",\"TXBALS\":\"\",\"TXBAL\":\"2819025.61\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150814\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"1395.56\",\"TXBALS\":\"\",\"TXBAL\":\"2817630.05\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150817\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"MLI\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"101662.56\",\"TXBALS\":\"\",\"TXBAL\":\"2919292.61\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"保費\"},{\"TXDATE\":\"20150817\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"194.16\",\"TXBALS\":\"\",\"TXBAL\":\"2919098.45\",\"REMARK1\":\"035580001910    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150818\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"130399.68\",\"TXBALS\":\"\",\"TXBAL\":\"3049498.13\",\"REMARK1\":\"R121094589\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150818\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"1280.00\",\"TXBALS\":\"\",\"TXBAL\":\"3048218.13\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150818\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"28434.00\",\"TXBALS\":\"\",\"TXBAL\":\"3076652.13\",\"REMARK1\":\"Q220904783\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150819\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"560.00\",\"TXBALS\":\"\",\"TXBAL\":\"3076092.13\",\"REMARK1\":\"027580002825    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150820\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"MLI\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"48175.05\",\"TXBALS\":\"\",\"TXBAL\":\"3124267.18\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"保費\"}]},{\"SPRefId\":\"00002\",\"AcctId\":\"053580003075\",\"Detail\":[{\"TXDATE\":\"20150803\",\"TIME\":\"131100\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"583.12\",\"TXBALS\":\"\",\"TXBAL\":\"2775869.49\",\"REMARK1\":\"033580017318    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150805\",\"TIME\":\"131100\",\"BRANCH\":\"053\",\"SUMMY\":\"MLI\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"31591.09\",\"TXBALS\":\"\",\"TXBAL\":\"2807460.58\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"保費\"},{\"TXDATE\":\"20150805\",\"TIME\":\"131100\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"3385.00\",\"TXBALS\":\"\",\"TXBAL\":\"2810845.58\",\"REMARK1\":\"R222789427\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150806\",\"TIME\":\"133359\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"4948.12\",\"TXBALS\":\"\",\"TXBAL\":\"2805897.46\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150810\",\"TIME\":\"133359\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"21204.00\",\"TXBALS\":\"\",\"TXBAL\":\"2827101.46\",\"REMARK1\":\"R103301376\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150811\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"7790.00\",\"TXBALS\":\"\",\"TXBAL\":\"2819311.46\",\"REMARK1\":\"044580002983    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150812\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"285.85\",\"TXBALS\":\"\",\"TXBAL\":\"2819025.61\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150814\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"1395.56\",\"TXBALS\":\"\",\"TXBAL\":\"2817630.05\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150817\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"MLI\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"101662.56\",\"TXBALS\":\"\",\"TXBAL\":\"2919292.61\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"保費\"},{\"TXDATE\":\"20150817\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"194.16\",\"TXBALS\":\"\",\"TXBAL\":\"2919098.45\",\"REMARK1\":\"035580001910    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150818\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"130399.68\",\"TXBALS\":\"\",\"TXBAL\":\"3049498.13\",\"REMARK1\":\"R121094589\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150818\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"1280.00\",\"TXBALS\":\"\",\"TXBAL\":\"3048218.13\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150818\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"CS\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"28434.00\",\"TXBALS\":\"\",\"TXBAL\":\"3076652.13\",\"REMARK1\":\"Q220904783\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"活存轉\"},{\"TXDATE\":\"20150819\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"TSW\",\"CDTYPE\":\"1\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"560.00\",\"TXBALS\":\"\",\"TXBAL\":\"3076092.13\",\"REMARK1\":\"027580002825    USD\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"借\",\"SUMMYName\":\"轉帳提\"},{\"TXDATE\":\"20150820\",\"TIME\":\"133407\",\"BRANCH\":\"053\",\"SUMMY\":\"MLI\",\"CDTYPE\":\"2\",\"CCY\":\"USD\",\"TXAMTS\":\"\",\"TXAMT\":\"48175.05\",\"TXBALS\":\"\",\"TXBAL\":\"3124267.18\",\"REMARK1\":\"\",\"BranchName\":\"台北分行\",\"CDTYPEName\":\"貸\",\"SUMMYName\":\"保費\"}]}]}";

​

            ////var jobject = JArray.Parse(json);

            //拿到RESULT Array

            var jsonData = JsonConvert.DeserializeObject<dynamic>(json);

​

            IJEnumerable<JToken> jtokens = (IJEnumerable<JToken>)jsonData.RESULT;

            //也可以用此寫法拿到RESULT Array

            //var jobject = JObject.Parse(json);

            // IJEnumerable<JToken> jtokens = jobject.Values().Children();//拿到Result Array

​

            //var DetailResult = new List<IEnumerable<JToken>>();           

            //var DetailResult = new List<dynamic>();

            var DetailResult = new List<Dictionary<string, string>>();

            jtokens.ForEach(item => {

                var level1Property = item.Children().Where(m => m.Type == JTokenType.Property && ((JProperty)m).Name != "Detail")

                .ToDictionary(m => ((JProperty)m).Name, m => ((JProperty)m).Value.ToString());//取第一層屬性值 (轉Dic目的是將原本的JObject的屬性移掉)

                var DetailPropery = item.Children().Where(m => m.Type == JTokenType.Property && ((JProperty)m).Name == "Detail");//取Detail屬性值

                var DetailArrays = DetailPropery.Values().Values();

                foreach (JToken subitem in DetailArrays) {

                    var subitemDic = subitem.ToDictionary(m => ((JProperty)m).Name, m => ((JProperty)m).Value.ToString());

                    var temp = subitemDic.Concat(level1Property).ToDictionary(m => m.Key, m => m.Value);

                    DetailResult.Add(temp);

                }

            });

            //因為jsonData.RESULT原本是 JArray物件，所以不可以用List填入，要將List轉為JArray物件

            jsonData.RESULT = (JArray)JToken.FromObject(DetailResult);

            //var mm = JsonConvert.SerializeObject(DetailResult);

            //jsonData.RESULT = DetailResult;//因為RESULT是 JArray物件，所以不可以用List填入

            //var tt = JArray.FromObject(DetailResult);

            //jsonData.RESULT = (JArray)JToken.FromObject(DetailResult);

​

            var result = JsonConvert.SerializeObject(jsonData);

        Console.WriteLine("Hello World：Result="+result);

    }

}

​

public static class ListExtension{

//ForEach的擴充

      public static void ForEach<T>(this IEnumerable<T> collections, Action<T> action)

        {

            foreach (var n in collections)

            {

                action(n);

            }

        }

}

​