SELECT dbo.canshu.id AS Expr1, t_UserLogin_1.ID AS Expr2, dbo.Shenp.ID,
dbo.Shenp.请求时间, t_UserLogin_1.公司名称, t_UserLogin_1.公司全称,
dbo.Shenp.收款公司, t_UserLogin_1.用户名, t_UserLogin_1.姓名,
t_UserLogin_1.短信开启, t_UserLogin_1.联系电话, t_UserLogin_1.手机号码,
dbo.Shenp.编号, dbo.Shenp.审批单号, dbo.Shenp.审批金额, dbo.Shenp.审批内容,
dbo.Shenp.单据状态, dbo.Shenp.状态说明,
(select 批复日期 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 批复日期,
(select 审批意见nm from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 审批意见nm,
(select 审批意见 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 审批意见,
(select 批复金额 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 批复金额,
(select 姓名 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 审批人,
(CASE WHEN(select 审批意见 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) ))='同意' then dbo.Shenp.加密认证 ELSE '' END)AS 加密信息,
t_UserLogin_1.等级,
dbo.canshu.参数值 AS 审批状态, t_UserLogin_1.授信额度, dbo.Shenp.收款人,
dbo.Shenp.帐号, dbo.Shenp.开户银行, dbo.Shenp.付出银行,
dbo.Shenp.付出银行账号, dbo.Shenp.结算方式, dbo.Shenp.userid,
(CASE WHEN
(SELECT TOP 1 审批意见
FROM v_shenpjg
WHERE (批复单号 = 审批单号)
ORDER BY 批复日期 DESC) = '同意' THEN dbo.Shenp.加密认证 ELSE '' END)
AS 加密信息
FROM dbo.Shenp INNER JOIN
dbo.t_UserLogin t_UserLogin_1 ON
dbo.Shenp.userid = t_UserLogin_1.ID LEFT OUTER JOIN
dbo.canshu ON dbo.Shenp.审批状态 = dbo.canshu.id