truncate table [dbo].[tb_ErpClientSatisfaction] truncate table [dbo].[tb_ErpCustomer] truncate table [dbo].[tb_ErpCustomerTrackLog] truncate table [dbo].[tb_ErpDressDepositReceivables] truncate table [dbo].[tb_ErpDressFrom] truncate table [dbo].[tb_ErpDressRefundRecord] truncate table [dbo].[tb_ErpDressSaleRentalDetail] truncate table [dbo].[tb_ErpDressSaleRentalOrder] truncate table [dbo].[tb_ErpDressSendWashDetail] truncate table [dbo].[tb_ErpDressSendWashOrder] truncate table [dbo].[tb_ErpFixedAssetManagement] truncate table [dbo].[tb_ErpKepanLogo] truncate table [dbo].[tb_ErpMemberCard] truncate table [dbo].[tb_ErpMemberCardAmountCashStatus] truncate table [dbo].[tb_ErpMemberCardAmountChangeLOG] truncate table [dbo].[tb_ErpMemberCardBackCash] truncate table [dbo].[tb_ErpMemberCardBackCashSet] truncate table [dbo].[tb_ErpMemberCardDiscount] truncate table [dbo].[tb_ErpMemberCardInterfaceManagement] truncate table [dbo].[tb_ErpMemberCardOperateLOG] truncate table [dbo].[tb_ErpMemberCardPaymentContentDetail] truncate table [dbo].[tb_ErpMemberCardPoints] truncate table [dbo].[tb_ErpMemberCardPointsLOG] truncate table [dbo].[tb_ErpMemberCardRechargeDonateSet] truncate table [dbo].[tb_ErpMemberCardRechargeRecord] truncate table [dbo].[tb_ErpMemberCardRechargeTypeSet] truncate table [dbo].[tb_ErpMemberCardServiceContent] truncate table [dbo].[tb_ErpMemberCardServiceContentSet] truncate table [dbo].[tb_ErpMemberCardServiceContentUseLog] truncate table [dbo].[tb_ErpMemberCardServicePackageContent] truncate table [dbo].[tb_ErpMemberCardServicePackageSet] truncate table [dbo].[tb_ErpMemberCardViceCard] truncate table [dbo].[tb_ErpOrder] truncate table [dbo].[tb_ErpOrderDigital] truncate table [dbo].[tb_ErpOrderPhotoPrints] truncate table [dbo].[tb_ErpOrderProcessMonitor] truncate table [dbo].[tb_ErpOrderProductList] truncate table [dbo].[tb_ErpOrderProductLOG] truncate table [dbo].[tb_ErpOrdersClothing] truncate table [dbo].[tb_ErpOrdersPerson] truncate table [dbo].[tb_ErpOrdersPhotography] truncate table [dbo].[tb_ErpOtherIncomeAndExpenses] truncate table [dbo].[tb_ErpPackages] truncate table [dbo].[tb_ErpPackagesGiftMerchandise] truncate table [dbo].[tb_ErpPayment] truncate table [dbo].[tb_ErpPieceCommissionRecords] truncate table [dbo].[tb_ErpPlusPickItems] truncate table [dbo].[tb_ErpProduct] truncate table [dbo].[tb_ErpProductIntStorage] truncate table [dbo].[tb_ErpProductOutStorage] truncate table [dbo].[tb_ErpPurchaseOrder] truncate table [dbo].[tb_ErpPurchaseProduct] truncate table [dbo].[tb_ErpRewardPunishment] truncate table [dbo].[tb_ErpSmsAccountInfo] truncate table [dbo].[tb_ErpSMSRecord] truncate table [dbo].[tb_ErpSystemLogs] truncate table [dbo].[tb_ErpTheScenery] truncate table [dbo].[tb_ErpTwoPinsProjectCommissionProportion] truncate table [dbo].[tb_ErpTwoSalesOrder] truncate table [dbo].[tb_ErpUserExpandInfo] truncate table [dbo].[tb_ErpVendor] truncate table [dbo].[tb_ErpWageCommissionSet] truncate table [dbo].[tb_ErpWagesSet] truncate table [dbo].[tb_ErpWeddingService] truncate table dbo.loginsign truncate table dbo.loninbanset truncate table dbo.lonindata truncate table dbo.tb_ErpCustomerGroup truncate table dbo.tb_ErpCustomerGroupMembers truncate table dbo.tb_ErpCustomersTrackRecord truncate table dbo.tempTB_AggregationCustomer truncate table dbo.[tb_ErpShopEvententry] truncate table dbo.[tb_ErpShopBulletin] truncate table dbo.tempTB_AggregationCustomer truncate table dbo.tempTB_GroupByAggregationCustomer truncate table dbo.tb_ErpShopAssignmente truncate table dbo.tb_ErpShopDebriefing truncate table dbo.tb_SMSRecords truncate table [dbo].[tb_ErpMemberCardPayment] truncate table [dbo].[tb_ErpMemberCardPhotographerMain] truncate table [dbo].tb_ErpOrderNumberRecord truncate table tb_ErpHospitalClient truncate table tb_ErpHospitalContactRecord truncate table tb_ErpHospitalDispatchDoor truncate table tb_ErpHospitalRemindSettings truncate table [tb_ErpShopEvententry] truncate table [tb_ErpShopBulletin] truncate table [tb_ErpShopDesignatedAnnounced] truncate table [tb_OldOrderHistory] GO delete [dbo].[tb_ErpUser] where id>1 delete [dbo].[tb_ErpRolePermission] where id>1 delete [dbo].[tb_ErpSystemCategory] where Sc_IsDelete=0 delete [dbo].[tb_ErpMemberCardGradeSet] where id>1 GO update [dbo].[tb_ErpSmsAccountInfo] set Smsa_MoneyBalances=0 update tb_ErpSystemConfigure set Sconfig_Value = 'JointlyDiscount' where Sconfig_Code = 'MemberDiscount' update tb_ErpSystemConfigure set Sconfig_Value = 'AvailablePoints' where Sconfig_Code = 'MemberPhotographerNeededType' update tb_ErpSystemConfigure set Sconfig_Value = 'CumulativePoints' where Sconfig_Code = 'MemberUpgradeScheme' update tb_ErpSystemConfigure set Sconfig_Value = 'ZH15010100001' where Sconfig_Code = 'OpenOrderNumberLog' update tb_ErpSystemConfigure set Sconfig_Value = 'M0000000001' where Sconfig_Code = 'OpenMemberNumberLog' update tb_ErpSystemConfigure set Sconfig_Value = 'false' where Sconfig_Code = 'OrderAddRandom' update tb_ErpSystemConfigure set Sconfig_Value = '0000001' where Sconfig_Code = 'PrintReceiptSerial' update tb_ErpSystemConfigure set Sconfig_Value = '5|20,20,20,20,20,0,0,0,0,0' where Sconfig_Code = 'Proportion' update [dbo].[tb_ErpCompanyInfo] set Company_MicroShareAccount='',Company_MicroSharePassword='' where id>0 GO update [dbo].[tb_ErpPrinterSet] set ps_PrinterName='',ps_PrinterPath='',ps_PrintTitles='', ps_SmallTicketPrintName='',ps_SmallTicketPrintPath='', ps_PaperFeed='0' GO if exists (select * from syscolumns where id=object_id('tb_ErpShopBulletin') and name='Bulletin_content' and [length]>0) begin alter table [dbo].[tb_ErpShopBulletin] alter column [Bulletin_content] nvarchar(max) end GO if exists (select * from syscolumns where id=object_id('tb_ErpShopBulletin') and name='Bulletin_Title' and [length]<1600) begin alter table [dbo].[tb_ErpShopBulletin] alter column [Bulletin_Title] nvarchar(800) end GO delete [dbo].[tb_ErpUser] where id>1 ---在要添加的数据库中按F5执行就可以添加,注意,在执行前请先备份数据库,以免造成不可意料的错误后损坏数据 if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5624939574486901996') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'门市', N'Role5624939574486901996', N'0', N'开单，查询客户订单，付款情况，摄控，件完成情况，会员资料查看', CAST(0x0000A52C00DDF126 AS DateTime), N'20141125111443713', CAST(0x0000A52C00E99722 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role4640595258782358074') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'收银', N'Role4640595258782358074', N'0', N'订单收款，其它消费，店面支出，日报查看', CAST(0x0000A52C00E967C7 AS DateTime), N'20141125111443713', CAST(0x0000A52C00EEAF5B AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5326381932302887603') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'调度客服', N'Role5326381932302887603', N'1', N'摄控本安排，数码安排，客服中心（流程把控，沟通助手，回访调查），短信发送（不含群发以及设置短信模板设置权限）', CAST(0x0000A52C00EEA555 AS DateTime), N'20141125111443713', CAST(0x0000A52C00FA1140 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5639526247055793367') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'摄影', N'Role5639526247055793367', N'1', N'查看摄控，导入原片（不含原片删除，如果要删除照片请设置专属）', CAST(0x0000A52C00F0F837 AS DateTime), N'20141125111443713', CAST(0x0000A52C00F8E011 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5693425949144247100') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'调色初修', N'Role5693425949144247100', N'0', N'导入初修片，查看摄控本，查看拍摄状态以及照片，查看自己工作（不含数码安排，如果需要添加专属权限）', CAST(0x0000A52C00F203B4 AS DateTime), N'20141125111443713', CAST(0x0000A52C00F8DAD9 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role4627023413454812990') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'选片', N'Role4627023413454812990', N'0', N'选片，看设计，查看安排客户选片时间，以及查看客户拍摄状态，修片状态，', CAST(0x0000A52C00F54859 AS DateTime), N'20141125111443713', CAST(0x0000A52C00F8D653 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5040501071734281934') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'精修设计', N'Role5040501071734281934', N'0', N'选片导出，精修导入，精修导出，设计导入。查看数码工作安排不含安排权限，需要请设置专属权限', CAST(0x0000A52C00F5FB4D AS DateTime), N'20141125111443713', CAST(0x0000A52C00F8CB8A AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5752237472295880333') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'刻盘/照片导出', N'Role5752237472295880333', N'1', N'光盘刻录/导出（默认包含所以刻录权限，不同请修改角色）', CAST(0x0000A52C00F798D0 AS DateTime), N'20141125111443713', CAST(0x0000A52C00F89369 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role4832522906297557074') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'发片取件', N'Role4832522906297557074', N'0', N'件发出登记，成品回来登记，件取走登记（不含本月发片，本月冲印，需要请设置专属权限）', CAST(0x0000A52C00F87020 AS DateTime), N'20141125111443713', CAST(0x0000A52C0106FE3C AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5397848181199747317') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'会员管理', N'Role5397848181199747317', N'1', N'默认只含会员基础操作，（不含会员设置，删除，导入导出，充值套系修改等）（需要会员全部功能请设置专属权限）', CAST(0x0000A52C00FB608B AS DateTime), N'20141125111443713', CAST(0x0000A52C0106F983 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5723079338361453538') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'礼服管理', N'Role5723079338361453538', N'1', N'礼服录入，礼服信息查看，礼服出租出售收款（不含删除需要请设置专属权限），摄控查看，原片，修片，设计班查看', CAST(0x0000A52C01024340 AS DateTime), N'20141125111443713', CAST(0x0000A52C0106F470 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5219495439957547767') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'库存管理', N'Role5219495439957547767', N'1', N'库存录入盘点，采购入库，（不含删除记录功能 需要设置专属权限）', CAST(0x0000A52C010378D6 AS DateTime), N'20141125111443713', CAST(0x0000A52C01085679 AS DateTime), N'20141125111443713') if not EXISTS (select Rp_RoleMark from [dbo].[tb_ErpRolePermission] where Rp_RoleMark='Role5358053950841599807') INSERT [dbo].[tb_ErpRolePermission] ( [Rp_Type], [Rp_RoleName], [Rp_RoleMark], [Rp_PermissionValue], [Rp_Description], [Rp_CreateDatetime], [Rp_CreateName], [Rp_UpdateDatetime], [Rp_UpdateName]) VALUES ( 1, N'财务', N'Role5358053950841599807', N'0', N'日，月，年财务报表查看，财务支出，员工工资业绩查看，考勤查看', CAST(0x0000A52C0106CA36 AS DateTime), N'20141125111443713', CAST(0x0000A52C0108D629 AS DateTime), N'20141125111443713') GO update [dbo].[tb_ErpSystemConfigure] set [Sconfig_Value]='' where [Sconfig_Code]='SSN001' update [dbo].[tb_ErpSystemConfigure] set [Sconfig_Value]='50FalseTrueTrueTrueTrueTrueFalseTrueTrueTrueFalseTrueFalse20TrueTrueFalseTrue12020False30FalseFalseFalseTrueFalse801FalseFalse' where [Sconfig_Code]='SystemGlobalSetting' GO delete [dbo].[tb_SMSTemplates] where id>2 GO SET IDENTITY_INSERT [dbo].[tb_SMSTemplates] ON GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (61, 0, 1, 1, 101, N'1', N'相关客户', N'', N'XXX先生/女士，您在本店制作的所有产品已全部完成，请尽快到本店进行取件，记得带上您的单据前来。蒙娜丽莎祝您家庭幸福。电话2398865', 0, N'', CAST(0x0000A4F500DF056F AS DateTime), CAST(0x0000A4F500DF056F AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (4, 0, 1, 1, 100, N'1', N'相关客户', N'', N'XXX先生/女士您好，蒙娜丽莎婚纱摄影温馨提示您，您成功在本店预订套系。拍照前请与客服联系2398865我们将竭诚为您服务，祝您生活愉快！', 0, N'', CAST(0x0000A4F500E0C8AA AS DateTime), CAST(0x0000A4F500E0C8AA AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (5, 0, 1, 1, 103, N'1', N'相关客户', N'', N'XXX先生/女士，感谢您对蒙娜丽莎的支持，在您拍照期间，若有服务不周或待慢之处，恳请原谅！客服部敬上！电话2398865', 0, N'', CAST(0x0000A4F500E10BB8 AS DateTime), CAST(0x0000A4F500E10BB8 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (6, 0, 1, 1, 102, N'1', N'相关客户', N'', N'XXX先生/女士，您在本店预约拍摄时间为XXT，请务必在此时间到店，以免耽误您的拍摄形成。温馨提示：睡前一小时勿喝水，以免眼袋臃肿；请保持充足的睡眠时间；贵重物品请妥善保管；请带上您的收据单到店。感谢您对蒙娜丽莎的支持。电话2398865', 0, N'', CAST(0x0000A4F500E2344F AS DateTime), CAST(0x0000A4F500E2344F AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (7, 0, 1, 1, 104, N'1', N'相关客户', N'', N'XXX先生/女士，您选的照片已进入数码部进行设计，我们会将您最靓丽的演出，最美丽的神韵，创作出您最满意的作品，祝贺您俩百年好合，永浴爱河！电话2398865', 0, N'', CAST(0x0000A4F500E26FB0 AS DateTime), CAST(0x0000A4F500E26FB0 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (8, 0, 1, 1, 105, N'1', N'相关客户', N'', N'XXX先生/女士，您确定的作品已进入制作部进行制作，感谢您对蒙娜丽莎的支持！后续工作我们会全程把关，让您的照片更出色，也希望您能满意！电话2398865', 0, N'', CAST(0x0000A4F500E29C17 AS DateTime), CAST(0x0000A4F500E29C17 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (9, 0, 1, 1, 114, N'1', N'相关客户', N'', N'XXX先生/女士，在您生日的来临之际，蒙娜丽莎全体员工祝您生日快乐，青春常驻，身体健康！感谢您对蒙娜丽莎的支持！电话2398865', 0, N'', CAST(0x0000A4F500E2CBEA AS DateTime), CAST(0x0000A4F500E2CBEA AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (10, 0, 1, 1, 315, N'0', N'相关客户', N'', N'XXX先生/女士，^o^在天愿做比翼鸟，在地愿结连理枝，不羡神仙逍遥游，只羡鸳鸯戏水在池中。今天是你们大喜的日子，蒙娜丽莎祝你们喜结连理，白头偕老！电话2398865', 0, N'', CAST(0x0000A4F500E30478 AS DateTime), CAST(0x0000A4F500E30478 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (11, 0, 1, 1, 316, N'1', N'相关客户', N'', N'XXX先生/女士，明天就是您俩的结婚纪念日哦，您肯定不会忘记吧！^-^在此蒙娜丽莎全体员工祝您俩幸福永远，与之偕老，永远像新婚当天一样。电话2398865', 0, N'', CAST(0x0000A4F500E32AA6 AS DateTime), CAST(0x0000A4F500E32AA6 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (12, 0, 1, 2, 100, N'1', N'相关客户', N'', N'XXX您好，今天很荣幸能为您服务！感谢您选择星光贝贝儿童摄影记录您宝贝成长的美好故事。我们全体员工一定会用心做到最好！再次感谢！同时请坚信我们星光贝贝是最棒的。电话2398865', 0, N'', CAST(0x0000A4F500E55C18 AS DateTime), CAST(0x0000A4F500E55C18 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (13, 0, 1, 2, 101, N'1', N'相关客户', N'', N'XXX您好！您的产品已全部制作完毕，明天终于可以拿到宝贝的相册了，很期待吧！我们已经把照片都准备好了。记得带上票据准时来取哦，相信您回去之后所有的亲友都会用幸福的眼光看宝贝照片！电话2398865', 0, N'', CAST(0x0000A4F500E5CA01 AS DateTime), CAST(0x0000A4F500E5CA01 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (14, 0, 1, 1, 114, N'0', N'相关客户', N'', N'XXX先生/女士，今天是您的生日，蒙娜丽莎全体员工祝您生日快乐，青春常驻，身体健康，家庭幸福！感谢您对蒙娜丽莎的支持！电话2398865', 0, N'', CAST(0x0000A4F500F42D3B AS DateTime), CAST(0x0000A4F500F42D3B AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (15, 0, 1, 2, 102, N'1', N'相关客户', N'', N'XXX您好，您预约拍摄时间为XXT期待的拍照日明天就要来了。您及宝贝要好好休息哦，记得给宝贝带好所需物品。相信我们会把宝贝最可爱的一面给您保留住，明天见！星光贝贝儿童摄影。电话2398865', 0, N'', CAST(0x0000A4F500F53ED4 AS DateTime), CAST(0x0000A4F500F53ED4 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (17, 0, 1, 2, 104, N'1', N'相关客户', N'', N'XXX您好！宝贝拍出这么可爱的片子是值得恭喜的事，当然这还是的宝贝表现好的主要原因！宝贝的照片拍的自然又成功，后续所有的工作我们会全程关注，让宝贝的照片更出色，也希望一切您能满意。电话2398865', 0, N'', CAST(0x0000A4F500F5E29C AS DateTime), CAST(0x0000A4F500F5E29C AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (18, 0, 1, 2, 105, N'1', N'相关客户', N'', N'XXX您好，您确定的宝贝作品已进入制作部进行制作，感谢您对星光贝贝的支持！后续工作我们会全程把关，让您宝贝的照片更出色，也希望您能满意！电话2398865', 0, N'', CAST(0x0000A4F500F6294C AS DateTime), CAST(0x0000A4F500F6294C AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (19, 0, 1, 2, 106, N'1', N'相关客户', N'', N'XXX您好，您宝贝在我们影楼拍摄的所有作品已经取完，亲友们问起您宝贝的幸福照片时，记得跟我们推荐哦！谢谢您对星光贝贝的信任与支持！服务电话：2398865', 0, N'', CAST(0x0000A4F500F69E82 AS DateTime), CAST(0x0000A4F500F69E82 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (21, 0, 1, 2, 217, N'0', N'相关客户', N'', N'XXX您好，星光贝贝全体员工祝您家宝贝生日快乐！我们为宝贝提供最专业，最贴心的拍照服务，让我们一同为宝贝留下一年一变的珍贵瞬间！服务电话2398865', 0, N'', CAST(0x0000A4F500F73110 AS DateTime), CAST(0x0000A4F500F73110 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (22, 0, 1, 2, 103, N'1', N'相关客户', N'', N'XXX您好，感谢您对星光贝贝的支持，您宝贝的照片已拍摄完毕，选片时间我们另行通知。在您宝贝拍照期间，若有服务不周或待慢之处，恳请原谅！客服部敬上。电话2398865', 0, N'', CAST(0x0000A4F500F754DD AS DateTime), CAST(0x0000A4F500F754DD AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (23, 0, 1, 2, 218, N'7', N'相关客户', N'', N'XXX您好，星光贝贝温馨提示：宝宝出生一周了，您须注意宝宝的脐带护理，保持其清洁、干爽，以加快愈合的速度。服务电话2398865', 0, N'', CAST(0x0000A4F500F7CAE5 AS DateTime), CAST(0x0000A4F500F7CAE5 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (24, 0, 1, 2, 218, N'14', N'相关客户', N'', N'XXX您好，星光贝贝温馨提示：宝宝出生二周了，天气比较干燥，记得给宝宝多喝温开水，母乳期间妈妈少吃巧克力，乳汁中的咖啡因会影响宝宝的睡眠和消化。服务电话2398865', 0, N'', CAST(0x0000A4F500F7F54E AS DateTime), CAST(0x0000A4F500F7F54E AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (25, 0, 1, 2, 218, N'21', N'相关客户', N'', N'XXX您好，星光贝贝温馨提示：宝宝出生三周了，妈妈可以下床适量的活动以加快身体的恢复，但一定要注意休息并补充营养！服务电话2398865', 0, N'', CAST(0x0000A4F500F8E089 AS DateTime), CAST(0x0000A4F500F8E089 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (26, 0, 1, 2, 218, N'30', N'相关客户', N'', N'XXX您好，星光贝贝全体员工恭贺您宝贝满月了，祝您宝贝健康快乐的成长，全家幸福美满！爱心热线：2398865地址：演达大道丽园新村。 ', 0, N'', CAST(0x0000A4F500F95589 AS DateTime), CAST(0x0000A4F500F95589 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (27, 0, 1, 2, 218, N'60', N'相关客户', N'', N'XXX您好，宝宝出生两个月，喂奶时切记勿给宝宝吸吮空奶瓶，大量的空气会引起腹胀等一系列不良症状。关爱宝贝的成长是星光贝贝最大的喜悦！ 服务电话2398865', 0, N'', CAST(0x0000A4F500F9A38F AS DateTime), CAST(0x0000A4F500F9A38F AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (28, 0, 1, 2, 218, N'90', N'相关客户', N'', N'XXX您好，宝宝三个月了，可以添加鲜果汁和青菜汁等辅食营养，但需让宝宝有个适应的过程，不能急于求成。关爱宝贝的成长是星光贝贝最大的喜悦！ 服务电话2398865', 0, N'', CAST(0x0000A4F500F9CF18 AS DateTime), CAST(0x0000A4F500F9CF18 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (29, 0, 1, 2, 218, N'100', N'相关客户', N'', N'XXX您好，星光贝贝全体员工恭贺您宝贝百天了，祝您宝贝健康快乐成长，全家幸福美满，打电话来店，咱帮您安排宝宝百天照！爱心热线：2398865 地址：演达大道丽园新村 ', 0, N'', CAST(0x0000A4F500FA10A0 AS DateTime), CAST(0x0000A4F500FA10A0 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (30, 0, 1, 2, 218, N'120', N'相关客户', N'', N'XXX您好，宝宝四个月了，给宝宝添加辅食过程中，如出现消化不良、腹泻、呕吐等情况，应暂停一段时间，再少量试喂或换另一种食物。关注宝贝成长尽在星光贝贝！ 电话2398865', 0, N'', CAST(0x0000A4F500FA4508 AS DateTime), CAST(0x0000A4F500FA4508 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (31, 0, 1, 2, 218, N'150', N'相关客户', N'', N'XXX您好，宝宝五个月，别在宝宝的食物中添加调味品，盐也要少放或不放，特别要避免蜂蜜，蜂蜜中的肉毒杆菌会让宝宝生病。关注宝贝成长尽在星光贝贝！ 电话2398865', 0, N'', CAST(0x0000A4F500FA7688 AS DateTime), CAST(0x0000A4F500FA7688 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (32, 0, 1, 2, 218, N'180', N'相关客户', N'', N'XXX您好，宝宝六个月，这个阶段能沉浮的浴室玩具、软积木、软球、能发声的填充娃娃、不倒翁等都将是宝宝很好的玩具。关注宝贝成长尽在星光贝贝！请打电话2398865，帮您安排宝宝半岁照。', 0, N'', CAST(0x0000A4F500FAA51D AS DateTime), CAST(0x0000A4F500FAA51D AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (33, 0, 1, 2, 218, N'210', N'相关客户', N'', N'XXX您好，宝宝七个月，调整宝宝正确的睡姿，趴睡会影响宝宝的上腭承受较大的压力，可能造成牙齿排列不整齐的问题。关注宝贝成长尽在星光贝贝！ 电话2398865', 0, N'', CAST(0x0000A4F500FADF16 AS DateTime), CAST(0x0000A4F500FADF16 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (34, 0, 1, 2, 218, N'240', N'相关客户', N'', N'XXX您好，宝宝八个月，记得让宝宝少看电视，而且要让宝宝离电视2米远的正面，时间不宜长，而播放儿歌可舒缓宝贝的情绪！关注宝贝成长尽在星光贝贝！ 电话2398865', 0, N'', CAST(0x0000A4F500FB093D AS DateTime), CAST(0x0000A4F500FB093D AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (35, 0, 1, 2, 218, N'270', N'相关客户', N'', N'XXX 您好，九个月的宝宝会发脾气了，建议父母保持冷静，引开宝宝的注意力，处罚或屈服都是不适当的。关注宝贝成长尽在星光贝贝！请致电2398865，帮您宝宝安排9个月照相。 ', 0, N'', CAST(0x0000A4F500FB6976 AS DateTime), CAST(0x0000A4F500FB6976 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (36, 0, 1, 2, 218, N'300', N'相关客户', N'', N'XXX您好，宝宝十个月，鼓励宝宝自己玩，有助于增强宝宝的独立能力，还能学到如何自娱，但一定要保证他的安全。关注宝贝成长尽在星光贝贝！ 电话2398865', 0, N'', CAST(0x0000A4F500FB912A AS DateTime), CAST(0x0000A4F500FB912A AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (38, 0, 1, 2, 219, N'1', N'相关客户', N'', N'XXX您好，宝宝一岁，星光贝贝全体员工恭贺宝贝周岁了，祝宝贝生日快乐！关注宝贝成长尽在星光贝贝！爱心热线：2398865 地址：演达大道丽园新村 ', 0, N'', CAST(0x0000A4F500FC302D AS DateTime), CAST(0x0000A4F500FC302D AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (39, 0, 1, 1, 317, N'1', N'相关客户', N'', N'XXX您好，蒙娜丽莎温馨提示您，在XXSR是XXVN先生的生日，浪漫的日子用浪漫的方式表达，给他准备个神秘礼物吧吧。(>^ω^<)祝愿你们幸福长久。幸福热线2398865', 0, N'', CAST(0x0000A4F500FE8E9C AS DateTime), CAST(0x0000A4F500FE8E9C AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (40, 0, 1, 1, 318, N'1', N'相关客户', N'', N'XXX您好，蒙娜丽莎温馨提示您，在XXSR是XXVN女士的生日，浪漫的日子用浪漫的方式表达，给她准备个神秘礼物吧。(>^ω^<)祝愿你们幸福长久。幸福热线2398865', 0, N'', CAST(0x0000A4F500FEC034 AS DateTime), CAST(0x0000A4F500FEC034 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (41, 0, 1, 3, 100, N'1', N'相关客户', N'', N'XXX您好，蒙娜丽莎婚纱摄影温馨提示您，您成功在本店预订套系。拍照前请与客服联系2398865我们将竭诚为您服务，祝您生活愉快！', 0, N'', CAST(0x0000A4F500FEF4F9 AS DateTime), CAST(0x0000A4F500FEF4F9 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (42, 0, 1, 3, 101, N'1', N'相关客户', N'', N'XXX您好，您在本店制作的所有产品已全部完成，请尽快到本店进行取件，记得带上您的单据前来。蒙娜丽莎祝您家庭幸福。电话2398865', 0, N'', CAST(0x0000A4F500FF24CC AS DateTime), CAST(0x0000A4F500FF24CC AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (43, 0, 1, 3, 102, N'1', N'相关客户', N'', N'XXX您好，您在本店预约拍摄时间为XXT，请务必在此时间到店，以免耽误您的拍摄行程。温馨提示：睡前一小时勿喝水，以免眼袋臃肿；请保持充足的睡眠时间；贵重物品请妥善保管；请带上您的收据单到店。感谢您对蒙娜丽莎的支持。电话2398865', 0, N'', CAST(0x0000A4F500FF63A5 AS DateTime), CAST(0x0000A4F500FF63A5 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (44, 0, 1, 3, 103, N'1', N'相关客户', N'', N'XXX您好，感谢您对蒙娜丽莎的支持，您的拍摄已全部完毕，选片时间另行通知。在您拍照期间，若有服务不周或待慢之处，恳请原谅！客服部敬上！电话2398865', 0, N'', CAST(0x0000A4F500FFA2FC AS DateTime), CAST(0x0000A4F500FFA2FC AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (45, 0, 1, 3, 104, N'1', N'相关客户', N'', N'XXX您好，您选的照片已进入数码部进行设计，我们会将您最靓丽的演出，最美丽的神韵，创作出您最满意的作品，祝您青春永驻！电话2398865', 0, N'', CAST(0x0000A4F500FFD04D AS DateTime), CAST(0x0000A4F500FFD04D AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (46, 0, 1, 3, 105, N'1', N'相关客户', N'', N'XXX您好，您确定的作品已进入制作部进行制作，感谢您对蒙娜丽莎的支持！后续工作我们会全程把关，让您的照片更出色，也希望您能满意！电话2398865', 0, N'', CAST(0x0000A4F500FFE8EC AS DateTime), CAST(0x0000A4F500FFE8EC AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (47, 0, 1, 3, 114, N'1', N'相关客户', N'', N'XXX您好，在您生日的来临之际，蒙娜丽莎全体员工祝您生日快乐，青春常驻，身体健康！感谢您对蒙娜丽莎的支持！电话2398865', 0, N'', CAST(0x0000A4F5010008F3 AS DateTime), CAST(0x0000A4F5010008F3 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (48, 0, 1, 1, 106, N'1', N'相关客户', N'', N'XXX先生/女士您好，您在我们影楼拍摄的所有作品已经取完，亲友们问起您的幸福照片时，记得跟我们推荐哦！谢谢您对蒙娜丽莎的信任与支持！服务电话：2398865', 0, N'', CAST(0x0000A4F50100685D AS DateTime), CAST(0x0000A4F50100685D AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (49, 0, 1, 3, 106, N'1', N'相关客户', N'', N'XXX您好，您在我们影楼拍摄的所有作品已经取完，亲友们问起您的美丽照片时，记得跟我们推荐哦！谢谢您对蒙娜丽莎的信任与支持！服务电话：2398865', 0, N'', CAST(0x0000A4F50100855E AS DateTime), CAST(0x0000A4F50100855E AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (50, 0, 1, 0, 921, N'0', N'相关员工', N'', N'亲爱的XXX，公司的每一次进步，都离不开你的协作和努力，公司的每一次成长，都离不开你的辛勤和汗水，公司的每一次壮大，都离不开你的心血和付出。日月轮转永不断，情若真挚长相伴，不论你身在天涯海角，公司都送上对你最真挚的祝福。祝你生日快乐！', 0, N'', CAST(0x0000A4F50101D744 AS DateTime), CAST(0x0000A4F50101D744 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (51, 0, 1, 0, 926, N'1', N'相关客户', N'', N'亲爱的XXX先生/女士，放心吧！我们一定用最好的服务和产品，为您创造出最美的作品！电话2398865', 0, N'', CAST(0x0000A4F501021BAE AS DateTime), CAST(0x0000A4F501021BAE AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (52, 0, 1, 0, 927, N'1', N'相关客户', N'', N'感谢您致电蒙娜丽莎婚纱摄影，我们将用最优蕙的的价格，最强的团队，为您打造一辈子的幸福回艺！电话2398865', 0, N'', CAST(0x0000A4F501023C93 AS DateTime), CAST(0x0000A4F501023C93 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (53, 0, 1, 0, 928, N'1', N'相关员工', N'', N'亲爱的伙伴们，一丝不苟，积极向上，作好每一幅作品，服务好每一位客人，让每一对新人感激我们一辈子。就靠你了……', 0, N'', CAST(0x0000A4F50102525C AS DateTime), CAST(0x0000A4F50102525C AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (54, 0, 1, 0, 929, N'1', N'18607523124', N'', N'XXSR是XXX这位员工的生日，请做好祝贺准备', 0, N'', CAST(0x0000A4F50102A63E AS DateTime), CAST(0x0000A4F50102A63E AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (55, 0, 1, 0, 922, N'21:0', N'18607523124', N'', N'系统自动生成', 0, N'', CAST(0x0000A4F50102BD9F AS DateTime), CAST(0x0000A4F50102BD9F AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (56, 0, 1, 0, 913, N'1', N'相关客户', N'', N'XXX您好，您的XXN卡号，在XXT充值了XXCM元，现当前卡总金额为XXM元。感谢您对蒙娜丽莎的支持。电话2398865', 0, N'', CAST(0x0000A4F50103531E AS DateTime), CAST(0x0000A4F50103531E AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (57, 0, 1, 0, 912, N'1', N'相关客户', N'', N'XXX您好，您的XXN卡号，在XXT消费了XXQM元，现卡剩余金额为XXM元。感谢您对蒙娜丽莎的支持，电话2398865', 0, N'', CAST(0x0000A4F50103C185 AS DateTime), CAST(0x0000A4F50103C185 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (58, 0, 1, 0, 910, N'1', N'相关客户', N'', N'XXX您好，感谢您成为本公司的荣誉贵宾，您的卡号为XXN，未来的日子里您可享受本公司所有的会员优蕙，同时希望您为我公司介绍更多的客户。电话2398865', 0, N'', CAST(0x0000A4F501040D66 AS DateTime), CAST(0x0000A4F501040D66 AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (59, 0, 1, 0, 909, N'1', N'相关客户', N'', N'XXX您好，您的朋友XXC在XXT成功在本店订单，给你积分XXF，达到一定积分可在本店兑换相应礼品哦。感谢您的介绍。2225955', 0, N'', CAST(0x0000A4F50104DBAC AS DateTime), CAST(0x0000A4F50104DBAC AS DateTime)) GO INSERT [dbo].[tb_SMSTemplates] ([id], [ST_SendChannel], [ST_Type], [ST_Category], [ST_SendEvent], [ST_SendEventValue], [ST_ReceiveObjects], [ST_Title], [ST_SMSContent], [ST_IsEnabled], [ST_Remark], [ST_CreateDatetime], [ST_UpdateDatetime]) VALUES (60, 0, 1, 2, 218, N'330', N'相关客户', N'', N'XXX您好，宝宝十一个月，带宝宝到户外呼吸新鲜空气，他的心情会变得愉快，也能够学着与人交往，促进孩子的身心发展。关注宝贝成长尽在星光贝贝！ 电话2398865', 0, N'', CAST(0x0000A4F7009D05D8 AS DateTime), CAST(0x0000A4F7009D05D8 AS DateTime)) GO SET IDENTITY_INSERT [dbo].[tb_SMSTemplates] OFF --2015-10-14--更新权限-- truncate table dbo.[tb_ErpPermissionTemplate] GO SET IDENTITY_INSERT [dbo].[tb_ErpPermissionTemplate] ON 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|ProcessDateReset', CAST(0x0000A485011FCE52 AS DateTime), N'20141125111443713', CAST(0x0000A4FC00D48F8E AS DateTime), N'20141125111443713') 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|ProcessDateReset', CAST(0x0000A4860139EC0B AS DateTime), N'20141125111443713', CAST(0x0000A4FC00D49643 AS DateTime), N'20141125111443713') 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|ProcessDateReset', CAST(0x0000A486013A17DD AS DateTime), N'20141125111443713', CAST(0x0000A4FC00D49C5D AS DateTime), N'20141125111443713') 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|ProcessDateReset', CAST(0x0000A486013A3D95 AS DateTime), N'20141125111443713', CAST(0x0000A4FC00D4A384 AS DateTime), N'20141125111443713') 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|ProcessDateReset', CAST(0x0000A486013A4984 AS DateTime), N'20141125111443713', CAST(0x0000A4FC00D4ADE2 AS DateTime), N'20141125111443713') 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|ProcessDateReset', CAST(0x0000A486013A59A3 AS DateTime), N'20141125111443713', CAST(0x0000A4FC00D4BA75 AS DateTime), N'20141125111443713') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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|DataImport|DataExport|SMSSend', CAST(0x0000A4A500EA8E8F AS DateTime), N'20141125111443713', CAST(0x0000A525009B6001 AS DateTime), N'20141125111443713') 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|DataImport|DataExport|SMSSend', CAST(0x0000A4A500EAC4D2 AS DateTime), N'20141125111443713', CAST(0x0000A525009B7ECC AS DateTime), N'20141125111443713') 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') 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'Delete|Receipt', CAST(0x0000A4A500EB6066 AS DateTime), N'20141125111443713', CAST(0x0000A4F800EFD229 AS DateTime), N'20141125111443713') 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'Delete|Delivery', CAST(0x0000A4A500EB6EA6 AS DateTime), N'20141125111443713', CAST(0x0000A4F800EFCA3A AS DateTime), N'20141125111443713') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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') 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'Add|Delete|ViewAll', CAST(0x0000A4A500ECC2EA AS DateTime), N'20141125111443713', CAST(0x0000A51B00F2B1D0 AS DateTime), N'20141125111443713') 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|UpdatePaymentTime', CAST(0x0000A4A500ED3D56 AS DateTime), N'20141125111443713', CAST(0x0000A52C00F161F7 AS DateTime), N'20141125111443713') 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') 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') 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') 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') 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') 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') 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') 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') 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|UpdateMemberRechargeTime', CAST(0x0000A4A600B830A7 AS DateTime), N'20141125111443713', CAST(0x0000A50E01254CB9 AS DateTime), N'20141125111443713') 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') 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') 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') 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') 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') 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') 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'Setting|KePanCD|KePanUDisk|KePanClientSelectEarlyRepair|KePanClientSelectOriginalPiece|KePanRefinedRepairAll|KePanDesignAll|KePanEarlyRepairAll|KePanOriginalPieceAll', CAST(0x0000A4F1012CD5B4 AS DateTime), N'20141125111443713', CAST(0x0000A52900DFDF11 AS DateTime), N'20141125111443713') 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') 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') 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') 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') 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') INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (70, N'SatisticalInquiryEmployeesCompetence', N'统计员工资料', N'ViewAll', CAST(0x0000A4F800A5FA3B AS DateTime), N'20141125111443713', CAST(0x0000A4F800A5FA3B AS DateTime), N'20141125111443713') INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (71, N'IndividualPerformanceCompetence', N'个人业绩管理', N'ViewAll', CAST(0x0000A51B00F69575 AS DateTime), N'20141125111443713', CAST(0x0000A51B00F69575 AS DateTime), N'20141125111443713') INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (72, N'OtherCustomerCompetence', N'其它客户', N'Add|Delete|Update|DataImport|DataExport|SMSSend', CAST(0x0000A525009BF63E AS DateTime), N'20141125111443713', CAST(0x0000A525009BF63E AS DateTime), N'20141125111443713') INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (73, N'TodayRemindedCustomerCompetence', N'客户今日提醒', N'SMSSend|RemindedSet|CancelRemindedSet', CAST(0x0000A525009C0E88 AS DateTime), N'20141125111443713', CAST(0x0000A525009C25E0 AS DateTime), N'20141125111443713') INSERT [dbo].[tb_ErpPermissionTemplate] ([ID], [Pte_TemplateMark], [Pte_TemplateName], [Pte_PermissionValue], [Pte_CreateDatetime], [Pte_CreateName], [Pte_UpdateDatetime], [Pte_UpdateName]) VALUES (74, N'HospitalTrackingSystem', N'医院跟踪系统', N'Add|Delete|Update|DataImport|DataExport|SMSSend|RemindedSet|CancelRemindedSet|AddCommunicateRecord|DelCommunicateRecord|AddSendSingleTask|DelSendSingleTask|UpdateSendSingleTask', CAST(0x0000A52900958C32 AS DateTime), N'20141125111443713', CAST(0x0000A5290095B3A5 AS DateTime), N'20141125111443713') SET IDENTITY_INSERT [dbo].[tb_ErpPermissionTemplate] OFF GO