public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { ReserveReport1 rpt = new ReserveReport1(); rpt.Site = this.Site; return(rpt); }
public void btReportReserve_Click(object sender, EventArgs e) { if (!Information.IsNumeric(txtDay.Text) && txtDay.Text != "") //ກວດທັງຕົວເລກ ແລະ ຊ່ອງວ່າງ { // txtDay.Text = txtDay.Text.Substring(0, txtDay.Text.Length - 1) //txtDay.Select(txtDay.Text.Length + 1, 1) txtDay.ResetText(); txtDay.Focus(); // Exit Sub } else { var sql = @"SELECT dbo.tb_reserveBoat.reserveID, dbo.tb_employee.employeeName, dbo.tb_reserveBoat.boatID, dbo.tb_customer.customerName, dbo.tb_reserveBoat.reserveDate, dbo.tb_reserveBoat.reserveComeDate, convert(varchar(8),dbo.tb_reserveBoat.reserveComeTime, 108) as reserveComeTime, dbo.tb_reserveBoat.boatHour, dbo.tb_reserveBoat.reserveStatus FROM dbo.tb_reserveBoat INNER JOIN dbo.tb_employee ON dbo.tb_reserveBoat.employeeID = dbo.tb_employee.employeeID INNER JOIN dbo.tb_customer ON dbo.tb_reserveBoat.customerID = dbo.tb_customer.customerID where reserveComeDate between GETDATE() and DateADD(day, " + System.Convert.ToString(int.Parse(txtDay.Text)) + ", GETDATE())"; DSReport dsr = new DSReport(); ReserveReport1 rpt = new ReserveReport1(); var da = new SqlDataAdapter(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr)); da.Fill(dsr, "DTReserve"); if (dsr.Tables["DTReserve"].Rows.Count == 0) { MessageBox.Show("ບໍ່ມີຂໍ້ມູນ"); } else { rpt.SetDataSource(dsr); // rpt.SetParameterValue("top", TextBox1.Text) rpt.SetParameterValue("year", txtDay.Text); frm_MainReportChoosing.Default.CrystalReportViewer1.ReportSource = rpt; frm_MainReportChoosing.Default.Show(this); } } }