/// <summary>

     /// 实体转换辅助类

     /// </summary>

     public class ModelConvertHelper<T> where T : new()

     {

         /// <summary>

         /// List泛型转换DataTable.

         /// </summary>

         public DataTable ListToDataTable<T>(List<T> items)

         {

             var tb = new DataTable(typeof(T).Name);

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

             foreach (PropertyInfo prop in props)

             {

                 Type t = GetCoreType(prop.PropertyType);

                 tb.Columns.Add(prop.Name, t);

             }

             foreach (T item in items)

             {

                 var values = new object[props.Length];

                 for (int i = ; i < props.Length; i++)

                 {

                     values[i] = props[i].GetValue(item, null);

                 }

                 tb.Rows.Add(values);

             }

             return tb;

         }

         /// <summary>

         /// model转换DataTable

         /// </summary>

         /// <typeparam name="T"></typeparam>

         /// <param name="items"></param>

         /// <returns></returns>

         public DataTable ModelToDataTable<T>(T items)

         {

             var tb = new DataTable(typeof(T).Name);

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

             foreach (PropertyInfo prop in props)

             {

                 Type t = GetCoreType(prop.PropertyType);

                 tb.Columns.Add(prop.Name, t);

             }

             var values = new object[props.Length];

             for (int i = ; i < props.Length; i++)

             {

                 values[i] = props[i].GetValue(items, null);

             }

             tb.Rows.Add(values);

             return tb;

         }

         /// <summary>

         /// Determine of specified type is nullable

         /// </summary>

         public static bool IsNullable(Type t)

         {

             return !t.IsValueType || (t.IsGenericType && t.GetGenericTypeDefinition() == typeof(Nullable<>));

         }

         /// <summary>

         /// Return underlying type if type is Nullable otherwise return the type

         /// </summary>

         public static Type GetCoreType(Type t)

         {

             if (t != null && IsNullable(t))

             {

                 if (!t.IsValueType)

                 {

                     return t;

                 }

                 else

                 {

                     return Nullable.GetUnderlyingType(t);

                 }

             }

             else

             {

                 return t;

             }

         }

         /// <summary>

         /// DataTable转换泛型List

         /// </summary>

         /// <param name="dt"></param>

         /// <returns></returns>

         public static List<T> DataTableToList(DataTable dt)

         {

             // 定义集合

             List<T> ts = new List<T>();

             // 获得此模型的类型

             Type type = typeof(T);

             string tempName = "";

             foreach (DataRow dr in dt.Rows)

             {

                 T t = new T();

                 // 获得此模型的公共属性

                 PropertyInfo[] propertys = t.GetType().GetProperties();

                 foreach (PropertyInfo pi in propertys)

                 {

                     tempName = pi.Name;  // 检查DataTable是否包含此列    

                     if (dt.Columns.Contains(tempName))

                     {

                         // 判断此属性是否有Setter

                         if (!pi.CanWrite) continue;

                         object value = dr[tempName];

                         if (value != DBNull.Value)

                             pi.SetValue(t, value, null);

                     }

                 }

                 ts.Add(t);

             }

             return ts;

         }

         public static T DataTableToModel(DataTable dt)

         {

             // 定义实体

             T t = new T();

             // 获得此模型的类型

             Type type = typeof(T);

             string tempName = "";

             foreach (DataRow dr in dt.Rows)

             {

                 // 获得此模型的公共属性

                 PropertyInfo[] propertys = t.GetType().GetProperties();

                 foreach (PropertyInfo pi in propertys)

                 {

                     tempName = pi.Name;  // 检查DataTable是否包含此列    

                     if (dt.Columns.Contains(tempName))

                     {

                         // 判断此属性是否有Setter

                         if (!pi.CanWrite) continue;

                         object value = dr[tempName];

                         if (value != DBNull.Value)

                             pi.SetValue(t, value, null);

                     }

                 }

                 break;

             }

             return t;

         }

     }