INSERT INTO basedata.ShopShowFunction ( ShowFunctionId , ShowFunctionName ) VALUES ( 100 , -- ShowFunctionId - int N'只有【产品展示】功能' -- ShowFunctionName - nvarchar(50) ), ( 110 , -- ShowFunctionId - int N'只看补件' -- ShowFunctionName - nvarchar(50) ), ( 120 , -- ShowFunctionId - int N'只看产品' -- ShowFunctionName - nvarchar(50) ); -- 初始化业务员展示权限 -- INSERT INTO basedata.ShopMemberShowPrivilege ( ShopMemberId, ShowFunctionId ) SELECT ShopMemberId, 100 FROM basedata.ShopMemberPrivilege WHERE FunctionId = 20000;