protected void btn_ShowList_Click(object sender, EventArgs e)
{
img_ExportToExcel1.Visible = false;
img_ExportToExcel2.Visible = false;
if (ddl_Term.SelectedValue == null || ddl_Term.SelectedValue == "0")
{
RadWindowManager1.RadAlert("رکوردی وجود ندارد", 0, 100, "پیام", "");
}
else
{
LAD.CodeOstad = txt_CodeOstad.Text;
LAD.FromDate = txt_FromDate.Text;
LAD.ToDate = txt_ToDate.Text;
LAD.AzJobrani = txt_AzJobrani.Text;
LAD.TaJobrani = txt_ToJobrani.Text;
if (txt_AzJobrani.Text == "")
{
txt_AzJobrani.Text = " / / ";
}
if (txt_ToJobrani.Text == "")
{
txt_ToJobrani.Text = " / / ";
}
if (txt_FromDate.Text == "")
{
txt_FromDate.Text = " / / ";
}
if (txt_ToDate.Text == "")
{
txt_ToDate.Text = " / / ";
}
if (ddl_GroupOstad.SelectedValue == null)
{
ddl_GroupOstad.SelectedValue = "0";
}
if (ddl_Daneshkade.SelectedValue == null)
{
ddl_Daneshkade.SelectedValue = "0";
}
if (txt_AzJobrani.Text == string.Empty)
{
txt_AzJobrani.Text = "0";
}
if (txt_ToJobrani.Text == string.Empty)
{
txt_ToJobrani.Text = "0";
}
if (txt_FromDate.Text == string.Empty)
{
txt_FromDate.Text = "0";
}
if (txt_FromDate.Text == string.Empty)
{
txt_FromDate.Text = "0";
}
if (txt_NumberAbsence.Text == string.Empty)
{
txt_NumberAbsence.Text = "0";
}
if (txt_CodeOstad.Text == null || txt_CodeOstad.Text == "")
{
txt_CodeOstad.Text = "0";
}
if (rdb_YesAbsencesNoCountervailing.Checked == true)
{
if ((txt_FromDate.Text == " / / ") || (txt_ToDate.Text == " / / "))
{
RadWindowManager1.RadAlert("لطفا از تاریخ ، تا تاریخ را پر کنید", 0, 100, "پیام", "");
}
else
{
DataTable dtResault = FRB.GetAbsenceButNoCompensationProf(ddl_Term.SelectedValue, int.Parse(ddl_GroupOstad.SelectedValue), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(txt_CodeOstad.Text), txt_FromDate.Text, txt_ToDate.Text, int.Parse(txt_NumberAbsence.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/ReportAbsenceButNoCompensation.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_AbsenceButNoCompensation]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_GroupOstad.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text);
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@FromDate"].ParameterValue = txt_FromDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@ToDate"].ParameterValue = txt_ToDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[SP_AbsenceButNoCompensation]"].Parameters["@CountAbsence"].ParameterValue = int.Parse(txt_NumberAbsence.Text);
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
}
if (rdb_YesAbsenceYesCountervailing.Checked == true)
{
if (txt_FromDate.Text == " / / " || txt_ToDate.Text == " / / ")
{
RadWindowManager1.RadAlert("لطفا از تاریخ تا تاریخ پر کنید", 0, 100, "پیام", "");
}
if (txt_AzJobrani.Text == " / / " || txt_ToJobrani.Text == " / / ")
{
RadWindowManager1.RadAlert("لطفا از تاریخ جبرانی تا تاریخ جبرانی را پر کنید", 0, 100, "پیام", "");
}
else
{
DataTable dtResault = FRB.GetAbsenceAndCompensationProf(ddl_Term.SelectedValue, int.Parse(ddl_GroupOstad.SelectedValue), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(txt_CodeOstad.Text), txt_FromDate.Text, txt_ToDate.Text, int.Parse(txt_NumberAbsence.Text), txt_AzJobrani.Text, txt_ToJobrani.Text);
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/ReportAbsenceAndCompensation.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_AbsenceAndCompensation]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@Departman"].ParameterValue = int.Parse(ddl_GroupOstad.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@Daneshkade"].ParameterValue = int.Parse(ddl_Daneshkade.SelectedValue);
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text);
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@AzJobrani"].ParameterValue = txt_AzJobrani.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@TaJobrani"].ParameterValue = txt_ToJobrani.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@FromDate"].ParameterValue = txt_FromDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@ToDate"].ParameterValue = txt_ToDate.Text;
rpt.CompiledReport.DataSources["[Faculty].[Sp_AbsenceAndCompensation]"].Parameters["@CountAbsence"].ParameterValue = int.Parse(txt_NumberAbsence.Text);
rpt.RegData(dtResault);
rpt.Dictionary.Synchronize();
//rpt.Show();
StiWebViewer1.Report = rpt;
StiWebViewer1.Visible = true;
//rpt.Print(true);
}
}
}
}
}