public List <TC_QuyHocBongInfo> GetList(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
List <TC_QuyHocBongInfo> oTC_QuyHocBongInfoList = new List <TC_QuyHocBongInfo>();
DataTable dtb = Get(pTC_QuyHocBongInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_QuyHocBongInfo = new TC_QuyHocBongInfo();
oTC_QuyHocBongInfo.TC_QuyHocBongID = int.Parse(dtb.Rows[i]["TC_QuyHocBongID"].ToString());
oTC_QuyHocBongInfo.IDDM_He = int.Parse(dtb.Rows[i]["IDDM_He"].ToString());
oTC_QuyHocBongInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i]["IDDM_TrinhDo"].ToString());
oTC_QuyHocBongInfo.IDDM_LoaiQuy = int.Parse(dtb.Rows[i]["IDDM_LoaiQuy"].ToString());
oTC_QuyHocBongInfo.PhanTramHocPhi = double.Parse(dtb.Rows[i]["PhanTramHocPhi"].ToString());
oTC_QuyHocBongInfo.SoTien = double.Parse(dtb.Rows[i]["SoTien"].ToString());
oTC_QuyHocBongInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString();
oTC_QuyHocBongInfo.HetHan = bool.Parse(dtb.Rows[i]["HetHan"].ToString());
oTC_QuyHocBongInfoList.Add(oTC_QuyHocBongInfo);
}
}
return(oTC_QuyHocBongInfoList);
}
public frmXetHocBong()
{
InitializeComponent();
pTC_QuyHocBongInfo = new TC_QuyHocBongInfo();
oBTC_QuyHocBong = new cBTC_QuyHocBong();
pTC_PhanBoQuyHocBongInfo = new TC_PhanBoQuyHocBongInfo();
oBTC_PhanBoQuyHocBong = new cBTC_PhanBoQuyHocBong();
}
public void Delete(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_QuyHocBongID", SqlDbType.Int, pTC_QuyHocBongInfo.TC_QuyHocBongID));
RunProcedure("sp_TC_QuyHocBong_Delete", colParam);
}
public DataTable Get(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_QuyHocBongID", SqlDbType.Int, pTC_QuyHocBongInfo.TC_QuyHocBongID));
return(RunProcedureGet("sp_TC_QuyHocBong_Get", colParam));
}
public int Add(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
int ID = 0;
ID = oDTC_QuyHocBong.Add(pTC_QuyHocBongInfo);
mErrorMessage = oDTC_QuyHocBong.ErrorMessages;
mErrorNumber = oDTC_QuyHocBong.ErrorNumber;
return(ID);
}
public frmQuyHocBong()
{
InitializeComponent();
pDM_LoaiQuyInfo = new DM_LoaiQuyInfo();
oBDM_LoaiQuy = new cBDM_LoaiQuy();
pTC_QuyHocBongInfo = new TC_QuyHocBongInfo();
oBTC_QuyHocBong = new cBTC_QuyHocBong();
pTC_PhanBoQuyHocBongInfo = new TC_PhanBoQuyHocBongInfo();
oBTC_PhanBoQuyHocBong = new cBTC_PhanBoQuyHocBong();
}
public void ToInfo(ref TC_QuyHocBongInfo pTC_QuyHocBongInfo, DataRow dr)
{
pTC_QuyHocBongInfo.TC_QuyHocBongID = int.Parse(dr[pTC_QuyHocBongInfo.strTC_QuyHocBongID].ToString());
pTC_QuyHocBongInfo.IDDM_He = int.Parse(dr[pTC_QuyHocBongInfo.strIDDM_He].ToString());
pTC_QuyHocBongInfo.IDDM_TrinhDo = int.Parse(dr[pTC_QuyHocBongInfo.strIDDM_TrinhDo].ToString());
pTC_QuyHocBongInfo.IDDM_LoaiQuy = int.Parse(dr[pTC_QuyHocBongInfo.strIDDM_LoaiQuy].ToString());
pTC_QuyHocBongInfo.PhanTramHocPhi = double.Parse(dr[pTC_QuyHocBongInfo.strPhanTramHocPhi].ToString());
pTC_QuyHocBongInfo.SoTien = double.Parse(dr[pTC_QuyHocBongInfo.strSoTien].ToString());
pTC_QuyHocBongInfo.GhiChu = dr[pTC_QuyHocBongInfo.strGhiChu].ToString();
pTC_QuyHocBongInfo.HetHan = bool.Parse(dr[pTC_QuyHocBongInfo.strHetHan].ToString());
}
public void ToDataRow(TC_QuyHocBongInfo pTC_QuyHocBongInfo, ref DataRow dr)
{
dr[pTC_QuyHocBongInfo.strTC_QuyHocBongID] = pTC_QuyHocBongInfo.TC_QuyHocBongID;
dr[pTC_QuyHocBongInfo.strIDDM_He] = pTC_QuyHocBongInfo.IDDM_He;
dr[pTC_QuyHocBongInfo.strIDDM_TrinhDo] = pTC_QuyHocBongInfo.IDDM_TrinhDo;
dr[pTC_QuyHocBongInfo.strIDDM_LoaiQuy] = pTC_QuyHocBongInfo.IDDM_LoaiQuy;
dr[pTC_QuyHocBongInfo.strPhanTramHocPhi] = pTC_QuyHocBongInfo.PhanTramHocPhi;
dr[pTC_QuyHocBongInfo.strSoTien] = pTC_QuyHocBongInfo.SoTien;
dr[pTC_QuyHocBongInfo.strGhiChu] = pTC_QuyHocBongInfo.GhiChu;
dr[pTC_QuyHocBongInfo.strHetHan] = pTC_QuyHocBongInfo.HetHan;
}
public void Update(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_He", SqlDbType.Int, pTC_QuyHocBongInfo.IDDM_He));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pTC_QuyHocBongInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@IDDM_LoaiQuy", SqlDbType.Int, pTC_QuyHocBongInfo.IDDM_LoaiQuy));
colParam.Add(CreateParam("@PhanTramHocPhi", SqlDbType.Float, pTC_QuyHocBongInfo.PhanTramHocPhi));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_QuyHocBongInfo.SoTien));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_QuyHocBongInfo.GhiChu));
colParam.Add(CreateParam("@HetHan", SqlDbType.Bit, pTC_QuyHocBongInfo.HetHan));
colParam.Add(CreateParam("@TC_QuyHocBongID", SqlDbType.Int, pTC_QuyHocBongInfo.TC_QuyHocBongID));
RunProcedure("sp_TC_QuyHocBong_Update", colParam);
}
public int Add(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_He", SqlDbType.Int, pTC_QuyHocBongInfo.IDDM_He));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pTC_QuyHocBongInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@IDDM_LoaiQuy", SqlDbType.Int, pTC_QuyHocBongInfo.IDDM_LoaiQuy));
colParam.Add(CreateParam("@PhanTramHocPhi", SqlDbType.Float, pTC_QuyHocBongInfo.PhanTramHocPhi));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_QuyHocBongInfo.SoTien));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_QuyHocBongInfo.GhiChu));
colParam.Add(CreateParam("@HetHan", SqlDbType.Bit, pTC_QuyHocBongInfo.HetHan));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_QuyHocBong_Add", colParam));
}
public void Delete(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
oDTC_QuyHocBong.Delete(pTC_QuyHocBongInfo);
mErrorMessage = oDTC_QuyHocBong.ErrorMessages;
mErrorNumber = oDTC_QuyHocBong.ErrorNumber;
}
public DataTable Get(TC_QuyHocBongInfo pTC_QuyHocBongInfo)
{
return(oDTC_QuyHocBong.Get(pTC_QuyHocBongInfo));
}
