/// <summary>
/// 导出文件
/// </summary>
/// <param name="fileUrl">保存位置</param>
/// <param name="files">文件类型</param>
public bool ExportFile(string fileUrl, string files)
{
if (dt == null && dt.Rows.Count > 0)
{
MessageCommon.ShowErr("结果集不能为空！");
}
if (files == FileEnum.JsonFiles)
{
JsonUtilities jsonUtilities = new JsonUtilities();
return(jsonUtilities.SaveJson(dt, fileUrl));
}
else if (files == FileEnum.ExcelFiles)
{
ExcelUtilities excelUtilities = new ExcelUtilities();
return(excelUtilities.ToExcel(dt, fileUrl));
}
else if (files == FileEnum.XMLFiles)
{
XmlUtilities xmlUtilities = new XmlUtilities();
string xml = xmlUtilities.ConvertDataTableToXML(dt);
return(xmlUtilities.SaveXml(xml, fileUrl));
}
else
{
return(false);
}
}
/// <summary>
/// Excel转Json操作
/// </summary>
private void ExcelToXmls()
{
ExcelUtilities excelUtilities = new ExcelUtilities();
var data = excelUtilities.ExcelToDataTable(文件路径.Text);
if (data != null && data.Rows.Count > 0)
{
XmlUtilities xmlUtilities = new XmlUtilities();
string xml = xmlUtilities.ConvertDataTableToXML(data);
if (xmlUtilities.SaveXml(xml, 文件夹路径.Text))
{
MessageCommon.ShowInf("转换成功");
}
else
{
MessageCommon.ShowErr("转换失败");
}
}
}
