public List <TC_LoaiThuChiInfo> GetList(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
{
List <TC_LoaiThuChiInfo> oTC_LoaiThuChiInfoList = new List <TC_LoaiThuChiInfo>();
DataTable dtb = Get(pTC_LoaiThuChiInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_LoaiThuChiInfo = new TC_LoaiThuChiInfo();
oTC_LoaiThuChiInfo.TC_LoaiThuChiID = int.Parse(dtb.Rows[i]["TC_LoaiThuChiID"].ToString());
oTC_LoaiThuChiInfo.TenLoaiThuChi = dtb.Rows[i]["TenLoaiThuChi"].ToString();
oTC_LoaiThuChiInfo.SoTien = double.Parse(dtb.Rows[i]["SoTien"].ToString());
oTC_LoaiThuChiInfo.KhoanThu = bool.Parse(dtb.Rows[i]["KhoanThu"].ToString());
oTC_LoaiThuChiInfo.BatBuoc = bool.Parse(dtb.Rows[i]["BatBuoc"].ToString());
oTC_LoaiThuChiInfo.TheoNienKhoa = bool.Parse(dtb.Rows[i]["TheoNienKhoa"].ToString());
oTC_LoaiThuChiInfo.HocPhi = bool.Parse(dtb.Rows[i]["HocPhi"].ToString());
oTC_LoaiThuChiInfo.NhapHoc = bool.Parse(dtb.Rows[i]["NhapHoc"].ToString());
oTC_LoaiThuChiInfo.ParentID = int.Parse(dtb.Rows[i]["ParentID"].ToString());
oTC_LoaiThuChiInfo.IDNamHoc = int.Parse(dtb.Rows[i]["IDNamHoc"].ToString());
oTC_LoaiThuChiInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oTC_LoaiThuChiInfoList.Add(oTC_LoaiThuChiInfo);
}
}
return(oTC_LoaiThuChiInfoList);
}
public void Delete(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_LoaiThuChiID", SqlDbType.Int, pTC_LoaiThuChiInfo.TC_LoaiThuChiID));
RunProcedure("sp_TC_LoaiThuChi_Delete", colParam);
}
public DataTable Get(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_LoaiThuChiID", SqlDbType.Int, pTC_LoaiThuChiInfo.TC_LoaiThuChiID));
return(RunProcedureGet("sp_TC_LoaiThuChi_Get", colParam));
}
public int Add(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
{
int ID = 0;
ID = oDTC_LoaiThuChi.Add(pTC_LoaiThuChiInfo);
mErrorMessage = oDTC_LoaiThuChi.ErrorMessages;
mErrorNumber = oDTC_LoaiThuChi.ErrorNumber;
return(ID);
}
public frmDinhMucThu()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pTC_DinhMucThuSinhVienInfo = new TC_DinhMucThuSinhVienInfo();
oBTC_DinhMucThuSinhVien = new cBTC_DinhMucThuSinhVien();
pTC_LoaiThuChiInfo = new TC_LoaiThuChiInfo();
oBTC_LoaiThuChi = new cBTC_LoaiThuChi();
oBTC_DinhMucThuSinhVien_ChiTiet = new cBTC_DinhMucThuSinhVien_ChiTiet();
pTC_DinhMucThuSinhVien_ChiTietInfo = new TC_DinhMucThuSinhVien_ChiTietInfo();
}
public frmDanhSachMienGiam()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_DoiTuongMienGiamInfo = new DM_DoiTuongMienGiamInfo();
oBDM_DoiTuongMienGiam = new cBDM_DoiTuongMienGiam();
pTC_DanhSachMienGiamInfo = new TC_DanhSachMienGiamInfo();
oBTC_DanhSachMienGiam = new cBTC_DanhSachMienGiam();
pTC_LoaiThuChiInfo = new TC_LoaiThuChiInfo();
oBTC_LoaiThuChi = new cBTC_LoaiThuChi();
oBTC_DanhSachMienGiam_ChiTiet = new cBTC_DanhSachMienGiam_ChiTiet();
pTC_DanhSachMienGiam_ChiTietInfo = new TC_DanhSachMienGiam_ChiTietInfo();
}
public void ToDataRow(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo, ref DataRow dr)
{
dr[pTC_LoaiThuChiInfo.strTC_LoaiThuChiID] = pTC_LoaiThuChiInfo.TC_LoaiThuChiID;
dr[pTC_LoaiThuChiInfo.strTenLoaiThuChi] = pTC_LoaiThuChiInfo.TenLoaiThuChi;
dr[pTC_LoaiThuChiInfo.strSoTien] = pTC_LoaiThuChiInfo.SoTien;
dr[pTC_LoaiThuChiInfo.strKhoanThu] = pTC_LoaiThuChiInfo.KhoanThu;
dr[pTC_LoaiThuChiInfo.strBatBuoc] = pTC_LoaiThuChiInfo.BatBuoc;
dr[pTC_LoaiThuChiInfo.strTheoNienKhoa] = pTC_LoaiThuChiInfo.TheoNienKhoa;
dr[pTC_LoaiThuChiInfo.strHocPhi] = pTC_LoaiThuChiInfo.HocPhi;
dr[pTC_LoaiThuChiInfo.strNhapHoc] = pTC_LoaiThuChiInfo.NhapHoc;
dr[pTC_LoaiThuChiInfo.strParentID] = pTC_LoaiThuChiInfo.ParentID;
dr[pTC_LoaiThuChiInfo.strIDNamHoc] = pTC_LoaiThuChiInfo.IDNamHoc;
dr[pTC_LoaiThuChiInfo.strHocKy] = pTC_LoaiThuChiInfo.HocKy;
}
public void ToInfo(ref TC_LoaiThuChiInfo pTC_LoaiThuChiInfo, DataRow dr)
{
pTC_LoaiThuChiInfo.TC_LoaiThuChiID = int.Parse(dr[pTC_LoaiThuChiInfo.strTC_LoaiThuChiID].ToString());
pTC_LoaiThuChiInfo.TenLoaiThuChi = dr[pTC_LoaiThuChiInfo.strTenLoaiThuChi].ToString();
pTC_LoaiThuChiInfo.SoTien = double.Parse(dr[pTC_LoaiThuChiInfo.strSoTien].ToString());
pTC_LoaiThuChiInfo.KhoanThu = bool.Parse(dr[pTC_LoaiThuChiInfo.strKhoanThu].ToString());
pTC_LoaiThuChiInfo.BatBuoc = bool.Parse(dr[pTC_LoaiThuChiInfo.strBatBuoc].ToString());
pTC_LoaiThuChiInfo.TheoNienKhoa = bool.Parse(dr[pTC_LoaiThuChiInfo.strTheoNienKhoa].ToString());
pTC_LoaiThuChiInfo.HocPhi = bool.Parse(dr[pTC_LoaiThuChiInfo.strHocPhi].ToString());
pTC_LoaiThuChiInfo.NhapHoc = bool.Parse(dr[pTC_LoaiThuChiInfo.strNhapHoc].ToString());
pTC_LoaiThuChiInfo.ParentID = int.Parse(dr[pTC_LoaiThuChiInfo.strParentID].ToString());
pTC_LoaiThuChiInfo.IDNamHoc = int.Parse(dr[pTC_LoaiThuChiInfo.strIDNamHoc].ToString());
pTC_LoaiThuChiInfo.HocKy = int.Parse(dr[pTC_LoaiThuChiInfo.strHocKy].ToString());
}
public void Update(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenLoaiThuChi", SqlDbType.NVarChar, pTC_LoaiThuChiInfo.TenLoaiThuChi));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_LoaiThuChiInfo.SoTien));
colParam.Add(CreateParam("@KhoanThu", SqlDbType.Bit, pTC_LoaiThuChiInfo.KhoanThu));
colParam.Add(CreateParam("@BatBuoc", SqlDbType.Bit, pTC_LoaiThuChiInfo.BatBuoc));
colParam.Add(CreateParam("@TheoNienKhoa", SqlDbType.Bit, pTC_LoaiThuChiInfo.TheoNienKhoa));
colParam.Add(CreateParam("@HocPhi", SqlDbType.Bit, pTC_LoaiThuChiInfo.HocPhi));
colParam.Add(CreateParam("@NhapHoc", SqlDbType.Bit, pTC_LoaiThuChiInfo.NhapHoc));
colParam.Add(CreateParam("@ParentID", SqlDbType.Int, pTC_LoaiThuChiInfo.ParentID));
colParam.Add(CreateParam("@IDNamHoc", SqlDbType.Int, pTC_LoaiThuChiInfo.IDNamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_LoaiThuChiInfo.HocKy));
colParam.Add(CreateParam("@TC_LoaiThuChiID", SqlDbType.Int, pTC_LoaiThuChiInfo.TC_LoaiThuChiID));
RunProcedure("sp_TC_LoaiThuChi_Update", colParam);
}
public frmDM_LoaiThuChi()
{
InitializeComponent();
pTC_LoaiThuChiInfo = new TC_LoaiThuChiInfo();
oBTC_LoaiThuChi = new cBTC_LoaiThuChi();
}
public void Delete(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
{
oDTC_LoaiThuChi.Delete(pTC_LoaiThuChiInfo);
mErrorMessage = oDTC_LoaiThuChi.ErrorMessages;
mErrorNumber = oDTC_LoaiThuChi.ErrorNumber;
}
public DataTable Get(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
{
return(oDTC_LoaiThuChi.Get(pTC_LoaiThuChiInfo));
}
public cBTC_LoaiThuChi()
{
oDTC_LoaiThuChi = new cDTC_LoaiThuChi();
oTC_LoaiThuChiInfo = new TC_LoaiThuChiInfo();
}
