帮助中心
帮助中心主页
安装与部署
开发与集成
RDS脚本方法字典
根据条件更新库位
  • 方法说明
    根据条件更新库位
typescript
function updateSitesByCondition(conditions: string,values:string): number
1
  • 输入参数
    • conditions,更新条件,模糊查询用'%'标记
json
{
  "area": "area01", //区域名
  "colNum": ["abc","'%bc'","'%b%'","'ab%'"],//列,带'%'表示模糊查询
  "content": ["abc","'%bc'","'%b%'","'ab%'"],//货物
  "depth": ["abc","'%bc'","'%b%'","'ab%'"],//深
  "filled": true,    //是否有货
  "groupNames": ["abc","'%bc'","'%b%'","'ab%'"],//库区名
  "level": ["abc","'%bc'","'%b%'","'ab%'"],//货架层数
  "locked": true, //是否已锁定
  "lockedBy": "12345", //锁定的任务实例id
  "no": ["abc","'%bc'","'%b%'","'ab%'"],//库位编号
  "rowNum": ["abc","'%bc'","'%b%'","'ab%'"], //货架行
  "siteIds": ["abc","'%bc'","'%b%'","'ab%'"], //库位id
  "tags": ["abc","'%bc'","'%b%'","'ab%'"],//库位标签
  "type": 1    //库位类别,1物理库位,0逻辑库位
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
  • values,修改的字段
json
{
  "area": "abc",  //区域
  "colNum": "4",  //列
  "content": "abc", //货物
  "depth": "2",  //深
  "disabled": true, //禁用
  "filled": true, //有货
  "groupName": "abc", //库区名
  "level": "3", //层
  "locked": true,  //锁定
  "lockedBy": "12345",  //锁定的任务id
  "no": "10",  //编号
  "preparing": true,  //准备中
  "rowNum": "5",  //行
  "siteId": "site_01",  //库位名
  "tags": "abc",  //标签
  "type": 1,  //是否物理库位
  "working": true //工作中
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
  • 输出参数
    • 更新成功的数据库记录行数
  • 异常
    本方法不抛出异常。
最近更新 2022/11/28
文章内容