private void FormThemLopHoc_Load(object sender, EventArgs e)
{
CSDL csdl = new CSDL();
// ma MHP
string getAllMaMHP = "SELECT MaMHP FROM MUCHOCPHI";
DataTable maMHPTable = csdl.SelectData(getAllMaMHP);
comboBoxMaMHP.DataSource = maMHPTable.Copy();
comboBoxMaMHP.DisplayMember = "MaMHP";
comboBoxMaMHP.ValueMember = "MaMHP";
//ma mon học
string getAllMaMH = "SELECT MaMH FROM MONHOC";
DataTable maMHTable = csdl.SelectData(getAllMaMH);
comboBoxMaMonHoc.DataSource = maMHTable.Copy();
comboBoxMaMonHoc.DisplayMember = "MaMH";
comboBoxMaMonHoc.ValueMember = "MaMH";
// mã giáo viên
string getAllMaGV = "SELECT MaGV FROM GIAOVIEN";
DataTable maGVTable = csdl.SelectData(getAllMaGV);
comboBoxMaGiaoVien.DataSource = maGVTable.Copy();
comboBoxMaGiaoVien.DisplayMember = "MaGV";
comboBoxMaGiaoVien.ValueMember = "MaGV";
if (string.IsNullOrEmpty(malh))
{
this.Text = "Thêm mới lớp học";
}
else
{
this.Text = "Cập nhật thông tin lớp học";
var r = new CSDL().Select(string.Format("searchMaLop '" + malh + "'"));
textBoxMaLop.Text = r["MaLH"].ToString();
textBoxMaLop.ReadOnly = true;
textBoxTenLop.Text = r["TenLH"].ToString();
string maMucHocPhi = r["MaMHP"].ToString();
Console.WriteLine(maMucHocPhi);
comboBoxMaMHP.SelectedValue = maMucHocPhi;
string maMonHoc = r["MaMH"].ToString();
comboBoxMaMHP.SelectedValue = maMonHoc;
string maGiaoVien = r["MaGV"].ToString();
comboBoxMaMHP.SelectedValue = maGiaoVien;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(textBox1.Text))
{
MessageBox.Show("Bạn chưa nhập thông tin tìm kiếm", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (comboBoxSearch.SelectedIndex != -1)
{
String valueSearch = textBox1.Text;
var db = new CSDL();
String sqlSearch = "";
if (comboBoxSearch.SelectedIndex == 0)
{
sqlSearch = "exec searchMaLop '" + valueSearch + "'";
if (db.SelectData(sqlSearch).Rows.Count != 0)
{
new SearchOutLH(sqlSearch).Show();
}
else
{
MessageBox.Show("Không tìm thấy thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (comboBoxSearch.SelectedIndex == 1)
{
sqlSearch = "exec searchTenLop N'" + valueSearch + "'";
if (db.SelectData(sqlSearch).Rows.Count != 0)
{
new SearchOutLH(sqlSearch).Show();
}
else
{
MessageBox.Show("Không tìm thấy thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
resetValue();
}
}
private void FormQLDD_Load(object sender, EventArgs e)
{
CSDL csdl = new CSDL();
string getAllMaLH = "SELECT MaLH FROM LOPHOC";
DataTable maLHTable = csdl.SelectData(getAllMaLH);
comboBoxChonLop.DataSource = maLHTable.Copy();
comboBoxChonLop.DisplayMember = "MaLH";
comboBoxChonLop.ValueMember = "MaLH";
comboBoxChonLop.SelectedIndex = 7;
comboBoxChonThang.SelectedIndex = 8;
}