/// <summary>
/// 点击导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ImgBtnExport_Click(object sender, ImageClickEventArgs e)
{
if (ActionValidator("SystemRolesExpert"))
{
DataTable dt = DbHelperSql.GetDataTable("SystemRoles", "RloeName,Remarks", (string.IsNullOrEmpty(tbRoleName.Text) ? string.Empty : " RoleName Like '%" + tbRoleName.Text + "%' "), "ID desc").Tables[0]; //导出;
dt.Columns[0].ColumnName = "角色名称";
dt.Columns[1].ColumnName = "备注说明";
ExcelManage.HaikanExcelExport("角色信息列表", dt);
}
}
/// <summary>
/// 点击导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnExport_Click(object sender, EventArgs e)
{
DataTable dt = DbHelperSql.GetDataTable("SystemLog", "UserName,TimeStr,ActionStr,IPAddress", "UserName like '%" + txtUserName.Text.Trim() + "%' order by ID desc", "").Tables[0]; //导出;
dt.Columns[0].ColumnName = "用户名";
dt.Columns[1].ColumnName = "日志时间";
dt.Columns[2].ColumnName = "操作内容";
dt.Columns[3].ColumnName = "IP地址";
ExcelManage.HaikanExcelExport("操作日志", dt);
AddSystemLog("导出操作日志", "导出");
}