金蝶老单据序时簿上增加一个按钮再调用插件在数据库中的配置关联

金蝶老单据序时簿上增加一个按钮再调用插件在数据库中的配置关联（SQL）采购单VB插件 2010-07-30 09:06:46 阅读108 评论0   字号：大中小 订阅
 

select * from V_tools where FbandId=18 and FtoolId=10005

select * from v_tools where ftoolid=888

 

 

select * from t_menuToolBar where FName like'%FMenuPC4%'

select fid,Fmenuid from iclisttemplate where FName = '采购订单'
--select * from t_MenuToolBar where FImageName =51 or FToolID=10005 or Fname= 'FMenuPC4'
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 (10005,'FMenuPC4','历史采购价格查询','历史采购价格查询','历史采购价格查询','51','历史采购价格查询','历史采购价格查询','历史采购价格查询',0,0,1,0,0,'','','',0,0,0,'历史采购价格查询','历史采购价格查询','历史采购价格查询')

select * from t_BandToolMapping where fid=81 and FToolID=666 and FBandID=52

update t_BandToolMapping set  FToolID=888 where fid=81  and FBandID=52

insert into t_BandToolMapping (FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
values (81,52,10005,0,65,'|Dev_QueryPrice_InList.QueryPrice',0)

select * from t_BandToolMapping where fid=81  and FBandID=18

update t_BandToolMapping set FToolID=888 where  fid=81  and FBandID=18

insert into t_BandToolMapping (FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
values (81,18,10005,0,65,'|Dev_QueryPrice_InList.QueryPrice',0)

Update IclistTemplate
set FLogicStr=FLogicStr+ Case When Right(FLogicStr,1)='|' then 'V:FMenuPC4' else '|V:FMenuPC4' end
where FID =26 and not FLogicStr like '%FMenuPC4%'

select * from t_menutoolbar where FToolID=666

select * from t_MenuToolBar where   FName='FMenuPC4'

update t_MenuToolBar set  FToolID=888 where FName='FMenuPC4'

delete from t_MenuToolBar where  FToolID=10005 and FName='FMenuPC4'

select * from t_BandToolMapping where FID=81 and FToolID=10005 and FBandID=18

delete From t_BandToolMapping where FID=81 and FToolID=10005 and FBandID=52

这个是杭州分公司的二次开发人员杨工的例子（V12.0）而且是好用的

delete  from t_MenuToolBar where FToolID = 9999
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 (9999,'ZWGBOS','出库','出库','出库','39','出库','','出库',0,1,1,0,0,'','','',0,0,0,'出库','出库','出库')
--FID 对应t_ICTemplateList FMenuID
--加入菜单中,
Delete From t_BandToolMapping where FBandID=3 and FToolID = 9999 and FID = 82
insert into t_BandToolMapping (FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
values (82,3,9999,0,120
杨坚胜（杭分二次 20:36:43
 ,'|ZWGBOS.clsMakeOut',0)
--加入工具条中
-- Delete From t_BandToolMapping where FBandID=48 and FToolID = 9999 and FID = 82
-- insert into t_BandToolMapping (FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
-- values (82,48,9999,0,5 ,'|ZWGBOS.clsMakeOut',0)
 这个是序时簿sql语句的一些解释

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,FCBStyl

e,FCBWidth,FIndex,FToolCaption,FToolCaption_CHT,FToolCaption_EN)
values (9999,'ZWGBOS','出库','出库','出库','39','出库','','出

库',0,1,1,0,0,'','','',0,0,0,'出库','出库','出库')

--FID 对应dbo.ICListTemplate FMenuID
--加入菜单中,
Delete From t_BandToolMapping where FBandID=3 and FToolID = 9999 and FID = 82
insert into t_BandToolMapping (FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
values (82,3,9999,0,120 ,'|ZWGBOS.clsMakeOut',0)
--加入工具条中
-- Delete From t_BandToolMapping where FBandID=48 and FToolID = 9999 and FID = 82
 insert into t_BandToolMapping

(FID,FBandID,FToolID,FSubBandID,FIndex,FComName,FBeginGroup)
  values (82,48,9999,0,5 ,'|ZWGBOS.clsMakeOut',0)

 

金蝶开发数据库中部分表的含义

dbo.ICTemplateEntry，序时簿的过滤条件表（根据条件查询的查询数据的，专门处理这些条件的数据表）

dbo.ICListTemplate，单据信息表（主要是k3中单据的信息）