ResourceController.cs 177 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350435143524353435443554356435743584359436043614362436343644365436643674368436943704371437243734374437543764377437843794380438143824383438443854386438743884389439043914392439343944395439643974398439944004401
  1. using Aspose.Cells;
  2. using Aspose.Words;
  3. using EyeSoft.Extensions;
  4. using EyeSoft.Reflection;
  5. using NPOI.SS.Formula.Functions;
  6. using OASystem.API.OAMethodLib;
  7. using OASystem.API.OAMethodLib.QiYeWeChatAPI.AppNotice;
  8. using OASystem.Domain.AesEncryption;
  9. using OASystem.Domain.Dtos.CRM;
  10. using OASystem.Domain.Dtos.Groups;
  11. using OASystem.Domain.Dtos.PersonnelModule;
  12. using OASystem.Domain.Entities.Groups;
  13. using OASystem.Domain.ViewModels.Groups;
  14. using OASystem.Domain.ViewModels.QiYeWeChat;
  15. using OASystem.Infrastructure.Repositories.Groups;
  16. using Org.BouncyCastle.Utilities.Encoders;
  17. using System.Data;
  18. using XAct.Users;
  19. using static OASystem.API.OAMethodLib.JWTHelper;
  20. using static OpenAI.GPT3.ObjectModels.SharedModels.IOpenAiModels;
  21. namespace OASystem.API.Controllers
  22. {
  23. /// <summary>
  24. /// 资料相关
  25. /// </summary>
  26. //[Authorize]
  27. [Route("api/[controller]/[action]")]
  28. public class ResourceController : ControllerBase
  29. {
  30. private readonly IMapper _mapper;
  31. private readonly SqlSugarClient _sqlSugar;
  32. private readonly IConfiguration _config;
  33. private readonly CarDataRepository _carDataRep;
  34. private readonly LocalGuideDataRepository _localGuideDataRep;
  35. private readonly ThreeCodeRepository _ThreeCodeRep;
  36. private readonly HotelDataRepository _hotelDataRep;
  37. private readonly ResItemInfoRepository _resItemInfoRep;
  38. private readonly SetDataRepository _setDataRepository;
  39. private readonly CountryFeeRepository _countryFeeRep;
  40. private readonly SetDataTypeRepository _setDataTypeRep;
  41. private readonly AirTicketAgentRepository _airTicketAgentRep;
  42. private readonly InvitationOfficialActivityDataRepository _InvitationOfficialActivityDataRep;
  43. private readonly OfficialActivitiesRepository _officialActivitiesRep;
  44. private readonly AskDataRepository _askDataRep;
  45. private readonly TicketBlackCodeRepository _ticketBlackCodeRep;
  46. private readonly TourClientListRepository _tourClientListRep;
  47. private readonly DelegationInfoRepository _delegationInfoRep;
  48. private readonly TranslatorLibraryRepository _translatorRep;
  49. private readonly MediaSuppliersRepository _mediaSupplierRep;
  50. private readonly List<int> _portIds;
  51. private readonly BasicInsuranceCostRepository _insuranceCostRep;
  52. public ResourceController(
  53. IMapper mapper,
  54. IConfiguration config,
  55. SqlSugarClient sqlSugar,
  56. CarDataRepository carDataRep,
  57. LocalGuideDataRepository localGuideDataRep,
  58. ThreeCodeRepository threeCodeRep,
  59. HotelDataRepository hotelDataRep,
  60. ResItemInfoRepository resItemInfoRep,
  61. SetDataRepository setDataRepository,
  62. CountryFeeRepository countryFeeRep,
  63. SetDataTypeRepository setDataTypeRep,
  64. AirTicketAgentRepository airTicketAgentRep,
  65. InvitationOfficialActivityDataRepository invitationOfficialActivityDataRep,
  66. OfficialActivitiesRepository officialActivitiesRep,
  67. AskDataRepository askDataRep,
  68. TicketBlackCodeRepository ticketBlackCodeRep,
  69. TourClientListRepository tourClientListRep,
  70. DelegationInfoRepository delegationInfoRep,
  71. TranslatorLibraryRepository translatorRep,
  72. MediaSuppliersRepository mediaSupplierRep,
  73. BasicInsuranceCostRepository insuranceCostRep
  74. )
  75. {
  76. _mapper = mapper;
  77. _config = config;
  78. _sqlSugar = sqlSugar;
  79. _carDataRep = carDataRep;
  80. _localGuideDataRep = localGuideDataRep;
  81. _ThreeCodeRep = threeCodeRep;
  82. _hotelDataRep = hotelDataRep;
  83. _resItemInfoRep = resItemInfoRep;
  84. _setDataRepository = setDataRepository;
  85. _countryFeeRep = countryFeeRep;
  86. _setDataTypeRep = setDataTypeRep;
  87. _airTicketAgentRep = airTicketAgentRep;
  88. _InvitationOfficialActivityDataRep = invitationOfficialActivityDataRep;
  89. _officialActivitiesRep = officialActivitiesRep;
  90. _askDataRep = askDataRep;
  91. _ticketBlackCodeRep = ticketBlackCodeRep;
  92. _tourClientListRep = tourClientListRep;
  93. _delegationInfoRep = delegationInfoRep;
  94. _translatorRep = translatorRep;
  95. _mediaSupplierRep = mediaSupplierRep;
  96. _portIds = new List<int> { 1, 2, 3 };
  97. _insuranceCostRep = insuranceCostRep;
  98. }
  99. #region 车公司资料板块
  100. /// <summary>
  101. /// 车公司信息查询
  102. /// </summary>
  103. /// <returns></returns>
  104. [HttpPost]
  105. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  106. public async Task<IActionResult> QueryCarData(QueryCarDataDto dto)
  107. {
  108. try
  109. {
  110. Result LocalGuide = await _carDataRep.QueryCarData(dto);
  111. if (LocalGuide.Code == 0)
  112. {
  113. return Ok(JsonView(true, "查询成功", LocalGuide.Data));
  114. }
  115. else
  116. {
  117. return Ok(JsonView(false, LocalGuide.Msg));
  118. }
  119. }
  120. catch (Exception)
  121. {
  122. return Ok(JsonView(false, "程序错误!"));
  123. throw;
  124. }
  125. }
  126. /// <summary>
  127. /// 车公司资料下拉框数据
  128. /// </summary>
  129. /// <returns></returns>
  130. [HttpPost]
  131. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  132. public async Task<IActionResult> QueryCarSelect()
  133. {
  134. try
  135. {
  136. var CarData = _carDataRep.QueryDto<Res_CarData, CarDataSelectView>().ToList();
  137. if (CarData.Count == 0)
  138. {
  139. return Ok(JsonView(false, "暂无数据!"));
  140. }
  141. CarData.Add(new CarDataSelectView { Id = 0, UnitArea = "全部" });
  142. CarData = CarData.Where((x, i) => CarData.FindIndex(z => z.UnitArea == x.UnitArea) == i).ToList();
  143. CarData = CarData.OrderBy(x => x.Id).ToList();
  144. List<CarDataSelectView> data = new List<CarDataSelectView>();
  145. foreach (CarDataSelectView car in CarData)
  146. {
  147. if (!string.IsNullOrWhiteSpace(car.UnitArea))
  148. {
  149. data.Add(car);
  150. }
  151. }
  152. return Ok(JsonView(true, "查询成功", data));
  153. }
  154. catch (Exception)
  155. {
  156. return Ok(JsonView(false, "程序错误!"));
  157. throw;
  158. }
  159. }
  160. /// <summary>
  161. /// 根据Id查询车公司详细数据
  162. /// </summary>
  163. /// <returns></returns>
  164. [HttpPost]
  165. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  166. public async Task<IActionResult> QuerCarDataDetailById(QueryCarDataDetailDto dto)
  167. {
  168. string sql = string.Format(@" Select * From Res_CarData With(Nolock) Where Id = {0} ", dto.Id);
  169. CarDataDetailDataView info = _resItemInfoRep._sqlSugar.SqlQueryable<CarDataDetailDataView>(sql).First();
  170. if (info == null)
  171. {
  172. return Ok(JsonView(false, "未找到相关数据!"));
  173. }
  174. return Ok(JsonView(true, "查询成功", info));
  175. }
  176. /// <summary>
  177. /// 车公司信息添加
  178. /// </summary>
  179. /// <returns></returns>
  180. [HttpPost]
  181. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  182. public async Task<IActionResult> AddCarData(AddCarDataDto dto)
  183. {
  184. try
  185. {
  186. if (dto.UnitArea == "")
  187. {
  188. return Ok(JsonView(false, "请检查单位区域是否填写!"));
  189. }
  190. if (dto.UnitName == "")
  191. {
  192. return Ok(JsonView(false, "请检查单位名称是否填写!"));
  193. }
  194. if (dto.Contact == "")
  195. {
  196. return Ok(JsonView(false, "请检查单位联系人是否填写!"));
  197. }
  198. if (dto.ContactTel == "")
  199. {
  200. return Ok(JsonView(false, "请检查联系方式是否填写正确!"));
  201. }
  202. var carDada = _carDataRep.QueryDto<Res_CarData, CarDataView>(a => a.UnitArea == dto.UnitArea && a.UnitName == dto.UnitName && a.Contact == dto.Contact && a.ContactTel == dto.ContactTel).ToList();
  203. if (carDada.Count != 0)
  204. {
  205. return Ok(JsonView(false, "该信息已存在,请勿重复添加!"));
  206. }
  207. Res_CarData _CarData = _mapper.Map<Res_CarData>(dto);
  208. int id = await _carDataRep.AddAsyncReturnId(_CarData);
  209. if (id == 0)
  210. {
  211. return Ok(JsonView(false, "添加失败!"));
  212. }
  213. return Ok(JsonView(true, "添加成功", new { Id = id }));
  214. }
  215. catch (Exception ex)
  216. {
  217. return Ok(JsonView(false, "程序错误!"));
  218. throw;
  219. }
  220. }
  221. /// <summary>
  222. /// 车公司信息修改
  223. /// </summary>
  224. /// <returns></returns>
  225. [HttpPost]
  226. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  227. public async Task<IActionResult> UpCarData(UpCarDataDto dto)
  228. {
  229. try
  230. {
  231. if (dto.UnitArea == "")
  232. {
  233. return Ok(JsonView(false, "请检查单位区域是否填写!"));
  234. }
  235. if (dto.UnitName == "")
  236. {
  237. return Ok(JsonView(false, "请检查单位名称是否填写!"));
  238. }
  239. if (dto.Contact == "")
  240. {
  241. return Ok(JsonView(false, "请检查单位联系人是否填写!"));
  242. }
  243. if (dto.ContactTel == "")
  244. {
  245. return Ok(JsonView(false, "请检查联系方式是否填写正确!"));
  246. }
  247. bool res = await _carDataRep.UpdateAsync(a => a.Id == dto.Id, a => new Res_CarData
  248. {
  249. UnitArea = dto.UnitArea,
  250. UnitName = dto.UnitName,
  251. Address = dto.Address,
  252. Contact = dto.Contact,
  253. ContactTel = dto.ContactTel,
  254. ContactEmail = dto.ContactEmail,
  255. ContactFax = dto.ContactFax,
  256. CarDes = dto.CarDes,
  257. CarPicPaths = dto.CarPicPaths,
  258. OtherInfo = dto.OtherInfo,
  259. Score = dto.Score,
  260. QualificationScore = dto.QualificationScore,
  261. CarAgeScore = dto.CarAgeScore,
  262. CleanImgScore = dto.CleanImgScore,
  263. SmellScore = dto.SmellScore,
  264. WaterPaperScore = dto.WaterPaperScore,
  265. HardwareScore = dto.HardwareScore,
  266. TimeScore = dto.TimeScore,
  267. SafetyScore = dto.SafetyScore,
  268. DrivingAgeScore = dto.DrivingAgeScore,
  269. Remark = dto.Remark,
  270. });
  271. if (!res) { return Ok(JsonView(false, "修改失败!")); }
  272. return Ok(JsonView(true, "修改成功"));
  273. }
  274. catch (Exception ex)
  275. {
  276. return Ok(JsonView(false, "程序错误!"));
  277. throw;
  278. }
  279. }
  280. /// <summary>
  281. /// 车公司信息删除
  282. /// </summary>
  283. /// <returns></returns>
  284. [HttpPost]
  285. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  286. public async Task<IActionResult> DelCarData(DelCarDataDto dto)
  287. {
  288. try
  289. {
  290. bool res = await _carDataRep.SoftDeleteByIdAsync<Res_CarData>(dto.Id.ToString(), dto.DeleteUserId);
  291. if (!res) { return Ok(JsonView(false, "删除失败!")); }
  292. return Ok(JsonView(true, "删除成功"));
  293. }
  294. catch (Exception ex)
  295. {
  296. return Ok(JsonView(false, "程序错误!"));
  297. throw;
  298. }
  299. }
  300. #endregion
  301. #region 导游地接资料板块
  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> QueryLocalGuide(QueryLocalGuide dto)
  310. {
  311. try
  312. {
  313. Result LocalGuide = await _localGuideDataRep.QueryLocalGuide(dto);
  314. if (LocalGuide.Code == 0)
  315. {
  316. return Ok(JsonView(true, "查询成功", LocalGuide.Data));
  317. }
  318. else
  319. {
  320. return Ok(JsonView(false, LocalGuide.Msg));
  321. }
  322. }
  323. catch (Exception ex)
  324. {
  325. return Ok(JsonView(false, "程序错误!"));
  326. throw;
  327. }
  328. }
  329. /// <summary>
  330. /// 导游地接资料下拉框数据
  331. /// </summary>
  332. /// <returns></returns>
  333. [HttpPost]
  334. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  335. public async Task<IActionResult> QueryLocalGuideSelect()
  336. {
  337. try
  338. {
  339. var LocalGuide = _carDataRep.QueryDto<Res_LocalGuideData, QueryLocalGuideSelectView>().ToList();
  340. if (LocalGuide.Count == 0)
  341. {
  342. return Ok(JsonView(false, "暂无数据!"));
  343. }
  344. LocalGuide.Add(new QueryLocalGuideSelectView { Id = 0, UnitArea = "全部" });
  345. LocalGuide = LocalGuide.Where((x, i) => LocalGuide.FindIndex(z => z.UnitArea == x.UnitArea && z.UnitArea != "") == i).ToList();
  346. LocalGuide = LocalGuide.OrderBy(x => x.Id).ToList();
  347. List<QueryLocalGuideSelectView> data = new List<QueryLocalGuideSelectView>();
  348. foreach (QueryLocalGuideSelectView Local in LocalGuide)
  349. {
  350. if (!string.IsNullOrWhiteSpace(Local.UnitArea))
  351. {
  352. data.Add(Local);
  353. }
  354. }
  355. return Ok(JsonView(true, "查询成功", data));
  356. }
  357. catch (Exception)
  358. {
  359. return Ok(JsonView(false, "程序错误!"));
  360. throw;
  361. }
  362. }
  363. /// <summary>
  364. /// 根据Id查询地接详细数据
  365. /// </summary>
  366. /// <returns></returns>
  367. [HttpPost]
  368. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  369. public async Task<IActionResult> QueryLocalGuideDetailById(QueryLocalGuideDetailDto dto)
  370. {
  371. string sql = string.Format(@" Select * From Res_LocalGuideData With(Nolock) Where Id = {0} ", dto.Id);
  372. LocalGuideDetailDataView info = _resItemInfoRep._sqlSugar.SqlQueryable<LocalGuideDetailDataView>(sql).First();
  373. if (info == null)
  374. {
  375. return Ok(JsonView(false, "未找到相关数据!"));
  376. }
  377. return Ok(JsonView(true, "查询成功", info));
  378. }
  379. /// <summary>
  380. /// 导游地接信息操作(Status:1.新增,2.修改)
  381. /// </summary>
  382. /// <returns></returns>
  383. [HttpPost]
  384. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  385. public async Task<IActionResult> OperationLocalGuide(LocalGuideOperationDto dto)
  386. {
  387. try
  388. {
  389. if (dto.UnitArea == "")
  390. {
  391. return Ok(JsonView(false, "请检查单位区域是否填写!"));
  392. }
  393. if (dto.UnitName == "")
  394. {
  395. return Ok(JsonView(false, "请检查单位名称是否填写!"));
  396. }
  397. if (dto.Contact == "")
  398. {
  399. return Ok(JsonView(false, "请检查单位联系人是否填写!"));
  400. }
  401. if (dto.ContactTel == "")
  402. {
  403. return Ok(JsonView(false, "请检查联系方式是否填写正确!"));
  404. }
  405. Result result = await _localGuideDataRep.LocalGuideOperation(dto);
  406. if (result.Code != 0)
  407. {
  408. return Ok(JsonView(false, result.Msg));
  409. }
  410. return Ok(JsonView(true, result.Msg));
  411. }
  412. catch (Exception ex)
  413. {
  414. return Ok(JsonView(false, "程序错误!"));
  415. throw;
  416. }
  417. }
  418. /// <summary>
  419. /// 导游地接信息操作(删除)
  420. /// </summary>
  421. /// <returns></returns>
  422. [HttpPost]
  423. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  424. public async Task<IActionResult> DelLocalGuide(LocalGuideDelDto dto)
  425. {
  426. try
  427. {
  428. var res = await _localGuideDataRep.SoftDeleteByIdAsync<Res_LocalGuideData>(dto.Id.ToString(), dto.DeleteUserId);
  429. if (!res)
  430. {
  431. return Ok(JsonView(false, "删除失败"));
  432. }
  433. return Ok(JsonView(true, "删除成功!"));
  434. }
  435. catch (Exception ex)
  436. {
  437. return Ok(JsonView(false, "程序错误!"));
  438. throw;
  439. }
  440. }
  441. #endregion
  442. #region 机场三字码信息
  443. /// <summary>
  444. /// 机场三字码查询
  445. /// </summary>
  446. /// <param name="dto"></param>
  447. /// <returns></returns>
  448. [HttpPost]
  449. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  450. public async Task<IActionResult> QueryThreeCode(QueryThreeCodeDto dto)
  451. {
  452. try
  453. {
  454. Result LocalGuide = await _ThreeCodeRep.QueryThreeCode(dto);
  455. if (LocalGuide.Code == 0)
  456. {
  457. return Ok(JsonView(true, "查询成功", LocalGuide.Data));
  458. }
  459. else
  460. {
  461. return Ok(JsonView(false, LocalGuide.Msg));
  462. }
  463. }
  464. catch (Exception ex)
  465. {
  466. return Ok(JsonView(false, "程序错误!"));
  467. throw;
  468. }
  469. }
  470. /// <summary>
  471. /// 机场三字码数据城市下拉框数据
  472. /// </summary>
  473. /// <returns></returns>
  474. [HttpPost]
  475. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  476. public async Task<IActionResult> QueryThreeCodeSelect()
  477. {
  478. try
  479. {
  480. var ThreeCode = _carDataRep.QueryDto<Res_ThreeCode, ThreeCodeSelectView>().ToList();
  481. if (ThreeCode.Count == 0)
  482. {
  483. return Ok(JsonView(false, "暂无数据!"));
  484. }
  485. ThreeCode.Add(new ThreeCodeSelectView { Id = 0, City = "全部" });
  486. ThreeCode = ThreeCode.Where((x, i) => ThreeCode.FindIndex(z => z.City == x.City && z.City != "") == i).ToList();
  487. ThreeCode = ThreeCode.OrderBy(x => x.Id).ToList();
  488. List<ThreeCodeSelectView> data = new List<ThreeCodeSelectView>();
  489. foreach (ThreeCodeSelectView _ThreeCode in ThreeCode)
  490. {
  491. if (!string.IsNullOrWhiteSpace(_ThreeCode.City))
  492. {
  493. data.Add(_ThreeCode);
  494. }
  495. }
  496. return Ok(JsonView(true, "查询成功", data));
  497. }
  498. catch (Exception)
  499. {
  500. return Ok(JsonView(false, "程序错误!"));
  501. throw;
  502. }
  503. }
  504. /// <summary>
  505. /// 机场三字码资料操作(Status:1.新增,2.修改)
  506. /// </summary>
  507. /// <param name="dto"></param>
  508. /// <returns></returns>
  509. [HttpPost]
  510. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  511. public async Task<IActionResult> OperationThreeCode(ThreeCodeOperationDto dto)
  512. {
  513. try
  514. {
  515. if (dto.Three == "")
  516. {
  517. return Ok(JsonView(false, "请检查三字码是否填写!"));
  518. }
  519. if (dto.Country == "")
  520. {
  521. return Ok(JsonView(false, "请检查国家是否填写!"));
  522. }
  523. if (dto.City == "")
  524. {
  525. return Ok(JsonView(false, "请检查城市是否填写正确!"));
  526. }
  527. if (dto.AirPort == "")
  528. {
  529. return Ok(JsonView(false, "请检查机场是否填写正确!"));
  530. }
  531. Result result = await _ThreeCodeRep.ThreeCodeOperation(dto);
  532. if (result.Code != 0)
  533. {
  534. return Ok(JsonView(false, result.Msg));
  535. }
  536. return Ok(JsonView(true, result.Msg));
  537. }
  538. catch (Exception ex)
  539. {
  540. return Ok(JsonView(false, "程序错误!"));
  541. throw;
  542. }
  543. }
  544. /// <summary>
  545. /// 机场三字码资料操作(删除)
  546. /// </summary>
  547. /// <returns></returns>
  548. [HttpPost]
  549. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  550. public async Task<IActionResult> DelThreeCode(ThreeCodeDelDto dto)
  551. {
  552. try
  553. {
  554. var res = await _ThreeCodeRep.SoftDeleteByIdAsync<Res_ThreeCode>(dto.Id.ToString(), dto.DeleteUserId);
  555. if (!res)
  556. {
  557. return Ok(JsonView(false, "删除失败"));
  558. }
  559. return Ok(JsonView(true, "删除成功!"));
  560. }
  561. catch (Exception ex)
  562. {
  563. return Ok(JsonView(false, "程序错误!"));
  564. throw;
  565. }
  566. }
  567. /// <summary>
  568. ///根据ID查询三字码信息
  569. /// </summary>
  570. /// <returns></returns>
  571. [HttpPost]
  572. public IActionResult QuerySingleThreeCode(QuerySingleThreeCode dto)
  573. {
  574. var jw = JsonView(false);
  575. var single = _sqlSugar.Queryable<Res_ThreeCode>().First(x => x.Id == dto.ID && x.IsDel == 0);
  576. if (single != null)
  577. {
  578. jw = JsonView(true, "获取成功!", new
  579. {
  580. single.Three,
  581. Four = single.Four?.Trim(),
  582. single.AirPort,
  583. single.AirPort_En,
  584. single.City,
  585. single.Country,
  586. single.Remark
  587. });
  588. }
  589. else
  590. {
  591. jw.Msg = "暂无!";
  592. }
  593. return Ok(jw);
  594. }
  595. #endregion
  596. #region 代理出票合作方资料
  597. /// <summary>
  598. /// 代理出票合作方资料
  599. /// </summary>
  600. /// <param name="dto"></param>
  601. /// <returns></returns>
  602. [HttpPost]
  603. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  604. public async Task<IActionResult> QueryAirTicketAgent(DtoBase dto)
  605. {
  606. try
  607. {
  608. List<Res_AirTicketAgent> res_AirTicketAgents = _airTicketAgentRep.Query<Res_AirTicketAgent>(a => a.IsDel == 0).ToList();
  609. if (res_AirTicketAgents.Count != 0)
  610. {
  611. res_AirTicketAgents = res_AirTicketAgents.OrderByDescending(a => a.CreateTime).ToList();
  612. if (dto.PageSize == 0 && dto.PageIndex == 0)
  613. {
  614. return Ok(JsonView(true, "查询成功!", res_AirTicketAgents));
  615. }
  616. else
  617. {
  618. int count = res_AirTicketAgents.Count;
  619. float totalPage = (float)count / dto.PageSize;//总页数
  620. if (totalPage == 0) totalPage = 1;
  621. else totalPage = (int)Math.Ceiling((double)totalPage);
  622. List<Res_AirTicketAgent> _AirTicketAgent = new List<Res_AirTicketAgent>();
  623. for (int i = 0; i < dto.PageSize; i++)
  624. {
  625. var RowIndex = i + (dto.PageIndex - 1) * dto.PageSize;
  626. if (RowIndex < res_AirTicketAgents.Count)
  627. {
  628. _AirTicketAgent.Add(res_AirTicketAgents[RowIndex]);
  629. }
  630. else
  631. {
  632. break;
  633. }
  634. }
  635. return Ok(JsonView(true, "查询成功!", new { pageCount = count, totalPage = (int)totalPage, pageIndex = dto.PageIndex, pageSize = dto.PageSize, pageSource = _AirTicketAgent }));
  636. }
  637. }
  638. else
  639. {
  640. return Ok(JsonView(false, "暂无数据!"));
  641. }
  642. }
  643. catch (Exception ex)
  644. {
  645. return Ok(JsonView(false, "程序错误!"));
  646. throw;
  647. }
  648. }
  649. /// <summary>
  650. /// 代理出票合作方资料操作(Status:1.新增,2.修改)
  651. /// </summary>
  652. /// <param name="dto"></param>
  653. /// <returns></returns>
  654. [HttpPost]
  655. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  656. public async Task<IActionResult> OpAirTicketAgent(OpAirTicketAgentDto dto)
  657. {
  658. try
  659. {
  660. if (dto.Account == "")
  661. {
  662. return Ok(JsonView(false, "请检查代理商账户是否填写!"));
  663. }
  664. if (dto.Bank == "")
  665. {
  666. return Ok(JsonView(false, "请检查代理商银行是否填写!"));
  667. }
  668. if (dto.Name == "")
  669. {
  670. return Ok(JsonView(false, "请检查代理商名称是否填写正确!"));
  671. }
  672. Result result = await _airTicketAgentRep.OpAirTicketAgent(dto);
  673. if (result.Code != 0)
  674. {
  675. return Ok(JsonView(false, result.Msg));
  676. }
  677. return Ok(JsonView(true, result.Msg));
  678. }
  679. catch (Exception ex)
  680. {
  681. return Ok(JsonView(false, "程序错误!"));
  682. throw;
  683. }
  684. }
  685. /// <summary>
  686. /// 代理出票合作方资料操作(删除)
  687. /// </summary>
  688. /// <returns></returns>
  689. [HttpPost]
  690. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  691. public async Task<IActionResult> DelAirTicketAgent(DelBaseDto dto)
  692. {
  693. try
  694. {
  695. var res = await _airTicketAgentRep.SoftDeleteByIdAsync<Res_AirTicketAgent>(dto.Id.ToString(), dto.DeleteUserId);
  696. if (!res)
  697. {
  698. return Ok(JsonView(false, "删除失败"));
  699. }
  700. return Ok(JsonView(true, "删除成功!"));
  701. }
  702. catch (Exception ex)
  703. {
  704. return Ok(JsonView(false, "程序错误!"));
  705. throw;
  706. }
  707. }
  708. #endregion
  709. #region 酒店资料数据
  710. /// <summary>
  711. /// 酒店信息查询 Page
  712. /// </summary>
  713. /// <param name="dto"></param>
  714. /// <returns></returns>
  715. [HttpPost]
  716. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  717. public async Task<IActionResult> QueryHotelData(QueryHotelDataDto dto)
  718. {
  719. string sqlWhere = string.Empty;
  720. if (!string.IsNullOrWhiteSpace(dto.Name))
  721. {
  722. sqlWhere += string.Format(@" And hd.Name like '%{0}%'", dto.Name);
  723. }
  724. if (!string.IsNullOrWhiteSpace(dto.City) && dto.City != "全部")
  725. {
  726. sqlWhere += string.Format(@" And hd.City like '%{0}%'", dto.City);
  727. }
  728. if (!string.IsNullOrWhiteSpace(dto.Contact))
  729. {
  730. sqlWhere += string.Format(@" And hd.Contact like '%{0}%'", dto.Contact);
  731. }
  732. if (!string.IsNullOrWhiteSpace(dto.ContactPhone))
  733. {
  734. sqlWhere += string.Format(@" And hd.ContactPhone like '%{0}%'", dto.ContactPhone);
  735. }
  736. sqlWhere += string.Format(@" And hd.IsDel={0}", 0);
  737. if (!string.IsNullOrEmpty(sqlWhere.Trim()))
  738. {
  739. Regex r = new Regex("And");
  740. sqlWhere = r.Replace(sqlWhere, "Where", 1);
  741. }
  742. string sql = string.Format(@"SELECT
  743. *
  744. FROM
  745. (
  746. SELECT
  747. ROW_NUMBER() OVER (
  748. ORDER BY
  749. hd.CreateTime DESC
  750. ) AS Row_Number,
  751. hd.Id,
  752. hd.City,
  753. hd.[Name],
  754. hd.Tel,
  755. hd.Fax,
  756. hd.Contact,
  757. hd.ContactPhone,
  758. u.CnName AS CreateUserName,
  759. hd.CreateTime
  760. FROM
  761. Res_HotelData hd
  762. WITH
  763. (NoLock)
  764. LEFT JOIN Sys_Users u
  765. WITH
  766. (NoLock) ON hd.CreateUserId = u.Id {0}
  767. ) Temp
  768. ", sqlWhere);
  769. if (dto.PortType == 1)
  770. {
  771. var HotelDataData = await _sqlSugar.SqlQueryable<HotelDataItemView>(sql)
  772. //.Select(x => new {
  773. // x.Row_Number,
  774. // x.Id,
  775. // City = AesEncryptionHelper.Decrypt(x.City),
  776. // Name = AesEncryptionHelper.Decrypt(x.Name),
  777. // Tel = AesEncryptionHelper.Decrypt(x.Tel),
  778. // Fax = AesEncryptionHelper.Decrypt(x.Fax),
  779. // Contact = AesEncryptionHelper.Decrypt(x.Contact),
  780. // x.CreateUserName,
  781. // ContactPhone = AesEncryptionHelper.Decrypt(x.ContactPhone),
  782. // x.CreateTime
  783. //})
  784. .ToListAsync();
  785. if (HotelDataData.Count == 0)
  786. {
  787. return Ok(JsonView(false, "暂无数据"));
  788. }
  789. foreach (var item in HotelDataData)
  790. {
  791. EncryptionProcessor.DecryptProperties(item);
  792. }
  793. return Ok(JsonView(true, "操作成功", HotelDataData));
  794. }
  795. else if (dto.PortType == 2 || dto.PortType == 3)
  796. {
  797. RefAsync<int> total = 0;//REF和OUT不支持异步,想要真的异步这是最优解
  798. var data = await _sqlSugar.SqlQueryable<HotelDataItemView>(sql).ToPageListAsync(dto.PageIndex, dto.PageSize, total); //ToPageAsync
  799. return Ok(JsonView(true, "操作成功", data, total));
  800. }
  801. else return Ok(JsonView(false, "请传入PortType参数!1:Web,2:Android,3:IOS"));
  802. }
  803. /// <summary>
  804. /// 酒店资料
  805. /// 详情
  806. /// add time:2024-05-14 11:57:10
  807. /// </summary>
  808. /// <returns></returns>
  809. [HttpPost]
  810. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  811. public async Task<IActionResult> QueryHotelDataInfo(QueryHotelDataInfoDto dto)
  812. {
  813. var _view = await _hotelDataRep._Info(dto.PortType, dto.Id);
  814. if (_view.Code == 0)
  815. {
  816. return Ok(JsonView(true, _view.Msg, _view.Data));
  817. }
  818. return Ok(JsonView(false, _view.Msg));
  819. }
  820. /// <summary>
  821. /// 酒店资料下拉框数据
  822. /// </summary>
  823. /// <returns></returns>
  824. [HttpPost]
  825. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  826. public async Task<IActionResult> QueryHotelDataSelect()
  827. {
  828. try
  829. {
  830. var HotelData = _carDataRep.QueryDto<Res_HotelData, QueryHotelDataSelect>().ToList();
  831. if (HotelData.Count == 0)
  832. {
  833. return Ok(JsonView(false, "暂无数据!"));
  834. }
  835. HotelData.Add(new QueryHotelDataSelect { Id = 0, City = "全部" });
  836. HotelData = HotelData.Where((x, i) => HotelData.FindIndex(z => z.City == x.City && z.City != "") == i).ToList();
  837. HotelData = HotelData.OrderBy(x => x.Id).ToList();
  838. List<QueryHotelDataSelect> data = new List<QueryHotelDataSelect>();
  839. foreach (QueryHotelDataSelect Hotel in HotelData)
  840. {
  841. if (!string.IsNullOrWhiteSpace(Hotel.City))
  842. {
  843. data.Add(Hotel);
  844. }
  845. }
  846. return Ok(JsonView(true, "查询成功", data));
  847. }
  848. catch (Exception)
  849. {
  850. return Ok(JsonView(false, "程序错误!"));
  851. throw;
  852. }
  853. }
  854. /// <summary>
  855. /// 酒店资料操作(Status:1.新增,2.修改)
  856. /// </summary>
  857. /// <param name="dto"></param>
  858. /// <returns></returns>
  859. [HttpPost]
  860. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  861. public async Task<IActionResult> OperationHotelData(OperationHotelDto dto)
  862. {
  863. if (string.IsNullOrEmpty(dto.City)) return Ok(JsonView(false, "请检查酒店所在城市是否填写!"));
  864. if (string.IsNullOrEmpty(dto.Name)) return Ok(JsonView(false, "请检查酒店名称是否填写!"));
  865. if (string.IsNullOrEmpty(dto.Address)) return Ok(JsonView(false, "请检查酒店地址是否填写正确!"));
  866. if (string.IsNullOrEmpty(dto.Tel)) return Ok(JsonView(false, "请检查酒店联系方式是否填写正确!"));
  867. Result result = await _hotelDataRep.OperationHotelData(dto);
  868. if (result.Code != 0) return Ok(JsonView(false, result.Msg));
  869. return Ok(JsonView(true, result.Msg));
  870. }
  871. /// <summary>
  872. /// 酒店资料操作(删除)
  873. /// </summary>
  874. /// <returns></returns>
  875. [HttpPost]
  876. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  877. public async Task<IActionResult> DelHotelData(DelHotelDataDto dto)
  878. {
  879. try
  880. {
  881. var res = await _hotelDataRep.SoftDeleteByIdAsync<Res_HotelData>(dto.Id.ToString(), dto.DeleteUserId);
  882. if (!res)
  883. {
  884. return Ok(JsonView(false, "删除失败"));
  885. }
  886. return Ok(JsonView(true, "删除成功!"));
  887. }
  888. catch (Exception ex)
  889. {
  890. return Ok(JsonView(false, "程序错误!"));
  891. throw;
  892. }
  893. }
  894. #endregion
  895. #region 签证费用资料
  896. /// <summary>
  897. /// 签证费用资料查询
  898. /// </summary>
  899. /// <param name="dto"></param>
  900. /// <returns></returns>
  901. [HttpPost]
  902. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  903. public async Task<IActionResult> QueryCountryFeeCost(DtoBase dto)
  904. {
  905. if (dto.PortType == 1)
  906. {
  907. var CountryFee = _countryFeeRep.QueryDto<Res_CountryFeeCost, CountryFeeCostView>().ToList();
  908. if (CountryFee.Count == 0)
  909. {
  910. return Ok(JsonView(false, "暂无数据!"));
  911. }
  912. CountryFee = CountryFee.OrderByDescending(s => s.CreateTime).ToList();
  913. return Ok(JsonView(true, "查询成功", CountryFee));
  914. }
  915. else if (dto.PortType == 2)
  916. {
  917. var CountryFee = _countryFeeRep.QueryDto<Res_CountryFeeCost, CountryFeeCostView>().ToList();
  918. if (CountryFee.Count == 0)
  919. {
  920. return Ok(JsonView(false, "暂无数据!"));
  921. }
  922. CountryFee = CountryFee.OrderByDescending(s => s.CreateTime).ToList();
  923. return Ok(JsonView(true, "查询成功", CountryFee));
  924. }
  925. else
  926. {
  927. return Ok(JsonView(false, "请传入PortType参数!1:Web,2:Android,3:IOS"));
  928. }
  929. }
  930. /// <summary>
  931. /// 签证费用资料操作(Status:1.新增,2.修改)
  932. /// </summary>
  933. /// <param name="dto"></param>
  934. /// <returns></returns>
  935. [HttpPost]
  936. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  937. public async Task<IActionResult> OperationCountryFeeCost(OperationCountryFeeCostDto dto)
  938. {
  939. if (string.IsNullOrWhiteSpace(dto.VisaContinent))
  940. {
  941. return Ok(JsonView(false, "请检查州名是否填写!"));
  942. }
  943. if (string.IsNullOrWhiteSpace(dto.VisaCountry))
  944. {
  945. return Ok(JsonView(false, "请检查国家名是否填写!"));
  946. }
  947. if (string.IsNullOrWhiteSpace(dto.VisaTime))
  948. {
  949. return Ok(JsonView(false, "请检一般签证时间是否填写正确!"));
  950. }
  951. if (string.IsNullOrWhiteSpace(dto.UrgentTime))
  952. {
  953. return Ok(JsonView(false, "请检加急时间是否填写正确!"));
  954. }
  955. Result result = await _countryFeeRep.OperationCountryFeeCost(dto);
  956. if (result.Code == 0)
  957. {
  958. return Ok(JsonView(true, result.Msg));
  959. }
  960. return Ok(JsonView(false, result.Msg));
  961. }
  962. /// <summary>
  963. /// 签证费用资料操作(删除)
  964. /// </summary>
  965. /// <returns></returns>
  966. [HttpPost]
  967. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  968. public async Task<IActionResult> DelCountryFeeCost(DelCountryFeeCostDto dto)
  969. {
  970. var res = await _countryFeeRep.SoftDeleteByIdAsync<Res_CountryFeeCost>(dto.Id.ToString(), dto.DeleteUserId);
  971. if (!res)
  972. {
  973. return Ok(JsonView(false, "删除失败"));
  974. }
  975. return Ok(JsonView(true, "删除成功!"));
  976. }
  977. #endregion
  978. #region 物料信息、供应商维护
  979. #region 供应商
  980. /// <summary>
  981. /// 物料供应商查询
  982. /// </summary>
  983. /// <param name="paras">Json序列化</param>
  984. /// <returns></returns>
  985. [HttpPost]
  986. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  987. public async Task<IActionResult> PostSearchItemVendor(JsonDtoBase _jsonDto)
  988. {
  989. if (string.IsNullOrEmpty(_jsonDto.Paras))
  990. {
  991. return Ok(JsonView(false, "参数为空"));
  992. }
  993. Search_ResItemVendorDto _ItemVendorDto = System.Text.Json.JsonSerializer.Deserialize<Search_ResItemVendorDto>(_jsonDto.Paras);
  994. if (_ItemVendorDto != null)
  995. {
  996. if (_ItemVendorDto.SearchType == 2) //获取列表
  997. {
  998. Res_ItemVendorListView rstList = _resItemInfoRep.GetVendorList(_ItemVendorDto);
  999. return Ok(rstList);
  1000. }
  1001. else
  1002. {
  1003. Res_ItemVendorView rstInfo = _resItemInfoRep.getVendorInfo(_ItemVendorDto);
  1004. return Ok(rstInfo);
  1005. }
  1006. }
  1007. else
  1008. {
  1009. return Ok(JsonView(false, "参数反序列化失败"));
  1010. }
  1011. return Ok(JsonView(false));
  1012. }
  1013. /// <summary>
  1014. /// 创建/编辑/删除供应商信息
  1015. /// </summary>
  1016. /// <param name="_dto"></param>
  1017. /// <returns></returns>
  1018. [HttpPost]
  1019. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1020. public async Task<IActionResult> PostEditItemVendor(Edit_ResItemVendorDto _dto)
  1021. {
  1022. bool rst = false;
  1023. if (_dto.EditType >= 0)
  1024. {
  1025. if (string.IsNullOrEmpty(_dto.VendorFullName))
  1026. {
  1027. return Ok(JsonView(false, "全称未填写"));
  1028. }
  1029. if (string.IsNullOrEmpty(_dto.VendorLinker))
  1030. {
  1031. return Ok(JsonView(false, "联系人未填写"));
  1032. }
  1033. if (string.IsNullOrEmpty(_dto.VendorMobile))
  1034. {
  1035. return Ok(JsonView(false, "联系人手机号未填写"));
  1036. }
  1037. if (string.IsNullOrEmpty(_dto.BusRange))
  1038. {
  1039. return Ok(JsonView(false, "经营范围未选择"));
  1040. }
  1041. if (_dto.EditType == 0)
  1042. {
  1043. var checkEmpty = _resItemInfoRep.Query<Res_ItemVendor>(s => s.FullName == _dto.VendorFullName).First();
  1044. if (checkEmpty != null)
  1045. {
  1046. return Ok(JsonView(false, "已存在同名供应商"));
  1047. }
  1048. rst = await _resItemInfoRep.addVendorInfo(_dto);
  1049. }
  1050. else if (_dto.EditType == 1)
  1051. {
  1052. if (_dto.VendorId > 0)
  1053. {
  1054. Res_ItemVendor _entity = _mapper.Map<Res_ItemVendor>(_dto);
  1055. rst = await _resItemInfoRep.updVendorInfo(_entity);
  1056. }
  1057. else
  1058. {
  1059. return Ok(JsonView(false, "供应商不存在"));
  1060. }
  1061. }
  1062. }
  1063. else
  1064. {
  1065. if (_dto.VendorId < 1 || _dto.SysUserId < 1)
  1066. {
  1067. return Ok(JsonView(false, "用户Id或供应商Id不存在"));
  1068. }
  1069. Res_ItemVendor _entity = _mapper.Map<Res_ItemVendor>(_dto);
  1070. rst = await _resItemInfoRep.delVendorInfo(_entity);
  1071. }
  1072. return Ok(JsonView(rst));
  1073. }
  1074. #endregion
  1075. #region 物料信息
  1076. /// <summary>
  1077. /// 物料信息查询
  1078. /// </summary>
  1079. /// <param name="paras">Json序列化</param>
  1080. /// <returns></returns>
  1081. [HttpPost]
  1082. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1083. public async Task<IActionResult> PostSearchItemInfo(string paras)
  1084. {
  1085. if (string.IsNullOrEmpty(paras))
  1086. {
  1087. return Ok(JsonView(false, "参数为空"));
  1088. }
  1089. Search_ItemInfoDto _ItemInfoDto = System.Text.Json.JsonSerializer.Deserialize<Search_ItemInfoDto>(paras);
  1090. if (_ItemInfoDto != null)
  1091. {
  1092. if (_ItemInfoDto.SearchType == 2) //获取列表
  1093. {
  1094. Res_ItemInfoListView rstList = _resItemInfoRep.GetItemList(_ItemInfoDto);
  1095. return Ok(rstList);
  1096. }
  1097. else
  1098. {
  1099. Res_ItemInfoView rstInfo = _resItemInfoRep.getItemInfo(_ItemInfoDto);
  1100. return Ok(rstInfo);
  1101. }
  1102. }
  1103. else
  1104. {
  1105. return Ok(JsonView(false, "参数反序列化失败"));
  1106. }
  1107. return Ok(JsonView(false));
  1108. }
  1109. /// <summary>
  1110. /// 创建/编辑/删除物料信息
  1111. /// </summary>
  1112. ///
  1113. /// <returns></returns>
  1114. [HttpPost]
  1115. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1116. public async Task<IActionResult> PostEditItemInfo(Edit_ResItemInfoDto _dto)
  1117. {
  1118. bool rst = false;
  1119. if (_dto.EditType >= 0)
  1120. {
  1121. if (_dto.VendorId < 1)
  1122. {
  1123. return Ok(JsonView(false, "未选择供应商"));
  1124. }
  1125. if (string.IsNullOrEmpty(_dto.ItemName))
  1126. {
  1127. return Ok(JsonView(false, "物料名称为空"));
  1128. }
  1129. if (_dto.ItemTypeId < 1)
  1130. {
  1131. return Ok(JsonView(false, "未选择物料类型"));
  1132. }
  1133. if (_dto.SysUserId < 1)
  1134. {
  1135. return Ok(JsonView(false, "当前操作用户Id为空"));
  1136. }
  1137. if (_dto.CurrRate <= 0)
  1138. {
  1139. return Ok(JsonView(false, "物料录入价格不能小于等于0"));
  1140. }
  1141. if (_dto.EditType == 0)
  1142. {
  1143. //判断物料名称、类型、供应商全部重复
  1144. var checkEmpty = _resItemInfoRep.Query<Res_ItemDetailInfo>(s => s.ItemName == _dto.ItemName && s.ItemTypeId == _dto.ItemTypeId && s.VendorId == _dto.VendorId).First();
  1145. if (checkEmpty != null)
  1146. {
  1147. return Ok(JsonView(false, "已存在重复物料信息"));
  1148. }
  1149. Res_ItemDetailInfo _entity = _mapper.Map<Res_ItemDetailInfo>(_dto);
  1150. DateTime dtNow = DateTime.Now;
  1151. _entity.CreateUserId = _dto.SysUserId;
  1152. _entity.IsDel = 0;
  1153. _entity.MaxRate = _dto.CurrRate;
  1154. _entity.MaxDt = dtNow;
  1155. _entity.CurrRate = _dto.CurrRate;
  1156. _entity.CurrDt = dtNow;
  1157. _entity.MinRate = _dto.CurrRate;
  1158. _entity.MinDt = dtNow;
  1159. rst = await _resItemInfoRep.AddAsync<Res_ItemDetailInfo>(_entity) > 0;
  1160. }
  1161. else if (_dto.EditType == 1)
  1162. {
  1163. if (_dto.ItemId > 0)
  1164. {
  1165. Res_ItemDetailInfo _entity = _mapper.Map<Res_ItemDetailInfo>(_dto);
  1166. _entity.Id = _dto.ItemId;
  1167. rst = await _resItemInfoRep.updItemInfo(_entity);
  1168. }
  1169. else
  1170. {
  1171. return Ok(JsonView(false, "供应商不存在"));
  1172. }
  1173. }
  1174. }
  1175. else
  1176. {
  1177. if (_dto.ItemId < 1 || _dto.SysUserId < 1)
  1178. {
  1179. return Ok(JsonView(false, "用户Id或物料信息Id不存在"));
  1180. }
  1181. Res_ItemDetailInfo _entity = _mapper.Map<Res_ItemDetailInfo>(_dto);
  1182. rst = await _resItemInfoRep.delItemInfo(_entity);
  1183. }
  1184. return Ok(JsonView(rst));
  1185. }
  1186. #endregion
  1187. #region 物料类型获取
  1188. #endregion
  1189. #endregion
  1190. #region 备忘录
  1191. /// <summary>
  1192. /// 备忘录查询
  1193. /// </summary>
  1194. /// <param name="paras">Json序列化</param>
  1195. /// <returns></returns>
  1196. [HttpPost]
  1197. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1198. public async Task<IActionResult> PostSearchMemo(JsonDtoBase _jsonDto)
  1199. {
  1200. if (string.IsNullOrEmpty(_jsonDto.Paras))
  1201. {
  1202. return Ok(JsonView(false, "参数为空"));
  1203. }
  1204. Search_ResMemoDto _memoDto = JsonConvert.DeserializeObject<Search_ResMemoDto>(_jsonDto.Paras);
  1205. if (_memoDto != null)
  1206. {
  1207. if (_memoDto.SearchType == 2)
  1208. {
  1209. //获取列表
  1210. string sqlWhere = string.Format(" Where IsDel=0 ");
  1211. #region SqlWhere
  1212. if (!string.IsNullOrEmpty(_memoDto.Abstracts))
  1213. {
  1214. sqlWhere += string.Format(@" And m.Abstracts Like '%{0}%' ", _memoDto.Abstracts);
  1215. }
  1216. if (!string.IsNullOrEmpty(_memoDto.Title))
  1217. {
  1218. sqlWhere += string.Format(@" And m.Title Like '%{0}%' ", _memoDto.Title);
  1219. }
  1220. if (_memoDto.ReadLevel > 0)
  1221. {
  1222. sqlWhere += string.Format(@" And m.ReadLevel = {0} ", _memoDto.ReadLevel);
  1223. }
  1224. #endregion
  1225. int currPIndex = (((_memoDto.PageIndex > 0) ? (_memoDto.PageIndex - 1) : 0) * _memoDto.PageSize) + 1;
  1226. int currPSize = (((_memoDto.PageIndex > 0) ? (_memoDto.PageIndex - 1) : 0) + 1) * _memoDto.PageSize;
  1227. string sql = string.Format(@" Select * From(Select ROW_NUMBER() Over(order By m.Id desc) as RowNumber,
  1228. m.Id as MemoId,d.DepName as DepartmentName,m.ReadLevel,m.Title,m.Abstracts,
  1229. m.LastedEditDt,m.LastedEditorId
  1230. From Res_Memo as m With(Nolock) Inner Join Sys_Users as u With(Nolock) On m.CreateUserId=u.Id
  1231. Inner Join Sys_Department as d With(Nolock) On u.DepId=d.Id {2}
  1232. ) as tb Where tb.RowNumber Between {0} And {1} ", currPIndex, currPSize, sqlWhere);
  1233. Res_MemoListView rst = new Res_MemoListView();
  1234. rst.CurrPageIndex = currPIndex;
  1235. rst.CurrPageSize = currPSize;
  1236. List<Res_MemoView> dataSource = _carDataRep._sqlSugar.SqlQueryable<Res_MemoView>(sql).ToList();
  1237. Dictionary<int, string> userDic = new Dictionary<int, string>();
  1238. foreach (var item in dataSource)
  1239. {
  1240. if (userDic.ContainsKey(item.LastedEditorId))
  1241. {
  1242. item.LastedEditor = userDic[item.LastedEditorId];
  1243. }
  1244. else
  1245. {
  1246. Sys_Users _sysUser = _carDataRep.Query<Sys_Users>(s => s.Id == item.LastedEditorId).First();
  1247. userDic[item.LastedEditorId] = _sysUser.CnName;
  1248. item.LastedEditor = _sysUser.CnName;
  1249. }
  1250. }
  1251. rst.DataList = new List<Res_MemoView>(dataSource);
  1252. if (rst.DataList.Count > 0)
  1253. {
  1254. string sqlCount = string.Format(@" Select Id From Res_Memo as m With(Nolock) {0} ", sqlWhere);
  1255. int dataCount = _carDataRep._sqlSugar.SqlQueryable<Res_MemoInfo>(sqlCount).Count();
  1256. rst.DataCount = dataCount;
  1257. }
  1258. return Ok(JsonView(rst));
  1259. }
  1260. else
  1261. {
  1262. //获取对象
  1263. string sqlSingle = string.Format(@" Select
  1264. m.Id as MemoId,d.DepName as DepartmentName,m.ReadLevel,m.Title,m.Abstracts,
  1265. m.LastedEditDt,m.LastedEditor,m.MDFilePath
  1266. From Res_Memo as m With(Nolock) Inner Join Sys_Users as u With(Nolock) On m.CreateUserId=u.Id
  1267. Inner Join Sys_Department as d With(Nolock) On u.DepId=d.Id Where m.Id={0} ", _memoDto.MemoId);
  1268. Res_MemoView _result = _carDataRep._sqlSugar.SqlQueryable<Res_MemoView>(sqlSingle).First();
  1269. if (_result != null)
  1270. {
  1271. Sys_Users _sysUser = _carDataRep.Query<Sys_Users>(s => s.Id == _result.LastedEditorId).First();
  1272. _result.LastedEditor = _sysUser.CnName;
  1273. _result.MarkDownContent = new IOOperatorHelper().Read(_result.MDFilePath);
  1274. return Ok(JsonView(_result));
  1275. }
  1276. }
  1277. }
  1278. else
  1279. {
  1280. return Ok(JsonView(false, "参数反序列化失败"));
  1281. }
  1282. return Ok(JsonView(false));
  1283. }
  1284. /// <summary>
  1285. /// 创建/编辑/删除备忘录信息
  1286. /// </summary>
  1287. /// <param name="_dto"></param>
  1288. /// <returns></returns>
  1289. [HttpPost]
  1290. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1291. public async Task<IActionResult> PostEditMemo(Edit_ResMemoDto _dto)
  1292. {
  1293. bool rst = false;
  1294. if (_dto.SysUserId < 1)
  1295. {
  1296. return Ok(JsonView(false, "操作人失效"));
  1297. }
  1298. Sys_Users _sysUser = _resItemInfoRep.Query<Sys_Users>(s => s.Id == _dto.SysUserId).First();
  1299. if (_sysUser == null)
  1300. {
  1301. return Ok(JsonView(false, "操作人失效02"));
  1302. }
  1303. if (_dto.EditType >= 0)
  1304. {
  1305. if (_dto.ReadLevel < 1)
  1306. {
  1307. return Ok(JsonView(false, "未知的阅读等级"));
  1308. }
  1309. if (string.IsNullOrEmpty(_dto.Title.Trim()))
  1310. {
  1311. return Ok(JsonView(false, "标题不能为空"));
  1312. }
  1313. if (string.IsNullOrEmpty(_dto.Content.Trim()))
  1314. {
  1315. return Ok(JsonView(false, "正文内容不能为空"));
  1316. }
  1317. //新增备忘录
  1318. DateTime dtNow = DateTime.Now;
  1319. string dir = AppSettingsHelper.Get("MemoCurrPath");
  1320. string fileName = dtNow.ToString("yyyyMMddHHmmss") + _dto.Title + ".md";
  1321. string content = JsonConvert.SerializeObject(_dto.Content);
  1322. if (_dto.EditType == 0)//新增
  1323. {
  1324. string savePath = new IOOperatorHelper().Write_CoverFile(content, dir, fileName);
  1325. if (savePath.Length > 0)
  1326. {
  1327. Res_MemoInfo _insert = new Res_MemoInfo();
  1328. _insert.Abstracts = _dto.Abstracts;
  1329. _insert.Title = _dto.Title;
  1330. _insert.DepartmentId = _sysUser.DepId;
  1331. _insert.CreateUserId = _sysUser.Id;
  1332. _insert.LastedEditDt = dtNow;
  1333. _insert.LastedEditor = _sysUser.Id;
  1334. _insert.MDFilePath = savePath;
  1335. _insert.ReadLevel = _dto.ReadLevel;
  1336. _insert.Title = _dto.Title;
  1337. int result = await _resItemInfoRep.AddAsync(_insert);
  1338. return Ok(JsonView(result > 0));
  1339. }
  1340. else
  1341. {
  1342. return Ok(JsonView(false, "路径保存失败"));
  1343. }
  1344. }
  1345. else//修改
  1346. {
  1347. if (_dto.MemoId < 1)
  1348. {
  1349. return Ok(JsonView(false, "MemoId不存在"));
  1350. }
  1351. Res_MemoInfo _source = _resItemInfoRep.Query<Res_MemoInfo>(s => s.Id == _dto.MemoId).First();
  1352. if (_source == null)
  1353. {
  1354. return Ok(JsonView(false, "MemoInfo不存在"));
  1355. }
  1356. //修改
  1357. string sourcePath = _source.MDFilePath;
  1358. string recycDir = AppSettingsHelper.Get("MemoRecycleBinPath");
  1359. new IOOperatorHelper().MoveFile(sourcePath, recycDir);
  1360. string savePath = new IOOperatorHelper().Write_CoverFile(content, dir, fileName);
  1361. if (savePath.Length > 0)
  1362. {
  1363. var result = await _resItemInfoRep._sqlSugar.Updateable<Res_MemoInfo>()
  1364. .SetColumns(it => it.LastedEditDt == DateTime.Now)
  1365. .SetColumns(it => it.LastedEditor == _sysUser.Id)
  1366. .SetColumns(it => it.Abstracts == _dto.Abstracts)
  1367. .SetColumns(it => it.MDFilePath == savePath)
  1368. .SetColumns(it => it.ReadLevel == _dto.ReadLevel)
  1369. .SetColumns(it => it.Title == _dto.Title)
  1370. .Where(s => s.Id == _source.Id)
  1371. .ExecuteCommandAsync();
  1372. return Ok(JsonView(result > 0));
  1373. }
  1374. }
  1375. }
  1376. else
  1377. {
  1378. //删除
  1379. if (_dto.MemoId < 1)
  1380. {
  1381. return Ok(JsonView(false, "MemoId不存在"));
  1382. }
  1383. Res_MemoInfo _source = _resItemInfoRep.Query<Res_MemoInfo>(s => s.Id == _dto.MemoId).First();
  1384. if (_source == null)
  1385. {
  1386. return Ok(JsonView(false, "MemoInfo不存在"));
  1387. }
  1388. //修改
  1389. string sourcePath = _source.MDFilePath;
  1390. string recycDir = AppSettingsHelper.Get("MemoRecycleBinPath");
  1391. new IOOperatorHelper().MoveFile(sourcePath, recycDir);
  1392. var result = await _resItemInfoRep._sqlSugar.Updateable<Res_MemoInfo>()
  1393. .SetColumns(it => it.IsDel == 1)
  1394. .SetColumns(it => it.DeleteUserId == _sysUser.Id)
  1395. .SetColumns(it => it.DeleteTime == DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"))
  1396. .Where(s => s.Id == _source.Id)
  1397. .ExecuteCommandAsync();
  1398. return Ok(JsonView(result > 0));
  1399. }
  1400. return Ok(JsonView(rst));
  1401. }
  1402. #endregion
  1403. #region 商邀资料
  1404. /// <summary>
  1405. /// 商邀资料 基础数据源
  1406. /// </summary>
  1407. /// <param name="dto"></param>
  1408. /// <returns></returns>
  1409. [HttpPost]
  1410. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1411. public async Task<IActionResult> QueryIOAInitData(QueryIOAInitDataDto dto)
  1412. {
  1413. try
  1414. {
  1415. #region 参数验证
  1416. if (dto.PortType < 1) return Ok(JsonView(false, "请传入有效的PortType参数!"));
  1417. #endregion
  1418. var ExcludedKeyStr = new string[] { "快递费" };
  1419. var ClientKeyStr = new string[] { "邀请函翻译" };
  1420. var expable = Expressionable.Create<Res_InvitationOfficialActivityData>();
  1421. foreach (var key in ClientKeyStr)
  1422. {
  1423. expable = expable.And(it => !it.Contact.Contains(key));
  1424. }
  1425. foreach (var item in ExcludedKeyStr)
  1426. {
  1427. expable = expable.And(it => !it.UnitName.Contains(item));
  1428. }
  1429. List<Grp_DelegationInfo> _DelegationInfos = _sqlSugar.Queryable<Grp_DelegationInfo>().Where(it => it.IsDel == 0).OrderByDescending(it => it.JietuanTime).ToList();
  1430. List<Res_InvitationOfficialActivityData> _ioaDatas = _sqlSugar.Queryable<Res_InvitationOfficialActivityData>().Where(it => it.IsDel == 0).Where(expable.ToExpression()).ToList();
  1431. List<Sys_Users> _Users = _sqlSugar.Queryable<Sys_Users>().Where(it => it.IsDel == 0).ToList();
  1432. var _countryData = _ioaDatas.Select(it => it.Country).Distinct().ToList(); _countryData.Remove("");
  1433. var _inviterData = _ioaDatas.Select(it => it.UnitName).Distinct().ToList(); _inviterData.Remove("");
  1434. var _contactData = _ioaDatas.Select(it => it.Contact).Distinct().ToList(); _contactData.Remove("");
  1435. var _domainData = _ioaDatas.Select(it => it.Field).Distinct().ToList(); _domainData.Remove("");
  1436. var _groupNameData = _DelegationInfos.Select(it => new { it.Id, it.TeamName }).ToList();
  1437. var _userNameData = _Users.Select(it => new { it.Id, it.CnName }).ToList();
  1438. var _data = new
  1439. {
  1440. CountryData = _countryData,
  1441. InviterData = _inviterData,
  1442. DomainData = _domainData,
  1443. ContactData = _contactData,
  1444. GroupNameData = _groupNameData,
  1445. UserNameData = _userNameData,
  1446. };
  1447. return Ok(JsonView(true, $"查询成功!", _data));
  1448. }
  1449. catch (Exception ex)
  1450. {
  1451. return Ok(JsonView(false, ex.Message));
  1452. }
  1453. }
  1454. /// <summary>
  1455. /// 商邀资料查询
  1456. /// </summary>
  1457. /// <param name="dto"></param>
  1458. /// <returns></returns>
  1459. [HttpPost]
  1460. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1461. public async Task<IActionResult> QueryInvitationOfficialActivityData(QueryInvitationOfficialActivityDataDto dto)
  1462. {
  1463. var ExcludedKeyStr = new string[] { "快递费" };
  1464. var ClientKeyStr = new string[] { "邀请函翻译" };
  1465. try
  1466. {
  1467. #region 参数验证
  1468. if (dto.PageIndex < 1) return Ok(JsonView(false, "请传入有效的PageIndex参数!"));
  1469. if (dto.PageSize < 1) return Ok(JsonView(false, "请传入有效的PageSize参数!"));
  1470. #endregion
  1471. string sqlWhere = string.Empty;
  1472. if (!string.IsNullOrWhiteSpace(dto.Country)) { sqlWhere += string.Format(@" And i.Country like '%{0}%'", dto.Country); }
  1473. if (!string.IsNullOrWhiteSpace(dto.UnitName)) { sqlWhere += string.Format(@" And i.UnitName like '%{0}%'", dto.UnitName); }
  1474. if (!string.IsNullOrWhiteSpace(dto.Contact)) { sqlWhere += string.Format(@" And i.Contact like '%{0}%'", dto.Contact); }
  1475. if (!string.IsNullOrWhiteSpace(dto.Delegation)) { sqlWhere += string.Format(@" And i.Delegation like '%{0}%'", dto.Delegation); }
  1476. if (!string.IsNullOrWhiteSpace(dto.Field)) { sqlWhere += string.Format(@" And i.Field like '%{0}%'", dto.Field); }
  1477. if (dto.CreateUserId != 0 && !string.IsNullOrWhiteSpace(dto.CreateUserId.ToString())) { sqlWhere += string.Format(@" And i.CreateUserId={0}", dto.CreateUserId); }
  1478. if (!string.IsNullOrWhiteSpace(dto.StartCreateTime) && !string.IsNullOrWhiteSpace(dto.EndCreateTime))
  1479. {
  1480. sqlWhere += string.Format(@" And i.CreateTime between '{0}' and '{1}'", dto.StartCreateTime, dto.EndCreateTime);
  1481. }
  1482. sqlWhere += string.Format(@"And i.Isdel={0}", 0);
  1483. foreach (var item in ExcludedKeyStr)
  1484. {
  1485. sqlWhere += $" And i.UnitName not like '%{item}%' ";
  1486. }
  1487. foreach (var item in ClientKeyStr)
  1488. {
  1489. sqlWhere += $" And i.Contact not like '%{item}%' ";
  1490. }
  1491. if (!string.IsNullOrEmpty(sqlWhere.Trim()))
  1492. {
  1493. Regex r = new Regex("And");
  1494. sqlWhere = r.Replace(sqlWhere, "Where", 1);
  1495. }
  1496. string sql = string.Format(@"Select ROW_NUMBER() Over(Order By i.CreateTime Desc) As Row_Number,
  1497. i.*,u.CnName As CreateUserName
  1498. From Res_InvitationOfficialActivityData i
  1499. Left Join Sys_Users u On i.CreateUserId = u.Id {0}", sqlWhere);
  1500. RefAsync<int> totalCount = 0;
  1501. var _ivitiesViews = await _sqlSugar.SqlQueryable<InvitationOfficialActivityDataView>(sql).ToPageListAsync(dto.PageIndex, dto.PageSize, totalCount);
  1502. //List<Grp_DelegationInfo> _DelegationInfos = _sqlSugar.Queryable<Grp_DelegationInfo>().ToList();
  1503. foreach (var item in _ivitiesViews)
  1504. {
  1505. string groupNameStr = "";
  1506. if (!string.IsNullOrEmpty(item.Delegation))
  1507. {
  1508. int[] groupIds = item.Delegation.Split(',').Select(x =>
  1509. {
  1510. int id;
  1511. if (int.TryParse(x, out id)) return id;
  1512. else return id;
  1513. }).ToArray();
  1514. var _DelegationInfos = _sqlSugar.Queryable<Grp_DelegationInfo>().Where(x => groupIds.Contains(x.Id) && x.IsDel == 0).ToList();
  1515. foreach (var group in _DelegationInfos)
  1516. {
  1517. groupNameStr += $"{group.TeamName},";
  1518. }
  1519. if (groupNameStr.Length > 1)
  1520. {
  1521. groupNameStr = groupNameStr.Substring(0, groupNameStr.Length - 1);
  1522. }
  1523. }
  1524. item.DelegationStr = groupNameStr;
  1525. }
  1526. return Ok(JsonView(true, $"查询成功!", _ivitiesViews, totalCount));
  1527. }
  1528. catch (Exception ex)
  1529. {
  1530. return Ok(JsonView(false, ex.Message));
  1531. }
  1532. }
  1533. /// <summary>
  1534. /// 根据商邀资料Id查询信息
  1535. /// </summary>
  1536. /// <param name="id"></param>
  1537. /// <returns></returns>
  1538. [HttpGet("{id}")]
  1539. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1540. public async Task<IActionResult> QueryInvitationOfficialActivityById(int id)
  1541. {
  1542. if (id < 1) return Ok(JsonView(false, "Id参数错误!"));
  1543. return Ok(await _InvitationOfficialActivityDataRep.Info(id));
  1544. }
  1545. /// <summary>
  1546. /// 商邀资料操作(Status:1.新增,2.修改)
  1547. /// </summary>
  1548. /// <param name="dto"></param>
  1549. /// <returns></returns>
  1550. [HttpPost]
  1551. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1552. public async Task<IActionResult> OpInvitationOfficialActivity([FromForm] OpInvitationOfficialActivityDto dto)
  1553. {
  1554. return Ok(await _InvitationOfficialActivityDataRep.IOA_OP(dto));
  1555. }
  1556. /// <summary>
  1557. /// 商邀资料 删除文件
  1558. /// </summary>
  1559. /// <param name="id"></param>
  1560. /// <param name="fileName"></param>
  1561. /// <returns></returns>
  1562. [HttpDelete("{id}")]
  1563. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1564. public async Task<IActionResult> InvitationOfficialActivityDelFile(int id, string fileName)
  1565. {
  1566. if (id < 1) return Ok(JsonView(false, "请传入有效的Id"));
  1567. if (string.IsNullOrEmpty(fileName)) return Ok(JsonView(false, "文件名称不能为空!"));
  1568. var info = await _sqlSugar.Queryable<Res_InvitationOfficialActivityData>().FirstAsync(x => x.Id == id);
  1569. if (info == null) return Ok(JsonView(false, "该条数据不存在!"));
  1570. var files = new List<string>();
  1571. try
  1572. {
  1573. files = JsonConvert.DeserializeObject<List<string>>(info.SndFileName);
  1574. }
  1575. catch (Exception) { }
  1576. if (files != null && files.Count > 0 && files.Contains(fileName))
  1577. {
  1578. var filePath = $@"{AppSettingsHelper.Get("GrpFileBasePath")}/商邀相关文件/{fileName}";
  1579. if (System.IO.File.Exists(filePath))
  1580. {
  1581. System.IO.File.Delete(filePath);
  1582. }
  1583. //更改文件值
  1584. files.Remove(fileName);
  1585. var fileUpd = await _sqlSugar.Updateable<Res_InvitationOfficialActivityData>()
  1586. .SetColumns(x => x.SndFileName == JsonConvert.SerializeObject(files))
  1587. .Where(x => x.Id == id)
  1588. .ExecuteCommandAsync();
  1589. if (fileUpd > 0) return Ok(JsonView(true, "操作成功!"));
  1590. }
  1591. return Ok(JsonView(false, "操作失败!"));
  1592. }
  1593. /// <summary>
  1594. /// 删除商邀资料信息
  1595. /// </summary>
  1596. /// <param name="dto"></param>
  1597. /// <returns></returns>
  1598. [HttpPost]
  1599. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1600. public async Task<IActionResult> DelInvitationOfficialActivity(DelBaseDto dto)
  1601. {
  1602. var res = await _InvitationOfficialActivityDataRep.SoftDeleteByIdAsync<Res_InvitationOfficialActivityData>(dto.Id.ToString(), dto.DeleteUserId);
  1603. if (!res) return Ok(JsonView(false, "删除失败"));
  1604. var info = await _sqlSugar.Queryable<Res_InvitationOfficialActivityData>().FirstAsync(x => x.Id == dto.Id);
  1605. if (info == null) return Ok(JsonView(false, "该条数据不存在!"));
  1606. var files = new List<string>();
  1607. try
  1608. {
  1609. files = JsonConvert.DeserializeObject<List<string>>(info.SndFileName);
  1610. }
  1611. catch (Exception) { }
  1612. if (files != null && files.Count > 0)
  1613. {
  1614. foreach (var fileName in files)
  1615. {
  1616. var filePath = $@"{AppSettingsHelper.Get("GrpFileBasePath")}/商邀相关文件/{fileName}";
  1617. if (System.IO.File.Exists(filePath))
  1618. {
  1619. System.IO.File.Delete(filePath);
  1620. }
  1621. }
  1622. }
  1623. return Ok(JsonView(true, "删除成功!"));
  1624. }
  1625. #endregion
  1626. #region 公务出访
  1627. /// <summary>
  1628. /// 获取团组所有信息,绑定下拉框
  1629. /// </summary>
  1630. /// <param name="dto"></param>
  1631. /// <returns></returns>
  1632. [HttpPost]
  1633. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1634. public async Task<IActionResult> GetGroupAllList(OfficialActivitiesByDiIdDto dto)
  1635. {
  1636. //string groupSql = string.Format("Select * From Grp_DelegationInfo With(NoLock) Where IsDel = 0 Order By CreateTime Desc");
  1637. //List<Grp_DelegationInfo> _DelegationInfos = _sqlSugar.SqlQueryable< Grp_DelegationInfo >(groupSql).ToList();
  1638. var _groupData = await _delegationInfoRep.PostShareGroupInfos(1);
  1639. dynamic groupInfos = null;
  1640. if (_groupData.Code == 0) groupInfos = _groupData.Data;
  1641. var data = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.IsDel == 0 && a.STid == 38).ToList();
  1642. var _DeleFile = _sqlSugar.Queryable<Grp_DeleFile>().Where(a => a.Diid == dto.DiId && a.IsDel == 0 && a.Category == 970).ToList();
  1643. var translatorData = _sqlSugar.Queryable<Res_TranslatorLibrary>().Where(a => a.IsDel == 0).Select(x => new { x.Id, x.Name }).ToList();
  1644. return Ok(JsonView(true, "查询成功!", new { Delegation = groupInfos, SetData = data, DeleFile = _DeleFile , TranslatorData = translatorData }));
  1645. }
  1646. /// <summary>
  1647. /// 公务List
  1648. /// </summary>
  1649. /// <param name="dto"></param>
  1650. /// <returns></returns>
  1651. [HttpPost]
  1652. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1653. public async Task<IActionResult> QueryOfficialActivitiesByDiId(OfficialActivitiesByDiIdDto dto)
  1654. {
  1655. return Ok(await _officialActivitiesRep.QueryOfficialActivitiesByDiId(dto));
  1656. }
  1657. /// <summary>
  1658. /// 根据公务出访数据Id查询数据
  1659. /// </summary>
  1660. /// <param name="dto"></param>
  1661. /// <returns></returns>
  1662. [HttpPost]
  1663. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1664. public async Task<IActionResult> QueryOfficialActivitiesById(OfficialActivitiesDiIdDto dto)
  1665. {
  1666. Result groupData = await _officialActivitiesRep.QueryOfficialActivitiesById(dto);
  1667. if (groupData.Code != 0)
  1668. {
  1669. return Ok(JsonView(false, groupData.Msg));
  1670. }
  1671. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1672. }
  1673. /// <summary>
  1674. /// 公务出访操作(Status:1.新增,2.修改)
  1675. /// </summary>
  1676. /// <param name="dto"></param>
  1677. /// <returns></returns>
  1678. [HttpPost]
  1679. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1680. public async Task<IActionResult> OpOfficialActivities(OpOfficialActivitiesDto dto)
  1681. {
  1682. Result groupData = await _officialActivitiesRep.OpOfficialActivities(dto);
  1683. if (groupData.Code != 0)
  1684. {
  1685. return Ok(JsonView(StatusCodes.Status400BadRequest, groupData.Msg, new { Id = 0 }));
  1686. }
  1687. try
  1688. {
  1689. //公务出访变更发送通知
  1690. await AppNoticeLibrary.SendUserMsg_GroupShare_ToOP(dto.DiId, dto.CreateUserId);
  1691. }
  1692. catch (Exception ex)
  1693. {
  1694. //抄送日志
  1695. }
  1696. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1697. }
  1698. /// <summary>
  1699. /// 上传文件(邮件截图)
  1700. /// </summary>
  1701. /// <param name="file"></param>
  1702. /// <returns></returns>
  1703. [HttpPost]
  1704. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1705. public async Task<IActionResult> OfficialActivitiesUploadFiles([FromForm] OfficialActivitiesUploadFilesDto dto)
  1706. {
  1707. string networkPath = AppSettingsHelper.Get("GrpFileBaseUrl");
  1708. string localPath = AppSettingsHelper.Get("GrpFileBasePath");
  1709. string ptfPath = AppSettingsHelper.Get("GrpFileFtpPath");
  1710. if (dto.diId < 1 || dto.currUserId < 1)
  1711. {
  1712. return Ok(JsonView(false, "参数有误,上传失败!"));
  1713. }
  1714. if (dto.files == null || dto.files.Count < 1)
  1715. {
  1716. return Ok(JsonView(false, "文件为空,上传失败!"));
  1717. }
  1718. string localFileDir = $"{localPath}{ptfPath}";
  1719. List<string> fileUrls = new List<string>();
  1720. string[] failFiles = new string[] { };
  1721. foreach (var file in dto.files)
  1722. {
  1723. //文件名称
  1724. string[] fileNameArray = file.FileName.Split(".");
  1725. string projectFileName = $"{fileNameArray[0].ToString().Replace("-", "_").Replace("/", "_")}{DateTime.UtcNow.ToString("yyyyMMddHHmmss")}.{fileNameArray[1].ToString()}";
  1726. //上传的文件的路径
  1727. string filePath = $@"{localPath}公务相关文件";
  1728. if (!Directory.Exists(filePath))
  1729. {
  1730. Directory.CreateDirectory(filePath);
  1731. }
  1732. var path = Path.Combine(filePath, projectFileName);
  1733. //using var stream = new FileStream(path, FileMode.Create);
  1734. //await file.CopyToAsync(stream);
  1735. try
  1736. {
  1737. using (FileStream fs = System.IO.File.Create(path))
  1738. {
  1739. file.CopyTo(fs);
  1740. fs.Flush();
  1741. }
  1742. fileUrls.Add($"/{ptfPath}公务相关文件/{projectFileName}");
  1743. }
  1744. catch (Exception ex)
  1745. {
  1746. failFiles.Append(file.FileName);
  1747. }
  1748. }
  1749. var oaInfo = await _sqlSugar.Queryable<Res_OfficialActivities>().Where(x => x.Id == dto.id).FirstAsync();
  1750. List<string> files = new List<string>();
  1751. var status = false;
  1752. var _oaInfo = new Res_OfficialActivities()
  1753. {
  1754. DiId = dto.diId,
  1755. ScreenshotOfMailUrl = JsonConvert.SerializeObject(fileUrls),
  1756. IsDel = 0,
  1757. CreateUserId = dto.currUserId,
  1758. CreateTime = DateTime.Now
  1759. };
  1760. if (oaInfo == null)
  1761. {
  1762. var id = await _sqlSugar.Insertable<Res_OfficialActivities>(_oaInfo)
  1763. .ExecuteReturnIdentityAsync();
  1764. if (id > 0)
  1765. {
  1766. status = true;
  1767. dto.id = id;
  1768. }
  1769. }
  1770. else
  1771. {
  1772. var oldFiles = string.IsNullOrEmpty(oaInfo.ScreenshotOfMailUrl)
  1773. ? new List<string>()
  1774. : JsonConvert.DeserializeObject<List<string>>(oaInfo.ScreenshotOfMailUrl);
  1775. if (oldFiles.Count > 0)
  1776. {
  1777. fileUrls.AddRange(oldFiles);
  1778. }
  1779. fileUrls = fileUrls.Distinct().ToList();
  1780. if (fileUrls.Count() > 0)
  1781. {
  1782. var upd = await _sqlSugar.Updateable<Res_OfficialActivities>()
  1783. .SetColumns(x => x.ScreenshotOfMailUrl == JsonConvert.SerializeObject(fileUrls))
  1784. .Where(x => x.Id == dto.id)
  1785. .ExecuteCommandAsync();
  1786. if (upd > 0) status = true;
  1787. }
  1788. }
  1789. List<string> returnFileUrls = new List<string>();
  1790. fileUrls.ForEach(x =>
  1791. {
  1792. returnFileUrls.Add($"{networkPath}{x}");
  1793. });
  1794. if (status)
  1795. {
  1796. string msg = "操作成功!";
  1797. if (failFiles.Length > 1)
  1798. {
  1799. foreach (var item in failFiles)
  1800. {
  1801. msg += $"{failFiles}、";
  1802. }
  1803. msg = msg.Substring(0, msg.Length - 1);
  1804. msg += "等文件保存失败!";
  1805. }
  1806. return Ok(JsonView(true, msg, new { id = dto.id, fileUrls = returnFileUrls }));
  1807. }
  1808. return Ok(JsonView(false, "操作失败!"));
  1809. }
  1810. /// <summary>
  1811. /// 删除文件(邮件截图)
  1812. /// </summary>
  1813. /// <param name="file"></param>
  1814. /// <returns></returns>
  1815. [HttpPost]
  1816. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1817. public async Task<IActionResult> OfficialActivitiesDelFile(OfficialActivitiesDelFileDto dto)
  1818. {
  1819. string networkPath = AppSettingsHelper.Get("GrpFileBaseUrl");
  1820. string localPath = AppSettingsHelper.Get("GrpFileBasePath");
  1821. string ptfPath = AppSettingsHelper.Get("GrpFileFtpPath");
  1822. if (dto.Id < 1 || string.IsNullOrEmpty(dto.FileName))
  1823. {
  1824. return Ok(JsonView(false, "参数有误,上传失败!"));
  1825. }
  1826. string localFileDir = $"{localPath}{ptfPath}";
  1827. List<string> fileUrls = new List<string>();
  1828. var oaInfo = await _sqlSugar.Queryable<Res_OfficialActivities>().Where(x => x.Id == dto.Id).FirstAsync();
  1829. if (oaInfo != null)
  1830. {
  1831. string urlJson = oaInfo.ScreenshotOfMailUrl ?? "";
  1832. if (!string.IsNullOrEmpty(urlJson))
  1833. {
  1834. List<string> urls = JsonConvert.DeserializeObject<List<string>>(urlJson);
  1835. var filePath = urls.Find(x => x.Contains(dto.FileName));
  1836. if (string.IsNullOrEmpty(filePath)) return Ok(JsonView(false, "文件不存在!"));
  1837. var updFile = urls.Remove(filePath);
  1838. if (updFile)
  1839. {
  1840. //删除文件
  1841. string fileUrl = AppSettingsHelper.Get("GrpFileBasePath").Replace(@"/Office/GrpFile", "") + filePath;
  1842. if (System.IO.File.Exists(fileUrl))
  1843. {
  1844. System.IO.File.Delete(fileUrl);
  1845. }
  1846. string urlJsonstr = JsonConvert.SerializeObject(urls);
  1847. var upd = await _sqlSugar.Updateable<Res_OfficialActivities>()
  1848. .SetColumns(x => x.ScreenshotOfMailUrl == urlJsonstr)
  1849. .Where(x => x.Id == dto.Id)
  1850. .ExecuteCommandAsync();
  1851. if (upd > 0) return Ok(JsonView(true, "操作成功!"));
  1852. }
  1853. }
  1854. }
  1855. return Ok(JsonView(false, "操作失败!"));
  1856. }
  1857. /// <summary>
  1858. /// 公务出访 确认、取消邀请
  1859. /// </summary>
  1860. /// <param name="file"></param>
  1861. /// <returns></returns>
  1862. [HttpPost]
  1863. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1864. public async Task<IActionResult> OfficialActivitiesInviteOperation(OfficialActivitiesInviteOperationDto dto)
  1865. {
  1866. if (dto.Id < 1) return Ok(JsonView(false, "Id参数有误!"));
  1867. if (dto.Type < 0 || dto.Type > 1) return Ok(JsonView(false, "Type参数有误!"));
  1868. var upd = await _sqlSugar.Updateable<Res_OfficialActivities>()
  1869. .SetColumns(x => x.ConfirmTheInvitation == dto.Type)
  1870. .Where(x => x.Id == dto.Id)
  1871. .ExecuteCommandAsync();
  1872. if (upd > 0) return Ok(JsonView(true, "操作成功!"));
  1873. return Ok(JsonView(false, "操作失败!"));
  1874. }
  1875. /// <summary>
  1876. /// 上传文件
  1877. /// </summary>
  1878. /// <param name="file"></param>
  1879. /// <returns></returns>
  1880. [HttpPost]
  1881. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1882. public async Task<IActionResult> UploadOfficialActivities(IFormFile file)
  1883. {
  1884. try
  1885. {
  1886. int Type = int.Parse(Request.Headers["Type"]);//1公务方简介,2公务活动图片,3发票
  1887. int DiId = int.Parse(Request.Headers["DiId"]);
  1888. int CreateUserId = int.Parse(Request.Headers["CreateUserId"]);
  1889. if (file != null)
  1890. {
  1891. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  1892. //文件名称
  1893. string projectFileName = file.FileName;
  1894. //上传的文件的路径
  1895. string filePath = "";
  1896. if (!Directory.Exists(fileDir))
  1897. {
  1898. Directory.CreateDirectory(fileDir);
  1899. }
  1900. //上传的文件的路径
  1901. filePath = fileDir + $@"\商邀相关文件\{projectFileName}";
  1902. using (FileStream fs = System.IO.File.Create(filePath))
  1903. {
  1904. file.CopyTo(fs);
  1905. fs.Flush();
  1906. }
  1907. Grp_DeleFile d = new Grp_DeleFile();
  1908. d.Diid = DiId;
  1909. d.Category = 970;
  1910. if (Type == 1) d.Kind = 1;
  1911. else if (Type == 2) d.Kind = 2;
  1912. else if (Type == 3) d.Kind = 3;
  1913. d.FileName = projectFileName;
  1914. d.FilePath = "";
  1915. d.CreateUserId = CreateUserId;
  1916. int id = await _sqlSugar.Insertable(d).ExecuteReturnIdentityAsync();
  1917. return Ok(JsonView(true, "上传成功!", projectFileName));
  1918. }
  1919. else
  1920. {
  1921. return Ok(JsonView(false, "上传失败!"));
  1922. }
  1923. }
  1924. catch (Exception ex)
  1925. {
  1926. return Ok(JsonView(false, "程序错误!"));
  1927. throw;
  1928. }
  1929. }
  1930. /// <summary>
  1931. /// 删除文件
  1932. /// </summary>
  1933. /// <param name="dto"></param>
  1934. /// <returns></returns>
  1935. [HttpPost]
  1936. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1937. public async Task<IActionResult> DelloadOfficialActivities(DelBaseDto dto)
  1938. {
  1939. try
  1940. {
  1941. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  1942. Grp_DeleFile _DeleFile = await _sqlSugar.Queryable<Grp_DeleFile>().FirstAsync(a => a.Id == dto.Id);
  1943. if (_DeleFile != null)
  1944. {
  1945. string fileName = _DeleFile.FileName;
  1946. string filePath = fileDir + "/团组增减款项相关文件/" + fileName;
  1947. // 删除该文件
  1948. System.IO.File.Delete(filePath);
  1949. int id = await _sqlSugar.Updateable<Grp_DeleFile>().Where(a => a.Id == dto.Id).SetColumns(a => new Grp_DeleFile { IsDel = 1, DeleteUserId = dto.DeleteUserId, DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }).ExecuteCommandAsync();
  1950. return Ok(JsonView(true, "取消文件成功!"));
  1951. }
  1952. else
  1953. {
  1954. return Ok(JsonView(false, "取消文件失败!"));
  1955. }
  1956. }
  1957. catch (Exception ex)
  1958. {
  1959. return Ok(JsonView(false, "程序错误!"));
  1960. throw;
  1961. }
  1962. }
  1963. /// <summary>
  1964. /// 删除公务出访信息
  1965. /// </summary>
  1966. /// <param name="dto"></param>
  1967. /// <returns></returns>
  1968. [HttpPost]
  1969. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1970. public async Task<IActionResult> DelOfficialActivities(DelBaseDto dto)
  1971. {
  1972. _sqlSugar.BeginTran();
  1973. var res = await _officialActivitiesRep.SoftDeleteByIdAsync<Res_OfficialActivities>(dto.Id.ToString(), dto.DeleteUserId);
  1974. if (!res)
  1975. {
  1976. _sqlSugar.RollbackTran();
  1977. return Ok(JsonView(false, "删除失败"));
  1978. }
  1979. #region 删除公务出访
  1980. await _sqlSugar.Updateable<Grp_OfficialDutyLinkTranslator>()
  1981. .SetColumns(x => new Grp_OfficialDutyLinkTranslator()
  1982. {
  1983. DeleteUserId = dto.DeleteUserId,
  1984. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
  1985. IsDel = 1,
  1986. Remark = $"公务出访-->删除"
  1987. })
  1988. .Where(x => x.OfficialDutyId == dto.Id)
  1989. .ExecuteCommandAsync();
  1990. #endregion
  1991. _sqlSugar.CommitTran();
  1992. return Ok(JsonView(true, "删除成功!"));
  1993. }
  1994. /// <summary>
  1995. /// 公务出访
  1996. /// 请示范例提示
  1997. /// Add Time:2024-05-13 13:56:44
  1998. /// </summary>
  1999. /// <param name="dto"></param>
  2000. /// <returns></returns>
  2001. [HttpPost]
  2002. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2003. public async Task<IActionResult> PostOfficialActivitiesReqReqSampleTips(PostOfficialActivitiesReqReqSampleTipsDto dto)
  2004. {
  2005. var res = await _officialActivitiesRep.PostReqReqSampleTips(dto.country, dto.area, dto.client);
  2006. if (res.Code == 0)
  2007. {
  2008. return Ok(JsonView(true, "操作成功!", res.Data));
  2009. }
  2010. return Ok(JsonView(false, res.Msg));
  2011. }
  2012. /// <summary>
  2013. /// 公务出访 (省外办,市外办) File Downlaod
  2014. /// </summary>
  2015. /// <param name="dto"></param>
  2016. /// <returns></returns>
  2017. [HttpPost]
  2018. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2019. public async Task<IActionResult> OfficialActivitiesFileDownload(OfficialActivitiesFileDownload dto)
  2020. {
  2021. #region 参数验证
  2022. if (dto.FileType < 1 || dto.FileType > 2) return Ok(JsonView(false, "请传入有效的FileType参数. 1 省外办出访请示 2 市外办出访请示", ""));
  2023. if (dto.DiId < 1) return Ok(JsonView(false, "请传入有效的DiId参数.", ""));
  2024. #endregion
  2025. //团组基础信息
  2026. var groupInfo = _sqlSugar.Queryable<Grp_DelegationInfo>().Where(it => it.IsDel == 0 && it.Id == dto.DiId).First();
  2027. if (groupInfo == null) return Ok(JsonView(false, "该团组基本信息不存在", ""));
  2028. groupInfo.VisitCountry = groupInfo.VisitCountry.Replace("|", "、");
  2029. //团组公务信息
  2030. var obDatas = _sqlSugar.Queryable<Res_OfficialActivities>().Where(it => it.IsDel == 0 && it.DiId == dto.DiId).OrderBy(it => it.Date).ToList();
  2031. //if (obDatas.Count < 1) return Ok(JsonView(false, "请先录入公务信息!"));
  2032. //团组客户名单
  2033. var guestResult = _tourClientListRep._ItemByDiId(1, dto.DiId);
  2034. List<TourClientListByDiIdView> guestInfos = new List<TourClientListByDiIdView>();
  2035. if (guestResult.Result.Code == 0) guestInfos = guestResult.Result.Data as List<TourClientListByDiIdView>;
  2036. string visitCountrys = ""; //××国家(或地区)×天,××国家(或地区)×天
  2037. string countryStayStr = ""; // xx、xx、xx
  2038. //出入境费用 住宿类型
  2039. var dayCostDatas = _sqlSugar.Queryable<Grp_DayAndCost>().Where(it => it.IsDel == 0 && it.DiId == dto.DiId && it.Type == 1).ToList();
  2040. if (dayCostDatas.Count > 0)
  2041. {
  2042. List<int> nationalIds = dayCostDatas.Select(it => it.NationalTravelFeeId).ToList();
  2043. var nationalDatas = _sqlSugar.Queryable<Grp_NationalTravelFee>().Where(it => nationalIds.Contains(it.Id)).ToList();
  2044. var nationalDataGroupByCountry = nationalDatas.GroupBy(it => it.Country);
  2045. foreach (var item in nationalDataGroupByCountry)
  2046. {
  2047. visitCountrys += $"{item.Key}、";
  2048. int stayDays = nationalIds.Where(it => it == item.ToList()[0].Id).Count();
  2049. countryStayStr += $"{item.Key}{stayDays}天,";
  2050. }
  2051. if (visitCountrys.Length > 0) visitCountrys = visitCountrys.Substring(0, visitCountrys.Length - 1);
  2052. if (countryStayStr.Length > 0) countryStayStr = countryStayStr.Substring(0, countryStayStr.Length - 1);
  2053. }
  2054. else
  2055. {
  2056. visitCountrys = groupInfo.VisitCountry;
  2057. countryStayStr = GeneralMethod.GetCountryStandingTime(groupInfo.Id); //计算国家出访天数
  2058. }
  2059. //出访人数
  2060. int visitPeopleNum = groupInfo.VisitPNumber;
  2061. int visitDaysNum = groupInfo.VisitDays;
  2062. //出访单位
  2063. string obInfoStr = "";
  2064. foreach (var ob in obDatas) obInfoStr += @$"{ob.Client.Trim()}{ob.Job.Trim()}{ob.Contact.Trim()}、";
  2065. if (obInfoStr.Length > 0) obInfoStr = obInfoStr.Substring(0, obInfoStr.Length - 1);
  2066. obInfoStr = obInfoStr ?? "[公务出访未录入]";
  2067. //出访路线
  2068. string lineStr = GeneralMethod.GetGroupCityLine(groupInfo.Id, "—");
  2069. if (dto.FileType == 1)
  2070. {
  2071. //载入模板
  2072. string tempPath = AppSettingsHelper.Get("WordBasePath") + "Template/省外办出访请示 - 模板.docx";
  2073. var doc = new Document(tempPath);
  2074. DocumentBuilder builder = new DocumentBuilder(doc);
  2075. //键值对存放数据
  2076. Dictionary<string, string> dic = new Dictionary<string, string>();
  2077. //××(组团单位):接团客户信息团组
  2078. dic.Add("GroupClient", $"{groupInfo.ClientUnit}\r\n");
  2079. //关于××(职务、姓名)等×人赴××(国家或地区)进行×××(出访目的)的请示
  2080. string guestName = "";
  2081. string guestJob = "";
  2082. string guestInfoStr = "";
  2083. var guestFirstInfo = guestInfos.FirstOrDefault();
  2084. if (guestFirstInfo != null)
  2085. {
  2086. guestName = guestFirstInfo.LastName.Trim() + guestFirstInfo.FirstName.Trim();
  2087. guestJob = guestFirstInfo.Job.Trim();
  2088. guestInfoStr = $@"{guestJob}、{guestName}";
  2089. }
  2090. guestInfoStr = guestInfoStr ?? "[接团客户名单未录入]";
  2091. string askTitle = $@"关于{guestInfoStr}等{visitPeopleNum}人赴{visitCountrys}进行{groupInfo.VisitPurpose}的请示";
  2092. dic.Add("AskTitle", askTitle);
  2093. //应×××(邀请方名称+邀请人职务和姓名)的邀请,我单位拟派×××(职务、姓名)等×人(人数)于×××年×××月×××日赴×××(国家或地区)进行×××(出访目的)。现请示如下。
  2094. string visitDateStr = @$"{groupInfo.VisitDate.Year}年{groupInfo.VisitDate.Month}月{groupInfo.VisitDate.Day}日";
  2095. string askSubTitle = $@"应{obInfoStr}的邀请,我单位拟派{guestInfoStr}等{visitPeopleNum}人于{visitDateStr}赴{visitCountrys}进行{groupInfo.VisitPurpose}。现请示如下。";
  2096. dic.Add("AskSubTitle", askSubTitle);
  2097. //出访目的
  2098. dic.Add("VisitPurpose", groupInfo.VisitPurpose);
  2099. //出访任务
  2100. //(一)××(国家或地区)
  2101. //1.拜访×××(机构名称)×××(姓名、职务)洽谈(或调研、推动等)×××(项目或机构名称等)。(例:拜会×××经济与发展司司长×××,商讨“×××活动”相关筹备工作。)
  2102. //2.拜访×××(机构名称)×××(姓名、职务)洽谈(或调研、推动等)×××(项目或机构名称等)。(例:拜会×××经济与发展司司长×××,商讨“×××活动”相关筹备工作。)
  2103. string obBackgroundStr = "";//出访背景
  2104. string taskStr = ""; ; //出访任务
  2105. var countrys = obDatas.GroupBy(it => it.Country);
  2106. int countryIndex = 1;
  2107. foreach (var item in countrys)
  2108. {
  2109. string taskTitle = $"({GetToUpperNumber(countryIndex)}){item.Key}\r\n";
  2110. string taskContent = "";
  2111. string obBackgroundContent = "";
  2112. int obIndex = 1;
  2113. foreach (var obInfo in item.ToList())
  2114. {
  2115. string reqSmaple = "";
  2116. string settingStr = "";
  2117. if (!string.IsNullOrEmpty(obInfo.ReqSample)) reqSmaple = obInfo.ReqSample;
  2118. else reqSmaple = "[公务出访请示范例未录入]";
  2119. if (!string.IsNullOrEmpty(obInfo.Setting)) settingStr = obInfo.Setting;
  2120. else settingStr = "[公务方背景未录入]";
  2121. taskContent += $"{obIndex}. {reqSmaple}\r\n";
  2122. obBackgroundContent += $"{obIndex}. {obInfo.Client}:{settingStr}\r\n";
  2123. obIndex++;
  2124. }
  2125. taskStr += $"{taskTitle}{taskContent}";
  2126. obBackgroundStr += $"{taskTitle}{obBackgroundContent}";
  2127. countryIndex++;
  2128. }
  2129. //出访背景
  2130. if (obBackgroundStr.Length < 1) obBackgroundStr = "[公务出访背景未录入]";
  2131. dic.Add("OBSetting", obBackgroundStr);
  2132. //出访任务
  2133. if (taskStr.Length < 1) taskStr = "[公务出访任务未录入]";
  2134. dic.Add("TaskContent", taskStr);
  2135. //出访时间
  2136. //代表团拟于××年×月×日—×月×日出访,在外停留×天。其中,××国家(或地区)×天,××国家(或地区)×天。
  2137. string visitTimeQuantumStr = $"代表团拟于{groupInfo.VisitStartDate.Year}年{groupInfo.VisitStartDate.Month}月{groupInfo.VisitStartDate.Day}日—{groupInfo.VisitEndDate.Month}月{groupInfo.VisitEndDate.Day}日出访,在外停留{visitDaysNum}天。其中,{countryStayStr}。";
  2138. //出访时间
  2139. dic.Add("TimeQuantum", visitTimeQuantumStr);
  2140. //出访路线
  2141. //成都—××(出境城市名称)—××(转机不出机场)—××(公务所在城市)……—××(入境城市名称)—成都。(例:成都—法兰克福<转机不出机场>—巴黎—巴塞罗那—阿姆斯特丹<转机不出机场>-成都)
  2142. dic.Add("Line", lineStr);
  2143. //scheduling //行程安排
  2144. string schedulingStr = $"[OP行程单暂未生成]";
  2145. #region op行程 根据黑屏代码录入
  2146. var opTripView = GeneralMethod.GetBriefStroke(groupInfo.Id);
  2147. if (opTripView.Code != 0) schedulingStr = $"[{opTripView.Msg}]";
  2148. schedulingStr = "";
  2149. List<Grp_TravelList> travelList = new List<Grp_TravelList>();
  2150. travelList = opTripView.Data as List<Grp_TravelList>;
  2151. if (travelList != null)
  2152. {
  2153. foreach (var item in travelList)
  2154. {
  2155. schedulingStr += $"{item.Date}({item.WeekDay})\r\n{item.Trip}\r\n";
  2156. }
  2157. }
  2158. #endregion
  2159. dic.Add("Scheduling", schedulingStr);
  2160. #region 填充word模板书签内容
  2161. foreach (var key in dic.Keys)
  2162. {
  2163. builder.MoveToBookmark(key);
  2164. builder.Write(dic[key]);
  2165. }
  2166. #endregion
  2167. //获取word里所有表格
  2168. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  2169. //获取所填表格的序数
  2170. Aspose.Words.Tables.Table tableOne = allTables[0] as Aspose.Words.Tables.Table;
  2171. var rowStart = tableOne.Rows[0]; //获取第1行
  2172. //循环赋值
  2173. for (int i = 0; i < guestInfos.Count; i++)
  2174. {
  2175. var guestInfo = guestInfos[i];
  2176. builder.MoveToCell(0, i + 1, 0, 0);
  2177. builder.Write(guestInfo.LastName + guestInfo.FirstName);
  2178. builder.MoveToCell(0, i + 1, 1, 0);
  2179. int sex = guestInfo.Sex;
  2180. string sexStr = string.Empty;
  2181. if (sex == 0) sexStr = "男";
  2182. else if (sex == 1) sexStr = "女";
  2183. else sexStr = "-";
  2184. builder.Write(sexStr);
  2185. builder.MoveToCell(0, i + 1, 2, 0);
  2186. builder.Write(guestInfo.CompanyFullName + guestInfo.Job);
  2187. builder.MoveToCell(0, i + 1, 3, 0);
  2188. string birthDay = "";
  2189. string birthDayStr = string.Empty;
  2190. if (guestInfo.BirthDay != null)
  2191. {
  2192. birthDayStr = guestInfo.BirthDay.ToString("yyyy.MM");
  2193. }
  2194. builder.Write(birthDayStr);
  2195. }
  2196. //删除多余行
  2197. while (tableOne.Rows.Count > guestInfos.Count + 1)
  2198. {
  2199. tableOne.Rows.RemoveAt(guestInfos.Count + 1);
  2200. }
  2201. var fileDir = AppSettingsHelper.Get("WordBasePath");
  2202. string fileName = $"{groupInfo.TeamName}省外办出访请示{DateTime.Now.ToString("yyyyMMddHHmmss")}.docx";
  2203. string filePath = fileDir + $@"OfficialActivities/{fileName}";
  2204. doc.Save(filePath);
  2205. string Url = $@"{AppSettingsHelper.Get("WordBaseUrl")}Office/Word/OfficialActivities/{fileName}";
  2206. return Ok(JsonView(true, "操作成功!", Url));
  2207. }
  2208. else if (dto.FileType == 2)
  2209. {
  2210. //载入模板
  2211. string tempPath = AppSettingsHelper.Get("WordBasePath") + "Template/市外办出访请示 - 模板.docx";
  2212. var doc = new Document(tempPath);
  2213. DocumentBuilder builder = new DocumentBuilder(doc);
  2214. //键值对存放数据
  2215. Dictionary<string, string> dic = new Dictionary<string, string>();
  2216. //××(组团单位):接团客户信息团组
  2217. dic.Add("GroupClient", $"{groupInfo.ClientUnit}");
  2218. dic.Add("GroupClient1", $"{groupInfo.ClientUnit}");
  2219. //关于××(职务、姓名)等×人赴××(国家或地区)进行×××(出访目的)的请示
  2220. string guestName = "";
  2221. string guestJob = "";
  2222. string guestInfoStr = "";
  2223. var guestFirstInfo = guestInfos.FirstOrDefault();
  2224. if (guestFirstInfo != null)
  2225. {
  2226. guestName = guestFirstInfo.LastName.Trim() + guestFirstInfo.FirstName.Trim();
  2227. guestJob = guestFirstInfo.Job;
  2228. guestInfoStr = $@"{guestJob}、{guestName.Trim()}";
  2229. }
  2230. string reqTitle = $@"关于{guestInfoStr}等{visitPeopleNum}人赴{visitCountrys}进行{groupInfo.VisitPurpose}的请示";
  2231. dic.Add("ReqTitle", reqTitle);
  2232. //应×××(邀请方名称+邀请人职务和姓名)的邀请,我单位拟派×××(职务、姓名)等×人(人数)于×××年×××月×××日赴×××(国家或地区)进行×××(出访目的)。
  2233. string visitDateStr = @$"{groupInfo.VisitDate.Year}年{groupInfo.VisitDate.Month}月{groupInfo.VisitDate.Day}日";
  2234. string reqSubTitle = $@"应{obInfoStr}的邀请,我单位拟派{guestInfoStr}等{visitPeopleNum}人于{visitDateStr}赴{visitCountrys}进行{groupInfo.VisitPurpose}。";
  2235. dic.Add("ReqSubTitle", reqSubTitle);
  2236. /*
  2237. * 出访任务
  2238. * (一)××(国家或地区)
  2239. * 1.拜访×××(机构名称)×××(姓名、职务)洽谈(或调研、推动等)×××(项目或机构名称等)。(例:拜会×××经济与发展司司长×××,商讨“×××活动”相关筹备工作。)背景:拟拜访机构的优势、拟洽谈项目的前期进展情况等。(例:背景:由×××总领馆联合×××市政府共同举办的“×××活动”将于今年6月在×××举行。)
  2240. * 2.拜访×××(机构名称)×××(姓名、职务)洽谈(或调研等)×××(项目或机构名称等)。(例:拜会友城×××市市长×××,巩固和发展两市传统友谊,商谈两市未来互动交流合作项目。)背景:拟拜访机构的优势、拟洽谈项目的前期进展情况等。(例:背景:×××年×月,×××市与×××市正式缔结友好城市关系。在此框架下,两市开展了一系列友好互访和商务交流。并于×××年×月共同举办了“×××活动”。)
  2241. *
  2242. */
  2243. string taskStr = string.Empty;
  2244. List<string> countrys = obDatas.Where(it => !string.IsNullOrEmpty(it.Country)).Select(it => it.Country).ToList();
  2245. int countryIndex = 1;
  2246. foreach (var item in countrys)
  2247. {
  2248. string taskTitle = $"({GetToUpperNumber(countryIndex)}){item ?? "[公务出访国家未填写]"}\r\n";
  2249. string taskContent = "";
  2250. if (!string.IsNullOrEmpty(item))
  2251. {
  2252. var countryObDatas = obDatas.Where(it => !string.IsNullOrEmpty(it.Country) && it.Country.Contains(item)).OrderBy(it => it.Date).ToList();
  2253. int obIndex = 1;
  2254. if (countryObDatas.Count == 0) taskContent = "[公务出访未录入]\r\n";
  2255. else
  2256. {
  2257. foreach (var obInfo in countryObDatas)
  2258. {
  2259. taskContent += $"{obIndex}.{obInfo.ReqSample ?? "[公务出访请示范例未填写]"}\r\n背景:{obInfo.Setting ?? "[公务出访背景未填写]"}\r\n";
  2260. obIndex++;
  2261. }
  2262. }
  2263. }
  2264. taskStr += $"{taskTitle}{taskContent}";
  2265. countryIndex++;
  2266. }
  2267. if (string.IsNullOrEmpty(taskStr)) taskStr = "××××××";
  2268. //出访任务
  2269. dic.Add("TaskContent", taskStr);
  2270. //出访目的
  2271. dic.Add("VisitPurpose", groupInfo.VisitPurpose);
  2272. //出访信息
  2273. //代表团拟于××年×月×日—×月×日出访,在外停留×天。其中,××国家(或地区)×天,××国家(或地区)×天。出访路线:成都—××(出境城市名称)—××(转机不出机场)—××(公务所在城市)……—××(入境城市名称)—成都。(例:成都—法兰克福<转机不出机场>—巴黎—巴塞罗那—阿姆斯特丹<转机不出机场>-成都)出访费用:由××承担(注明由外方或上级机关承担,还是由派员单位在年度安排的预算经费中列支)。
  2274. string tripInfoStr = "";
  2275. tripInfoStr = $"代表团拟于{groupInfo.VisitStartDate.Year}年{groupInfo.VisitStartDate.Month}月{groupInfo.VisitStartDate.Day}日—{groupInfo.VisitEndDate.Month}月{groupInfo.VisitEndDate.Day}日出访,在外停留{visitDaysNum}天。其中,{countryStayStr}。出访路线:{lineStr}。出访费用:由××承担(注明由外方或上级机关承担,还是由派员单位在年度安排的预算经费中列支)";
  2276. dic.Add("TripInfo", tripInfoStr);
  2277. #region 填充word模板书签内容
  2278. foreach (var key in dic.Keys)
  2279. {
  2280. builder.MoveToBookmark(key);
  2281. builder.Write(dic[key]);
  2282. }
  2283. #endregion
  2284. //获取word里所有表格
  2285. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  2286. //获取所填表格的序数
  2287. Aspose.Words.Tables.Table tableOne = allTables[0] as Aspose.Words.Tables.Table;
  2288. var rowStart = tableOne.Rows[0]; //获取第1行
  2289. //循环赋值
  2290. for (int i = 0; i < guestInfos.Count; i++)
  2291. {
  2292. var guestInfo = guestInfos[i];
  2293. builder.MoveToCell(0, i + 1, 0, 0);
  2294. builder.Write(guestInfo.LastName + guestInfo.FirstName);
  2295. builder.MoveToCell(0, i + 1, 1, 0);
  2296. int sex = guestInfo.Sex;
  2297. string sexStr = string.Empty;
  2298. if (sex == 0) sexStr = "男";
  2299. else if (sex == 1) sexStr = "女";
  2300. else sexStr = "未设置";
  2301. builder.Write(sexStr);
  2302. builder.MoveToCell(0, i + 1, 2, 0);
  2303. builder.Write(guestInfo.CompanyFullName + guestInfo.Job);
  2304. builder.MoveToCell(0, i + 1, 3, 0);
  2305. DateTime birthDay = guestInfo.BirthDay;
  2306. string birthDayStr = string.Empty;
  2307. if (birthDay != null)
  2308. {
  2309. birthDayStr = birthDay.ToString("yyyy.MM");
  2310. }
  2311. builder.Write(birthDayStr);
  2312. }
  2313. //删除多余行
  2314. while (tableOne.Rows.Count > guestInfos.Count + 1)
  2315. {
  2316. tableOne.Rows.RemoveAt(guestInfos.Count + 1);
  2317. }
  2318. var fileDir = AppSettingsHelper.Get("WordBasePath");
  2319. var fileName = $"{groupInfo.TeamName}市外办出访请示{DateTime.Now.ToString("yyyyMMddHHmmss")}.docx";
  2320. var filePath = fileDir + $@"OfficialActivities/{fileName}";
  2321. doc.Save(filePath);
  2322. var url = $@"{AppSettingsHelper.Get("WordBaseUrl")}Office/Word/OfficialActivities/{fileName}";
  2323. return Ok(JsonView(true, "操作成功!", url));
  2324. }
  2325. return Ok(JsonView(true, "操作失败!", ""));
  2326. }
  2327. private string GetToUpperNumber(int num)
  2328. {
  2329. string numStr = "";
  2330. if (num == 1) numStr = "一";
  2331. else if (num == 2) numStr = "二";
  2332. else if (num == 3) numStr = "三";
  2333. else if (num == 4) numStr = "四";
  2334. else if (num == 5) numStr = "五";
  2335. else if (num == 6) numStr = "六";
  2336. else if (num == 7) numStr = "七";
  2337. else if (num == 8) numStr = "八";
  2338. else if (num == 9) numStr = "九";
  2339. else if (num == 10) numStr = "十";
  2340. return numStr;
  2341. }
  2342. [HttpPost]
  2343. public IActionResult ExportOfficialActivitiesInfo(ExportOfficialActivitiesInfoDto dto)
  2344. {
  2345. var jw = JsonView(false);
  2346. if (!ModelState.IsValid)
  2347. {
  2348. jw.Data = ModelState;
  2349. return Ok(jw);
  2350. }
  2351. var startTime_bool = DateTime.TryParse(dto.StartTime, out DateTime startTime_parse);
  2352. var endTime_bool = DateTime.TryParse(dto.EndTime, out DateTime endTime_parse);
  2353. if(startTime_parse > endTime_parse)
  2354. {
  2355. jw.Msg = "开始实际不能大于结束时间!";
  2356. return Ok(jw);
  2357. }
  2358. if (startTime_bool && endTime_bool)
  2359. {
  2360. //处理时间模板
  2361. var Query_DB = _sqlSugar.Queryable<Grp_DelegationInfo>()
  2362. .LeftJoin<Res_OfficialActivities>((a, b) => a.Id == b.DiId && b.IsDel == 0)
  2363. .LeftJoin<Sys_Users>((a, b, c) => b.CreateUserId == c.Id && c.IsDel == 0)
  2364. .Where((a, b, c) => a.IsDel == 0 && a.VisitDate >= startTime_parse && a.VisitDate <= endTime_parse)
  2365. .WhereIF(dto.State != -1, (a, b, c) => b.ConfirmTheInvitation == dto.State)
  2366. .Select((a, b, c) => new
  2367. {
  2368. a.TeamName,
  2369. b.Client,
  2370. b.ConfirmTheInvitation,
  2371. b.Contact,
  2372. ConfirmTheInvitationStr = b.ConfirmTheInvitation == 1 ? "是" : "否",
  2373. b.Date,
  2374. b.Nature,
  2375. c.CnName,
  2376. b.Address,
  2377. b.CreateTime
  2378. })
  2379. .ToList()
  2380. .Where(x=>!x.Client.IsNullOrWhiteSpace())
  2381. .ToList();
  2382. if (Query_DB.Count > 0)
  2383. {
  2384. //打开excel
  2385. var ftpPath = AppSettingsHelper.Get("ExcelFtpPath");
  2386. var fileBasePath = AppSettingsHelper.Get("ExcelBasePath");
  2387. var fileName = "公务出访信息.docx";
  2388. //创建数据源Table
  2389. DataTable dtSource = new DataTable();
  2390. dtSource.TableName = "TB";
  2391. var firstElem = Query_DB.First();
  2392. //遍历firstElem所有属性
  2393. foreach (var item in firstElem.GetType().GetProperties())
  2394. {
  2395. dtSource.Columns.Add(item.Name, item.PropertyType);
  2396. }
  2397. foreach (var item in Query_DB)
  2398. {
  2399. DataRow dr = dtSource.NewRow();
  2400. //遍历dtSource所有列头
  2401. foreach (DataColumn column in dtSource.Columns)
  2402. {
  2403. dr[column.ColumnName] = item.GetType().GetProperty(column.ColumnName)?.GetValue(item)?.ToString();
  2404. }
  2405. dtSource.Rows.Add(dr);
  2406. }
  2407. WorkbookDesigner designer = new WorkbookDesigner();
  2408. designer.Workbook = new Workbook(fileBasePath + ("Template/公务出访信息.xlsx"));
  2409. var title = startTime_parse.ToString("yyyy年MM月dd日") + " - " + endTime_parse.ToString("yyyy年MM月dd日") + " 公务出访信息";
  2410. designer.SetDataSource("title", title);
  2411. designer.SetDataSource(dtSource);
  2412. designer.Process();
  2413. var exportSerevePath = fileBasePath + "ExportOfficialActivitiesInfo/" + title + ".xlsx";
  2414. var exportFtpPaht = ftpPath + "ExportOfficialActivitiesInfo/" + title + ".xlsx";
  2415. //保存文件
  2416. designer.Workbook.Save(exportSerevePath);
  2417. jw.Data = AppSettingsHelper.Get("ExcelBaseUrl") + exportFtpPaht;
  2418. jw.Code = 200;
  2419. jw.Msg = "获取成功!";
  2420. }
  2421. else
  2422. {
  2423. jw.Data = "无公务信息!";
  2424. }
  2425. }
  2426. else
  2427. {
  2428. jw.Data = "时间格式错误!";
  2429. }
  2430. return Ok(jw);
  2431. }
  2432. #endregion
  2433. #region 请示数据库
  2434. /// <summary>
  2435. /// 查询请示数据库初始化
  2436. /// </summary>
  2437. /// <param name="dto"></param>
  2438. /// <returns></returns>
  2439. [HttpPost]
  2440. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2441. public async Task<IActionResult> QueryAskData(QueryAskDataDto dto)
  2442. {
  2443. Result groupData = await _askDataRep.QueryAskData(dto);
  2444. if (groupData.Code != 0)
  2445. {
  2446. return Ok(JsonView(false, groupData.Msg));
  2447. }
  2448. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2449. }
  2450. /// <summary>
  2451. /// 根据Id查询请示数据库单条数据
  2452. /// </summary>
  2453. /// <param name="dto"></param>
  2454. /// <returns></returns>
  2455. [HttpPost]
  2456. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2457. public async Task<IActionResult> QueryAskDataById(QueryAskDataByIdDto dto)
  2458. {
  2459. Res_AskData _AskData = await _sqlSugar.Queryable<Res_AskData>().FirstAsync(a => a.IsDel == 0 && a.Id == dto.id);
  2460. if (_AskData == null)
  2461. {
  2462. return Ok(JsonView(true, "暂无数据!", _AskData));
  2463. }
  2464. return Ok(JsonView(true, "查询成功!", _AskData));
  2465. }
  2466. /// <summary>
  2467. /// 请示数据库操作(Status:1.新增,2.修改)
  2468. /// </summary>
  2469. /// <param name="dto"></param>
  2470. /// <returns></returns>
  2471. [HttpPost]
  2472. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2473. public async Task<IActionResult> OpAskData(OpAskDataDto dto)
  2474. {
  2475. Result groupData = await _askDataRep.OpAskData(dto);
  2476. if (groupData.Code != 0)
  2477. {
  2478. return Ok(JsonView(false, groupData.Msg));
  2479. }
  2480. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2481. }
  2482. /// <summary>
  2483. /// 删除请示资料信息
  2484. /// </summary>
  2485. /// <param name="dto"></param>
  2486. /// <returns></returns>
  2487. [HttpPost]
  2488. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2489. public async Task<IActionResult> DelAskData(DelBaseDto dto)
  2490. {
  2491. var res = await _askDataRep.SoftDeleteByIdAsync<Res_AskData>(dto.Id.ToString(), dto.DeleteUserId);
  2492. if (!res)
  2493. {
  2494. return Ok(JsonView(false, "删除失败"));
  2495. }
  2496. return Ok(JsonView(true, "删除成功!"));
  2497. }
  2498. /// <summary>
  2499. /// 请示资料信息
  2500. /// 省外办下载
  2501. /// </summary>
  2502. /// <param name="dto"></param>
  2503. /// <returns></returns>
  2504. [HttpPost]
  2505. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2506. public async Task<IActionResult> AskDataProvinceFAOPFile(AskDataProvinceFileDto dto)
  2507. {
  2508. if (dto.DataIdItem.Length < 1) return Ok(JsonView(false,$"请传入有效的数据Id集合!"));
  2509. if (dto.DiId < 1) return Ok(JsonView(false, $"请传入有效的数据DiId参数!"));
  2510. //大写数字序号
  2511. string[] num = { "一", "二", "三", "四", "五", "六", "七", "八", "九", "十" ,
  2512. "十一","十二","十三","十四","十五","十六","十七","十八","十九","二十",
  2513. "二十一","二十二","二十三","二十四","二十五","二十六","二十七","二十八","二十九","三十",
  2514. "三十一","三十二","三十三","三十四","三十五","三十六","三十七","三十八","三十九","四十"};
  2515. //数据源
  2516. var idItem = dto.DataIdItem.OrderBy(x => x);
  2517. var askDatas = await _sqlSugar.Queryable<Res_AskData>().Where(x => x.IsDel == 0 && idItem.Contains(x.Id)).ToListAsync();
  2518. //书签名
  2519. string Area = "",
  2520. Official = "";
  2521. //表格数据源
  2522. DataTable dt = new DataTable();
  2523. dt.Columns.Add("Country", typeof(string));
  2524. dt.Columns.Add("TalkCase", typeof(string));
  2525. int id = 0;
  2526. int TalkcaseOrder = 0;
  2527. int RowOrder = 0;
  2528. //填充数据
  2529. for (int i = 0; i < askDatas.Count; i++)
  2530. {
  2531. var ad = askDatas[i];
  2532. Area = Area + ad.Country + ad.Area + "、";
  2533. Official = Official + ad.UnitName + "、";
  2534. //填充表格数据源
  2535. DataRow dr = dt.NewRow();
  2536. if (i > 0)
  2537. {
  2538. var adtemp = askDatas[i - 1];
  2539. if (ad.Country == adtemp.Country)
  2540. {
  2541. TalkcaseOrder++;
  2542. dt.Rows[RowOrder]["TalkCase"] = dt.Rows[RowOrder]["TalkCase"] + "\r\n" + (1 + TalkcaseOrder).ToString() + "、" + ad.TalkCase;
  2543. }
  2544. else
  2545. {
  2546. RowOrder++;
  2547. dr = dt.NewRow();
  2548. dr["Country"] = "(" + num[RowOrder] + ")" + ad.Country;
  2549. dr["TalkCase"] = "1、" + ad.TalkCase;
  2550. dt.Rows.Add(dr);
  2551. TalkcaseOrder = 0;
  2552. }
  2553. }
  2554. else
  2555. {
  2556. dr["Country"] = "(" + num[i] + ")" + ad.Country;
  2557. dr["TalkCase"] = "1、" + ad.TalkCase;
  2558. dt.Rows.Add(dr);
  2559. }
  2560. id = ad.Id;
  2561. }
  2562. //模板路径
  2563. var tempPath = AppSettingsHelper.Get("WordBasePath") + "Template/省外办出访请示模板.doc";
  2564. //载入模板
  2565. Aspose.Words.Document doc = new Aspose.Words.Document(tempPath);
  2566. #region 填充word内容
  2567. #region 填充请示内容
  2568. //利用DocumentBuilder处理表格或是书签
  2569. Aspose.Words.DocumentBuilder builder = new DocumentBuilder(doc);
  2570. string bookmark = "";
  2571. try
  2572. {
  2573. for (int i = 0; i < dt.Rows.Count; i++)
  2574. {
  2575. bookmark = bookmark
  2576. + dt.Rows[i]["Country"].ToString() + "\r\n"
  2577. + dt.Rows[i]["TalkCase"].ToString() + "\r\n";
  2578. }
  2579. }
  2580. catch
  2581. {
  2582. }
  2583. #endregion
  2584. #region 填充word模板书签内容
  2585. //团组信息
  2586. var di = await _sqlSugar.Queryable<Grp_DelegationInfo>().Where(x => x.IsDel == 0 && x.Id == dto.DiId).FirstAsync();
  2587. //接团客户名单实例
  2588. string client_sql = string.Format(@"
  2589. SELECT
  2590. tcl.Id,
  2591. tcl.DiId,
  2592. tcl.IsAccompany,
  2593. temp.*,
  2594. u.CnName AS Operator,
  2595. tcl.CreateTime AS OperatingTime
  2596. FROM
  2597. Grp_TourClientList tcl
  2598. LEFT JOIN (
  2599. SELECT
  2600. dc.Id AS DcId,
  2601. dc.LastName,
  2602. dc.FirstName,
  2603. ccom.CompanyFullName,
  2604. dc.Job,
  2605. cc.CertNo AS IDCardNo,
  2606. dc.Sex,
  2607. dc.BirthDay
  2608. FROM
  2609. Crm_DeleClient dc
  2610. LEFT JOIN Crm_CustomerCompany ccom ON dc.CrmCompanyId = ccom.Id
  2611. AND ccom.IsDel = 0
  2612. LEFT JOIN Crm_CustomerCert cc ON dc.Id = cc.DcId
  2613. AND cc.SdId = 773
  2614. AND cc.IsDel = 0
  2615. WHERE
  2616. dc.IsDel = 0
  2617. ) temp ON temp.DcId = tcl.ClientId
  2618. LEFT JOIN Sys_Users u ON tcl.CreateUserId = u.Id
  2619. WHERE
  2620. tcl.IsDel = 0
  2621. AND tcl.DiId = {0}", dto.DiId);
  2622. var clientList = await _sqlSugar.SqlQueryable<TourClientListDetailsView>(client_sql).ToListAsync();
  2623. //机票代码实例
  2624. DataTable airTable = GeneralMethod.GetTableByBlackCode(dto.DiId);
  2625. //三字码
  2626. var threeCodes = await _sqlSugar.Queryable<Res_ThreeCode>().Where(x => x.IsDel == 0 ).ToListAsync();
  2627. //团名
  2628. if (doc.Range.Bookmarks["TeamName"] != null)
  2629. {
  2630. Bookmark mark = doc.Range.Bookmarks["TeamName"];
  2631. mark.Text = di.TeamName;
  2632. }
  2633. //团长名
  2634. if (doc.Range.Bookmarks["ClientName2"] != null)
  2635. {
  2636. Bookmark mark = doc.Range.Bookmarks["ClientName2"];
  2637. if (clientList == null || clientList.Count == 0)
  2638. {
  2639. mark.Text = "【本团尚未录入客户名单,请联系主管!】";
  2640. }
  2641. else
  2642. {
  2643. mark.Text = clientList[0].CompanyFullName + clientList[0].Job + clientList[0].LastName + clientList[0].FirstName;
  2644. }
  2645. }
  2646. if (doc.Range.Bookmarks["ClientName"] != null)
  2647. {
  2648. Bookmark mark = doc.Range.Bookmarks["ClientName"];
  2649. if (clientList == null || clientList.Count == 0)
  2650. {
  2651. mark.Text = "【本团尚未录入客户名单,请联系主管!】";
  2652. }
  2653. else
  2654. {
  2655. mark.Text = clientList[0].CompanyFullName + clientList[0].Job + clientList[0].LastName + clientList[0].FirstName;
  2656. }
  2657. }
  2658. //跟团人数
  2659. if (doc.Range.Bookmarks["ClientNumber2"] != null)
  2660. {
  2661. Bookmark mark = doc.Range.Bookmarks["ClientNumber2"];
  2662. mark.Text = di.VisitPNumber.ToString();
  2663. }
  2664. if (doc.Range.Bookmarks["ClientNumber"] != null)
  2665. {
  2666. Bookmark mark = doc.Range.Bookmarks["ClientNumber"];
  2667. mark.Text = di.VisitPNumber.ToString();
  2668. }
  2669. //地区
  2670. if (doc.Range.Bookmarks["Area"] != null)
  2671. {
  2672. Bookmark mark = doc.Range.Bookmarks["Area"];
  2673. mark.Text = Area.TrimEnd('、');
  2674. }
  2675. if (doc.Range.Bookmarks["Area2"] != null)
  2676. {
  2677. Bookmark mark = doc.Range.Bookmarks["Area2"];
  2678. mark.Text = Area.TrimEnd('、');
  2679. }
  2680. //出访目的
  2681. if (doc.Range.Bookmarks["Destination2"] != null)
  2682. {
  2683. Bookmark mark = doc.Range.Bookmarks["Destination2"];
  2684. mark.Text = di.VisitPurpose;
  2685. }
  2686. if (doc.Range.Bookmarks["Destination"] != null)
  2687. {
  2688. Bookmark mark = doc.Range.Bookmarks["Destination"];
  2689. mark.Text = di.VisitPurpose;
  2690. }
  2691. //邀请方
  2692. if (doc.Range.Bookmarks["Official"] != null)
  2693. {
  2694. Bookmark mark = doc.Range.Bookmarks["Official"];
  2695. mark.Text = Official.TrimEnd('、');
  2696. }
  2697. //出访日期
  2698. if (doc.Range.Bookmarks["VisitDate"] != null)
  2699. {
  2700. Bookmark mark = doc.Range.Bookmarks["VisitDate"];
  2701. mark.Text = di.VisitStartDate.Year + "年"
  2702. + di.VisitStartDate.Month + "月"
  2703. + di.VisitStartDate.Day + "日"
  2704. + "至"
  2705. + di.VisitEndDate.Month + "月"
  2706. + di.VisitEndDate.Day + "日";
  2707. }
  2708. //请示范例
  2709. if (doc.Range.Bookmarks["Temp"] != null)
  2710. {
  2711. Bookmark mark = doc.Range.Bookmarks["Temp"];
  2712. mark.Text = bookmark;
  2713. }
  2714. //出访起止日期
  2715. if (doc.Range.Bookmarks["Duration"] != null)
  2716. {
  2717. Bookmark mark = doc.Range.Bookmarks["Duration"];
  2718. mark.Text = di.VisitStartDate.Year + "年"
  2719. + di.VisitStartDate.Month + "月"
  2720. + di.VisitStartDate.Day + "日"
  2721. + "至"
  2722. + di.VisitEndDate.Month + "月"
  2723. + di.VisitEndDate.Day + "日";
  2724. }
  2725. //出访天数
  2726. if (doc.Range.Bookmarks["Durationdays"] != null)
  2727. {
  2728. Bookmark mark = doc.Range.Bookmarks["Durationdays"];
  2729. mark.Text = di.VisitDays.ToString();
  2730. }
  2731. if (doc.Range.Bookmarks["Durationdays2"] != null)
  2732. {
  2733. Bookmark mark = doc.Range.Bookmarks["Durationdays2"];
  2734. mark.Text = di.VisitDays.ToString();
  2735. }
  2736. #region 根据黑屏代码获取国家呆的天数;获取路线
  2737. string result_CountryAndDay = "", result_Air = "";
  2738. if (airTable.Rows[airTable.Rows.Count - 1]["Day"].ToString() == "")
  2739. {
  2740. result_CountryAndDay = airTable.Rows[airTable.Rows.Count - 1]["Fliagtcode"].ToString();
  2741. result_Air = result_CountryAndDay;
  2742. }
  2743. else
  2744. {
  2745. string place_start, place_end;
  2746. DateTime time_start, time_end;
  2747. Res_ThreeCode three = null;
  2748. for (int i = 0; i < airTable.Rows.Count; i++)
  2749. {
  2750. //三字码实例
  2751. three = threeCodes.Find(x => x.Three == airTable.Rows[i]["Three"].ToString().Substring(0, 3));
  2752. if (three == null)
  2753. {
  2754. place_start = "【未收录三字码" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + ",请联系机票同事】";
  2755. }
  2756. else
  2757. {
  2758. if (string.IsNullOrEmpty(three.Country))
  2759. {
  2760. place_start = "【本三字码" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + "未录入国家信息,请联系机票同事】";
  2761. }
  2762. else
  2763. {
  2764. place_start = three.City;
  2765. }
  2766. }
  2767. three = threeCodes.Find(x => x.Three == airTable.Rows[i]["Three"].ToString().Substring(3, 3));
  2768. if (three == null)
  2769. {
  2770. place_end = "【未收录" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + ",请联系机票同事】";
  2771. }
  2772. else
  2773. {
  2774. if (string.IsNullOrEmpty(three.Country))
  2775. {
  2776. place_end = "【本三字码" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + "未录入国家信息,请联系机票同事】";
  2777. }
  2778. else
  2779. {
  2780. place_end = three.City;
  2781. }
  2782. }
  2783. result_Air += place_start + "一" + place_end + "一";
  2784. //获取国家和呆的天数
  2785. if (i > 0 && i < airTable.Rows.Count - 1)
  2786. {
  2787. time_start = Convert.ToDateTime(airTable.Rows[i - 1]["Day"]);
  2788. time_end = Convert.ToDateTime(airTable.Rows[i]["Day"]);
  2789. TimeSpan daycount = time_end.Subtract(time_start);
  2790. result_CountryAndDay += place_start + daycount.Days + "天" + ",";
  2791. }
  2792. }
  2793. }
  2794. #endregion
  2795. //每个国家呆的天数
  2796. if (doc.Range.Bookmarks["CountryAndDay"] != null)
  2797. {
  2798. Bookmark mark = doc.Range.Bookmarks["CountryAndDay"];
  2799. mark.Text = result_CountryAndDay.TrimEnd(',');
  2800. }
  2801. #region 出访路线城市字符串去重
  2802. result_Air = result_Air.TrimEnd('一');
  2803. string[] airTemp = result_Air.Split('一');
  2804. airTemp = airTemp.Distinct().ToArray();
  2805. result_Air = "";
  2806. foreach (string str in airTemp)
  2807. {
  2808. result_Air += str + "一";
  2809. }
  2810. result_Air = result_Air + airTemp[0];
  2811. #endregion
  2812. //出访路线
  2813. if (doc.Range.Bookmarks["Air"] != null)
  2814. {
  2815. Bookmark mark = doc.Range.Bookmarks["Air"];
  2816. mark.Text = result_Air;
  2817. }
  2818. #endregion
  2819. #region 客户名单
  2820. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  2821. Aspose.Words.Tables.Table tableClient = allTables[0] as Aspose.Words.Tables.Table;
  2822. if (clientList == null || clientList.Count == 0)
  2823. {
  2824. builder.MoveToCell(0, 1, 0, 0);
  2825. builder.Write("【本团尚未录入客户名单,请联系主管!】");
  2826. }
  2827. else
  2828. {
  2829. for (int i = 0; i < clientList.Count(); i++)
  2830. {
  2831. builder.MoveToCell(0, i + 1, 0, 0);
  2832. builder.Write((i + 1).ToString());
  2833. builder.MoveToCell(0, i + 1, 1, 0);
  2834. builder.Write(clientList[i].LastName.ToString() + clientList[i].FirstName.ToString());
  2835. builder.MoveToCell(0, i + 1, 2, 0);
  2836. builder.Write(clientList[i].Sex.ToString());
  2837. builder.MoveToCell(0, i + 1, 3, 0);
  2838. builder.Write(clientList[i].BirthDay);
  2839. builder.MoveToCell(0, i + 1, 4, 0);
  2840. builder.Write(clientList[i].CompanyFullName + clientList[i].Job.ToString());
  2841. }
  2842. }
  2843. while (tableClient.Rows.Count > clientList.Count + 1)
  2844. {
  2845. tableClient.Rows.RemoveAt(clientList.Count + 1);
  2846. }
  2847. #endregion
  2848. #region 商邀行程
  2849. string content = "", temp1 = "", temp2 = "";
  2850. //获取数据,放到datatable
  2851. var listapt = await _sqlSugar.Queryable<Grp_ApprovalTravel>()
  2852. .LeftJoin<Grp_ApprovalTravelDetails>((at, atd) => at.Id == atd.ParentId)
  2853. .Where((at, atd) => at.IsDel == 0 && at.Diid == dto.DiId)
  2854. .Select((at, atd) => new
  2855. {
  2856. at.Id,
  2857. at.Date,
  2858. atd.Time,
  2859. atd.Details
  2860. })
  2861. .ToListAsync();
  2862. if (listapt == null || listapt.Count == 0)
  2863. {
  2864. content = "尚未生成商邀行程";
  2865. }
  2866. else
  2867. {
  2868. for (int i = 0; i < listapt.Count; i++)
  2869. {
  2870. content = content + " " + listapt[i].Date + "\r\n";
  2871. temp1 = listapt[i].Time;
  2872. temp2 = listapt[i].Details;
  2873. if (!string.IsNullOrEmpty(temp1))
  2874. {
  2875. string[] str = temp1.Replace("\r\n", " ").Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  2876. string[] str2 = temp2.Replace("\r\n", " ").Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  2877. for (int j = 0; j < str.Count(); j++)
  2878. {
  2879. content = content + " " + str[j] + str2[j] + "\r\n";
  2880. }
  2881. }
  2882. }
  2883. }
  2884. if (doc.Range.Bookmarks["Content"] != null)
  2885. {
  2886. Bookmark mark = doc.Range.Bookmarks["Content"];
  2887. mark.Text = content;
  2888. }
  2889. while (tableClient.Rows.Count > 1 + clientList.Count)
  2890. {
  2891. tableClient.Rows.RemoveAt(1 + clientList.Count);
  2892. }
  2893. #endregion
  2894. #endregion
  2895. string strFileName = $"/AskData/省外办出访请示{Guid.NewGuid().ToString()}.doc";
  2896. doc.Save(AppSettingsHelper.Get("WordBasePath") + strFileName); //"C:\\Server\\File\\OA2023\\Office\\Word" + strFileName
  2897. var url = AppSettingsHelper.Get("WordBaseUrl") + AppSettingsHelper.Get("WordFtpPath") + strFileName; //"C:\\Server\\File\\OA2023\\Office\\Word" + strFileName
  2898. return Ok(JsonView(true,"操作成功!",new { url = url }));
  2899. }
  2900. /// <summary>
  2901. /// 请示资料信息
  2902. /// 市外办下载
  2903. /// </summary>
  2904. /// <param name="dto"></param>
  2905. /// <returns></returns>
  2906. [HttpPost]
  2907. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2908. public async Task<IActionResult> AskDataCityFAOPFile(AskDataProvinceFileDto dto)
  2909. {
  2910. if (dto.DataIdItem.Length < 1) return Ok(JsonView(false, $"请传入有效的数据Id集合!"));
  2911. if (dto.DiId < 1) return Ok(JsonView(false, $"请传入有效的数据DiId参数!"));
  2912. //大写数字序号
  2913. string[] num = { "一", "二", "三", "四", "五", "六", "七", "八", "九", "十" ,
  2914. "十一","十二","十三","十四","十五","十六","十七","十八","十九","二十",
  2915. "二十一","二十二","二十三","二十四","二十五","二十六","二十七","二十八","二十九","三十",
  2916. "三十一","三十二","三十三","三十四","三十五","三十六","三十七","三十八","三十九","四十"};
  2917. //数据源
  2918. var idItem = dto.DataIdItem.OrderBy(x => x);
  2919. var askDatas = await _sqlSugar.Queryable<Res_AskData>().Where(x => x.IsDel == 0 && idItem.Contains(x.Id)).ToListAsync();
  2920. //书签名
  2921. string Area = "",
  2922. Official = "";
  2923. //表格数据源
  2924. DataTable dt = new DataTable();
  2925. dt.Columns.Add("Country", typeof(string));
  2926. dt.Columns.Add("TalkCase", typeof(string));
  2927. int id = 0;
  2928. int TalkcaseOrder = 0;
  2929. int RowOrder = 0;
  2930. //填充数据
  2931. for (int i = 0; i < askDatas.Count; i++)
  2932. {
  2933. var ad = askDatas[i];
  2934. Area = Area + ad.Country + ad.Area + "、";
  2935. Official = Official + ad.UnitName + "、";
  2936. //填充表格数据源
  2937. DataRow dr = dt.NewRow();
  2938. if (i > 0)
  2939. {
  2940. var adtemp = askDatas[i - 1];
  2941. if (ad.Country == adtemp.Country)
  2942. {
  2943. TalkcaseOrder++;
  2944. dt.Rows[RowOrder]["TalkCase"] = dt.Rows[RowOrder]["TalkCase"] + "\r\n" + (1 + TalkcaseOrder).ToString() + "、" + ad.TalkCase;
  2945. }
  2946. else
  2947. {
  2948. RowOrder++;
  2949. dr = dt.NewRow();
  2950. dr["Country"] = "(" + num[RowOrder] + ")" + ad.Country;
  2951. dr["TalkCase"] = "1、" + ad.TalkCase;
  2952. dt.Rows.Add(dr);
  2953. TalkcaseOrder = 0;
  2954. }
  2955. }
  2956. else
  2957. {
  2958. dr["Country"] = "(" + num[i] + ")" + ad.Country;
  2959. dr["TalkCase"] = "1、" + ad.TalkCase;
  2960. dt.Rows.Add(dr);
  2961. }
  2962. id = ad.Id;
  2963. }
  2964. //模板路径
  2965. var tempPath = AppSettingsHelper.Get("WordBasePath") + "Template/市外办出访请示.doc";
  2966. //载入模板
  2967. Aspose.Words.Document doc = new Aspose.Words.Document(tempPath);
  2968. #region 填充word内容
  2969. #region 填充请示内容
  2970. //利用DocumentBuilder处理表格或是书签
  2971. Aspose.Words.DocumentBuilder builder = new DocumentBuilder(doc);
  2972. string bookmark = "";
  2973. try
  2974. {
  2975. for (int i = 0; i < dt.Rows.Count; i++)
  2976. {
  2977. bookmark = bookmark
  2978. + dt.Rows[i]["Country"].ToString() + "\r\n"
  2979. + dt.Rows[i]["TalkCase"].ToString() + "\r\n";
  2980. }
  2981. }
  2982. catch
  2983. {
  2984. }
  2985. #endregion
  2986. #region 填充word模板书签内容
  2987. //团组信息
  2988. var di = await _sqlSugar.Queryable<Grp_DelegationInfo>().Where(x => x.IsDel == 0 && x.Id == dto.DiId).FirstAsync();
  2989. //接团客户名单实例
  2990. string client_sql = string.Format(@"
  2991. SELECT
  2992. tcl.Id,
  2993. tcl.DiId,
  2994. tcl.IsAccompany,
  2995. temp.*,
  2996. u.CnName AS Operator,
  2997. tcl.CreateTime AS OperatingTime
  2998. FROM
  2999. Grp_TourClientList tcl
  3000. LEFT JOIN (
  3001. SELECT
  3002. dc.Id AS DcId,
  3003. dc.LastName,
  3004. dc.FirstName,
  3005. ccom.CompanyFullName,
  3006. dc.Job,
  3007. cc.CertNo AS IDCardNo,
  3008. dc.Sex,
  3009. dc.BirthDay
  3010. FROM
  3011. Crm_DeleClient dc
  3012. LEFT JOIN Crm_CustomerCompany ccom ON dc.CrmCompanyId = ccom.Id
  3013. AND ccom.IsDel = 0
  3014. LEFT JOIN Crm_CustomerCert cc ON dc.Id = cc.DcId
  3015. AND cc.SdId = 773
  3016. AND cc.IsDel = 0
  3017. WHERE
  3018. dc.IsDel = 0
  3019. ) temp ON temp.DcId = tcl.ClientId
  3020. LEFT JOIN Sys_Users u ON tcl.CreateUserId = u.Id
  3021. WHERE
  3022. tcl.IsDel = 0
  3023. AND tcl.DiId = {0}", dto.DiId);
  3024. var clientList = await _sqlSugar.SqlQueryable<TourClientListDetailsView>(client_sql).ToListAsync();
  3025. //机票代码实例
  3026. DataTable airTable = GeneralMethod.GetTableByBlackCode(dto.DiId);
  3027. //三字码
  3028. var threeCodes = await _sqlSugar.Queryable<Res_ThreeCode>().Where(x => x.IsDel == 0).ToListAsync();
  3029. //团名
  3030. if (doc.Range.Bookmarks["TeamName"] != null)
  3031. {
  3032. Bookmark mark = doc.Range.Bookmarks["TeamName"];
  3033. mark.Text = di.TeamName;
  3034. }
  3035. //团长名
  3036. if (doc.Range.Bookmarks["ClientName2"] != null)
  3037. {
  3038. Bookmark mark = doc.Range.Bookmarks["ClientName2"];
  3039. if (clientList == null || clientList.Count == 0)
  3040. {
  3041. mark.Text = "【本团尚未录入客户名单,请联系主管!】";
  3042. }
  3043. else
  3044. {
  3045. mark.Text = clientList[0].CompanyFullName + clientList[0].Job + clientList[0].LastName + clientList[0].FirstName;
  3046. }
  3047. }
  3048. if (doc.Range.Bookmarks["ClientName"] != null)
  3049. {
  3050. Bookmark mark = doc.Range.Bookmarks["ClientName"];
  3051. if (clientList == null || clientList.Count == 0)
  3052. {
  3053. mark.Text = "【本团尚未录入客户名单,请联系主管!】";
  3054. }
  3055. else
  3056. {
  3057. mark.Text = clientList[0].CompanyFullName + clientList[0].Job + clientList[0].LastName + clientList[0].FirstName;
  3058. }
  3059. }
  3060. //跟团人数
  3061. if (doc.Range.Bookmarks["ClientNumber2"] != null)
  3062. {
  3063. Bookmark mark = doc.Range.Bookmarks["ClientNumber2"];
  3064. mark.Text = di.VisitPNumber.ToString();
  3065. }
  3066. if (doc.Range.Bookmarks["ClientNumber"] != null)
  3067. {
  3068. Bookmark mark = doc.Range.Bookmarks["ClientNumber"];
  3069. mark.Text = di.VisitPNumber.ToString();
  3070. }
  3071. //地区
  3072. if (doc.Range.Bookmarks["Area"] != null)
  3073. {
  3074. Bookmark mark = doc.Range.Bookmarks["Area"];
  3075. mark.Text = Area.TrimEnd('、');
  3076. }
  3077. if (doc.Range.Bookmarks["Area2"] != null)
  3078. {
  3079. Bookmark mark = doc.Range.Bookmarks["Area2"];
  3080. mark.Text = Area.TrimEnd('、');
  3081. }
  3082. //出访目的
  3083. if (doc.Range.Bookmarks["Destination2"] != null)
  3084. {
  3085. Bookmark mark = doc.Range.Bookmarks["Destination2"];
  3086. mark.Text = di.VisitPurpose;
  3087. }
  3088. if (doc.Range.Bookmarks["Destination"] != null)
  3089. {
  3090. Bookmark mark = doc.Range.Bookmarks["Destination"];
  3091. mark.Text = di.VisitPurpose;
  3092. }
  3093. //邀请方
  3094. if (doc.Range.Bookmarks["Official"] != null)
  3095. {
  3096. Bookmark mark = doc.Range.Bookmarks["Official"];
  3097. mark.Text = Official.TrimEnd('、');
  3098. }
  3099. //出访日期
  3100. if (doc.Range.Bookmarks["VisitDate"] != null)
  3101. {
  3102. Bookmark mark = doc.Range.Bookmarks["VisitDate"];
  3103. mark.Text = di.VisitStartDate.Year + "年"
  3104. + di.VisitStartDate.Month + "月"
  3105. + di.VisitStartDate.Day + "日"
  3106. + "至"
  3107. + di.VisitEndDate.Month + "月"
  3108. + di.VisitEndDate.Day + "日";
  3109. }
  3110. //请示范例
  3111. if (doc.Range.Bookmarks["Temp"] != null)
  3112. {
  3113. Bookmark mark = doc.Range.Bookmarks["Temp"];
  3114. mark.Text = bookmark;
  3115. }
  3116. //出访起止日期
  3117. if (doc.Range.Bookmarks["Duration"] != null)
  3118. {
  3119. Bookmark mark = doc.Range.Bookmarks["Duration"];
  3120. mark.Text = di.VisitStartDate.Year + "年"
  3121. + di.VisitStartDate.Month + "月"
  3122. + di.VisitStartDate.Day + "日"
  3123. + "至"
  3124. + di.VisitEndDate.Month + "月"
  3125. + di.VisitEndDate.Day + "日";
  3126. }
  3127. //出访天数
  3128. if (doc.Range.Bookmarks["Durationdays"] != null)
  3129. {
  3130. Bookmark mark = doc.Range.Bookmarks["Durationdays"];
  3131. mark.Text = di.VisitDays.ToString();
  3132. }
  3133. if (doc.Range.Bookmarks["Durationdays2"] != null)
  3134. {
  3135. Bookmark mark = doc.Range.Bookmarks["Durationdays2"];
  3136. mark.Text = di.VisitDays.ToString();
  3137. }
  3138. #region 根据黑屏代码获取国家呆的天数;获取路线
  3139. string result_CountryAndDay = "", result_Air = "";
  3140. if (airTable.Rows[airTable.Rows.Count - 1]["Day"].ToString() == "")
  3141. {
  3142. result_CountryAndDay = airTable.Rows[airTable.Rows.Count - 1]["Fliagtcode"].ToString();
  3143. result_Air = result_CountryAndDay;
  3144. }
  3145. else
  3146. {
  3147. string place_start, place_end;
  3148. DateTime time_start, time_end;
  3149. Res_ThreeCode three = null;
  3150. for (int i = 0; i < airTable.Rows.Count; i++)
  3151. {
  3152. //三字码实例
  3153. three = threeCodes.Find(x => x.Three == airTable.Rows[i]["Three"].ToString().Substring(0, 3));
  3154. if (three == null)
  3155. {
  3156. place_start = "【未收录三字码" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + ",请联系机票同事】";
  3157. }
  3158. else
  3159. {
  3160. if (string.IsNullOrEmpty(three.Country))
  3161. {
  3162. place_start = "【本三字码" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + "未录入国家信息,请联系机票同事】";
  3163. }
  3164. else
  3165. {
  3166. place_start = three.City;
  3167. }
  3168. }
  3169. three = threeCodes.Find(x => x.Three == airTable.Rows[i]["Three"].ToString().Substring(3, 3));
  3170. if (three == null)
  3171. {
  3172. place_end = "【未收录" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + ",请联系机票同事】";
  3173. }
  3174. else
  3175. {
  3176. if (string.IsNullOrEmpty(three.Country))
  3177. {
  3178. place_end = "【本三字码" + airTable.Rows[i]["Three"].ToString().Substring(0, 3) + "未录入国家信息,请联系机票同事】";
  3179. }
  3180. else
  3181. {
  3182. place_end = three.City;
  3183. }
  3184. }
  3185. result_Air += place_start + "一" + place_end + "一";
  3186. //获取国家和呆的天数
  3187. if (i > 0 && i < airTable.Rows.Count - 1)
  3188. {
  3189. time_start = Convert.ToDateTime(airTable.Rows[i - 1]["Day"]);
  3190. time_end = Convert.ToDateTime(airTable.Rows[i]["Day"]);
  3191. TimeSpan daycount = time_end.Subtract(time_start);
  3192. result_CountryAndDay += place_start + daycount.Days + "天" + ",";
  3193. }
  3194. }
  3195. }
  3196. #endregion
  3197. //每个国家呆的天数
  3198. if (doc.Range.Bookmarks["CountryAndDay"] != null)
  3199. {
  3200. Bookmark mark = doc.Range.Bookmarks["CountryAndDay"];
  3201. mark.Text = result_CountryAndDay.TrimEnd(',');
  3202. }
  3203. #region 出访路线城市字符串去重
  3204. result_Air = result_Air.TrimEnd('一');
  3205. string[] airTemp = result_Air.Split('一');
  3206. airTemp = airTemp.Distinct().ToArray();
  3207. result_Air = "";
  3208. foreach (string str in airTemp)
  3209. {
  3210. result_Air += str + "一";
  3211. }
  3212. result_Air = result_Air + airTemp[0];
  3213. #endregion
  3214. //出访路线
  3215. if (doc.Range.Bookmarks["Air"] != null)
  3216. {
  3217. Bookmark mark = doc.Range.Bookmarks["Air"];
  3218. mark.Text = result_Air;
  3219. }
  3220. #endregion
  3221. #region 客户名单
  3222. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  3223. Aspose.Words.Tables.Table tableClient = allTables[0] as Aspose.Words.Tables.Table;
  3224. if (clientList == null || clientList.Count == 0)
  3225. {
  3226. builder.MoveToCell(0, 1, 0, 0);
  3227. builder.Write("【本团尚未录入客户名单,请联系主管!】");
  3228. }
  3229. else
  3230. {
  3231. for (int i = 0; i < clientList.Count(); i++)
  3232. {
  3233. builder.MoveToCell(0, i + 1, 0, 0);
  3234. builder.Write((i + 1).ToString());
  3235. builder.MoveToCell(0, i + 1, 1, 0);
  3236. builder.Write(clientList[i].LastName.ToString() + clientList[i].FirstName.ToString());
  3237. builder.MoveToCell(0, i + 1, 2, 0);
  3238. builder.Write(clientList[i].Sex.ToString());
  3239. builder.MoveToCell(0, i + 1, 3, 0);
  3240. builder.Write(clientList[i].BirthDay);
  3241. builder.MoveToCell(0, i + 1, 4, 0);
  3242. builder.Write(clientList[i].CompanyFullName + clientList[i].Job.ToString());
  3243. }
  3244. }
  3245. while (tableClient.Rows.Count > clientList.Count + 1)
  3246. {
  3247. tableClient.Rows.RemoveAt(clientList.Count + 1);
  3248. }
  3249. #endregion
  3250. #region 商邀行程
  3251. string content = "", temp1 = "", temp2 = "";
  3252. //获取数据,放到datatable
  3253. var listapt = await _sqlSugar.Queryable<Grp_ApprovalTravel>()
  3254. .LeftJoin<Grp_ApprovalTravelDetails>((at, atd) => at.Id == atd.ParentId)
  3255. .Where((at, atd) => at.IsDel == 0 && at.Diid == dto.DiId)
  3256. .Select((at, atd) => new
  3257. {
  3258. at.Id,
  3259. at.Date,
  3260. atd.Time,
  3261. atd.Details
  3262. })
  3263. .ToListAsync();
  3264. if (listapt == null || listapt.Count == 0)
  3265. {
  3266. content = "尚未生成商邀行程";
  3267. }
  3268. else
  3269. {
  3270. for (int i = 0; i < listapt.Count; i++)
  3271. {
  3272. content = content + " " + listapt[i].Date + "\r\n";
  3273. temp1 = listapt[i].Time;
  3274. temp2 = listapt[i].Details;
  3275. if (!string.IsNullOrEmpty(temp1))
  3276. {
  3277. string[] str = temp1.Replace("\r\n", " ").Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  3278. string[] str2 = temp2.Replace("\r\n", " ").Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  3279. for (int j = 0; j < str.Count(); j++)
  3280. {
  3281. content = content + " " + str[j] + str2[j] + "\r\n";
  3282. }
  3283. }
  3284. }
  3285. }
  3286. if (doc.Range.Bookmarks["Content"] != null)
  3287. {
  3288. Bookmark mark = doc.Range.Bookmarks["Content"];
  3289. mark.Text = content;
  3290. }
  3291. while (tableClient.Rows.Count > 1 + clientList.Count)
  3292. {
  3293. tableClient.Rows.RemoveAt(1 + clientList.Count);
  3294. }
  3295. #endregion
  3296. #endregion
  3297. string strFileName = $"/AskData/市外办出访请示{Guid.NewGuid().ToString()}.doc";
  3298. doc.Save(AppSettingsHelper.Get("WordBasePath") + strFileName); //"C:\\Server\\File\\OA2023\\Office\\Word" + strFileName
  3299. var url = AppSettingsHelper.Get("WordBaseUrl") + AppSettingsHelper.Get("WordFtpPath") + strFileName; //"C:\\Server\\File\\OA2023\\Office\\Word" + strFileName
  3300. return Ok(JsonView(true, "操作成功!", new { url = url }));
  3301. }
  3302. #endregion
  3303. #region 机票黑屏代码
  3304. /// <summary>
  3305. /// 根据团组Id查询黑屏代码列表
  3306. /// </summary>
  3307. /// <param name="dto"></param>
  3308. /// <returns></returns>
  3309. [HttpPost]
  3310. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3311. public async Task<IActionResult> QueryTicketBlackCodeByDiId(QueryTicketBlackCodeByDiIdDto dto)
  3312. {
  3313. try
  3314. {
  3315. Result groupData = await _ticketBlackCodeRep.QueryTicketBlackCodeByDiId(dto);
  3316. if (groupData.Code != 0)
  3317. {
  3318. return Ok(JsonView(false, groupData.Msg));
  3319. }
  3320. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3321. }
  3322. catch (Exception ex)
  3323. {
  3324. return Ok(JsonView(false, "程序错误!"));
  3325. throw;
  3326. }
  3327. }
  3328. /// <summary>
  3329. /// 根据黑屏代码数据Id查询信息
  3330. /// </summary>
  3331. /// <param name="dto"></param>
  3332. /// <returns></returns>
  3333. [HttpPost]
  3334. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3335. public async Task<IActionResult> QueryTicketBlackCodeById(QueryTicketBlackCodeByIdDto dto)
  3336. {
  3337. try
  3338. {
  3339. Result groupData = await _ticketBlackCodeRep.QueryTicketBlackCodeById(dto);
  3340. if (groupData.Code != 0)
  3341. {
  3342. return Ok(JsonView(false, groupData.Msg));
  3343. }
  3344. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3345. }
  3346. catch (Exception ex)
  3347. {
  3348. return Ok(JsonView(false, "程序错误!"));
  3349. throw;
  3350. }
  3351. }
  3352. /// <summary>
  3353. /// 黑屏代码操作(Status:1.新增,2.修改)
  3354. /// </summary>
  3355. /// <param name="dto"></param>
  3356. /// <returns></returns>
  3357. [HttpPost]
  3358. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3359. public async Task<IActionResult> OpTicketBlackCode(OpTicketBlackCodeDto dto)
  3360. {
  3361. Result groupData = await _ticketBlackCodeRep.OpTicketBlackCode(dto);
  3362. if (groupData.Code != 0)
  3363. {
  3364. return Ok(JsonView(false, groupData.Msg));
  3365. }
  3366. try
  3367. {
  3368. var tongzhi = _ticketBlackCodeRep.DescBlackToVisa(dto.DiId);
  3369. if (tongzhi.Code == 0)
  3370. {
  3371. var info = tongzhi.Data.GetType().GetProperty("info").GetValue(tongzhi.Data) as List<string>;
  3372. var data = tongzhi.Data.GetType().GetProperty("data").GetValue(tongzhi.Data) as List<CountryDataTime>;
  3373. if (data != null)
  3374. await AppNoticeLibrary.SendUserMsg_blackAirInfo_ToVisaUser(dto.DiId, data);
  3375. }
  3376. //行程代码变更通知
  3377. await AppNoticeLibrary.SendUserMsg_GroupShare_ToDP(dto.DiId, dto.CreateUserId);
  3378. }
  3379. catch (Exception ex)
  3380. {
  3381. throw;
  3382. }
  3383. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3384. }
  3385. /// <summary>
  3386. /// 删除黑屏代码
  3387. /// </summary>
  3388. /// <param name="dto"></param>
  3389. /// <returns></returns>
  3390. [HttpPost]
  3391. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3392. public async Task<IActionResult> DelTicketBlackCode(DelBaseDto dto)
  3393. {
  3394. try
  3395. {
  3396. var res = await _ticketBlackCodeRep.SoftDeleteByIdAsync<Air_TicketBlackCode>(dto.Id.ToString(), dto.DeleteUserId);
  3397. if (!res)
  3398. {
  3399. return Ok(JsonView(false, "删除失败"));
  3400. }
  3401. return Ok(JsonView(true, "删除成功!"));
  3402. }
  3403. catch (Exception ex)
  3404. {
  3405. return Ok(JsonView(false, "程序错误!"));
  3406. throw;
  3407. }
  3408. }
  3409. #endregion
  3410. #region 翻译人员
  3411. /// <summary>
  3412. /// 翻译人员库
  3413. /// Init
  3414. /// </summary>
  3415. /// <param name="id"></param>
  3416. /// <returns></returns>
  3417. [HttpGet()]
  3418. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3419. public async Task<IActionResult> TranslatorLibraryInit()
  3420. {
  3421. var currencyData = await _sqlSugar.Queryable<Sys_SetData>()
  3422. .Where(x => x.IsDel == 0 && x.STid == 66)
  3423. .Select(x => new {
  3424. x.Id,
  3425. x.Name,
  3426. })
  3427. .ToListAsync();
  3428. var officialDutyData = await _sqlSugar.Queryable<Res_OfficialActivities>()
  3429. .LeftJoin<Grp_DelegationInfo>((oa, di) => oa.DiId == di.Id)
  3430. .Where((oa, di) => oa.IsDel == 0)
  3431. .Select((oa, di) => new
  3432. {
  3433. oa.Id,
  3434. oa.Client,
  3435. oa.DiId,
  3436. di.TeamName
  3437. })
  3438. .ToListAsync();
  3439. var officialDutyData1 = officialDutyData.GroupBy(x => x.DiId)
  3440. .Select(g => new {
  3441. id = g.Key,
  3442. label = g.FirstOrDefault()?.TeamName ?? "-",
  3443. children = g.Select(g1 => new { id = g1.Id, label = g1.Client }).ToList()
  3444. })
  3445. .ToList();
  3446. var view = new {
  3447. currencyData = currencyData,
  3448. officialDutyData = officialDutyData1
  3449. };
  3450. return Ok(JsonView(view));
  3451. }
  3452. /// <summary>
  3453. /// 翻译人员库
  3454. /// 详情
  3455. /// </summary>
  3456. /// <param name="id"></param>
  3457. /// <returns></returns>
  3458. [HttpGet("id")]
  3459. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3460. public async Task<IActionResult> TranslatorLibraryInfo(int id)
  3461. {
  3462. if (id <1 ) return Ok(JsonView(false,"请传入有效的Id!"));
  3463. var info = await _translatorRep.Query(x => x.Id == id).FirstAsync();
  3464. var view = _mapper.Map<TranslatorLibraryInfoView>(info);
  3465. //var data1 = await _sqlSugar.Queryable<Grp_OfficialDutyLinkTranslator>().Where(x => x.TranslatorId == id).Select(x => x.Id).ToArrayAsync();
  3466. view.OfficialDutyIdItem = await _sqlSugar
  3467. .Queryable<Grp_OfficialDutyLinkTranslator>()
  3468. .Where(x => x.IsDel == 0 && x.TranslatorId == id)
  3469. .Select(x => x.OfficialDutyId)
  3470. .ToArrayAsync();
  3471. return Ok(JsonView(view));
  3472. }
  3473. /// <summary>
  3474. /// 翻译人员库
  3475. /// Item
  3476. /// </summary>
  3477. /// <param name="dto"></param>
  3478. /// <returns></returns>
  3479. [HttpPost]
  3480. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3481. public async Task<IActionResult> TranslatorLibraryItem(TranslatorLibraryItemDto dto)
  3482. {
  3483. if (dto.PortType < 1 || dto.PortType > 3) return Ok(JsonView(false, MsgTips.Port));
  3484. RefAsync<int> total = 0;
  3485. var view = await _sqlSugar.Queryable<Res_TranslatorLibrary>()
  3486. .Where(x => x.IsDel == 0)
  3487. .WhereIF(!string.IsNullOrEmpty(dto.Name), x => x.Name.Contains(dto.Name))
  3488. .Select(x => new
  3489. {
  3490. x.Id,
  3491. x.Area,
  3492. x.Name,
  3493. Sex = x.Sex == 0 ? "未设置" : x.Sex == 1 ? "男" : "女",
  3494. x.Tel,
  3495. x.Email,
  3496. x.WechatNo,
  3497. x.Language,
  3498. x.Price,
  3499. //x.Currency,
  3500. Currency = SqlFunc.Subqueryable<Sys_SetData>().Where(x1 => x1.Id == x.Currency).Select(x1 => x1.Name) ?? "-",
  3501. CreateUserName = SqlFunc.Subqueryable<Sys_Users>().Where(x1 => x1.Id == x.CreateUserId).Select(x1 => x1.CnName) ?? "-",
  3502. x.CreateTime,
  3503. x.Remark
  3504. })
  3505. .OrderByDescending(x => x.CreateTime)
  3506. .ToPageListAsync(dto.PageIndex, dto.PageSize, total);
  3507. return Ok(JsonView(view, total));
  3508. }
  3509. /// <summary>
  3510. /// 翻译人员库
  3511. /// OP
  3512. /// </summary>
  3513. /// <param name="dto"></param>
  3514. /// <returns></returns>
  3515. [HttpPost]
  3516. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3517. public async Task<IActionResult> TranslatorLibraryOp([FromForm]TranslatorLibraryOpDto dto)
  3518. {
  3519. if (dto.PortType < 1 || dto.PortType > 3) return Ok(JsonView(false, MsgTips.Port));
  3520. if (dto.Status < 1 || dto.Status > 2) return Ok(JsonView(false, MsgTips.Status));
  3521. var currUserInfo = JwtHelper.SerializeJwt(HttpContext.Request.Headers.Authorization);
  3522. if (currUserInfo == null) return Ok(JsonView(false, "请传入token!"));
  3523. var fileNames = new List<string>();
  3524. //D:\FTP\File\OA2023\Office\GrpFile\TranslatorLibrary
  3525. var fileBasePath = $"{AppSettingsHelper.Get("GrpFileBasePath")}TranslatorLibrary";
  3526. #region 保存文件
  3527. if (dto.Files != null)
  3528. {
  3529. if (!System.IO.Directory.Exists(fileBasePath))
  3530. {
  3531. System.IO.Directory.CreateDirectory(fileBasePath);
  3532. }
  3533. foreach (var item in dto.Files)
  3534. {
  3535. if (item.Length < 1) continue;
  3536. var file = item;
  3537. // 将文件保存到指定位置
  3538. var filePath = Path.Combine(fileBasePath, file.FileName);
  3539. using (var stream = new FileStream(filePath, FileMode.Create))
  3540. {
  3541. await file.CopyToAsync(stream);
  3542. }
  3543. //验证文件是否上传成功
  3544. if (!System.IO.File.Exists(filePath))
  3545. {
  3546. foreach (var filePathStr in fileNames)
  3547. {
  3548. System.IO.File.Delete(Path.Combine(fileBasePath, filePathStr));
  3549. }
  3550. return Ok(JsonView(false, "文件上传失败!"));
  3551. }
  3552. fileNames.Add(file.FileName);
  3553. }
  3554. }
  3555. #endregion
  3556. #region 参数处理
  3557. var translatorInfo = _mapper.Map<Res_TranslatorLibrary>(dto);
  3558. #endregion
  3559. _sqlSugar.BeginTran();
  3560. if (dto.Status == 1)
  3561. {
  3562. //验证重复
  3563. var info = await _translatorRep.Query(x => x.Area.Equals(dto.Area) && x.Name.Equals(dto.Name)).FirstAsync();
  3564. if (info != null) return Ok(JsonView(false, "该条数据已存在!"));
  3565. translatorInfo.CreateUserId = currUserInfo.UserId;
  3566. if (fileNames.Count > 0)
  3567. {
  3568. translatorInfo.Files = JsonConvert.SerializeObject(fileNames);
  3569. }
  3570. var id = await _translatorRep.AddAsync(translatorInfo);
  3571. if (id > 0) {
  3572. #region 新增(公务信息关联翻译人员) 关联信息
  3573. if (dto.officialDutyIdItem != null && dto.officialDutyIdItem.Length > 0)
  3574. {
  3575. var officialDutyLinkTranslators = new List<Grp_OfficialDutyLinkTranslator>();
  3576. foreach (var officialDutyId in dto.officialDutyIdItem)
  3577. {
  3578. officialDutyLinkTranslators.Add(new Grp_OfficialDutyLinkTranslator()
  3579. {
  3580. TranslatorId = id,
  3581. OfficialDutyId = officialDutyId,
  3582. CreateUserId = currUserInfo.UserId,
  3583. Remark = $"翻译人员库-->添加"
  3584. });
  3585. }
  3586. if (officialDutyLinkTranslators.Count > 0)
  3587. {
  3588. await _sqlSugar.Insertable(officialDutyLinkTranslators).ExecuteCommandAsync();
  3589. }
  3590. }
  3591. #endregion
  3592. _sqlSugar.CommitTran();
  3593. return Ok(JsonView(true));
  3594. }
  3595. }
  3596. else if (dto.Status == 2)
  3597. {
  3598. var info = await _translatorRep.Query(x => x.Id == dto.Id).FirstAsync();
  3599. if (info != null)
  3600. {
  3601. if (!string.IsNullOrEmpty(info.Files))
  3602. {
  3603. try
  3604. {
  3605. var selectFiles = JsonConvert.DeserializeObject<List<string>>(info.Files);
  3606. fileNames.AddRange(selectFiles);
  3607. }
  3608. catch (Exception)
  3609. {
  3610. }
  3611. }
  3612. }
  3613. if (fileNames.Count > 0)
  3614. {
  3615. translatorInfo.Files = JsonConvert.SerializeObject(fileNames);
  3616. }
  3617. var upd = await _translatorRep
  3618. .UpdateAsync(x => x.Id == dto.Id, x => new Res_TranslatorLibrary()
  3619. {
  3620. Area = translatorInfo.Area,
  3621. Name = translatorInfo.Name,
  3622. Sex = translatorInfo.Sex,
  3623. Photo = translatorInfo.Photo,
  3624. Tel = translatorInfo.Tel,
  3625. Email = translatorInfo.Email,
  3626. WechatNo = translatorInfo.WechatNo,
  3627. OtherSocialAccounts = translatorInfo.OtherSocialAccounts,
  3628. Language = translatorInfo.Language,
  3629. Price = translatorInfo.Price,
  3630. Currency = translatorInfo.Currency,
  3631. Remark = translatorInfo.Remark,
  3632. Files = translatorInfo.Files,
  3633. });
  3634. if (upd) {
  3635. #region 更新(公务信息关联翻译人员) 关联信息
  3636. var officialDutyLinkTranslators_select = await _sqlSugar.Queryable<Grp_OfficialDutyLinkTranslator>()
  3637. .Where(x => x.IsDel == 0 && x.TranslatorId == dto.Id)
  3638. .ToListAsync();
  3639. //删除
  3640. var officialDutyLinkTranslatorIds = officialDutyLinkTranslators_select.Select(x => x.Id).ToList();
  3641. if (officialDutyLinkTranslatorIds.Count > 0)
  3642. {
  3643. await _sqlSugar.Updateable<Grp_OfficialDutyLinkTranslator>()
  3644. .SetColumnsIF(officialDutyLinkTranslatorIds.Count > 0, x => new Grp_OfficialDutyLinkTranslator()
  3645. {
  3646. DeleteUserId = currUserInfo.UserId,
  3647. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
  3648. IsDel = 1,
  3649. Remark = $"翻译人员库-->删除"
  3650. })
  3651. .Where(x => officialDutyLinkTranslatorIds.Contains(x.Id))
  3652. .ExecuteCommandAsync();
  3653. }
  3654. if (dto.officialDutyIdItem != null && dto.officialDutyIdItem.Length > 0)
  3655. {
  3656. //添加
  3657. var officialDutyLinkTranslators = new List<Grp_OfficialDutyLinkTranslator>();
  3658. foreach (var officialDutyId in dto.officialDutyIdItem)
  3659. {
  3660. officialDutyLinkTranslators.Add(new Grp_OfficialDutyLinkTranslator()
  3661. {
  3662. TranslatorId = dto.Id,
  3663. OfficialDutyId = officialDutyId,
  3664. CreateUserId = currUserInfo.UserId,
  3665. Remark = $"翻译人员库-->更新"
  3666. });
  3667. }
  3668. if (officialDutyLinkTranslators.Count > 0)
  3669. {
  3670. await _sqlSugar.Insertable(officialDutyLinkTranslators).ExecuteCommandAsync();
  3671. }
  3672. }
  3673. #endregion
  3674. _sqlSugar.CommitTran();
  3675. return Ok(JsonView(true));
  3676. }
  3677. }
  3678. _sqlSugar.RollbackTran();
  3679. return Ok(JsonView(false));
  3680. }
  3681. /// <summary>
  3682. /// 翻译人员库
  3683. /// Del
  3684. /// </summary>
  3685. /// <param name="id"></param>
  3686. /// <returns></returns>
  3687. [HttpDelete("id")]
  3688. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3689. public async Task<IActionResult> TranslatorLibraryDel(int id)
  3690. {
  3691. if (id < 1) return Ok(JsonView(false, MsgTips.Id));
  3692. var currUserInfo = JwtHelper.SerializeJwt(HttpContext.Request.Headers.Authorization);
  3693. if (currUserInfo == null) return Ok(JsonView(false, "请传入token!"));
  3694. _sqlSugar.BeginTran();
  3695. var upd = await _translatorRep.SoftDeleteByIdAsync<Res_TranslatorLibrary>(id.ToString(), currUserInfo.UserId);
  3696. if (!upd) {
  3697. _sqlSugar.RollbackTran();
  3698. return Ok(JsonView(false));
  3699. }
  3700. #region 删除公务出访
  3701. await _sqlSugar.Updateable<Grp_OfficialDutyLinkTranslator>()
  3702. .SetColumns(x => new Grp_OfficialDutyLinkTranslator() {
  3703. DeleteUserId = currUserInfo.UserId,
  3704. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
  3705. IsDel = 1,
  3706. Remark = $"翻译人员库-->删除"
  3707. })
  3708. .Where(x => x.TranslatorId == id)
  3709. .ExecuteCommandAsync();
  3710. #endregion
  3711. _sqlSugar.CommitTran();
  3712. return Ok(JsonView(true));
  3713. }
  3714. #endregion
  3715. #region 策划部供应商资料
  3716. /// <summary>
  3717. /// 策划部供应商资料
  3718. /// Init
  3719. /// </summary>
  3720. /// <returns></returns>
  3721. [HttpGet]
  3722. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3723. public async Task<IActionResult> MediaSupplierInit()
  3724. {
  3725. return Ok(await _mediaSupplierRep.Init());
  3726. }
  3727. /// <summary>
  3728. /// 策划部供应商资料
  3729. /// Info
  3730. /// </summary>
  3731. /// <param name="dto"></param>
  3732. /// <returns></returns>
  3733. [HttpPost]
  3734. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3735. public async Task<IActionResult> MediaSupplierInfo(MediaSupplierInfoDto dto)
  3736. {
  3737. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3738. if (dto.Id < 1) return Ok(JsonView(false, MsgTips.Port));
  3739. return Ok(await _mediaSupplierRep.Info(dto));
  3740. }
  3741. /// <summary>
  3742. /// 策划部供应商资料
  3743. /// 分页查询
  3744. /// </summary>
  3745. /// <param name="dto"></param>
  3746. /// <returns></returns>
  3747. [HttpPost]
  3748. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3749. public async Task<IActionResult> MediaSupplierPageItem(MediaSupplierPageItemDto dto)
  3750. {
  3751. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3752. return Ok(await _mediaSupplierRep.PageItem(dto));
  3753. }
  3754. /// <summary>
  3755. /// 策划部供应商资料
  3756. /// 操作(添加 Or 编辑)
  3757. /// </summary>
  3758. /// <param name="dto"></param>
  3759. /// <returns></returns>
  3760. [HttpPost]
  3761. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3762. public async Task<IActionResult> MediaSupplierOp(MediaSupplierAddOrEditDto dto)
  3763. {
  3764. var result = new JsonView() { Code = 400, Msg = "操作失败" };
  3765. var userId = dto.CurrUserId;
  3766. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3767. if (userId < 1) return Ok(JsonView(false, MsgTips.UserId));
  3768. return Ok(await _mediaSupplierRep.AddOrEdit(dto));
  3769. }
  3770. /// <summary>
  3771. /// 策划部供应商资料
  3772. /// 删除
  3773. /// </summary>
  3774. /// <param name="dto"></param>
  3775. /// <returns></returns>
  3776. [HttpPost]
  3777. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3778. public async Task<IActionResult> MediaSupplierSoftDel(MediaSupplierSoftDelDto dto)
  3779. {
  3780. var result = new JsonView() { Code = 400, Msg = "操作失败" };
  3781. int userId = dto.CurrUserId, id = dto.Id;
  3782. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3783. if (userId < 1) return Ok(JsonView(false, MsgTips.UserId));
  3784. if (id < 1) return Ok(JsonView(false, MsgTips.Id));
  3785. return Ok(await _mediaSupplierRep.SoftDel(dto));
  3786. }
  3787. #endregion
  3788. #region 保险国家基础费用
  3789. /// <summary>
  3790. /// 保险国家基础费用
  3791. /// Info
  3792. /// </summary>
  3793. /// <param name="dto"></param>
  3794. /// <returns></returns>
  3795. [HttpPost]
  3796. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3797. public async Task<IActionResult> InsuranceCostInfo(InsuranceCostInfoDto dto)
  3798. {
  3799. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3800. if (dto.Id < 1) return Ok(JsonView(false, MsgTips.Port));
  3801. var id = dto.Id;
  3802. var info = await _insuranceCostRep.Query(x => x.Id == id)
  3803. .Select(x => new {
  3804. x.Id,
  3805. x.IsSchengen,
  3806. x.CountryName,
  3807. x.Cost,
  3808. x.Remark,
  3809. CreateUserName = SqlFunc.Subqueryable<Sys_Users>().Where(s => s.Id == x.CreateUserId).Select(s => s.CnName).FirstOrDefault(),
  3810. x.CreateTime
  3811. })
  3812. .FirstAsync();
  3813. return Ok(JsonView(info));
  3814. }
  3815. /// <summary>
  3816. /// 保险国家基础费用
  3817. /// 分页查询
  3818. /// </summary>
  3819. /// <param name="dto"></param>
  3820. /// <returns></returns>
  3821. [HttpPost]
  3822. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3823. public async Task<IActionResult> InsuranceCostPageItem(InsuranceCostPageItemDto dto)
  3824. {
  3825. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3826. RefAsync<int> total = 0;
  3827. var data = await _sqlSugar.Queryable<Res_BasicInsuranceCost>()
  3828. .LeftJoin<Sys_Users>((bic,u) => bic.CreateUserId == u.Id)
  3829. .Where((bic, u) => bic.IsDel == 0)
  3830. .WhereIF(!string.IsNullOrEmpty(dto.Search), (bic, u) => bic.CountryName.Contains(dto.Search))
  3831. .OrderBy((bic, u) => bic.Id)
  3832. .Select((bic, u) => new {
  3833. bic.Id,
  3834. bic.IsSchengen,
  3835. bic.CountryName,
  3836. bic.Cost,
  3837. bic.Remark,
  3838. CreateUserName = u.CnName,
  3839. bic.CreateTime
  3840. })
  3841. .ToPageListAsync(dto.PageIndex,dto.PageSize,total);
  3842. return Ok(JsonView(data,total));
  3843. }
  3844. /// <summary>
  3845. /// 保险国家基础费用
  3846. /// 操作(添加 Or 编辑)
  3847. /// </summary>
  3848. /// <param name="dto"></param>
  3849. /// <returns></returns>
  3850. [HttpPost]
  3851. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3852. public async Task<IActionResult> InsuranceCostOp(InsuranceCostOpDto dto)
  3853. {
  3854. var result = new JsonView() { Code = 400, Msg = "操作失败" };
  3855. var userId = dto.CurrUserId;
  3856. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3857. if (userId < 1) return Ok(JsonView(false, MsgTips.UserId));
  3858. var countryName = dto.CountryName.Trim();
  3859. if (string.IsNullOrEmpty(countryName)) return Ok(JsonView(false,$"国家名称不能为空!"));
  3860. var info = _mapper.Map<Res_BasicInsuranceCost>(dto);
  3861. info.CreateUserId = dto.CurrUserId;
  3862. info.CountryName = countryName;
  3863. if (dto.Id < 1) //添加
  3864. {
  3865. var addInfo = await _insuranceCostRep.Query(x => x.CountryName.Equals(countryName)).FirstAsync();
  3866. if (addInfo != null) return Ok(JsonView(false, $"该国家信息已存在,不可添加!"));
  3867. var add = await _insuranceCostRep.AddAsync(info);
  3868. if (add < 1) return Ok(JsonView(false, "添加失败!"));
  3869. }
  3870. else //修改
  3871. {
  3872. var upd = await _insuranceCostRep.UpdateAsync(x => x.Id == dto.Id, x => new Res_BasicInsuranceCost
  3873. {
  3874. IsSchengen = dto.IsSchengen,
  3875. CountryName = dto.CountryName,
  3876. Cost = dto.Cost,
  3877. Remark = dto.Remark
  3878. });
  3879. if (!upd) return Ok(JsonView(false, "修改失败!"));
  3880. }
  3881. return Ok(JsonView(true));
  3882. }
  3883. /// <summary>
  3884. /// 保险国家基础费用
  3885. /// 删除
  3886. /// </summary>
  3887. /// <param name="dto"></param>
  3888. /// <returns></returns>
  3889. [HttpPost]
  3890. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3891. public async Task<IActionResult> InsuranceCostSoftDel(InsuranceCostSoftDelDto dto)
  3892. {
  3893. int userId = dto.CurrUserId, id = dto.Id;
  3894. if (!_portIds.Contains(dto.PortType)) return Ok(JsonView(false, MsgTips.Port));
  3895. if (userId < 1) return Ok(JsonView(false, MsgTips.UserId));
  3896. if (id < 1) return Ok(JsonView(false, MsgTips.Id));
  3897. var del = await _insuranceCostRep.SoftDeleteAsync(x => x.Id == id, userId);
  3898. if (!del) return Ok(JsonView(false));
  3899. return Ok(JsonView(true));
  3900. }
  3901. #endregion
  3902. }
  3903. }