コード例 #1
0
        private ReportViewer LoadReport(ReportSearchParams reportSearchModel)
        {
            #region Server Report
            //ReportViewer reportViewer = new ReportViewer();
            //reportViewer.ProcessingMode = ProcessingMode.Remote;
            //reportViewer.SizeToReportContent = true;
            //reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
            //reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
            //reportViewer.ServerReport.ReportPath = string.Format(ColorTrend.Common.GetAppKeyValue("ReportsPath"), reportName);
            //reportViewer.ServerReport.ReportServerUrl = new Uri(ColorTrend.Common.GetAppKeyValue("ReportServerName"));
            //reportViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials(ColorTrend.Common.GetAppKeyValue("ReportServerUser"), ColorTrend.Common.GetAppKeyValue("ReportServerPassword"), "");

            #endregion
            string reportName = "";
            if (reportSearchModel == null || string.IsNullOrEmpty(reportSearchModel.ReportName))
            {
                reportName = "Empty";
            }
            else
            {
                reportName = reportSearchModel.ReportName;
            }
            #region Local Report
            ReportViewer reportViewer = new ReportViewer();
            reportViewer.ProcessingMode      = ProcessingMode.Local;
            reportViewer.SizeToReportContent = true;
            reportViewer.Width  = System.Web.UI.WebControls.Unit.Percentage(100);
            reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);

            //TODO: To use our report path
            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + string.Format(@"Reports\{0}.rdlc", reportName);
            //TODO: To get datasource as per report;
            reportViewer.LocalReport.DataSources.Clear();
            // string value = SessionManagement.CurrentLang.ToString();
            string value = SessionManagement.Language;
            string lang  = "EN";//default lang

            if (value != "")
            {
                lang = value;
            }

            //TODO: Globalisation Of Reports

            switch (reportName)
            {
            case "EmployeePresence":
                ReportDataSet dsEP = new ReportDataSet();
                usp_GetEmployeePresence1TableAdapter daEP = new usp_GetEmployeePresence1TableAdapter();
                dsEP.EnforceConstraints = false;
                daEP.Fill(dsEP.usp_GetEmployeePresence1, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
                List <ReportParameter> parmE     = new List <ReportParameter>();
                DataTable        dtEP            = dsEP.Tables["usp_GetEmployeePresence1"];
                ReportDataSource rptDataSourceEP = new ReportDataSource("GetEmployeePresence", dtEP);
                reportViewer.LocalReport.DataSources.Add(rptDataSourceEP);
                ReportParameter[] EmployeePresenceParm = new ReportParameter[] {
                    new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("EmployeePresence", new CultureInfo(lang))),
                    new ReportParameter("Date", Resources.Resource.ResourceManager.GetString("Date", new CultureInfo(lang))),
                    new ReportParameter("Start", Resources.Resource.ResourceManager.GetString("Start", new CultureInfo(lang))),
                    new ReportParameter("Stop", Resources.Resource.ResourceManager.GetString("Stop", new CultureInfo(lang)))
                };
                reportViewer.LocalReport.SetParameters(EmployeePresenceParm);
                break;

            case "EmployeeSms":
                ReportDataSet dsES = new ReportDataSet();
                usp_GetEmployeeSMSTableAdapter daES = new usp_GetEmployeeSMSTableAdapter();
                dsES.EnforceConstraints = false;
                daES.Fill(dsES.usp_GetEmployeeSMS, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
                List <ReportParameter> parmES    = new List <ReportParameter>();
                DataTable        dtES            = dsES.Tables["usp_GetEmployeeSMS"];
                ReportDataSource rptDataSourceES = new ReportDataSource("Getsms", dtES);
                reportViewer.LocalReport.DataSources.Add(rptDataSourceES);
                break;

            case "ListCustomers":
                ReportDataSet ds = new ReportDataSet();
                usp_GetCustomersTableAdapter da = new usp_GetCustomersTableAdapter();
                da.Fill(ds.usp_GetCustomers, SessionManagement.FactoryID, reportSearchModel.FilterSearch);
                DataTable        dt            = ds.Tables["usp_GetCustomers"];
                ReportDataSource rptDataSource = new ReportDataSource("GetCustomers", dt);
                reportViewer.LocalReport.DataSources.Add(rptDataSource);
                ReportParameter[] parm = new ReportParameter[] {
                    new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("ListCustomers", new CultureInfo(lang))),
                    new ReportParameter("Number", Resources.Resource.ResourceManager.GetString("Number", new CultureInfo(lang))),
                    new ReportParameter("CustomerName", Resources.Resource.ResourceManager.GetString("CustomerName", new CultureInfo(lang))),
                    new ReportParameter("Phone", Resources.Resource.ResourceManager.GetString("Phone", new CultureInfo(lang))),
                    new ReportParameter("Address", Resources.Resource.ResourceManager.GetString("Address", new CultureInfo(lang)))
                };
                reportViewer.LocalReport.SetParameters(parm);
                break;
            }
            reportViewer.LocalReport.Refresh();
            #endregion
            return(reportViewer);
        }
