private void DoSearch(bool searchCount = false)
{
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_LOG_INFO logBll = new Maticsoft.BLL.SMT_LOG_INFO();
if (searchCount)
{
int count = logBll.GetRecordCount(pageDataGridView.SqlWhere);
this.Invoke(new Action(() =>
{
pageDataGridView.Reset();
pageDataGridView.PageControl.TotalRecords = count;
}));
}
var ds = logBll.GetListByPage(pageDataGridView.SqlWhere, "OPR_TIME desc", pageDataGridView.PageControl.StartIndex, pageDataGridView.PageControl.EndIndex);
var models = logBll.DataTableToList(ds.Tables[0]);
this.Invoke(new Action(() =>
{
ShowModels(models);
}));
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "查询日志异常：" + ex.Message);
log.Error("查询日志异常：", ex);
}
});
waiting.Show(this);
}
private static void DoSave(string logType, LogLevel level, string msg)
{
ThreadPool.QueueUserWorkItem(new WaitCallback((o) =>
{
try
{
Maticsoft.BLL.SMT_LOG_INFO logBll = new Maticsoft.BLL.SMT_LOG_INFO();
Maticsoft.Model.SMT_LOG_INFO model = new Maticsoft.Model.SMT_LOG_INFO();
model.OPR_CONTENT = msg;
model.LOG_LEVEL = (int)level;
model.OPR_TIME = DateTime.Now;
model.LOG_TYPE = logType;
model.OPR_USERID = UserInfoHelper.UserID;
if (string.IsNullOrWhiteSpace(UserInfoHelper.UserInfo.REAL_NAME))
{
model.OPR_REALNAME = UserInfoHelper.UserInfo.USER_NAME;
}
else
{
model.OPR_REALNAME = UserInfoHelper.UserInfo.USER_NAME + "(" + UserInfoHelper.UserInfo.REAL_NAME + ")";
}
logBll.Add(model);
}
catch (Exception ex)
{
log.Error("保存日志到数据库异常：" + ex.Message + "=>" + logType + "," + level + "," + msg);
}
}));
}
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);
}
