Kezdőlap Felfedezés Súgó
Regisztráció Bejelentkezés
LYFZ
/
lyfz_repos
2
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Fa: 8b4791aa7f
Branch-ok Tag-ek
lyfz_repos
/
铂金版源码
/
DBFile
/
SQL
/
更新相关文件
/
UpdateInitialDB.sql

UpdateInitialDB.sql 41 KB
Előzmények Nyers

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798 
  1. --SQL Server 如何启用CLR函数
    2. 

  2. exec sp_configure 'clr enabled' --查看状态  
    3. 

  3. exec sp_configure 'clr enabled',1 --1,启用clr,禁用clr
    4. 

  4. reconfigure with override
    5. 

  5. GO
    6. 

  6. --要使用.Net写的自定义聚合函数，需以上代码开启clr功能
    7. 

  7. IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[FunTrim]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
    8. 

  8. DROP FUNCTION [dbo].[FunTrim]
    9. 

  9. GO
    10. 

  10. IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AggregateString]') AND type = N'AF')
    11. 

  11. DROP AGGREGATE [dbo].[AggregateString]
    12. 

  12. GO
    13. 

  13. IF  EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'LYFZCLR')
    14. 

  14. DROP ASSEMBLY [LYFZCLR]
    15. 

  15. GO
    16. 

  16. CREATE ASSEMBLY [LYFZCLR]
    17. 

  17.     AUTHORIZATION [dbo]
    18. 

  18.     FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103006008A7550000000000000000E00002210B010B000014000000060000000000000E330000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000B832000053000000004000007003000000000000000000000000000000000000006000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000014130000002000000014000000020000000000000000000000000000200000602E7273726300000070030000004000000004000000160000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001A00000000000000000000000000004000004200000000000000000000000000000000F0320000000000004800000002000500A0260000180C000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004A02036F1000000A731100000A7D010000042A4A03027B010000046F1200000A6F1300000A2A5E02731400000A7D0100000402731500000A7D020000042A0000133005005C030000010000110F01281600000A2D1E0F01FE16080000016F1200000A6F1700000A72010000706F1800000A2C012A170A0F01FE16080000016F1200000A0B07720B0000706F1900000A39CF02000007178D1A000001130B110B16720B000070A2110B166F1A00000A0C08179A178D1A000001130C110C16721B000070A2110C166F1A00000A0D08169A6F1B00000A0B098E691A408502000009199A25130D397A020000110D7225000070281C00000A2D38110D7229000070281C00000A3AC5000000110D722D000070281C00000A3A52010000110D7231000070281C00000A3AA3010000383402000009169A6F1B00000A6F1D00000A16314C09169A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2D2E09189A6F1B00000A6F1D00000A16311E09189A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2C07160A38D101000009169A6F1B00000A281E00000A130409189A6F1B00000A281E00000A13050211048C1D00000111058C1D00000109179A28060000060A389601000009169A6F1B00000A6F1D00000A16314C09169A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2D2E09189A6F1B00000A6F1D00000A16311E09189A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2C07160A383301000009169A6F1B00000A281F00000A130609189A6F1B00000A281F00000A13070211068C1E00000111078C1E00000109179A28060000060A38F800000009169A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2D1E09189A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2C07160A38B50000000209169A6F1B00000A09189A6F1B00000A09179A28060000060A389600000009169A6F1B00000A6F1D00000A16314C09169A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2D2E09189A6F1B00000A6F1D00000A16311E09189A6F1B00000A6F1200000A6F1700000A72010000706F1800000A2C04160A2B3609169A6F1B00000A282000000A130809189A6F1B00000A282000000A13090211088C1F00000111098C1F00000109179A28060000060A02072805000006130A062C38027B010000046F2100000A163011027B01000004110A169A6F2200000A262A027B01000004110A179A110A169A282300000A6F2200000A262A133004005700000002000011188D1A0000010A03721B0000706F1900000A2C3003178D1A0000010B0716721B000070A207166F1A00000A0A061606169A6F1B00000AA2061706179A6F1B00000AA22B110616036F1B00000AA206177235000070A2062A00133004003D01000003000011160A05250B3931010000FE137E040000042D611D732500000A25723700007016282600000A25723B00007017282600000A25724100007018282600000A25724500007019282600000A2572490000701A282600000A25724F0000701B282600000A2572550000701C282600000AFE138004000004FE137E04000004071202282700000A39B3000000084507000000050000001500000022000000360000004A0000005E00000072000000388C00000003046F2800000A3980000000170A2B7C03046F2800000A2D73170A2B6F027B0200000403046F2900000A17335F170A2B5B027B0200000403046F2900000A15334B170A2B47027B0200000403046F2900000A163237170A2B33027B0200000403046F2900000A163023170A2B1F036F1200000A6F1700000A046F1200000A6F1700000A6F1900000A2C02170A062A52027B010000040F017B010000046F2A00000A262A46027B010000046F1200000A732B00000A2A13300500C0000000040000110F00281600000A2D1E0F00FE16080000016F1200000A6F1700000A72010000706F1800000A2C0B7235000070732B00000A2A140A0F00281600000A2D3C0F00FE16080000016F1200000A6F1700000A72010000706F1800000A2D1E0F01FE16080000016F1200000A0B076F1D00000A163107076F2D00000A0A062C2C068E691631260F00FE16080000016F1200000A178D230000010C08160616939D086F2E00000A732B00000A2A0F00FE16080000016F1200000A6F1B00000A732B00000A2A1E02282F00000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C000000F8030000237E0000640400006005000023537472696E677300000000C40900006000000023555300240A0000100000002347554944000000340A0000E401000023426C6F620000000000000002000001571702080900000000FA253300160000010000002300000004000000040000000A0000000A000000010000002F0000000D0000000400000001000000010000000200000000000A0001000000000006004B0044000A007C00610006008D0044000600A00094000600CB00C1000600DD00C10006000301F0000A0043012E010600E201D0010600F901D00106001602D00106003502D00106004E02D00106006702D00106008202D00106009D02D0010600D502B6020600E902D0010600220302030600420302030600680344000A007E0361000A009F0361000600A603B6020600BC03B6020600E603440006000504440006003A04440006004A0444000600500444000600620444000600C90402030600FF04E4040A00380561000600590544000000000001000000000001000100092110001600000005000100010001001000260000000D000400090000000000840400000D0004000B000100AE000A0001001B011A0006008401400013000C052C01502000000000E601D8000E000100632000000000E601EA0014000200762000000000860029011E00030090200000000086004D0122000300F8230000000081005801280004005C2400000000810066012E000500A525000000008600740135000800BA250000000086007A013B000900CC250000000096008A0143000900982600000000861892011E000B00000001009801000001009A01000001009C0100000100A70100000100B30100000200B50100000300B70100000100C101000001009C0100000200C70102000900490092014C00510092014C00590092014C00610092014C00690092014C00710092014C00790092014C00810092014C00890092015100910092014C00990092015600A10092011E00A90092011E00B10092015B00C1009201C3002900C703C900210092014C001900D203C9003100EA004C00210092011E00390092011E004100DB03CD00D100ED03C900D100F503D100D100FC03D100D1001804D600D1001E04C900D1002304DF00D1002F04E500E1004204E900E1005804EE00E1006B04F40021002F04E50021007604FA00D1007D040001010192011E000C00920156000C0020053D010C00240545011900F5034E01390030055301210076045F01410092014C00110192011E00D1004D056501D1001E046A01190092011E002E0023008B012E006300C4012E000B0078012E00130085012E001B0085012E002B0078012E0033009A012E003B0085012E004B0085012E005B00BB014300730061008300230127012001630127010601200159017001350104800000010000002B1670420000000000006003000002000000000000000000000001003B0000000000020000000000000000000000010055000000000000000000003C4D6F64756C653E004C59465A434C522E646C6C00416767726567617465537472696E670055736572446566696E656446756E6374696F6E73006D73636F726C69620053797374656D0056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A65004F626A6563740053797374656D2E5465787400537472696E674275696C64657200696E7465726D656469617465526573756C740053797374656D2E494F0042696E61727952656164657200526561640042696E6172795772697465720057726974650053797374656D2E436F6C6C656374696F6E730043617365496E73656E736974697665436F6D7061726572004F626A656374436F6D7061726500496E69740053797374656D2E446174612E53716C54797065730053716C537472696E6700416363756D756C617465004765744669656C6456616C756500436F6D70617265526573756C74004D65726765005465726D696E617465005F766172310046756E5472696D002E63746F7200720077004669656C6456616C75650076616C7565537472696E6700610062006F70657261746F72730047726F7570007472696D436861720053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465004C59465A434C520053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E640052656164537472696E6700546F537472696E67006765745F49734E756C6C00537472696E6700546F4C6F77657200457175616C7300436F6E7461696E7300537472696E6753706C69744F7074696F6E730053706C6974005472696D006F705F457175616C697479006765745F4C656E67746800436F6E7665727400546F496E74333200496E74333200446563696D616C00546F446563696D616C004461746554696D6500546F4461746554696D6500417070656E6400436F6E636174003C50726976617465496D706C656D656E746174696F6E44657461696C733E7B43323141363937372D324231432D343446372D383138392D3630463636303643364234467D00436F6D70696C657247656E6572617465644174747269627574650053797374656D2E436F6C6C656374696F6E732E47656E657269630044696374696F6E61727960320024246D6574686F643078363030303030362D31004164640054727947657456616C756500436F6D706172650053716C46756E6374696F6E41747472696275746500546F436861724172726179004368617200000000096E0075006C006C00000F7B00770068006500720065007D0000097B00240024007D0000036900000366000003730000037400000100033D0000053C003E0000033E0000033C0000053E003D0000053C003D0000096C0069006B006500000077691AC21C2BF744818960F6606C6B4F0008B77A5C561934E089030612110520010112150520010112190306121D032000010520010111210520011D0E0E062003021C1C0E0520010111080420001121020608080002112111211121042001010E0420010102042001010805200101115D6101000200000004005402124973496E76617269616E74546F4E756C6C73015402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F00000520010111650320000E03200002042001020E0820021D0E1D0E116D050002020E0E03200008040001080E05000111790E050001117D0E05200112110E0500020E0E0E19070E020E1D0E1D0E080811791179117D117D1D0E1D0E1D0E0E0607021D0E1D0E0401000000080615128085020E080715128085020E080720020113001301082002021300101301042001021C052002081C1C050703020E0805200112111C0420001D030520010E1D030707031D030E1D030C0100074C59465A434C5200000501000000000E0100094D6963726F736F667400002001001B436F7079726967687420C2A9204D6963726F736F6674203230313500000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100E03200000000000000000000FE320000002000000000000000000000000000000000000000000000F032000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000180300000000000000000000180334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE000001000000010070422B160000010070422B163F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00478020000010053007400720069006E006700460069006C00650049006E0066006F00000054020000010030003000300030003000340062003000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F00660074000000380008000100460069006C0065004400650073006300720069007000740069006F006E00000000004C00590046005A0043004C005200000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0035003600370035002E00310037003000300038000000000038000C00010049006E007400650072006E0061006C004E0061006D00650000004C00590046005A0043004C0052002E0064006C006C0000005C001B0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004D006900630072006F0073006F0066007400200032003000310035000000000040000C0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004C00590046005A0043004C0052002E0064006C006C000000300008000100500072006F0064007500630074004E0061006D006500000000004C00590046005A0043004C005200000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0035003600370035002E00310037003000300038000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0035003600370035002E003100370030003000380000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000103300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    19. 

  19.     WITH PERMISSION_SET = SAFE;
    20. 

  20. GO
    21. 

  21. CREATE AGGREGATE [dbo].[AggregateString] (@FieldValue [nvarchar](4000))
    22. 

  22. RETURNS [nvarchar](4000)
    23. 

  23. EXTERNAL NAME [LYFZCLR].[AggregateString];
    24. 

  24. GO
    25. 

  25. CREATE FUNCTION [dbo].[FunTrim] (@FieldValue [nvarchar](4000),@trimChar [nvarchar](4000))
    26. 

  26. RETURNS [nvarchar](4000) 
    27. 

  27. AS
    28. 

  28. EXTERNAL NAME [LYFZCLR].[UserDefinedFunctions].[FunTrim];
    29. 

  29. GO
    30. 

  30. truncate table dbo.[tb_ErpPermissionTemplate]
    31. 

  31. SET IDENTITY_INSERT [dbo].[tb_ErpPermissionTemplate] ON
    32. 

  32. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (1, N'StoresOPenSingle', N'门市开单', N'Print|NewOrder|ModifyOrder|OrderClsssSet|OrderClientRegionSet|OrderClientRelationSet|OrderPackagesNameSet|OrderSightsOrStageSet|OrderClientSourceSet|OrderLoveStyleSet', CAST(0x0000A485011FCE52 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012FB828 AS DateTime), N'20141125111443713')
    33. 

  33. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (6, N'StoresPhotograph', N'拍照', N'PhotoImport|PhotoExport|PhotoView|PhotoDelete|PhotographClientAvatarSeeView|PhotographMicroShare|ProcessStatusReset', CAST(0x0000A4860139EC0B AS DateTime), N'20141125111443713', CAST(0x0000A4F1012BD1A9 AS DateTime), N'20141125111443713')
    34. 

  34. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (7, N'StoresRepairPiece', N'初修', N'PhotoImport|PhotoExport|PhotoView|PhotoDelete|ProcessStatusReset|RepairPieceSeparatePhoto', CAST(0x0000A486013A17DD AS DateTime), N'20141125111443713', CAST(0x0000A4F1012C1D75 AS DateTime), N'20141125111443713')
    35. 

  35. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (8, N'StoresFilmSelection', N'选片', N'PhotoExport|Print|StartFilmSelection|ProcessStatusReset|FilmSelectionCache|FilmSelectionCacheManage', CAST(0x0000A486013A3D95 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012C76C1 AS DateTime), N'20141125111443713')
    36. 

  36. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (9, N'StoresRefinedRepair', N'精修', N'PhotoImport|PhotoExport|PhotoView|PhotoDelete|ProcessStatusReset', CAST(0x0000A486013A4984 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012C9F69 AS DateTime), N'20141125111443713')
    37. 

  37. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (10, N'StoresDesign', N'设计', N'PhotoImport|PhotoExport|PhotoView|PhotoDelete|LookDesign|ProcessStatusResetDesign|ProcessStatusResetLookDesign', CAST(0x0000A486013A59A3 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012CC262 AS DateTime), N'20141125111443713')
    38. 

  38. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (11, N'StoresDigital', N'数码', N'AnPaiWork|SeeAnPaiWork', CAST(0x0000A486013A7B43 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012D540F AS DateTime), N'20141125111443713')
    39. 

  39. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (12, N'OrderReport', N'订单报表', N'Delete|DataExport|OrderIntent', CAST(0x0000A486013AB2DB AS DateTime), N'20141125111443713', CAST(0x0000A4F1012D6DA4 AS DateTime), N'20141125111443713')
    40. 

  40. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (13, N'UserCompetence', N'员工设置权限', N'Add|Delete|Update|SeeView', CAST(0x0000A48601619A02 AS DateTime), N'20141125111443713', CAST(0x0000A48601619A01 AS DateTime), N'20141125111443713')
    41. 

  41. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (14, N'DressEntry', N'礼服录入', N'Add|Delete|Update|DataExport', CAST(0x0000A4A000B8ED4B AS DateTime), N'20141125111443713', CAST(0x0000A4A500EE5934 AS DateTime), N'20141125111443713')
    42. 

  42. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (15, N'DressView', N'礼服查询', N'SeeView', CAST(0x0000A4A000B8FD7F AS DateTime), N'20141125111443713', CAST(0x0000A4A000B8FD7F AS DateTime), N'20141125111443713')
    43. 

  43. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (16, N'DressManagement', N'礼服管理', N'Dress_Preselection|Dress_Rental|Dress_Valet', CAST(0x0000A4A000B90796 AS DateTime), N'20141125111443713', CAST(0x0000A4A000B90796 AS DateTime), N'20141125111443713')
    44. 

  44. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (17, N'ProductCompetence', N'商品设置', N'Add|Delete|Update', CAST(0x0000A4A500E86312 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EE68C9 AS DateTime), N'20141125111443713')
    45. 

  45. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (18, N'AttractionsCompetence', N'景点/次数设置', N'Add|Delete|Update', CAST(0x0000A4A500E88107 AS DateTime), N'20141125111443713', CAST(0x0000A4A500E91A0B AS DateTime), N'20141125111443713')
    46. 

  46. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (19, N'PackagesGoodsCompetence', N'套系赠送商品设置', N'Add|Delete|Update', CAST(0x0000A4A500E8B482 AS DateTime), N'20141125111443713', CAST(0x0000A4A500E8B482 AS DateTime), N'20141125111443713')
    47. 

  47. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (20, N'SupplierCompetence', N'供应商设置', N'Add|Delete|Update', CAST(0x0000A4A500E8E4D9 AS DateTime), N'20141125111443713', CAST(0x0000A4A500E8E4D9 AS DateTime), N'20141125111443713')
    48. 

  48. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (21, N'GoodsManufacturersCompetence', N'商品厂商设置', N'Add|Delete|Update', CAST(0x0000A4A500E931A1 AS DateTime), N'20141125111443713', CAST(0x0000A4A500E931A1 AS DateTime), N'20141125111443713')
    49. 

  49. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (22, N'WageCompetence', N'工资设置', N'Add|Update', CAST(0x0000A4A500E96348 AS DateTime), N'20141125111443713', CAST(0x0000A4A500E96348 AS DateTime), N'20141125111443713')
    50. 

  50. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (23, N'RatingsProportionCompetence', N'工资提成比重设置', N'Add', CAST(0x0000A4A500E984E2 AS DateTime), N'20141125111443713', CAST(0x0000A4A500E984E2 AS DateTime), N'20141125111443713')
    51. 

  51. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (24, N'SystemCompetence', N'系统类别设置', N'Add|Delete|Update', CAST(0x0000A4A500E9BE49 AS DateTime), N'20141125111443713', CAST(0x0000A4A500E9BE49 AS DateTime), N'20141125111443713')
    52. 

  52. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (25, N'CustomerSatisfactionRecordCompetence', N'客户满意度设置', N'SatisfactionSurvey|SatisfactionSurveySet', CAST(0x0000A4A500E9F63C AS DateTime), N'20141125111443713', CAST(0x0000A4D400C19672 AS DateTime), N'20141125111443713')
    53. 

  53. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (26, N'CustomerCallsCompetence', N'客户来电设置', N'Delete', CAST(0x0000A4A500EA2348 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EA2348 AS DateTime), N'20141125111443713')
    54. 

  54. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (27, N'OutgoingCallsCompetence', N'拨出电话设置', N'Delete', CAST(0x0000A4A500EA2DB0 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EA2DB0 AS DateTime), N'20141125111443713')
    55. 

  55. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (28, N'MissedCallCompetence', N'未接电话设置', N'Delete', CAST(0x0000A4A500EA4466 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EA4466 AS DateTime), N'20141125111443713')
    56. 

  56. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (29, N'OrdersCustomerCompetence', N'订单客户设置', N'Update|DataExport', CAST(0x0000A4A500EA6500 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EA70BD AS DateTime), N'20141125111443713')
    57. 

  57. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (30, N'OldCustomerCompetence', N'老客户设置', N'Add|Delete|Update|DataExport|SMSSend', CAST(0x0000A4A500EA8E8F AS DateTime), N'20141125111443713', CAST(0x0000A4A500EA8E8F AS DateTime), N'20141125111443713')
    58. 

  58. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (31, N'IntentionCustomerCompetence', N'意向客户设置', N'Add|Delete|Update|DataExport|SMSSend', CAST(0x0000A4A500EAC4D2 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EAC4D2 AS DateTime), N'20141125111443713')
    59. 

  59. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (32, N'StockCompetence', N'库存查询设置', N'Add|Delete|InstockInventory|ProcurementApplication', CAST(0x0000A4A500EB3D52 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EB3D52 AS DateTime), N'20141125111443713')
    60. 

  60. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (33, N'ReceiptCompetence', N'入库记录设置', N'Receipt', CAST(0x0000A4A500EB6066 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EB6066 AS DateTime), N'20141125111443713')
    61. 

  61. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (34, N'DeliveryCompetence', N'出库记录设置', N'Delivery', CAST(0x0000A4A500EB6EA6 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EB6EA6 AS DateTime), N'20141125111443713')
    62. 

  62. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (35, N'PurchasingManagementCompetence', N'采购管理设置', N'PurchasingManagement|AcceptanceManagement', CAST(0x0000A4A500EB8996 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EB8996 AS DateTime), N'20141125111443713')
    63. 

  63. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (36, N'FixedAssetManagementCompetence', N'固定资料管理设置', N'Add|Delete|Update', CAST(0x0000A4A500EB9882 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EB9882 AS DateTime), N'20141125111443713')
    64. 

  64. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (37, N'ShortSmsMessageCompetence', N'短信群发设置', N'DataExport|SMSSend', CAST(0x0000A4A500EC0D01 AS DateTime), N'20141125111443713', CAST(0x0000A4E601252F28 AS DateTime), N'20141125111443713')
    65. 

  65. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (38, N'SmsSendCompetence', N'短信发送设置', N'SMSSend', CAST(0x0000A4A500EC19FB AS DateTime), N'20141125111443713', CAST(0x0000A4A500EC19FB AS DateTime), N'20141125111443713')
    66. 

  66. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (39, N'SMSProcessCompetence', N'流程短信设置', N'SMSSend', CAST(0x0000A4A500EC2909 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EC2909 AS DateTime), N'20141125111443713')
    67. 

  67. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (40, N'SMSEmployeesCompetence', N'员工短信设置', N'SMSSend', CAST(0x0000A4A500EC3774 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EC3774 AS DateTime), N'20141125111443713')
    68. 

  68. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (41, N'SendRecordsCompetence', N'发送记录', N'Delete|DataExport|SMSResendSend', CAST(0x0000A4A500EC4659 AS DateTime), N'20141125111443713', CAST(0x0000A4E600B790CC AS DateTime), N'20141125111443713')
    69. 

  69. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (42, N'SMSSettingsCompetence', N'短信设置', N'Add|Delete|Update', CAST(0x0000A4A500EC62D0 AS DateTime), N'20141125111443713', CAST(0x0000A4E600B76CE5 AS DateTime), N'20141125111443713')
    70. 

  70. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (43, N'DayFinanceCompetence', N'日财务设置', N'DataExport|Print|FinancialAudit|FinancialExpenses', CAST(0x0000A4A500EC9037 AS DateTime), N'20141125111443713', CAST(0x0000A4BA01153D60 AS DateTime), N'20141125111443713')
    71. 

  71. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (44, N'MonthFinanceCompetence', N'月财务设置', N'DataExport|Print|FinancialExpenses', CAST(0x0000A4A500EC9DA6 AS DateTime), N'20141125111443713', CAST(0x0000A4BA01154EEB AS DateTime), N'20141125111443713')
    72. 

  72. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (45, N'YearFinanceCompetence', N'年财务设置', N'DataExport|Print|FinancialExpenses', CAST(0x0000A4A500ECA76C AS DateTime), N'20141125111443713', CAST(0x0000A4BA01155CD1 AS DateTime), N'20141125111443713')
    73. 

  73. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (46, N'CostingCompetence', N'成本核算设置', N'DataExport', CAST(0x0000A4A500ECB2C8 AS DateTime), N'20141125111443713', CAST(0x0000A4A500ECB2C8 AS DateTime), N'20141125111443713')
    74. 

  74. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (47, N'StatisticalInquiryAllWagesCompetence', N'工资管理设置', N'DataExport|Print', CAST(0x0000A4A500ECC2EA AS DateTime), N'20141125111443713', CAST(0x0000A4A500ECC2EA AS DateTime), N'20141125111443713')
    75. 

  75. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (48, N'TwoSalesOrderCompetence', N'其它消费设置', N'Add|Delete|Update|SMSSend|OtherConsumerReceivables', CAST(0x0000A4A500ED3D56 AS DateTime), N'20141125111443713', CAST(0x0000A4A500ED3D56 AS DateTime), N'20141125111443713')
    76. 

  76. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (49, N'CashExpendituresCompetence', N'现金支出设置', N'Add|Delete|Update|Print|ReportForm', CAST(0x0000A4A500ED6136 AS DateTime), N'20141125111443713', CAST(0x0000A4A500ED6136 AS DateTime), N'20141125111443713')
    77. 

  77. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (50, N'OtherIncomeCompetence', N'其它收入设置', N'Add|Delete|Print', CAST(0x0000A4A500ED738F AS DateTime), N'20141125111443713', CAST(0x0000A4A500ED738F AS DateTime), N'20141125111443713')
    78. 

  78. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (51, N'PieceCommissionRecordsCompetence', N'计件提成设置', N'Add|Delete', CAST(0x0000A4A500ED9612 AS DateTime), N'20141125111443713', CAST(0x0000A4A500ED9612 AS DateTime), N'20141125111443713')
    79. 

  79. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (52, N'StaffAwardPunishCompetence', N'员工奖罚设置', N'Add|Delete|Update', CAST(0x0000A4A500EDA5E5 AS DateTime), N'20141125111443713', CAST(0x0000A4A500EDA5E5 AS DateTime), N'20141125111443713')
    80. 

  80. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (53, N'OrdersReceivablesCompetence', N'订单收款设置', N'Delete|OrdersReceivables|UpdatePaymentTime|OrdersLatePayment|OrdersLatePickGoods|OrderPaymentMethodSet', CAST(0x0000A4A500EDBA19 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012FA04F AS DateTime), N'20141125111443713')
    81. 

  81. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (54, N'BulletinBoardCompetence', N'公告栏', N'Delete|Update|Announcement', CAST(0x0000A4A500EDE073 AS DateTime), N'20141125111443713', CAST(0x0000A4F2009B1A80 AS DateTime), N'20141125111443713')
    82. 

  82. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (55, N'StoresPhotosPrints', N'相片冲印', N'Delete|PhotosPrints|OrderSendOut|OrderRework|OrderComplete', CAST(0x0000A4A600B7DAB6 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012CFDBD AS DateTime), N'20141125111443713')
    83. 

  83. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (56, N'StoresTotakePiece', N'发片取件', N'DataExport|TotakePiece|OrderSendOut|OrderRework|OrderComplete|OrderPickup|TotakePieceMonthRework|TotakePieceSentNotBack', CAST(0x0000A4A600B7F555 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012D22CF AS DateTime), N'20141125111443713')
    84. 

  84. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (57, N'MemberManage', N'会员管理', N'Delete|DataImport|DataExport|Print|SMSSend|Member_Recharge|Member_Cash|Member_PointsRedeem|Member_TurnPoints|Member_Logout|Member_ChangingCard|Member_SendPoint|Member_PasswordSet|Member_SendViceCard|Member_OpenCard|Member_CashBackCash|Member_GradeUpdateType|Member_ServiceData|Member_PhotographerOpenCard|Member_PhotographerReturnAmount|Member_PhotographerUseGift|Member_ServiceKoufei|Member_ParameterSet_BaseSet|Member_ParameterSet_PointsSet|Member_ParameterSet_CashBackProportionSet|Member_ParameterSet_RechargeTypeSet|Member_ParameterSet_GradeSet|Member_ParameterSet_ServiceContentSet|Member_ParameterSet_PackageServiceSet|Member_ParameterSet_PhotographerConferenceSet|Member_ViceCardReclaim', CAST(0x0000A4A600B830A7 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012E799C AS DateTime), N'20141125111443713')
    85. 

  85. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (58, N'PhotoStudioInfo', N'本店信息设置', N'Update', CAST(0x0000A4A600EE9711 AS DateTime), N'20141125111443713', CAST(0x0000A4A600EE9711 AS DateTime), N'20141125111443713')
    86. 

  86. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (59, N'PrinterSetup', N'打印机设置', N'Update', CAST(0x0000A4A600EEA53A AS DateTime), N'20141125111443713', CAST(0x0000A4A600EEA53A AS DateTime), N'20141125111443713')
    87. 

  87. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (60, N'Attendance', N'考勤管理', N'AttendanceSigning|AttendanceDataManager', CAST(0x0000A4A800DBFAEF AS DateTime), N'20141125111443713', CAST(0x0000A4A800DBFAEF AS DateTime), N'20141125111443713')
    88. 

  88. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (61, N'FinancialExpensesCompetence', N'财务支出设置', N'Add|Delete|Update|Print|ReportForm', CAST(0x0000A4B900E2B3BF AS DateTime), N'20141125111443713', CAST(0x0000A4B900E2B3BF AS DateTime), N'20141125111443713')
    89. 

  89. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (62, N'SystemRightsManagement', N'权限管理', N'AddRole|DelRole|SetUserRole|SetUserExclusiveCompetence', CAST(0x0000A4C000E29B8C AS DateTime), N'20141125111443713', CAST(0x0000A4C000E29B8C AS DateTime), N'20141125111443713')
    90. 

  90. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (63, N'GroupInfo', N'集团信息', N'SeeView', CAST(0x0000A4F1012B3AF1 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012B3AF1 AS DateTime), N'20141125111443713')
    91. 

  91. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (64, N'StoresKePan', N'刻盘', N'KePanCD|KePanUDisk', CAST(0x0000A4F1012CD5B4 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012CD5B4 AS DateTime), N'20141125111443713')
    92. 

  92. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (65, N'CameraControlBook', N'摄控本', N'Print|SMSSend|CameraControlBook_PhotographClientAnPai|CameraControlBook_FilmsSelectionClientAnPai|CameraControlBook_LookDesignClientAnPai|CameraControlBook_TakePiecesClientAnPai|CameraControlBook_ServiceClientAnPai|CameraControlBook_SelectDressClientAnPai|CameraControlBook_AnPaiQuantitySet|CameraControlBook_SelectDress', CAST(0x0000A4F1012E3227 AS DateTime), N'20141125111443713', CAST(0x0000A4F1012E3227 AS DateTime), N'20141125111443713')
    93. 

  93. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (66, N'TasksAssigned', N'任务交办', N'Add|Delete|Update', CAST(0x0000A4F2009B76C5 AS DateTime), N'20141125111443713', CAST(0x0000A4F2009B76C5 AS DateTime), N'20141125111443713')
    94. 

  94. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (67, N'MattersApplication', N'事项申请', N'Add|Delete|Update|Audit', CAST(0x0000A4F2009B8CE6 AS DateTime), N'20141125111443713', CAST(0x0000A4F2009B8CE6 AS DateTime), N'20141125111443713')
    95. 

  95. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (68, N'CommunicationAide', N'沟通助手', N'Add|Delete|AudioPlayback', CAST(0x0000A4F2009BC74E AS DateTime), N'20141125111443713', CAST(0x0000A4F2009C5810 AS DateTime), N'20141125111443713')
    96. 

  96. INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (69, N'MyCallCenter', N'通话中心', N'AudioPlayback', CAST(0x0000A4F2009C6884 AS DateTime), N'20141125111443713', CAST(0x0000A4F2009C6884 AS DateTime), N'20141125111443713')
    97. 

  97. SET IDENTITY_INSERT [dbo].[tb_ErpPermissionTemplate] OFF
    98. 

  98. GO
    99.