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);
}
}
}
public void Delete(DM_HeInfo pDM_HeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_HeID", SqlDbType.Int, pDM_HeInfo.DM_HeID));
RunProcedure("sp_DM_He_Delete", colParam);
}
public DataTable Get(DM_HeInfo pDM_HeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_HeID", SqlDbType.Int, pDM_HeInfo.DM_HeID));
return(RunProcedureGet("sp_DM_He_Get", colParam));
}
public frmHeDaoTao()
{
InitializeComponent();
oBHe = new cBDM_He();
pDM_HeInfo = new DM_HeInfo();
lstHe = new List <DM_HeInfo>();
lstHe = oBHe.GetList(pDM_HeInfo);
}
public int Add(DM_HeInfo pDM_HeInfo)
{
int ID = 0;
ID = oDDM_He.Add(pDM_HeInfo);
mErrorMessage = oDDM_He.ErrorMessages;
mErrorNumber = oDDM_He.ErrorNumber;
return(ID);
}
public void Update(DM_HeInfo pDM_HeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaHe", SqlDbType.NVarChar, pDM_HeInfo.MaHe));
colParam.Add(CreateParam("@TenHe", SqlDbType.NVarChar, pDM_HeInfo.TenHe));
colParam.Add(CreateParam("@TenHe_E", SqlDbType.NVarChar, pDM_HeInfo.TenHe_E));
colParam.Add(CreateParam("@DM_HeID", SqlDbType.Int, pDM_HeInfo.DM_HeID));
RunProcedure("sp_DM_He_Update", colParam);
}
public int Add(DM_HeInfo pDM_HeInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaHe", SqlDbType.NVarChar, pDM_HeInfo.MaHe));
colParam.Add(CreateParam("@TenHe", SqlDbType.NVarChar, pDM_HeInfo.TenHe));
colParam.Add(CreateParam("@TenHe_E", SqlDbType.NVarChar, pDM_HeInfo.TenHe_E));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_He_Add", colParam));
}
private void GetHe()
{
cBDM_He oBHe = new cBDM_He();
DM_HeInfo pHeInfo = new DM_HeInfo();
pHeInfo.DM_HeID = 0;
DataTable dt = oBHe.Get(pHeInfo);
cmbIDTrinhDo.Properties.DataSource = dt;
cmbIDTrinhDo.Properties.DisplayMember = "TenHe";
cmbIDTrinhDo.Properties.ValueMember = "DM_HeID";
}
public frmLopGop()
{
InitializeComponent();
this.Tag = "";
oBDM_He = new cBDM_He();
oBDM_Nganh = new cBDM_Nganh();
oBDM_TrinhDo = new cBDM_TrinhDo();
oBDM_KhoaHoc = new cBDM_KhoaHoc();
pDM_HeInfo = new DM_HeInfo();
pDM_NganhInfo = new DM_NganhInfo();
pDM_TrinhDoInfo = new DM_TrinhDoInfo();
pDM_KhoaHocInfo = new DM_KhoaHocInfo();
pXL_LopTachGopInfo = new XL_LopTachGopInfo();
oBXL_LopTachGop = new cBXL_LopTachGop();
}
public List <DM_HeInfo> GetList(DM_HeInfo pDM_HeInfo)
{
List <DM_HeInfo> oDM_HeInfoList = new List <DM_HeInfo>();
DataTable dtb = Get(pDM_HeInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_HeInfo = new DM_HeInfo();
oDM_HeInfo.DM_HeID = int.Parse(dtb.Rows[i]["DM_HeID"].ToString());
oDM_HeInfo.MaHe = dtb.Rows[i]["MaHe"].ToString();
oDM_HeInfo.TenHe = dtb.Rows[i]["TenHe"].ToString();
oDM_HeInfo.TenHe_E = dtb.Rows[i]["TenHe_E"].ToString();
oDM_HeInfoList.Add(oDM_HeInfo);
}
}
return(oDM_HeInfoList);
}
public void Delete(DM_HeInfo pDM_HeInfo)
{
oDDM_He.Delete(pDM_HeInfo);
mErrorMessage = oDDM_He.ErrorMessages;
mErrorNumber = oDDM_He.ErrorNumber;
}
public void Update(DM_HeInfo pDM_HeInfo)
{
oDDM_He.Update(pDM_HeInfo);
mErrorMessage = oDDM_He.ErrorMessages;
mErrorNumber = oDDM_He.ErrorNumber;
}
public DataTable Get(DM_HeInfo pDM_HeInfo)
{
return(oDDM_He.Get(pDM_HeInfo));
}
