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)); }