• GZFramework.DB.Core初始化


    单数据库初始化,以MSSQL为例

    public class DBConfig : IDBConfig
        {
            public static void InitDB()
            {
                GZFramework.DB.Core.Config.DBConfig = new DBConfig();
            }
    
            IDatabase db;
            public DBConfig()
            {
                string connectionstr = "Data Source=local;Initial Catalog=gzframework;User ID=sa;Password=xxxx";
    
                const string ProviderName = "System.Data.SqlClient";
                bool b = DatabaseFactory.Validate(connectionstr, ProviderName);
    
                db = DatabaseFactory.CreateDatabase(connectionstr, ProviderName);
            }
    
    
            public IDatabase GetDBConnectionInfo(string DBCode)
            {
                return db;
            }
    
            public void RefreshDBList()
            {
                
            }
    
            
        }

    MSSQL参数集合

    public class SqlParameterProvider : DbParameterBase
        {
    
            //DbParameter GenerateParmeter(string parameterName, object value);
    
            //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType);
    
            //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size);
    
            //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size, string sourceColumn);
            //protected abstract DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size, string sourceColumn, ParameterDirection direction);
    
            //DbParameter GenerateParmeter(string parameterName, SqlDbType dbType, int size, ParameterDirection direction, bool isNullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value);
    
            //DbParameter SqlParameter(string parameterName, SqlDbType dbType, int size, ParameterDirection direction, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, bool sourceColumnNullMapping, object value, string xmlSchemaCollectionDatabase, string xmlSchemaCollectionOwningSchema, string xmlSchemaCollectionName);
            public void AddParameter(string parameterName, object value)
            {
                SqlParameter parm = new SqlParameter(parameterName, value);
                AddParameter(parm);
            }
            public void AddParameter(string parameterName, SqlDbType dbType, object value)
            {
                SqlParameter parm = new SqlParameter(parameterName, dbType);
                parm.Value = value;
                AddParameter(parm);
            }
    
            public void AddParameter(string parameterName, SqlDbType dbType, int size, object value)
            {
                SqlParameter parm = new SqlParameter(parameterName, dbType, size);
                parm.Value = value;
                AddParameter(parm);
            }
            public void AddParameter(string parameterName, SqlDbType dbType, int size, object value, ParameterDirection direction)
            {
                SqlParameter parm = new SqlParameter(parameterName, dbType, size);
                parm.Value = value;
                parm.Direction = direction;
                AddParameter(parm);
            }
            public void AddParameter(string parameterName, SqlDbType dbType, int size, object value, string sourceColumn)
            {
                SqlParameter parm = new SqlParameter(parameterName, dbType, size, sourceColumn);
                parm.Value = value;
                AddParameter(parm);
            }
        }
    慎于行,敏于思!GGGGGG
  • 相关阅读:
    狄慧201771010104《面向对象程序设计(java)》第十六周学习总结
    狄慧201771010104《面向对象程序设计(java)》第十五周学习总结
    狄慧201771010104《面向对象程序设计(java)》第十四周学习总结
    201771030122-王瑞梅 实验二 个人项目—《西北师范大学学生疫情上报系统》项目报告
    201771030122-王瑞梅 实验一 软件工程准备—<初读《构建之法--现代软件工程》>
    软件工程学习总结
    团队项目在GitHub合作开发管理流程
    2020 软件工程—— 中期获“衣”有感
    201771010131-王之泰 实验四 软件项目案例分析
    数据库连接和导出excal
  • 原文地址:https://www.cnblogs.com/GarsonZhang/p/5412609.html
Copyright © 2020-2023  润新知