BobbyCore数据库切换/DBHelperSql.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using TbColAttribute;
using System.Reflection;
using System.Collections;
using System.Configuration;
using System.Data.Common;
using System.Data.OleDb;

namespace Wld.DBCore
{
    /// <summary>
    /// 移植到的数据库名称集
    /// </summary>
    public enum DataBaseType
    {
        SqlServer,
        Access,
        Oracle,
    }
    public class DBHelperSql
    {
        /// <summary>
        /// 数据库类型
        /// </summary>
        DataBaseType dbType = (DataBaseType)Enum.Parse(typeof(DataBaseType), ConfigurationManager.AppSettings["dbType"]);
        // Fields
        private DbSql db;

        // Methods
        public DBHelperSql()
        {
            this.db = new DbSql(dbType);
        }

        private List<DbParameter> GetOleDb(List<object> sp)
        {
            List<DbParameter> sqlparemeter = new List<DbParameter>();
            foreach (object item in sp)
            {
                sqlparemeter.Add((DbParameter)item);
            }
            return sqlparemeter;
        }

        public virtual int Delete(string tsql)
        {
            return this.db.ExecuteNonQuery(tsql);
        }

        public virtual int Delete<T>(string where) where T : new()
        {
            int result; 
            T tp = default(T);
            Type type = ((tp == null) ? Activator.CreateInstance<T>() : default(T)).GetType();
            try
            {