dtbnyjy.vue 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705
  1. <template>
  2. <div class="app-container">
  3. <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
  4. <el-form-item label="唯一注册号" prop="assemblyAccession">
  5. <el-input
  6. v-model="queryParams.assemblyAccession"
  7. placeholder="请输入唯一注册号"
  8. clearable
  9. @keyup.enter.native="handleQuery"
  10. />
  11. </el-form-item>
  12. <!-- <el-form-item label="参考基因组类型" prop="refseqCategory">
  13. <el-input
  14. v-model="queryParams.refseqCategory"
  15. placeholder="请输入参考基因组类型"
  16. clearable
  17. @keyup.enter.native="handleQuery"
  18. />
  19. </el-form-item> -->
  20. <el-form-item label="分类号" prop="taxid">
  21. <el-input
  22. v-model="queryParams.taxid"
  23. placeholder="请输入分类号"
  24. clearable
  25. @keyup.enter.native="handleQuery"
  26. />
  27. </el-form-item>
  28. <!-- <el-form-item label="种分类号" prop="speciesTaxid">
  29. <el-input
  30. v-model="queryParams.speciesTaxid"
  31. placeholder="请输入种分类号"
  32. clearable
  33. @keyup.enter.native="handleQuery"
  34. />
  35. </el-form-item> -->
  36. <el-form-item label="生物名称" prop="organismName">
  37. <el-input
  38. v-model="queryParams.organismName"
  39. placeholder="请输入生物名称"
  40. clearable
  41. @keyup.enter.native="handleQuery"
  42. />
  43. </el-form-item>
  44. <!-- <el-form-item label="亚种名称" prop="infraspecificName">
  45. <el-input
  46. v-model="queryParams.infraspecificName"
  47. placeholder="请输入亚种名称"
  48. clearable
  49. @keyup.enter.native="handleQuery"
  50. />
  51. </el-form-item> -->
  52. <!-- <el-form-item label="分类类型" prop="isolate">
  53. <el-input
  54. v-model="queryParams.isolate"
  55. placeholder="请输入分类类型"
  56. clearable
  57. @keyup.enter.native="handleQuery"
  58. />
  59. </el-form-item>
  60. <el-form-item label="拼装级别" prop="assemblyLevel">
  61. <el-input
  62. v-model="queryParams.assemblyLevel"
  63. placeholder="请输入拼装级别"
  64. clearable
  65. @keyup.enter.native="handleQuery"
  66. />
  67. </el-form-item>
  68. <el-form-item label="基因组级别" prop="genomeRep">
  69. <el-input
  70. v-model="queryParams.genomeRep"
  71. placeholder="请输入基因组级别"
  72. clearable
  73. @keyup.enter.native="handleQuery"
  74. />
  75. </el-form-item>
  76. <el-form-item label="seq_rel_date" prop="seqRelDate">
  77. <el-date-picker clearable
  78. v-model="queryParams.seqRelDate"
  79. type="date"
  80. value-format="yyyy-MM-dd"
  81. placeholder="请选择seq_rel_date">
  82. </el-date-picker>
  83. </el-form-item>
  84. <el-form-item label="ASM编号" prop="asmName">
  85. <el-input
  86. v-model="queryParams.asmName"
  87. placeholder="请输入ASM编号"
  88. clearable
  89. @keyup.enter.native="handleQuery"
  90. />
  91. </el-form-item>
  92. <el-form-item label="gbrs_paired_asm" prop="gbrsPairedAsm">
  93. <el-input
  94. v-model="queryParams.gbrsPairedAsm"
  95. placeholder="请输入gbrs_paired_asm"
  96. clearable
  97. @keyup.enter.native="handleQuery"
  98. />
  99. </el-form-item>
  100. <el-form-item label="paired_asm_comp" prop="pairedAsmComp">
  101. <el-input
  102. v-model="queryParams.pairedAsmComp"
  103. placeholder="请输入paired_asm_comp"
  104. clearable
  105. @keyup.enter.native="handleQuery"
  106. />
  107. </el-form-item> -->
  108. <el-form-item label="来源地址" prop="ftpPath">
  109. <el-input
  110. v-model="queryParams.ftpPath"
  111. placeholder="请输入来源地址"
  112. clearable
  113. @keyup.enter.native="handleQuery"
  114. />
  115. </el-form-item>
  116. <!-- <el-form-item label="excluded_from_refseq" prop="excludedFromRefseq">
  117. <el-input
  118. v-model="queryParams.excludedFromRefseq"
  119. placeholder="请输入excluded_from_refseq"
  120. clearable
  121. @keyup.enter.native="handleQuery"
  122. />
  123. </el-form-item>
  124. <el-form-item label="病源类型" prop="group">
  125. <el-input
  126. v-model="queryParams.group"
  127. placeholder="请输入病源类型"
  128. clearable
  129. @keyup.enter.native="handleQuery"
  130. />
  131. </el-form-item>
  132. <el-form-item label="基因组大小" prop="genomeSize">
  133. <el-input
  134. v-model="queryParams.genomeSize"
  135. placeholder="请输入基因组大小"
  136. clearable
  137. @keyup.enter.native="handleQuery"
  138. />
  139. </el-form-item>
  140. <el-form-item label="基因组大小" prop="genomeSizeUngapped">
  141. <el-input
  142. v-model="queryParams.genomeSizeUngapped"
  143. placeholder="请输入基因组大小"
  144. clearable
  145. @keyup.enter.native="handleQuery"
  146. />
  147. </el-form-item>
  148. <el-form-item label="GC比例" prop="gcPercent">
  149. <el-input
  150. v-model="queryParams.gcPercent"
  151. placeholder="请输入GC比例"
  152. clearable
  153. @keyup.enter.native="handleQuery"
  154. />
  155. </el-form-item>
  156. <el-form-item label="replicon_count" prop="repliconCount">
  157. <el-input
  158. v-model="queryParams.repliconCount"
  159. placeholder="请输入replicon_count"
  160. clearable
  161. @keyup.enter.native="handleQuery"
  162. />
  163. </el-form-item>
  164. <el-form-item label="scaffold_count" prop="scaffoldCount">
  165. <el-input
  166. v-model="queryParams.scaffoldCount"
  167. placeholder="请输入scaffold_count"
  168. clearable
  169. @keyup.enter.native="handleQuery"
  170. />
  171. </el-form-item>
  172. <el-form-item label="contig_count" prop="contigCount">
  173. <el-input
  174. v-model="queryParams.contigCount"
  175. placeholder="请输入contig_count"
  176. clearable
  177. @keyup.enter.native="handleQuery"
  178. />
  179. </el-form-item>
  180. <el-form-item label="总基因数" prop="totalGeneCount">
  181. <el-input
  182. v-model="queryParams.totalGeneCount"
  183. placeholder="请输入总基因数"
  184. clearable
  185. @keyup.enter.native="handleQuery"
  186. />
  187. </el-form-item>
  188. <el-form-item label="翻译蛋白基因数" prop="proteinCodingGeneCount">
  189. <el-input
  190. v-model="queryParams.proteinCodingGeneCount"
  191. placeholder="请输入翻译蛋白基因数"
  192. clearable
  193. @keyup.enter.native="handleQuery"
  194. />
  195. </el-form-item>
  196. <el-form-item label="非编码基因数" prop="nonCodingGeneCount">
  197. <el-input
  198. v-model="queryParams.nonCodingGeneCount"
  199. placeholder="请输入非编码基因数"
  200. clearable
  201. @keyup.enter.native="handleQuery"
  202. />
  203. </el-form-item> -->
  204. <el-form-item label="中文名" prop="nameCn">
  205. <el-input
  206. v-model="queryParams.nameCn"
  207. placeholder="请输入中文名"
  208. clearable
  209. @keyup.enter.native="handleQuery"
  210. />
  211. </el-form-item>
  212. <el-form-item label="序列来源" prop="seqSource">
  213. <el-input
  214. v-model="queryParams.seqSource"
  215. placeholder="请输入序列来源"
  216. clearable
  217. @keyup.enter.native="handleQuery"
  218. />
  219. </el-form-item>
  220. <el-form-item label="解释来源" prop="express">
  221. <el-input
  222. v-model="queryParams.express"
  223. placeholder="请输入解释来源"
  224. clearable
  225. @keyup.enter.native="handleQuery"
  226. />
  227. </el-form-item>
  228. <!-- <el-form-item label="文件路径" prop="filePath">
  229. <el-input
  230. v-model="queryParams.filePath"
  231. placeholder="请输入文件路径"
  232. clearable
  233. @keyup.enter.native="handleQuery"
  234. />
  235. </el-form-item>
  236. <el-form-item label="点突变耐药基因" prop="dtpnyjy">
  237. <el-input
  238. v-model="queryParams.dtpnyjy"
  239. placeholder="请输入点突变耐药基因"
  240. clearable
  241. @keyup.enter.native="handleQuery"
  242. />
  243. </el-form-item>
  244. <el-form-item label="点突变耐药基因说明" prop="dtpnyjyExpress">
  245. <el-input
  246. v-model="queryParams.dtpnyjyExpress"
  247. placeholder="请输入点突变耐药基因说明"
  248. clearable
  249. @keyup.enter.native="handleQuery"
  250. />
  251. </el-form-item>
  252. <el-form-item label="耐药基因" prop="nyjy">
  253. <el-input
  254. v-model="queryParams.nyjy"
  255. placeholder="请输入耐药基因"
  256. clearable
  257. @keyup.enter.native="handleQuery"
  258. />
  259. </el-form-item>
  260. <el-form-item label="耐药基因说明" prop="nyjyExpress">
  261. <el-input
  262. v-model="queryParams.nyjyExpress"
  263. placeholder="请输入耐药基因说明"
  264. clearable
  265. @keyup.enter.native="handleQuery"
  266. />
  267. </el-form-item>
  268. <el-form-item label="毒力基因" prop="dljy">
  269. <el-input
  270. v-model="queryParams.dljy"
  271. placeholder="请输入毒力基因"
  272. clearable
  273. @keyup.enter.native="handleQuery"
  274. />
  275. </el-form-item>
  276. <el-form-item label="毒力基因说明" prop="dljyExpress">
  277. <el-input
  278. v-model="queryParams.dljyExpress"
  279. placeholder="请输入毒力基因说明"
  280. clearable
  281. @keyup.enter.native="handleQuery"
  282. />
  283. </el-form-item> -->
  284. <el-form-item>
  285. <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
  286. <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
  287. </el-form-item>
  288. </el-form>
  289. <el-row :gutter="10" class="mb8">
  290. <el-col :span="1.5">
  291. <el-button
  292. type="danger"
  293. plain
  294. icon="el-icon-delete"
  295. size="mini"
  296. :disabled="multiple"
  297. @click="handleDelete"
  298. >删除</el-button>
  299. </el-col>
  300. <el-col :span="1.5">
  301. <el-button
  302. type="warning"
  303. plain
  304. icon="el-icon-upload"
  305. size="mini"
  306. @click="$refs.upload_file.click()"
  307. >导入</el-button>
  308. </el-col>
  309. <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
  310. </el-row>
  311. <el-table v-loading="loading" :data="dataBaseList" @selection-change="handleSelectionChange">
  312. <el-table-column type="selection" width="55" align="center" />
  313. <el-table-column label="唯一注册号" align="center" prop="assemblyAccession" />
  314. <el-table-column label="参考基因组类型" align="center" prop="refseqCategory" />
  315. <el-table-column label="分类号" align="center" prop="taxid" />
  316. <el-table-column label="种分类号" align="center" prop="speciesTaxid" />
  317. <el-table-column label="生物名称" align="center" prop="organismName" />
  318. <el-table-column label="亚种名称" align="center" prop="infraspecificName" />
  319. <el-table-column label="分类类型" align="center" prop="isolate" />
  320. <el-table-column label="拼装级别" align="center" prop="assemblyLevel" />
  321. <el-table-column label="基因组级别" align="center" prop="genomeRep" />
  322. <el-table-column label="seq_rel_date" align="center" prop="seqRelDate" width="180">
  323. <template slot-scope="scope">
  324. <span>{{ parseTime(scope.row.seqRelDate, '{y}-{m}-{d}') }}</span>
  325. </template>
  326. </el-table-column>
  327. <el-table-column label="ASM编号" align="center" prop="asmName" />
  328. <el-table-column label="gbrs_paired_asm" align="center" prop="gbrsPairedAsm" />
  329. <el-table-column label="paired_asm_comp" align="center" prop="pairedAsmComp" />
  330. <el-table-column label="来源地址" align="center" prop="ftpPath" />
  331. <el-table-column label="excluded_from_refseq" align="center" prop="excludedFromRefseq" />
  332. <el-table-column label="装配类型" align="center" prop="assemblyType" />
  333. <el-table-column label="病源类型" align="center" prop="group" />
  334. <el-table-column label="基因组大小" align="center" prop="genomeSize" />
  335. <el-table-column label="基因组大小" align="center" prop="genomeSizeUngapped" />
  336. <el-table-column label="GC比例" align="center" prop="gcPercent" />
  337. <el-table-column label="replicon_count" align="center" prop="repliconCount" />
  338. <el-table-column label="scaffold_count" align="center" prop="scaffoldCount" />
  339. <el-table-column label="contig_count" align="center" prop="contigCount" />
  340. <el-table-column label="总基因数" align="center" prop="totalGeneCount" />
  341. <el-table-column label="翻译蛋白基因数" align="center" prop="proteinCodingGeneCount" />
  342. <el-table-column label="非编码基因数" align="center" prop="nonCodingGeneCount" />
  343. <el-table-column label="中文名" align="center" prop="nameCn" />
  344. <el-table-column label="定义" align="center" prop="defined" />
  345. <el-table-column label="序列来源" align="center" prop="seqSource" />
  346. <el-table-column label="解释来源" align="center" prop="express" />
  347. <el-table-column label="文件路径" align="center" prop="filePath" />
  348. <el-table-column label="点突变耐药基因" align="center" prop="dtpnyjy" />
  349. <el-table-column label="点突变耐药基因说明" align="center" prop="dtpnyjyExpress" />
  350. <el-table-column label="耐药基因" align="center" prop="nyjy" />
  351. <el-table-column label="耐药基因说明" align="center" prop="nyjyExpress" />
  352. <el-table-column label="毒力基因" align="center" prop="dljy" />
  353. <el-table-column label="毒力基因说明" align="center" prop="dljyExpress" />
  354. <el-table-column label="备注" align="center" prop="remark" />
  355. <el-table-column label="操作" align="center" class-name="small-padding fixed-width" fixed="right">
  356. <template slot-scope="scope">
  357. <el-button
  358. size="mini"
  359. type="text"
  360. icon="el-icon-delete"
  361. @click="handleDelete(scope.row)"
  362. v-hasPermi="['data:dataBase:remove']"
  363. >删除</el-button>
  364. </template>
  365. </el-table-column>
  366. </el-table>
  367. <pagination
  368. v-show="total>0"
  369. :total="total"
  370. :page.sync="queryParams.pageNum"
  371. :limit.sync="queryParams.pageSize"
  372. @pagination="getList"
  373. />
  374. <!-- 添加或修改病原体管理对话框 -->
  375. <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
  376. <el-form ref="form" :model="form" :rules="rules" label-width="80px">
  377. <el-form-item label="唯一注册号" prop="assemblyAccession">
  378. <el-input v-model="form.assemblyAccession" placeholder="请输入唯一注册号" />
  379. </el-form-item>
  380. <el-form-item label="参考基因组类型" prop="refseqCategory">
  381. <el-input v-model="form.refseqCategory" placeholder="请输入参考基因组类型" />
  382. </el-form-item>
  383. <el-form-item label="分类号" prop="taxid">
  384. <el-input v-model="form.taxid" placeholder="请输入分类号" />
  385. </el-form-item>
  386. <el-form-item label="种分类号" prop="speciesTaxid">
  387. <el-input v-model="form.speciesTaxid" placeholder="请输入种分类号" />
  388. </el-form-item>
  389. <el-form-item label="生物名称" prop="organismName">
  390. <el-input v-model="form.organismName" placeholder="请输入生物名称" />
  391. </el-form-item>
  392. <el-form-item label="亚种名称" prop="infraspecificName">
  393. <el-input v-model="form.infraspecificName" placeholder="请输入亚种名称" />
  394. </el-form-item>
  395. <el-form-item label="分类类型" prop="isolate">
  396. <el-input v-model="form.isolate" placeholder="请输入分类类型" />
  397. </el-form-item>
  398. <el-form-item label="拼装级别" prop="assemblyLevel">
  399. <el-input v-model="form.assemblyLevel" placeholder="请输入拼装级别" />
  400. </el-form-item>
  401. <el-form-item label="基因组级别" prop="genomeRep">
  402. <el-input v-model="form.genomeRep" placeholder="请输入基因组级别" />
  403. </el-form-item>
  404. <el-form-item label="seq_rel_date" prop="seqRelDate">
  405. <el-date-picker clearable
  406. v-model="form.seqRelDate"
  407. type="date"
  408. value-format="yyyy-MM-dd"
  409. placeholder="请选择seq_rel_date">
  410. </el-date-picker>
  411. </el-form-item>
  412. <el-form-item label="ASM编号" prop="asmName">
  413. <el-input v-model="form.asmName" placeholder="请输入ASM编号" />
  414. </el-form-item>
  415. <el-form-item label="gbrs_paired_asm" prop="gbrsPairedAsm">
  416. <el-input v-model="form.gbrsPairedAsm" placeholder="请输入gbrs_paired_asm" />
  417. </el-form-item>
  418. <el-form-item label="paired_asm_comp" prop="pairedAsmComp">
  419. <el-input v-model="form.pairedAsmComp" placeholder="请输入paired_asm_comp" />
  420. </el-form-item>
  421. <el-form-item label="来源地址" prop="ftpPath">
  422. <el-input v-model="form.ftpPath" placeholder="请输入来源地址" />
  423. </el-form-item>
  424. <el-form-item label="excluded_from_refseq" prop="excludedFromRefseq">
  425. <el-input v-model="form.excludedFromRefseq" placeholder="请输入excluded_from_refseq" />
  426. </el-form-item>
  427. <el-form-item label="病源类型" prop="group">
  428. <el-input v-model="form.group" placeholder="请输入病源类型" />
  429. </el-form-item>
  430. <el-form-item label="基因组大小" prop="genomeSize">
  431. <el-input v-model="form.genomeSize" placeholder="请输入基因组大小" />
  432. </el-form-item>
  433. <el-form-item label="基因组大小" prop="genomeSizeUngapped">
  434. <el-input v-model="form.genomeSizeUngapped" placeholder="请输入基因组大小" />
  435. </el-form-item>
  436. <el-form-item label="GC比例" prop="gcPercent">
  437. <el-input v-model="form.gcPercent" placeholder="请输入GC比例" />
  438. </el-form-item>
  439. <el-form-item label="replicon_count" prop="repliconCount">
  440. <el-input v-model="form.repliconCount" placeholder="请输入replicon_count" />
  441. </el-form-item>
  442. <el-form-item label="scaffold_count" prop="scaffoldCount">
  443. <el-input v-model="form.scaffoldCount" placeholder="请输入scaffold_count" />
  444. </el-form-item>
  445. <el-form-item label="contig_count" prop="contigCount">
  446. <el-input v-model="form.contigCount" placeholder="请输入contig_count" />
  447. </el-form-item>
  448. <el-form-item label="总基因数" prop="totalGeneCount">
  449. <el-input v-model="form.totalGeneCount" placeholder="请输入总基因数" />
  450. </el-form-item>
  451. <el-form-item label="翻译蛋白基因数" prop="proteinCodingGeneCount">
  452. <el-input v-model="form.proteinCodingGeneCount" placeholder="请输入翻译蛋白基因数" />
  453. </el-form-item>
  454. <el-form-item label="非编码基因数" prop="nonCodingGeneCount">
  455. <el-input v-model="form.nonCodingGeneCount" placeholder="请输入非编码基因数" />
  456. </el-form-item>
  457. <el-form-item label="中文名" prop="nameCn">
  458. <el-input v-model="form.nameCn" placeholder="请输入中文名" />
  459. </el-form-item>
  460. <el-form-item label="定义" prop="defined">
  461. <el-input v-model="form.defined" type="textarea" placeholder="请输入内容" />
  462. </el-form-item>
  463. <el-form-item label="序列来源" prop="seqSource">
  464. <el-input v-model="form.seqSource" placeholder="请输入序列来源" />
  465. </el-form-item>
  466. <el-form-item label="解释来源" prop="express">
  467. <el-input v-model="form.express" placeholder="请输入解释来源" />
  468. </el-form-item>
  469. <el-form-item label="文件路径" prop="filePath">
  470. <el-input v-model="form.filePath" placeholder="请输入文件路径" />
  471. </el-form-item>
  472. <el-form-item label="点突变耐药基因" prop="dtpnyjy">
  473. <el-input v-model="form.dtpnyjy" placeholder="请输入点突变耐药基因" />
  474. </el-form-item>
  475. <el-form-item label="点突变耐药基因说明" prop="dtpnyjyExpress">
  476. <el-input v-model="form.dtpnyjyExpress" placeholder="请输入点突变耐药基因说明" />
  477. </el-form-item>
  478. <el-form-item label="耐药基因" prop="nyjy">
  479. <el-input v-model="form.nyjy" placeholder="请输入耐药基因" />
  480. </el-form-item>
  481. <el-form-item label="耐药基因说明" prop="nyjyExpress">
  482. <el-input v-model="form.nyjyExpress" placeholder="请输入耐药基因说明" />
  483. </el-form-item>
  484. <el-form-item label="毒力基因" prop="dljy">
  485. <el-input v-model="form.dljy" placeholder="请输入毒力基因" />
  486. </el-form-item>
  487. <el-form-item label="毒力基因说明" prop="dljyExpress">
  488. <el-input v-model="form.dljyExpress" placeholder="请输入毒力基因说明" />
  489. </el-form-item>
  490. <el-form-item label="备注" prop="remark">
  491. <el-input v-model="form.remark" type="textarea" placeholder="请输入内容" />
  492. </el-form-item>
  493. </el-form>
  494. <div slot="footer" class="dialog-footer">
  495. <el-button @click="cancel">取 消</el-button>
  496. </div>
  497. </el-dialog>
  498. <!-- 上传文件 -->
  499. <input hidden type="file" ref="upload_file" accept=".xls,.xlsx" class="upload_file" @change="readExcel($event)" />
  500. </div>
  501. </template>
  502. <script>
  503. import { listDataBase, getDataBase, delDataBase, addDataBase, updateDataBase } from "@/api/data/dataBase"
  504. export default {
  505. name: "DataBase",
  506. data() {
  507. return {
  508. // 遮罩层
  509. loading: true,
  510. // 选中数组
  511. ids: [],
  512. // 非单个禁用
  513. single: true,
  514. // 非多个禁用
  515. multiple: true,
  516. // 显示搜索条件
  517. showSearch: true,
  518. // 总条数
  519. total: 0,
  520. // 病原体管理表格数据
  521. dataBaseList: [],
  522. // 弹出层标题
  523. title: "",
  524. // 是否显示弹出层
  525. open: false,
  526. // 查询参数
  527. queryParams: {
  528. pageNum: 1,
  529. pageSize: 10,
  530. type:3,
  531. assemblyAccession: null,
  532. refseqCategory: null,
  533. taxid: null,
  534. speciesTaxid: null,
  535. organismName: null,
  536. infraspecificName: null,
  537. isolate: null,
  538. assemblyLevel: null,
  539. genomeRep: null,
  540. seqRelDate: null,
  541. asmName: null,
  542. gbrsPairedAsm: null,
  543. pairedAsmComp: null,
  544. ftpPath: null,
  545. excludedFromRefseq: null,
  546. assemblyType: null,
  547. group: null,
  548. genomeSize: null,
  549. genomeSizeUngapped: null,
  550. gcPercent: null,
  551. repliconCount: null,
  552. scaffoldCount: null,
  553. contigCount: null,
  554. totalGeneCount: null,
  555. proteinCodingGeneCount: null,
  556. nonCodingGeneCount: null,
  557. nameCn: null,
  558. defined: null,
  559. seqSource: null,
  560. express: null,
  561. filePath: null,
  562. dtpnyjy: null,
  563. dtpnyjyExpress: null,
  564. nyjy: null,
  565. nyjyExpress: null,
  566. dljy: null,
  567. dljyExpress: null,
  568. },
  569. // 表单参数
  570. form: {},
  571. // 表单校验
  572. rules: {
  573. }
  574. }
  575. },
  576. created() {
  577. this.getList()
  578. },
  579. methods: {
  580. // 读取Excel文件
  581. readExcel(e) {
  582. console.log("读取Excel文件", e);
  583. console.log("读取Excel文件11", XLSX);
  584. // 读取表格文件
  585. let that = this;
  586. const files = e.target.files;
  587. if (files.length <= 0) {
  588. return false;
  589. } else if (!/\.(xls|xlsx)$/.test(files[0].name.toLowerCase())) {
  590. this.$message({
  591. message: "上传格式不正确,请上传xls或者xlsx格式",
  592. type: "warning",
  593. });
  594. return false;
  595. } else {
  596. this.uploadFile(files[0]);
  597. }
  598. },
  599. uploadFile(file) {
  600. console.log("上传文件", file);
  601. // 创建FormData对象
  602. const formData = new FormData(); // 创建FormData对象
  603. formData.append('file', file); // 将文件添加到FormData对象中,
  604. importDataBase(formData).then(response => {
  605. this.$modal.msgSuccess("导入成功")
  606. this.getList()
  607. })
  608. },
  609. /** 查询病原体管理列表 */
  610. getList() {
  611. this.loading = true
  612. listDataBase(this.queryParams).then(response => {
  613. this.dataBaseList = response.rows
  614. this.total = response.total
  615. this.loading = false
  616. })
  617. },
  618. // 取消按钮
  619. cancel() {
  620. this.open = false
  621. this.reset()
  622. },
  623. // 表单重置
  624. reset() {
  625. this.form = {
  626. assemblyAccession: null,
  627. refseqCategory: null,
  628. taxid: null,
  629. speciesTaxid: null,
  630. organismName: null,
  631. infraspecificName: null,
  632. isolate: null,
  633. assemblyLevel: null,
  634. genomeRep: null,
  635. seqRelDate: null,
  636. asmName: null,
  637. gbrsPairedAsm: null,
  638. pairedAsmComp: null,
  639. ftpPath: null,
  640. excludedFromRefseq: null,
  641. assemblyType: null,
  642. group: null,
  643. genomeSize: null,
  644. genomeSizeUngapped: null,
  645. gcPercent: null,
  646. repliconCount: null,
  647. scaffoldCount: null,
  648. contigCount: null,
  649. totalGeneCount: null,
  650. proteinCodingGeneCount: null,
  651. nonCodingGeneCount: null,
  652. nameCn: null,
  653. defined: null,
  654. seqSource: null,
  655. express: null,
  656. filePath: null,
  657. dtpnyjy: null,
  658. dtpnyjyExpress: null,
  659. nyjy: null,
  660. nyjyExpress: null,
  661. dljy: null,
  662. dljyExpress: null,
  663. createBy: null,
  664. createTime: null,
  665. updateBy: null,
  666. updateTime: null,
  667. remark: null
  668. }
  669. this.resetForm("form")
  670. },
  671. /** 搜索按钮操作 */
  672. handleQuery() {
  673. this.queryParams.pageNum = 1
  674. this.getList()
  675. },
  676. /** 重置按钮操作 */
  677. resetQuery() {
  678. this.resetForm("queryForm")
  679. this.handleQuery()
  680. },
  681. // 多选框选中数据
  682. handleSelectionChange(selection) {
  683. this.ids = selection.map(item => item.assemblyAccession)
  684. this.single = selection.length!==1
  685. this.multiple = !selection.length
  686. },
  687. /** 删除按钮操作 */
  688. handleDelete(row) {
  689. const ids = row.assemblyAccession || this.ids
  690. this.$modal.confirm('是否确认删除病原体管理编号为"' + ids + '"的数据项?').then(function() {
  691. return delDataBase(ids)
  692. }).then(() => {
  693. this.getList()
  694. this.$modal.msgSuccess("删除成功")
  695. }).catch(() => {})
  696. },
  697. }
  698. }
  699. </script>