客户的解决方案如下:
var sql = "select item_客户名称,item_联系人,formid,domainid from tlk_公海资源 where item_机会等级='甲级客户'";
var docs = queryBySQL(sql);
var count=0;
var table = "<table border=\"0\" cellSpacing=\"0\" borderColor=\"#cccccc\" cellPadding=\"1\" width=\"100%\" align=\"center\">";
table += "<tbody>";
table += ' <tr><td style="text-align: left"></td>';
for (var it = docs.iterator(); it.hasNext();) {
var doc = it.next();
var s=count+"";
var jname = doc.getItemValueAsString("item_客户名称");
table += "<tr><td>" + jname + "</td> ";
count++;
}
table += "</tr> </tbody></table>";
table; |