/// <summary>
/// 提示信息
/// </summary>
/// <param name="tips"></param>
/// <param name="showBox">是否显示弹窗</param>
public static void ShowTips(string tips, bool isShowMessageBox)
{
AppCurrent.Tip.Tips += string.Format("{0} {1}\r\n", DateTime.Now.ToString("HH:mm:ss"), tips);
var log = new OperationLog
{
User = AppCurrent.User,
DateTime = DateTime.Now,
Content = tips
};
Context.OperationContext.Operations.Add(log);
Context.OperationContext.SaveChanges();
if (isShowMessageBox)
{
Tip.Alert(tips);
}
}
/// <summary>
/// 导出Excel方法
/// </summary>
/// <param name="dt">数据源</param>
/// <param name="DefaultFileName">默认文件名</param>
/// <param name="SheetName">Excel表名</param>
public static void Export(DataTable dt, string DefaultFileName, string SheetName)
{
if (dt == null || dt.Rows.Count < 1)
{
Tip.Alert("尚无数据！");
return;
}
SaveFileDialog kk = new SaveFileDialog();
kk.Title = "保存EXECL文件";
kk.Filter = "EXECL文件(*.xlsx) |*.xlsx |所有文件(*.*) |*.*";
kk.FilterIndex = 1;
//默认文件名
kk.FileName = DefaultFileName;
if (kk.ShowDialog() == true)
{
string FileName = kk.FileName;
if (File.Exists(FileName))
{
File.Delete(FileName);
}
try
{
using (ExcelHelper excelHelper = new ExcelHelper(FileName))
{
int count = excelHelper.DataTableToExcel(dt, SheetName, true);
if (count > 0)
{
Tip.Alert("导出为Excel成功！");
}
}
}
catch (Exception ex)
{
Tip.Alert("导出Excel出现异常: \r\n" + ex.Message);
}
}
}