/*向帮助表里面插入新帮助(参考字典方法)*/
INSERT INTO LSHELP (F_HELP,F_HEBH,F_TITL,F_JSZD,F_NMZD,F_BHZD,F_MCZD,F_ZJM,F_FZXX,F_MXZD,F_BMJG,F_PathZD,F_SUBS,F_WHER,F_XZMX,F_ALLS,F_ColSysDisp,F_ColDisp,F_ColField,F_Filter,F_PSortTable,F_PAGESIZE,F_MXYJ,F_GSPHELP,F_MJZD,F_ClassSetCode,F_OFIELDS,F_OTITLE,F_OtableS,F_OCONDTION,LSHELP_ORDERFIELD,F_TEMPLATE)
VALUES
('KKZDNIAN', -- F_HELP - varchar(60)
'001', -- F_HEBH - varchar(4)
'选择年', -- F_TITL - varchar(60)
'', -- F_JSZD - varchar(40)
'KKZDNIAN_NAME', -- F_NMZD - varchar(40)
'KKZDNIAN_BH', -- F_BHZD - varchar(60)
'KKZDNIAN_NAME', -- F_MCZD - varchar(40)
'', -- F_ZJM - varchar(40)
'', -- F_FZXX - varchar(40)
'', -- F_MXZD - varchar(40)
'', -- F_BMJG - varchar(40)
'', -- F_PathZD - varchar(100)
0, -- F_SUBS - int
'', -- F_WHER - varchar(2000)
0, -- F_XZMX - int
0, -- F_ALLS - int
'', -- F_ColSysDisp - varchar(512)
'', -- F_ColDisp - varchar(1024)
'', -- F_ColField - varchar(256)
'', -- F_Filter - varchar(40)
'', -- F_PSortTable - varchar(30)
20, -- F_PAGESIZE - int
'', -- F_MXYJ - varchar(4)
'', -- F_GSPHELP - varchar(36)
'', -- F_MJZD - varchar(30)
'', -- F_ClassSetCode - varchar(30)
'', -- F_OFIELDS - varchar(255)
'', -- F_OTITLE - varchar(255)
'', -- F_OtableS - varchar(255)
'', -- F_OCONDTION - varchar(255)
'', -- LSHELP_ORDERFIELD - varchar(200)
'' -- F_TEMPLATE - varchar(800)
)
/*创建字典存储表*/
CREATE TABLE KKZDNIAN(
KKZDNIAN_BH VARCHAR(4) NULL DEFAULT ''
,KKZDNIAN_NAME VARCHAR(10) NULL DEFAULT ''
,KKZDNIAN_SYBZ VARCHAR(1) NOT NULL DEFAULT '1'
)
/*手工插入字典值*/
INSERT INTO KKZDNIAN (KKZDNIAN_BH,KKZDNIAN_NAME,KKZDNIAN_SYBZ)
SELECT '2018','2018年','1'
UNION ALL
SELECT '2019','2019年','1'
UNION ALL
SELECT '2020','2020年','1'
UNION ALL
SELECT '2021','2021年','1'
UNION ALL
SELECT '2022','2022年','1'
UNION ALL
SELECT '2023','2023年','1'
UNION ALL
SELECT '2024','2024年','1'
UNION ALL
SELECT '2025','2025年','1'
效果如图: