index.vue 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220
  1. <template>
  2. <div class="table-container">
  3. <vab-query-form>
  4. <div class="title">
  5. <div class="left">
  6. <div class="left-item">
  7. <div style="width: 70px;">名称:</div>
  8. <el-input v-model="fuzzyQuery_name" placeholder="请输入" clearable />
  9. </div>
  10. <el-button icon="el-icon-search" type="primary" native-type="submit" @click="fetchData">
  11. 查询
  12. </el-button>
  13. </div>
  14. <div class="right">
  15. <el-button icon="el-icon-plus" type="primary" @click="handleAdd">
  16. 添加成功
  17. </el-button>
  18. <el-button icon="el-icon-delete" type="danger" @click="handleDelete">
  19. 删除
  20. </el-button>
  21. <UploadExcel style="margin-left: 10px;" @getResult="getMyExcelData"></UploadExcel>
  22. <ExportExcel :exportList="exportExcel" :useType="'export'" partsName="变电所"></ExportExcel>
  23. <ExportExcel :exportList="templateExcel" :useType="'template'" partsName="变电所模板"></ExportExcel>
  24. </div>
  25. </div>
  26. <el-table ref="tableSort" v-loading="listLoading" :data="list" :element-loading-text="elementLoadingText"
  27. :height="height" @selection-change="setSelectRows">
  28. <el-table-column show-overflow-tooltip type="selection" width="40"></el-table-column>
  29. <el-table-column show-overflow-tooltip label="id" prop="id" align="center" sortable></el-table-column>
  30. <el-table-column show-overflow-tooltip label="编码" prop="code" align="center" sortable></el-table-column>
  31. <el-table-column show-overflow-tooltip label="名称" prop="name" align="center" sortable></el-table-column>
  32. <el-table-column show-overflow-tooltip label="别名" prop="aname" align="center" sortable>
  33. </el-table-column>
  34. <el-table-column show-overflow-tooltip label="风场编号" prop="windpowerstationid" align="center" sortable>
  35. </el-table-column>
  36. <el-table-column show-overflow-tooltip label="顺序" prop="ordernum" align="center" sortable></el-table-column>
  37. <el-table-column show-overflow-tooltip label="操作" width="100px" fixed="right">
  38. <template #default="{ row }">
  39. <el-button type="text" @click="handleEdit(row)">编辑</el-button>
  40. <el-button type="text" @click="handleDelete(row)">删除</el-button>
  41. </template>
  42. </el-table-column>
  43. </el-table>
  44. <el-pagination :background="background" :current-page="queryForm.pageNo" :layout="layout"
  45. :page-size="queryForm.pageSize" :total="total" @current-change="handleCurrentChange"
  46. @size-change="handleSizeChange"></el-pagination>
  47. <table-edit ref="edit" :options="options" :stationList="stationList" @save-success="fetchData"></table-edit>
  48. </vab-query-form>
  49. </div>
  50. </template>
  51. <script>
  52. import UploadExcel from '@/components/UploadExcel/index'
  53. import ExportExcel from '@/components/ExportExcel/index'
  54. import api from '@/api/realtimeDatabaseConfiguration'
  55. import stationApi from '@/api/station'
  56. import TableEdit from './components/TableEdit'
  57. export default {
  58. components: {
  59. UploadExcel,
  60. ExportExcel,
  61. TableEdit,
  62. },
  63. data() {
  64. return {
  65. fuzzyQuery_name: '',
  66. listLoading: true,
  67. list: [],
  68. options: [],
  69. exportExcel: [],
  70. templateExcel: [],
  71. elementLoadingText: '正在加载...',
  72. selectRows: '',
  73. layout: 'total, sizes, prev, pager, next, jumper',
  74. total: 0,
  75. background: true,
  76. exportList: [],
  77. queryForm: {
  78. pageNo: 1,
  79. pageSize: 20,
  80. },
  81. stationList: [],
  82. selectValue: ''
  83. };
  84. },
  85. computed: {
  86. height() {
  87. return this.$baseTableHeight() + 50
  88. },
  89. },
  90. created() {
  91. this.getStation()
  92. this.fetchData()
  93. },
  94. methods: {
  95. getMyExcelData(val) {
  96. val.forEach(item => {
  97. api.addWindsubstation(item).then(res => {
  98. if (res.code == 200) {
  99. this.$message({
  100. type: 'success',
  101. message: '添加成功!'
  102. });
  103. this.fetchData()
  104. }
  105. })
  106. })
  107. },
  108. getStation() {
  109. stationApi.windpowerstationList({
  110. id: '',
  111. name: '',
  112. companyid: '',
  113. pageNum: 1,
  114. pageSize: 1000,
  115. }).then(res => {
  116. if (res.data) {
  117. this.listLoading = false
  118. this.stationList = res.data.records
  119. }
  120. })
  121. },
  122. fetchData() {
  123. api.windsubstation({
  124. name: this.fuzzyQuery_name,
  125. pageNum: this.queryForm.pageNo,
  126. pageSize: this.queryForm.pageSize,
  127. }).then(res => {
  128. if (res.data) {
  129. this.listLoading = false
  130. this.total = res.data.total
  131. this.list = res.data.records
  132. this.templateExcel = [
  133. {
  134. id: '',
  135. code: '',
  136. name: '',
  137. aname: '',
  138. windpowerstationid: '',
  139. ordernum: ''
  140. }
  141. ]
  142. // 导出
  143. let exportExcel = []
  144. res.data.records.forEach(item => {
  145. exportExcel.push({
  146. id: item.id,
  147. code: item.code,
  148. name: item.name,
  149. aname: item.aname,
  150. windpowerstationid: item.windpowerstationid,
  151. ordernum: item.ordernum
  152. })
  153. })
  154. this.exportExcel = exportExcel
  155. }
  156. })
  157. },
  158. handleSizeChange(val) {
  159. this.queryForm.pageSize = val
  160. this.fetchData()
  161. },
  162. handleCurrentChange(val) {
  163. this.queryForm.pageNo = val
  164. this.fetchData()
  165. },
  166. handleAdd() {
  167. this.$refs['edit'].showEdit()
  168. },
  169. handleEdit(row) {
  170. this.$refs['edit'].showEdit(row)
  171. },
  172. handleDelete(row) {
  173. if (row.id || this.selectRows.length > 0) {
  174. this.$baseConfirm('你确定要删除吗', null, async () => {
  175. let ids = ''
  176. if (this.selectRows.length > 0) {
  177. ids = this.selectRows.map((item) => item.id).join()
  178. }
  179. api.deleteWindsubstation({
  180. id: row.id || ids
  181. }).then(res => {
  182. if (res.data) {
  183. this.$baseMessage('删除成功', 'success')
  184. this.fetchData()
  185. }
  186. })
  187. })
  188. } else {
  189. this.$baseMessage('未选中任何行', 'error')
  190. return false
  191. }
  192. },
  193. setSelectRows(val) {
  194. this.selectRows = val
  195. },
  196. },
  197. }
  198. </script>
  199. <style lang="less" scoped>
  200. .title {
  201. display: flex;
  202. flex-direction: row;
  203. align-items: center;
  204. justify-content: space-between;
  205. margin-bottom: 20px;
  206. }
  207. .left {
  208. display: flex;
  209. flex-direction: row;
  210. align-items: center;
  211. .left-item {
  212. display: flex;
  213. flex-direction: row;
  214. align-items: center;
  215. margin-right: 10px;
  216. }
  217. }
  218. </style>