菜单页面枚举显示名称改名脚本

by 祁宏伟 2012.12.6 10:25

注:脚本执行有风险,对于客户正式环境请在研发指导下执行。

--将需要修改的名称换入到下面脚本中。

1.       一般菜单改名:                  
    update UBF_Assemble_Menu_Trl set DisplayName ='广青采购订单' where DisplayName = '采购合同' and SysMLFlag='zh-CN'
2.       对应的标题改名:     
    update UBF_Assemble_Page_Trl set Title ='广青采购订单' where Title = '采购合同'       
       有的标题是开发人员代码赋的值,如标准采购、标准销售等所以,需要去找对应的资源:     
      select * from UBF_RES_ResourceValue where DisplayName = '标准销售'  and type='CustomResource' 
       注意其ResouceName 为资源类型属性全名:UFIDA.U9.SCM.SM.SOUIModel.SOUIModelRes.Com_SOStd  
 3.       一般顺便可以把Form名称改一下,影响其在权限分配等相关地方展现。
    update UBF_MD_UIForm_Trl set DisplayName ='广青采购订单' where DisplayName = '采购合同' and SysMLFlag='zh-CN'
 4.       对于枚举显示名称:注意要找对枚举类型全名就可。
update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购订单' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='362E9505-235D-4B45-83FD-3448E1880617') and  SysMLFlag='zh-CN' and Name ='采购合同'update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购合同' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='362E9505-235D-4B45-83FD-3448E1880617') and  SysMLFlag='zh-CN' and Name ='采购订单'       
      
--修改菜单
update UBF_Assemble_Menu_Trl set DisplayName='领料差异倒冲' where DisplayName='盘点差异倒冲' 
--修改页面
update UBF_Assemble_Page_Trl set Title='领料差异倒冲' where Title ='盘点差异倒冲' 
--修改界面Form
update UBF_MD_UIForm_Trl set DisplayName='领料差异倒冲' where DisplayName='盘点差异倒冲'

Tags:

评论 (20) -

qihw wrote at 2012/12/5 15:50:33 #


--广青 更改专用SQL
update UBF_Assemble_Menu_Trl set DisplayName ='广青采购订单' where DisplayName = '采购合同' and SysMLFlag='zh-CN'
update UBF_Assemble_Menu_Trl set DisplayName ='广青采购合同' where DisplayName = '标准采购' and SysMLFlag='zh-CN'
update UBF_Assemble_Menu_Trl set DisplayName ='广青采购合同变更单' where DisplayName = '采购订单变更单' and SysMLFlag='zh-CN'
update UBF_Assemble_Menu_Trl set DisplayName ='广青销售订单' where DisplayName = '销售合同' and SysMLFlag='zh-CN'
update UBF_Assemble_Menu_Trl set DisplayName ='广青销售合同' where DisplayName = '标准销售' and SysMLFlag='zh-CN'
update UBF_Assemble_Menu_Trl set DisplayName ='广青销售合同变更单' where DisplayName = '销售订单变更单' and SysMLFlag='zh-CN'

--更改form
update UBF_MD_UIForm_Trl set DisplayName ='广青采购订单' where DisplayName = '采购合同' and SysMLFlag='zh-CN'
update UBF_MD_UIForm_Trl set DisplayName ='广青采购合同' where DisplayName = '标准采购' and SysMLFlag='zh-CN'
update UBF_MD_UIForm_Trl set DisplayName ='广青采购合同变更单' where DisplayName = '采购订单变更单' and SysMLFlag='zh-CN'
update UBF_MD_UIForm_Trl set DisplayName ='广青销售订单' where DisplayName = '销售合同' and SysMLFlag='zh-CN'
update UBF_MD_UIForm_Trl set DisplayName ='广青销售合同' where DisplayName = '销售订单' and SysMLFlag='zh-CN'
update UBF_MD_UIForm_Trl set DisplayName ='广青销售合同变更单' where DisplayName = '销售订单变更单' and SysMLFlag='zh-CN'

