public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportCHITIETNOVAY rpt = new CrystalReportCHITIETNOVAY();
rpt.Site = this.Site;
return(rpt);
}
private void buttonVIEW_Click(object sender, EventArgs e)
{
var _ncc = long.Parse(comboBoxNCC.SelectedValue.ToString());
var _from = dateTimePicker1.Value.Date;
var _to = dateTimePicker2.Value.Date;
BindingSource bs = new BindingSource();
var rows = (from v in DataInstance.Instance().DBContext().VAYs
join nv in DataInstance.Instance().DBContext().NGUON_VAY on v.MA_NGUON_VAY equals nv.ID
where v.MA_NGUON_VAY == _ncc
where v.NGAY_VAY >= _from && v.NGAY_VAY <= _to
orderby v.NGAY_VAY ascending
select v);
List <CChiTietNoVay> l = new List <CChiTietNoVay>();
foreach (VAY _r in rows)
{
l.Add(new CChiTietNoVay
{
NGAYVAY = _r.NGAY_VAY.Date,
TONGTIEN = _r.TONG_TIEN,
LAISUAT = _r.LAI_SUAT * 100,
THOIDOAN = "Vay",
TRAGOC = 0,
TRALAI = 0
});
}
foreach (TRA_NO_VAY _r in DataInstance.Instance().DBContext().TRA_NO_VAY
.Where(u => u.MA_NGUON_VAY == _ncc && u.NGAY_TRA >= _from && u.NGAY_TRA <= _to))
{
l.Add(new CChiTietNoVay
{
NGAYVAY = _r.NGAY_TRA.Date,
TONGTIEN = 0,
LAISUAT = 0,
THOIDOAN = "Trả nợ vay",
TRAGOC = _r.TIEN_GOC,
TRALAI = _r.TIEN_LAI
});
}
bs.DataSource = l;
CrystalReportCHITIETNOVAY rpt = new CrystalReportCHITIETNOVAY();
rpt.SetDataSource(bs);
rpt.SetParameterValue("NV", comboBoxNCC.Text);
rpt.SetParameterValue("FROM", _from);
rpt.SetParameterValue("TO", _to);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
crystalReportViewer1.ReportSource = rpt;
}
