private void btn_Click(object sender, RoutedEventArgs e)
{
try
{
var txt = (sender as Button).Name;
switch (txt)
{
case "query":
var frmFilter = new FormListFilterPopup();
frmFilter.Filter = m_filter;
frmFilter.FilterPopupEvent += (args) =>
{
m_filter = args.Filter;
Query();
};
frmFilter.Show();
break;
case "export":
break;
case "refresh":
Query();
break;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
FinanceMessageBox.Error(ex.Message);
}
}
private void btn_Click(object sender, RoutedEventArgs e)
{
try
{
var txt = (sender as Button).Name;
switch (txt)
{
case "query":
var frmFilter = new FormListFilterPopup();
frmFilter.Filter = m_filter;
frmFilter.Hide2();
frmFilter.FilterPopupEvent += (args) =>
{
m_filter = args.Filter;
m_lstTemplate = DataFactory.Instance.GetTemplateExecuter().GetExcelTemplate("利润表");
SheetModel = SheetModel;
};
frmFilter.Show();
break;
case "export":
break;
case "refresh":
m_lstTemplate = DataFactory.Instance.GetTemplateExecuter().GetExcelTemplate("利润表");
SheetModel = SheetModel;
break;
case "formula":
if (SheetModel == SheetModel.FORMULA)
{
SheetModel = SheetModel.DATA;
}
else
{
SheetModel = SheetModel.FORMULA;
}
break;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
FinanceMessageBox.Error(ex.Message);
}
}
private void btn_Click(object sender, RoutedEventArgs e)
{
try
{
var txt = (sender as Button).Name;
switch (txt)
{
case "query":
var frmFilter = new FormListFilterPopup();
frmFilter.Filter = m_filter;
frmFilter.FilterPopupEvent += (args) =>
{
m_filter = args.Filter;
SheetModel = SheetModel;
};
frmFilter.Show();
break;
case "refresh":
SheetModel = SheetModel;
break;
case "formula":
if (SheetModel == SheetModel.FORMULA)
{
SheetModel = SheetModel.DATA;
}
else
{
SheetModel = SheetModel.FORMULA;
}
break;
case "exportformula":
SaveFileDialog sflg = new SaveFileDialog();
sflg.Filter = "Excel(*.xls)|*.xls|Excel(*.xlsx)|*.xlsx";
sflg.FileName = "资产负债表";
var bRnt = sflg.ShowDialog();
if (bRnt == null || bRnt == false)
{
return;
}
ExcelExportor exportor = new ExcelExportor(new BalanceSheetExportHandler());
var dt = EntityConvertor <ExcelTemplateItem> .ToDataTable(m_lstTemplate);
MemoryStream ms = new MemoryStream();
string flg = FileHelper.FileSuffix(sflg.FileName);
exportor.Export(ms, dt, flg);
using (FileStream fs = new FileStream(sflg.FileName, FileMode.Create, FileAccess.Write))
{
byte[] data = ms.ToArray();
fs.Write(data, 0, data.Length);
fs.Flush();
}
ms.Close();
ms.Dispose();
FileHelper.ExplorePath(sflg.FileName.Substring(0, sflg.FileName.LastIndexOf("\\")));
break;
case "importformula":
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "Excel(*.xls)|*.xls|Excel(*.xlsx)|*.xlsx";
ofd.Title = "选择文件";
ofd.RestoreDirectory = true;
if (ofd.ShowDialog() == true)
{
DataFactory.Instance.GetTemplateExecuter().UploadTemplate("BalanceSheet", ofd.FileName);
FinanceMessageBox.Info("导入成功");
}
break;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
FinanceMessageBox.Error(ex.Message);
}
}
