public List <KQHT_DangKyThiLaiInfo> GetList(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { List <KQHT_DangKyThiLaiInfo> oKQHT_DangKyThiLaiInfoList = new List <KQHT_DangKyThiLaiInfo>(); DataTable dtb = Get(pKQHT_DangKyThiLaiInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_DangKyThiLaiInfo = new KQHT_DangKyThiLaiInfo(); oKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID = int.Parse(dtb.Rows[i]["KQHT_DangKyThiLaiID"].ToString()); oKQHT_DangKyThiLaiInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString()); oKQHT_DangKyThiLaiInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString()); oKQHT_DangKyThiLaiInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString()); oKQHT_DangKyThiLaiInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString()); oKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi = int.Parse(dtb.Rows[i]["IDKQHT_ToChucThi"].ToString()); oKQHT_DangKyThiLaiInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString(); oKQHT_DangKyThiLaiInfo.TienLePhi = double.Parse(dtb.Rows[i]["TienLePhi"].ToString()); oKQHT_DangKyThiLaiInfo.IDHT_User = int.Parse(dtb.Rows[i]["IDHT_User"].ToString()); oKQHT_DangKyThiLaiInfo.NgayDangKy = DateTime.Parse(dtb.Rows[i]["NgayDangKy"].ToString()); oKQHT_DangKyThiLaiInfoList.Add(oKQHT_DangKyThiLaiInfo); } } return(oKQHT_DangKyThiLaiInfoList); }
public void Delete(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DangKyThiLaiID", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID)); RunProcedure("sp_KQHT_DangKyThiLai_Delete", colParam); }
public DataTable Get(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DangKyThiLaiID", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID)); return(RunProcedureGet("sp_KQHT_DangKyThiLai_Get", colParam)); }
public int Add(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { int ID = 0; ID = oDKQHT_DangKyThiLai.Add(pKQHT_DangKyThiLaiInfo); mErrorMessage = oDKQHT_DangKyThiLai.ErrorMessages; mErrorNumber = oDKQHT_DangKyThiLai.ErrorNumber; return(ID); }
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 void ToDataRow(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo, ref DataRow dr) { dr[pKQHT_DangKyThiLaiInfo.strKQHT_DangKyThiLaiID] = pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID; dr[pKQHT_DangKyThiLaiInfo.strIDSV_SinhVien] = pKQHT_DangKyThiLaiInfo.IDSV_SinhVien; dr[pKQHT_DangKyThiLaiInfo.strIDDM_MonHoc] = pKQHT_DangKyThiLaiInfo.IDDM_MonHoc; dr[pKQHT_DangKyThiLaiInfo.strIDDM_NamHoc] = pKQHT_DangKyThiLaiInfo.IDDM_NamHoc; dr[pKQHT_DangKyThiLaiInfo.strHocKy] = pKQHT_DangKyThiLaiInfo.HocKy; dr[pKQHT_DangKyThiLaiInfo.strIDKQHT_ToChucThi] = pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi; dr[pKQHT_DangKyThiLaiInfo.strGhiChu] = pKQHT_DangKyThiLaiInfo.GhiChu; dr[pKQHT_DangKyThiLaiInfo.strTienLePhi] = pKQHT_DangKyThiLaiInfo.TienLePhi; dr[pKQHT_DangKyThiLaiInfo.strIDHT_User] = pKQHT_DangKyThiLaiInfo.IDHT_User; dr[pKQHT_DangKyThiLaiInfo.strNgayDangKy] = pKQHT_DangKyThiLaiInfo.NgayDangKy; }
public void ToInfo(ref KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo, DataRow dr) { pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strKQHT_DangKyThiLaiID].ToString()); pKQHT_DangKyThiLaiInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDSV_SinhVien].ToString()); pKQHT_DangKyThiLaiInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDDM_MonHoc].ToString()); pKQHT_DangKyThiLaiInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDDM_NamHoc].ToString()); pKQHT_DangKyThiLaiInfo.HocKy = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strHocKy].ToString()); pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDKQHT_ToChucThi].ToString()); pKQHT_DangKyThiLaiInfo.GhiChu = dr[pKQHT_DangKyThiLaiInfo.strGhiChu].ToString(); pKQHT_DangKyThiLaiInfo.TienLePhi = double.Parse(dr[pKQHT_DangKyThiLaiInfo.strTienLePhi].ToString()); pKQHT_DangKyThiLaiInfo.IDHT_User = int.Parse(dr[pKQHT_DangKyThiLaiInfo.strIDHT_User].ToString()); pKQHT_DangKyThiLaiInfo.NgayDangKy = DateTime.Parse(dr[pKQHT_DangKyThiLaiInfo.strNgayDangKy].ToString()); }
public void Update(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.HocKy)); colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DangKyThiLaiInfo.GhiChu)); colParam.Add(CreateParam("@TienLePhi", SqlDbType.Money, pKQHT_DangKyThiLaiInfo.TienLePhi)); colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDHT_User)); colParam.Add(CreateParam("@NgayDangKy", SqlDbType.DateTime, pKQHT_DangKyThiLaiInfo.NgayDangKy)); colParam.Add(CreateParam("@KQHT_DangKyThiLaiID", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.KQHT_DangKyThiLaiID)); RunProcedure("sp_KQHT_DangKyThiLai_Update", colParam); }
public int Add(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.HocKy)); colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.LanThi)); colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDKQHT_ToChucThi)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DangKyThiLaiInfo.GhiChu)); colParam.Add(CreateParam("@TienLePhi", SqlDbType.Money, pKQHT_DangKyThiLaiInfo.TienLePhi)); colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_DangKyThiLaiInfo.IDHT_User)); colParam.Add(CreateParam("@NgayDangKy", SqlDbType.DateTime, pKQHT_DangKyThiLaiInfo.NgayDangKy)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_DangKyThiLai_Add", colParam)); }
public void Delete(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { oDKQHT_DangKyThiLai.Delete(pKQHT_DangKyThiLaiInfo); mErrorMessage = oDKQHT_DangKyThiLai.ErrorMessages; mErrorNumber = oDKQHT_DangKyThiLai.ErrorNumber; }
public DataTable Get(KQHT_DangKyThiLaiInfo pKQHT_DangKyThiLaiInfo) { return(oDKQHT_DangKyThiLai.Get(pKQHT_DangKyThiLaiInfo)); }