.net 反射实例

/// <summary>        /// 分页查询；函数中，存储过程参数含义见接口文档        /// </summary>        /// <param name="table_Name">表或视图名</param>        /// <param name="Fields">字段列表,“*”为全部字段</param>        /// <param name="limit_Condition">where条件（不用带where）</param>        /// <param name="order_By">排序关键字（不用带order by）</param>        /// <param name="order_Direction">查询顺序（升序asc或降序desc）</param>        /// <param name="page_Size">每页显示条数</param>        /// <param name="current_Page">当前页码</param>        /// <returns>返回一个数据集</returns>        public List<Model.Ppt> Select(string table_Name, string Fields, string limit_Condition, string order_By, string order_Direction, int page_Size, int current_Page)        {            SqlParameter[] para = new SqlParameter[7];

            para[0] = new SqlParameter("@TableName", table_Name);            para[1] = new SqlParameter("@ReFieldsStr", Fields);            para[2] = new SqlParameter("@OrderString", order_By);            para[3] = new SqlParameter("@OrderDirection", order_Direction);            para[4] = new SqlParameter("@WhereString", limit_Condition);            para[5] = new SqlParameter("@PageSize", page_Size);            para[6] = new SqlParameter("@PageIndex ", current_Page);

            List<Model.Ppt> list = new List<Model.Ppt>();            Model.Ppt model = new Model.Ppt();            int fieldNum = 18;            PropertyInfo[] infos = model.GetType().GetProperties();            string[] field = Fields.Split(',');

            using (SqlDataReader reader = SQLHelper.ExecuteReader(conn, CommandType.StoredProcedure, "PROCE_PAGECHANGE", para))            {                while (reader.Read())                {                    model = new Model.Ppt();                    foreach (string fName in field)                    {                        for (int i = 0; i < fieldNum;i++ )                        {                            if ("*" == fName)                            {                                if (infos.PropertyType == Type.GetType("Systerm.String"))                                {                                    if (DBNull.Value != reader[infos.Name])                                    infos.SetValue(model, (string)reader[infos.Name], null);

                                }

if (infos.PropertyType == Type.GetType("System.Int32"))                                {                                    if (DBNull.Value != reader[infos.Name])                                    infos.SetValue(model, (int)reader[infos.Name], null);                                }                                if (infos.PropertyType == Type.GetType("System.Double"))                                {                                    if (DBNull.Value != reader[infos.Name])                                    infos.SetValue(model, (double)reader[infos.Name], null);                                }                                if (infos.PropertyType == Type.GetType("System.Boolean"))                                {                                    if (DBNull.Value != reader[infos.Name])                                    infos.SetValue(model, (bool)reader[infos.Name], null);                                }

                                if (infos.PropertyType == Type.GetType("System.DateTime"))                                {                                    if (DBNull.Value != reader[infos.Name])                                    infos.SetValue(model, (DateTime)reader[infos.Name], null);                                }                            }                            else                            {                                if (infos.Name == fName)                                {                                    if (infos.PropertyType == Type.GetType("Systerm.String"))                                    {                                        if (DBNull.Value!=reader[fName])                                        infos.SetValue(model, (string)reader[fName], null);                                    }                                    if (infos.PropertyType == Type.GetType("System.Int32"))                                    {                                        if (DBNull.Value != reader[fName])                                        infos.SetValue(model, (int)reader[fName], null);                                    }if (infos.PropertyType == Type.GetType("System.Double"))                                    {                                        if (DBNull.Value != reader[fName])                                        infos.SetValue(model, (double)reader[fName], null);                                    }                                    if (infos.PropertyType == Type.GetType("System.Boolean"))                                    {                                        if (DBNull.Value != reader[fName])                                        infos.SetValue(model, (bool)reader[fName], null);                                    }

                                    if (infos.PropertyType == Type.GetType("System.DateTime"))                                    {                                        if (DBNull.Value != reader[fName])                                        infos.SetValue(model, (DateTime)reader[fName], null);                                    }                                }                            }                        }                    }

                    list.Add(model);                }            }            return list;

        }