.net csv转json

1.接口返回是csv文件,如下:

 

  if (response != null && response != "")
            {
                string data = response.Remove(0,23).Trim();
                byte[] arry = Encoding.ASCII.GetBytes(data);
                MemoryStream stem = new MemoryStream(arry);//创建流
                StreamReader reader = new StreamReader(stem);//转成流文件
                Dictionary<string,int> dics  = new Dictionary<string, int>();
                JObject objs = new JObject();
                JArray arr = new JArray();
                int m = 0;
                while (!reader.EndOfStream)
                {
                    m = m + 1;
                    string line = reader.ReadLine();
                    string[] values = line.Split(',');
                    if (m == 1)  //第一行作为列
                    {
                       for (int i = 0; i < values.Length; i++)
                       {
                            dics.Add(values[i],i);
                       }
                    }
                    if (m > 1)
                    {
                        arr.Add(new JObject(new JProperty("playerID", values[0]), new JProperty("extPlayerID", values[1]), new JProperty("gameID", values[2]),
                         new JProperty("playSessionID", values[3]), new JProperty("parentSessionID", values[4]), new JProperty("startDate", values[5]),
                         new JProperty("endDate", values[6]), new JProperty("status", values[7]), new JProperty("type", values[8]),
                         new JProperty("bet", values[9]), new JProperty("win", values[10]), new JProperty("currency", values[11]), new JProperty("jackpot", values[12])
                       ));
                    }
                }
                reader.Close();
                objs.Add(new JProperty("list",arr));

                Log.Debug("PP=>BetRecord:==>" + objs);
                r.code = (int)ResultType.Success;
                r.data = objs;
                r.message = "Success";
                return r;
            }

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值