private void frmLop_Load(object sender, EventArgs e)
{
string strSelect = "Select * From LopHoc";
MyPublic.OpenData(strSelect, lop, "LopHoc");
strSelect = "Select MaTT, TenTT From TrungTam";
MyPublic.OpenData(strSelect, trungtam, "TrungTam");
cbTrungtam.DataSource = trungtam.Tables["TrungTam"];
cbTrungtam.DisplayMember = "TenTT";
cbTrungtam.ValueMember = "MaTT";
txtMalop.MaxLength = 8;
txtTenlop.MaxLength = 40;
dgvLophoc.DataSource = lop;
dgvLophoc.DataMember = "LopHoc";
dgvLophoc.Width = 525;
dgvLophoc.AllowUserToAddRows = false;
dgvLophoc.AllowUserToDeleteRows = false;
dgvLophoc.Columns[0].Width = 100;
dgvLophoc.Columns[0].HeaderText = "Mã lớp";
dgvLophoc.Columns[1].Width = 265;
dgvLophoc.Columns[1].HeaderText = "Tên lớp";
dgvLophoc.Columns[2].Width = 100;
dgvLophoc.Columns[2].HeaderText = "Mã trung tâm";
dgvLophoc.EditMode = DataGridViewEditMode.EditProgrammatically;
GanDuLieu();
DieuKhienKhiBinhThuong();
}
private void frmBaithitheolophoc_Load(object sender, EventArgs e)
{
string select = "Select MaLop, MaMon, LanThi, HocKy, NamHoc, NgayThi, SoBai, NgayNhan, HanNop From TheoDoiBaiThi";
MyPublic.OpenData(select, dsbaithi, "TheoDoiBaiThi");
select = "Select TenLop, MaLop From LopHoc";
MyPublic.OpenData(select, lop, "LopHoc");
select = "Select MaMon, TenMon From MonHoc";
MyPublic.OpenData(select, mon, "MonHoc");
cbLophoc.DataSource = lop.Tables["LopHoc"];
cbLophoc.DisplayMember = "TenLop";
cbLophoc.ValueMember = "MaLop";
cbMonhoc.DataSource = mon.Tables["MonHoc"];
cbMonhoc.DisplayMember = "TenMon";
cbMonhoc.ValueMember = "MaMon";
dvbaithi.Table = dsbaithi.Tables["TheoDoiBaiThi"];
dvbaithi.RowFilter = "MaLop like '" + cbLophoc.SelectedValue + "'";
dgvBaithitheolop.DataSource = dvbaithi;
dgvBaithitheolop.Width = 723;
dgvBaithitheolop.AllowUserToAddRows = false;
dgvBaithitheolop.AllowUserToDeleteRows = false;
dgvBaithitheolop.Columns[0].Width = 70;
dgvBaithitheolop.Columns[0].HeaderText = "Mã lớp";
dgvBaithitheolop.Columns[1].Width = 70;
dgvBaithitheolop.Columns[1].HeaderText = "Mã môn";
dgvBaithitheolop.Columns[2].Width = 65;
dgvBaithitheolop.Columns[2].HeaderText = "Lần thi";
dgvBaithitheolop.Columns[3].Width = 70;
dgvBaithitheolop.Columns[3].HeaderText = "Học Kỳ";
dgvBaithitheolop.Columns[4].Width = 80;
dgvBaithitheolop.Columns[4].HeaderText = "Năm học";
dgvBaithitheolop.Columns[5].Width = 80;
dgvBaithitheolop.Columns[5].HeaderText = "Ngày thi";
dgvBaithitheolop.Columns[5].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvBaithitheolop.Columns[6].Width = 80;
dgvBaithitheolop.Columns[6].HeaderText = "Số bài thi";
dgvBaithitheolop.Columns[7].Width = 85;
dgvBaithitheolop.Columns[7].HeaderText = "Ngày nhận";
dgvBaithitheolop.Columns[7].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvBaithitheolop.Columns[8].Width = 80;
dgvBaithitheolop.Columns[8].HeaderText = "Hạn nộp";
dgvBaithitheolop.Columns[8].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvBaithitheolop.EditMode = DataGridViewEditMode.EditProgrammatically;
GanDuLieu();
DieuKhienKhiBinhThuong();
}
private void frmMon_Load(object sender, EventArgs e)
{
dsMHGridView.AllowUserToAddRows = false;
dsMHGridView.AllowUserToDeleteRows = false;
mamonTextBox.MaxLength = 6;
tenmonTextBox.MaxLength = 60;
tinchiTextBox.MaxLength = 10;
string query = "SELECT MaMon, TenMon, SoTinChi FROM MonHoc";
DataSet dataSet = new DataSet();
MyPublic.OpenData(query, dataSet, "MonHoc");
dsMonHoc = dataSet.Tables["MonHoc"];
dsMHGridView.DataSource = dataSet.Tables["MonHoc"];
dsMHGridView.Columns[0].Width = 95;
dsMHGridView.Columns[0].HeaderText = "Mã Môn";
dsMHGridView.Columns[1].Width = 250;
dsMHGridView.Columns[1].HeaderText = "Tên Môn";
dsMHGridView.Columns[2].Width = 100;
dsMHGridView.Columns[2].HeaderText = "Số Tín Chỉ";
if (MyPublic.quyenSD == "AdTinh" || MyPublic.quyenSD == "AdTruong")
{
themBtn.Enabled = true;
suaBtn.Enabled = true;
xoaBtn.Enabled = true;
}
else
{
themBtn.Enabled = false;
suaBtn.Enabled = false;
xoaBtn.Enabled = false;
}
dsMHGridView.Enabled = true;
mamonTextBox.Enabled = false;
tenmonTextBox.Enabled = false;
tinchiTextBox.Enabled = false;
luuBtn.Enabled = false;
khongluuBtn.Enabled = false;
displayRowAt(0);
}
private void frmTaikhoan_Load(object sender, EventArgs e)
{
dsTKGridView.AllowUserToAddRows = false;
dsTKGridView.AllowUserToDeleteRows = false;
tenTKTextBox.MaxLength = 20;
// set data cho combobox
DataTable table = new DataTable();
table.Columns.Add("QuyenSD");
table.Rows.Add("User");
table.Rows.Add("AdTruong");
table.Rows.Add("AdTinh");
quyenSDCBBox.DataSource = table;
quyenSDCBBox.DisplayMember = "QuyenSD";
quyenSDCBBox.ValueMember = "QuyenSD";
// set data cho data ma tt combobox
if (MyPublic.connection.State == ConnectionState.Closed)
{
MyPublic.connection.Open();
}
string query = "SELECT MaTT, TenTT FROM TrungTam";
DataSet dataSet = new DataSet();
MyPublic.OpenData(query, dataSet, "TrungTam");
maTTCBBox.DataSource = dataSet.Tables["TrungTam"];
maTTCBBox.DisplayMember = "TenTT";
maTTCBBox.ValueMember = "MaTT";
// set data cho data grid view
query = "SELECT TenTaiKhoan, QuyenSD, MaTT FROM NguoiSuDung";
dataSet = new DataSet();
MyPublic.OpenData(query, dataSet, "NguoiSuDung");
dsNguoiSD = dataSet.Tables["NguoiSuDung"];
dsTKGridView.DataSource = dataSet.Tables["NguoiSuDung"];
dsTKGridView.Columns[0].Width = 125;
dsTKGridView.Columns[0].HeaderText = "Tên tài khoản";
dsTKGridView.Columns[1].Width = 125;
dsTKGridView.Columns[1].HeaderText = "Quyền sử dụng";
dsTKGridView.Columns[2].Width = 125;
dsTKGridView.Columns[2].HeaderText = "Mã trung tâm";
// highlight cac button
if (MyPublic.quyenSD == "AdTinh")
{
themBtn.Enabled = true;
suaBtn.Enabled = true;
xoaBtn.Enabled = true;
}
else
{
themBtn.Enabled = false;
suaBtn.Enabled = false;
xoaBtn.Enabled = false;
}
dsTKGridView.Enabled = true;
tenTKTextBox.Enabled = false;
maTTCBBox.Enabled = false;
quyenSDCBBox.Enabled = false;
luuBtn.Enabled = false;
khongluuBtn.Enabled = false;
// select tai khoan dau tien
displayRowAt(0);
}
private void frmBaithi_Load(object sender, EventArgs e)
{
dtpNgaythi.Format = DateTimePickerFormat.Custom;
dtpNgaythi.CustomFormat = "dd-MM-yyyy";
dtpNgaynhan.Format = DateTimePickerFormat.Custom;
dtpNgaynhan.CustomFormat = "dd-MM-yyyy";
dtpHannop.Format = DateTimePickerFormat.Custom;
dtpHannop.CustomFormat = "dd-MM-yyyy";
dgvBaithi.AllowUserToAddRows = false;
dgvBaithi.AllowUserToDeleteRows = false;
txtNamhoc.MaxLength = 10;
txtLanthi.MaxLength = 10;
txtSobaithi.MaxLength = 10;
string select = "Select MaLop, TenLop From LopHoc";
DataSet dataset = new DataSet();
MyPublic.OpenData(select, dataset, "LopHoc");
cbLophoc.DataSource = dataset.Tables["LopHoc"];
cbLophoc.DisplayMember = "TenLop";
cbLophoc.ValueMember = "MaLop";
select = "Select MaMon, TenMon From MonHoc";
dataset = new DataSet();
MyPublic.OpenData(select, dataset, "MonHoc");
cbMonhoc.DataSource = dataset.Tables["MonHoc"];
cbMonhoc.DisplayMember = "TenMon";
cbMonhoc.ValueMember = "MaMon";
select = "Select * From TheoDoiBaiThi";
dataset = new DataSet();
MyPublic.OpenData(select, dataset, "TheoDoiBaiThi");
dtBaithi = dataset.Tables["TheoDoiBaiThi"];
dgvBaithi.DataSource = dataset.Tables["TheoDoiBaiThi"];
dgvBaithi.Width = 723;
dgvBaithi.Columns[0].Width = 70;
dgvBaithi.Columns[0].HeaderText = "Mã Môn";
dgvBaithi.Columns[1].Width = 70;
dgvBaithi.Columns[1].HeaderText = "Mã Lớp";
dgvBaithi.Columns[2].Width = 65;
dgvBaithi.Columns[2].HeaderText = "Lần thi";
dgvBaithi.Columns[3].Width = 70;
dgvBaithi.Columns[3].HeaderText = "Học Kỳ";
dgvBaithi.Columns[4].Width = 80;
dgvBaithi.Columns[4].HeaderText = "Năm học";
dgvBaithi.Columns[5].Width = 80;
dgvBaithi.Columns[5].HeaderText = "Ngày thi";
dgvBaithi.Columns[5].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvBaithi.Columns[6].Width = 80;
dgvBaithi.Columns[6].HeaderText = "Số bài thi";
dgvBaithi.Columns[7].Width = 85;
dgvBaithi.Columns[7].HeaderText = "Ngày nhận";
dgvBaithi.Columns[7].DefaultCellStyle.Format = "dd/MM/yyyy";
dgvBaithi.Columns[8].Width = 80;
dgvBaithi.Columns[8].HeaderText = "Hạn nộp";
dgvBaithi.Columns[8].DefaultCellStyle.Format = "dd/MM/yyyy";
if (MyPublic.quyenSD == "AdTinh" || MyPublic.quyenSD == "AdTruong")
{
btnThem.Enabled = true;
btnSua.Enabled = true;
btnXoa.Enabled = true;
}
else
{
btnThem.Enabled = false;
btnSua.Enabled = false;
btnXoa.Enabled = false;
}
dgvBaithi.Enabled = true;
cbMonhoc.Enabled = false;
cbLophoc.Enabled = false;
txtLanthi.Enabled = false;
rbtnHocky1.Enabled = false;
rbtnHocky2.Enabled = false;
txtNamhoc.Enabled = false;
dtpNgaythi.Enabled = false;
txtSobaithi.Enabled = false;
dtpNgaynhan.Enabled = false;
dtpHannop.Enabled = false;
btnLuu.Enabled = false;
btnKhongluu.Enabled = false;
displayRowAt(0);
}
