private void btnBaoCao_Click(object sender, EventArgs e)
{
try
{
using (SqlConnection cnn = new SqlConnection(constr))
{
using (SqlCommand cmd = cnn.CreateCommand())
{
cnn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_thongKeSanPhamNhapTHeoNgayVaNhanVien";
//cmd.Parameters.AddWithValue("@ngayBatDau", DateTime.Parse(txtNgayBatDau.Text));
//cmd.Parameters.AddWithValue("@ngayKetThuc", DateTime.Parse(txtNgayKetThuc.Text));
cmd.Parameters.AddWithValue("@ngayBatDau", DateTime.ParseExact(txtNgayBatDau.Text, "dd/MM/yyyy", null));
cmd.Parameters.AddWithValue("@ngayKetThuc", DateTime.ParseExact(txtNgayKetThuc.Text, "dd/MM/yyyy", null));
SqlDataAdapter dap = new SqlDataAdapter(cmd);
DataTable data = new DataTable();
dap.Fill(data);
BaoCaoNhapHangTheoNhanVienVaThoiGian report = new BaoCaoNhapHangTheoNhanVienVaThoiGian();
report.SetDataSource(data);
crystalReportViewer1.ReportSource = report;
}
}
}
catch (Exception ex)
{
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
BaoCaoNhapHangTheoNhanVienVaThoiGian rpt = new BaoCaoNhapHangTheoNhanVienVaThoiGian();
rpt.Site = this.Site;
return(rpt);
}