| | |
| | | |
| | | |
| | | DELETE Base_BasicDataSet where BasicDataType='1'; |
| | | INSERT INTO Base_BasicDataSet( |
| | | DELETE wms_sys_basic_data where BasicDataType='1'; |
| | | INSERT INTO wms_sys_basic_data( |
| | | [id], |
| | | [BasicDataType], |
| | | [BasicDataValue], |
| | | [BasicDataUnit], |
| | | [OperationRemark], |
| | | [CreateBy], |
| | | [CreateUserName], |
| | | [CreateTime], |
| | | [ModifyBy], |
| | | [ModifyTime] |
| | | [UpdateUserName], |
| | | [UpdateTime], |
| | | [IsDelete] |
| | | ) |
| | | VALUES |
| | | ( |
| | | '613664349835334', |
| | | '1', -- 调度系统启动相关 |
| | | '000000', -- 有值就代表有机器启动了调度系统 (000000是默认的空值) |
| | | '', |
| | | '调度系统启动相关', |
| | | 'sys', |
| | | getdate(), |
| | | 'sys', |
| | | getdate() |
| | | getdate(), |
| | | 0 |
| | | ); |
| | | |
| | | |
| | | |
| | | DELETE wms_rbline_runmode ; |
| | | INSERT INTO wms_rbline_runmode( |
| | | [id], |
| | | [CreateUserName], |
| | | [CreateTime], |
| | | [UpdateUserName], |
| | | [UpdateTime], |
| | | [IsDelete] |
| | | ) |
| | | VALUES |
| | | ( |
| | | '613664349835335', |
| | | 'sys', |
| | | getdate(), |
| | | 'sys', |
| | | getdate(), |
| | | 0 |
| | | ); |
| | | |