<el-tabsvalue="treeType"type="border-card">
  <el-tab-panename="treeType"label="按文件类型">
    <myTree:data="treeType"icon-class="el-icon-price-tag"@nodeClick="nodeTypeClick" />
  </el-tab-pane>
  <el-tab-panename="treeCategory"label="按类别名称">
    <myTree:data="treeCategory"icon-class="el-icon-price-tag"@nodeClick="nodeCategoryClick" />
  </el-tab-pane>
</el-tabs>

        /// <summary>
        ///获取所有类别(Distinct)/// </summary>
        /// <returns></returns>
        public virtual async Task<List<string>>GetAllCategory()

        {var query = Repository.GetAll().Where(s=> s.Category != null).OrderBy(s =>s.Category);var list = query.Select(s =>s.Category).Distinct().ToList();return awaitTask.FromResult(list);

        }

        public voidConfigure(IApplicationBuilder app, ILoggerFactory loggerFactory)

        {

            ............



            app.UseStaticFiles();//指定特定的目录作为静态文件目录，如UploadFiles//是否可以访问静态文件
            app.UseStaticFiles(newStaticFileOptions

            {

                FileProvider= new PhysicalFileProvider(Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, "UploadFiles")),

                RequestPath= "/UploadFiles"}); 



            .........

        /// <summary>
        ///对记录进行转义/// </summary>
        /// <param name="item">dto数据对象</param>
        /// <returns></returns>
        protected override voidConvertDto(FileUploadDto item)

        {//转义相对地址为绝对地址
            item.FileUrl =GetFileUrl(item.BasePath, item.SavePath);

        }

        /// <summary>
        ///根据记录的basePath和savePath，以及HttpContext上下文确定绝对路径/// </summary>
        /// <param name="basePath">附件的基础路径</param>
        /// <param name="savePath">附件的保存路径</param>
        /// <returns></returns>
        private string GetFileUrl(string basePath, stringsavePath)

        {var httpContext =_httpContext.HttpContext;string serverRealPath =basePath.UriCombine(savePath);if (!Path.IsPathRooted(basePath) &&
                !basePath.StartsWith("http://") &&
                !basePath.StartsWith("https://"))

            {//如果是相对目录，加上当前程序的目录才能定位文件地址
                var url = string.Format("{0}://{1}", httpContext.Request.Scheme, httpContext.Request.Host.Value);

                serverRealPath= url.UriCombine(serverRealPath).Replace('\\', '/');

            }returnserverRealPath;

        }

    <el-form-itemlabel="封面图片">
      <el-uploadref="upload"action="/abp/services/app/FileUpload/PostUpload"list-type="picture-card":on-preview="handlePictureCardPreview":on-remove="handleRemove":on-success="onSuccess":on-error="onError"accept="image/jpeg,image/gif,image/png,image/bmp":headers="myHeaders":file-list="editForm.fileList"
      >
        <iclass="el-icon-plus" />
      </el-upload>
      <el-dialog:visible.sync="dialogVisible">
        <imgwidth="100%":src="dialogImageUrl"alt="">
      </el-dialog>
    </el-form-item> 

  myHeaders: { Authorization: 'Bearer ' + getToken() }, //用于上传文件的身份认证

    <testproduct-advanceref="advancesearch"@search="advanceSearch"
    />

    async handleSearch() { //表单提交
      this.isVisible = false;this.$emit('search', this.searchForm)

    },

