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