コード例 #2
0
        private ReportViewer LoadReport(ReportSearchParams reportSearchModel)
        {
            #region Server Report
            //ReportViewer reportViewer = new ReportViewer();
            //reportViewer.ProcessingMode = ProcessingMode.Remote;
            //reportViewer.SizeToReportContent = true;
            //reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
            //reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);
            //reportViewer.ServerReport.ReportPath = string.Format(ColorTrend.Common.GetAppKeyValue("ReportsPath"), reportName);
            //reportViewer.ServerReport.ReportServerUrl = new Uri(ColorTrend.Common.GetAppKeyValue("ReportServerName"));
            //reportViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials(ColorTrend.Common.GetAppKeyValue("ReportServerUser"), ColorTrend.Common.GetAppKeyValue("ReportServerPassword"), "");

            #endregion
            string reportName = "";
            if (reportSearchModel == null || string.IsNullOrEmpty(reportSearchModel.ReportName))
            {
                reportName = "Empty";
            }
            else
            {
                reportName = reportSearchModel.ReportName;
            }
            #region Local Report
            ReportViewer reportViewer = new ReportViewer();
            reportViewer.ProcessingMode = ProcessingMode.Local;
            reportViewer.SizeToReportContent = true;
            reportViewer.Width = System.Web.UI.WebControls.Unit.Percentage(100);
            reportViewer.Height = System.Web.UI.WebControls.Unit.Percentage(100);

            //TODO: To use our report path
            reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + string.Format(@"Reports\{0}.rdlc", reportName);
            //TODO: To get datasource as per report;
            reportViewer.LocalReport.DataSources.Clear();
            // string value = SessionManagement.CurrentLang.ToString();
            string value = SessionManagement.Language;
            string lang = "EN";//default lang

            if (value != "")
            {
                lang = value;
            }

            //TODO: Globalisation Of Reports

            switch (reportName)
            {
                case "EmployeePresence":
                    ReportDataSet dsEP = new ReportDataSet();
                    usp_GetEmployeePresence1TableAdapter daEP = new usp_GetEmployeePresence1TableAdapter();
                    dsEP.EnforceConstraints = false;
                    daEP.Fill(dsEP.usp_GetEmployeePresence1, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
                    List<ReportParameter> parmE = new List<ReportParameter>();
                    DataTable dtEP = dsEP.Tables["usp_GetEmployeePresence1"];
                    ReportDataSource rptDataSourceEP = new ReportDataSource("GetEmployeePresence", dtEP);
                    reportViewer.LocalReport.DataSources.Add(rptDataSourceEP);
                    ReportParameter[] EmployeePresenceParm = new ReportParameter[]{
                       new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("EmployeePresence", new CultureInfo(lang))),
                        new ReportParameter("Date",Resources.Resource.ResourceManager.GetString("Date", new CultureInfo(lang))),
                         new ReportParameter("Start",Resources.Resource.ResourceManager.GetString("Start", new CultureInfo(lang))),
                          new ReportParameter("Stop",Resources.Resource.ResourceManager.GetString("Stop", new CultureInfo(lang)))
                    };
                    reportViewer.LocalReport.SetParameters(EmployeePresenceParm);
                    break;

                case "EmployeeSms":
                    ReportDataSet dsES = new ReportDataSet();
                    usp_GetEmployeeSMSTableAdapter daES = new usp_GetEmployeeSMSTableAdapter();
                    dsES.EnforceConstraints = false;
                    daES.Fill(dsES.usp_GetEmployeeSMS, reportSearchModel.StartDate, SessionManagement.FactoryID, reportSearchModel.EndDate, reportSearchModel.FilterSearch);
                    List<ReportParameter> parmES = new List<ReportParameter>();
                    DataTable dtES = dsES.Tables["usp_GetEmployeeSMS"];
                    ReportDataSource rptDataSourceES = new ReportDataSource("Getsms", dtES);
                    reportViewer.LocalReport.DataSources.Add(rptDataSourceES);
                    break;

                case "ListCustomers":
                    ReportDataSet ds = new ReportDataSet();
                    usp_GetCustomersTableAdapter da = new usp_GetCustomersTableAdapter();
                    da.Fill(ds.usp_GetCustomers, SessionManagement.FactoryID, reportSearchModel.FilterSearch);
                    DataTable dt = ds.Tables["usp_GetCustomers"];
                    ReportDataSource rptDataSource = new ReportDataSource("GetCustomers", dt);
                    reportViewer.LocalReport.DataSources.Add(rptDataSource);
                    ReportParameter[] parm = new ReportParameter[]{
                       new ReportParameter("Title", Resources.Resource.ResourceManager.GetString("ListCustomers", new CultureInfo(lang))),
                        new ReportParameter("Number",Resources.Resource.ResourceManager.GetString("Number", new CultureInfo(lang))),
                         new ReportParameter("CustomerName",Resources.Resource.ResourceManager.GetString("CustomerName", new CultureInfo(lang))),
                          new ReportParameter("Phone",Resources.Resource.ResourceManager.GetString("Phone", new CultureInfo(lang))),
                           new ReportParameter("Address",Resources.Resource.ResourceManager.GetString("Address", new CultureInfo(lang)))
                    };
                    reportViewer.LocalReport.SetParameters(parm);
                    break;

            }
            reportViewer.LocalReport.Refresh();
            #endregion
            return reportViewer;
        }