-- 创建菜单语句 INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('9105', '预处理管理', '', '91', '9105', '021.svg', '预处理管理'); -- ----------------------------- 2022-09-15 add by dingj--------------begin -- 建表语句 CREATE TABLE T_LIMS_PRETREAT_INFORMATION( ID NUMBER NOT NULL, SORTER NUMBER NULL, TESTTYPE VARCHAR2(12) NULL, PROCESSNAME VARCHAR2(36) NULL, PROCESSDES VARCHAR2(36) NULL, ELNID NUMBER NULL, ORGID VARCHAR2(36) NULL, ORGNAME VARCHAR2(36) 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_PRETREAT_INFORMATION IS '预处理信息'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.ID IS '主键'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.SORTER IS '序号'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.TESTTYPE IS '测试类型'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.PROCESSNAME IS '工序名称'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.PROCESSDES IS '工序说明'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.ELNID IS '记录表ID'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.ORGID IS 'orgId'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.ORGNAME IS 'orgName'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_PRETREAT_INFORMATION.CREATEDBYORGNAME IS '制单人单位名称'; ALTER TABLE T_LIMS_PRETREAT_INFORMATION ADD CONSTRAINT PK_LIMS_PRETREAT_INFORMATION PRIMARY KEY (ID); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.SERVICE_NAME', '预处理信息', '预处理信息', 'zh-CN', '预处理信息'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.ID', '预处理信息的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.SORTER', '预处理信息的序号', '序号', 'zh-CN', '序号'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.TESTTYPE', '预处理信息的测试类型', '测试类型', 'zh-CN', '测试类型'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.PROCESSNAME', '预处理信息的工序名称', '工序名称', 'zh-CN', '工序名称'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.PROCESSDES', '预处理信息的工序说明', '工序说明', 'zh-CN', '工序说明'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.ELNID', '预处理信息的记录表ID', '记录表ID', 'zh-CN', '记录表ID'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.ORGID', '预处理信息的orgId', 'orgId', 'zh-CN', 'orgId'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.ORGNAME', '预处理信息的orgName', 'orgName', 'zh-CN', 'orgName'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.CREATEDBYID', '预处理信息的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.CREATEDBYNAME', '预处理信息的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.CREATEDTIME', '预处理信息的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.CREATEDBYORGID', '预处理信息的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.CREATEDBYORGNAME', '预处理信息的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATINFORMATIONS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATINFORMATIONS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATINFORMATIONS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATINFORMATIONS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATINFORMATIONS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); -- 创建菜单语句 INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('910501', '预处理信息', '/secure/basemodule/trm/pretreatment/pretreat-informations/page/edit-list', '9105', '910501', '034.svg', '预处理信息'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_PRETREAT_INFORMATION', '0', '0'); COMMIT; -- ----------------------------- 2022-09-15 add by dingj------------end -- ----------------------------- 2022-09-15 add by dingj--------------begin -- 建表语句 CREATE TABLE T_LIMS_PRETREAT_TESTDIRECT( ID NUMBER NOT NULL, TESTTYPE VARCHAR2(12) NULL, TESTDIRECTION VARCHAR2(12) NULL, ORGID VARCHAR2(36) NULL, ORGNAME VARCHAR2(36) 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_PRETREAT_TESTDIRECT IS '测试方向'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.ID IS '主键'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.TESTTYPE IS '测试类型'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.TESTDIRECTION IS '测试方向'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.ORGID IS 'orgId'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.ORGNAME IS 'orgName'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYORGNAME IS '制单人单位名称'; ALTER TABLE T_LIMS_PRETREAT_TESTDIRECT ADD CONSTRAINT PK_LIMS_PRETREAT_TESTDIRECT PRIMARY KEY (ID); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.SERVICE_NAME', '测试方向', '测试方向', 'zh-CN', '测试方向'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.ID', '测试方向的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.TESTTYPE', '测试方向的测试类型', '测试类型', 'zh-CN', '测试类型'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.TESTDIRECTION', '测试方向的测试方向', '测试方向', 'zh-CN', '测试方向'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.ORGID', '测试方向的orgId', 'orgId', 'zh-CN', 'orgId'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.ORGNAME', '测试方向的orgName', 'orgName', 'zh-CN', 'orgName'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYID', '测试方向的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYNAME', '测试方向的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.CREATEDTIME', '测试方向的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYORGID', '测试方向的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTDIRECT.CREATEDBYORGNAME', '测试方向的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.TESTDIRECTIONS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.TESTDIRECTIONS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.TESTDIRECTIONS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.TESTDIRECTIONS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.TESTDIRECTIONS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); -- 创建菜单语句 INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('910502', '测试方向', '/secure/basemodule/trm/pretreatment/pretreat-testdirects/page/edit-list', '9105', '910502', '057.svg', '测试方向'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_PRETREAT_TESTDIRECT', '0', '0'); COMMIT; -- ----------------------------- 2022-09-15 add by dingj------------end -- 建表语句 CREATE TABLE T_LIMS_PRETREAT_TESTPROCESS( ID NUMBER NOT NULL, PROCESSID NUMBER NULL, PROCESSSORTER NUMBER NULL, PROCESSNAME VARCHAR2(12) NULL, ORGID VARCHAR2(36) NULL, ORGNAME VARCHAR2(36) 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_PRETREAT_TESTPROCESS IS '测试方向工序'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.ID IS '主键'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.PROCESSID IS '测试方向ID'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.PROCESSSORTER IS '工序顺序'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.PROCESSNAME IS '工序'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.ORGID IS 'orgId'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.ORGNAME IS 'orgName'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYORGNAME IS '制单人单位名称'; ALTER TABLE T_LIMS_PRETREAT_TESTPROCESS ADD CONSTRAINT PK_LIMS_PRETREAT_TESTPROCESS PRIMARY KEY (ID); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.SERVICE_NAME', '测试方向工序', '测试方向工序', 'zh-CN', '测试方向工序'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.ID', '测试方向工序的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.PROCESSID', '测试方向工序的测试方向ID', '测试方向ID', 'zh-CN', '测试方向ID'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.PROCESSSORTER', '测试方向工序的工序顺序', '工序顺序', 'zh-CN', '工序顺序'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.PROCESSNAME', '测试方向工序的工序', '工序', 'zh-CN', '工序'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.ORGID', '测试方向工序的orgId', 'orgId', 'zh-CN', 'orgId'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.ORGNAME', '测试方向工序的orgName', 'orgName', 'zh-CN', 'orgName'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYID', '测试方向工序的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYNAME', '测试方向工序的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.CREATEDTIME', '测试方向工序的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYORGID', '测试方向工序的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_PRETREAT_TESTPROCESS.CREATEDBYORGNAME', '测试方向工序的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATPROCESSS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATPROCESSS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATPROCESSS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATPROCESSS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.TRM.PRETREATMENT.PRETREATPROCESSS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_PRETREAT_TESTPROCESS', '0', '0'); COMMIT; INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES ('pretreatProcessType','工序类型','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 (2022091516321,'烘干','pretreatProcessType',NULL,1,0,'0',NULL,NULL,NULL,'drying','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022091516322,'称重','pretreatProcessType',NULL,2,0,'0',NULL,NULL,NULL,'weighing','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022091516323,'搅浆','pretreatProcessType',NULL,3,0,'0',NULL,NULL,NULL,'stirPulp','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022091516324,'组装','pretreatProcessType',NULL,4,0,'0',NULL,NULL,NULL,'assembly','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022091516325,'辊压','pretreatProcessType',NULL,5,0,'0',NULL,NULL,NULL,'rollerPressure','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916401,'注液','pretreatProcessType',NULL,6,0,'0',NULL,NULL,NULL,'noteLiquid','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916402,'水分测试','pretreatProcessType',NULL,7,0,'0',NULL,NULL,NULL,'waterTest','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916403,'超声波焊接','pretreatProcessType',NULL,8,0,'0',NULL,NULL,NULL,'ultrasonicWelding','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916404,'正极辊压','pretreatProcessType',NULL,9,0,'0',NULL,NULL,NULL,'anodeRollerPressure','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916405,'负极辊压','pretreatProcessType',NULL,10,0,'0',NULL,NULL,NULL,'cathodeRollerPressure','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916406,'负极搅拌','pretreatProcessType',NULL,11,0,'0',NULL,NULL,NULL,'cathodeStir','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916407,'正极搅拌','pretreatProcessType',NULL,12,0,'0',NULL,NULL,NULL,'anodeStir','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916408,'正极涂布','pretreatProcessType',NULL,13,0,'0',NULL,NULL,NULL,'anodeCoating','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022092916409,'负极涂布','pretreatProcessType',NULL,14,0,'0',NULL,NULL,NULL,'cathodeCoating','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (20220929164010,'极片称重','pretreatProcessType',NULL,15,0,'0',NULL,NULL,NULL,'polePieceWeighing','admin','系统管理员',NULL); INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES ('pretreatTestType','测试类型','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 (2022091609321,'扣电','pretreatTestType',NULL,1,0,'0',NULL,NULL,NULL,'扣电','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022091609322,'软包','pretreatTestType',NULL,2,0,'0',NULL,NULL,NULL,'软包','admin','系统管理员',NULL); INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES ('pretreatDirectionType','测试方向类型','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 (2022091610021,'半电','pretreatDirectionType',NULL,1,0,'0',NULL,NULL,NULL,'半电','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022091610022,'全电','pretreatDirectionType',NULL,2,0,'0',NULL,NULL,NULL,'全电','admin','系统管理员',NULL); INSERT INTO t_core_code (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES (2022091610023,'钠电','pretreatDirectionType',NULL,3,0,'0',NULL,NULL,NULL,'钠电','admin','系统管理员',NULL); ALTER TABLE T_LIMS_PRETREAT_INFORMATION ADD (ELNNAME VARCHAR2(270) DEFAULT NULL NULL); CALL INSERTI18N('T_LIMS_PRETREAT_INFORMATION.ELNNAME', 'ELN模板', 'ELN模板', 'zh-CN', 'ELN模板'); INSERT INTO LIMS_BP_DEV.T_CORE_CODE (ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE) VALUES(20220920004, '全电', 'testDirection', '8', 3, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'allInclusive');