lyfz_repos/铂金版源码/DBFile/SQL/清空数据.sql

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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:1|1012:1|1013:0|1058:1|1059:1|1060:1|1061:1|1062:1|1063:1|1064:1|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:1|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:1|1001:0|1002:1|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:1|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:1|1115:1|1116:1]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem><OrderDiscounts>0</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:1|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:1|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:1|Gst055st057:1|Gst055st058:1|Gst055st059:1|Gst055st05560:1,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:1|Qqt003:1|Qqt004:1|Qqt090:1|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:1|1024:1|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:1|1001:0|1002:0|1017:0|1025:1]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:1|1001:0|1002:0|1010:1|1026:1]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:1|1001:0|1010:1]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:1|1054:0|1055:1|1056:1|1091:1]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem><OrderDiscounts>0</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:1|Gst015st017:1|Gst015st018:1|Gst015st073:0|Gst015st019:1|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:1|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:0|Qqt002:1|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><OrderDiscounts>1</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:1,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:1,Gst033=Gst033st034:0|Gst033st036:1|Gst033st037:1|Gst033st038:1|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:1|Gst060st062:1|Gst060st063:1,Gst064=Gst064st065:0,Gst071=Gst071st0701:1|Gst071st0703:1|Gst071st0704:1|Gst071st0702:1,Gst081=Gst081st0801:1|Gst081st0803:1|Gst081st0804:1|Gst081st0805:1,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:1|Qqt003:1|Qqt004:1|Qqt090:1|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:1|1082:1]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:1|1015:1]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:1|1017:1|1103:1|1104:1|1105:1|1106:1|1107:1|1108:1|1109:1|1110:1]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:1]]></MyCallCenter><CommunicationAide><![CDATA[1000:1|1001:0|1111:1]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><OrderDiscounts>1</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:1|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:1|1005:0|1006:1|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem><OrderDiscounts>0</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:1|GretailProcessst007:1|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:1,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:1|1006:1|1007:0|1065:1|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:1|1005:1|1006:1|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:1]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><OrderDiscounts>0</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:1|GretailProcessst007:1|GretailProcessst008:1|GretailProcessst009:0|GretailProcessst010:1|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:1|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:1|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:1|1037:1|1067:1|1069:1|1070:1|1113:1]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:1|1007:0|1071:1|1072:1|1073:1|1113:1]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:1|1017:1|1103:1|1104:1|1105:1|1106:1|1107:1|1108:1|1109:1|1110:1]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:1|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:1|1005:1|1006:1|1007:0|1067:1|1113:1]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:1|1005:1|1006:1|1007:0|1071:1|1072:1|1073:1|1113:1]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:1]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem><OrderDiscounts>0</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:1|GretailProcessst010:1|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:1,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><OrderDiscounts>1</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:1|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:0|Qqt003:0|Qqt004:1|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:1|1074:1|1075:1|1122:1|1123:1|1124:1|1125:1|1126:1|1127:1]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:1|1035:0|1076:1|1077:1|1078:1]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:1|1077:1|1078:1|1079:1|1080:0|1081:1]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem><OrderDiscounts>0</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:1|GretailProcessst013:1|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><OrderDiscounts>1</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:1|Gst040st043:1|Gst040st0802:1|Gst040st044:1|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:0|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:1|1017:1|1038:1|1039:1|1040:1|1041:1|1042:0|1043:1|1044:1|1045:0|1046:1|1084:1|1085:1|1086:1|1087:1|1088:1|1089:1|1090:1|1092:1|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><OrderDiscounts>1</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:1|GretailProcessst007:1|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:1|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:0|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:1|Gst045st047:1|Gst045lfst048:1,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:1|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:1|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:1|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:1|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:1]]></DressView><DressManagement><![CDATA[1047:1|1048:1|1049:1]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><OrderDiscounts>1</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:0|GretailProcessst007:0|GretailProcessst008:0|GretailProcessst009:0|GretailProcessst010:0|GretailProcessst011:0|GretailProcessst012:0|GretailProcessst013:0|GretailProcessst014:0,Gst015=Gst015st016:0|Gst015st017:0|Gst015st018:0|Gst015st073:0|Gst015st019:0|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:0|Gst0240st026:0|Gst0240st027:0|Gst0240st028:0|Gst0240st024:0|Gst0240st091:0|Gst0240st030:0|Gst0240st031:0|Gst0240st072:1|Gst0240st074:0,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:1|Gst048st051:1|Gst048st052:1|Gst048st053:1|Gst048st054:1,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:0,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:0|Qqt002:0|Qqt003:0|Qqt004:0|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:1|Ssm007:0|Ssm009:1|Ssm010:1|Ssm011:1|Ssm013:0|Ssm014:0|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:0|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:0|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:0|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:0|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:0|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:0|1083:0]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:0|1001:0|1002:0]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:0|1002:0]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:0]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:1|1001:1|1018:1|1019:1]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:1|1021:1]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:1]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:1]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:1|1001:0|1002:1]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:0|1010:0|1024:0|1053:0]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:0|1010:0|1053:0]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:0]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:0|1001:0|1112:0]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:0]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:0]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:0|1001:0|1002:0|1017:0|1025:0]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:0|1001:0|1002:0|1010:0|1026:0]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:0|1001:0|1010:0]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:0|1001:0]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:0|1001:0|1002:0]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:0|1027:0|1054:0|1055:0|1056:0|1091:0]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:0|1052:0]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem></UserPermissionValue>', 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'<?xml version="1.0" encoding="utf-8"?><UserPermissionValue><GroupInfo><![CDATA[1003:0]]></GroupInfo><StoresOPenSingle><![CDATA[1010:0|1012:0|1013:0|1058:0|1059:0|1060:0|1061:0|1062:0|1063:0|1064:0|1113:0]]></StoresOPenSingle><StoresPhotograph><![CDATA[1004:0|1005:0|1006:1|1007:0|1065:0|1066:0|1067:0|1113:0]]></StoresPhotograph><StoresRepairPiece><![CDATA[1004:0|1005:0|1006:1|1007:0|1067:0|1068:0|1113:0]]></StoresRepairPiece><StoresFilmSelection><![CDATA[1005:0|1010:0|1037:0|1067:0|1069:0|1070:0|1113:0]]></StoresFilmSelection><StoresRefinedRepair><![CDATA[1004:0|1005:0|1006:1|1007:0|1067:0|1113:0]]></StoresRefinedRepair><StoresDesign><![CDATA[1004:0|1005:0|1006:1|1007:0|1071:0|1072:0|1073:0|1113:0]]></StoresDesign><StoresKePan><![CDATA[1030:0|1074:0|1075:0|1122:0|1123:0|1124:0|1125:0|1126:0|1127:0]]></StoresKePan><StoresPhotosPrints><![CDATA[1001:0|1035:1|1076:0|1077:0|1078:0]]></StoresPhotosPrints><StoresTotakePiece><![CDATA[1009:0|1036:1|1076:0|1077:0|1078:0|1079:0|1080:0|1081:0]]></StoresTotakePiece><StoresDigital><![CDATA[1016:0|1082:0]]></StoresDigital><OrderReport><![CDATA[1001:0|1009:1|1083:1]]></OrderReport><UserCompetence><![CDATA[1000:0|1001:0|1002:0|1003:0]]></UserCompetence><ProductCompetence><![CDATA[1000:1|1001:1|1002:1]]></ProductCompetence><AttractionsCompetence><![CDATA[1000:0|1001:0|1002:0]]></AttractionsCompetence><PackagesGoodsCompetence><![CDATA[1000:0|1001:0|1002:0]]></PackagesGoodsCompetence><SupplierCompetence><![CDATA[1000:0|1001:0|1002:0]]></SupplierCompetence><GoodsManufacturersCompetence><![CDATA[1000:0|1001:0|1002:0]]></GoodsManufacturersCompetence><WageCompetence><![CDATA[1000:1|1002:1]]></WageCompetence><RatingsProportionCompetence><![CDATA[1000:1]]></RatingsProportionCompetence><SystemCompetence><![CDATA[1000:0|1001:0|1002:0]]></SystemCompetence><CustomerSatisfactionRecordCompetence><![CDATA[1014:0|1015:0]]></CustomerSatisfactionRecordCompetence><CustomerCallsCompetence><![CDATA[1001:0]]></CustomerCallsCompetence><OutgoingCallsCompetence><![CDATA[1001:0]]></OutgoingCallsCompetence><MissedCallCompetence><![CDATA[1001:0]]></MissedCallCompetence><OrdersCustomerCompetence><![CDATA[1002:0|1009:0]]></OrdersCustomerCompetence><OldCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OldCustomerCompetence><IntentionCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></IntentionCustomerCompetence><OtherCustomerCompetence><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0]]></OtherCustomerCompetence><TodayRemindedCustomerCompetence><![CDATA[1017:0|1115:0|1116:0]]></TodayRemindedCustomerCompetence><StockCompetence><![CDATA[1000:0|1001:0|1018:0|1019:0]]></StockCompetence><PurchasingManagementCompetence><![CDATA[1020:0|1021:0]]></PurchasingManagementCompetence><ReceiptCompetence><![CDATA[1001:0|1022:0]]></ReceiptCompetence><DeliveryCompetence><![CDATA[1001:0|1023:0]]></DeliveryCompetence><FixedAssetManagementCompetence><![CDATA[1000:0|1001:0|1002:0]]></FixedAssetManagementCompetence><ShortSmsMessageCompetence><![CDATA[1009:0|1017:0]]></ShortSmsMessageCompetence><SMSProcessCompetence><![CDATA[1017:0]]></SMSProcessCompetence><SMSEmployeesCompetence><![CDATA[1017:0]]></SMSEmployeesCompetence><SendRecordsCompetence><![CDATA[1001:0|1009:0|1098:0]]></SendRecordsCompetence><SMSSettingsCompetence><![CDATA[1000:0|1001:0|1002:0]]></SMSSettingsCompetence><DayFinanceCompetence><![CDATA[1009:1|1010:1|1024:1|1053:1]]></DayFinanceCompetence><MonthFinanceCompetence><![CDATA[1009:1|1010:1|1053:1]]></MonthFinanceCompetence><YearFinanceCompetence><![CDATA[1009:1|1010:1|1053:1]]></YearFinanceCompetence><CostingCompetence><![CDATA[1009:1]]></CostingCompetence><StatisticalInquiryAllWagesCompetence><![CDATA[1000:1|1001:1|1112:1]]></StatisticalInquiryAllWagesCompetence><SatisticalInquiryEmployeesCompetence><![CDATA[1112:1]]></SatisticalInquiryEmployeesCompetence><IndividualPerformanceCompetence><![CDATA[1112:1]]></IndividualPerformanceCompetence><TwoSalesOrderCompetence><![CDATA[1000:1|1001:1|1002:1|1017:1|1025:1]]></TwoSalesOrderCompetence><CashExpendituresCompetence><![CDATA[1000:1|1001:1|1002:1|1010:1|1026:1]]></CashExpendituresCompetence><FinancialExpensesCompetence><![CDATA[1000:1|1001:1|1002:1|1010:1|1026:1]]></FinancialExpensesCompetence><OtherIncomeCompetence><![CDATA[1000:1|1001:1|1010:1]]></OtherIncomeCompetence><PieceCommissionRecordsCompetence><![CDATA[1000:1|1001:1]]></PieceCommissionRecordsCompetence><StaffAwardPunishCompetence><![CDATA[1000:1|1001:1|1002:1]]></StaffAwardPunishCompetence><OrdersReceivablesCompetence><![CDATA[1001:1|1027:1|1054:1|1055:1|1056:1|1091:1]]></OrdersReceivablesCompetence><SystemRightsManagement><![CDATA[1031:0|1032:0|1033:0|1034:0]]></SystemRightsManagement><MemberManage><![CDATA[1001:0|1008:0|1009:0|1010:0|1017:0|1038:0|1039:0|1040:0|1041:0|1042:0|1043:0|1044:0|1045:0|1046:0|1084:0|1085:0|1086:0|1087:0|1088:0|1089:0|1090:0|1092:0|1093:0|1094:0|1095:0|1096:0|1097:0|1099:0|1100:0|1101:0|1102:0|1114:0]]></MemberManage><CameraControlBook><![CDATA[1010:0|1017:0|1103:0|1104:0|1105:0|1106:0|1107:0|1108:0|1109:0|1110:0]]></CameraControlBook><DressEntry><![CDATA[1000:0|1001:0|1002:0|1009:0]]></DressEntry><DressView><![CDATA[1003:0]]></DressView><DressManagement><![CDATA[1047:0|1048:0|1049:0]]></DressManagement><PhotoStudioInfo><![CDATA[1002:0]]></PhotoStudioInfo><PrinterSetup><![CDATA[1002:0]]></PrinterSetup><Attendance><![CDATA[1051:1|1052:1]]></Attendance><BulletinBoardCompetence><![CDATA[1001:0|1002:0|1028:0]]></BulletinBoardCompetence><TasksAssigned><![CDATA[1000:0|1001:0|1002:0]]></TasksAssigned><MattersApplication><![CDATA[1000:0|1001:0|1002:0|1011:0]]></MattersApplication><MyCallCenter><![CDATA[1111:0]]></MyCallCenter><CommunicationAide><![CDATA[1000:0|1001:0|1111:0]]></CommunicationAide><HospitalTrackingSystem><![CDATA[1000:0|1001:0|1002:0|1008:0|1009:0|1017:0|1115:0|1116:0|1117:0|1118:0|1119:0|1120:0|1121:0]]></HospitalTrackingSystem><OrderDiscounts>0</OrderDiscounts><SystemInterface><![CDATA[GHTSystem=GHTSystemht002:0|GHTSystemht003:0|GHTSystemht004:0|GHTSystemht005:0,GretailProcess=GretailProcessstA003:0|GretailProcessst006:1|GretailProcessst007:1|GretailProcessst008:1|GretailProcessst009:1|GretailProcessst010:1|GretailProcessst011:0|GretailProcessst012:1|GretailProcessst013:1|GretailProcessst014:0,Gst015=Gst015st016:1|Gst015st017:1|Gst015st018:1|Gst015st073:1|Gst015st019:1|Gst015st020:0|Gst015st023:0,Gst0240=Gst0240st025:1|Gst0240st026:1|Gst0240st027:1|Gst0240st028:1|Gst0240st024:1|Gst0240st091:1|Gst0240st030:1|Gst0240st031:0|Gst0240st072:1|Gst0240st074:1,Gst033=Gst033st034:0|Gst033st036:0|Gst033st037:0|Gst033st038:0|Gst033st039:0,Gst040=Gst040st041:0|Gst040st043:0|Gst040st0802:0|Gst040st044:0|Gst040st045:0,Gst045=Gst045st046:0|Gst045st047:0|Gst045lfst048:0,Gst048=Gst048st049:0|Gst048st051:0|Gst048st052:0|Gst048st053:0|Gst048st054:0,Gst055=Gst055st056:0|Gst055st057:0|Gst055st058:0|Gst055st059:0|Gst055st05560:0,Gst060=Gst060st061:0|Gst060st062:0|Gst060st063:0,Gst064=Gst064st065:1,Gst071=Gst071st0701:0|Gst071st0703:0|Gst071st0704:0|Gst071st0702:0,Gst081=Gst081st0801:0|Gst081st0803:0|Gst081st0804:0|Gst081st0805:0,Gst099=Gst099st090:0,quickToolsPet=QfrmWelcomeForm:1|Qqt001:1|Qqt002:1|Qqt003:1|Qqt004:1|Qqt090:0|Qqt007:1,systemMenuPet=Ssm002:0|Ssm004:0|Ssm003:1|Ssm005:0|Ssm006:0|Ssm007:0|Ssm009:0|Ssm010:0|Ssm011:0|Ssm013:1|Ssm014:1|Ssm015:0|Ssm017:0|Ssm018:0]]></SystemInterface></UserPermissionValue>', N'日，月，年财务报表查看，财务支出，员工工资业绩查看，考勤查看', CAST(0x0000A52C0106CA36 AS DateTime), N'20141125111443713', CAST(0x0000A52C0108D629 AS DateTime), N'20141125111443713')
GO
update [dbo].[tb_ErpSystemConfigure] set [Sconfig_Value]='<?xml version="1.0" encoding="utf-8"?><CurrentShopSetting><StudioStoreNumbers><![CDATA[SSN001]]></StudioStoreNumbers><OrdersNumberPrefixName><![CDATA[HS|ET|XZ|QT]]></OrdersNumberPrefixName></CurrentShopSetting>' where [Sconfig_Code]='SSN001'
update [dbo].[tb_ErpSystemConfigure] set [Sconfig_Value]='<?xml version="1.0" encoding="utf-8"?><SystemGlobalSetting><ReportFormPageSize>50</ReportFormPageSize><IsSelectionFilmsHiddenPhoto>False</IsSelectionFilmsHiddenPhoto><IsSelectionFilmsDisruptOrder>True</IsSelectionFilmsDisruptOrder><F2SWitchDisplayPhoto>True</F2SWitchDisplayPhoto><F4SWitchPhotoOrder>True</F4SWitchPhotoOrder><IsShowSelectPhtotInfo>True</IsShowSelectPhtotInfo><IsSelectPhotoIntoBookIncludeAllProduct>True</IsSelectPhotoIntoBookIncludeAllProduct><IsHideSelectPhotoSeeDeleteButton>False</IsHideSelectPhotoSeeDeleteButton><SelectPhotoF5SeeDeletePhtoto>True</SelectPhotoF5SeeDeletePhtoto><ServiceCompletedAddPieceRate1>True</ServiceCompletedAddPieceRate1><IsEnablePhotoStyle>True</IsEnablePhotoStyle><LocalPhotoDirectory><![CDATA[D:\ProgramData\LocalCache\PhotoDirectory\]]></LocalPhotoDirectory><IsLocalCacheOriginalFilm>False</IsLocalCacheOriginalFilm><IsLoginAutoOpenIndex>True</IsLoginAutoOpenIndex><IsEnabledAutomaticCalculationPlusPickMoney>False</IsEnabledAutomaticCalculationPlusPickMoney><PhotoPlusPickUnitPrice>20</PhotoPlusPickUnitPrice><ServiceCompletedAddPieceRate>True</ServiceCompletedAddPieceRate><IsEnablePhotoEdition>True</IsEnablePhotoEdition><IsCustomOrderNumber>False</IsCustomOrderNumber><FilmSelectionRemindTimesOut>True</FilmSelectionRemindTimesOut><FilmSelectionTimesOutMinute>120</FilmSelectionTimesOutMinute><FilmSelectionOvertimeMinute>20</FilmSelectionOvertimeMinute><FilmSelectionOvertimePassword><![CDATA[]]></FilmSelectionOvertimePassword><WithoutOperatingAutomaticLogout>False</WithoutOperatingAutomaticLogout><AutomaticLogoutMinute>30</AutomaticLogoutMinute><PrintOrderNoSuffix>False</PrintOrderNoSuffix><IntoBookAndIntoBottom>False</IntoBookAndIntoBottom><UpDownLeftRightKeysBrowsePhotos>False</UpDownLeftRightKeysBrowsePhotos><CroppingSizedList><![CDATA[1600x900:1600x900|1x1方形:1x1|200x500相框:200x500|2x1长方形:1x1|800x300相框:800x300]]></CroppingSizedList><EnableOrderDiscountSystem>True</EnableOrderDiscountSystem><EnableOrderCostControlSystem>False</EnableOrderCostControlSystem><PreviewQuality>80</PreviewQuality><TicketPrintingNumber>1</TicketPrintingNumber><EnabledIDNumber>False</EnabledIDNumber><OrderAutoOpenMemberCard>False</OrderAutoOpenMemberCard></SystemGlobalSetting>' 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