谷神后端$vs.dbTools.insert

批量插入

// isNotEmpty
#set($list = $form.detailTable)
#if(!$vs.util.isList($detailTable) || $detailTable.size() == 0)
	$vs.exception.throwException($strMsg)
#end

// 迭代处理
#foreach ($row in $list)
	// 删除主键
	$row.remove('MID')
	
	// 编号
	#set($row.CODE = $form.CODE)
	
	// 时间戳
	#set($row.TIMEMD5 = $vs.util.GUID())
#end

// 批量插入
#set($i = $vs.dbTools.batchInsert($strTableName, $datas))
#if ($i != $datas.size())
	$vs.exception.throwException('操作失败!')
#end

insert

/**
 * insert
 *
 * @param $strTableName:string:表名
 * @param $data:map:数据
 * @param $strMsg:string:消息
 *
 * @return void
 *
 */
#function insert($strTableName, $data, $strMsg)
	#set($i = $vs.dbTools.insert($strTableName, $data))
	#if ($i != 1)
		#if ($vs.util.isNull($strMsg))
			#set($strMsg = '操作失败！')
		#end
		$vs.exception.throwException($strMsg)
	#end
#end

// insert
#set($i = $vs.dbTools.insert($strTableName, $data))
#if ($i != 1)
	$vs.exception.throwException('操作失败！')
#end

batchInsert

/**
 * batchInsert
 *
 * @param $strTableName:string:表名
 * @param $datas:list:数据
 * @param $strMsg:string:消息
 *
 * @return number
 *
 */
#function batchInsert($strTableName, $datas, $strMsg)
	#set($i = $vs.dbTools.batchInsert($strTableName, $datas))
	#if ($i != $datas.size())
		#if ($vs.util.isNull($strMsg))
			#set($strMsg = '操作失败!')
		#end
		$vs.exception.throwException($strMsg)
	#end
	return $i
#end

// batchInsert
#set($i = $vs.dbTools.batchInsert($strTableName, $datas))
#if ($i != $datas.size())
	$vs.exception.throwException('操作失败!')
#end

simpleInsert

/**
 * simpleInsert
 *
 * @param $strTableName:string:表名
 * @param $datas:list:数据
 * @param $strMsg:string:消息
 *
 * @return void
 *
 */
#function simpleInsert($strTableName, $datas, $strMsg)
	#if ($vs.util.isNull($strMsg))
		#set($strMsg = '操作失败！')
	#end
	#if ($vs.util.isList($datas))
		#set($i = $vs.dbTools.batchInsert($strTableName, $datas))
		#if ($i != $datas.size())
			$vs.exception.throwException($strMsg)
		#end
	#else
		#set($i = $vs.dbTools.insert($strTableName, $datas))
		#if ($i != 1)
			$vs.exception.throwException($strMsg)
		#end
	#end
#end