通过URL地址webRequest.GetResponse()访问页面不能调试,可以先查看一下url地址,是否是localhost
节点属性弹出页面
D:\CCFLOW_EN\CCPortal\CCOA_en\CCOA\WF\Comm\Refmethod.aspx.cs
流程属性弹出页面
http://www.test.com.cn:8810/WF/Comm/RefFunc/UIEn.aspx?EnsName=BP.WF.Ext.FlowSheets&No=093
流程属性重新生成标题页面
D:\CCFLOW_EN\CCPortal\CCOA_en\CCOA\WF\Comm\Refmethod.aspx.cs
签核权限
EXEC P_Flow_QX '082',@JinE,@v1,'0','purchase','TM','',@cond2 out
companyNo | flowNo | type1 | type2 | type3 | keji | buji | chuji | fuzong | zongjingli | dongshizhang | remark |
0 | 82 | purchase | TM | NULL | 0 | 0 | 20000 | 50000 | 1E+09 | 1E+09 | 模具/治具 |
0 | 82 | purchase | other | NULL | 0 | 0 | 10000 | 20000 | 100000 | 1E+09 | NULL |
0 | 82 | input | NULL | 0 | 0 | 10000 | 100000 | 1E+09 | 1E+09 | 进货签核权限 | |
0 | 100 | purchase | TM | NULL | 0 | 0 | 20000 | 50000 | 1E+09 | 1E+09 | 模具/治具 |
0 | 100 | purchase | other | NULL | 0 | 0 | 10000 | 20000 | 100000 | 1E+09 | NULL |
0 | 100 | input | NULL | 0 | 0 | 10000 | 100000 | 1E+09 | 1E+09 | 自行采进货签核权限 | |
0 | 101 | NULL | NULL | NULL | NULL | NULL | 10000 | 100000 | 1E+09 | 1E+09 | 进货流程 |
create PROC [dbo].[P_Flow_QX]
@flowNo varchar(10),@JinE float,@level int,@company nvarchar(10),
@t1 varchar(100)='',@t2 varchar(100)='',@t3 varchar(100)='',@ReturnVal char(1) output
as
--@level:级别;@c:公司别
begin
declare @sql nvarchar(1000),@Return int
declare @keji float,@buji float,@chuji float,@fuzong float,@zongjingli float,@dongshizhang float
set @sql='select top 1 @keji=keji,@buji=buji,@chuji=chuji,@fuzong=fuzong,@zongjingli=zongjingli,
@dongshizhang=dongshizhang
from QianHeQX where companyNo='''+@company+''' AND flowNo='''+@flowNo+''''
if @t1!=''
set @sql=@sql+' and type1='''+@t1+''''
if @t2!=''
set @sql=@sql+' and type2='''+@t2+''''
if @t3!=''
set @sql=@sql+' and type3='''+@t3+''''
exec SP_EXECUTESQL @sql,N'@keji float out,@buji float OUT,@chuji float OUT,@fuzong float OUT,
@zongjingli float OUT,@dongshizhang float OUT',@keji out,@buji OUT,@chuji OUT,@fuzong OUT,@zongjingli OUT,@dongshizhang OUT
if @JinE>@dongshizhang and @level=9
set @Return=1
else if @JinE>@zongjingli and @level=8
set @Return=1
else if @JinE>@fuzong and @level=7
set @Return=1
else if @JinE>@chuji and @level=6
set @Return=1
else if @JinE>@buji and @level=5
set @Return=1
else if @JinE>@keji and @level=4
set @Return=1
else
set @Return=-1
if (@ReturnVal=0 and @Return=1)
set @ReturnVal=0
else if @ReturnVal=0 and @Return=-1
set @ReturnVal=1
else if @ReturnVal=1 and @Return=-1
set @ReturnVal=0
else
set @ReturnVal=@Return
end