AiDOPWarehouse/Admin.NET/Admin.NET.Web.Entry/wwwroot/template/index.vue.vm

@{
  string LowerFirstLetter(string text) => text.ToString()[..1].ToLower() + text[1..];

  string getDropdownName(dynamic column) => $"{column.FkEntityName}{Regex.Replace(column.PropertyName, "[iI]d$", "")}Dropdown";

  var pkField = Model.TableField.Where(c => c.ColumnKey == "True").FirstOrDefault();

  string pkFieldName = pkField != null && !string.IsNullOrEmpty(pkField.PropertyName) ? LowerFirstLetter(pkField.PropertyName) : null;

  var definedObjects = new Dictionary<string, int>();

  bool hasImport = Model.TableField.Any(x => x.WhetherImport == "Y");

  bool haveLikeCdt = Model.TableField.Any(col => col.WhetherQuery == "Y" && col.QueryType == "like");

  var hasSetStatus = Model.TableField.Any(col => col.NetType == "StatusEnum" && col.PropertyName == "Status");

  var isStatus = false;
}
<template>
  <div class="@(Model.LowerClassName)-container">
    <el-card shadow="hover" :body-style="{ paddingBottom: '0' }"> 
      <el-form :model="queryParams" ref="queryForm" labelWidth="90">
        <el-row>
          @if(Model.QueryWhetherList.Count > 0){
          if(haveLikeCdt){
          @:<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10">
            @:<el-form-item label="关键字">
              @:<el-input v-model="queryParams.keyword" clearable placeholder="请输入模糊查询关键字"/>
            @:</el-form-item>
          @:</el-col>
          }
          foreach (var column in Model.QueryWhetherList){
          @:<el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUI">
            if(column.EffectType == "Input" || column.EffectType == "InputTextArea"){
            @:<el-form-item label="@column.ColumnComment">
              @:<el-input v-model="queryParams.@(column.LowerPropertyName)" clearable placeholder="请输入@(column.ColumnComment)"/>
            @:</el-form-item>
            }else if(column.EffectType == "InputTextArea"){
            @:<el-form-item label="@column.ColumnComment">
              @:<el-input-number v-model="queryParams.@(column.LowerPropertyName)"  clearable placeholder="请输入@(column.ColumnComment)"/>
              @:
            @:</el-form-item>
            }else if(column.EffectType == "InputNumber"){
            @:<el-form-item label="@column.ColumnComment">
              @:<el-input-number v-model="queryParams.@(column.LowerPropertyName)"  clearable placeholder="请输入@(column.ColumnComment)"/>
            @:</el-form-item>
            }else if(column.EffectType == "ForeignKey"){
            @:<el-form-item label="@column.ColumnComment">
              @:<el-select clearable filterable v-model="queryParams.@(column.LowerPropertyName)" placeholder="请选择@(column.ColumnComment)">
                @:<el-option v-for="(item,index) in get@(getDropdownName(column))List" :key="index" :value="item.value" :label="item.label" />
              @:</el-select>
            @:</el-form-item>
            }else if(column.EffectType == "DictSelector" || column.EffectType == "EnumSelector"){
            @:<el-form-item label="@column.ColumnComment">
              @:<el-select clearable filterable v-model="queryParams.@(column.LowerPropertyName)" placeholder="请选择@(column.ColumnComment)">
                @:<el-option v-for="(item,index) in getDictDataByCode('@(column.DictTypeCode)')" :key="index" :value="item.code" :label="`[${item.code}]${item.value}`" />
              @:</el-select>
            @:</el-form-item>
            }else if(column.EffectType == "ApiTreeSelector"){
            @:<el-form-item label="@column.ColumnComment">
              @:<el-cascader
                  @::options="@LowerFirstLetter(@column.FkEntityName)TreeData"
                  @:@:props="{ checkStrictly: true, emitPath: false, value: '@LowerFirstLetter(@column.FkLinkColumnName)' }"
                  @:placeholder="请选择@(column.ColumnComment)"
                  @:clearable
                  @:filterable
                  @:class="w100"
                  @:v-model="queryParams.@(column.LowerPropertyName)"
                  @:>
                @:<template #default="{ node, data }">
                  @:<span>{{ data.label }}</span>
                  @:<span v-if="!node.isLeaf"> ({{ data.children.length }}) </span>
                @:</template>
              @:</el-cascader>
            @:</el-form-item>
            }else if(column.EffectType == "DatePicker"){
            @:<el-form-item label="@column.ColumnComment">
              if (column.QueryType == "~") {
              @:<el-date-picker type="daterange" v-model="queryParams.@(column.LowerPropertyName)Range"  value-format="YYYY-MM-DD HH:mm:ss" start-placeholder="开始日期" end-placeholder="结束日期" :default-time="[new Date('1 00:00:00'), new Date('1 23:59:59')]" />
              } else {
              @:<el-date-picker placeholder="请选择@(column.ColumnComment)" value-format="YYYY/MM/DD"  v-model="queryParams.@(column.LowerPropertyName)" />
              }
            @:</el-form-item>
            }
          @:</el-col>
          }
          }
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10">
            <el-form-item @(Model.QueryWhetherList.Count > 0?"":"label-width=\"0px\"")>
              <el-button-group style="display: flex; align-items: center;">
                <el-button type="primary"  icon="ele-Search" @@click="handleQuery" v-auth="'@(Model.LowerClassName):page'"> @(Model.QueryWhetherList.Count > 0 ? "查询" : "刷新") </el-button>
                @if (Model.QueryWhetherList.Count > 0) {
                @:<el-button icon="ele-Refresh" @@click="() => queryParams = {}"> 重置 </el-button>
                @if (haveLikeCdt) {
                @:<el-button icon="ele-ZoomIn" @@click="changeAdvanceQueryUI" v-if="!showAdvanceQueryUI" style="margin-left:5px;"> 高级查询 </el-button>
                @:<el-button icon="ele-ZoomOut" @@click="changeAdvanceQueryUI" v-if="showAdvanceQueryUI" style="margin-left:5px;"> 隐藏 </el-button>
                }
                }
                <el-button type="danger" style="margin-left:5px;" icon="ele-Delete" @@click="batchDel@(Model.ClassName)" :disabled="selectData.length == 0" v-auth="'@(Model.LowerClassName):batchDelete'"> 删除 </el-button>
                <el-button type="primary" style="margin-left:5px;" icon="ele-Plus" @@click="openAdd@(Model.ClassName)" v-auth="'@(Model.LowerClassName):add'"> 新增 </el-button>
                @if (hasImport) {
                @:<el-button type="warning" icon="ele-MostlyCloudy" @@click="importDataRef.openDialog()" v-auth="'@(Model.LowerClassName):import'"> 导入 </el-button>
                }
              </el-button-group>
            </el-form-item>
          </el-col>
        </el-row>
        @* 操作区另起一行
        @:<el-row>
          @:<el-col>
            @:<el-button-group style="margin-left:20px;margin-bottom:5px;">
              @:<el-button type="primary" icon="ele-Plus" @@click="openAdd@(Model.ClassName)" v-auth="'@(Model.LowerClassName):add'"> 新增 </el-button>
            </el-button-group>
          @:</el-col>
        @:</el-row>
		*@
      </el-form>
    </el-card>
    <el-card class="full-table" shadow="hover" style="margin-top: 5px">
      <el-table :data="tableData" @@selection-change="(val: any[]) => { selectData = val; }" style="width: 100%" v-loading="loading" tooltip-effect="light" @(pkFieldName != null ? $"row-key=\"{@pkFieldName}\"" : "") @@sort-change="sortChange" border>
        <el-table-column type="selection" width="40" align="center" v-auth="'@(Model.LowerClassName):batchDelete'" />
        <el-table-column type="index" label="序号" width="55" align="center"/>
        @foreach (var column in Model.TableField.Where(u => u.WhetherTable == "Y")){
        if(column.EffectType == "Upload"||@column.EffectType == "ForeignKey" || @column.EffectType == "ApiTreeSelector" || @column.EffectType == "Switch" || @column.EffectType == "ConstSelector"){
        @:<el-table-column prop="@column.LowerPropertyName" label="@column.ColumnComment" @(column.WhetherSortable == "Y" ? "sortable='custom'" : "") show-overflow-tooltip="">
          @:<template #default="scope">
            if(column.EffectType == "Upload"){
            @:<el-image
            @:v-if="scope.row.@column.LowerPropertyName"
            @:style="width: 60px; height: 60px"
            @::src="scope.row.@column.LowerPropertyName"
            @::lazy="true"
            @::hide-on-click-modal="true"
            @::preview-src-list="[scope.row.@column.LowerPropertyName]"
            @::initial-index="0"
            @:fit="scale-down"
            @:preview-teleported />
            }else if(column.EffectType == "ForeignKey"){
            @:<span>{{scope.row.@LowerFirstLetter(@column.PropertyName)FkColumn}}</span>
            }else if(column.EffectType == "ApiTreeSelector"){
            @:<span>{{scope.row.@LowerFirstLetter(@column.PropertyName)Display}}</span>
            }else if(column.EffectType == "Switch"){
            @:<el-tag v-if="scope.row.@(column.LowerPropertyName)"> 是 </el-tag>
            @:<el-tag type="danger" v-else> 否 </el-tag>
            }else if(column.EffectType == "ConstSelector"){
            @:<span>{{codeToName(scope.row.@(column.LowerPropertyName), '@(column.DictTypeCode)')}}</span>
            }
          @:</template>
        @:</el-table-column>
        } else if (column.EffectType == "DictSelector" || column.EffectType == "EnumSelector") {
        isStatus = column.NetType == "StatusEnum" && column.PropertyName == "Status";
        @:<el-table-column prop="@column.LowerPropertyName" label="@column.ColumnComment" @(column.WhetherSortable == "Y" ? "sortable='custom'" : "") show-overflow-tooltip @(isStatus ? $"v-auth=\"'{@Model.LowerClassName}:setStatus'\"": "")>
          @:<template #default="scope">
            if (isStatus) {
              @:<el-switch v-model="scope.row.@column.LowerPropertyName" :active-value="1" :inactive-value="2" size="small" @@change="change@(Model.ClassName)Status(scope.row)" />
            } else {
              @:<DictLabel :value="scope.row.@column.LowerPropertyName" code="@column.DictTypeCode" />
            }
          @:</template>
        @:</el-table-column>
        } else {
        @:<el-table-column prop="@column.LowerPropertyName" label="@column.ColumnComment" @(column.WhetherSortable == "Y" ? "sortable='custom'" : "") show-overflow-tooltip />
        }
        }
        <el-table-column label="修改记录" width="100" align="center" show-overflow-tooltip>
          <template #default="scope">
            <ModifyRecord :data="scope.row" />
          </template>
        </el-table-column>
        <el-table-column label="操作" width="@(Model.PrintType == "custom" ? "200" : "140")" align="center" fixed="right" show-overflow-tooltip v-if="auth('@(Model.LowerClassName):update') || auth('@(Model.LowerClassName):delete')">
          <template #default="scope">
            @if (Model.PrintType == "custom"){
            @:<el-button icon="ele-Printer" size="small" text type="primary" @@click="openPrint@(Model.ClassName)(scope.row)" v-auth="'@(Model.LowerClassName):print'"> 打印 </el-button>
            }
            <el-button icon="ele-Edit" size="small" text type="primary" @@click="openEdit@(Model.ClassName)(scope.row)" v-auth="'@(Model.LowerClassName):update'"> 编辑 </el-button>
            <el-button icon="ele-Delete" size="small" text type="primary" @@click="del@(Model.ClassName)(scope.row)" v-auth="'@(Model.LowerClassName):delete'"> 删除 </el-button>
          </template>
        </el-table-column>
      </el-table>
      <el-pagination
				v-model:currentPage="tableParams.page"
				v-model:page-size="tableParams.pageSize"
				:page-sizes="[10, 20, 50, 100, 200, 500]"
                :total="tableParams.total"
                @@size-change="handleSizeChange"
                @@current-change="handleCurrentChange"
                layout="total, sizes, prev, pager, next, jumper"
				size="small"
				background
      />
      <printDialog
        ref="printDialogRef"
        :title="print@(Model.ClassName)Title"
        @@reloadTable="handleQuery" />
      <editDialog
        ref="editDialogRef"
        :title="edit@(Model.ClassName)Title"
        @@reloadTable="handleQuery"
      />
    </el-card>
  </div>
  @if (hasImport) {
  @:<ImportData
        @:ref="importDataRef"
        @::import="@(Model.LowerClassName)Api.importData"
        @::download="@(Model.LowerClassName)Api.downloadTemplate"
        @:v-auth="'@(Model.LowerClassName):import'"
        @:@@refresh="handleQuery"
        @:/>
  }