--更改Page
update UBF_Assemble_Page_Trl set Title ='广青采购订单' where Title = '采购合同'
update UBF_Assemble_Page_Trl set Title ='广青采购合同' where Title = '标准采购'
update UBF_Assemble_Page_Trl set Title ='广青采购合同变更单' where Title = '采购订单变更单'
update UBF_Assemble_Page_Trl set Title ='广青销售订单' where Title = '销售合同'
update UBF_Assemble_Page_Trl set Title ='广青销售合同' where Title = '销售订单'
update UBF_Assemble_Page_Trl set Title ='广青销售合同变更单' where Title = '销售订单变更单'


-- UFIDA::U9:TongM::Enums:TongOSrcDocTypeEnum  采购订单来源单据类型  
update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购订单' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='362E9505-235D-4B45-83FD-3448E1880617') and  SysMLFlag='zh-CN' and Name ='采购合同'
update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购合同' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='362E9505-235D-4B45-83FD-3448E1880617') and  SysMLFlag='zh-CN' and Name ='采购订单'

-- UFIDA::U9:TongM::Enums::RcvSrcDocTypeEnum  标准收货来源类别  
update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购订单' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='2E16635C-7286-4325-A97D-2267D1560A7E') and  SysMLFlag='zh-CN' and Name ='采购合同'
update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购合同' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='2E16635C-7286-4325-A97D-2267D1560A7E') and  SysMLFlag='zh-CN' and Name ='采购订单'

--SrcDocTypeEnum  UFIDA::U9::SM::Enums::SrcDocTypeEnum  标准销售来源单据类型  
update UBF_Sys_ExtEnumValue_Trl set Name ='广青销售订单' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='9F4CEAC4-9BA2-491E-B940-FBDC9DD6ADC2') and  SysMLFlag='zh-CN' and Name ='销售合同'
update UBF_Sys_ExtEnumValue_Trl set Name ='广青销售合同' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='9F4CEAC4-9BA2-491E-B940-FBDC9DD6ADC2') and  SysMLFlag='zh-CN' and Name ='采购订单'

-- UFIDA::U9::SM::Ship::ShipSrcDocTypeEnum  标准出货来源类别  
update UBF_Sys_ExtEnumValue_Trl set Name ='广青销售订单' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='9E7E5DA7-DFAF-4EB4-B4A4-D9400298912C') and  SysMLFlag='zh-CN' and Name ='采购合同'
update UBF_Sys_ExtEnumValue_Trl set Name ='广青销售合同' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='9E7E5DA7-DFAF-4EB4-B4A4-D9400298912C') and  SysMLFlag='zh-CN' and Name ='采购订单'


--UFIDA::U9::SM::RMR::RMRSrcDocTypeEnum  销售退回申请来源类别  
update UBF_Sys_ExtEnumValue_Trl set Name ='广青销售合同' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='C1D5B96C-8C13-4F40-8075-FE5422DA8C24') and  SysMLFlag='zh-CN' and Name ='销售订单'

-- UFIDA::U9::CBO::FI::Enums:TongrePayObjEnum  请款单行预付款类型
update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购合同' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='75DF2363-F539-4D07-AA61-28C642E6F1D4') and  SysMLFlag='zh-CN' and Name ='采购订单'
update UBF_Sys_ExtEnumValue_Trl set Name ='广青采购订单' where ID in (select ID from UBF_Sys_ExtEnumValue where ExtEnumTypeUID='75DF2363-F539-4D07-AA61-28C642E6F1D4') and  SysMLFlag='zh-CN' and Name ='合同'


tyg wrote at 2012/12/6 12:24:38 #

--销售订单窗口标题
update UBF_RES_ResourceValue
set DisplayName = '广青销售合同'
from UBF_RES_ResourceValue
where resourcename = 'UFIDA.U9.SCM.SM.SOUIModel.SOUIModelRes.Com_SOStd' and LanguageName = 'zh-CN'

