private void btnTimMaHD_Click(object sender, EventArgs e) { txbKH.Text = String.Empty; if (txbHD.Text == String.Empty) { LoadHoaDon(); } else { HoaDon hoaDon = HoaDonBUS.GetHoaDon(txbHD.Text); if (hoaDon != null) { List <HoaDon> list = new List <HoaDon>(); list.Add(hoaDon); dgvHoaDon.DataSource = list; dgvHoaDon.Columns[0].HeaderText = "Mã hóa đơn"; dgvHoaDon.Columns[1].HeaderText = "Khách hàng"; dgvHoaDon.Columns[2].HeaderText = "Ngày lập"; dgvHoaDon.Columns[3].HeaderText = "Tổng tiền"; dgvHoaDon.Columns[4].HeaderText = "Địa chỉ giao"; dgvHoaDon.Columns[5].Visible = false; dgvHoaDon.Columns[6].HeaderText = "Trạng thái"; } else { dgvHoaDon.DataSource = null; lblKH.Text = String.Empty; lblMaHD.Text = String.Empty; lblNgay.Text = String.Empty; lblStt.Text = String.Empty; lblDiaChi.Text = String.Empty; lblTien.Text = String.Empty; } } }
public DataSet HoaDon_GetHoaDon(HoaDon inp, string swhere) { try { return(HoaDon_bus.GetHoaDon(inp, swhere)); } catch (Exception ex) { throw ex; } }
private void Form1_Load(object sender, EventArgs e) { DataTable cthd = HoaDonBUS.GetCTHD(MaHD); DataTable pn = HoaDonBUS.GetHoaDon(MaHD); ReportParameter[] param = new ReportParameter[5]; param[0] = new ReportParameter("MaHD", "" + MaHD); param[1] = new ReportParameter("KhachHang", pn.Rows[0][1].ToString()); param[2] = new ReportParameter("NguoiLap", pn.Rows[0][2].ToString()); param[3] = new ReportParameter("NgayLap", pn.Rows[0][3].ToString()); param[4] = new ReportParameter("TongTien", pn.Rows[0][4].ToString()); this.reportViewer1.LocalReport.SetParameters(param); ReportDataSource rds = new ReportDataSource("DataSet2", cthd); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(rds); this.reportViewer1.RefreshReport(); }