EnterExitCostRepository.cs 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812
  1. 
  2. using AutoMapper;
  3. using OASystem.Domain;
  4. using OASystem.Domain.Dtos.Groups;
  5. using OASystem.Domain.Entities.Groups;
  6. using OASystem.Domain.ViewModels.Groups;
  7. using OASystem.Infrastructure.Repositories.System;
  8. using OASystem.Infrastructure.Tools;
  9. namespace OASystem.Infrastructure.Repositories.Groups
  10. {
  11. /// <summary>
  12. /// 出入境费用 仓库
  13. /// </summary>
  14. public class EnterExitCostRepository : BaseRepository<Grp_EnterExitCost, EnterExitCostView>
  15. {
  16. private readonly IMapper _mapper;
  17. private readonly SetDataRepository _setDataRep;
  18. private readonly DelegationInfoRepository _groupRep;
  19. public EnterExitCostRepository(SqlSugarClient sqlSugar, IMapper mapper, SetDataRepository setDataRep, DelegationInfoRepository groupRep)
  20. : base(sqlSugar)
  21. {
  22. _setDataRep = setDataRep;
  23. _mapper = mapper;
  24. _groupRep = groupRep;
  25. }
  26. /// <summary>
  27. /// 权限用户基础数据
  28. /// </summary>
  29. /// <returns></returns>
  30. public async Task<List<PermissionViewUserview>> PermissionViewUsersAsync()
  31. {
  32. //添加市场部人员
  33. var viewPermissionData = await _sqlSugar.Queryable<Sys_Users>()
  34. .LeftJoin<Sys_Department>((u, d) => u.DepId == d.Id)
  35. .Where((u, d) => u.IsDel == 0 && u.HrAudit == 1 && d.DepName.Equals("市场部"))
  36. .Select((u, d) => new PermissionViewUserview { Id = u.Id, Name = u.CnName })
  37. .ToListAsync();
  38. //去掉特殊人员
  39. if (viewPermissionData.Any())
  40. {
  41. var notName = new string[] { "高媛媛", "管理员" };
  42. viewPermissionData = viewPermissionData.Where(x => !notName.Any(x1 => x.Name.Contains(x1))).ToList();
  43. }
  44. //添加特定人员
  45. var feeBasePerm = AppSettingsHelper.Get<FeeBasePermView>("FeeBasePerm");
  46. if (feeBasePerm.Any())
  47. {
  48. foreach (var item in feeBasePerm)
  49. {
  50. if (item.Users.Any())
  51. {
  52. viewPermissionData.AddRange(item.Users);
  53. }
  54. }
  55. return viewPermissionData.GroupBy(x => x.Id).Select(x => x.First()).OrderBy(x => x.Id).ToList();
  56. }
  57. return viewPermissionData;
  58. }
  59. /// <summary>
  60. /// 初始化配置权限
  61. /// </summary>
  62. /// <param name="groupId"></param>
  63. /// <param name="currUserId"></param>
  64. /// <returns></returns>
  65. public async Task<bool> InitPerm(int groupId, int currUserId)
  66. {
  67. var feeBasePerm = AppSettingsHelper.Get<FeeBasePermView>("FeeBasePerm");
  68. var intlDplmcyBasePerm = new List<PermissionViewUserview>(); //国交部
  69. var mktStratBasePerm = new List<PermissionViewUserview>(); //市场部
  70. if (feeBasePerm.Any())
  71. {
  72. var intlDplmcyData = feeBasePerm.Find(x => x.Dept.Equals("IntlDplmcy"));
  73. if (intlDplmcyData != null) if (intlDplmcyData.Users.Any()) intlDplmcyBasePerm = intlDplmcyData.Users.ToList();
  74. var mktStratData = feeBasePerm.Find(x => x.Dept.Equals("MktStrat"));
  75. if (mktStratData != null) if (mktStratData.Users.Any()) mktStratBasePerm = mktStratData.Users.ToList();
  76. }
  77. /*
  78. * 权限分配规则
  79. * 刘琪、王鸽、朱琳的账号:默认只能李夏、王、朱查看
  80. * 舒庆的账号 默认只能舒、刘、王、朱查看
  81. * 其他销售 默认只能自己、舒、刘、王、朱查看
  82. */
  83. var feeBasePermIds = new List<int>();
  84. if (intlDplmcyBasePerm.Any(x => x.Id == currUserId))
  85. {
  86. feeBasePermIds = intlDplmcyBasePerm.Select(x => x.Id).ToList();
  87. }
  88. else if (mktStratBasePerm.Any(x => x.Id == currUserId))
  89. {
  90. feeBasePermIds.AddRange(mktStratBasePerm.Select(x => x.Id).ToList());
  91. feeBasePermIds.AddRange(intlDplmcyBasePerm.Select(x => x.Id).ToList());
  92. }
  93. else
  94. {
  95. feeBasePermIds.Add(currUserId);
  96. feeBasePermIds.AddRange(mktStratBasePerm.Select(x => x.Id).ToList());
  97. feeBasePermIds.AddRange(intlDplmcyBasePerm.Select(x => x.Id).ToList());
  98. }
  99. /*
  100. * 市场部 朱姝 默认添加贵州、重庆、云南的出入境费用查看权限
  101. */
  102. var cityPerm = new List<string>()
  103. {
  104. "贵州", "重庆", "云南"
  105. };
  106. var groupInfo = await _sqlSugar.Queryable<Grp_DelegationInfo>().FirstAsync(x => x.Id == groupId && x.IsDel == 0);
  107. if (groupInfo != null)
  108. {
  109. //1.通过团组名称判断是否包含城市
  110. if (cityPerm.Any(x => groupInfo.TeamName.Contains(x)))
  111. {
  112. feeBasePermIds.Add(380);
  113. }
  114. //2.通过城市Id判断是否包含城市
  115. else
  116. {
  117. var groupCity = await _sqlSugar.Queryable<Sys_Cities>().FirstAsync(x => x.Id == groupInfo.CityId && x.IsDel == 0);
  118. if (groupCity != null)
  119. {
  120. var groupProvince = await _sqlSugar.Queryable<Sys_Cities>()
  121. .FirstAsync(x => x.Id == groupCity.ParentId && cityPerm.Contains(x.Name_CN) && x.IsDel == 0);
  122. if (groupProvince != null) feeBasePermIds.Add(380);
  123. }
  124. }
  125. }
  126. if (feeBasePermIds.Any())
  127. {
  128. var permissions = new List<Grp_EnterExitCostPermission>();
  129. foreach (var userId in feeBasePermIds)
  130. {
  131. permissions.Add(new Grp_EnterExitCostPermission()
  132. {
  133. GroupId = groupId,
  134. UserId = userId,
  135. Permission = 1,
  136. CreateUserId = currUserId,
  137. });
  138. }
  139. if (permissions.Any())
  140. {
  141. await _sqlSugar.Insertable(permissions).ExecuteReturnIdentityAsync();
  142. return true;
  143. }
  144. }
  145. return false;
  146. }
  147. /// <summary>
  148. /// 出入境费用正式 --> 权限验证
  149. /// </summary>
  150. /// <param name="groupId">团组Id</param>
  151. /// <param name="userId">用户Id</param>
  152. /// <param name="permission">操作权限 1:查看;2:新增;3:编辑;4:删除;5:下载; </param>
  153. /// <returns></returns>
  154. public async Task<(bool, bool)> PermissionValidationAsync(int groupId, int userId, int permission = 1)
  155. {
  156. //参数验证
  157. if (groupId < 1) return (false, false);
  158. if (userId < 1) return (false, false);
  159. var permissionIds = new List<int>() { 1, 2, 3, 4, 5 };
  160. if (!permissionIds.Contains(permission)) return (false, false);
  161. var feeBasePerm = AppSettingsHelper.Get<FeeBasePermView>("FeeBasePerm");
  162. var feeBasePermUserIds = new List<int>();
  163. if (feeBasePerm.Any())
  164. {
  165. var intlDplmcyData = feeBasePerm.Find(x => x.Dept.Equals("IntlDplmcy"));
  166. if (intlDplmcyData != null) if (intlDplmcyData.Users.Any()) feeBasePermUserIds.AddRange(intlDplmcyData.Users.Select(x => x.Id).ToList());
  167. var mktStratData = feeBasePerm.Find(x => x.Dept.Equals("MktStrat"));
  168. if (mktStratData != null) if (mktStratData.Users.Any()) feeBasePermUserIds.AddRange(mktStratData.Users.Select(x => x.Id).ToList());
  169. }
  170. if (feeBasePermUserIds.Any(x => x == userId)) return (true, true);
  171. var info = await _sqlSugar.Queryable<Grp_EnterExitCostPermission>()
  172. .Where(it => it.GroupId == groupId && it.UserId == userId && it.Permission == permission)
  173. .FirstAsync();
  174. if (info != null) return (true, false);
  175. return (false, false);
  176. }
  177. /// <summary>
  178. /// 更新出入境费用汇率信息
  179. /// </summary>
  180. /// <returns></returns>
  181. public async Task<Result> SetEnterExitCostCurrencyChange()
  182. {
  183. var result = new Result { Code = -1, Msg = "未知错误" };
  184. var enterExitList = await _sqlSugar.Queryable<Grp_EnterExitCost>().ToListAsync();
  185. foreach (var item in enterExitList)
  186. {
  187. string rateStr = string.Format(@"美元(USD):{0}|日元(JPY):{1}|欧元(EUR):{2}|英镑(GBP):{3}|港币(HKD):{4}", item.RateUSD, item.RateJPY, item.RateEUR, item.RateGBP, item.RateHKD);
  188. item.CurrencyRemark = rateStr;
  189. }
  190. var res = await _sqlSugar.Updateable(enterExitList)
  191. .WhereColumns(it => new { it.Id })
  192. .UpdateColumns(it => new { it.CurrencyRemark })
  193. .ExecuteCommandAsync();
  194. if (res > 0)
  195. {
  196. result.Code = 0;
  197. result.Msg = res.ToString();
  198. return result;
  199. }
  200. return result;
  201. }
  202. /// <summary>
  203. /// 移动端操作权限验证
  204. /// </summary>
  205. /// <param name="groupId"></param>
  206. /// <param name="currUserId"></param>
  207. /// <param name="permissionType">1 查看 2 编辑</param>
  208. /// <returns></returns>
  209. public async Task<(bool, string)> MobilePermissionsValidationAsync(int groupId, int currUserId, int permissionType = 1)
  210. {
  211. string msg = string.Empty;
  212. (bool viewPerm, bool assignPerm) = await PermissionValidationAsync(groupId, currUserId);//分配权限
  213. var enterExitCostData = await _sqlSugar
  214. .Queryable<Grp_EnterExitCost>()
  215. .OrderByDescending(x => x.CreateTime)
  216. .FirstAsync(it => it.DiId == groupId && it.IsDel == 0);
  217. if (permissionType == 1)
  218. {
  219. if (enterExitCostData == null)
  220. {
  221. msg = $"数据不存在!";
  222. return (false, msg);
  223. }
  224. if (!assignPerm || enterExitCostData.CreateUserId != currUserId)
  225. {
  226. msg = $"未分配查看权限,如要查看,请联系市场部或国交部负责人!";
  227. }
  228. return (true, msg);
  229. }
  230. else if (permissionType == 2)
  231. {
  232. //if (enterExitCostData.CreateUserId == currUserId) status = true; //编辑权限
  233. if (!assignPerm || enterExitCostData.CreateUserId != currUserId)
  234. {
  235. msg = $"未分配编辑权限,如要编辑,请联系市场部或国交部负责人!";
  236. }
  237. return (true, msg);
  238. }
  239. else msg = $"请传入正确的权限验证类型!";
  240. return (false, msg);
  241. }
  242. /// <summary>
  243. /// 查询 根据 Diid 查询
  244. /// </summary>
  245. /// <returns></returns>
  246. public async Task<JsonView> GetEnterExitCostInfoByDiId(EnterExitCostInfobyDiIdDto dto)
  247. {
  248. var result = new JsonView() { Code = 400, Msg = "暂无数据" };
  249. var enterExitCostData = await _sqlSugar.Queryable<Grp_EnterExitCost>().OrderByDescending(x => x.CreateTime).FirstAsync(it => it.DiId == dto.DiId && it.IsDel == 0);
  250. //Sys_PageFunctionPermission Function = _mapper.Map<Sys_PageFunctionPermission>(dto);
  251. var enterExitCostInfoView = new EnterExitCostInfoView();
  252. if (dto.PortType == 1) // Web
  253. {
  254. if (enterExitCostData != null)
  255. {
  256. enterExitCostInfoView = _mapper.Map<EnterExitCostInfoView>(enterExitCostData);
  257. (bool viewPerm, bool assignPerm) = await PermissionValidationAsync(dto.DiId, dto.CurrUserId);
  258. if (viewPerm || enterExitCostData.CreateUserId == dto.CurrUserId)
  259. {
  260. enterExitCostInfoView.IsSave = true; //操作权限
  261. enterExitCostInfoView.IsView = true; //查看权限
  262. }
  263. else
  264. {
  265. result.Msg = $"未分配查看权限,如要查看,请联系市场部或国交部负责人!";
  266. return result;
  267. }
  268. //设置权限按钮
  269. if (assignPerm)
  270. {
  271. enterExitCostInfoView.IsAssignPerm = true;
  272. enterExitCostInfoView.ViewUsers = await _sqlSugar
  273. .Queryable<Grp_EnterExitCostPermission>()
  274. .Where(x => x.IsDel == 0 && x.GroupId == dto.DiId)
  275. .Select(x => x.UserId)
  276. .ToArrayAsync();
  277. }
  278. int provinceId = 122;
  279. var groupNames = await _groupRep.EnterExitCostGroupNameInfoAsync(dto.DiId);
  280. if (groupNames != null)
  281. {
  282. provinceId = groupNames.ProvinceId;
  283. }
  284. //云南暂无三公费用标准 暂时先用四川的
  285. if (provinceId == 132) provinceId = 122;
  286. enterExitCostInfoView.ProvinceId = provinceId;
  287. //if (dto.DiId == 2775) enterExitCostInfoView.ProvinceId = 122;
  288. //enterExitCostInfoView.FirstItemRemark = enterExitCostData.Remark;
  289. var dayAndCostSql = string.Format(@"Select ntf.Country,ntf.City,ssd.Name CurremcyCode,ssd.Remark CurrencyName,gdac.* From Grp_DayAndCost gdac
  290. Left Join Grp_NationalTravelFee ntf On ntf.Id = gdac.NationalTravelFeeId
  291. Left Join Sys_SetData ssd On ssd.STid = 66 And gdac.Currency = ssd.Id
  292. Where gdac.Isdel = 0 And ntf.IsDel = 0 And gdac.DiId = {0} Order By [Type] ASC,[Days] ASC", dto.DiId);
  293. var dayAndCostData = await _sqlSugar.SqlQueryable<DayAndCostInfoView>(dayAndCostSql).ToListAsync();
  294. enterExitCostInfoView.QuarterageData = dayAndCostData.Where(it => it.Type == 1).ToList(); //住宿费 1
  295. enterExitCostInfoView.BoardWagesData = dayAndCostData.Where(it => it.Type == 2).ToList(); //伙食费 2
  296. enterExitCostInfoView.MiscellaneousFeeData = dayAndCostData.Where(it => it.Type == 3).ToList(); //公杂费 3
  297. enterExitCostInfoView.TrainingExpenseData = dayAndCostData.Where(it => it.Type == 4).ToList(); //培训费 4
  298. enterExitCostInfoView.DayOtherPriceData = _sqlSugar.Queryable<Grp_DayOtherPrice>()
  299. .Where(x => x.IsDel == 0 && x.Diid == dto.DiId)
  300. .OrderBy(x => x.Index)
  301. .Select(x => new DayOtherPriceView
  302. {
  303. DiId = x.Diid,
  304. Id = x.Id,
  305. Cost = x.Cost,
  306. Currency = x.Currency,
  307. Index = x.Index,
  308. SetDataId = x.SetDataId,
  309. SubTotal = x.SubTotal,
  310. Remark = x.Remark,
  311. })
  312. .ToList();
  313. enterExitCostInfoView.Currencys = (List<CurrencyInfo>?)CommonFun.GetCurrencyChinaToList(enterExitCostData.CurrencyRemark);
  314. result.Msg = "操作成功";
  315. result.Code = 200;
  316. }
  317. else
  318. {
  319. // List<DayAndCostInfoView> views = new List<DayAndCostInfoView>()
  320. // {
  321. // new DayAndCostInfoView {Days=1},
  322. // new DayAndCostInfoView {Days=2},
  323. // new DayAndCostInfoView {Days=3},
  324. // new DayAndCostInfoView {Days=4},
  325. // new DayAndCostInfoView {Days=5},
  326. // new DayAndCostInfoView {Days=6},
  327. // new DayAndCostInfoView {Days=7},
  328. // new DayAndCostInfoView {Days=8},
  329. // };
  330. // enterExitCostInfoView.QuarterageData = views;
  331. // enterExitCostInfoView.BoardWagesData = views;
  332. // enterExitCostInfoView.MiscellaneousFeeData = views;
  333. // enterExitCostInfoView.TrainingExpenseData = views;
  334. // result.Code = 0;
  335. enterExitCostInfoView.IsView = true;
  336. enterExitCostInfoView.IsSave = true;
  337. result.Msg = "未查询出数据!可操作该条数据!";
  338. }
  339. result.Data = enterExitCostInfoView;
  340. }
  341. else if (dto.PortType == 2 || dto.PortType == 3)
  342. {
  343. var mobileInfo = new EnterExitCostMobileInfoView();
  344. if (enterExitCostData != null)
  345. {
  346. mobileInfo = _mapper.Map<EnterExitCostMobileInfoView>(enterExitCostData);
  347. var dayAndCostData = _sqlSugar.Queryable<Grp_DayAndCost>()
  348. .LeftJoin<Grp_NationalTravelFee>((dac, ntf) => dac.NationalTravelFeeId == ntf.Id)
  349. .LeftJoin<Sys_SetData>((dac, ntf, sd) => dac.Currency == sd.Id)
  350. .Where((dac, ntf, sd) => dac.IsDel == 0 && dac.DiId == dto.DiId)
  351. .Select((dac, ntf, sd) => new DayAndCostMobileInfoView
  352. {
  353. SubId = dac.Id,
  354. DiId = dac.DiId,
  355. Type = dac.Type,
  356. Days = dac.Days,
  357. NationalTravelFeeId = dac.NationalTravelFeeId,
  358. Arae = $"{ntf.Country}-{ntf.City}",
  359. Cost = dac.Cost,
  360. Currency = dac.Currency,
  361. CurrencyName = sd.Name,
  362. SubTotal = dac.SubTotal,
  363. })
  364. .ToList();
  365. mobileInfo.ChoiceOneTotalCost = enterExitCostData.InsidePay;
  366. mobileInfo.ChoiceOneDetails = new ChoiceOneMobileInfoView()
  367. {
  368. Visa = enterExitCostData.Visa,
  369. VisaRemark = enterExitCostData.VisaRemark,
  370. YiMiao = enterExitCostData.YiMiao,
  371. HeSuan = enterExitCostData.HeSuan,
  372. Service = enterExitCostData.Service,
  373. Ticket = enterExitCostData.Ticket,
  374. Safe = enterExitCostData.Safe,
  375. };
  376. mobileInfo.ChoiceTwoDetails = new ChoiceTwoMobileInfoView()
  377. {
  378. AirJJ = enterExitCostData.AirJJ,
  379. AirGW = enterExitCostData.AirGW,
  380. AirTD = enterExitCostData.AirTD,
  381. CityTranffic = enterExitCostData.CityTranffic
  382. };
  383. mobileInfo.ChoiceThreeDetails = dayAndCostData.Where(it => it.Type == 1).OrderBy(it => it.Days).ToArray(); //住宿费 1
  384. mobileInfo.ChoiceFourDetails = dayAndCostData.Where(it => it.Type == 2).OrderBy(it => it.Days).ToArray(); //伙食费 2
  385. mobileInfo.ChoiceFiveDetails = dayAndCostData.Where(it => it.Type == 3).OrderBy(it => it.Days).ToArray(); //公杂费 3
  386. mobileInfo.ChoiceSixDetails = dayAndCostData.Where(it => it.Type == 4).OrderBy(it => it.Days).ToArray(); //培训费 4
  387. //其他款项
  388. mobileInfo.OtherExpensesDetails = _sqlSugar.Queryable<Grp_DayOtherPrice>()
  389. .LeftJoin<Sys_SetData>((dop, sd1) => dop.SetDataId == sd1.Id)
  390. .LeftJoin<Sys_SetData>((dop, sd1, sd2) => dop.Currency == sd2.Id)
  391. .Where((dop, sd1, sd2) => dop.IsDel == 0 && dop.Diid == dto.DiId)
  392. .OrderBy((dop, sd1, sd2) => dop.Index)
  393. .Select((dop, sd1, sd2) => new DayOtherPriceMobileInfoView
  394. {
  395. SubId = dop.Id,
  396. DiId = dop.Diid,
  397. Index = dop.Index,
  398. SetDataId = dop.SetDataId,
  399. SetDataName = sd1.Name,
  400. Cost = dop.Cost,
  401. Currency = dop.Currency,
  402. CurrencyName = sd2.Remark,
  403. SubTotal = dop.SubTotal,
  404. Remark = dop.Remark,
  405. })
  406. .ToArray();
  407. mobileInfo.Currencys = (List<CurrencyInfo>?)CommonFun.GetCurrencyChinaToList(enterExitCostData.CurrencyRemark);
  408. result.Msg = "查询成功";
  409. result.Code = 200;
  410. }
  411. result.Data = mobileInfo;
  412. }
  413. else result.Msg = MsgTips.Port;
  414. return result;
  415. }
  416. /// <summary>
  417. /// Add Or Update
  418. /// </summary>
  419. /// <param name="dto"></param>
  420. /// <returns></returns>
  421. public async Task<Result> PostEnterExitCostOperate(EnterExitCostOperateDto dto)
  422. {
  423. var result = new Result() { Code = -1, Msg = "操作失败!" };
  424. if (dto.SumJJC == 0) dto.OutsideJJPay = 0;
  425. if (dto.SumGWC == 0) dto.OutsideGWPay = 0;
  426. if (dto.SumTDC == 0) dto.OutsideTDPay = 0;
  427. var enterExitCost = _mapper.Map<Grp_EnterExitCost>(dto);
  428. //enterExitCost.Remark = dto.FirstItemRemark;
  429. //enterExitCost.InsidePay = enterExitCost.Visa + enterExitCost.YiMiao + enterExitCost.HeSuan + enterExitCost.Service + enterExitCost.Safe + enterExitCost.Ticket;
  430. var subData = new List<Grp_DayAndCost>();
  431. var quarterageData = _mapper.Map<List<Grp_DayAndCost>>(dto.QuarterageData); //住宿费 1
  432. quarterageData = quarterageData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
  433. if (quarterageData.Count > 0) subData.AddRange(quarterageData);
  434. var boardWagesData = _mapper.Map<List<Grp_DayAndCost>>(dto.BoardWagesData); //伙食费 2
  435. boardWagesData = boardWagesData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
  436. if (boardWagesData.Count > 0) subData.AddRange(boardWagesData);
  437. var miscellaneousFeeData = _mapper.Map<List<Grp_DayAndCost>>(dto.MiscellaneousFeeData); //公杂费 3
  438. miscellaneousFeeData = miscellaneousFeeData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
  439. if (miscellaneousFeeData.Count > 0) subData.AddRange(miscellaneousFeeData);
  440. var trainingExpenseData = _mapper.Map<List<Grp_DayAndCost>>(dto.TrainingExpenseData); //培训费 4
  441. trainingExpenseData = trainingExpenseData.Select(it => { it.CreateUserId = dto.UserId; return it; }).ToList();
  442. if (trainingExpenseData.Count > 0) subData.AddRange(trainingExpenseData);
  443. //处理币种string
  444. enterExitCost.CurrencyRemark = CommonFun.GetCurrencyChinaToString(dto.Currencys);
  445. enterExitCost.CreateUserId = dto.UserId;
  446. _sqlSugar.BeginTran();
  447. if (dto.PortType == 1)
  448. {
  449. try
  450. {
  451. int enterExitId = 0;
  452. if (enterExitCost.Id > 0) //修改
  453. {
  454. //操作权限验证 可查看人员亦可编辑
  455. (bool viewPerm, bool assignPerm) = await PermissionValidationAsync(enterExitCost.DiId, dto.UserId);
  456. if (!viewPerm)
  457. {
  458. _sqlSugar.RollbackTran();
  459. result.Msg = "未分配编辑权限,如要编辑,请联系市场部或国交部负责人!";
  460. return result;
  461. }
  462. var updateId = _sqlSugar.Updateable<Grp_EnterExitCost>(enterExitCost)
  463. .IgnoreColumns(it => new { it.DeleteUserId, it.DeleteTime, it.CreateUserId, it.CreateTime, it.IsDel })
  464. .ExecuteCommand();
  465. if (updateId > 0) enterExitId = enterExitCost.Id;
  466. else
  467. {
  468. _sqlSugar.RollbackTran();
  469. result.Msg = "修改操作失败!";
  470. return result;
  471. }
  472. }
  473. else
  474. {
  475. //效重 根据团组Id
  476. var info = _sqlSugar.Queryable<Grp_EnterExitCost>().Where(it => it.IsDel == 0 && it.DiId == dto.DiId).First();
  477. if (info != null)
  478. {
  479. _sqlSugar.RollbackTran();
  480. result.Msg = "该团组相关数据已存在,请勿重新添加!";
  481. return result;
  482. }
  483. //添加
  484. enterExitId = _sqlSugar.Insertable<Grp_EnterExitCost>(enterExitCost).ExecuteReturnIdentity();
  485. if (enterExitId < 1)
  486. {
  487. _sqlSugar.RollbackTran();
  488. result.Msg = "添加操作失败!";
  489. return result;
  490. }
  491. //初始化权限(查看、编辑)
  492. await InitPerm(dto.DiId, dto.UserId);
  493. }
  494. if (enterExitId > 0)
  495. {
  496. string sqlDelete = string.Format(@" Delete From Grp_DayAndCost Where Diid = {0} ", dto.DiId);
  497. await ExecuteCommandAsync(sqlDelete);
  498. foreach (var item in subData)
  499. {
  500. var updateId = _sqlSugar.Insertable<Grp_DayAndCost>(item).ExecuteCommand();
  501. if (updateId < 1)
  502. {
  503. _sqlSugar.RollbackTran();
  504. result.Msg = "添加操作失败!";
  505. return result;
  506. }
  507. }
  508. }
  509. _sqlSugar.CommitTran();
  510. result.Code = 0;
  511. result.Msg = "操作成功!";
  512. result.Data = new { sign = enterExitId };
  513. }
  514. catch (Exception ex)
  515. {
  516. _sqlSugar.RollbackTran();
  517. result.Msg = ex.Message;
  518. }
  519. }
  520. else result.Msg = MsgTips.Port;
  521. return result;
  522. }
  523. /// <summary>
  524. /// 确认费用
  525. /// </summary>
  526. /// <param name="id"></param>
  527. /// <returns></returns>
  528. public async Task<JsonView> ConfirmCost(ConfirmCostDto dto)
  529. {
  530. var _view = new JsonView() { Code = 20001, Msg = "操作失败!" };
  531. if (dto.Id < 1)
  532. {
  533. _view.Msg = MsgTips.Id;
  534. return _view;
  535. }
  536. int confirm = 1;
  537. if (dto.Type == 1) confirm = 2; // 确认
  538. else if (dto.Type == 2) { confirm = 1; } // 撤回
  539. else
  540. {
  541. _view.Msg = "请传入正确的type;1:确认 2:撤回";
  542. return _view;
  543. }
  544. var update = await _sqlSugar.Updateable<Grp_EnterExitCost>()
  545. .SetColumns(x => new Grp_EnterExitCost() { IsConfirm = confirm })
  546. .Where(x => x.Id == dto.Id)
  547. .ExecuteCommandAsync();
  548. if (update > 0)
  549. {
  550. _view.Code = 200;
  551. _view.Msg = "操作成功!";
  552. return _view;
  553. }
  554. return _view;
  555. }
  556. /// <summary>
  557. /// Del
  558. /// </summary>
  559. /// <param name="dto"></param>
  560. /// <returns></returns>
  561. public Task<Result> PostEnterExitCostSubItemDel(EnterExitCostSubItemDelDto dto)
  562. {
  563. var result = new Result();
  564. var data = new Grp_DayAndCost()
  565. {
  566. Id = dto.Id,
  567. IsDel = 1,
  568. DeleteUserId = dto.DeleteUserId,
  569. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")
  570. };
  571. var del = _sqlSugar.Updateable(data).UpdateColumns(it => new { it.IsDel, it.DeleteUserId, it.DeleteTime }).ExecuteCommand();
  572. if (del > 0) result.Code = 0;
  573. else result.Msg = string.Format("删除失败!");
  574. return Task.FromResult(result);
  575. }
  576. /// <summary>
  577. /// 团组模块 - 出入境国家费用标准 - Add Or Update
  578. /// </summary>
  579. /// <param name="dto"></param>
  580. /// <returns></returns>
  581. public async Task<JsonView> PostNationalTravelFeeOperate(NationalTravelFeeOperateDto dto)
  582. {
  583. var result = new JsonView() { Code = StatusCodes.Status400BadRequest, Msg = "操作失败!" };
  584. var info = _mapper.Map<Grp_NationalTravelFee>(dto);
  585. info.LastUpdateUserId = dto.UserId;
  586. info.CreateUserId = dto.UserId;
  587. if (dto.PortType == 1) //web
  588. {
  589. if (dto.Id == 0) //新增
  590. {
  591. var isNul = await _sqlSugar
  592. .Queryable<Grp_NationalTravelFee>()
  593. .FirstAsync(x => x.IsDel == 0 &&
  594. x.Continent.Equals(dto.Continent) &&
  595. x.Country.Equals(dto.Country) &&
  596. x.City.Equals(dto.City) &&
  597. x.ProvinceId == info.ProvinceId);
  598. if (isNul != null)
  599. {
  600. result.Msg = "该国家或者城市已存在,请勿重复添加!";
  601. return result;
  602. }
  603. await _sqlSugar.Insertable(info).ExecuteCommandAsync();
  604. }
  605. else
  606. {
  607. await _sqlSugar.Updateable(info)
  608. .IgnoreColumns(it => new { it.CreateUserId, it.CreateTime, it.IsDel })
  609. .WhereColumns(it => it.Id)
  610. .ExecuteCommandAsync();
  611. }
  612. result.Code = 200;
  613. result.Msg = "操作成功!";
  614. }
  615. else if (dto.PortType == 2) //Android
  616. {
  617. }
  618. else if (dto.PortType == 3) //Ios
  619. {
  620. }
  621. else result.Msg = MsgTips.Port;
  622. return result;
  623. }
  624. /// <summary>
  625. /// 一键清空
  626. /// 删除主表数据 Update
  627. /// 删除子表数据 delete
  628. /// </summary>
  629. /// <param name="id"></param>
  630. /// <param name="diid"></param>
  631. /// <returns></returns>
  632. public async Task<Result> OneClickClear(int id, int diId, int userId)
  633. {
  634. var result = new Result() { Code = -1, Msg = "操作成功!" };
  635. if (id < 1) return result = new Result() { Code = -1, Msg = "请传入有效的Id参数!" };
  636. if (diId < 1) return result = new Result() { Code = -1, Msg = "请传入有效的Id参数!" };
  637. if (userId < 1) return result = new Result() { Code = -1, Msg = "请传入有效的UserId参数!" };
  638. BeginTran();
  639. var _EnterExitCost = new Grp_EnterExitCost()
  640. {
  641. Id = id,
  642. IsDel = 1,
  643. DeleteUserId = userId,
  644. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  645. };
  646. //int update = await _sqlSugar.Updateable<Grp_EnterExitCost>(_EnterExitCost).Where(it => it.Id == id).ExecuteCommandAsync();
  647. int update = await _sqlSugar.Updateable<Grp_EnterExitCost>(_EnterExitCost)
  648. .UpdateColumns(it => new
  649. {
  650. it.IsDel,
  651. it.DeleteUserId,
  652. it.DeleteTime
  653. })
  654. .Where(it => it.Id == id).ExecuteCommandAsync();
  655. if (update > 0)
  656. {
  657. string sqlDelete = string.Format(@"Delete From Grp_DayAndCost Where Diid = {0} ", diId);
  658. await ExecuteCommandAsync(sqlDelete);
  659. result.Code = 0;
  660. result.Msg = "操作成功!";
  661. CommitTran();
  662. }
  663. else
  664. {
  665. result.Msg = "操作失败";
  666. RollbackTran();
  667. }
  668. return result;
  669. }
  670. /// <summary>
  671. /// 文件类型
  672. /// </summary>
  673. /// <param name="provinceId"></param>
  674. /// <returns></returns>
  675. public async Task<(SetDataInfoView[], SetDataInfoView[])> FileOwner(int provinceId = 122)
  676. {
  677. //122 四川
  678. //108 贵州
  679. //103 重庆
  680. //132 云南
  681. var datas = await _sqlSugar
  682. .Queryable<Sys_SetData>()
  683. .Where(x => x.IsDel == 0 && (x.STid == 72 || x.STid == 73))
  684. .ToListAsync();
  685. var wordTypeData = datas.Where(x => x.STid == 72 && x.Remark.Contains(provinceId.ToString()))
  686. .Select(x => new SetDataInfoView()
  687. {
  688. Id = x.Id,
  689. Name = x.Name,
  690. Remark = x.Remark
  691. }).ToArray();
  692. var excelTypeData = datas.Where(x => x.STid == 73 && x.Remark.Contains(provinceId.ToString()))
  693. .Select(x => new SetDataInfoView()
  694. {
  695. Id = x.Id,
  696. Name = x.Name,
  697. Remark = x.Remark
  698. }).ToArray();
  699. return (wordTypeData, excelTypeData);
  700. }
  701. }
  702. }