public DataTable Get(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_TrinhDo_GetResult>(client.cDDM_TrinhDo_Get(GlobalVar.MaXacThuc, pDM_TrinhDoInfo)));
}
}
public frmTrinhDo()
{
InitializeComponent();
oBTrinhDo = new cBDM_TrinhDo();
pTrinhDoInfo = new DM_TrinhDoInfo();
LstTrinhDo = new List <DM_TrinhDoInfo>();
LstTrinhDo = oBTrinhDo.GetList(pTrinhDoInfo);
}
public void Delete(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_TrinhDoID", SqlDbType.Int, pDM_TrinhDoInfo.DM_TrinhDoID));
RunProcedure("sp_DM_TrinhDo_Delete", colParam);
}
public DataTable Get(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_TrinhDoID", SqlDbType.Int, pDM_TrinhDoInfo.DM_TrinhDoID));
return(RunProcedureGet("sp_DM_TrinhDo_Get", colParam));
}
public int Add(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
int ID = 0;
ID = oDDM_TrinhDo.Add(pDM_TrinhDoInfo);
mErrorMessage = oDDM_TrinhDo.ErrorMessages;
mErrorNumber = oDDM_TrinhDo.ErrorNumber;
return(ID);
}
public frmXetLenLop()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBSV_SinhVien = new cBSV_SinhVien();
pDM_LopInfo = new DM_LopInfo();
oBKQHT_DiemTongKetHocKy = new cBKQHT_DiemTongKetHocKy();
pDM_TrinhDoInfo = new DM_TrinhDoInfo();
oBDM_TrinhDo = new cBDM_TrinhDo();
}
public void Update(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_He", SqlDbType.Int, pDM_TrinhDoInfo.IDDM_He));
colParam.Add(CreateParam("@IDKQHT_QuyChe", SqlDbType.Int, pDM_TrinhDoInfo.IDKQHT_QuyChe));
colParam.Add(CreateParam("@MaTrinhDo", SqlDbType.NVarChar, pDM_TrinhDoInfo.MaTrinhDo));
colParam.Add(CreateParam("@TenTrinhDo", SqlDbType.NVarChar, pDM_TrinhDoInfo.TenTrinhDo));
colParam.Add(CreateParam("@TenTrinhDo_E", SqlDbType.NVarChar, pDM_TrinhDoInfo.TenTrinhDo_E));
colParam.Add(CreateParam("@DM_TrinhDoID", SqlDbType.Int, pDM_TrinhDoInfo.DM_TrinhDoID));
RunProcedure("sp_DM_TrinhDo_Update", colParam);
}
public int Add(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_He", SqlDbType.Int, pDM_TrinhDoInfo.IDDM_He));
colParam.Add(CreateParam("@IDKQHT_QuyChe", SqlDbType.Int, pDM_TrinhDoInfo.IDKQHT_QuyChe));
colParam.Add(CreateParam("@MaTrinhDo", SqlDbType.NVarChar, pDM_TrinhDoInfo.MaTrinhDo));
colParam.Add(CreateParam("@TenTrinhDo", SqlDbType.NVarChar, pDM_TrinhDoInfo.TenTrinhDo));
colParam.Add(CreateParam("@TenTrinhDo_E", SqlDbType.NVarChar, pDM_TrinhDoInfo.TenTrinhDo_E));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_TrinhDo_Add", colParam));
}
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_TrinhDoInfo> GetList(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
List <DM_TrinhDoInfo> oDM_TrinhDoInfoList = new List <DM_TrinhDoInfo>();
DataTable dtb = Get(pDM_TrinhDoInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_TrinhDoInfo = new DM_TrinhDoInfo();
oDM_TrinhDoInfo.DM_TrinhDoID = int.Parse(dtb.Rows[i]["DM_TrinhDoID"].ToString());
oDM_TrinhDoInfo.IDDM_He = int.Parse(dtb.Rows[i]["IDDM_He"].ToString());
oDM_TrinhDoInfo.IDKQHT_QuyChe = int.Parse(dtb.Rows[i]["IDKQHT_QuyChe"].ToString());
oDM_TrinhDoInfo.MaTrinhDo = dtb.Rows[i]["MaTrinhDo"].ToString();
oDM_TrinhDoInfo.TenTrinhDo = dtb.Rows[i]["TenTrinhDo"].ToString();
oDM_TrinhDoInfo.TenTrinhDo_E = dtb.Rows[i]["TenTrinhDo_E"].ToString();
oDM_TrinhDoInfoList.Add(oDM_TrinhDoInfo);
}
}
return(oDM_TrinhDoInfoList);
}
public void Delete(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
oDDM_TrinhDo.Delete(pDM_TrinhDoInfo);
mErrorMessage = oDDM_TrinhDo.ErrorMessages;
mErrorNumber = oDDM_TrinhDo.ErrorNumber;
}
public DataTable Get(DM_TrinhDoInfo pDM_TrinhDoInfo)
{
return(oDDM_TrinhDo.Get(pDM_TrinhDoInfo));
}