--SrcDocTypeEnum  UFIDA::U9::SM::Enums::SrcDocTypeEnum  标准销售来源单据类型  
update evt set evt.Name = (
case  ev.Code
when 'SaleContract' then '广青销售订单'
when 'SO' then '广青销售合同'
else evt.Name end )
from UBF_Sys_ExtEnumType e join UBF_Sys_ExtEnumValue ev on e.ID=ev.ExtEnumType
join UBF_Sys_ExtEnumValue_Trl evt on evt.ID=ev.ID and evt.SysMLFlag='zh-CN'
where e.Code='UFIDA.U9.SM.Enums.SrcDocTypeEnum'
and ev.Code in ('SaleContract','SO') and evt.SysMLFlag='zh-CN'

-- UFIDA::U9::SM::Ship::ShipSrcDocTypeEnum  标准出货来源类别  
update evt set evt.Name = (
case  ev.Code
when 'SaleContract' then '广青销售订单'
when 'SO' then '广青销售合同'
--when 'ShipmentPlan' then '广青出货通知单'
else evt.Name end )
from UBF_Sys_ExtEnumType e join UBF_Sys_ExtEnumValue ev on e.ID=ev.ExtEnumType
join UBF_Sys_ExtEnumValue_Trl evt on evt.ID=ev.ID and evt.SysMLFlag='zh-CN'
where e.Code='UFIDA.U9.SM.Ship.ShipSrcDocTypeEnum'
and ev.Code in ('SaleContract','SO','ShipmentPlan') and evt.SysMLFlag='zh-CN'

--UFIDA::U9::SM::ShipPlan::ShipPlanSrcDocTypeEnum  出货计划来源类别
update evt set evt.Name = (
case  ev.Code
when 'SaleContract' then '广青销售订单'
when 'SO' then '广青销售合同'
--when 'ShipmentPlan' then '广青出货通知单'
else evt.Name end )
from UBF_Sys_ExtEnumType e join UBF_Sys_ExtEnumValue ev on e.ID=ev.ExtEnumType
join UBF_Sys_ExtEnumValue_Trl evt on evt.ID=ev.ID and evt.SysMLFlag='zh-CN'
where e.Code='UFIDA.U9.SM.ShipPlan.ShipPlanSrcDocTypeEnum'
and ev.Code in ('SaleContract','SO') and evt.SysMLFlag='zh-CN'

tyg wrote at 2012/12/6 14:34:10 #

标准销售来源单据类型 不是UFIDA::U9::SM::Enums::SrcDocTypeEnum  
而是UFIDA::U9::SM::SO::SOSourceTypeEnum

lkc wrote at 2012/12/25 10:40:13 #

这个最好还是做到实施工具中 不然不可控

sexy 美国 wrote at 2016/8/13 0:26:14 #

La verdad es que el articulo es uno de los mejores que he visto sobre ese tema, se agradece mucho la info y el hecho de que esté tan bien redactado y escrito. Hace algún tiempo creo que escuche algo en la radio sobre esto, aunque no recuerdo muy bien. Espero que sigas publicando ya que seguiré visitando este blog! un saludo!.|

お金 借りる 即日 美国 wrote at 2016/10/25 16:21:56 #

頻繁にテレビで流れる、みんなが知っている消費者金融の金融各社は大多数がスピード審査をやっていて、急ぎで受けられる即日キャッシングに対応することも可能です。審査にかかる時間も早いところだと最も短くて30分前後です。金利ゼロサービスの特典は、それぞれの消費者金融会社で変わってくるので、ネットをうまく活用していろいろなサイトを比較してみていくことで、自分にあっている便利なところを見つけることができるでしょう。

お金 借りる 即日 美国 wrote at 2016/11/7 20:34:56 #

