public bool Execute
        (
            string connectionString
            , string storeProcedureName
            , JToken parameters
            , out JToken result
            , Func
            <
                IDataReader
                , Type                          // fieldType
                , string                        // fieldName
                , int                           // row index
                , int                           // column index
                , JProperty                     //  JObject Field 对象
            > onReadRowColumnProcessFunc  = null
            , int commandTimeoutInSeconds = 90
        )
        {
            if
            (
                CachedParametersDefinitionExpiredInSeconds > 0
                &&
                _executor
                .CachedParametersDefinitionExpiredInSeconds
                !=
                CachedParametersDefinitionExpiredInSeconds
            )
            {
                _executor
                .CachedParametersDefinitionExpiredInSeconds
                    = CachedParametersDefinitionExpiredInSeconds;
            }
            result = null;
            DbConnection connection = new SqlConnection(connectionString);

            result = _executor
                     .Execute
                     (
                connection
                , storeProcedureName
                , parameters
                , onReadRowColumnProcessFunc
                , commandTimeoutInSeconds
                     );
            if (NeedAutoRefreshExecutedTimeForSlideExpire)
            {
                _executor
                .RefreshCachedExecuted
                (
                    connection
                    , storeProcedureName
                );
            }
            return(true);
        }
示例#2
0
        public bool Execute
        (
            string connectionString
            , string storeProcedureName
            , JToken parameters
            , out JToken result
            , int commandTimeoutInSeconds = 90
        )
        {
            if
            (
                CachedExecutingParametersExpiredInSeconds > 0
                &&
                _executor
                .CachedExecutingParametersExpiredInSeconds
                !=
                CachedExecutingParametersExpiredInSeconds
            )
            {
                _executor
                .CachedExecutingParametersExpiredInSeconds
                    = CachedExecutingParametersExpiredInSeconds;
            }
            result = null;
            DbConnection connection = new OracleConnection(connectionString);

            result = _executor
                     .Execute
                     (
                connection
                , storeProcedureName
                , parameters
                , commandTimeoutInSeconds
                     );
            if (NeedAutoRefreshExecutedTimeForSlideExpire)
            {
                _executor
                .RefreshCachedExecuted
                (
                    connection
                    , storeProcedureName
                );
            }
            return(true);
        }