将datarow转换成json字符串 转换时将表字段名转小写
internal class DataRowConverter: Newtonsoft.Json.Converters.CustomCreationConverter<DataRow>
{
public override bool CanWrite => true;
public override DataRow Create(Type objectType)
{
return null;
}
public override void WriteJson(JsonWriter writer, object value, JsonSerializer serializer)
{
if (value == null)
{
writer.WriteNull();
return;
}
writer.WriteStartObject();
DataRow row = (DataRow)value;
foreach (DataColumn column in row.Table.Columns)
{
object obj2 = row[column];
if (serializer.NullValueHandling != NullValueHandling.Ignore || (obj2 != null && obj2 != DBNull.Value))
{
writer.WritePropertyName(column.ColumnName.ToLower());
serializer.Serialize(writer, obj2);
}
}
writer.WriteEndObject();
}
}