Beispiel #1
0
        public DataTable GetTableReport(ReportViewer rpt)
        {
            var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);

            try
            {
                objDataEngine.InitiateConnection();

                SqlParameter[] Parameters = new SqlParameter[3];
                Parameters[0] = new SqlParameter("@RptType", rpt.SelectedRptType);
                Parameters[1] = new SqlParameter("@RefKey", rpt.RefKey);
                Parameters[2] = new SqlParameter("@RptDate", ConvertDatetimeDB(rpt.Date));
                var Collector = objDataEngine.FillDt("WebRptViewer", CommandType.StoredProcedure, Parameters);
                return(Collector);
            }
            finally
            {
                objDataEngine.CloseConnection();
            }
        }