/// <summary>
/// 导出本地excel
/// </summary>
/// <param name="lists"></param>
public void ExportExcel(List <InfoListModel> lists)
{
try
{
string file = NPOIUtil.OpenSaveExcelDialog();
if (file != null)
{
Task.Run(() =>
{
this.Dispatcher.Invoke(() => { ShowExportLoding("数据正在导出...请勿关闭电源或录入信息"); });
DataTable dt = new DataTable();
Dictionary <string, string> header = NPOIUtil.InfoListModel2Head();
dt = NPOIUtil.List2DataTable(lists, header);
NPOIUtil.RenderDataTableToExcel(dt, file);
this.Dispatcher.Invoke(() =>
{
CloseExportLoding();
ShowOK("数据导出完成");
});
});
}
}
catch (Exception ex)
{
CloseExportLoding();
MessageTips(ex.Message);
}
finally
{
autoRead_Timer.Start();
}
}
/// <summary>
/// 导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void InData_Click(object sender, RoutedEventArgs e)
{
try
{
autoRead_Timer.Stop();
string file = NPOIUtil.OpenJsonDialog();
if (file != null)
{
Task.Run(() =>
{
this.Dispatcher.Invoke(() =>
{
ShowExportLoding("数据正在导入...请勿关闭电源或录入信息");
});
List <InfoListModel> newlists = SettingJsonConfig.readData(file) ?? new List <InfoListModel>();
List <InfoListModel> oldlists = SettingJsonConfig.readData() ?? new List <InfoListModel>();
foreach (var item in newlists)
{
if (!oldlists.Any(u => u.acidNo == item.acidNo))
{
oldlists.Add(item);
}
}
SettingJsonConfig.saveData(oldlists);
this.Dispatcher.Invoke(() =>
{
CloseExportLoding();
ShowOK("数据导入完成");
});
});
}
}
catch (Exception ex)
{
MessageTips(ex.Message);
}
finally
{
autoRead_Timer.Start();
}
}
public void ExportJson(List <InfoListModel> lists)
{
try
{
string file = NPOIUtil.OpenSaveJsonDialog();
if (file != null)
{
Task.Run(() =>
{
this.Dispatcher.Invoke(() =>
{
ShowExportLoding("数据正在导出...请勿关闭电源或录入信息");
});
foreach (var item in lists)
{
item.versions = 1;
}
SettingJsonConfig.saveJson(lists, file);
this.Dispatcher.Invoke(() =>
{
CloseExportLoding();
ShowOK("数据导出完成");
});
});
}
}
catch (Exception ex)
{
CloseExportLoding();
MessageTips(ex.Message);
}
finally
{
autoRead_Timer.Start();
}
}
