myApps查询选项并回显

myApps获取选项的脚本函数：

//查询选项  formname  key
function queryOptions(formname, key) {
	var opts = createOptions();
	opts.add("", "");
	var query = queryBySQLNoPage("select * from tlk_" + formname);
	if (query != null && query.size() > 0) {
		for (var it=query.iterator(); it.hasNext();) {
			var doc = it.next();
			opts.add(doc.getItemValueAsString(key), doc.getId());
		}
	}
	
	return opts;
}
function queryOptions2(formname, key, where) {
	var opts = createOptions();
	opts.add("", "");
	var query = queryBySQLNoPage("select * from tlk_" + formname + " " + where);
	if (query != null && query.size() > 0) {
		for (var it=query.iterator(); it.hasNext();) {
			var doc = it.next();
			opts.add(doc.getItemValueAsString(key), doc.getId());
		}
	}
	
	return opts;
}
function queryOptions3(formname, key, where) {//无空值的
	var opts = createOptions();
	var query = queryBySQLNoPage("select * from tlk_" + formname + " " + where);
	if (query != null && query.size() > 0) {
		for (var it=query.iterator(); it.hasNext();) {
			var doc = it.next();
			opts.add(doc.getItemValueAsString(key), doc.getId());
		}
	}
	
	return opts;
}

function queryWHOptions(formname, key) {
        var opts = "";
	var query = queryBySQLNoPage("select * from tlk_" + formname);
	if (query != null && query.size() > 0) {
		for (var it=query.iterator(); it.hasNext();) {
                        var doc = it.next();
			opts += ";" + doc.getItemValueAsString(key);
		}
	}
	return opts;
}

function queryWHOptions2(formname, key) {
        var opts = "";
	var query = queryBySQLNoPage("select * from tlk_" + formname);
	if (query != null && query.size() > 0) {
		for (var it=query.iterator(); it.hasNext();) {
			var doc = it.next();
			if (opts != "")
				opts += ";";
			opts += doc.getItemValueAsString(key);
		}
	}
	return opts;
}
function queryWHOptions3(formname, key, where) {
        var opts = "";
	var query = queryBySQLNoPage("select * from tlk_" + formname + " " + where);
	if (query != null && query.size() > 0) {
		for (var it=query.iterator(); it.hasNext();) {
			var doc = it.next();
			if (opts != "")
				opts += ";";
			opts += doc.getItemValueAsString(key);
		}
	}
	return opts;
}

用法示例：

#include "queryOptions" ;
queryWHOptions("Fm_Rate" , "Fd_Name");