你好,可以参考以下方法
(function() {
var doc = getCurrentDocument();
var docId = doc.getId();
var statelabel = doc.getStateLabel();
if(isNotNull(statelabel) && "回访反馈".equals(statelabel)) {
var sql = " SELECT DOMAINID FROM TLK_SZXM_APPLICATION_MD_DETAIL WHERE PARNET='"+ getId() +"' AND ITEM_VISIT_MODE IS NULL "
sql += " UNION ALL ";
sql += " SELECT DOMAINID FROM TLK_SZXM_APPLICATION_MD_DETAIL WHERE PARNET='"+ getId() +"' AND ITEM_VISIT_DATE IS NULL "
var count = countBySQL(sql);
if(count > 0) {
return "回访方式、回访时间必填!";
}
}
})(); |