/// <summary>
/// 点击查询按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button1_Click(object sender, EventArgs e)
{
string condition = "";
string value = textBox1.Text;
if (comboBox1.Text == "员工姓名")
{
condition = "name";
}
if (comboBox1.Text == "性别")
{
condition = "gender";
}
//模糊查询关键字
string sql = string.Format("SELECT [Id],[name],[gender],[date] FROM [Attendance] WHERE [{0}] LIKE '%{1}%'", condition, value);
DataTable dt = AttendanceDAL.FindDataTable(sql);
dataGridView1.DataSource = null;
dataGridView1.Columns.Clear();
dataGridView1.DataSource = dt;
dataGridView1.Columns["name"].HeaderText = "员工姓名";
dataGridView1.Columns["gender"].HeaderText = "性别";
dataGridView1.Columns["date"].HeaderText = "考勤日期";
dataGridView1.Columns["Id"].HeaderText = "考勤ID";
}