技术区 › 用友政务 › U8R10-B、C版修改账套号的脚本

3755163@qq.com 发表于 2013-2-7 08:59:47

U8R10-B、C版修改账套号的脚本

-- 适用于U8R10的B、C版(账务、报表、出纳、资产、工资)：
declare @gsdm varchar(20),@zth varchar(20),@oldGSDM VARCHAR(20),@oldZTH varchar(20)
set @oldGSDM='01'    --原单位代码
set @oldZTH ='01'    --原账套号
set @gsdm   ='001'   --新单位代码
set @zth    ='00101' --新账套号
------------------------------------------------------------------------------
-- select * from anyisys..anyigl where zth=@oldZTH
update anyisys..anyigl set zth=@zth ,dwdm=@gsdm where zth=@oldZTH
-- select * from PubModSetupwhere gsdm<>'99999999999999999999'
update pubmodsetup set gsdm=@gsdm where gsdm<>'99999999999999999999'
-- select * from pubyearhandle   where gsdm<>'99999999999999999999' and modname<>'BA'
-- select * from pubyearhandle   where gsdm<>'99999999999999999999' and modname='BA'
update pubyearhandle set gsdm=@gsdm,modname=substring(modname,1,2)+@zth where gsdm<>'99999999999999999999' and modname<>'BA'
update pubyearhandle set gsdm=@gsdmwhere gsdm<>'99999999999999999999' and modname='BA'
-- select * from GL_Pzml
update gl_pzml set gsdm=@gsdm,zth=@zth
-- select * from GL_Pznr
update gl_pznr set gsdm=@gsdm,zth=@zth
-- select * from GL_Pzflmx
update gl_pzflmx set gsdm=@gsdm,zth=@zth
-- select * from GL_Yeb
update gl_yeb set gsdm=@gsdm,zth=@zth
-- select * from GL_Yebk
update gl_yebk set gsdm=@gsdm,zth=@zth
-- select * from GL_Ztcs where hsdwdm<>'99999999999999999999'
-- select * from GL_Ztcs where hsdwdm<>'99999999999999999999' and ztbh<>'99999999999999999999'
update gl_ztcs set hsdwdm=@gsdm where hsdwdm<>'99999999999999999999'
update gl_ztcs set ztbh=@zth    where hsdwdm<>'99999999999999999999' and ztbh<>'99999999999999999999'
-- select * from PubKjqj
update pubkjqj set gsdm=@gsdm,zth=@zth
-- select * from GL_KMXZLX where gsdm<>'99999999999999999999'
-- select * from GL_KMXZLX where gsdm='99999999999999999999'
update gl_kmxzlx set gsdm=@gsdm,zth=@zth where gsdm<>'99999999999999999999'
-- select * from GL_KMxx
update gl_kmxx set gsdm=@gsdm,zth=@zth
--select * from GL_FZXLB where gsdm<>'99999999999999999999'
--select * from GL_FZXLB where gsdm='99999999999999999999'
update gl_fzxlb set gsdm=@gsdm where gsdm<>'99999999999999999999'
-- select * from gl_fzxzl where gsdm<>'99999999999999999999'
update gl_fzxzl set gsdm=@gsdm where gsdm<>'99999999999999999999'
-- select * from gl_xmzl
update gl_xmzl set gsdm=@gsdm
-- select * from pubkszl
update pubkszl set gsdm=@gsdm

