根据条件更新库位
- 方法说明
根据条件更新库位
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
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
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
- 输出参数
- 更新成功的数据库记录行数
- 异常
本方法不抛出异常。
最近更新 2022/11/28
感谢反馈有用
感谢反馈没用
