/// <summary>

     /// 将List保存为Excel

     /// </summary>

     /// <typeparam name="T">保存的类类型</typeparam>

     /// <param name="lt">需要保存的源数据</param>

     /// <param name="fileName">保存的文件名称</param>

     /// <param name="fields">对应于类的字段名称</param>

     /// <param name="titles">对应于Excel的列名</param>

     public static void Save<T>(List<T> lt, string fileName, string[] fields, string[] titles)

     {

         if (lt == null || lt.Count == )

         {

             throw new ArgumentNullException("数据为空");

         }

         var sb = new StringBuilder();

         PropertyInfo[] props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);

         const string next = "\t";

         foreach (var title in titles)

         {

             sb.Append(title).Append(next);

         }

         var propertys = new List<PropertyInfo>();

         foreach (var field in fields)

         {

             foreach (PropertyInfo prop in props)

             {

                 if (prop.Name.Equals(field))

                 {

                     propertys.Add(prop);

                     break;

                 }

             }

         }

         sb.Append(Environment.NewLine);

         foreach (T item in lt)

         {

             foreach (var property in propertys)

             {

                 object value = property.GetValue(item, null);

                 if (property.PropertyType.BaseType == typeof(Enum))

                 {

                     sb.Append(GPMSKernel.Unility.Enums.GetEnumDescription(value));

                 }

                 else if (property.PropertyType == typeof(Boolean))

                 {

                     if ((bool)value)

                     {

                         sb.Append("是");

                     }

                     else

                     {

                         sb.Append("否");

                     }

                 }

                 else

                 {

                     sb.Append(value);

                 }

                 sb.Append(next);

             }

             sb.Append(Environment.NewLine);

         }

         fileName = string.Format("{0}_{1}.xls", DateTime.Now.ToString("yyMMddHHmmss"), fileName);

         HttpContext.Current.Response.ContentType = "application/octet-stream";

         //通知浏览器下载文件而不是打开

         HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;  filename=" + HttpUtility.UrlEncode(fileName, Encoding.UTF8));

         HttpContext.Current.Response.BinaryWrite(Encoding.UTF8.GetBytes(sb.ToString()));

         HttpContext.Current.Response.Flush();

         HttpContext.Current.Response.End();

     }