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;
}
