Exemplo n.º 1
0
        public static DataTable ProcessStoredProc(string storeProcName, IDataParameter[] param, string dbName)
        {
            IDbCommand        cmd    = Query.StoredProcCommand(storeProcName, param, dbName);
            PersistenceBroker broker = PersistenceBroker.Instance();

            return(broker.ExecuteQuery(cmd, dbName));
        }
        public static PersistenceBroker Instance()
        {
            if (null == m_Instance)
            {
                m_Instance = new PersistenceBroker();
            }

            return(m_Instance);
        }
Exemplo n.º 3
0
        public static DataTable ExecuteSQLQuery(string strSQL, string dbName, int timeout)
        {
            PersistenceBroker broker = PersistenceBroker.Instance();
            IDbCommand        cmd    = broker.GetCommand(dbName);

            cmd.CommandText = strSQL;
            if (timeout >= 0)
            {
                cmd.CommandTimeout = timeout;
            }

            return(broker.ExecuteQuery(cmd, dbName));
        }
Exemplo n.º 4
0
        public DataTable Execute()
        {
            StringWriter sql = new StringWriter();

            RenderSelect(sql);
            Assert.VerifyNotNull(sql, Error.NotNull);

            PersistenceBroker broker = PersistenceBroker.Instance();
            IDbCommand        cmd    = broker.GetCommand(m_ClassMap.Database.Name);

            cmd.CommandText = sql.ToString();
            DataTable dt = broker.ExecuteQuery(cmd, m_ClassMap.Database.Name);

            return(dt);
        }
Exemplo n.º 5
0
        private static IDbCommand StoredProcCommand(string storedProcName, IDataParameter[] param, string dbName)
        {
            PersistenceBroker broker = PersistenceBroker.Instance();
            IDbCommand        cmd    = broker.GetCommand(dbName);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = storedProcName;
            if (param != null)
            {
                for (int intlop = 0; intlop < param.Length; intlop++)
                {
                    IDataParameter parameter = param[intlop];
                    cmd.Parameters.Add(parameter);
                }
            }
            return(cmd);
        }
Exemplo n.º 6
0
        public static void SaveDataTable(DataTable dt, string tableName, string dbName, int timeout)
        {
            PersistenceBroker broker = PersistenceBroker.Instance();

            broker.SaveDataTable(dt, tableName, dbName, timeout);
        }
Exemplo n.º 7
0
        public static IDataParameter GetParameter(string dbName)
        {
            PersistenceBroker broker = PersistenceBroker.Instance();

            return(broker.GetCommand(dbName).CreateParameter());
        }
 public void DelDataSource(string dbName) => PersistenceBroker.Instance().DelDataSource(dbName);
 public void AddDataSource(string dbName, string dbType, string connectionString) => PersistenceBroker.Instance().AddDataSource(dbName, dbType, connectionString);
 public void ReInitialize()
 {
     PersistenceBroker.ClearPersistenceBroker();
     Initialize();
 }
 public void Initialize()
 {
     Assert.Verify(this.m_ApplicationContextFile != "", Error.XmlNotFound);
     PersistenceBroker.Initialize();
 }