public List <TC_DinhMucThuSinhVienInfo> GetList(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
List <TC_DinhMucThuSinhVienInfo> oTC_DinhMucThuSinhVienInfoList = new List <TC_DinhMucThuSinhVienInfo>();
DataTable dtb = Get(pTC_DinhMucThuSinhVienInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_DinhMucThuSinhVienInfo = new TC_DinhMucThuSinhVienInfo();
oTC_DinhMucThuSinhVienInfo.TC_DinhMucThuSinhVienID = int.Parse(dtb.Rows[i]["TC_DinhMucThuSinhVienID"].ToString());
oTC_DinhMucThuSinhVienInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oTC_DinhMucThuSinhVienInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oTC_DinhMucThuSinhVienInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oTC_DinhMucThuSinhVienInfo.IDTC_LoaiThuChi = int.Parse(dtb.Rows[i]["IDTC_LoaiThuChi"].ToString());
oTC_DinhMucThuSinhVienInfo.SoTienPhaiNop = double.Parse(dtb.Rows[i]["SoTienPhaiNop"].ToString());
oTC_DinhMucThuSinhVienInfo.SoTienGiam = double.Parse(dtb.Rows[i]["SoTienGiam"].ToString());
oTC_DinhMucThuSinhVienInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString();
oTC_DinhMucThuSinhVienInfoList.Add(oTC_DinhMucThuSinhVienInfo);
}
}
return(oTC_DinhMucThuSinhVienInfoList);
}
public void Delete(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DinhMucThuSinhVienID", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.TC_DinhMucThuSinhVienID));
RunProcedure("sp_TC_DinhMucThuSinhVien_Delete", colParam);
}
public DataTable Get(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DinhMucThuSinhVienID", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.TC_DinhMucThuSinhVienID));
return(RunProcedureGet("sp_TC_DinhMucThuSinhVien_Get", colParam));
}
public int Add(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
int ID = 0;
ID = oDTC_DinhMucThuSinhVien.Add(pTC_DinhMucThuSinhVienInfo);
mErrorMessage = oDTC_DinhMucThuSinhVien.ErrorMessages;
mErrorNumber = oDTC_DinhMucThuSinhVien.ErrorNumber;
return(ID);
}
public void ToInfo(ref TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo, DataRow dr)
{
pTC_DinhMucThuSinhVienInfo.TC_DinhMucThuSinhVienID = int.Parse(dr[pTC_DinhMucThuSinhVienInfo.strTC_DinhMucThuSinhVienID].ToString());
pTC_DinhMucThuSinhVienInfo.IDSV_SinhVien = int.Parse(dr[pTC_DinhMucThuSinhVienInfo.strIDSV_SinhVien].ToString());
pTC_DinhMucThuSinhVienInfo.IDDM_NamHoc = int.Parse(dr[pTC_DinhMucThuSinhVienInfo.strIDDM_NamHoc].ToString());
pTC_DinhMucThuSinhVienInfo.HocKy = int.Parse(dr[pTC_DinhMucThuSinhVienInfo.strHocKy].ToString());
pTC_DinhMucThuSinhVienInfo.IDTC_LoaiThuChi = int.Parse(dr[pTC_DinhMucThuSinhVienInfo.strIDTC_LoaiThuChi].ToString());
pTC_DinhMucThuSinhVienInfo.SoTienPhaiNop = double.Parse(dr[pTC_DinhMucThuSinhVienInfo.strSoTienPhaiNop].ToString());
pTC_DinhMucThuSinhVienInfo.SoTienGiam = double.Parse(dr[pTC_DinhMucThuSinhVienInfo.strSoTienGiam].ToString());
pTC_DinhMucThuSinhVienInfo.GhiChu = dr[pTC_DinhMucThuSinhVienInfo.strGhiChu].ToString();
}
public void ToDataRow(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo, ref DataRow dr)
{
dr[pTC_DinhMucThuSinhVienInfo.strTC_DinhMucThuSinhVienID] = pTC_DinhMucThuSinhVienInfo.TC_DinhMucThuSinhVienID;
dr[pTC_DinhMucThuSinhVienInfo.strIDSV_SinhVien] = pTC_DinhMucThuSinhVienInfo.IDSV_SinhVien;
dr[pTC_DinhMucThuSinhVienInfo.strIDDM_NamHoc] = pTC_DinhMucThuSinhVienInfo.IDDM_NamHoc;
dr[pTC_DinhMucThuSinhVienInfo.strHocKy] = pTC_DinhMucThuSinhVienInfo.HocKy;
dr[pTC_DinhMucThuSinhVienInfo.strIDTC_LoaiThuChi] = pTC_DinhMucThuSinhVienInfo.IDTC_LoaiThuChi;
dr[pTC_DinhMucThuSinhVienInfo.strSoTienPhaiNop] = pTC_DinhMucThuSinhVienInfo.SoTienPhaiNop;
dr[pTC_DinhMucThuSinhVienInfo.strSoTienGiam] = pTC_DinhMucThuSinhVienInfo.SoTienGiam;
dr[pTC_DinhMucThuSinhVienInfo.strGhiChu] = pTC_DinhMucThuSinhVienInfo.GhiChu;
}
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 void Update(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.HocKy));
colParam.Add(CreateParam("@IDTC_LoaiThuChi", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.IDTC_LoaiThuChi));
colParam.Add(CreateParam("@SoTienPhaiNop", SqlDbType.Money, pTC_DinhMucThuSinhVienInfo.SoTienPhaiNop));
colParam.Add(CreateParam("@SoTienGiam", SqlDbType.Money, pTC_DinhMucThuSinhVienInfo.SoTienGiam));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_DinhMucThuSinhVienInfo.GhiChu));
colParam.Add(CreateParam("@TC_DinhMucThuSinhVienID", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.TC_DinhMucThuSinhVienID));
RunProcedure("sp_TC_DinhMucThuSinhVien_Update", colParam);
}
public int Add(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.HocKy));
colParam.Add(CreateParam("@IDTC_LoaiThuChi", SqlDbType.Int, pTC_DinhMucThuSinhVienInfo.IDTC_LoaiThuChi));
colParam.Add(CreateParam("@SoTienPhaiNop", SqlDbType.Money, pTC_DinhMucThuSinhVienInfo.SoTienPhaiNop));
colParam.Add(CreateParam("@SoTienGiam", SqlDbType.Money, pTC_DinhMucThuSinhVienInfo.SoTienGiam));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_DinhMucThuSinhVienInfo.GhiChu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_DinhMucThuSinhVien_Add", colParam));
}
public void Delete(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
oDTC_DinhMucThuSinhVien.Delete(pTC_DinhMucThuSinhVienInfo);
mErrorMessage = oDTC_DinhMucThuSinhVien.ErrorMessages;
mErrorNumber = oDTC_DinhMucThuSinhVien.ErrorNumber;
}
public DataTable Get(TC_DinhMucThuSinhVienInfo pTC_DinhMucThuSinhVienInfo)
{
return(oDTC_DinhMucThuSinhVien.Get(pTC_DinhMucThuSinhVienInfo));
}
