private void textBox1_TextChanged(object sender, EventArgs e) { int num; if (int.TryParse(textBox1.Text, out num)) { DataTable dt = new DataTable(); string str = "select * from userInfo where userID ='" + textBox1.Text + "'"; dt = operate.getTables(str); int i = dt.Rows.Count; dt.Dispose(); if (i > 0) { textBox1.ForeColor = Color.Red; label2.BorderStyle = BorderStyle.FixedSingle; } else { textBox1.ForeColor = Color.Black; label2.BorderStyle = BorderStyle.None; } } else { textBox1.ForeColor = Color.Red; label2.BorderStyle = BorderStyle.FixedSingle; } }
private void userAuthValue_SelectedIndexChanged(object sender, EventArgs e) { switch (userAuthValue.Text) { case "毕业生": { if (stuIDValue.Text.Trim() == "") { stuIDKey.BorderStyle = BorderStyle.FixedSingle; stuIDValue.ForeColor = Color.Red; } else { string str = "select * from stuInfo where stuID ='" + stuIDValue.Text + "'"; DataTable dt = operate.getTables(str); int i = dt.Rows.Count; dt.Dispose(); if (i <= 0) { stuIDValue.ForeColor = Color.Red; stuIDKey.BorderStyle = BorderStyle.FixedSingle; } else { stuIDValue.ForeColor = Color.Black; stuIDKey.BorderStyle = BorderStyle.None; } } break; } case "教师": { if (teaNameValue.Text.Trim() == "") { teaNameKey.BorderStyle = BorderStyle.FixedSingle; teaNameValue.ForeColor = Color.Red; } else { teaNameKey.BorderStyle = BorderStyle.None; teaNameValue.ForeColor = Color.Black; } break; } case "企业": { if (corIDValue.Text.Trim() == "") { corIDKey.BorderStyle = BorderStyle.FixedSingle; corIDValue.ForeColor = Color.Red; } else { string str = "select * from corInfo where corID ='" + corIDValue.Text + "'"; DataTable dt = operate.getTables(str); int i = dt.Rows.Count; dt.Dispose(); if (i <= 0) { corIDValue.ForeColor = Color.Red; corIDKey.BorderStyle = BorderStyle.FixedSingle; } else { corIDValue.ForeColor = Color.Black; corIDKey.BorderStyle = BorderStyle.None; } } break; } case "管理": { if (adNameValue.Text.Trim() == "") { adNameKey.BorderStyle = BorderStyle.FixedSingle; adNameValue.ForeColor = Color.Red; } else { adNameKey.BorderStyle = BorderStyle.None; adNameValue.ForeColor = Color.Black; } break; } default: break; } }