将实体的属性组合成字符串返回 ,可以修改成用于数据库插入的格式

  /// <summary>  
        /// 将实体的属性组合成字符串返回  ,可以修改成用于数据库插入的格式
        /// </summary>  
        /// <param name="enStudent"></param>  
        /// <returns></returns>  
        public static List<string> GetSql(Object model)
        {
            PropertyInfo[] fields = model.GetType().GetProperties();
            StringBuilder sb1 = new StringBuilder();
            StringBuilder sb2 = new StringBuilder();
            foreach (PropertyInfo pi in fields)
            {
                sb1.Append(pi.Name).Append(","); sb2.Append("'").Append(pi.GetValue(model, null)).Append("',");
            }
            string s1 = sb1.ToString().Substring(0, sb1.ToString().Length - 1);
            string s2 = sb2.ToString().Substring(0, sb2.ToString().Length - 1);
            List<string> s = new List<string>();
            s.Add(s1);
            s.Add(s2);
            return s;
        }