chenjingyong
/
DSWMS
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
NET31
FEST
NET8
dev
WUTONG
master
djz_new
djz
temp
sdgslk
test
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
DSWMS/说明文档/初始化数据库/DSWMS基础数据.sql

1172 lines
148 KiB
Transact-SQL
Raw Permalink Blame History Unescape Escape

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

set IDENTITY_INSERT [Sys_Dictionary] ON
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (3, N'{valueField: ''Enable'',
textField: ''Enable'',
containField: null,
handler: null }', '2019-07-05 17:36:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'admin', N'1', NULL, N'是否值', N'enable', 1, N'系统管理员', '2020-08-14 17:06:30.770', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (30, N'{valueField: ''Success'',
textField: ''Success'',
containField: null,
handler: null }
', '2018-06-11 18:26:05.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'响应状态', N'restatus', 1, N'测试超级管理员', '2018-06-12 10:21:48.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (31, N'{valueField: ''LogType'',
textField: ''LogType'',
containField: null,
handler: null }
', '2018-06-12 14:46:07.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'日志类型', N'log', 1, N'测试超级管理员', '2018-08-01 14:41:48.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (32, N'{valueField: ''Role_Id'',
textField: ''RoleName'',
containField: [''Role_Id'',''RoleName''],
handler: null }
', '2018-06-14 16:48:35.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, N'SELECT Role_Id as ''key'',RoleName as ''value'' FROM Sys_Role_Core WHERE Enable=1
', N'角色列表', N'roles', 1, N'测试超级管理员', '2018-07-13 15:03:53.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 123, 0, N'sql语句需要key,value列，界面才能绑定数据源', NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (34, N'{valueField: ''PINType'',
textField: ''PINTypeV'',
containField:null
}', '2018-07-09 10:04:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'验证码获取记录', N'pin', 1, N'测试超级管理员', '2018-07-10 14:08:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (35, N'{
valueField: ''AuditStatus'',
textField: ''AuditStatus'',
containField:null
}', '2018-07-10 10:51:37.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'审核状态', N'audit', 1, N'测试超级管理员', '2018-07-10 11:02:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (36, N'{
valueField: ''Variety'',
textField: ''Variety'',
containField:null
}', '2018-07-10 14:06:12.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'品种', N'pz', 1, N'超级管理员', '2020-01-05 19:01:22.367', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (37, N'{
valueField: ''AgeRange'',
textField: ''AgeRange'',
containField:null
}', '2018-07-10 14:07:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'月龄', N'age', 1, N'测试超级管理员', '2018-07-10 14:14:49.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (38, N'{
valueField: ''City'',
textField: ''City'',
containField:null
}', '2018-07-10 14:18:25.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, N'
SELECT CASE WHEN CityName=''市辖区'' THEN ProvinceName ELSE CityName end as ''key'',CASE WHEN CityName=''市辖区'' THEN ProvinceName ELSE CityName end as ''value'' FROM Sys_City AS a
INNER JOIN Sys_Province AS b
ON a.ProvinceCode=b.ProvinceCode
WHERE a.CityName<> ''县''', N'城市', N'city', 1, N'超级管理员', '2020-02-01 22:27:08.157', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (39, N'{
valueField: ''ReplyStatus'',
textField: ''ReplyStatus'',
containField:null
}', '2018-07-10 14:53:08.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'回复状态', N'reply', 1, N'测试超级管理员', '2018-07-10 14:56:16.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (41, N'{
valueField: ''Sex'',
textField: ''Sex'',
containField:null
}', '2018-07-10 15:43:44.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'公母牛', N'sex', 1, N'超级管理员', '2019-11-24 14:41:02.100', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 1, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (42, N'{
valueField: ''Temperature'',
textField: ''Temperature'',
containField:null
}', '2018-07-10 15:47:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'温度', N'wd', 1, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (44, N'{
valueField: ''NewsType'',
textField: ''NewsType'',
containField:null
}', '2018-07-10 16:15:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'新闻类型', N'news', 1, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (45, N'{
valueField: ''Expire'',
textField: ''Expire'',
containField:null
}', '2018-07-10 16:38:40.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'是否过期', N'expire', 1, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (46, N'{
valueField: ''ProvinceName'',
textField: ''ProvinceName'',
containField:null
}', '2018-07-16 13:27:34.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, N'
SELECT CASE WHEN CityName=''市辖区'' THEN ProvinceName ELSE CityName end as ''key'',CASE WHEN CityName=''市辖区'' THEN ProvinceName ELSE CityName end as ''value'' FROM Sys_City AS a
INNER JOIN Sys_Province AS b
ON a.ProvinceCode=b.ProvinceCode
WHERE a.CityName<> ''县''', N'省列表', N'pro', 1, N'超级管理员', '2020-02-01 22:26:59.223', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, N'sql语句需要key,value列，界面才能绑定数据源', NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (48, N'{
valueField: ''ClassifyId'',
textField: ''ClassifyTitle'',
containField:null
}', '2018-07-18 10:16:22.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'是否买入', N'nav', 1, N'超级管理员', '2019-09-18 18:09:42.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (49, N'{
valueField: ''Gender'',
textField: ''Gender'',
containField:null
}', '2018-07-23 10:04:45.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'性别', N'gender', 1, N'测试超级管理员', '2018-07-23 11:10:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (50, N'{
valueField: ''Enable'',
textField: ''Enable'',
containField:null
}', '2018-07-23 15:36:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'启用状态', N'status', 1, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (52, N'{
valueField: ''Choiceness'',
textField: ''Choiceness'',
containField:null
}', '2018-07-24 15:45:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'是否买入', N'cq', 1, N'超级管理员', '2019-09-18 17:32:36.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (53, N'{
valueField: ''SourceType'',
textField: ''SourceType'',
containField:null
}', '2018-08-07 13:53:56.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'图片来源', N'ps', 1, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (59, N'{
valueField: ''IsRegregisterPhone'',
textField: ''IsRegregisterPhone'',
containField:null
}', '2018-08-29 15:54:21.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', NULL, NULL, N'是否手机用户', N'isphone', 1, N'超级管理员', '2019-11-01 10:05:12.673', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (60, N'{
valueField: ''DailyRecommend'',
textField: ''DailyRecommend'',
containField:null
}', '2018-09-05 15:45:49.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', NULL, NULL, N'是否今日推荐', N'dr', 1, N'超级管理员', '2019-11-24 14:40:13.913', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 1, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (62, N'{
valueField: ''IsTop'',
textField: ''IsTop'',
containField:null
}', '2019-08-20 09:57:54.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', NULL, NULL, N'推荐价格', N'top', 1, N'超级管理员', '2019-09-18 15:23:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 1, N'dddd', NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (64, NULL, '2019-09-18 19:25:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', NULL, NULL, N'订单类型', N'ordertype', 1, N'超级管理员', '2019-11-01 10:04:20.833', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, N'xxxxx', NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (65, NULL, '2019-09-19 10:07:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', NULL, NULL, N'商品名称', N'pn', 1, N'超级管理员', '2020-02-07 17:57:11.940', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 2, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (69, NULL, '2020-08-14 17:03:45.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, NULL, N'权限范围名称', N'userrange', 1, N'系统管理员', '2020-08-14 17:05:16.583', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (70, NULL, '2020-08-19 11:30:58.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (select name from company where gid=LINKID)+''''+DEPTNAME as value , GID [key] from sys_dept', N'部门', N'dept', 1, N'系统管理员', '2020-08-19 11:48:58.790', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (71, NULL, '2020-08-19 11:35:52.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select companyname+''''+DEPTNAME+''''+SHOWNAME as value , USERID [key] from vw_user
', N'用户', N'user', 1, N'冯夏青', '2020-11-16 17:12:25.420', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (72, NULL, '2020-08-19 11:48:36.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select GID [key],name value from company', N'公司ID', N'companyid', 1, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (73, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL, NULL, N'逻辑仓储区项目', N'logicname', 1, N'系统管理员', '2020-08-21 11:12:29.673', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 9000, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (75, NULL, '2020-08-05 17:32:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', NULL, N'SELECT codename as ''key'',NAME as ''value'' FROM company where isdisable=0', N'分公司', N'company', 1, N'超级管理员', '2020-08-11 11:16:15.510', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (76, NULL, '2020-08-26 14:07:27.470', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, NULL, N'是否', N'shifou', 1, N'系统管理员', '2020-09-27 10:47:22.133', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (78, NULL, '2020-08-28 16:17:04.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT gid as ''key'',GOODSDETAILNAME as ''value'' FROM code_goods_detail', N'商品明细', N'goodsdetail', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (79, NULL, '2020-08-28 16:19:30.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT GoodsTypeName as ''key'',GoodsTypeName as ''value'' FROM code_goodsType', N'商品类型', N'goodstype', 1, N'系统管理员', '2020-09-16 17:46:41.060', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (80, NULL, '2020-09-01 11:44:49.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT gid as ''key'',optype as ''value'' FROM code_op_status', N'业务类型', N'optype', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (81, NULL, '2020-09-02 10:52:14.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select * from(
SELECT SHORTNAME as ''key'',CODENAME + '''' + SHORTNAME as ''value'' FROM info_Client
union all
select '''' as ''key'','''' as ''value''
)t order by ''value'' ', N'客户名称', N'CustName', 1, N'冯夏青', '2020-12-31 12:41:09.477', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (82, NULL, '2020-09-02 11:02:21.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT AREACODE as ''key'',AREANAME as ''value'' FROM OP_WMS_STOREHOUSE where ##companyfield=''##companyvalue''', N'仓库', N'storage', 1, N'冯夏青', '2020-11-17 21:56:59.577', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, 'CORPNAME')
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (83, NULL, '2020-09-02 11:18:12.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT ACCBOOKID as ''key'',ACCBOOKNO as ''value'' FROM INFO_ACCBOOK where ##companyfield=''##companyvalue''', N'账册编号', N'ACCBOOKNO', 1, N'冯夏青', '2020-12-03 11:19:37.860', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, 'CORPID')
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (85, NULL, '2020-09-14 18:40:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT yardcode as ''key'',yard as ''value'' FROM OP_WMS_YARD', N'yards', N'yards', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (86, NULL, '2020-09-16 16:13:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, NULL, N'品名大类', N'goodsfeetype', 1, N'系统管理员', '2020-11-23 15:01:35.443', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, N'用于设置费率', NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (87, NULL, '2020-09-16 17:28:40.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT GOODNAME as ''key'',GOODNAME as ''value'' FROM code_goods where ISSTOP=''false''', N'商品名称', N'goodscode', 1, N'系统管理员', '2020-09-25 21:30:50.867', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (88, NULL, '2020-09-17 10:23:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select NAME as ''key'',FEECODE+'' ''+NAME as ''value'' from code_fee', N'费用名称', N'feename', 1, N'系统管理员', '2020-11-16 08:45:40.423', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (89, NULL, '2020-09-17 10:27:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select FEEGROUPNAME as ''key'',FEEGROUPNAME as ''value'' from code_fee_group', N'费用类型分组', N'code_fee_group', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (90, NULL, '2020-09-17 10:34:57.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, NULL, N'计费单位类型', N'defaultfeeunit', 1, N'系统管理员', '2020-11-16 08:44:37.667', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, N'费率设置调用', NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (91, NULL, '2020-09-17 10:37:12.787', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select 1 as ''key'',''应收'' as ''value''
union all
select 2 as ''key'',''应付'' as ''value''', N'收付方向', N'feetype', 1, N'冯夏青', '2020-11-20 14:48:04.027', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (92, NULL, '2020-09-17 17:48:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select '''' as ''key'','''' as ''value''
union all
select SHORTNAME as ''key'',CODENAME+''''+SHORTNAME as ''value'' from info_client where ISCONTROLLER=1', N'委托单位', N'customer_iscontroller', 1, N'系统管理员', '2020-09-18 11:43:43.960', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (93, NULL, '2020-09-21 09:26:19.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select STATEKEY as ''key'',[name] as ''value'' from Sys_Task_State', N'任务状态值 业务状态值 sys_task_state', N'billstate', 1, N'系统管理员', '2020-09-23 14:01:20.093', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 600, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (94, NULL, '2020-09-21 14:00:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, NULL, N'仓储计费单位', N'storeunit', 1, N'系统管理员', '2020-09-21 14:11:51.677', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (95, NULL, '2020-09-21 15:33:18.423', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, NULL, N'是否bit型', N'shifoubit', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (96, NULL, '2020-09-22 10:06:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select workname as ''key'',workname as ''value'' from op_wms_workname', N'作业动作名称工作量名称', N'workname', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (97, NULL, '2020-09-22 13:45:15.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'SELECT AREACODE as ''key'',AREANAME as ''value'' FROM OP_WMS_STOREHOUSE_AREA
where pid in(select Id FROM OP_WMS_STOREHOUSE where ##companyfield=''##companyvalue'') order by AREACODE ', N'库位', N'areacode', 1, N'冯夏青', '2020-11-17 22:01:45.307', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 82, NULL, 'CORPNAME')
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (98, NULL, '2020-09-23 14:02:19.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select STATEKEY as ''key'',[name] as ''value'' from [Sys_Task_Execution]', N'任务动作值 sys_task_execute', N'taskexecute', 1, N'系统管理员', '2020-09-23 14:06:16.207', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 599, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (99, NULL, '2020-09-23 14:06:06.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select STATEKEY as ''key'',[name] as ''value'' from [Sys_Task_Progress_Index]', N'任务动作状态关系 Sys_Task_Progress_Index', N'taskprogress', 1, N'系统管理员', '2020-09-23 14:13:58.793', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 598, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (100, NULL, '2020-11-01 15:26:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select NAME as ''key'',ZHI as ''value'' from OP_WMS_TEMP', N'空绑', N'kongbind', 1, N'冯夏青', '2020-11-16 16:02:13.580', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (101, NULL, '2020-11-02 11:19:58.000', '7A3CE389-FA53-4640-88D4-6A16651F9458', N'冯夏青', NULL, N'select '''' as [key],'''' as [value]', N'空白绑定', N'blankdic', 1, N'冯夏青', '2020-11-02 11:20:18.357', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (102, NULL, '2020-11-16 15:58:25.000', '7A3CE389-FA53-4640-88D4-6A16651F9458', N'冯夏青', NULL, NULL, N't_roles', N't_roles', 1, N'冯夏青', '2020-11-16 16:08:09.730', '7A3CE389-FA53-4640-88D4-6A16651F9458', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (103, NULL, '2020-11-16 17:13:13.000', '7A3CE389-FA53-4640-88D4-6A16651F9458', N'冯夏青', NULL, N'select SHOWNAME as value , USERID [key] from vw_user where ##companyfield=''##companyvalue''', N'用户名称', N'username', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', 0, 0, NULL, 'COMPANYID')
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (104, NULL, '2020-11-21 18:27:55.000', '7A3CE389-FA53-4640-88D4-6A16651F9458', N'冯夏青', NULL, N'select USERID as ''key'',SHOWNAME as value from VW_OP_WMS_WORKNAME where ##companyfield=''##companyvalue''', N'工作人员列表', N'workerlist', 1, N'冯夏青', '2020-11-21 18:30:51.657', '7A3CE389-FA53-4640-88D4-6A16651F9458', 0, 0, N'包括用户和装卸工', 'CORPID')
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (105, NULL, '2020-11-22 14:10:41.000', '7A3CE389-FA53-4640-88D4-6A16651F9458', N'冯夏青', NULL, N'select EnumValueID as''key'' , EnumValueName as ''value'' from tSysEnumValue where EnumTypeID=99024', N'费用状态', N'feestatus', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (106, NULL, '2020-11-24 08:59:02.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select KEYVALUE as [key] , KEYVALUE as value from crm_key_code where KEYTYPE=''装运方式'' ', N'装运方式', N'zhuangyunfangshi', 1, N'系统管理员', '2020-11-24 14:39:23.533', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (107, NULL, '2020-11-24 09:04:08.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select SOURCEID as [key] , SourceName as value from code_source ', N'业务来源', N'yewulaiyuan', 1, N'系统管理员', '2020-11-24 14:02:56.087', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (108, NULL, '2020-11-24 09:06:55.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select SOURCEDETAILID as ''key'',SOURCEDETAIL as ''value'' from code_source_detail', N'来源明细', N'laiyuanmingxi', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (109, NULL, '2020-11-24 09:09:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select gid as [key] , Name as value from company', N'所属分部', N'suoshufenbu', 1, N'系统管理员', '2020-11-24 14:03:26.313', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (110, NULL, '2020-11-24 09:11:58.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select SHOWNAME as ''key'',SHOWNAME as ''value'' from VW_user', N'操作', N'caozuo', 1, N'系统管理员', '2020-11-24 14:28:16.793', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (111, NULL, '2020-11-24 09:14:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select SHOWNAME as ''key'',SHOWNAME as ''value'' from info_client_contact', N'委托单位联系人', N'weituolianxiren', 1, N'系统管理员', '2020-11-24 14:51:38.527', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (112, NULL, '2020-11-24 09:41:22.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select VESSEL as ''key'',VESSEL as ''value'' from code_vessel', N'船名', N'chuanming', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (113, NULL, '2020-11-24 09:42:26.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select VOYNO as ''key'',VOYNO as ''value'' from code_voyno', N'航次', N'hangci', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (114, NULL, '2020-11-24 09:44:55.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (PORT+''''+EDICODE) as ''key'',PORT as ''value'' from Code_Disport', N'装货港', N'zhuanghuogang', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (115, NULL, '2020-11-24 09:46:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (PORT+''''+CNAME) as ''key'',PORT as ''value'' from Code_Loadport', N'卸货港', N'xiehuogang', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (116, NULL, '2020-11-24 09:48:16.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select EnumValueName as ''key'',EnumValueName as ''value'' from tSysEnumValue where EnumTypeID=96016', N'码头', N'matou', 1, N'系统管理员', '2020-11-25 14:00:49.393', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (117, NULL, '2020-11-24 09:50:52.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISYARD=1', N'场站', N'changzhan', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (118, NULL, '2020-11-24 09:52:05.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISAGENT=1', N'国外代理', N'guowaidaili', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (119, NULL, '2020-11-24 09:53:05.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISCARRIER=1', N'船公司', N'chuangongsi', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (120, NULL, '2020-11-24 09:54:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select LANE as ''key'',LANE as ''value'' from code_lanes', N'航线', N'hangxian', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (121, NULL, '2020-11-24 09:55:52.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISENTERP=1', N'经营单位', N'jingyingdanwei', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (122, NULL, '2020-11-24 09:56:41.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISBOOKING=1', N'货代', N'huodai', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (123, NULL, '2020-11-24 09:57:31.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISTRUCK=1', N'承运车队', N'chenyunchedui', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (124, NULL, '2020-11-24 09:58:12.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISSHIPAGENCY=1', N'船代', N'chuandai', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (125, NULL, '2020-11-24 10:00:40.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (GoodsTypeCode+''''+GoodsTypeName) as ''key'',GoodsTypeName as ''value'' from Code_GoodsType ', N'品名类型', N'pinmingleixing', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (126, NULL, '2020-11-24 10:02:19.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (GOODCODE+''''+GOODNAME) as ''key'',GOODNAME as ''value'' from code_goods ', N'品名', N'pinming', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (127, NULL, '2020-11-24 10:03:27.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select country as ''key'',country as ''value'' from code_country ', N'原产地', N'yuanchandi', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (128, NULL, '2020-11-24 10:04:39.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select PKGS as ''key'',PKGS as ''value'' from code_package ', N'包装', N'baozhuang', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (129, NULL, '2020-11-24 10:10:48.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select EnumValueName as ''key'',EnumValueName as ''value'' from tSysEnumValue where EnumTypeID=97047 ', N'运输包装', N'yunshubaozhuang', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (130, NULL, '2020-11-24 10:11:49.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select KEYVALUE as ''key'',KEYVALUE as ''value'' from crm_key_code where KEYTYPE=''贸易方式''', N'贸易方式', N'maoyifangshi', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (131, NULL, '2020-11-24 10:13:45.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select EnumValueName as ''key'',EnumValueName as ''value'' from tSysEnumValue where EnumTypeID=97023', N'贸易条款', N'maoyitiaokuan', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (132, NULL, '2020-11-24 10:14:50.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select EnumValueName as ''key'',EnumValueName as ''value'' from tSysEnumValue where EnumTypeID=97024', N'报检项目', N'baojianxiangmu', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (133, NULL, '2020-11-24 10:16:01.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISCUSTOM=1', N'报关行', N'baoguanhang', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (134, NULL, '2020-11-24 10:17:34.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select KEYVALUE as ''key'',KEYVALUE as ''value'' from crm_key_code where KEYTYPE=''仓储类型''', N'仓储类型', N'cangchuleixing', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (135, NULL, '2020-11-24 10:18:20.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select CODENAME as ''key'',CODENAME as ''value'' from code_currency ', N'币别', N'bibie', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (136, NULL, '2020-11-24 10:19:17.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select (CODENAME + '''' + SHORTNAME) as ''key'',SHORTNAME as ''value'' from info_Client where ISWAREHOUSE=1', N'仓库', N'cangku', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Dictionary]([Dic_ID], [Config], [CreateDate], [CreateID], [Creator], [DBServer], [DbSql], [DicName], [DicNo], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [ParentId], [Remark], [CompanyField]) VALUES (137, NULL, '2020-11-27 13:48:08.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', NULL, N'select CTN as ''key'',CTN as ''value'' from code_ctn', N'箱型', N'xiangxing', 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', NULL, 0, NULL, NULL)
GO
set IDENTITY_INSERT [Sys_Dictionary] OFF
set IDENTITY_INSERT [Sys_DictionaryList] ON
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (3, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'admin', N'否', N'0', 3, 1, N'系统管理员', '2020-08-14 17:06:30.770', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 2, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (4, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'xxx', N'是', N'1', 3, 1, N'系统管理员', '2020-08-14 17:06:30.770', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 1, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (22, '2018-06-11 18:26:05.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'其他', N'0', 30, NULL, N'超级管理员', '2019-08-21 16:49:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 10, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (23, '2018-06-11 18:26:05.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'成功', N'1', 30, NULL, N'超级管理员', '2019-08-21 16:49:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 100, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (24, '2018-06-12 09:41:58.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'异常', N'2', 30, NULL, N'超级管理员', '2019-08-21 16:49:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 50, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (25, '2018-06-12 14:46:08.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'系统', N'System', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 100, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (26, '2018-06-12 14:47:32.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'登陆', N'Login', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 90, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (27, '2018-06-15 15:29:58.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'新建', N'Add', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (28, '2018-06-15 15:29:58.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'删除', N'Del', 31, 1, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (29, '2018-06-15 15:30:34.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'编辑', N'Edit', 31, 1, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (33, '2018-07-09 10:04:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'注册', N'1', 34, NULL, N'测试超级管理员', '2018-07-10 14:08:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (34, '2018-07-09 10:04:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'忘记密码', N'2', 34, NULL, N'测试超级管理员', '2018-07-10 14:08:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (35, '2018-07-09 10:04:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'验证码登录', N'3', 34, NULL, N'测试超级管理员', '2018-07-10 14:08:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (36, '2018-07-09 10:04:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'修改密码', N'4', 34, NULL, N'测试超级管理员', '2018-07-10 14:08:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (37, '2018-07-10 10:51:38.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'审核中', N'0', 35, NULL, N'测试超级管理员', '2018-07-10 11:02:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (38, '2018-07-10 10:51:38.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'审核通过', N'1', 35, NULL, N'测试超级管理员', '2018-07-10 11:02:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (39, '2018-07-10 10:51:38.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'审核未通过', N'2', 35, NULL, N'测试超级管理员', '2018-07-10 11:02:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (40, '2018-07-10 14:06:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'西门塔尔', N'8', 36, NULL, N'超级管理员', '2020-01-05 19:01:22.377', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (41, '2018-07-10 14:06:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'利木赞牛', N'7', 36, NULL, N'超级管理员', '2020-01-05 19:01:22.377', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (42, '2018-07-10 14:06:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'夏洛莱牛', N'6', 36, NULL, N'超级管理员', '2020-01-05 19:01:22.373', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (43, '2018-07-10 14:06:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'鲁西黄牛', N'5', 36, NULL, N'超级管理员', '2020-01-05 19:01:22.373', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (44, '2018-07-10 14:06:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'神户肉牛', N'4', 36, NULL, N'超级管理员', '2020-01-05 19:01:22.373', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (45, '2018-07-10 14:06:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'南阳牛', N'3', 36, NULL, N'超级管理员', '2020-01-05 19:01:22.370', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (46, '2018-07-10 14:06:13.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'秦川牛', N'2', 36, NULL, N'超级管理员', '2020-01-05 19:01:22.370', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (47, '2018-07-10 14:07:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'0-2月龄', N'0-2月龄', 37, NULL, N'测试超级管理员', '2018-09-06 15:57:29.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (48, '2018-07-10 14:07:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'2-6月龄', N'2-6月龄', 37, NULL, N'测试超级管理员', '2018-09-06 15:57:29.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (49, '2018-07-10 14:07:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'7-12月龄', N'7-12月龄', 37, NULL, N'测试超级管理员', '2018-09-06 15:57:29.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (50, '2018-07-10 14:07:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'12-16月龄', N'12-16月龄', 37, NULL, N'测试超级管理员', '2018-09-06 15:57:29.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (51, '2018-07-10 14:07:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'16月龄以上', N'16月龄以上', 37, NULL, N'测试超级管理员', '2018-09-06 15:57:29.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (52, '2018-07-10 14:53:08.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'未回复', N'0', 39, NULL, N'测试超级管理员', '2018-07-10 14:56:16.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (53, '2018-07-10 14:53:08.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'已回复', N'1', 39, NULL, N'测试超级管理员', '2018-07-10 14:56:16.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (56, '2018-07-10 15:43:44.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'公牛', N'公牛', 41, NULL, N'超级管理员', '2019-11-24 14:41:02.103', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (57, '2018-07-10 15:43:44.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'母牛', N'母牛', 41, NULL, N'超级管理员', '2019-11-24 14:41:02.100', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (58, '2018-07-10 15:47:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'39.5°C以上(升高)', N'39.5°C以上(升高)', 42, NULL, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (59, '2018-07-10 15:47:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'38°C~39.5°C以上(正常)', N'38°C~39.5°C以上(正常)', 42, NULL, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (60, '2018-07-10 15:47:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'38°C以下(降低)', N'38°C以下(降低)', 42, NULL, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (64, '2018-07-10 16:15:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'行业新闻', N'1', 44, NULL, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (65, '2018-07-10 16:15:59.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'行情资讯', N'2', 44, NULL, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (66, '2018-07-10 16:38:40.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'否', N'0', 45, NULL, N'超级管理员', '2019-09-03 13:20:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (67, '2018-07-10 16:38:40.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'是', N'1', 45, NULL, N'超级管理员', '2019-09-03 13:20:46.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (68, '2018-07-11 13:20:11.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'App登陆', N'ApiLogin', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (69, '2018-07-11 15:57:03.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'App发送验证码', N'ApiSendPIN', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (70, '2018-07-11 17:11:18.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'App请求异常', N'ApiException', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (71, '2018-07-11 17:11:19.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'PC请求异常', N'Exception', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (77, '2018-07-18 10:16:22.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'现金', N'1', 48, NULL, N'超级管理员', '2019-09-18 18:09:42.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 120, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (78, '2018-07-18 10:16:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'赊账', N'2', 48, NULL, N'超级管理员', '2019-09-18 18:09:42.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 70, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (79, '2018-07-18 10:16:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'抵扣', N'3', 48, NULL, N'超级管理员', '2019-09-18 18:09:42.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 100, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (86, '2018-07-19 11:34:35.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'App首页', N'AppHome', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (89, '2018-07-20 17:35:36.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'加入会议', N'JoinMeeting', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (90, '2018-07-23 10:04:45.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'男', N'0', 49, NULL, N'测试超级管理员', '2018-07-23 11:10:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (91, '2018-07-23 10:04:45.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'女', N'1', 49, NULL, N'测试超级管理员', '2018-07-23 11:10:28.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (92, '2018-07-23 10:44:14.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'修改密码', N'ApiModifyPwd', 31, 0, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (93, '2018-07-23 13:51:27.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'加入我们', N'JoinUs', 31, 0, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (96, '2018-07-23 15:36:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'未启用', N'0', 50, 1, N'超级管理员', '2019-08-16 18:17:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (97, '2018-07-23 15:36:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'已启用', N'1', 50, 1, N'超级管理员', '2019-08-16 18:17:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (98, '2018-07-23 15:36:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'已删除', N'2', 50, 1, N'超级管理员', '2019-08-16 18:17:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (101, '2018-07-24 15:45:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'否', N'0', 52, 0, N'超级管理员', '2019-09-18 17:32:36.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (102, '2018-07-24 15:45:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'是', N'1', 52, 0, N'超级管理员', '2019-09-18 17:32:36.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (104, '2018-07-25 18:51:07.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'iPhone测试', N'IPhoneTest', 31, 0, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (109, '2018-08-07 13:53:57.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'PC后台上传', N'0', 53, 0, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (110, '2018-08-07 13:53:57.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'专家提问', N'1', 53, 0, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (111, '2018-08-07 13:53:57.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'公开提问', N'2', 53, 0, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (112, '2018-08-07 13:53:57.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'首面轮播', N'3', 53, 0, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (128, '2018-08-29 15:54:21.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'是', N'1', 59, 0, N'超级管理员', '2019-11-01 10:05:12.677', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (129, '2018-08-29 15:54:21.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'否', N'0', 59, 1, N'超级管理员', '2019-11-01 10:05:12.673', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (130, '2018-09-04 16:13:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'测试超级管理员', N'安格斯', N'1', 36, 1, N'超级管理员', '2020-01-05 19:01:22.367', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (137, '2018-09-05 15:45:49.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'是', N'1', 60, 1, N'超级管理员', '2019-11-24 14:40:13.917', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 2, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (138, '2018-09-05 15:45:49.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'否', N'0', 60, 1, N'超级管理员', '2019-11-24 14:40:13.917', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 1, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (142, '2019-08-20 09:57:54.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'是', N'1', 62, 1, N'超级管理员', '2019-09-18 15:23:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, N'1')
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (143, '2019-08-20 09:57:54.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'否', N'0', 62, 1, N'超级管理员', '2019-09-18 15:23:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, N'测试')
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (144, '2019-08-21 16:40:50.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'刷新Token', N'ReplaceToeken', 31, NULL, N'超级管理员', '2019-08-21 16:44:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 110, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (145, '2019-08-21 16:49:43.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'Info', N'3', 30, NULL, NULL, NULL, '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (147, '2019-08-28 14:54:11.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'xxxxx', N'2', 62, 1, N'超级管理员', '2019-09-18 15:23:10.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 99, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (149, '2019-09-18 19:25:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'发货', N'1', 64, 1, N'超级管理员', '2019-11-01 10:04:20.837', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, N'fd')
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (150, '2019-09-18 19:25:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'退货', N'2', 64, 0, N'超级管理员', '2019-11-01 10:04:20.837', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, N'fs')
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (151, '2019-09-18 19:25:47.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'返单', N'3', 64, 1, N'超级管理员', '2019-11-01 10:04:20.833', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, N'xx')
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (152, '2019-09-19 10:07:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'家居', N'家居', 65, 1, N'超级管理员', '2020-02-07 17:57:12.107', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (153, '2019-09-19 10:07:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'男装', N'男装', 65, 1, N'超级管理员', '2020-02-07 17:57:12.103', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 4, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (154, '2019-09-19 10:07:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'女装', N'女装', 65, NULL, N'超级管理员', '2020-02-07 17:57:12.103', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 6, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (155, '2019-09-19 10:07:23.000', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'超级管理员', N'食品', N'食品', 65, NULL, N'超级管理员', '2020-02-07 17:57:12.047', '1BEC90E1-9780-472F-90C2-0C6390C044A4', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (423, '2020-08-14 17:05:16.593', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'全部', N'0', 69, 1, NULL, NULL, NULL, 1, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (424, '2020-08-14 17:05:16.607', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'分公司', N'1', 69, 1, NULL, NULL, NULL, 2, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (425, '2020-08-14 17:05:16.610', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'部门', N'2', 69, 1, NULL, NULL, NULL, 3, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (426, '2020-08-14 17:05:16.610', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'个人', N'3', 69, 1, NULL, NULL, NULL, 4, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (427, '2020-08-14 17:05:16.610', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'无', N'4', 69, 1, NULL, NULL, NULL, 5, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (428, '2020-08-21 11:11:02.623', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'主提单号', N'mblno', 73, 1, N'系统管理员', '2020-08-21 11:12:29.673', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 1, N'1')
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (432, '2020-09-16 16:13:57.040', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'普通棉花', N'普通棉花', 86, 0, N'系统管理员', '2020-11-23 15:01:35.443', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 80, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (433, '2020-09-16 16:15:00.283', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'散装橡胶', N'散装橡胶', 86, 0, N'系统管理员', '2020-11-23 15:01:35.443', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 50, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (434, '2020-09-17 10:35:41.583', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'单票', N'单票', 90, 0, N'系统管理员', '2020-11-16 08:44:37.670', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 2, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (435, '2020-09-17 10:35:41.573', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'计费单位', N'计费单位', 90, 0, N'系统管理员', '2020-11-16 08:44:37.670', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 1, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (438, '2020-09-21 14:01:23.820', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'吨', N'吨', 94, 1, N'系统管理员', '2020-09-21 14:11:51.717', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 4, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (439, '2020-09-21 14:01:23.830', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'立方米', N'立方米', 94, 0, N'系统管理员', '2020-09-21 14:11:51.717', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 3, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (440, '2020-09-21 14:01:23.830', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'千克', N'千克', 94, 0, N'系统管理员', '2020-09-21 14:11:51.717', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 2, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (441, '2020-09-21 14:01:23.833', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'件', N'件', 94, 0, N'系统管理员', '2020-09-21 14:11:51.703', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 1, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (442, '2020-09-21 15:33:18.487', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'是', N'true', 95, 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', 1, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (443, '2020-09-21 15:33:18.500', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'否', N'false', 95, 1, NULL, NULL, '00000000-0000-0000-0000-000000000000', 2, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (444, '2020-09-27 10:44:33.807', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'是', N'1', 76, 1, N'系统管理员', '2020-09-27 10:47:22.137', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 2, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (445, '2020-09-27 10:44:33.793', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'否', N'0', 76, 1, N'系统管理员', '2020-09-27 10:47:22.137', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 1, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (446, '2020-11-17 16:04:02.640', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'羊毛', N'羊毛', 86, 0, N'系统管理员', '2020-11-23 15:01:35.443', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 20, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (447, '2020-11-23 15:00:47.540', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'托盘橡胶', N'托盘橡胶', 86, 0, N'系统管理员', '2020-11-23 15:01:35.443', '1BEC90E1-9780-472F-90C2-0C6390C044A4', 90, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (448, '2020-11-23 15:01:35.443', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'棉纱', N'棉纱', 86, 0, NULL, NULL, '00000000-0000-0000-0000-000000000000', 91, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (449, '2020-11-23 15:01:35.447', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'纸浆', N'纸浆', 86, 0, NULL, NULL, '00000000-0000-0000-0000-000000000000', 92, NULL)
GO
INSERT INTO [dbo].[Sys_DictionaryList]([DicList_ID], [CreateDate], [CreateID], [Creator], [DicName], [DicValue], [Dic_ID], [Enable], [Modifier], [ModifyDate], [ModifyID], [OrderNo], [Remark]) VALUES (450, '2020-11-23 15:01:35.447', '1BEC90E1-9780-472F-90C2-0C6390C044A4', N'系统管理员', N'颗粒', N'颗粒', 86, 0, NULL, NULL, '00000000-0000-0000-0000-000000000000', 93, NULL)
GO
set IDENTITY_INSERT [Sys_DictionaryList] OFF
set IDENTITY_INSERT [Sys_Menu] ON
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (2, N'基础信息', N'[{"text":"查询","value":"Search"}]', N'ios-people', NULL, 1, 1600, N'.', 0, NULL, '2017-08-28 12:21:13.000', N'2017-08-28 11:12:45', '2020-11-12 18:52:08.067', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (3, N'角色管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 3, N'Sys_Role', 2, N'/Sys_Role/Manager', '2017-09-12 16:20:02.000', N'2017-08-28 14:19:13', '2020-08-14 17:58:18.160', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (5, N'日志管理', N'[{"text":"查询","value":"Search"}]', N'ios-chatbubbles', NULL, 1, 1300, N'xxx', 61, N'/', '2017-09-22 17:59:37.000', N'2017-09-22 17:59:37', '2020-11-13 00:48:36.997', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (6, N'系统日志', N'[{"text":"查询","value":"Search"},{"text":"删除","value":"Delete"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 0, N'Sys_Log', 5, N'/Sys_Log/Manager', '2017-09-22 18:00:25.000', N'2017-09-22 18:0:25', '2019-08-14 16:20:35.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (7, N'角色权限分配', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 0, 10, N'Sys_Role', 2, N'/Sys_Role/TreeManager', NULL, NULL, '2019-09-19 15:15:54.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (8, N'图表', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 10000, N'/', 32, N'chart', NULL, NULL, '2020-04-05 21:20:29.177', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (9, N'用户管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 1, N'Sys_User', 2, N'/Sys_User/Manager', NULL, NULL, '2020-11-12 18:54:05.573', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (13, N'表单+图表', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 800, N'App_Transaction', 55, N'/multi3', '2017-08-28 14:22:08.000', N'null', '2019-11-08 19:03:23.187', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (17, N'用户注册信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 0, 5, N'Sys_UserRegisterRecord', 2, N'/Sys_UserRegisterRecord/Manager', NULL, NULL, '2020-11-12 19:01:57.957', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (24, N'后台加载table数据', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 750, N'/', 56, N'/table', NULL, NULL, '2019-09-20 14:59:25.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (25, N'其他组件', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1100, N'/', 29, N'/form6', NULL, NULL, '2019-09-20 12:44:50.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (28, N'基础可编辑table', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1500, N'vtable', 29, N'table1', NULL, NULL, '2020-09-08 17:25:29.363', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (29, N'其他组件', N'[{"text":"查询","value":"Search"}]', N'md-build', NULL, 1, 1690, N'/', 45, N'', NULL, NULL, '2020-11-03 10:43:55.707', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (31, N'表单一对多table', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 950, N'App_TransactionAvgPrice1', 55, N'/multi1', NULL, NULL, '2019-11-08 17:06:27.160', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (32, N'图表+表单', N'[{"text":"查询","value":"Search"}]', N'ios-pie', NULL, 1, 1720, N'/', 45, N'', NULL, NULL, '2020-11-03 10:43:34.380', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (33, N'tables', N'[{"text":"查询","value":"Search"}]', N'ios-keypad', NULL, 1, 1710, N'tables', 29, N'/', NULL, NULL, '2020-09-08 17:25:13.903', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (34, N'表单与上传下载', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 0, N'表单与上传下载', 84, N'/formUpload', NULL, NULL, '2019-11-24 21:07:25.177', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (35, N'可编辑的table', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 730, N'editTable', 56, N'/editTable', NULL, NULL, '2019-09-20 15:50:21.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (36, N'图表+表单', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 0, N'/', 32, N'formChart', NULL, NULL, '2019-11-09 18:23:53.990', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (37, N'图片上传与预览 ', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 800, N'图片上传与预览 ', 84, N'', NULL, NULL, '2019-11-24 08:24:39.550', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (39, N'用户Token生成记录', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 0, 4, N'x', 2, N'/Sys_UserTokenLog/Manager', NULL, NULL, '2020-11-12 19:01:51.287', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (40, N'api加载table数据', N'[{"text":"查询","value":"Search"}]', N'ivu-icon ivu-icon-ios-add-circle', NULL, 1, 900, N'table2', 33, N'table2', NULL, NULL, '2019-11-10 14:25:09.340', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (42, N'下载已上传文件', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 0, N'下载已上传文件', 84, N'', NULL, NULL, '2019-11-24 08:25:12.490', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (44, N'table+forms', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 800, N'tableForms', 33, N'tableForms', NULL, NULL, '2019-11-10 18:20:36.140', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (45, N'不用节点', N'', N'', NULL, 0, 0, N'/', 0, NULL, NULL, NULL, '2020-05-05 13:20:14.130', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (48, N'Table+单表数据', N'[{"text":"查询","value":"Search"}]', N'ios-apps', NULL, 1, 2000, N'Table+表单数据', 45, N'/', '2019-07-12 13:26:32.000', N'超级管理员', '2020-11-03 10:39:58.480', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (49, N'基础表单+编辑只读', N'[{"text":"查询","value":"Search"},{"text":"导出","value":"Export"},{"text":"test","value":"test"}]', N'', NULL, 1, 1000, N'App_Appointment', 48, N'/App_Appointment', '2019-07-12 13:28:17.000', N'超级管理员', '2020-03-17 12:56:33.107', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (50, N'自动绑定下拉框', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 900, N'App_TransactionAvgPrice', 48, N'/App_TransactionAvgPrice', '2019-07-12 13:53:32.000', N'超级管理员', '2020-04-07 21:47:48.153', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (51, N'自定义扩展一对多', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 800, N'App_ReportPrice', 74, N'/App_ReportPrice', '2019-07-12 13:55:21.000', N'超级管理员', '2020-04-03 21:58:21.133', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (52, N'导入导出表单', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 600, N'App_Transaction', 48, N'/App_Transaction', '2019-07-12 13:56:15.000', N'超级管理员', '2019-10-31 10:09:00.100', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (53, N'混合表单一对多', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 900, N'App_ReportPrice', 55, N'/multi2', '2019-07-12 13:57:05.000', N'超级管理员', '2019-11-08 19:03:19.680', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (54, N'主从表单明细一对多', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 10, N'SellOrder1', 55, N'/multi4', '2019-07-12 13:57:56.000', N'超级管理员', '2020-04-03 21:57:16.087', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (55, N'表单一对多', N'[{"text":"查询","value":"Search"}]', N'md-cube', NULL, 1, 1740, N'/', 45, NULL, '2019-07-12 13:58:34.000', N'超级管理员', '2020-11-03 10:43:28.097', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (56, N'表单布局', N'[{"text":"查询","value":"Search"}]', N'md-podium', NULL, 1, 1750, N'/', 45, NULL, '2019-07-12 14:00:19.000', N'超级管理员', '2020-11-03 10:43:22.337', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (57, N'单列表单', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1000, N'.', 56, N'/form1', '2019-07-12 14:01:12.000', N'超级管理员', '2020-04-05 21:11:52.390', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (58, N'两列表单', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 900, N'两列表单', 56, N'/form2', '2019-07-12 14:01:43.000', N'超级管理员', '2019-09-20 13:59:03.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (59, N'多列表单', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 800, N'多列表单', 56, N'/form3', '2019-07-12 14:02:17.000', N'超级管理员', '2020-04-07 21:48:03.980', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (60, N'Table+表单', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 700, N'Table+表单', 56, N'/form4', '2019-07-12 14:03:14.000', N'超级管理员', '2019-09-20 13:59:09.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (61, N'系统', N'[{"text":"查询","value":"Search"}]', N'ios-cog', NULL, 1, 1000, N'系统', 0, N'/', '2019-07-12 14:04:04.000', N'超级管理员', '2020-02-02 20:53:12.627', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (62, N'菜单设置', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1000, N'Sys_Menu', 61, N'/sysmenu', '2019-07-12 14:04:35.000', N'超级管理员', '2020-09-23 13:53:19.640', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (63, N'下拉框绑定设置', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 900, N'Sys_Dictionary', 61, N'/Sys_Dictionary', '2019-07-12 14:05:58.000', N'超级管理员', '2020-09-23 13:53:26.923', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (64, N'代码在线生成器', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1500, N'代码在线生成器', 5, N'/coding', '2019-07-12 14:07:55.000', N'超级管理员', '2020-11-16 16:09:28.570', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (65, N'Vue+后台代码生成', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 10, N'/', 64, N'/coder', '2019-07-12 14:08:58.000', N'超级管理员', '2019-08-14 16:15:02.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (66, N'编辑器与HTML', N'[{"text":"查询","value":"Search"}]', N'md-options', NULL, 1, 1520, N'静态页面发布', 29, N'/', '2019-07-12 14:12:38.000', N'超级管理员', '2020-09-08 17:25:24.360', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (67, N'静态页面发布', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 0, N'App_News', 66, N'/App_News', '2019-07-12 14:14:16.000', N'超级管理员', '2019-12-22 14:46:38.830', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (68, N'审核、启用图片支持', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 700, N'App_Expert', 48, N'/App_Expert', '2019-07-12 14:24:15.000', N'超级管理员', '2020-04-02 18:34:49.170', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (69, N'前端自定义扩展', N'', N'', NULL, 0, 500, N'前端自定义扩展', 48, N'/coding', '2019-07-12 14:26:25.000', N'超级管理员', '2019-11-17 19:10:35.503', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (70, N'后台自定义扩展', N'', N'', NULL, 0, 400, N'后台自定义扩展', 48, N'/coding', '2019-07-12 14:28:45.000', N'超级管理员', '2019-11-17 19:10:37.867', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (71, N'角色权限管理', N'[{"text":"查询","value":"Search"},{"text":"编辑","value":"Update"}]', N'ivu-icon ivu-icon-ios-boat', NULL, 1, 2, N'Sys_Role', 2, N'/permission', '2019-08-10 10:25:36.000', N'超级管理员', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (72, N'移动H5开发', N'[{"text":"查询","value":"Search"}]', N'logo-apple', NULL, 1, 1650, N'/', 45, N'', '2019-08-14 13:16:06.000', N'超级管理员', '2020-08-26 16:52:21.363', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (73, N'移动H5开发打包介绍', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, NULL, N'/', 72, N'/app/guide', '2019-08-14 13:16:55.000', N'超级管理员', NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (74, N'一对一与一对多', N'[{"text":"查询","value":"Search"}]', N'ios-color-filter', NULL, 1, 1770, N'/', 45, N'/', '2019-08-22 17:43:58.000', N'超级管理员', '2020-11-03 10:40:06.487', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (75, N'主从一对一', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 1000, N'SellOrder', 74, N'/SellOrder', '2019-08-22 18:12:43.000', N'超级管理员', '2020-04-03 21:57:49.450', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (77, N'表单只读', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 600, N'表单只读', 56, N'/form7', '2019-08-26 11:58:55.000', N'超级管理员', '2019-09-20 13:59:13.000', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (84, N'文件上传与下载', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'ios-folder-open', NULL, 1, 1700, N'文件上传与下载', 45, N'/', '2019-11-11 12:59:02.637', N'超级管理员', '2020-11-03 10:43:44.960', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (85, N'基本文件上传', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1000, N'基本文件上传', 84, N'/volUploadExample', '2019-11-20 18:03:07.417', N'超级管理员', '2019-12-17 11:18:34.193', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (86, N'可复用后台校验', N'[{"text":"查询","value":"Search"}]', N'logo-rss', NULL, 1, 1700, N'/', 45, N'', '2019-11-22 11:17:21.897', N'超级管理员', '2020-11-03 10:43:51.513', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (87, N'KindEditor编辑器', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1000, N'KindEditor编辑器', 66, N'/kindEditor', '2019-12-19 11:37:30.843', N'超级管理员', '2019-12-23 10:01:38.163', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (88, N'静态页面列表', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 900, N'htmlList', 66, N'/htmlList', '2019-12-22 14:31:21.500', N'超级管理员', '2019-12-23 10:01:42.770', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (89, N'后台参数校验', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 1700, N'.', 86, N'/validator', '2020-02-02 17:00:05.203', N'超级管理员', '2020-02-02 17:00:49.313', N'超级管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (90, N'从表图片上传', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 0, N'vSellOrderImg', 74, N'/vSellOrderImg', '2020-04-07 20:41:33.930', N'超级管理员', '2020-04-03 21:58:21.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (91, N'数字排版', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 0, N'数字排版', 32, N'/flex', '2020-04-07 21:51:38.487', N'超级管理员', '2019-11-09 18:23:53.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (92, N'树形菜单与表', N'[{"text":"查询","value":"Search"}]', N'md-analytics', NULL, 1, 1705, N'树形菜单与表', 45, N'', '2020-04-26 14:19:01.283', N'超级管理员', '2020-11-03 10:43:39.040', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (93, N'tree与代码生成页面', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 1000, N'tree与代码生成页面', 92, N'treetable1', '2020-04-26 14:20:35.840', N'超级管理员', '2020-04-26 14:19:51.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (94, N'tree与自定义table', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 0, N'treetable2', 92, N'/treetable2', '2020-04-26 18:12:46.497', N'超级管理员', '2020-04-26 14:19:51.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (95, N'放此节点下', N'', N'', NULL, 1, 1, N'/', 45, N'', '2020-05-05 13:20:30.740', N'超级管理员', '2019-09-20 09:54:26.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (96, N'作家信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"},{"text":"提交审核","value":"Submit"},{"text":"撤回","value":"Recall"},{"text":"驳回","value":"Reject"}]', N'md-body', NULL, 1, 1, N'WRITER_HEAD', 74, N'/WRITER_HEAD', '2020-08-13 10:26:07.920', N'系统管理员', '2020-09-11 17:23:53.373', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (97, N'权限范围', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 5, N'Vw_Sys_User_Authority_Range', 45, N'Vw_Sys_User_Authority_Range/Manager', '2020-08-14 17:30:20.490', N'系统管理员', '2020-11-06 15:26:54.830', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (98, N'仓储管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 2100, N'仓储管理', 0, N'', NULL, N'1BEC90E1-9780-472F-90C2-0C6390C044A4', '2020-11-26 16:10:05.233', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (99, N'库存原始表', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 50, N'Vw_Op_Wms', 45, N'/Vw_Op_Wms', NULL, N'1BEC90E1-9780-472F-90C2-0C6390C044A4', '2020-12-29 15:23:00.790', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (102, N'账册信息管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"上传","value":"Upload"}]', N'', NULL, 1, 10, N'INFO_ACCBOOK', 2, N'/INFO_ACCBOOK', '2020-08-26 11:06:04.527', N'系统管理员', '2020-12-03 10:14:53.147', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (103, N'仓库与库位', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"},{"text":"上传","value":"Upload"},{"text":"审核","value":"Audit"}]', N'', NULL, 1, 15, N'OP_WMS_STOREHOUSE', 2, N'/OP_WMS_STOREHOUSE', '2020-08-26 11:07:40.553', N'系统管理员', '2020-11-12 18:52:51.793', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (104, N'入库执行', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"入库执行","value":"Do1"},{"text":"入库执行取消","value":"UnDo1"},{"text":"入库完成","value":"Do2"},{"text":"入库完成取消","value":"UnDo2"},{"text":"推进状态","value":"PushStatus"},{"text":"入库审核","value":"Do3"},{"text":"入库审核取消","value":"UnDo3"}]', N'', NULL, 1, 90, N'VW_OP_WMS_IN_DO', 98, N'/VW_OP_WMS_IN_DO', '2020-08-26 14:09:07.277', N'系统管理员', '2020-09-26 21:00:45.533', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (105, N'入库计划', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 100, N'OP_WMS_IN_PLAN', 98, N'/OP_WMS_IN_PLAN', '2020-08-27 11:33:33.520', N'系统管理员', '2020-12-22 15:42:58.167', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (106, N'商品信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 40, N'Code_goods', 2, N'/Code_goods', '2020-09-16 17:19:50.897', N'系统管理员', '2020-11-12 18:52:41.737', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (107, N'协议客户费率维护', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 46, N'OP_WMS_FEERATE', 98, N'/OP_WMS_FEERATE', '2020-09-17 10:54:09.650', N'系统管理员', '2020-10-14 15:58:05.250', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (108, N'工作量系数表', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 12, N'OP_WMS_WORKNAME', 2, N'OP_WMS_WORKNAME', '2020-09-21 16:27:26.223', N'系统管理员', '2020-11-12 18:53:15.773', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (109, N'任务状态表', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 600, N'Sys_Task_State', 61, N'/Sys_Task_State', '2020-09-23 11:56:08.833', N'系统管理员', '2020-09-23 13:53:32.247', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (110, N'任务动作表', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 599, N'Sys_Task_Execution', 61, N'/Sys_Task_Execution', '2020-09-23 13:52:59.677', N'系统管理员', '2020-09-23 13:54:11.847', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (111, N'任务动作执行', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 598, N'Sys_Task_Progress_Index', 61, N'/Sys_Task_Progress_Index', '2020-09-23 14:25:29.323', N'系统管理员', '2020-09-23 13:54:11.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (112, N'出库计划', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 80, N'OP_WMS_OUT_PLAN', 98, N'/OP_WMS_OUT_PLAN', '2020-09-24 09:18:02.777', N'系统管理员', '2020-10-13 14:18:30.407', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (113, N'订餐', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 0, N'lunch_head', 74, N'lunch_head', '2020-09-25 17:55:15.427', N'系统管理员', '2020-09-11 17:23:53.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (115, N'库位出租', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 18, N'OP_WMS_STOREHOUSE_LETOUT', 98, N'OP_WMS_STOREHOUSE_LETOUT', '2020-09-29 09:15:08.537', N'系统管理员', '2020-09-17 10:52:19.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (116, N'仓储月结账单', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"},{"text":"计算月结仓储费","value":"DUIMAKEFEE"}]', N'', NULL, 1, 48, N'VW_OP_WMS_FEEDUI_STORAGE', 98, N'VW_OP_WMS_FEEDUI_STORAGE', '2020-09-29 16:22:25.077', N'系统管理员', '2020-11-03 11:51:28.590', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (117, N'货权转移', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"执行货转","value":"DoTrans"},{"text":"取消执行货转","value":"UnDoTrans"},{"text":"推进状态","value":"PushStatus"}]', N'', NULL, 1, 52, N'VW_OP_WMS_TRANSFERGOODS', 98, N'VW_OP_WMS_TRANSFERGOODS', '2020-10-14 15:58:44.963', N'系统管理员', '2020-11-20 17:06:55.003', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1118, N'移库', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"移库执行","value":"DoMove"},{"text":"取消移库","value":"UnDoMove"},{"text":"推进状态","value":"PushStatus"}]', N'', NULL, 1, 51, N'VW_OP_WMS_MOVE', 98, N'VW_OP_WMS_MOVE', '2020-10-23 14:42:12.603', N'冯夏青', '2020-11-20 17:06:42.040', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1119, N'仓库盘点', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"盘点结果提交","value":"CheckSubmit"},{"text":"盘点撤销提交","value":"CheckRecall"},{"text":"盘点审核确认","value":"CheckAudit"},{"text":"推进状态","value":"PushStatus"}]', N'', NULL, 1, 49, N'VW_OP_WMS_CHECK', 98, N'VW_OP_WMS_CHECK', '2020-10-27 09:07:51.367', N'冯夏青', '2020-11-20 17:06:44.853', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1120, N'库位效果图', N'', N'', NULL, 1, 9, N'OP_WMS_STORAGEAREA_SKETCH', 98, N'OP_WMS_STORAGEAREA_SKETCH', '2020-10-29 16:53:40.920', N'系统管理员', '2020-10-29 16:54:44.923', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1121, N'过磅作业', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 60, N'VW_OP_WMS_WEIGH', 98, N'VW_OP_WMS_WEIGH', '2020-10-29 22:12:20.193', N'冯夏青', '2020-11-24 11:49:05.433', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1122, N'电子档案', N'[{"text":"查询","value":"Search"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 45, N'VW_INFO_FILES', 98, N'VW_INFO_FILES', '2020-10-31 11:06:47.863', N'冯夏青', '2020-10-31 11:21:16.020', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1123, N'出库作业单', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"出库完毕","value":"LoadingFinish"},{"text":"审核完毕","value":"CarryoutFinish"},{"text":"推进状态","value":"PushStatus"}]', N'', NULL, 1, 70, N'OP_WMS_OUT_DO', 98, N'/OP_WMS_OUT_DO', '2020-11-01 09:57:27.480', N'系统管理员', '2020-11-20 17:00:16.753', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1124, N'库位位置维护', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 13, N'VW_OP_WMS_STOREHOUSE_AREA_POSITION', 2, N'VW_OP_WMS_STOREHOUSE_AREA_POSITION', '2020-11-01 17:16:21.133', N'冯夏青', '2020-11-12 18:53:05.907', N'系统管理员')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1125, N'数据查询', N'[{"text":"查询","value":"Search"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 110, N'数据查询', 98, N'', '2020-11-01 23:14:52.960', N'冯夏青', '2020-12-08 11:16:17.930', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1126, N'当前库存查询', N'[{"text":"查询","value":"Search"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 1000, N'VW_OP_WMS_AREAGOODS', 1125, N'VW_OP_WMS_AREAGOODS', '2020-11-01 23:15:40.557', N'冯夏青', '2020-12-08 11:16:29.737', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1127, N'打印格式列表', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"}]', N'', NULL, 1, 1, N'SYS_PRINTINFO', 2, N'SYS_PRINTINFO', '2020-11-12 22:49:50.350', N'冯夏青', '2020-11-23 16:19:18.400', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1128, N'工作量统计', N'[{"text":"查询","value":"Search"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 10, N'VW_OP_WMS_WORKTOTAL', 1125, N'VW_OP_WMS_WORKTOTAL', '2020-11-13 00:21:44.840', N'系统管理员', '2020-11-01 23:14:58.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1129, N'入库统计', N'[{"text":"查询","value":"Search"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 900, N'VW_OP_REP_WMSINDO', 1125, N'VW_OP_REP_WMSINDO', '2020-11-20 18:07:30.617', N'冯夏青', '2020-11-16 16:20:49.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1130, N'出库统计', N'[{"text":"查询","value":"Search"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 800, N'VW_OP_REP_WMSOUTDO', 1125, N'VW_OP_REP_WMSOUTDO', '2020-11-21 17:03:57.563', N'冯夏青', '2020-11-16 16:20:49.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1131, N'装卸工/叉车工维护', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 50, N'wms_stevedores', 2, N'wms_stevedores', '2020-11-21 17:52:18.327', N'冯夏青', '2020-11-12 18:53:15.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1132, N'Ch_fee', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"提交","value":"PushStatus"}]', N'', NULL, 1, 10, N'Ch_fee', 45, N'Ch_fee', '2020-11-23 16:05:39.777', N'冯夏青', '2020-11-23 16:07:47.187', N'冯夏青')
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1133, N'进口业务', N'[{"text":"查询","value":"Search"}]', N'', NULL, 1, 2200, N'进口业务', 0, N'', '2020-11-26 16:10:29.437', N'冯夏青', '2020-11-26 16:09:46.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1134, N'海运进口', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 0, N'Op_seai', 1133, N'Op_seai', '2020-11-26 16:11:31.117', N'冯夏青', '2020-11-26 16:09:46.000', NULL)
GO
INSERT INTO [dbo].[Sys_Menu]([Menu_Id], [MenuName], [Auth], [Icon], [Description], [Enable], [OrderNo], [TableName], [ParentId], [Url], [CreateDate], [Creator], [ModifyDate], [Modifier]) VALUES (1135, N'库存初始化', N'[{"text":"查询","value":"Search"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'', NULL, 1, 0, N'VW_OP_WMS_IMPORT', 61, N'/VW_OP_WMS_IMPORT', '2020-12-29 16:09:43.917', N'冯夏青', '2020-12-30 14:11:43.353', N'冯夏青')
GO
set IDENTITY_INSERT [Sys_Menu] OFF
set IDENTITY_INSERT [Sys_Task_Execution] ON
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (10, '录入-执行', NULL, NULL, NULL, NULL, NULL, '入库执行', 1001)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (11, '执行-待审核', NULL, NULL, NULL, NULL, NULL, '入库录入完成', 1002)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (12, '待审核-完成', NULL, NULL, NULL, NULL, NULL, '入库审核', 1003)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (13, '货转业务执行，生成新库存，核减旧库存', NULL, NULL, NULL, NULL, NULL, '货转执行', 1030)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (14, '取消货转执行，将库存恢复至原状。如果下家库存存在【入库之外的物理库存变动类型】或者【存在费用日历（即生成过月结账单）】则不允许取消', NULL, NULL, NULL, NULL, NULL, '取消货转执行', 10301)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1013, '出库执行,出库执行单由仓库确认接受', NULL, NULL, NULL, NULL, NULL, '出库执行', 1010)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1014, '出库执行取消 退回录入状态', NULL, NULL, NULL, NULL, NULL, '出库执行_取消', 10101)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1015, '出库装货完成', NULL, NULL, NULL, NULL, NULL, '出库装货完成', 1011)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1016, '出库装货完成取消 退回出库执行状态', NULL, NULL, NULL, NULL, NULL, '出库装货完成_取消', 10111)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1017, '出库完成', NULL, NULL, NULL, NULL, NULL, '出库完成', 1012)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1018, '出库完成取消 退回出库装货完成状态', NULL, NULL, NULL, NULL, NULL, '出库完成_取消', 10121)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1019, '执行移库', NULL, NULL, NULL, NULL, NULL, '执行移库', 1040)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1020, '移库取消', '', NULL, NULL, NULL, NULL, NULL, 10401)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1021, '盘点撤销提交', '', NULL, NULL, NULL, NULL, NULL, 10501)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1022, '盘点审核通过', '', NULL, NULL, NULL, NULL, NULL, 1051)
GO
INSERT INTO [dbo].[Sys_Task_Execution]([ID], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [NAME], [STATEKEY]) VALUES (1023, '盘点提交审核', '', NULL, NULL, NULL, NULL, NULL, 1050)
GO
set IDENTITY_INSERT [Sys_Task_Execution] OFF
set IDENTITY_INSERT [Sys_Task_Progress_Index] ON
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (12, '1001', NULL, '0', '1001', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (13, '1002', NULL, '1001', '1002', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (14, '1003', NULL, '1002', '1003', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (15, '10011', NULL, '1001', '0', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (16, '10021', NULL, '1002', '1001', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (17, '10031', NULL, '1003', '1002', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (18, '1030', NULL, '3100', '1030', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (19, '10301', NULL, '1030', '3100', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1018, '1010', NULL, '1000', '1010', '', '', '', '', '')
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1019, '10101', NULL, '1010', '1000', '', '', '', '', '')
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1020, '1011', NULL, '1010', '1011', '', '', '', '', '')
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1021, '10101', NULL, '1011', '1010', '', '', '', '', '')
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1022, '1012', NULL, '1011', '1012', '', '', '', '', '')
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1023, '10121', NULL, '1012', '1011', '', '', '', '', '')
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1024, '1040', NULL, '1000', '1040', '', '', '', '', '')
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1025, '10401', '', '1040', '1000', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1026, '1050', '', '1000', '1050', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1027, '1051', '', '1050', '1051', NULL, NULL, NULL, NULL, NULL)
GO
INSERT INTO [dbo].[Sys_Task_Progress_Index]([ID], [EXECUTIONID], [DESCRIPTION], [CURRENTSTATEID], [FINISHSTATEID], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5]) VALUES (1028, '10501', '', '1050', '1000', NULL, NULL, NULL, NULL, NULL)
GO
set IDENTITY_INSERT [Sys_Task_Progress_Index] OFF
set IDENTITY_INSERT [Sys_Task_State] ON
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (9, '录入状态', NULL, NULL, NULL, NULL, NULL, NULL, 1000)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (10, '入库执行', '操作将入库执行单推给理货', NULL, NULL, NULL, NULL, NULL, 1001)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (11, '入库待审核', '理货录入件数重量备注，入库工作量，推送至仓库管理员审核', NULL, NULL, NULL, NULL, NULL, 1002)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (12, '入库完成', '仓库管理员审核数据并通过；
生成费用；生成操作工作量；根据入库计划的费率生成入库费用；同时向库存表中生成仓储费率', NULL, NULL, NULL, NULL, NULL, 1003)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (13, '货转执行', NULL, NULL, NULL, NULL, NULL, NULL, 1030)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (1013, '出库受理', '出库执行单由仓库确认接受，开始填写实际出库数量', NULL, NULL, NULL, NULL, NULL, 1010)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (1014, '出库完成', '实际出库数量填写完成，等待生成费用和缴费确认', NULL, NULL, NULL, NULL, NULL, 1011)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (1015, '审核完成', '生成费用，缴费确认已收到，准许放行', NULL, NULL, NULL, NULL, NULL, 1012)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (1016, '移库完成', '确认移库', NULL, NULL, NULL, NULL, NULL, 1040)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (1017, '盘点提交审核', '盘点完成提交审核', NULL, NULL, NULL, NULL, NULL, 1050)
GO
INSERT INTO [dbo].[Sys_Task_State]([ID], [NAME], [DESCRIPTION], [PROP1], [PROP2], [PROP3], [PROP4], [PROP5], [STATEKEY]) VALUES (1018, '盘点审核通过', '盘点审核通过', NULL, NULL, NULL, NULL, NULL, 1051)
set IDENTITY_INSERT [Sys_Task_State] OFF
update [user] set role_id=1 where CODENAME='admin'
INSERT INTO [dbo].[Sys_Role_Core]([CreateDate], [Creator], [DeleteBy], [DeptName], [Dept_Id], [Enable], [Modifier], [ModifyDate], [OrderNo], [ParentId], [RoleName], [Role_Id], [LimitCompanyRange]) VALUES ('2018-08-23 11:46:06.000', '超级管理员', NULL, N'无', '0', 1, '测试超级管理员', '2018-09-06 17:08:35.000', 1000, '0', N'超级管理员', '1', '0')
Reference in New Issue View Git Blame Copy Permalink