everlight.eap/backend/DllEapBll/Controllers/ParamsCommstController.cs

using DllEapEntity.Dtos;
using DllEapEntity;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Text;
using Cksoft.Data;
using Cksoft.Data.Repository;
using DllEapDal;
using Microsoft.AspNetCore.Authorization;

namespace DllEapBll.Controllers
{
    /// <summary>
    /// 参数
    /// </summary>
    [Authorize]
    [ApiController]
    [Route("eap/api/[controller]/[action]")]
    public class ParamsCommstController : ControllerBase
    {
        /// <summary>
        /// 参数列表
        /// </summary>
        /// <param name="filter"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="sortField"></param>
        /// <param name="sortOrder"></param>
        /// <returns></returns>
        [HttpGet]
        public LayuiModel<ParamsComMst> Get(string filter, int pageIndex = 1, int pageSize = 10000, string sortField = "ID", string sortOrder = "ascend")
        {
            if (sortOrder == "descend")
            {
                sortOrder = "desc";
            }
            else
            {
                sortOrder = "asc";
            }
            int start, end;
            start = (pageIndex - 1) * pageSize + 1;
            end = start + pageSize;
            using (IDatabase db = DbFactory.Base("eapslave"))
            {
                db.BeginTrans();
                var dal = new ParamsComMstDal(db);
                var total = dal.GetCount(filter);
                string errorinfo = string.Empty;
                var roles = dal.Get(start, pageSize, sortOrder, sortField, filter, errorinfo);
                return new LayuiModel<ParamsComMst>
                {
                    code = 1,
                    count = total,
                    data = roles,
                    msg = ""
                };
            }
        }
    }
}