分享一个获取List<model>的dbHelper类部分代码。

 public static class GetGenericObject<T, K>
        where T : new()
        where K : IDataReader
    {
        /// <summary>
        /// 返回对象
        /// </summary>
        /// <param name="dataReader"></param>
        /// <returns></returns>
        public static T GetObject(K dataReader)
        {
            T newInstance = Activator.CreateInstance<T>();
            if (dataReader.Read())
            {
                SetModelValue(dataReader, newInstance);
            }
            dataReader.Close();
            return newInstance;
        }


        /// <summary>
        /// 返回列表。
        /// </summary>
        /// <param name="dataReader"></param>
        /// <returns></returns>
        public static IList<T> GetObjectList(K dataReader)
        {
            IList<T> objectLists = new List<T>();
            while (dataReader.Read())
            {
                T newInstance = Activator.CreateInstance<T>();
                SetModelValue(dataReader, newInstance);

                objectLists.Add(newInstance);
            }
            dataReader.Close();

            return objectLists;
        }

        private static void SetModelValue(K dataReader, T newInstance)
        {
            Type type = newInstance.GetType();
            PropertyInfo[] properties = type.GetProperties();
            foreach (PropertyInfo pi in properties)
            {
                if (CheckDataReader(dataReader, pi.Name))
                    pi.SetValue(newInstance, dataReader[pi.Name], null);
            }
        }

        private static bool CheckDataReader(K dataReader, string fieldName)
        {
            int fields = dataReader.FieldCount;
            bool state = false;
            for (int i = 0; i < fields; i++)
            {
                if (dataReader.GetName(i) == fieldName)
                    if (dataReader[i] != null && dataReader[i] != DBNull.Value)
                        state = true;
            }
            return state;
        }

    }

该回复于2011-12-14 09:09:37被管理员删除

该回复于2011-12-14 09:34:08被管理员删除

PropertyInfo[] properties = type.GetProperties();
while (dataReader.Read())
{
.....
}