添加打印记录
__K1gy9oHGDHtsf9235M5
__K1gy9oHGDHtsf9235M5
published
__HymZTsjvZx2bgHVouge
UTF-8
post
/comPrint/addPrintLog
json
" +cerId );
if (isNotNull(cerId)) {
var findCerSql = "SELECT ITEM_CERTIFICATENUM,ITEM_COMNAME,ITEM_LEGALNAME,ITEM_FZRQ,ITEM_SOURCE " +
" FROM tlk_license_information WHERE id='" + cerId + "'";
println("cerId ===============>" +cerId );
var userinfo = queryByDSName("baibaodunflow", findCerSql);
if (userinfo != null) {
var iterator = userinfo.iterator();
if (iterator.hasNext()) {
var map1 = iterator.next();//取值
xkzh = map1.get("ITEM_CERTIFICATENUM");
gsmc = map1.get("ITEM_COMNAME");
frmc = map1.get("ITEM_LEGALNAME");
fzrq = map1.get("ITEM_FZRQ");
source = map1.get("ITEM_SOURCE");
}
}
}
try {
var uuid = new Packages.cn.myapps.util.sequence.Sequence();
var sql="INSERT INTO `tlk_com_certificate_log`(`LASTMODIFIED`, `FORMNAME`, `CREATED`, `FORMID`, `ISTMP`, " +
"`VERSIONS`, `APPLICATIONID`, `STATEINT`, `STATELABEL`, `AUDITORNAMES`, `DOMAINID`, `AUDITORLIST`," +
" `COAUDITORLIST`, `STATELABELINFO`,`ITEM_XKZH`, `ITEM_GSMC`, `ITEM_FRMC`, `ITEM_FZRQ`," +
" `ITEM_SOURCE`, `ITEM_CERTIFICATETYPE`, `ITEM_PRINTORGANIZATION`, `ITEM_PRINTPEOPLE`, `ITEM_PRINTDATE`," +
" `ID`) VALUES ("+
"NOW(),'许可证打印/打印记录/com_certificate_log',NOW(),'__O0KukwFDOgwspm8kwzg',0,'1','__K1gy9oHGDHtsf9235M5'," +
" '0', '', '','"+getDomainid()+"','{}', '{}'," +
"'[{\"nodes\":[{\"nodeId\":\"\",\"stateLabel\":\"\",\"state\":\"\",\"auditors\":[],\"coAuditors\":[]}]}]','"+
xkzh+"','"+gsmc+"','"+frmc+"','"+fzrq+"','"+source+"','"+certificateType+"','"+printOrganization+"','"+
printPeople+"','"+printDate+"','"+uuid.getSequence()+"--__O0KukwFDOgwspm8kwzg'"+
");";
println(sql);
insertByDSName("baibaodunflow",sql);
result.put("code", "1");
result.put("data", "添加成功");
result.put("msg", "success");
}catch (e){
result.put("code", "0");
result.put("data", "添加失败");
result.put("msg", e.message);
}
return result;
})()]]>