protected void btn_ShowList_Click(object sender, EventArgs e)
{
img_ExportToExcel1.Visible = false;
RMD.FromDate = txt_FromDate.Text;
RMD.ToDate = txt_ToDate.Text;
if (txt_FromDate.Text == " / / " && txt_ToDate.Text == " / / ")
{
RadWindowManager1.RadAlert("لطفا تاریخ را وارد نمایید", 0, 100, "پیام", "");
}
else
{
if (ddl_Term.SelectedValue == null || chk_Term.Checked == true)
{
ddl_Term.SelectedValue = "0";
}
if (txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "0";
}
DataTable dtResault = FRB.ReferToProf(ddl_Term.SelectedValue, txt_CodeOstad.Text, txt_FromDate.Text, txt_ToDate.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/ReportReferToMaster.mrt"));
rpt.ReportCacheMode = StiReportCacheMode.On;
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_ReferToMaster]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_ReferToMaster]"].Parameters["@CodeOstad"].ParameterValue = txt_CodeOstad.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_ReferToMaster]"].Parameters["@FromDate"].ParameterValue = txt_FromDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_ReferToMaster]"].Parameters["@ToDate"].ParameterValue = txt_ToDate.Text;
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;
}
}