# 新增時 自訂流水號
###### tags: `火箭` `webapi` `mvc`

# model 新增 標籤在流水號欄位

[DatabaseGenerated(DatabaseGeneratedOption.Identity)]

# sql function

USE [pet]
GO
/****** Object:  UserDefinedFunction [dbo].[GetCompanyNo]    Script Date: 2020/9/10 上午 10:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[GetCompanyNo]()
RETURNS nvarchar(20)
AS
BEGIN

    DECLARE @OrderID nvarchar(20)
    DECLARE @DT nvarchar(20)
	SELECT @DT = convert(varchar(10),getdate(),112)
 set @OrderID =	(select  REPLICATE('0',4- Len(cast(isnull(max(substring(companyseq,10,4)),0)+1 as varchar(4)) )) + cast(isnull(max(substring(companyseq,10,4)),0)+1 as varchar(4)) as sno from Company where companyseq like '%' + @dt + '%')

    RETURN 'C'+@DT + @OrderID
END

# 預設值新增