#region 数据表DataTable 转键值对集合 List
/// <summary>
/// 数据表DataTable 转键值对集合 List
/// 把DataTable转成 List集合, 存每一行
/// 集合中放的是键值对字典,存每一列
/// </summary>
/// <param name="dt">数据表</param>
/// <returns>哈希表数组</returns>
public static List<Dictionary<string, object>> DataTableToList(DataTable dt)
{
List<Dictionary<string, object>> list= new List<Dictionary<string, object>>();
foreach (DataRow dr in dt.Rows)
{
Dictionary<string, object> dic = new Dictionary<string, object>();
foreach (DataColumn dc in dt.Columns)
{
dic.Add(dc.ColumnName, dr[dc.ColumnName]);
}
list.Add(dic);
}
return list;
}
#endregion
#region 数据集转键值对数组字典
/// <summary>
/// 数据集转键值对数组字典
/// </summary>
/// <param name="dataSet">数据集</param>
/// <returns>键值对数组字典</returns>
public static Dictionary<string, List<Dictionary<string, object>>> DataSetToDic(DataSet ds)
{
Dictionary<string, List<Dictionary<string, object>>> result = new Dictionary<string, List<Dictionary<string, object>>>();
foreach (DataTable dt in ds.Tables)
result.Add(dt.TableName, DataTableToList(dt));
return result;
}
#endregion
#region 数据表Tables 转JSON
/// <summary>
/// 数据表转Tables JSON
/// </summary>
/// <param name="dataTable">数据表</param>
/// <returns>JSON字符串</returns>
public static string DataTableToJSON(DataTable dt)
{
return JsonHelper.ObjectToJSON(DataTableToList(dt));
}
#endregion
#region 将datatable转换为json
/// <summary>
/// 将datatable转换为json
/// </summary>
/// <param name="dtb">Dt</param>
/// <returns>JSON字符串</returns>
public static string Dtb2Json(DataTable dtb)
{
System.Collections.ArrayList dic = new System.Collections.ArrayList();
foreach (DataRow dr in dtb.Rows)
{
System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
foreach (DataColumn dc in dtb.Columns)
{
drow.Add(dc.ColumnName, dr[dc.ColumnName]);
}
dic.Add(drow);
}
return null;
}
#endregion
#region 将Dictionary转换为数据表数据 Tables
public static DataTable DictToDataTable(Dictionary<string, object> dict)
{
DataTable dt = new DataTable();
foreach (var colName in dict.Keys)
{
dt.Columns.Add(colName, typeof(string));
}
DataRow dr = dt.NewRow();
foreach (KeyValuePair<string, object> item in dict)
{
dr[item.Key] = item.Value;
}
dt.Rows.Add(dr);
return dt;
}
#endregion
#region 将List转换为数据表数据 Tables
/// <summary>
/// List转DataTable
/// </summary>
public static DataTable ListToDataTable<T>(List<T> list)
{
if (list == null || list.Count == 0)
{
return new DataTable();
}
//获取T下所有的属性
Type entityType = list[0].GetType();
PropertyInfo[] entityProperties = entityType.GetProperties();
DataTable dt = new DataTable("data");
for (int i = 0; i < entityProperties.Length; i++)
{
dt.Columns.Add(entityProperties[i].Name);
}
foreach (var item in list)
{
if (item.GetType() != entityType)
{
throw new Exception("要转换集合元素类型不一致！");
}
//创建一个用于放所有属性值的数组
object[] entityValues = new object[entityProperties.Length];
for (int i = 0; i < entityProperties.Length; i++)
{
entityValues[i] = entityProperties[i].GetValue(item, null);
}
dt.Rows.Add(entityValues);
}
return dt;
}
#endregion
#region Json 字符串 转换为 DataTable数据集合 简要版，正在使用中
/// <summary>
/// Json 字符串 转换为 DataTable数据集合 简要版，正在使用中
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
///
//格式;
//[{"mac":"20:f1:7c:c5:cd:80","rssi":"-86","ch":"9"},{"mac":"20:f1:7c:c5:cd:85","rssi":"-91","ch":"9"}]
public static DataTable ToDataTableTwo(string json)
{
DataTable dataTable = new DataTable(); //实例化
DataTable result;
try
{
List<Dictionary<string, object>> arrayList = JsonHelper.JSONToObject<List<Dictionary<string, object>>>(json);
if (arrayList != null && arrayList.Count > 0)
{
foreach (Dictionary<string, object> dictionary in arrayList)
{
if (dictionary.Keys.Count == 0)
{
result = dataTable;
return result;
}
if (dataTable.Columns.Count == 0)
{
foreach (var current in dictionary)
{
if (current.Value != null)
{
dataTable.Columns.Add(current.Key, current.Value.GetType());
}
else
{
dataTable.Columns.Add(current.Key);
}
}
}
DataRow dataRow = dataTable.NewRow();
foreach (string current in dictionary.Keys)
{
if (dictionary[current] != null)
{
dataRow[current] = dictionary[current];
}
}
dataTable.Rows.Add(dataRow); //循环添加行到DataTable中
}
}
}
catch (Exception ex)
{
throw ex;
}
result = dataTable;
return result;
}
#endregion
