public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportCHITUNGKHO rpt = new CrystalReportCHITUNGKHO();
rpt.Site = this.Site;
return(rpt);
}
private void buttonVIEW_Click(object sender, EventArgs e)
{
long _kho = long.Parse(comboBoxKHO.SelectedValue.ToString());
DateTime _from = dateTimePickerFROM.Value.Date;
DateTime _to = dateTimePickerTO.Value.Date;
BindingSource bs = new BindingSource();
List <CChiTungKho> list = new List <CChiTungKho>();
var luong = (from _luong in DataInstance.Instance().DBContext().CHI_LUONG
join _nv in DataInstance.Instance().DBContext().NHAN_VIEN on _luong.MANV equals _nv.ID
where _luong.MAKHO == _kho
where _luong.NGAY_CHI >= _from && _luong.NGAY_CHI <= _to
select new CChiTungKho
{
NGAYCHI = _luong.NGAY_CHI,
NOIDUNG = "Chi luong: " + _nv.NAME,
TONGTIEN = _luong.TONG_TIEN,
});
var noibo = (from _chi in DataInstance.Instance().DBContext().CHI_TIEU_DUNG_NOI_BO
join _xe in DataInstance.Instance().DBContext().XEs on _chi.MAXE equals _xe.ID
where _chi.MAHH == -1
where _chi.MAKHO == _kho
where _chi.NGAY_CHI >= _from && _chi.NGAY_CHI <= _to
select new CChiTungKho
{
NGAYCHI = _chi.NGAY_CHI,
NOIDUNG = "Xe: " + _xe.BIEN_SO + " - " + _chi.NOI_DUNG,
TONGTIEN = _chi.TONG_TIEN,
});
var khac = (from _luong in DataInstance.Instance().DBContext().CHI_KHAC
where _luong.MAKHO == _kho
where _luong.NGAY_CHI >= _from && _luong.NGAY_CHI <= _to
select new CChiTungKho
{
NGAYCHI = _luong.NGAY_CHI,
NOIDUNG = _luong.NOI_DUNG,
TONGTIEN = _luong.TONG_TIEN,
});
var chovay = (from _luong in DataInstance.Instance().DBContext().XUAT_HANG
join _kh in DataInstance.Instance().DBContext().KHACH_HANG on _luong.MAKH equals _kh.ID
where _luong.MAKHO == _kho
where _luong.MAHH == -1
where _luong.NGAY_XUAT >= _from && _luong.NGAY_XUAT <= _to
select new CChiTungKho
{
NGAYCHI = _luong.NGAY_XUAT.Value,
NOIDUNG = "Cho vay: " + _kh.NAME,
TONGTIEN = _luong.THANH_TIEN,
});
var trancc = (from _luong in DataInstance.Instance().DBContext().TRA_NO_NCC
join ncc in DataInstance.Instance().DBContext().NHA_CUNG_CAP on _luong.MANCC equals ncc.ID
where _luong.MAKHO == _kho
where _luong.NGAY_TRA >= _from && _luong.NGAY_TRA <= _to
select new CChiTungKho
{
NGAYCHI = _luong.NGAY_TRA,
NOIDUNG = "Trả nợ: " + ncc.NAME,
TONGTIEN = _luong.TONG_TIEN,
});
var travay = (from _luong in DataInstance.Instance().DBContext().TRA_NO_VAY
join no in DataInstance.Instance().DBContext().NGUON_VAY on _luong.MA_NGUON_VAY equals no.ID
where _luong.MAKHO == _kho
where _luong.NGAY_TRA >= _from && _luong.NGAY_TRA <= _to
select new CChiTungKho
{
NGAYCHI = _luong.NGAY_TRA,
NOIDUNG = "Trả nợ: " + no.NAME,
TONGTIEN = _luong.TIEN_GOC + _luong.TIEN_LAI,
});
foreach (CChiTungKho h in trancc)
{
list.Add(h);
}
/*CHI LUONG*/
foreach (CChiTungKho h in luong)
{
list.Add(h);
}
foreach (CChiTungKho h in noibo)
{
list.Add(h);
}
foreach (CChiTungKho h in khac)
{
list.Add(h);
}
foreach (CChiTungKho h in chovay)
{
list.Add(h);
}
list = list.OrderBy(u => u.NGAYCHI).ToList();
bs.DataSource = list;
CrystalReportCHITUNGKHO rpt = new CrystalReportCHITUNGKHO();
rpt.SetDataSource(bs);
rpt.SetParameterValue("KHO", comboBoxKHO.Text);
rpt.SetParameterValue("FROM", dateTimePickerFROM.Value);
rpt.SetParameterValue("TO", dateTimePickerTO.Value);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Zoom(150);
}