Example #1
0
        /// <summary>
        /// 执行存储过程返回DbDataReader
        /// </summary>
        /// <param name="strSpName">SQL语句</param>
        /// <param name="arrParam">参数数组</param>
        /// <returns>DbDataReader</returns>
        public DbDataReader ExecuteDataReaderSp(string strSpName, List <DataParameter> arrParam)
        {
            string        begintime = DateTime.Now.ToString() + "  " + DateTime.Now.Millisecond.ToString();
            OracleCommand myComd    = GetOracleCommand(strSpName, arrParam);

            OpenConn();
            DfkDataReader dfkdr   = new DfkDataReader(myComd, myComd.ExecuteReader(CommandBehavior.CloseConnection));
            string        endtime = DateTime.Now.ToString() + "  " + DateTime.Now.Millisecond.ToString();

            return(dfkdr);
        }
Example #2
0
 /// <summary>
 /// 执行存储过程返回DbDataReader
 /// </summary>
 /// <param name="strSpName">SQL语句</param>
 /// <param name="arrParam">参数数组</param>
 /// <returns>DbDataReader</returns>
 public DbDataReader ExecuteDataReaderSp(string strSpName, List<DataParameter> arrParam)
 {
     string begintime = DateTime.Now.ToString() + "  " + DateTime.Now.Millisecond.ToString();
     OracleCommand myComd = GetOracleCommand(strSpName, arrParam);
     OpenConn();
     DfkDataReader dfkdr = new DfkDataReader(myComd, myComd.ExecuteReader(CommandBehavior.CloseConnection));
     string endtime = DateTime.Now.ToString() + "  " + DateTime.Now.Millisecond.ToString();
     return dfkdr;
 }