everlight.eap/backend/DllEapBll/OFILM/MacCheckController.cs

using Cksoft.Data;
using Cksoft.Data.Repository;
using DllEapDal;
using DllEapEntity.Dtos;
using DllEapEntity.OFILM;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using System;

namespace DllEapBll.OFILM
{
    [Route("eap/api/[controller]/[action]")]
    [ApiController]
    [Authorize]
    public class MacCheckController : ControllerBase
    {
        [HttpGet]
        public LayuiModel<MacCheckMstDto> Get(string filter, string sort, int pageIndex = 1, int pageSize = 10, string sortField = "rectime", string sortOrder = "ascend")
        {
            string userCode = Request.Headers["usercode"];
            if (!string.IsNullOrEmpty(sort))
            {
                var arr = sort.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                if (arr != null && arr.Length > 0)
                {
                    sortField = arr[0];
                    sortOrder = arr[1];
                }
            }
            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 MacCheckMstDal(db);
                var total = 0;
                string errorinfo = string.Empty;
                total = dal.GetCount(filter);
                var roles = dal.Get(start, pageSize, sortOrder,
                    sortField, filter, errorinfo);
                return new LayuiModel<MacCheckMstDto>
                {
                    code = 1,
                    count = total,
                    data = roles,
                    msg = ""
                };
            }
        }

        [HttpGet]
        public LayuiModel<MacCheckMstDetailDto> GetMstDetail(string filter, string sort, int pageIndex = 1, int pageSize = 10, string sortField = "rectime", string sortOrder = "ascend")
        {
            string userCode = Request.Headers["usercode"];
            if (!string.IsNullOrEmpty(sort))
            {
                var arr = sort.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                if (arr != null && arr.Length > 0)
                {
                    sortField = arr[0];
                    sortOrder = arr[1];
                }
            }
            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 MacCheckMstDal(db);
                var total = 0;
                string errorinfo = string.Empty;
                total = dal.GetCount(filter);
                var roles = dal.GetMstDetail(start, pageSize, sortOrder,
                    sortField, filter, errorinfo);
                return new LayuiModel<MacCheckMstDetailDto>
                {
                    code = 1,
                    count = total,
                    data = roles,
                    msg = ""
                };
            }
        }

        public LayuiModel<MacCheckMstDetailDto> GetMstDetailExport(string filter, string sort, int pageIndex = 1, int pageSize = 10, string sortField = "rectime", string sortOrder = "ascend")
        {
            string userCode = Request.Headers["usercode"];
            if (!string.IsNullOrEmpty(sort))
            {
                var arr = sort.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                if (arr != null && arr.Length > 0)
                {
                    sortField = arr[0];
                    sortOrder = arr[1];
                }
            }
            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 MacCheckMstDal(db);
                var total = 0;
                string errorinfo = string.Empty;
                total = dal.GetCount(filter);
                var roles = dal.GetMstDetailExport(start, pageSize, sortOrder,
                    sortField, filter, errorinfo);
                return new LayuiModel<MacCheckMstDetailDto>
                {
                    code = 1,
                    count = total,
                    data = roles,
                    msg = ""
                };
            }
        }
    }


}