列表

/*** 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 = $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* 远程列表。** @param $systemId:string:系统id。* @param $strTableName:string:表。* @param $strColumns:string:字段。* @param $where:map:条件。** @return list:列表。**/
#function remoteList($systemId, $strTableName, $strColumns, $where)#if ($vs.util.isBlankOne($strTableName, $systemId))return null#end#if ($vs.util.isNull($strColumns))#set($strColumns = ' * ')#end#set($strSql = `select${$strColumns}from${strTableName}where 1 = 1`)#set($strSql = $strSql + @andWhere($where))return $vs.dbTools.remoteList($systemId, $strSql ,$where)
#end

// 初始化到常量栈
#if ($vs.util.isNull($vs.stock.dbTools))#set($vs.stock.dbTools = $vs.util.newMap())
#end
#set($vs.stock.dbTools.remoteList = @remoteList)

公共引用：条件

/*** andWhere* 条件。* * @param $where:map:条件** @return string：sql。**/
#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#endreturn $sql
#end

// 初始化到常量栈
#if ($vs.util.isNull($vs.stock.dbTools))#set($vs.stock.dbTools = $vs.util.newMap())
#end
#set($vs.stock.dbTools.andWhere = @andWhere)