private void pageDataGridView1_PageControl_ExportAll(object sender, Li.Controls.PageEventArgs args)
{
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_LOG_INFO logBll = new Maticsoft.BLL.SMT_LOG_INFO();
var models = logBll.GetModelList(pageDataGridView.SqlWhere + " order by OPR_TIME desc");
DataTable dt = new DataTable();
foreach (DataGridViewColumn item in dgvData.Columns)
{
dt.Columns.Add(item.HeaderText);
}
foreach (var item in models)
{
string str = "信息";
switch (item.LOG_LEVEL)
{
case 0:
str = "调试";
break;
case 1:
str = "信息";
break;
case 2:
str = "警告";
break;
case 3:
str = "错误";
break;
default:
break;
}
DataRow row = dt.NewRow();
row[0] = item.OPR_REALNAME;
row[1] = item.OPR_TIME;
row[2] = str;
row[3] = item.LOG_TYPE;
row[4] = item.OPR_CONTENT;
dt.Rows.Add(row);
}
this.Invoke(new Action(() =>
{
ExportHelper.ExportEx(dt, "操作日志" + dtpStart.Value.ToString("yyyyMMddHHmmss") + "_" + dtpEnd.Value.ToString("yyyyMMddHHmmss") + ".xls", "操作日志" + dtpStart.Value.ToString("yyyyMMddHHmmss") + "_" + dtpEnd.Value.ToString("yyyyMMddHHmmss"));
}));
}
catch (System.Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "导出操作日志异常：" + ex.Message);
log.Error("导出操作日志异常：", ex);
}
});
waiting.Show(this);
}