頻繁にテレビで流れる、みんながその存在を知る消費者金融の金融会社はほとんどが最短即日審査を売りにしていて、最短で受けられる即日融資に対応することも可能です。審査に必要な時間も短いところだと最も短くて30分前後です。金利ゼロサービスの特典は、おのおののキャッシング会社で変わってくるので、ウェブをうまく利用していろいろなサイトを比べてみていくことで、自分にあっている便利なサービスを探すことができると思います。

electric car conversion 美国 wrote at 2016/11/30 18:45:44 #

Hello I am so thrilled I found your blog page, I really found you by accident, while I was browsing on Aol for something else, Anyways I am here now and would just like to say thanks a lot for a fantastic post and a all round thrilling blog (I also love the theme/design), I don’t have time to read through it all at the minute but I have book-marked it and also added in your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the awesome jo.

bicycle 美国 wrote at 2017/3/9 7:23:49 #

It's going to be ending of mine day, however before finish I am reading this fantastic article to improve my know-how.

scooter 美国 wrote at 2017/4/11 6:52:01 #

You are so interesting! I do not suppose I have read through anything like that before. So great to find somebody with a few genuine thoughts on this issue. Seriously.. thank you for starting this up. This website is one thing that's needed on the internet, someone with some originality!

クリアネイルショット‖クリアネイル‖クリアネイルショット 美国 wrote at 2017/5/15 3:48:32 #

Appreciate the recommendation. Will try it out.

nike football cleats 美国 wrote at 2018/7/8 9:38:07 #

I simply could not go away your web site before suggesting that I extremely loved the usual info a person supply for your visitors? Is gonna be again continuously in order to inspect new posts  my blog post;  nike football cleats - http://top-tier-income.net/

ferragamo shoes sale 美国 wrote at 2018/7/8 9:55:40 #

I like the helpful info you provide in your articles. I will bookmark your weblog and check again right here frequently. I'm slightly sure I'll be informed a lot of new stuff right here! Good luck for the next!

cheap red bottom heels 美国 wrote at 2018/7/8 10:08:21 #

Your mode of telling everything in this paragraph is genuinely pleasant, all can simply be aware of it, Thanks a lot.  Feel free to surf to my web page;  cheap red bottom heels - http://red-bottom-high-heels.com/

Dsquared2 Shoes 美国 wrote at 2018/7/8 12:11:20 #

Definitely believe that which you stated. Your favorite justification appeared to be on the internet the easiest thing to be aware of. I say to you, I definitely get irked while people think about worries that they just don't know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people can take a signal. Will likely be back to get more. Thanks

wedge heels 美国 wrote at 2018/7/8 13:41:51 #

Whoa! This blog looks exactly like my old one! It's on a entirely different topic but it has pretty much the same layout and design. Wonderful choice of colors!

adidas shoes outlet 美国 wrote at 2018/7/8 13:49:11 #

If some one wants expert view about blogging and site-building afterward i suggest him/her to go to see this website, Keep up the pleasant work.

Sports Shoes Sale 美国 wrote at 2018/7/8 23:20:13 #

Ahaa, its fastidious discussion about this paragraph here at this website, I have read all that, so now me also commenting at this place.

gai goi sinh vien ha noi 美国 wrote at 2019/4/25 14:21:42 #

It's great that you are getting ideas from this piece of writing as well as from our dialogue made at this time.

상품권현금화 美国 wrote at 2020/6/17 17:14:54 #

For loans among £7,000 and £15,000.  Also visit my webpage;  상품권현금화 - community.thulo.com/.../

添加评论



biuquote
微笑得意调皮害羞酷大笑惊讶发呆喜欢可怜尴尬闭嘴噘嘴皱眉伤心抓狂呕吐坏笑漫骂发怒
Loading


RecentComments

评论 RSS

Statistics

989 篇文章
0 个单页
775897 条评论
11 次评分
1443329 次访问
访问统计开始于 2019年12月15日
平均日访问 6808 次
当前 131 人在线