protected void btn_ShowReport_Click(object sender, EventArgs e) { img_ExportToExcel1.Visible = false; if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0") { RadWindowManager1.RadAlert("لطفا ترم را انتخاب نمایید", 0, 100, "پیام ", ""); } else { if (ddl_Daneshkade.SelectedValue == null) { ddl_Daneshkade.SelectedValue = "0"; } if (ddl_Departman.SelectedValue == null) { ddl_Departman.SelectedValue = "0"; } if (ddl_Cooperation.SelectedValue == null) { ddl_Cooperation.SelectedValue = "0"; } if (ddl_Term.SelectedValue == null) { ddl_Term.SelectedValue = "0"; } if (ddl_Field.SelectedValue == null) { ddl_Field.SelectedValue = "0"; } if (txt_CodeOstad.Text == string.Empty) { txt_CodeOstad.Text = "0"; } dtResault = FRB.GetListPayProf(ddl_Term.SelectedValue, int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Field.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue), int.Parse(txt_CodeOstad.Text), int.Parse(txt_Zarib.Text)); if (dtResault.Rows.Count == 0) { RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", ""); } else { img_ExportToExcel1.Visible = true; this.StiWebViewer1.ResetReport(); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Report/ReportListPayProf.mrt")); rpt.ReportCacheMode = StiReportCacheMode.On; StiOptions.Engine.ReportCache.AmountOfProcessedPagesForStartGCCollect = 20000; // default - 20 StiOptions.Engine.ReportCache.AmountOfQuickAccessPages = 10000; // default - 50 rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Faculty].[SP_ListPayTuition]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue; rpt.CompiledReport.DataSources["[Faculty].[SP_ListPayTuition]"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_ListPayTuition]"].Parameters["@Field"].ParameterValue = int.Parse(ddl_Field.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_ListPayTuition]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_Departman.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_ListPayTuition]"].Parameters["@Cooperation"].ParameterValue = int.Parse(ddl_Cooperation.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_ListPayTuition]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text); rpt.CompiledReport.DataSources["[Faculty].[SP_ListPayTuition]"].Parameters["@Zarib"].ParameterValue = int.Parse(txt_Zarib.Text); //((StiSqlSource)rpt.Dictionary.DataSources["[Faculty].[SP_ConflictClassbyNumberClass]"]).CommandTimeout = 30000; rpt.RegData(dtResault); rpt.Render(); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; } } if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "") { txt_CodeOstad.Text = ""; Session["code_ostad"] = null;; } //txt_CodeOstad.Text = ""; Session["code_ostad"] = null; }