一个案例:参考
string html = "";
html += "<table style='width: 100%;'><thead>";
html += "<tr><th style='border:1px solid black; '>代表处</th><th style='border:1px solid black; '>省份</th><th style='border:1px solid black; '>地市</th><th style='border:1px solid black;'>代理商</th>";
foreach (var item in bartitle)
{
html += "<th style='border:1px solid black; '>" +
item.B_item_code +
"</th>";
}
html += "</tr></thead><tbody>";
foreach (var item in sales)
{
html += "<tr>";
html += "<td style='border:1px solid black;'>" + item.regionname + "</td><td style='border:1px solid black;'>" + item.PROVINCENAME + "</td><td style='border:1px solid black; '>" + item.cityname + "</td><td style='border:1px solid black; '>" + item.COMPANYNAME + "</td>";
string sal = item.COMPANYNAME;
foreach (var title in bartitle)
{
var tab = barcode.Where(o => o.RESELLER_NAME == sal && o.B_item_code == title.B_item_code).ToList();
html += "<td style='border:1px solid black; '>" + tab.Count() + "</td>";
}
html += "</tr>";
}
html += "</tbody></table>";
return Json(html);