依赖插入
@add($data, $dependence, $refresh, $now)
#function add($data, $dependence, $refresh, $now)
$vs.util.checkInput($data, '插入信息不能为空!')
$vs.util.checkInput($refresh, '是否刷新不能为空!')
$vs.util.checkInput($now, '当前时间不能为空!')
$vs.util.checkInput($dependence, '依赖信息不能为空!')
$vs.util.checkInput($dependence.FOREIGN_KEY, '外键不能为空!')
#set($data.FOREIGN_KEY = $dependence.FOREIGN_KEY)
#set($data.FOREIGN_KEY = $dependence.FOREIGN_KEY)
#set($data.OPTIMISTIC_LOCK = $vs.util.GUID())
#set($data.OPTIMISTIC_LOCK = $vs.date.getTimeStamp($now))
#set($data.OPTIMISTIC_LOCK = $now)
#set($i = $vs.dbTools.insert($strTableName, $data))
#if ($i != 1)
$vs.exception.throwException('操作失败!')
#end
#if ($refresh)
@refreshOneOptimisticLock ($strTableName, $PRIMARY_KEY, $OPTIMISTIC_LOCK, $dependence, $OPTIMISTIC_LOCK_VALUE)
#end
return null
#end
#function refreshOneOptimisticLock ($strTableName, $PRIMARY_KEY, $OPTIMISTIC_LOCK, $one, $OPTIMISTIC_LOCK_VALUE)
$vs.util.checkInput($strTableName, '表名不能为空!')
$vs.util.checkInput($PRIMARY_KEY, '主键KEY不能为空!')
$vs.util.checkInput($OPTIMISTIC_LOCK, '乐观锁KEY不能为空!')
$vs.util.checkInput($one, '数据不能为空!')
$vs.util.checkInput($OPTIMISTIC_LOCK_VALUE, '乐观锁VALUE不能为空!')
#set($where = $vs.util.newMap())
$where.put($PRIMARY_KEY, $one.get($PRIMARY_KEY))
$where.put($OPTIMISTIC_LOCK, $one.get($OPTIMISTIC_LOCK))
#set($data = $vs.util.newMap())
$data.put($OPTIMISTIC_LOCK, $OPTIMISTIC_LOCK_VALUE)
#set($i = $vs.dbTools.update($strTableName ,$data, $where))
$vs.dbTools.update($strTableName, $data, $where)
#if ($i ne 1)
$vs.exception.throwException('数据已变更,请刷新重试!')
#end
return null
#end