public void ToInfo(ref KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo, DataRow dr) { pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strKQHT_DanhSachKhongThiTotNghiepID].ToString()); pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDSV_SinhVien].ToString()); pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo = dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strLyDo].ToString(); pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDDM_NamHoc].ToString()); pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot = bool.Parse(dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strXetVot].ToString()); }
public void Delete(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID)); RunProcedure("sp_KQHT_DanhSachKhongThiTotNghiep_Delete", colParam); }
public void ToDataRow(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo, ref DataRow dr) { dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strKQHT_DanhSachKhongThiTotNghiepID] = pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID; dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDSV_SinhVien] = pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien; dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strLyDo] = pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo; dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strIDDM_NamHoc] = pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc; dr[pKQHT_DanhSachKhongThiTotNghiepInfo.strXetVot] = pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot; }
public DataTable Get(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID)); return(RunProcedureGet("sp_KQHT_DanhSachKhongThiTotNghiep_Get", colParam)); }
public frmXetThiTotNghiep() { InitializeComponent(); oBDM_Lop = new cBDM_Lop(); pDM_LopInfo = new DM_LopInfo(); oBSV_SinhVien = new cBSV_SinhVien(); oBKQHT_DanhSachKhongThiTotNghiep = new cBKQHT_DanhSachKhongThiTotNghiep(); pKQHT_DanhSachKhongThiTotNghiepInfo = new KQHT_DanhSachKhongThiTotNghiepInfo(); }
public int Add(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { int ID = 0; ID = oDKQHT_DanhSachKhongThiTotNghiep.Add(pKQHT_DanhSachKhongThiTotNghiepInfo); mErrorMessage = oDKQHT_DanhSachKhongThiTotNghiep.ErrorMessages; mErrorNumber = oDKQHT_DanhSachKhongThiTotNghiep.ErrorNumber; return(ID); }
public void Update(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@XetVot", SqlDbType.Bit, pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot)); colParam.Add(CreateParam("@KQHT_DanhSachKhongThiTotNghiepID", SqlDbType.BigInt, pKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID)); RunProcedure("sp_KQHT_DanhSachKhongThiTotNghiep_Update", colParam); }
public int Add(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@LyDo", SqlDbType.NVarChar, pKQHT_DanhSachKhongThiTotNghiepInfo.LyDo)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@XetVot", SqlDbType.Bit, pKQHT_DanhSachKhongThiTotNghiepInfo.XetVot)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_DanhSachKhongThiTotNghiep_Add", colParam)); }
public List <KQHT_DanhSachKhongThiTotNghiepInfo> GetList(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { List <KQHT_DanhSachKhongThiTotNghiepInfo> oKQHT_DanhSachKhongThiTotNghiepInfoList = new List <KQHT_DanhSachKhongThiTotNghiepInfo>(); DataTable dtb = Get(pKQHT_DanhSachKhongThiTotNghiepInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_DanhSachKhongThiTotNghiepInfo = new KQHT_DanhSachKhongThiTotNghiepInfo(); oKQHT_DanhSachKhongThiTotNghiepInfo.KQHT_DanhSachKhongThiTotNghiepID = int.Parse(dtb.Rows[i]["KQHT_DanhSachKhongThiTotNghiepID"].ToString()); oKQHT_DanhSachKhongThiTotNghiepInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString()); oKQHT_DanhSachKhongThiTotNghiepInfo.LyDo = dtb.Rows[i]["LyDo"].ToString(); oKQHT_DanhSachKhongThiTotNghiepInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString()); oKQHT_DanhSachKhongThiTotNghiepInfo.XetVot = bool.Parse(dtb.Rows[i]["XetVot"].ToString()); oKQHT_DanhSachKhongThiTotNghiepInfoList.Add(oKQHT_DanhSachKhongThiTotNghiepInfo); } } return(oKQHT_DanhSachKhongThiTotNghiepInfoList); }
public void Delete(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { oDKQHT_DanhSachKhongThiTotNghiep.Delete(pKQHT_DanhSachKhongThiTotNghiepInfo); mErrorMessage = oDKQHT_DanhSachKhongThiTotNghiep.ErrorMessages; mErrorNumber = oDKQHT_DanhSachKhongThiTotNghiep.ErrorNumber; }
public DataTable Get(KQHT_DanhSachKhongThiTotNghiepInfo pKQHT_DanhSachKhongThiTotNghiepInfo) { return(oDKQHT_DanhSachKhongThiTotNghiep.Get(pKQHT_DanhSachKhongThiTotNghiepInfo)); }