public void Delete(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_CongThucDiemID", SqlDbType.Int, pKQHT_CongThucDiemInfo.KQHT_CongThucDiemID));
RunProcedure("sp_KQHT_CongThucDiem_Delete", colParam);
}
public DataTable Get(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_CongThucDiemID", SqlDbType.Int, pKQHT_CongThucDiemInfo.KQHT_CongThucDiemID));
return(RunProcedureGet("sp_KQHT_CongThucDiem_Get", colParam));
}
private void barbtnThem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (IDDM_Lop > 0)
{
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
dlgCongThucDiem dlg = new dlgCongThucDiem(dtCongThuc, null, EDIT_MODE.THEM, IDDM_Lop);
dlg.ShowDialog();
}
}
public void ToDataRow(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo, ref DataRow dr)
{
dr[pKQHT_CongThucDiemInfo.strKQHT_CongThucDiemID] = pKQHT_CongThucDiemInfo.KQHT_CongThucDiemID;
dr[pKQHT_CongThucDiemInfo.strIDDM_Lop] = pKQHT_CongThucDiemInfo.IDDM_Lop;
dr[pKQHT_CongThucDiemInfo.strIDDM_MonHoc] = pKQHT_CongThucDiemInfo.IDDM_MonHoc;
dr[pKQHT_CongThucDiemInfo.strIDDM_NamHoc] = pKQHT_CongThucDiemInfo.IDDM_NamHoc;
dr[pKQHT_CongThucDiemInfo.strHocKy] = pKQHT_CongThucDiemInfo.HocKy;
dr[pKQHT_CongThucDiemInfo.strCongThuc] = pKQHT_CongThucDiemInfo.CongThuc;
}
public int Add(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
int ID = 0;
ID = oDKQHT_CongThucDiem.Add(pKQHT_CongThucDiemInfo);
mErrorMessage = oDKQHT_CongThucDiem.ErrorMessages;
mErrorNumber = oDKQHT_CongThucDiem.ErrorNumber;
return(ID);
}
public void ToInfo(ref KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo, DataRow dr)
{
pKQHT_CongThucDiemInfo.KQHT_CongThucDiemID = int.Parse(dr[pKQHT_CongThucDiemInfo.strKQHT_CongThucDiemID].ToString());
pKQHT_CongThucDiemInfo.IDDM_Lop = int.Parse(dr[pKQHT_CongThucDiemInfo.strIDDM_Lop].ToString());
pKQHT_CongThucDiemInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_CongThucDiemInfo.strIDDM_MonHoc].ToString());
pKQHT_CongThucDiemInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_CongThucDiemInfo.strIDDM_NamHoc].ToString());
pKQHT_CongThucDiemInfo.HocKy = int.Parse(dr[pKQHT_CongThucDiemInfo.strHocKy].ToString());
pKQHT_CongThucDiemInfo.CongThuc = dr[pKQHT_CongThucDiemInfo.strCongThuc].ToString();
}
private void barbtnSua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (drCongThuc != null)
{
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oBKQHT_CongThucDiem.ToInfo(ref pKQHT_CongThucDiemInfo, drCongThuc);
dlgCongThucDiem dlg = new dlgCongThucDiem(dtCongThuc, drCongThuc, EDIT_MODE.SUA, IDDM_Lop);
dlg.ShowDialog();
}
}
public dlgCongThucDiem(DataTable mdtCongThuc, DataRow mdrCongThuc, EDIT_MODE mEdit, int mIDDM_Lop)
{
InitializeComponent();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oBKQHT_CongThucDiem_ThanhPhanDiem = new cBKQHT_CongThucDiem_ThanhPhanDiem();
pKQHT_CongThucDiem_ThanhPhanDiemInfo = new KQHT_CongThucDiem_ThanhPhanDiemInfo();
dtCongThuc = mdtCongThuc;
drCongThuc = mdrCongThuc;
edit = mEdit;
IDDM_Lop = mIDDM_Lop;
}
public void Update(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pKQHT_CongThucDiemInfo.IDDM_Lop));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_CongThucDiemInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_CongThucDiemInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_CongThucDiemInfo.HocKy));
colParam.Add(CreateParam("@CongThuc", SqlDbType.NVarChar, pKQHT_CongThucDiemInfo.CongThuc));
colParam.Add(CreateParam("@KQHT_CongThucDiemID", SqlDbType.Int, pKQHT_CongThucDiemInfo.KQHT_CongThucDiemID));
RunProcedure("sp_KQHT_CongThucDiem_Update", colParam);
}
public int Add(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pKQHT_CongThucDiemInfo.IDDM_Lop));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_CongThucDiemInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_CongThucDiemInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_CongThucDiemInfo.HocKy));
colParam.Add(CreateParam("@CongThuc", SqlDbType.NVarChar, pKQHT_CongThucDiemInfo.CongThuc));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_CongThucDiem_Add", colParam));
}
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 frmNhapDiemTheoLopHocLai()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
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();
oBKQHT_LopHocLai = new cBKQHT_LopHocLai();
pKQHT_DiemTongKetMonInfo = new KQHT_DiemTongKetMonInfo();
oBKQHT_DiemTongKetMon = new cBKQHT_DiemTongKetMon();
}
public List <KQHT_CongThucDiemInfo> GetList(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
List <KQHT_CongThucDiemInfo> oKQHT_CongThucDiemInfoList = new List <KQHT_CongThucDiemInfo>();
DataTable dtb = Get(pKQHT_CongThucDiemInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
oKQHT_CongThucDiemInfo.KQHT_CongThucDiemID = int.Parse(dtb.Rows[i]["KQHT_CongThucDiemID"].ToString());
oKQHT_CongThucDiemInfo.IDDM_Lop = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString());
oKQHT_CongThucDiemInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oKQHT_CongThucDiemInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oKQHT_CongThucDiemInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oKQHT_CongThucDiemInfo.CongThuc = dtb.Rows[i]["CongThuc"].ToString();
oKQHT_CongThucDiemInfoList.Add(oKQHT_CongThucDiemInfo);
}
}
return(oKQHT_CongThucDiemInfoList);
}
public frmCongThucDiem()
{
InitializeComponent();
oBKQHT_CongThucDiem = new cBKQHT_CongThucDiem();
pKQHT_CongThucDiemInfo = new KQHT_CongThucDiemInfo();
}
public void Delete(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
oDKQHT_CongThucDiem.Delete(pKQHT_CongThucDiemInfo);
mErrorMessage = oDKQHT_CongThucDiem.ErrorMessages;
mErrorNumber = oDKQHT_CongThucDiem.ErrorNumber;
}
public DataTable Get(KQHT_CongThucDiemInfo pKQHT_CongThucDiemInfo)
{
return(oDKQHT_CongThucDiem.Get(pKQHT_CongThucDiemInfo));
}
