public UserLogWin(string RyId)
{
InitializeComponent();
SQL = "select * from SysLog where UserName ='******'";
SetCulnms();
TableToUserLog.DataTableSelect(SQL, "更新");
label1.Content = TableToUserLog.dt.Rows.Count;
}
public void SetCulnms()
{
TableToUserLog.InitTableHeightWidth(498, 960);
TableToUserLog.SetCanUserAddRows(false);
TableToUserLog.AddColumns("UserName", "用户编号", 80);
TableToUserLog.AddColumns("LogId", "日志编号", 80);
TableToUserLog.AddColumns("LogDate", "发生日期", 140);
TableToUserLog.AddColumns("LogTime", "发生时间", 140);
TableToUserLog.AddColumns("LogType", "日志类型", 80);
TableToUserLog.AddColumns("Title", "日志标题", 200);
TableToUserLog.AddColumns("Body", "日志内容", 260);
}
private void button1_Click(object sender, RoutedEventArgs e)
{
string[] Str = { "日志编号", "发生日期", "发生时间", "日志类型", "日志标题", "日志内容",
"操作编号" };
TableToUserLog.ExportExcel(SQL, Str, "操作日志.xlsx");
}
