public SystemAdministrator_Logging() { InitializeComponent(); InitLoggingTable(); LoggingTable.DataTableSelect("select * from SysLog where UserName in( select RyId from ArmsUsers where User_type = '普通用户') ", "更新"); InitRightBm(); }
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), "更新"); }