K3自定义sql报表字段显示标题

 

DELETE FROM ICListTemplate WHERE FID=70001;
DELETE FROM ICChatBillTitle WHERE FTypeID = 70001;
DELETE FROM t_ObjectAccessType WHERE FObjectType=4100 AND FObjectID =70001;
DELETE FROM t_ObjectType WHERE FObjectType=4100 AND FObjectID =70001;
DELETE FROM t_ObjectAccess WHERE FObjectType=4100 AND FObjectID =70001;
 

关键是

select * from [ICChatBillTitle] ---这是标题
select * FROM ICListTemplate

 

连接查询

select u.FName,t.* from [ICChatBillTitle] t ---这是标题
inner join ICListTemplate u on t.FTypeID=u.FID and u.FName like '%合同%'
 

更新显示字段

select u.FName,t.* from AIS20090905160608.dbo.ICChatBillTitle t ---这是标题
inner join AIS20090905160608.dbo.ICListTemplate u on t.FTypeID=u.FID and u.FName like '%合同%'

 

update t
set t.FColCaption=u1.FColCaption,
t.FColCaption_CHT=u1.FColCaption,
t.FColCaption_EN=u1.FColCaption

from AIS20090905160608.dbo.ICChatBillTitle t ---这是标题
inner join AIS20090905160608.dbo.ICListTemplate u on t.FTypeID=u.FID and t.FTypeID in (70001)
left join AIS20090905162212.dbo.ICChatBillTitle u1 on t.FColName=u1.FColName and u1.FTypeID='70000' ----合同执行表70000

 

update t
set t.FColCaption=u1.FColCaption,
t.FColCaption_CHT=u1.FColCaption,
t.FColCaption_EN=u1.FColCaption
from AIS20090905160608.dbo.ICChatBillTitle t ---这是标题
inner join AIS20090905160608.dbo.ICListTemplate u on t.FTypeID=u.FID and t.FTypeID in (70002)
left join AIS20090905162212.dbo.ICChatBillTitle u1 on t.FColName=u1.FColName and u1.FTypeID='70003' ----合同执行阶段70003