-- 创建菜单语句 INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('9107', '质控样管理', '', '91', '9107', '021.svg', '质控样管理'); -- 建表语句 CREATE TABLE T_LIMS_SPECIMEN( ID NUMBER NOT NULL, BASEORG VARCHAR2(36) NULL, TESTGROUP VARCHAR2(36) NULL, SPECIMENNAME VARCHAR2(270) NULL, SPECIMENCODE VARCHAR2(270) NULL, HIGHLIMIT NUMBER(16,2) NULL, LOWLIMIT NUMBER(16,2) NULL, ORGID VARCHAR2(60) NULL, ORGNAME VARCHAR2(60) NULL, CREATEDBYID VARCHAR2(36) NULL, CREATEDBYNAME VARCHAR2(60) NULL, CREATEDTIME DATE NULL, CREATEDBYORGID VARCHAR2(36) NULL, CREATEDBYORGNAME VARCHAR2(270) NULL ); COMMENT ON TABLE T_LIMS_SPECIMEN IS '质控样'; COMMENT ON COLUMN T_LIMS_SPECIMEN.ID IS '主键'; COMMENT ON COLUMN T_LIMS_SPECIMEN.BASEORG IS '实验室'; COMMENT ON COLUMN T_LIMS_SPECIMEN.TESTGROUP IS '测试组'; COMMENT ON COLUMN T_LIMS_SPECIMEN.SPECIMENNAME IS '质控样名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN.SPECIMENCODE IS '质控样编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN.HIGHLIMIT IS '上限值'; COMMENT ON COLUMN T_LIMS_SPECIMEN.LOWLIMIT IS '下限值'; COMMENT ON COLUMN T_LIMS_SPECIMEN.ORGID IS '组织ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN.ORGNAME IS '组织名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_SPECIMEN.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN.CREATEDBYORGNAME IS '制单人单位名称'; ALTER TABLE T_LIMS_SPECIMEN ADD CONSTRAINT PK_LIMS_SPECIMEN PRIMARY KEY (ID); CALL INSERTI18N('T_LIMS_SPECIMEN.SERVICE_NAME', '质控样', '质控样', 'zh-CN', '质控样'); CALL INSERTI18N('T_LIMS_SPECIMEN.ID', '质控样的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_SPECIMEN.BASEORG', '质控样的实验室', '实验室', 'zh-CN', '实验室'); CALL INSERTI18N('T_LIMS_SPECIMEN.TESTGROUP', '质控样的测试组', '测试组', 'zh-CN', '测试组'); CALL INSERTI18N('T_LIMS_SPECIMEN.SPECIMENNAME', '质控样的质控样名称', '质控样名称', 'zh-CN', '质控样名称'); CALL INSERTI18N('T_LIMS_SPECIMEN.SPECIMENCODE', '质控样的质控样编码', '质控样编码', 'zh-CN', '质控样编码'); CALL INSERTI18N('T_LIMS_SPECIMEN.HIGHLIMIT', '质控样的上限值', '上限值', 'zh-CN', '上限值'); CALL INSERTI18N('T_LIMS_SPECIMEN.LOWLIMIT', '质控样的下限值', '下限值', 'zh-CN', '下限值'); CALL INSERTI18N('T_LIMS_SPECIMEN.ORGID', '质控样的组织ID', '组织ID', 'zh-CN', '组织ID'); CALL INSERTI18N('T_LIMS_SPECIMEN.ORGNAME', '质控样的组织名称', '组织名称', 'zh-CN', '组织名称'); CALL INSERTI18N('T_LIMS_SPECIMEN.CREATEDBYID', '质控样的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_SPECIMEN.CREATEDBYNAME', '质控样的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_SPECIMEN.CREATEDTIME', '质控样的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_SPECIMEN.CREATEDBYORGID', '质控样的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_SPECIMEN.CREATEDBYORGNAME', '质控样的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYSAMPLES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYSAMPLES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYSAMPLES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYSAMPLES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYSAMPLES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); -- 创建菜单语句 INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('910701', '质控样管理', '/secure/basemodule/trm/qualitycontrol/specimens/page/edit-list', '9107', '910701', '060.svg', '质控样管理'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_SPECIMEN', '0', '0'); COMMIT; -- 建表语句 CREATE TABLE T_LIMS_SPECIMEN_ITEM( ID NUMBER NOT NULL, SPECIMENID NUMBER NULL, TESTMETHODID NUMBER NULL, TESTID NUMBER NULL, TESTNAME VARCHAR2(270) NULL, TESTCODE VARCHAR2(270) NULL, METHODID NUMBER NULL, ORGID VARCHAR2(60) NULL, ORGNAME VARCHAR2(60) NULL, CREATEDBYID VARCHAR2(36) NULL, CREATEDBYNAME VARCHAR2(60) NULL, CREATEDTIME DATE NULL, CREATEDBYORGID VARCHAR2(36) NULL, CREATEDBYORGNAME VARCHAR2(270) NULL ); COMMENT ON TABLE T_LIMS_SPECIMEN_ITEM IS '质控样配置'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.ID IS '主键'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.SPECIMENID IS '质控样ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.TESTMETHODID IS '项目方法ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.TESTID IS '项目ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.TESTNAME IS '项目名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.TESTCODE IS '项目编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.METHODID IS '方法ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.ORGID IS '组织ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.ORGNAME IS '组织名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN_ITEM.CREATEDBYORGNAME IS '制单人单位名称'; ALTER TABLE T_LIMS_SPECIMEN_ITEM ADD CONSTRAINT PK_LIMS_SPECIMEN_ITEM PRIMARY KEY (ID); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.SERVICE_NAME', '质控样配置', '质控样配置', 'zh-CN', '质控样配置'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.ID', '质控样配置的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.SPECIMENID', '质控样配置的质控样ID', '质控样ID', 'zh-CN', '质控样ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.TESTMETHODID', '质控样配置的项目方法ID', '项目方法ID', 'zh-CN', '项目方法ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.TESTID', '质控样配置的项目ID', '项目ID', 'zh-CN', '项目ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.TESTNAME', '质控样配置的项目名称', '项目名称', 'zh-CN', '项目名称'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.TESTCODE', '质控样配置的项目编码', '项目编码', 'zh-CN', '项目编码'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.METHODID', '质控样配置的方法ID', '方法ID', 'zh-CN', '方法ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.ORGID', '质控样配置的组织ID', '组织ID', 'zh-CN', '组织ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.ORGNAME', '质控样配置的组织名称', '组织名称', 'zh-CN', '组织名称'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.CREATEDBYID', '质控样配置的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.CREATEDBYNAME', '质控样配置的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.CREATEDTIME', '质控样配置的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.CREATEDBYORGID', '质控样配置的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_SPECIMEN_ITEM.CREATEDBYORGNAME', '质控样配置的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_SPECIMEN_ITEM', '0', '0'); COMMIT; -- 建表语句 CREATE TABLE T_LIMS_SPECIMEN_EQUIPMENT( ID NUMBER NOT NULL, SPECIMENITEMID NUMBER NULL, EQUIPTID NUMBER NULL, EQUIPTNAME VARCHAR2(270) NULL, EQUIPTCODE VARCHAR2(270) NULL, FREQUENCY VARCHAR2(36) NULL, HIGHLIMIT NUMBER(16,2) NULL, LOWLIMIT NUMBER(16,2) NULL, ORGID VARCHAR2(60) NULL, ORGNAME VARCHAR2(60) NULL, CREATEDBYID VARCHAR2(36) NULL, CREATEDBYNAME VARCHAR2(60) NULL, CREATEDTIME DATE NULL, CREATEDBYORGID VARCHAR2(36) NULL, CREATEDBYORGNAME VARCHAR2(270) NULL ); COMMENT ON TABLE T_LIMS_SPECIMEN_EQUIPMENT IS '质控样设备'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.ID IS '主键'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.SPECIMENITEMID IS '质控样项目ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.EQUIPTID IS '设备ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.EQUIPTNAME IS '设备名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.EQUIPTCODE IS '设备编号'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.FREQUENCY IS '频率'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.HIGHLIMIT IS '上限值'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.LOWLIMIT IS '下限值'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.ORGID IS '组ID'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.ORGNAME IS '组名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYORGNAME IS '制单人单位名称'; ALTER TABLE T_LIMS_SPECIMEN_EQUIPMENT ADD CONSTRAINT PK_LIMS_SPECIMEN_EQUIPMENT PRIMARY KEY (ID); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.SERVICE_NAME', '质控样设备', '质控样设备', 'zh-CN', '质控样设备'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.ID', '质控样设备的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.SPECIMENITEMID', '质控样设备的质控样项目ID', '质控样项目ID', 'zh-CN', '质控样项目ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.EQUIPTID', '质控样设备的设备ID', '设备ID', 'zh-CN', '设备ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.EQUIPTNAME', '质控样设备的设备名称', '设备名称', 'zh-CN', '设备名称'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.EQUIPTCODE', '质控样设备的设备编号', '设备编号', 'zh-CN', '设备编号'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.FREQUENCY', '质控样设备的频率', '频率', 'zh-CN', '频率'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.HIGHLIMIT', '质控样设备的上限值', '上限值', 'zh-CN', '上限值'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.LOWLIMIT', '质控样设备的下限值', '下限值', 'zh-CN', '下限值'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.ORGID', '质控样设备的组ID', '组ID', 'zh-CN', '组ID'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.ORGNAME', '质控样设备的组名称', '组名称', 'zh-CN', '组名称'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYID', '质控样设备的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYNAME', '质控样设备的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.CREATEDTIME', '质控样设备的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYORGID', '质控样设备的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_SPECIMEN_EQUIPMENT.CREATEDBYORGNAME', '质控样设备的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILEQUIPMENTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILEQUIPMENTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILEQUIPMENTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILEQUIPMENTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.TRM.QUALITYCONTROL.QUALITYDETAILEQUIPMENTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_SPECIMEN_EQUIPMENT', '0', '0'); COMMIT; INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES ('frequencyType','频率类型','biz',NULL,25,NULL,NULL,NULL,NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714101,'3次/天','frequencyType',NULL,1,0,'0',NULL,NULL,NULL,'3time/day','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714102,'2次/天','frequencyType',NULL,2,0,'0',NULL,NULL,NULL,'2time/day','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714103,'1次/天','frequencyType',NULL,3,0,'0',NULL,NULL,NULL,'1time/day','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714104,'1次/周','frequencyType',NULL,4,0,'0',NULL,NULL,NULL,'1time/week','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714105,'1次/月','frequencyType',NULL,5,0,'0',NULL,NULL,NULL,'1time/month','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714106,'2次/月','frequencyType',NULL,6,0,'0',NULL,NULL,NULL,'2time/month','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714107,'3次/月','frequencyType',NULL,7,0,'0',NULL,NULL,NULL,'3time/month','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714108,'1次/季度','frequencyType',NULL,8,0,'0',NULL,NULL,NULL,'1time/quarter','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092714109,'1次/半年','frequencyType',NULL,9,0,'0',NULL,NULL,NULL,'1time/halfYear','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (20220927141010,'1次/年','frequencyType',NULL,10,0,'0',NULL,NULL,NULL,'1time/year','admin','系统管理员',NULL); INSERT INTO t_core_admin_choose_config (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES (2022092014001,'质控样信息','质控样信息','specimensChoose','/secure/basemodule/trm/qualitycontrol/specimens/page/choose-list','80%'); INSERT INTO t_core_admin_choose_config (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES (2022092018301,'质控样项目信息','质控样项目信息','specimensTestMethodChoose','/secure/basemodule/trm/qualitycontrol/specimen-items/page/choose-list','80%'); INSERT INTO t_core_admin_choose_config (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES (2022092619191,'质控样项目设备信息','质控样项目设备信息','specimensTestEquipmentChoose','/secure/basemodule/trm/qualitycontrol/specimen-equipments/page/choose-list','80%');