コード例 #1
0
        static public DataTable ExecuteDataTable(SqlConnection connection, String command, CommandType commandType, SqlParameterCollection Parameters, SqlTransaction trans)
        {
            SqlBase st = new SqlBase();

            try
            {
                return(st.ExecuteDataTable(connection, command, commandType, Parameters, trans));
            }
            finally
            {
                st = null;
            }
        }
コード例 #2
0
        static public void ExecuteNonQuery(SqlConnection connection, String command, CommandType commandType, SqlParameterCollection Parameters, SqlTransaction trans)
        {
            SqlBase st = new SqlBase();

            try
            {
                st.ExecuteNonQuery(connection, command, commandType, Parameters, trans);
            }
            finally
            {
                st = null;
            }
        }
コード例 #3
0
        static public void Insert2(SqlConnection connection, String insertSQL, SqlParameterCollection Parameters)
        {
            SqlBase st = new SqlBase();

            try
            {
                Insert(connection, insertSQL, Parameters);
            }
            finally
            {
                st = null;
            }
        }
コード例 #4
0
        static public Object ExecuteScalar(SqlConnection connection, String command, CommandType commandType, SqlParameterCollection Parameters)
        {
            SqlBase st = new SqlBase();

            try
            {
                return(st.ExecuteScalar(connection, command, commandType, Parameters));
            }
            finally
            {
                st = null;
            }
        }
コード例 #5
0
        static public DataTable selectAllFrom(SqlConnection connection, String tableName, String filter)
        {
            SqlBase st = new SqlBase();

            try
            {
                return(st.selectAllFrom(connection, tableName, filter));
            }
            finally
            {
                st = null;
            }
        }
コード例 #6
0
        static public void BulkCopy(SqlConnection connection, DataTable source, String table, SqlTransaction trans)
        {
            SqlBase st = new SqlBase();

            try
            {
                BulkCopy(connection, source, table, trans);
            }
            finally
            {
                st = null;
            }
        }
コード例 #7
0
        static public DataTable Select(SqlConnection connection, String SQL, SqlTransaction transaction)
        {
            SqlBase st = new SqlBase();

            try
            {
                return(st.Select(connection, SQL, transaction));
            }
            finally
            {
                st = null;
            }
        }
コード例 #8
0
        static public DataTable GetSchema(SqlConnection connection, String tableName)
        {
            SqlBase st = new SqlBase();

            try
            {
                return(st.GetSchema(connection, tableName));
            }
            finally
            {
                st = null;
            }
        }
コード例 #9
0
        static public void AddUserLog(SqlConnection connection, LogKey key, DateTime?date, String source, UserLogLevel level, Int64 proxyId, Int64 enterpriseId, Int64 contextId, Int64 resourceId, Int64 pluginId, Int64 entityId, Int64 identityId, String text, String additionalData, Int64 executedByEntityId, SqlTransaction transaction)
        {
            SqlBase st = new SqlBase();

            try
            {
                st.AddUserLog(connection, key, date, source, level, proxyId, enterpriseId, contextId, resourceId, pluginId, entityId, identityId, text, additionalData, executedByEntityId, transaction);
            }
            finally
            {
                st = null;
            }
        }