public List <KQHT_ToChucThiInfo> GetList(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { List <KQHT_ToChucThiInfo> oKQHT_ToChucThiInfoList = new List <KQHT_ToChucThiInfo>(); DataTable dtb = Get(pKQHT_ToChucThiInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_ToChucThiInfo = new KQHT_ToChucThiInfo(); oKQHT_ToChucThiInfo.KQHT_ToChucThiID = int.Parse(dtb.Rows[i]["KQHT_ToChucThiID"].ToString()); oKQHT_ToChucThiInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString()); oKQHT_ToChucThiInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString()); oKQHT_ToChucThiInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString()); oKQHT_ToChucThiInfo.LanThi = int.Parse(dtb.Rows[i]["LanThi"].ToString()); oKQHT_ToChucThiInfo.DotThi = int.Parse(dtb.Rows[i]["DotThi"].ToString()); oKQHT_ToChucThiInfo.NgayThi = DateTime.Parse(dtb.Rows[i]["NgayThi"].ToString()); oKQHT_ToChucThiInfo.CaThi = int.Parse(dtb.Rows[i]["CaThi"].ToString()); oKQHT_ToChucThiInfo.NhomTiet = int.Parse(dtb.Rows[i]["NhomTiet"].ToString()); oKQHT_ToChucThiInfo.IDHT_User = int.Parse(dtb.Rows[i]["IDHT_User"].ToString()); oKQHT_ToChucThiInfo.NgayTao = DateTime.Parse(dtb.Rows[i]["NgayTao"].ToString()); oKQHT_ToChucThiInfoList.Add(oKQHT_ToChucThiInfo); } } return(oKQHT_ToChucThiInfoList); }
public void Delete(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_ToChucThiID", SqlDbType.Int, pKQHT_ToChucThiInfo.KQHT_ToChucThiID)); RunProcedure("sp_KQHT_ToChucThi_Delete", colParam); }
public DataTable Get(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_ToChucThiID", SqlDbType.Int, pKQHT_ToChucThiInfo.KQHT_ToChucThiID)); return(RunProcedureGet("sp_KQHT_ToChucThi_Get", colParam)); }
public int Add(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { int ID = 0; ID = oDKQHT_ToChucThi.Add(pKQHT_ToChucThiInfo); mErrorMessage = oDKQHT_ToChucThi.ErrorMessages; mErrorNumber = oDKQHT_ToChucThi.ErrorNumber; return(ID); }
public void ToInfo(ref KQHT_ToChucThiInfo pKQHT_ToChucThiInfo, DataRow dr) { pKQHT_ToChucThiInfo.KQHT_ToChucThiID = int.Parse(dr[pKQHT_ToChucThiInfo.strKQHT_ToChucThiID].ToString()); pKQHT_ToChucThiInfo.IDDM_MonHoc = int.Parse(dr[pKQHT_ToChucThiInfo.strIDDM_MonHoc].ToString()); pKQHT_ToChucThiInfo.IDDM_NamHoc = int.Parse(dr[pKQHT_ToChucThiInfo.strIDDM_NamHoc].ToString()); pKQHT_ToChucThiInfo.HocKy = int.Parse(dr[pKQHT_ToChucThiInfo.strHocKy].ToString()); pKQHT_ToChucThiInfo.LanThi = int.Parse(dr[pKQHT_ToChucThiInfo.strLanThi].ToString()); pKQHT_ToChucThiInfo.DotThi = int.Parse(dr[pKQHT_ToChucThiInfo.strDotThi].ToString()); pKQHT_ToChucThiInfo.NgayThi = DateTime.Parse(dr[pKQHT_ToChucThiInfo.strNgayThi].ToString()); pKQHT_ToChucThiInfo.CaThi = int.Parse(dr[pKQHT_ToChucThiInfo.strCaThi].ToString()); pKQHT_ToChucThiInfo.NhomTiet = int.Parse(dr[pKQHT_ToChucThiInfo.strNhomTiet].ToString()); pKQHT_ToChucThiInfo.IDHT_User = int.Parse(dr[pKQHT_ToChucThiInfo.strIDHT_User].ToString()); pKQHT_ToChucThiInfo.NgayTao = DateTime.Parse(dr[pKQHT_ToChucThiInfo.strNgayTao].ToString()); }
public void ToDataRow(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo, ref DataRow dr) { dr[pKQHT_ToChucThiInfo.strKQHT_ToChucThiID] = pKQHT_ToChucThiInfo.KQHT_ToChucThiID; dr[pKQHT_ToChucThiInfo.strIDDM_MonHoc] = pKQHT_ToChucThiInfo.IDDM_MonHoc; dr[pKQHT_ToChucThiInfo.strIDDM_NamHoc] = pKQHT_ToChucThiInfo.IDDM_NamHoc; dr[pKQHT_ToChucThiInfo.strHocKy] = pKQHT_ToChucThiInfo.HocKy; dr[pKQHT_ToChucThiInfo.strLanThi] = pKQHT_ToChucThiInfo.LanThi; dr[pKQHT_ToChucThiInfo.strDotThi] = pKQHT_ToChucThiInfo.DotThi; dr[pKQHT_ToChucThiInfo.strNgayThi] = pKQHT_ToChucThiInfo.NgayThi; dr[pKQHT_ToChucThiInfo.strCaThi] = pKQHT_ToChucThiInfo.CaThi; dr[pKQHT_ToChucThiInfo.strNhomTiet] = pKQHT_ToChucThiInfo.NhomTiet; dr[pKQHT_ToChucThiInfo.strIDHT_User] = pKQHT_ToChucThiInfo.IDHT_User; dr[pKQHT_ToChucThiInfo.strNgayTao] = pKQHT_ToChucThiInfo.NgayTao; }
public frmToChucThi(int mIDKQHT_ToChucThi, int mIDDM_MonHoc, string TenMonHoc) { InitializeComponent(); IDKQHT_ToChucThi = mIDKQHT_ToChucThi; IDDM_MonHoc = mIDDM_MonHoc; txtTenMonHoc.Text = TenMonHoc; oBDM_Lop = new cBDM_Lop(); oBDM_MonHoc = new cBDM_MonHoc(); oBKQHT_ToChucThi = new cBKQHT_ToChucThi(); pKQHT_ToChucThiInfo = new KQHT_ToChucThiInfo(); oBKQHT_DanhSachDuThi = new cBKQHT_DanhSachDuThi(); pKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo(); DataTable dt = (new cBDM_PhongHoc()).GetAll(); repositoryItemLookUpEditPhongThi.DataSource = dt; dtpNgayThi.EditValue = DateTime.Today; }
public void Update(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_ToChucThiInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_ToChucThiInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_ToChucThiInfo.HocKy)); colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_ToChucThiInfo.LanThi)); colParam.Add(CreateParam("@DotThi", SqlDbType.Int, pKQHT_ToChucThiInfo.DotThi)); colParam.Add(CreateParam("@NgayThi", SqlDbType.DateTime, pKQHT_ToChucThiInfo.NgayThi)); colParam.Add(CreateParam("@CaThi", SqlDbType.Int, pKQHT_ToChucThiInfo.CaThi)); colParam.Add(CreateParam("@NhomTiet", SqlDbType.Int, pKQHT_ToChucThiInfo.NhomTiet)); colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_ToChucThiInfo.IDHT_User)); colParam.Add(CreateParam("@DongTui", SqlDbType.Bit, pKQHT_ToChucThiInfo.DongTui)); colParam.Add(CreateParam("@TotNghiep", SqlDbType.Bit, pKQHT_ToChucThiInfo.TotNghiep)); colParam.Add(CreateParam("@KQHT_ToChucThiID", SqlDbType.Int, pKQHT_ToChucThiInfo.KQHT_ToChucThiID)); RunProcedure("sp_KQHT_ToChucThi_Update", colParam); }
public int Add(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_ToChucThiInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pKQHT_ToChucThiInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pKQHT_ToChucThiInfo.HocKy)); colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_ToChucThiInfo.LanThi)); colParam.Add(CreateParam("@DotThi", SqlDbType.Int, pKQHT_ToChucThiInfo.DotThi)); colParam.Add(CreateParam("@NgayThi", SqlDbType.DateTime, pKQHT_ToChucThiInfo.NgayThi)); colParam.Add(CreateParam("@CaThi", SqlDbType.Int, pKQHT_ToChucThiInfo.CaThi)); colParam.Add(CreateParam("@NhomTiet", SqlDbType.Int, pKQHT_ToChucThiInfo.NhomTiet)); colParam.Add(CreateParam("@IDHT_User", SqlDbType.Int, pKQHT_ToChucThiInfo.IDHT_User)); colParam.Add(CreateParam("@DongTui", SqlDbType.Bit, pKQHT_ToChucThiInfo.DongTui)); colParam.Add(CreateParam("@TotNghiep", SqlDbType.Bit, pKQHT_ToChucThiInfo.TotNghiep)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_ToChucThi_Add", colParam)); }
public frmToChucThi_TotNghiep(int mIDKQHT_ToChucThi, int mIDDM_MonHoc, DataTable dtMonHoc) { InitializeComponent(); IDKQHT_ToChucThi = mIDKQHT_ToChucThi; cmbMonThiTotNghiep.Properties.DataSource = dtMonHoc; cmbMonThiTotNghiep.EditValue = mIDDM_MonHoc; cmbSapXepDanhSach.Properties.DataSource = bLoadSapXep(); oBDM_Lop = new cBDM_Lop(); oBDM_MonHoc = new cBDM_MonHoc(); oBKQHT_ToChucThi = new cBKQHT_ToChucThi(); pKQHT_ToChucThiInfo = new KQHT_ToChucThiInfo(); oBKQHT_DanhSachDuThi = new cBKQHT_DanhSachDuThi(); pKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo(); DataTable dt = (new cBDM_PhongHoc()).GetAll(); repositoryItemLookUpEditPhongThi.DataSource = dt; dtpNgayThi.EditValue = DateTime.Today; }
private void barbtnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (grvDotThi.RowCount > 0) { if (bool.Parse(grvDotThi.GetDataRow(grvDotThi.FocusedRowHandle)["DongTui"].ToString())) { ThongBao("Đợt thi của môn này đã đóng túi, bạn không thể xóa."); return; } else { if (ThongBaoChon("Bạn có chắc chắn muốn xóa đợt thi này không ?") == DialogResult.Yes) { KQHT_ToChucThiInfo pKQHT_ToChucThiInfo = new KQHT_ToChucThiInfo(); pKQHT_ToChucThiInfo.KQHT_ToChucThiID = KQHT_ToChucThiID; oBKQHT_ToChucThi.Delete(pKQHT_ToChucThiInfo); grvDotThi.DeleteSelectedRows(); } } } }
public void Delete(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { oDKQHT_ToChucThi.Delete(pKQHT_ToChucThiInfo); mErrorMessage = oDKQHT_ToChucThi.ErrorMessages; mErrorNumber = oDKQHT_ToChucThi.ErrorNumber; }
public DataTable Get(KQHT_ToChucThiInfo pKQHT_ToChucThiInfo) { return(oDKQHT_ToChucThi.Get(pKQHT_ToChucThiInfo)); }