数据表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NumSeq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NumSeq]
GO
CREATE TABLE [dbo].[NumSeq] (
[Cate] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DateNo] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Seq] [int] NOT NULL ,
[CrTime] [datetime] NOT NULL
) ON [PRIMARY]
GO
网上找到的存储过程CREATE PROC dpPMT_SGetMaintainSeq
@MaintainCate VARCHAR(2)AS
--***********************累加编号*************************************************
DECLARE @MaintainNo VARCHAR(12)
IF NOT EXISTS(SELECT
*
FROM
NumSeq
WHERE
Cate=@MaintainCate AND DATEDIFF(DAY,CrTime,GETDATE())=0)
BEGIN
INSERT INTO
NumSeq(Cate,DateNo,Seq)
values(@MaintainCate,RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE())),0) END
ELSE
BEGIN
UPDATE
NumSeq
SET
Seq=Seq+1
WHERE
Cate=@MaintainCate AND DateNo=RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE()))
END--************************组合编号***************************************************************
SELECT
@MaintainNo=Cate+DateNo+REPLICATE('0',6-LEN(Seq))+CONVERT(VARCHAR(6),Seq)
FROM
NumSeq
WHERE
Cate=@MaintainCate AND DateNo=RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE()))SELECT @MaintainNoGO我怎么调用 存储过程所输出的@MaintainNo 值 在textBox显示
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NumSeq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NumSeq]
GO
CREATE TABLE [dbo].[NumSeq] (
[Cate] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DateNo] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Seq] [int] NOT NULL ,
[CrTime] [datetime] NOT NULL
) ON [PRIMARY]
GO
网上找到的存储过程CREATE PROC dpPMT_SGetMaintainSeq
@MaintainCate VARCHAR(2)AS
--***********************累加编号*************************************************
DECLARE @MaintainNo VARCHAR(12)
IF NOT EXISTS(SELECT
*
FROM
NumSeq
WHERE
Cate=@MaintainCate AND DATEDIFF(DAY,CrTime,GETDATE())=0)
BEGIN
INSERT INTO
NumSeq(Cate,DateNo,Seq)
values(@MaintainCate,RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE())),0) END
ELSE
BEGIN
UPDATE
NumSeq
SET
Seq=Seq+1
WHERE
Cate=@MaintainCate AND DateNo=RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE()))
END--************************组合编号***************************************************************
SELECT
@MaintainNo=Cate+DateNo+REPLICATE('0',6-LEN(Seq))+CONVERT(VARCHAR(6),Seq)
FROM
NumSeq
WHERE
Cate=@MaintainCate AND DateNo=RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE()))SELECT @MaintainNoGO我怎么调用 存储过程所输出的@MaintainNo 值 在textBox显示
",con) ;
cmd.CommandType=CommandType.Procedure;
con.Open();
object obj = cmd.ExecuteScalar();
con.Close();