private void btnXem_Click(object sender, EventArgs e) { using (quanlithucungEntities1 quanli = new quanlithucungEntities1()) { DataTable table = new DataTable(); table.Columns.Add("mapn"); table.Columns.Add("ngaylap"); table.Columns.Add("nhanvien"); table.Columns.Add("nhacc"); table.Columns.Add("tensanpham"); table.Columns.Add("soluong"); table.Columns.Add("dongia"); table.Columns.Add("thanhtien"); table.Columns.Add("tongtien"); List <reportPhieuNhap_Result> ds_hoadon = quanli.reportPhieuNhap(comboBox1.SelectedValue.ToString()).ToList(); foreach (var item in ds_hoadon) { table.Rows.Add(item.mapn, item.ngaylap, item.nhanvien, item.nhacc, item.tensanpham, item.soluong, item.dongia, item.thanhtien, item.tongtien); } RPHoaDonNhap2.SetDataSource(table); crystalReportViewer1.ReportSource = RPHoaDonNhap2; crystalReportViewer1.Show(); } }
private void ThongTinHoaDonNhap_Load(object sender, EventArgs e) { using (quanlithucungEntities1 quanli = new quanlithucungEntities1()) { RPHoaDon report = new RPHoaDon(); DataTable table = new DataTable(); table.Columns.Add("mapn"); table.Columns.Add("ngaylap"); table.Columns.Add("nhanvien"); table.Columns.Add("nhacc"); table.Columns.Add("tensanpham"); table.Columns.Add("soluong"); table.Columns.Add("dongia"); table.Columns.Add("thanhtien"); table.Columns.Add("TongTien"); List <reportPhieuNhap_Result> ds_hoadon = quanli.reportPhieuNhap("PN01").ToList(); foreach (var item in ds_hoadon) { table.Rows.Add(item.mapn, item.ngaylap, item.nhanvien, item.nhacc, item.tensanpham, item.soluong, item.dongia, item.thanhtien, item.tongtien); } RPHoaDonNhap1.SetDataSource(table); crystalReportViewer1.ReportSource = RPHoaDonNhap1; crystalReportViewer1.Show(); } }