|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
原先正常,点击银行报盘文件,是否过滤实发合计不大于0的,选择是.
曾经有一次是否过滤实发合计不大于0的,偶选择了否.就出问题了.
以后就是再打开无论选择是还是否都不出界面.再双击银行代发也没有反应,重新推出工资再进入才可以让选择银行报盘文件等.但是还是打不开.
修复安装无效.
我跟踪一下没有看出什么问题,请高手帮忙看看,谢谢啦!
以下是跟踪结果:USE UFSystem
go
declare @P1 int
set @P1=NULL
declare @P2 int
set @P2=557064
declare @P3 int
set @P3=98305
declare @P4 int
set @P4=NULL
exec sp_cursoropen @P1 output, N'SELECT cSub_id,cAuth_Name FROM UA_Auth WHERE cAuth_Id=''WA0305''', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
go
exec sp_cursorfetch 180150001, 16, 1, 1
go
exec sp_cursorclose 180150001
go
USE UFSystem
go
declare @P1 int
set @P1=NULL
declare @P2 int
set @P2=557064
declare @P3 int
set @P3=98305
declare @P4 int
set @P4=NULL
exec sp_cursoropen @P1 output, N'SELECT cSub_id,cAuth_Name FROM UA_Auth WHERE cAuth_Id=''WA0305''', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
go
exec sp_cursorfetch 180150002, 16, 1, 1
go
exec sp_cursorclose 180150002
go
SELECT DISTINCT iauthtype FROM UA_control WHERE cauth_id='WA0305' order by iauthtype asc
go
set implicit_transactions on
go
SELECT * FROM UA_version WITH (updlock)
go
SELECT TOP 1 cstation,csub_id,UA_task.cauth_id as cauth_id FROM UA_task,UA_Control WHERE cacc_id='991' AND (iAuthType =1 or iAuthType=2) AND UA_task.cauth_id=UA_Control.cauth_id AND UA_task.cauth_id<>'reg'
go
SELECT crepellent as ctask FROM UA_control WHERE cauth_id='WA0305' AND (iauthtype<1 OR iauthtype IS NULL)UNION SELECT cauth_id as ctask FROM UA_control WHERE crepellent='WA0305' AND (iauthtype=0 OR iauthtype IS NULL)
go
SELECT TOP 1 cstation,csub_id,cauth_id FROM UA_task WHERE cacc_id='991' AND iyear=2007 AND cauth_id IN ('WA0105','WA0301','WA0302','WA0305')
go
SELECT DISTINCT cauth_id FROM UA_control WHERE cRepellentModule='WA' AND iauthtype=4
go
SELECT TOP 1 cstation,csub_id,cauth_id FROM UA_task WHERE cacc_id='991' AND iyear=2007 AND cauth_id IN ('AS026','GF010802','GF1512','GL010802','GL1512')
go
SELECT distinct csub_id FROM UA_task WHERE cacc_id='991' AND iyear=2007 AND cauth_id<>'reg'
go
select isnull(cNotRepellent,'') from UA_control where cauth_id='WA0305' and iauthtype=3
go
SELECT distinct cstation,csub_id, ua_Task.cauth_id,ua_task.cacc_id,ua_task.iyear FROM ua_Task,UA_control WHERE ua_Task.cauth_id=UA_control.cauth_id and cSub_id='WA' and iauthtype=3
go
SELECT DISTINCT ctaskid FROM UA_tasklog WHERE ctaskid='3408630'
go
SELECT DISTINCT iLogId FROM UA_task WHERE iLogId=2035035153.31226
go
INSERT INTO UA_task (cAcc_Id,iYear,cUser_Id,cAuth_Id,cStation,cTaskId,iLogId,cSub_id,cAppServer) VALUES('991',2007,'xushan','WA0305','REDFLY','3408630',2035035153.31226,'WA','{5DF9E57C-13F4-4DC6-9959-4C707583B071}REDFLY@0')
go
INSERT INTO UA_log VALUES('991','WA','xushan','WA0305','REDFLY','2008-07-24 09:10:27',NULL,2035035153.31226,'2007',0)
go
IF @@TRANCOUNT > 0 COMMIT TRAN
go
SELECT * FROM WA_Bank_Set WHERE cGZGradeNum ='001'and i_id in (SELECT WA_Bank.i_id From WA_Bank WHERE (WA_Bank.bBankUse=1 and cGZGradeNum ='001'))
go
exec WA_GZtblSet
go
exec WA_GZtblSet
go
select * from WA_GZtblSet
go
SELECT WA_GZData.*FROM WA_GZData INNER JOIN WA_psn ON (WA_GZData.cPsn_Num = WA_psn.cPsn_Num) AND (WA_GZData.cPsn_Name = WA_psn.cPsn_Name) AND (WA_GZData.cGZGradeNum = WA_psn.cGZGradeNum) WHERE (WA_GZData.cGZGradeNum='001') and wa_gzdata.Btfbz<>1 and wa_gzdata.bdcbz<>1 AND (WA_GZData.iMonth=11) and WA_psn.i_id=1 ORDER BY WA_GZData.cPsn_Num
go
SELECT WA_psn.*,Department.cdepname FROM WA_GZData INNER JOIN WA_psn ON (WA_GZData.cPsn_Num = WA_psn.cPsn_Num) AND (WA_GZData.cPsn_Name = WA_psn.cPsn_Name) AND (WA_GZData.cGZGradeNum = WA_psn.cGZGradeNum) left join Department on (WA_GZData.cDept_Num = Department.cDepcode) WHERE (WA_GZData.cGZGradeNum='001') and wa_gzdata.Btfbz<>1 and wa_gzdata.bdcbz<>1 AND (WA_GZData.iMonth=11) and WA_psn.i_id=1 ORDER BY WA_GZData.cPsn_Num
go
select * from printex where csystemname='WA' and ntablenum=12
go
SELECT * FROM WA_Bankname WHERE i_id in (SELECT WA_Bank.i_id From WA_Bank WHERE (((WA_Bank.bBankUse)=1)) and cGZGradeNum ='001')
go
SELECT * FROM WA_BankPar WHERE cGZGradeNum ='001' and i_id in (SELECT WA_Bank.i_id From WA_Bank WHERE (cGZGradeNum ='001' and (WA_Bank.bBankUse=1)))
go
SELECT * From WA_Bank WHERE cGZGradeNum ='001'
go |
|