public List <KQHT_CT_KhoiKienThucInfo> GetList(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { List <KQHT_CT_KhoiKienThucInfo> oKQHT_CT_KhoiKienThucInfoList = new List <KQHT_CT_KhoiKienThucInfo>(); DataTable dtb = Get(pKQHT_CT_KhoiKienThucInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oKQHT_CT_KhoiKienThucInfo = new KQHT_CT_KhoiKienThucInfo(); oKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID = int.Parse(dtb.Rows[i]["KQHT_CT_KhoiKienThucID"].ToString()); oKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc = dtb.Rows[i]["TenCT_KhoiKienThuc"].ToString(); oKQHT_CT_KhoiKienThucInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i]["IDDM_TrinhDo"].ToString()); oKQHT_CT_KhoiKienThucInfo.IDDM_Nganh = int.Parse(dtb.Rows[i]["IDDM_Nganh"].ToString()); oKQHT_CT_KhoiKienThucInfo.IDDM_ChuyenNganh = int.Parse(dtb.Rows[i]["IDDM_ChuyenNganh"].ToString()); oKQHT_CT_KhoiKienThucInfo.IDDM_KhoaHoc = int.Parse(dtb.Rows[i]["IDDM_KhoaHoc"].ToString()); oKQHT_CT_KhoiKienThucInfo.IDDM_KhoiKienThuc = int.Parse(dtb.Rows[i]["IDDM_KhoiKienThuc"].ToString()); oKQHT_CT_KhoiKienThucInfo.CT_KhoiKienThucSo = int.Parse(dtb.Rows[i]["CT_KhoiKienThucSo"].ToString()); oKQHT_CT_KhoiKienThucInfo.TongSoHocTrinh = int.Parse(dtb.Rows[i]["TongSoHocTrinh"].ToString()); oKQHT_CT_KhoiKienThucInfo.TongSoMon = int.Parse(dtb.Rows[i]["TongSoMon"].ToString()); oKQHT_CT_KhoiKienThucInfo.MoTa = dtb.Rows[i]["MoTa"].ToString(); oKQHT_CT_KhoiKienThucInfoList.Add(oKQHT_CT_KhoiKienThucInfo); } } return(oKQHT_CT_KhoiKienThucInfoList); }
public dlgCT_KhoiKienThuc(KQHT_CT_KhoiKienThucInfo mpCTDT, EDIT_MODE mEdit, int mMaxCTSo) { InitializeComponent(); pCTDT = mpCTDT; edit = mEdit; MaxCTSo = mMaxCTSo; }
private void barbtnThemMoi_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { dlgCT_KhoiKienThuc dlg = new dlgCT_KhoiKienThuc(pKQHT_CT_KhoiKienThucInfo, EDIT_MODE.THEM, mMaxCTSo); dlg.ShowDialog(); if (dlg.Tag.ToString() == "1") { try { pKQHT_CT_KhoiKienThucInfo = dlg.pCTDT; pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID = oBKQHT_CT_KhoiKienThuc.Add(pKQHT_CT_KhoiKienThucInfo); DataRow drNew = dtCTDT.NewRow(); oBKQHT_CT_KhoiKienThuc.ToDataRow(pKQHT_CT_KhoiKienThucInfo, ref drNew); drNew["TenTrinhDo"] = dlg.cmbTrinhDo.Text; DM_HeInfo pDM_HeInfo = new DM_HeInfo(); pDM_HeInfo.DM_HeID = int.Parse(dlg.cmbTrinhDo.GetColumnValue("IDDM_He").ToString()); drNew["TenHe"] = new cBDM_He().Get(pDM_HeInfo).Rows[0]["TenHe"].ToString(); drNew["TenKhoiKienThuc"] = dlg.cmbKhoiKienThuc.Text; drNew["TenNganh"] = dlg.ucmbNganh.cmb.Text; drNew["TenChuyenNganh"] = dlg.ucmbChuyenNganh.cmb.Text; drNew["TenKhoaHoc"] = dlg.cmbKhoaHoc.Text; dtCTDT.Rows.Add(drNew); //LoadCTDT(); dlgCTDTChonMonHoc dlgMon = new dlgCTDTChonMonHoc(pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID, pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc, ref dtMonHoc); dlgMon.ShowDialog(); // Ghi Log GhiLog("Thêm chương trình khối kiến thức '" + pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc + "'", "Thêm", this.Tag.ToString()); ThemThanhCong(); } catch (Exception ex) { ThongBao(ex.Message); } } }
private void barbtnSua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (grvCTDT.FocusedRowHandle >= 0) { dlgCT_KhoiKienThuc dlg = new dlgCT_KhoiKienThuc(pKQHT_CT_KhoiKienThucInfo, EDIT_MODE.SUA, mMaxCTSo); dlg.ShowDialog(); if (dlg.Tag.ToString() == "1") { try { pKQHT_CT_KhoiKienThucInfo = dlg.pCTDT; oBKQHT_CT_KhoiKienThuc.Update(pKQHT_CT_KhoiKienThucInfo); // Ghi Log GhiLog("Sửa chương trình khối kiến thức '" + pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc + "'", "Sửa", this.Tag.ToString()); LoadCTDT(); SuaThanhCong(); } catch (Exception ex) { ThongBao(ex.Message); } } } else { ThongBao("Bạn chưa chọn chương trình khối kiến thức nào."); } }
public DataTable Get(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { using (var client = new UnimOsServiceClient()) { return(ConvertList.ToDataTable <KQHT_CT_KhoiKienThucInfo>(client.cDKQHT_CT_KhoiKienThuc_Get(GlobalVar.MaXacThuc, pKQHT_CT_KhoiKienThucInfo))); } }
private void barbtnThemKeThua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (grvCTDT.FocusedRowHandle >= 0) { int IDKQHT_CT_KhoiKienThucGoc = pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID; dlgCT_KhoiKienThucKeThua frm = new dlgCT_KhoiKienThucKeThua(pKQHT_CT_KhoiKienThucInfo, mMaxCTSo); frm.ShowDialog(); if (frm.Tag.ToString() == "1") { try { pKQHT_CT_KhoiKienThucInfo = frm.pKQHT_CT_KhoiKienThucInfo; pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID = oBKQHT_CT_KhoiKienThuc.AddKeThua(pKQHT_CT_KhoiKienThucInfo, IDKQHT_CT_KhoiKienThucGoc); LoadCTDT(); //dlgCTDTChonMonHoc dlgMon = new dlgCTDTChonMonHoc(pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID, pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc, ref dtMonHoc); //dlgMon.ShowDialog(); // Ghi Log GhiLog("Thêm chương trình khối kiến thức '" + pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc + "'", "Thêm", this.Tag.ToString()); ThemThanhCong(); } catch (Exception ex) { ThongBao(ex.Message); } } } else { ThongBao("Bạn chưa chọn chương trình khối kiến thức nào."); } }
public DataTable Get(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID)); return(RunProcedureGet("sp_KQHT_CT_KhoiKienThuc_Get", colParam)); }
public dlgCT_KhoiKienThucKeThua(KQHT_CT_KhoiKienThucInfo mKQHT_CT_KhoiKienThucInfo, int mMaxCTSo) { InitializeComponent(); pKQHT_CT_KhoiKienThucInfo = mKQHT_CT_KhoiKienThucInfo; MaxCTSo = mMaxCTSo; this.Tag = ""; }
public int AddKeThua(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo, int IDKQHT_CT_KhoiKienThucGoc) { int ID = 0; ID = oDKQHT_CT_KhoiKienThuc.AddKeThua(pKQHT_CT_KhoiKienThucInfo, IDKQHT_CT_KhoiKienThucGoc); mErrorMessage = oDKQHT_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_CT_KhoiKienThuc.ErrorNumber; return(ID); }
public int Add(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { int ID = 0; ID = oDKQHT_CT_KhoiKienThuc.Add(pKQHT_CT_KhoiKienThucInfo); mErrorMessage = oDKQHT_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_CT_KhoiKienThuc.ErrorNumber; return(ID); }
public void Delete(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { var client = new UnimOsServiceClient(); client.cDKQHT_CT_KhoiKienThuc_Delete(GlobalVar.MaXacThuc, pKQHT_CT_KhoiKienThucInfo); client.Close(); mErrorMessage = oDKQHT_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_CT_KhoiKienThuc.ErrorNumber; }
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_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@KQHT_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID)); // colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); // return (int)RunProcedureOut("sp_KQHT_CT_KhoiKienThuc_Delete", colParam); RunProcedure("sp_KQHT_CT_KhoiKienThuc_Delete", colParam); }
public int AddKeThua(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo, int IDKQHT_CT_KhoiKienThucGoc) { int ID = 0; var client = new UnimOsServiceClient(); ID = client.cDKQHT_CT_KhoiKienThuc_AddKeThua(GlobalVar.MaXacThuc, pKQHT_CT_KhoiKienThucInfo, IDKQHT_CT_KhoiKienThucGoc); client.Close(); mErrorMessage = oDKQHT_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_CT_KhoiKienThuc.ErrorNumber; return(ID); }
public void ToDataRow(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo, ref DataRow dr) { dr[pKQHT_CT_KhoiKienThucInfo.strKQHT_CT_KhoiKienThucID] = pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID; dr[pKQHT_CT_KhoiKienThucInfo.strTenCT_KhoiKienThuc] = pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc; dr[pKQHT_CT_KhoiKienThucInfo.strIDDM_TrinhDo] = pKQHT_CT_KhoiKienThucInfo.IDDM_TrinhDo; dr[pKQHT_CT_KhoiKienThucInfo.strIDDM_Nganh] = pKQHT_CT_KhoiKienThucInfo.IDDM_Nganh; dr[pKQHT_CT_KhoiKienThucInfo.strIDDM_ChuyenNganh] = pKQHT_CT_KhoiKienThucInfo.IDDM_ChuyenNganh; dr[pKQHT_CT_KhoiKienThucInfo.strIDDM_KhoaHoc] = pKQHT_CT_KhoiKienThucInfo.IDDM_KhoaHoc; dr[pKQHT_CT_KhoiKienThucInfo.strIDDM_KhoiKienThuc] = pKQHT_CT_KhoiKienThucInfo.IDDM_KhoiKienThuc; dr[pKQHT_CT_KhoiKienThucInfo.strCT_KhoiKienThucSo] = pKQHT_CT_KhoiKienThucInfo.CT_KhoiKienThucSo; dr[pKQHT_CT_KhoiKienThucInfo.strTongSoHocTrinh] = pKQHT_CT_KhoiKienThucInfo.TongSoHocTrinh; dr[pKQHT_CT_KhoiKienThucInfo.strTongSoMon] = pKQHT_CT_KhoiKienThucInfo.TongSoMon; dr[pKQHT_CT_KhoiKienThucInfo.strMoTa] = pKQHT_CT_KhoiKienThucInfo.MoTa; }
public void Update(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TenCT_KhoiKienThuc", SqlDbType.NVarChar, pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc)); colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_TrinhDo)); colParam.Add(CreateParam("@IDDM_Nganh", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_Nganh)); colParam.Add(CreateParam("@IDDM_ChuyenNganh", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_ChuyenNganh)); colParam.Add(CreateParam("@IDDM_KhoaHoc", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_KhoaHoc)); colParam.Add(CreateParam("@IDDM_KhoiKienThuc", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_KhoiKienThuc)); colParam.Add(CreateParam("@CT_KhoiKienThucSo", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.CT_KhoiKienThucSo)); colParam.Add(CreateParam("@TongSoHocTrinh", SqlDbType.Real, pKQHT_CT_KhoiKienThucInfo.TongSoHocTrinh)); colParam.Add(CreateParam("@TongSoMon", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.TongSoMon)); colParam.Add(CreateParam("@MoTa", SqlDbType.NText, pKQHT_CT_KhoiKienThucInfo.MoTa)); colParam.Add(CreateParam("@KQHT_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.KQHT_CT_KhoiKienThucID)); RunProcedure("sp_KQHT_CT_KhoiKienThuc_Update", colParam); }
public int Add(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TenCT_KhoiKienThuc", SqlDbType.NVarChar, pKQHT_CT_KhoiKienThucInfo.TenCT_KhoiKienThuc)); colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_TrinhDo)); colParam.Add(CreateParam("@IDDM_Nganh", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_Nganh)); colParam.Add(CreateParam("@IDDM_ChuyenNganh", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_ChuyenNganh)); colParam.Add(CreateParam("@IDDM_KhoaHoc", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_KhoaHoc)); colParam.Add(CreateParam("@IDDM_KhoiKienThuc", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.IDDM_KhoiKienThuc)); colParam.Add(CreateParam("@CT_KhoiKienThucSo", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.CT_KhoiKienThucSo)); colParam.Add(CreateParam("@TongSoHocTrinh", SqlDbType.Real, pKQHT_CT_KhoiKienThucInfo.TongSoHocTrinh)); colParam.Add(CreateParam("@TongSoMon", SqlDbType.Int, pKQHT_CT_KhoiKienThucInfo.TongSoMon)); colParam.Add(CreateParam("@MoTa", SqlDbType.NText, pKQHT_CT_KhoiKienThucInfo.MoTa)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_KQHT_CT_KhoiKienThuc_Add", colParam)); }
public DataTable Get(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { return(oDKQHT_CT_KhoiKienThuc.Get(pKQHT_CT_KhoiKienThucInfo)); }
public void Delete(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo) { oDKQHT_CT_KhoiKienThuc.Delete(pKQHT_CT_KhoiKienThucInfo); mErrorMessage = oDKQHT_CT_KhoiKienThuc.ErrorMessages; mErrorNumber = oDKQHT_CT_KhoiKienThuc.ErrorNumber; }