using NCC.Common.Core.Manager;
using NCC.Common.Enum;
using NCC.Common.Extension;
using NCC.Common.Filter;
using NCC.Dependency;
using NCC.DynamicApiController;
using NCC.FriendlyException;
using NCC.Extend.Interfaces.LqKqhzb;
using Mapster;
using Microsoft.AspNetCore.Mvc;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using NCC.Extend.Entitys.lq_kqhzb;
using NCC.Extend.Entitys.Dto.LqKqhzb;
using Yitter.IdGenerator;
using NCC.Common.Helper;
using NCC.JsonSerialization;
using NCC.Common.Model.NPOI;
using NCC.Common.Configuration;
using NCC.DataEncryption;
using NCC.ClayObject;

namespace NCC.Extend.LqKqhzb
{
    /// <summary>
    /// 考勤汇总表服务
    /// </summary>
    [ApiDescriptionSettings(Tag = "Extend",Name = "LqKqhzb", Order = 200)]
    [Route("api/Extend/[controller]")]
    public class LqKqhzbService : ILqKqhzbService, IDynamicApiController, ITransient
    {
        private readonly ISqlSugarRepository<LqKqhzbEntity> _lqKqhzbRepository;
        private readonly SqlSugarScope _db;
        private readonly IUserManager _userManager;

        /// <summary>
        /// 初始化一个<see cref="LqKqhzbService"/>类型的新实例
        /// </summary>
        public LqKqhzbService(
            ISqlSugarRepository<LqKqhzbEntity> lqKqhzbRepository,
            IUserManager userManager)
        {
            _lqKqhzbRepository = lqKqhzbRepository;            
            _db = _lqKqhzbRepository.Context;
            _userManager = userManager;
        }

        /// <summary>
        /// 获取考勤汇总表
        /// </summary>
        /// <param name="id">参数</param>
        /// <returns></returns>
        [HttpGet("{id}")]
        public async Task<dynamic> GetInfo(string id)
        {
            var entity = await _db.Queryable<LqKqhzbEntity>().FirstAsync(p => p.Id == id);
            var output = entity.Adapt<LqKqhzbInfoOutput>();
            return output;
        }

