public DataTable Get(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { using (var client = new UnimOsServiceClient()) { return(ConvertList.ToDataTable <sp_KQHT_MonHoc_CT_KhoiKienThuc_GetResult>(client.cDKQHT_MonHoc_CT_KhoiKienThuc_Get(GlobalVar.MaXacThuc, pKQHT_MonHoc_CT_KhoiKienThucInfo))); } }
public List <KQHT_MonHoc_CT_KhoiKienThucInfo> GetList(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { List <KQHT_MonHoc_CT_KhoiKienThucInfo> oKQHT_MonHoc_CT_KhoiKienThucInfoList = new List <KQHT_MonHoc_CT_KhoiKienThucInfo>(); DataTable dtb = Get(pKQHT_MonHoc_CT_KhoiKienThucInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_MonHoc_CT_KhoiKienThucInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo(); oKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID = int.Parse(dtb.Rows[i]["KQHT_MonHoc_CT_KhoiKienThucID"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.IDKQHT_CT_KhoiKienThuc = int.Parse(dtb.Rows[i]["IDKQHT_CT_KhoiKienThuc"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.SoHocTrinh = double.Parse(dtb.Rows[i]["SoHocTrinh"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.SoTiet = int.Parse(dtb.Rows[i]["SoTiet"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.LyThuyet = int.Parse(dtb.Rows[i]["LyThuyet"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.ThucHanh = int.Parse(dtb.Rows[i]["ThucHanh"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac1 = int.Parse(dtb.Rows[i]["LoaiTietKhac1"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac2 = int.Parse(dtb.Rows[i]["LoaiTietKhac2"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.ChoPhepXepLich = bool.Parse(dtb.Rows[i]["ChoPhepXepLich"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_HinhThucThi = int.Parse(dtb.Rows[i]["IDDM_HinhThucThi"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.TuChon = bool.Parse(dtb.Rows[i]["TuChon"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfo.SapXep = int.Parse(dtb.Rows[i]["SapXep"].ToString()); oKQHT_MonHoc_CT_KhoiKienThucInfoList.Add(oKQHT_MonHoc_CT_KhoiKienThucInfo); } } return(oKQHT_MonHoc_CT_KhoiKienThucInfoList); }
public void Delete(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_MonHoc_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID)); RunProcedure("sp_KQHT_MonHoc_CT_KhoiKienThuc_Delete", colParam); }
public DataTable Get(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_MonHoc_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID)); return(RunProcedureGet("sp_KQHT_MonHoc_CT_KhoiKienThuc_Get", colParam)); }
public frmChuongTrinhKhoiKienThuc() { InitializeComponent(); oBKQHT_CT_KhoiKienThuc = new cBKQHT_CT_KhoiKienThuc(); pKQHT_CT_KhoiKienThucInfo = new KQHT_CT_KhoiKienThucInfo(); oBKQHT_MonHoc_CT_KhoiKienThuc = new cBKQHT_MonHoc_CT_KhoiKienThuc(); pKQHT_MonHoc_CT_KhoiKienThucInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo(); SetButton(false); }
public dlgChonCTKhoiKienThuc(int mIDKQHT_ChuongTrinhDaoTao) { InitializeComponent(); oBKQHT_CT_KhoiKienThuc = new cBKQHT_CT_KhoiKienThuc(); pKQHT_CT_KhoiKienThucInfo = new KQHT_CT_KhoiKienThucInfo(); oBKQHT_MonHoc_CT_KhoiKienThuc = new cBKQHT_MonHoc_CT_KhoiKienThuc(); pKQHT_MonHoc_CT_KhoiKienThucInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo(); IDKQHT_ChuongTrinhDaoTao = mIDKQHT_ChuongTrinhDaoTao; }
public void Delete(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { var client = new UnimOsServiceClient(); client.cDKQHT_MonHoc_CT_KhoiKienThuc_Delete(GlobalVar.MaXacThuc, pKQHT_MonHoc_CT_KhoiKienThucInfo); client.Close(); mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber; }
public int Add(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { int ID = 0; ID = oDKQHT_MonHoc_CT_KhoiKienThuc.Add(pKQHT_MonHoc_CT_KhoiKienThucInfo); mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber; return(ID); }
public dlgCTDTChonMonHoc(int mIDKQHT_CT_KhoiKienThuc, string TenCTDT, ref DataTable _dtMonHoc) { InitializeComponent(); dtMonHoc = _dtMonHoc; oBKQHT_MonHoc_CT_KhoiKienThuc = new cBKQHT_MonHoc_CT_KhoiKienThuc(); pInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo(); pInfo.IDKQHT_CT_KhoiKienThuc = mIDKQHT_CT_KhoiKienThuc; lblCTDT.Text = TenCTDT.ToUpper(); this.DialogResult = DialogResult.Cancel; }
public int Add(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { int ID = 0; var client = new UnimOsServiceClient(); ID = client.cDKQHT_MonHoc_CT_KhoiKienThuc_Add(GlobalVar.MaXacThuc, pKQHT_MonHoc_CT_KhoiKienThucInfo); client.Close(); mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber; return(ID); }
public void ToDataRow(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo, ref DataRow dr) { dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strKQHT_MonHoc_CT_KhoiKienThucID] = pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strIDKQHT_CT_KhoiKienThuc] = pKQHT_MonHoc_CT_KhoiKienThucInfo.IDKQHT_CT_KhoiKienThuc; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strIDDM_MonHoc] = pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_MonHoc; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strSoHocTrinh] = pKQHT_MonHoc_CT_KhoiKienThucInfo.SoHocTrinh; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strSoTiet] = pKQHT_MonHoc_CT_KhoiKienThucInfo.SoTiet; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strLyThuyet] = pKQHT_MonHoc_CT_KhoiKienThucInfo.LyThuyet; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strThucHanh] = pKQHT_MonHoc_CT_KhoiKienThucInfo.ThucHanh; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strLoaiTietKhac1] = pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac1; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strLoaiTietKhac2] = pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac2; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strChoPhepXepLich] = pKQHT_MonHoc_CT_KhoiKienThucInfo.ChoPhepXepLich; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strIDDM_HinhThucThi] = pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_HinhThucThi; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strTuChon] = pKQHT_MonHoc_CT_KhoiKienThucInfo.TuChon; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strSapXep] = pKQHT_MonHoc_CT_KhoiKienThucInfo.SapXep; dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strTinhDiemToanKhoa] = pKQHT_MonHoc_CT_KhoiKienThucInfo.TinhDiemToanKhoa; }
public void Update(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDKQHT_CT_KhoiKienThuc", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.IDKQHT_CT_KhoiKienThuc)); colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_MonHoc)); colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Real, pKQHT_MonHoc_CT_KhoiKienThucInfo.SoHocTrinh)); colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.SoTiet)); colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.LyThuyet)); colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.ThucHanh)); colParam.Add(CreateParam("@LoaiTietKhac1", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac1)); colParam.Add(CreateParam("@LoaiTietKhac2", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac2)); colParam.Add(CreateParam("@ChoPhepXepLich", SqlDbType.Bit, pKQHT_MonHoc_CT_KhoiKienThucInfo.ChoPhepXepLich)); colParam.Add(CreateParam("@IDDM_HinhThucThi", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_HinhThucThi)); colParam.Add(CreateParam("@TuChon", SqlDbType.Bit, pKQHT_MonHoc_CT_KhoiKienThucInfo.TuChon)); colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.SapXep)); colParam.Add(CreateParam("@TinhDiemToanKhoa", SqlDbType.Bit, pKQHT_MonHoc_CT_KhoiKienThucInfo.TinhDiemToanKhoa)); colParam.Add(CreateParam("@KQHT_MonHoc_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID)); RunProcedure("sp_KQHT_MonHoc_CT_KhoiKienThuc_Update", colParam); }
public void Delete(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { oDKQHT_MonHoc_CT_KhoiKienThuc.Delete(pKQHT_MonHoc_CT_KhoiKienThucInfo); mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber; }
public DataTable Get(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo) { return(oDKQHT_MonHoc_CT_KhoiKienThuc.Get(pKQHT_MonHoc_CT_KhoiKienThucInfo)); }