C#.NET DataTable擴充 ToList/Get/OrderBy/Where/ToPage

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Reflection;
using System.Data;
using System.Data.Common;
using System.Web.Script.Serialization;
using System.IO;
using System.Security.Cryptography;

namespace Pub.Class {
public static class DataTableExtensions {

public static List<TResult> ToList<TResult>(this DataTable dt) where TResult : class,new() {   
            List<TResult> list= new List<TResult>();
if (dt == null) return list;
int len = dt.Rows.Count;

for (int i = 0; i < len; i++) {
                TResult info = new TResult();
foreach (DataColumn dc in dt.Rows[i].Table.Columns) {
if (dt.Rows[i][dc.ColumnName] == null || string.IsNullOrEmpty(dt.Rows[i][dc.ColumnName].ToString())) continue;
                    System.Reflection.PropertyInfo pi = info.GetType().GetProperty(dc.ColumnName);
                    pi.SetValue(info, dt.Rows[i][dc.ColumnName], null);
                }
                list.Add(info);
            }
            dt.Dispose(); dt = null;
return list;
        }   
public static DataTable OrderBy(this DataTable dt, string orderBy) {
            dt.DefaultView.Sort = orderBy;
return dt.DefaultView.ToTable();
        }
public static DataTable Where(this DataTable dt, string where) {
            DataTable resultDt = dt.Clone();
            DataRow[] resultRows = dt.Select(where);
foreach (DataRow dr in resultRows) resultDt.Rows.Add(dr.ItemArray);
return resultDt;
        }
public static List<TResult> OrderBy<TResult>(this DataTable dt, string orderBy) where TResult : class,new() {   
return dt.OrderBy(orderBy).ToList<TResult>();
        }
public static List<TResult> Where<TResult>(this DataTable dt, string where) where TResult : class,new() {   
return dt.Where(where).ToList<TResult>();
        }
public static List<TResult> ToPage<TResult>(this DataTable dt, int pageIndex,int pageSize,out int totalRecords) where TResult : class,new() {   
            totalRecords = dt.Rows.Count;
int startRow = (pageIndex - 1) * pageSize;
int endRow = startRow + pageSize;
if (startRow > totalRecords || startRow < 0) { startRow = 0; endRow = pageSize; }
if (endRow > totalRecords + pageSize) { startRow = totalRecords - pageSize; endRow = totalRecords; }

            DataTable dt2 = dt.Clone();
for (int i = startRow; i < endRow; i++) { if (i >= totalRecords) break; dt2.Rows.Add(dt.Rows[i].ItemArray); }

return dt2.ToList<TResult>();
        }

public static T Get<T>(this DataRow row, string field) { return row.Get<T>(field, default(T)); }
public static T Get<T>(this DataRow row, string field, T defaultValue) {
            var value = row[field];
if(value == DBNull.Value) return defaultValue;
return value.ConvertTo<T>(defaultValue);
        }
public static T Get<T>(this DataRowView row, string field) { return row.Get<T>(field, default(T)); }
public static T Get<T>(this DataRowView row, string field, T defaultValue) {
            var value = row[field];
if(value == DBNull.Value) return defaultValue;
return value.ConvertTo<T>(defaultValue);
        }

    } 
}