public void Delete(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_XepLoaiTotNghiepID", SqlDbType.Int, pKQHT_XepLoaiTotNghiepInfo.KQHT_XepLoaiTotNghiepID));
RunProcedure("sp_KQHT_XepLoaiTotNghiep_Delete", colParam);
}
public void ToDataRow(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo, ref DataRow dr)
{
dr[pKQHT_XepLoaiTotNghiepInfo.strKQHT_XepLoaiTotNghiepID] = pKQHT_XepLoaiTotNghiepInfo.KQHT_XepLoaiTotNghiepID;
dr[pKQHT_XepLoaiTotNghiepInfo.strTenXepLoai] = pKQHT_XepLoaiTotNghiepInfo.TenXepLoai;
dr[pKQHT_XepLoaiTotNghiepInfo.strTuDiem] = pKQHT_XepLoaiTotNghiepInfo.TuDiem;
dr[pKQHT_XepLoaiTotNghiepInfo.strMaXepLoai] = pKQHT_XepLoaiTotNghiepInfo.MaXepLoai;
dr[pKQHT_XepLoaiTotNghiepInfo.strHaXepLoaiThiLaiQuaMucPhanTram] = pKQHT_XepLoaiTotNghiepInfo.HaXepLoaiThiLaiQuaMucPhanTram;
}
public DataTable Get(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_XepLoaiTotNghiepID", SqlDbType.Int, pKQHT_XepLoaiTotNghiepInfo.KQHT_XepLoaiTotNghiepID));
return(RunProcedureGet("sp_KQHT_XepLoaiTotNghiep_Get", colParam));
}
public void ToInfo(ref KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo, DataRow dr)
{
pKQHT_XepLoaiTotNghiepInfo.KQHT_XepLoaiTotNghiepID = int.Parse(dr[pKQHT_XepLoaiTotNghiepInfo.strKQHT_XepLoaiTotNghiepID].ToString());
pKQHT_XepLoaiTotNghiepInfo.TenXepLoai = dr[pKQHT_XepLoaiTotNghiepInfo.strTenXepLoai].ToString();
pKQHT_XepLoaiTotNghiepInfo.TuDiem = double.Parse(dr[pKQHT_XepLoaiTotNghiepInfo.strTuDiem].ToString());
pKQHT_XepLoaiTotNghiepInfo.MaXepLoai = dr[pKQHT_XepLoaiTotNghiepInfo.strMaXepLoai].ToString();
pKQHT_XepLoaiTotNghiepInfo.HaXepLoaiThiLaiQuaMucPhanTram = "" + dr[pKQHT_XepLoaiTotNghiepInfo.strHaXepLoaiThiLaiQuaMucPhanTram] == "" ?
false : bool.Parse(dr[pKQHT_XepLoaiTotNghiepInfo.strHaXepLoaiThiLaiQuaMucPhanTram].ToString());
}
public int Add(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
int ID = 0;
ID = oDKQHT_XepLoaiTotNghiep.Add(pKQHT_XepLoaiTotNghiepInfo);
mErrorMessage = oDKQHT_XepLoaiTotNghiep.ErrorMessages;
mErrorNumber = oDKQHT_XepLoaiTotNghiep.ErrorNumber;
return(ID);
}
//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 void Update(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiTotNghiepInfo.TenXepLoai));
colParam.Add(CreateParam("@TuDiem", SqlDbType.Float, pKQHT_XepLoaiTotNghiepInfo.TuDiem));
colParam.Add(CreateParam("@MaXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiTotNghiepInfo.MaXepLoai));
colParam.Add(CreateParam("@HaXepLoaiThiLaiQuaMucPhanTram", SqlDbType.Bit, pKQHT_XepLoaiTotNghiepInfo.HaXepLoaiThiLaiQuaMucPhanTram));
colParam.Add(CreateParam("@KQHT_XepLoaiTotNghiepID", SqlDbType.Int, pKQHT_XepLoaiTotNghiepInfo.KQHT_XepLoaiTotNghiepID));
RunProcedure("sp_KQHT_XepLoaiTotNghiep_Update", colParam);
}
public int Add(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiTotNghiepInfo.TenXepLoai));
colParam.Add(CreateParam("@TuDiem", SqlDbType.Float, pKQHT_XepLoaiTotNghiepInfo.TuDiem));
colParam.Add(CreateParam("@MaXepLoai", SqlDbType.NVarChar, pKQHT_XepLoaiTotNghiepInfo.MaXepLoai));
colParam.Add(CreateParam("@HaXepLoaiThiLaiQuaMucPhanTram", SqlDbType.Bit, pKQHT_XepLoaiTotNghiepInfo.HaXepLoaiThiLaiQuaMucPhanTram));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_XepLoaiTotNghiep_Add", colParam));
}
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 List <KQHT_XepLoaiTotNghiepInfo> GetList(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
List <KQHT_XepLoaiTotNghiepInfo> oKQHT_XepLoaiTotNghiepInfoList = new List <KQHT_XepLoaiTotNghiepInfo>();
DataTable dtb = Get(pKQHT_XepLoaiTotNghiepInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_XepLoaiTotNghiepInfo = new KQHT_XepLoaiTotNghiepInfo();
oKQHT_XepLoaiTotNghiepInfo.KQHT_XepLoaiTotNghiepID = int.Parse(dtb.Rows[i]["KQHT_XepLoaiTotNghiepID"].ToString());
oKQHT_XepLoaiTotNghiepInfo.TenXepLoai = dtb.Rows[i]["TenXepLoai"].ToString();
oKQHT_XepLoaiTotNghiepInfo.TuDiem = double.Parse(dtb.Rows[i]["TuDiem"].ToString());
oKQHT_XepLoaiTotNghiepInfo.MaXepLoai = dtb.Rows[i]["MaXepLoai"].ToString();
oKQHT_XepLoaiTotNghiepInfo.HaXepLoaiThiLaiQuaMucPhanTram =
"" + dtb.Rows[i]["HaXepLoaiThiLaiQuaMucPhanTram"] == "" ? false :
bool.Parse(dtb.Rows[i]["HaXepLoaiThiLaiQuaMucPhanTram"].ToString());
oKQHT_XepLoaiTotNghiepInfoList.Add(oKQHT_XepLoaiTotNghiepInfo);
}
}
return(oKQHT_XepLoaiTotNghiepInfoList);
}
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();
}
public void Delete(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
oDKQHT_XepLoaiTotNghiep.Delete(pKQHT_XepLoaiTotNghiepInfo);
mErrorMessage = oDKQHT_XepLoaiTotNghiep.ErrorMessages;
mErrorNumber = oDKQHT_XepLoaiTotNghiep.ErrorNumber;
}
public DataTable Get(KQHT_XepLoaiTotNghiepInfo pKQHT_XepLoaiTotNghiepInfo)
{
return(oDKQHT_XepLoaiTotNghiep.Get(pKQHT_XepLoaiTotNghiepInfo));
}
