dict.asp

来自「本系统是一套完整游戏金币交易平台,可以建立一个网站实现游戏金币的在线交易」· ASP 代码 · 共 83 行

<!--#include file="../fcDatabase/Database.asp"-->

<%
/*=========================================================================================
 * 字典类标签
 =========================================================================================*/
 /*
  * 业务代码选择标签提供将业务字典中的代码以selectOptions方式给用户选择
  * 参数: database-数据库对象, businTypeId-字典类型ID, initValue-初始值,用于缺省选择项
  */
function DICT_OPTIONS(database, businTypeId, initValue, privilege, status) {
	var db = database;
	var strSQL = "select BUSINID, BUSINNAME from BNDICT_T_DICTIONARY where BUSINTYPEID='" + businTypeId + "' ";
	if(privilege!=null) strSQL += " and PRIVILEGE=" + privilege + " ";
	if(status!=null) strSQL += " and STATUS='" + status + "' ";
	var rs = db.runQuerySql(strSQL);

	var htmlOptions = "";
	while(!rs.EOF) {
		var id = rs("BUSINID") + "";
		var name = rs("BUSINNAME") + "";
		if(id==initValue) 
			htmlOptions += "<option value=\"" + id + "\" selected>" + name + "</option>";
		else
			htmlOptions += "<option value=\"" + id + "\">" + name + "</option>";
		rs.MoveNext();
	}
	Response.Write(htmlOptions);
	
	rs.close();
	rs = null;
	//db.close();
}


 /*
  * 业务代码翻译标签,提供将业务代码翻译成中文描述的标签
  * 参数: database-数据库对象, businTypeId-字典类型ID, businessId-常量表示的业务代码，确定需要翻译的业务代码
  */
function DICT_WRITE(database, businTypeId, businessId) {
	var db = database;
	var strSQL = "select BUSINNAME from BNDICT_T_DICTIONARY where BUSINTYPEID='" + businTypeId + "' and BUSINID='" + businessId + "' ";
	var rs = db.runQuerySql(strSQL);
	
	if(!rs.EOF) {
		Response.Write(rs("BUSINNAME") + "");
	}
	else {
		if(businessId==null || businessId=="null")
			Response.Write("");	
		else
			Response.Write(businessId + "");
	}
	
	rs.close();
	rs = null;
}

/*
  * 业务代码翻译标签,提供将业务代码翻译成中文描述的函数
  * 参数: database-数据库对象, businTypeId-字典类型ID, businessId-常量表示的业务代码，确定需要翻译的业务代码
  * 返回: BUSINNAME
  */
function DICT_GET_BUSINNAME(database, businTypeId, businessId) {
	var db = database;
	var strSQL = "select BUSINNAME from BNDICT_T_DICTIONARY where BUSINTYPEID='" + businTypeId + "' and BUSINID='" + businessId + "' ";
	var rs = db.runQuerySql(strSQL);
	
	if(!rs.EOF) {
		return rs("BUSINNAME") + "";
	}
	else {
		if(businessId==null || businessId=="null")
			return "";
		else
			return (businessId + "");
	}
	
	rs.close();
	rs = null;
}
%>