.net反射实例（优化后）

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>();            Hashtable hashValue = new Hashtable();            Model.Ppt model = new Model.Ppt();            object temp=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())                {                    hashValue = new Hashtable();                    temp = new Model.Ppt();                    foreach (string fName in field)                    {                        for (int i = 0; i < fieldNum; i++)                        {                            if ("*" == fName)                            {                                if (DBNull.Value != reader[infos.Name])                                {                                    hashValue.Add(infos.Name, reader[infos.Name]);                                    infos.SetValue(temp, hashValue[infos.Name], null);                                }                            }                            else                            {                                if (infos.Name == fName)                                {                                    if (DBNull.Value != reader[infos.Name])                                    {                                        hashValue.Add(infos.Name, reader[infos.Name]);                                        infos.SetValue(temp, hashValue[infos.Name], null);                                    }                                    break;                                }                            }                        }                    }                    list.Add((Model.Ppt)temp);                }            }            return list;        }