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);
}
}
}
