DataTable纵向记录转换成横向列显示，动态新增列及填充数据

DataTable dt = Maticsoft.DBUtility.DbHelperOra.Query(QuerySql).Tables[0];

#region 创建新的DataTable   
DataTable dtShow = new DataTable();  
dtShow.Columns.Add("序号", Type.GetType("System.String"));  
dtShow.Columns.Add("部门", Type.GetType("System.String"));  
dtShow.Columns.Add("编号", Type.GetType("System.String"));  
dtShow.Columns.Add("姓名", Type.GetType("System.String"));  
  
dtShow.Columns.Add("职务", Type.GetType("System.String"));  
dtShow.Columns.Add("期间", Type.GetType("System.String"));  
dtShow.Columns.Add("开始日期", Type.GetType("System.String"));  
dtShow.Columns.Add("结束日期", Type.GetType("System.String"));  
  
//加载帐套的薪资项 转换成列   
DataTable dtCover = GetCoverItemDT();  
if (dtCover.Rows.Count > 0)  
{  
    for (int i = 0; i < dtCover.Rows.Count; i++)  
    {  
        dtShow.Columns.Add(dtCover.Rows[i]["ITEMNAME"].ToString(), Type.GetType("System.String"));  
    }  
}  
#endregion  
 
#region 插入员工薪资项数据到dtShow   
int p = 1; //行号   
for (int n = 0; n < dt.Rows.Count; n++)  
{  
    string EMPLOYEEID = dt.Rows[n]["EMPLOYEEID"].ToString();  
    //判断是否最末一行     
    string CompareEMPLOYEEID = (n == dt.Rows.Count - 1) ? "000000" : dt.Rows[n + 1]["EMPLOYEEID"].ToString();  
    if (CompareEMPLOYEEID != EMPLOYEEID) //比较当前行与下行ID 不同ID 则添加本行数据     
    {  
        DataRow dr = dtShow.NewRow();  
        dr["序号"] = p;  
        dr["部门"] = dt.Rows[n]["EMPLOYDEP"];  
        dr["编号"] = dt.Rows[n]["EMPLOYEEID"];  
        dr["姓名"] = dt.Rows[n]["EMPLOYEENAME"];  
  
        dr["职务"] = dt.Rows[n]["POST"];  
        dr["期间"] = dt.Rows[n]["CYCLENAME"];  
        dr["开始日期"] = dt.Rows[n]["CYCLESTARTDATE"];  
        dr["结束日期"] = dt.Rows[n]["CYCLEENDDATE"];  
        for (int j = 0; j < dtShow.Columns.Count; j++)  
        {  
            DataRow[] dr1 = dt.Select("EMPLOYEEID='" + EMPLOYEEID + "' AND ITEMNAME='" + dtShow.Columns[j].ColumnName + "'");  
            if (dr1.Length > 0)  
            {  
                dr[dtShow.Columns[j].ColumnName] = dr1[0]["AMOUNT"].ToString();  
            }  
        }  
        dtShow.Rows.Add(dr);  
        p++;  
    }  
}  
#endregion

 

转载于:https://my.oschina.net/smartsmile/blog/815038