methods: {

    advanceSearch(searchObj) {//高级查询
      //console.log(searchObj)
      this.advanceSearchForm =searchObj;this.msgSuccess('已选择高级查询条件进行查询了')this.isAdvanceSeach = false //关闭高级查询窗口
      this.getlist()

    },

    onResetAdvance(searchObj) {//重置高级查询条件
      //console.log(searchObj)
      this.advanceSearchForm =searchObj;

    },

    showAdvanceForm() {//显示自定义的高级查询对话框
      this.$refs.advancesearch.show()

    },

    getlist() { //列表数据获取
      //如果高级查询对象非空，则采用高级查询条件
       var form = this.isEmpty(this.advanceSearchForm) ? this.searchForm : this.advanceSearchForm;var param = { //构造常规的分页查询条件
        //分页条件
        SkipCount: (this.pageinfo.pageindex - 1) * this.pageinfo.pagesize,

        MaxResultCount:this.pageinfo.pagesize,//查询过滤条件
ProductNo: form.productNo,

        BarCode: form.barCode,

        MaterialCode: form.materialCode,

        ProductType: form.productType,

        ProductName: form.productName,

        Status: form.status

      }



      .............

<el-button:icon="expandMore ?'el-icon-arrow-up':'el-icon-arrow-down'"type="text"@click="expandMore =!expandMore">{{ expandMore ? '收起':'展开' }}</el-button>

    getlist() { //列表数据获取
      var param = { //构造常规的分页查询条件
        //分页条件
        SkipCount: (this.pageinfo.pageindex - 1) * this.pageinfo.pagesize,

        MaxResultCount:this.pageinfo.pagesize,//查询过滤条件
        Name: this.searchForm.name,

        Sex:this.searchForm.sex,

        .............



        State:this.searchForm.state

      };//使用日期范围选择控件，在查询对象增加开始日期CreationTimeStart、结束日期CreationTimeEnd
      this.addDateRange(param, this.searchForm.creationTime)//获取列表，绑定到模型上，并修改分页数量
      this.listLoading = truetestUser.GetAll(param).then(data=>{this.list =data.result.itemsthis.pageinfo.total =data.result.totalCountthis.listLoading = false})

    },

namespaceMyProject.EntityFrameworkCore

{/// <summary>
    ///配置使用特定数据库的处理/// </summary>
    public static classMyProjectDbContextConfigurer

    {public static void Configure(DbContextOptionsBuilder<MyProjectDbContext> builder, stringconnectionString)

        {//builder.UseSqlServer(connectionString);//默认SQlServer
            builder.UseMySql(connectionString, new MySqlServerVersion(new Version(5, 7)));//MySQL//builder.UseNpgsql(connectionString);//PostgreSQL//builder.UseOracle(connectionString);//Oracle
}public static void Configure(DbContextOptionsBuilder<MyProjectDbContext>builder, DbConnection connection)

        {//builder.UseSqlServer(connection);//默认SQlServer
            builder.UseMySql(connection, new MySqlServerVersion(new Version(5, 7)));//MySQL//builder.UseNpgsql(connection);//PostgreSQL//builder.UseOracle(connection);//Oracle
}

    }

}

new MySqlServerVersion(new Version(5, 7)

{"ConnectionStrings": {"Default": "Server=.\\SQL2014; Database=MyProjectDb; Trusted_Connection=True;","Oracle": "User Id=orcl;Password=orcl;Data Source=orcl;Persist Security Info=True;","MySql": "Server=localhost;Database=myprojectdb;Uid=root;Pwd=123456;","PostgreSQL": "Server=localhost;Port=5432;Database=myprojectdb;User Id=postgres;Password=123456"},"RedisCache": {"ConnectionString": "localhost","DatabaseId": "-1"},



...............

    public class MyProjectDbContextFactory : IDesignTimeDbContextFactory<MyProjectDbContext>{public MyProjectDbContext CreateDbContext(string[] args)

        {var builder = new DbContextOptionsBuilder<MyProjectDbContext>();//获取配置文件信息
            var configuration =AppConfigurations.Get(WebContentDirectoryFinder.CalculateContentRootFolder());//通过连接字符串切换对应的数据库，ConnectionStringName默认为Default
MyProjectDbContextConfigurer.Configure(builder, configuration.GetConnectionString(Constants.ConnectionStringName));return newMyProjectDbContext(builder.Options);

        }

    }

dotnet --info

net stop was /y
net start w3svc

startnginx    启动



nginx -s reload     刷新配置文件



tasklist/fi "imagename eq nginx.exe"查看所有的nginx进程



taskkill/fi "imagename eq nginx.exe" /f  停止所有nginx进程

server {

        listen8000;

        server_name  localhost;



        #charset koi8-r;

        #access_log  logs/host.access.log  main;
location/{

            root   html/dist;
index  index.html index.htm;

            try_files $uri $uri/ /index.html =404;                    
}

        location/baseabp { 
            proxy_set_header Host                    $host:21021; #图片等资源需带端口获取

            proxy_set_header x-forwarded-for$remote_addr;

            proxy_set_header X-Real-IP               $remote_addr;

            proxy_pass                               http://localhost:21021;
}            

        location/abp { 
            proxy_set_header Host                    $host:21021; #图片等资源需带端口获取

            proxy_set_header x-forwarded-for$remote_addr;

            proxy_set_header X-Real-IP               $remote_addr;

            proxy_pass                               http://localhost:21021/api;
        }

    <!--表格列表信息-->
    <el-tablev-loading="listLoading":data="list"border

      fit

      stripe

      highlight-current-row

      :header-cell-style="{background:'#eef1f6',color:'#606266'}"@selection-change="selectionChange"@row-dblclick="rowDbclick"@sort-change="sortChange"
    >
      <el-table-columntype="selection"width="40" />
      <el-table-columnalign="center"sortable="custom"prop="name"label="姓名">
        <templateslot-scope="scope">{{ scope.row.name }}</template>
      </el-table-column>
      <el-table-columnalign="center"sortable="custom"prop="age"label="年龄">
        <templateslot-scope="scope">{{ scope.row.age }} 岁</template>
      </el-table-column>
      <!--日期字段信息，显示完整时间格式:formatter="timeFormat"，否则使用:formatter="dateFormat"-->
      <el-table-columnalign="center"label="创建时间"sortable="custom"width="160"prop="creationTime":formatter="timeFormat" />

methods: {

    sortChange({ column, prop, order }) {var direction = (order === 'ascending') ? ' ASC' : ' DESC'
      this.sorting = !this.isEmpty(prop) ? (prop + direction) : null
      this.getlist()

    },

    getlist() { //列表数据获取
      var param = { //构造常规的分页查询条件
        //分页条件
        SkipCount: (this.pageinfo.pageindex - 1) * this.pageinfo.pagesize,

        MaxResultCount:this.pageinfo.pagesize,

        Sorting:this.sorting,//查询过滤条件
        Name: this.searchForm.name,

        AgeStart:this.searchForm.ageStart

      };//使用日期范围选择控件，在查询对象增加开始日期CreationTimeStart、结束日期CreationTimeEnd
      this.addDateRange(param, this.searchForm.creationTime)//获取列表，绑定到模型上，并修改分页数量
      this.listLoading = truecustomer.GetAll(param).then(data=>{this.list =data.result.itemsthis.pageinfo.total =data.result.totalCountthis.listLoading = false})

    },

        public virtual async Task<PagedResultDto<TEntityDto>>GetAllAsync(TGetAllInput input)

        {

            CheckGetAllPermission();//检查权限

            var query = CreateFilteredQuery(input);  //构建查询条件

            var totalCount = await AsyncQueryableExecuter.CountAsync(query);  //获取记录总数
query= ApplySorting(query, input);  //排序
            query = ApplyPaging(query, input);   //分页

            var entities = await AsyncQueryableExecuter.ToListAsync(query);  //返回实体记录

            return new PagedResultDto<TEntityDto>(  //构建分页展示数据
totalCount,

                entities.Select(MapToEntityDto).ToList()  //实体转换DTO

            );

        }

        /// <summary>
        ///自定义条件处理/// </summary>
        /// <param name="input">查询条件Dto</param>
        /// <returns></returns>
        protected override IQueryable<Customer>CreateFilteredQuery(CustomerPagedDto input)

        {return base.CreateFilteredQuery(input)

                .WhereIf(!input.ExcludeId.IsNullOrWhiteSpace(), t=>t.Id != input.ExcludeId) //不包含排除ID
                .WhereIf(!input.Name.IsNullOrWhiteSpace(), t => t.Name.Contains(input.Name)) //如需要精确匹配则用Equals//年龄区间查询
                .WhereIf(input.AgeStart.HasValue, s => s.Age >=input.AgeStart.Value)

                .WhereIf(input.AgeEnd.HasValue, s=> s.Age <=input.AgeEnd.Value)//创建日期区间查询
                .WhereIf(input.CreationTimeStart.HasValue, s => s.CreationTime >=input.CreationTimeStart.Value)

                .WhereIf(input.CreationTimeEnd.HasValue, s=> s.CreationTime <=input.CreationTimeEnd.Value)

                ;

        }

        /// <summary>
        ///自定义排序处理/// </summary>
        /// <param name="query">可查询LINQ</param>
        /// <param name="input">查询条件Dto</param>
        /// <returns></returns>
        protected override IQueryable<Customer> ApplySorting(IQueryable<Customer>query, CustomerPagedDto input)

        {if (!string.IsNullOrEmpty(input.Sorting))//排序字段是否有值
{

                query=query.OrderBy(input.Sorting);

            }else{

                query= query.OrderByDescending(t =>t.CreationTime);

            }returnquery;
        }