Beispiel #1
0
        /// <summary>
        ///     执行Sql语句返回DataTable
        /// </summary>
        /// <param name="sql">SQL语句</param>
        /// <param name="dbName">操作的数据库名</param>
        /// <returns>SQL语句查询结果集</returns>
        public static DataSet ProcessMultiSql(string sql, string dbName)
        {
            PersistenceBroker broker = PersistenceBroker.Instance();
            IDbCommand        cmd    = broker.GetCommand(dbName);

            cmd.CommandTimeout = 120;
            cmd.CommandText    = sql;
            Logger.Write(sql);   //add by duhu
            return(broker.ExecuteMultiQuery(cmd, dbName));
        }