public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CReportEx1 rpt = new CReportEx1();
rpt.Site = this.Site;
return(rpt);
}
//SqlConnection con1 = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=IT_REQUEST;Integrated Security=True");
//SqlConnection con1 = new SqlConnection(@"Data Source=10.65.2.217\SQLEXPRESS;Initial Catalog=IT_REQUEST;Persist Security Info=True;User ID=sa;Password=abc@123");
//-----------------------------------------------------------SHOW REPORT------------------------------------------------------------------------------
private void btnShowRP_Click(object sender, EventArgs e)
{
if (rbNoiDung.Checked == true)
{
FrmMain.con1.Open();
SqlDataAdapter sqlSDa = new SqlDataAdapter("ViewReportNoiDungSR", FrmMain.con1);
sqlSDa.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlSDa.SelectCommand.Parameters.AddWithValue("@RequestID", txtMaNV.Text.Trim());
sqlSDa.SelectCommand.Parameters.AddWithValue("@RequestName", txtMaNV.Text.Trim());
sqlSDa.SelectCommand.Parameters.AddWithValue("@MaNV", txtMaNV.Text.Trim());
//sqlSDa.SelectCommand.Parameters.AddWithValue("@NgayGui", dtNgayGui.Value.Date);
DataTable dtb = new DataTable();
sqlSDa.Fill(dtb);
FrmMain.con1.Close();
WindowsFormsApplication1.CReportMain.CReportEx1 crpTest = new CReportMain.CReportEx1();
crpTest.Database.Tables["ViewReportNoiDungSR"].SetDataSource(dtb);
//crpTest.Database.Tables["NHANVIEN"].SetDataSource(dtb.Tables[1]);
crystalReportViewer1.ReportSource = null;
crystalReportViewer1.ReportSource = crpTest;
}
//-----------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------
if (rbNgayThang.Checked == true)
{
FrmMain.con1.Open();
SqlDataAdapter sqlSDa = new SqlDataAdapter("ViewReportNgayThangSR", FrmMain.con1);
sqlSDa.SelectCommand.CommandType = CommandType.StoredProcedure;
//sqlSDa.SelectCommand.Parameters.AddWithValue("@MaNV", txtMaNV.Text.Trim());
sqlSDa.SelectCommand.Parameters.AddWithValue("@NgayGui", dtNgayGui.Value.Date);
DataTable dtb = new DataTable();
sqlSDa.Fill(dtb);
FrmMain.con1.Close();
WindowsFormsApplication1.CReportMain.CReportEx1 crpTest = new CReportMain.CReportEx1();
crpTest.Database.Tables["REQUESTSEND"].SetDataSource(dtb);
crystalReportViewer1.ReportSource = null;
crystalReportViewer1.ReportSource = crpTest;
}
}
