没有合适的资源?快使用搜索试试~ 我知道了~
c#调用存储过程
需积分: 9 2 下载量 32 浏览量
2012-05-08
21:02:44
上传
评论
收藏 1KB TXT 举报
温馨提示
试读
2页
c#调用存储过程
资源推荐
资源详情
资源评论
ALTER PROCEDURE [dbo].[notice]
@username varchar(30),@vstr varchar(600) output
AS
BEGIN
SET NOCOUNT ON;
declare @xiaozhang int,@fenguan int,@zhuguan int,@jiaowu int,@zonghe int,@caiwu int
set @xiaozhang=dbo.Get_ArrayStr((select quanxian from login where username=@username),',',4)
set @fenguan=dbo.Get_ArrayStr((select quanxian from login where username=@username),',',5)
set @zhuguan=dbo.Get_ArrayStr((select quanxian from login where username=@username),',',6)
set @vstr =''
--校长权限
if @xiaozhang=1 and (select count(*) from baoxiao where threeapply=0)>0
set @vstr=@vstr+'■校长报销审批模块'
if @xiaozhang=1 and (select count(*) from borrow where threeapply=0)>0
set @vstr=@vstr+'■校长借款审批模块'
if @xiaozhang=1 and (select count(*) from tech where threeapply=0)>0
set @vstr=@vstr+'■校长日志审批模块'
--分管校长权限
if @fenguan=1 and (select count(*) from baoxiao where twoapply=0)>0
set @vstr=@vstr+'■分管校长报销审批'
if @fenguan=1 and (select count(*) from borrow where twoapply=0)>0
set @vstr=@vstr+'■分管校长借款审批'
if @fenguan=1 and (select count(*) from tech where twoapply=0)>0
set @vstr=@vstr+'■分管校长日志审批'
--主管权限
if @zhuguan=1 and (select count(*) from baoxiao where oneapply=0 and suoshu=3)>0
set @vstr=@vstr+'■招办主任报销审批'
if @zhuguan=1 and (select count(*) from borrow where oneapply=0 and suoshu=3)>0
set @vstr=@vstr+'■招办主任借款审批'
return
@username varchar(30),@vstr varchar(600) output
AS
BEGIN
SET NOCOUNT ON;
declare @xiaozhang int,@fenguan int,@zhuguan int,@jiaowu int,@zonghe int,@caiwu int
set @xiaozhang=dbo.Get_ArrayStr((select quanxian from login where username=@username),',',4)
set @fenguan=dbo.Get_ArrayStr((select quanxian from login where username=@username),',',5)
set @zhuguan=dbo.Get_ArrayStr((select quanxian from login where username=@username),',',6)
set @vstr =''
--校长权限
if @xiaozhang=1 and (select count(*) from baoxiao where threeapply=0)>0
set @vstr=@vstr+'■校长报销审批模块'
if @xiaozhang=1 and (select count(*) from borrow where threeapply=0)>0
set @vstr=@vstr+'■校长借款审批模块'
if @xiaozhang=1 and (select count(*) from tech where threeapply=0)>0
set @vstr=@vstr+'■校长日志审批模块'
--分管校长权限
if @fenguan=1 and (select count(*) from baoxiao where twoapply=0)>0
set @vstr=@vstr+'■分管校长报销审批'
if @fenguan=1 and (select count(*) from borrow where twoapply=0)>0
set @vstr=@vstr+'■分管校长借款审批'
if @fenguan=1 and (select count(*) from tech where twoapply=0)>0
set @vstr=@vstr+'■分管校长日志审批'
--主管权限
if @zhuguan=1 and (select count(*) from baoxiao where oneapply=0 and suoshu=3)>0
set @vstr=@vstr+'■招办主任报销审批'
if @zhuguan=1 and (select count(*) from borrow where oneapply=0 and suoshu=3)>0
set @vstr=@vstr+'■招办主任借款审批'
return
资源评论
mengmeng1314fei
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功