public List <KQHT_DanhSachDuThiInfo> GetList(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { List <KQHT_DanhSachDuThiInfo> oKQHT_DanhSachDuThiInfoList = new List <KQHT_DanhSachDuThiInfo>(); DataTable dtb = Get(pKQHT_DanhSachDuThiInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_DanhSachDuThiInfo = new KQHT_DanhSachDuThiInfo(); oKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID = long.Parse(dtb.Rows[i]["KQHT_DanhSachDuThiID"].ToString()); oKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi = int.Parse(dtb.Rows[i]["IDKQHT_ToChucThi"].ToString()); oKQHT_DanhSachDuThiInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString()); oKQHT_DanhSachDuThiInfo.IDDM_PhongHoc = int.Parse(dtb.Rows[i]["IDDM_PhongHoc"].ToString()); oKQHT_DanhSachDuThiInfo.SoBaoDanh = int.Parse(dtb.Rows[i]["SoBaoDanh"].ToString()); oKQHT_DanhSachDuThiInfo.SoPhach = dtb.Rows[i]["SoPhach"].ToString(); oKQHT_DanhSachDuThiInfo.TuiThiSo = int.Parse(dtb.Rows[i]["TuiThiSo"].ToString()); oKQHT_DanhSachDuThiInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString(); oKQHT_DanhSachDuThiInfoList.Add(oKQHT_DanhSachDuThiInfo); } } return(oKQHT_DanhSachDuThiInfoList); }
public void Delete(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID)); RunProcedure("sp_KQHT_DanhSachDuThi_Delete", colParam); }
public DataTable Get(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID)); return(RunProcedureGet("sp_KQHT_DanhSachDuThi_Get", colParam)); }
public int Add(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { int ID = 0; ID = oDKQHT_DanhSachDuThi.Add(pKQHT_DanhSachDuThiInfo); mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages; mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber; return(ID); }
public void ToInfo(ref KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo, DataRow dr) { pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID = long.Parse(dr[pKQHT_DanhSachDuThiInfo.strKQHT_DanhSachDuThiID].ToString()); pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDKQHT_ToChucThi].ToString()); pKQHT_DanhSachDuThiInfo.IDSV_SinhVien = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDSV_SinhVien].ToString()); pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strIDDM_PhongHoc].ToString()); pKQHT_DanhSachDuThiInfo.SoBaoDanh = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strSoBaoDanh].ToString()); pKQHT_DanhSachDuThiInfo.SoPhach = dr[pKQHT_DanhSachDuThiInfo.strSoPhach].ToString(); pKQHT_DanhSachDuThiInfo.TuiThiSo = int.Parse(dr[pKQHT_DanhSachDuThiInfo.strTuiThiSo].ToString()); pKQHT_DanhSachDuThiInfo.GhiChu = dr[pKQHT_DanhSachDuThiInfo.strGhiChu].ToString(); }
public void ToDataRow(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo, ref DataRow dr) { dr[pKQHT_DanhSachDuThiInfo.strKQHT_DanhSachDuThiID] = pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID; dr[pKQHT_DanhSachDuThiInfo.strIDKQHT_ToChucThi] = pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi; dr[pKQHT_DanhSachDuThiInfo.strIDSV_SinhVien] = pKQHT_DanhSachDuThiInfo.IDSV_SinhVien; dr[pKQHT_DanhSachDuThiInfo.strIDDM_PhongHoc] = pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc; dr[pKQHT_DanhSachDuThiInfo.strSoBaoDanh] = pKQHT_DanhSachDuThiInfo.SoBaoDanh; dr[pKQHT_DanhSachDuThiInfo.strSoPhach] = pKQHT_DanhSachDuThiInfo.SoPhach; dr[pKQHT_DanhSachDuThiInfo.strTuiThiSo] = pKQHT_DanhSachDuThiInfo.TuiThiSo; dr[pKQHT_DanhSachDuThiInfo.strGhiChu] = pKQHT_DanhSachDuThiInfo.GhiChu; }
public void Update(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi)); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc)); colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.SoBaoDanh)); colParam.Add(CreateParam("@SoPhach", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.SoPhach)); colParam.Add(CreateParam("@TuiThiSo", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.TuiThiSo)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.GhiChu)); colParam.Add(CreateParam("@KQHT_DanhSachDuThiID", SqlDbType.BigInt, pKQHT_DanhSachDuThiInfo.KQHT_DanhSachDuThiID)); RunProcedure("sp_KQHT_DanhSachDuThi_Update", colParam); }
public int Add(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDKQHT_ToChucThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDKQHT_ToChucThi)); colParam.Add(CreateParam("@LanThi", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.LanThi)); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.IDDM_PhongHoc)); colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.SoBaoDanh)); colParam.Add(CreateParam("@SoPhach", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.SoPhach)); colParam.Add(CreateParam("@TuiThiSo", SqlDbType.Int, pKQHT_DanhSachDuThiInfo.TuiThiSo)); colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pKQHT_DanhSachDuThiInfo.GhiChu)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_DanhSachDuThi_Add", colParam)); }
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 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; }
public void Update(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { oDKQHT_DanhSachDuThi.Update(pKQHT_DanhSachDuThiInfo); mErrorMessage = oDKQHT_DanhSachDuThi.ErrorMessages; mErrorNumber = oDKQHT_DanhSachDuThi.ErrorNumber; }
public DataTable Get(KQHT_DanhSachDuThiInfo pKQHT_DanhSachDuThiInfo) { return(oDKQHT_DanhSachDuThi.Get(pKQHT_DanhSachDuThiInfo)); }