public SystemAdministrator_Logging()
{
InitializeComponent();
InitLoggingTable();
LoggingTable.DataTableSelect("select * from SysLog where UserName in( select RyId from ArmsUsers where User_type = '普通用户') ", "更新");
InitRightBm();
}
public void InitRightBm()
{
MenuItem TempMenu = LoggingTable.AddMenuItem("事件内容");
MenuItem DeletRowMenu1 = LoggingTable.AddMenuItem("删除选中的行");
TempMenu.Click += EventContent;
DeletRowMenu1.Click += DeletRows1;
LoggingTable.dgMenu.Items.Add(TempMenu);
LoggingTable.dgMenu.Items.Add(DeletRowMenu1);
}
private void InitLoggingTable()
{
LoggingTable.InitTableHeightWidth(449, 1250);
LoggingTable.SetCanUserAddRows(false);
LoggingTable.AddColumns("LogId", "日志编号", 80);
LoggingTable.AddColumns("LogDate", "事件发生日期", 120);
LoggingTable.AddColumns("LogTime", "事件发生时间", 120);
LoggingTable.AddColumns("LogType", "事件类型", 120);
LoggingTable.AddColumns("Title", "事件标题", 160);
LoggingTable.AddColumns("UserName", "操作用户编号", 169);
LoggingTable.AddColumns("Body", "事件内容", 580);
}
public void EventContent(object sender, RoutedEventArgs e)
{
moinf = new MoreInf();
string[] Table_Str = { "LogId", "LogDate", "LogTime", "LogType", "Title", "UserName", "Body" };
if (LoggingTable.dataGrid.SelectedIndex != -1)
{
moinf.SetValues(LoggingTable.Getdt(), LoggingTable.dataGrid.SelectedIndex, LoggingTable.Rows, Table_Str, Str, 7);
moinf.Show();
}
else
{
MessageBox.Show("当前未选中任何行！");
}
}
private void OrdinarySearch_button_Click(object sender, RoutedEventArgs e)
{
string StrSql = "select * from SysLog where UserName ='******'";
try
{
SqlCommand Ori = new SqlCommand(StrSql, Temp.GetConn());
if (Ori.ExecuteScalar() == null)
{
MessageBox.Show("无此人员！");
}
else
{
LoggingTable.DataTableSelect(StrSql, "更新");
}
}
catch (Exception a)
{
MessageBox.Show("提交失败！" + a);
return;
}
}
private void user_DropDownClosed(object sender, EventArgs e)
{
LoggingTable.DataTableSelect(loggingRy(user.SelectedIndex), "更新");
}
private void OrdinaryExport_button_Click(object sender, RoutedEventArgs e)
{
LoggingTable.ExportExcel(loggingRy(user.SelectedIndex), Str, "事件日志表格.xlsx");
}
