PadLeft函数

string num=12

num.PadLeft(4, '0'); //结果为为 '0012'

看字符串长度是否满足4位,不满足则在字符串左边以"0"补足

 

         public string OrderCode
        {
            get
            {
                var result = string.Empty;

                if (CreateTime.HasValue && id>0)
                {
                    result = "D-" + CreateTime.Value.ToString("yyMMdd") + "-" + id.ToString().PadLeft(5, '0');
                }

                return result;
            }
        }

 

SELECT 'D-' + SUBSTRING(CONVERT(NVARCHAR(8), a.CreateTime, 112), 3, 6) + '-'
       + ISNULL(REPLICATE('0', 5 - LEN(ISNULL(a.id, 0))), '') + CONVERT(NVARCHAR(10), a.id)
FROM ClientExchange a
WHERE 'D-' + SUBSTRING(CONVERT(NVARCHAR(8), CreateTime, 112), 3, 6)
      + ISNULL(REPLICATE('0', 5 - LEN(ISNULL(id, 0))), '') + CONVERT(NVARCHAR(10), id) = 'D-191109-00004';

 

create function PadLeft(@num varchar(16),@paddingChar char(1),@totalWidth int)
returns varchar(16) as
begin
declare @curStr varchar(16)
select @curStr = isnull(replicate(@paddingChar,@totalWidth - len(isnull(@num ,0))), '') + @num
return @curStr
end

SELECT dbo.PadLeft('8', '0', 6)
 
----------------
000008

 

 

 

 

在sql server中实现PadLeft函数  https://blog.csdn.net/woods240/article/details/7878344/