<template>
|
<div ref="boxOutWrap" class="boxOutWrap">
|
<div ref="boxForm" class="boxForm">
|
<a-card :bordered="false" :bodyStyle="tstyle">
|
@{var index = 0;}
|
@if(Model.QueryWhetherList.Count > 0){
|
<text>
|
<div class="table-page-search-wrapper" v-if="hasPerm('@Model.ClassName:page')">
|
<a-form layout="inline">
|
<a-row :gutter="48"></text>
|
foreach (var column in Model.QueryWhetherList){
|
index++;
|
if(@index == 3){
|
<text><template v-if="advanced"></text>
|
}
|
if(@column.EffectType == "input" || @column.EffectType == "textarea"){
|
if(@index >= 3){
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-input v-model="queryParam.@column.LowerColumnName" allow-clear placeholder="请输入@(@column.ColumnComment)"/>
|
</a-form-item>
|
</a-col></text>
|
} else {
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-input v-model="queryParam.@column.LowerColumnName" allow-clear placeholder="请输入@(@column.ColumnComment)"/>
|
</a-form-item>
|
</a-col></text>
|
}
|
}else if(@column.EffectType == "inputnumber"){
|
if(@index >= 3){
|
<text><a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-input-number v-model="queryParam.@column.LowerColumnName" style="width: 100%" allow-clear placeholder="请输入@(@column.ColumnComment)"/>
|
</a-form-item>
|
</a-col></text>
|
} else {
|
<text><a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-input-number v-model="queryParam.@column.LowerColumnName" style="width: 100%" allow-clear placeholder="请输入@(@column.ColumnComment)"/>
|
</a-form-item>
|
</a-col></text>
|
}
|
}else if(@column.EffectType == "select" || @column.EffectType == "radio"){
|
if(@index >= 3){
|
<text><a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-select :allowClear="true" style="width: 100%" v-model="queryParam.@column.LowerColumnName" placeholder="请选择@(@column.ColumnComment)">
|
<a-select-option v-for="(item,index) in @(@column.LowerColumnName)Data" :key="index" :value="item.code">{{ item.name }}</a-select-option>
|
</a-select>
|
</a-form-item>
|
</a-col></text>
|
} else {
|
<text><a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-select :allowClear="true" style="width: 100%" v-model="queryParam.@column.LowerColumnName" placeholder="请选择@(@column.ColumnComment)">
|
<a-select-option v-for="(item,index) in @(@column.LowerColumnName)Data" :key="index" :value="item.code">{{ item.name }}</a-select-option>
|
</a-select>
|
</a-form-item>
|
</a-col></text>
|
}
|
}else if(@column.EffectType == "switch"){
|
if(@index >= 3){
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-select :allowClear="true" style="width: 100%" v-model="queryParam.@column.LowerColumnName" placeholder="请选择@(@column.ColumnComment)">
|
<a-select-option v-for="(item,index) in @(@column.LowerColumnName)Data" :key="index" :value="item.code">{{ item.name }}</a-select-option>
|
</a-select>
|
</a-form-item>
|
</a-col>
|
</text>
|
} else {
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-select :allowClear="true" style="width: 100%" v-model="queryParam.@column.LowerColumnName" placeholder="请选择@(@column.ColumnComment)">
|
<a-select-option v-for="(item,index) in @(@column.LowerColumnName)Data" :key="index" :value="item.code">{{ item.name }}</a-select-option>
|
</a-select>
|
</a-form-item>
|
</a-col>
|
</text>
|
}
|
}
|
|
else if(@column.EffectType == "datetimepicker"){
|
<!--年月日时分秒-->
|
if(@column.QueryType != "between"){
|
if(@index >= 3){
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-date-picker style="width: 100%" placeholder="请选择@(@column.ColumnComment)" v-model="queryParam.@(@column.LowerColumnName)" :show-time="{
|
format: 'HH:mm:ss', defaultValue: [moment('00:00:00', 'HH:mm:ss'),moment('23:59:59', 'HH:mm:ss')]}" value-format="YYYY-MM-DD HH:mm:ss" format="YYYY-MM-DD HH:mm:ss" @@change="onChange@(@column.LowerColumnName)"/>
|
</a-form-item>
|
</a-col>
|
</text>
|
} else {
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-date-picker style="width: 100%" placeholder="请选择@(@column.ColumnComment)" :show-time="{
|
format: 'HH:mm:ss', defaultValue: [moment('00:00:00', 'HH:mm:ss'),moment('23:59:59', 'HH:mm:ss')]}" v-model="queryParam.@(@column.LowerColumnName)" value-format="YYYY-MM-DD HH:mm:ss" format="YYYY-MM-DD HH:mm:ss" @@change="onChange@(@column.LowerColumnName)"/>
|
</a-form-item>
|
</a-col>
|
</text>
|
}
|
}else{
|
<!--时间范围-->
|
if(@index >= 3){
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-range-picker style="width: 100%" :placeholder="['开始时间', '结束时间']" :show-time="{
|
format: 'HH:mm:ss', defaultValue: [moment('00:00:00', 'HH:mm:ss'),moment('23:59:59', 'HH:mm:ss')]}" v-model="queryParam.@(@column.LowerColumnName)" value-format="YYYY-MM-DD HH:mm:ss" format="YYYY-MM-DD HH:mm:ss" @@change="onChange@(@column.LowerColumnName)"/>
|
|
</a-form-item>
|
</a-col>
|
</text>
|
} else {
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-range-picker style="width: 100%" :placeholder="['开始时间', '结束时间']" :show-time="{
|
format: 'HH:mm:ss', defaultValue: [moment('00:00:00', 'HH:mm:ss'),moment('23:59:59', 'HH:mm:ss')]}" v-model="queryParam.@(@column.LowerColumnName)" value-format="YYYY-MM-DD HH:mm:ss" format="YYYY-MM-DD HH:mm:ss" @@change="onChange@(@column.LowerColumnName)"/>
|
</a-form-item>
|
</a-col>
|
</text>
|
}
|
}
|
|
|
}
|
else if(@column.EffectType == "datepicker"){
|
|
if(@column.QueryType != "between"){
|
if(@index >= 3){
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-date-picker style="width: 100%" placeholder="请选择@(@column.ColumnComment)" v-model="queryParam.@(@column.LowerColumnName)" @@change="onChange@(@column.LowerColumnName)"/>
|
</a-form-item>
|
</a-col>
|
</text>
|
} else {
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-date-picker style="width: 100%" placeholder="请选择@(@column.ColumnComment)" v-model="queryParam.@(@column.LowerColumnName)" @@change="onChange@(@column.LowerColumnName)"/>
|
</a-form-item>
|
</a-col>
|
</text>
|
}
|
}else{
|
<!--时间范围-->
|
if(@index >= 3){
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-range-picker style="width: 100%" :placeholder="['开始时间', '结束时间']" v-model="queryParam.@(@column.LowerColumnName)" @@change="onChange@(@column.LowerColumnName)"/>
|
|
</a-form-item>
|
</a-col>
|
</text>
|
} else {
|
<text>
|
<a-col :md="8" :sm="24">
|
<a-form-item label="@column.ColumnComment">
|
<a-range-picker style="width: 100%" :placeholder="['开始时间', '结束时间']" v-model="queryParam.@(@column.LowerColumnName)" @@change="onChange@(@column.LowerColumnName)"/>
|
</a-form-item>
|
</a-col>
|
</text>
|
}
|
|
}
|
}
|
}
|
if(Model.QueryWhetherList.Count > 2){
|
</template>
|
}if(Model.QueryWhetherList.Count > 2){
|
<text>
|
<a-col :md="8" :sm="24" >
|
<span class="table-page-search-submitButtons">
|
<a-button type="primary" @@click="$refs.table.refresh(true)" >查询</a-button>
|
<a-button style="margin-left: 8px" @@click="() => queryParam = {}">重置</a-button>
|
<a @@click="toggleAdvanced" style="margin-left: 8px"> {{ advanced ? '收起' : '展开' }}
|
<a-icon :type="advanced ? 'up' : 'down'"/>
|
</a>
|
</span>
|
</a-col></text>
|
} else {
|
<text><a-col :md="8" :sm="24">
|
<span class="table-page-search-submitButtons">
|
<a-button type="primary" @@click="$refs.table.refresh(true)">查询</a-button>
|
<a-button style="margin-left: 8px" @@click="() => queryParam = {}">重置</a-button>
|
</span>
|
</a-col></text>
|
}
|
<text>
|
</text>
|
</a-row>
|
</a-form>
|
</div>
|
}
|
</a-card>
|
</div>
|
<a-card :bordered="false">
|
<s-table
|
ref="table"
|
:columns="columns"
|
:data="loadData"
|
:alert="true"
|
@@changeTablePage="pageInfo = $event"
|
:scroll="{x: true,y:tableHeight}"
|
@foreach (var column in Model.TableField){
|
if (@column.ColumnKey == "True"){
|
@::rowKey="(record) => record.@column.LowerColumnName"
|
}
|
}
|
:rowSelection="{ selectedRowKeys: selectedRowKeys, onChange: onSelectChange }">
|
<template class="table-operator" slot="operator" v-if="hasPerm('@Model.ClassName:add')" >
|
<div ref="actionBar" class="actionBar">
|
@if(@Model.IsWhetherImport == true && @Model.IsOnlyQuery !=true){
|
<a-button type="info" v-if="hasPerm('sysExcelTemplate:importExcel')" icon="upload" @@click="$refs.excelForm.index()">
|
导入
|
</a-button>
|
}
|
<a-button type="info" v-if="hasPerm('@Model.ClassName:exportExcel')" icon="download" @@click="@(@Model.ClassName)ToExcel()">
|
导出
|
</a-button>
|
@if( @Model.IsOnlyQuery !=true){
|
<a-button type="primary" v-if="hasPerm('@Model.ClassName:add')" icon="plus" @@click="$refs.addForm.add()">新增@(@Model.BusName)</a-button>
|
}
|
</div>
|
</template>
|
@foreach (var column in Model.TableField){
|
if(@column.WhetherTable == "Y"){
|
if(@column.WhetherRetract == "Y" || @column.EffectType == "select" || @column.EffectType == "radio" || @column.EffectType == "checkbox" ||@column.EffectType == "switch"){
|
@:<span slot="@(@column.LowerColumnName)scopedSlots" slot-scope="text">
|
if(@column.WhetherRetract == "Y" && (@column.EffectType == "select" || @column.EffectType == "radio" || @column.EffectType == "checkbox")){
|
@:<ellipsis :length="10" tooltip>{{ '@column.DictTypeCode' | dictType(text) }}</ellipsis>
|
}else if(@column.WhetherRetract == "Y"){
|
@:<ellipsis :length="10" tooltip>{{ text }}</ellipsis>
|
}else if(@column.EffectType == "checkbox"){
|
@:<a-tag v-for="textData in JSON.parse(text)" :key="textData.code" color="green">{{ '@column.DictTypeCode' | dictType(textData) }}</a-tag>
|
}
|
else if (@column.EffectType == "switch"){
|
<div v-if="text===true ">
|
<a-tag color="green">是</a-tag>
|
</div>
|
<div v-else-if="text==false">
|
<a-tag color="volcano">否</a-tag>
|
</div>
|
<div v-else=""></div>
|
}
|
else {
|
@:{{ '@column.DictTypeCode' | dictType(text) }}
|
}
|
@:</span>
|
}
|
}
|
}
|
@if( @Model.IsOnlyQuery !=true){
|
<span slot="action" slot-scope="text, record">
|
|
<a v-if="hasPerm('@Model.ClassName:edit')" @@click="$refs.editForm.edit(record)">编辑</a>
|
<a-divider type="vertical" v-if="hasPerm('@Model.ClassName:edit') & hasPerm('@Model.ClassName:delete')"/>
|
<a-popconfirm v-if="hasPerm('@Model.ClassName:delete')" placement="topRight" title="确认删除？" @@confirm="() => @(@Model.ClassName)Delete(record)">
|
<a>删除</a>
|
</a-popconfirm>
|
</span>
|
}
|
</s-table>
|
<add-form ref="addForm" @@ok="handleOk" />
|
<edit-form ref="editForm" @@ok="handleOk" />
|
<excel-form ref="excelForm" @@ok="handleOk" />
|
</a-card>
|
</div>
|
</template>
|
<script>
|
@{
|
var columnData = 0;
|
var Ellipsis = "N";
|
var DateQuery = "N";
|
}
|
@foreach (var column in Model.TableField){
|
if(@column.WhetherTable == "Y"){
|
if(@column.WhetherRetract == "Y")
|
Ellipsis="Y";
|
columnData++;
|
}
|
if(@column.QueryWhether == "Y"){
|
if(@column.EffectType == "datepicker"||@column.EffectType == "datetimepicker")
|
DateQuery="Y";
|
}
|
}
|
@if(Ellipsis == "Y"){
|
@:import { STable, Ellipsis } from '@@/components'
|
} else {
|
@:import { STable } from '@@/components'
|
}
|
@if(DateQuery == "Y"){
|
@:import moment from 'moment'
|
}
|
import { @(@Model.ClassName)Page, @(@Model.ClassName)Delete, @(@Model.ClassName)ToExcel } from '@@/api/modular/main/@(@Model.ModuleName)/@(@Model.ClassName)Manage'
|
//自定义table高度
|
import setTableHtMixin from '@@/mixins/handleTableHt.js'
|
import addForm from './addForm.vue'
|
import { exportExcel } from '@@/utils/exportToExcel'
|
import { downloadFile } from '@@/utils/util'
|
import editForm from './editForm.vue'
|
import excelForm from './excelForm.vue'
|
export default {
|
mixins: [setTableHtMixin],
|
components: {
|
@if(Ellipsis == "Y")
|
@:Ellipsis,
|
STable,
|
addForm,
|
editForm,
|
excelForm
|
},
|
data () {
|
return {
|
@if(Model.QueryWhetherList.Count > 2){
|
@:advanced: false, // 高级搜索 展开/关闭
|
}
|
queryParam: {},
|
pageInfo: {
|
current: 1,
|
pageSize: 10
|
},
|
columns: [
|
{
|
title:'序号',
|
width: '60px',
|
align: 'center',
|
customRender: (text, record, index) => `${index + 1 + (this.pageInfo.current - 1) * this.pageInfo.pageSize}`
|
},
|
@{var columnDataColumns = 0;}
|
@foreach (var column in Model.TableField){
|
if (@column.WhetherTable == "Y"){
|
columnDataColumns++;
|
@:{
|
@:title: '@column.ColumnComment',
|
@:align: 'center',
|
|
@:customHeaderCell: () => {
|
@:return {
|
@: style: {
|
@:'min-width': '@column.ShowTitleMinWidth'//最小列宽设置
|
@: }
|
@: }
|
@:},
|
|
@:customCell: () => {
|
@:return {
|
@:style: {
|
@:'min-width': '@column.ShowTitleMinWidth'//最小列宽设置
|
@:}
|
@:}
|
@:},
|
|
if (@column.WhetherOrderBy == "Y"){
|
@:sorter: true,
|
}
|
|
if(@column.EffectType == "datepicker"){
|
@:customRender: (value) => (value ? value.split(" ")[0] : value),//时间截取 不要时分秒
|
@:customCutout:true,//时间截取 不要时分秒
|
}
|
|
if(@column.EffectType == "fk"){
|
@:customRender: (value, record) => record.@(@column.LowerFkEntityName).@(@column.LowerFkLowerColumnName),
|
}
|
|
if(@column.WhetherRetract == "Y" || @column.EffectType == "select" || @column.EffectType == "radio" || @column.EffectType == "checkbox" || @column.EffectType == "switch"){
|
@:dataIndex: '@column.LowerColumnName',
|
@:scopedSlots: { customRender: '@(@column.LowerColumnName)scopedSlots' }
|
} else {
|
@:dataIndex: '@column.LowerColumnName'
|
}
|
if(columnDataColumns != columnData){
|
@:},
|
} else {
|
@:}
|
}
|
}
|
}
|
],
|
tstyle: { 'padding-bottom': '0px', 'margin-bottom': '10px' },
|
// 加载数据方法 必须为 Promise 对象
|
loadData: parameter => {
|
@if(DateQuery == "Y"){
|
@:return @(@Model.ClassName)Page(Object.assign(parameter, this.switchingDate())).then((res) => {
|
} else {
|
@:return @(@Model.ClassName)Page(Object.assign(parameter, this.queryParam)).then((res) => {
|
}
|
return res.data
|
})
|
},
|
@foreach (var column in Model.TableField){
|
if(@column.QueryWhether == "Y"){
|
if(@column.EffectType == "select" || @column.EffectType == "radio"){
|
if(@column.DictTypeCode != "")
|
@: @(@column.LowerColumnName)Data: [],
|
}
|
}
|
}
|
selectedRowKeys: [],
|
selectedRows: []
|
}
|
},
|
created () {
|
@if(Model.IsOnlyQuery !=true){
|
@:if (this.hasPerm('@Model.ClassName:edit') || this.hasPerm('@Model.ClassName:delete')) {
|
@:this.columns.push({
|
@:title: '操作',
|
@:width: '150px',
|
@:dataIndex: 'action',
|
@:scopedSlots: { customRender: 'action' }
|
@:})
|
@:}
|
}
|
const path = this.$route.path
|
const columnStr = window.localStorage.getItem(path)
|
if(columnStr) {
|
var _columns = JSON.parse(columnStr)
|
this.columns.forEach(element => {
|
var fObj = _columns.find((item, index) => {
|
return item.dataIndex === element.dataIndex;
|
})
|
if(fObj!=undefined && fObj!=null){
|
element.checked=fObj.checked;
|
}
|
});
|
}
|
@foreach (var column in Model.TableField){
|
if(@column.QueryWhether == "Y"){
|
|
if(@column.EffectType == "select" || @column.EffectType == "radio"){
|
if(@column.DictTypeCode != ""){
|
@:const @(@column.LowerColumnName)Option = this.$options
|
@:this.@(@column.LowerColumnName)Data = @(@column.LowerColumnName)Option.filters['dictData']('@column.DictTypeCode')
|
}
|
}
|
|
if(@column.EffectType == "switch"){
|
@:const @(@column.LowerColumnName)Option = this.$options
|
@:this.@(@column.LowerColumnName)Data = @(@column.LowerColumnName)Option.filters['dictData']('yes_true_false')
|
}
|
|
}
|
}
|
|
this.handleTableHt() //设置主表表格高度
|
window.addEventListener(
|
'resize',
|
() => {
|
this.handleTableHt() // 监听屏幕大小改变表格高度
|
},
|
false
|
)
|
|
},
|
methods: {
|
@if(DateQuery == "Y"){
|
@:moment,
|
}
|
/**
|
* 查询参数组装
|
*/
|
switchingDate () {
|
const obj = JSON.parse(JSON.stringify(this.queryParam))
|
return obj
|
},
|
@(@Model.ClassName)Delete (record) {
|
@(@Model.ClassName)Delete(record).then((res) => {
|
if (res.success) {
|
this.$message.success('删除成功')
|
this.$refs.table.refresh()
|
} else {
|
this.$message.error('删除失败') // + res.message
|
}
|
})
|
},
|
|
|
@(@Model.ClassName)ToExcel() {
|
this.loading = true
|
let entozh = {};
|
const path = this.$route.path;
|
if (window.localStorage.getItem(path)) {
|
JSON.parse(window.localStorage.getItem(path)).forEach(item => {
|
if (item.dataIndex != 'action' && item.checked) {
|
entozh[item.dataIndex] = item.title
|
}
|
})
|
} else { //直接点导出
|
this.columns.forEach(item => {
|
if (item.dataIndex != 'action') {
|
entozh[item.dataIndex] = item.title
|
}
|
})
|
}
|
@(@Model.ClassName)Page(Object.assign({ pageSize: 100000, pageIndex: 1 }, this.queryParam)).then((res) => {
|
this.loading = false;
|
//需要截取日期的字段
|
var arrDataCutout = this.columns.filter(v => v.customCutout == true);
|
res.data.rows.forEach(item => {
|
var arrKeys = Object.keys(item);
|
arrKeys.forEach(key => {
|
var strFieldDic = key + 'Data';
|
//枚举转值
|
if (this[strFieldDic] && this[strFieldDic].length > 0) {
|
let arrFieldDic = this[strFieldDic].filter(v => String(v.code) == String(item[key]));
|
if (arrFieldDic.length > 0) {
|
item[key] = arrFieldDic[0]?.name || '没有枚举值';
|
}
|
}
|
// 日期截取
|
if (arrDataCutout.length > 0) {
|
arrDataCutout.forEach(itemIn => {
|
if (key == itemIn.dataIndex && item[key]) {
|
item[key] = item[key].split(" ")[0]
|
}
|
})
|
}
|
});
|
})
|
exportExcel(res.data.rows, entozh, "xlsx", `${this.$route.meta.title}`)
|
}).catch((err) => {
|
this.loading = false
|
this.$message.error('下载错误：获取文件流错误' + err)
|
})
|
},
|
|
|
@if(Model.QueryWhetherList.Count > 2){
|
@:toggleAdvanced () {
|
@:this.advanced = !this.advanced
|
@:this.handleTableHt() //设置主表表格高度
|
@:},
|
}
|
@foreach (var column in Model.QueryWhetherList){
|
if(@column.QueryWhether == "Y"){
|
if(@column.EffectType == "datepicker" || @column.EffectType == "datetimepicker"){
|
@:onChange@(@column.LowerColumnName)(date, dateString) {
|
@: this.queryParam.@(@column.LowerColumnName) = dateString
|
@:},
|
|
}
|
}
|
}
|
handleOk () {
|
this.$refs.table.refresh()
|
},
|
onSelectChange (selectedRowKeys, selectedRows) {
|
this.selectedRowKeys = selectedRowKeys
|
this.selectedRows = selectedRows
|
}
|
}
|
}
|
</script>
|
<style lang="less">
|
.table-operator {
|
margin-bottom: 18px;
|
}
|
button {
|
margin-right: 8px;
|
}
|
</style>
|
