OA2023/OASystem/OASystem.Infrastructure/Repositories/Groups/EnterExitCostRepository.cs


using AutoMapper;
using EyeSoft.Collections.Generic;
using EyeSoft.Runtime.InteropServices;
using NPOI.SS.Formula.Functions;
using OASystem.Domain;
using OASystem.Domain.Dtos.Groups;
using OASystem.Domain.Dtos.System;
using OASystem.Domain.Entities.Groups;
using OASystem.Domain.ViewModels.Groups;
using OASystem.Infrastructure.Repositories.System;
using OASystem.Infrastructure.Tools;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Policy;
using System.Text;
using System.Threading.Tasks;

namespace OASystem.Infrastructure.Repositories.Groups
{
    /// <summary>
    /// 出入境费用 仓库
    /// </summary>
    public class EnterExitCostRepository : BaseRepository<Grp_EnterExitCost, EnterExitCostView>
    {
        private readonly IMapper _mapper;
        private readonly SetDataRepository _setDataRep;
        private readonly DelegationInfoRepository _groupRep;

        public EnterExitCostRepository(SqlSugarClient sqlSugar, IMapper mapper, SetDataRepository setDataRep, DelegationInfoRepository groupRep)
            : base(sqlSugar)
        {
            _setDataRep = setDataRep;
            _mapper = mapper; 
            _groupRep = groupRep;
        }

        /// <summary>
        /// 权限用户基础数据
        /// </summary>
        /// <returns></returns>
        public async Task<List<PermissionViewUserview>> PermissionViewUsersAsync()
        {
            //添加市场部人员
            var viewPermissionData = await _sqlSugar.Queryable<Sys_Users>()
                .LeftJoin<Sys_Department>((u, d) => u.DepId == d.Id)
                .Where((u, d) => u.IsDel == 0 && u.HrAudit == 1 && d.DepName.Equals("市场部"))
                .Select((u, d) => new PermissionViewUserview { Id = u.Id, Name = u.CnName })
                .ToListAsync();

            //去掉特殊人员
            if (viewPermissionData.Any())
            {
                var notName = new string[] { "高媛媛", "管理员" };
                viewPermissionData = viewPermissionData.Where(x => !notName.Any(x1 => x.Name.Contains(x1))).ToList();
            }

            //添加特定人员
            var feeBasePerm = AppSettingsHelper.Get<FeeBasePermView>("FeeBasePerm");
            if (feeBasePerm.Any())
            {
                foreach (var item in feeBasePerm)
                {
                    if (item.Users.Any())
                    {
                        viewPermissionData.AddRange(item.Users);
                    }
                }

                return viewPermissionData.GroupBy(x => x.Id).Select(x => x.First()).OrderBy(x => x.Id).ToList();
            }

            return viewPermissionData;
        }