        /// <summary>
		/// 获取考勤汇总表列表
		/// </summary>
		/// <param name="input">请求参数</param>
		/// <returns></returns>
        [HttpGet("")]
        public async Task<dynamic> GetList([FromQuery] LqKqhzbListQueryInput input)
        {
            var sidx = input.sidx == null ? "id" : input.sidx;
            var data = await _db.Queryable<LqKqhzbEntity>()
                .WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
                .WhereIF(!string.IsNullOrEmpty(input.mdbh), p => p.Mdbh.Contains(input.mdbh))
                .WhereIF(!string.IsNullOrEmpty(input.mdmc), p => p.Mdmc.Contains(input.mdmc))
                .WhereIF(!string.IsNullOrEmpty(input.zw), p => p.Zw.Contains(input.zw))
                .WhereIF(!string.IsNullOrEmpty(input.gwfl1), p => p.Gwfl1.Contains(input.gwfl1))
                .WhereIF(!string.IsNullOrEmpty(input.ygbh), p => p.Ygbh.Contains(input.ygbh))
                .WhereIF(!string.IsNullOrEmpty(input.xm), p => p.Xm.Contains(input.xm))
                .WhereIF(!string.IsNullOrEmpty(input.zzqk), p => p.Zzqk.Contains(input.zzqk))
                .WhereIF(!string.IsNullOrEmpty(input.gwfl2), p => p.Gwfl2.Contains(input.gwfl2))
                .WhereIF(!string.IsNullOrEmpty(input.ffyf), p => p.Ffyf.Contains(input.ffyf))
                .WhereIF(!string.IsNullOrEmpty(input.zgts), p => p.Zgts.Contains(input.zgts))
                .WhereIF(!string.IsNullOrEmpty(input.dybzxxts), p => p.Dybzxxts.Contains(input.dybzxxts))
                .WhereIF(!string.IsNullOrEmpty(input.sjxxts), p => p.Sjxxts.Contains(input.sjxxts))
                .WhereIF(!string.IsNullOrEmpty(input.xx), p => p.Xx.Contains(input.xx))
                .WhereIF(!string.IsNullOrEmpty(input.qj), p => p.Qj.Contains(input.qj))
                .WhereIF(!string.IsNullOrEmpty(input.flj), p => p.Flj.Contains(input.flj))
                .WhereIF(!string.IsNullOrEmpty(input.sj), p => p.Sj.Contains(input.sj))
                .WhereIF(!string.IsNullOrEmpty(input.nj), p => p.Nj.Contains(input.nj))
                .WhereIF(!string.IsNullOrEmpty(input.cq), p => p.Cq.Contains(input.cq))
                .WhereIF(!string.IsNullOrEmpty(input.cqjxx), p => p.Cqjxx.Contains(input.cqjxx))
                .WhereIF(!string.IsNullOrEmpty(input.yx), p => p.Yx.Contains(input.yx))
                .WhereIF(!string.IsNullOrEmpty(input.bkts), p => p.Bkts.Contains(input.bkts))
                .WhereIF(!string.IsNullOrEmpty(input.tjxx), p => p.Tjxx.Contains(input.tjxx))
                .WhereIF(!string.IsNullOrEmpty(input.sjqj), p => p.Sjqj.Contains(input.sjqj))
                .WhereIF(!string.IsNullOrEmpty(input.sxts), p => p.Sxts.Contains(input.sxts))
                .WhereIF(!string.IsNullOrEmpty(input.sxbt), p => p.Sxbt.Contains(input.sxbt))
                .WhereIF(!string.IsNullOrEmpty(input.qk), p => p.Qk.Contains(input.qk))
                .WhereIF(!string.IsNullOrEmpty(input.cd), p => p.Cd.Contains(input.cd))
                .WhereIF(!string.IsNullOrEmpty(input.qq), p => p.Qq.Contains(input.qq))
                .WhereIF(!string.IsNullOrEmpty(input.jtbz), p => p.Jtbz.Contains(input.jtbz))
                .WhereIF(!string.IsNullOrEmpty(input.xxqkk), p => p.Xxqkk.Contains(input.xxqkk))
                .WhereIF(!string.IsNullOrEmpty(input.zs), p => p.Zs.Contains(input.zs))
                .WhereIF(!string.IsNullOrEmpty(input.gzf), p => p.Gzf.Contains(input.gzf))
                .WhereIF(!string.IsNullOrEmpty(input.sjyj), p => p.Sjyj.Contains(input.sjyj))
                .WhereIF(!string.IsNullOrEmpty(input.ssyj), p => p.Ssyj.Contains(input.ssyj))
                .WhereIF(!string.IsNullOrEmpty(input.qtjl), p => p.Qtjl.Contains(input.qtjl))
                .WhereIF(!string.IsNullOrEmpty(input.bdyhsje), p => p.Bdyhsje.Contains(input.bdyhsje))
                .WhereIF(!string.IsNullOrEmpty(input.dypx), p => p.Dypx.Contains(input.dypx))
                .WhereIF(!string.IsNullOrEmpty(input.dyjtbt), p => p.Dyjtbt.Contains(input.dyjtbt))
                .WhereIF(!string.IsNullOrEmpty(input.yfsy), p => p.Yfsy.Contains(input.yfsy))
                .WhereIF(!string.IsNullOrEmpty(input.yfcy), p => p.Yfcy.Contains(input.yfcy))
                .WhereIF(!string.IsNullOrEmpty(input.zdts), p => p.Zdts.Contains(input.zdts))
                .WhereIF(!string.IsNullOrEmpty(input.kyts), p => p.Kyts.Contains(input.kyts))
                .WhereIF(!string.IsNullOrEmpty(input.sygzy), p => p.Sygzy.Contains(input.sygzy))
                .WhereIF(!string.IsNullOrEmpty(input.dyzdjzcxts), p => p.Dyzdjzcxts.Contains(input.dyzdjzcxts))
                .WhereIF(!string.IsNullOrEmpty(input.dysfhs), p => p.Dysfhs.Contains(input.dysfhs))
                .Select(it=> new LqKqhzbListOutput
                {
                    id = it.Id,
                    mdbh=it.Mdbh,
                    mdmc=it.Mdmc,
                    zw=it.Zw,
                    gwfl1=it.Gwfl1,
                    ygbh=it.Ygbh,
                    xm=it.Xm,
                    zzqk=it.Zzqk,
                    gwfl2=it.Gwfl2,
                    ffyf=it.Ffyf,
                    zgts=it.Zgts,
                    dybzxxts=it.Dybzxxts,
                    sjxxts=it.Sjxxts,
                    xx=it.Xx,
                    qj=it.Qj,
                    flj=it.Flj,
                    sj=it.Sj,
                    nj=it.Nj,
                    cq=it.Cq,
                    cqjxx=it.Cqjxx,
                    yx=it.Yx,
                    bkts=it.Bkts,
                    tjxx=it.Tjxx,
                    sjqj=it.Sjqj,
                    sxts=it.Sxts,
                    sxbt=it.Sxbt,
                    qk=it.Qk,
                    cd=it.Cd,
                    qq=it.Qq,
                    jtbz=it.Jtbz,
                    xxqkk=it.Xxqkk,
                    zs=it.Zs,
                    gzf=it.Gzf,
                    sjyj=it.Sjyj,
                    ssyj=it.Ssyj,
                    qtjl=it.Qtjl,
                    bdyhsje=it.Bdyhsje,
                    dypx=it.Dypx,
                    dyjtbt=it.Dyjtbt,
                    yfsy=it.Yfsy,
                    yfcy=it.Yfcy,
                    zdts=it.Zdts,
                    kyts=it.Kyts,
                    sygzy=it.Sygzy,
                    dyzdjzcxts=it.Dyzdjzcxts,
                    dysfhs=it.Dysfhs,
                }).MergeTable().OrderBy(sidx+" "+input.sort).ToPagedListAsync(input.currentPage, input.pageSize);
                return PageResult<LqKqhzbListOutput>.SqlSugarPageResult(data);
        }

