得到发起人的未还借款Proc

最新推荐文章于 2023-03-16 10:55:15 发布

tzjly

最新推荐文章于 2023-03-16 10:55:15 发布

阅读量907

点赞数

分类专栏：金和C6 procedure 文章标签： join date 脚本 c

本文链接：https://blog.csdn.net/tzjly/article/details/7567105

版权

金和C6 同时被 2 个专栏收录

44 篇文章 1 订阅

订阅专栏

procedure

6 篇文章 0 订阅

订阅专栏

得到发起人的未还借款Proc

USE [C6]
GO
/****** 对象:  StoredProcedure [dbo].[Form_pYS_GetBorrowMoney]    脚本日期: 05/15/2012 07:40:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Form_pYS_GetBorrowMoney]
	@UserID varchar(50)
AS
BEGIN
	declare @BorrowMoney numeric(15,2)
	declare @ReturnMoney numeric(15,2)
	select @BorrowMoney=0
	select @ReturnMoney=0
	select @BorrowMoney=@BorrowMoney+isnull(sum(BorrowMoney),0) from Form_YS_PaymentApply as a inner join moduleapproveflag b on a.id=b.id and b.app_flag=1 and b.delflag = 0 where AppUserID=@UserID
	select @BorrowMoney=@BorrowMoney+isnull(sum(BorrowMoney),0) from Form_YS_EvectionApply as a inner join moduleapproveflag b on a.id=b.id and b.app_flag=1 and b.delflag = 0 where AppUserID=@UserID

	select @ReturnMoney=@ReturnMoney+isnull(sum(ReturnLoan),0) from Form_YS_PaymentExpense as a inner join moduleapproveflag b on a.id=b.id and b.app_flag=1 and b.delflag = 0 where AppUserID=@UserID
	select @ReturnMoney=@ReturnMoney+isnull(sum(ReturnLoan),0) from Form_YS_TravelExpense as a inner join moduleapproveflag b on a.id=b.id and b.app_flag=1 and b.delflag = 0 where AppUserID=@UserID
	select @ReturnMoney=@ReturnMoney+isnull(sum(Money),0) from Form_YS_RepaymentReg where BorrowUserID=@UserID

	select case when (@BorrowMoney-@ReturnMoney)<0 then 0 else @BorrowMoney-@ReturnMoney end ,case when @BorrowMoney<0 then 0 else @BorrowMoney end,case when @ReturnMoney<0 then 0 else @ReturnMoney end

END