Пример #1
0
        internal List <DashboardBackgroundProcessStatsEntity> DashboardV2GetBackgroundProcessStats()
        {
            List <DashboardBackgroundProcessStatsEntity> result = new List <DashboardBackgroundProcessStatsEntity>();

            try
            {
                DataTable             dt    = new DataTable();
                StoredProcedureEntity sproc = new StoredProcedureEntity();
                sproc.StoredProcedureName = "dnb.DashboardV2GetBackgroundProcessStats";
                dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc);
                if (dt != null && dt.Rows.Count > 0)
                {
                    result = new DashboardBackgroundProcessStatsAdapter().Adapt(dt);
                }
                return(result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #2
0
        internal List <DashboardBackgroundProcessStatsEntity> DashboardV2GetBackgroundProcessStats(bool ShowDetails)
        {
            List <DashboardBackgroundProcessStatsEntity> result = new List <DashboardBackgroundProcessStatsEntity>();

            try
            {
                DataSet ds = new DataSet();
                StoredProcedureEntity sproc = new StoredProcedureEntity();
                sproc.StoredProcedureName = "dnb.DashboardV2GetBackgroundProcessStats";
                sproc.StoredProceduresParameter.Add(GetParam("@ShowDetails", ShowDetails.ToString(), SQLServerDatatype.BitDataType));
                ds = sql.ExecuteDataSet(CommandType.StoredProcedure, sproc);
                if (ds != null && ds.Tables.Count > 0)
                {
                    result = new DashboardBackgroundProcessStatsAdapter().Adapt(ds.Tables[0]);
                }
                return(result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }