下拉框考虑历史数据脚本示例-爱游戏

smart · 发表于 2020-12-10 17:05:32

/**
* 考虑历史数据：获取通用主数据类型返回options
* table:当前表名 docid：当前docid valuename:当前字段名 type：通用主数据的类型
*/
function getdatatype(table, docid, valuename, isnull) {
var opts = $tools.createoptions();
var sql1 = "select * from " table " where id='" docid "' ";
var data = findbysql(sql1);
var value1 = "";
if (data != null) {
value1 = data.getitemvalueasstring(valuename);
}
var sql = "select * from obpm_crm_new.tlk_客户状态 where item_status='有效' order by item_类别名称";
if (value1 != null && !"".equals(value1)) {
sql = "select * from obpm_crm_new.tlk_客户状态 where (item_status='有效') or (item_status='无效' and item_类别名称='" value1 "') order by item_类别名称";
}
if (isnull) {
opts.add("", "");
}
var query = querybysql(sql);
if (query != null && query.size() > 0) {
for (var it = query.iterator(); it.hasnext(); ) {
var doc = it.next();
var value = doc.getitemvalueasstring("类别名称");
var name = doc.getitemvalueasstring("类别名称");
opts.add(name, value);
}
}
return opts;
};

复制代码

		自动登录
密码			注册成为天翎用户