/// <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>
/// Xml转Excel操作
/// </summary>
private void XmlToExcels()
{
XmlUtilities xmlUtilities = new XmlUtilities();
var data = xmlUtilities.ConvertXMLToDataSet(文件路径.Text);
if (data != null && data.Rows.Count > 0)
{
ExcelUtilities excelUtilities = new ExcelUtilities();
if (excelUtilities.ToExcel(data, 文件夹路径.Text))
{
MessageCommon.ShowInf("转换成功");
}
else
{
MessageCommon.ShowErr("转换失败");
}
}
}
/// <summary>
/// json转Excel操作
/// </summary>
private void JsonToExcels()
{
JsonUtilities jsonUtilities = new JsonUtilities();
var dataTale = jsonUtilities.JsonToData(文件路径.Text);
if (dataTale != null && dataTale.Rows.Count > 0)
{
ExcelUtilities excelUtilities = new ExcelUtilities();
if (excelUtilities.ToExcel(dataTale, 文件夹路径.Text))
{
MessageCommon.ShowInf("转换成功");
}
else
{
MessageCommon.ShowErr("转换失败");
}
}
}