GroupsController.cs 91 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133
  1. using Aspose.Cells;
  2. using Aspose.Cells.Drawing.Texts;
  3. using Aspose.Words;
  4. using Aspose.Words.Tables;
  5. using NPOI.Util;
  6. using OASystem.API.OAMethodLib;
  7. using OASystem.API.OAMethodLib.File;
  8. using OASystem.Domain.Dtos.Groups;
  9. using OASystem.Domain.Entities.Groups;
  10. using OASystem.Domain.ViewModels.Groups;
  11. using OASystem.Infrastructure.Repositories.Groups;
  12. using TencentCloud.Ocr.V20181119.Models;
  13. using OASystem.Infrastructure.Tools;
  14. using System.Web;
  15. using System.Data;
  16. using static OASystem.Infrastructure.Repositories.Groups.AirTicketResRepository;
  17. using static OpenAI.GPT3.ObjectModels.SharedModels.IOpenAiModels;
  18. using Cell = Aspose.Words.Tables.Cell;
  19. using Row = Aspose.Words.Tables.Row;
  20. using System.Runtime.Intrinsics.Arm;
  21. using Microsoft.AspNetCore.Mvc.Filters;
  22. using OASystem.Domain.Entities.Customer;
  23. using NPOI.SS.Formula.Functions;
  24. using OASystem.Domain.Dtos.CRM;
  25. namespace OASystem.API.Controllers
  26. {
  27. /// <summary>
  28. /// 团组相关
  29. /// </summary>
  30. //[Authorize]
  31. [Route("api/[controller]/[action]")]
  32. public class GroupsController : ControllerBase
  33. {
  34. private readonly GrpScheduleRepository _grpScheduleRep;
  35. private readonly IMapper _mapper;
  36. private readonly DelegationInfoRepository _groupRepository;
  37. private readonly TaskAssignmentRepository _taskAssignmentRep;
  38. private readonly AirTicketResRepository _airTicketResRep;
  39. private readonly DecreasePaymentsRepository _decreasePaymentsRep;
  40. private readonly InvitationOfficialActivitiesRepository _InvitationOfficialActivitiesRep;
  41. private readonly DelegationEnDataRepository _delegationEnDataRep;
  42. private readonly SqlSugarClient _sqlSugar;
  43. private string url;
  44. private string path;
  45. public GroupsController(IMapper mapper, SqlSugarClient sqlSugar, GrpScheduleRepository grpScheduleRep, DelegationInfoRepository groupRepository,
  46. TaskAssignmentRepository taskAssignmentRep, AirTicketResRepository airTicketResRep, DecreasePaymentsRepository decreasePaymentsRep,
  47. InvitationOfficialActivitiesRepository InvitationOfficialActivitiesRep, DelegationEnDataRepository delegationEnDataRep)
  48. {
  49. _mapper = mapper;
  50. _grpScheduleRep = grpScheduleRep;
  51. _groupRepository = groupRepository;
  52. _taskAssignmentRep = taskAssignmentRep;
  53. _airTicketResRep = airTicketResRep;
  54. _sqlSugar = sqlSugar;
  55. url = AppSettingsHelper.Get("ExcelBaseUrl");
  56. path = AppSettingsHelper.Get("ExcelBasePath");
  57. if (!System.IO.Directory.Exists(path))
  58. {
  59. System.IO.Directory.CreateDirectory(path);//不存在就创建文件夹
  60. }
  61. _decreasePaymentsRep = decreasePaymentsRep;
  62. _InvitationOfficialActivitiesRep = InvitationOfficialActivitiesRep;
  63. _delegationEnDataRep = delegationEnDataRep;
  64. }
  65. #region 流程管控
  66. /// <summary>
  67. /// 获取团组流程管控信息
  68. /// </summary>
  69. /// <param name="paras">参数Json字符串</param>
  70. /// <returns></returns>
  71. [HttpPost]
  72. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  73. public async Task<IActionResult> PostSearchGrpSchedule(JsonDtoBase _jsonDto)
  74. {
  75. if (string.IsNullOrEmpty(_jsonDto.Paras))
  76. {
  77. return Ok(JsonView(false, "参数为空"));
  78. }
  79. Grp_ScheduleDto _ScheduleDto = JsonConvert.DeserializeObject<Grp_ScheduleDto>(_jsonDto.Paras);
  80. if (_ScheduleDto != null)
  81. {
  82. if (_ScheduleDto.SearchType == 2)//获取列表
  83. {
  84. List<Grp_ScheduleView> _grpScheduleViewList = await _grpScheduleRep.GetViewList_GrpSchedule(_ScheduleDto);
  85. return Ok(JsonView(_grpScheduleViewList));
  86. }
  87. else//获取对象
  88. {
  89. Grp_ScheduleCombinView _grpScheduleView = await _grpScheduleRep.GetView_GrpSchedule(_ScheduleDto);
  90. if (_grpScheduleView != null)
  91. {
  92. return Ok(JsonView(_grpScheduleView));
  93. }
  94. }
  95. }
  96. else
  97. {
  98. return Ok(JsonView(false, "参数反序列化失败"));
  99. }
  100. return Ok(JsonView(false, "暂无数据!"));
  101. }
  102. /// <summary>
  103. /// 修改团组流程管控详细表数据
  104. /// </summary>
  105. /// <param name="paras"></param>
  106. /// <returns></returns>
  107. [HttpPost]
  108. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  109. public async Task<IActionResult> PostUpdateGrpScheduleDetail(Grp_ScheduleDetailUpdDto dto)
  110. {
  111. Grp_ScheduleDetailInfo _detail = _mapper.Map<Grp_ScheduleDetailInfo>(dto);
  112. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_ScheduleDetailInfo>()
  113. .SetColumns(it => it.Duty == _detail.Duty)
  114. .SetColumns(it => it.ExpectBeginDt == _detail.ExpectBeginDt)
  115. .SetColumns(it => it.ExpectEndDt == _detail.ExpectEndDt)
  116. .SetColumns(it => it.JobContent == _detail.JobContent)
  117. .SetColumns(it => it.Remark == _detail.Remark)
  118. .SetColumns(it => it.StepStatus == _detail.StepStatus)
  119. .Where(s => s.Id == dto.Id)
  120. //.UpdateColumns(s => new { s.Duty, s.ExpectBeginDt, s.ExpectEndDt, s.JobContent, s.Remark, s.StepStatus })
  121. .ExecuteCommandAsync();
  122. if (result > 0)
  123. {
  124. return Ok(JsonView(true, "保存成功!"));
  125. }
  126. return Ok(JsonView(false, "保存失败!"));
  127. }
  128. /// <summary>
  129. /// 删除团组流程管控详细表数据,删除人Id请放在Duty
  130. /// </summary>
  131. /// <param name="dto"></param>
  132. /// <returns></returns>
  133. [HttpPost]
  134. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  135. public async Task<ActionResult> PostDeleteGrpScheduleDetail(Grp_ScheduleDetailUpdDto dto)
  136. {
  137. Grp_ScheduleDetailInfo _detail = _mapper.Map<Grp_ScheduleDetailInfo>(dto);
  138. _detail.IsDel = 1;
  139. _detail.DeleteUserId = dto.Duty;
  140. _detail.DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  141. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_ScheduleDetailInfo>()
  142. .SetColumns(it => it.IsDel == _detail.IsDel)
  143. .SetColumns(it => it.DeleteUserId == _detail.DeleteUserId)
  144. .SetColumns(it => it.DeleteTime == _detail.DeleteTime)
  145. .Where(it => it.Id == dto.Id)
  146. //.UpdateColumns(s => new { s.IsDel, s.DeleteUserId, s.DeleteTime })
  147. //.WhereColumns(s => s.Id == dto.Id)
  148. .ExecuteCommandAsync();
  149. if (result > 0)
  150. {
  151. return Ok(JsonView(true, "删除成功!"));
  152. }
  153. return Ok(JsonView(false, "删除失败!"));
  154. }
  155. /// <summary>
  156. /// 增加团组流程管控详细表数据
  157. /// </summary>
  158. /// <param name="dto"></param>
  159. /// <returns></returns>
  160. [HttpPost]
  161. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  162. public async Task<ActionResult> PostInsertGrpScheduleDetail(Grp_ScheduleDetailInsertDto dto)
  163. {
  164. Grp_ScheduleDetailInfo _detail = _mapper.Map<Grp_ScheduleDetailInfo>(dto);
  165. if (DateTime.Now < _detail.ExpectBeginDt)
  166. {
  167. _detail.StepStatus = 0;
  168. }
  169. else
  170. {//若大于设置时间,不考虑设置的预计结束日期,统一视为进行中
  171. _detail.StepStatus = 1;
  172. }
  173. var result = await _grpScheduleRep._sqlSugar.Insertable(_detail).ExecuteReturnIdentityAsync();
  174. if (result > 0)
  175. {
  176. Grp_ScheduleDetailView _result = await _grpScheduleRep.GetInsertBackData(result);
  177. return Ok(JsonView(true, "添加成功!", _result));
  178. }
  179. return Ok(JsonView(false, "添加失败!"));
  180. }
  181. #endregion
  182. #region 团组基本信息
  183. /// <summary>
  184. /// 接团信息列表
  185. /// </summary>
  186. /// <param name="dto">团组列表请求dto</param>
  187. /// <returns></returns>
  188. [HttpPost]
  189. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  190. public async Task<IActionResult> GetGroupList(GroupListDto dto)
  191. {
  192. var groupData = await _groupRepository.GetGroupList(dto);
  193. if (groupData.Code != 0)
  194. {
  195. return Ok(JsonView(false, groupData.Msg));
  196. }
  197. return Ok(JsonView(groupData.Data));
  198. }
  199. /// <summary>
  200. /// 接团信息详情
  201. /// </summary>
  202. /// <param name="dto">团组info请求dto</param>
  203. /// <returns></returns>
  204. [HttpPost]
  205. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  206. public async Task<IActionResult> GetGroupInfo(GroupInfoDto dto)
  207. {
  208. var groupData = await _groupRepository.GetGroupInfo(dto);
  209. if (groupData.Code != 0)
  210. {
  211. return Ok(JsonView(false, groupData.Msg));
  212. }
  213. return Ok(JsonView(groupData.Data));
  214. }
  215. /// <summary>
  216. /// 接团信息 编辑添加
  217. /// 基础信息数据源
  218. /// </summary>
  219. /// <param name="dto"></param>
  220. /// <returns></returns>
  221. [HttpPost]
  222. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  223. public async Task<IActionResult> GroupEditBasicSource(GroupListDto dto)
  224. {
  225. var groupData = await _groupRepository.GroupEditBasicSource(dto);
  226. if (groupData.Code != 0)
  227. {
  228. return Ok(JsonView(false, groupData.Msg));
  229. }
  230. return Ok(JsonView(groupData.Data));
  231. }
  232. /// <summary>
  233. /// 接团信息 操作(增改)
  234. /// </summary>
  235. /// <param name="dto"></param>
  236. /// <returns></returns>
  237. [HttpPost]
  238. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  239. public async Task<IActionResult> GroupOperation(GroupOperationDto dto)
  240. {
  241. try
  242. {
  243. var groupData = await _groupRepository.GroupOperation(dto);
  244. if (groupData.Code != 0)
  245. {
  246. return Ok(JsonView(false, groupData.Msg));
  247. }
  248. return Ok(JsonView(true));
  249. }
  250. catch (Exception ex)
  251. {
  252. Logs("[response]" + JsonConvert.SerializeObject(dto));
  253. Logs(ex.Message);
  254. return Ok(JsonView(false, ex.Message));
  255. }
  256. }
  257. /// <summary>
  258. /// 接团信息 操作(删除)
  259. /// </summary>
  260. /// <param name="dto"></param>
  261. /// <returns></returns>
  262. [HttpPost]
  263. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  264. public async Task<IActionResult> GroupDel(GroupDelDto dto)
  265. {
  266. try
  267. {
  268. var groupData = await _groupRepository.GroupDel(dto);
  269. if (groupData.Code != 0)
  270. {
  271. return Ok(JsonView(false, groupData.Msg));
  272. }
  273. return Ok(JsonView(true));
  274. }
  275. catch (Exception ex)
  276. {
  277. Logs("[response]" + JsonConvert.SerializeObject(dto));
  278. Logs(ex.Message);
  279. return Ok(JsonView(false, ex.Message));
  280. }
  281. }
  282. /// <summary>
  283. /// 获取团组销售报价号
  284. /// 团组添加时 使用
  285. /// </summary>
  286. /// <returns></returns>
  287. [HttpPost]
  288. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  289. public async Task<IActionResult> GetGroupSalesQuoteNo()
  290. {
  291. var groupData = await _groupRepository.GetGroupSalesQuoteNo();
  292. if (groupData.Code != 0)
  293. {
  294. return Ok(JsonView(false, groupData.Msg));
  295. }
  296. object salesQuoteNo = new
  297. {
  298. SalesQuoteNo = groupData.Data
  299. };
  300. return Ok(JsonView(salesQuoteNo));
  301. }
  302. /// <summary>
  303. /// 设置确认出团
  304. /// </summary>
  305. /// <param name="dto"></param>
  306. /// <returns></returns>
  307. [HttpPost]
  308. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  309. public async Task<IActionResult> SetConfirmationGroup(ConfirmationGroupDto dto)
  310. {
  311. var groupData = await _groupRepository.ConfirmationGroup(dto);
  312. if (groupData.Code != 0)
  313. {
  314. return Ok(JsonView(false, groupData.Msg));
  315. }
  316. GroupStepForDelegation.CreateWorkStep(dto.GroupId); //创建管控流程
  317. return Ok(JsonView(groupData.Data));
  318. }
  319. /// <summary>
  320. /// 获取团组名称 List
  321. /// </summary>
  322. /// <param name="dto"></param>
  323. /// <returns></returns>
  324. [HttpPost]
  325. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  326. public async Task<IActionResult> GetGroupNameList(GroupNameDto dto)
  327. {
  328. var groupData = await _groupRepository.GetGroupNameList(dto);
  329. if (groupData.Code != 0)
  330. {
  331. return Ok(JsonView(false, groupData.Msg));
  332. }
  333. return Ok(JsonView(groupData.Data, groupData.Data.Count));
  334. }
  335. /// <summary>
  336. /// 获取团组名称data And 签证国别Data
  337. /// </summary>
  338. /// <param name="dto"></param>
  339. /// <returns></returns>
  340. [HttpPost]
  341. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  342. public async Task<IActionResult> GetGroupNameAndVisaNationality(GroupNameDto dto)
  343. {
  344. var groupData = await _groupRepository.GetGroupNameAndVisaNationality(dto);
  345. if (groupData.Code != 0)
  346. {
  347. return Ok(JsonView(false, groupData.Msg));
  348. }
  349. return Ok(JsonView(groupData.Data));
  350. }
  351. #endregion
  352. #region 团组&签证
  353. /// <summary>
  354. /// 根据团组Id获取签证客户信息List
  355. /// </summary>
  356. /// <param name="dto">请求dto</param>
  357. /// <returns></returns>
  358. [HttpPost]
  359. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  360. public async Task<IActionResult> GetCrmByGroupId(ClientByGroupIdDto dto)
  361. {
  362. var groupData = await _groupRepository.GetCrmByGroupId(dto);
  363. if (groupData.Code != 0)
  364. {
  365. return Ok(JsonView(false, groupData.Msg));
  366. }
  367. return Ok(JsonView(groupData.Data));
  368. }
  369. #endregion
  370. #region 团组任务分配
  371. /// <summary>
  372. /// 团组任务分配初始化
  373. /// </summary>
  374. /// <param name="dto"></param>
  375. /// <returns></returns>
  376. [HttpPost]
  377. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  378. public async Task<IActionResult> GetTaskAssignmen()
  379. {
  380. var groupData = await _taskAssignmentRep.GetTaskAssignmen();
  381. if (groupData.Code != 0)
  382. {
  383. return Ok(JsonView(false, groupData.Msg));
  384. }
  385. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  386. }
  387. /// <summary>
  388. /// 团组任务分配查询
  389. /// </summary>
  390. /// <param name="dto"></param>
  391. /// <returns></returns>
  392. [HttpPost]
  393. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  394. public async Task<IActionResult> TaskAssignmenQuery(TaskAssignmenQueryDto dto)
  395. {
  396. var groupData = await _taskAssignmentRep.TaskAssignmenQuery(dto);
  397. if (groupData.Code != 0)
  398. {
  399. return Ok(JsonView(false, groupData.Msg));
  400. }
  401. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  402. }
  403. /// <summary>
  404. /// 团组任务分配操作
  405. /// </summary>
  406. /// <param name="dto"></param>
  407. /// <returns></returns>
  408. [HttpPost]
  409. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  410. public async Task<IActionResult> GetTaskAssignmenOp(TaskAssignmenDto dto)
  411. {
  412. Result groupData = await _taskAssignmentRep.GetTaskAssignmenOp(dto);
  413. if (groupData.Code != 0)
  414. {
  415. return Ok(JsonView(false, groupData.Msg));
  416. }
  417. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  418. }
  419. #endregion
  420. #region 团组费用审核
  421. /// <summary>
  422. /// 获取团组费用审核
  423. /// </summary>
  424. /// <param name="paras">参数Json字符串</param>
  425. /// <returns></returns>
  426. [HttpPost]
  427. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  428. public async Task<IActionResult> PostSearchGrpCreditCardPayment(Search_GrpCreditCardPaymentDto _dto)
  429. {
  430. if (_dto.DiId < 1)
  431. {
  432. return Ok(JsonView(false, "团组Id为空"));
  433. }
  434. Grp_CreditCardPaymentView _view = new Grp_CreditCardPaymentView();
  435. #region 团组基本信息
  436. Grp_DelegationInfo _delegation = _groupRepository.Query<Grp_DelegationInfo>(s => s.Id == _dto.DiId).First();
  437. if (_delegation != null)
  438. {
  439. _view.ClientName = _delegation.ClientName;
  440. _view.DiId = _dto.DiId;
  441. _view.TeamName = _delegation.TeamName;
  442. _view.VisitCountry = _delegation.VisitCountry;
  443. _view.VisitDate = _delegation.VisitStartDate.ToString("yyyy-MM-dd") + " ~ " + _delegation.VisitEndDate.ToString("yyyy-MM-dd");
  444. _view.VisitDays = _delegation.VisitDays;
  445. _view.VisitPNumber = _delegation.VisitPNumber;
  446. }
  447. else
  448. {
  449. return Ok(JsonView(false, "团组信息为空"));
  450. }
  451. #endregion
  452. #region 费用清单
  453. var exp = Expressionable.Create<Grp_CreditCardPayment>();
  454. exp.AndIF(_dto.AuditStatus != -1, it => it.IsAuditGM == _dto.AuditStatus);
  455. exp.AndIF(_dto.Label != -1, it => it.CTable == _dto.Label);
  456. List<Grp_CreditCardPayment> entityList = _groupRepository
  457. .Query<Grp_CreditCardPayment>(s => s.DIId == _dto.DiId && s.IsDel == 0 && s.CreateUserId > 0)
  458. .Where(exp.ToExpression())
  459. .ToList();
  460. List<Grp_CreditCardPaymentDetailView> detailList = new List<Grp_CreditCardPaymentDetailView>();
  461. decimal CNY = 0;
  462. decimal PayCNY = 0;
  463. decimal BalanceCNY = 0;
  464. decimal YSFYCNY = 0;
  465. decimal USD = 0;
  466. decimal PayUSD = 0;
  467. decimal BalanceUSD = 0;
  468. decimal YSFYUSD = 0;
  469. decimal EUR = 0;
  470. decimal PayEUR = 0;
  471. decimal BalanceEUR = 0;
  472. decimal YSFYEUR = 0;
  473. foreach (var entity in entityList)
  474. {
  475. Grp_CreditCardPaymentDetailView _detail = new Grp_CreditCardPaymentDetailView();
  476. _detail.Id = entity.Id;
  477. /*
  478. * Bus名称
  479. */
  480. _detail.BusName = "";
  481. /*
  482. *费用所属
  483. */
  484. switch (entity.CTable)
  485. {
  486. case 85:
  487. Grp_AirTicketReservations jpRes = _groupRepository.Query<Grp_AirTicketReservations>(s => s.Id == entity.CId).First();
  488. if (jpRes != null)
  489. {
  490. string FlightsDescription = jpRes.FlightsDescription;
  491. string PriceDescription = jpRes.PriceDescription;
  492. _detail.PriceMsgContent = "航班号:" + jpRes.FlightsCode + "<br/>城市A-B:" + jpRes.FlightsCity + "<br/>航班描述:" + FlightsDescription.Replace("\r\n", "<br />") + "<br/>" + "价格描述:" + PriceDescription;
  493. _detail.PriceNameContent = "(" + jpRes.FlightsCode + ")";
  494. }
  495. break;
  496. case 79:
  497. _detail.BusName = "待增加";
  498. break;
  499. case 98:
  500. Grp_DecreasePayments gdpRes = _groupRepository.Query<Grp_DecreasePayments>(s => s.Id == entity.CId).First();
  501. if (gdpRes != null)
  502. {
  503. _detail.PriceMsgContent = "备注:" + gdpRes.Remark;
  504. _detail.PriceNameContent = gdpRes.PriceName;
  505. }
  506. break;
  507. default:
  508. break;
  509. }
  510. /*
  511. * 费用模块
  512. */
  513. Sys_SetData sdPriceName = _groupRepository.Query<Sys_SetData>(s => s.Id == entity.CTable).First();
  514. if (sdPriceName != null)
  515. {
  516. _detail.PriceName = sdPriceName.Name;
  517. }
  518. /*
  519. * 应付款金额
  520. */
  521. Sys_SetData sdPaymentCurrency_WaitPay = _groupRepository.Query<Sys_SetData>(s => s.Id == entity.PaymentCurrency).First();
  522. string PaymentCurrency_WaitPay = "Unknown";
  523. if (sdPaymentCurrency_WaitPay != null)
  524. {
  525. PaymentCurrency_WaitPay = sdPaymentCurrency_WaitPay.Name;
  526. }
  527. _detail.WaitPay = entity.PayMoney.ToString("#0.00") + " " + PaymentCurrency_WaitPay;
  528. /*
  529. * 此次付款金额
  530. */
  531. decimal CurrPayStr = 0;
  532. if (entity.PayPercentage == 0)
  533. {
  534. if (entity.PayThenMoney != 0)
  535. CurrPayStr = entity.PayThenMoney * entity.DayRate;
  536. }
  537. else
  538. {
  539. CurrPayStr = entity.PayMoney * (decimal.Parse(entity.PayPercentage.ToString("#0.00")) / 100 * entity.DayRate);
  540. }
  541. _detail.CurrPay = CurrPayStr.ToString("#0.00") + " CNY";
  542. /*
  543. * 剩余尾款
  544. */
  545. decimal BalanceStr = 0;
  546. if (entity.PayMoney - (CurrPayStr / entity.DayRate) < 0.01M)
  547. BalanceStr = 0;
  548. else
  549. BalanceStr = (entity.PayMoney - CurrPayStr / entity.DayRate);
  550. _detail.Balance = BalanceStr.ToString("#0.00") + " " + PaymentCurrency_WaitPay;
  551. /*
  552. * 申请人
  553. */
  554. string operatorName = "无";
  555. Sys_Users _opUser = _groupRepository.Query<Sys_Users>(s => s.Id == entity.CreateUserId).First();
  556. if (_opUser != null)
  557. {
  558. operatorName = _opUser.CnName;
  559. }
  560. _detail.OperatorName = operatorName;
  561. /*
  562. * 审核人
  563. */
  564. string auditOperatorName = "Unknown";
  565. if (entity.AuditGMOperate == 0)
  566. auditOperatorName = "无";
  567. else if (entity.AuditGMOperate == 4)
  568. auditOperatorName = "自动审核";
  569. else
  570. {
  571. Sys_Users _adUser = _groupRepository.Query<Sys_Users>(s => s.Id == entity.AuditGMOperate).First();
  572. if (_adUser != null)
  573. {
  574. auditOperatorName = _adUser.CnName;
  575. }
  576. }
  577. _detail.AuditOperatorName = auditOperatorName;
  578. /*
  579. *
  580. * *超预算比例
  581. */
  582. string overBudgetStr = "";
  583. if (entity.ExceedBudget == -1)
  584. overBudgetStr = sdPriceName.Name + "尚无预算";
  585. else if (entity.ExceedBudget == 0)
  586. overBudgetStr = "未超预算";
  587. else
  588. overBudgetStr = entity.ExceedBudget.ToString("P");
  589. _detail.OverBudget = overBudgetStr;
  590. /*
  591. * 费用总计
  592. */
  593. if (entity.PaymentCurrency == 48)
  594. {
  595. CNY += entity.PayMoney;
  596. PayCNY += CurrPayStr;
  597. BalanceCNY += BalanceStr;
  598. YSFYCNY += CurrPayStr;
  599. }
  600. if (entity.PaymentCurrency == 49)
  601. {
  602. USD += entity.PayMoney;
  603. PayUSD += CurrPayStr;
  604. BalanceUSD += BalanceStr;
  605. YSFYUSD += CurrPayStr;
  606. }
  607. if (entity.PaymentCurrency == 51)
  608. {
  609. EUR += entity.PayMoney;
  610. PayEUR += CurrPayStr;
  611. BalanceEUR += BalanceStr;
  612. YSFYEUR += CurrPayStr;
  613. }
  614. _detail.IsAuditGM = entity.IsAuditGM;
  615. detailList.Add(_detail);
  616. }
  617. #endregion
  618. _view.DetailList = new List<Grp_CreditCardPaymentDetailView>(detailList);
  619. _view.TotalStr1 = string.Format(@"应付款总金额:{0}CNY&nbsp;|&nbsp;{1}USD&nbsp;|&nbsp;{2}EUR", CNY, USD, EUR);
  620. _view.TotalStr2 = string.Format(@"此次付款总金额:{0}CNY&nbsp;|&nbsp;{1}USD&nbsp;|&nbsp;{2}EUR", PayCNY, PayUSD, PayEUR);
  621. _view.TotalStr3 = string.Format(@"目前剩余尾款总金额:{0}CNY&nbsp;|&nbsp;{1}USD&nbsp;|&nbsp;{2}EUR", BalanceCNY, BalanceUSD, BalanceEUR);
  622. _view.TotalStr4 = string.Format(@"已审费用总额:{0}CNY&nbsp;|&nbsp;{1}USD&nbsp;|&nbsp;{2}EUR", YSFYCNY, YSFYUSD, YSFYEUR);
  623. return Ok(JsonView(_view));
  624. }
  625. /// <summary>
  626. /// 修改团组费用审核状态
  627. /// </summary>
  628. /// <param name="paras">参数Json字符串</param>
  629. /// <returns></returns>
  630. [HttpPost]
  631. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  632. public async Task<IActionResult> PostAuditGrpCreditCardPayment(Edit_GrpCreditCardPaymentDto _dto)
  633. {
  634. List<string> idList = _dto.CreditIdStr.Split(',').ToList();
  635. Grp_CreditCardPayment _detail = _mapper.Map<Grp_CreditCardPayment>(_dto);
  636. DateTime dtNow = DateTime.Now;
  637. _groupRepository.BeginTran();
  638. int rst = 0;
  639. foreach (var item in idList)
  640. {
  641. int CreditId = int.Parse(item);
  642. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_CreditCardPayment>()
  643. .SetColumns(it => it.IsAuditGM == _dto.AuditCode)
  644. .SetColumns(it => it.AuditGMOperate == _dto.User)
  645. .SetColumns(it => it.AuditGMDate == dtNow.ToString())
  646. .Where(s => s.Id == CreditId)
  647. .ExecuteCommandAsync();
  648. if (result < 1)
  649. {
  650. rst = -1;
  651. }
  652. else
  653. {
  654. _groupRepository.RollbackTran();
  655. return Ok(JsonView(false, "保存失败并回滚!"));
  656. }
  657. }
  658. _groupRepository.CommitTran();
  659. if (rst == 0)
  660. {
  661. return Ok(JsonView(true, "保存成功!"));
  662. }
  663. return Ok(JsonView(false, "保存失败!"));
  664. }
  665. #endregion
  666. #region 机票费用录入
  667. /// <summary>
  668. /// 机票录入当前登录人可操作团组
  669. /// </summary>
  670. /// <param name="dto"></param>
  671. /// <returns></returns>
  672. [HttpPost]
  673. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  674. public async Task<IActionResult> AirTicketResSelect(AirTicketResDto dto)
  675. {
  676. try
  677. {
  678. Result groupData = await _airTicketResRep.AirTicketResSelect(dto);
  679. if (groupData.Code != 0)
  680. {
  681. return Ok(JsonView(false, groupData.Msg));
  682. }
  683. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  684. }
  685. catch (Exception ex)
  686. {
  687. return Ok(JsonView(false, "程序错误!"));
  688. throw;
  689. }
  690. }
  691. /// <summary>
  692. /// 机票费用录入列表
  693. /// </summary>
  694. /// <param name="dto"></param>
  695. /// <returns></returns>
  696. [HttpPost]
  697. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  698. public async Task<IActionResult> AirTicketResList(AirTicketResDto dto)
  699. {
  700. try
  701. {
  702. Result groupData = await _airTicketResRep.AirTicketResList(dto);
  703. if (groupData.Code != 0)
  704. {
  705. return Ok(JsonView(false, groupData.Msg));
  706. }
  707. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  708. }
  709. catch (Exception ex)
  710. {
  711. return Ok(JsonView(false, "程序错误!"));
  712. throw;
  713. }
  714. }
  715. /// <summary>
  716. /// 根据id查询费用录入信息
  717. /// </summary>
  718. /// <param name="dto"></param>
  719. /// <returns></returns>
  720. [HttpPost]
  721. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  722. public async Task<IActionResult> AirTicketResById(AirTicketResByIdDto dto)
  723. {
  724. try
  725. {
  726. Result groupData = await _airTicketResRep.AirTicketResById(dto);
  727. if (groupData.Code != 0)
  728. {
  729. return Ok(JsonView(false, groupData.Msg));
  730. }
  731. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  732. }
  733. catch (Exception ex)
  734. {
  735. return Ok(JsonView(false, "程序错误!"));
  736. throw;
  737. }
  738. }
  739. /// <summary>
  740. /// 机票费用录入操作(Status:1.新增,2.修改)
  741. /// </summary>
  742. /// <param name="dto"></param>
  743. /// <returns></returns>
  744. [HttpPost]
  745. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  746. public async Task<IActionResult> OpAirTicketRes(AirTicketResOpDto dto)
  747. {
  748. try
  749. {
  750. Result groupData = await _airTicketResRep.OpAirTicketRes(dto);
  751. if (groupData.Code != 0)
  752. {
  753. return Ok(JsonView(false, groupData.Msg));
  754. }
  755. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  756. }
  757. catch (Exception ex)
  758. {
  759. return Ok(JsonView(false, "程序错误!"));
  760. throw;
  761. }
  762. }
  763. /// <summary>
  764. /// 机票费用录入,删除
  765. /// </summary>
  766. /// <param name="dto"></param>
  767. /// <returns></returns>
  768. [HttpPost]
  769. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  770. public async Task<IActionResult> DelAirTicketRes(DelBaseDto dto)
  771. {
  772. try
  773. {
  774. var res = await _airTicketResRep.SoftDeleteByIdAsync<Grp_AirTicketReservations>(dto.Id.ToString(), dto.DeleteUserId);
  775. if (!res)
  776. {
  777. return Ok(JsonView(false, "删除失败"));
  778. }
  779. return Ok(JsonView(true, "删除成功!"));
  780. }
  781. catch (Exception ex)
  782. {
  783. return Ok(JsonView(false, "程序错误!"));
  784. throw;
  785. }
  786. }
  787. /// <summary>
  788. /// 导出机票录入报表
  789. /// </summary>
  790. /// <param name="dto"></param>
  791. /// <returns></returns>
  792. [HttpPost]
  793. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  794. public async Task<IActionResult> DeriveAirTicketRes(AirTicketResDto dto)
  795. {
  796. try
  797. {
  798. Result groupData = await _airTicketResRep.DeriveAirTicketRes(dto);
  799. if (groupData.Code != 0)
  800. {
  801. return Ok(JsonView(false, groupData.Msg));
  802. }
  803. else
  804. {
  805. List<AirTicketReservationsPayView> AirTicketReservations = groupData.Data.GetType().GetProperty("AirTicketRes").GetValue(groupData.Data);
  806. if (AirTicketReservations.Count != 0)
  807. {
  808. Grp_DelegationInfo DelegationInfo = groupData.Data.GetType().GetProperty("Delegation").GetValue(groupData.Data);
  809. Sys_Users _Users = groupData.Data.GetType().GetProperty("Users").GetValue(groupData.Data);
  810. string diCode = DelegationInfo != null ? DelegationInfo.TourCode : "XXX";
  811. string diName = DelegationInfo != null ? DelegationInfo.TeamName : "XXX";
  812. WorkbookDesigner designer = new WorkbookDesigner();
  813. designer.Workbook = new Workbook(AppSettingsHelper.Get("ExcelBasePath") + "Template/机票预订费用报表模板.xlsx");
  814. decimal countCost = 0;
  815. foreach (var item in AirTicketReservations)
  816. {
  817. if (item.BankType == "其他")
  818. {
  819. item.BankNo = "--";
  820. }
  821. else
  822. {
  823. item.BankNo = item.BankType + ":" + item.BankNo.Substring(0, 3);
  824. }
  825. item.PrePrice = System.Decimal.Round(item.PrePrice, 2);
  826. item.Price = System.Decimal.Round(item.Price, 2);
  827. countCost += Convert.ToDecimal(item.Price);
  828. }
  829. designer.SetDataSource("Export", AirTicketReservations);
  830. designer.SetDataSource("ExportDiCode", diCode);
  831. designer.SetDataSource("ExportDiName", diName);
  832. designer.SetDataSource("ExportOpUserName", _Users.CnName);
  833. designer.SetDataSource("ExportCountCost", countCost + "(" + AirTicketReservations[0].CurrencyStr);
  834. designer.Process();
  835. string fileName = "AirfareStatement/" + diName + "机票费用报表" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
  836. designer.Workbook.Save(AppSettingsHelper.Get("ExcelBasePath") + fileName);
  837. string rst = AppSettingsHelper.Get("ExcelBaseUrl") + AppSettingsHelper.Get("ExcelFtpPath") + fileName;
  838. return Ok(JsonView(true, "成功", url = rst));
  839. }
  840. else
  841. {
  842. return Ok(JsonView(false, "暂无数据!"));
  843. }
  844. }
  845. }
  846. catch (Exception ex)
  847. {
  848. return Ok(JsonView(false, "程序错误!"));
  849. throw;
  850. }
  851. }
  852. Dictionary<string, string> transDic = new Dictionary<string, string>();
  853. /// <summary>
  854. /// 行程单导出
  855. /// </summary>
  856. /// <param name="dto"></param>
  857. /// <returns></returns>
  858. [HttpPost]
  859. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  860. public async Task<IActionResult> ItineraryAirTicketRes(ItineraryAirTicketResDto dto)
  861. {
  862. try
  863. {
  864. Result groupData = await _airTicketResRep.ItineraryAirTicketRes(dto);
  865. if (groupData.Code != 0)
  866. {
  867. return Ok(JsonView(false, groupData.Msg));
  868. }
  869. else
  870. {
  871. List<AirTicketReservationsView> _AirTicketReservations = groupData.Data;
  872. if (dto.Language == "CN")
  873. {
  874. Document doc = new Document(AppSettingsHelper.Get("WordBasePath") + "Template/电子客票行程单模板_CN.docx");
  875. DocumentBuilder builder = new DocumentBuilder(doc);
  876. int tableIndex = 0;//表格索引
  877. //得到文档中的第一个表格
  878. Table table = (Table)doc.GetChild(NodeType.Table, tableIndex, true);
  879. foreach (var item in _AirTicketReservations)
  880. {
  881. #region 处理固定数据
  882. string[] FlightsCode = item.FlightsCode.Split('/');
  883. if (FlightsCode.Length != 0)
  884. {
  885. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  886. if (_AirCompany != null)
  887. {
  888. table.Range.Bookmarks["AirlineCompany"].Text = _AirCompany.CnName;
  889. }
  890. else
  891. {
  892. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  893. }
  894. }
  895. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  896. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  897. string[] nameArray = Regex.Split(item.ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  898. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  899. string name = "";
  900. foreach (string clientName in nameArray)
  901. {
  902. if (!name.Contains(clientName))
  903. {
  904. name += clientName + ",";
  905. }
  906. }
  907. if (!string.IsNullOrWhiteSpace(name))
  908. {
  909. table.Range.Bookmarks["ClientName"].Text = name.Substring(0, name.Length - 1);
  910. }
  911. else
  912. {
  913. table.Range.Bookmarks["ClientName"].Text = "--";
  914. }
  915. table.Range.Bookmarks["TicketNumber"].Text = "--";
  916. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  917. table.Range.Bookmarks["JointTicket"].Text = "--";
  918. table.Range.Bookmarks["TimeIssue"].Text = "--";
  919. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  920. table.Range.Bookmarks["NavigationCode"].Text = "--";
  921. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  922. table.Range.Bookmarks["AgentPhone"].Text = "--";
  923. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  924. #endregion
  925. #region 循环数据处理
  926. List<AirInfo> airs = new List<AirInfo>();
  927. string[] DayArray = Regex.Split(item.FlightsDescription, "\\d+\\.", RegexOptions.IgnoreCase);
  928. DayArray = DayArray.Where(s => s != " " && s != "" && !string.IsNullOrEmpty(s)).ToArray();
  929. for (int i = 0; i < FlightsCode.Length; i++)
  930. {
  931. AirInfo air = new AirInfo();
  932. string[] tempstr = DayArray[i]
  933. .Replace("\r\n", string.Empty)
  934. .Replace("\\r\\n", string.Empty)
  935. .TrimStart().TrimEnd()
  936. .Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  937. Res_ThreeCode star_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(0, 3));
  938. string starCity = "";
  939. if (star_Three != null)
  940. {
  941. starCity = star_Three.AirPort;
  942. }
  943. Res_ThreeCode End_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(3, 3));
  944. string EndCity = "";
  945. if (End_Three != null)
  946. {
  947. EndCity = End_Three.AirPort;
  948. }
  949. air.Destination = starCity + "/" + EndCity;
  950. air.Flight = FlightsCode[i];
  951. air.SeatingClass = item.CTypeName;
  952. string dateTime = tempstr[2];
  953. string DateTemp = dateTime.Substring(2, 5).ToUpper();
  954. air.FlightDate = DateTemp;
  955. air.DepartureTime = tempstr[5];
  956. air.LandingTime = tempstr[6];
  957. air.ValidityPeriod = DateTemp + "/" + DateTemp;
  958. air.TicketStatus = "--";
  959. air.Luggage = "--";
  960. air.DepartureTerminal = "--";
  961. air.LandingTerminal = "--";
  962. airs.Add(air);
  963. }
  964. int row = 13;
  965. for (int i = 0; i < airs.Count; i++)
  966. {
  967. if (airs.Count > 2)
  968. {
  969. for (int j = 0; j < airs.Count - 2; j++)
  970. {
  971. var CopyRow = table.Rows[12].Clone(true);
  972. table.Rows.Add(CopyRow);
  973. }
  974. }
  975. PropertyInfo[] properties = airs[i].GetType().GetProperties();
  976. int index = 0;
  977. foreach (PropertyInfo property in properties)
  978. {
  979. string value = property.GetValue(airs[i]).ToString();
  980. Cell ishcel0 = table.Rows[row].Cells[index];
  981. Paragraph p = new Paragraph(doc);
  982. string s = value;
  983. p.AppendChild(new Run(doc, s));
  984. p.ParagraphFormat.Alignment = ParagraphAlignment.Center;//水平居中对齐
  985. ishcel0.AppendChild(p);
  986. ishcel0.CellFormat.VerticalAlignment = CellVerticalAlignment.Center;//垂直居中对齐
  987. index++;
  988. }
  989. row++;
  990. }
  991. #endregion
  992. Paragraph lastParagraph = new Paragraph(doc);
  993. //第一个表格末尾加段落
  994. table.ParentNode.InsertAfter(lastParagraph, table);
  995. //复制第一个表格
  996. Table cloneTable = (Table)table.Clone(true);
  997. //在文档末尾段落后面加入复制的表格
  998. table.ParentNode.InsertAfter(cloneTable, lastParagraph);
  999. if (item != _AirTicketReservations[_AirTicketReservations.Count - 1])
  1000. {
  1001. int rownewsIndex = 13;
  1002. for (int i = 0; i < 2; i++)
  1003. {
  1004. var CopyRow = table.Rows[12].Clone(true);
  1005. table.Rows.RemoveAt(13);
  1006. table.Rows.Add(CopyRow);
  1007. rownewsIndex++;
  1008. }
  1009. }
  1010. else
  1011. {
  1012. table.Rows.RemoveAt(12);
  1013. }
  1014. cloneTable.Rows.RemoveAt(12);
  1015. }
  1016. if (_AirTicketReservations.Count != 0)
  1017. {
  1018. string[] FlightsCode = _AirTicketReservations[0].FlightsCode.Split('/');
  1019. if (FlightsCode.Length != 0)
  1020. {
  1021. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1022. if (_AirCompany != null)
  1023. {
  1024. table.Range.Bookmarks["AirlineCompany"].Text = _AirCompany.CnName;
  1025. }
  1026. else
  1027. {
  1028. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  1029. }
  1030. }
  1031. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  1032. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  1033. string[] nameArray = Regex.Split(_AirTicketReservations[0].ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1034. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1035. string name = "";
  1036. foreach (string clientName in nameArray)
  1037. {
  1038. if (!name.Contains(clientName))
  1039. {
  1040. name += clientName + ",";
  1041. }
  1042. }
  1043. if (!string.IsNullOrWhiteSpace(name))
  1044. {
  1045. table.Range.Bookmarks["ClientName"].Text = name.Substring(0, name.Length - 1);
  1046. }
  1047. else
  1048. {
  1049. table.Range.Bookmarks["ClientName"].Text = "--";
  1050. }
  1051. table.Range.Bookmarks["TicketNumber"].Text = "--";
  1052. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  1053. table.Range.Bookmarks["JointTicket"].Text = "--";
  1054. table.Range.Bookmarks["TimeIssue"].Text = "--";
  1055. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  1056. table.Range.Bookmarks["NavigationCode"].Text = "--";
  1057. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  1058. table.Range.Bookmarks["AgentPhone"].Text = "--";
  1059. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  1060. }
  1061. doc.MailMerge.Execute(new[] { "PageCount" }, new object[] { doc.PageCount });
  1062. //保存合并后的文档
  1063. string fileName = "AirItinerary/电子客票中文行程单_CN.docx";
  1064. string rst = AppSettingsHelper.Get("WordBaseUrl") + AppSettingsHelper.Get("WordFtpPath") + fileName;
  1065. doc.Save(AppSettingsHelper.Get("WordBasePath") + fileName);
  1066. return Ok(JsonView(true, "成功!", rst));
  1067. }
  1068. else
  1069. {
  1070. Document doc = new Document(AppSettingsHelper.Get("WordBasePath") + "Template/电子客票行程单模板_EN.docx");
  1071. DocumentBuilder builder = new DocumentBuilder(doc);
  1072. int tableIndex = 0;//表格索引
  1073. //得到文档中的第一个表格
  1074. Table table = (Table)doc.GetChild(NodeType.Table, tableIndex, true);
  1075. List<string> texts = new List<string>();
  1076. foreach (var item in _AirTicketReservations)
  1077. {
  1078. string[] FlightsCode = item.FlightsCode.Split('/');
  1079. if (FlightsCode.Length != 0)
  1080. {
  1081. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1082. if (_AirCompany != null)
  1083. {
  1084. if (!transDic.ContainsKey(_AirCompany.CnName))
  1085. {
  1086. transDic.Add(_AirCompany.CnName, _AirCompany.EnName);
  1087. }
  1088. }
  1089. else
  1090. {
  1091. if (!transDic.ContainsKey("--"))
  1092. {
  1093. transDic.Add("--", "--");
  1094. }
  1095. }
  1096. }
  1097. string[] nameArray = Regex.Split(item.ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1098. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1099. string name = "";
  1100. foreach (string clientName in nameArray)
  1101. {
  1102. name += clientName + ",";
  1103. }
  1104. if (!texts.Contains(name))
  1105. {
  1106. texts.Add(name);
  1107. }
  1108. List<AirInfo> airs = new List<AirInfo>();
  1109. string[] DayArray = Regex.Split(item.FlightsDescription, "\\d+\\.", RegexOptions.IgnoreCase);
  1110. DayArray = DayArray.Where(s => s != " " && s != "" && !string.IsNullOrEmpty(s)).ToArray();
  1111. for (int i = 0; i < FlightsCode.Length; i++)
  1112. {
  1113. AirInfo air = new AirInfo();
  1114. string[] tempstr = DayArray[i]
  1115. .Replace("\r\n", string.Empty)
  1116. .Replace("\\r\\n", string.Empty)
  1117. .TrimStart().TrimEnd()
  1118. .Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1119. Res_ThreeCode star_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(0, 3));
  1120. if (star_Three != null)
  1121. {
  1122. if (!transDic.ContainsKey(star_Three.AirPort))
  1123. {
  1124. transDic.Add(star_Three.AirPort, star_Three.AirPort_En);
  1125. }
  1126. }
  1127. Res_ThreeCode End_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(3, 3));
  1128. if (End_Three != null)
  1129. {
  1130. if (!transDic.ContainsKey(End_Three.AirPort))
  1131. {
  1132. transDic.Add(End_Three.AirPort, End_Three.AirPort_En);
  1133. }
  1134. }
  1135. if (!texts.Contains(item.CTypeName))
  1136. {
  1137. texts.Add(item.CTypeName);
  1138. }
  1139. }
  1140. }
  1141. List<TranslateResult> transData = _airTicketResRep.ReTransBatch(texts, "en");
  1142. if (transData.Count > 0)
  1143. {
  1144. foreach (TranslateResult item in transData)
  1145. {
  1146. if (!transDic.ContainsKey(item.Query))
  1147. {
  1148. transDic.Add(item.Query, item.Translation);
  1149. }
  1150. }
  1151. }
  1152. foreach (var item in _AirTicketReservations)
  1153. {
  1154. #region 处理固定数据
  1155. string[] FlightsCode = item.FlightsCode.Split('/');
  1156. if (FlightsCode.Length != 0)
  1157. {
  1158. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1159. if (_AirCompany != null)
  1160. {
  1161. string str = "--";
  1162. string translateResult = transDic.Where(s => s.Key == _AirCompany.CnName).FirstOrDefault().Value;
  1163. if (!string.IsNullOrEmpty(translateResult))
  1164. {
  1165. str = translateResult;
  1166. str = _airTicketResRep.Processing(str);
  1167. }
  1168. table.Range.Bookmarks["AirlineCompany"].Text = str;
  1169. }
  1170. else
  1171. {
  1172. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  1173. }
  1174. }
  1175. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  1176. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  1177. string[] nameArray = Regex.Split(item.ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1178. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1179. string names = "";
  1180. foreach (string clientName in nameArray)
  1181. {
  1182. names += clientName + ",";
  1183. }
  1184. if (!string.IsNullOrWhiteSpace(names))
  1185. {
  1186. string str = "--";
  1187. string translateResult = transDic.Where(s => s.Key == names).FirstOrDefault().Value;
  1188. if (!string.IsNullOrEmpty(translateResult))
  1189. {
  1190. str = translateResult;
  1191. str = _airTicketResRep.Processing(str);
  1192. }
  1193. table.Range.Bookmarks["ClientName"].Text = str;
  1194. }
  1195. else
  1196. {
  1197. table.Range.Bookmarks["ClientName"].Text = "--";
  1198. }
  1199. table.Range.Bookmarks["TicketNumber"].Text = "--";
  1200. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  1201. table.Range.Bookmarks["JointTicket"].Text = "--";
  1202. table.Range.Bookmarks["TimeIssue"].Text = "--";
  1203. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  1204. table.Range.Bookmarks["NavigationCode"].Text = "--";
  1205. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  1206. table.Range.Bookmarks["AgentPhone"].Text = "--";
  1207. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  1208. #endregion
  1209. #region 循环数据处理
  1210. List<AirInfo> airs = new List<AirInfo>();
  1211. string[] DayArray = Regex.Split(item.FlightsDescription, "\\d+\\.", RegexOptions.IgnoreCase);
  1212. DayArray = DayArray.Where(s => s != " " && s != "" && !string.IsNullOrEmpty(s)).ToArray();
  1213. for (int i = 0; i < FlightsCode.Length; i++)
  1214. {
  1215. AirInfo air = new AirInfo();
  1216. string[] tempstr = DayArray[i]
  1217. .Replace("\r\n", string.Empty)
  1218. .Replace("\\r\\n", string.Empty)
  1219. .TrimStart().TrimEnd()
  1220. .Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1221. Res_ThreeCode star_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(0, 3));
  1222. string starCity = "";
  1223. if (star_Three != null)
  1224. {
  1225. string str2 = "--";
  1226. string translateResult2 = transDic.Where(s => s.Key == star_Three.AirPort).FirstOrDefault().Value;
  1227. if (!string.IsNullOrEmpty(translateResult2))
  1228. {
  1229. str2 = translateResult2;
  1230. str2 = _airTicketResRep.Processing(str2);
  1231. }
  1232. starCity = str2;
  1233. }
  1234. Res_ThreeCode End_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(3, 3));
  1235. string EndCity = "";
  1236. if (End_Three != null)
  1237. {
  1238. string str1 = "--";
  1239. string translateResult1 = transDic.Where(s => s.Key == End_Three.AirPort).FirstOrDefault().Value;
  1240. if (!string.IsNullOrEmpty(translateResult1))
  1241. {
  1242. str1 = translateResult1;
  1243. str1 = _airTicketResRep.Processing(str1);
  1244. }
  1245. EndCity = str1;
  1246. }
  1247. air.Destination = starCity + "/" + EndCity;
  1248. air.Flight = FlightsCode[i];
  1249. string str = "--";
  1250. string translateResult = transDic.Where(s => s.Key == item.CTypeName).FirstOrDefault().Value;
  1251. if (!string.IsNullOrEmpty(translateResult))
  1252. {
  1253. str = translateResult;
  1254. str = _airTicketResRep.Processing(str);
  1255. }
  1256. air.SeatingClass = str;
  1257. string dateTime = tempstr[2];
  1258. string DateTemp = dateTime.Substring(2, 5).ToUpper();
  1259. air.FlightDate = DateTemp;
  1260. air.DepartureTime = tempstr[5];
  1261. air.LandingTime = tempstr[6];
  1262. air.ValidityPeriod = DateTemp + "/" + DateTemp;
  1263. air.TicketStatus = "--";
  1264. air.Luggage = "--";
  1265. air.DepartureTerminal = "--";
  1266. air.LandingTerminal = "--";
  1267. airs.Add(air);
  1268. }
  1269. int row = 13;
  1270. for (int i = 0; i < airs.Count; i++)
  1271. {
  1272. if (airs.Count > 2)
  1273. {
  1274. for (int j = 0; j < airs.Count - 2; j++)
  1275. {
  1276. var CopyRow = table.Rows[12].Clone(true);
  1277. table.Rows.Add(CopyRow);
  1278. }
  1279. }
  1280. PropertyInfo[] properties = airs[i].GetType().GetProperties();
  1281. int index = 0;
  1282. foreach (PropertyInfo property in properties)
  1283. {
  1284. string value = property.GetValue(airs[i]).ToString();
  1285. Cell ishcel0 = table.Rows[row].Cells[index];
  1286. Paragraph p = new Paragraph(doc);
  1287. string s = value;
  1288. p.AppendChild(new Run(doc, s));
  1289. p.ParagraphFormat.Alignment = ParagraphAlignment.Center;//水平居中对齐
  1290. ishcel0.AppendChild(p);
  1291. ishcel0.CellFormat.VerticalAlignment = CellVerticalAlignment.Center;//垂直居中对齐
  1292. //ishcel0.CellFormat.VerticalAlignment=
  1293. index++;
  1294. }
  1295. row++;
  1296. }
  1297. #endregion
  1298. Paragraph lastParagraph = new Paragraph(doc);
  1299. //第一个表格末尾加段落
  1300. table.ParentNode.InsertAfter(lastParagraph, table);
  1301. //复制第一个表格
  1302. Table cloneTable = (Table)table.Clone(true);
  1303. //在文档末尾段落后面加入复制的表格
  1304. table.ParentNode.InsertAfter(cloneTable, lastParagraph);
  1305. if (item != _AirTicketReservations[_AirTicketReservations.Count - 1])
  1306. {
  1307. int rownewsIndex = 13;
  1308. for (int i = 0; i < 2; i++)
  1309. {
  1310. var CopyRow = table.Rows[12].Clone(true);
  1311. table.Rows.RemoveAt(13);
  1312. table.Rows.Add(CopyRow);
  1313. rownewsIndex++;
  1314. }
  1315. }
  1316. else
  1317. {
  1318. table.Rows.RemoveAt(12);
  1319. }
  1320. cloneTable.Rows.RemoveAt(12);
  1321. }
  1322. if (_AirTicketReservations.Count != 0)
  1323. {
  1324. string[] FlightsCode = _AirTicketReservations[0].FlightsCode.Split('/');
  1325. if (FlightsCode.Length != 0)
  1326. {
  1327. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1328. if (_AirCompany != null)
  1329. {
  1330. string str = "--";
  1331. string translateResult = transDic.Where(s => s.Key == _AirCompany.CnName).FirstOrDefault().Value;
  1332. if (!string.IsNullOrEmpty(translateResult))
  1333. {
  1334. str = translateResult;
  1335. str = _airTicketResRep.Processing(str);
  1336. }
  1337. table.Range.Bookmarks["AirlineCompany"].Text = str;
  1338. }
  1339. else
  1340. {
  1341. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  1342. }
  1343. }
  1344. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  1345. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  1346. string[] nameArray = Regex.Split(_AirTicketReservations[0].ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1347. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1348. string names = "";
  1349. foreach (string clientName in nameArray)
  1350. {
  1351. names += clientName + ",";
  1352. }
  1353. if (!string.IsNullOrWhiteSpace(names))
  1354. {
  1355. string str = "--";
  1356. string translateResult = transDic.Where(s => s.Key == names).FirstOrDefault().Value;
  1357. if (!string.IsNullOrEmpty(translateResult))
  1358. {
  1359. str = translateResult;
  1360. str = _airTicketResRep.Processing(str);
  1361. }
  1362. table.Range.Bookmarks["ClientName"].Text = str;
  1363. }
  1364. else
  1365. {
  1366. table.Range.Bookmarks["ClientName"].Text = "--";
  1367. }
  1368. table.Range.Bookmarks["TicketNumber"].Text = "--";
  1369. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  1370. table.Range.Bookmarks["JointTicket"].Text = "--";
  1371. table.Range.Bookmarks["TimeIssue"].Text = "--";
  1372. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  1373. table.Range.Bookmarks["NavigationCode"].Text = "--";
  1374. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  1375. table.Range.Bookmarks["AgentPhone"].Text = "--";
  1376. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  1377. }
  1378. doc.MailMerge.Execute(new[] { "PageCount" }, new object[] { doc.PageCount });
  1379. //保存合并后的文档
  1380. string fileName = "AirItinerary/电子客票英文行程单_EN.docx";
  1381. string rst = AppSettingsHelper.Get("WordBaseUrl") + AppSettingsHelper.Get("WordFtpPath") + fileName;
  1382. doc.Save(AppSettingsHelper.Get("WordBasePath") + fileName);
  1383. return Ok(JsonView(true, "成功!", rst));
  1384. }
  1385. }
  1386. }
  1387. catch (Exception ex)
  1388. {
  1389. return Ok(JsonView(false, "程序错误!"));
  1390. throw;
  1391. }
  1392. }
  1393. #endregion
  1394. #region 团组增减款项
  1395. /// <summary>
  1396. /// 团组增减款项下拉框绑定
  1397. /// </summary>
  1398. /// <param name="dto"></param>
  1399. /// <returns></returns>
  1400. [HttpPost]
  1401. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1402. public async Task<IActionResult> DecreasePaymentsSelect(DecreasePaymentsDto dto)
  1403. {
  1404. try
  1405. {
  1406. Result groupData = await _decreasePaymentsRep.DecreasePaymentsSelect(dto);
  1407. if (groupData.Code != 0)
  1408. {
  1409. return Ok(JsonView(false, groupData.Msg));
  1410. }
  1411. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1412. }
  1413. catch (Exception ex)
  1414. {
  1415. return Ok(JsonView(false, "程序错误!"));
  1416. throw;
  1417. }
  1418. }
  1419. /// <summary>
  1420. /// 根据团组Id查询团组增减款项
  1421. /// </summary>
  1422. /// <param name="dto"></param>
  1423. /// <returns></returns>
  1424. [HttpPost]
  1425. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1426. public async Task<IActionResult> DecreasePaymentsList(DecreasePaymentsListDto dto)
  1427. {
  1428. try
  1429. {
  1430. Result groupData = await _decreasePaymentsRep.DecreasePaymentsList(dto);
  1431. if (groupData.Code != 0)
  1432. {
  1433. return Ok(JsonView(false, groupData.Msg));
  1434. }
  1435. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1436. }
  1437. catch (Exception ex)
  1438. {
  1439. return Ok(JsonView(false, "程序错误!"));
  1440. throw;
  1441. }
  1442. }
  1443. /// <summary>
  1444. /// 团组增减款项操作(Status:1.新增,2.修改)
  1445. /// </summary>
  1446. /// <param name="dto"></param>
  1447. /// <returns></returns>
  1448. [HttpPost]
  1449. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1450. public async Task<IActionResult> OpDecreasePayments(DecreasePaymentsOpDto dto)
  1451. {
  1452. try
  1453. {
  1454. Result groupData = await _decreasePaymentsRep.OpDecreasePayments(dto);
  1455. if (groupData.Code != 0)
  1456. {
  1457. return Ok(JsonView(false, groupData.Msg));
  1458. }
  1459. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1460. }
  1461. catch (Exception ex)
  1462. {
  1463. return Ok(JsonView(false, "程序错误!"));
  1464. throw;
  1465. }
  1466. }
  1467. /// <summary>
  1468. /// 团组增减款项操作 删除
  1469. /// </summary>
  1470. /// <param name="dto"></param>
  1471. /// <returns></returns>
  1472. [HttpPost]
  1473. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1474. public async Task<IActionResult> DelDecreasePayments(DelBaseDto dto)
  1475. {
  1476. try
  1477. {
  1478. var res = await _decreasePaymentsRep.SoftDeleteByIdAsync<Grp_DecreasePayments>(dto.Id.ToString(), dto.DeleteUserId);
  1479. if (!res)
  1480. {
  1481. return Ok(JsonView(false, "删除失败"));
  1482. }
  1483. return Ok(JsonView(true, "删除成功!"));
  1484. }
  1485. catch (Exception ex)
  1486. {
  1487. return Ok(JsonView(false, "程序错误!"));
  1488. throw;
  1489. }
  1490. }
  1491. /// <summary>
  1492. /// 根据团组增减款项Id查询
  1493. /// </summary>
  1494. /// <param name="dto"></param>
  1495. /// <returns></returns>
  1496. [HttpPost]
  1497. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1498. public async Task<IActionResult> QueryDecreasePaymentsById(DecreasePaymentsByIdDto dto)
  1499. {
  1500. try
  1501. {
  1502. Result groupData = await _decreasePaymentsRep.QueryDecreasePaymentsById(dto);
  1503. if (groupData.Code != 0)
  1504. {
  1505. return Ok(JsonView(false, groupData.Msg));
  1506. }
  1507. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1508. }
  1509. catch (Exception ex)
  1510. {
  1511. return Ok(JsonView(false, "程序错误!"));
  1512. throw;
  1513. }
  1514. }
  1515. #endregion
  1516. #region 文件上传、删除
  1517. /// <summary>
  1518. /// region 文件上传 可以带参数
  1519. /// </summary>
  1520. /// <param name="file"></param>
  1521. /// <returns></returns>
  1522. [HttpPost]
  1523. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1524. public async Task<IActionResult> UploadProject(IFormFile file)
  1525. {
  1526. try
  1527. {
  1528. var TypeName = Request.Headers["TypeName"].ToString();
  1529. if (file != null)
  1530. {
  1531. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  1532. //文件名称
  1533. string projectFileName = file.FileName;
  1534. //上传的文件的路径
  1535. string filePath = "";
  1536. if (TypeName == "A")//A代表团组增减款项
  1537. {
  1538. if (!Directory.Exists(fileDir))
  1539. {
  1540. Directory.CreateDirectory(fileDir);
  1541. }
  1542. //上传的文件的路径
  1543. filePath = fileDir + $@"\团组增减款项相关文件\{projectFileName}";
  1544. }
  1545. else if (TypeName == "B")//B代表商邀相关文件
  1546. {
  1547. if (!Directory.Exists(fileDir))
  1548. {
  1549. Directory.CreateDirectory(fileDir);
  1550. }
  1551. //上传的文件的路径
  1552. filePath = fileDir + $@"\商邀相关文件\{projectFileName}";
  1553. }
  1554. using (FileStream fs = System.IO.File.Create(filePath))
  1555. {
  1556. file.CopyTo(fs);
  1557. fs.Flush();
  1558. }
  1559. return Ok(JsonView(true, "上传成功!", projectFileName));
  1560. }
  1561. else
  1562. {
  1563. return Ok(JsonView(false, "上传失败!"));
  1564. }
  1565. }
  1566. catch (Exception ex)
  1567. {
  1568. return Ok(JsonView(false, "程序错误!"));
  1569. throw;
  1570. }
  1571. }
  1572. /// <summary>
  1573. /// 删除指定文件
  1574. /// </summary>
  1575. /// <param name="dto"></param>
  1576. /// <returns></returns>
  1577. [HttpPost]
  1578. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1579. public async Task<IActionResult> DelFile(DelFileDto dto)
  1580. {
  1581. try
  1582. {
  1583. var TypeName = Request.Headers["TypeName"].ToString();
  1584. string filePath = "";
  1585. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  1586. // 返回与指定虚拟路径相对应的物理路径即绝对路径
  1587. int id = 0;
  1588. if (TypeName == "A")
  1589. {
  1590. filePath = fileDir + "/团组增减款项相关文件/" + dto.fileName;
  1591. // 删除该文件
  1592. System.IO.File.Delete(filePath);
  1593. id = await _sqlSugar.Updateable<Grp_DecreasePayments>().Where(a => a.Id == dto.Id).SetColumns(a => new Grp_DecreasePayments { FilePath = "" }).ExecuteCommandAsync();
  1594. }
  1595. else if (TypeName == "B")
  1596. {
  1597. filePath = fileDir + "/商邀相关文件/" + dto.fileName;
  1598. // 删除该文件
  1599. System.IO.File.Delete(filePath);
  1600. id = await _sqlSugar.Updateable<Grp_InvitationOfficialActivities>().Where(a => a.Id == dto.Id).SetColumns(a => new Grp_InvitationOfficialActivities { Attachment = "" }).ExecuteCommandAsync();
  1601. }
  1602. if (id != 0)
  1603. {
  1604. return Ok(JsonView(true, "成功!"));
  1605. }
  1606. else
  1607. {
  1608. return Ok(JsonView(false, "失败!"));
  1609. }
  1610. }
  1611. catch (Exception ex)
  1612. {
  1613. return Ok(JsonView(false, "程序错误!"));
  1614. throw;
  1615. }
  1616. }
  1617. #endregion
  1618. #region 商邀费用录入
  1619. /// <summary>
  1620. /// 根据团组Id查询商邀费用列表
  1621. /// </summary>
  1622. /// <param name="dto"></param>
  1623. /// <returns></returns>
  1624. [HttpPost]
  1625. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1626. public async Task<IActionResult> InvitationOfficialActivitiesList(InvitationOfficialActivitiesListDto dto)
  1627. {
  1628. try
  1629. {
  1630. Result groupData = await _InvitationOfficialActivitiesRep.InvitationOfficialActivitiesList(dto);
  1631. if (groupData.Code != 0)
  1632. {
  1633. return Ok(JsonView(false, groupData.Msg));
  1634. }
  1635. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1636. }
  1637. catch (Exception ex)
  1638. {
  1639. return Ok(JsonView(false, "程序错误!"));
  1640. throw;
  1641. }
  1642. }
  1643. /// <summary>
  1644. /// 根据商邀费用ID查询C表和商邀费用数据
  1645. /// </summary>
  1646. /// <param name="dto"></param>
  1647. /// <returns></returns>
  1648. [HttpPost]
  1649. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1650. public async Task<IActionResult> InvitationOfficialActivitiesById(InvitationOfficialActivitiesByIdDto dto)
  1651. {
  1652. try
  1653. {
  1654. Result groupData = await _InvitationOfficialActivitiesRep.InvitationOfficialActivitiesById(dto);
  1655. if (groupData.Code != 0)
  1656. {
  1657. return Ok(JsonView(false, groupData.Msg));
  1658. }
  1659. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1660. }
  1661. catch (Exception ex)
  1662. {
  1663. return Ok(JsonView(false, "程序错误!"));
  1664. throw;
  1665. }
  1666. }
  1667. /// <summary>
  1668. /// 商邀费用录入操作(Status:1.新增,2.修改)
  1669. /// </summary>
  1670. /// <param name="dto"></param>
  1671. /// <returns></returns>
  1672. [HttpPost]
  1673. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1674. public async Task<IActionResult> OpInvitationOfficialActivities(OpInvitationOfficialActivitiesDto dto)
  1675. {
  1676. try
  1677. {
  1678. Result groupData = await _InvitationOfficialActivitiesRep.OpInvitationOfficialActivities(dto);
  1679. if (groupData.Code != 0)
  1680. {
  1681. return Ok(JsonView(false, groupData.Msg));
  1682. }
  1683. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1684. }
  1685. catch (Exception ex)
  1686. {
  1687. return Ok(JsonView(false, "程序错误!"));
  1688. throw;
  1689. }
  1690. }
  1691. /// <summary>
  1692. /// 商邀删除
  1693. /// </summary>
  1694. /// <param name="dto"></param>
  1695. /// <returns></returns>
  1696. [HttpPost]
  1697. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1698. public async Task<IActionResult> DelInvitationOfficialActivities(DelBaseDto dto)
  1699. {
  1700. try
  1701. {
  1702. var res = await _InvitationOfficialActivitiesRep.SoftDeleteByIdAsync<Grp_InvitationOfficialActivities>(dto.Id.ToString(), dto.DeleteUserId);
  1703. if (!res)
  1704. {
  1705. return Ok(JsonView(false, "删除失败"));
  1706. }
  1707. return Ok(JsonView(true, "删除成功!"));
  1708. }
  1709. catch (Exception ex)
  1710. {
  1711. return Ok(JsonView(false, "程序错误!"));
  1712. throw;
  1713. }
  1714. }
  1715. #endregion
  1716. #region 团组英文资料
  1717. /// <summary>
  1718. /// 查询团组英文所有资料
  1719. /// </summary>
  1720. /// <param name="dto"></param>
  1721. /// <returns></returns>
  1722. [HttpPost]
  1723. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1724. public async Task<IActionResult> QueryDelegationEnData(QueryDelegationEnDataDto dto)
  1725. {
  1726. try
  1727. {
  1728. Result groupData = await _delegationEnDataRep.QueryDelegationEnData(dto);
  1729. if (groupData.Code != 0)
  1730. {
  1731. return Ok(JsonView(false, groupData.Msg));
  1732. }
  1733. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1734. }
  1735. catch (Exception ex)
  1736. {
  1737. return Ok(JsonView(false, "程序错误!"));
  1738. throw;
  1739. }
  1740. }
  1741. /// <summary>
  1742. /// 团组英文资料操作(Status:1.新增,2.修改)
  1743. /// </summary>
  1744. /// <param name="dto"></param>
  1745. /// <returns></returns>
  1746. [HttpPost]
  1747. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1748. public async Task<IActionResult> OpDelegationEnData(OpDelegationEnDataDto dto)
  1749. {
  1750. try
  1751. {
  1752. Result groupData = await _delegationEnDataRep.OpDelegationEnData(dto);
  1753. if (groupData.Code != 0)
  1754. {
  1755. return Ok(JsonView(false, groupData.Msg));
  1756. }
  1757. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1758. }
  1759. catch (Exception ex)
  1760. {
  1761. return Ok(JsonView(false, "程序错误!"));
  1762. throw;
  1763. }
  1764. }
  1765. /// <summary>
  1766. /// 团组英文资料Id查询数据
  1767. /// </summary>
  1768. /// <param name="dto"></param>
  1769. /// <returns></returns>
  1770. [HttpPost]
  1771. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1772. public async Task<IActionResult> QueryDelegationEnDataById(QueryDelegationEnDataByIdDto dto)
  1773. {
  1774. try
  1775. {
  1776. Grp_DelegationEnData _DelegationEnData=await _sqlSugar.Queryable<Grp_DelegationEnData>().FirstAsync(it => it.Id==dto.Id && it.IsDel==0);
  1777. if (_DelegationEnData != null)
  1778. {
  1779. return Ok(JsonView(true, "查询成功!", _DelegationEnData));
  1780. }
  1781. return Ok(JsonView(true, "暂无数据!",_DelegationEnData));
  1782. }
  1783. catch (Exception ex)
  1784. {
  1785. return Ok(JsonView(false, "程序错误!"));
  1786. throw;
  1787. }
  1788. }
  1789. /// <summary>
  1790. /// 团组英文资料删除
  1791. /// </summary>
  1792. /// <param name="dto"></param>
  1793. /// <returns></returns>
  1794. [HttpPost]
  1795. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1796. public async Task<IActionResult> DelDelegationEnData(DelBaseDto dto)
  1797. {
  1798. try
  1799. {
  1800. var res = await _delegationEnDataRep.SoftDeleteByIdAsync<Grp_DelegationEnData>(dto.Id.ToString(), dto.DeleteUserId);
  1801. if (!res)
  1802. {
  1803. return Ok(JsonView(false, "删除失败"));
  1804. }
  1805. return Ok(JsonView(true, "删除成功!"));
  1806. }
  1807. catch (Exception ex)
  1808. {
  1809. return Ok(JsonView(false, "程序错误!"));
  1810. throw;
  1811. }
  1812. }
  1813. #endregion
  1814. #region 导出邀请函
  1815. /// <summary>
  1816. /// 导出邀请函页面初始化
  1817. /// </summary>
  1818. /// <param name="dto"></param>
  1819. /// <returns></returns>
  1820. [HttpPost]
  1821. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1822. public async Task<IActionResult> QueryinvitationLetter(DecreasePaymentsListDto dto)
  1823. {
  1824. try
  1825. {
  1826. List<Grp_DelegationInfo> grp_Delegations = await _sqlSugar.Queryable<Grp_DelegationInfo>().Where(a => a.IsDel==0).OrderBy(a=>a.Id,OrderByType.Desc).ToListAsync();
  1827. List<Crm_DeleClient> crm_Deles = new List<Crm_DeleClient>();
  1828. if (dto.DiId==0)
  1829. {
  1830. crm_Deles = await _sqlSugar.Queryable<Crm_DeleClient>().Where(a => a.DiId==grp_Delegations[0].Id && a.IsDel==0).ToListAsync();
  1831. }
  1832. else
  1833. {
  1834. crm_Deles = await _sqlSugar.Queryable<Crm_DeleClient>().Where(a => a.DiId==dto.DiId && a.IsDel==0).ToListAsync();
  1835. }
  1836. return Ok(JsonView(true, "查询成功!",new
  1837. {
  1838. deleClient = crm_Deles,
  1839. delegations= grp_Delegations
  1840. }));
  1841. }
  1842. catch (Exception ex)
  1843. {
  1844. return Ok(JsonView(false, "程序错误!"));
  1845. throw;
  1846. }
  1847. }
  1848. /// <summary>
  1849. /// 导出邀请函
  1850. /// </summary>
  1851. /// <param name="dto"></param>
  1852. /// <returns></returns>
  1853. [HttpPost]
  1854. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1855. public async Task<IActionResult> invitationLetter(DecreasePaymentsListDto dto)
  1856. {
  1857. try
  1858. {
  1859. Dictionary<string, string> transDic = new Dictionary<string, string>();
  1860. List<Crm_DeleClient> crm_DeleClients = await _sqlSugar.Queryable<Crm_DeleClient>().Where(a => a.DiId==dto.DiId && a.IsDel==0).ToListAsync();
  1861. List<string> texts = new List<string>();
  1862. if (crm_DeleClients.Count!=0)
  1863. {
  1864. foreach (Crm_DeleClient item in crm_DeleClients)
  1865. {
  1866. if (!string.IsNullOrWhiteSpace(item.Pinyin))
  1867. {
  1868. transDic.Add(item.LastName+item.FirstName, item.Pinyin);
  1869. }
  1870. else
  1871. {
  1872. string name = item.LastName + item.FirstName;
  1873. texts.Add(name);
  1874. }
  1875. if (!string.IsNullOrEmpty(item.Job) && !texts.Contains(item.Job))
  1876. {
  1877. if (!transDic.ContainsKey(item.Job))
  1878. {
  1879. texts.Add(item.Job);
  1880. }
  1881. }
  1882. if (item.CrmCompanyId!=0)
  1883. {
  1884. Crm_CustomerCompany crm_Customer = await _sqlSugar.Queryable<Crm_CustomerCompany>().FirstAsync(a => a.Id==item.CrmCompanyId && a.IsDel==0);
  1885. if (!transDic.ContainsKey(crm_Customer.CompanyName))
  1886. {
  1887. texts.Add(crm_Customer.CompanyName);
  1888. }
  1889. }
  1890. }
  1891. List<TranslateResult> transData = _airTicketResRep.ReTransBatch(texts, "en");
  1892. if (transData.Count > 0)
  1893. {
  1894. foreach (TranslateResult item in transData)
  1895. {
  1896. if (!transDic.ContainsKey(item.Query))
  1897. {
  1898. transDic.Add(item.Query, item.Translation);
  1899. }
  1900. }
  1901. }
  1902. List<guestList> list = new List<guestList>();
  1903. foreach (Crm_DeleClient dele in crm_DeleClients)
  1904. {
  1905. guestList guestList = new guestList();
  1906. if (!string.IsNullOrWhiteSpace(dele.Pinyin))
  1907. {
  1908. guestList.Name = dele.Pinyin;
  1909. }
  1910. else
  1911. {
  1912. string Name = transDic.Where(s => s.Key == dele.LastName + dele.FirstName).FirstOrDefault().Value;
  1913. guestList.Name = Name;
  1914. }
  1915. if (dele.Sex ==0)
  1916. {
  1917. guestList.Sex = "Male";
  1918. }
  1919. else if (dele.Sex == 1)
  1920. {
  1921. guestList.Sex = "Female";
  1922. }
  1923. guestList.DOB = dele.BirthDay.Replace('-', '.');
  1924. Crm_CustomerCompany crm_Customer = await _sqlSugar.Queryable<Crm_CustomerCompany>().FirstAsync(a => a.Id==dele.CrmCompanyId && a.IsDel==0);
  1925. string jobName = transDic.Where(s => s.Key == crm_Customer.CompanyName).FirstOrDefault().Value + " "+transDic.Where(s => s.Key == dele.Job).FirstOrDefault().Value;
  1926. guestList.Job = jobName;
  1927. list.Add(guestList);
  1928. }
  1929. //载入模板
  1930. Document doc = new Document(AppSettingsHelper.Get("WordBasePath") + "Template/邀请函模板0210.docx");
  1931. DocumentBuilder builder = new DocumentBuilder(doc);
  1932. //获取word里所有表格
  1933. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  1934. //获取所填表格的序数
  1935. Aspose.Words.Tables.Table tableOne = allTables[0] as Aspose.Words.Tables.Table;
  1936. var rowStart = tableOne.Rows[0]; //获取第1行
  1937. //循环赋值
  1938. for (int i = 0; i < list.Count; i++)
  1939. {
  1940. builder.MoveToCell(0, i + 1, 0, 0);
  1941. builder.Write(list[i].Name.ToString());
  1942. builder.MoveToCell(0, i + 1, 1, 0);
  1943. builder.Write(list[i].Sex.ToString());
  1944. builder.MoveToCell(0, i + 1, 2, 0);
  1945. builder.Write(list[i].DOB.ToString());
  1946. builder.MoveToCell(0, i + 1, 3, 0);
  1947. builder.Write(list[i].Job.ToString());
  1948. }
  1949. //删除多余行
  1950. while (tableOne.Rows.Count > list.Count + 1)
  1951. {
  1952. tableOne.Rows.RemoveAt(list.Count + 1);
  1953. }
  1954. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  1955. string fileName = "邀请函"+DateTime.Now.ToString("yyyy-MM-dd")+".docx";
  1956. string filePath = fileDir + $@"商邀相关文件/{fileName}";
  1957. doc.Save(filePath);
  1958. string Url= AppSettingsHelper.Get("WordBaseUrl") + "Office/GrpFile/商邀相关文件"+fileName;
  1959. return Ok(JsonView(true, "成功!", Url));
  1960. }
  1961. else
  1962. {
  1963. return Ok(JsonView(false, "失败,该团组没有客户名单!"));
  1964. }
  1965. }
  1966. catch (Exception ex)
  1967. {
  1968. return Ok(JsonView(false, "程序错误!"));
  1969. throw;
  1970. }
  1971. }
  1972. #endregion
  1973. }
  1974. }