金蝶老單據(jù)序時(shí)簿上增加一個(gè)按鈕再調(diào)用插件在數(shù)據(jù)庫(kù)中的配置關(guān)聯(lián)（SQL）采購(gòu)單VB插件 2010-07-30 09:06:46 閱讀108 評(píng)論0   字號(hào)：大中小 訂閱
 

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 = '采購(gòu)訂單'
--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','歷史采購(gòu)價(jià)格查詢','歷史采購(gòu)價(jià)格查詢','歷史采購(gòu)價(jià)格查詢','51','歷史采購(gòu)價(jià)格查詢','歷史采購(gòu)價(jià)格查詢','歷史采購(gòu)價(jià)格查詢',0,0,1,0,0,'','','',0,0,0,'歷史采購(gòu)價(jià)格查詢','歷史采購(gòu)價(jià)格查詢','歷史采購(gòu)價(jià)格查詢')

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

這個(gè)是杭州分公司的二次開發(fā)人員楊工的例子（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','出庫(kù)','出庫(kù)','出庫(kù)','39','出庫(kù)','','出庫(kù)',0,1,1,0,0,'','','',0,0,0,'出庫(kù)','出庫(kù)','出庫(kù)')
--FID 對(duì)應(yīng)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
楊堅(jiān)勝（杭分二次 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)
 這個(gè)是序時(shí)簿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','出庫(kù)','出庫(kù)','出庫(kù)','39','出庫(kù)','','出

庫(kù)',0,1,1,0,0,'','','',0,0,0,'出庫(kù)','出庫(kù)','出庫(kù)')

--FID 對(duì)應(yīng)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)

 

金蝶開發(fā)數(shù)據(jù)庫(kù)中部分表的含義

dbo.ICTemplateEntry，序時(shí)簿的過濾條件表（根據(jù)條件查詢的查詢數(shù)據(jù)的，專門處理這些條件的數(shù)據(jù)表）

dbo.ICListTemplate，單據(jù)信息表（主要是k3中單據(jù)的信息）