private void 作者EToolStripMenuItem_Click(object sender, EventArgs e)
{
Form A = null;
if (sender.Equals(预览XToolStripMenuItem))
{
A = new MainForm();
}
else if (sender.Equals(管理BToolStripMenuItem))
{
A = new ReadInfoForm();
}
else if (sender.Equals(搜索CToolStripMenuItem))
{
A = new SearchInfoForm();
}
else if (sender.Equals(说明DToolStripMenuItem))
{
A = new ExplanationForm();
}
else if (sender.Equals(作者EToolStripMenuItem))
{
A = new Anthor();
}
this.ForMF.Dispose();
this.Hide();
A.Show();
}
static public void MoreSearch(string No, string Name, string Sex, string Age, string Dept, SearchInfoForm This)
{
string SelectText = "select * from Information where ";
bool First = false;
if (No == "" && Name == "" && Sex == "" && Age == "" && Dept == "")
{
MessageBox.Show("必须查询一项信息！", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (No != "")
{
SelectText += "No='" + No + "'"; First = true;
}
if (Name != "")
{
if (First)
{
SelectText += " and ";
}
else
{
First = true;
}
SelectText += "Name like '%" + Name + "%'";
}
if (Sex != "")
{
if (First)
{
SelectText += " and ";
}
else
{
First = true;
}
SelectText += "Sex='" + Sex + "'";
}
if (Age != "")
{
if (First)
{
SelectText += " and ";
}
else
{
First = true;
}
SelectText += "Age='" + Age + "'";
}
if (Dept != "")
{
if (First)
{
SelectText += " and ";
}
SelectText += "Dept='" + Dept + "'";
}
SqlConnection Con = new SqlConnection("server=.;database=StudentPlus;integrated security=true");
try { Con.Open(); }
catch { MessageBox.Show("数据库连接失败！请检查您的数据库！", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); System.Environment.Exit(0); }
SqlCommand Com = new SqlCommand(SelectText, Con);
SqlDataReader Reader = null;
Reader = Com.ExecuteReader();
This.tabControl1.SelectedIndex = 1;
This.dataGridView2.Rows.Clear();
try
{
while (Reader.Read())
{
foreach (DataGridViewRow Row in This.dataGridView1.Rows)
{
if (Row.Cells[0].Value.ToString().CompareTo(Reader["No"].ToString()) == 0)
{
DataGridViewRow Result = (DataGridViewRow)(Row.Clone());
for (int i = 0; i < Row.Cells.Count; ++i)
{
Result.Cells[i].Value = Row.Cells[i].Value;
}
This.dataGridView2.Rows.Add(Result);
break;
}
}
}
}
catch (Exception e) { MessageBox.Show(e.Message); }
if (This.dataGridView2.Rows[0].Cells[0].Value == null)
{
MessageBox.Show("没有查到相关数据！", "Result", MessageBoxButtons.OK);
}
Con.Dispose();
Com.Dispose();
Reader.Close();
}
