lyfz_repos/铂金版源码/DBFile/SQL/添加默认角色权限.sql

---在要添加的数据库中按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')