private void btnSearch_HocSinh_Click(object sender, EventArgs e)
{
if (cbOption.Text.Equals(""))
{
MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cbOption.Text.Equals("Mã học sinh"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "HocSinh";
string key = "mahocsinh";
dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'");
LockControl();
}
if (cbOption.Text.Equals("Tên học sinh"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "HocSinh";
string key = "hoten";
dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'");
LockControl();
}
if (cbOption.Text.Equals("Mã lớp"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "HocSinh";
string key = "malop";
dgvHocSinh.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_HocSinh.Text.Trim() + "%'");
LockControl();
}
}
private void btnSearch_GiangDay_Click(object sender, EventArgs e)
{
if (cbOption_GiangDay.Text.Equals(""))
{
MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cbOption_GiangDay.Text.Equals("Mã giáo viên"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "GiangDay";
string key = "magiaovien";
dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'");
LockControl();
}
if (cbOption_GiangDay.Text.Equals("Mã lớp học"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "GiangDay";
string key = "malop";
dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'");
LockControl();
}
if (cbOption_GiangDay.Text.Equals("Mã môn học"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "GiangDay";
string key = "mamonhoc";
dgvGiangDay.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_GiangDay.Text.Trim() + "%'");
LockControl();
}
}
private void btnSearch_ChucVu_Click(object sender, EventArgs e)
{
if (cbOption_ChucVu.Text.Equals(""))
{
MessageBox.Show("Chọn tiêu chí cần sắp xếp", "ERROR!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (cbOption_ChucVu.Text.Equals("Mã chức vụ"))
{
DATA.SqlConn sql = new DATA.SqlConn();
string tb = "ChucVu";
string key = "machucvu";
dgvChucVu.DataSource = sql.searchQuery("select * from " + tb + " where " + key + " Like '%" + txtSearch_ChucVu.Text.Trim() + "%'");
LockControl();
}
}
