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)); }