开放更新
$vs.util.checkInput($form, '参数不能为空!')
$vs.util.checkInput($form.PRIMARY_KEY, '主键不能为空!')
$vs.util.checkInput($form.OPTIMISTIC_LOCK, '乐观锁不能为空!')
#set($now = $vs.date.getDbDate())
#if ($vs.util.isNull($now))
#set($now = $vs.date.getDbDate())
#end
#set($where = $vs.util.newMap())
#set($where.PRIMARY_KEY = $form.PRIMARY_KEY)
#set($where.OPTIMISTIC_LOCK = $form.OPTIMISTIC_LOCK)
#set($one = $vs.dbTools.selectOne($strTableName, $where))
$vs.util.checkInput($one, '数据已变更,请刷新重试!')
#set($list = $vs.util.newList())
#if(!$list.contains($one.STATE))
$vs.exception.throwException('不可操作!')
#end
#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.update($strTableName, $form, $where))
#if ($i != 1)
$vs.exception.throwException('数据已变更,请刷新重试!')
#end
封闭更新
$vs.util.checkInput($form, '参数不能为空!')
$vs.util.checkInput($form.PRIMARY_KEY, '主键不能为空!')
$vs.util.checkInput($form.OPTIMISTIC_LOCK, '乐观锁不能为空!')
#set($now = $vs.date.getDbDate())
#if ($vs.util.isNull($now))
#set($now = $vs.date.getDbDate())
#end
#set($where = $vs.util.newMap())
#set($where.PRIMARY_KEY = $form.PRIMARY_KEY)
#set($where.OPTIMISTIC_LOCK = $form.OPTIMISTIC_LOCK)
#set($one = $vs.dbTools.selectOne($strTableName, $where))
$vs.util.checkInput($one, '数据已变更,请刷新重试!')
#set($list = $vs.util.newList())
#if(!$list.contains($one.STATE))
$vs.exception.throwException('不可操作!')
#end
#set($data = $vs.util.newMap())
#set($data.MEMBER_CODE = $vs.user.MEMBER_CODE)
#set($data.MEMBER_NAME = $vs.user.member.MEMBER_NAME)
#set($data.ORG_CODE = $vs.user.ORG_CODE)
#set($data.DEPT_CODE = $vs.user.DEPT_CODE)
#set($data.USER_ID = $vs.user.USER_ID)
#set($data.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.update($strTableName, $data, $where))
#if ($i != 1)
$vs.exception.throwException('数据已变更,请刷新重试!')
#end
批量更新
#set($now = $vs.date.getDbDate())
#if ($vs.util.isNull($now))
#set($now = $vs.date.getDbDate())
#end
#set($where = $vs.util.newMap())
#set($list = $vs.dbTools.select($strTableName, $where))
#if(!$vs.util.isList($list) || $list.size() == 0)
$vs.exception.throwException('未找到!')
#end
#set($wheres = $vs.util.newList())
#set($datas = $vs.util.newList())
#foreach ($row in $list)
$vs.util.checkInput($row, '参数不能为空!')
$vs.util.checkInput($row.PRIMARY_KEY, '主键不能为空!')
$vs.util.checkInput($row.OPTIMISTIC_LOCK, '乐观锁不能为空!')
#set($where = $vs.util.newMap())
#set($where.PRIMARY_KEY = $row.PRIMARY_KEY)
#set($where.OPTIMISTIC_LOCK = $row.OPTIMISTIC_LOCK)
$wheres.add($where)
#set($data = $vs.util.newMap())
#set($data.OPTIMISTIC_LOCK = $vs.util.GUID())
#set($data.OPTIMISTIC_LOCK = $vs.date.getTimeStamp($now))
#set($data.OPTIMISTIC_LOCK = $now)
$datas.add($data)
#end
#set($i = $vs.dbTools.batchUpdate($strTableName, $datas, $wheres))
#if ($i != $datas.size())
$vs.exception.throwException('数据已变更,请刷新重试!')
#end