通过id获取证书信息
__E90fgpplhOsklLI9mr4
__E90fgpplhOsklLI9mr4
published
__U0zK57yzOSmE3jxXfJD
UTF-8
post
/comPrint/findLicenseById
json
" );
var cerId = getParameter("id");
var result = new Packages.java.util.HashMap();
var xkzh="";
var gsmc="";
var frmc="";
var fzrq="";
var gsdz="";
var management="";
var clrq="";
var pzwh="";
println("cerId ===============>" +cerId );
if (isNotNull(cerId)) {
var findCerSql = "SELECT ITEM_CERTIFICATENUM as 'xkzh',ITEM_COMNAME as 'gsmc',ITEM_LEGALNAME as 'frmc'," +
"date_format(ITEM_FZRQ,'%Y-%m-%d') as 'fzrq',ITEM_COMADDRESS as 'gsdz',ITEM_FWFW as 'management'," +
"date_format(ITEM_CLRQ,'%Y-%m-%d') as 'clrq',ITEM_PZWH as 'pzwh' " +
" FROM tlk_companycertificate WHERE id='" + cerId + "'";
println("cerId ===============>" +cerId );
var userinfo = queryByDSName("securityflow", findCerSql);
if (userinfo != null) {
var iterator = userinfo.iterator();
if (iterator.hasNext()) {
var map1 = iterator.next();//取值
xkzh = map1.get("xkzh");
gsmc = map1.get("gsmc");
frmc = map1.get("frmc");
fzrq = map1.get("fzrq");
gsdz = map1.get("gsdz");
management = map1.get("management");
clrq = map1.get("clrq");
pzwh = map1.get("pzwh");
}
}
}
result.put("xkzh", xkzh);
result.put("gsmc", gsmc);
result.put("frmc", frmc);
result.put("fzrq", fzrq);
result.put("gsdz", gsdz);
result.put("management", management);
result.put("clrq", clrq);
result.put("pzwh", pzwh);
return result;
})()]]>