private void Window_Loaded(object sender, RoutedEventArgs e) { Information INFor = new SystemOfTest.Information(); INFor.Class = StaticInform.Class; INFor.Name = StaticInform.Name; INFor.Num = StaticInform.Num; textClass.DataContext = INFor; textName.DataContext = INFor; textNum.DataContext = INFor; }
private void button_Click(object sender, RoutedEventArgs e) { if (textNum.Text.Trim() == string.Empty) { MessageBox.Show("请输入学号"); } else { Information InFor = new SystemOfTest.Information(); string cmdText = "select T_StuClass,T_StuName,T_StuNum from T_Students where T_StuNum=@Num"; SqlParameter parameters = new SqlParameter("@Num", textNum.Text); DataSet dataset = new DataSet(); dataset = SqlHelper.ExcuteDataSet(cmdText, parameters); DataTable table = dataset.Tables[0]; DataRowCollection rows = table.Rows; for (int i = 0; i < rows.Count; i++) { DataRow row = rows[i]; InFor.Class = (string)row["T_StuClass"]; InFor.Name = (string)row["T_StuName"]; InFor.Num = (string)row["T_StuNum"]; } LoGing_Grid.DataContext = InFor; //textName.DataContext = InFor; if (Convert.ToString(textNum.Text) != InFor.Num) { MessageBox.Show("没有该考生信息,请重新输入!"); } else { if (System.Windows.MessageBox.Show("信息核对完毕?", "信息核对", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes) == MessageBoxResult.Yes) { StaticInform.Class = InFor.Class; StaticInform.Name = InFor.Name; StaticInform.Num = InFor.Num; btCheck.Visibility = Visibility.Collapsed; btLoging.Visibility = Visibility.Visible; wp1.Visibility = Visibility.Visible; wp2.Visibility = Visibility.Visible; btLoging.Focus(); } } } return; }
private void btLoging_Click(object sender, RoutedEventArgs e) { string id = ID.Text.Trim(); string pas = PS.Password; Information InFor = new SystemOfTest.Information(); string cmdText = "select * from T_TeachUser where Teach_UserName=@UserName and Teach_PassWord=@PassWord"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserName", ID.Text), new SqlParameter("@PassWord", PS.Password) }; DataSet dataset = new DataSet(); dataset = SqlHelper.ExcuteDataSet(cmdText, parameters); DataTable table = dataset.Tables[0]; DataRowCollection rows = table.Rows; for (int i = 0; i < rows.Count; i++) { DataRow row = rows[i]; InFor.ID = (string)row["Teach_UserName"]; InFor.PS = (string)row["Teach_PassWord"]; } TL_Grid.DataContext = InFor; if (id == InFor.ID && pas == InFor.PS) { this.Close(); SetQuestion SQ = new SystemOfTest.SetQuestion(); SQ.Show(); } if (id != string.Empty && pas != string.Empty) { if (ID.Text != InFor.ID || pas != InFor.PS) { MessageBox.Show("用户名或密码错误!"); return; } } if (id == string.Empty || pas == string.Empty) { MessageBox.Show("请输入账号和密码!"); return; } }