/**ѡű*/

//ȡ
function getRegionOptions(isSearch) {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='region'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("region");
		var dst_code = doc.getItemValueAsString("regionid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ȡֹ˾
function getBranchOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='branch'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("branchname");
		var dst_code = doc.getItemValueAsString("branchid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ȡ´
function getOfficeOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='office'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("officename");
		var dst_code = doc.getItemValueAsString("officeid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ȡ

function getDealernatureOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='dealernature'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("dealernature");
		var dst_code = doc.getItemValueAsString("dealernatureid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ȡʽ
function getResultssectionOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='resultssection'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("resultssection");
		var dst_code = doc.getItemValueAsString("resultssectionid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ȡƷƷ
function getProducttypeOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='producttype'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("producttype");
		var dst_code = doc.getItemValueAsString("producttypeID");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ȡ
function getExpensetypeOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='expensetype'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("expensetype");
		var dst_code = doc.getItemValueAsString("expensetypeID");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//ȡƷ
function getProOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='productlevel'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("productlevel");
		var dst_code = doc.getItemValueAsString("productlevelID");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//ȡб
function getOptions(formName,fieldName,fieldId) {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='"+formName+"'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString(fieldName);
		var dst_code = doc.getItemValueAsString(fieldId);
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//ݿͻÿͻϢ
function getCustomerInfo(fieldName, codeField) {
	var dql = "$formname='customers' and customercode ='" + getItemValue(codeField) + "'";
	var datas = findByDQL(dql);
	var returnValue = datas.getItemValueAsString(fieldName);
	return returnValue;
}

//ȡù
function getCostsattributableOptions() {
	var opts = $TOOLS.createOptions();
	    opts.add("", "");
	var dql = "$formname='costsattributable'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("costsattributable");
		var dst_code = doc.getItemValueAsString("costid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}//ȡ֯
function getOrganizationOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='organization'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("organizationname");
		var dst_code = doc.getItemValueAsString("organizationid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ȡģ
function getTemplateOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='template'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("templatename");
		var dst_code = doc.getItemValueAsString("templateid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}

//ƷƷ༯
function getBrandOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='brand'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("brandname");
		var dst_code = doc.getItemValueAsString("brandid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//װߴ༯
function getPackingsizeOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='packingsize'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("packingsizename");
		var dst_code = doc.getItemValueAsString("packingsizeid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//ζ༯
function getTasteOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='taste'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("tastename");
		var dst_code = doc.getItemValueAsString("tasteid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//ۼ
function getPromotionsOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='promotions'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("promotionsname");
		var dst_code = doc.getItemValueAsString("promotionsid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//װ༯
function getPortfolioOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='portfolio'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("portfolioname");
		var dst_code = doc.getItemValueAsString("portfolioid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//װʽ༯
function getPackingOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='packing'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("packingname");
		var dst_code = doc.getItemValueAsString("packingid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//۷ʽ༯
function getSalestypeOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='salestype'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("salestypename");
		var dst_code = doc.getItemValueAsString("salestypeid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}
//ƻ༯
function getPlancategoryOptions(){
    var opts = $TOOLS.createOptions();
	opts.add("","");
	var dql ="$fromname ='plancategory'";
	var docs = queryByDQL(dql);
	for (var iter = docs.iterator(); iter.hasNext();) {
		var doc = iter.next();
		var dst_name = doc.getItemValueAsString("plancategoryname");
		var dst_code = doc.getItemValueAsString("plancategoryid");
		opts.add(dst_name, dst_code);
	}
	return opts;
}