public DataTable Get(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { ArrayList colParam = new ArrayList(); return(RunProcedureGet("sp_TC_DanhSachHocBong_Get", colParam)); }
public void Delete(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TC_DanhSachHocBongID", SqlDbType.Int, pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID)); RunProcedure("sp_TC_DanhSachHocBong_Delete", colParam); }
public int Add(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { int ID = 0; ID = oDTC_DanhSachHocBong.Add(pTC_DanhSachHocBongInfo); mErrorMessage = oDTC_DanhSachHocBong.ErrorMessages; mErrorNumber = oDTC_DanhSachHocBong.ErrorNumber; return(ID); }
public frmDanhSachHocBong_ChamCong() { InitializeComponent(); pTC_DanhSachHocBongInfo = new TC_DanhSachHocBongInfo(); oBTC_DanhSachHocBong = new cBTC_DanhSachHocBong(); oBTC_DanhSachHocBong_ChiTiet = new cBTC_DanhSachHocBong_ChiTiet(); pDM_LopInfo = new DM_LopInfo(); }
public void ToInfo(ref TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo, DataRow dr) { pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID = int.Parse(dr[pTC_DanhSachHocBongInfo.strTC_DanhSachHocBongID].ToString()); pTC_DanhSachHocBongInfo.IDSV_SinhVien = int.Parse(dr[pTC_DanhSachHocBongInfo.strIDSV_SinhVien].ToString()); pTC_DanhSachHocBongInfo.IDDM_NamHoc = int.Parse(dr[pTC_DanhSachHocBongInfo.strIDDM_NamHoc].ToString()); pTC_DanhSachHocBongInfo.HocKy = int.Parse(dr[pTC_DanhSachHocBongInfo.strHocKy].ToString()); pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong = int.Parse(dr[pTC_DanhSachHocBongInfo.strIDTC_PhanBoQuyHocBong].ToString()); pTC_DanhSachHocBongInfo.SoTienThang = double.Parse(dr[pTC_DanhSachHocBongInfo.strSoTienThang].ToString()); pTC_DanhSachHocBongInfo.SoTienKy = double.Parse(dr[pTC_DanhSachHocBongInfo.strSoTienKy].ToString()); }
public void ToDataRow(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo, ref DataRow dr) { dr[pTC_DanhSachHocBongInfo.strTC_DanhSachHocBongID] = pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID; dr[pTC_DanhSachHocBongInfo.strIDSV_SinhVien] = pTC_DanhSachHocBongInfo.IDSV_SinhVien; dr[pTC_DanhSachHocBongInfo.strIDDM_NamHoc] = pTC_DanhSachHocBongInfo.IDDM_NamHoc; dr[pTC_DanhSachHocBongInfo.strHocKy] = pTC_DanhSachHocBongInfo.HocKy; dr[pTC_DanhSachHocBongInfo.strIDTC_PhanBoQuyHocBong] = pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong; dr[pTC_DanhSachHocBongInfo.strSoTienThang] = pTC_DanhSachHocBongInfo.SoTienThang; dr[pTC_DanhSachHocBongInfo.strSoTienKy] = pTC_DanhSachHocBongInfo.SoTienKy; }
public frmDanhSachHocBong() { InitializeComponent(); pTC_DanhSachHocBongInfo = new TC_DanhSachHocBongInfo(); oBTC_DanhSachHocBong = new cBTC_DanhSachHocBong(); oBTC_DanhSachHocBong_ChiTiet = new cBTC_DanhSachHocBong_ChiTiet(); pTC_DanhSachHocBong_ChiTietInfo = new TC_DanhSachHocBong_ChiTietInfo(); pDM_LopInfo = new DM_LopInfo(); //pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo(); //oBTC_BienLaiThuTien_ChiTiet = new cBTC_BienLaiThuTien_ChiTiet(); //pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo(); //oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien(); }
public void Update(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@TC_DanhSachHocBongID", SqlDbType.Int, pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID)); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachHocBongInfo.HocKy)); colParam.Add(CreateParam("@IDTC_PhanBoQuyHocBong", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong)); colParam.Add(CreateParam("@SoTienThang", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienThang)); colParam.Add(CreateParam("@SoTienKy", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienKy)); RunProcedure("sp_TC_DanhSachHocBong_Update", colParam); }
public int Add(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { ArrayList colParam = new ArrayList(); colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDSV_SinhVien)); colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDDM_NamHoc)); colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachHocBongInfo.HocKy)); colParam.Add(CreateParam("@IDTC_PhanBoQuyHocBong", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong)); colParam.Add(CreateParam("@SoTienThang", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienThang)); colParam.Add(CreateParam("@SoTienKy", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienKy)); colParam.Add(CreateParamOut("@ID", SqlDbType.Int)); return((int)RunProcedureOut("sp_TC_DanhSachHocBong_Add", colParam)); }
public List <TC_DanhSachHocBongInfo> GetList(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { List <TC_DanhSachHocBongInfo> oTC_DanhSachHocBongInfoList = new List <TC_DanhSachHocBongInfo>(); DataTable dtb = Get(pTC_DanhSachHocBongInfo); if (dtb != null) { for (int i = 0; i < dtb.Rows.Count; i++) { oTC_DanhSachHocBongInfo = new TC_DanhSachHocBongInfo(); oTC_DanhSachHocBongInfo.TC_DanhSachHocBongID = int.Parse(dtb.Rows[i]["TC_DanhSachHocBongID"].ToString()); oTC_DanhSachHocBongInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString()); oTC_DanhSachHocBongInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString()); oTC_DanhSachHocBongInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString()); oTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong = int.Parse(dtb.Rows[i]["IDTC_PhanBoQuyHocBong"].ToString()); oTC_DanhSachHocBongInfo.SoTienThang = double.Parse(dtb.Rows[i]["SoTienThang"].ToString()); oTC_DanhSachHocBongInfo.SoTienKy = double.Parse(dtb.Rows[i]["SoTienKy"].ToString()); oTC_DanhSachHocBongInfoList.Add(oTC_DanhSachHocBongInfo); } } return(oTC_DanhSachHocBongInfoList); }
public void Delete(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { oDTC_DanhSachHocBong.Delete(pTC_DanhSachHocBongInfo); mErrorMessage = oDTC_DanhSachHocBong.ErrorMessages; mErrorNumber = oDTC_DanhSachHocBong.ErrorNumber; }
public DataTable Get(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo) { return(oDTC_DanhSachHocBong.Get(pTC_DanhSachHocBongInfo)); }