        /// <summary>
        /// 初始化配置权限
        /// </summary>
        /// <param name="groupId"></param>
        /// <param name="currUserId"></param>
        /// <returns></returns>
        public async Task<bool> InitPerm(int groupId,int currUserId)
        {
            var feeBasePerm = AppSettingsHelper.Get<FeeBasePermView>("FeeBasePerm");
            var intlDplmcyBasePerm = new List<PermissionViewUserview>(); //国交部
            var mktStratBasePerm = new List<PermissionViewUserview>();   //市场部

            if (feeBasePerm.Any())
            {
                var intlDplmcyData = feeBasePerm.Find(x => x.Dept.Equals("IntlDplmcy"));
                if (intlDplmcyData != null) if (intlDplmcyData.Users.Any()) intlDplmcyBasePerm = intlDplmcyData.Users.ToList();

                var mktStratData = feeBasePerm.Find(x => x.Dept.Equals("MktStrat"));
                if (mktStratData != null) if (mktStratData.Users.Any()) mktStratBasePerm = mktStratData.Users.ToList();
            }

            /*
             * 权限分配规则
             * 刘琪、王鸽、朱琳的账号：默认只能刘、王、朱查看
             * 舒庆的账号 默认只能舒、刘、王、朱查看
             * 其他销售 默认只能自己、舒、刘、王、朱查看
             */
            var feeBasePermIds = new List<int>();
            if (intlDplmcyBasePerm.Any(x => x.Id == currUserId))
            {
                feeBasePermIds = intlDplmcyBasePerm.Select(x => x.Id).ToList();
            }
            else if (mktStratBasePerm.Any(x => x.Id == currUserId))
            {
                feeBasePermIds.AddRange(mktStratBasePerm.Select(x => x.Id).ToList());
                feeBasePermIds.AddRange(intlDplmcyBasePerm.Select(x => x.Id).ToList());
            }
            else
            {
                feeBasePermIds.Add(currUserId);
                feeBasePermIds.AddRange(mktStratBasePerm.Select(x => x.Id).ToList());
                feeBasePermIds.AddRange(intlDplmcyBasePerm.Select(x => x.Id).ToList());
            }

            /*
             * 市场部 朱姝 默认添加贵州、重庆、云南的出入境费用查看权限
             */
            if (currUserId == 380)
            {
                var cityPerm = new List<string>()
                {
                    "贵州", "重庆", "云南"
                };
                var groupInfo = await _sqlSugar.Queryable<Grp_DelegationInfo>().FirstAsync(x => x.Id == groupId && x.IsDel == 0);
                if (groupInfo != null)
                {
                    //1.通过团组名称判断是否包含城市
                    if (cityPerm.Any(x => groupInfo.TeamName.Contains(x)))
                    {
                        feeBasePermIds.Add(currUserId);
                    }
                    //2.通过城市Id判断是否包含城市
                    else 
                    {
                        var groupCity = await _sqlSugar.Queryable<Sys_Cities>().FirstAsync(x => x.Id == groupInfo.CityId && x.IsDel == 0);
                        if (groupCity != null)
                        {
                            var groupProvince = await _sqlSugar.Queryable<Sys_Cities>()
                                .FirstAsync(x => x.Id == groupCity.ParentId && cityPerm.Contains(x.Name_CN) && x.IsDel == 0);
                            if (groupProvince != null) feeBasePermIds.Add(currUserId);
                        }
                    }    
                }
            }

            if (feeBasePermIds.Any())
            {
                var permissions = new List<Grp_EnterExitCostPermission>();
                foreach (var userId in feeBasePermIds)
                {
                    permissions.Add(new Grp_EnterExitCostPermission()
                    {
                        GroupId = groupId,
                        UserId = userId,
                        Permission = 1,
                        CreateUserId = currUserId,
                    });
                }

                if (permissions.Any())
                {
                    await _sqlSugar.Insertable(permissions).ExecuteReturnIdentityAsync();
                    return true;
                }
            }
            return false;
        }

        /// <summary>
        /// 出入境费用正式 --> 权限验证
        /// </summary>
        /// <param name="groupId">团组Id</param>
        /// <param name="userId">用户Id</param>
        /// <param name="permission">操作权限 1:查看;2:新增;3:编辑;4:删除;5:下载; </param>
        /// <returns></returns>
        public async Task<(bool, bool)> PermissionValidationAsync(int groupId, int userId, int permission = 1)
        {
            //参数验证
            if (groupId < 1) return (false, false);
            if (userId < 1) return (false, false);
            var permissionIds = new List<int>() { 1, 2, 3, 4, 5 };
            if (!permissionIds.Contains(permission)) return (false, false);

            var feeBasePerm = AppSettingsHelper.Get<FeeBasePermView>("FeeBasePerm");
            var feeBasePermUserIds = new List<int>(); 

            if (feeBasePerm.Any())
            {
                var intlDplmcyData = feeBasePerm.Find(x => x.Dept.Equals("IntlDplmcy"));
                if (intlDplmcyData != null) if (intlDplmcyData.Users.Any()) feeBasePermUserIds.AddRange(intlDplmcyData.Users.Select(x=>x.Id).ToList());

                var mktStratData = feeBasePerm.Find(x => x.Dept.Equals("MktStrat"));
                if (mktStratData != null) if (mktStratData.Users.Any()) feeBasePermUserIds.AddRange(mktStratData.Users.Select(x => x.Id).ToList());
            }

            if (feeBasePermUserIds.Any(x => x == userId)) return (true, true);

            var info = await _sqlSugar.Queryable<Grp_EnterExitCostPermission>()
                .Where(it => it.GroupId == groupId && it.UserId == userId && it.Permission == permission)
                .FirstAsync();
            if (info != null) return (true, false);

            return (false, false);
        }

        /// <summary>
        /// 更新出入境费用汇率信息
        /// </summary>
        /// <returns></returns>
        public async Task<Result> SetEnterExitCostCurrencyChange()
        {
            Result result = new Result { Code = -1, Msg = "未知错误" };

            var enterExitList = await _sqlSugar.Queryable<Grp_EnterExitCost>().ToListAsync();

            foreach (var item in enterExitList)
            {
                string rateStr = string.Format(@"美元(USD):{0}|日元(JPY):{1}|欧元(EUR):{2}|英镑(GBP):{3}|港币(HKD):{4}", item.RateUSD, item.RateJPY, item.RateEUR, item.RateGBP, item.RateHKD);
                item.CurrencyRemark = rateStr;
            }

            var res = await _sqlSugar.Updateable(enterExitList)
                .WhereColumns(it => new { it.Id })
                .UpdateColumns(it => new { it.CurrencyRemark })
                .ExecuteCommandAsync();

            if (res > 0)
            {
                result.Code = 0;
                result.Msg = res.ToString();
                return result;
            }

            return result;
        }

        /// <summary>
        /// 移动端操作权限验证
        /// </summary>
        /// <param name="groupId"></param>
        /// <param name="currUserId"></param>
        /// <param name="permissionType">1 查看 2 编辑</param>
        /// <returns></returns>
        public async Task<(bool, string)> MobilePermissionsValidationAsync(int groupId, int currUserId, int permissionType = 1)
        {
            string msg = string.Empty;
            (bool viewPerm,bool assignPerm) = await PermissionValidationAsync(groupId, currUserId);//分配权限

            var enterExitCostData = await _sqlSugar
                .Queryable<Grp_EnterExitCost>()
                .OrderByDescending(x => x.CreateTime)
                .FirstAsync(it => it.DiId == groupId && it.IsDel == 0);
            if (permissionType == 1)
            {
                if (enterExitCostData == null)
                {
                    msg = $"数据不存在!";
                    return (false, msg);
                }

                if (!assignPerm || enterExitCostData.CreateUserId != currUserId)
                {
                    msg = $"未分配查看权限，如要查看，请联系市场部或国交部负责人!";
                }
                return (true, msg);
            }
            else if (permissionType == 2)
            {
                //if (enterExitCostData.CreateUserId == currUserId) status = true; //编辑权限
                if (!assignPerm || enterExitCostData.CreateUserId != currUserId)
                {
                    msg = $"未分配编辑权限，如要编辑，请联系市场部或国交部负责人!";
                }
                return (true, msg);

            }
            else msg = $"请传入正确的权限验证类型!";
            return (false, msg);
        }

