protected void btn_EvalutionProf_Click(object sender, EventArgs e) { img_ExportToExcel1.Visible = false; img_ExportToExcel2.Visible = false; img_ExportToExcel3.Visible = false; img_ExportToExcel4.Visible = false; if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0") { RadWindowManager1.RadAlert("لطفا ترم را انتخاب بفرمایید", 0, 100, "پیام", ""); } else { if (txt_CodeOstad.Text == "") { txt_CodeOstad.Text = "0"; } if (ddl_CodeGroup.SelectedValue == null) { ddl_CodeGroup.SelectedValue = "0"; } if (ddl_CodeDras.SelectedValue == null) { ddl_CodeDras.SelectedValue = "0"; } Order = 1; dt = FRB.GetEvalutionProfDividedDid(ddl_Term.SelectedValue, int.Parse(txt_CodeOstad.Text), int.Parse(ddl_CodeGroup.SelectedValue), int.Parse(ddl_CodeDras.SelectedValue), Order); if (dt.Rows.Count == 0) { RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", ""); } else { img_ExportToExcel1.Visible = true; this.StiWebViewer1.ResetReport(); StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Report/ReportEvalutionProf.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_EvalutionProfDividedDid]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue; rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text); rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@Lesson"].ParameterValue = int.Parse(ddl_CodeDras.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_CodeGroup.SelectedValue); rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@Order"].ParameterValue = Order; ((StiSqlSource)rpt.Dictionary.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"]).CommandTimeout = 30000; rpt.RegData(dt); 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; }
protected void btn_EvalutionProfByLesson_Click(object sender, EventArgs e) { if (TED.Term == null) { RadWindowManager1.RadAlert("لطفا ترم را انتخاب بفرمایید", 0, 100, "پیام", ""); } else { if (txt_CodeOstad.Text == string.Empty) { txt_CodeOstad.Text = "0"; } if (TED.Departman == null) { TED.Departman = "0"; } if (TED.Lesson == null) { TED.Lesson = "0"; } //if (chk_NameOstad.Checked == true && chk_ScoreOstad.Checked == false) //{ // Order = 1; //} //if (chk_NameOstad.Checked == false && chk_ScoreOstad.Checked == true) //{ // Order = 2; //} //if (chk_NameOstad.Checked == true && chk_ScoreOstad.Checked == true) //{ // Order = 3; //} //if (chk_NameOstad.Checked == false && chk_ScoreOstad.Checked == false) //{ // Order = 1; //} Order = 1; dt = FRB.GetEvalutionProfDividedDid(TED.Term, int.Parse(txt_CodeOstad.Text), int.Parse(TED.Departman), int.Parse(TED.Lesson), Order); if (dt.Rows.Count == 0) { RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", ""); } else { this.StiWebViewer1.ResetReport(); StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Report/ReportEvalutionProfDividedDid.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_EvalutionProfDividedDid]"].Parameters["@Term"].ParameterValue = TED.Term; rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text); rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@Lesson"].ParameterValue = int.Parse(TED.Lesson); rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@Departman"].ParameterValue = int.Parse(TED.Departman); rpt.CompiledReport.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"].Parameters["@Order"].ParameterValue = Order; ((StiSqlSource)rpt.Dictionary.DataSources["[Faculty].[SP_EvalutionProfDividedDid]"]).CommandTimeout = 30000; rpt.RegData(dt); rpt.Dictionary.Synchronize(); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; } if (txt_CodeOstad.Text == "0" || txt_CodeOstad.Text == "") { txt_CodeOstad.Text = ""; Session["code_ostad"] = null; } } Session["code_ostad"] = null; }