谷神后端代码模板：插入

插入

// 参数校验
$vs.util.checkInput($form, '参数不能为空！')

// 唯一性校验
#set($count = $vs.dbTools.count($strTableName, $where))
#if ($count > 0)
	$vs.exception.throwException($strMsg)
#end

// 当前时间
#set($now = $vs.date.getDbDate())
#if ($vs.util.isNull($now))
	#set($now = $vs.date.getDbDate())
#end

// 表单处理
#set($form.CODE = $vs.billNoTools.getBillNo($strBillTypeCode, $form)) // 编号

// 登录信息
#set($form.MEMBER_CODE = $vs.user.MEMBER_CODE)
#set($form.MEMBER_NAME = $vs.user.member.MEMBER_NAME)
#set($form.ORG_CODE = $vs.user.ORG_CODE)
#set($form.DEPT_CODE = $vs.user.DEPT_CODE)
#set($form.USER_ID = $vs.user.USER_ID)
#set($form.USER_NAME = $vs.user.USER_NAME)

// 乐观锁
#set($form.OPTIMISTIC_LOCK = $vs.util.GUID())
#set($form.OPTIMISTIC_LOCK = $vs.date.getTimeStamp($now))
#set($form.OPTIMISTIC_LOCK = $now)

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