public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
Reprot_BaoCaoHocPhi rpt = new Reprot_BaoCaoHocPhi();
rpt.Site = this.Site;
return(rpt);
}
private void Frm_BaoCaoHocPhi_Load(object sender, EventArgs e)
{
Reprot_BaoCaoHocPhi rpt = new Reprot_BaoCaoHocPhi();
SqlConnection conn = DBUtils.getConnection();
conn.Open();
SqlDataAdapter dataAdapter;
DataSetTienHocPhi ds = new DataSetTienHocPhi();
dataAdapter = new SqlDataAdapter("Select hp.mathu, hp.mahs, hs.hoten, hs.ngaysinh, hs.nienkhoa, hs.lop, hp.maloaihocphi, hp.mamiengiam, CASE WHEN hp.dathu IS NOT NULL THEN 'Đã thu' ELSE '' END AS dathu from THUHOCPHI hp JOIN HOCSINH hs ON hs.mahs = hp.mahs", conn);
dataAdapter.Fill(ds.DataTableHocPhi);
DataTable dataTable = ds.DataTableHocPhi;
foreach (DataRow row in dataTable.Rows)
{
{
string rowMaLoaiHocPhi = row["maloaihocphi"].ToString();
string rowMaMienGiam = row["mamiengiam"].ToString();
double totalTutionFee = CalTotalTutionFee(rowMaLoaiHocPhi);
double totalTutionOff = 0;
if (!string.IsNullOrEmpty(rowMaMienGiam))
{
totalTutionOff = CalTotalTutionFeeOff(rowMaMienGiam);
}
double haveToPayTution = totalTutionFee - (totalTutionFee * totalTutionOff);
row["tienhocphi"] = totalTutionFee.ToString("N0", CultureInfo.InvariantCulture);
if (totalTutionOff != 0)
{
row["tienmiengiam"] = (totalTutionFee * totalTutionOff).ToString("N0", CultureInfo.InvariantCulture);
}
else
{
row["tienmiengiam"] = "";
}
row["tongtien"] = haveToPayTution.ToString("N0", CultureInfo.InvariantCulture);
}
}
rpt.SetDataSource(dataTable);
crv_hocphi.ReportSource = rpt;
}
