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;
public EnterExitCostRepository(SqlSugarClient sqlSugar, IMapper mapper, SetDataRepository setDataRep)
: base(sqlSugar)
{
_setDataRep = setDataRep;
_mapper = mapper;
}
/// <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 (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();
}
//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<Result> PostNationalTravelFeeOperate(NationalTravelFeeOperateDto dto)
{
Result result = new Result();
Grp_NationalTravelFee nationalTravelFee = _mapper.Map<Grp_NationalTravelFee>(dto);
nationalTravelFee.LastUpdateUserId = dto.UserId;
nationalTravelFee.CreateUserId = dto.UserId;
if (dto.PortType == 1) //web
{
var _nationalTravelFee = _sqlSugar.Storageable<Grp_NationalTravelFee>(nationalTravelFee).ToStorage();
if (dto.Id == 0) //新增
{
string selectSql = string.Format(@"Select * From Grp_NationalTravelFee
Where IsDel = 0
And Continent = '{0}'
And Country = '{1}'
And City = '{2}'", dto.Continent, dto.Country, dto.City);
Grp_NationalTravelFee nationalTravelFee1 = new Grp_NationalTravelFee();
nationalTravelFee1 = await _sqlSugar.SqlQueryable<Grp_NationalTravelFee>(selectSql).FirstAsync();
if (nationalTravelFee1 != null)
{
result.Msg = "该国家 城市已存在,请勿重复添加!";
return result;
}
_nationalTravelFee.AsInsertable.ExecuteCommand(); //不存在插入
}
else
{
_nationalTravelFee.AsUpdateable
.IgnoreColumns(it => new { it.CreateUserId, it.CreateTime, it.IsDel })
.WhereColumns(it => it.Id)
.ExecuteCommand(); //存在更新
}
result.Code = 0;
}
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;
}
}
}