//int IDDM_Khoa, IDDM_He, IDDM_TrinhDo, IDDM_Nganh, IDDM_KhoaHoc, IDDM_Lop;
public frmXetTotNghiepRaTruong()
{
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();
}
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 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 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();
}
private void AddBand()
{
GridBand grb;
BandedGridColumn bgcSoSV, bgcTyLe;
KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo = new KQHT_XepLoaiTotNghiepInfo();
cBKQHT_XepLoaiTotNghiep oBKQHT_XepLoaiTotNghiep = new cBKQHT_XepLoaiTotNghiep();
dtXepLoai = oBKQHT_XepLoaiTotNghiep.Get(pKQHT_XepLoaiTotNghiepInfo);
grbXepLoai.Columns.Clear();
grbXepLoai.Children.Clear();
if ((dtXepLoai != null) && (dtXepLoai.Rows.Count > 0))
{
foreach (DataRow dr in dtXepLoai.Rows)
{
dtLop.Columns.Add(dr["KQHT_XepLoaiTotNghiepID"].ToString(), typeof(double));
dtLop.Columns.Add("TyLe_" + dr["KQHT_XepLoaiTotNghiepID"], typeof(string));
// Add band Tên xếp loại
grb = new GridBand();
grbXepLoai.Children.AddRange(new GridBand[] { grb });
// Add cột số sinh viên
bgcSoSV = new BandedGridColumn();
grb.Columns.Add(bgcSoSV);
SetColumnBandCaption(bgcSoSV, "SL", dr["KQHT_XepLoaiTotNghiepID"].ToString(),
50, DevExpress.Utils.HorzAlignment.Default, true);
bgcSoSV.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgcSoSV.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
// Add cột tỷ lệ
bgcTyLe = new BandedGridColumn();
grb.Columns.Add(bgcTyLe);
SetColumnBandCaption(bgcTyLe, "%", "TyLe_" + dr["KQHT_XepLoaiTotNghiepID"].ToString(),
50, DevExpress.Utils.HorzAlignment.Far, false);
bgcTyLe.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgcTyLe.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgvLop.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgcSoSV, bgcTyLe });
SetBandCaption(grb, dr["TenXepLoai"].ToString(), 100);
// End add band Tên xếp loại
}
// Add band chưa xếp loại
dtLop.Columns.Add("0", typeof(double));
dtLop.Columns.Add("TyLe_0", typeof(string));
// Add band Tên xếp loại
grb = new GridBand();
grbXepLoai.Children.AddRange(new GridBand[] { grb });
// Add cột số sinh viên
bgcSoSV = new BandedGridColumn();
grb.Columns.Add(bgcSoSV);
SetColumnBandCaption(bgcSoSV, "SL", "0", 50, DevExpress.Utils.HorzAlignment.Default, false);
bgcSoSV.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgcSoSV.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
// Add cột tỷ lệ
bgcTyLe = new BandedGridColumn();
grb.Columns.Add(bgcTyLe);
SetColumnBandCaption(bgcTyLe, "%", "TyLe_0", 50, DevExpress.Utils.HorzAlignment.Far, false);
bgcTyLe.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgcTyLe.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgvLop.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgcSoSV, bgcTyLe });
SetBandCaption(grb, "Chưa xếp loại", 100);
// End add band Tên xếp loại
}
}
public frmXepLoaiTotNghiep()
{
InitializeComponent();
pKQHT_XepLoaiTotNghiepInfo = new KQHT_XepLoaiTotNghiepInfo();
oBKQHT_XepLoaiTotNghiep = new cBKQHT_XepLoaiTotNghiep();
}
