Пример #1
0
        /// <summary>
        /// 回傳Mapping後的物件列表
        /// </summary>
        /// <param name="dataReader"></param>
        /// <param name="method"></param>
        /// <returns></returns>
        public virtual IList <T> RowsMapping <T>(IDataReader dataReader, ParseToPOCO <T> method)
        {
            if (method == null)
            {
                throw new Exception("無指定轉型的指派方法可呼叫");
            }
            bool      hasData = false;
            IList <T> list    = new List <T>();

            do
            {
                T obj = default(T);
                if (hasData = method.Invoke(dataReader, out obj))
                {
                    list.Add(obj);
                }
            }while (hasData);
            if (list.Count == 0)
            {
                return(null);
            }
            else
            {
                return(list);
            }
        }
Пример #2
0
        /// <summary>
        /// 執行sqlcommand的ExecuteReader並讓外部帶入委派方法來轉成自訂型別物件
        /// </summary>
        /// <typeparam name="T">外部所要轉的物件類別</typeparam>
        /// <param name="cmd"></param>
        /// <param name="parsePOCO_method">轉物件用的委派方法</param>
        /// <param name="paras"></param>
        /// <returns></returns>
        public virtual IList <T> Execute_ReaderToPOCO <T>(IDbCommand cmd, ParseToPOCO <T> parsePOCO_method, IDbDataParameter[] paras = null)
        {
            IList <T> list = null;

            this.Set_Parameters(cmd, paras);
            using (IDataReader reader = cmd.ExecuteReader())
            {
                list = RowsMapping <T>(reader, parsePOCO_method);
            }
            return(list);
        }