set到最后一条审批意见(docid 及意见参数)
function setAttitude(docid,dValue){
var dName = sys_function.DATASOURCENAME;
var updateRel = " UPDATE T_RELATIONHIS SET ATTITUDE ='"+dValue+"'";
updateRel += " WHERE PROCESSTIME = ";
updateRel += "(SELECT MAX(PROCESSTIME) T_RELATIONHIS WHERE DOCID = '"+docid+"')";
updateRel += " AND DOCID = '"+docid+"'";
updateByDSName(dName,updateRel);
var updateAtt = " UPDATE T_ACTORHIS SET [ATTITUDE] = '"+dValue+"' ";
updateAtt += " WHERE PROCESSTIME = ";
updateAtt += " (SELECT MAX(PROCESSTIME) FROM T_ACTORHIS ";
updateAtt += " WHERE DOC_ID = '"+docid+"' ";
updateAtt += " AND FLOWSTATERT_ID = (SELECT ID FROM T_FLOWSTATERT WHERE DOCID = '"+docid+"')) ";
updateAtt += " AND FLOWSTATERT_ID = (SELECT ID FROM T_FLOWSTATERT WHERE DOCID = '"+docid+"') ";
updateByDSName(dName,updateAtt);
}
文档更新时间: 2023-09-16 06:51 作者:admin