/// <summary>
/// DataTable 转List(扩张方法)
/// </summary>
public static List<T> EList<T>(this DataTable dt, Func<DataRow, T> f)
{
return (from DataRow dr in dt.Rows select f(dr)).ToList();
}
用法:如
List<xxx> request = dt.EList(dr => new xxx
{
CustomerId = (dr["客户编号"]),
IsCash = IsCash,
TypeId = dr.GetValue<int>("会计科目编号"),
Batch = dr["单号"].ToString(),
Price = dr.GetValue<decimal>("金额"),
Date = dr.GetValue<DateTime>("日期"),
Instructionsa = dr["说明"].ToString(),
Note = "Excel导入"
});