list<DataTable > 多行转换拼接为DataTable

 

 

  //新建datatable存放返回值
  
  DataTable ret = new DataTable();
   
  ret.Columns.Add("nodeid");
  
  ///
...　　在datatable中添加列
  ///
 ret.Columns.Add("opinion");
 ret.PrimaryKey = new DataColumn[] { ret.Columns["nodeid"] };//设置主键
 List<string> lst = new List<string>();//新建list存放已编辑的 主键
 for (int i = 0; i < dateList.Count; i++)//循环传入值
 {
 Hashtable ht = dateList[i];
string nodeid = ht["nodeid"].ToString();
 if (!lst.Contains(nodeid))//标记已编辑主键
 {
 lst.Add(nodeid);
 DataRow dr = ret.NewRow();
 dr["nodeid"] = nodeid;
 dr["actionname"] = ht["actionname"].ToString();
 dr["submittime"] = ht["submittime"].ToString();
 dr["nodename"] = ht["nodename"].ToString();
 SetVarToDataRow(ht, dr);
 ret.Rows.Add(dr);//追加到返回值中
 }
 else
 {
 DataRow dr = ret.Rows.Find(nodeid);//查找到已编辑过的行值
 SetVarToDataRow(ht, dr);
 }
 }
 ret.DefaultView.Sort = "submittime DESC";//排序
 DataView dataView = ret.DefaultView;
 ret = dataView.ToTable();
 return ret;
//根据key值标记编辑对应值
private static void SetVarToDataRow(Hashtable ht, DataRow dr)
{
switch (ht["key"].ToString())
{
case "opinion":
dr["opinion"] = ht["value"].ToString();
break;
case "checkusername":
dr["checkusername"] = ht["value"].ToString();
break;
case "checkuseragencyname":
dr["checkuseragencyname"] = ht["value"].ToString();
break;
case "checkuserpostname":
dr["checkuserpostname"] = ht["value"].ToString();
break;
default:
break;
}
}