Beispiel #1
0
        /**
         * @ 返回一个结果集合
         * */
        public List <SQLDataResult> ExecuteToDataResult()
        {
            List <SQLDataResult> dataList = null;

            try
            {
                base.ExecuteReader();
                DbDataReader reader = Context.DbReader;
                if (reader.HasRows == false)
                {
                    return(null);
                }
                reader.Read();
                do
                {
                    SQLDataResult result = new SQLDataResult();
                    int           len    = reader.FieldCount;

                    for (int i = 0; i < len; i++)
                    {
                        result.Add(reader.GetName(i), reader.GetValue(i));
                    }
                    dataList.Add(result);
                } while (Context.DbReader.Read());
            }
            finally
            {
                Dispose(false);
            }

            return(dataList);
        }
Beispiel #2
0
        /**
         * @ 获取 SQLDataResult 列表
         * */
        protected List <SQLDataResult> GetDataResult(DbDataReader reader)
        {
            List <SQLDataResult> list = new List <SQLDataResult>();

            try
            {
                if (reader == null || reader.HasRows == false)
                {
                    return(list);
                }
                do
                {
                    SQLDataResult result = new SQLDataResult();
                    int           len    = fields.Count();

                    for (int i = 0; i < len; i++)
                    {
                        result.Add(reader.GetName(i), reader.GetValue(i));
                    }
                    list.Add(result);
                } while (reader.Read());
            }
            finally
            {
                Dispose(false);
            }

            return(list);
        }