/// <summary>
/// 导出数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lblExport_MouseDown(object sender, MouseButtonEventArgs e)
{
string savePath = Load.getSavePath();
List <Data> list = new List <Data>();
if (lswData.ItemsSource != null)
{
foreach (Data data in lswData.ItemsSource)
{
list.Add(data);
}
if (!string.IsNullOrEmpty(savePath))
{
ExcelOperate.exportDataToExcel(savePath, list);
MessageBox.Show("生成完成");
System.Diagnostics.Process.Start(savePath);
}
}
}
private void lblImport_MouseDown(object sender, MouseButtonEventArgs e)
{
try {
bool autoCalculate = (bool)cbxAutoCalculate.IsChecked;
if (cbxTown.SelectedIndex != 0)
{
foreach (Data data in ExcelOperate.getDataList(tbxPath.Text, cbxTown.Text, autoCalculate))
{
DataOperate.insertData(data);
}
MessageBox.Show(Messages.IMPORT_COMPLETE);
}
else
{
MessageBox.Show(Messages.IMPORT_NOTIFY);
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
