// to fix bug 2495
private String getTable(TSendInfoBO tSendInfoBO) {
StringBuilder s1 = new StringBuilder(100);
try { // bug 0003895 0003898 0003046
List<TInstanceInfoBO> list =
orderDao.findService2InstanceByOrderId(tSendInfoBO.getOrderId(), tSendInfoBO.getType());
s1.append("<table id=\"mytable\" cellspacing=\"0\"><caption> </caption>");
if (list.size() != 0) { // bug 0003884
s1.append("<tr>");
s1.append("<th scope=\"col\">服 务</th>");
s1.append("<th scope=\"col\">资 源</th>");
s1.append("<th scope=\"col\">类 型</th>");
s1.append("</tr>");
} // fix bug 0002495
for (TInstanceInfoBO info : list) {
s1.append("<tr>");
s1.append("<td class=\"row\">" + info.getServiceName() + "</td>");
s1.append("<td class=\"row\">" + info.getInstanceName() + "</td>");
s1.append("<td class=\"row\">" + info.getTemplateName() + "</td>");
s1.append("</tr>");
}
s1.append("</table>");
} catch (SQLException e) {
e.printStackTrace();
}
return s1.toString();
}
// to fix bug 2495
private String setMailMessage(TSendInfoBO tSendInfoBO) throws SQLException {
StringBuilder sb = new StringBuilder(500);
try {
TUserBO auditor = orderDao.getAuditorByOrderId(tSendInfoBO.getOrderId());
TOrderBO order = orderDao.searchOrderById(tSendInfoBO.getOrderId());
// fix bug 2495
sb.append(
"<br />"
+ order.getCreateUserName()
+ " 您好，您的订单"
+ getAuditStr(tSendInfoBO)
+ "，具体订单信息如下：");
// fix bug 2495
sb.append("<br />订单号为：" + tSendInfoBO.getOrderId() + "");
sb.append("<br />包含以下服务内容：<br />" + getTable(tSendInfoBO));
sb.append("<br />订单类型：" + getOrderType(tSendInfoBO) + "");
sb.append("<br />当前审批人为：" + auditor.getName() + "");
sb.append("<br />操作时间：" + auditor.getCreateDt().toString().replace(".0", "") + "");
if (tSendInfoBO.getState() == 1) { // 审核拒绝
sb.append("<br />审批不通过原因：" + tSendInfoBO.getApproveReason() + "");
sb.append("<br />您可以重新选择其他服务进行申请，如有问题请登录自服务门户查询，谢谢您选择我们的云平台");
}
if (tSendInfoBO.getState() == 2) { // 审核通过
// to fix bug:2853
String desc = "";
if (tSendInfoBO.getType() == 1) { // 新申请
desc = "已经审核通过，敬请耐心等待服务开通使用，如有问题请登录自服务门户查询，谢谢您选择我们的云平台。";
} else if (tSendInfoBO.getType() == 2) { // 修改
desc = "修改审核已通过，请等待开通使用，谢谢。";
} else if (tSendInfoBO.getType() == 3) { // 退订
desc = "退订审核已通过，服务即将关闭，谢谢。";
}
sb.append("<br />" + desc);
}
} catch (Exception e) {
e.printStackTrace();
}
return sb.toString();
}