        /// <summary>
        /// 查询 根据 Diid 查询
        /// </summary>
        /// <returns></returns>
        public async Task<JsonView> GetEnterExitCostInfoByDiId(EnterExitCostInfobyDiIdDto dto)
        {
            var result = new JsonView() { Code = 400, Msg = "暂无数据" };

            var enterExitCostData = await _sqlSugar.Queryable<Grp_EnterExitCost>().OrderByDescending(x => x.CreateTime).FirstAsync(it => it.DiId == dto.DiId && it.IsDel == 0);

            //Sys_PageFunctionPermission Function = _mapper.Map<Sys_PageFunctionPermission>(dto);

            var enterExitCostInfoView = new EnterExitCostInfoView();

            if (dto.PortType == 1) // Web
            {
                if (enterExitCostData != null)
                {
                    enterExitCostInfoView = _mapper.Map<EnterExitCostInfoView>(enterExitCostData);

                    (bool viewPerm, bool assignPerm) = await PermissionValidationAsync(dto.DiId, dto.CurrUserId);
                    if (viewPerm || enterExitCostData.CreateUserId == dto.CurrUserId)
                    {
                        enterExitCostInfoView.IsSave = true; //操作权限
                        enterExitCostInfoView.IsView = true; //查看权限
                    }
                    else
                    {
                        result.Msg = $"未分配查看权限，如要查看，请联系市场部或国交部负责人!";
                        return result;
                    }

                    //设置权限按钮
                    if (assignPerm)
                    {
                        enterExitCostInfoView.IsAssignPerm = true;

                        enterExitCostInfoView.ViewUsers = await _sqlSugar
                            .Queryable<Grp_EnterExitCostPermission>()
                            .Where(x => x.IsDel == 0 && x.GroupId == dto.DiId)
                            .Select(x => x.UserId)
                            .ToArrayAsync();
                    }

                    int provinceId = 122;
                    var groupNames = await _groupRep.EnterExitCostGroupNameInfoAsync(dto.DiId);
                    if (groupNames!=null)
                    {
                        provinceId = groupNames.ProvinceId;
                    }
                    enterExitCostInfoView.ProvinceId = provinceId;


                    //enterExitCostInfoView.FirstItemRemark = enterExitCostData.Remark;
                    var dayAndCostSql = string.Format(@"Select ntf.Country,ntf.City,ssd.Name CurremcyCode,ssd.Remark CurrencyName,gdac.* From Grp_DayAndCost gdac
                                                        Left Join Grp_NationalTravelFee ntf On ntf.Id = gdac.NationalTravelFeeId
                                                        Left Join Sys_SetData ssd On ssd.STid = 66 And gdac.Currency = ssd.Id
                                                        Where gdac.Isdel = 0 And ntf.IsDel = 0 And gdac.DiId = {0} Order By [Type] ASC,[Days] ASC", dto.DiId);
                    var dayAndCostData = await _sqlSugar.SqlQueryable<DayAndCostInfoView>(dayAndCostSql).ToListAsync();

                    enterExitCostInfoView.QuarterageData = dayAndCostData.Where(it => it.Type == 1).ToList(); //住宿费 1
                    enterExitCostInfoView.BoardWagesData = dayAndCostData.Where(it => it.Type == 2).ToList(); //伙食费 2
                    enterExitCostInfoView.MiscellaneousFeeData = dayAndCostData.Where(it => it.Type == 3).ToList();  //公杂费 3
                    enterExitCostInfoView.TrainingExpenseData = dayAndCostData.Where(it => it.Type == 4).ToList();  //培训费 4

                    enterExitCostInfoView.DayOtherPriceData = _sqlSugar.Queryable<Grp_DayOtherPrice>()
                        .Where(x => x.IsDel == 0 && x.Diid == dto.DiId)
                        .OrderBy(x => x.Index)
                        .Select(x => new DayOtherPriceView
                        {
                            DiId = x.Diid,
                            Id = x.Id,
                            Cost = x.Cost,
                            Currency = x.Currency,
                            Index = x.Index,
                            SetDataId = x.SetDataId,
                            SubTotal = x.SubTotal,
                            Remark = x.Remark,
                        })
                        .ToList();

                    enterExitCostInfoView.Currencys = (List<CurrencyInfo>?)CommonFun.GetCurrencyChinaToList(enterExitCostData.CurrencyRemark);

                    result.Msg = "操作成功";
                    result.Code = 200;
                }
                else
                {
                    //    List<DayAndCostInfoView> views = new List<DayAndCostInfoView>()
                    //    {
                    //            new DayAndCostInfoView {Days=1},
                    //            new DayAndCostInfoView {Days=2},
                    //            new DayAndCostInfoView {Days=3},
                    //            new DayAndCostInfoView {Days=4},
                    //            new DayAndCostInfoView {Days=5},
                    //            new DayAndCostInfoView {Days=6},
                    //            new DayAndCostInfoView {Days=7},
                    //            new DayAndCostInfoView {Days=8},
                    //    };
                    //    enterExitCostInfoView.QuarterageData = views;
                    //    enterExitCostInfoView.BoardWagesData = views;
                    //    enterExitCostInfoView.MiscellaneousFeeData = views;
                    //    enterExitCostInfoView.TrainingExpenseData = views;
                    //    result.Code = 0;
                    enterExitCostInfoView.IsView = true;
                    enterExitCostInfoView.IsSave = true;
                    result.Msg = "未查询出数据!可操作该条数据!";
                }

                result.Data = enterExitCostInfoView;
            }
            else if (dto.PortType == 2 || dto.PortType == 3)
            {
                var mobileInfo = new EnterExitCostMobileInfoView();
                if (enterExitCostData != null)
                {
                    mobileInfo = _mapper.Map<EnterExitCostMobileInfoView>(enterExitCostData);

                    var dayAndCostData = _sqlSugar.Queryable<Grp_DayAndCost>()
                        .LeftJoin<Grp_NationalTravelFee>((dac, ntf) => dac.NationalTravelFeeId == ntf.Id)
                        .LeftJoin<Sys_SetData>((dac, ntf, sd) => dac.Currency == sd.Id)
                        .Where((dac, ntf, sd) => dac.IsDel == 0 && dac.DiId == dto.DiId)
                        .Select((dac, ntf, sd) => new DayAndCostMobileInfoView
                        {
                            SubId = dac.Id,
                            DiId = dac.DiId,
                            Type = dac.Type,
                            Days = dac.Days,
                            NationalTravelFeeId = dac.NationalTravelFeeId,
                            Arae = $"{ntf.Country}-{ntf.City}",
                            Cost = dac.Cost,
                            Currency = dac.Currency,
                            CurrencyName = sd.Name,
                            SubTotal = dac.SubTotal,
                        })
                        .ToList();

                    mobileInfo.ChoiceOneTotalCost = enterExitCostData.InsidePay;
                    mobileInfo.ChoiceOneDetails = new ChoiceOneMobileInfoView()
                    {
                        Visa = enterExitCostData.Visa,
                        VisaRemark = enterExitCostData.VisaRemark,
                        YiMiao = enterExitCostData.YiMiao,
                        HeSuan = enterExitCostData.HeSuan,
                        Service = enterExitCostData.Service,
                        Ticket = enterExitCostData.Ticket,
                        Safe = enterExitCostData.Safe,
                    };
                    mobileInfo.ChoiceTwoDetails = new ChoiceTwoMobileInfoView()
                    {
                        AirJJ = enterExitCostData.AirJJ,
                        AirGW = enterExitCostData.AirGW,
                        AirTD = enterExitCostData.AirTD,
                        CityTranffic = enterExitCostData.CityTranffic
                    };
                    mobileInfo.ChoiceThreeDetails = dayAndCostData.Where(it => it.Type == 1).OrderBy(it => it.Days).ToArray(); //住宿费 1
                    mobileInfo.ChoiceFourDetails = dayAndCostData.Where(it => it.Type == 2).OrderBy(it => it.Days).ToArray();  //伙食费 2
                    mobileInfo.ChoiceFiveDetails = dayAndCostData.Where(it => it.Type == 3).OrderBy(it => it.Days).ToArray();  //公杂费 3
                    mobileInfo.ChoiceSixDetails = dayAndCostData.Where(it => it.Type == 4).OrderBy(it => it.Days).ToArray();   //培训费 4

                    //其他款项
                    mobileInfo.OtherExpensesDetails = _sqlSugar.Queryable<Grp_DayOtherPrice>()
                        .LeftJoin<Sys_SetData>((dop, sd1) => dop.SetDataId == sd1.Id)
                        .LeftJoin<Sys_SetData>((dop, sd1, sd2) => dop.Currency == sd2.Id)
                        .Where((dop, sd1, sd2) => dop.IsDel == 0 && dop.Diid == dto.DiId)
                        .OrderBy((dop, sd1, sd2) => dop.Index)
                        .Select((dop, sd1, sd2) => new DayOtherPriceMobileInfoView
                        {
                            SubId = dop.Id,
                            DiId = dop.Diid,
                            Index = dop.Index,
                            SetDataId = dop.SetDataId,
                            SetDataName = sd1.Name,
                            Cost = dop.Cost,
                            Currency = dop.Currency,
                            CurrencyName = sd2.Remark,
                            SubTotal = dop.SubTotal,
                            Remark = dop.Remark,
                        })
                        .ToArray();

                    mobileInfo.Currencys = (List<CurrencyInfo>?)CommonFun.GetCurrencyChinaToList(enterExitCostData.CurrencyRemark);

                    result.Msg = "查询成功";
                    result.Code = 200;
                }
                result.Data = mobileInfo;
            }
            else result.Msg = MsgTips.Port;

            return result;
        }

        /// <summary>
        /// Add Or Update
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        public async Task<Result> PostEnterExitCostOperate(EnterExitCostOperateDto dto)
        {
            Result result = new Result() { Code = -1, Msg = "操作失败!" };

            if (dto.SumJJC == 0) dto.OutsideJJPay = 0;
            if (dto.SumGWC == 0) dto.OutsideGWPay = 0;
            if (dto.SumTDC == 0) dto.OutsideTDPay = 0;

            var enterExitCost = _mapper.Map<Grp_EnterExitCost>(dto);
            //enterExitCost.Remark = dto.FirstItemRemark;
            //enterExitCost.InsidePay = enterExitCost.Visa + enterExitCost.YiMiao + enterExitCost.HeSuan + enterExitCost.Service + enterExitCost.Safe + enterExitCost.Ticket;

            List<Grp_DayAndCost> subData = new List<Grp_DayAndCost>();
            var quarterageData = _mapper.Map<List<Grp_DayAndCost>>(dto.QuarterageData);  //住宿费 1
            quarterageData = quarterageData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
            if (quarterageData.Count > 0) subData.AddRange(quarterageData);

            var boardWagesData = _mapper.Map<List<Grp_DayAndCost>>(dto.BoardWagesData);  //伙食费 2
            boardWagesData = boardWagesData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
            if (boardWagesData.Count > 0) subData.AddRange(boardWagesData);

            var miscellaneousFeeData = _mapper.Map<List<Grp_DayAndCost>>(dto.MiscellaneousFeeData);  //公杂费 3
            miscellaneousFeeData = miscellaneousFeeData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
            if (miscellaneousFeeData.Count > 0) subData.AddRange(miscellaneousFeeData);

            var trainingExpenseData = _mapper.Map<List<Grp_DayAndCost>>(dto.TrainingExpenseData);    //培训费 4
            trainingExpenseData = trainingExpenseData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
            if (trainingExpenseData.Count > 0) subData.AddRange(trainingExpenseData);

            //处理币种string
            enterExitCost.CurrencyRemark = CommonFun.GetCurrencyChinaToString(dto.Currencys);
            enterExitCost.CreateUserId = dto.UserId;

            _sqlSugar.BeginTran();

            if (dto.PortType == 1)
            {
                try
                {
                    int enterExitId = 0;

                    if (enterExitCost.Id > 0) //修改
                    {
                        //操作权限验证 可查看人员亦可编辑
                        (bool viewPerm,bool assignPerm) = await PermissionValidationAsync(enterExitCost.DiId, dto.UserId);
                        if (!viewPerm)
                        {
                            _sqlSugar.RollbackTran();
                            result.Msg = "未分配编辑权限，如要编辑，请联系市场部或国交部负责人!";
                            return result;
                        }

                        var updateId = _sqlSugar.Updateable<Grp_EnterExitCost>(enterExitCost)
                            .IgnoreColumns(it => new { it.DeleteUserId, it.DeleteTime, it.CreateUserId, it.CreateTime, it.IsDel })
                            .ExecuteCommand();
                        if (updateId > 0) enterExitId = enterExitCost.Id;
                        else
                        {
                            _sqlSugar.RollbackTran();
                            result.Msg = "修改操作失败!";
                            return result;
                        }
                    }
                    else
                    {
                        //效重 根据团组Id 
                        var info = _sqlSugar.Queryable<Grp_EnterExitCost>().Where(it => it.IsDel == 0 && it.DiId == dto.DiId).First();
                        if (info != null)
                        {
                            _sqlSugar.RollbackTran();
                            result.Msg = "该团组相关数据已存在,请勿重新添加!";
                            return result;
                        }

                        //添加
                        enterExitId = _sqlSugar.Insertable<Grp_EnterExitCost>(enterExitCost).ExecuteReturnIdentity();
                        if (enterExitId < 1)
                        {
                            _sqlSugar.RollbackTran();
                            result.Msg = "添加操作失败!";
                            return result;
                        }

                        //初始化权限（查看、编辑） 
                        await InitPerm(dto.DiId, dto.UserId);
                    }

                    if (enterExitId > 0)
                    {
                        string sqlDelete = string.Format(@" Delete From Grp_DayAndCost Where Diid = {0} ", dto.DiId);
                        await ExecuteCommandAsync(sqlDelete);

                        foreach (var item in subData)
                        {
                            var updateId = _sqlSugar.Insertable<Grp_DayAndCost>(item).ExecuteCommand();
                            if (updateId < 1)
                            {
                                _sqlSugar.RollbackTran();
                                result.Msg = "添加操作失败!";
                                return result;
                            }
                        }
                    }

                    _sqlSugar.CommitTran();
                    result.Code = 0;
                    result.Msg = "操作成功!";
                    result.Data = new { sign = enterExitId };

                }
                catch (Exception ex)
                {
                    _sqlSugar.RollbackTran();
                    result.Msg = ex.Message;
                }
            }
            else result.Msg = MsgTips.Port;

            return result;
        }

        /// <summary>
        /// 确认费用
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public async Task<JsonView> ConfirmCost(ConfirmCostDto dto)
        {
            var _view = new JsonView() { Code = 20001, Msg = "操作失败!" };
            if (dto.Id < 1)
            {
                _view.Msg = MsgTips.Id;
                return _view;
            }

            int confirm = 1;
            if (dto.Type == 1) confirm = 2; // 确认
            else if (dto.Type == 2) { confirm = 1; } // 撤回
            else
            {
                _view.Msg = "请传入正确的type;1：确认 2:撤回";
                return _view;
            }
            var update = await _sqlSugar.Updateable<Grp_EnterExitCost>()
                                        .SetColumns(x => new Grp_EnterExitCost() { IsConfirm = confirm })
                                        .Where(x => x.Id == dto.Id)
                                        .ExecuteCommandAsync();
            if (update > 0)
            {
                _view.Code = 200;
                _view.Msg = "操作成功!";
                return _view;
            }

            return _view;
        }

        /// <summary>
        /// Del
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        public Task<Result> PostEnterExitCostSubItemDel(EnterExitCostSubItemDelDto dto)
        {
            Result result = new Result();

            var data = new Grp_DayAndCost()
            {
                Id = dto.Id,
                IsDel = 1,
                DeleteUserId = dto.DeleteUserId,
                DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")
            };

            var del = _sqlSugar.Updateable(data).UpdateColumns(it => new { it.IsDel, it.DeleteUserId, it.DeleteTime }).ExecuteCommand();

            if (del > 0) result.Code = 0;
            else result.Msg = string.Format("删除失败!");

            return Task.FromResult(result);
        }

        /// <summary>
        /// 团组模块 - 出入境国家费用标准 - Add Or Update
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        public async Task<JsonView> PostNationalTravelFeeOperate(NationalTravelFeeOperateDto dto)
        {
            var result = new JsonView() { Code = StatusCodes.Status400BadRequest, Msg = "操作失败!" };

            var info = _mapper.Map<Grp_NationalTravelFee>(dto);
            info.LastUpdateUserId = dto.UserId;
            info.CreateUserId = dto.UserId;


            if (dto.PortType == 1) //web
            {
                if (dto.Id == 0) //新增
                {
                    var isNul = await _sqlSugar
                        .Queryable<Grp_NationalTravelFee>()
                        .FirstAsync(x => x.IsDel == 0 &&
                            x.Continent.Equals(dto.Continent) &&
                            x.Country.Equals(dto.Country) &&
                            x.City.Equals(dto.City) &&
                            x.ProvinceId == info.ProvinceId);
                    if (isNul != null)
                    {
                        result.Msg = "该国家或者城市已存在,请勿重复添加!";
                        return result;
                    }

                    await _sqlSugar.Insertable(info) .ExecuteCommandAsync();   
                }
                else
                {
                    await _sqlSugar.Updateable(info)
                    .IgnoreColumns(it => new { it.CreateUserId, it.CreateTime, it.IsDel })
                    .WhereColumns(it => it.Id)
                    .ExecuteCommandAsync();  
                }

                result.Code = 200;
                result.Msg = "操作成功!";
            }
            else if (dto.PortType == 2) //Android
            {

            }
            else if (dto.PortType == 3) //Ios
            {

            }
            else result.Msg = MsgTips.Port;

            return result;
        }

        /// <summary>
        /// 一键清空
        /// 删除主表数据 Update
        /// 删除子表数据 delete
        /// </summary>
        /// <param name="id"></param>
        /// <param name="diid"></param>
        /// <returns></returns>
        public async Task<Result> _OneClickClear(int id, int diId, int userId)
        {
            Result result = new Result() { Code = -1, Msg = "操作成功!" };

            if (id < 1) return result = new Result() { Code = -1, Msg = "请传入有效的Id参数!" };
            if (diId < 1) return result = new Result() { Code = -1, Msg = "请传入有效的Id参数!" };
            if (userId < 1) return result = new Result() { Code = -1, Msg = "请传入有效的UserId参数!" };

            BeginTran();
            Grp_EnterExitCost _EnterExitCost = new Grp_EnterExitCost()
            {
                Id = id,
                IsDel = 1,
                DeleteUserId = userId,
                DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
            };

            //int update = await _sqlSugar.Updateable<Grp_EnterExitCost>(_EnterExitCost).Where(it => it.Id == id).ExecuteCommandAsync();
            int update = await _sqlSugar.Updateable<Grp_EnterExitCost>(_EnterExitCost)
                .UpdateColumns(it => new
                {
                    it.IsDel,
                    it.DeleteUserId,
                    it.DeleteTime
                })
                .Where(it => it.Id == id).ExecuteCommandAsync();

            if (update > 0)
            {
                string sqlDelete = string.Format(@"Delete From Grp_DayAndCost Where Diid = {0} ", diId);
                await ExecuteCommandAsync(sqlDelete);
                result.Code = 0;
                result.Msg = "操作成功!";
                CommitTran();
            }
            else
            {
                result.Msg = "操作失败";
                RollbackTran();
            }

            return result;
        }

        /// <summary>
        /// 文件类型
        /// </summary>
        /// <param name="provinceId"></param>
        /// <returns></returns>
        public async Task<(SetDataInfoView[], SetDataInfoView[])> FileOwner(int provinceId = 122)
        {
            //122 四川
            //108 贵州
            //103 重庆
            //132 云南

            var datas = await _sqlSugar
                .Queryable<Sys_SetData>()
                .Where(x => x.IsDel == 0 && (x.STid == 72 || x.STid == 73))

                .ToListAsync();


            var wordTypeData = datas.Where(x => x.STid == 72 && x.Remark.Contains(provinceId.ToString()))
                                .Select(x => new SetDataInfoView()
                                {
                                    Id = x.Id,
                                    Name = x.Name,
                                    Remark = x.Remark

                                }).ToArray();
            var excelTypeData = datas.Where(x => x.STid == 73 && x.Remark.Contains(provinceId.ToString()))
                                .Select(x => new SetDataInfoView()
                                {
                                    Id = x.Id,
                                    Name = x.Name,
                                    Remark = x.Remark

                                }).ToArray();

            return (wordTypeData, excelTypeData);
        }

    }
}