| | |
| | | VALUES ( |
| | | N'入库站点抓拍配置', |
| | | N'InboundCameraCapture', |
| | | N'{"enabled":true,"captureUrl":"http://192.168.10.11:8000/startPic","imageUrlPrefix":"http://192.168.10.11:8000/image/","stations":{"101":[{"ip":"10.10.16.13","port":554,"user":"admin","password":"a327482030"},{"ip":"10.10.16.14","port":554,"user":"admin","password":"a327482030"}]}}', |
| | | N'{"enabled":true,"captureUrl":"http://192.168.160.11:8000/startPic","imageUrlPrefix":"http://192.168.160.11/","stations":{"101":[{"ip":"10.10.16.13","port":554,"user":"admin","password":"a327482030"},{"ip":"10.10.16.14","port":554,"user":"admin","password":"a327482030"}]}}', |
| | | 2, |
| | | 1 |
| | | ); |
| | | END |
| | | GO |
| | | |
| | | UPDATE sys_config |
| | | SET value = REPLACE(value, N'"captureUrl":"http://192.168.10.11:8000/startPic"', N'"captureUrl":"http://192.168.160.11:8000/startPic"') |
| | | WHERE code = N'InboundCameraCapture' |
| | | AND value LIKE N'%"captureUrl":"http://192.168.10.11:8000/startPic"%'; |
| | | GO |
| | | |
| | | UPDATE sys_config |
| | | SET value = REPLACE(value, N'"imageUrlPrefix":"http://192.168.10.11:8000/image/"', N'"imageUrlPrefix":"http://192.168.160.11/"') |
| | | WHERE code = N'InboundCameraCapture' |
| | | AND value LIKE N'%"imageUrlPrefix":"http://192.168.10.11:8000/image/"%'; |
| | | GO |