public DataTable GetTableReport(ReportViewerDTO rpt)
{
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@RptType", rpt.SelectedRptType);
Parameters[1] = new SqlParameter("@RefKey", rpt.RefKey);
Parameters[2] = new SqlParameter("@RptDate", NumberExtensions.ConvertDatetimeDB(rpt.Date));
var Collector = FillDataTable("WebRptViewer", CommandType.StoredProcedure, Parameters);
return(Collector);
}
public object GetReport(ReportViewerDTO rpt)
{
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = string.IsNullOrEmpty(rpt.SelectedRptType) ? new SqlParameter("@RptType", DBNull.Value) : new SqlParameter("@RptType", rpt.SelectedRptType);
Parameters[1] = string.IsNullOrEmpty(rpt.RefKey) ? new SqlParameter("@RefKey", DBNull.Value) : new SqlParameter("@RefKey", rpt.RefKey);
Parameters[2] = new SqlParameter("@RptDate", NumberExtensions.ConvertDatetimeDB(rpt.Date));
var Collector = FillDataSet("WebRptViewer", CommandType.StoredProcedure, Parameters);
var objDataInfo = GetInfo(Collector.Tables[0]);
return(objDataInfo);
}
public List <object> GetRowReport(ReportViewerDTO rpt)
{
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = string.IsNullOrEmpty(rpt.SelectedRptType) ? new SqlParameter("@RptType", DBNull.Value) : new SqlParameter("@RptType", rpt.SelectedRptType);
Parameters[1] = string.IsNullOrEmpty(rpt.RefKey) ? new SqlParameter("@RefKey", DBNull.Value) : new SqlParameter("@RefKey", rpt.RefKey);
Parameters[2] = new SqlParameter("@RptDate", NumberExtensions.ConvertDatetimeDB(rpt.Date));
var Collector = FillDataSet("WebRptViewer", CommandType.StoredProcedure, Parameters);
var dataRow = Collector.Tables[0].AsEnumerable().ToList();
List <object> rows = new List <object>();
foreach (var x in dataRow)
{
rows.Add(x.ItemArray);
}
return(rows);
}
public DataTable GetTableReport(ReportViewerDTO rpt)
{
Logger.Info("Invoking GetTableReport function");
try
{
using (var scope = Container.BeginLifetimeScope())
{
var reportpDAO = scope.Resolve <IReportOpDAO>();
var result = reportpDAO.GetTableReport(rpt);
return(result);
}
}
catch (Exception ex)
{
string msg = string.Format("Error in GetTableReport: detail:{0}", ex.Message);
Logger.Error(msg, ex);
}
return(null);
}
