public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportCHIDUNGCHOXE rpt = new CrystalReportCHIDUNGCHOXE();
rpt.Site = this.Site;
return(rpt);
}
private void button1_Click(object sender, EventArgs e)
{
long xe = long.Parse(comboBox1.SelectedValue.ToString());
DateTime from = dateTimePickerFROM.Value.Date;
DateTime to = dateTimePickerTO.Value.Date;
var lst = DataInstance.Instance().DBContext().CHI_TIEU_DUNG_NOI_BO.Where(u => u.MAXE == xe)
.Where(u => u.NGAY_CHI >= from && u.NGAY_CHI <= to)
.OrderBy(u => u.NGAY_CHI);
List <object> list = new List <object>();
foreach (CHI_TIEU_DUNG_NOI_BO nb in lst)
{
list.Add(new
{
NGAY = nb.NGAY_CHI,
KHO = MKho.GetNamebyID(nb.MAKHO),
NOIDUNG = nb.NOI_DUNG,
HANGHOA = nb.MAHH == -1 ? "" : MHangHoa.GetNameByID(nb.MAHH),
SOLUONG = nb.SO_LUONG,
DONGIA = nb.DON_GIA_BAN,
THANHTIEN = nb.TONG_TIEN,
});
}
CrystalReportCHIDUNGCHOXE rpt = new CrystalReportCHIDUNGCHOXE();
rpt.SetDataSource(list);
rpt.SetParameterValue("FROM", dateTimePickerFROM.Value);
rpt.SetParameterValue("TO", dateTimePickerTO.Value);
rpt.SetParameterValue("COMP", ConstClass.COMPANY_NAME);
rpt.SetParameterValue("KH", comboBox1.Text);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Zoom(150);
}
