public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
ReserveBill rpt = new ReserveBill();
rpt.Site = this.Site;
return(rpt);
}
public void btBill_Click(object sender, EventArgs e)
{
DSReserveBill ds = new DSReserveBill();
ReserveBill rpt = new ReserveBill();
string sql = "select reserveID, employeeName, customerName, reserveDate, reserveComedate, convert(varchar(8),reservecometime, 108) as reserveCometime, boatHOur, foodname, foodamount, unitName, foodPrice, Total from v_reserveBill where reserveID = '" + System.Convert.ToString(dgvReserve.Rows[dgvReserve.CurrentRow.Index].Cells[0].Value) + "'";
SqlCommand cm = default(SqlCommand);
SqlDataAdapter da = default(SqlDataAdapter);
cm = new SqlCommand(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr));
da = new SqlDataAdapter(cm);
da.Fill(ds, "DTReserveBill");
rpt.SetDataSource(ds);
frm_ReserveBill.Default.CrystalReportViewer1.ReportSource = rpt;
frm_ReserveBill.Default.Show();
//frm_Bill.rp_Bill.ReportSource = rpt
//frm_Bill.Show()
}
