public static string ToJson(this object o)
{
string data;
try
{
if (o != null)
{
if (utilidades.getTipo(o).ToLower() == "dataset")
{
data = DataSetConverter.ToJson((DataSet)o);
}
else if (utilidades.getTipo(o).ToLower() == "datatable")
{
data = DataTableConverter.ToJson((DataTable)o);
}
else
{
data = JsonSerializer.Serialize(o);
}
}
else
{
data = "{\"Object\":\"NULL\"}";
}
}
catch (Exception ex)
{
data = $"{{\"Exception\":\"{ex.Message}\"}}";
}
return(data);
}
public void ShouldConvertUncompressed()
{
var unBytes = DataSetConverter.ToBytes(DataSetTestContent.DS, false);
var fromUnBytes = DataSetConverter.FromBytes(unBytes, false);
Assert.IsTrue(IsSetSame(DataSetTestContent.DS, fromUnBytes));
}
public void ShouldConvertCompressed()
{
var bytes = DataSetConverter.ToBytes(DataSetTestContent.DS);
var fromBytes = DataSetConverter.FromBytes(bytes);
Assert.IsTrue(IsSetSame(DataSetTestContent.DS, fromBytes));
Assert.IsFalse(IsSetSame(DataSetTestContent.FalseDS, fromBytes));
}
public void WriteJsonNull()
{
StringWriter sw = new StringWriter();
JsonTextWriter jsonWriter = new JsonTextWriter(sw);
DataSetConverter converter = new DataSetConverter();
converter.WriteJson(jsonWriter, null, null);
StringAssert.AreEqual(@"null", sw.ToString());
}
protected override void ProcessRecord()
{
WriteProgress(new ProgressRecord(1, "Conversion", "Converting database..."));
AccessDbHelper acccessdbHelper = new AccessDbHelper(AccessDbFilePath, "Database");
IJsonConverter dbJsonConverter = new DataSetConverter(acccessdbHelper.GetDataSet());
string databaseJson = dbJsonConverter.ConvertToJson();
if (SaveOutputToFile)
{
FileHelper.SaveToFile(databaseJson, $"output_{Guid.NewGuid()}.json");
}
WriteObject(databaseJson);
}
private void buttonConvert_Click(object sender, EventArgs e)
{
try
{
ApplicationSettings.Instance.ConvertFromPath = textBoxConvertFromPath.Text;
ApplicationSettings.Instance.ConvertToPath = textBoxConvertToPath.Text;
ApplicationSettings.Instance.ConvertReportPath = textBoxConvertReportPath.Text;
HelperClasses.TimeTools timer = new HelperClasses.TimeTools();
timer.Start();
var inputPath = textBoxConvertFromPath.Text;
var outputPath = textBoxConvertToPath.Text;
var reportPath = textBoxConvertReportPath.Text;
DataSetConverter.Convert(inputPath, outputPath, reportPath);
timer.Stop();
WindowsHelperMethods.ShowInformationMessage("عملیات با موفقیت خاتمه یافت. زمان اجرا : {0} ثانیه.", timer.StringEllapsedTime);
}
catch (Exception exception)
{
HandleUIException(exception, "بروز خطا هنگام تبدیل فایل ورودی.");
}
}
/// <summary>
/// 将object转为Json字符串
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static string JsonString(object obj)
{
DataSetConverter dataSetConverter = new DataSetConverter();
DataTableConverter dataTableConverter = new DataTableConverter();
JsonSerializer json = new JsonSerializer();
json.ObjectCreationHandling = ObjectCreationHandling.Replace;
json.MissingMemberHandling = MissingMemberHandling.Ignore;
json.ReferenceLoopHandling = ReferenceLoopHandling.Ignore;
json.Converters.Add(dataSetConverter);
json.Converters.Add(dataTableConverter);
StringBuilder sbJson = new StringBuilder();
using (StringWriter writer = new StringWriter(sbJson))
{
json.Serialize(writer, obj);
}
string ps = sbJson.ToString();
return(ps);
}
public void GasCostUncompressedShouldMatch()
{
var bytes = DataSetConverter.ToBytes(DataSetTestContent.DS, false);
Assert.AreEqual(DataSetTestContent.UncompressedGas, EthereumConnection.EstimateGasCost(bytes));
}
