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