shanxia2.0/docs/sql/2026-05-26-pilot-infusion-method-dict.sql

-- 中试服务申请单 — 输注方式字典（dict_type: szfs）
-- 在「系统管理 > 字典管理」中维护；前端通过 fetchDictDataOptions('szfs') 加载

INSERT INTO `sys_dict_type` (
  `id`, `dict_name`, `dict_type`, `tenant_no`, `order_num`, `remark`,
  `create_by`, `create_dept_id`, `create_time`, `update_by`, `update_time`, `del_flag`
) VALUES (
  'TDP000000000000000000000000000090',
  '输注方式',
  'szfs',
  'zkxw',
  10,
  '中试服务申请单-输注计划输注方式',
  'd3000000000000000000000000000001',
  'b13c2be2-4e71-11f1-9f47-00163e3bdd96',
  NOW(),
  'd3000000000000000000000000000001',
  NOW(),
  0
);

INSERT INTO `sys_dict_data` (
  `id`, `dict_label`, `dict_value`, `dict_type`, `tenant_no`, `order_num`, `remark`,
  `create_by`, `create_dept_id`, `create_time`, `update_by`, `update_time`, `del_flag`
) VALUES
(
  'TDP000000000000000000000000000091',
  '静脉输注',
  'jmsz',
  'szfs',
  'zkxw',
  1,
  '',
  'd3000000000000000000000000000001',
  'b13c2be2-4e71-11f1-9f47-00163e3bdd96',
  NOW(),
  'd3000000000000000000000000000001',
  NOW(),
  0
),
(
  'TDP000000000000000000000000000092',
  '皮下注射',
  'pxzs',
  'szfs',
  'zkxw',
  2,
  '',
  'd3000000000000000000000000000001',
  'b13c2be2-4e71-11f1-9f47-00163e3bdd96',
  NOW(),
  'd3000000000000000000000000000001',
  NOW(),
  0
),
(
  'TDP000000000000000000000000000093',
  '局部注射',
  'jbzs',
  'szfs',
  'zkxw',
  3,
  '',
  'd3000000000000000000000000000001',
  'b13c2be2-4e71-11f1-9f47-00163e3bdd96',
  NOW(),
  'd3000000000000000000000000000001',
  NOW(),
  0
),
(
  'TDP000000000000000000000000000094',
  '其他',
  'qt',
  'szfs',
  'zkxw',
  4,
  '',
  'd3000000000000000000000000000001',
  'b13c2be2-4e71-11f1-9f47-00163e3bdd96',
  NOW(),
  'd3000000000000000000000000000001',
  NOW(),
  0
);