public static void RenderReport(string reportName, string schoolyear, string schoolcode, string publishCycle, string userID)
{
try
{
MyADO.MyParameterRS[] reportParameters = new MyADO.MyParameterRS[4];
setParameterArray(reportParameters, 0, "UserID", userID);
setParameterArray(reportParameters, 1, "SchoolYear", schoolyear);
setParameterArray(reportParameters, 2, "SchoolCode", schoolcode);
setParameterArray(reportParameters, 3, "PublishCycle", publishCycle);
string rFormat = WebConfig.ReportFormat();
Byte[] result = GetReportR2(reportName, reportParameters);
if (result.Length != 0)
{
HttpContext.Current.Response.AppendHeader("content-disposition", "filename=" + reportName + "." + rFormat);
HttpContext.Current.Response.ContentType = getReportContentType(rFormat);
HttpContext.Current.Response.OutputStream.Write(result, 0, result.GetLength(0));
HttpContext.Current.Response.End();
}
else
{
HttpContext.Current.Response.Redirect("PDFPageFile2.aspx?");
}
}
catch (Exception ex)
{
string showmsg = ex.Message;
}
}
public static Byte[] GetOneReport(string reportName, string userID, string schoolYear, string schoolCode, string version)
{
MyADO.MyParameterRS[] reportParameters = new MyADO.MyParameterRS[4];
setParameterArray(reportParameters, 0, "UserID", userID);
setParameterArray(reportParameters, 1, "SchoolYear", schoolYear);
setParameterArray(reportParameters, 2, "SchoolCode", schoolCode);
setParameterArray(reportParameters, 3, "Version", version);
return(GetReportR2(reportName, reportParameters));
}
private static Byte[] GetOneReport(string reportName, string userID, string schoolyear, string schoolcode, string sessionID, string employeeID)
{
MyADO.MyParameterRS[] reportParameters = new MyADO.MyParameterRS[7];
setParameterArray(reportParameters, 0, "Operate", "Report");
setParameterArray(reportParameters, 1, "UserID", userID);
setParameterArray(reportParameters, 2, "SchoolYear", schoolyear);
setParameterArray(reportParameters, 3, "SchoolCode", schoolcode);
setParameterArray(reportParameters, 4, "EmployeeID", employeeID);
setParameterArray(reportParameters, 5, "SessionID", sessionID);
setParameterArray(reportParameters, 6, "Category", "EPA");
return(GetReportR2(reportName, reportParameters));
}
public static void setParameterArray(MyADO.MyParameterRS[] _ParaArray, int X, string _Name, string _Value)
{
try
{
_ParaArray[X] = new MyADO.MyParameterRS();
_ParaArray[X].pName = _Name;
_ParaArray[X].pValue = _Value;
}
catch (Exception ex)
{
string error = ex.Message;
}
}
