GenTableColumnView.vue 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454
  1. <template>
  2. <div class="back-form-container">
  3. <div>
  4. <el-form :model="query" label-width="80px" :inline="true">
  5. <el-form-item label="表格id" prop="tableId">
  6. <el-input v-model="query.tableId" placeholder="请输入表格id"/>
  7. </el-form-item>
  8. <el-form-item label="排序" prop="sort">
  9. <el-input-number v-model="query.sort" placeholder="请输入排序"/>
  10. </el-form-item>
  11. <el-form-item label="字段注释" prop="columnComment">
  12. <el-input v-model="query.columnComment" placeholder="请输入字段注释"/>
  13. </el-form-item>
  14. <el-form-item label="字段类型" prop="columnType">
  15. <el-input v-model="query.columnType" placeholder="请输入字段类型"/>
  16. </el-form-item>
  17. <el-form-item label="go类型" prop="goType">
  18. <el-select v-model="query.goType" placeholder="请选择go类型">
  19. <el-option
  20. v-for="item in store.state.dicts.get('go_type')"
  21. :key="item.dictValue"
  22. :label="item.dictLabel"
  23. :value="item.dictValue"/>
  24. </el-select>
  25. </el-form-item>
  26. <el-form-item label="go字段名" prop="goField">
  27. <el-input v-model="query.goField" placeholder="请输入go字段名"/>
  28. </el-form-item>
  29. <el-form-item label="是否主键" prop="isKey"> <el-radio-group v-model="query.isKey">
  30. <el-radio
  31. v-for="item in [['0','否'], ['1','是']]"
  32. :key="item[0]"
  33. :label="item[0]">
  34. {{ item[1] }}
  35. </el-radio>
  36. </el-radio-group>
  37. </el-form-item>
  38. <el-form-item label="是否自增" prop="isIncrement"> <el-radio-group v-model="query.isIncrement">
  39. <el-radio
  40. v-for="item in [['0','否'], ['1','是']]"
  41. :key="item[0]"
  42. :label="item[0]">
  43. {{ item[1] }}
  44. </el-radio>
  45. </el-radio-group>
  46. </el-form-item>
  47. <el-form-item label="是否未必填" prop="isRequired"> <el-radio-group v-model="query.isRequired">
  48. <el-radio
  49. v-for="item in [['0','否'], ['1','是']]"
  50. :key="item[0]"
  51. :label="item[0]">
  52. {{ item[1] }}
  53. </el-radio>
  54. </el-radio-group>
  55. </el-form-item>
  56. <el-form-item label="查询方式" prop="queryType">
  57. <el-select v-model="query.queryType" placeholder="请选择查询方式">
  58. <el-option
  59. v-for="item in store.state.dicts.get('query_type')"
  60. :key="item.dictValue"
  61. :label="item.dictLabel"
  62. :value="item.dictValue"/>
  63. </el-select>
  64. </el-form-item>
  65. <el-form-item label="前端显示类型" prop="vueShowType">
  66. <el-select v-model="query.vueShowType" placeholder="请选择前端显示类型">
  67. <el-option
  68. v-for="item in store.state.dicts.get('vue_show_type')"
  69. :key="item.dictValue"
  70. :label="item.dictLabel"
  71. :value="item.dictValue"/>
  72. </el-select>
  73. </el-form-item>
  74. <el-form-item label="字典类型" prop="dictType">
  75. <el-select v-model="query.dictType" placeholder="请选择字典类型">
  76. <el-option
  77. v-for="item in store.state.dicts.get('')"
  78. :key="item.dictValue"
  79. :label="item.dictLabel"
  80. :value="item.dictValue"/>
  81. </el-select>
  82. </el-form-item>
  83. <el-form-item label="字段名" prop="columnName">
  84. <el-input v-model="query.columnName" placeholder="请输入字段名"/>
  85. </el-form-item>
  86. </el-form>
  87. </div>
  88. <div class="back-table-handler">
  89. <el-row :gutter="10" class="mb8">
  90. <el-col :span="1.5">
  91. <el-button type="primary" plain size="small" @click="getList(pageNum)">
  92. <el-icon>
  93. <RefreshLeft/>
  94. </el-icon>
  95. <span>刷新</span>
  96. </el-button>
  97. </el-col>
  98. <el-col :span="1.5">
  99. <el-button type="primary" plain size="small" @click="openDialog('save', GenTableColumn.Create())">
  100. <el-icon>
  101. <Plus/>
  102. </el-icon>
  103. <span>新增</span>
  104. </el-button>
  105. </el-col>
  106. <el-col :span="1.5">
  107. <el-button type="danger" plain size="small" @click="deleteByIds()">
  108. <el-icon>
  109. <Delete/>
  110. </el-icon>
  111. <span>删除</span>
  112. </el-button>
  113. </el-col>
  114. </el-row>
  115. </div>
  116. <div class="back-table">
  117. <el-table v-loading="listLoading" :data="list" @selection-change="selected" border :key="ListKey">
  118. <el-table-column type="selection" width="40" align="center"/>
  119. <el-table-column label="id" align="center" prop="id"/>
  120. <el-table-column label="表格id" align="center" prop="tableId"/>
  121. <el-table-column label="排序" align="center" prop="sort"/>
  122. <el-table-column label="字段注释" align="center" prop="columnComment"/>
  123. <el-table-column label="字段类型" align="center" prop="columnType"/>
  124. <el-table-column label="go类型" align="center" prop="goType">
  125. <template #default="scope">
  126. <DictTag :dict-type="'go_type'" :dict-value="scope.row.goType"/>
  127. </template>
  128. </el-table-column>
  129. <el-table-column label="go字段名" align="center" prop="goField"/>
  130. <el-table-column label="是否主键" align="center" prop="isKey"/>
  131. <el-table-column label="是否自增" align="center" prop="isIncrement"/>
  132. <el-table-column label="是否未必填" align="center" prop="isRequired"/>
  133. <el-table-column label="查询方式" align="center" prop="queryType">
  134. <template #default="scope">
  135. <DictTag :dict-type="'query_type'" :dict-value="scope.row.queryType"/>
  136. </template>
  137. </el-table-column>
  138. <el-table-column label="前端显示类型" align="center" prop="vueShowType">
  139. <template #default="scope">
  140. <DictTag :dict-type="'vue_show_type'" :dict-value="scope.row.vueShowType"/>
  141. </template>
  142. </el-table-column>
  143. <el-table-column label="字典类型" align="center" prop="dictType"/>
  144. <el-table-column label="字段名" align="center" prop="columnName"/>
  145. <el-table-column label="操作" align="center" fixed="right">
  146. <template #default="scope">
  147. <el-button link type="primary" @click="openDialog('update',scope.row)">修改</el-button>
  148. <el-button link type="danger" @click="deleteById(scope.row.id)">删除</el-button>
  149. </template>
  150. </el-table-column>
  151. </el-table>
  152. <div class="pagination-container">
  153. <el-pagination
  154. background
  155. :current-page="pageNum"
  156. @current-change="getList"
  157. :page-size="pageSize"
  158. :page-sizes="[10, 20, 30, 50,100]"
  159. :total="total"
  160. @size-change="SetPageSized"
  161. layout="total, sizes, prev, pager, next"
  162. />
  163. </div>
  164. <!-- 添加或修改参数配置对话框 -->
  165. <el-dialog :title="dialogType=='update'?'更改字典类型':'新增字典类型'" v-model="open" width="500px" append-to-body>
  166. <el-form ref="dictRef" :model="dialogForm" label-width="80px">
  167. <el-form-item label="表格id" prop="tableId">
  168. <el-input v-model="dialogForm.tableId" placeholder="请输入表格id"/>
  169. </el-form-item>
  170. <el-form-item label="排序" prop="sort">
  171. <el-input-number v-model="dialogForm.sort" placeholder="请输入排序"/>
  172. </el-form-item>
  173. <el-form-item label="字段注释" prop="columnComment">
  174. <el-input v-model="dialogForm.columnComment" placeholder="请输入字段注释"/>
  175. </el-form-item>
  176. <el-form-item label="字段类型" prop="columnType">
  177. <el-input v-model="dialogForm.columnType" placeholder="请输入字段类型"/>
  178. </el-form-item>
  179. <el-form-item label="go类型" prop="goType">
  180. <el-select v-model="dialogForm.goType" placeholder="请选择go类型">
  181. <el-option
  182. v-for="item in store.state.dicts.get('go_type')"
  183. :key="item.dictValue"
  184. :label="item.dictLabel"
  185. :value="item.dictValue"/>
  186. </el-select>
  187. </el-form-item>
  188. <el-form-item label="go字段名" prop="goField">
  189. <el-input v-model="dialogForm.goField" placeholder="请输入go字段名"/>
  190. </el-form-item>
  191. <el-form-item label="是否主键" prop="isKey"> <el-radio-group v-model="dialogForm.isKey">
  192. <el-radio
  193. v-for="item in [['0','否'], ['1','是']]"
  194. :key="item[0]"
  195. :label="item[0]">
  196. {{ item[1] }}
  197. </el-radio>
  198. </el-radio-group>
  199. </el-form-item>
  200. <el-form-item label="是否自增" prop="isIncrement"> <el-radio-group v-model="dialogForm.isIncrement">
  201. <el-radio
  202. v-for="item in [['0','否'], ['1','是']]"
  203. :key="item[0]"
  204. :label="item[0]">
  205. {{ item[1] }}
  206. </el-radio>
  207. </el-radio-group>
  208. </el-form-item>
  209. <el-form-item label="是否未必填" prop="isRequired"> <el-radio-group v-model="dialogForm.isRequired">
  210. <el-radio
  211. v-for="item in [['0','否'], ['1','是']]"
  212. :key="item[0]"
  213. :label="item[0]">
  214. {{ item[1] }}
  215. </el-radio>
  216. </el-radio-group>
  217. </el-form-item>
  218. <el-form-item label="查询方式" prop="queryType">
  219. <el-select v-model="dialogForm.queryType" placeholder="请选择查询方式">
  220. <el-option
  221. v-for="item in store.state.dicts.get('query_type')"
  222. :key="item.dictValue"
  223. :label="item.dictLabel"
  224. :value="item.dictValue"/>
  225. </el-select>
  226. </el-form-item>
  227. <el-form-item label="前端显示类型" prop="vueShowType">
  228. <el-select v-model="dialogForm.vueShowType" placeholder="请选择前端显示类型">
  229. <el-option
  230. v-for="item in store.state.dicts.get('vue_show_type')"
  231. :key="item.dictValue"
  232. :label="item.dictLabel"
  233. :value="item.dictValue"/>
  234. </el-select>
  235. </el-form-item>
  236. <el-form-item label="字典类型" prop="dictType">
  237. <el-select v-model="dialogForm.dictType" placeholder="请选择字典类型">
  238. <el-option
  239. v-for="item in store.state.dicts.get('')"
  240. :key="item.dictValue"
  241. :label="item.dictLabel"
  242. :value="item.dictValue"/>
  243. </el-select>
  244. </el-form-item>
  245. <el-form-item label="字段名" prop="columnName">
  246. <el-input v-model="dialogForm.columnName" placeholder="请输入字段名"/>
  247. </el-form-item>
  248. </el-form>
  249. <template #footer>
  250. <div class="dialog-footer">
  251. <el-button type="primary" @click="submitForm()">确 定</el-button>
  252. <el-button @click="open=false">取 消</el-button>
  253. </div>
  254. </template>
  255. </el-dialog>
  256. </div>
  257. </div>
  258. </template>
  259. <script setup lang="ts">
  260. import {ref} from "vue";
  261. import {
  262. DeleteBaseGenTableColumnById,
  263. GetBaseGenTableColumnListByGenTableColumn,
  264. SaveBaseGenTableColumn,
  265. UpdateBaseGenTableColumn,
  266. GenTableColumn,
  267. GenTableColumnQuery
  268. } from "../../../api/back/BaseBackApi.ts";
  269. import {ElMessage} from "element-plus";
  270. import {Delete, Plus, RefreshLeft} from "@element-plus/icons-vue";
  271. import router from "../../../router";
  272. import {store} from "../../../state/TokenState.ts";
  273. import DictTag from "../../../components/dict/DictTag.vue";
  274. import MultipleTag from "../../../components/MultipleTag/MultipleTag.vue";
  275. import ImageUpload from "../../../components/ImageUpload/ImageUpload.vue";
  276. let listLoading = ref(true)
  277. let total = ref(0)
  278. let pageNum = ref(1)
  279. let pageSize = ref(10)
  280. let list = ref<GenTableColumn[]>([])
  281. let ListKey = ref(0)
  282. //搜索用
  283. //let search = ref<GenTableColumn>(GenTableColumn.Create())
  284. //修改,添加用
  285. let open = ref(false)
  286. let dialogType = ref("")//save添加,update修改
  287. let dialogForm = ref<GenTableColumn>(null)
  288. let query = ref<GenTableColumnQuery>(GenTableColumnQuery.Create())
  289. let selectItems = ref<GenTableColumn[]>([])
  290. const selected = (arr: GenTableColumn[]) => {
  291. selectItems.value = arr
  292. }
  293. getList()
  294. const SetPageSized = (val: number) => {
  295. pageSize.value = val
  296. getList(pageNum.value)
  297. }
  298. function openDialog(type: string, row: GenTableColumn) {
  299. open.value = true
  300. dialogType.value = type
  301. if (type==="save"){
  302. dialogForm.value = GenTableColumn.Create()
  303. return
  304. }
  305. //深拷贝,不会影响数据
  306. dialogForm.value = JSON.parse(JSON.stringify(row))
  307. }
  308. function deleteByIds() {
  309. for (let i = 0; i < selectItems.value.length; i++) {
  310. deleteById(selectItems[i].id)
  311. }
  312. }
  313. function deleteById(id) {
  314. DeleteBaseGenTableColumnById(id).then(response => {
  315. if (response.code == 200) {
  316. ElMessage.success("删除成功,id:" + id)
  317. getList()
  318. } else {
  319. ElMessage.error("删除失败,id:" + id)
  320. }
  321. })
  322. }
  323. function getList(pn = 1) {
  324. pageNum.value = pn
  325. GetBaseGenTableColumnListByGenTableColumn(query.value, pageNum.value, pageSize.value).then(response => {
  326. let data = response.data
  327. total.value = data.total
  328. list.value = response.data.list
  329. ListKey.value++
  330. listLoading.value = false
  331. })
  332. }
  333. function submitForm() {
  334. switch (dialogType.value) {
  335. case "update":
  336. UpdateBaseGenTableColumn(dialogForm.value, dialogForm.value.id).then(response => {
  337. if (response.code == 200) {
  338. open.value = false
  339. getList()
  340. ElMessage.success("修改成功")
  341. } else {
  342. ElMessage.error("修改失败")
  343. }
  344. })
  345. break
  346. case "save":
  347. SaveBaseGenTableColumn(dialogForm.value).then(response => {
  348. if (response.code == 200) {
  349. open.value = false
  350. getList()
  351. ElMessage.success("添加成功")
  352. } else {
  353. ElMessage.error("添加失败")
  354. }
  355. })
  356. break
  357. default:
  358. break
  359. }
  360. }
  361. </script>