69
1
using System;2
using Newtonsoft.Json;3
using Newtonsoft.Json.Linq;4
using System.Collections.Generic;5
using System.Linq;6
7
public class Program8
{9
public static void Main()10
{11
12
13
14
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\":\"保費\"}]}]}";15
16
////var jobject = JArray.Parse(json);17
18
//拿到RESULT Array19
var jsonData = JsonConvert.DeserializeObject<dynamic>(json);20
21
IJEnumerable<JToken> jtokens = (IJEnumerable<JToken>)jsonData.RESULT;22
23
//也可以用此寫法拿到RESULT Array24
//var jobject = JObject.Parse(json);Cached Result