谷神后端$vs.dbTools.select

selectOne

/**
 * selectOne
 *
 * @param $strTableName:string:表名
 * @param $where:map:条件
 * @param $tipMsg:string:提示
 *
 * @return map
 *
 */
#function selectOne($strTableName, $where, $tipMsg)
	#set($one = $vs.dbTools.selectOne($strTableName, $where))
	$vs.util.checkInput($one, $tipMsg)
	return $one
#end

// selectOne
#set($one = $vs.dbTools.selectOne($strTableName, $where))
$vs.util.checkInput($one, $tipMsg)

select

/**
 * select
 *
 * @param $strTableName:string:表名
 * @param $where:map:条件
 * @param $tipMsg:string:提示
 *
 * @return map
 *
 */
#function select($strTableName, $where, $tipMsg)
	#set($list = $vs.dbTools.select($strTableName, $where))
	#if(!$vs.util.isList($list) || $list.size() == 0)
		$vs.exception.throwException($tipMsg)
	#end
	return $list
#end

#set($list = $vs.dbTools.select($strTableName, $where))
#if(!$vs.util.isList($list) || $list.size() == 0)
	$vs.exception.throwException($tipMsg)
#end

andWhere

/**
 * andWhere
 * 
 * @param $where:map:条件
 *
 * @return string
 *
 */
#function andWhere($where)
	#set($sql = '')
	#if ($vs.util.isMap($where))
		#foreach ($key in $vs.util.getMapKeys($where))
			#set($value = $where.get($key))
			#if ($vs.util.isList($value))
				#set($sql = $sql + " and " + $vs.sqlHelper.listIn($value, $key))
			#else
				#set($sql = $sql + $vs.sqlHelper.and($where, $key))
			#end
		#end
	#end
	return $sql
#end

list

/**
 * list
 *
 * @param $strTableName:string:表
 * @param $strColumns:string:字段
 * @param $where:map:条件
 *
 * @return list
 *
 */
#function list($strTableName, $strColumns, $where)
	#set($strSql = `
		select
			${$strColumns}
		from
			${strTableName}
		where 1 = 1
	`)
	#set($strSql = @andWhere($where))
	return $vs.dbTools.list($strSql, $where)
#end

// 添加到常量栈
#if ($vs.util.isNull($vs.stock.dbTools))
	#set($vs.stock.dbTools = $vs.util.newMap())
#end
#set($vs.stock.dbTools.list= @list)

remoteList

/**
 * remoteList
 *
 * @param $systemId:string:系统ID
 * @param $strTableName:string:表
 * @param $strColumns:string:字段
 * @param $where:map:条件
 *
 * @return list
 *
 */
#function remoteList($systemId, $strTableName, $strColumns, $where)
	#set($strSql = `
		select
			${$strColumns}
		from
			${strTableName}
		where 1 = 1
	`)
	#set($strSql = @andWhere($where))
	return $vs.dbTools.remoteList($systemId, $strSql ,$where)
#end

countSQL

/**
 * 查询数量
 *
 * @param $strTableName:表
 * @param $strColumns:字段
 * @param $where:条件
 *
 * @return number
 *
 */
#function countSQL($strTableName, $where)
	#set($strSql = `
		select
			count(1)
		from
			${strTableName}
		where 1 = 1
	`)
	#foreach ($strTableFieldId in $vs.util.getMapKeys($where))
		#set($v = $where.get($strTableFieldId))
		#if ($vs.util.isList($v))
			#set($strSql= $strSql + " and " + $vs.sqlHelper.listIn($v, $strTableFieldId))
		#else
			#set($strSql= $strSql + $vs.sqlHelper.and($where, $strTableFieldId))
		#end
	#end
	return $vs.dbTools.countSQL($strSql,$where)
#end

tableWhereSql

/**
 * whereSql
 * 
 * @param $form:map:表单参数
 *
 * @return string
 *
 */
#function tableWhereSql($form)
	// 默认值初始化
	#set($whereSql = ' ')
	#set($dateBetween = $vs.util.newList())

	// 迭代处理
	#foreach ($key in $vs.util.getMapKeys($form))
		// dateBetween
		#if ($vs.util.startsWith($key, '_') && ($vs.util.endsWith($key, '_DATE_START_') || $vs.util.endsWith($key, '_DATE_END_')))
			#set($key = $vs.regexp.replaceAll($key, '^_', ''))
			#set($key = $vs.regexp.replaceAll($key, '_DATE_START_$', ''))
			#set($key = $vs.regexp.replaceAll($key, '_DATE_END_$', ''))
			#if (!$dateBetween.contains($key))
				$dateBetween.add($key)
			#end
		#end
	#end
	
	// 拼接sql
	// dateBetween
	#foreach($dateBetweenKey in $dateBetween)
		#set($whereSql = $whereSql + $vs.sqlHelper.andDateBetween($form, $dateBetweenKey, '_' + $dateBetweenKey + '_DATE_START_', '_' + $dateBetweenKey + '_DATE_END_'))
	#end

	// 返回
	return $whereSql
#end