上线初始化数据部分

一、调整项目到管理区

SELECT * FROM dbo.Tb_Sys_Organ WHERE OrganName LIKE '%金马%'

SELECT OrganCode,* FROM dbo.Tb_HSPR_Community WHERE CommName LIKE '%西岸%'

UPDATE Tb_HSPR_Community SET OrganCode='010403' WHERE CommID=100051

二、清除工作通知

select * from Tb_Common_CommonInfo --工作通知

select * from Tb_Common_CommunityService --项目快报

三、配置tb_system_burst

INSERT INTO pms_bs..Tb_System_Burst

(

Id,

CorpID,

CommID,

DataBaseIp,

DataBaseUser,

DataBasePwd,

DataBasePort,

DataBaseName,

DataBaseIp_Read,

DataBaseUser_Read,

DataBasePwd_Read,

DataBasePort_Read,

DataBaseName_Read,

BurstType,

DBPhysicsAddress

)SELECT NEWID(),CorpID,'100073',DataBaseIp,DataBaseUser,DataBasePwd,DataBasePort,'PMS_Charge_100073',DataBaseIp_Read,DataBaseUser_Read,DataBasePwd_Read,DataBasePort_Read,'PMS_Charge_100073' DataBaseName_Read

,BurstType,DBPhysicsAddress

FROM pms_bs..Tb_System_Burst WHERE Id='412FD464-9FAB-4B73-9D3B-1C6B2A19FD13'

1、财务收据调整

后台运营管理系统部署后：吧老系统的tw_bs库中的 tb_system_powernode 迁移到新系统

找到原模板，后台系统进行模板绑定。

http://101.200.76.65/tw/backmanage/indexmain.aspx

Receive_Receipt_ListAllNew.et

账号 admin 99819981

SELECT * FROM dbo.Tb_System_UseRep2 WHERE CommID=100042 --10000004189

SELECT TOP 10 UseRepID,* FROM PMS_Charge_100042..Tb_HSPR_FeesReceipts

UPDATE PMS_Charge_100042..Tb_HSPR_FeesReceipts SET UseRepID='10000004189' WHERE CommID=100042

2、预收票据