C/S架构软件:系统权限初始化、系统初始化界面设计及参考方案


本文简介
C/S系统开发框架的【初始化权限】是指清除所有权限系统的数据,还原为最原始状态(数据不可恢复!),如:角色资料、用户组资料、用户的权限数据等。
权限初始化 usp_InitPermission 存储过程参考:
SQL Code:
DELETE FROM dbo.tb_MyFormTagName
DELETE FROM dbo.tb_MyGroup
DELETE FROM dbo.tb_MyGroupRole
DELETE FROM dbo.tb_MyGroupUser
DELETE FROM dbo.tb_MyMenu
DELETE FROM dbo.tb_MyRole
DELETE FROM dbo.tb_MyRoleActions
DELETE FROM dbo.tb_MyUserRoles
//来源:C/S框架网 | www.csframework.com | QQ:23404761
DELETE FROM dbo.tb_MyGroup
DELETE FROM dbo.tb_MyGroupRole
DELETE FROM dbo.tb_MyGroupUser
DELETE FROM dbo.tb_MyMenu
DELETE FROM dbo.tb_MyRole
DELETE FROM dbo.tb_MyRoleActions
DELETE FROM dbo.tb_MyUserRoles
//来源:C/S框架网 | www.csframework.com | QQ:23404761
初始化权限按钮
打开【系统管理】模块的【组织机构权限】界面,【初始化权限】功能按钮如下图:

系统初始化
将系统所有资料还原为最原始状态,包括系统权限、用户数据、所有业务数据等。
系统初始化界面设计参考:

系统初始化界面包括两部分设计:
1. 勾选要初始化数据的资料名称。
2. 输入确认指令。系统一旦初始化,将不可恢复数据!
3. 设计一个存储过程,如: usp_InitPermission,用于开发系统初始化的处理逻辑。

扫一扫加微信


版权声明:本文为开发框架文库发布内容,转载请附上原文出处连接
NewDoc C/S框架网