Newtonsoft JSON-到/从数据集的转换会导致十进制变为Double? [英] Newtonsoft JSON- Conversion to/from DataSet causes Decimal to become Double?
本文介绍了Newtonsoft JSON-到/从数据集的转换会导致十进制变为Double?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用Newtonsoft JSON使用以下代码将DataSet序列化为二进制JSON.当反序列化回DataSet时,字段类型从Decimal变为Double?有人知道出什么事了吗?
I'm using Newtonsoft JSON to serialize a DataSet to binary JSON using the code below. When de-serializing back to a DataSet, the field type changes from a Decimal to a Double? Does anybody know what's going wrong?
示例代码:
static void Main(string[] args)
{
var ds = new DataSet();
var dt = ds.Tables.Add();
dt.Columns.Add("Test", typeof(Decimal));
dt.Rows.Add(new object[] { 1.23345M });
var data = DataSetToBinJSON(ds);
var ds2 = BinJSONToDataSet(data);
Console.WriteLine((ds2.Tables[0].Columns[0].DataType == typeof(Decimal)) ? "Passed" : string.Format("Failed- {0}", ds2.Tables[0].Columns[0].DataType));
Console.ReadLine();
}
/// <summary>
/// Utility function to create an optimized Binary JSON version of a DataSet
/// </summary>
public static byte[] DataSetToBinJSON(DataSet dataSet)
{
if (dataSet == null || dataSet.Tables == null || dataSet.Tables.Count == 0)
{
return null;
}
using (var ms = new MemoryStream())
{
using (var writer = new BsonWriter(ms))
{
var serializer = new JsonSerializer();
serializer.Serialize(writer, dataSet);
return ms.ToArray();
}
}
}
/// <summary>
/// Utility function to deserialize an optimized Binary JSON serialized DataSet
/// </summary>
public static DataSet BinJSONToDataSet(byte[] dataBytes)
{
if (dataBytes.Length == 0)
{
return null;
}
using (var ms = new MemoryStream(dataBytes))
{
using (var reader = new BsonReader(ms))
{
var serializer = new JsonSerializer();
return serializer.Deserialize<DataSet>(reader);
}
}
}
推荐答案
轻松解决此问题的简便方法FloatParseHandling = FloatParseHandling.Decimal
Easy way to fix this set FloatParseHandling = FloatParseHandling.Decimal
示例:
public class Foo
{
public object Value { get; set; }
}
Foo original = new Foo
{
Value = 1.23m
};
string json = JsonConvert.SerializeObject(original);
var settings = new JsonSerializerSettings
{
FloatParseHandling = FloatParseHandling.Decimal //hint
};
Foo actual = JsonConvert.DeserializeObject<Foo>(json, settings);
// actual.Value.GetType() == 'Decimal'
这篇关于Newtonsoft JSON-到/从数据集的转换会导致十进制变为Double?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文