public void Delete(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_KhoaHocID", SqlDbType.Int, pDM_KhoaHocInfo.DM_KhoaHocID));
RunProcedure("sp_DM_KhoaHoc_Delete", colParam);
}
public frmKhoaHoc()
{
InitializeComponent();
oBDM_KhoaHoc = new cBDM_KhoaHoc();
pDM_KhoaHocInfo = new DM_KhoaHocInfo();
panelTop.Visible = false;
SetControl(false);
}
public DataTable Get(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_KhoaHocID", SqlDbType.Int, pDM_KhoaHocInfo.DM_KhoaHocID));
return(RunProcedureGet("sp_DM_KhoaHoc_Get", colParam));
}
public int Add(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
int ID = 0;
ID = oDDM_KhoaHoc.Add(pDM_KhoaHocInfo);
mErrorMessage = oDDM_KhoaHoc.ErrorMessages;
mErrorNumber = oDDM_KhoaHoc.ErrorNumber;
return(ID);
}
public void ToDataRow(DM_KhoaHocInfo pDM_KhoaHocInfo, ref DataRow dr)
{
dr[pDM_KhoaHocInfo.strDM_KhoaHocID] = pDM_KhoaHocInfo.DM_KhoaHocID;
dr[pDM_KhoaHocInfo.strTenKhoaHoc] = pDM_KhoaHocInfo.TenKhoaHoc;
dr[pDM_KhoaHocInfo.strIDDM_TrinhDo] = pDM_KhoaHocInfo.IDDM_TrinhDo;
dr[pDM_KhoaHocInfo.strIDDM_Nganh] = pDM_KhoaHocInfo.IDDM_Nganh;
dr[pDM_KhoaHocInfo.strIDDM_ChuyenNganh] = pDM_KhoaHocInfo.IDDM_ChuyenNganh;
dr[pDM_KhoaHocInfo.strNamVaoTruong] = pDM_KhoaHocInfo.NamVaoTruong;
dr[pDM_KhoaHocInfo.strNamRaTruong] = pDM_KhoaHocInfo.NamRaTruong;
}
public void Update(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenKhoaHoc", SqlDbType.NVarChar, pDM_KhoaHocInfo.TenKhoaHoc));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pDM_KhoaHocInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@IDDM_Nganh", SqlDbType.Int, pDM_KhoaHocInfo.IDDM_Nganh));
colParam.Add(CreateParam("@IDDM_ChuyenNganh", SqlDbType.Int, pDM_KhoaHocInfo.IDDM_ChuyenNganh));
colParam.Add(CreateParam("@NamVaoTruong", SqlDbType.Int, pDM_KhoaHocInfo.NamVaoTruong));
colParam.Add(CreateParam("@NamRaTruong", SqlDbType.Int, pDM_KhoaHocInfo.NamRaTruong));
colParam.Add(CreateParam("@DM_KhoaHocID", SqlDbType.Int, pDM_KhoaHocInfo.DM_KhoaHocID));
RunProcedure("sp_DM_KhoaHoc_Update", colParam);
}
public int Add(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenKhoaHoc", SqlDbType.NVarChar, pDM_KhoaHocInfo.TenKhoaHoc));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pDM_KhoaHocInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@IDDM_Nganh", SqlDbType.Int, pDM_KhoaHocInfo.IDDM_Nganh));
colParam.Add(CreateParam("@IDDM_ChuyenNganh", SqlDbType.Int, pDM_KhoaHocInfo.IDDM_ChuyenNganh));
colParam.Add(CreateParam("@NamVaoTruong", SqlDbType.Int, pDM_KhoaHocInfo.NamVaoTruong));
colParam.Add(CreateParam("@NamRaTruong", SqlDbType.Int, pDM_KhoaHocInfo.NamRaTruong));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_KhoaHoc_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_KhoaHocInfo> GetList(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
List <DM_KhoaHocInfo> oDM_KhoaHocInfoList = new List <DM_KhoaHocInfo>();
DataTable dtb = Get(pDM_KhoaHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_KhoaHocInfo = new DM_KhoaHocInfo();
oDM_KhoaHocInfo.DM_KhoaHocID = int.Parse(dtb.Rows[i]["DM_KhoaHocID"].ToString());
oDM_KhoaHocInfo.TenKhoaHoc = dtb.Rows[i]["TenKhoaHoc"].ToString();
oDM_KhoaHocInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i]["IDDM_TrinhDo"].ToString());
oDM_KhoaHocInfo.IDDM_Nganh = int.Parse(dtb.Rows[i]["IDDM_Nganh"].ToString());
oDM_KhoaHocInfo.IDDM_ChuyenNganh = int.Parse(dtb.Rows[i]["IDDM_ChuyenNganh"].ToString());
oDM_KhoaHocInfo.NamVaoTruong = int.Parse(dtb.Rows[i]["NamVaoTruong"].ToString());
oDM_KhoaHocInfo.NamRaTruong = int.Parse(dtb.Rows[i]["NamRaTruong"].ToString());
oDM_KhoaHocInfoList.Add(oDM_KhoaHocInfo);
}
}
return(oDM_KhoaHocInfoList);
}
public void Delete(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
oDDM_KhoaHoc.Delete(pDM_KhoaHocInfo);
mErrorMessage = oDDM_KhoaHoc.ErrorMessages;
mErrorNumber = oDDM_KhoaHoc.ErrorNumber;
}
public DataTable Get(DM_KhoaHocInfo pDM_KhoaHocInfo)
{
return(oDDM_KhoaHoc.Get(pDM_KhoaHocInfo));
}