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