</template>

<script lang="ts" setup name="@(Model.LowerClassName)">
  import { ref } from "vue";
  import { auth } from '/@@/utils/authFunction';
  import { getAPI } from '/@@/utils/axios-utils';
  import { ElMessageBox, ElMessage } from "element-plus";
  @if(Model.TableField.Any(x => x.EffectType == "DatePicker")) {
  @:import { formatDate } from '/@@/utils/formatTime';
  }
  @if(Model.TableField.Any(x => x.EffectType == "ConstSelector")) {
  @:import { codeToName, getConstType } from '/@@/utils/constHelper';
  }
  @if(Model.TableField.Any(x => x.EffectType == "DictSelector" || x.EffectType == "EnumSelector")) {
  @:import { useUserInfo } from "/@@/stores/userInfo";
  }
  @if(Model.PrintType == "custom") {
  @:// 推荐设置操作 width 为 200
  @:import { hiprint } from 'vue-plugin-hiprint';
  @:import { SysPrintApi } from '/@@/api-services/api';
  @:import { SysPrint } from '/@@/api-services/models';
  }
  @if(Model.TableField.Any(x => x.EffectType == "DictSelector" || x.EffectType == "EnumSelector")) {
  @:import DictLabel from "/@@/components/table/dictLabel.vue";
  }
  @if(hasImport) {
  @:import ImportData from "/@@/components/table/importData.vue";
  }
  import editDialog from '/@@/views/@(Model.PagePath)/@(Model.LowerClassName)/component/editDialog.vue'
  import printDialog from '/@@/views/system/print/component/hiprint/preview.vue'
  import ModifyRecord from '/@@/components/table/modifyRecord.vue';
  import { use@(Model.ClassName)Api} from '/@@/api/@(Model.PagePath)/@(Model.LowerClassName)';
  @if(Model.TableField.Any(x => x.EffectType == "DictSelector" || x.EffectType == "EnumSelector")) {
  @:const getDictDataByCode = useUserInfo().getDictDataByCode;
  }
  const showAdvanceQueryUI = ref(@(haveLikeCdt ? "false" : "true"));
  const @(Model.LowerClassName)Api = use@(Model.ClassName)Api();
  const printDialogRef = ref();
  const editDialogRef = ref();
  @if (hasImport){
  @:const importDataRef = ref();
  }
  const loading = ref(false);
  const tableData = ref<any>([]);
  const selectData = ref<any>([]);
  const queryParams = ref<any>({});
  const tableParams = ref({
    page: 1,
    pageSize: 10,
    field: 'createTime', // 默认的排序字段
    order: 'descending', // 排序方向
    descstr: 'descending', // 降序排序的关键字符
    total: 0 as any,
  });

  const print@(Model.ClassName)Title = ref("");
  const edit@(Model.ClassName)Title = ref("")

  // 改变高级查询的控件显示状态
  const changeAdvanceQueryUI = () => {
    showAdvanceQueryUI.value = !showAdvanceQueryUI.value;
  }

  // 查询操作
  const handleQuery = async () => {
    loading.value = true;
    var res = await @(Model.LowerClassName)Api.page(Object.assign(queryParams.value, tableParams.value));
    tableData.value = res.data.result?.items ?? [];
    tableParams.value.total = res.data.result?.total;
    loading.value = false;
  };

  // 列排序
  const sortChange = async (column: any) => {
	tableParams.value.field = column.prop;
	tableParams.value.order = column.order;
	await handleQuery();
  };

  // 打开新增页面
  const openAdd@(Model.ClassName) = () => {
    edit@(Model.ClassName)Title.value = '添加@(Model.BusName)';
    const data = {
@if (hasSetStatus) {
        @:status: 1,
}
@if (Model.TableField.Any(col => col.PropertyName == "OrderNo")) {
        @:orderNo: 100,
}
    };
    editDialogRef.value.openDialog(data);
  };

  // 设置状态
  const change@(Model.ClassName)Status = async (row: any) => {
    await @(Model.LowerClassName)Api.setStatus({ id: row.id, status: row.status })
            .then(() => ElMessage.success('状态设置成功'))
            .catch(() => { row.status = row.status == 1 ? 2 : 1; });
  };
  
  // 打开打印页面
  const openPrint@(Model.ClassName) = async (row: any) => {
    print@(Model.ClassName)Title.value = '打印@(Model.BusName)';
    @if(Model.PrintType == "custom"){
    @:var res = await getAPI(SysPrintApi).apiSysPrintPrintNameGet('@Model.PrintName');
	@:var printTemplate = res.data.result as SysPrint;
    @:var template = JSON.parse(printTemplate.template);
    @:row['printDate'] = formatDate(new Date(), 'YYYY-mm-dd HH:MM:SS')
    @:printDialogRef.value.showDialog(new hiprint.PrintTemplate({template: template}), row, template.panels[0].width);
    }
  }
  
  // 打开编辑页面
  const openEdit@(Model.ClassName) = (row: any) => {
    edit@(Model.ClassName)Title.value = '编辑@(Model.BusName)';
    editDialogRef.value.openDialog(row);
  };

  // 删除
  const del@(Model.ClassName) = (row: any) => {
    ElMessageBox.confirm(`确定要删除吗?`, "提示", {
    confirmButtonText: "确定",
    cancelButtonText: "取消",
    type: "warning",
  })
  .then(async () => {
    await @(Model.LowerClassName)Api.delete(row);
    handleQuery();
    ElMessage.success("删除成功");
  })
  .catch(() => {});
  };

  // 批量删除
  const batchDel@(Model.ClassName) = () => {
    ElMessageBox.confirm(`确定要删除${selectData.value.length}条记录吗?`, "提示", {
      confirmButtonText: "确定",
      cancelButtonText: "取消",
      type: "warning",
    }).then(async () => {
      @foreach (var column in @Model.TableField.Where(u => u.ColumnKey == "True")) {
      @:const count = await @(Model.LowerClassName)Api.batchDelete({ @(column.LowerPropertyName)List: selectData.value.map(u => u.@(column.LowerPropertyName)) });
      }
      handleQuery();
      ElMessage.success(`成功批量删除${count}条记录`);
    }).catch(() => {});
  };

  // 改变页面容量
  const handleSizeChange = (val: number) => {
    tableParams.value.pageSize = val;
    handleQuery();
  };

  // 改变页码序号
  const handleCurrentChange = (val: number) => {
    tableParams.value.page = val;
    handleQuery();
  };

