k3调拨单中新增一级菜单及二级菜单

调拨单序时簿单据增加菜单
插入对象运输合同 39为图标的类型
insert into t_MenuToolBar ( FToolID,FName,FCaption,FCaption_CHT,FCaption_EN,FImageName,FToolTip,FToolTip_CHT,FToolTip_EN,FControlType,FVisible,FEnable,FChecked,FShortCut,FCBList,FCBList_CHT,FCBList_EN,FCBStyle,FCBWidth,FIndex,FToolCaption,FToolCaption_CHT,FToolCaption_EN)
values (11001,’TransportContract’,’运输合同’,’运输合同’,’运输合同’,’39’,’运输合同’,’运输合同’,’运输合同’,0,1,1,0,0,”,”,”,0,0,0,’运输合同’,’运输合同’,’运输合同’)
插入对象 运输合同查询 39为图标的类型
insert into t_MenuToolBar ( FToolID,FName,FCaption,FCaption_CHT,FCaption_EN,FImageName,FToolTip,FToolTip_CHT,FToolTip_EN,FControlType,FVisible,FEnable,FChecked,FShortCut,FCBList,FCBList_CHT,FCBList_EN,FCBStyle,FCBWidth,FIndex,FToolCaption,FToolCaption_CHT,FToolCaption_EN)
values (11002,’TransportContractView’,’运输合同查询’,’运输合同查询’,’运输合同查询’,’39’,’运输合同查询’,’运输合同查询’,’运输合同查询’,0,1,1,0,0,”,”,”,0,0,0,’运输合同查询’,’运输合同查询’,’运输合同查询’)
添加一级菜单 FBandID=1及FSubBandID不为空，且大于5，控制是否为1级菜单，FIndex控制位置
insert into t_BandToolMapping (FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
values (82,1,11001,7,199,”,0)
查看调拨单对应的菜单数据
select a.,b. From t_BandToolMapping a left join t_MenuToolBar b on a.ftoolid=b.ftoolid where a.FID in(select FMenuID from ICListTemplate where FBillTemplateID=’41’) and b.FVisible=1 order by FID asc
插入二级菜单到菜单下面 7 代表运输合同 即是上面添加的一级菜单代码， 65为位置FSubBandID必须为0
insert into t_BandToolMapping (FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
values (82,7,11002,0,65,’|jhjt.TransportContractList’,0)
添加到工具条 53 为这个是能出来的，具体情况不明 194为位置
INSERT INTO t_BandToolMapping
(FID, FBandID, FToolID, FSubBandID, FIndex, FComName, FBeginGroup) VALUES(82, 53, 11002, 0, 194, ‘|jhjt.TransportContractList’, 0)
此处设置，将工具条中内容显示出来
Update IclistTemplate set FLogicStr=FLogicStr+ Case When Right(FLogicStr,1)=’|’ then ‘V:TransportContractView’ else ‘|V:TransportContractView’ end
where FID =41 and not FLogicStr like ‘%TransportContractView%’