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); }