新模块BOM从开发流导入到集成流-后台脚本

by 马杰 2014.9.2 16:11

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

 

/*电商数据中心 导入构造项  从V3.0开发流导入集成流*/
/*
INSERT INTO dbo.UBF_Build_Group
        ( ID ,
          CreatedOn ,
          CreatedBy ,
          ModifiedOn ,
          ModifiedBy ,
          SysVersion ,
          Name ,
          Parent ,
          Code ,
          GroupType
        )
SELECT ID,CreatedOn,CreatedBy,ModifiedOn,ModifiedBy,SysVersion,Name,1001409020000021,CODE,GroupType
FROM U9BuildV30_DEV.dbo.UBF_Build_Group WHERE ID IN (1001406230000024,1001406230000025)

INSERT INTO dbo.UBF_Build_Item
        ( ID ,
          CreatedOn ,
          CreatedBy ,
          ModifiedOn ,
          ModifiedBy ,
          SysVersion ,
          Name ,
          OriginType ,
          Version ,
          StartDate ,
          EndDate ,
          BuildItemGroup ,
          Code ,
          IsActive ,
          Applicatioin ,
          Owner
        )
        */
--SELECT * FROM U9BuildV30_DEV.dbo.UBF_Build_Item WHERE BuildItemGroup IN (1001406230000024,1001406230000025)

/*导入bom*/
/*
INSERT INTO dbo.UBF_Build_Group
        ( ID ,
          CreatedOn ,
          CreatedBy ,
          ModifiedOn ,
          ModifiedBy ,
          SysVersion ,
          Name ,
          Parent ,
          Code ,
          GroupType
        )
SELECT ID
FROM U9BuildV30_DEV.dbo.UBF_Build_Group WHERE name='ECDC'
*/
/*
INSERT INTO dbo.UBF_Build_Bom
        ( ID ,
          CreatedOn ,
          CreatedBy ,
          ModifiedOn ,
          ModifiedBy ,
          SysVersion ,
          Name ,
          Industry ,
          Region ,
          BuildMainItem ,
          Code ,
          SrcPath ,
          BuildNo ,
          BuildScript ,
          IsActive ,
          ISV ,
          BuildGroup ,
          BuildSourceLibrary ,
          Version ,
          Module
        )
SELECT * FROM U9BuildV30_DEV.dbo.UBF_Build_BOM WHERE BuildGroup IN (SELECT ID
FROM U9BuildV30_DEV.dbo.UBF_Build_Group WHERE name='ECDC' AND GroupType=1)

---导入模块
INSERT INTO dbo.UBF_Build_Module
        ( ID ,
          CreatedOn ,
          CreatedBy ,
          ModifiedOn ,
          ModifiedBy ,
          SysVersion ,
          Mod_Name ,
          Mod_Disc ,
          Package_Path ,
          Owner ,
          Mod_State ,
          Version
        )
SELECT * FROM U9BuildV30_DEV.dbo.UBF_Build_Module WHERE Mod_Name='ECDC'
*/

Tags:

评论 (22) -

full movies online streaming 美国 wrote at 2016/4/4 18:48:24 #

With havin so much content and articles do you ever run into any problems of plagorism or copyright infringement? My site has a lot of unique content I've either created myself or outsourced but it appears a lot of it is popping it up all over the internet without my authorization. Do you know any solutions to help protect against content from being ripped off? I'd genuinely appreciate it.

www.studiolegaleazzaramarino.it 美国 wrote at 2016/4/10 0:35:08 #

It's going to be finish of mine day, however before ending I am reading this wonderful article to improve my know-how.  Feel free to visit my weblog - Lantai kayu;  www.studiolegaleazzaramarino.it - www.studiolegaleazzaramarino.it/ ,

short people got no reason to live 美国 wrote at 2016/4/10 0:40:04 #

Hey, I think your blog might be having browser compatibility issues. When I look at your blog site in Firefox, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, very good blog!

full movies online streaming 美国 wrote at 2016/4/10 8:27:59 #

Hello it's me, I am also visiting this site regularly, this web site is genuinely nice and the users are in fact sharing good thoughts.

SELGRID Jakarta 美国 wrote at 2016/4/18 16:42:39 #

It's going to be finish of mine day, except before ending I am reading this wonderful piece of writing to increase my experience.  Visit my site -  SELGRID Jakarta - www.tanglewoodtunes.com/.../312866

Yuli 美国 wrote at 2016/4/21 7:34:41 #

Quality posts is the key to be a focus for the users to visit the website, that's what this web page is providing.  Here is my web-site ...  Yuli - www.kvconsultantsinc.com/.../657843

