F/ADO/DB/ParameterResolve.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Data;
using System.Data.OracleClient;
//using Oracle.ManagedDataAccess.Client;
using System.Data.SQLite;
using MySql.Data.MySqlClient;
using System.Reflection;
using System.Data.Common;

namespace V.ADO
{
    /// <summary>
    /// 参数分解
    /// </summary>
    internal class ParameterResolve
    {
        #region 分解相关

        /// <summary>
        /// sql SqlParameter 方法
        /// </summary>
        /// <param name="ih">IHash</param>
        /// <returns>返回SqlParameter</returns>
        internal SqlParameter[] SqlPar(FHash ih)
        {
            if (ih == null) { return null; }
            FHash fh = ih; fh.Remove(":DBSET");

            SqlParameter[] pars = new SqlParameter[fh.Count];
            int i = 0;
            foreach (DictionaryEntry a in fh)
            {
                F.ADO.Model.SQLType st = SQLType(a.Value);
                SqlParameter sp = new SqlParameter();
                sp.ParameterName = a.Key.ToString();
                sp.Value = a.Value;

                if (st.sqltype != null)
                {
                    sp.SqlDbType = (SqlDbType)st.sqltype;
                }
                if (st.length > 0)
                {
                    sp.Size = st.length;
                }
                pars[i] = sp;
                i++;
            }
            return pars;
        }

        /// <summary>
        /// access OleDbParameter 方法
        /// </summary>