public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportLAILOTUNGKHO rpt = new CrystalReportLAILOTUNGKHO();
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 <CLaiLoTungKho> list = new List <CLaiLoTungKho>();
var hanghoa = (from _hh in DataInstance.Instance().DBContext().HANG_HOA select _hh);
var khachhang = (from _hh in DataInstance.Instance().DBContext().KHACH_HANG select _hh);
var xuathang = (from _bh in DataInstance.Instance().DBContext().XUAT_HANG
where _bh.MAKHO == _kho
where _bh.NGAY_XUAT >= _from && _bh.NGAY_XUAT <= _to
select _bh);
foreach (XUAT_HANG b in xuathang)
{
List <CXuatHangChiTiet> bchitiet = JsonConvert.DeserializeObject <List <CXuatHangChiTiet> >(b.CHI_TIET_XUAT_HANG);
if (bchitiet != null)
{
foreach (CXuatHangChiTiet row in bchitiet)
{
CLaiLoTungKho c = new CLaiLoTungKho();
c.NGAY = b.NGAY_XUAT.Value;
c.HANGHOA = hanghoa.Where(u => u.ID == b.MAHH).First().NAME;
if (b.MAKH == MXuatHang.MAKH_XUAT_MAT)
{
c.GHICHU = "Bán mặt";
}
else
{
c.GHICHU = "Xuất hàng: " + khachhang.Where(u => u.ID == b.MAKH).First().NAME;
}
c.SOLUONG = row.SOLUONG;
c.DONGIAMUA = row.DONGIA;
c.DONGIABAN = b.DON_GIA_BAN;
c.TONGLAI = row.SOLUONG * (b.DON_GIA_BAN - row.DONGIA);
list.Add(c);
}
}
else
{
}
}
list = list.OrderBy(u => u.NGAY).ToList();
bs.DataSource = list;
CrystalReportLAILOTUNGKHO rpt = new CrystalReportLAILOTUNGKHO();
rpt.SetDataSource(bs);
rpt.SetParameterValue("KHO", comboBoxKHO.Text);
rpt.SetParameterValue("FROM", dateTimePickerFROM.Value);
rpt.SetParameterValue("TO", dateTimePickerTO.Value);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
rpt.SetParameterValue("TONGCHI", MKho.Total_Chi(_kho, _from, _to));
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Zoom(150);
}