public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportTONGHOPNONCC rpt = new CrystalReportTONGHOPNONCC();
rpt.Site = this.Site;
return(rpt);
}
private void buttonVIEW_Click(object sender, EventArgs e)
{
string note = "";
long da_tra = 0;
var _from = dateTimePickerFROM.Value;
var _to = dateTimePickerTO.Value;
BindingSource bs = new BindingSource();
List <CTongHopNoNCC> dt = new List <CTongHopNoNCC>();
var _nh = (from nh in DataInstance.Instance().DBContext().NHAP_HANG
join ncc in DataInstance.Instance().DBContext().NHA_CUNG_CAP on nh.MANCC equals ncc.ID
join hh in DataInstance.Instance().DBContext().HANG_HOA on nh.MAHH equals hh.ID
/* Khac ton kho */
where nh.NGAY_NHAP >= _from && nh.NGAY_NHAP <= _to
select new CTongHopNoNCC
{
NCC = ncc.NAME,
HANGHOA = hh.NAME,
SOLUONG = nh.SO_LUONG,
THANHTIEN = nh.SO_LUONG * nh.DON_GIA_MUA,
});
foreach (CTongHopNoNCC row in _nh)
{
dt.Add(new CTongHopNoNCC
{
NCC = row.NCC,
HANGHOA = row.HANGHOA,
SOLUONG = row.SOLUONG,
THANHTIEN = row.THANHTIEN,
});
}
var _tn = (from nh in DataInstance.Instance().DBContext().TRA_NO_NCC
join ncc in DataInstance.Instance().DBContext().NHA_CUNG_CAP on nh.MANCC equals ncc.ID
where nh.NGAY_TRA >= _from && nh.NGAY_TRA <= _to
select new CTongHopNoNCC
{
NCC = ncc.NAME,
HANGHOA = "z Trả Nợ z",
SOLUONG = 0,
THANHTIEN = -nh.TONG_TIEN,
});
foreach (CTongHopNoNCC row in _tn)
{
dt.Add(new CTongHopNoNCC
{
NCC = row.NCC,
HANGHOA = row.HANGHOA,
SOLUONG = row.SOLUONG,
THANHTIEN = row.THANHTIEN,
});
}
bs.DataSource = dt;
CrystalReportTONGHOPNONCC rpt = new CrystalReportTONGHOPNONCC();
rpt.SetDataSource(bs);
rpt.SetParameterValue("FROM", _from);
rpt.SetParameterValue("TO", _to);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
crystalReportViewer1.ReportSource = rpt;
}