RzCheckTree实现权限管理

--权限表 create table authority(autoid int identity(1,1) primary key not null, authcode varchar(50) not null, authname varchar(100) not null, authgrade int not null, accid varchar(10) not null, isown bit default 0 null, ownPcode varchar(20) not null, memo varchar(50) null) go insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL','基础设置','1','999','1','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL01','机构设置','2','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0101','部门档案','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0102','人员档案','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL02','往来单位','2','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0201','供应商分类','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0202','供应商档案','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0203','客户分类','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0204','客户档案','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL03','物料','2','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0301','物料分类','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0302','物料档案','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL04','购销存','2','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0401','仓库档案','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0402','收发类别','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ZL0403','物料清单','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST','库存管理','1','999','1','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST01','初始设置','2','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0101','选项','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0102','期初数据','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST010201','期初数据 - 查询','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST010202','期初数据 - 新增','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST010203','期初数据 - 修改','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST02','入库业务','2','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0201','采购入库单','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020101','采购入库单 - 查询','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020102','采购入库单 - 新增','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020103','采购入库单 - 修改','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020104','采购入库单 - 删除','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020105','采购入库单 - 审核','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0202','产成品入库单','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020201','产成品入库单 - 查询','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020202','产成品入库单 - 新增','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020203','产成品入库单 - 修改','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020204','产成品入库单 - 删除','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020205','产成品入库单 - 审核','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0203','其它入库单','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020301','其它入库单 - 查询','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020302','其它入库单 - 新增','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020303','其它入库单 - 修改','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020304','其它入库单 - 删除','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST020305','其它入库单 - 审核','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST03','出库业务','2','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0301','销售出库单','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030101','销售出库单 - 查询','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030102','销售出库单 - 新增','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030103','销售出库单 - 修改','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030104','销售出库单 - 删除','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030105','销售出库单 - 审核','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0302','材料出库单','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030201','材料出库单 - 查询','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030202','材料出库单 - 新增','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030203','材料出库单 - 修改','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030204','材料出库单 - 删除','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST030205','材料出库单 - 审核','4','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) values('ST0303','其它出库单','3','999','0','demo',''); insert into authority(authcode,authname,authgrade,accid,isown,ownpcode,memo) val