USE [CmxSystem]
GO
/****** Object: StoredProcedure [dbo].[getorderno] Script Date: 2018/10/11 星期四 17:13:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[getorderno](
@ordertype VARCHAR(10)
)
AS
BEGIN ------ 2018--7--23
DECLARE @letid INT -----字母ID
DECLARE @number INT ---数字
DECLARE @nowdate VARCHAR(20) ---今天日期
DECLARE @letter VARCHAR(10) ----字母
DECLARE @neworderno VARCHAR(30) -----新单号
SET @number=0
SET @letid=0
SET @letter=''
SELECT @nowdate=RIGHT(CONVERT(VARCHAR(8),GETDATE(),112),6) ----取日期
SELECT @number=OrderNumber,@letid=LetId FROM dbo.OrderNumbers WHERE OrderType=@ordertype
IF(@number=0)
BEGIN
SET @neworderno='' --设置值
SELECT @neworderno --赋值
END
IF NOT EXISTS(SELECT TOP 1 1 FROM ordernumbers WHERE orderdate=@nowdate AND OrderType=@ordertype)----新的日期
BEGIN
UPDATE ordernumbers S
SQLserver 按规则生成单号的存储过程
最新推荐文章于 2023-09-10 11:27:08 发布