foreach (var c in ColName<MarketViewModel>())
{
for (int i = 0; i < queryData.Count; i++)
{
var data = ModelToDictionary(queryData[i]);
if (dict.ContainsKey(c))
{
dict[c].Add(i.ToString(), data[c]);
}
else
{
dict.Add(c, new Dictionary<string, object>() { { i.ToString(), data[c] } });
}
}
}
List<string> ColName<T>()
{
List<string> colname = new List<string>();
var propts = typeof(MarketViewModel).GetProperties(BindingFlags.Instance | BindingFlags.Public);
foreach (var p in propts)
{
colname.Add(p.Name);
}
return colname;
}
Dictionary<string, object> ModelToDictionary<T>(T data)
{
Dictionary<string, object> dicts = new Dictionary<string, object>();
var propts = typeof(T).GetProperties(BindingFlags.Instance | BindingFlags.Public);
foreach (var p in propts)
{
var value = p.GetValue(data);
if (value == DBNull.Value)
{
dicts.Add(p.Name, null);
}
else
{
dicts.Add(p.Name, value);
}
}
return dicts;
}