Json 序列化

//下面的代码就是将数据库的值转化为Json的主要代码
                JavaScriptSerializer java = new JavaScriptSerializer();
                StringBuilder sb = new StringBuilder();
                java.Serialize(lst, sb);
                string json = sb.ToString();

                //JHType_BTable jhData = java.Deserialize<JHType_BTable>(this);

                // 解析Json格式字符串
                JavaScriptSerializer ser = new JavaScriptSerializer();
                List<AJAX_DATA> lists = ser.Deserialize<List<AJAX_DATA>>(json);

                List<string> sqlList = new List<string>();
                foreach (AJAX_DATA itemData in lists)
                {
                    sqlList.Add("insert into JHType_BTable values('" + itemData.ACode + "','" + itemData.XMMC + "','" + itemData.XMJZ + "','" + itemData.XMGM + "','" + itemData.ZNJ + "','" + itemData.FZNJ + "','" + itemData.ZJ + "','" + itemData.CLWQ + "','" + itemData.ZRR + "','" + itemData.QT_NR + "','" + itemData.SFWL + "','" + itemData.DepName + "','" + itemData.JH_RenWuTable + "','" + itemData.DepID + "','" + itemData.EmpID + "')");
                    //System.IO.File.AppendAllText("D:\\Error.txt", "\r\n" + itemData.XMMC);

                }
                int Istate = 0;
                if (sqlList.Count > 0)
                {
                    Istate = DbHelperSQL.ExecuteSqlTran(sqlList);
                }

                //------
                //记录填写人
                string sql_JH_State = string.Format(@"insert into JH_State(State_writeEmpID,JH_RenWuTable_ID) values('{0}','{1}')", jh_EmpID, JH_RenWuTable);
                DbHelperSQL.ExecuteSql(sql_JH_State);
                //------
                //json = "{totalPorperty:" + dt1.Rows[0]["totalPorperty"].ToString() + ",root:" + json + "}";
                //return json;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值