-- select * from pubgszl
update pubgszl set gsdm=@gsdm
-- select * from gl_pzzy
update gl_pzzy set gsdm=@gsdm,zth=@zth
-- select * from GL_ZDFL   
update gl_zdfl setgsdm=@gsdm,zth=@zth
-- select * from GL_ZDFLmx
update gl_zdflmx set gsdm=@gsdm,zth=@zth
-- select * from gl_pzlx where gsdm<>'99999999999999999999'
update gl_pzlx set gsdm=@gsdm,zth=@zthwhere gsdm<>'99999999999999999999'
-- select * from gl_bz
update gl_bz set gsdm=@gsdm,zth=@zth
-- select * from gl_bzdmx
update gl_bz set gsdm=@gsdm
-- select * from gl_dlzgsml
update gl_dlzgsml set gsdm=@gsdm,zth=@zth
-- select * from gl_dlzgsnr
update gl_dlzgsnr set gsdm=@gsdm,zth=@zth
-- select * from gl_hskm
update gl_hskm set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_JZMBML
update GL_JZMBML set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_JZMBnr
update GL_JZMBnr set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_NotePZLog
update GL_NotePZLog set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_PZFJ
update GL_PZFJ set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_wlkm
update GL_wlkm set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_wlyw
update GL_wlyw set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_xmkm
update GL_xmkm set gsdm=@gsdm,zth=@zth
-- select * from dbo.GL_Yhdzd
update GL_Yhdzd set gsdm=@gsdm,zth=@zth
-------------------报表-----------------------------------------
-- select * from Rpt_Report where gsdm<>'99999999999999999999'
update Rpt_Report set gsdm=@gsdm,zth=@zth where gsdm<>'99999999999999999999'
-- select * from Rpt_Units_Relations
update Rpt_Units_Relationsset gsdm=@gsdm,zth=@zth
--------------------------------------------------------------------
-- select * from pubbmxx
update pubbmxx set gsdm=@gsdm
-- select * from pubzjxz
update pubzjxz set gsdm=@gsdm
-- select * from zb_jsfs
update zb_jsfs set gsdm=@gsdm
-- select * from zb_yhzl
update zb_yhzl set gsdm=@gsdm
-- select * from zb_DWYEZJLY where gsdm<>'99999999999999999999'
update zb_DWYEZJLY set gsdm=@gsdmwhere gsdm<>'99999999999999999999'
-- select * from gl_xjllxm where gsdm<>'99999999999999999999'
update gl_xjllxm set gsdm=@gsdm where gsdm<>'99999999999999999999'
-- select * from gl_czy where gsdm=@oldGSDM
UPDATE gl_czy set gsdm=@gsdm where gsdm=@oldGSDM
-------------------出纳模块--------------------------------------------------
-- select * from dbo.CM_ztcs      where gsdm<>'99999999999999999999'
update CM_bsqk set gsdm=@gsdm
update CM_BYJJHK set gsdm=@gsdm
updatecm_CDHP set gsdm=@gsdm
updateCM_FKzp set gsdm=@gsdm
update CM_Fzyeset gsdm=@gsdm
updateCM_hdJS set gsdm=@gsdm
updateCM_JSFS set gsdm=@gsdm
updateCM_jxqk set gsdm=@gsdm
updateCM_kjqj set gsdm=@gsdm where gsdm<>'99999999999999999999'
updatecm_kmye set gsdm=@gsdm
updatecm_kmyek set gsdm=@gsdm
updateCM_Pzmlset gsdm=@gsdm
updateCM_Pznr set gsdm=@gsdm
updateCM_SFKXMset gsdm=@gsdm
update   CM_SFPD set gsdm=@gsdm
updateCM_SFPD_BK set gsdm=@gsdm
updateCM_skzpset gsdm=@gsdm
update   CM_XJDZd set gsdm=@gsdm
update   dbo.CM_xjdzqkb set gsdm=@gsdm
update   dbo.CM_XJPDB set gsdm=@gsdm
updatedbo.CM_xjpdbgbset gsdm=@gsdm
update dbo.CM_xjpddset gsdm=@gsdm
update dbo.CM_XJRJZset gsdm=@gsdm
update dbo.CM_YETJBset gsdm=@gsdm
update dbo.CM_yhbpset gsdm=@gsdm
update dbo.CM_Yhdzdset gsdm=@gsdm
update dbo.cm_yhhp   set gsdm=@gsdm
updatedbo.cm_yhhp set gsdm=@gsdm
updatedbo.cm_yhhp set gsdm=@gsdm
update dbo.CM_YHRJZset gsdm=@gsdm
updatedbo.Cm_YHZH set gsdm=@gsdm
update dbo.CM_YHZLset gsdm=@gsdm
update dbo.CM_YJZQset gsdm=@gsdm
updatedbo.CM_zpgz set gsdm=@gsdm
updatedbo.CM_ZTCS set gsdm=@gsdm,ztbh=@zthwhere gsdm<>'99999999999999999999'
-------------------资产模块--------------------------------------------------:
-- select * from FA_Kpjg      where gsdm<>'99999999999999999999'
updatefa_bdd set gsdm=@gsdm
updateFA_BDSQB set gsdm=@gsdm
updateFA_BDSQMXB set gsdm=@gsdm
update   dbo.FA_Bmzjset gsdm=@gsdm
update   FA_CFDD   set gsdm=@gsdm
update   dbo.Fa_CodeListset gsdm=@gsdm where gsdm<>'99999999999999999999'
update   dbo.Fa_Codetypeset gsdm=@gsdm where gsdm<>'99999999999999999999'
update   dbo.FA_Fssbset gsdm=@gsdm
update   dbo.FA_Gdlbset gsdm=@gsdm where gsdm<>'99999999999999999999'
update   dbo.FA_Gzlset gsdm=@gsdm
update   dbo.FA_GZSQBset gsdm=@gsdm
updatedbo.FA_GZSQMXB   set gsdm=@gsdm
update   dbo.FA_GZYSBset gsdm=@gsdm
update   dbo.FA_Kpset gsdm=@gsdm
update   dbo.fa_kpallbdset gsdm=@gsdm
updatedbo.FA_Kpbak   set gsdm=@gsdm
update   dbo.fa_kpcfFssbset gsdm=@gsdm
update   dbo.Fa_KPDBMset gsdm=@gsdm
updatedbo.fa_kpcf   set gsdm=@gsdm
updatedbo.Fa_KPDBM_KPADD   set gsdm=@gsdm
updatedbo.Fa_KPDBM_KPADD_BDQ   set gsdm=@gsdm
update   dbo.Fa_KPDBM_MLset gsdm=@gsdm
updatedbo.FA_KPGYS   set gsdm=@gsdm
updatedbo.Fa_KpImage   set gsdm=@gsdm
updatedbo.FA_Kpjg   set gsdm=@gsdm where gsdm<>'99999999999999999999'
updatedbo.FA_KPMONTH   set gsdm=@gsdm
update   dbo.Fa_KPZJLYset gsdm=@gsdm
update   dbo.Fa_KPZJLY_KPADDset gsdm=@gsdm
update   dbo.FA_KPZJLY_KPADD_BDQset gsdm=@gsdm
update   dbo.FA_MBDYGXset gsdm=@gsdm
update   dbo.FA_Pzset gsdm=@gsdm
update   dbo.FA_PZMBMLset gsdm=@gsdm
update   dbo.FA_PZMBNRset gsdm=@gsdm
updatedbo.FA_rq   set gsdm=@gsdm where gsdm<>'99999999999999999999'
updatedbo.FA_Shflow   set gsdm=@gsdmwhere gsdm<>'99999999999999999999'
update   dbo.FA_SQFJBset gsdm=@gsdm
update   dbo.FA_SYset gsdm=@gsdm
update   dbo.FA_Syzkset gsdm=@gsdm where gsdm<>'99999999999999999999'
update    dbo.FA_TXMXX set gsdm=@gsdm
updatedbo.FA_Ys   set gsdm=@gsdmwhere gsdm<>'99999999999999999999'
update   dbo.FA_Yslbset gsdm=@gsdm where gsdm<>'99999999999999999999'
update   dbo.FA_Ysoutset gsdm=@gsdm
update   dbo.FA_ZCCZBset gsdm=@gsdm
update   dbo.FA_ZCCZCJBset gsdm=@gsdm
update   dbo.FA_ZCCZCJMXBset gsdm=@gsdm
update   dbo.FA_ZCCZMXBset gsdm=@gsdm
update   dbo.FA_ZCDBBset gsdm=@gsdm
update    dbo.FA_ZCDBMXB set gsdm=@gsdm
updatedbo.FA_ZCPD   set gsdm=@gsdm
update   dbo.FA_ZCPDJGset gsdm=@gsdm
update   dbo.FA_ZCPGBset gsdm=@gsdm
update   dbo.FA_ZCPGMXDset gsdm=@gsdm
update   dbo.FA_ZCSYBset gsdm=@gsdm
update   dbo.FA_ZCSYMXBset gsdm=@gsdm
update   dbo.FA_ZCTJBset gsdm=@gsdm
update   dbo.FA_ZCTJMXBset gsdm=@gsdm
update   dbo.FA_Zjffset gsdm=@gsdm where gsdm<>'99999999999999999999'
update    dbo.FA_Zjfp set gsdm=@gsdm
update   dbo.FA_Zjfsset gsdm=@gsdm where gsdm<>'99999999999999999999'
update   dbo.FA_Ztcsset gsdm=@gsdm,ztbh=@zthwhere gsdm<>'99999999999999999999'
-------------------工资模块--------------------------------------------------:
-- select *fromGZ_Gzlb            where gsdm<>'99999999999999999999'
updatedbo.GZ_BFGZ set gsdm=@gsdm
update   dbo.GZ_BMGZXMSZset gsdm=@gsdm
update   dbo.GZ_BMZYLXGZXKMModelset gsdm=@gsdm
updatedbo.GZ_DWSWJ   set gsdm=@gsdm
update   dbo.gz_dygxset gsdm=@gsdm
updatedbo.GZ_Ftlx   set gsdm=@gsdmwhere gsdm<>'99999999999999999999'
update   dbo.GZ_Ftlx_pzset gsdm=@gsdm
updatedbo.GZ_GKPZMBML   set gsdm=@gsdm
updatedbo.GZ_GKPZMBNR   set gsdm=@gsdm
updatedbo.GZ_Grsds   set gsdm=@gsdmwhere gsdm<>'99999999999999999999'
update   dbo.GZ_Gsnameset gsdm=@gsdm
update   dbo.GZ_Gzset gsdm=@gsdm
update   dbo.GZ_Gz_TFBAKset gsdm=@gsdm
updatedbo.GZ_GZFFHZB_FA   set gsdm=@gsdm
updatedbo.GZ_Gzft   set gsdm=@gsdm
updatedbo.GZ_Gzlb   set gsdm=@gsdm where gsdm<>'99999999999999999999'
updatedbo.GZ_GzSH   set gsdm=@gsdm
update   dbo.GZ_GZTFPZSCset gsdm=@gsdm
updatedbo.GZ_Month   set gsdm=@gsdm
update   dbo.Gz_SdsCycleset gsdm=@gsdm
updatedbo.GZ_SHBZ   set gsdm=@gsdm
updatedbo.GZ_SHJG1   set gsdm=@gsdm
update   dbo.GZ_SHJG2set gsdm=@gsdm
update   dbo.GZ_SHJG3set gsdm=@gsdm
updatedbo.GZ_T_GZ   set gsdm=@gsdm
updatedbo.GZ_XMZCFL   set gsdm=@gsdm
update   dbo.GZ_Yhset gsdm=@gsdm
update   dbo.GZ_Yhdataset gsdm=@gsdm
update   dbo.GZ_Ysgzxset gsdm=@gsdmwhere gsdm<>'99999999999999999999'
updatedbo.GZ_ZBJKSJ   set gsdm=@gsdm
updatedbo.GZ_Zdyzbs   set gsdm=@gsdm
update   dbo.GZ_ZdyzbXXset gsdm=@gsdm
update   dbo.GZ_Ztcsset gsdm=@gsdm,ztbh=@zth where gsdm<>'99999999999999999999'
updatedbo.GZ_Zylx   set gsdm=@gsdm
update   dbo.GZ_Zyxxset gsdm=@gsdm
update   dbo.GZ_Zyxxbdset gsdm=@gsdmwhere gsdm<>'99999999999999999999'
-----------------------------------------------------------------------------
-- By 王明利 2013.02.04

