GroupsController.cs 256 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350435143524353435443554356435743584359436043614362436343644365436643674368436943704371437243734374437543764377437843794380438143824383438443854386438743884389439043914392439343944395439643974398439944004401440244034404440544064407440844094410441144124413441444154416441744184419442044214422442344244425442644274428442944304431443244334434443544364437443844394440444144424443444444454446444744484449445044514452445344544455445644574458445944604461446244634464446544664467446844694470447144724473447444754476447744784479448044814482448344844485448644874488448944904491449244934494449544964497449844994500450145024503450445054506450745084509451045114512451345144515451645174518451945204521452245234524452545264527452845294530453145324533453445354536453745384539454045414542454345444545454645474548454945504551455245534554455545564557455845594560456145624563456445654566456745684569457045714572457345744575457645774578457945804581458245834584458545864587458845894590459145924593459445954596459745984599460046014602460346044605460646074608460946104611461246134614461546164617461846194620462146224623462446254626462746284629463046314632463346344635463646374638463946404641464246434644464546464647464846494650465146524653465446554656465746584659466046614662466346644665466646674668466946704671467246734674467546764677467846794680468146824683468446854686468746884689469046914692469346944695469646974698469947004701470247034704470547064707470847094710471147124713471447154716471747184719472047214722472347244725472647274728472947304731473247334734473547364737473847394740474147424743474447454746474747484749475047514752475347544755475647574758475947604761476247634764476547664767476847694770477147724773477447754776477747784779478047814782478347844785478647874788478947904791479247934794479547964797479847994800480148024803480448054806480748084809481048114812481348144815481648174818481948204821482248234824482548264827482848294830483148324833483448354836483748384839484048414842484348444845484648474848484948504851485248534854485548564857485848594860486148624863486448654866486748684869487048714872487348744875487648774878487948804881488248834884488548864887488848894890489148924893489448954896489748984899490049014902490349044905490649074908490949104911491249134914491549164917491849194920492149224923492449254926492749284929493049314932493349344935493649374938493949404941494249434944494549464947494849494950495149524953495449554956495749584959496049614962496349644965496649674968496949704971497249734974497549764977497849794980498149824983498449854986498749884989499049914992499349944995499649974998499950005001500250035004500550065007500850095010501150125013501450155016501750185019502050215022502350245025502650275028502950305031503250335034503550365037503850395040504150425043504450455046504750485049505050515052505350545055505650575058505950605061506250635064506550665067506850695070507150725073507450755076507750785079508050815082508350845085508650875088508950905091509250935094509550965097509850995100510151025103510451055106510751085109511051115112511351145115511651175118511951205121512251235124512551265127512851295130513151325133513451355136513751385139514051415142514351445145514651475148514951505151515251535154515551565157515851595160516151625163516451655166516751685169517051715172517351745175517651775178517951805181518251835184518551865187518851895190519151925193519451955196519751985199520052015202520352045205520652075208520952105211521252135214521552165217521852195220522152225223522452255226522752285229523052315232523352345235523652375238523952405241524252435244524552465247524852495250525152525253525452555256525752585259526052615262526352645265526652675268526952705271527252735274527552765277527852795280528152825283528452855286528752885289529052915292529352945295529652975298529953005301530253035304530553065307530853095310531153125313531453155316531753185319532053215322532353245325532653275328532953305331533253335334533553365337533853395340534153425343534453455346534753485349535053515352535353545355535653575358535953605361536253635364536553665367536853695370537153725373537453755376537753785379538053815382538353845385538653875388538953905391539253935394539553965397539853995400540154025403540454055406540754085409541054115412541354145415541654175418541954205421542254235424542554265427542854295430543154325433543454355436543754385439544054415442544354445445544654475448544954505451545254535454545554565457545854595460546154625463546454655466546754685469547054715472547354745475547654775478547954805481548254835484548554865487548854895490549154925493549454955496549754985499550055015502550355045505550655075508550955105511551255135514551555165517551855195520552155225523552455255526552755285529553055315532553355345535553655375538553955405541554255435544554555465547554855495550555155525553555455555556555755585559556055615562556355645565556655675568556955705571557255735574557555765577557855795580558155825583558455855586558755885589559055915592559355945595559655975598559956005601560256035604560556065607560856095610561156125613561456155616561756185619562056215622562356245625562656275628562956305631563256335634563556365637563856395640564156425643564456455646564756485649565056515652565356545655565656575658565956605661566256635664566556665667566856695670567156725673567456755676567756785679568056815682568356845685568656875688568956905691569256935694569556965697569856995700570157025703570457055706570757085709571057115712571357145715571657175718571957205721572257235724572557265727572857295730573157325733573457355736573757385739574057415742574357445745574657475748574957505751575257535754575557565757575857595760576157625763576457655766576757685769577057715772577357745775577657775778577957805781578257835784578557865787578857895790579157925793579457955796579757985799580058015802580358045805580658075808580958105811581258135814581558165817581858195820582158225823582458255826582758285829583058315832583358345835583658375838583958405841584258435844584558465847584858495850585158525853585458555856585758585859586058615862586358645865586658675868586958705871587258735874587558765877587858795880588158825883588458855886588758885889589058915892589358945895589658975898589959005901590259035904590559065907590859095910591159125913591459155916591759185919592059215922592359245925592659275928592959305931593259335934593559365937593859395940594159425943594459455946594759485949595059515952595359545955595659575958595959605961596259635964596559665967596859695970597159725973597459755976597759785979598059815982598359845985598659875988598959905991599259935994599559965997599859996000600160026003600460056006600760086009601060116012601360146015601660176018601960206021602260236024602560266027602860296030
  1. using Aspose.Cells;
  2. using Aspose.Cells.Drawing.Texts;
  3. using Aspose.Words;
  4. using Aspose.Words.Tables;
  5. using NPOI.Util;
  6. using OASystem.API.OAMethodLib;
  7. using OASystem.API.OAMethodLib.File;
  8. using OASystem.Domain.Dtos.Groups;
  9. using OASystem.Domain.Entities.Groups;
  10. using OASystem.Domain.ViewModels.Groups;
  11. using OASystem.Infrastructure.Repositories.Groups;
  12. using TencentCloud.Ocr.V20181119.Models;
  13. using OASystem.Infrastructure.Tools;
  14. using System.Web;
  15. using System.Data;
  16. using static OASystem.Infrastructure.Repositories.Groups.AirTicketResRepository;
  17. using static OpenAI.GPT3.ObjectModels.SharedModels.IOpenAiModels;
  18. using Cell = Aspose.Words.Tables.Cell;
  19. using Row = Aspose.Words.Tables.Row;
  20. using System.Runtime.Intrinsics.Arm;
  21. using Microsoft.AspNetCore.Mvc.Filters;
  22. using OASystem.Domain.Entities.Customer;
  23. using NPOI.SS.Formula.Functions;
  24. using OASystem.Domain.Dtos.CRM;
  25. using System.Diagnostics;
  26. using MathNet.Numerics.Statistics.Mcmc;
  27. using AlibabaCloud.OpenApiClient.Models;
  28. using System;
  29. using NPOI.HPSF;
  30. using SqlSugar;
  31. using System.Collections;
  32. using Org.BouncyCastle.Ocsp;
  33. using System.Globalization;
  34. using static QRCoder.PayloadGenerator;
  35. using Bookmark = Aspose.Words.Bookmark;
  36. using Aspose.Words.Fields;
  37. using NPOI.POIFS.FileSystem;
  38. using Microsoft.AspNetCore.Mvc.ViewEngines;
  39. using OASystem.Domain.ViewModels.QiYeWeChat;
  40. using OASystem.Domain.Entities.Financial;
  41. using NPOI.POIFS.Crypt.Dsig;
  42. using System.Diagnostics.Eventing.Reader;
  43. using System.IO;
  44. using StackExchange.Redis;
  45. using Org.BouncyCastle.Utilities;
  46. namespace OASystem.API.Controllers
  47. {
  48. /// <summary>
  49. /// 团组相关
  50. /// </summary>
  51. //[Authorize]
  52. [Route("api/[controller]/[action]")]
  53. public class GroupsController : ControllerBase
  54. {
  55. private readonly GrpScheduleRepository _grpScheduleRep;
  56. private readonly IMapper _mapper;
  57. private readonly DelegationInfoRepository _groupRepository;
  58. private readonly TaskAssignmentRepository _taskAssignmentRep;
  59. private readonly AirTicketResRepository _airTicketResRep;
  60. private readonly DecreasePaymentsRepository _decreasePaymentsRep;
  61. private readonly InvitationOfficialActivitiesRepository _InvitationOfficialActivitiesRep;
  62. private readonly DelegationEnDataRepository _delegationEnDataRep;
  63. private readonly DelegationVisaRepository _delegationVisaRep;
  64. private readonly VisaPriceRepository _visaPriceRep;
  65. private readonly CarTouristGuideGroundRepository _carTouristGuideGroundRep;
  66. private readonly HotelPriceRepository _hotelPriceRep;
  67. private readonly CustomersRepository _customersRep;
  68. private readonly MessageRepository _message;
  69. private readonly SqlSugarClient _sqlSugar;
  70. private readonly TourClientListRepository _tourClientListRep;
  71. private readonly TeamRateRepository _teamRateRep;
  72. #region 成本相关
  73. private readonly CheckBoxsRepository _checkBoxs;
  74. private readonly GroupCostRepository _GroupCostRepository;
  75. private readonly CostTypeHotelNumberRepository _CostTypeHotelNumberRepository;
  76. private readonly GroupCostParameterRepository _GroupCostParameterRepository;
  77. #endregion
  78. private readonly SetDataRepository _setDataRep;
  79. private string url;
  80. private string path;
  81. private readonly EnterExitCostRepository _enterExitCostRep;
  82. public GroupsController(IMapper mapper, SqlSugarClient sqlSugar, GrpScheduleRepository grpScheduleRep, DelegationInfoRepository groupRepository,
  83. TaskAssignmentRepository taskAssignmentRep, AirTicketResRepository airTicketResRep, DecreasePaymentsRepository decreasePaymentsRep,
  84. InvitationOfficialActivitiesRepository InvitationOfficialActivitiesRep, DelegationEnDataRepository delegationEnDataRep, EnterExitCostRepository enterExitCostRep
  85. , DelegationVisaRepository delegationVisaRep, MessageRepository message, VisaPriceRepository visaPriceRep, CarTouristGuideGroundRepository carTouristGuideGroundRep,
  86. CheckBoxsRepository checkBoxs, GroupCostRepository GroupCostRepository, CostTypeHotelNumberRepository CostTypeHotelNumberRepository,
  87. GroupCostParameterRepository GroupCostParameterRepository, HotelPriceRepository hotelPriceRep, CustomersRepository customersRep, SetDataRepository setDataRep,
  88. TourClientListRepository tourClientListRep, TeamRateRepository teamRateRep)
  89. {
  90. _mapper = mapper;
  91. _grpScheduleRep = grpScheduleRep;
  92. _groupRepository = groupRepository;
  93. _taskAssignmentRep = taskAssignmentRep;
  94. _airTicketResRep = airTicketResRep;
  95. _sqlSugar = sqlSugar;
  96. url = AppSettingsHelper.Get("ExcelBaseUrl");
  97. path = AppSettingsHelper.Get("ExcelBasePath");
  98. if (!System.IO.Directory.Exists(path))
  99. {
  100. System.IO.Directory.CreateDirectory(path);//不存在就创建文件夹
  101. }
  102. _decreasePaymentsRep = decreasePaymentsRep;
  103. _InvitationOfficialActivitiesRep = InvitationOfficialActivitiesRep;
  104. _delegationEnDataRep = delegationEnDataRep;
  105. _enterExitCostRep = enterExitCostRep;
  106. _delegationVisaRep = delegationVisaRep;
  107. _message = message;
  108. _visaPriceRep = visaPriceRep;
  109. _carTouristGuideGroundRep = carTouristGuideGroundRep;
  110. _checkBoxs = checkBoxs;
  111. _GroupCostRepository = GroupCostRepository;
  112. _CostTypeHotelNumberRepository = CostTypeHotelNumberRepository;
  113. _GroupCostParameterRepository = GroupCostParameterRepository;
  114. _hotelPriceRep = hotelPriceRep;
  115. _customersRep = customersRep;
  116. _setDataRep = setDataRep;
  117. _tourClientListRep = tourClientListRep;
  118. _teamRateRep = teamRateRep;
  119. }
  120. #region 流程管控
  121. /// <summary>
  122. /// 获取团组流程管控信息
  123. /// </summary>
  124. /// <param name="paras">参数Json字符串</param>
  125. /// <returns></returns>
  126. [HttpPost]
  127. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  128. public async Task<IActionResult> PostSearchGrpSchedule(JsonDtoBase _jsonDto)
  129. {
  130. if (string.IsNullOrEmpty(_jsonDto.Paras))
  131. {
  132. return Ok(JsonView(false, "参数为空"));
  133. }
  134. Grp_ScheduleDto _ScheduleDto = JsonConvert.DeserializeObject<Grp_ScheduleDto>(_jsonDto.Paras);
  135. if (_ScheduleDto != null)
  136. {
  137. if (_ScheduleDto.SearchType == 2)//获取列表
  138. {
  139. List<Grp_ScheduleView> _grpScheduleViewList = await _grpScheduleRep.GetViewList_GrpSchedule(_ScheduleDto);
  140. return Ok(JsonView(_grpScheduleViewList));
  141. }
  142. else//获取对象
  143. {
  144. Grp_ScheduleCombinView _grpScheduleView = await _grpScheduleRep.GetView_GrpSchedule(_ScheduleDto);
  145. if (_grpScheduleView != null)
  146. {
  147. return Ok(JsonView(_grpScheduleView));
  148. }
  149. }
  150. }
  151. else
  152. {
  153. return Ok(JsonView(false, "参数反序列化失败"));
  154. }
  155. return Ok(JsonView(false, "暂无数据!"));
  156. }
  157. /// <summary>
  158. /// 修改团组流程管控详细表数据
  159. /// </summary>
  160. /// <param name="paras"></param>
  161. /// <returns></returns>
  162. [HttpPost]
  163. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  164. public async Task<IActionResult> PostUpdateGrpScheduleDetail(Grp_ScheduleDetailUpdDto dto)
  165. {
  166. Grp_ScheduleDetailInfo _detail = _mapper.Map<Grp_ScheduleDetailInfo>(dto);
  167. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_ScheduleDetailInfo>()
  168. .SetColumns(it => it.Duty == _detail.Duty)
  169. .SetColumns(it => it.ExpectBeginDt == _detail.ExpectBeginDt)
  170. .SetColumns(it => it.ExpectEndDt == _detail.ExpectEndDt)
  171. .SetColumns(it => it.JobContent == _detail.JobContent)
  172. .SetColumns(it => it.Remark == _detail.Remark)
  173. .SetColumns(it => it.StepStatus == _detail.StepStatus)
  174. .Where(s => s.Id == dto.Id)
  175. //.UpdateColumns(s => new { s.Duty, s.ExpectBeginDt, s.ExpectEndDt, s.JobContent, s.Remark, s.StepStatus })
  176. .ExecuteCommandAsync();
  177. if (result > 0)
  178. {
  179. return Ok(JsonView(true, "保存成功!"));
  180. }
  181. return Ok(JsonView(false, "保存失败!"));
  182. }
  183. /// <summary>
  184. /// 删除团组流程管控详细表数据,删除人Id请放在Duty
  185. /// </summary>
  186. /// <param name="dto"></param>
  187. /// <returns></returns>
  188. [HttpPost]
  189. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  190. public async Task<ActionResult> PostDeleteGrpScheduleDetail(Grp_ScheduleDetailUpdDto dto)
  191. {
  192. Grp_ScheduleDetailInfo _detail = _mapper.Map<Grp_ScheduleDetailInfo>(dto);
  193. _detail.IsDel = 1;
  194. _detail.DeleteUserId = dto.Duty;
  195. _detail.DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  196. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_ScheduleDetailInfo>()
  197. .SetColumns(it => it.IsDel == _detail.IsDel)
  198. .SetColumns(it => it.DeleteUserId == _detail.DeleteUserId)
  199. .SetColumns(it => it.DeleteTime == _detail.DeleteTime)
  200. .Where(it => it.Id == dto.Id)
  201. //.UpdateColumns(s => new { s.IsDel, s.DeleteUserId, s.DeleteTime })
  202. //.WhereColumns(s => s.Id == dto.Id)
  203. .ExecuteCommandAsync();
  204. if (result > 0)
  205. {
  206. return Ok(JsonView(true, "删除成功!"));
  207. }
  208. return Ok(JsonView(false, "删除失败!"));
  209. }
  210. /// <summary>
  211. /// 增加团组流程管控详细表数据
  212. /// </summary>
  213. /// <param name="dto"></param>
  214. /// <returns></returns>
  215. [HttpPost]
  216. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  217. public async Task<ActionResult> PostInsertGrpScheduleDetail(Grp_ScheduleDetailInsertDto dto)
  218. {
  219. Grp_ScheduleDetailInfo _detail = _mapper.Map<Grp_ScheduleDetailInfo>(dto);
  220. if (DateTime.Now < _detail.ExpectBeginDt)
  221. {
  222. _detail.StepStatus = 0;
  223. }
  224. else
  225. {//若大于设置时间,不考虑设置的预计结束日期,统一视为进行中
  226. _detail.StepStatus = 1;
  227. }
  228. var result = await _grpScheduleRep._sqlSugar.Insertable(_detail).ExecuteReturnIdentityAsync();
  229. if (result > 0)
  230. {
  231. Grp_ScheduleDetailView _result = await _grpScheduleRep.GetInsertBackData(result);
  232. return Ok(JsonView(true, "添加成功!", _result));
  233. }
  234. return Ok(JsonView(false, "添加失败!"));
  235. }
  236. #endregion
  237. #region 团组基本信息
  238. /// <summary>
  239. /// 接团信息列表
  240. /// </summary>
  241. /// <param name="dto">团组列表请求dto</param>
  242. /// <returns></returns>
  243. [HttpPost]
  244. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  245. public async Task<IActionResult> GetGroupList(GroupListDto dto)
  246. {
  247. var groupData = await _groupRepository.GetGroupList(dto);
  248. if (groupData.Code != 0)
  249. {
  250. return Ok(JsonView(false, groupData.Msg));
  251. }
  252. return Ok(JsonView(groupData.Data));
  253. }
  254. /// <summary>
  255. /// 接团信息列表 Page
  256. /// </summary>
  257. /// <param name="dto">团组列表请求dto</param>
  258. /// <returns></returns>
  259. [HttpPost]
  260. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  261. public async Task<IActionResult> PostGroupPageList(GroupPageListDto dto)
  262. {
  263. #region 参数验证
  264. if (dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  265. if (dto.PageId < 1) return Ok(JsonView(false, "页面Id为空"));
  266. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  267. #region 页面操作权限验证
  268. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(dto.UserId, dto.PageId);
  269. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限"));
  270. #endregion
  271. #endregion
  272. if (dto.PortType == 1 || dto.PortType == 2) // web/Android
  273. {
  274. string sqlWhere = string.Empty;
  275. if (dto.IsSure == 0) //未完成
  276. {
  277. sqlWhere += string.Format(@" And IsSure = 0");
  278. }
  279. else if (dto.IsSure == 1) //已完成
  280. {
  281. sqlWhere += string.Format(@" And IsSure = 1");
  282. }
  283. if (!string.IsNullOrEmpty(dto.SearchCriteria))
  284. {
  285. string tj = dto.SearchCriteria;
  286. sqlWhere += string.Format(@"And (ssd.Name Like '%{0}%' Or TeamName Like '%{1}%' Or ClientName Like '%{2}%' Or ClientName Like '%{3}%' Or su.CnName Like '%{4}%')",
  287. tj, tj, tj, tj, tj);
  288. }
  289. string sql = string.Format(@"Select Row_Number,Id,SalesQuoteNo,TourCode,TeamTypeId, TeamType,
  290. TeamLevId,TeamLev,TeamName,ClientName,ClientUnit,
  291. VisitDate,VisitDays,VisitPNumber,JietuanOperator,IsSure,CreateTime
  292. From (
  293. Select row_number() over(order by gdi.CreateTime Desc) as Row_Number,
  294. gdi.Id,SalesQuoteNo,TourCode,ssd.Id TeamTypeId, ssd.Name TeamType,
  295. ssd1.Id TeamLevId,ssd1.Name TeamLev,TeamName,ClientName,ClientUnit,
  296. VisitDate,VisitDays,VisitPNumber,su.CnName JietuanOperator,IsSure,gdi.CreateTime
  297. From Grp_DelegationInfo gdi
  298. Inner Join Sys_SetData ssd On gdi.TeamDid = ssd.Id
  299. Inner Join Sys_SetData ssd1 On gdi.TeamLevSId = ssd1.Id
  300. Left Join Sys_Users su On gdi.JietuanOperator = su.Id
  301. Where gdi.IsDel = 0 {0}
  302. ) temp ", sqlWhere);
  303. RefAsync<int> total = 0;//REF和OUT不支持异步,想要真的异步这是最优解
  304. var _DelegationList = await _sqlSugar.SqlQueryable<DelegationListView>(sql).ToPageListAsync(dto.PageIndex, dto.PageSize, total);//ToPageAsync
  305. var _view = new
  306. {
  307. PageFuncAuth = pageFunAuthView,
  308. Data = _DelegationList
  309. };
  310. return Ok(JsonView(true, "查询成功!", _view, total));
  311. }
  312. else
  313. {
  314. return Ok(JsonView(false, "查询失败"));
  315. }
  316. }
  317. /// <summary>
  318. /// 接团信息详情
  319. /// </summary>
  320. /// <param name="dto">团组info请求dto</param>
  321. /// <returns></returns>
  322. [HttpPost]
  323. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  324. public async Task<IActionResult> GetGroupInfo(GroupInfoDto dto)
  325. {
  326. var groupData = await _groupRepository.GetGroupInfo(dto);
  327. if (groupData.Code != 0)
  328. {
  329. return Ok(JsonView(false, groupData.Msg));
  330. }
  331. return Ok(JsonView(groupData.Data));
  332. }
  333. /// <summary>
  334. /// 接团信息 编辑添加
  335. /// 基础信息数据源
  336. /// </summary>
  337. /// <param name="dto"></param>
  338. /// <returns></returns>
  339. [HttpPost]
  340. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  341. public async Task<IActionResult> GroupEditBasicSource(GroupListDto dto)
  342. {
  343. var groupData = await _groupRepository.GroupEditBasicSource(dto);
  344. if (groupData.Code != 0)
  345. {
  346. return Ok(JsonView(false, groupData.Msg));
  347. }
  348. return Ok(JsonView(groupData.Data));
  349. }
  350. /// <summary>
  351. /// 接团信息 操作(增改)
  352. /// </summary>
  353. /// <param name="dto"></param>
  354. /// <returns></returns>
  355. [HttpPost]
  356. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  357. public async Task<IActionResult> GroupOperation(GroupOperationDto dto)
  358. {
  359. try
  360. {
  361. var groupData = await _groupRepository.GroupOperation(dto);
  362. if (groupData.Code != 0)
  363. {
  364. return Ok(JsonView(false, groupData.Msg));
  365. }
  366. //添加时 默认加入团组汇率
  367. if (dto.Status == 1)
  368. {
  369. int diId = groupData.Data;
  370. GeneralMethod.PostGroupRateAddInit(dto.UserId, diId);
  371. }
  372. return Ok(JsonView(true));
  373. }
  374. catch (Exception ex)
  375. {
  376. Logs("[response]" + JsonConvert.SerializeObject(dto));
  377. Logs(ex.Message);
  378. return Ok(JsonView(false, ex.Message));
  379. }
  380. }
  381. /// <summary>
  382. /// 建团添加默认工作人员团组权限测试
  383. /// </summary>
  384. /// <param name="dto"></param>
  385. /// <returns></returns>
  386. [HttpPost]
  387. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  388. public async Task<IActionResult> PostGroupAuthAddInit(int userId, int diId)
  389. {
  390. try
  391. {
  392. GeneralMethod.PostGroupAuthAddInit(userId, diId);
  393. return Ok(JsonView(true));
  394. }
  395. catch (Exception ex)
  396. {
  397. Logs(ex.Message);
  398. return Ok(JsonView(false, ex.Message));
  399. }
  400. }
  401. /// <summary>
  402. /// 建团添加默认币种测试
  403. /// </summary>
  404. /// <param name="dto"></param>
  405. /// <returns></returns>
  406. [HttpPost]
  407. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  408. public async Task<IActionResult> GroupOperation11(int userId,int diId)
  409. {
  410. try
  411. {
  412. GeneralMethod.PostGroupRateAddInit(userId, diId);
  413. return Ok(JsonView(true));
  414. }
  415. catch (Exception ex)
  416. {
  417. Logs(ex.Message);
  418. return Ok(JsonView(false, ex.Message));
  419. }
  420. }
  421. /// <summary>
  422. /// 接团信息 操作(删除)
  423. /// </summary>
  424. /// <param name="dto"></param>
  425. /// <returns></returns>
  426. [HttpPost]
  427. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  428. public async Task<IActionResult> GroupDel(GroupDelDto dto)
  429. {
  430. try
  431. {
  432. var groupData = await _groupRepository.GroupDel(dto);
  433. if (groupData.Code != 0)
  434. {
  435. return Ok(JsonView(false, groupData.Msg));
  436. }
  437. return Ok(JsonView(true));
  438. }
  439. catch (Exception ex)
  440. {
  441. Logs("[response]" + JsonConvert.SerializeObject(dto));
  442. Logs(ex.Message);
  443. return Ok(JsonView(false, ex.Message));
  444. }
  445. }
  446. /// <summary>
  447. /// 获取团组销售报价号
  448. /// 团组添加时 使用
  449. /// </summary>
  450. /// <returns></returns>
  451. [HttpPost]
  452. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  453. public async Task<IActionResult> GetGroupSalesQuoteNo()
  454. {
  455. var groupData = await _groupRepository.GetGroupSalesQuoteNo();
  456. if (groupData.Code != 0)
  457. {
  458. return Ok(JsonView(false, groupData.Msg));
  459. }
  460. object salesQuoteNo = new
  461. {
  462. SalesQuoteNo = groupData.Data
  463. };
  464. return Ok(JsonView(salesQuoteNo));
  465. }
  466. /// <summary>
  467. /// 设置确认出团
  468. /// </summary>
  469. /// <param name="dto"></param>
  470. /// <returns></returns>
  471. [HttpPost]
  472. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  473. public async Task<IActionResult> SetConfirmationGroup(ConfirmationGroupDto dto)
  474. {
  475. var groupData = await _groupRepository.ConfirmationGroup(dto);
  476. if (groupData.Code != 0)
  477. {
  478. return Ok(JsonView(false, groupData.Msg));
  479. }
  480. GroupStepForDelegation.CreateWorkStep(dto.GroupId); //创建管控流程
  481. return Ok(JsonView(true, "操作成功!", groupData.Data));
  482. }
  483. /// <summary>
  484. /// 获取团组名称data And 签证国别Data
  485. /// </summary>
  486. /// <param name="dto"></param>
  487. /// <returns></returns>
  488. [HttpPost]
  489. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  490. public async Task<IActionResult> GetGroupNameAndVisaNationality(GroupNameDto dto)
  491. {
  492. var groupData = await _groupRepository.GetGroupNameAndVisaNationality(dto);
  493. if (groupData.Code != 0)
  494. {
  495. return Ok(JsonView(false, groupData.Msg));
  496. }
  497. return Ok(JsonView(groupData.Data));
  498. }
  499. /// <summary>
  500. /// 根据CTable类型返回对应的团组名称及简单数据(APP端)
  501. /// </summary>
  502. /// <returns></returns>
  503. [HttpPost]
  504. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  505. public async Task<IActionResult> PostGroupNameAndEasy(DecreasePaymentsDto dto)
  506. {
  507. try
  508. {
  509. Result groupData = await _decreasePaymentsRep.PostGroupNameAndEasy(dto);
  510. if (groupData.Code != 0)
  511. {
  512. return Ok(JsonView(false, groupData.Msg));
  513. }
  514. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  515. }
  516. catch (Exception ex)
  517. {
  518. return Ok(JsonView(false, "程序错误!"));
  519. throw;
  520. }
  521. }
  522. #endregion
  523. #region 团组&签证
  524. /// <summary>
  525. /// 根据团组Id获取签证客户信息List
  526. /// </summary>
  527. /// <param name="dto">请求dto</param>
  528. /// <returns></returns>
  529. [HttpPost]
  530. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  531. public async Task<IActionResult> GetCrmByGroupId(ClientByGroupIdDto dto)
  532. {
  533. var groupData = await _groupRepository.GetCrmByGroupId(dto);
  534. if (groupData.Code != 0)
  535. {
  536. return Ok(JsonView(false, groupData.Msg));
  537. }
  538. return Ok(JsonView(groupData.Data));
  539. }
  540. /// <summary>
  541. /// IOS获取团组签证拍照上传进度01(团组列表)
  542. /// </summary>
  543. /// <param name="dto">请求dto</param>
  544. /// <returns></returns>
  545. [HttpPost]
  546. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  547. public async Task<IActionResult> PostIOSVisaProgress(IOS_VisaDto dto)
  548. {
  549. if (dto == null)
  550. {
  551. return Ok(JsonView(false, "参数为空"));
  552. }
  553. DelegationVisaViewList visaList = _delegationVisaRep.GetDelegationList(dto);
  554. return Ok(JsonView(visaList));
  555. }
  556. /// <summary>
  557. /// IOS获取团组签证拍照上传进度02(团组签证详情\人员列表\国家)
  558. /// </summary>
  559. /// <returns></returns>
  560. [HttpPost]
  561. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  562. public async Task<ActionResult> PostIOSVisaProgressContent(IOS_VisaCustomerListDto dto)
  563. {
  564. if (dto == null)
  565. {
  566. return Ok(JsonView(false, "请求错误:"));
  567. }
  568. List<DelegationVisaProgressView> list = _delegationVisaRep.GetDelegationProgressList(dto.diId);
  569. return Ok(JsonView(list));
  570. }
  571. /// <summary>
  572. /// IOS获取团组签证拍照上传进度03(相册)
  573. /// </summary>
  574. /// <returns></returns>
  575. [HttpPost]
  576. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  577. public async Task<ActionResult> PostIOSVisaProgressImageList(IOS_VisaImageListDto dto)
  578. {
  579. if (dto == null)
  580. {
  581. return Ok(JsonView(false, "请求错误:"));
  582. }
  583. List<VisaProgressImageView> list = _delegationVisaRep.GetVisaProgressImageList(dto.visaProgressCustomerId, dto.picType);
  584. string url = AppSettingsHelper.Get("VisaProgressImageBaseUrl") + AppSettingsHelper.Get("VisaProgressImageFtpPath");
  585. list.ForEach(s => s.url = url);
  586. return Ok(JsonView(list));
  587. }
  588. /// <summary>
  589. /// IOS获取团组签证拍照上传进度04(图片上传)
  590. /// </summary>
  591. /// <param name="dto"></param>
  592. /// <returns></returns>
  593. [HttpPost]
  594. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  595. public async Task<ActionResult> PostIOSVisaProgressUploadImage(IOS_VisaUploadImageDto dto)
  596. {
  597. //string result = decodeBase64ToImage(dto.base64DataURL, dto.imageName);
  598. //if (!string.IsNullOrEmpty(result))
  599. //{
  600. //}
  601. //else {
  602. // return Ok(JsonView(false, "上传失败"));
  603. //}
  604. DateTime dt1970 = new DateTime(1970, 1, 1, 0, 0, 0, 0);
  605. int sucNum = 0;
  606. try
  607. {
  608. foreach (var item in dto.base64DataList)
  609. {
  610. string imageName = dto.imageName + ((DateTime.Now.Ticks - dt1970.Ticks) / 10000).ToString();
  611. string result = decodeBase64ToImage(item, imageName);
  612. if (!string.IsNullOrEmpty(result))
  613. {
  614. Grp_VisaProgressCustomerPicture pic = new Grp_VisaProgressCustomerPicture();
  615. pic.CreateUserId = dto.CreateUserId;
  616. pic.PicName = imageName;
  617. pic.PicPath = result;
  618. pic.VisaProgressCustomerId = dto.visaProgressCustomerId;
  619. int insertResult = await _delegationVisaRep.AddAsync<Grp_VisaProgressCustomerPicture>(pic);
  620. if (insertResult > 0)
  621. {
  622. sucNum++;
  623. }
  624. }
  625. }
  626. }
  627. catch (Exception ex)
  628. {
  629. return Ok(JsonView(false, ex.Message));
  630. }
  631. string msg = string.Format(@"成功上传{0}张", sucNum);
  632. return Ok(JsonView(true, msg));
  633. }
  634. private string decodeBase64ToImage(string base64DataURL, string imgName)
  635. {
  636. string filename = "";//声明一个string类型的相对路径
  637. String base64 = base64DataURL.Substring(base64DataURL.IndexOf(",") + 1); //将‘,’以前的多余字符串删除
  638. System.Drawing.Bitmap bitmap = null;//定义一个Bitmap对象,接收转换完成的图片
  639. try//会有异常抛出,try,catch一下
  640. {
  641. byte[] arr = Convert.FromBase64String(base64);//将纯净资源Base64转换成等效的8位无符号整形数组
  642. System.IO.MemoryStream ms = new System.IO.MemoryStream(arr);//转换成无法调整大小的MemoryStream对象
  643. bitmap = new System.Drawing.Bitmap(ms);//将MemoryStream对象转换成Bitmap对象
  644. var fileDir = AppSettingsHelper.Get("VisaProgressImageBasePath");
  645. //文件名称
  646. filename = "VisaProgress_" + DateTime.Now.ToString("yyyyMMddHHmmss") + "_" + imgName + ".jpeg";//所要保存的相对路径及名字
  647. //上传的文件的路径
  648. string filePath = "";
  649. if (!Directory.Exists(fileDir))
  650. {
  651. Directory.CreateDirectory(fileDir);
  652. }
  653. //上传的文件的路径
  654. filePath = fileDir + filename;
  655. //string url = HttpRuntime.AppDomainAppPath.ToString();
  656. //string tmpRootDir = System.Web.HttpContext.Current.Server.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath.ToString()); //获取程序根目录
  657. //string imagesurl2 = tmpRootDir + filename; //转换成绝对路径
  658. bitmap.Save(filePath, System.Drawing.Imaging.ImageFormat.Jpeg);//保存到服务器路径
  659. //bitmap.Save(filePath + ".bmp", System.Drawing.Imaging.ImageFormat.Bmp);
  660. //bitmap.Save(filePath + ".gif", System.Drawing.Imaging.ImageFormat.Gif);
  661. //bitmap.Save(filePath, System.Drawing.Imaging.ImageFormat.Png);
  662. ms.Close();//关闭当前流,并释放所有与之关联的资源
  663. bitmap.Dispose();
  664. }
  665. catch (Exception e)
  666. {
  667. string massage = e.Message;
  668. Logs("IOS图片上传Error:" + massage);
  669. //filename = e.Message;
  670. }
  671. return filename;//返回相对路径
  672. }
  673. /// <summary>
  674. /// IOS获取团组签证拍照上传进度05(修改签证状态/通知)
  675. /// </summary>
  676. /// <param name="dto"></param>
  677. /// <returns></returns>
  678. [HttpPost]
  679. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  680. public async Task<ActionResult> PostIOSVisaProgressChangeStatus(IOS_VisaChangeStatusDto dto)
  681. {
  682. if (dto == null)
  683. {
  684. return Ok(JsonView(false, "请求错误:"));
  685. }
  686. string msg = "参数错误";
  687. if (dto.diId > 0 && dto.visaStatus > 0 && dto.visaStatus < 4)
  688. {
  689. try
  690. {
  691. //_delegationVisaRep.BeginTran();
  692. var updCount = await _delegationVisaRep._sqlSugar.Updateable<Grp_VisaProgressCustomer>()
  693. .SetColumns(it => it.WorkStatus == dto.visaStatus)
  694. .Where(s => s.Id == dto.visaProgressCustomerId)
  695. .ExecuteCommandAsync();
  696. if (updCount > 0 && dto.publishCode == 1)
  697. {
  698. _delegationVisaRep.ChangeDataBase(DBEnum.OA2014DB); //切换到新OA后删除
  699. string sqlDelegation = string.Format(@" Select * From DelegationInfo With(Nolock) Where Id = {0} ", dto.diId);
  700. OA2021_DelegationInfo groupData = _sqlSugar.SqlQueryable<OA2021_DelegationInfo>(sqlDelegation).First();
  701. //GroupInfoDto grpDto = new GroupInfoDto() { Id = dto.diId };
  702. //var groupData = await _groupRepository.GetGroupInfo(grpDto);
  703. _delegationVisaRep.ChangeDataBase(DBEnum.OA2023DB); //切换到新OA后删除
  704. if (groupData == null)
  705. {
  706. _delegationVisaRep.RollbackTran();
  707. }
  708. string title = string.Format(@"[签证进度更新]");
  709. string content = string.Format(@"测试文本");
  710. bool rst = await _message.AddMsg(new MessageDto()
  711. {
  712. Type = 5,
  713. IssuerId = dto.publisher,
  714. Title = title,
  715. Content = content,
  716. ReleaseTime = DateTime.Now,
  717. UIdList = new List<int> {
  718. 234
  719. }
  720. });
  721. if (rst)
  722. {
  723. return Ok(JsonView(true, "发送通知成功"));
  724. }
  725. }
  726. //_delegationVisaRep.CommitTran();
  727. }
  728. catch (Exception)
  729. {
  730. //_delegationVisaRep.RollbackTran();
  731. }
  732. }
  733. return Ok(JsonView(true, msg));
  734. }
  735. #endregion
  736. #region 团组任务分配
  737. /// <summary>
  738. /// 团组任务分配初始化
  739. /// </summary>
  740. /// <param name="dto"></param>
  741. /// <returns></returns>
  742. [HttpPost]
  743. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  744. public async Task<IActionResult> GetTaskAssignmen()
  745. {
  746. var groupData = await _taskAssignmentRep.GetTaskAssignmen();
  747. if (groupData.Code != 0)
  748. {
  749. return Ok(JsonView(false, groupData.Msg));
  750. }
  751. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  752. }
  753. /// <summary>
  754. /// 团组任务分配查询
  755. /// </summary>
  756. /// <param name="dto"></param>
  757. /// <returns></returns>
  758. [HttpPost]
  759. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  760. public async Task<IActionResult> TaskAssignmenQuery(TaskAssignmenQueryDto dto)
  761. {
  762. var groupData = await _taskAssignmentRep.TaskAssignmenQuery(dto);
  763. if (groupData.Code != 0)
  764. {
  765. return Ok(JsonView(false, groupData.Msg));
  766. }
  767. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  768. }
  769. /// <summary>
  770. /// 团组任务分配操作
  771. /// </summary>
  772. /// <param name="dto"></param>
  773. /// <returns></returns>
  774. [HttpPost]
  775. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  776. public async Task<IActionResult> GetTaskAssignmenOp(TaskAssignmenDto dto)
  777. {
  778. Result groupData = await _taskAssignmentRep.GetTaskAssignmenOp(dto);
  779. if (groupData.Code != 0)
  780. {
  781. return Ok(JsonView(false, groupData.Msg));
  782. }
  783. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  784. }
  785. #endregion
  786. #region 团组费用审核
  787. /// <summary>
  788. /// 费用审核
  789. /// 团组列表 Page
  790. /// </summary>
  791. /// <param name="_dto">团组列表请求dto</param>
  792. /// <returns></returns>
  793. [HttpPost]
  794. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  795. public async Task<IActionResult> PostExpenseAuditGroupPageItems(ExpenseAuditGroupPageItemsDto _dto)
  796. {
  797. #region 参数验证
  798. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  799. if (_dto.PageId < 1) return Ok(JsonView(false, "页面Id为空"));
  800. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  801. #region 页面操作权限验证
  802. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  803. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限"));
  804. #endregion
  805. #endregion
  806. if (_dto.PortType == 1 || _dto.PortType == 2 || _dto.PortType == 2) // web/Android/IOS
  807. {
  808. string sqlWhere = string.Empty;
  809. if (_dto.IsSure == 0) //未完成
  810. {
  811. sqlWhere += string.Format(@" And IsSure = 0");
  812. }
  813. else if (_dto.IsSure == 1) //已完成
  814. {
  815. sqlWhere += string.Format(@" And IsSure = 1");
  816. }
  817. if (!string.IsNullOrEmpty(_dto.SearchCriteria))
  818. {
  819. string tj = _dto.SearchCriteria;
  820. sqlWhere += string.Format(@"And (ssd.Name Like '%{0}%' Or TeamName Like '%{1}%' Or ClientName Like '%{2}%' Or ClientName Like '%{3}%' Or su.CnName Like '%{4}%')",
  821. tj, tj, tj, tj, tj);
  822. }
  823. string sql = string.Format(@"Select Row_Number,Id,SalesQuoteNo,TourCode,TeamTypeId, TeamType,
  824. TeamName,ClientName,ClientUnit, TeamLevId,TeamLev,VisitDate,
  825. VisitDays,VisitPNumber,JietuanOperator,IsSure,CreateTime
  826. From (
  827. Select row_number() over(order by gdi.VisitDate Desc) as Row_Number,
  828. gdi.Id,SalesQuoteNo,TourCode,ssd1.Id TeamLevId,ssd1.Name TeamLev,TeamName,
  829. ClientName,ClientUnit,ssd.Id TeamTypeId, ssd.Name TeamType,VisitDate,
  830. VisitDays,VisitPNumber,su.CnName JietuanOperator,IsSure,gdi.CreateTime
  831. From Grp_DelegationInfo gdi
  832. Inner Join Sys_SetData ssd On gdi.TeamDid = ssd.Id
  833. Inner Join Sys_SetData ssd1 On gdi.TeamLevSId = ssd1.Id
  834. Left Join Sys_Users su On gdi.JietuanOperator = su.Id
  835. Where gdi.IsDel = 0 {0}
  836. ) temp ", sqlWhere);
  837. RefAsync<int> total = 0;//REF和OUT不支持异步,想要真的异步这是最优解
  838. var _DelegationList = await _sqlSugar.SqlQueryable<DelegationListView>(sql).ToPageListAsync(_dto.PageIndex, _dto.PageSize, total);//ToPageAsync
  839. var _view = new
  840. {
  841. PageFuncAuth = pageFunAuthView,
  842. Data = _DelegationList
  843. };
  844. return Ok(JsonView(true, "查询成功!", _view, total));
  845. }
  846. else
  847. {
  848. return Ok(JsonView(false, "查询失败"));
  849. }
  850. }
  851. /// <summary>
  852. /// 获取团组费用审核
  853. /// </summary>
  854. /// <param name="paras">参数Json字符串</param>
  855. /// <returns></returns>
  856. [HttpPost]
  857. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  858. public async Task<IActionResult> PostSearchGrpCreditCardPayment(Search_GrpCreditCardPaymentDto _dto)
  859. {
  860. try
  861. {
  862. #region 参数验证
  863. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  864. if (_dto.PageId < 1) return Ok(JsonView(false, "页面Id为空"));
  865. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  866. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  867. #region 页面操作权限验证
  868. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  869. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限"));
  870. #endregion
  871. #endregion
  872. Grp_CreditCardPaymentView _view = new Grp_CreditCardPaymentView();
  873. #region 费用清单
  874. var exp = Expressionable.Create<Grp_CreditCardPayment>();
  875. exp.AndIF(_dto.AuditStatus != -1, it => it.IsAuditGM == _dto.AuditStatus);
  876. exp.AndIF(_dto.Label != -1, it => it.CTable == _dto.Label);
  877. List<Grp_CreditCardPayment> entityList = _groupRepository
  878. .Query<Grp_CreditCardPayment>(s => s.DIId == _dto.DiId && s.IsDel == 0 && s.CreateUserId > 0)
  879. .Where(exp.ToExpression())
  880. .ToList();
  881. List<Grp_CreditCardPaymentDetailView> detailList = new List<Grp_CreditCardPaymentDetailView>();
  882. List<CreditCardPaymentCurrencyPriceItem> ccpCurrencyPrices = new List<CreditCardPaymentCurrencyPriceItem>();
  883. /*
  884. * 76://酒店预订
  885. */
  886. List<Grp_HotelReservations> _HotelReservations = await _groupRepository
  887. .Query<Grp_HotelReservations>(s => s.DiId == _dto.DiId && s.IsDel == 0)
  888. .ToListAsync();
  889. /*
  890. * 79://车/导游地接
  891. */
  892. List<Grp_CarTouristGuideGroundReservations> _CarTouristGuideGroundReservations = await _groupRepository
  893. .Query<Grp_CarTouristGuideGroundReservations>(s => s.DiId == _dto.DiId && s.IsDel == 0)
  894. .ToListAsync();
  895. List<Grp_CarTouristGuideGroundReservationsContent> _CarTouristGuideGroundReservationsContent = await _groupRepository
  896. .Query<Grp_CarTouristGuideGroundReservationsContent>(s => s.DiId == _dto.DiId && s.IsDel == 0)
  897. .ToListAsync();
  898. /*
  899. * 80: //签证
  900. */
  901. List<Grp_VisaInfo> _VisaInfos = await _groupRepository
  902. .Query<Grp_VisaInfo>(s => s.DIId == _dto.DiId && s.IsDel == 0)
  903. .ToListAsync();
  904. /*
  905. *81: //邀请/公务活动
  906. */
  907. List<Grp_InvitationOfficialActivities> _InvitationOfficialActivities = await _groupRepository
  908. .Query<Grp_InvitationOfficialActivities>(s => s.DiId == _dto.DiId && s.IsDel == 0)
  909. .ToListAsync();
  910. /*
  911. * 82: //团组客户保险
  912. */
  913. /*
  914. * Label = 98 其他款项
  915. */
  916. List<Grp_DecreasePayments> _DecreasePayments = await _groupRepository
  917. .Query<Grp_DecreasePayments>(s => s.DiId == _dto.DiId && s.IsDel == 0)
  918. .ToListAsync();
  919. /*
  920. * Lable = 85 机票预订
  921. */
  922. List<Grp_AirTicketReservations> p_AirTicketReservations = await _groupRepository
  923. .Query<Grp_AirTicketReservations>(s => s.DIId == _dto.DiId && s.IsDel == 0)
  924. .ToListAsync();
  925. /*
  926. * 98 机票预定
  927. */
  928. List<Grp_AirTicketReservations> _AirTicketReservations = await _groupRepository.Query<Grp_AirTicketReservations>(s => s.DIId == _dto.DiId && s.IsDel == 0).ToListAsync();
  929. /*
  930. * 285://收款退还
  931. */
  932. List<Fin_PaymentRefundAndOtherMoney> _PaymentRefundAndOtherMoneys= await _groupRepository
  933. .Query<Fin_PaymentRefundAndOtherMoney>(s => s.DiId == _dto.DiId && s.IsDel == 0)
  934. .ToListAsync();
  935. List<Grp_Customers> _Customers = await _groupRepository.Query<Grp_Customers>(s => s.DiId == _dto.DiId && s.IsDel == 0) .ToListAsync();
  936. /*
  937. * 币种信息
  938. */
  939. var currencyItems = await _groupRepository.Query<Sys_SetData>(s => s.STid == 66 && s.IsDel == 0).ToListAsync();
  940. /*
  941. * 车/导游地接 费用类型
  942. */
  943. var carFeeTypeItems = await _groupRepository.Query<Sys_SetData>(s => s.STid == 17 && s.IsDel == 0).ToListAsync();
  944. /*
  945. * 用户信息
  946. */
  947. var userItems = await _groupRepository.Query<Sys_Users>(s => s.IsDel == 0).ToListAsync();
  948. /*
  949. * 费用模块
  950. */
  951. Sys_SetData sdPriceName = _groupRepository.Query<Sys_SetData>(s => s.Id == _dto.Label).First();
  952. string priceModule = string.Empty;
  953. if (sdPriceName != null)
  954. {
  955. priceModule = sdPriceName.Name;
  956. }
  957. /*
  958. * 处理详情数据
  959. */
  960. foreach (var entity in entityList)
  961. {
  962. Grp_CreditCardPaymentDetailView _detail = new Grp_CreditCardPaymentDetailView();
  963. _detail.Id = entity.Id;
  964. _detail.PriceName = priceModule;
  965. /*
  966. * 应付款金额
  967. */
  968. Sys_SetData sdPaymentCurrency_WaitPay = currencyItems.Where(s => s.Id == entity.PaymentCurrency).FirstOrDefault();
  969. string PaymentCurrency_WaitPay = "Unknown";
  970. string hotelCurrncyCode = "Unknown";
  971. string hotelCurrncyName = "Unknown";
  972. if (sdPaymentCurrency_WaitPay != null)
  973. {
  974. PaymentCurrency_WaitPay = sdPaymentCurrency_WaitPay.Name;
  975. hotelCurrncyCode = sdPaymentCurrency_WaitPay.Name;
  976. hotelCurrncyName = sdPaymentCurrency_WaitPay.Remark;
  977. }
  978. _detail.WaitPay = entity.PayMoney.ConvertToDecimal1() + " " + PaymentCurrency_WaitPay;
  979. /*
  980. * 此次付款金额
  981. */
  982. decimal CurrPayStr = 0;
  983. if (entity.PayPercentage == 0)
  984. {
  985. if (entity.PayThenMoney != 0)
  986. CurrPayStr = (entity.PayThenMoney * entity.DayRate).ConvertToDecimal1();
  987. }
  988. else
  989. {
  990. CurrPayStr = (entity.PayMoney * (decimal.Parse(entity.PayPercentage.ToString("#0.00")) / 100 * entity.DayRate)).ConvertToDecimal1();
  991. }
  992. _detail.CurrPay = CurrPayStr.ToString("#0.00") + " CNY";
  993. /*
  994. * 剩余尾款
  995. */
  996. decimal BalanceStr = 0;
  997. if (entity.PayMoney - (CurrPayStr / entity.DayRate) < 0.01M)
  998. BalanceStr = 0;
  999. else
  1000. BalanceStr = (entity.PayMoney - CurrPayStr / entity.DayRate).ConvertToDecimal1();
  1001. _detail.Balance = BalanceStr.ToString("#0.00") + " " + PaymentCurrency_WaitPay;
  1002. /*
  1003. * Bus名称
  1004. */
  1005. _detail.BusName = "待增加";
  1006. /*
  1007. *费用所属
  1008. */
  1009. switch (entity.CTable)
  1010. {
  1011. case 76://酒店预订
  1012. Grp_HotelReservations hotelReservations = _HotelReservations.Where(s => s.Id == entity.CId).FirstOrDefault();
  1013. if (hotelReservations != null)
  1014. {
  1015. _detail.PriceMsgContent = "信用卡金额:" + _detail.WaitPay + " " + hotelCurrncyCode + "(" + hotelCurrncyName + ")<br/>" +
  1016. "房间说明:" + hotelReservations.Remark;
  1017. _detail.PriceNameContent = hotelReservations.HotelName;
  1018. }
  1019. break;
  1020. case 79://车/导游地接
  1021. Grp_CarTouristGuideGroundReservations touristGuideGroundReservations = _CarTouristGuideGroundReservations.Where(s => s.Id == entity.CId).FirstOrDefault();
  1022. if (touristGuideGroundReservations != null)
  1023. {
  1024. if (!string.IsNullOrEmpty(touristGuideGroundReservations.BusName))
  1025. {
  1026. _detail.BusName = touristGuideGroundReservations.BusName;
  1027. }
  1028. _detail.PriceNameContent = touristGuideGroundReservations.Area;
  1029. List<Grp_CarTouristGuideGroundReservationsContent> touristGuideGroundReservationsContents = _CarTouristGuideGroundReservationsContent
  1030. .Where(s => s.CTGGRId == touristGuideGroundReservations.Id && s.IsDel == 0 && s.Price != 0).ToList();
  1031. string priceMsg = string.Empty;
  1032. foreach (var item in touristGuideGroundReservationsContents)
  1033. {
  1034. string typeName = "Unknown";
  1035. string carCurrencyCode = "Unknown";
  1036. string carCurrencyName = "Unknown";
  1037. var carTypeData = carFeeTypeItems.Where(s => s.Id == item.SId && s.IsDel == 0).FirstOrDefault();
  1038. if (carTypeData != null) typeName = carTypeData.Name;
  1039. var currencyData = currencyItems.Where(s => s.Id == item.Currency && s.IsDel == 0).FirstOrDefault();
  1040. if (currencyData != null) {
  1041. carCurrencyCode = currencyData.Name;
  1042. carCurrencyName = currencyData.Remark;
  1043. }
  1044. priceMsg += typeName + ":" + item.Price.ToString("#0.00") + " " + carCurrencyCode + "(" + carCurrencyName + ")<br/>" +
  1045. "明细:" + item.PriceContent + "<br/>" +
  1046. "备注:" + item.Remark + "<br/><br/>";
  1047. }
  1048. _detail.PriceMsgContent = priceMsg;
  1049. }
  1050. break;
  1051. case 80: //签证
  1052. Grp_VisaInfo visaInfo = _VisaInfos.Where(s => s.Id == entity.CId).FirstOrDefault();
  1053. if (visaInfo != null)
  1054. {
  1055. _detail.PriceNameContent = visaInfo.VisaClient;
  1056. _detail.PriceMsgContent = "备注:" + visaInfo.Remark;
  1057. }
  1058. break;
  1059. case 81: //邀请/公务活动
  1060. Grp_InvitationOfficialActivities invitationOfficialActivities = _InvitationOfficialActivities.Where(s => s.Id == entity.CId).FirstOrDefault();
  1061. if (invitationOfficialActivities != null)
  1062. {
  1063. string ioaCurrencyCode = "Unknown";
  1064. string ioaCurrencyName= "Unknown";
  1065. var currencyData = currencyItems.Where(s => s.Id == invitationOfficialActivities.Currency && s.IsDel == 0).FirstOrDefault();
  1066. if (currencyData != null)
  1067. {
  1068. ioaCurrencyCode = currencyData.Name;
  1069. ioaCurrencyName = currencyData.Remark;
  1070. }
  1071. _detail.PriceNameContent = invitationOfficialActivities.InviterArea;
  1072. _detail.PriceMsgContent = "邀请费用:" + invitationOfficialActivities.InviteCosts + " "+ ioaCurrencyCode + "("+ ioaCurrencyName+ ")<br/>" +
  1073. "活动费用:- <br/>" +
  1074. "备注:" + invitationOfficialActivities.Remark + "<br/>";
  1075. }
  1076. break;
  1077. case 82: //团组客户保险
  1078. Grp_Customers customers = _Customers.Where(s => s.Id == entity.Id && s.IsDel == 0).FirstOrDefault();
  1079. if (customers != null)
  1080. {
  1081. _detail.PriceNameContent = customers.ClientName;
  1082. _detail.PriceMsgContent = "备注:" + customers.Remark + "<br/>";
  1083. }
  1084. break;
  1085. case 85: //机票预订
  1086. Grp_AirTicketReservations jpRes = _AirTicketReservations.Where(s => s.Id == entity.CId).FirstOrDefault();
  1087. if (jpRes != null)
  1088. {
  1089. string FlightsDescription = jpRes.FlightsDescription;
  1090. string PriceDescription = jpRes.PriceDescription;
  1091. _detail.PriceMsgContent = "航班号:" + jpRes.FlightsCode + "<br/>城市A-B:" + jpRes.FlightsCity + "<br/>航班描述:" + FlightsDescription.Replace("\r\n", "<br />") + "<br/>" + "价格描述:" + PriceDescription;
  1092. _detail.PriceNameContent = "(" + jpRes.FlightsCode + ")";
  1093. }
  1094. break;
  1095. case 98://其他款项
  1096. Grp_DecreasePayments gdpRes = _DecreasePayments.Where(s => s.Id == entity.CId).FirstOrDefault();
  1097. if (gdpRes != null)
  1098. {
  1099. _detail.PriceMsgContent = "备注:" + gdpRes.Remark;
  1100. _detail.PriceNameContent = gdpRes.PriceName;
  1101. }
  1102. break;
  1103. case 285://收款退还
  1104. Fin_PaymentRefundAndOtherMoney refundAndOtherMoney = _PaymentRefundAndOtherMoneys.Where(s => s.Id == entity.CId).FirstOrDefault();
  1105. if (refundAndOtherMoney != null)
  1106. {
  1107. _detail.PriceMsgContent = "备注:" + refundAndOtherMoney.Remark;
  1108. _detail.PriceNameContent = refundAndOtherMoney.PriceName;
  1109. }
  1110. break;
  1111. case 751://酒店早餐
  1112. break;
  1113. default:
  1114. break;
  1115. }
  1116. /*
  1117. * 申请人
  1118. */
  1119. string operatorName = " - ";
  1120. Sys_Users _opUser = userItems.Where(s => s.Id == entity.CreateUserId).FirstOrDefault();
  1121. if (_opUser != null)
  1122. {
  1123. operatorName = _opUser.CnName;
  1124. }
  1125. _detail.OperatorName = operatorName;
  1126. /*
  1127. * 审核人
  1128. */
  1129. string auditOperatorName = "Unknown";
  1130. if (entity.AuditGMOperate == 0)
  1131. auditOperatorName = " - ";
  1132. else if (entity.AuditGMOperate == 4)
  1133. auditOperatorName = "自动审核";
  1134. else
  1135. {
  1136. Sys_Users _adUser = userItems.Where(s => s.Id == entity.AuditGMOperate).FirstOrDefault();
  1137. if (_adUser != null)
  1138. {
  1139. auditOperatorName = _adUser.CnName;
  1140. }
  1141. }
  1142. _detail.AuditOperatorName = auditOperatorName;
  1143. /*
  1144. * 超预算比例
  1145. */
  1146. string overBudgetStr = "";
  1147. if (entity.ExceedBudget == -1)
  1148. overBudgetStr = sdPriceName.Name + "尚无预算";
  1149. else if (entity.ExceedBudget == 0)
  1150. overBudgetStr = "未超预算";
  1151. else
  1152. overBudgetStr = entity.ExceedBudget.ToString("P");
  1153. _detail.OverBudget = overBudgetStr;
  1154. /*
  1155. * 费用总计
  1156. */
  1157. ccpCurrencyPrices.Add(new CreditCardPaymentCurrencyPriceItem()
  1158. {
  1159. CurrencyId = entity.PaymentCurrency,
  1160. CurrencyName = PaymentCurrency_WaitPay,
  1161. AmountPayable = entity.PayMoney,
  1162. ThisPayment = CurrPayStr,
  1163. BalancePayment = BalanceStr,
  1164. AuditedFunds = CurrPayStr
  1165. });
  1166. _detail.IsAuditGM = entity.IsAuditGM;
  1167. detailList.Add(_detail);
  1168. }
  1169. #endregion
  1170. _view.DetailList = new List<Grp_CreditCardPaymentDetailView>(detailList);
  1171. /*
  1172. * 下方描述处理
  1173. */
  1174. List<CreditCardPaymentCurrencyPriceItem> nonDuplicat = ccpCurrencyPrices.Where((x, i) => ccpCurrencyPrices.FindIndex(z => z.CurrencyId == x.CurrencyId) == i).ToList();//Lambda表达式去重
  1175. CreditCardPaymentCurrencyPriceItem ccpCurrencyPrice = nonDuplicat.Where(it => it.CurrencyId == 836).FirstOrDefault();
  1176. if (ccpCurrencyPrice != null)
  1177. {
  1178. int CNYIndex = nonDuplicat.IndexOf(ccpCurrencyPrice);
  1179. nonDuplicat.MoveItemAtIndexToFront(CNYIndex);
  1180. }
  1181. else
  1182. {
  1183. nonDuplicat.OrderBy(it => it.CurrencyId).ToList();
  1184. }
  1185. string amountPayableStr = string.Format(@"应付款总金额: ");
  1186. string thisPaymentStr = string.Format(@"此次付款总金额: ");
  1187. string balancePaymentStr = string.Format(@"目前剩余尾款总金额: ");
  1188. string auditedFundsStr = string.Format(@"已审费用总额: ");
  1189. foreach (var item in nonDuplicat)
  1190. {
  1191. var strs = ccpCurrencyPrices.Where(it => it.CurrencyId == item.CurrencyId).ToList();
  1192. if (strs.Count > 0)
  1193. {
  1194. decimal amountPayable = strs.Sum(it => it.AmountPayable);
  1195. decimal balancePayment = strs.Sum(it => it.BalancePayment);
  1196. amountPayableStr += string.Format(@"{0}{1}&nbsp;|", amountPayable.ToString("#0.00"), item.CurrencyName);
  1197. //单独处理此次付款金额
  1198. if (item.CurrencyId == 836) //人名币
  1199. {
  1200. decimal thisPayment = ccpCurrencyPrices.Sum(it => it.ThisPayment);
  1201. thisPaymentStr += string.Format(@"{0}{1}&nbsp;|", thisPayment.ToString("#0.00"), item.CurrencyName);
  1202. }
  1203. else
  1204. {
  1205. thisPaymentStr += string.Format(@"{0}{1}&nbsp;|","0.00", item.CurrencyName);
  1206. }
  1207. balancePaymentStr += string.Format(@"{0}{1}&nbsp;|", balancePayment.ToString("#0.00"), item.CurrencyName);
  1208. //单独处理已审核费用
  1209. if (item.CurrencyId == 836) //人名币
  1210. {
  1211. decimal auditedFunds = ccpCurrencyPrices.Sum(it => it.AuditedFunds);
  1212. auditedFundsStr += string.Format(@"{0}{1}&nbsp;|", auditedFunds.ToString("#0.00"), item.CurrencyName);
  1213. }
  1214. else
  1215. {
  1216. auditedFundsStr += string.Format(@"{0}{1}&nbsp;|", "0.00", item.CurrencyName);
  1217. }
  1218. }
  1219. }
  1220. _view.TotalStr1 = amountPayableStr.Substring(0, amountPayableStr.Length - 1);
  1221. _view.TotalStr2 = thisPaymentStr.Substring(0, thisPaymentStr.Length - 1);
  1222. _view.TotalStr3 = balancePaymentStr.Substring(0, balancePaymentStr.Length - 1);
  1223. _view.TotalStr4 = auditedFundsStr.Substring(0, auditedFundsStr.Length - 1);
  1224. var _view1 = new
  1225. {
  1226. PageFuncAuth = pageFunAuthView,
  1227. Data = _view
  1228. };
  1229. return Ok(JsonView(_view1));
  1230. }
  1231. catch (Exception ex)
  1232. {
  1233. return Ok(JsonView(false, ex.Message));
  1234. }
  1235. }
  1236. /// <summary>
  1237. /// 费用审核
  1238. /// 修改团组费用审核状态
  1239. /// </summary>
  1240. /// <param name="_dto">参数Json字符串</param>
  1241. /// <returns></returns>
  1242. [HttpPost]
  1243. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1244. public async Task<IActionResult> PostAuditGrpCreditCardPayment(Edit_GrpCreditCardPaymentDto _dto)
  1245. {
  1246. #region 参数验证
  1247. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  1248. if (_dto.PageId < 1) return Ok(JsonView(false, "页面Id为空"));
  1249. #endregion
  1250. #region 页面操作权限验证
  1251. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  1252. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  1253. if (pageFunAuthView.AuditAuth == 0) return Ok(JsonView(false, "您没有审核权限"));
  1254. #endregion
  1255. List<string> idList = _dto.CreditIdStr.Split(',').ToList();
  1256. Grp_CreditCardPayment _detail = _mapper.Map<Grp_CreditCardPayment>(_dto);
  1257. DateTime dtNow = DateTime.Now;
  1258. _groupRepository.BeginTran();
  1259. int rst = 0;
  1260. foreach (var item in idList)
  1261. {
  1262. int CreditId = int.Parse(item);
  1263. var result = await _grpScheduleRep._sqlSugar.Updateable<Grp_CreditCardPayment>()
  1264. .SetColumns(it => it.IsAuditGM == _dto.AuditCode)
  1265. .SetColumns(it => it.AuditGMOperate == _dto.UserId)
  1266. .SetColumns(it => it.AuditGMDate == dtNow.ToString("yyyy-MM-dd HH:mm:ss"))
  1267. .Where(s => s.Id == CreditId)
  1268. .ExecuteCommandAsync();
  1269. if (result < 1)
  1270. {
  1271. rst = -1;
  1272. _groupRepository.RollbackTran();
  1273. return Ok(JsonView(false, "操作失败并回滚!"));
  1274. }
  1275. else
  1276. {
  1277. }
  1278. }
  1279. _groupRepository.CommitTran();
  1280. if (rst == 0)
  1281. {
  1282. return Ok(JsonView(true, "操作成功!"));
  1283. }
  1284. return Ok(JsonView(false, "操作失败!"));
  1285. }
  1286. #endregion
  1287. #region 机票费用录入
  1288. /// <summary>
  1289. /// 机票录入当前登录人可操作团组
  1290. /// </summary>
  1291. /// <param name="dto"></param>
  1292. /// <returns></returns>
  1293. [HttpPost]
  1294. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1295. public async Task<IActionResult> AirTicketResSelect(AirTicketResDto dto)
  1296. {
  1297. try
  1298. {
  1299. Result groupData = await _airTicketResRep.AirTicketResSelect(dto);
  1300. if (groupData.Code != 0)
  1301. {
  1302. return Ok(JsonView(false, groupData.Msg));
  1303. }
  1304. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1305. }
  1306. catch (Exception ex)
  1307. {
  1308. return Ok(JsonView(false, "程序错误!"));
  1309. throw;
  1310. }
  1311. }
  1312. /// <summary>
  1313. /// 机票费用录入列表
  1314. /// </summary>
  1315. /// <param name="dto"></param>
  1316. /// <returns></returns>
  1317. [HttpPost]
  1318. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1319. public async Task<IActionResult> AirTicketResList(AirTicketResDto dto)
  1320. {
  1321. try
  1322. {
  1323. Result groupData = await _airTicketResRep.AirTicketResList(dto);
  1324. if (groupData.Code != 0)
  1325. {
  1326. return Ok(JsonView(false, groupData.Msg));
  1327. }
  1328. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1329. }
  1330. catch (Exception ex)
  1331. {
  1332. return Ok(JsonView(false, "程序错误!"));
  1333. throw;
  1334. }
  1335. }
  1336. /// <summary>
  1337. /// 根据id查询费用录入信息
  1338. /// </summary>
  1339. /// <param name="dto"></param>
  1340. /// <returns></returns>
  1341. [HttpPost]
  1342. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1343. public async Task<IActionResult> AirTicketResById(AirTicketResByIdDto dto)
  1344. {
  1345. try
  1346. {
  1347. Result groupData = await _airTicketResRep.AirTicketResById(dto);
  1348. if (groupData.Code != 0)
  1349. {
  1350. return Ok(JsonView(false, groupData.Msg));
  1351. }
  1352. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1353. }
  1354. catch (Exception ex)
  1355. {
  1356. return Ok(JsonView(false, "程序错误!"));
  1357. throw;
  1358. }
  1359. }
  1360. /// <summary>
  1361. /// 机票费用录入操作(Status:1.新增,2.修改)
  1362. /// </summary>
  1363. /// <param name="dto"></param>
  1364. /// <returns></returns>
  1365. [HttpPost]
  1366. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1367. public async Task<IActionResult> OpAirTicketRes(AirTicketResOpDto dto)
  1368. {
  1369. try
  1370. {
  1371. Result groupData = await _airTicketResRep.OpAirTicketRes(dto);
  1372. if (groupData.Code != 0)
  1373. {
  1374. return Ok(JsonView(false, groupData.Msg));
  1375. }
  1376. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  1377. }
  1378. catch (Exception ex)
  1379. {
  1380. return Ok(JsonView(false, "程序错误!"));
  1381. throw;
  1382. }
  1383. }
  1384. /// <summary>
  1385. /// 根据舱位类型查询接团客户名单信息
  1386. /// </summary>
  1387. /// <param name="dto"></param>
  1388. /// <returns></returns>
  1389. [HttpPost]
  1390. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1391. public async Task<IActionResult> tankType(AirTicketResByIdDto dto)
  1392. {
  1393. try
  1394. {
  1395. List<Crm_GroupCustomer> crm_Groups = _sqlSugar.Queryable<Crm_GroupCustomer>().Where(a => a.IsDel == 0 && a.AirType == dto.Id).ToList();
  1396. if (crm_Groups.Count != 0)
  1397. {
  1398. List<dynamic> Customer = new List<dynamic>();
  1399. foreach (var item in crm_Groups)
  1400. {
  1401. var data = new
  1402. {
  1403. Id = item.Id,
  1404. Pinyin = item.Pinyin,
  1405. Name = item.LastName + item.FirstName
  1406. };
  1407. Customer.Add(data);
  1408. }
  1409. return Ok(JsonView(true, "查询成功!", Customer));
  1410. }
  1411. return Ok(JsonView(true, "暂无数据", crm_Groups));
  1412. }
  1413. catch (Exception ex)
  1414. {
  1415. return Ok(JsonView(false, "程序错误!"));
  1416. throw;
  1417. }
  1418. }
  1419. /// <summary>
  1420. /// 机票费用录入,删除
  1421. /// </summary>
  1422. /// <param name="dto"></param>
  1423. /// <returns></returns>
  1424. [HttpPost]
  1425. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1426. public async Task<IActionResult> DelAirTicketRes(DelBaseDto dto)
  1427. {
  1428. try
  1429. {
  1430. var res = await _airTicketResRep.SoftDeleteByIdAsync<Grp_AirTicketReservations>(dto.Id.ToString(), dto.DeleteUserId);
  1431. if (!res)
  1432. {
  1433. var result = await _sqlSugar.Updateable<Grp_CreditCardPayment>().Where(a => a.CId == dto.Id && a.CTable == 85).SetColumns(a => new Grp_CreditCardPayment()
  1434. {
  1435. IsDel = 1,
  1436. DeleteUserId = dto.DeleteUserId,
  1437. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  1438. }).ExecuteCommandAsync();
  1439. return Ok(JsonView(false, "删除失败"));
  1440. }
  1441. return Ok(JsonView(true, "删除成功!"));
  1442. }
  1443. catch (Exception ex)
  1444. {
  1445. return Ok(JsonView(false, "程序错误!"));
  1446. throw;
  1447. }
  1448. }
  1449. /// <summary>
  1450. /// 导出机票录入报表
  1451. /// </summary>
  1452. /// <param name="dto"></param>
  1453. /// <returns></returns>
  1454. [HttpPost]
  1455. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1456. public async Task<IActionResult> DeriveAirTicketRes(AirTicketResDto dto)
  1457. {
  1458. try
  1459. {
  1460. Result groupData = await _airTicketResRep.DeriveAirTicketRes(dto);
  1461. if (groupData.Code != 0)
  1462. {
  1463. return Ok(JsonView(false, groupData.Msg));
  1464. }
  1465. else
  1466. {
  1467. List<AirTicketReservationsPayView> AirTicketReservations = groupData.Data.GetType().GetProperty("AirTicketRes").GetValue(groupData.Data);
  1468. if (AirTicketReservations.Count != 0)
  1469. {
  1470. Grp_DelegationInfo DelegationInfo = groupData.Data.GetType().GetProperty("Delegation").GetValue(groupData.Data);
  1471. Sys_Users _Users = groupData.Data.GetType().GetProperty("Users").GetValue(groupData.Data);
  1472. string diCode = DelegationInfo != null ? DelegationInfo.TourCode : "XXX";
  1473. string diName = DelegationInfo != null ? DelegationInfo.TeamName : "XXX";
  1474. WorkbookDesigner designer = new WorkbookDesigner();
  1475. designer.Workbook = new Workbook(AppSettingsHelper.Get("ExcelBasePath") + "Template/机票预订费用报表模板.xlsx");
  1476. decimal countCost = 0;
  1477. foreach (var item in AirTicketReservations)
  1478. {
  1479. if (item.BankType == "其他")
  1480. {
  1481. item.BankNo = "--";
  1482. }
  1483. else
  1484. {
  1485. item.BankNo = item.BankType + ":" + item.BankNo.Substring(0, 3);
  1486. }
  1487. item.PrePrice = System.Decimal.Round(item.PrePrice, 2);
  1488. item.Price = System.Decimal.Round(item.Price, 2);
  1489. countCost += Convert.ToDecimal(item.Price);
  1490. }
  1491. designer.SetDataSource("Export", AirTicketReservations);
  1492. designer.SetDataSource("ExportDiCode", diCode);
  1493. designer.SetDataSource("ExportDiName", diName);
  1494. designer.SetDataSource("ExportOpUserName", _Users.CnName);
  1495. designer.SetDataSource("ExportCountCost", countCost + "(" + AirTicketReservations[0].CurrencyStr);
  1496. designer.Process();
  1497. string fileName = "AirfareStatement/" + diName + "机票费用报表" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
  1498. designer.Workbook.Save(AppSettingsHelper.Get("ExcelBasePath") + fileName);
  1499. string rst = AppSettingsHelper.Get("ExcelBaseUrl") + AppSettingsHelper.Get("ExcelFtpPath") + fileName;
  1500. return Ok(JsonView(true, "成功", url = rst));
  1501. }
  1502. else
  1503. {
  1504. return Ok(JsonView(false, "暂无数据!"));
  1505. }
  1506. }
  1507. }
  1508. catch (Exception ex)
  1509. {
  1510. return Ok(JsonView(false, "程序错误!"));
  1511. throw;
  1512. }
  1513. }
  1514. Dictionary<string, string> transDic = new Dictionary<string, string>();
  1515. /// <summary>
  1516. /// 行程单导出
  1517. /// </summary>
  1518. /// <param name="dto"></param>
  1519. /// <returns></returns>
  1520. [HttpPost]
  1521. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  1522. public async Task<IActionResult> ItineraryAirTicketRes(ItineraryAirTicketResDto dto)
  1523. {
  1524. try
  1525. {
  1526. Result groupData = await _airTicketResRep.ItineraryAirTicketRes(dto);
  1527. if (groupData.Code != 0)
  1528. {
  1529. return Ok(JsonView(false, groupData.Msg));
  1530. }
  1531. else
  1532. {
  1533. List<AirTicketReservationsView> _AirTicketReservations = groupData.Data;
  1534. if (dto.Language == "CN")
  1535. {
  1536. Document doc = new Document(AppSettingsHelper.Get("WordBasePath") + "Template/电子客票行程单模板_CN.docx");
  1537. DocumentBuilder builder = new DocumentBuilder(doc);
  1538. int tableIndex = 0;//表格索引
  1539. //得到文档中的第一个表格
  1540. Table table = (Table)doc.GetChild(NodeType.Table, tableIndex, true);
  1541. foreach (var item in _AirTicketReservations)
  1542. {
  1543. #region 处理固定数据
  1544. string[] FlightsCode = item.FlightsCode.Split('/');
  1545. if (FlightsCode.Length != 0)
  1546. {
  1547. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1548. if (_AirCompany != null)
  1549. {
  1550. table.Range.Bookmarks["AirlineCompany"].Text = _AirCompany.CnName;
  1551. }
  1552. else
  1553. {
  1554. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  1555. }
  1556. }
  1557. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  1558. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  1559. string[] nameArray = Regex.Split(item.ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1560. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1561. string name = "";
  1562. foreach (string clientName in nameArray)
  1563. {
  1564. if (!name.Contains(clientName))
  1565. {
  1566. name += clientName + ",";
  1567. }
  1568. }
  1569. if (!string.IsNullOrWhiteSpace(name))
  1570. {
  1571. table.Range.Bookmarks["ClientName"].Text = name.Substring(0, name.Length - 1);
  1572. }
  1573. else
  1574. {
  1575. table.Range.Bookmarks["ClientName"].Text = "--";
  1576. }
  1577. table.Range.Bookmarks["TicketNumber"].Text = "--";
  1578. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  1579. table.Range.Bookmarks["JointTicket"].Text = "--";
  1580. table.Range.Bookmarks["TimeIssue"].Text = "--";
  1581. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  1582. table.Range.Bookmarks["NavigationCode"].Text = "--";
  1583. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  1584. table.Range.Bookmarks["AgentPhone"].Text = "--";
  1585. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  1586. #endregion
  1587. #region 循环数据处理
  1588. List<AirInfo> airs = new List<AirInfo>();
  1589. string[] DayArray = Regex.Split(item.FlightsDescription, "\\d+\\.", RegexOptions.IgnoreCase);
  1590. DayArray = DayArray.Where(s => s != " " && s != "" && !string.IsNullOrEmpty(s)).ToArray();
  1591. for (int i = 0; i < FlightsCode.Length; i++)
  1592. {
  1593. AirInfo air = new AirInfo();
  1594. string[] tempstr = DayArray[i]
  1595. .Replace("\r\n", string.Empty)
  1596. .Replace("\\r\\n", string.Empty)
  1597. .TrimStart().TrimEnd()
  1598. .Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1599. Res_ThreeCode star_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(0, 3));
  1600. string starCity = "";
  1601. if (star_Three != null)
  1602. {
  1603. starCity = star_Three.AirPort;
  1604. }
  1605. Res_ThreeCode End_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(3, 3));
  1606. string EndCity = "";
  1607. if (End_Three != null)
  1608. {
  1609. EndCity = End_Three.AirPort;
  1610. }
  1611. air.Destination = starCity + "/" + EndCity;
  1612. air.Flight = FlightsCode[i];
  1613. air.SeatingClass = item.CTypeName;
  1614. string dateTime = tempstr[2];
  1615. string DateTemp = dateTime.Substring(2, 5).ToUpper();
  1616. air.FlightDate = DateTemp;
  1617. air.DepartureTime = tempstr[5];
  1618. air.LandingTime = tempstr[6];
  1619. air.ValidityPeriod = DateTemp + "/" + DateTemp;
  1620. air.TicketStatus = "--";
  1621. air.Luggage = "--";
  1622. air.DepartureTerminal = "--";
  1623. air.LandingTerminal = "--";
  1624. airs.Add(air);
  1625. }
  1626. int row = 13;
  1627. for (int i = 0; i < airs.Count; i++)
  1628. {
  1629. if (airs.Count > 2)
  1630. {
  1631. for (int j = 0; j < airs.Count - 2; j++)
  1632. {
  1633. var CopyRow = table.Rows[12].Clone(true);
  1634. table.Rows.Add(CopyRow);
  1635. }
  1636. }
  1637. PropertyInfo[] properties = airs[i].GetType().GetProperties();
  1638. int index = 0;
  1639. foreach (PropertyInfo property in properties)
  1640. {
  1641. string value = property.GetValue(airs[i]).ToString();
  1642. Cell ishcel0 = table.Rows[row].Cells[index];
  1643. Paragraph p = new Paragraph(doc);
  1644. string s = value;
  1645. p.AppendChild(new Run(doc, s));
  1646. p.ParagraphFormat.Alignment = ParagraphAlignment.Center;//水平居中对齐
  1647. ishcel0.AppendChild(p);
  1648. ishcel0.CellFormat.VerticalAlignment = CellVerticalAlignment.Center;//垂直居中对齐
  1649. index++;
  1650. }
  1651. row++;
  1652. }
  1653. #endregion
  1654. Paragraph lastParagraph = new Paragraph(doc);
  1655. //第一个表格末尾加段落
  1656. table.ParentNode.InsertAfter(lastParagraph, table);
  1657. //复制第一个表格
  1658. Table cloneTable = (Table)table.Clone(true);
  1659. //在文档末尾段落后面加入复制的表格
  1660. table.ParentNode.InsertAfter(cloneTable, lastParagraph);
  1661. if (item != _AirTicketReservations[_AirTicketReservations.Count - 1])
  1662. {
  1663. int rownewsIndex = 13;
  1664. for (int i = 0; i < 2; i++)
  1665. {
  1666. var CopyRow = table.Rows[12].Clone(true);
  1667. table.Rows.RemoveAt(13);
  1668. table.Rows.Add(CopyRow);
  1669. rownewsIndex++;
  1670. }
  1671. }
  1672. else
  1673. {
  1674. table.Rows.RemoveAt(12);
  1675. }
  1676. cloneTable.Rows.RemoveAt(12);
  1677. }
  1678. if (_AirTicketReservations.Count != 0)
  1679. {
  1680. string[] FlightsCode = _AirTicketReservations[0].FlightsCode.Split('/');
  1681. if (FlightsCode.Length != 0)
  1682. {
  1683. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1684. if (_AirCompany != null)
  1685. {
  1686. table.Range.Bookmarks["AirlineCompany"].Text = _AirCompany.CnName;
  1687. }
  1688. else
  1689. {
  1690. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  1691. }
  1692. }
  1693. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  1694. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  1695. string[] nameArray = Regex.Split(_AirTicketReservations[0].ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1696. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1697. string name = "";
  1698. foreach (string clientName in nameArray)
  1699. {
  1700. if (!name.Contains(clientName))
  1701. {
  1702. name += clientName + ",";
  1703. }
  1704. }
  1705. if (!string.IsNullOrWhiteSpace(name))
  1706. {
  1707. table.Range.Bookmarks["ClientName"].Text = name.Substring(0, name.Length - 1);
  1708. }
  1709. else
  1710. {
  1711. table.Range.Bookmarks["ClientName"].Text = "--";
  1712. }
  1713. table.Range.Bookmarks["TicketNumber"].Text = "--";
  1714. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  1715. table.Range.Bookmarks["JointTicket"].Text = "--";
  1716. table.Range.Bookmarks["TimeIssue"].Text = "--";
  1717. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  1718. table.Range.Bookmarks["NavigationCode"].Text = "--";
  1719. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  1720. table.Range.Bookmarks["AgentPhone"].Text = "--";
  1721. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  1722. }
  1723. doc.MailMerge.Execute(new[] { "PageCount" }, new object[] { doc.PageCount });
  1724. //保存合并后的文档
  1725. string fileName = "AirItinerary/电子客票中文行程单_CN.docx";
  1726. string rst = AppSettingsHelper.Get("WordBaseUrl") + AppSettingsHelper.Get("WordFtpPath") + fileName;
  1727. doc.Save(AppSettingsHelper.Get("WordBasePath") + fileName);
  1728. return Ok(JsonView(true, "成功!", rst));
  1729. }
  1730. else
  1731. {
  1732. Document doc = new Document(AppSettingsHelper.Get("WordBasePath") + "Template/电子客票行程单模板_EN.docx");
  1733. DocumentBuilder builder = new DocumentBuilder(doc);
  1734. int tableIndex = 0;//表格索引
  1735. //得到文档中的第一个表格
  1736. Table table = (Table)doc.GetChild(NodeType.Table, tableIndex, true);
  1737. List<string> texts = new List<string>();
  1738. foreach (var item in _AirTicketReservations)
  1739. {
  1740. string[] FlightsCode = item.FlightsCode.Split('/');
  1741. if (FlightsCode.Length != 0)
  1742. {
  1743. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1744. if (_AirCompany != null)
  1745. {
  1746. if (!transDic.ContainsKey(_AirCompany.CnName))
  1747. {
  1748. transDic.Add(_AirCompany.CnName, _AirCompany.EnName);
  1749. }
  1750. }
  1751. else
  1752. {
  1753. if (!transDic.ContainsKey("--"))
  1754. {
  1755. transDic.Add("--", "--");
  1756. }
  1757. }
  1758. }
  1759. string[] nameArray = Regex.Split(item.ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1760. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1761. string name = "";
  1762. foreach (string clientName in nameArray)
  1763. {
  1764. name += clientName + ",";
  1765. }
  1766. if (!texts.Contains(name))
  1767. {
  1768. texts.Add(name);
  1769. }
  1770. List<AirInfo> airs = new List<AirInfo>();
  1771. string[] DayArray = Regex.Split(item.FlightsDescription, "\\d+\\.", RegexOptions.IgnoreCase);
  1772. DayArray = DayArray.Where(s => s != " " && s != "" && !string.IsNullOrEmpty(s)).ToArray();
  1773. for (int i = 0; i < FlightsCode.Length; i++)
  1774. {
  1775. AirInfo air = new AirInfo();
  1776. string[] tempstr = DayArray[i]
  1777. .Replace("\r\n", string.Empty)
  1778. .Replace("\\r\\n", string.Empty)
  1779. .TrimStart().TrimEnd()
  1780. .Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1781. Res_ThreeCode star_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(0, 3));
  1782. if (star_Three != null)
  1783. {
  1784. if (!transDic.ContainsKey(star_Three.AirPort))
  1785. {
  1786. transDic.Add(star_Three.AirPort, star_Three.AirPort_En);
  1787. }
  1788. }
  1789. Res_ThreeCode End_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(3, 3));
  1790. if (End_Three != null)
  1791. {
  1792. if (!transDic.ContainsKey(End_Three.AirPort))
  1793. {
  1794. transDic.Add(End_Three.AirPort, End_Three.AirPort_En);
  1795. }
  1796. }
  1797. if (!texts.Contains(item.CTypeName))
  1798. {
  1799. texts.Add(item.CTypeName);
  1800. }
  1801. }
  1802. }
  1803. List<TranslateResult> transData = _airTicketResRep.ReTransBatch(texts, "en");
  1804. if (transData.Count > 0)
  1805. {
  1806. foreach (TranslateResult item in transData)
  1807. {
  1808. if (!transDic.ContainsKey(item.Query))
  1809. {
  1810. transDic.Add(item.Query, item.Translation);
  1811. }
  1812. }
  1813. }
  1814. foreach (var item in _AirTicketReservations)
  1815. {
  1816. #region 处理固定数据
  1817. string[] FlightsCode = item.FlightsCode.Split('/');
  1818. if (FlightsCode.Length != 0)
  1819. {
  1820. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1821. if (_AirCompany != null)
  1822. {
  1823. string str = "--";
  1824. string translateResult = transDic.Where(s => s.Key == _AirCompany.CnName).FirstOrDefault().Value;
  1825. if (!string.IsNullOrEmpty(translateResult))
  1826. {
  1827. str = translateResult;
  1828. str = _airTicketResRep.Processing(str);
  1829. }
  1830. table.Range.Bookmarks["AirlineCompany"].Text = str;
  1831. }
  1832. else
  1833. {
  1834. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  1835. }
  1836. }
  1837. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  1838. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  1839. string[] nameArray = Regex.Split(item.ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  1840. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  1841. string names = "";
  1842. foreach (string clientName in nameArray)
  1843. {
  1844. names += clientName + ",";
  1845. }
  1846. if (!string.IsNullOrWhiteSpace(names))
  1847. {
  1848. string str = "--";
  1849. string translateResult = transDic.Where(s => s.Key == names).FirstOrDefault().Value;
  1850. if (!string.IsNullOrEmpty(translateResult))
  1851. {
  1852. str = translateResult;
  1853. str = _airTicketResRep.Processing(str);
  1854. }
  1855. table.Range.Bookmarks["ClientName"].Text = str;
  1856. }
  1857. else
  1858. {
  1859. table.Range.Bookmarks["ClientName"].Text = "--";
  1860. }
  1861. table.Range.Bookmarks["TicketNumber"].Text = "--";
  1862. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  1863. table.Range.Bookmarks["JointTicket"].Text = "--";
  1864. table.Range.Bookmarks["TimeIssue"].Text = "--";
  1865. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  1866. table.Range.Bookmarks["NavigationCode"].Text = "--";
  1867. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  1868. table.Range.Bookmarks["AgentPhone"].Text = "--";
  1869. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  1870. #endregion
  1871. #region 循环数据处理
  1872. List<AirInfo> airs = new List<AirInfo>();
  1873. string[] DayArray = Regex.Split(item.FlightsDescription, "\\d+\\.", RegexOptions.IgnoreCase);
  1874. DayArray = DayArray.Where(s => s != " " && s != "" && !string.IsNullOrEmpty(s)).ToArray();
  1875. for (int i = 0; i < FlightsCode.Length; i++)
  1876. {
  1877. AirInfo air = new AirInfo();
  1878. string[] tempstr = DayArray[i]
  1879. .Replace("\r\n", string.Empty)
  1880. .Replace("\\r\\n", string.Empty)
  1881. .TrimStart().TrimEnd()
  1882. .Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
  1883. Res_ThreeCode star_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(0, 3));
  1884. string starCity = "";
  1885. if (star_Three != null)
  1886. {
  1887. string str2 = "--";
  1888. string translateResult2 = transDic.Where(s => s.Key == star_Three.AirPort).FirstOrDefault().Value;
  1889. if (!string.IsNullOrEmpty(translateResult2))
  1890. {
  1891. str2 = translateResult2;
  1892. str2 = _airTicketResRep.Processing(str2);
  1893. }
  1894. starCity = str2;
  1895. }
  1896. Res_ThreeCode End_Three = _sqlSugar.Queryable<Res_ThreeCode>().First(a => a.Three == tempstr[3].Substring(3, 3));
  1897. string EndCity = "";
  1898. if (End_Three != null)
  1899. {
  1900. string str1 = "--";
  1901. string translateResult1 = transDic.Where(s => s.Key == End_Three.AirPort).FirstOrDefault().Value;
  1902. if (!string.IsNullOrEmpty(translateResult1))
  1903. {
  1904. str1 = translateResult1;
  1905. str1 = _airTicketResRep.Processing(str1);
  1906. }
  1907. EndCity = str1;
  1908. }
  1909. air.Destination = starCity + "/" + EndCity;
  1910. air.Flight = FlightsCode[i];
  1911. string str = "--";
  1912. string translateResult = transDic.Where(s => s.Key == item.CTypeName).FirstOrDefault().Value;
  1913. if (!string.IsNullOrEmpty(translateResult))
  1914. {
  1915. str = translateResult;
  1916. str = _airTicketResRep.Processing(str);
  1917. }
  1918. air.SeatingClass = str;
  1919. string dateTime = tempstr[2];
  1920. string DateTemp = dateTime.Substring(2, 5).ToUpper();
  1921. air.FlightDate = DateTemp;
  1922. air.DepartureTime = tempstr[5];
  1923. air.LandingTime = tempstr[6];
  1924. air.ValidityPeriod = DateTemp + "/" + DateTemp;
  1925. air.TicketStatus = "--";
  1926. air.Luggage = "--";
  1927. air.DepartureTerminal = "--";
  1928. air.LandingTerminal = "--";
  1929. airs.Add(air);
  1930. }
  1931. int row = 13;
  1932. for (int i = 0; i < airs.Count; i++)
  1933. {
  1934. if (airs.Count > 2)
  1935. {
  1936. for (int j = 0; j < airs.Count - 2; j++)
  1937. {
  1938. var CopyRow = table.Rows[12].Clone(true);
  1939. table.Rows.Add(CopyRow);
  1940. }
  1941. }
  1942. PropertyInfo[] properties = airs[i].GetType().GetProperties();
  1943. int index = 0;
  1944. foreach (PropertyInfo property in properties)
  1945. {
  1946. string value = property.GetValue(airs[i]).ToString();
  1947. Cell ishcel0 = table.Rows[row].Cells[index];
  1948. Paragraph p = new Paragraph(doc);
  1949. string s = value;
  1950. p.AppendChild(new Run(doc, s));
  1951. p.ParagraphFormat.Alignment = ParagraphAlignment.Center;//水平居中对齐
  1952. ishcel0.AppendChild(p);
  1953. ishcel0.CellFormat.VerticalAlignment = CellVerticalAlignment.Center;//垂直居中对齐
  1954. //ishcel0.CellFormat.VerticalAlignment=
  1955. index++;
  1956. }
  1957. row++;
  1958. }
  1959. #endregion
  1960. Paragraph lastParagraph = new Paragraph(doc);
  1961. //第一个表格末尾加段落
  1962. table.ParentNode.InsertAfter(lastParagraph, table);
  1963. //复制第一个表格
  1964. Table cloneTable = (Table)table.Clone(true);
  1965. //在文档末尾段落后面加入复制的表格
  1966. table.ParentNode.InsertAfter(cloneTable, lastParagraph);
  1967. if (item != _AirTicketReservations[_AirTicketReservations.Count - 1])
  1968. {
  1969. int rownewsIndex = 13;
  1970. for (int i = 0; i < 2; i++)
  1971. {
  1972. var CopyRow = table.Rows[12].Clone(true);
  1973. table.Rows.RemoveAt(13);
  1974. table.Rows.Add(CopyRow);
  1975. rownewsIndex++;
  1976. }
  1977. }
  1978. else
  1979. {
  1980. table.Rows.RemoveAt(12);
  1981. }
  1982. cloneTable.Rows.RemoveAt(12);
  1983. }
  1984. if (_AirTicketReservations.Count != 0)
  1985. {
  1986. string[] FlightsCode = _AirTicketReservations[0].FlightsCode.Split('/');
  1987. if (FlightsCode.Length != 0)
  1988. {
  1989. Res_AirCompany _AirCompany = _sqlSugar.Queryable<Res_AirCompany>().First(a => a.ShortCode == FlightsCode[0].Substring(0, 2));
  1990. if (_AirCompany != null)
  1991. {
  1992. string str = "--";
  1993. string translateResult = transDic.Where(s => s.Key == _AirCompany.CnName).FirstOrDefault().Value;
  1994. if (!string.IsNullOrEmpty(translateResult))
  1995. {
  1996. str = translateResult;
  1997. str = _airTicketResRep.Processing(str);
  1998. }
  1999. table.Range.Bookmarks["AirlineCompany"].Text = str;
  2000. }
  2001. else
  2002. {
  2003. table.Range.Bookmarks["AirlineCompany"].Text = "--";
  2004. }
  2005. }
  2006. table.Range.Bookmarks["AirlineRecordCode"].Text = "--";
  2007. table.Range.Bookmarks["ReservationRecordCode"].Text = "--";
  2008. string[] nameArray = Regex.Split(_AirTicketReservations[0].ClientName, "\\d+\\.", RegexOptions.IgnoreCase);
  2009. nameArray = nameArray.Where(str => str != "" && str != " " && !string.IsNullOrEmpty(str)).ToArray();
  2010. string names = "";
  2011. foreach (string clientName in nameArray)
  2012. {
  2013. names += clientName + ",";
  2014. }
  2015. if (!string.IsNullOrWhiteSpace(names))
  2016. {
  2017. string str = "--";
  2018. string translateResult = transDic.Where(s => s.Key == names).FirstOrDefault().Value;
  2019. if (!string.IsNullOrEmpty(translateResult))
  2020. {
  2021. str = translateResult;
  2022. str = _airTicketResRep.Processing(str);
  2023. }
  2024. table.Range.Bookmarks["ClientName"].Text = str;
  2025. }
  2026. else
  2027. {
  2028. table.Range.Bookmarks["ClientName"].Text = "--";
  2029. }
  2030. table.Range.Bookmarks["TicketNumber"].Text = "--";
  2031. table.Range.Bookmarks["IdentificationCode"].Text = "--";
  2032. table.Range.Bookmarks["JointTicket"].Text = "--";
  2033. table.Range.Bookmarks["TimeIssue"].Text = "--";
  2034. table.Range.Bookmarks["DrawingAgent"].Text = "--";
  2035. table.Range.Bookmarks["NavigationCode"].Text = "--";
  2036. table.Range.Bookmarks["AgentsAddress"].Text = "--";
  2037. table.Range.Bookmarks["AgentPhone"].Text = "--";
  2038. table.Range.Bookmarks["AgentFacsimile"].Text = "--";
  2039. }
  2040. doc.MailMerge.Execute(new[] { "PageCount" }, new object[] { doc.PageCount });
  2041. //保存合并后的文档
  2042. string fileName = "AirItinerary/电子客票英文行程单_EN.docx";
  2043. string rst = AppSettingsHelper.Get("WordBaseUrl") + AppSettingsHelper.Get("WordFtpPath") + fileName;
  2044. doc.Save(AppSettingsHelper.Get("WordBasePath") + fileName);
  2045. return Ok(JsonView(true, "成功!", rst));
  2046. }
  2047. }
  2048. }
  2049. catch (Exception ex)
  2050. {
  2051. return Ok(JsonView(false, "程序错误!"));
  2052. throw;
  2053. }
  2054. }
  2055. #endregion
  2056. #region 团组增减款项
  2057. /// <summary>
  2058. /// 团组增减款项下拉框绑定
  2059. /// </summary>
  2060. /// <param name="dto"></param>
  2061. /// <returns></returns>
  2062. [HttpPost]
  2063. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2064. public async Task<IActionResult> DecreasePaymentsSelect(DecreasePaymentsDto dto)
  2065. {
  2066. try
  2067. {
  2068. Result groupData = await _decreasePaymentsRep.DecreasePaymentsSelect(dto);
  2069. if (groupData.Code != 0)
  2070. {
  2071. return Ok(JsonView(false, groupData.Msg));
  2072. }
  2073. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2074. }
  2075. catch (Exception ex)
  2076. {
  2077. return Ok(JsonView(false, "程序错误!"));
  2078. throw;
  2079. }
  2080. }
  2081. /// <summary>
  2082. /// 根据团组Id查询团组增减款项
  2083. /// </summary>
  2084. /// <param name="dto"></param>
  2085. /// <returns></returns>
  2086. [HttpPost]
  2087. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2088. public async Task<IActionResult> DecreasePaymentsList(DecreasePaymentsListDto dto)
  2089. {
  2090. try
  2091. {
  2092. Result groupData = await _decreasePaymentsRep.DecreasePaymentsList(dto);
  2093. if (groupData.Code != 0)
  2094. {
  2095. return Ok(JsonView(false, groupData.Msg));
  2096. }
  2097. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2098. }
  2099. catch (Exception ex)
  2100. {
  2101. return Ok(JsonView(false, "程序错误!"));
  2102. throw;
  2103. }
  2104. }
  2105. /// <summary>
  2106. /// 团组增减款项操作(Status:1.新增,2.修改)
  2107. /// </summary>
  2108. /// <param name="dto"></param>
  2109. /// <returns></returns>
  2110. [HttpPost]
  2111. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2112. public async Task<IActionResult> OpDecreasePayments(DecreasePaymentsOpDto dto)
  2113. {
  2114. try
  2115. {
  2116. Result groupData = await _decreasePaymentsRep.OpDecreasePayments(dto);
  2117. if (groupData.Code != 0)
  2118. {
  2119. return Ok(JsonView(false, groupData.Msg));
  2120. }
  2121. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2122. }
  2123. catch (Exception ex)
  2124. {
  2125. return Ok(JsonView(false, "程序错误!"));
  2126. throw;
  2127. }
  2128. }
  2129. /// <summary>
  2130. /// 团组增减款项操作 删除
  2131. /// </summary>
  2132. /// <param name="dto"></param>
  2133. /// <returns></returns>
  2134. [HttpPost]
  2135. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2136. public async Task<IActionResult> DelDecreasePayments(DelBaseDto dto)
  2137. {
  2138. try
  2139. {
  2140. var res = await _decreasePaymentsRep.SoftDeleteByIdAsync<Grp_DecreasePayments>(dto.Id.ToString(), dto.DeleteUserId);
  2141. if (!res)
  2142. {
  2143. var result = await _sqlSugar.Updateable<Grp_CreditCardPayment>().Where(a => a.CId == dto.Id && a.CTable == 98).SetColumns(a => new Grp_CreditCardPayment()
  2144. {
  2145. IsDel = 1,
  2146. DeleteUserId = dto.DeleteUserId,
  2147. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  2148. }).ExecuteCommandAsync();
  2149. return Ok(JsonView(false, "删除失败"));
  2150. }
  2151. return Ok(JsonView(true, "删除成功!"));
  2152. }
  2153. catch (Exception ex)
  2154. {
  2155. return Ok(JsonView(false, "程序错误!"));
  2156. throw;
  2157. }
  2158. }
  2159. /// <summary>
  2160. /// 根据团组增减款项Id查询
  2161. /// </summary>
  2162. /// <param name="dto"></param>
  2163. /// <returns></returns>
  2164. [HttpPost]
  2165. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2166. public async Task<IActionResult> QueryDecreasePaymentsById(DecreasePaymentsByIdDto dto)
  2167. {
  2168. try
  2169. {
  2170. Result groupData = await _decreasePaymentsRep.QueryDecreasePaymentsById(dto);
  2171. if (groupData.Code != 0)
  2172. {
  2173. return Ok(JsonView(false, groupData.Msg));
  2174. }
  2175. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2176. }
  2177. catch (Exception ex)
  2178. {
  2179. return Ok(JsonView(false, "程序错误!"));
  2180. throw;
  2181. }
  2182. }
  2183. #endregion
  2184. #region 文件上传、删除
  2185. /// <summary>
  2186. /// region 文件上传 可以带参数
  2187. /// </summary>
  2188. /// <param name="file"></param>
  2189. /// <returns></returns>
  2190. [HttpPost]
  2191. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2192. public async Task<IActionResult> UploadProject(IFormFile file)
  2193. {
  2194. try
  2195. {
  2196. var TypeName = Request.Headers["TypeName"].ToString();
  2197. if (file != null)
  2198. {
  2199. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  2200. //文件名称
  2201. string projectFileName = file.FileName;
  2202. //上传的文件的路径
  2203. string filePath = "";
  2204. if (TypeName == "A")//A代表团组增减款项
  2205. {
  2206. if (!Directory.Exists(fileDir))
  2207. {
  2208. Directory.CreateDirectory(fileDir);
  2209. }
  2210. //上传的文件的路径
  2211. filePath = fileDir + $@"\团组增减款项相关文件\{projectFileName}";
  2212. }
  2213. else if (TypeName == "B")//B代表商邀相关文件
  2214. {
  2215. if (!Directory.Exists(fileDir))
  2216. {
  2217. Directory.CreateDirectory(fileDir);
  2218. }
  2219. //上传的文件的路径
  2220. filePath = fileDir + $@"\商邀相关文件\{projectFileName}";
  2221. }
  2222. using (FileStream fs = System.IO.File.Create(filePath))
  2223. {
  2224. file.CopyTo(fs);
  2225. fs.Flush();
  2226. }
  2227. return Ok(JsonView(true, "上传成功!", projectFileName));
  2228. }
  2229. else
  2230. {
  2231. return Ok(JsonView(false, "上传失败!"));
  2232. }
  2233. }
  2234. catch (Exception ex)
  2235. {
  2236. return Ok(JsonView(false, "程序错误!"));
  2237. throw;
  2238. }
  2239. }
  2240. /// <summary>
  2241. /// 删除指定文件
  2242. /// </summary>
  2243. /// <param name="dto"></param>
  2244. /// <returns></returns>
  2245. [HttpPost]
  2246. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2247. public async Task<IActionResult> DelFile(DelFileDto dto)
  2248. {
  2249. try
  2250. {
  2251. var TypeName = Request.Headers["TypeName"].ToString();
  2252. string filePath = "";
  2253. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  2254. // 返回与指定虚拟路径相对应的物理路径即绝对路径
  2255. int id = 0;
  2256. if (TypeName == "A")
  2257. {
  2258. filePath = fileDir + "/团组增减款项相关文件/" + dto.fileName;
  2259. // 删除该文件
  2260. System.IO.File.Delete(filePath);
  2261. id = await _sqlSugar.Updateable<Grp_DecreasePayments>().Where(a => a.Id == dto.Id).SetColumns(a => new Grp_DecreasePayments { FilePath = "" }).ExecuteCommandAsync();
  2262. }
  2263. else if (TypeName == "B")
  2264. {
  2265. filePath = fileDir + "/商邀相关文件/" + dto.fileName;
  2266. // 删除该文件
  2267. System.IO.File.Delete(filePath);
  2268. id = await _sqlSugar.Updateable<Grp_InvitationOfficialActivities>().Where(a => a.Id == dto.Id).SetColumns(a => new Grp_InvitationOfficialActivities { Attachment = "" }).ExecuteCommandAsync();
  2269. }
  2270. if (id != 0)
  2271. {
  2272. return Ok(JsonView(true, "成功!"));
  2273. }
  2274. else
  2275. {
  2276. return Ok(JsonView(false, "失败!"));
  2277. }
  2278. }
  2279. catch (Exception ex)
  2280. {
  2281. return Ok(JsonView(false, "程序错误!"));
  2282. throw;
  2283. }
  2284. }
  2285. #endregion
  2286. #region 商邀费用录入
  2287. /// <summary>
  2288. /// 根据团组Id查询商邀费用列表
  2289. /// </summary>
  2290. /// <param name="dto"></param>
  2291. /// <returns></returns>
  2292. [HttpPost]
  2293. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2294. public async Task<IActionResult> InvitationOfficialActivitiesList(InvitationOfficialActivitiesListDto dto)
  2295. {
  2296. try
  2297. {
  2298. Result groupData = await _InvitationOfficialActivitiesRep.InvitationOfficialActivitiesList(dto);
  2299. if (groupData.Code != 0)
  2300. {
  2301. return Ok(JsonView(false, groupData.Msg));
  2302. }
  2303. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2304. }
  2305. catch (Exception ex)
  2306. {
  2307. return Ok(JsonView(false, "程序错误!"));
  2308. throw;
  2309. }
  2310. }
  2311. /// <summary>
  2312. /// 根据商邀费用ID查询C表和商邀费用数据
  2313. /// </summary>
  2314. /// <param name="dto"></param>
  2315. /// <returns></returns>
  2316. [HttpPost]
  2317. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2318. public async Task<IActionResult> InvitationOfficialActivitiesById(InvitationOfficialActivitiesByIdDto dto)
  2319. {
  2320. try
  2321. {
  2322. Result groupData = await _InvitationOfficialActivitiesRep.InvitationOfficialActivitiesById(dto);
  2323. if (groupData.Code != 0)
  2324. {
  2325. return Ok(JsonView(false, groupData.Msg));
  2326. }
  2327. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2328. }
  2329. catch (Exception ex)
  2330. {
  2331. return Ok(JsonView(false, "程序错误!"));
  2332. throw;
  2333. }
  2334. }
  2335. /// <summary>
  2336. /// 商邀费用录入操作(Status:1.新增,2.修改)
  2337. /// </summary>
  2338. /// <param name="dto"></param>
  2339. /// <returns></returns>
  2340. [HttpPost]
  2341. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2342. public async Task<IActionResult> OpInvitationOfficialActivities(OpInvitationOfficialActivitiesDto dto)
  2343. {
  2344. try
  2345. {
  2346. Result groupData = await _InvitationOfficialActivitiesRep.OpInvitationOfficialActivities(dto);
  2347. if (groupData.Code != 0)
  2348. {
  2349. return Ok(JsonView(false, groupData.Msg));
  2350. }
  2351. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2352. }
  2353. catch (Exception ex)
  2354. {
  2355. return Ok(JsonView(false, "程序错误!"));
  2356. throw;
  2357. }
  2358. }
  2359. /// <summary>
  2360. /// 商邀删除
  2361. /// </summary>
  2362. /// <param name="dto"></param>
  2363. /// <returns></returns>
  2364. [HttpPost]
  2365. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2366. public async Task<IActionResult> DelInvitationOfficialActivities(DelBaseDto dto)
  2367. {
  2368. try
  2369. {
  2370. var res = await _InvitationOfficialActivitiesRep.SoftDeleteByIdAsync<Grp_InvitationOfficialActivities>(dto.Id.ToString(), dto.DeleteUserId);
  2371. if (!res)
  2372. {
  2373. var result = await _sqlSugar.Updateable<Grp_CreditCardPayment>().Where(a => a.CId == dto.Id && a.CTable == 81).SetColumns(a => new Grp_CreditCardPayment()
  2374. {
  2375. IsDel = 1,
  2376. DeleteUserId = dto.DeleteUserId,
  2377. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  2378. }).ExecuteCommandAsync();
  2379. return Ok(JsonView(false, "删除失败"));
  2380. }
  2381. return Ok(JsonView(true, "删除成功!"));
  2382. }
  2383. catch (Exception ex)
  2384. {
  2385. return Ok(JsonView(false, "程序错误!"));
  2386. throw;
  2387. }
  2388. }
  2389. #endregion
  2390. #region 团组英文资料
  2391. /// <summary>
  2392. /// 查询团组英文所有资料
  2393. /// </summary>
  2394. /// <param name="dto"></param>
  2395. /// <returns></returns>
  2396. [HttpPost]
  2397. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2398. public async Task<IActionResult> QueryDelegationEnData(QueryDelegationEnDataDto dto)
  2399. {
  2400. try
  2401. {
  2402. Result groupData = await _delegationEnDataRep.QueryDelegationEnData(dto);
  2403. if (groupData.Code != 0)
  2404. {
  2405. return Ok(JsonView(false, groupData.Msg));
  2406. }
  2407. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2408. }
  2409. catch (Exception ex)
  2410. {
  2411. return Ok(JsonView(false, "程序错误!"));
  2412. throw;
  2413. }
  2414. }
  2415. /// <summary>
  2416. /// 团组英文资料操作(Status:1.新增,2.修改)
  2417. /// </summary>
  2418. /// <param name="dto"></param>
  2419. /// <returns></returns>
  2420. [HttpPost]
  2421. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2422. public async Task<IActionResult> OpDelegationEnData(OpDelegationEnDataDto dto)
  2423. {
  2424. try
  2425. {
  2426. Result groupData = await _delegationEnDataRep.OpDelegationEnData(dto);
  2427. if (groupData.Code != 0)
  2428. {
  2429. return Ok(JsonView(false, groupData.Msg));
  2430. }
  2431. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  2432. }
  2433. catch (Exception ex)
  2434. {
  2435. return Ok(JsonView(false, "程序错误!"));
  2436. throw;
  2437. }
  2438. }
  2439. /// <summary>
  2440. /// 团组英文资料Id查询数据
  2441. /// </summary>
  2442. /// <param name="dto"></param>
  2443. /// <returns></returns>
  2444. [HttpPost]
  2445. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2446. public async Task<IActionResult> QueryDelegationEnDataById(QueryDelegationEnDataByIdDto dto)
  2447. {
  2448. try
  2449. {
  2450. Grp_DelegationEnData _DelegationEnData = await _sqlSugar.Queryable<Grp_DelegationEnData>().FirstAsync(it => it.Id == dto.Id && it.IsDel == 0);
  2451. if (_DelegationEnData != null)
  2452. {
  2453. return Ok(JsonView(true, "查询成功!", _DelegationEnData));
  2454. }
  2455. return Ok(JsonView(true, "暂无数据!", _DelegationEnData));
  2456. }
  2457. catch (Exception ex)
  2458. {
  2459. return Ok(JsonView(false, "程序错误!"));
  2460. throw;
  2461. }
  2462. }
  2463. /// <summary>
  2464. /// 团组英文资料删除
  2465. /// </summary>
  2466. /// <param name="dto"></param>
  2467. /// <returns></returns>
  2468. [HttpPost]
  2469. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2470. public async Task<IActionResult> DelDelegationEnData(DelBaseDto dto)
  2471. {
  2472. try
  2473. {
  2474. var res = await _delegationEnDataRep.SoftDeleteByIdAsync<Grp_DelegationEnData>(dto.Id.ToString(), dto.DeleteUserId);
  2475. if (!res)
  2476. {
  2477. return Ok(JsonView(false, "删除失败"));
  2478. }
  2479. return Ok(JsonView(true, "删除成功!"));
  2480. }
  2481. catch (Exception ex)
  2482. {
  2483. return Ok(JsonView(false, "程序错误!"));
  2484. throw;
  2485. }
  2486. }
  2487. #endregion
  2488. #region 导出邀请函
  2489. /// <summary>
  2490. /// 导出邀请函页面初始化
  2491. /// </summary>
  2492. /// <param name="dto"></param>
  2493. /// <returns></returns>
  2494. [HttpPost]
  2495. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2496. public async Task<IActionResult> QueryinvitationLetter(DecreasePaymentsListDto dto)
  2497. {
  2498. try
  2499. {
  2500. List<Grp_DelegationInfo> grp_Delegations = await _sqlSugar.Queryable<Grp_DelegationInfo>().Where(a => a.IsDel == 0).OrderBy(a => a.Id, OrderByType.Desc).ToListAsync();
  2501. List<Crm_DeleClient> crm_Deles = new List<Crm_DeleClient>();
  2502. if (dto.DiId == 0)
  2503. {
  2504. crm_Deles = await _sqlSugar.Queryable<Crm_DeleClient>().Where(a => a.DiId == grp_Delegations[0].Id && a.IsDel == 0).ToListAsync();
  2505. }
  2506. else
  2507. {
  2508. crm_Deles = await _sqlSugar.Queryable<Crm_DeleClient>().Where(a => a.DiId == dto.DiId && a.IsDel == 0).ToListAsync();
  2509. }
  2510. return Ok(JsonView(true, "查询成功!", new
  2511. {
  2512. deleClient = crm_Deles,
  2513. delegations = grp_Delegations
  2514. }));
  2515. }
  2516. catch (Exception ex)
  2517. {
  2518. return Ok(JsonView(false, "程序错误!"));
  2519. throw;
  2520. }
  2521. }
  2522. /// <summary>
  2523. /// 导出邀请函
  2524. /// </summary>
  2525. /// <param name="dto"></param>
  2526. /// <returns></returns>
  2527. [HttpPost]
  2528. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2529. public async Task<IActionResult> invitationLetter(DecreasePaymentsListDto dto)
  2530. {
  2531. try
  2532. {
  2533. Dictionary<string, string> transDic = new Dictionary<string, string>();
  2534. List<Crm_DeleClient> crm_DeleClients = await _sqlSugar.Queryable<Crm_DeleClient>().Where(a => a.DiId == dto.DiId && a.IsDel == 0).ToListAsync();
  2535. List<string> texts = new List<string>();
  2536. if (crm_DeleClients.Count != 0)
  2537. {
  2538. foreach (Crm_DeleClient item in crm_DeleClients)
  2539. {
  2540. if (!string.IsNullOrWhiteSpace(item.Pinyin))
  2541. {
  2542. transDic.Add(item.LastName + item.FirstName, item.Pinyin);
  2543. }
  2544. else
  2545. {
  2546. string name = item.LastName + item.FirstName;
  2547. texts.Add(name);
  2548. }
  2549. if (!string.IsNullOrEmpty(item.Job) && !texts.Contains(item.Job))
  2550. {
  2551. if (!transDic.ContainsKey(item.Job))
  2552. {
  2553. texts.Add(item.Job);
  2554. }
  2555. }
  2556. if (item.CrmCompanyId != 0)
  2557. {
  2558. Crm_CustomerCompany crm_Customer = await _sqlSugar.Queryable<Crm_CustomerCompany>().FirstAsync(a => a.Id == item.CrmCompanyId && a.IsDel == 0);
  2559. if (!transDic.ContainsKey(crm_Customer.CompanyFullName))
  2560. {
  2561. texts.Add(crm_Customer.CompanyFullName);
  2562. }
  2563. }
  2564. }
  2565. List<TranslateResult> transData = _airTicketResRep.ReTransBatch(texts, "en");
  2566. if (transData.Count > 0)
  2567. {
  2568. foreach (TranslateResult item in transData)
  2569. {
  2570. if (!transDic.ContainsKey(item.Query))
  2571. {
  2572. transDic.Add(item.Query, item.Translation);
  2573. }
  2574. }
  2575. }
  2576. List<guestList> list = new List<guestList>();
  2577. foreach (Crm_DeleClient dele in crm_DeleClients)
  2578. {
  2579. guestList guestList = new guestList();
  2580. if (!string.IsNullOrWhiteSpace(dele.Pinyin))
  2581. {
  2582. guestList.Name = dele.Pinyin;
  2583. }
  2584. else
  2585. {
  2586. string Name = transDic.Where(s => s.Key == dele.LastName + dele.FirstName).FirstOrDefault().Value;
  2587. guestList.Name = Name;
  2588. }
  2589. if (dele.Sex == 0)
  2590. {
  2591. guestList.Sex = "Male";
  2592. }
  2593. else if (dele.Sex == 1)
  2594. {
  2595. guestList.Sex = "Female";
  2596. }
  2597. guestList.DOB = dele.BirthDay.Replace('-', '.');
  2598. Crm_CustomerCompany crm_Customer = await _sqlSugar.Queryable<Crm_CustomerCompany>().FirstAsync(a => a.Id == dele.CrmCompanyId && a.IsDel == 0);
  2599. string jobName = transDic.Where(s => s.Key == crm_Customer.CompanyFullName).FirstOrDefault().Value + " " + transDic.Where(s => s.Key == dele.Job).FirstOrDefault().Value;
  2600. guestList.Job = jobName;
  2601. list.Add(guestList);
  2602. }
  2603. //载入模板
  2604. Document doc = new Document(AppSettingsHelper.Get("WordBasePath") + "Template/邀请函模板0210.docx");
  2605. DocumentBuilder builder = new DocumentBuilder(doc);
  2606. //获取word里所有表格
  2607. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  2608. //获取所填表格的序数
  2609. Aspose.Words.Tables.Table tableOne = allTables[0] as Aspose.Words.Tables.Table;
  2610. var rowStart = tableOne.Rows[0]; //获取第1行
  2611. //循环赋值
  2612. for (int i = 0; i < list.Count; i++)
  2613. {
  2614. builder.MoveToCell(0, i + 1, 0, 0);
  2615. builder.Write(list[i].Name.ToString());
  2616. builder.MoveToCell(0, i + 1, 1, 0);
  2617. builder.Write(list[i].Sex.ToString());
  2618. builder.MoveToCell(0, i + 1, 2, 0);
  2619. builder.Write(list[i].DOB.ToString());
  2620. builder.MoveToCell(0, i + 1, 3, 0);
  2621. builder.Write(list[i].Job.ToString());
  2622. }
  2623. //删除多余行
  2624. while (tableOne.Rows.Count > list.Count + 1)
  2625. {
  2626. tableOne.Rows.RemoveAt(list.Count + 1);
  2627. }
  2628. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  2629. string fileName = "邀请函" + DateTime.Now.ToString("yyyy-MM-dd") + ".docx";
  2630. string filePath = fileDir + $@"商邀相关文件/{fileName}";
  2631. doc.Save(filePath);
  2632. string Url = AppSettingsHelper.Get("WordBaseUrl") + "Office/GrpFile/商邀相关文件" + fileName;
  2633. return Ok(JsonView(true, "成功!", Url));
  2634. }
  2635. else
  2636. {
  2637. return Ok(JsonView(false, "失败,该团组没有客户名单!"));
  2638. }
  2639. }
  2640. catch (Exception ex)
  2641. {
  2642. return Ok(JsonView(false, "程序错误!"));
  2643. throw;
  2644. }
  2645. }
  2646. #endregion
  2647. #region 团组经理模块 出入境费用
  2648. ///// <summary>
  2649. ///// 团组模块 - 出入境费用
  2650. ///// </summary>
  2651. ///// <returns></returns>
  2652. //[HttpPost]
  2653. //[ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2654. //public async Task<IActionResult> SetEnterExitCostCurrencyChange()
  2655. //{
  2656. // try
  2657. // {
  2658. // var data = await _enterExitCostRep.SetEnterExitCostCurrencyChange();
  2659. // if (data.Code != 0)
  2660. // {
  2661. // return Ok(JsonView(false, data.Msg));
  2662. // }
  2663. // return Ok(JsonView(true, "查询成功!"));
  2664. // }
  2665. // catch (Exception ex)
  2666. // {
  2667. // return Ok(JsonView(false, ex.Message));
  2668. // throw;
  2669. // }
  2670. //}
  2671. /// <summary>
  2672. /// 团组模块 - 出入境费用 - 子项 地区更改为 nationalTravelFee 的id
  2673. /// </summary>
  2674. /// <returns></returns>
  2675. [HttpPost]
  2676. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2677. public async Task<IActionResult> SetDayAndCostAreaChange()
  2678. {
  2679. try
  2680. {
  2681. var nationalTravelFee = await _sqlSugar.Queryable<Grp_NationalTravelFee>().ToListAsync();
  2682. var dayAndCost = await _sqlSugar.Queryable<Grp_DayAndCost>().Where(it => it.IsDel == 0).ToListAsync();
  2683. var unite = dayAndCost.Where(a => nationalTravelFee.Any(b => a.Place.Trim() == b.City)).ToList(); //交集
  2684. var merge = dayAndCost.Where(a => !nationalTravelFee.Any(b => a.Place.Trim() == b.City)).ToList(); //差集
  2685. foreach (var item in unite) //处理交集数据
  2686. {
  2687. dayAndCost.Where(it => it.Id == item.Id).FirstOrDefault().NationalTravelFeeId = nationalTravelFee.Where(it => it.City.Trim() == item.Place.Trim()).FirstOrDefault().Id;
  2688. }
  2689. foreach (var item in merge) //处理差集数据
  2690. {
  2691. int nationalTravelFeeId = 0;
  2692. var cityData = nationalTravelFee.Where(it => it.City.Trim() == item.Place.Trim()).FirstOrDefault();
  2693. if (cityData != null) nationalTravelFeeId = cityData.Id;
  2694. else
  2695. {
  2696. var countryData = nationalTravelFee.Where(it => it.Country.Trim() == item.Place.Trim()).FirstOrDefault();
  2697. if (countryData != null) nationalTravelFeeId = countryData.Id;
  2698. }
  2699. dayAndCost.Where(it => it.Id == item.Id).FirstOrDefault().NationalTravelFeeId = nationalTravelFeeId;
  2700. }
  2701. //只更新dayAndCost 的 nationalTravelFeeId;
  2702. var result = _sqlSugar.Updateable(dayAndCost).UpdateColumns(it => new { it.NationalTravelFeeId }).ExecuteCommand();
  2703. if (result > 0) return Ok(JsonView(true, "nationalTravelFeeId列更新成功!"));
  2704. else return Ok(JsonView(false, "nationalTravelFeeId列更新失败!"));
  2705. }
  2706. catch (Exception ex)
  2707. {
  2708. return Ok(JsonView(false, ex.Message));
  2709. throw;
  2710. }
  2711. }
  2712. /// <summary>
  2713. /// 团组模块 - 出入境费用 - 基础数据源(团组名称/币种类型)
  2714. /// </summary>
  2715. /// <returns></returns>
  2716. [HttpPost]
  2717. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2718. public async Task<IActionResult> GetEnterExitCostDataSource(PortDtoBase dto)
  2719. {
  2720. try
  2721. {
  2722. var groupNameData = await _groupRepository.GetGroupNameList(new GroupNameDto { PortType = dto.PortType });
  2723. string sql = string.Format("Select * From Sys_SetData Where IsDel = 0");
  2724. //SetDataInfoView
  2725. var dataSource = await _sqlSugar.SqlQueryable<Sys_SetData>(sql).ToListAsync();
  2726. var currencyData = dataSource.Where(it => it.STid == 66).ToList(); //所有币种
  2727. List<SetDataInfoView> _CurrencyData = _mapper.Map<List<SetDataInfoView>>(currencyData);
  2728. var wordTypeData = dataSource.Where(it => it.STid == 72).ToList(); //三公费用-Word明细类型
  2729. List<SetDataInfoView> _WordTypeData = _mapper.Map<List<SetDataInfoView>>(wordTypeData);
  2730. var excelTypeData = dataSource.Where(it => it.STid == 73).ToList(); //三公费用-Excel明细类型
  2731. List<SetDataInfoView> _ExcelTypeData = _mapper.Map<List<SetDataInfoView>>(excelTypeData);
  2732. return Ok(JsonView(true, "查询成功!", new
  2733. {
  2734. GroupNameData = groupNameData.Data,
  2735. CurrencyData = _CurrencyData,
  2736. WordTypeData = _WordTypeData,
  2737. ExcelTypeData = _ExcelTypeData
  2738. //NationalTravelFeeData = nationalTravelFeeData
  2739. }));
  2740. }
  2741. catch (Exception ex)
  2742. {
  2743. return Ok(JsonView(false, ex.Message));
  2744. throw;
  2745. }
  2746. }
  2747. /// <summary>
  2748. /// 团组模块 - 出入境费用 - Info
  2749. /// </summary>
  2750. /// <returns></returns>
  2751. [HttpPost]
  2752. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2753. public async Task<IActionResult> GetEnterExitCostInfobyDiId(EnterExitCostInfobyDiIdDto dto)
  2754. {
  2755. try
  2756. {
  2757. var data = await _enterExitCostRep.GetEnterExitCostInfoByDiId(dto);
  2758. if (data.Code != 0)
  2759. {
  2760. return Ok(JsonView(false, data.Msg));
  2761. }
  2762. return Ok(JsonView(true, "查询成功!", data.Data));
  2763. }
  2764. catch (Exception ex)
  2765. {
  2766. return Ok(JsonView(false, ex.Message));
  2767. }
  2768. }
  2769. /// <summary>
  2770. /// 团组模块 - 出入境费用 - Add And Update
  2771. /// </summary>
  2772. /// <returns></returns>
  2773. [HttpPost]
  2774. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2775. public async Task<IActionResult> PostEnterExitCostOperate(EnterExitCostOperateDto dto)
  2776. {
  2777. try
  2778. {
  2779. var data = await _enterExitCostRep.PostEnterExitCostOperate(dto);
  2780. if (data.Code != 0)
  2781. {
  2782. return Ok(JsonView(false, data.Msg));
  2783. }
  2784. return Ok(JsonView(true, data.Msg, data.Data));
  2785. }
  2786. catch (Exception ex)
  2787. {
  2788. return Ok(JsonView(false, ex.Message));
  2789. }
  2790. }
  2791. /// <summary>
  2792. /// 团组模块 - 出入境费用 - 明细表导出
  2793. /// </summary>
  2794. /// <returns></returns>
  2795. [HttpPost]
  2796. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2797. public async Task<IActionResult> PostEnterExitCostExportDetailsList(EnterExitCostOperateDto dto)
  2798. {
  2799. try
  2800. {
  2801. var data = await _enterExitCostRep.PostEnterExitCostOperate(dto);
  2802. if (data.Code != 0)
  2803. {
  2804. return Ok(JsonView(false, data.Msg));
  2805. }
  2806. return Ok(JsonView(true, data.Msg, data.Data));
  2807. }
  2808. catch (Exception ex)
  2809. {
  2810. return Ok(JsonView(false, ex.Message));
  2811. }
  2812. }
  2813. /// <summary>
  2814. /// 团组模块 - 出入境费用 - 子项删除
  2815. /// </summary>
  2816. /// <returns></returns>
  2817. [HttpPost]
  2818. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2819. public async Task<IActionResult> PostEnterExitCostSubItemDel(EnterExitCostSubItemDelDto dto)
  2820. {
  2821. try
  2822. {
  2823. var data = await _enterExitCostRep.PostEnterExitCostSubItemDel(dto);
  2824. if (data.Code != 0)
  2825. {
  2826. return Ok(JsonView(false, data.Msg));
  2827. }
  2828. return Ok(JsonView(true, "操作成功!", data.Data));
  2829. }
  2830. catch (Exception ex)
  2831. {
  2832. return Ok(JsonView(false, ex.Message));
  2833. }
  2834. }
  2835. /// <summary>
  2836. /// 团组模块 - 出入境国家费用标准 List
  2837. /// </summary>
  2838. /// <returns></returns>
  2839. [HttpPost]
  2840. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2841. public async Task<IActionResult> GetNationalTravelFeeData(PortDtoBase dto)
  2842. {
  2843. try
  2844. {
  2845. Stopwatch sw = new Stopwatch();
  2846. sw.Start();
  2847. string nationalTravelFeeSql = string.Format(@"Select ssd.Name as CurrencyCode, ssd.Remark as CurrencyName,su.CnName as LastUpdateUserName,gntf.* From Grp_NationalTravelFee gntf
  2848. Left Join Sys_SetData ssd On ssd.STid = 66 And gntf.Currency = ssd.Id
  2849. Left Join Sys_Users su On gntf.LastUpdateUserId = su.Id
  2850. Where gntf.Isdel = 0");
  2851. var nationalTravelFeeData = await _sqlSugar.SqlQueryable<NationalTravelFeeInfoView>(nationalTravelFeeSql).ToListAsync();
  2852. //var nationalTravel = nationalTravelFeeData.GroupBy(it => it.Country).Select(it1 => it1.FirstOrDefault());
  2853. //List<dynamic> nationalTravelFeeData1 = new List<dynamic>();
  2854. //foreach (var item in nationalTravel)
  2855. //{
  2856. // var cityData = nationalTravelFeeData.Where(it => it.Country == item.Country).ToList();
  2857. // var otherData = cityData.Where(it => it.City.Contains("其他城市")).FirstOrDefault();
  2858. // if (otherData != null)
  2859. // {
  2860. // cityData.Remove(otherData);
  2861. // cityData.Add(otherData);
  2862. // }
  2863. // nationalTravelFeeData1.Add(new
  2864. // {
  2865. // Country = item.Country,
  2866. // CityData = cityData
  2867. // });
  2868. //}
  2869. sw.Stop();
  2870. return Ok(JsonView(true, "查询成功!耗时:" + sw.ElapsedMilliseconds + "ms", nationalTravelFeeData));
  2871. }
  2872. catch (Exception ex)
  2873. {
  2874. return Ok(JsonView(false, ex.Message));
  2875. throw;
  2876. }
  2877. }
  2878. /// <summary>
  2879. /// 团组模块 - 出入境国家费用标准 Page List Data Source
  2880. /// </summary>
  2881. /// <returns></returns>
  2882. [HttpPost]
  2883. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2884. public async Task<IActionResult> GetNationalTravelFeePageDataSource()
  2885. {
  2886. string sql = string.Format(@"Select * From Grp_NationalTravelFee Where Isdel = 0 ");
  2887. var nationalTravelFeeData = await _groupRepository._sqlSugar.SqlQueryable<Grp_NationalTravelFee>(sql).ToListAsync();
  2888. List<string> countryData = new List<string>();
  2889. countryData.AddRange(nationalTravelFeeData.Select(it => it.Country).ToList());
  2890. countryData = countryData.Distinct().ToList();
  2891. List<dynamic> dataSource = new List<dynamic>();
  2892. foreach (var item in countryData)
  2893. {
  2894. List<string> cityData1 = new List<string>();
  2895. cityData1 = nationalTravelFeeData.Where(it => it.Country == item).Select(it => it.City).ToList();
  2896. var countryData2 = new
  2897. {
  2898. CountryName = item,
  2899. CityData = cityData1
  2900. };
  2901. dataSource.Add(countryData2);
  2902. }
  2903. return Ok(JsonView(true, "查询成功!", dataSource));
  2904. }
  2905. /// <summary>
  2906. /// 团组模块 - 出入境国家费用标准 Page List
  2907. /// </summary>
  2908. /// <returns></returns>
  2909. [HttpPost]
  2910. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2911. public async Task<IActionResult> PostNationalTravelFeePage(NationalTravelFeePageDto dto)
  2912. {
  2913. int portId = dto.PortType;
  2914. if (portId != 1 && portId != 2 && portId != 3) return Ok(JsonView(false, "请输入正确的端口号!\r\n请求端口分类1 Web 2 Android 3 IOS"));
  2915. if (dto.PageIndex == 0) return Ok(JsonView(false, "当前页码数不能为0!"));
  2916. if (dto.PageSize == 0) return Ok(JsonView(false, "每页条数不能0!"));
  2917. string whereSql = string.Empty;
  2918. if (!string.IsNullOrEmpty(dto.Country))
  2919. {
  2920. whereSql += string.Format(@" And gntf.Country ='{0}'", dto.Country);
  2921. }
  2922. if (!string.IsNullOrEmpty(dto.City))
  2923. {
  2924. whereSql += string.Format(@" And gntf.City='{0}'", dto.City);
  2925. }
  2926. string pageSql = string.Format(@"Select * From (
  2927. Select row_number() over(order by gntf.LastUpdateTime Desc) as RowNumber,
  2928. ssd.Name as CurrencyCode, ssd.Remark as CurrencyName,su.CnName as LastUpdateUserName,gntf.*
  2929. From Grp_NationalTravelFee gntf
  2930. Left Join Sys_SetData ssd On ssd.STid = 66 And gntf.Currency = ssd.Id
  2931. Left Join Sys_Users su On gntf.LastUpdateUserId = su.Id
  2932. Where gntf.Isdel = 0 {0} ) temp ", whereSql);
  2933. RefAsync<int> total = 0;
  2934. var nationalTravelFeeData = await _groupRepository._sqlSugar.SqlQueryable<NationalTravelFeePageInfoView>(pageSql).ToPageListAsync(dto.PageIndex, dto.PageSize, total);
  2935. return Ok(JsonView(true, "查询成功!", nationalTravelFeeData, (int)total));
  2936. }
  2937. /// <summary>
  2938. /// 团组模块 - 出入境国家费用标准 根据城市查询
  2939. /// </summary>
  2940. /// <returns></returns>
  2941. [HttpPost]
  2942. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2943. public async Task<IActionResult> PostNationalTravelFeeInfoByCountryAndCity(NationalTravelFeeByCountryAndCityDto dto)
  2944. {
  2945. if (dto == null) return Ok(JsonView(false, "请传入参数!"));
  2946. int portId = dto.PortType;
  2947. if (portId != 1 && portId != 2 && portId != 3) return Ok(JsonView(false, "请输入正确的端口号!\r\n请求端口分类1 Web 2 Android 3 IOS"));
  2948. string whereSql = string.Empty;
  2949. if (!string.IsNullOrEmpty(dto.Country))
  2950. {
  2951. whereSql = string.Format(@"And Country = '{0}' ", dto.Country);
  2952. }
  2953. if (!string.IsNullOrEmpty(dto.City))
  2954. {
  2955. whereSql = string.Format(@"And City = '{0}' ", dto.City);
  2956. }
  2957. string sql = string.Format(@"Select gntf.Country,gntf.City,gntf.Currency,ssd.Name as CurrencyCode,
  2958. ssd.Remark as CurrencyName,gntf.RoomCost,gntf.FoodCost,gntf.PublicCost,
  2959. gntf.LastUpdateUserId,su.CnName as LastUpdateUserName,gntf.LastUpdateTime
  2960. From Grp_NationalTravelFee gntf
  2961. Left Join Sys_SetData ssd On ssd.STid = 66 And gntf.Currency = ssd.Id
  2962. Left Join Sys_Users su On gntf.LastUpdateUserId = su.Id
  2963. Where gntf.Isdel = 0 {0} ", whereSql);
  2964. var nationalTravelFeeData = await _groupRepository._sqlSugar.SqlQueryable<NationalTravelFeeInfoByCountryAndCityView>(sql).FirstAsync();
  2965. return Ok(JsonView(true, "查询成功!", nationalTravelFeeData));
  2966. }
  2967. /// <summary>
  2968. /// 团组模块 - 出入境国家费用标准 - Add Or Update
  2969. /// </summary>
  2970. /// <returns></returns>
  2971. [HttpPost]
  2972. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2973. public async Task<IActionResult> PostNationalTravelFeeOperate(NationalTravelFeeOperateDto dto)
  2974. {
  2975. try
  2976. {
  2977. var data = await _enterExitCostRep.PostNationalTravelFeeOperate(dto);
  2978. if (data.Code != 0)
  2979. {
  2980. return Ok(JsonView(false, data.Msg));
  2981. }
  2982. return Ok(JsonView(true, "操作成功!", data.Data));
  2983. }
  2984. catch (Exception ex)
  2985. {
  2986. return Ok(JsonView(false, ex.Message));
  2987. }
  2988. }
  2989. /// <summary>
  2990. /// 团组模块 - 出入境国家费用标准 - Del
  2991. /// </summary>
  2992. /// <returns></returns>
  2993. [HttpPost]
  2994. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  2995. public async Task<IActionResult> PostNationalTravelFeeDel(NationalTravelFeeDelDto dto)
  2996. {
  2997. try
  2998. {
  2999. Grp_NationalTravelFee _nationalTravelFee = new Grp_NationalTravelFee()
  3000. {
  3001. Id = dto.Id,
  3002. DeleteUserId = dto.DeleteUserId,
  3003. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd"),
  3004. IsDel = 1
  3005. };
  3006. var delStatus = await _enterExitCostRep._sqlSugar.Updateable<Grp_NationalTravelFee>(_nationalTravelFee)
  3007. .UpdateColumns(it => new { it.DeleteTime, it.DeleteUserId, it.IsDel })
  3008. .WhereColumns(it => new { it.Id })
  3009. .ExecuteCommandAsync();
  3010. if (delStatus <= 0)
  3011. {
  3012. return Ok(JsonView(false, "删除失败!"));
  3013. }
  3014. return Ok(JsonView(true, "操作成功!"));
  3015. }
  3016. catch (Exception ex)
  3017. {
  3018. return Ok(JsonView(false, ex.Message));
  3019. }
  3020. }
  3021. #endregion
  3022. #region 签证费用录入
  3023. /// <summary>
  3024. /// 根据diid查询签证费用列表
  3025. /// </summary>
  3026. /// <param name="dto"></param>
  3027. /// <returns></returns>
  3028. [HttpPost]
  3029. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3030. public async Task<IActionResult> QueryVisaByDiId(VisaPriceDto dto)
  3031. {
  3032. try
  3033. {
  3034. Result groupData = await _visaPriceRep.PostVisaByDiId(dto);
  3035. if (groupData.Code != 0)
  3036. {
  3037. return Ok(JsonView(false, groupData.Msg));
  3038. }
  3039. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3040. }
  3041. catch (Exception ex)
  3042. {
  3043. return Ok(JsonView(false, ex.Message));
  3044. }
  3045. }
  3046. /// <summary>
  3047. /// 根据签证费用Id查询单条数据及c表数据
  3048. /// </summary>
  3049. /// <param name="dto"></param>
  3050. /// <returns></returns>
  3051. [HttpPost]
  3052. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3053. public async Task<IActionResult> QueryVisaById(PostVisaByIdDto dto)
  3054. {
  3055. try
  3056. {
  3057. Result groupData = await _visaPriceRep.PostVisaById(dto);
  3058. if (groupData.Code != 0)
  3059. {
  3060. return Ok(JsonView(false, groupData.Msg));
  3061. }
  3062. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3063. }
  3064. catch (Exception ex)
  3065. {
  3066. return Ok(JsonView(false, ex.Message));
  3067. }
  3068. }
  3069. /// <summary>
  3070. /// 签证费用删除
  3071. /// </summary>
  3072. /// <param name="dto"></param>
  3073. /// <returns></returns>
  3074. [HttpPost]
  3075. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3076. public async Task<IActionResult> DelVisaPrice(DelBaseDto dto)
  3077. {
  3078. try
  3079. {
  3080. var res = await _visaPriceRep.SoftDeleteByIdAsync<Grp_VisaInfo>(dto.Id.ToString(), dto.DeleteUserId);
  3081. if (!res)
  3082. {
  3083. return Ok(JsonView(false, "删除失败"));
  3084. }
  3085. var resultC = await _sqlSugar.Updateable<Grp_CreditCardPayment>().Where(a => a.CId == dto.Id && a.IsDel == 0 && a.CTable == 80).SetColumns(a => new Grp_CreditCardPayment()
  3086. {
  3087. IsDel = 1,
  3088. DeleteUserId = dto.DeleteUserId,
  3089. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  3090. }).ExecuteCommandAsync();
  3091. return Ok(JsonView(true, "删除成功!"));
  3092. }
  3093. catch (Exception ex)
  3094. {
  3095. return Ok(JsonView(false, "程序错误!"));
  3096. throw;
  3097. }
  3098. }
  3099. /// <summary>
  3100. /// 签证费用录入下拉框初始化
  3101. /// </summary>
  3102. /// <returns></returns>
  3103. [HttpPost]
  3104. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3105. public async Task<IActionResult> VisaPriceAddSelect()
  3106. {
  3107. try
  3108. {
  3109. //支付方式
  3110. List<Sys_SetData> Payment = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 14 && a.IsDel == 0).ToList();
  3111. List<SetDataInfoView> _Payment = _mapper.Map<List<SetDataInfoView>>(Payment);
  3112. //币种
  3113. List<Sys_SetData> CurrencyList = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 66 && a.IsDel == 0).ToList();
  3114. List<SetDataInfoView> _CurrencyList = _mapper.Map<List<SetDataInfoView>>(CurrencyList);
  3115. //乘客类型
  3116. List<Sys_SetData> PassengerType = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 69 && a.IsDel == 0).ToList();
  3117. List<SetDataInfoView> _PassengerType = _mapper.Map<List<SetDataInfoView>>(PassengerType);
  3118. //卡类型
  3119. List<Sys_SetData> BankCard = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 15 && a.IsDel == 0).ToList();
  3120. List<SetDataInfoView> _BankCard = _mapper.Map<List<SetDataInfoView>>(BankCard);
  3121. var data = new
  3122. {
  3123. Payment = _Payment,
  3124. CurrencyList = _CurrencyList,
  3125. PassengerType = _PassengerType,
  3126. BankCard = _BankCard
  3127. };
  3128. return Ok(JsonView(true, "查询成功!", data));
  3129. }
  3130. catch (Exception ex)
  3131. {
  3132. return Ok(JsonView(false, "程序错误!"));
  3133. throw;
  3134. }
  3135. }
  3136. /// <summary>
  3137. /// 签证费用录入操作(Status:1.新增,2.修改)
  3138. /// </summary>
  3139. /// <param name="dto"></param>
  3140. /// <returns></returns>
  3141. [HttpPost]
  3142. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3143. public async Task<IActionResult> OpVisaPrice(OpVisaPriceDto dto)
  3144. {
  3145. try
  3146. {
  3147. Result groupData = await _visaPriceRep.OpVisaPrice(dto);
  3148. if (groupData.Code != 0)
  3149. {
  3150. return Ok(JsonView(false, groupData.Msg));
  3151. }
  3152. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3153. }
  3154. catch (Exception ex)
  3155. {
  3156. return Ok(JsonView(false, ex.Message));
  3157. }
  3158. }
  3159. #endregion
  3160. #region op费用录入
  3161. /// <summary>
  3162. /// 根据diid查询op费用列表
  3163. /// </summary>
  3164. /// <param name="dto"></param>
  3165. /// <returns></returns>
  3166. [HttpPost]
  3167. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3168. public async Task<IActionResult> QueryCarTouristGuideGroundByDiId(CarTouristGuideGroundDto dto)
  3169. {
  3170. try
  3171. {
  3172. Result groupData = await _carTouristGuideGroundRep.QueryCarTouristGuideGroundByDiId(dto);
  3173. if (groupData.Code != 0)
  3174. {
  3175. return Ok(JsonView(false, groupData.Msg));
  3176. }
  3177. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3178. }
  3179. catch (Exception ex)
  3180. {
  3181. return Ok(JsonView(false, ex.Message));
  3182. }
  3183. }
  3184. /// <summary>
  3185. /// 根据op费用Id查询单条数据及c表数据
  3186. /// </summary>
  3187. /// <param name="dto"></param>
  3188. /// <returns></returns>
  3189. [HttpPost]
  3190. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3191. public async Task<IActionResult> QueryCarTouristGuideGroundById(CarTouristGuideGroundIdDto dto)
  3192. {
  3193. try
  3194. {
  3195. Grp_CarTouristGuideGroundReservations _groupData = await _sqlSugar.Queryable<Grp_CarTouristGuideGroundReservations>().FirstAsync(a => a.Id == dto.Id && a.IsDel == 0);
  3196. Grp_CreditCardPayment _creditCardPayment = await _sqlSugar.Queryable<Grp_CreditCardPayment>().FirstAsync(a => a.CId == dto.Id && a.CTable == 79 && a.IsDel == 0);
  3197. var data = new
  3198. {
  3199. CarTouristGuideGround = _groupData,
  3200. CreditCardPayment = _creditCardPayment
  3201. };
  3202. return Ok(JsonView(true, "查询成功!", data));
  3203. }
  3204. catch (Exception ex)
  3205. {
  3206. return Ok(JsonView(false, "程序错误!"));
  3207. }
  3208. }
  3209. /// <summary>
  3210. /// op费用删除
  3211. /// </summary>
  3212. /// <param name="dto"></param>
  3213. /// <returns></returns>
  3214. [HttpPost]
  3215. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3216. public async Task<IActionResult> DelCarTouristGuideGround(DelBaseDto dto)
  3217. {
  3218. try
  3219. {
  3220. var res = await _carTouristGuideGroundRep.SoftDeleteByIdAsync<Grp_CarTouristGuideGroundReservations>(dto.Id.ToString(), dto.DeleteUserId);
  3221. if (!res)
  3222. {
  3223. return Ok(JsonView(false, "删除失败"));
  3224. }
  3225. var result = await _sqlSugar.Updateable<Grp_CarTouristGuideGroundReservationsContent>().Where(a => a.CTGGRId == dto.Id && a.IsDel == 0).SetColumns(a => new Grp_CarTouristGuideGroundReservationsContent()
  3226. {
  3227. IsDel = 1,
  3228. DeleteUserId = dto.DeleteUserId,
  3229. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  3230. }).ExecuteCommandAsync();
  3231. var resultC = await _sqlSugar.Updateable<Grp_CreditCardPayment>().Where(a => a.CId == dto.Id && a.IsDel == 0 && a.CTable == 79).SetColumns(a => new Grp_CreditCardPayment()
  3232. {
  3233. IsDel = 1,
  3234. DeleteUserId = dto.DeleteUserId,
  3235. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  3236. }).ExecuteCommandAsync();
  3237. return Ok(JsonView(true, "删除成功!"));
  3238. }
  3239. catch (Exception ex)
  3240. {
  3241. return Ok(JsonView(false, "程序错误!"));
  3242. throw;
  3243. }
  3244. }
  3245. /// <summary>
  3246. /// op费用录入操作(Status:1.新增,2.修改)
  3247. /// </summary>
  3248. /// <param name="dto"></param>
  3249. /// <returns></returns>
  3250. [HttpPost]
  3251. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3252. public async Task<IActionResult> OpCarTouristGuideGround(OpCarTouristGuideGroundDto dto)
  3253. {
  3254. try
  3255. {
  3256. Result groupData = await _carTouristGuideGroundRep.OpCarTouristGuideGround(dto);
  3257. if (groupData.Code != 0)
  3258. {
  3259. return Ok(JsonView(false, groupData.Msg));
  3260. }
  3261. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3262. }
  3263. catch (Exception ex)
  3264. {
  3265. return Ok(JsonView(false, ex.Message));
  3266. }
  3267. }
  3268. /// <summary>
  3269. /// 填写费用详细页面初始化绑定
  3270. /// </summary>
  3271. /// <param name="dto"></param>
  3272. /// <returns></returns>
  3273. [HttpPost]
  3274. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3275. public async Task<IActionResult> CarTouristGuideGroundContentInitialize(CarTouristGuideGroundContentDto dto)
  3276. {
  3277. try
  3278. {
  3279. Result groupData = await _carTouristGuideGroundRep.CarTouristGuideGroundContent(dto);
  3280. if (groupData.Code != 0)
  3281. {
  3282. return Ok(JsonView(false, groupData.Msg));
  3283. }
  3284. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3285. }
  3286. catch (Exception ex)
  3287. {
  3288. return Ok(JsonView(false, ex.Message));
  3289. }
  3290. }
  3291. /// <summary>
  3292. /// 根据op费用Id查询详细数据
  3293. /// </summary>
  3294. /// <param name="dto"></param>
  3295. /// <returns></returns>
  3296. [HttpPost]
  3297. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3298. public async Task<IActionResult> OpCarTouristGuideGroundContentById(CarTouristGuideGroundIdDto dto)
  3299. {
  3300. try
  3301. {
  3302. Result groupData = await _carTouristGuideGroundRep.OpCarTouristGuideGroundContentById(dto);
  3303. if (groupData.Code != 0)
  3304. {
  3305. return Ok(JsonView(false, groupData.Msg));
  3306. }
  3307. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3308. }
  3309. catch (Exception ex)
  3310. {
  3311. return Ok(JsonView(false, ex.Message));
  3312. }
  3313. }
  3314. /// <summary>
  3315. /// OP费用录入填写详情
  3316. /// </summary>
  3317. /// <param name="dto"></param>
  3318. /// <returns></returns>
  3319. [HttpPost]
  3320. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3321. public async Task<IActionResult> OpCarTouristGuideGroundContent(OpCarTouristGuideGroundContentDto dto)
  3322. {
  3323. try
  3324. {
  3325. Result groupData = await _carTouristGuideGroundRep.OpCarTouristGuideGroundContent(dto);
  3326. if (groupData.Code != 0)
  3327. {
  3328. return Ok(JsonView(false, groupData.Msg));
  3329. }
  3330. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3331. }
  3332. catch (Exception ex)
  3333. {
  3334. return Ok(JsonView(false, ex.Message));
  3335. }
  3336. }
  3337. #endregion
  3338. #region 团组成本
  3339. /// <summary>
  3340. /// 团组成本数据初始化
  3341. /// </summary>
  3342. /// <param name="dto"></param>
  3343. /// <returns></returns>
  3344. [HttpPost]
  3345. public async Task<IActionResult> GroupCostInit(GroupCostInItDto dto)
  3346. {
  3347. var groupList = _sqlSugar.SqlQueryable<DelegationInfoAndIsTrueView>($@"
  3348. Select a.Id,TeamName GroupName,b.isTrue From Grp_DelegationInfo a left join (select top 100 percent Diid, CASE
  3349. WHEN COUNT(*) >= 0 THEN 'True'
  3350. ELSE 'False' END as isTrue from Grp_GroupCost where Isdel = 0 and date != '' group by Diid) b on a.Id = b.Diid
  3351. Where TeamName != '' And IsDel = 0 Order By a.Id Desc
  3352. ").ToList(); //团组列表
  3353. int diid = dto.Diid == -1 ? groupList.First().Id : dto.Diid;
  3354. var groupInfo = await _groupRepository.PostShareGroupInfo(new ShareGroupInfoDto { PortType = 1, Id = diid }); //团组信息
  3355. var groupChecks = _checkBoxs.GetCheckBoxsByDiid(diid); //团组选中信息 可枚举
  3356. var groupCost = _GroupCostRepository.GetAllByDiid(diid); //团组列表信息
  3357. var groupCostMap = _mapper.Map<List<Grp_GroupCostDto>>(groupCost);
  3358. var hotelNumber = _CostTypeHotelNumberRepository.GetCostTypeHotelNumberByDiid(diid); //酒店数量 可枚举
  3359. var GroupCostParameter = _GroupCostParameterRepository.GetGroupCostParameterListByDiid(diid); //成本系数 可枚举
  3360. //GroupCostParameter.Add(new
  3361. // Grp_GroupCostParameter());
  3362. var GroupCostParameterMap = _mapper.Map<List<Grp_GroupCostParameterDto>>(GroupCostParameter);
  3363. return Ok(JsonView(new
  3364. {
  3365. groupList,
  3366. groupInfo,
  3367. groupChecks,
  3368. groupCost = groupCostMap,
  3369. hotelNumber,
  3370. GroupCostParameter = GroupCostParameterMap,
  3371. }));
  3372. }
  3373. /// <summary>
  3374. /// 团组成本信息保存
  3375. /// </summary>
  3376. /// <param name="dto"></param>
  3377. /// <returns></returns>
  3378. [HttpPost]
  3379. public async Task<IActionResult> SaveGroupCost(GroupCostSavaDto dto)
  3380. {
  3381. if (dto.Diid <= 0 || dto.Userid <= 0)
  3382. {
  3383. return Ok(JsonView(false));
  3384. }
  3385. JsonView jw = null;
  3386. bool isTrue = false;
  3387. var Grp_groups = _mapper.Map<List<Grp_GroupCost>>(dto.GroupCosts);
  3388. Grp_groups.ForEach(x => { x.CreateUserId = dto.Userid; x.CreateTime = DateTime.Now; }); //.ToString("yyyy-MM-dd HH:mm:ss")
  3389. var Grp_CheckBoxs = _mapper.Map<List<Grp_CheckBoxs>>(dto.CheckBoxs);
  3390. Grp_CheckBoxs.ForEach(x => { x.CreateUserId = dto.Userid; x.CreateTime = DateTime.Now; });
  3391. var Grp_HotelNumber = _mapper.Map<List<Grp_CostTypeHotelNumber>>(dto.CostTypeHotelNumbers);
  3392. var Grp_CostParameters = _mapper.Map<List<Grp_GroupCostParameter>>(dto.GroupCostParameters);
  3393. try
  3394. {
  3395. _sqlSugar.BeginTran();
  3396. isTrue = await _GroupCostRepository.
  3397. SaveGroupCostList(Grp_groups, dto.Diid); //列表
  3398. isTrue = await _checkBoxs.SaveCheckBoxs(Grp_CheckBoxs, dto.Diid); //选中项
  3399. isTrue = await _CostTypeHotelNumberRepository.SaveHotelNumber(Grp_HotelNumber, dto.Userid, dto.Diid); //酒店房间数量
  3400. isTrue = await _GroupCostParameterRepository.SaveAsync(Grp_CostParameters, dto.Userid, dto.Diid); //系数
  3401. _sqlSugar.CommitTran();
  3402. jw = JsonView(true, "保存成功!", isTrue);
  3403. }
  3404. catch (Exception)
  3405. {
  3406. _sqlSugar.RollbackTran();
  3407. jw = JsonView(false);
  3408. }
  3409. return Ok(jw);
  3410. }
  3411. /// <summary>
  3412. /// 司兼导数据
  3413. /// </summary>
  3414. /// <param name="dto"></param>
  3415. /// <returns></returns>
  3416. [HttpPost]
  3417. public IActionResult GetCarGuides(CarGuidesDto dto)
  3418. {
  3419. JsonView jw = null;
  3420. var Data = _sqlSugar.SqlQueryable<Grp_CarGuides>($@" select * from Grp_CarGuides where isdel = 0 ").ToList();
  3421. jw = JsonView(true, "获取成功!", Data);
  3422. return Ok(jw);
  3423. }
  3424. /// <summary>
  3425. /// 导游数据
  3426. /// </summary>
  3427. /// <param name="dto"></param>
  3428. /// <returns></returns>
  3429. [HttpPost]
  3430. public IActionResult GetGuidesInfo(CarGuidesDto dto)
  3431. {
  3432. JsonView jw = null;
  3433. //var Data = _sqlSugar.SqlQueryable<Grp_GuidesInfo>($@" SELECT* FROM (
  3434. // SELECT*,ROW_NUMBER() OVER (ORDER BY Id) AS RowNumber FROM Grp_GuidesInfo where (city like '%{dto.City}%' or country like '%{dto.City}%' ) and isdel = 0 ) as b
  3435. // where RowNumber BETWEEN {(dto.Page - 1) * dto.Size + 1} and {(dto.Page) * dto.Size}").ToList();
  3436. var Data = _sqlSugar.SqlQueryable<Grp_GuidesInfo>($@" select * from Grp_GuidesInfo where isdel = 0 ").ToList();
  3437. jw = JsonView(true, "获取成功!", Data);
  3438. return Ok(jw);
  3439. }
  3440. /// <summary>
  3441. /// 成本车数据
  3442. /// </summary>
  3443. /// <param name="dto"></param>
  3444. /// <returns></returns>
  3445. [HttpPost]
  3446. public IActionResult GetCarInfo(CarGuidesDto dto)
  3447. {
  3448. JsonView jw = null;
  3449. var Data = _sqlSugar.SqlQueryable<Grp_CarInfo>($@" select * from Grp_CarInfo where isdel = 0 ").ToList();
  3450. jw = JsonView(true, "获取成功!", Data);
  3451. return Ok(jw);
  3452. }
  3453. /// <summary>
  3454. /// 景点数据
  3455. /// </summary>
  3456. /// <param name="dto"></param>
  3457. /// <returns></returns>
  3458. [HttpPost]
  3459. public IActionResult GetScenicSpotInfo(CarGuidesDto dto)
  3460. {
  3461. var Data = _sqlSugar.SqlQueryable<Grp_ScenicSpotInfo>($@" select * from Grp_ScenicSpotInfo where isdel = 0 ").ToList();
  3462. return Ok(JsonView(true, "获取成功!", Data));
  3463. }
  3464. /// <summary>
  3465. /// 成本通知
  3466. /// </summary>
  3467. /// <param name="dto"></param>
  3468. /// <returns></returns>
  3469. [HttpPost]
  3470. public async Task<IActionResult> GroupIsShare(GroupIsShareDto dto)
  3471. {
  3472. if (dto.Diid < 0)
  3473. {
  3474. return Ok(JsonView(false));
  3475. }
  3476. JsonView jw = null;
  3477. var GroupCostParameter = _GroupCostParameterRepository.GetGroupCostParameterMainByDiid(dto.Diid);
  3478. if (GroupCostParameter != null)
  3479. {
  3480. int IsShare = 0;
  3481. if (GroupCostParameter.IsShare == 0) IsShare = 1;
  3482. else if (GroupCostParameter.IsShare == 1) IsShare = 0;
  3483. bool isTrue = await _GroupCostParameterRepository.UpdateIsShareById(GroupCostParameter.Id,IsShare);
  3484. string msg = string.Empty;
  3485. if (isTrue)
  3486. {
  3487. if (IsShare == 0)
  3488. {
  3489. msg = "禁止通知,其他模块操作人员不可见此成本信息!";
  3490. }
  3491. else
  3492. {
  3493. msg = "通知成功,其他模块操作人员可见此成本信息!";
  3494. }
  3495. jw = JsonView(isTrue, msg);
  3496. }
  3497. else
  3498. {
  3499. msg = "修改失败!";
  3500. jw = JsonView(isTrue, msg);
  3501. }
  3502. }
  3503. else
  3504. {
  3505. jw = JsonView(false, "该团没有数据,请添加数据,保存后再操作!");
  3506. }
  3507. return Ok(jw);
  3508. }
  3509. /// <summary>
  3510. /// 导出收款账单
  3511. /// </summary>
  3512. /// <param name="dto"></param>
  3513. /// <returns></returns>
  3514. [HttpPost]
  3515. public async Task<IActionResult> ExportPriceCheckWordFile(GroupCostExportWordFile dto)
  3516. {
  3517. if (dto.Diid == 0)
  3518. {
  3519. return Ok(JsonView(false, "请传递团组id"));
  3520. }
  3521. var deleInfo = await _groupRepository.PostGroupInfo(new GroupInfoDto { Id = dto.Diid, PortType = 1 });
  3522. if (deleInfo.Code != 0)
  3523. {
  3524. return Ok(JsonView(false, "团组信息查询失败!"));
  3525. }
  3526. var di = deleInfo.Data as DelegationInfoWebView;
  3527. if (di != null)
  3528. {
  3529. //文件名
  3530. string strFileName = di.TeamName + "-收款账单.doc";
  3531. //获取模板
  3532. string tmppath = (AppSettingsHelper.Get("WordBasePath") + "Template/收款账单(四川)模板.doc");
  3533. //载入模板
  3534. Document doc = new Document(tmppath);
  3535. decimal TotalPrice = 0.00M;
  3536. string itemStr = string.Empty;
  3537. Dictionary<string, string> airSouer = new Dictionary<string, string>();
  3538. //airSouer.Add("JJCTBR", "经济舱及酒店双人间");
  3539. airSouer.Add("JJCTBR", "经济舱及酒店双人间");
  3540. airSouer.Add("JJCSGR", "经济舱及酒店单人间");
  3541. airSouer.Add("GWCSGR", "公务舱及酒店单人间");
  3542. airSouer.Add("GWCJSES", "公务舱及酒店小套房");
  3543. airSouer.Add("GWCSUITE", "公务舱及酒店套房");
  3544. airSouer.Add("JJCSUITE", "经济舱及酒店套房");
  3545. var groupCostType = dto.airs.GroupBy(x => x.costType).OrderBy(x=>x.Key);
  3546. foreach(var cost in groupCostType)
  3547. {
  3548. var List = cost.ToList();
  3549. if (cost.Key == "A")
  3550. {
  3551. foreach (var ListItem in List)
  3552. {
  3553. if (ListItem.number > 0)
  3554. {
  3555. if (ListItem.code.Contains("TBR"))
  3556. {
  3557. itemStr += "团费(" + airSouer[ListItem.code] + ") RMB " + ListItem.price.ToString("F2") + "/人*" + ListItem.number + "(" + (ListItem.number / 2) + "间( ............合计 RMB " + (ListItem.number * ListItem.price).ToString("#0.00") + "\n";
  3558. }
  3559. else
  3560. {
  3561. itemStr += "团费(" + airSouer[ListItem.code] + ") RMB " + ListItem.price.ToString("F2") + "/人*" + ListItem.number + "(" + ListItem.number + "间( ............合计 RMB " + (ListItem.number * ListItem.price).ToString("#0.00") + "\n";
  3562. }
  3563. TotalPrice += (ListItem.number * ListItem.price);
  3564. }
  3565. }
  3566. }
  3567. else
  3568. {
  3569. itemStr = itemStr.Insert(0, "A段\r\n");
  3570. itemStr += "B段\r\n";
  3571. foreach (var ListItem in List)
  3572. {
  3573. if (ListItem.number > 0)
  3574. {
  3575. if (ListItem.code.Contains("TBR"))
  3576. {
  3577. itemStr += "团费(" + airSouer[ListItem.code] + ") RMB " + ListItem.price.ToString("F2") + "/人*" + ListItem.number + "(" + (ListItem.number / 2) + "间( ............合计 RMB " + (ListItem.number * ListItem.price).ToString("#0.00") + "\n";
  3578. }
  3579. else
  3580. {
  3581. itemStr += "团费(" + airSouer[ListItem.code] + ") RMB " + ListItem.price.ToString("F2") + "/人*" + ListItem.number + "(" + ListItem.number + "间( ............合计 RMB " + (ListItem.number * ListItem.price).ToString("#0.00") + "\n";
  3582. }
  3583. TotalPrice += (ListItem.number * ListItem.price);
  3584. }
  3585. }
  3586. }
  3587. }
  3588. #region 替换Word模板书签内容
  3589. Dictionary<string, string> marks = new Dictionary<string, string>();
  3590. marks.Add("To", di.ClientUnit);//付款方
  3591. marks.Add("ToTel", di.TellPhone);//付款方电话
  3592. marks.Add("Date", DateTime.Now.ToString("yyyy-MM-dd"));//导出时间
  3593. marks.Add("Team", di.VisitCountry.Replace(" ", "、"));//团队名称
  3594. marks.Add("TontractTime", (di.VisitDate).ToString("yyyy年MM月dd日"));//付款日期
  3595. marks.Add("PayDay", (di.PayDay).ToString());//付款预期
  3596. marks.Add("PaymentMoney", (di.PaymentMoney).ToString("#0.00"));//付款金额
  3597. marks.Add("WeChat", "WeChat");//微信号 di.WeChat;
  3598. marks.Add("PayItemContent", itemStr);//详细信息
  3599. marks.Add("Total", TotalPrice.ToString("F2"));//合计
  3600. #endregion
  3601. ////注
  3602. //if (doc.Range.Bookmarks["Attention"] != null)
  3603. //{
  3604. // Bookmark mark = doc.Range.Bookmarks["Attention"];
  3605. // mark.Text = frList[0].Attention;
  3606. //}
  3607. foreach (var item in marks.Keys)
  3608. {
  3609. if (doc.Range.Bookmarks[item] != null)
  3610. {
  3611. Bookmark mark = doc.Range.Bookmarks[item];
  3612. mark.Text = marks[item];
  3613. }
  3614. }
  3615. byte[] bytes = null;
  3616. using (MemoryStream stream = new MemoryStream())
  3617. {
  3618. doc.Save(stream, Aspose.Words.SaveFormat.Doc);
  3619. bytes = stream.ToArray();
  3620. }
  3621. //doc.Save((AppSettingsHelper.Get("WordBasePath") + "Template/") + strFileName);
  3622. return Ok(JsonView(true,"",new
  3623. {
  3624. Data = bytes,
  3625. strFileName,
  3626. }));
  3627. }
  3628. else
  3629. {
  3630. return Ok(JsonView(false,"团组信息不存在!"));
  3631. }
  3632. }
  3633. [HttpPost]
  3634. public async Task<IActionResult> ExportGroupCostExcelFile(GroupCostExportExcelFile dto)
  3635. {
  3636. //Workbook SourceBook1 = new Workbook();
  3637. //List<string> fileList = new List<string>();
  3638. if (dto.Diid == 0)
  3639. {
  3640. return Ok(JsonView(false, "请传递团组id"));
  3641. }
  3642. List<GroupCost_Excel> List_GC1 = new List<GroupCost_Excel>();
  3643. WorkbookDesigner designer = new WorkbookDesigner();
  3644. //var style = new Aspose.Cells.Style();
  3645. //style.IsTextWrapped = true;
  3646. designer.Workbook = new Workbook(AppSettingsHelper.Get("ExcelBasePath") + ("Template/团组-成本.xls"));
  3647. var List_GC = _GroupCostRepository.GetAllByDiid(dto.Diid);
  3648. for (int i = 0; i < List_GC.Count; i++)
  3649. {
  3650. GroupCost_Excel gc = new GroupCost_Excel();
  3651. gc.Id = List_GC[i].Id;
  3652. gc.Diid = List_GC[i].Diid.ToString();
  3653. gc.DAY = List_GC[i].DAY;
  3654. string week = "";
  3655. if (!string.IsNullOrEmpty(List_GC[i].Date.Trim()))
  3656. week = CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(Convert.ToDateTime(List_GC[i].Date).DayOfWeek);
  3657. gc.Date = (List_GC[i].Date + "\n" + week).ToString();
  3658. gc.ITIN = List_GC[i].ITIN;
  3659. gc.CarType = List_GC[i].CarType;
  3660. gc.CarTiming = List_GC[i].CarTiming.ToString() == "0" ? "/" : List_GC[i].CarTiming.ToString();
  3661. gc.CarCost = List_GC[i].CarCost.ToString() == "0" ? "/" : List_GC[i].CarCost.ToString();
  3662. gc.CarNumber = List_GC[i].CarNumber.ToString() == "0" ? "/" : List_GC[i].CarNumber.ToString();
  3663. gc.TGS = List_GC[i].TGS.ToString() == "0" ? "/" : List_GC[i].TGS.ToString();
  3664. gc.TGWH = List_GC[i].TGWH.ToString() == "0" ? "/" : List_GC[i].TGWH.ToString();
  3665. gc.TGN = List_GC[i].TGS.ToString() == "0" ? "/" : List_GC[i].TGN.ToString();
  3666. gc.TGOF = List_GC[i].TGOF.ToString() == "0" ? "/" : List_GC[i].TGOF.ToString();
  3667. gc.TGM = List_GC[i].TGM.ToString() == "0" ? "/" : List_GC[i].TGM.ToString();
  3668. gc.TGA = List_GC[i].TGA.ToString() == "0" ? "/" : List_GC[i].TGA.ToString();
  3669. gc.TGTF = List_GC[i].TGTF.ToString() == "0" ? "/" : List_GC[i].TGTF.ToString();
  3670. gc.TGEF = List_GC[i].TGEF.ToString() == "0" ? "/" : List_GC[i].TGEF.ToString();
  3671. gc.CFS = List_GC[i].CFS.ToString() == "0" ? "/" : List_GC[i].CFS.ToString();
  3672. gc.CFM = List_GC[i].CFM.ToString() == "0" ? "/" : List_GC[i].CFOF.ToString();
  3673. gc.CFOF = List_GC[i].CFOF.ToString() == "0" ? "/" : List_GC[i].CFOF.ToString();
  3674. gc.B = List_GC[i].B.ToString() == "0" ? "/" : List_GC[i].B.ToString();
  3675. gc.L = List_GC[i].L.ToString() == "0" ? "/" : List_GC[i].L.ToString();
  3676. gc.D = List_GC[i].D.ToString() == "0" ? "/" : List_GC[i].D.ToString();
  3677. gc.TBR = List_GC[i].TBR.ToString() == "0" ? "/" : List_GC[i].TBR.ToString();
  3678. gc.SGR = List_GC[i].SGR.ToString() == "0" ? "/" : List_GC[i].SGR.ToString();
  3679. gc.JS_ES = List_GC[i].JS_ES.ToString() == "0" ? "/" : List_GC[i].JS_ES.ToString();
  3680. gc.Suite = List_GC[i].Suite.ToString() == "0" ? "/" : List_GC[i].Suite.ToString();
  3681. gc.ACCON = List_GC[i].ACCON.ToString() == "0" ? "/" : List_GC[i].ACCON.ToString();
  3682. gc.TV = List_GC[i].TV.ToString() == "0" ? "/" : List_GC[i].TV.ToString();
  3683. gc.iL = List_GC[i].iL.ToString() == "0" ? "/" : List_GC[i].iL.ToString();
  3684. gc.IF = List_GC[i].IF.ToString() == "0" ? "/" : List_GC[i].IF.ToString();
  3685. gc.EF = List_GC[i].EF.ToString() == "0" ? "/" : List_GC[i].EF.ToString();
  3686. gc.B_R_F = List_GC[i].B_R_F.ToString() == "0" ? "/" : List_GC[i].B_R_F.ToString();
  3687. gc.TE = List_GC[i].TE.ToString() == "0" ? "/" : List_GC[i].TE.ToString();
  3688. gc.TGTips = List_GC[i].TGTips.ToString() == "0" ? "/" : List_GC[i].TGTips.ToString();
  3689. gc.DRVTips = List_GC[i].DRVTips.ToString() == "0" ? "/" : List_GC[i].DRVTips.ToString();
  3690. gc.PC = List_GC[i].PC.ToString() == "0" ? "/" : List_GC[i].PC.ToString();
  3691. gc.TLF = List_GC[i].TLF.ToString() == "0" ? "/" : List_GC[i].TLF.ToString();
  3692. gc.ECT = List_GC[i].ECT.ToString() == "0" ? "/" : List_GC[i].ECT.ToString();
  3693. List_GC1.Add(gc);
  3694. }
  3695. var dt = CommonFun.GetDataTableFromIList(List_GC1);
  3696. dt.TableName = "TB";
  3697. //报表标题等不用dt的值
  3698. designer.SetDataSource("TeamName", dto.title.TeamName);
  3699. designer.SetDataSource("Pnumber", dto.title.GroupNumber);
  3700. designer.SetDataSource("Tax", dto.title.Tax);
  3701. //designer.SetDataSource("FFYS", lblHotelCB.Text);
  3702. designer.SetDataSource("Currency", dto.title.Currency);
  3703. //designer.SetDataSource("HotelXS", txtHotelXS.Text);
  3704. designer.SetDataSource("Rate", dto.title.Rate);
  3705. //酒店 标间 单间 套房 小套房 小套房/豪华套房 等 间数
  3706. //酒店数量
  3707. //designer.SetDataSource("SGRNumber", txtSGRNumber.Text);
  3708. //designer.SetDataSource("TBRNumber", txtTBRNumber.Text);
  3709. //designer.SetDataSource("JSESNumber", txtJSESNumber.Text);
  3710. //designer.SetDataSource("SUITENumber", txtSUITENumber.Text);
  3711. //#region
  3712. //designer.SetDataSource("VisaName", "签证(CNY)");
  3713. //designer.SetDataSource("VisaDRCB", txtVisaCost.Text);
  3714. //designer.SetDataSource("VisaRS", txtVisaNum.Text);
  3715. //designer.SetDataSource("VisaXS", txtVisaXS.Text);
  3716. //designer.SetDataSource("VisaZCB", lblVisaZCB.Text);
  3717. //designer.SetDataSource("VisaDRBJ", lblVisaDRBJ.Text);
  3718. //designer.SetDataSource("VisaZBJ", lblVisaZBJ.Text);
  3719. //designer.SetDataSource("VisaDRLR", lblVisaDRLR.Text);
  3720. //designer.SetDataSource("VisaZLR", lblVisaZLR.Text);
  3721. //designer.SetDataSource("BXName", "保险(CNY)");
  3722. //designer.SetDataSource("BXDRCB", txtBXCB.Text);
  3723. //designer.SetDataSource("BXRS", txtBXRS.Text);
  3724. //designer.SetDataSource("BXXS", txtBXXS.Text);
  3725. //designer.SetDataSource("BXZCB", lblBXZCB.Text);
  3726. //designer.SetDataSource("BXDRBJ", lblBXDRBJ.Text);
  3727. //designer.SetDataSource("BXZBJ", lblBXZBJ.Text);
  3728. //designer.SetDataSource("BXDRLR", lblBXDRLR.Text);
  3729. //designer.SetDataSource("BXZLR", lblBXZLR.Text);
  3730. //designer.SetDataSource("HSName", "核酸检测(CNY)");
  3731. //designer.SetDataSource("HSDRCB", txtHSCB.Text);
  3732. //designer.SetDataSource("HSRS", txtHSRS.Text);
  3733. //designer.SetDataSource("HSXS", txtHSXS.Text);
  3734. //designer.SetDataSource("HSZCB", lblHSZCB.Text);
  3735. //designer.SetDataSource("HSDRBJ", lblHSDRBJ.Text);
  3736. //designer.SetDataSource("HSZBJ", lblHSZBJ.Text);
  3737. //designer.SetDataSource("HSDRLR", lblHSDRLR.Text);
  3738. //designer.SetDataSource("HSZLR", lblHSZLR.Text);
  3739. //designer.SetDataSource("AirJJCName", "机票-经济舱(CNY)");
  3740. //designer.SetDataSource("JPJJCCB", tbJJCCB.Text);
  3741. //designer.SetDataSource("JPJJCPnum", tbJJCPnum.Text);
  3742. //designer.SetDataSource("JPJJCXS", BtxtJPJJCXS.Text);
  3743. //designer.SetDataSource("JPJJCZCB", lbJJCZCB.Text);
  3744. //designer.SetDataSource("JPJJCDRBJ", lblJJCDRBJ.Text);
  3745. //designer.SetDataSource("JPJJCZBJ", lblJJCZBJ.Text);
  3746. //designer.SetDataSource("JPJJCDRLR", lblJJCDRLR.Text);
  3747. //designer.SetDataSource("JPJJCZLR", LBLJJCZLR.Text);
  3748. //designer.SetDataSource("AirGWCName", "机票-公务舱(CNY)");
  3749. //designer.SetDataSource("JPGWCCB", tbGWCCB.Text);
  3750. //designer.SetDataSource("JPGWCPNum", tbGWCPNum.Text);
  3751. //designer.SetDataSource("JPGWCXS", txtJPGWCXS.Text);
  3752. //designer.SetDataSource("JPGWCZCB", lbGWCZCB.Text);
  3753. //designer.SetDataSource("JPGWCDRBJ", lblGWCDRBJ.Text);
  3754. //designer.SetDataSource("JPGWCZBJ", lblGWCZBJ.Text);
  3755. //designer.SetDataSource("JPGWCDRLR", lblGWCDRLR.Text);
  3756. //designer.SetDataSource("JPGWCZLR", lblGWCZLR.Text);
  3757. //designer.SetDataSource("HCPCB", txtHCPCB.Text);
  3758. //designer.SetDataSource("HCPRS", txtHCPRS.Text);
  3759. //designer.SetDataSource("HCPXS", txtHCPXS.Text);
  3760. //designer.SetDataSource("HCPZCB", lblHCPZCB.Text);
  3761. //designer.SetDataSource("HCPDRBJ", lblHCPDRBJ.Text);
  3762. //designer.SetDataSource("HCPZBJ", lblHCPZBJ.Text);
  3763. //designer.SetDataSource("HCPDRLR", lblHCPDRLR.Text);
  3764. //designer.SetDataSource("HCPZLR", lblHCPZLR.Text);
  3765. //designer.SetDataSource("CPCB", txtCPCB.Text);
  3766. //designer.SetDataSource("CPRS", txtCPRS.Text);
  3767. //designer.SetDataSource("CPXS", txtCPXS.Text);
  3768. //designer.SetDataSource("CPZCB", lblCPZCB.Text);
  3769. //designer.SetDataSource("CPDRBJ", lblCPDRBJ.Text);
  3770. //designer.SetDataSource("CPZBJ", lblCPZBJ.Text);
  3771. //designer.SetDataSource("CPDRLR", lblCPDRLR.Text);
  3772. //designer.SetDataSource("CPZLR", lblCPZLR.Text);
  3773. ////TBR
  3774. //designer.SetDataSource("HotelTBRDRCB", lblHotelTBRDRCB.Text);
  3775. //designer.SetDataSource("HotelTBRRS", txtHotelTBRRS.Text);
  3776. //designer.SetDataSource("HotelTBRXS", txtHoteLTBRXS.Text);
  3777. //designer.SetDataSource("HotelTBRCB", lblHotelTBRCB.Text);
  3778. //designer.SetDataSource("HotelTBRDRBJ", lblHotelTBRDRBJ.Text);
  3779. //designer.SetDataSource("HotelTBRZBJ", lblHotelTBRZBJ.Text);
  3780. //designer.SetDataSource("HotelTBRDRLR", lblHotelTBRDRLR.Text);
  3781. //designer.SetDataSource("HotelTBRZLR", lblHotelTBRZLR.Text);
  3782. ////SGR
  3783. //designer.SetDataSource("HotelSGRDRCB", lblHotelSGRDRCB.Text);
  3784. //designer.SetDataSource("HotelSGRRS", txtHotelSGRRS.Text);
  3785. //designer.SetDataSource("HotelSGRXS", txtHotelSGRXS.Text);
  3786. //designer.SetDataSource("HotelSGRCB", lblHotelSGRZCB.Text);
  3787. //designer.SetDataSource("HotelSGRDRBJ", lblHotelSGRDRBJ.Text);
  3788. //designer.SetDataSource("HotelSGRZBJ", lblHotelSGRZBJ.Text);
  3789. //designer.SetDataSource("HotelSGRDRLR", lblHotelSGRDRLR.Text);
  3790. //designer.SetDataSource("HotelSGRZLR", lblHotelSGRZLR.Text);
  3791. ////JS/ES
  3792. //designer.SetDataSource("HotelJSESDRCB", lblHotelJSESDRCB.Text);
  3793. //designer.SetDataSource("HotelJSESRS", txtHotelJSESRS.Text);
  3794. //designer.SetDataSource("HotelJSESXS", txtHotelJSESXS.Text);
  3795. //designer.SetDataSource("HotelJSESCB", lblHotelJSESZCB.Text);
  3796. //designer.SetDataSource("HotelJSESDRBJ", lblHotelJSESDRBJ.Text);
  3797. //designer.SetDataSource("HotelJSESZBJ", lblHotelJSESZBJ.Text);
  3798. //designer.SetDataSource("HotelJSESDRLR", lblHotelJSESDRLR.Text);
  3799. //designer.SetDataSource("HotelJSESZLR", lblHotelJSESZLR.Text);
  3800. ////SUITE
  3801. //designer.SetDataSource("HotelSUITEDRCB", lblHotelSUITEDRCB.Text);
  3802. //designer.SetDataSource("HotelSUITERS", txtHotelSUITERS.Text);
  3803. //designer.SetDataSource("HotelSUITEXS", txtHotelSUITEXS.Text);
  3804. //designer.SetDataSource("HotelSUITECB", lblHotelSUITEZCB.Text);
  3805. //designer.SetDataSource("HotelSUITEDRBJ", lblHotelSUITEDRBJ.Text);
  3806. //designer.SetDataSource("HotelSUITEZBJ", lblHotelSUITEZBJ.Text);
  3807. //designer.SetDataSource("HotelSUITEDRLR", lblHotelSUITEDRLR.Text);
  3808. //designer.SetDataSource("HotelSUITEZLR", lblHotelSUITEZLR.Text);
  3809. //designer.SetDataSource("DJDRCB", lblDJDRCB.Text);
  3810. //designer.SetDataSource("DJRS", txtDJRS.Text);
  3811. //designer.SetDataSource("DJXS", txtDJXS.Text);
  3812. //designer.SetDataSource("DJCB", lblDJCB.Text);
  3813. //designer.SetDataSource("DJDRBJ", lblDJDRBJ.Text);
  3814. //designer.SetDataSource("DJZBJ", lblDJZBJ.Text);
  3815. //designer.SetDataSource("DJDRLR", lblDJDRLR.Text);
  3816. //designer.SetDataSource("DJZLR", lblDJZLR.Text);
  3817. //designer.SetDataSource("GWDRCD", lblGWDRCD.Text);
  3818. //designer.SetDataSource("GWRS", txtGWRS.Text);
  3819. //designer.SetDataSource("GWXS", txtGWXS.Text);
  3820. //designer.SetDataSource("GWCB", lblGWCB.Text);
  3821. //designer.SetDataSource("GWDRBJ", lblGWDRBJ.Text);
  3822. //designer.SetDataSource("GWZBJ", lblGWZBJ.Text);
  3823. //designer.SetDataSource("GWDRLR", lblGWDRLR.Text);
  3824. //designer.SetDataSource("GWZLR", lblGWZLR.Text);
  3825. //designer.SetDataSource("LYJDRCB", lblLYJDRCB.Text);
  3826. //designer.SetDataSource("LYJRS", txtLYJRS.Text);
  3827. //designer.SetDataSource("LYJXS", txtLYJXS.Text);
  3828. //designer.SetDataSource("LYJCB", lblLYJCB.Text);
  3829. //designer.SetDataSource("LYJDRBJ", lblLYJDRBJ.Text);
  3830. //designer.SetDataSource("LYJZBJ", lblLYJZBJ.Text);
  3831. //designer.SetDataSource("LYJDRLR", lblLYJDRLR.Text);
  3832. //designer.SetDataSource("LYJZLR", lblLYJZLR.Text);
  3833. //#endregion
  3834. designer.SetDataSource(dt);
  3835. designer.Workbook.Worksheets[0].Name = "清单";
  3836. return Ok();
  3837. }
  3838. #endregion
  3839. #region 酒店预定 保留
  3840. /// <summary>
  3841. /// 酒店预订页面初始化绑定
  3842. /// </summary>
  3843. /// <param name="dto"></param>
  3844. /// <returns></returns>
  3845. [HttpPost]
  3846. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3847. public async Task<IActionResult> HotelReservationsInitialize(HotelReservationsDto dto)
  3848. {
  3849. try
  3850. {
  3851. Result groupData = await _hotelPriceRep.HotelReservationsInitialize(dto);
  3852. if (groupData.Code != 0)
  3853. {
  3854. return Ok(JsonView(false, groupData.Msg));
  3855. }
  3856. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3857. }
  3858. catch (Exception ex)
  3859. {
  3860. return Ok(JsonView(false, ex.Message));
  3861. }
  3862. }
  3863. /// <summary>
  3864. /// 根据团组Id查询酒店费用列表
  3865. /// </summary>
  3866. /// <param name="dto"></param>
  3867. /// <returns></returns>
  3868. [HttpPost]
  3869. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3870. public async Task<IActionResult> HotelReservationsByDiId(HotelReservationsByDiIdDto dto)
  3871. {
  3872. try
  3873. {
  3874. Result groupData = await _hotelPriceRep.HotelReservationsByDiId(dto);
  3875. if (groupData.Code != 0)
  3876. {
  3877. return Ok(JsonView(false, groupData.Msg));
  3878. }
  3879. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3880. }
  3881. catch (Exception ex)
  3882. {
  3883. return Ok(JsonView(false, ex.Message));
  3884. }
  3885. }
  3886. /// <summary>
  3887. /// 根据酒店费用Id查询酒店费用详细
  3888. /// </summary>
  3889. /// <param name="dto"></param>
  3890. /// <returns></returns>
  3891. [HttpPost]
  3892. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3893. public async Task<IActionResult> HotelReservationsById(HotelReservationsByIdDto dto)
  3894. {
  3895. try
  3896. {
  3897. Result groupData = await _hotelPriceRep.HotelReservationsById(dto);
  3898. if (groupData.Code != 0)
  3899. {
  3900. return Ok(JsonView(false, groupData.Msg));
  3901. }
  3902. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3903. }
  3904. catch (Exception ex)
  3905. {
  3906. return Ok(JsonView(false, ex.Message));
  3907. }
  3908. }
  3909. /// <summary>
  3910. /// 计算酒店付款总金额
  3911. /// </summary>
  3912. /// <param name="dto"></param>
  3913. /// <returns></returns>
  3914. [HttpPost]
  3915. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3916. public async Task<IActionResult> HotelConversionAmounts(HotelReservationsCNYDto dto)
  3917. {
  3918. try
  3919. {
  3920. Result groupData = await _hotelPriceRep.HotelConversionAmounts(dto);
  3921. if (groupData.Code != 0)
  3922. {
  3923. return Ok(JsonView(false, groupData.Msg));
  3924. }
  3925. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3926. }
  3927. catch (Exception ex)
  3928. {
  3929. return Ok(JsonView(false, ex.Message));
  3930. }
  3931. }
  3932. /// <summary>
  3933. /// 酒店费用操作(Status:1.新增,2.修改)
  3934. /// </summary>
  3935. /// <param name="dto"></param>
  3936. /// <returns></returns>
  3937. [HttpPost]
  3938. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3939. public async Task<IActionResult> OpHotelReservations(OpHotelReservationsData dto)
  3940. {
  3941. try
  3942. {
  3943. Result groupData = await _hotelPriceRep.OpHotelReservations(dto);
  3944. if (groupData.Code != 0)
  3945. {
  3946. return Ok(JsonView(false, groupData.Msg));
  3947. }
  3948. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  3949. }
  3950. catch (Exception ex)
  3951. {
  3952. return Ok(JsonView(false, ex.Message));
  3953. }
  3954. }
  3955. /// <summary>
  3956. /// 文件上传
  3957. /// </summary>
  3958. /// <param name="file"></param>
  3959. /// <returns></returns>
  3960. [HttpPost]
  3961. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  3962. public async Task<IActionResult> UploadHotel(IFormFile file)
  3963. {
  3964. try
  3965. {
  3966. if (file != null)
  3967. {
  3968. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  3969. //文件名称
  3970. string projectFileName = file.FileName;
  3971. //上传的文件的路径
  3972. string filePath = "";
  3973. if (!Directory.Exists(fileDir))
  3974. {
  3975. Directory.CreateDirectory(fileDir);
  3976. }
  3977. //上传的文件的路径
  3978. filePath = fileDir + $@"\酒店费用录入相关文件\{projectFileName}";
  3979. using (FileStream fs = System.IO.File.Create(filePath))
  3980. {
  3981. file.CopyTo(fs);
  3982. fs.Flush();
  3983. }
  3984. return Ok(JsonView(true, "上传成功!", projectFileName));
  3985. }
  3986. else
  3987. {
  3988. return Ok(JsonView(false, "上传失败!"));
  3989. }
  3990. }
  3991. catch (Exception ex)
  3992. {
  3993. return Ok(JsonView(false, "程序错误!"));
  3994. throw;
  3995. }
  3996. }
  3997. /// <summary>
  3998. /// 删除指定文件
  3999. /// </summary>
  4000. /// <param name="dto"></param>
  4001. /// <returns></returns>
  4002. [HttpPost]
  4003. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4004. public async Task<IActionResult> DelFileHotel(DelFileDto dto)
  4005. {
  4006. try
  4007. {
  4008. string filePath = "";
  4009. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  4010. // 返回与指定虚拟路径相对应的物理路径即绝对路径
  4011. //int id = 0;
  4012. filePath = fileDir + "/酒店费用录入相关文件/" + dto.fileName;
  4013. // 删除该文件
  4014. try
  4015. {
  4016. System.IO.File.Delete(filePath);
  4017. var result = await _sqlSugar.Updateable<Grp_HotelReservations>().Where(a => a.Id == dto.Id && a.IsDel == 0).SetColumns(a => new Grp_HotelReservations()
  4018. {
  4019. Attachment = "",
  4020. }).ExecuteCommandAsync();
  4021. if (result != 0)
  4022. {
  4023. return Ok(JsonView(true, "成功!"));
  4024. }
  4025. else
  4026. {
  4027. return Ok(JsonView(false, "失败!"));
  4028. }
  4029. }
  4030. catch (Exception)
  4031. {
  4032. var result = await _sqlSugar.Updateable<Grp_HotelReservations>().Where(a => a.Id == dto.Id && a.IsDel == 0).SetColumns(a => new Grp_HotelReservations()
  4033. {
  4034. Attachment = "",
  4035. }).ExecuteCommandAsync();
  4036. if (result != 0)
  4037. {
  4038. return Ok(JsonView(true, "成功!"));
  4039. }
  4040. else
  4041. {
  4042. return Ok(JsonView(false, "失败!"));
  4043. }
  4044. throw;
  4045. }
  4046. }
  4047. catch (Exception ex)
  4048. {
  4049. return Ok(JsonView(false, "程序错误!"));
  4050. throw;
  4051. }
  4052. }
  4053. /// <summary>
  4054. /// 生成VOUCHER
  4055. /// </summary>
  4056. /// <param name=""></param>
  4057. /// <returns></returns>
  4058. [HttpPost]
  4059. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4060. public async Task<IActionResult> HotelGenerate(HotelReservationsByIdDto dto)
  4061. {
  4062. Grp_HotelReservations h = _sqlSugar.Queryable<Grp_HotelReservations>().First(a => a.Id == dto.Id && a.IsDel == 0);
  4063. //判断数据是否完整
  4064. if (h != null)
  4065. {
  4066. if (!string.IsNullOrEmpty(h.DetermineNo))
  4067. {
  4068. string strFileName = "HotelStatement/";
  4069. Grp_DelegationInfo dele = _sqlSugar.Queryable<Grp_DelegationInfo>().First(a => a.Id == h.DiId && a.IsDel == 0);
  4070. if (dele != null)
  4071. strFileName += dele.TourCode;
  4072. //载入模板
  4073. string sss = AppSettingsHelper.Get("WordBasePath") + "Template/酒店预订模板.doc";
  4074. Document doc = new Document(sss);
  4075. DocumentBuilder builder = new DocumentBuilder(doc);
  4076. try
  4077. {
  4078. #region 替换Word模板书签内容
  4079. //这里可以创建个DataTable循环添加书签的值,这里提示一下就不多做修改了
  4080. //入住卷预定号码
  4081. if (doc.Range.Bookmarks["VNO"] != null)
  4082. {
  4083. Bookmark mark = doc.Range.Bookmarks["VNO"];
  4084. mark.Text = h.CheckNumber;
  4085. }
  4086. //酒店时间
  4087. if (doc.Range.Bookmarks["Date"] != null)
  4088. {
  4089. Bookmark mark = doc.Range.Bookmarks["Date"];
  4090. mark.Text = Convert.ToDateTime(h.CreateTime).ToString("yyyy-MM-dd");
  4091. }
  4092. //团号
  4093. if (doc.Range.Bookmarks["TNo"] != null)
  4094. {
  4095. Bookmark mark = doc.Range.Bookmarks["TNo"];
  4096. mark.Text = dele.TourCode;
  4097. }
  4098. //预定号码
  4099. if (doc.Range.Bookmarks["BookingId"] != null)
  4100. {
  4101. Bookmark mark = doc.Range.Bookmarks["BookingId"];
  4102. mark.Text = h.ReservationsNo;
  4103. }
  4104. if (doc.Range.Bookmarks["HotelConfirmNo"] != null)
  4105. {
  4106. Bookmark mark = doc.Range.Bookmarks["HotelConfirmNo"];
  4107. mark.Text = h.DetermineNo;
  4108. }
  4109. //酒店城市
  4110. if (doc.Range.Bookmarks["City"] != null)
  4111. {
  4112. Bookmark mark = doc.Range.Bookmarks["City"];
  4113. mark.Text = h.City;
  4114. }
  4115. //酒店名称
  4116. if (doc.Range.Bookmarks["HName"] != null)
  4117. {
  4118. Bookmark mark = doc.Range.Bookmarks["HName"];
  4119. mark.Text = h.HotelName;
  4120. }
  4121. //酒店地址
  4122. if (doc.Range.Bookmarks["Address"] != null)
  4123. {
  4124. Bookmark mark = doc.Range.Bookmarks["Address"];
  4125. mark.Text = h.HotelAddress;
  4126. }
  4127. //酒店电话
  4128. if (doc.Range.Bookmarks["Tel"] != null)
  4129. {
  4130. Bookmark mark = doc.Range.Bookmarks["Tel"];
  4131. mark.Text = h.HotelTel;
  4132. }
  4133. //酒店传真
  4134. if (doc.Range.Bookmarks["Fax"] != null)
  4135. {
  4136. Bookmark mark = doc.Range.Bookmarks["Fax"];
  4137. if (!string.IsNullOrWhiteSpace(h.HotelFax))
  4138. {
  4139. mark.Text = h.HotelFax;
  4140. }
  4141. }
  4142. //入住时间
  4143. if (doc.Range.Bookmarks["CIn"] != null)
  4144. {
  4145. DateTime dtCheckIn = Convert.ToDateTime(h.CheckInDate);
  4146. Bookmark mark = doc.Range.Bookmarks["CIn"];
  4147. mark.Text = dtCheckIn.Day + " " + dtCheckIn.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckIn.Year;
  4148. }
  4149. //退房时间
  4150. if (doc.Range.Bookmarks["COut"] != null)
  4151. {
  4152. DateTime dtCheckOut = Convert.ToDateTime(h.CheckOutDate);
  4153. Bookmark mark = doc.Range.Bookmarks["COut"];
  4154. mark.Text = dtCheckOut.Day + " " + dtCheckOut.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckOut.Year;
  4155. }
  4156. //客户名称
  4157. if (doc.Range.Bookmarks["GName"] != null)
  4158. {
  4159. Bookmark mark = doc.Range.Bookmarks["GName"];
  4160. mark.Text = h.GuestName;
  4161. }
  4162. //房间介绍
  4163. if (doc.Range.Bookmarks["ROOM"] != null)
  4164. {
  4165. Bookmark mark = doc.Range.Bookmarks["ROOM"];
  4166. mark.Text = h.RoomExplanation;
  4167. }
  4168. //报价描述
  4169. if (doc.Range.Bookmarks["NOTE"] != null)
  4170. {
  4171. Bookmark mark = doc.Range.Bookmarks["NOTE"];
  4172. Sys_SetData ss = _sqlSugar.Queryable<Sys_SetData>().First(a => a.Id == h.ReservationsWebsite);
  4173. if (ss != null)
  4174. mark.Text = ss.Name;
  4175. }
  4176. //入住时间
  4177. if (doc.Range.Bookmarks["CheckIn"] != null)
  4178. {
  4179. DateTime dtCheckIn = Convert.ToDateTime(h.CheckInDate);
  4180. Bookmark mark = doc.Range.Bookmarks["CheckIn"];
  4181. mark.Text = dtCheckIn.Day + " " + dtCheckIn.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckIn.Year + " ";
  4182. }
  4183. //退房时间
  4184. if (doc.Range.Bookmarks["CheckOut"] != null)
  4185. {
  4186. DateTime dtCheckOut = Convert.ToDateTime(h.CheckOutDate);
  4187. Bookmark mark = doc.Range.Bookmarks["CheckOut"];
  4188. mark.Text = " " + dtCheckOut.Day + " " + dtCheckOut.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckOut.Year;
  4189. }
  4190. //日期
  4191. if (doc.Range.Bookmarks["DT"] != null)
  4192. {
  4193. Bookmark mark = doc.Range.Bookmarks["DT"];
  4194. mark.Text = Convert.ToDateTime(h.CreateTime).ToString("yyyy-MM-dd");
  4195. }
  4196. //名称
  4197. if (doc.Range.Bookmarks["VName"] != null)
  4198. {
  4199. Bookmark mark = doc.Range.Bookmarks["VName"];
  4200. mark.Text = h.HotelName;
  4201. }
  4202. //号码
  4203. if (doc.Range.Bookmarks["VOUCHERNO"] != null)
  4204. {
  4205. Bookmark mark = doc.Range.Bookmarks["VOUCHERNO"];
  4206. mark.Text = h.CheckNumber;
  4207. }
  4208. #endregion
  4209. //string fileName = "HotelStatement/" + diName + "机票费用报表" + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
  4210. strFileName += "VOUCHER.doc";
  4211. var fileDir = AppSettingsHelper.Get("WordBasePath") + strFileName;
  4212. doc.Save(fileDir);
  4213. string Url = AppSettingsHelper.Get("WordBaseUrl") + "Office/Word/" + strFileName;
  4214. return Ok(JsonView(true, "成功!", Url));
  4215. }
  4216. catch (Exception ex)
  4217. {
  4218. throw;
  4219. }
  4220. }
  4221. else
  4222. {
  4223. return Ok(JsonView(false, "酒店确定号码未填写,无法生成Voucher!"));
  4224. }
  4225. }
  4226. else
  4227. {
  4228. return Ok(JsonView(false, "酒店确定号码未填写,无法生成Voucher!"));
  4229. }
  4230. }
  4231. /// <summary>
  4232. /// 导出确认单
  4233. /// </summary>
  4234. /// <param name=""></param>
  4235. /// <returns></returns>
  4236. [HttpPost]
  4237. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4238. public async Task<IActionResult> ConfirmWord(HotelReservationsByIdDto dto)
  4239. {
  4240. //团组信息
  4241. Grp_DelegationInfo di = _sqlSugar.Queryable<Grp_DelegationInfo>().First(a => a.Id == dto.Id);
  4242. //酒店数据
  4243. List<Grp_HotelReservations> listhoteldata = _sqlSugar.Queryable<Grp_HotelReservations>().Where(a => a.DiId == dto.Id && a.IsDel == 0).ToList();
  4244. //利datatable存储
  4245. DataTable dt = new DataTable();
  4246. dt.Columns.Add("CheckInDate", typeof(string));
  4247. dt.Columns.Add("City", typeof(string));
  4248. dt.Columns.Add("Hotel", typeof(string));
  4249. dt.Columns.Add("Room", typeof(string));
  4250. for (int i = 0; i < listhoteldata.Count; i++)
  4251. {
  4252. DateTime dayStart = Convert.ToDateTime(listhoteldata[i].CheckInDate);
  4253. DateTime dayEnd = Convert.ToDateTime(listhoteldata[i].CheckOutDate);
  4254. while (dayStart < dayEnd)
  4255. {
  4256. string temp = "";
  4257. DataRow row = dt.NewRow();
  4258. row["CheckInDate"] = dayStart.ToString("yyyy-MM-dd");
  4259. row["City"] = listhoteldata[i].City;
  4260. row["Hotel"] = listhoteldata[i].HotelName;
  4261. if (listhoteldata[i].SingleRoomCount > 0)
  4262. {
  4263. temp = listhoteldata[i].SingleRoomCount + "个单间" + "\r\n";
  4264. }
  4265. if (listhoteldata[i].DoubleRoomCount > 0)
  4266. {
  4267. temp = temp + listhoteldata[i].DoubleRoomCount + "个表间" + "\r\n";
  4268. }
  4269. if (listhoteldata[i].SuiteRoomCount > 0)
  4270. {
  4271. temp = temp + listhoteldata[i].SuiteRoomCount + "个套房" + "\r\n";
  4272. }
  4273. if (listhoteldata[i].OtherRoomCount > 0)
  4274. {
  4275. temp = temp + listhoteldata[i].OtherRoomCount + "个其他房型" + "\r\n";
  4276. }
  4277. row["Room"] = temp;
  4278. dt.Rows.Add(row);
  4279. dayStart = dayStart.AddDays(1);
  4280. }
  4281. }
  4282. Dictionary<string, string> dic = new Dictionary<string, string>();
  4283. dic.Add("Dele", di.TeamName);
  4284. dic.Add("City", di.VisitCountry);
  4285. //模板路径
  4286. string tempPath = AppSettingsHelper.Get("WordBasePath") + "Template/酒店用房确认单-模板.doc";
  4287. //载入模板
  4288. Aspose.Words.Document doc = new Aspose.Words.Document(tempPath);
  4289. DocumentBuilder builder = new DocumentBuilder(doc);
  4290. foreach (var key in dic.Keys)
  4291. {
  4292. builder.MoveToBookmark(key);
  4293. builder.Write(dic[key]);
  4294. }
  4295. //获取word里所有表格
  4296. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  4297. //获取所填表格的序数
  4298. Aspose.Words.Tables.Table tableOne = allTables[0] as Aspose.Words.Tables.Table;
  4299. var rowStart = tableOne.Rows[0]; //获取第1行
  4300. try
  4301. {
  4302. //循环赋值
  4303. for (int i = 0; i < dt.Rows.Count; i++)
  4304. {
  4305. builder.MoveToCell(0, i + 1, 0, 0);
  4306. builder.Write(dt.Rows[i]["CheckInDate"].ToString());
  4307. builder.MoveToCell(0, i + 1, 1, 0);
  4308. builder.Write(dt.Rows[i]["City"].ToString());
  4309. builder.MoveToCell(0, i + 1, 2, 0);
  4310. builder.Write(dt.Rows[i]["Hotel"].ToString());
  4311. builder.MoveToCell(0, i + 1, 3, 0);
  4312. builder.Write(dt.Rows[i]["Room"].ToString());
  4313. }
  4314. }
  4315. catch
  4316. {
  4317. }
  4318. //删除多余行
  4319. while (tableOne.Rows.Count > dt.Rows.Count + 1)
  4320. {
  4321. tableOne.Rows.RemoveAt(dt.Rows.Count + 1);
  4322. }
  4323. string strFileName = di.TeamName + "酒店确认单.doc";
  4324. try
  4325. {
  4326. doc.Save(AppSettingsHelper.Get("WordBasePath") + "HotelStatement/" + strFileName);
  4327. string Url = AppSettingsHelper.Get("WordBaseUrl") + "Office/Word/HotelStatement/" + strFileName;
  4328. return Ok(JsonView(true, "成功", Url));
  4329. }
  4330. catch (Exception)
  4331. {
  4332. return Ok(JsonView(false, "当前文档已打开,请先关闭!"));
  4333. throw;
  4334. }
  4335. }
  4336. /// <summary>
  4337. /// 酒店费用删除
  4338. /// </summary>
  4339. /// <param name="dto"></param>
  4340. /// <returns></returns>
  4341. [HttpPost]
  4342. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4343. public async Task<IActionResult> DelHotelPrice(DelBaseDto dto)
  4344. {
  4345. try
  4346. {
  4347. var res = await _hotelPriceRep.SoftDeleteByIdAsync<Grp_HotelReservations>(dto.Id.ToString(), dto.DeleteUserId);
  4348. if (!res)
  4349. {
  4350. return Ok(JsonView(false, "删除失败"));
  4351. }
  4352. var resultC = await _sqlSugar.Updateable<Grp_CreditCardPayment>().Where(a => a.CId == dto.Id && a.IsDel == 0 && a.CTable == 76).SetColumns(a => new Grp_CreditCardPayment()
  4353. {
  4354. IsDel = 1,
  4355. DeleteUserId = dto.DeleteUserId,
  4356. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  4357. }).ExecuteCommandAsync();
  4358. return Ok(JsonView(true, "删除成功!"));
  4359. }
  4360. catch (Exception ex)
  4361. {
  4362. return Ok(JsonView(false, "程序错误!"));
  4363. throw;
  4364. }
  4365. }
  4366. #endregion
  4367. #region 酒店预订 新 雷怡 2023-12-28 17:45
  4368. /// <summary>
  4369. /// 酒店预订
  4370. /// 酒店费用列表 根据团组Id查询
  4371. /// </summary>
  4372. /// <param name="_dto"></param>
  4373. /// <returns></returns>
  4374. [HttpPost]
  4375. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4376. public async Task<IActionResult> PostHotelReservationsItemsByDiId(HotelReservationItemDto _dto)
  4377. {
  4378. try
  4379. {
  4380. #region 参数验证
  4381. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4382. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4383. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4384. #region 团组操作权限验证 76 酒店预定模块
  4385. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4386. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4387. #endregion
  4388. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4389. #region 页面操作权限验证
  4390. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4391. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限!"));
  4392. #endregion
  4393. #endregion
  4394. Result _view = await _hotelPriceRep._ItemsByDiId(_dto.PortType, _dto.DiId);
  4395. if (_view.Code != 0)
  4396. {
  4397. return Ok(JsonView(false, _view.Msg));
  4398. }
  4399. return Ok(JsonView(true, _view.Msg, _view.Data));
  4400. }
  4401. catch (Exception ex)
  4402. {
  4403. return Ok(JsonView(false, ex.Message));
  4404. }
  4405. }
  4406. /// <summary>
  4407. /// 酒店预订
  4408. /// 基础数据
  4409. /// </summary>
  4410. /// <param name="_dto"></param>
  4411. /// <returns></returns>
  4412. [HttpPost]
  4413. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4414. public async Task<IActionResult> PostHotelReservationsBasicsDataInit(HotelReservationBasicsDataInitDto _dto)
  4415. {
  4416. try
  4417. {
  4418. #region 参数验证
  4419. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4420. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4421. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4422. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4423. #region 页面操作权限验证
  4424. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4425. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限!"));
  4426. #endregion
  4427. #region 团组操作权限验证 76 酒店预定模块
  4428. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4429. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4430. #endregion
  4431. #endregion
  4432. Result data = await _hotelPriceRep._BasicsDataInit(_dto.PortType, _dto.DiId);
  4433. if (data.Code != 0)
  4434. {
  4435. return Ok(JsonView(false, data.Msg));
  4436. }
  4437. return Ok(JsonView(true, data.Msg, data.Data));
  4438. }
  4439. catch (Exception ex)
  4440. {
  4441. return Ok(JsonView(false, "Catch:"+ex.Message));
  4442. }
  4443. }
  4444. /// <summary>
  4445. /// 酒店预订
  4446. /// 创建 入住卷号码
  4447. /// </summary>
  4448. /// <param name="_dto"></param>
  4449. /// <returns></returns>
  4450. [HttpPost]
  4451. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4452. public async Task<IActionResult> PostHotelReservationsCreateCheckVolumeNo(HotelReservationBasicsDataInitDto _dto)
  4453. {
  4454. try
  4455. {
  4456. #region 参数验证
  4457. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4458. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4459. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4460. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4461. #region 页面操作权限验证
  4462. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4463. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限!"));
  4464. #endregion
  4465. #region 团组操作权限验证 76 酒店预定模块
  4466. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4467. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4468. #endregion
  4469. #endregion
  4470. Result data = await _hotelPriceRep._CreateCheckVolumeNo(_dto.DiId);
  4471. if (data.Code != 0)
  4472. {
  4473. return Ok(JsonView(false, data.Msg));
  4474. }
  4475. return Ok(JsonView(true, data.Msg, data.Data));
  4476. }
  4477. catch (Exception ex)
  4478. {
  4479. return Ok(JsonView(false, ex.Message));
  4480. }
  4481. }
  4482. /// <summary>
  4483. /// 酒店预订
  4484. /// 详情
  4485. /// </summary>
  4486. /// <param name="_dto"></param>
  4487. /// <returns></returns>
  4488. [HttpPost]
  4489. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4490. public async Task<IActionResult> PostHotelReservationsDetails(HotelReservationsDetailsDto _dto)
  4491. {
  4492. try
  4493. {
  4494. #region 参数验证
  4495. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4496. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4497. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4498. #region 团组操作权限验证 76 酒店预定模块
  4499. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4500. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4501. #endregion
  4502. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4503. #region 页面操作权限验证
  4504. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4505. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限!"));
  4506. #endregion
  4507. #endregion
  4508. Result data = await _hotelPriceRep._Details(_dto.PortType,_dto.Id);
  4509. if (data.Code != 0)
  4510. {
  4511. return Ok(JsonView(false, data.Msg));
  4512. }
  4513. return Ok(JsonView(true, data.Msg, data.Data));
  4514. }
  4515. catch (Exception ex)
  4516. {
  4517. return Ok(JsonView(false, ex.Message));
  4518. }
  4519. }
  4520. /// <summary>
  4521. /// 酒店预订
  4522. /// Add Or Edit
  4523. /// </summary>
  4524. /// <param name="_dto"></param>
  4525. /// <returns></returns>
  4526. [HttpPost]
  4527. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4528. public async Task<IActionResult> PostHotelReservationsAddOrEdit(HotelReservationsAddOrEditDto _dto)
  4529. {
  4530. try
  4531. {
  4532. #region 参数验证
  4533. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4534. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4535. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4536. #region 团组操作权限验证 76 酒店预定模块
  4537. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4538. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4539. #endregion
  4540. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4541. #region 页面操作权限验证
  4542. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4543. if (_dto.Id == 0) // Add
  4544. if (pageFunAuthView.AddAuth == 0) return Ok(JsonView(false, "您没有添加权限!"));
  4545. else if (_dto.Id > 0) // Edit
  4546. if (pageFunAuthView.EditAuth == 0) return Ok(JsonView(false, "您没有编辑权限!"));
  4547. else return Ok(JsonView(false, "请输入正确的数据Id!"));
  4548. #endregion
  4549. #endregion
  4550. Result data = await _hotelPriceRep._AddOrEdit(_dto);
  4551. if (data.Code != 0)
  4552. {
  4553. return Ok(JsonView(false, data.Msg));
  4554. }
  4555. return Ok(JsonView(true, data.Msg, data.Data));
  4556. }
  4557. catch (Exception ex)
  4558. {
  4559. return Ok(JsonView(false, ex.Message));
  4560. }
  4561. }
  4562. /// <summary>
  4563. /// 酒店预订
  4564. /// Del
  4565. /// </summary>
  4566. /// <param name="_dto"></param>
  4567. /// <returns></returns>
  4568. [HttpPost]
  4569. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4570. public async Task<IActionResult> PostHotelReservationsDel(HotelReservationsDelDto _dto)
  4571. {
  4572. try
  4573. {
  4574. #region 参数验证
  4575. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4576. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4577. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4578. #region 团组操作权限验证 76 酒店预定模块
  4579. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4580. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4581. #endregion
  4582. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4583. #region 页面操作权限验证
  4584. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4585. if (pageFunAuthView.DeleteAuth == 0) return Ok(JsonView(false, "您没有删除权限!"));
  4586. #endregion
  4587. #endregion
  4588. Result data = await _hotelPriceRep._Del(_dto.Id, _dto.UserId);
  4589. if (data.Code != 0)
  4590. {
  4591. return Ok(JsonView(false, data.Msg));
  4592. }
  4593. return Ok(JsonView(true, data.Msg, data.Data));
  4594. }
  4595. catch (Exception ex)
  4596. {
  4597. return Ok(JsonView(false, ex.Message));
  4598. }
  4599. }
  4600. /// <summary>
  4601. /// 酒店预订
  4602. /// 生成VOUCHER
  4603. /// </summary>
  4604. /// <param name="_dto"></param>
  4605. /// <returns></returns>
  4606. [HttpPost]
  4607. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4608. public async Task<IActionResult> PostHotelReservationsCreateVoucher(HotelReservationsCreateVoucherDto _dto)
  4609. {
  4610. try
  4611. {
  4612. #region 参数验证
  4613. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4614. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4615. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4616. #region 团组操作权限验证 76 酒店预定模块
  4617. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4618. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4619. #endregion
  4620. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4621. #region 页面操作权限验证
  4622. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4623. if (pageFunAuthView.FilesDownloadAuth == 0) return Ok(JsonView(false, "您没有文件下载权限!"));
  4624. #endregion
  4625. #endregion
  4626. Grp_HotelReservations hr = await _sqlSugar.Queryable<Grp_HotelReservations>().Where(it => it.IsDel == 0 && it.Id == _dto.Id).FirstAsync();
  4627. //判断数据是否完整
  4628. if (hr != null)
  4629. {
  4630. if (!string.IsNullOrEmpty(hr.DetermineNo))
  4631. {
  4632. string strFileName = "HotelStatement/";
  4633. Grp_DelegationInfo dele = await _sqlSugar.Queryable<Grp_DelegationInfo>().Where(it => it.IsDel == 0 && it.Id == _dto.DiId).FirstAsync();
  4634. if (dele != null)
  4635. strFileName += dele.TourCode;
  4636. //载入模板
  4637. string sss = AppSettingsHelper.Get("WordBasePath") + "Template/酒店预订模板.doc";
  4638. Document doc = new Document(sss);
  4639. DocumentBuilder builder = new DocumentBuilder(doc);
  4640. #region 替换Word模板书签内容
  4641. //这里可以创建个DataTable循环添加书签的值,这里提示一下就不多做修改了
  4642. //入住卷预定号码
  4643. if (doc.Range.Bookmarks["VNO"] != null)
  4644. {
  4645. Bookmark mark = doc.Range.Bookmarks["VNO"];
  4646. mark.Text = hr.CheckNumber;
  4647. }
  4648. //酒店时间
  4649. if (doc.Range.Bookmarks["Date"] != null)
  4650. {
  4651. Bookmark mark = doc.Range.Bookmarks["Date"];
  4652. mark.Text = Convert.ToDateTime(hr.CreateTime).ToString("yyyy-MM-dd");
  4653. }
  4654. //团号
  4655. if (doc.Range.Bookmarks["TNo"] != null)
  4656. {
  4657. Bookmark mark = doc.Range.Bookmarks["TNo"];
  4658. mark.Text = dele.TourCode;
  4659. }
  4660. //预定号码
  4661. if (doc.Range.Bookmarks["BookingId"] != null)
  4662. {
  4663. Bookmark mark = doc.Range.Bookmarks["BookingId"];
  4664. mark.Text = hr.ReservationsNo;
  4665. }
  4666. if (doc.Range.Bookmarks["HotelConfirmNo"] != null)
  4667. {
  4668. Bookmark mark = doc.Range.Bookmarks["HotelConfirmNo"];
  4669. mark.Text = hr.DetermineNo;
  4670. }
  4671. //酒店城市
  4672. if (doc.Range.Bookmarks["City"] != null)
  4673. {
  4674. Bookmark mark = doc.Range.Bookmarks["City"];
  4675. mark.Text = hr.City;
  4676. }
  4677. //酒店名称
  4678. if (doc.Range.Bookmarks["HName"] != null)
  4679. {
  4680. Bookmark mark = doc.Range.Bookmarks["HName"];
  4681. mark.Text = hr.HotelName;
  4682. }
  4683. //酒店地址
  4684. if (doc.Range.Bookmarks["Address"] != null)
  4685. {
  4686. Bookmark mark = doc.Range.Bookmarks["Address"];
  4687. mark.Text = hr.HotelAddress;
  4688. }
  4689. //酒店电话
  4690. if (doc.Range.Bookmarks["Tel"] != null)
  4691. {
  4692. Bookmark mark = doc.Range.Bookmarks["Tel"];
  4693. mark.Text = hr.HotelTel;
  4694. }
  4695. //酒店传真
  4696. if (doc.Range.Bookmarks["Fax"] != null)
  4697. {
  4698. Bookmark mark = doc.Range.Bookmarks["Fax"];
  4699. if (!string.IsNullOrWhiteSpace(hr.HotelFax))
  4700. {
  4701. mark.Text = hr.HotelFax;
  4702. }
  4703. }
  4704. //入住时间
  4705. if (doc.Range.Bookmarks["CIn"] != null)
  4706. {
  4707. DateTime dtCheckIn = Convert.ToDateTime(hr.CheckInDate);
  4708. Bookmark mark = doc.Range.Bookmarks["CIn"];
  4709. mark.Text = dtCheckIn.Day + " " + dtCheckIn.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckIn.Year;
  4710. }
  4711. //退房时间
  4712. if (doc.Range.Bookmarks["COut"] != null)
  4713. {
  4714. DateTime dtCheckOut = Convert.ToDateTime(hr.CheckOutDate);
  4715. Bookmark mark = doc.Range.Bookmarks["COut"];
  4716. mark.Text = dtCheckOut.Day + " " + dtCheckOut.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckOut.Year;
  4717. }
  4718. //客户名称
  4719. if (doc.Range.Bookmarks["GName"] != null)
  4720. {
  4721. Bookmark mark = doc.Range.Bookmarks["GName"];
  4722. mark.Text = hr.GuestName;
  4723. }
  4724. //房间介绍
  4725. if (doc.Range.Bookmarks["ROOM"] != null)
  4726. {
  4727. Bookmark mark = doc.Range.Bookmarks["ROOM"];
  4728. mark.Text = hr.RoomExplanation;
  4729. }
  4730. //报价描述
  4731. if (doc.Range.Bookmarks["NOTE"] != null)
  4732. {
  4733. Bookmark mark = doc.Range.Bookmarks["NOTE"];
  4734. Sys_SetData ss = _sqlSugar.Queryable<Sys_SetData>().First(a => a.Id == hr.ReservationsWebsite);
  4735. if (ss != null)
  4736. mark.Text = ss.Name;
  4737. }
  4738. //入住时间
  4739. if (doc.Range.Bookmarks["CheckIn"] != null)
  4740. {
  4741. DateTime dtCheckIn = Convert.ToDateTime(hr.CheckInDate);
  4742. Bookmark mark = doc.Range.Bookmarks["CheckIn"];
  4743. mark.Text = dtCheckIn.Day + " " + dtCheckIn.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckIn.Year + " ";
  4744. }
  4745. //退房时间
  4746. if (doc.Range.Bookmarks["CheckOut"] != null)
  4747. {
  4748. DateTime dtCheckOut = Convert.ToDateTime(hr.CheckOutDate);
  4749. Bookmark mark = doc.Range.Bookmarks["CheckOut"];
  4750. mark.Text = " " + dtCheckOut.Day + " " + dtCheckOut.ToString("MMMM", CultureInfo.GetCultureInfo("en-US")) + " " + dtCheckOut.Year;
  4751. }
  4752. //日期
  4753. if (doc.Range.Bookmarks["DT"] != null)
  4754. {
  4755. Bookmark mark = doc.Range.Bookmarks["DT"];
  4756. mark.Text = Convert.ToDateTime(hr.CreateTime).ToString("yyyy-MM-dd");
  4757. }
  4758. //名称
  4759. if (doc.Range.Bookmarks["VName"] != null)
  4760. {
  4761. Bookmark mark = doc.Range.Bookmarks["VName"];
  4762. mark.Text = hr.HotelName;
  4763. }
  4764. //号码
  4765. if (doc.Range.Bookmarks["VOUCHERNO"] != null)
  4766. {
  4767. Bookmark mark = doc.Range.Bookmarks["VOUCHERNO"];
  4768. mark.Text = hr.CheckNumber;
  4769. }
  4770. #endregion
  4771. strFileName += "VOUCHER.doc";
  4772. var fileDir = AppSettingsHelper.Get("WordBasePath") + strFileName;
  4773. doc.Save(fileDir);
  4774. string Url = AppSettingsHelper.Get("WordBaseUrl") + "Office/Word/" + strFileName;
  4775. return Ok(JsonView(true, "操作成功!", Url));
  4776. }
  4777. else
  4778. {
  4779. return Ok(JsonView(false, "酒店确定号码未填写,无法生成Voucher!"));
  4780. }
  4781. }
  4782. else
  4783. {
  4784. return Ok(JsonView(false, "该条数据已删除或不存在!"));
  4785. }
  4786. }
  4787. catch (Exception ex)
  4788. {
  4789. return Ok(JsonView(false, ex.Message));
  4790. }
  4791. }
  4792. /// <summary>
  4793. /// 酒店预订
  4794. /// 确认单
  4795. /// </summary>
  4796. /// <param name="_dto"></param>
  4797. /// <returns></returns>
  4798. [HttpPost]
  4799. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4800. public async Task<IActionResult> PostHotelReservationsConfirmationSlip(HotelReservationsConfirmationSlipDto _dto)
  4801. {
  4802. try
  4803. {
  4804. #region 参数验证
  4805. if (_dto.UserId < 1) return Ok(JsonView(false, "员工Id为空"));
  4806. if (_dto.PageId < 1) _dto.PageId = 28; //酒店预定Id
  4807. if (_dto.DiId < 1) return Ok(JsonView(false, "团组Id为空"));
  4808. #region 团组操作权限验证 76 酒店预定模块
  4809. var groupAuthView = await GeneralMethod.PostGroupOperationAuth(_dto.DiId, _dto.UserId, 76);
  4810. if (groupAuthView.Code != 0) return Ok(JsonView(false, groupAuthView.Msg));
  4811. #endregion
  4812. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  4813. #region 页面操作权限验证
  4814. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  4815. if (pageFunAuthView.FilesDownloadAuth == 0) return Ok(JsonView(false, "您没有文件下载权限!"));
  4816. #endregion
  4817. #endregion
  4818. //团组信息
  4819. Grp_DelegationInfo di = _sqlSugar.Queryable<Grp_DelegationInfo>().First(a => a.Id == _dto.DiId);
  4820. //酒店数据
  4821. List<Grp_HotelReservations> listhoteldata = await _sqlSugar.Queryable<Grp_HotelReservations>().Where(a => a.DiId == _dto.DiId && a.IsDel == 0).ToListAsync();
  4822. if (listhoteldata.Count < 0)
  4823. {
  4824. return Ok(JsonView(false, "当前团组暂无酒店预订信息!"));
  4825. }
  4826. //利datatable存储
  4827. DataTable dt = new DataTable();
  4828. dt.Columns.Add("CheckInDate", typeof(string));
  4829. dt.Columns.Add("City", typeof(string));
  4830. dt.Columns.Add("Hotel", typeof(string));
  4831. dt.Columns.Add("Room", typeof(string));
  4832. for (int i = 0; i < listhoteldata.Count; i++)
  4833. {
  4834. DateTime dayStart = Convert.ToDateTime(listhoteldata[i].CheckInDate);
  4835. DateTime dayEnd = Convert.ToDateTime(listhoteldata[i].CheckOutDate);
  4836. while (dayStart < dayEnd)
  4837. {
  4838. string temp = "";
  4839. DataRow row = dt.NewRow();
  4840. row["CheckInDate"] = dayStart.ToString("yyyy-MM-dd");
  4841. row["City"] = listhoteldata[i].City;
  4842. row["Hotel"] = listhoteldata[i].HotelName;
  4843. if (listhoteldata[i].SingleRoomCount > 0)
  4844. {
  4845. temp = listhoteldata[i].SingleRoomCount + "个单间" + "\r\n";
  4846. }
  4847. if (listhoteldata[i].DoubleRoomCount > 0)
  4848. {
  4849. temp = temp + listhoteldata[i].DoubleRoomCount + "个标间" + "\r\n";
  4850. }
  4851. if (listhoteldata[i].SuiteRoomCount > 0)
  4852. {
  4853. temp = temp + listhoteldata[i].SuiteRoomCount + "个套房" + "\r\n";
  4854. }
  4855. if (listhoteldata[i].OtherRoomCount > 0)
  4856. {
  4857. temp = temp + listhoteldata[i].OtherRoomCount + "个其他房型" + "\r\n";
  4858. }
  4859. row["Room"] = temp;
  4860. dt.Rows.Add(row);
  4861. dayStart = dayStart.AddDays(1);
  4862. }
  4863. }
  4864. Dictionary<string, string> dic = new Dictionary<string, string>();
  4865. dic.Add("Dele", di.TeamName);
  4866. dic.Add("City", di.VisitCountry);
  4867. //模板路径
  4868. string tempPath = AppSettingsHelper.Get("WordBasePath") + "Template/酒店用房确认单-模板.doc";
  4869. //载入模板
  4870. Aspose.Words.Document doc = new Aspose.Words.Document(tempPath);
  4871. DocumentBuilder builder = new DocumentBuilder(doc);
  4872. foreach (var key in dic.Keys)
  4873. {
  4874. builder.MoveToBookmark(key);
  4875. builder.Write(dic[key]);
  4876. }
  4877. //获取word里所有表格
  4878. NodeCollection allTables = doc.GetChildNodes(NodeType.Table, true);
  4879. //获取所填表格的序数
  4880. Aspose.Words.Tables.Table tableOne = allTables[0] as Aspose.Words.Tables.Table;
  4881. var rowStart = tableOne.Rows[0]; //获取第1行
  4882. //循环赋值
  4883. for (int i = 0; i < dt.Rows.Count; i++)
  4884. {
  4885. builder.MoveToCell(0, i + 1, 0, 0);
  4886. builder.Write(dt.Rows[i]["CheckInDate"].ToString());
  4887. builder.MoveToCell(0, i + 1, 1, 0);
  4888. builder.Write(dt.Rows[i]["City"].ToString());
  4889. builder.MoveToCell(0, i + 1, 2, 0);
  4890. builder.Write(dt.Rows[i]["Hotel"].ToString());
  4891. builder.MoveToCell(0, i + 1, 3, 0);
  4892. builder.Write(dt.Rows[i]["Room"].ToString());
  4893. }
  4894. //删除多余行
  4895. while (tableOne.Rows.Count > dt.Rows.Count + 1)
  4896. {
  4897. tableOne.Rows.RemoveAt(dt.Rows.Count + 1);
  4898. }
  4899. string strFileName = di.TeamName + "酒店确认单.doc";
  4900. doc.Save(AppSettingsHelper.Get("WordBasePath") + "HotelStatement/" + strFileName);
  4901. string url = AppSettingsHelper.Get("WordBaseUrl") + "Office/Word/HotelStatement/" + strFileName;
  4902. return Ok(JsonView(true, "成功", url));
  4903. }
  4904. catch (Exception ex)
  4905. {
  4906. return Ok(JsonView(false, ex.Message));
  4907. }
  4908. }
  4909. #endregion
  4910. #region 团组状态
  4911. /// <summary>
  4912. /// 团组状态列表 Page
  4913. /// </summary>
  4914. /// <param name="dto">团组列表请求dto</param>
  4915. /// <returns></returns>
  4916. [HttpPost]
  4917. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4918. public async Task<IActionResult> PostGroupStatusPageList(GroupStatusListDto dto)
  4919. {
  4920. if (dto == null) return Ok(JsonView(false, "请输入搜索条件!"));
  4921. if (dto.PortType == 1 || dto.PortType == 2) // web/Android
  4922. {
  4923. string sqlWhere = string.Empty;
  4924. if (dto.IsSure == 0) //未完成
  4925. {
  4926. sqlWhere += string.Format(@" And IsSure = 0");
  4927. }
  4928. else if (dto.IsSure == 1) //已完成
  4929. {
  4930. sqlWhere += string.Format(@" And IsSure = 1");
  4931. }
  4932. if (!string.IsNullOrEmpty(dto.SearchCriteria))
  4933. {
  4934. string tj = dto.SearchCriteria;
  4935. sqlWhere += string.Format(@"And (ssd.Name Like '%{0}%' Or TeamName Like '%{1}%' Or ClientName Like '%{2}%' Or ClientName Like '%{3}%' Or su.CnName Like '%{4}%')",
  4936. tj, tj, tj, tj, tj);
  4937. }
  4938. string sql = string.Format(@"Select Row_Number,Id,SalesQuoteNo,TourCode,TeamTypeId, TeamType,
  4939. TeamLevId,TeamLev,TeamName,ClientName,ClientUnit,
  4940. VisitDate,VisitDays,VisitPNumber,JietuanOperator,IsSure,CreateTime
  4941. From (
  4942. Select row_number() over(order by gdi.CreateTime Desc) as Row_Number,
  4943. gdi.Id,SalesQuoteNo,TourCode,ssd.Id TeamTypeId, ssd.Name TeamType,
  4944. ssd1.Id TeamLevId,ssd1.Name TeamLev,TeamName,ClientName,ClientUnit,
  4945. VisitDate,VisitDays,VisitPNumber,su.CnName JietuanOperator,IsSure,gdi.CreateTime
  4946. From Grp_DelegationInfo gdi
  4947. Inner Join Sys_SetData ssd On gdi.TeamDid = ssd.Id
  4948. Inner Join Sys_SetData ssd1 On gdi.TeamLevSId = ssd1.Id
  4949. Left Join Sys_Users su On gdi.JietuanOperator = su.Id
  4950. Where gdi.IsDel = 0 {0}
  4951. ) temp ", sqlWhere);
  4952. RefAsync<int> total = 0;//REF和OUT不支持异步,想要真的异步这是最优解
  4953. var _DelegationList = await _sqlSugar.SqlQueryable<GroupStatusView>(sql).ToPageListAsync(dto.PageIndex, dto.PageSize, total);//ToPageAsync
  4954. return Ok(JsonView(true, "查询成功!", _DelegationList, total));
  4955. }
  4956. else
  4957. {
  4958. return Ok(JsonView(false, "查询失败"));
  4959. }
  4960. }
  4961. /// <summary>
  4962. /// 团组状态
  4963. /// 设置操作完成
  4964. /// </summary>
  4965. /// <param name="dto">团组列表请求dto</param>
  4966. /// <returns></returns>
  4967. [HttpPost]
  4968. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4969. public async Task<IActionResult> PostGroupStatusSetOperationComplete(GroupStatusSetOperationCompleteDto dto)
  4970. {
  4971. if (dto == null) return Ok(JsonView(false, "请输入搜索条件!"));
  4972. Grp_DelegationInfo _DelegationInfo = new Grp_DelegationInfo()
  4973. {
  4974. Id = dto.Id,
  4975. IsSure = 1
  4976. };
  4977. var result = await _sqlSugar.Updateable(_DelegationInfo)
  4978. .UpdateColumns(it => new { it.IsSure })
  4979. .WhereColumns(it => new { it.Id })
  4980. .ExecuteCommandAsync();
  4981. if (result > 0)
  4982. {
  4983. return Ok(JsonView(true, "操作完成!"));
  4984. }
  4985. return Ok(JsonView(false, "操作失败!"));
  4986. }
  4987. #endregion
  4988. #region 保险费用录入
  4989. /// <summary>
  4990. /// 根据团组Id查询保险费用列表
  4991. /// </summary>
  4992. /// <param name="dto"></param>
  4993. /// <returns></returns>
  4994. [HttpPost]
  4995. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  4996. public async Task<IActionResult> CustomersByDiId(CustomersByDiIdDto dto)
  4997. {
  4998. try
  4999. {
  5000. Result groupData = await _customersRep.CustomersByDiId(dto);
  5001. if (groupData.Code != 0)
  5002. {
  5003. return Ok(JsonView(false, groupData.Msg));
  5004. }
  5005. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  5006. }
  5007. catch (Exception ex)
  5008. {
  5009. return Ok(JsonView(false, ex.Message));
  5010. }
  5011. }
  5012. /// <summary>
  5013. /// 根据保险费用Id查询保险费用详细
  5014. /// </summary>
  5015. /// <param name="dto"></param>
  5016. /// <returns></returns>
  5017. [HttpPost]
  5018. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  5019. public async Task<IActionResult> CustomersById(CustomersByIdDto dto)
  5020. {
  5021. try
  5022. {
  5023. Result groupData = await _customersRep.CustomersById(dto);
  5024. if (groupData.Code != 0)
  5025. {
  5026. return Ok(JsonView(false, groupData.Msg));
  5027. }
  5028. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  5029. }
  5030. catch (Exception ex)
  5031. {
  5032. return Ok(JsonView(false, ex.Message));
  5033. }
  5034. }
  5035. /// <summary>
  5036. /// 保险费用录入页面初始化绑定
  5037. /// </summary>
  5038. /// <param name="dto"></param>
  5039. /// <returns></returns>
  5040. [HttpPost]
  5041. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  5042. public async Task<IActionResult> CustomersInitialize(CustomersInitializeDto dto)
  5043. {
  5044. try
  5045. {
  5046. Result groupData = await _customersRep.CustomersInitialize(dto);
  5047. if (groupData.Code != 0)
  5048. {
  5049. return Ok(JsonView(false, groupData.Msg));
  5050. }
  5051. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  5052. }
  5053. catch (Exception ex)
  5054. {
  5055. return Ok(JsonView(false, ex.Message));
  5056. }
  5057. }
  5058. /// <summary>
  5059. /// 保险费用操作(Status:1.新增,2.修改)
  5060. /// </summary>
  5061. /// <param name="dto"></param>
  5062. /// <returns></returns>
  5063. [HttpPost]
  5064. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  5065. public async Task<IActionResult> OpCustomers(OpCustomersDto dto)
  5066. {
  5067. try
  5068. {
  5069. Result groupData = await _customersRep.OpCustomers(dto);
  5070. if (groupData.Code != 0)
  5071. {
  5072. return Ok(JsonView(false, groupData.Msg));
  5073. }
  5074. return Ok(JsonView(true, groupData.Msg, groupData.Data));
  5075. }
  5076. catch (Exception ex)
  5077. {
  5078. return Ok(JsonView(false, ex.Message));
  5079. }
  5080. }
  5081. /// <summary>
  5082. /// 保险文件上传
  5083. /// </summary>
  5084. /// <param name="file"></param>
  5085. /// <returns></returns>
  5086. [HttpPost]
  5087. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  5088. public async Task<IActionResult> UploadCus(IFormFile file)
  5089. {
  5090. try
  5091. {
  5092. if (file != null)
  5093. {
  5094. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  5095. //文件名称
  5096. string projectFileName = file.FileName;
  5097. //上传的文件的路径
  5098. string filePath = "";
  5099. if (!Directory.Exists(fileDir))
  5100. {
  5101. Directory.CreateDirectory(fileDir);
  5102. }
  5103. //上传的文件的路径
  5104. filePath = fileDir + $@"\保险费用文件上传\{projectFileName}";
  5105. using (FileStream fs = System.IO.File.Create(filePath))
  5106. {
  5107. file.CopyTo(fs);
  5108. fs.Flush();
  5109. }
  5110. return Ok(JsonView(true, "上传成功!", projectFileName));
  5111. }
  5112. else
  5113. {
  5114. return Ok(JsonView(false, "上传失败!"));
  5115. }
  5116. }
  5117. catch (Exception ex)
  5118. {
  5119. return Ok(JsonView(false, "程序错误!"));
  5120. throw;
  5121. }
  5122. }
  5123. /// <summary>
  5124. /// 保险删除指定文件
  5125. /// </summary>
  5126. /// <param name="dto"></param>
  5127. /// <returns></returns>
  5128. [HttpPost]
  5129. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  5130. public async Task<IActionResult> DelFileCus(DelFileDto dto)
  5131. {
  5132. try
  5133. {
  5134. string filePath = "";
  5135. var fileDir = AppSettingsHelper.Get("GrpFileBasePath");
  5136. // 返回与指定虚拟路径相对应的物理路径即绝对路径
  5137. //int id = 0;
  5138. filePath = fileDir + "/保险费用文件上传/" + dto.fileName;
  5139. // 删除该文件
  5140. try
  5141. {
  5142. System.IO.File.Delete(filePath);
  5143. var result = await _sqlSugar.Updateable<Grp_Customers>().Where(a => a.Id == dto.Id && a.IsDel == 0 && a.Attachment == dto.fileName).SetColumns(a => new Grp_Customers()
  5144. {
  5145. Attachment = "",
  5146. }).ExecuteCommandAsync();
  5147. if (result != 0)
  5148. {
  5149. return Ok(JsonView(true, "成功!"));
  5150. }
  5151. else
  5152. {
  5153. return Ok(JsonView(false, "失败!"));
  5154. }
  5155. }
  5156. catch (Exception)
  5157. {
  5158. var result = await _sqlSugar.Updateable<Grp_Customers>().Where(a => a.Id == dto.Id && a.IsDel == 0 && a.Attachment == dto.fileName).SetColumns(a => new Grp_Customers()
  5159. {
  5160. Attachment = "",
  5161. }).ExecuteCommandAsync();
  5162. if (result != 0)
  5163. {
  5164. return Ok(JsonView(true, "成功!"));
  5165. }
  5166. else
  5167. {
  5168. return Ok(JsonView(false, "失败!"));
  5169. }
  5170. }
  5171. }
  5172. catch (Exception ex)
  5173. {
  5174. return Ok(JsonView(false, "程序错误!"));
  5175. throw;
  5176. }
  5177. }
  5178. /// <summary>
  5179. /// 保险费用操作(删除)
  5180. /// </summary>
  5181. /// <param name="dto"></param>
  5182. /// <returns></returns>
  5183. [HttpPost]
  5184. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  5185. public async Task<IActionResult> DelCustomers(DelBaseDto dto)
  5186. {
  5187. try
  5188. {
  5189. var res = await _customersRep.SoftDeleteByIdAsync<Grp_Customers>(dto.Id.ToString(), dto.DeleteUserId);
  5190. if (!res)
  5191. {
  5192. return Ok(JsonView(false, "删除失败"));
  5193. }
  5194. var resultC = await _sqlSugar.Updateable<Grp_CreditCardPayment>().Where(a => a.CId == dto.Id && a.IsDel == 0 && a.CTable == 82).SetColumns(a => new Grp_CreditCardPayment()
  5195. {
  5196. IsDel = 1,
  5197. DeleteUserId = dto.DeleteUserId,
  5198. DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
  5199. }).ExecuteCommandAsync();
  5200. return Ok(JsonView(true, "删除成功!"));
  5201. }
  5202. catch (Exception ex)
  5203. {
  5204. return Ok(JsonView(false, "程序错误!"));
  5205. throw;
  5206. }
  5207. }
  5208. #endregion
  5209. #region 接团客户名单 PageId 104
  5210. /// <summary>
  5211. /// 接团客户名单
  5212. /// 根据团组Id查询List
  5213. /// </summary>
  5214. /// <param name="dto"></param>
  5215. /// <returns></returns>
  5216. [HttpPost]
  5217. public async Task<IActionResult> PostTourClientListByDiId(TourClientListByDiIdDto _dto)
  5218. {
  5219. #region 参数验证
  5220. if (_dto.UserId < 1) return Ok(JsonView(false, "请传入有效的UserId"));
  5221. if (_dto.PageId < 1) _dto.PageId = 104; //接团客户名单PageId
  5222. if (_dto.DiId < 1) return Ok(JsonView(false, "请传入有效的DiId!"));
  5223. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  5224. #region 页面操作权限验证
  5225. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  5226. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限!"));
  5227. #endregion
  5228. #endregion
  5229. var viewData = await _tourClientListRep._ItemByDiId(_dto.PortType,_dto.DiId);
  5230. if (viewData.Code != 0)
  5231. {
  5232. return Ok(JsonView(false, viewData.Msg));
  5233. }
  5234. return Ok(JsonView(viewData.Data));
  5235. }
  5236. /// <summary>
  5237. /// 接团客户名单
  5238. /// 基础数据 Init
  5239. /// </summary>
  5240. /// <param name="_dto"></param>
  5241. /// <returns></returns>
  5242. [HttpPost]
  5243. public async Task<IActionResult> PostTourClientListBasicDataInit(TourClientListBasicDataInitDto _dto)
  5244. {
  5245. #region 参数验证
  5246. if (_dto.UserId < 1) return Ok(JsonView(false, "请传入有效的UserId参数"));
  5247. if (_dto.PageId < 1) _dto.PageId = 104; //接团客户名单PageId
  5248. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  5249. #region 页面操作权限验证
  5250. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  5251. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限!"));
  5252. #endregion
  5253. #endregion
  5254. var viewData = await _tourClientListRep._BasicDataInit(_dto.PortType);
  5255. if (viewData.Code != 0)
  5256. {
  5257. return Ok(JsonView(false, viewData.Msg));
  5258. }
  5259. return Ok(JsonView(viewData.Data));
  5260. }
  5261. /// <summary>
  5262. /// 接团客户名单
  5263. /// 根据 Id查询 Details
  5264. /// </summary>
  5265. /// <param name="_dto"></param>
  5266. /// <returns></returns>
  5267. [HttpPost]
  5268. public async Task<IActionResult> PostTourClientListDetails(TourClientListDetailsDto _dto)
  5269. {
  5270. #region 参数验证
  5271. if (_dto.UserId < 1) return Ok(JsonView(false, "请传入有效的UserId参数"));
  5272. if (_dto.PageId < 1) _dto.PageId = 104; //接团客户名单PageId
  5273. if (_dto.Id < 1) return Ok(JsonView(false, "请传入有效的Id参数!"));
  5274. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  5275. #region 页面操作权限验证
  5276. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  5277. if (pageFunAuthView.CheckAuth == 0) return Ok(JsonView(false, "您没有查看权限!"));
  5278. #endregion
  5279. #endregion
  5280. var viewData = await _tourClientListRep._Details(_dto.PortType, _dto.Id);
  5281. if (viewData.Code != 0)
  5282. {
  5283. return Ok(JsonView(false, viewData.Msg));
  5284. }
  5285. return Ok(JsonView(viewData.Data));
  5286. }
  5287. /// <summary>
  5288. /// 接团客户名单
  5289. /// Add Or Edit
  5290. /// </summary>
  5291. /// <param name="_dto"></param>
  5292. /// <returns></returns>
  5293. [HttpPost]
  5294. public async Task<IActionResult> PostTourClientListAddOrEdit(TourClientListAddOrEditDto _dto)
  5295. {
  5296. #region 参数验证
  5297. if (_dto.UserId < 1) return Ok(JsonView(false, "请传入有效的UserId参数"));
  5298. if (_dto.PageId < 1) _dto.PageId = 104; //接团客户名单PageId
  5299. if (_dto.Id < 0) return Ok(JsonView(false, "请传入有效的Id参数!"));
  5300. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  5301. #region 页面操作权限验证
  5302. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  5303. if (_dto.Id == 0) //添加
  5304. {
  5305. if (pageFunAuthView.AddAuth == 0) return Ok(JsonView(false, "您没有添加权限!"));
  5306. }else if (_dto.Id >= 0) //修改
  5307. {
  5308. if (pageFunAuthView.EditAuth == 0) return Ok(JsonView(false, "您没有编辑权限!"));
  5309. }
  5310. #endregion
  5311. #endregion
  5312. var viewData = await _tourClientListRep._AddOrEdit(_dto);
  5313. if (viewData.Code != 0)
  5314. {
  5315. return Ok(JsonView(false, viewData.Msg));
  5316. }
  5317. return Ok(JsonView(viewData.Data));
  5318. }
  5319. /// <summary>
  5320. /// 接团客户名单
  5321. /// Del
  5322. /// </summary>
  5323. /// <param name="_dto"></param>
  5324. /// <returns></returns>
  5325. [HttpPost]
  5326. public async Task<IActionResult> PostTourClientListDel(TourClientListDelDto _dto)
  5327. {
  5328. #region 参数验证
  5329. if (_dto.UserId < 1) return Ok(JsonView(false, "请传入有效的UserId参数"));
  5330. if (_dto.PageId < 1) _dto.PageId = 104; //接团客户名单PageId
  5331. PageFunAuthViewBase pageFunAuthView = new PageFunAuthViewBase();
  5332. #region 页面操作权限验证
  5333. pageFunAuthView = await GeneralMethod.PostUserPageFuncDatas(_dto.UserId, _dto.PageId);
  5334. if (pageFunAuthView.DeleteAuth == 0) return Ok(JsonView(false, "您没有删除权限!"));
  5335. #endregion
  5336. #endregion
  5337. var viewData = await _tourClientListRep._Del(_dto.Id, _dto.UserId);
  5338. if (viewData.Code != 0)
  5339. {
  5340. return Ok(JsonView(false, viewData.Msg));
  5341. }
  5342. return Ok(JsonView(viewData.Data));
  5343. }
  5344. #endregion
  5345. }
  5346. }