private void Inhoadon_Load(object sender, EventArgs e) { Hamchung hc = new Hamchung(); SqlConnection cnn = new SqlConnection(hc.sqlCon); cnn.Open(); SqlDataAdapter da = new SqlDataAdapter("rpHoadon '"+MainForm.frmHoadon.Madangchon+"'", cnn); DataTable dt = new DataTable(); da.Fill(dt); SqlCommand cmd = new SqlCommand("Tongtien", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaHD", MainForm.frmHoadon.Madangchon); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); string Tongtien = reader[0].ToString(); ReportHoadon cr = new ReportHoadon(); cr.SetDataSource(dt); cr.SetParameterValue("MaHD", MainForm.frmHoadon.Madangchon); cr.SetParameterValue("Tenkhachhang", MainForm.frmHoadon.tenkh); cr.SetParameterValue("Tennhanvien", MainForm.frmHoadon.tennv); cr.SetParameterValue("Makhachhang", MainForm.frmHoadon.makh); cr.SetParameterValue("Ngaylap", MainForm.frmHoadon.nl); try { cr.SetParameterValue("Tongtien", Tongtien); } catch { MessageBox.Show("Hóa đơn này rỗng"); return; } rptvHoadon.ReportSource = cr; cnn.Close(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { ReportHoadon rpt = new ReportHoadon(); rpt.Site = this.Site; return rpt; }