求助 这段存储过程在java怎么调用 万分感激

cjk0506 cjk0506 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
USE [by_furniture_hypsxt_sxysg]
GO
/****** Object: StoredProcedure [dbo].[Get_Code] Script Date: 10/21/2015 10:11:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* 流水号 */
ALTER procedure [dbo].[Get_Code]
(@instr VarChar(13),@outstr varchar(13) Output)
As
Declare
@v_ParaName char(12),
@v_lb char(2),
@v_deptcode char(2),
@v_rq char(6),
@v_number Int,
@v_rqa char(6),
@v_numberstr Varchar(4),
@strMM VarChar(2),
@strDD VarChar(3),
@IntCount Int

Select @v_ParaName = Rtrim(ParaName)
From Dict_Parameter
where Paratypecode='08' and ParaCode=RTRIM(@Instr)
Select @IntCount=@@RowCount
Select @v_lb =SubString(@v_ParaName,1,2)
Select @v_rq = SubString(@v_ParaName,3,6)
Select @v_number =Convert(Int,substring(@v_ParaName,9,4))

Select @strMM = DATEPART(MM, GetDate())
if Convert(Int,@strMM) < 10
Select @strMM = '0' + @strMM
Select @strDD = DATEPART(DD, GetDate())
If Convert(Int,@strDD) < 10
Select @strDD = '0' + @strDD

Select @v_rqa =SubString(Convert(Char(4),DATEPART(YY, GetDate())),3,2) + @strMM + @strDD
if @v_rq=@v_rqa
begin
select @v_number = @v_number+1
select @v_numberstr = Convert(VarChar(4),@v_number)
While len(rTrim(@v_numberstr)) < 4
select @v_numberstr = '0' + @v_numberstr
Select @v_ParaName = @v_lb + @v_rq + @v_numberstr
Select @outstr = ltrim(rTrim(@v_ParaName))
end
else
Select @v_ParaName = @v_lb + @v_rqa + '0001'
if @IntCount=0
Select @v_ParaName = SubString(@InStr,1,2) + @v_rqa + '0001'
Select @outstr = ltrim(rTrim(@v_ParaName))
If @IntCount=0
Insert Into Dict_Parameter (ParaCode,ParaName,ParaTypeCode,ParaTypeName )
Values (@InStr,@v_ParaName,'08','单据')
Else
update Dict_Parameter set ParaName=@v_ParaName Where Paratypecode='08' and ParaCode=rtrim(@instr)
...全文
评论 2
收藏 已收藏
分享
返回顶部
cjk0506
Java 51,407 成员 86,126 内容