private void BtnQuery_Click_1(object sender, RoutedEventArgs e) { //非空判断 if (txtNum.Text == null || txtName.Text == null) { MessageBox.Show("请输入查询条件"); } else if (txtNum.Text != "" && txtName.Text == "") { string Num = txtNum.Text; DataTable data = ser.showTeacherInfo1(Num); data.Columns[0].ColumnName = "工号"; data.Columns[1].ColumnName = "姓名"; data.Columns[2].ColumnName = "性别"; data.Columns[3].ColumnName = "院系"; data.Columns[4].ColumnName = "密码"; datagridShowInfo.ItemsSource = data.DefaultView; } else if (txtNum.Text == "" && txtName.Text != "") { string Name = txtName.Text; DataTable data = ser.showTeacherInfo2(Name); data.Columns[0].ColumnName = "工号"; data.Columns[1].ColumnName = "姓名"; data.Columns[2].ColumnName = "性别"; data.Columns[3].ColumnName = "院系"; data.Columns[4].ColumnName = "密码"; datagridShowInfo.ItemsSource = data.DefaultView; } else if (txtNum.Text != "" && txtName.Text != "") { string Num = txtNum.Text; string Name = txtName.Text; DataTable data = ser.showTeacherInfo3(Num, Name); data.Columns[0].ColumnName = "工号"; data.Columns[1].ColumnName = "姓名"; data.Columns[2].ColumnName = "性别"; data.Columns[3].ColumnName = "院系"; data.Columns[4].ColumnName = "密码"; datagridShowInfo.ItemsSource = data.DefaultView; } }