コード例 #1
0
ファイル: DbProvider4DAL.cs プロジェクト: ztshandong/WebApi
        internal DbProvider4DAL(string procedureName, ChooseDataBase chooseDataBase, DbProviderType dbProviderType)
        {
            CurrentDbProviderType = dbProviderType;
            CurrentChooseDataBase = chooseDataBase;

            CurrentCommand             = ProviderFactory.Instance.GetDbProviderFactory(dbProviderType).CreateCommand();
            CurrentCommand.CommandText = procedureName;
            CurrentCommand.CommandType = CommandType.StoredProcedure;

            CurrentDbDataAdapter = ProviderFactory.Instance.GetDbProviderFactory(dbProviderType).CreateDataAdapter();
            CurrentDbDataAdapter.SelectCommand = CurrentCommand;

            //_CurrentDbProviderType = dbProviderType;
            //_CurrentCommand = ProviderFactory.GetDbProviderFactory(dbProviderType).CreateCommand();
            ////_CurrentConnection = ProviderFactory.GetDbProviderFactory(dbProviderType).CreateConnection();
            //_CurrentDbDataAdapter = ProviderFactory.GetDbProviderFactory(dbProviderType).CreateDataAdapter();
            //_CurrentConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString;

            //_CurrentCommand.CommandType = CommandType.StoredProcedure;

            //_CurrentDbDataAdapter.SelectCommand = ProviderFactory.GetDbProviderFactory(dbProviderType).CreateCommand();
            //_CurrentDbDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
            ////_CurrentDbDataAdapter.InsertCommand = ProviderFactory.GetDbProviderFactory(dbProviderType).CreateCommand();
            ////_CurrentDbDataAdapter.UpdateCommand = ProviderFactory.GetDbProviderFactory(dbProviderType).CreateCommand();
            ////_CurrentDbDataAdapter.DeleteCommand = ProviderFactory.GetDbProviderFactory(dbProviderType).CreateCommand();

            ////_CurrentDbDataAdapter.InsertCommand.CommandType = CommandType.Text;
            ////_CurrentDbDataAdapter.UpdateCommand.CommandType = CommandType.Text;
            ////_CurrentDbDataAdapter.DeleteCommand.CommandType = CommandType.Text;
        }
コード例 #2
0
 /// <summary>
 /// 调用BLL之前检验UserKey属于哪个数据库,防止跨数据库访问
 /// </summary>
 /// <param name="chooseDataBase"></param>
 /// <returns></returns>
 internal string GetUserKeyAndDataBase(ChooseDataBase chooseDataBase)
 {
     return(CheckDataBase4UserKey[chooseDataBase]);
 }
コード例 #3
0
 internal string GetConnString(ChooseDataBase chooseDataBase)
 {
     return(Conn4StringDataBase[chooseDataBase]);
 }