@foreach (var column in Model.TableField) {
  if (column.EffectType == "ForeignKey") {
  var dropdownName = getDropdownName(column);
  @:const @LowerFirstLetter(dropdownName)List = ref<any>([]);
  @:const get@(dropdownName)List = async () => {
    @:let list = await @(Model.LowerClassName)Api.get@(dropdownName)();
    @:@(LowerFirstLetter(dropdownName))List.value = list.data.result ?? [];
  @:};
  @:get@(dropdownName)List();
  @:
  } else if (column.EffectType == "ApiTreeSelector" && !definedObjects.ContainsKey("define_get@(column.FkEntityName)TreeData")) {
  definedObjects.Add("define_get@(column.FkEntityName)TreeData", 1);
  @:const @LowerFirstLetter(@column.FkEntityName)TreeData = ref<any>([]);
  @:const get@(column.FkEntityName)TreeData = async () => {
    @:let list = await @(Model.LowerClassName)Api.get@(column.FkEntityName)Tree();
    @:@LowerFirstLetter(@column.FkEntityName)TreeData.value = list.data.result ?? [];
  @:};
  @:get@(column.FkEntityName)TreeData();
  @:
  } 
}
  handleQuery();
</script>
<style scoped>
:deep(.el-input), :deep(.el-select), :deep(.el-input-number) {
  width: 100%;
}
</style>