public frmHanhViViPham()
{
InitializeComponent();
pDM_HanhViInfo = new DM_HanhViInfo();
oBDM_HanhVi = new cBDM_HanhVi();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
}
public frmThanhTichKhenThuong()
{
InitializeComponent();
pDM_LoaiKhenThuongInfo = new DM_LoaiKhenThuongInfo();
oBDM_LoaiKhenThuong = new cBDM_LoaiKhenThuong();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
}
private void LoadKeHoach()
{
fg.Rows.Count = 0;
fg.Cols.Count = 0;
DataTable dtLop;
int row = RowBegin;
dtToanTruong = new cBDM_Lop().GetKeHoachToanTruong(Program.IDNamHoc, Program.NamHoc, pDM_LopInfo);
dtPhanCongGiangDay = new cBXL_MonHocTrongKy().GetByHocKyNamHoc(0, Program.HocKy, Program.IDNamHoc, 0, 0);
clsdt = new clsDataTableHelper();
dtLop = clsdt.SelectDistinct(dtToanTruong, new string[] { "IDDM_He", "IDDM_TrinhDo", "TenKhoaHoc", "DM_LopID", "TenLop", "SoSinhVien" });
if (dtLop.Rows.Count > 0)
{
fg.Rows.Count = row + dtLop.Rows.Count;
fg.Cols.Count = ColBegin + LoadTuan().Rows.Count;
FormatGrid();
for (int i = 0; i < dtLop.Rows.Count; i++)
{
// Gán giá trị lớp
fg.Rows[row].Height = rowHeight;
fg[row, 0] = 0;
fg[row, 1] = int.Parse(dtLop.Rows[i]["DM_LopID"].ToString());
fg[row, 3] = dtLop.Rows[i]["TenLop"].ToString();
fg[row, 4] = int.Parse(dtLop.Rows[i]["SoSinhVien"].ToString());
CellRange rg = fg.GetCellRange(row, 0, row, fg.Cols.Fixed - 1);
rg.Style = fg.Styles["MyCellStyleLop"];
FillKeHoachLop(row, int.Parse(dtLop.Rows[i]["DM_LopID"].ToString()));
row++;
FillChiTietLop(ref row, int.Parse(dtLop.Rows[i]["DM_LopID"].ToString()));
}
TinhSoTietCon(RowBegin, fg.Rows.Count - 1);
}
}
public frmNhapDiemTheoSoPhach()
{
InitializeComponent();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
oBKQHT_DanhSachDuThi = new cBKQHT_DanhSachDuThi();
}
public frmDangKyHocLai()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DangKyHocLai = new cBKQHT_DangKyHocLai();
pKQHT_DangKyHocLaiInfo = new KQHT_DangKyHocLaiInfo();
oBKQHT_LopHocLai = new cBKQHT_LopHocLai();
}
public dlgAnhXaMonHoc(DataRow mdr, string TenLopMoi)
{
InitializeComponent();
dr = mdr;
txtTenLopMoi.Text = TenLopMoi;
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBSV_AnhXaMon = new cBSV_AnhXaMon();
pSV_AnhXaMonInfo = new SV_AnhXaMonInfo();
}
public frmXetThiHetMon()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DanhSachKhongThiInfo = new KQHT_DanhSachKhongThiInfo();
oBKQHT_DanhSachKhongThi = new cBKQHT_DanhSachKhongThi();
pDM_LopInfo = new DM_LopInfo();
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
if (!CheckValid())
{
return;
}
if (grvLop.DataRowCount > 0)
{
int KiemTra = 0;
for (int i = 0; i < grvLop.DataRowCount; i++)
{
if ((bool)(grvLop.GetDataRow(i)["Chon"]) == true)
{
KiemTra += 1;
TongSoSV += int.Parse(grvLop.GetDataRow(i)["SoSinhVien"].ToString());
}
}
if (KiemTra < 2)
{
ThongBao("Bạn phải chọn ít nhất 2 lớp cần gộp");
}
else
{
cBXL_MonHocTrongKy oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
int ParentID = 0;
for (int i = 0; i < grvLop.DataRowCount; i++)
{
if ((bool)(grvLop.GetDataRow(i)["Chon"]) == true)
{
GetpLopTachGopInfo(grvLop.GetDataRow(i));
GetpLopTachMonHocInfo(grvLop.GetDataRow(i));
if (i == 0)
{
pXL_LopTachGopInfo.ParentID = 0;
ParentID = oBXL_LopTachGop.Add(pXL_LopTachGopInfo);
pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop = ParentID;
}
else
{
pXL_LopTachGopInfo.ParentID = ParentID;
pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop = oBXL_LopTachGop.Add(pXL_LopTachGopInfo);
}
oBXL_LopTachGop_MonHoc.Add(pXL_LopTachGop_MonHocInfo);
// Thiết lập lại giá trị HocOLopTachGop của bảng MonHocTrongKy thành true
oBXL_MonHocTrongKy.UpdateTachGop(pXL_LopTachGop_MonHocInfo.IDXL_MonHocTrongKy, true);
// ghi log
GhiLog("Thêm lớp gộp '" + txtTenLopGop.Text.Trim() + "' vào CSDL", "Thêm", this.Tag.ToString());
}
}
this.Tag = "1";
this.Close();
}
}
}
public frmTongKetDiemToanKhoa()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetToanKhoaInfo = new KQHT_DiemTongKetToanKhoaInfo();
oBKQHT_DiemTongKetToanKhoa = new cBKQHT_DiemTongKetToanKhoa();
pKQHT_XepLoaiTotNghiepInfo = new KQHT_XepLoaiTotNghiepInfo();
oBKQHT_XepLoaiTotNghiep = new cBKQHT_XepLoaiTotNghiep();
}
public frmDangKyThiLai()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DangKyThiLai = new cBKQHT_DangKyThiLai();
oBKQHT_DanhSachKhongThi = new cBKQHT_DanhSachKhongThi();
pKQHT_DangKyThiLaiInfo = new KQHT_DangKyThiLaiInfo();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
}
public frmDangKyTuChon()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DangKyMonChonInfo = new KQHT_DangKyMonChonInfo();
oBKQHT_DangKyMonChon = new cBKQHT_DangKyMonChon();
txtHocKy.Text = Program.HocKy.ToString();
txtNamHoc.Text = Program.NamHoc;
}
public frmTheoDoiMonHoc()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DiemDanh = new cBKQHT_DiemDanh();
pKQHT_DiemDanhInfo = new KQHT_DiemDanhInfo();
oBKQHT_DiemDanh_ChiTiet = new cBKQHT_DiemDanh_ChiTiet();
pKQHT_DiemDanh_ChiTietInfo = new KQHT_DiemDanh_ChiTietInfo();
}
private void barbtnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
grvLopTach.FocusedRowHandle = -1;
bool check = false;
if (ThongBaoChon("Bạn có chắc chắn muốn xóa?") == DialogResult.Yes)
{
try
{
cBXL_MonHocTrongKy oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
for (int i = 0; i < dtLopTach.Rows.Count; i++)
{
string mXL_LopTachGopIDs = "", mIDXL_MonHocTrongKys = "";
if (bool.Parse(dtLopTach.Rows[i]["Chon"].ToString()) == true)
{
check = true;
mXL_LopTachGopIDs = dtLopTach.Rows[i]["XL_LopTachGopIDs"].ToString() + ",";
try
{
// delete lop tach gop
oBXL_LopTachGop.DeleteByLopGoc(mXL_LopTachGopIDs.Substring(0, mXL_LopTachGopIDs.Length - 1));
// Thiết lập lại giá trị HocOLopTachGop của bảng MonHocTrongKy thành true
mIDXL_MonHocTrongKys = dtLopTach.Rows[i]["IDXL_MonHocTrongKys"].ToString() + ",";
while ((mIDXL_MonHocTrongKys != "") && (mIDXL_MonHocTrongKys != ","))
{
oBXL_MonHocTrongKy.UpdateTachGop(int.Parse(mIDXL_MonHocTrongKys.Substring(0, mIDXL_MonHocTrongKys.IndexOf(","))), false);
mIDXL_MonHocTrongKys = mIDXL_MonHocTrongKys.Substring(mIDXL_MonHocTrongKys.IndexOf(",") + 1);
}
// ghi log
GhiLog("Xóa các lớp tách '" + dtLopTach.Rows[i]["TenLopTach"].ToString() + "' khỏi CSDL", "Xóa", this.Tag.ToString());
}
catch
{
check = false;
}
}
}
if (check == true)
{
cmbLop_EditValueChanged(null, null);
frmLopTach_Load(null, null);
}
}
catch
{
XoaThatBai();
}
if (check == false)
{
ThongBao("Bạn chưa chọn dữ liệu cần xóa!");
}
}
}
public frmToChucLopHocLai()
{
InitializeComponent();
pKQHT_LopHocLaiInfo = new KQHT_LopHocLaiInfo();
oBKQHT_LopHocLai = new cBKQHT_LopHocLai();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
txtHocKy.Text = Program.HocKy.ToString();
txtNamHoc.Text = Program.NamHoc;
DM_MonHocID = 0;
}
public frmNhapDiemTongKet()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
oBKQHT_DaChuyenDiem = new cBKQHT_DaChuyenDiem();
}
public frmTongKetDiemNamHoc()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetHocKyInfo = new KQHT_DiemTongKetHocKyInfo();
oBKQHT_DiemTongKetHocKy = new cBKQHT_DiemTongKetHocKy();
pKQHT_XepLoaiTotNghiepInfo = new KQHT_XepLoaiTotNghiepInfo();
oBKQHT_XepLoaiTotNghiep = new cBKQHT_XepLoaiTotNghiep();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
}
public frmNhapDiemTheoSoBDVaPhach()
{
InitializeComponent();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_ToChucThi = new cBKQHT_ToChucThi();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
cls = new clsDataTableHelper();
}
public frmNhapDiemThanhPhan()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DiemThanhPhan = new cBKQHT_DiemThanhPhan();
pKQHT_DiemThanhPhanInfo = new KQHT_DiemThanhPhanInfo();
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
oBKQHT_DiemThi = new cBKQHT_DiemThi();
pKQHT_DiemThiInfo = new KQHT_DiemThiInfo();
rdgTuDanhSach.Enabled = false;
}
public frmTongKetDiemMonHoc()
{
InitializeComponent();
// Check quyền để cho phép hay không cho phép thực hiện thao tạc lưu dữ liệu
SetQuyen(this, "" + this.Tag);
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
}
private void LoadGrid()
{
cBXL_MonHocTrongKy oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
int IDDM_Khoa, IDDM_BoMon;
IDDM_Khoa = uccmbKhoa.cmb.EditValue == null ? 0 : int.Parse(uccmbKhoa.cmb.EditValue.ToString());
IDDM_BoMon = uccmbBoMon.cmb.EditValue == null ? 0 : int.Parse(uccmbBoMon.cmb.EditValue.ToString());
DataTable dtMon = oBXL_MonHocTrongKy.GetByHocKyNamHoc(0, Program.HocKy, Program.IDNamHoc, IDDM_Khoa, IDDM_BoMon);
dtPhanCong = XuLyTable(dtMon);
grdPhanCong.DataSource = dtPhanCong;
}
public frmTongHopDiemThiTotNghiep_QCNghe()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBSV_SinhVien = new cBSV_SinhVien();
pKQHT_XepLoaiTotNghiepInfo = new KQHT_XepLoaiTotNghiepInfo();
oBKQHT_XepLoaiTotNghiep = new cBKQHT_XepLoaiTotNghiep();
oBKQHT_DiemTongKetToanKhoa = new cBKQHT_DiemTongKetToanKhoa();
pKQHT_DiemTongKetToanKhoaInfo = new KQHT_DiemTongKetToanKhoaInfo();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
}
public frmMonHocTrongKy()
{
InitializeComponent();
IDKQHT_ChuongTrinhDaoTao = 0;
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
oBCTDT = new cBKQHT_ChuongTrinhDaoTao();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
cmbHocKy.Properties.Items.Add(Program.HocKy);
cmbNamHoc.Properties.Items.Add(Program.NamHoc);
cmbNamHoc.SelectedIndex = 0;
cmbHocKy.SelectedIndex = 0;
repositoryThiMonKhung.DataSource = LoadHinhThucThi();
repositoryThiMonKy.DataSource = LoadHinhThucThi();
}
public frmNhapDiemTongKet()
{
InitializeComponent();
// Check quyền để cho phép hay không cho phép thực hiện thao tạc lưu dữ liệu
SetQuyen(this, "" + this.Tag);
oBDM_Lop = new cBDM_Lop();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
oBKQHT_MonThiTotNghiep_Lop = new cBKQHT_MonThiTotNghiep_Lop();
oBKQHT_DiemMonThiTotNghiep = new cBKQHT_DiemMonThiTotNghiep();
dtXLMonHoc = (new cBKQHT_XepLoaiMonHoc()).Get(new KQHT_XepLoaiMonHocInfo());
}
public dlgChuyenLop_ChuyenDiem()
{
InitializeComponent();
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
if (grvChiTiet.DataRowCount > 0)
{
int TongSoSV = 0;
string TenCacLopTach = "";
for (int i = 0; i < dtChiTiet.Rows.Count; i++)
{
TongSoSV += int.Parse(dtChiTiet.Rows[i]["SoSinhVien"].ToString());
}
if (TongSoSV == int.Parse(cmbLop.GetColumnValue("SoSinhVien").ToString()))
{
if (edit == EDIT_MODE.THEM)
{
int ParentID = 0;
// kiem tra tong so sinh vien
for (int i = 0; i < dtChiTiet.Rows.Count; i++)
{
GetpLopTachGopInfo(dtChiTiet.Rows[i]);
GetpLopTachMonHocInfo(dtChiTiet.Rows[i]);
if (i == 0)
{
pXL_LopTachGopInfo.ParentID = 0;
ParentID = oBXL_LopTachGop.Add(pXL_LopTachGopInfo);
TenCacLopTach += pXL_LopTachGopInfo.TenLopTachGop;
pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop = ParentID;
}
else
{
pXL_LopTachGopInfo.ParentID = ParentID;
pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop = oBXL_LopTachGop.Add(pXL_LopTachGopInfo);
}
oBXL_LopTachGop_MonHoc.Add(pXL_LopTachGop_MonHocInfo);
}
// Thiết lập lại giá trị HocOLopTachGop của bảng MonHocTrongKy thành true
cBXL_MonHocTrongKy oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBXL_MonHocTrongKy.UpdateTachGop(pXL_LopTachGop_MonHocInfo.IDXL_MonHocTrongKy, true);
// ghi log
GhiLog("Thêm các lớp tách '" + TenCacLopTach + "' vào CSDL", "Thêm", this.Tag.ToString());
DataRow[] drMon = dtMonHoc.Select("XL_MonHocTrongKyID = " + cmbMonHoc.EditValue.ToString());
if (drMon.Length > 0)
{
drMon[0]["HocOLopTachGop"] = true;
}
frmLopTach_Load(null, null);
}
else
{
cmbMonHoc.Enabled = true;
cmbKhoa.Enabled = true;
cmbLop.Enabled = true;
SuaThanhCong();
ResetControls();
}
}
else
{
ThongBaoLoi("Tổng sinh viên của các lớp tách không cân bằng!");
}
}
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
cBXL_MonHocTrongKy oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
bool mStatus = false;
DataTable dtTemp = dtMonHoc.GetChanges();
DataRow[] drMon = dtMonHoc.Select("Chon=true");
if (drMon.Length == 0)
{
if (ThongBaoChon("Bỏ hết môn học, thông tin lớp tách gộp sẽ bị mất. Bạn có chắc chắn chấp nhận?") == DialogResult.Yes)
{
try
{
mStatus = true;
oBXL_LopTachGop.DeleteByLopGoc(XL_LopTachGopIDs.Substring(0, XL_LopTachGopIDs.Length - 1));
}
catch
{
XoaThatBai();
}
}
else
{
return;
}
}
if (dtTemp != null)
{
foreach (DataRow dr in dtTemp.Rows)
{
if (dr.RowState == DataRowState.Modified)
{
mStatus = true;
if ((bool)(dr["Chon"]) == true)
{
try
{
if (CheckTach_Gop == false)
{
// them mon hoc - lop tach
oBXL_LopTachGop_MonHoc.AddMonHoc_ByLopTach(IDXL_MonHocTrongKy, IDDM_Lop, int.Parse(dr["XL_MonHocTrongKyID"].ToString()),
("" + dr["IDNS_GiaoVien"].ToString() == "" ? -1 : int.Parse(dr["IDNS_GiaoVien"].ToString())), ("" + dr["IDDM_PhongHoc"].ToString() == "" ? -1 : int.Parse(dr["IDDM_PhongHoc"].ToString())), (dr["CaHocs"].ToString() == "" ? -1 : (dr["CaHocs"].ToString() == "Sáng" ? 0 : (dr["CaHocs"].ToString() == "Chiều" ? 1 : 2))));
// Thiết lập lại giá trị HocOLopTachGop của bảng MonHocTrongKy thành true
oBXL_MonHocTrongKy.UpdateTachGop(int.Parse(dr["XL_MonHocTrongKyID"].ToString()), true);
}
else
{
// them mon hoc - lop gop
oBXL_LopTachGop_MonHoc.AddMonHoc_ByLopGop(XL_LopTachGopIDs + ",", int.Parse(dr["IDDM_MonHoc"].ToString()),
("" + dr["IDNS_GiaoVien"].ToString() == "" ? -1 : int.Parse(dr["IDNS_GiaoVien"].ToString())), ("" + dr["IDDM_PhongHoc"].ToString() == "" ? -1 : int.Parse(dr["IDDM_PhongHoc"].ToString())), (dr["CaHocs"].ToString() == "" ? -1 : (dr["CaHocs"].ToString() == "Sáng" ? 0 : (dr["CaHocs"].ToString() == "Chiều" ? 1 : 2))));
}
}
catch (Exception exp)
{
ThongBao(exp.Message);
}
}
else
{
if (CheckTach_Gop == false)
{
// Lop Tach
oBXL_LopTachGop_MonHoc.DeleteByLopTach(IDDM_Lop, int.Parse(dr["XL_MonHocTrongKyID"].ToString()));
// Thiết lập lại giá trị HocOLopTachGop của bảng MonHocTrongKy thành true
oBXL_MonHocTrongKy.UpdateTachGop(int.Parse(dr["XL_MonHocTrongKyID"].ToString()), false);
}
else
{
for (int i = 0; i < ArrayLop.Length; i++)
{
try
{
DataRow[] drArray = dtMonHocAll.Select("IDDM_Lop =" + ArrayLop[i] + "and IDDM_MonHoc" + dr["IDDM_MonHoc"]);
oBXL_LopTachGop_MonHoc.DeleteByLopTach(int.Parse(ArrayLop[i]), int.Parse(drArray[0]["XL_MonHocTrongKyID"].ToString()));
// Thiết lập lại giá trị HocOLopTachGop của bảng MonHocTrongKy thành true
oBXL_MonHocTrongKy.UpdateTachGop(int.Parse(drArray[0]["XL_MonHocTrongKyID"].ToString()), false);
}
catch (Exception exp)
{
ThongBao(exp.Message);
}
}
}
}
}
}
}
if (mStatus == true)
{
this.Tag = "1";
this.Close();
}
else
{
ThongBao("Bạn chưa thay đổi môn học nào");
}
}
