新增文章

文章标题分类内容

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【功能权限管理】【查询权,管理权】

select * from t_GroupAccessType                          --【模块名称】
   select * from t_GroupAccess      where FUserID = 16399   --【模块权限】【用户】

select * from t_GroupAccessType  where FGroupID IN ( 15  ,16   )  --【一星软件】
   select * from t_GroupAccessType  where FGroupID IN ( 2101,2102 )  --【客户化开发】
   
   select * from t_Groups        --【空】
   select * from t_GrouptLink    --【空】

/*
   delete from t_GroupAccessType  where FGroupID in ( 15 ,16 ) 
   
   insert into t_GroupAccessType( FGroupID,FMask,FAccess,FSubSys,FSubSys_Cht,FSubSys_en,FAccess_Cht,FAccess_en,FVisiableForPlus ) 
   
                          select  15,1 ,'查询权','一星模块','一星模块','一星模块','一星模块','一星模块' ,1 
                    union select  16,7 ,'管理权','一星模块','一星模块','一星模块','一星模块','一星模块' ,1 
*/

exec a_Select 'a_ObjectAccess' ,@where = 'FAccess LIKE ''%%'' and  FObjectTypeName LIKE ''%一星%'' and  FObjectName LIKE ''%%''  '
                                  ,@order = 'FGroupID,FObjectType,FObjectID,FIndex'

select * from t_ObjectAccess                          --【模块名称.权限名称】
   select * from t_GroupAccessType                       --【模块名称】
   
   select * from t_ObjectType       where FObjectID = 0  --【权限名称】上级组
   select * from t_ObjectType                            --【权限名称】单据
   
   select * from t_ObjectAccessType                      --【功能名称】

/*
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   delete from T_ObjectType where FObjectType = 20 and FObjectID = 0
   delete from T_ObjectType where FObjectType = 18 and FObjectID = 0
   delete from t_ObjectType where FObjectType = 18 and FObjectID = 210001201; 
   
   insert into T_ObjectType( FObjectType,FObjectID,FName,FName_cht,FName_en ,FDescription,FDescription_cht,FDescription_en )

select  20,0 ,'一星基础','一星基础','一星基础','一星基础','一星基础','一星基础'
                     union select  18,0 ,'一星单据','一星单据','一星单据','一星单据','一星单据','一星单据'
                     
                     union select  18,210001201 ,'销售订单_New','销售订单_New','Bill_210001201','','',''

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   delete t_ObjectAccessType where FObjectType = 18 and FObjectID = 210001201

insert into t_ObjectAccessType( FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en )  
   
                           select  18,210001201 ,1 ,2097152  ,1048576 ,'查看','查看','查看','查看','查看','查看' 
                     union select  18,210001201 ,3 ,1024     ,3145728 ,'查看凭证','查看凭证','查看凭证','查看凭证','查看凭证','查看凭证' 
                     union select  18,210001201 ,4 ,131072   ,3145728 ,'新增','新增','新增','新增','新增','新增' 
                     union select  18,210001201 ,5 ,4194304  ,3145728 ,'修改','修改','修改','修改','修改','修改' 
                     union select  18,210001201 ,6 ,65536    ,3145728 ,'删除','删除','刪除','delete','刪除','delete' 
                     union select  18,210001201 ,7 ,32768    ,3145728 ,'打印','打印','列印','Print','列印','Print' 
                     union select  18,210001201 ,8 ,1        ,3145728 ,'作废','','作废','作废','','' 
                     union select  18,210001201 ,9 ,4        ,3145728 ,'反作废','','反作废','反作废','','' 
                     union select  18,210001201 ,10,2        ,3145728 ,'确认','','确认','确认','','' 
                     union select  18,210001201 ,11,8        ,3145728 ,'反确认','','反确认','反确认','','' 
                     union select  18,210001201 ,12,16       ,3145728 ,'引出内部数据','引出内部数据','引出内部数据','引出内部数据','引出内部数据','引出内部数据' 
                     union select  18,210001201 ,13,512      ,0       ,'合并生成凭证','合并生成凭证','合併生成憑證','Consolidate and Generate Voucher','合併生成憑證','Consolidate and Generate Voucher'

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   delete t_ObjectAccess where FObjectType = 18 and FObjectID = 210001201

insert into t_ObjectAccess( FGroupID,FObjectType,FObjectID,FIndex ) 
   
                       select  15,18,210001201,1
                 union select  15,18,210001201,3

union select  16,18,210001201,4
                 union select  16,18,210001201,5 
                 union select  16,18,210001201,6 
                 union select  16,18,210001201,7 
                 union select  16,18,210001201,8 
                 union select  16,18,210001201,9 
                 union select  16,18,210001201,10 
                 union select  16,18,210001201,11 
                 union select  16,18,210001201,12 
                 union select  16,18,210001201,13 
*/