MARKUS

using Dapper;

using System;

using System.Collections;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Linq.Expressions;

using System.Reflection;

using System.Reflection.Emit;

using System.ComponentModel;

using System.Data.SqlTypes;

using System.Dynamic;

using System.Globalization;

using System.Text.RegularExpressions;

using System.Diagnostics;

namespace Markus.Service.DataBase

{

    public partial class QueryParameters : SqlMapper.IDynamicParameters

    {

        DBMSType DBMS;

        public QueryParameters(DBMSType dbms)

        {

            DBMS = dbms;

        }

        //////////////////////////////////////////////////////////////////////////////////////////////////// Field

        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>

        /// 동적 매개 변수 목록

        /// </summary>

        private readonly DynamicParameters dynamicParameters = new DynamicParameters();

        /// <summary>

        /// 오라클 매개 변수 리스트

        /// </summary>

        private readonly List<Npgsql.NpgsqlParameter> NpgsqlParameterList = new List<Npgsql.NpgsqlParameter>();

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 추가하기 - Add(name, value, dbType, direction, size)

        /// <summary>

        /// 추가하기

        /// </summary>

        /// <param name="name">명칭</param>

        /// <param name="value">값</param>

        /// <param name="dbType">DB 타입</param>

        /// <param name="direction">방향</param>

        /// <param name="size">크기</param>

        public void Add(string name, object value = null, DbType? dbType = null, ParameterDirection? direction = null, int? size = null)

        {

            if (DBMS == DBMSType.MSSQL)

            {

                this.dynamicParameters.Add(name, value, dbType, direction, size);

            }

            else

            {

                Npgsql.NpgsqlParameter parameter = new Npgsql.NpgsqlParameter(parameterName: name, parameterType: dbType)

                {

                    Direction = direction.GetValueOrDefault()

                };

                this.NpgsqlParameterList.Add(parameter);

            }

        }

        #endregion

        #region 추가하기 - Add(name, oracleDbType, direction)

        /// <summary>

        /// 추가하기

        /// </summary>

        /// <param name="name">명칭</param>

        /// <param name="oracleDbType">오라클 DB 타입</param>

        /// <param name="direction">방향</param>

        public void Add(string name, NpgsqlTypes.NpgsqlDbType dbType, ParameterDirection direction)

        {

            Npgsql.NpgsqlParameter parameter = new Npgsql.NpgsqlParameter(parameterName: name, parameterType: dbType)

            {

                Direction = direction

            };

            this.NpgsqlParameterList.Add(parameter);

        }

        #endregion

    }

}