USE [db9pm2c]
GO
/****** Object:  Table [dbo].[SystemSetting]    Script Date: 01/30/2018 12:27:14 ******/
SET IDENTITY_INSERT [dbo].[SystemSetting] ON
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'平米', N'1', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 1)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'块', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 2)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'台', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 3)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'条', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 4)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'个', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 5)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'米', N'2', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 6)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'箱', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 7)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'包', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 8)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'卷', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 9)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'根', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 10)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'份', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 11)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PriceUnit', N'张', N'3', N'0', N'sys', NULL, NULL, NULL, NULL, NULL, NULL, 13)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'AddressOnReport', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 25)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PostCodeOnReport', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 26)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'LogoOnReport', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 27)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'ReceiveNoticeByMail', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 28)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PageSize', N'20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 29)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'EnableStatusTrack', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryEmptyRow', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 31)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryEmptyRowNumber', N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 32)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderEmptyRow', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 33)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderEmptyRowNumber', N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 34)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'OrderEditModels', N'true,true', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'FactoryOrderEditModels', N'true,true', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 36)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'OrderEditDefaultModel', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 37)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'ImgOnDeliveryPrint', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 38)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'ImgOnOrderPrint', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 39)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryMethod', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 40)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderMethod', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 41)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'DeductStock', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 42)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'DeductStockLessThenZero', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 43)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanySalarySetting', N'1', N'247.46,587.73,359.81,1439.26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 44)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanySalarySetting', N'2', N'61.87,247.46,1439.26,3418.23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 45)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanySalarySetting', N'3', N'0,21.65,0,125.936', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 46)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanySalarySetting', N'4', N'0,14.85,0,86.36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 47)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanySalarySetting', N'5', N'9.28,21.65,53.97,125.93', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 48)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanySalarySetting', N'10', N'248,248,2732,2732', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 49)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PaymentType', N'账户余额', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PaymentType', N'前台现金', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 51)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PaymentType', N'银行转账', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 52)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PaymentType', N'支付宝', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 53)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PaymentType', N'微信', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 54)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'PaymentType', N'其它', N'0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 55)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'EmployeeSalarySetting', N'0', N'true,true,true,true,0,0,0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 56)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'EmployeeSalarySetting', N'1', N'8,19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 57)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'EmployeeSalarySetting', N'2', N'2,8', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 58)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'EmployeeSalarySetting', N'3', N'0,0.7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'EmployeeSalarySetting', N'4', N'0,0.7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'EmployeeSalarySetting', N'5', N'0.3,0.7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 61)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'EmployeeSalarySetting', N'10', N'8,8', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 62)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'AccountTitle', N'购进固定资产支出', N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 63)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'AccountTitle', N'购进耗材支出', N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 64)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'AccountTitle', N'设备租赁支出', N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 65)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'AccountTitle', N'办公场地租赁支出', N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 66)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'AccountTitle', N'员工工资支出', N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 67)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'AccountTitle', N'其它收入', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 68)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'AccountTitle', N'其它支出', N'2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 69)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryOrderNo', N'true', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 70)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryMaterial', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 71)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryUnit', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 72)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryMemo', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 73)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallEmptyRow', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 74)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallEmptyRowNumber', N'6', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 75)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallMethod', N'1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 76)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'ImgOnInstallPrint', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 77)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderOrderNo', N'true', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 78)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderMaterial', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 79)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderUnit', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 80)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderMemo', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 81)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallOrderNo', N'true', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 82)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallMaterial', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 83)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallUnit', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 84)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallMemo', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 85)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'WidthUnit', N'm', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 86)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryOrderMemo', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 87)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderOrderMemo', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 88)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallOrderMemo', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 89)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintCommonFontSize', N'14px', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 90)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintCommonMargin', N'5,5,5,5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 91)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintCommonFontName', N'黑体', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 92)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintDeliveryCategory', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintOrderCategory', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 94)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'PrintInstallCategory', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 95)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'01', N'客户订单', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 96)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'02', N'外协订单', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 97)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'03', N'客户管理', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 98)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'04', N'财务管理', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 99)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'05', N'人力资源', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 100)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'06', N'统计报表', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 101)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'07', N'系统配置', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 102)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'RoleGroup', N'08', N'库存管理', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 103)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0101', N'01', N'订单查询', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 104)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0102', N'01', N'订单创建', N'1', NULL, NULL, NULL, NULL, NULL, NULL, 105)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0103', N'01', N'订单编辑', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 106)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0104', N'01', N'订单删除', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 107)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0105', N'01', N'订单支付', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 108)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0106', N'01', N'流程流转', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 109)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0107', N'01', N'价格查询', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 110)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0109', N'01', N'订单回收站', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 111)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0110', N'01', N'订单金额显示', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 112)
GO
print 'Processed 100 total records'
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0111', N'01', N'附件上传', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 113)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0112', N'01', N'附件删除', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 114)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0113', N'01', N'报价单管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 115)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0201', N'02', N'订单查询', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 116)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0202', N'02', N'订单创建', N'1', NULL, NULL, NULL, NULL, NULL, NULL, 117)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0203', N'02', N'订单编辑', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 118)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0204', N'02', N'订单删除', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 119)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0205', N'02', N'订单支付', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 120)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0206', N'02', N'完工设置', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 121)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0207', N'02', N'价格查询', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 122)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0209', N'02', N'订单回收站', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 123)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0210', N'02', N'订单金额显示', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 124)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0211', N'02', N'附件上传', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 125)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0212', N'02', N'附件删除', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 126)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0301', N'03', N'客户管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 127)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0302', N'03', N'客户创建', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 128)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0303', N'03', N'客户编辑', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 129)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0304', N'03', N'客户删除', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 130)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0305', N'03', N'联系人查询', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 131)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0306', N'03', N'联系人创建', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 132)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0307', N'03', N'联系人编辑', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 133)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0308', N'03', N'联系人删除', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 134)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0309', N'03', N'客户密码重置', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 135)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0310', N'03', N'客户充值', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 136)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0311', N'03', N'客户导入', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 137)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0312', N'03', N'外协管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 138)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0313', N'03', N'客户报价', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 139)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0314', N'03', N'外协报价', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 140)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0401', N'04', N'科目管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 141)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0402', N'04', N'收支明细', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 142)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0403', N'04', N'收支报表', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 143)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0404', N'04', N'客户对账单', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 144)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0405', N'04', N'外协对账单', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 145)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0406', N'04', N'供应商对账', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 146)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0407', N'04', N'成本核算', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 147)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0408', N'04', N'订单账龄统计', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 148)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0501', N'05', N'部门管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 149)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0502', N'05', N'员工管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 150)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0503', N'05', N'社保配置', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 151)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0504', N'05', N'工资管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 152)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0601', N'06', N'分类统计', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 153)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0602', N'06', N'客户排名', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 154)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0603', N'06', N'客户趋势', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 155)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0604', N'06', N'逐月业绩', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 156)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0605', N'06', N'员工绩效', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 157)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0606', N'06', N'订单成本分析', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 158)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0702', N'07', N'参数设置', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 159)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0703', N'07', N'软件授权', N'1', NULL, NULL, NULL, NULL, NULL, NULL, 160)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0704', N'07', N'模板配置', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 161)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0705', N'07', N'流程配置', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 162)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0706', N'07', N'支付方式', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 163)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0707', N'07', N'客户订单状态', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 164)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0708', N'07', N'计价单位', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 165)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0709', N'07', N'数据库备份', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 166)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0801', N'08', N'材料管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 167)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0802', N'08', N'进货管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 168)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0803', N'08', N'出库管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 169)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0804', N'08', N'进货单审核', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 170)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0805', N'08', N'出库单审核', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 171)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0806', N'08', N'供应商管理', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 172)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0807', N'08', N'库存查询', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 173)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'CompanyConfiguration', N'ShowSimpleFactoryItem', N'false', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 174)
INSERT [dbo].[SystemSetting] ([SettingName], [SettingValue1], [SettingValue2], [SettingValue3], [SettingValue4], [SettingValue5], [SettingValue6], [SettingValue7], [SettingValue8], [SettingValue9], [SettingValue10], [Id]) VALUES (N'Permission', N'P0409', N'04', N'订单收款明细', N'0', NULL, NULL, NULL, NULL, NULL, NULL, 175)
SET IDENTITY_INSERT [dbo].[SystemSetting] OFF
/****** Object:  Table [dbo].[Configuration]    Script Date: 01/30/2018 12:27:14 ******/
INSERT [dbo].[Configuration] ([SettingName], [SettingValue]) VALUES (N'DatabaseVersion', N'4.9.0')
INSERT [dbo].[Configuration] ([SettingName], [SettingValue]) VALUES (N'DefaultFactoryTemplate', N'[{"guid":"g914AAB53-67FD-4BB3-A9AE-D96D66AF9273","text":"喷绘","id":"喷绘","reportCategory":"喷绘","priceTip":"","fields":[{"id":"尺寸","type":"1","isRequired":true,"isPriceFactor":false,"formular":"","label":"尺寸"},{"id":"材质","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"材质","options":["喷绘布","黑白布","网格布","刀刮布","油画布","UV软膜"]}]},{"guid":"g37931D9A-5390-41D7-8CAD-ACDEBFB49CA4","text":"展架","id":"展架","reportCategory":"展架","priceTip":"","fields":[{"id":"材质","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"材质","options":["车贴","地贴","灯片","透明亚","透明亮","透明磨砂","相纸","单透"]},{"id":"覆膜","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"覆膜","options":["亚膜","亮膜","磨砂膜"]},{"id":"工艺","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"工艺","options":["无","KT板","PVC(1.5)","PVC板(5)","PVC板(10)","PVC板(15)","X展架","易拉宝","门形展架"]},{"id":"墨水","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"墨水","options":["户内","户外"]},{"id":"尺寸","type":"1","isRequired":true,"isPriceFactor":false,"formular":"","label":"尺寸"}]},{"guid":"g72AD21B0-D8B1-46D6-899A-B01CE08EBA65","text":"印刷(单张)","id":"印刷(单张)","reportCategory":"印刷","priceTip":"","fields":[{"id":"纸张","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"纸张","options":["128","157","200","250","300"]},{"id":"尺寸","type":"1","isRequired":true,"isPriceFactor":false,"formular":"","label":"尺寸"},{"id":"覆膜","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"覆膜","options":["否","是"]}]},{"guid":"g6013B619-A5BC-476B-BD08-603F716158A3","text":"印刷(画册)","id":"印刷(画册)","reportCategory":"印刷","priceTip":"","fields":[{"id":"封面","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"封面","options":["100","128","157","200","250"]},{"id":"内芯","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"内芯","options":["100","128","157","200","250"]},{"id":"覆膜","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"覆膜","options":["否","封面","内芯"]},{"id":"尺寸","type":"1","isRequired":true,"isPriceFactor":false,"formular":"","label":"尺寸"},{"id":"装订方式","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"装订方式","options":["胶装","骑马订"]},{"id":"纸张","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"纸张","options":["双胶","铜板","哑粉","珠光"]},{"id":"页数","type":"1","isRequired":true,"isPriceFactor":false,"formular":"","label":"页数"}]},{"guid":"gFC7C1A1C-A331-4EF7-B00E-2DE9AEBCFD7C","text":"印刷(折页)","id":"印刷(折页)","reportCategory":"印刷","priceTip":"","fields":[{"id":"纸张","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"纸张","options":["128","157","200","250"]},{"id":"尺寸","type":"1","isRequired":false,"isPriceFactor":false,"formular":"","label":"尺寸"},{"id":"折数","type":"1","isRequired":false,"isPriceFactor":false,"formular":"","label":"折数"},{"id":"覆膜","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"覆膜","options":["否","封面","内芯"]}]},{"guid":"gD0034510-E109-4C0F-A685-3D043935B85C","text":"安装","id":"安装","reportCategory":"安装","priceTip":"","fields":[{"id":"安装类型","type":"2","isRequired":true,"isPriceFactor":false,"formular":"","label":"安装类型","options":["室内安装","户外安装"]}]}]')
INSERT [dbo].[Configuration] ([SettingName], [SettingValue]) VALUES (N'DefaultOrderTemplate', N'[{"guid":"gFCE96522-D50C-43E8-B5EA-C30F4AD2A034","text":"标书","id":"标书","reportCategory":"标书","priceTip":"","fields":[{"id":"尺寸","type":"2","isRequired":true,"label":"尺寸","options":["A4","A3","A5"]},{"id":"装订方式","type":"2","isRequired":true,"label":"装订方式","options":["胶装","打孔","骑马订"]},{"id":"彩页","type":"1","isRequired":true,"label":"彩页"},{"id":"黑白","type":"1","isRequired":true,"label":"黑白"},{"id":"是否覆膜","type":"2","isRequired":true,"label":"是否覆膜","options":["是","否"]}]},{"guid":"g3FA8154E-CE82-483E-BEBD-845E335B8725","text":"彩打(单张)","id":"彩打(单张)","reportCategory":"彩打","priceTip":"","fields":[{"id":"纸张","type":"2","isRequired":true,"label":"纸张","options":["128","157","200","250","相纸","不干胶"]},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"覆膜","type":"2","isRequired":true,"label":"覆膜","options":["是","否"]},{"id":"过塑","type":"2","isRequired":true,"label":"过塑","options":["是","否"]}]},{"guid":"gAF1521AC-6DE4-479B-8B16-89B5E497D405","text":"彩打(画册)","id":"彩打(画册)","reportCategory":"彩打","priceTip":"","fields":[{"id":"封面","type":"2","isRequired":true,"label":"封面","options":["128","157","200","250"]},{"id":"内芯","type":"2","isRequired":true,"label":"内芯","options":["128","157","200","250"]},{"id":"覆膜","type":"2","isRequired":true,"label":"覆膜","options":["否","封面","内芯"]},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"装订方式","type":"2","isRequired":true,"label":"装订方式","options":["胶装","骑马订"]}]},{"guid":"gA9CF8531-7718-4B41-827F-F1E07E1C4B0D","text":"彩打(折页)","id":"彩打(折页)","reportCategory":"彩打","priceTip":"","fields":[{"id":"纸张","type":"2","isRequired":true,"label":"纸张","options":["128","157","200","250"]},{"id":"折数","type":"1","isRequired":false,"label":"折数"},{"id":"覆膜","type":"2","isRequired":true,"label":"覆膜","options":["是","否"]},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"}]},{"guid":"gA245434C-0676-4AF1-802B-7D33BD931ED1","text":"耗材","id":"耗材","reportCategory":"写真耗材","priceTip":"","fields":[{"id":"材质","type":"2","isRequired":true,"label":"材质","options":["背胶","PP","亮膜","亚膜","相纸","写真布","灯片"]},{"id":"尺寸","type":"2","isRequired":true,"label":"尺寸","options":["635","914","107","127","152"]},{"id":"克数","type":"2","isRequired":true,"label":"克数","options":["100","120","0"]}]},{"guid":"g99FFA43D-44E0-418F-BA21-51B31286AC47","text":"黑白","id":"黑白","reportCategory":"黑白","priceTip":"","fields":[{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"装订方式","type":"2","isRequired":true,"label":"装订方式","options":["无","胶装","骑马订","对折"]},{"id":"页数","type":"1","isRequired":true,"label":"页数"}]},{"guid":"gCEED3313-C903-43B0-BC3A-4DECE61058DD","text":"横幅","id":"横幅","reportCategory":"横幅","priceTip":"","fields":[{"id":"米数","type":"1","isRequired":true,"label":"米数"}]},{"guid":"gC8288A3B-9332-45B6-9DA4-E8B18ACC015E","text":"即时贴","id":"即时贴","reportCategory":"雕刻","priceTip":"","fields":[{"id":"颜色","type":"1","isRequired":true,"label":"颜色"},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"}]},{"guid":"g528FCAB9-CF7F-4283-820C-E37F914DFFD1","text":"联单","id":"联单","reportCategory":"联单","priceTip":"","fields":[{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"联数","type":"2","isRequired":true,"label":"联数","options":["2","3","4"]},{"id":"纸张","type":"2","isRequired":true,"label":"纸张","options":["无碳复写","再生纸"]},{"id":"页数","type":"2","isRequired":true,"label":"页数","options":["90","100"]},{"id":"装订","type":"2","isRequired":true,"label":"装订","options":["胶头","胶左"]},{"id":"是否打号","type":"2","isRequired":true,"label":"是否打号","options":["是","否"]}]},{"guid":"g434A834C-98F8-4223-9539-713F6D7B4C7C","text":"名片","id":"名片","reportCategory":"名片","priceTip":"","fields":[{"id":"材质","type":"2","isRequired":true,"label":"材质","options":["普通","珠光","UV","莱尼","特种"]},{"id":"尺寸","type":"2","isRequired":true,"label":"尺寸","options":["90*50","90*54","90*45"]},{"id":"是否覆膜","type":"2","isRequired":true,"label":"是否覆膜","options":["覆","不覆"]}]},{"guid":"gAB7A2A3A-B291-4CB9-B400-262DD4713448","text":"木托","id":"木托","reportCategory":"木托","priceTip":"","fields":[{"id":"尺寸","type":"2","isRequired":true,"label":"尺寸","options":["30*40","35*50","40*60"]},{"id":"工艺","type":"1","isRequired":true,"label":"工艺"}]},{"guid":"g2226E3F7-9317-480F-82BC-D70F9D4E264A","text":"喷绘","id":"喷绘","reportCategory":"喷绘","priceTip":"","fields":[{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"}]},{"guid":"gACC1D886-E5BF-4141-BF7C-90CECF5CC926","text":"其他","id":"其他","reportCategory":"其他","priceTip":"","fields":[{"id":"材质","type":"1","isRequired":true,"label":"材质"},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"后期","type":"1","isRequired":false,"label":"后期"},{"id":"规格","type":"1","isRequired":false,"label":"规格"}]},{"guid":"g43BC2FAD-4F36-4DD8-A7F4-331E413C1FA5","text":"旗帜","id":"旗帜","reportCategory":"锦旗","priceTip":"","fields":[{"id":"尺寸","type":"2","isRequired":true,"label":"尺寸","options":["大号(700*1100)","中号(600*900)"," 三角(300*400)","其它65/平"]}]},{"guid":"g39CCDD0E-FCCE-4132-A77A-DD0C56F45A0A","text":"双色板","id":"双色板","reportCategory":"双色板","priceTip":"","fields":[{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"色号","type":"1","isRequired":false,"label":"色号"}]},{"guid":"gBD6EE2CC-BFE9-4B02-AEA3-483C761A029E","text":"写真","id":"写真","reportCategory":"写真","priceTip":"","fields":[{"id":"材质","type":"2","isRequired":true,"label":"材质","options":["户内","户外","车贴","地贴","灯片","透明亚","透明亮","透明磨砂","相纸","单透"]},{"id":"覆膜","type":"2","isRequired":true,"label":"覆膜","options":["亚膜","亮膜","磨砂膜"]},{"id":"工艺","type":"2","isRequired":true,"label":"工艺","options":["无","KT板","PVC(1.5)","PVC板(5)","PVC板(10)","PVC板(15)","X展架","易拉宝","门形展架"]},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"}]},{"guid":"g4EF9AA18-024D-4EC9-9172-D28A2C3D5F81","text":"型材","id":"型材","reportCategory":"型材","priceTip":"","fields":[{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"工艺","type":"1","isRequired":false,"label":"工艺"}]},{"guid":"gD23E0310-CDC2-4165-9573-D62FEE506B56","text":"亚克力","id":"亚克力","reportCategory":"亚克力","priceTip":"","fields":[{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"厚度","type":"2","isRequired":true,"label":"厚度","options":["3","5","8","10","15","20"]},{"id":"工艺","type":"1","isRequired":true,"label":"工艺"}]},{"guid":"g38118891-F232-4C35-BFBF-6AD0773D18D5","text":"印刷(单张)","id":"印刷(单张)","reportCategory":"印刷","priceTip":"","fields":[{"id":"纸张","type":"2","isRequired":true,"label":"纸张","options":["128","157","200","250","300"]},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"覆膜","type":"2","isRequired":true,"label":"覆膜","options":["否","是"]}]},{"guid":"g26714361-B25A-4731-A874-9A7198E950D3","text":"印刷(画册)","id":"印刷(画册)","reportCategory":"印刷","priceTip":"","fields":[{"id":"封面","type":"2","isRequired":true,"label":"封面","options":["100","128","157","200","250"]},{"id":"内芯","type":"2","isRequired":true,"label":"内芯","options":["100","128","157","200","250"]},{"id":"覆膜","type":"2","isRequired":true,"label":"覆膜","options":["否","封面","内芯"]},{"id":"尺寸","type":"1","isRequired":true,"label":"尺寸"},{"id":"装订方式","type":"2","isRequired":true,"label":"装订方式","options":["胶装","骑马订"]},{"id":"纸张","type":"2","isRequired":true,"label":"纸张","options":["双胶","铜板","哑粉","珠光"]},{"id":"页数","type":"1","isRequired":true,"label":"页数"}]},{"guid":"g19D948D7-5E9E-4224-A7A1-C6AF5161F4B9","text":"印刷(折页)","id":"印刷(折页)","reportCategory":"印刷","priceTip":"","fields":[{"id":"纸张","type":"2","isRequired":true,"label":"纸张","options":["128","157","200","250"]},{"id":"尺寸","type":"1","isRequired":false,"label":"尺寸"},{"id":"折数","type":"1","isRequired":false,"label":"折数"},{"id":"覆膜","type":"2","isRequired":true,"label":"覆膜","options":["否","封面","内芯"]}]}]')
INSERT [dbo].[Configuration] ([SettingName], [SettingValue]) VALUES (N'DeliveryType', N'送货上门,客户自取,普通快递,物流配送,上门安装,其它')
INSERT [dbo].[Configuration] ([SettingName], [SettingValue]) VALUES (N'IncomeTaxBase', N'3500+1500,3,0|4500,10,105|9000,20,555|35000,25,1005|55000,30,2755|80000,35,5505|80000,45,13505')
INSERT [dbo].[Configuration] ([SettingName], [SettingValue]) VALUES (N'MachineSn', N'')
INSERT [dbo].[Configuration] ([SettingName], [SettingValue]) VALUES (N'LicenseSn', N'')

insert into Configuration values('LicensePubKey','<RSAKeyValue><Modulus>qAGdtsdvIOZ+x8TS8OkprplDlkUjRGFtrgHrr9y/DBmJ1AJFqCSvNarv42bj6NBf//sSqIlfG0KbSTmA+0YB8x9kF6jm6R0n+fEXEBYceybhTtDBwwzMkUIc4hVayLpkgD7STm2lAKJUhG4/ILmoceFG8f4bYBRt5FVocQjPaWM=</Modulus><Exponent>AQAB</Exponent></RSAKeyValue>')