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"); }