|
|
本帖最后由 purple 于 2012-12-31 14:10 编辑
函数格式:
isExists (tableName, fieldName, description, value, andSQL)
函数说明:
tableName: 字段名
fieldName: 对比字段名
description :描述
value : 要判断字段名(可不传)
andSQL: 条件(可不传)
示例:
实现isExists(tableName, fieldName, description, value, andSQL)函数的应用
function isExists(tableName, fieldName, description, value, andSQL) {
var returnStr = "";
var fieldValue = "";
if (value) {
fieldValue = value;
} else {
fieldValue = getItemValue(fieldName);
}
var dql = "$formname='" + tableName + "' and " + fieldName + "='" + fieldValue + "'";
if (andSQL) {
dql += " and " + andSQL;
}
if (fieldValue != null && fieldValue.trim().length() > 0) {
var count = countByDQL(dql);
$PRINTER.println("===========count----------------" + count);
if (count <= 0) {
returnStr = "'" + description + "' 数据不存在!";
}
}
return returnStr;
}
调用
#include " validationlib";
isExists ("tableName"," fieldName"," description","value"," andSQL"); |
|