lantaikayuselgrid.com 美国 wrote at 2016/4/28 2:38:46 #

whoah this blog is fantastic i really like reading your articles. Stay up the great work! You realize, many individuals are hunting around for this info, you could aid them greatly.  My weblog parket kayu;  lantaikayuselgrid.com - http://lantaikayuselgrid.com/why-us/ ,

3shop3.com 美国 wrote at 2016/6/9 16:13:23 #

wonderful publish, very informative. I'm wondering why the opposite specialists of this sector don't understand this. You must proceed your writing. I'm confident, you have a great readers' base already!  Also visit my weblog ... biaya sumur bor ( 3shop3.com - 3shop3.com/.../index.php?page=1&id=69039 )

showbox alternatives 2015 美国 wrote at 2016/7/14 7:19:58 #

Howdy very cool website!! Man .. Excellent .. Superb .. I'll bookmark your blog and take the feeds additionally? I am happy to find so many helpful information right here within the post, we want work out more techniques on this regard, thank you for sharing. . . . . .

Maureen Baby Mart 美国 wrote at 2016/7/16 15:52:38 #

I couldn't refrain from commenting. Well written!

www.hawthorns.org.uk 美国 wrote at 2016/7/23 8:04:23 #

My family members all the time say that I am wasting my time here at web, however I know I am getting knowledge every day by reading such good posts.  Also visit my blog post - biaya sumur bor ( www.hawthorns.org.uk - www.hawthorns.org.uk/.../Keperluan_air_jernih_baru_terpenuhi_dengan_memakai_sumur_bor )

simple nail art 美国 wrote at 2016/8/2 8:23:31 #

That is really attention-grabbing, You're an overly skilled blogger. I have joined your rss feed and look ahead to looking for more of your excellent post. Additionally, I've shared your web site in my social networks

Successroute.Co.In 美国 wrote at 2016/8/4 11:41:22 #

A fascinating discussion is worth comment. I think that you should write more on this topic, it may not be a taboo matter but generally folks don't talk about these subjects. To the next! All the best!!  Feel free to visit my weblog: Biaya Sumur Bor ( Successroute.Co.In - successroute.co.in/.../581106.html )

lantaikayuselgrid.com 美国 wrote at 2016/8/10 20:25:18 #

Hello! I simply want to give you a big thumbs up for the great info you have right here on this post. I will be coming back to your blog for more soon.  my site lantai kayu,  lantaikayuselgrid.com - lantaikayuselgrid.com/.../ ,

Nail Art 美国 wrote at 2016/8/13 3:30:25 #

I am really enjoying the theme/design of your website. Do you ever run into any browser compatibility issues? A number of my blog readers have complained about my website not operating correctly in Explorer but looks great in Firefox. Do you have any suggestions to help fix this issue?

Corine 美国 wrote at 2016/8/13 3:59:04 #

Its like you read my thoughts! You seem to understand a lot about this, like you wrote the e-book in it or something. I feel that you just can do with some p.c. to force the message home a little bit, however other than that, this is wonderful blog. An excellent read. I'll definitely be back.

Lantai kayu SELGRID Balikpapan 美国 wrote at 2016/8/18 18:55:02 #

Thanks , I have just been searching for information about this subject for a while and yours is the greatest I have discovered so far. But, what in regards to the conclusion? Are you positive in regards to the source?  Look at my homepage -  Parket Laminate Selgrid bogor - www.sanfrancisco.edu.pe/.../571524

biaya sumur bor 美国 wrote at 2016/8/28 1:58:19 #

It's great that you are getting thoughts from this post as well as from our argument made at this time.  Here is my blog ::  biaya Sumur bor - phpweb.guodns.com/.../index.php

harga Stroller pliko milano 美国 wrote at 2016/9/29 4:58:04 #

Greetings! Very helpful advice in this particular article! It is the little changes that will make the most significant changes. Thanks for sharing!

jxykl.com 美国 wrote at 2016/10/13 1:31:11 #

In fact no matter if someone doesn't be aware of after that its up to other viewers that they will assist, so here it occurs.  Here is my website; lantai kayu ( jxykl.com - jxykl.com/.../index.php?page=1&id=1084 )

concession 美国 wrote at 2017/1/16 6:29:24 #

I'm really enjoying the design and layout of your site. It's a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme? Fantastic work!

concession 美国 wrote at 2017/1/16 6:29:42 #

It's nearly impossible to find experienced people in this particular topic, but you seem like you know what you're talking about! Thanks

添加评论



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


RecentComments

评论 RSS

Statistics

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