IP地址程序更新地址

CW9 10.2.12.239
CW2 10.2.12.245
CW6 10.2.12.246


9003d1df22eb4d3820015070385194c8 密码pwd
update bas_userinfo set pwd='9003d1df22eb4d3820015070385194c8'


jdbc:oracle:thin:@10.2.12.246:1521:orcl


\\vabuild\output\TBM\2011-09-05-1030



\\vabuild\output\TBM
新地址：\\gmc\output\TBM


内置模板位置：/tongweb/webroot/tbmjl/tbm/budget/export





由于浙江签报涉及的改动特殊性
拆分出一个新的工程 之后的签报开发基于此工程
工程地址:
http://10.2.12.117/VA/TBM/trunk/src/vise
相应的数据库:
jdbc:oracle:thin:@10.2.12.246:1521:orcl zjsit3 zjsit3
db2库整理后提供
此工程基于new工程最新版本34662 则在34662版本之前发现的共性BUG要在两个工程内同步修改
签报版本的问题只在vise工程内修改

接口配置文件地址：
/tongweb/webroot/tbmjl/WEB-INF/classes/config/properties/biz

吉林供应商地址：
http://10.2.12.239:8008/tbm_service_ctl_jlmc/client.do?action=vendorsrv
配置位置：js\project\special\controller_JLMC.js

--查询成本补录单据报的主键冲突的表
select * from int_reserve_detail group by detail_id having count(1) > 1
select * from int_reserve group by detail_id having count(1) > 1
delete from INT_RESERVE_RESULT
delete from int_reserve_detail
delete from INT_RESERVE



资料库：
http://10.2.12.117/VA/TBM/trunk/doc

10.2.12.246
用户：administrator
密码：Flush


db2 export to tbm_grid_new.ixf of ixf messages tbm_grid_new.log select * from tbm_grid_new
db2move db load -lo replace -u user -p pwd;


imp zjsit8/zjsit8@ORCL file=D:\20120312.dmp grants=n fromuser=zjsit3 touser=zjsit8 >d:\1.txt

接口日志配置文件：
log4j.appender.BudgetControlServceFile.File=/tongweb/TongWeb4.6/interfacelogs/ZJQBinterface.log


select * from INT_ACCRUALUSED_LINE; --计提使用行表

select * from INT_ACCRUAL_CONTROLPOOL where prj_num='10ZH1248'; --计提控制池表

select * from INT_CONTRACT_CONTROLPOOL; --合同控制池表

select * from INT_VISE_CONTROLPOOL where prj_num='10ZH1248'; --签报控制池表

select * from int_budgetcontrolpool a where a.prj_num='10ZH1248' --项目控制池表

浙江替换所有表空间方法：
TABLESPACE "[A-Z0-9]+"
替换为TABLESPACE "你的表空间名" TEST05003
然后将第一个D改成U （DBA换成USER的意思）

插入预算数表：tbm_bgt_pool

















报表集团个性化：


select sum(freeze_amount),sum(reserved_amount-freeze_amount),sum(available_amount),sum(used_amount) from int_budgetcontrolpool where prj_num='0311XN11010315000001'
and CONTRACT_CODE = 'N/A' AND BUDGET_TYPE = 'C' and dateflag between '201101' and '201103'

select * from INT_DOCUMENT where document_num='20101627'
select sum(freeze_amount+reserved_amount),sum(used_amount),sum(available_amount),sum(available_amount) from int_budgetcontrolpool where prj_num='0311XN11010315000001'

select sum(freeze_amount),sum(reserved_amount-freeze_amount),sum(available_amount),sum(used_amount) from int_budgetcontrolpool where prj_num='0311XN11010302000002'



select sum(freeze_amount+reserved_amount),sum(used_amount),sum(available_amount),sum() from int_budgetcontrolpool where prj_num='0311XN11010315000001'

select * from int_budgetcontrolpool where prj_num='0311XN11010315000001'