        /// <summary>
        /// 新建考勤汇总表
        /// </summary>
        /// <param name="input">参数</param>
        /// <returns></returns>
        [HttpPost("")]
        public async Task Create([FromBody] LqKqhzbCrInput input)
        {
            var userInfo = await _userManager.GetUserInfo();
            var entity = input.Adapt<LqKqhzbEntity>();
            entity.Id = YitIdHelper.NextId().ToString();
            var isOk = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).ExecuteCommandAsync();
            if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1000);
        }

        /// <summary>
		/// 获取考勤汇总表无分页列表
		/// </summary>
		/// <param name="input">请求参数</param>
		/// <returns></returns>
        [NonAction]
        public async Task<dynamic> GetNoPagingList([FromQuery] LqKqhzbListQueryInput input)
        {
            var sidx = input.sidx == null ? "id" : input.sidx;
            var data = await _db.Queryable<LqKqhzbEntity>()
                .WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id))
                .WhereIF(!string.IsNullOrEmpty(input.mdbh), p => p.Mdbh.Contains(input.mdbh))
                .WhereIF(!string.IsNullOrEmpty(input.mdmc), p => p.Mdmc.Contains(input.mdmc))
                .WhereIF(!string.IsNullOrEmpty(input.zw), p => p.Zw.Contains(input.zw))
                .WhereIF(!string.IsNullOrEmpty(input.gwfl1), p => p.Gwfl1.Contains(input.gwfl1))
                .WhereIF(!string.IsNullOrEmpty(input.ygbh), p => p.Ygbh.Contains(input.ygbh))
                .WhereIF(!string.IsNullOrEmpty(input.xm), p => p.Xm.Contains(input.xm))
                .WhereIF(!string.IsNullOrEmpty(input.zzqk), p => p.Zzqk.Contains(input.zzqk))
                .WhereIF(!string.IsNullOrEmpty(input.gwfl2), p => p.Gwfl2.Contains(input.gwfl2))
                .WhereIF(!string.IsNullOrEmpty(input.ffyf), p => p.Ffyf.Contains(input.ffyf))
                .WhereIF(!string.IsNullOrEmpty(input.zgts), p => p.Zgts.Contains(input.zgts))
                .WhereIF(!string.IsNullOrEmpty(input.dybzxxts), p => p.Dybzxxts.Contains(input.dybzxxts))
                .WhereIF(!string.IsNullOrEmpty(input.sjxxts), p => p.Sjxxts.Contains(input.sjxxts))
                .WhereIF(!string.IsNullOrEmpty(input.xx), p => p.Xx.Contains(input.xx))
                .WhereIF(!string.IsNullOrEmpty(input.qj), p => p.Qj.Contains(input.qj))
                .WhereIF(!string.IsNullOrEmpty(input.flj), p => p.Flj.Contains(input.flj))
                .WhereIF(!string.IsNullOrEmpty(input.sj), p => p.Sj.Contains(input.sj))
                .WhereIF(!string.IsNullOrEmpty(input.nj), p => p.Nj.Contains(input.nj))
                .WhereIF(!string.IsNullOrEmpty(input.cq), p => p.Cq.Contains(input.cq))
                .WhereIF(!string.IsNullOrEmpty(input.cqjxx), p => p.Cqjxx.Contains(input.cqjxx))
                .WhereIF(!string.IsNullOrEmpty(input.yx), p => p.Yx.Contains(input.yx))
                .WhereIF(!string.IsNullOrEmpty(input.bkts), p => p.Bkts.Contains(input.bkts))
                .WhereIF(!string.IsNullOrEmpty(input.tjxx), p => p.Tjxx.Contains(input.tjxx))
                .WhereIF(!string.IsNullOrEmpty(input.sjqj), p => p.Sjqj.Contains(input.sjqj))
                .WhereIF(!string.IsNullOrEmpty(input.sxts), p => p.Sxts.Contains(input.sxts))
                .WhereIF(!string.IsNullOrEmpty(input.sxbt), p => p.Sxbt.Contains(input.sxbt))
                .WhereIF(!string.IsNullOrEmpty(input.qk), p => p.Qk.Contains(input.qk))
                .WhereIF(!string.IsNullOrEmpty(input.cd), p => p.Cd.Contains(input.cd))
                .WhereIF(!string.IsNullOrEmpty(input.qq), p => p.Qq.Contains(input.qq))
                .WhereIF(!string.IsNullOrEmpty(input.jtbz), p => p.Jtbz.Contains(input.jtbz))
                .WhereIF(!string.IsNullOrEmpty(input.xxqkk), p => p.Xxqkk.Contains(input.xxqkk))
                .WhereIF(!string.IsNullOrEmpty(input.zs), p => p.Zs.Contains(input.zs))
                .WhereIF(!string.IsNullOrEmpty(input.gzf), p => p.Gzf.Contains(input.gzf))
                .WhereIF(!string.IsNullOrEmpty(input.sjyj), p => p.Sjyj.Contains(input.sjyj))
                .WhereIF(!string.IsNullOrEmpty(input.ssyj), p => p.Ssyj.Contains(input.ssyj))
                .WhereIF(!string.IsNullOrEmpty(input.qtjl), p => p.Qtjl.Contains(input.qtjl))
                .WhereIF(!string.IsNullOrEmpty(input.bdyhsje), p => p.Bdyhsje.Contains(input.bdyhsje))
                .WhereIF(!string.IsNullOrEmpty(input.dypx), p => p.Dypx.Contains(input.dypx))
                .WhereIF(!string.IsNullOrEmpty(input.dyjtbt), p => p.Dyjtbt.Contains(input.dyjtbt))
                .WhereIF(!string.IsNullOrEmpty(input.yfsy), p => p.Yfsy.Contains(input.yfsy))
                .WhereIF(!string.IsNullOrEmpty(input.yfcy), p => p.Yfcy.Contains(input.yfcy))
                .WhereIF(!string.IsNullOrEmpty(input.zdts), p => p.Zdts.Contains(input.zdts))
                .WhereIF(!string.IsNullOrEmpty(input.kyts), p => p.Kyts.Contains(input.kyts))
                .WhereIF(!string.IsNullOrEmpty(input.sygzy), p => p.Sygzy.Contains(input.sygzy))
                .WhereIF(!string.IsNullOrEmpty(input.dyzdjzcxts), p => p.Dyzdjzcxts.Contains(input.dyzdjzcxts))
                .WhereIF(!string.IsNullOrEmpty(input.dysfhs), p => p.Dysfhs.Contains(input.dysfhs))
                .Select(it=> new LqKqhzbListOutput
                {
                    id = it.Id,
                    mdbh=it.Mdbh,
                    mdmc=it.Mdmc,
                    zw=it.Zw,
                    gwfl1=it.Gwfl1,
                    ygbh=it.Ygbh,
                    xm=it.Xm,
                    zzqk=it.Zzqk,
                    gwfl2=it.Gwfl2,
                    ffyf=it.Ffyf,
                    zgts=it.Zgts,
                    dybzxxts=it.Dybzxxts,
                    sjxxts=it.Sjxxts,
                    xx=it.Xx,
                    qj=it.Qj,
                    flj=it.Flj,
                    sj=it.Sj,
                    nj=it.Nj,
                    cq=it.Cq,
                    cqjxx=it.Cqjxx,
                    yx=it.Yx,
                    bkts=it.Bkts,
                    tjxx=it.Tjxx,
                    sjqj=it.Sjqj,
                    sxts=it.Sxts,
                    sxbt=it.Sxbt,
                    qk=it.Qk,
                    cd=it.Cd,
                    qq=it.Qq,
                    jtbz=it.Jtbz,
                    xxqkk=it.Xxqkk,
                    zs=it.Zs,
                    gzf=it.Gzf,
                    sjyj=it.Sjyj,
                    ssyj=it.Ssyj,
                    qtjl=it.Qtjl,
                    bdyhsje=it.Bdyhsje,
                    dypx=it.Dypx,
                    dyjtbt=it.Dyjtbt,
                    yfsy=it.Yfsy,
                    yfcy=it.Yfcy,
                    zdts=it.Zdts,
                    kyts=it.Kyts,
                    sygzy=it.Sygzy,
                    dyzdjzcxts=it.Dyzdjzcxts,
                    dysfhs=it.Dysfhs,
                }).MergeTable().OrderBy(sidx+" "+input.sort).ToListAsync();
                return data;
        }

        /// <summary>
		/// 导出考勤汇总表
		/// </summary>
		/// <param name="input">请求参数</param>
		/// <returns></returns>
        [HttpGet("Actions/Export")]
        public async Task<dynamic> Export([FromQuery] LqKqhzbListQueryInput input)
        {
            var userInfo = await _userManager.GetUserInfo();
            var exportData = new List<LqKqhzbListOutput>();
            if (input.dataType == 0)
            {
                var data = Clay.Object(await this.GetList(input));
                exportData = data.Solidify<PageResult<LqKqhzbListOutput>>().list;
            }
            else
            {
                exportData = await this.GetNoPagingList(input);
            }
            List<ParamsModel> paramList = "[{\"value\":\"考勤编号\",\"field\":\"id\"},{\"value\":\"门店编号\",\"field\":\"mdbh\"},{\"value\":\"门店名称\",\"field\":\"mdmc\"},{\"value\":\"职位\",\"field\":\"zw\"},{\"value\":\"岗位分类1\",\"field\":\"gwfl1\"},{\"value\":\"员工编号\",\"field\":\"ygbh\"},{\"value\":\"姓名\",\"field\":\"xm\"},{\"value\":\"在职情况\",\"field\":\"zzqk\"},{\"value\":\"岗位分类2\",\"field\":\"gwfl2\"},{\"value\":\"发放月份\",\"field\":\"ffyf\"},{\"value\":\"在岗天数\",\"field\":\"zgts\"},{\"value\":\"当月休息天数\",\"field\":\"dybzxxts\"},{\"value\":\"实际休息天数\",\"field\":\"sjxxts\"},{\"value\":\"休息\",\"field\":\"xx\"},{\"value\":\"请假\",\"field\":\"qj\"},{\"value\":\"福利假\",\"field\":\"flj\"},{\"value\":\"丧假\",\"field\":\"sj\"},{\"value\":\"年假\",\"field\":\"nj\"},{\"value\":\"出勤\",\"field\":\"cq\"},{\"value\":\"出勤加休息\",\"field\":\"cqjxx\"},{\"value\":\"应休\",\"field\":\"yx\"},{\"value\":\"不扣天数\",\"field\":\"bkts\"},{\"value\":\"调减休息\",\"field\":\"tjxx\"},{\"value\":\"实际请假\",\"field\":\"sjqj\"},{\"value\":\"少休天数\",\"field\":\"sxts\"},{\"value\":\"少休补贴\",\"field\":\"sxbt\"},{\"value\":\"缺卡\",\"field\":\"qk\"},{\"value\":\"迟到\",\"field\":\"cd\"},{\"value\":\"全勤\",\"field\":\"qq\"},{\"value\":\"交通补助\",\"field\":\"jtbz\"},{\"value\":\"学习期扣款\",\"field\":\"xxqkk\"},{\"value\":\"住宿\",\"field\":\"zs\"},{\"value\":\"工作服\",\"field\":\"gzf\"},{\"value\":\"手机押金\",\"field\":\"sjyj\"},{\"value\":\"宿舍押金\",\"field\":\"ssyj\"},{\"value\":\"其他奖励\",\"field\":\"qtjl\"},{\"value\":\"保底核算金额\",\"field\":\"bdyhsje\"},{\"value\":\"当月培训\",\"field\":\"dypx\"},{\"value\":\"当月交通补贴\",\"field\":\"dyjtbt\"},{\"value\":\"应发上月\",\"field\":\"yfsy\"},{\"value\":\"应发次月\",\"field\":\"yfcy\"},{\"value\":\"在店天数\",\"field\":\"zdts\"},{\"value\":\"跨月天数\",\"field\":\"kyts\"},{\"value\":\"上月工资有\",\"field\":\"sygzy\"},{\"value\":\"在店加正常休\",\"field\":\"dyzdjzcxts\"},{\"value\":\"当月是否核算\",\"field\":\"dysfhs\"},]".ToList<ParamsModel>();           
            ExcelConfig excelconfig = new ExcelConfig();
            excelconfig.FileName = "考勤汇总表.xls";
            excelconfig.HeadFont = "微软雅黑";
            excelconfig.HeadPoint = 10;
            excelconfig.IsAllSizeColumn = true;
            excelconfig.ColumnModel = new List<ExcelColumnModel>();
            List<string> selectKeyList = input.selectKey.Split(',').ToList();
            foreach (var item in selectKeyList)
            {
                var isExist = paramList.Find(p => p.field == item);
                if (isExist != null)
                {
                    excelconfig.ColumnModel.Add(new ExcelColumnModel() { Column = isExist.field, ExcelColumn = isExist.value });
                }
            }
            var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName;
            ExcelExportHelper<LqKqhzbListOutput>.Export(exportData, excelconfig, addPath);
            var fileName = _userManager.UserId + "|" + addPath + "|xls";
            var output = new
            {
                name = excelconfig.FileName,
                url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC")
            };
            return output;
        }

        /// <summary>
        /// 批量删除考勤汇总表
        /// </summary>
        /// <param name="ids">主键数组</param>
        /// <returns></returns>
        [HttpPost("batchRemove")]
        public async Task BatchRemove([FromBody] List<string> ids)
        {
            var entitys = await _db.Queryable<LqKqhzbEntity>().In(it => it.Id, ids).ToListAsync();
            if (entitys.Count > 0)
            {
                try
                {
                    //开启事务
                    _db.BeginTran();
                    //批量删除考勤汇总表
                    await _db.Deleteable<LqKqhzbEntity>().In(d => d.Id,ids).ExecuteCommandAsync();
                    //关闭事务
                    _db.CommitTran();
                }
                catch (Exception)
                {
                    //回滚事务
                    _db.RollbackTran();
                    throw NCCException.Oh(ErrorCode.COM1002);
                }
            }
        }

        /// <summary>
        /// 更新考勤汇总表
        /// </summary>
        /// <param name="id">主键</param>
        /// <param name="input">参数</param>
        /// <returns></returns>
        [HttpPut("{id}")]
        public async Task Update(string id, [FromBody] LqKqhzbUpInput input)
        {
            var entity = input.Adapt<LqKqhzbEntity>();
            var isOk = await _db.Updateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync();
            if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001);
        }

        /// <summary>
        /// 删除考勤汇总表
        /// </summary>
        /// <returns></returns>
        [HttpDelete("{id}")]
        public async Task Delete(string id)
        {
            var entity = await _db.Queryable<LqKqhzbEntity>().FirstAsync(p => p.Id == id);
            _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005);
            var isOk = await _db.Deleteable<LqKqhzbEntity>().Where(d => d.Id == id).ExecuteCommandAsync();
            if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1002);
        }
    }
}