protected void btn_ShowList_Click(object sender, EventArgs e) { img_ExportToExcel1.Visible = false; img_ExportToExcel2.Visible = false; if (ddl_Term.SelectedValue == null) { RadWindowManager1.RadAlert("لطفا ترم را انتخاب کنید", 0, 100, "پیام", ""); } if (ddl_Day.SelectedValue == null || ddl_Day.SelectedValue == "0") { RadWindowManager1.RadAlert("لطفا روز را انتخاب کنید", 0, 100, "پیام", ""); } if (ddl_NumberClass.SelectedValue == null || ddl_NumberClass.SelectedValue == ".") { RadWindowManager1.RadAlert("لطفا شماره کلاس را انتخاب کنید", 0, 100, "پیام", ""); } else { if (txt_CodeOstad.Text == string.Empty || txt_CodeOstad.Text == "") { txt_CodeOstad.Text = "0"; } else { LTKD.CodeOstad = txt_CodeOstad.Text; } if (rdb_ListByOstad.Checked == true) { Sort = 0; dtResault = FRB.GetConflictClassByCodeOstad(ddl_Term.SelectedValue, int.Parse(txt_CodeOstad.Text), Sort, int.Parse(ddl_Day.SelectedValue), int.Parse(ddl_NumberClass.SelectedValue)); 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/ReportConflictClassbyCodeOstad.mrt")); rpt.ReportCacheMode = StiReportCacheMode.On; rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyCodeOstad]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue; rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyCodeOstad]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text); rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyCodeOstad]"].Parameters["@Sort"].ParameterValue = Sort; rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyCodeOstad]"].Parameters["@Day"].ParameterValue = int.Parse(ddl_Day.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyCodeOstad]"].Parameters["@NumberClass"].ParameterValue = (ddl_NumberClass.SelectedValue); ((StiSqlSource)rpt.Dictionary.DataSources["[Faculty].[SP_ConflictClassbyCodeOstad]"]).CommandTimeout = 30000; rpt.RegData(dtResault); rpt.Dictionary.Synchronize(); //rpt.Show(); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; //rpt.Print(true); } if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "") { txt_CodeOstad.Text = ""; Session["code_ostad"] = null;; } txt_CodeOstad.Text = ""; Session["code_ostad"] = null; } if (rdb_ListByNumberClass.Checked == true) { Sort = 2; if (ddl_Day.SelectedValue == null || ddl_Day.SelectedValue == "") { RadWindowManager1.RadAlert("لطفا روز را انتخاب کنید", 0, 100, "پیام", ""); } else { dtResault = FRB.GetConflictClassByNumberClass(ddl_Term.SelectedValue, ddl_NumberClass.SelectedValue, Sort, int.Parse(ddl_Day.SelectedValue)); if (dtResault.Rows.Count == 0) { RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", ""); } else { img_ExportToExcel2.Visible = true; this.StiWebViewer1.ResetReport(); StiWebViewer1.Visible = true; StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Report/ReportConflictClassbyNumberClass.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_ConflictClassbyNumberClass]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue; rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyNumberClass]"].Parameters["@NumberClass"].ParameterValue = ddl_NumberClass.SelectedValue; rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyNumberClass]"].Parameters["@Sort"].ParameterValue = Sort; rpt.CompiledReport.DataSources["[Faculty].[SP_ConflictClassbyNumberClass]"].Parameters["@Day"].ParameterValue = int.Parse(ddl_Day.SelectedValue); ((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; } } } }