cjpxxx 发表于 2013-4-8 17:24:39

{:soso_e179:}，不过用友政务对这个做的太差，竟然要修改帐套才能进入

蓝色液滴乄 发表于 2013-4-26 08:47:26

本帖最后由 蓝色液滴乄 于 2013-4-26 09:08 编辑

楼主威武，正需要呢

我的行政事业C版执行时找不到两张表，其他没有问题，谢谢LZ
update   dbo.fa_kpcfFssbset gsdm=@gsdm
update   dbo.fa_kpcfset gsdm=@gsdm

二次就业 发表于 2013-9-12 17:40:58

厉害，，楼主威武，，做个MARK,现在还不知道怎么用。

a_minggrace 发表于 2013-12-27 20:22:14

真的是个好东西，谢谢！

zy_wcs 发表于 2014-4-13 20:59:03

非常好的东西感谢楼主！

zy_wcs 发表于 2014-4-13 21:03:15

非常好的东西感谢楼主！

yatou123 发表于 2020-11-23 17:07:58

账套参数没有获取成功，有办法解决吗？

金蝶用友金算盘 发表于 2022-8-11 16:00:37

yatou123 发表于 2020-11-23 17:07
账套参数没有获取成功，有办法解决吗？

建议使用Navicat工具，查找Ztcs，其中有几个表楼主的脚本没有包含，需要在修改下才行

查看完整版本: U8R10-B、C版修改账套号的脚本