public static ArrayList TableToList(DataTable table, Func <string, object, object> ColValFormat, ColNameFormat ColNameFormat = ColNameFormat.Default) { ArrayList al = new ArrayList(); foreach (DataRow row in table.Rows) { al.Add(RowToCollection(row, ColValFormat)); } return(al); }
public static Dictionary <string, Object> RowToCollection(DataRow row, Func <string, object, object> ColValFormat, ColNameFormat ColNameFormat = ColNameFormat.Default) { Dictionary <string, Object> hst = new Dictionary <string, Object>(); foreach (DataColumn dc in row.Table.Columns) { if (ColValFormat != null) { hst.Add(dc.ColumnName, ColValFormat(dc.ColumnName, row[dc.ColumnName])); } else { hst.Add(dc.ColumnName, row[dc.ColumnName]); } } return(hst); }
/// <summary> /// 字段,值》序Json队形序列化支持 /// </summary> /// <param name="dt"></param> /// <returns></returns> public static ArrayList TableToList(DataTable table, ColNameFormat ColNameFormat = ColNameFormat.Default) { return(TableToList(table, null, ColNameFormat)); }
/// <summary> /// 行对象转换 /// </summary> /// <param name="dr"></param> /// <returns></returns> public static Dictionary <string, Object> RowToCollection(DataRow row, ColNameFormat ColNameFormat = ColNameFormat.Default) { return(RowToCollection(row, null, ColNameFormat)); }