62,016
社区成员
发帖
与我相关
我的任务
分享
<table cellspacing="0" cellpadding="0" class="table_border" width="100%" style='text-align: center;'>
<head>
<style type="text/css">
table
{
border-collapse: collapse;
border: none;
width: 200px;
}
td
{
border: solid #000 1px;
}
</style>
</head>
<tr height='32' style='text-align: center; background: #99ccff; font-weight: bolder;'>
<td colspan="11" style="font-size: 15pt;">
测试
</td>
</tr>
<tr height='32' style='text-align: center; background: silver; font-weight: bolder;'>
<td style='text-align: center;' width='80px'>
<nobr>所属区域</nobr>
</td>
<td style='text-align: right;'>
<nobr>所属公司</nobr>
</td>
<td style='text-align: right;'>
<nobr>所属项目</nobr>
</td>
</tr>
<tr style='text-align: center; background: white; font-weight: bolder;' height='32'
height='28'>
<td rowspan='3'>
北方区
</td>
<td rowspan='2'>
大连公司
</td>
<td>
A项目
</td>
</tr>
<tr>
<td>B项目</td>
</tr>
<tr>
<td>沈阳公司</td>
<td>C项目</td>
</tr>
</table>
foreach (DataRow dtRegionRow in dtRegion.Rows)
{
//strHtml += "<tr style=\"background-color:#ffffff;text-align:left;height:25px;\">";
strHtml += "<tr style='text-align:center;background:white;font-weight:bolder;' height='32' height='28'>";
strHtml += "<td rowspan='" + Convert.ToInt32(dtRegionRow["countNum"]) * 2 + "'>" + dtRegionRow["RegionName"].ToString() + "</td>";
dtCompany.DefaultView.RowFilter = "RegionName='" + dtRegionRow["RegionName"].ToString() + "'";
int count_1 = 0;
foreach (DataRow dtCompanyRow in dtCompany.DefaultView.ToTable().Rows)
{
count_1++;
if(count_1>1)
{
strHtml += "<tr style='text-align:center;background:white;font-weight:bolder;' height='32' height='28'>";
}
strHtml += "<td rowspan='" + Convert.ToInt32(dtCompanyRow["countNum"])*2 + "'>" + dtCompanyRow["UnitName"].ToString() + "</td>";
int count_2=0;
dtProject.DefaultView.RowFilter="UnitID='"+dtCompanyRow["UnitID"].ToString()+"'";
foreach (DataRow dtProjectRow in dtProject.DefaultView.ToTable().Rows)
{
count_2++;
if(count_2>1)
{
strHtml += "<tr style='text-align:center;background:white;font-weight:bolder;' height='32' height='28'>";
}
strHtml += "<td rowspan='" + Convert.ToInt32(dtProjectRow["countNum"]) * 2 + "'>" + dtProjectRow["ProjectName"].ToString() + "</td>";
int count_3=0;
dt.DefaultView.RowFilter="ProjectID='"+dtProjectRow["ProjectID"]+"'";
foreach(DataRow dtRow in dt.DefaultView.ToTable().Rows)
{
count_3++;
if(count_3>1)
{
strHtml += "<tr style='text-align:center;background:white;font-weight:bolder;' height='32' height='28'>";
}
strHtml += "<tr style='text-align:center;background:white;font-weight:bolder;' height='32' height='28'>" + GetWaringDate(GetDataTimeString1(dtRow["BuildStartTime"]), GetDataTimeString1(dtRow["FactBuildStartTime"]));
strHtml += GetWaringDate(GetDataTimeString1(dtRow["SalesTime"]), GetDataTimeString1(dtRow["FactSalesTime"]));
strHtml += GetWaringDate(GetDataTimeString1(dtRow["BuildEndTime"]), GetDataTimeString1(dtRow["FactBuildEndTime"]));
strHtml += GetWaringDate(GetDataTimeString1(dtRow["OccupationTime"]), GetDataTimeString1(dtRow["FactOccupationTime"])) + "</tr>";
if(count_3>1)
{
strHtml += "</tr>";
}
}
if(count_2>1)
{
strHtml += "</tr>";
}
}
if(count_1>1)
{
strHtml += "</tr>";
}
}
strHtml += "</tr>";;
}
strHtml += "</table>";
strHtml += "</div>";
return strHtml;
}
我是这样解决的