T+13导入库存后无法自动生成助记码

linshengwei

T+13导入库存后无法自动生成助记码 怎么处理

qyhua

启用邀请码注册，提高发帖质量，建设交流社区.

♂Forever!

导入库存？库存的内容多了，具体是什么？存货档案？可以在畅捷通服务社区中，产品--工具，有一个助记码生成的工具，可以试试。

oslven

百度一下，有助记码生成工具，在数据库中执行一下就可以了

oslven

SET NO_BROWSETABLE OFF

select  dbo.f_GetPY('你是哪个昌是昌昌是夺博一年上')
update  code set chelp = upper(left(dbo.f_GetPY(replace(replace(ccode_name,'（',''),'）','')),15 ))

update  customer set ccushelp = upper(left(dbo.f_GetPY(replace(replace(ccusname,'（',''),'）','')),120 ))

update  vendor set cvenHelp = upper(left(dbo.f_GetPY(replace(replace(cvenName,'（',''),'）','')),60 ))

update  gl_bdigest set chelp = upper(left(dbo.f_GetPY(replace(replace(ctext,'（',''),'）','')),120 ))

update  person set cpersonhelp = upper(left(dbo.f_GetPY(replace(replace(cpersonname,'（',''),'）','')),10 ))

update  department set cdephelp = upper(left(dbo.f_GetPY(replace(replace(cdepname,'（',''),'）','')),20 ))

update  Inventory set cInvhelp = upper(left(dbo.f_GetPY(replace(replace(cInvName,'（',''),'）','')),90 ))






if exists(select * from sysobjects where name = 'f_getPY')

drop function f_getPY

go

create function f_getPY(@str nvarchar(4000))

returns nvarchar(4000)

as

begin

declare @word nchar(1), @PY nvarchar(4000)

set @PY = ''

while len(@str) > 0

begin

set @word = left(@str, 1) --如果非汉字字符，返回原字符

set @PY = @PY +

--简体GBK码汉字UNICODE值从19968开始, WINDOWS多国汉字，UNICODE目前收录汉字共20902个

(case when unicode(@word) between 19968 and 19968 + 20901 then

(select top 1 PY from

( select 'A' as PY, N'驁' as word

union all

select 'B',N'簿'

union all

select 'C',N'錯'

union all

select 'D',N'鵽'

union all

select 'E',N'樲'

union all

select 'F',N'鰒'

union all

select 'G',N'腂'

union all

select 'H',N'夻'

union all

select 'J',N'攈'

union all

select 'K',N'穒'

union all

select 'L',N'鱳'

union all

select 'M',N'旀'

union all

select 'N',N'桛'

union all

select 'O',N'漚'

union all

select 'P',N'曝'

union all

select 'Q',N'囕'

union all

select 'R',N'鶸'

union all

select 'S',N'蜶'

union all

select 'T',N'籜'

union all

select 'W',N'鶩'

union all

select 'X',N'鑂'

union all

select 'Y',N'韻'

union all

select 'Z',N'咗') T

where word >= @word

collate Chinese_PRC_CS_AS_KS_WS order by PY ASC)

else @word

end)

set @str = right(@str, len(@str) - 1)

end

return @PY

end

go

--测试用例

--update tj_key