【038】U9私有扩展字段枚举的多语言表的SQL更新

最新U9C更新方式

https://success.yonyou.com/community/askDetail?aId=5816881121fbf549e5b4247c41ea84d91d9f7ed00d9da70f&cid=d65f538614c87d47&themeType=3

exec dbo.P_SyncFieldCombineNameNew 'UFIDA.U9.CBO.SCM.Item.ItemMaster','Global',3,'admin',1002011066091830

枚举名称更新到出货行私有段2

Select SMSL.ID as ID,
ISNULL(UBF_Sys_E1.Code, '') as Code,
ISNULL(UBF_Sys_ET1.name, '') as Name,
'zh-CN' as SysMLFlag
Into #TempDataID  
from SM_Shipline as SMSL
join UBF_Sys_ExtEnumValue as UBF_Sys_E1 on SMSL.DescFlexField_PrivateDescSeg2=UBF_Sys_E1.Code   
left join [UBF_Sys_ExtEnumValue_Trl] as UBF_Sys_ET1 on (UBF_Sys_ET1.SysMlFlag='zh-CN') and (UBF_Sys_E1.[ID]=UBF_Sys_ET1.[ID])
where SMSL.ID='1001605211160465'
and UBF_Sys_E1.[ExtEnumType]=1001510090000043
--select * from #TempDataID
exec P_Samuel_CombineNameUpdate 'SM_Shipline','#TempDataID',52
DropTable #TempDataID

其中：UBF\_Sys\_E1.Code是枚举编码，UBF\_Sys\_ET1.name是枚举名称，SMSL.ID是更新的表记录ID，TempDataID  是存储更新表记录的ID，枚举编码，枚举名称和语言的临时表，P\_Samuel\_CombineNameUpdate是更新多语言表的存储过程，SM\_Shipline是要更新的表的名称，52，是扩展第二个字段。扩展第一个字段是51，第三是53，依次类推。