ResourceController.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576
  1. 
  2. using NetTaste;
  3. using System.Drawing.Printing;
  4. using static OpenAI.GPT3.ObjectModels.SharedModels.IOpenAiModels;
  5. namespace OASystem.API.Controllers
  6. {
  7. /// <summary>
  8. /// 资料相关
  9. /// </summary>
  10. //[Authorize]
  11. [Route("api/[controller]/[action]")]
  12. public class ResourceController : ControllerBase
  13. {
  14. private readonly IMapper _mapper;
  15. private readonly IConfiguration _config;
  16. private readonly CarDataRepository _carDataRep;
  17. private readonly LocalGuideDataRepository _localGuideDataRep;
  18. private readonly ThreeCodeRepository _ThreeCodeRep;
  19. private readonly HotelDataRepository _hotelDataRep;
  20. public ResourceController(IMapper mapper, IConfiguration config, CarDataRepository carDataRep, LocalGuideDataRepository localGuideDataRep, ThreeCodeRepository threeCodeRep, HotelDataRepository hotelDataRep)
  21. {
  22. _mapper = mapper;
  23. _config = config;
  24. _carDataRep = carDataRep;
  25. _localGuideDataRep = localGuideDataRep;
  26. _ThreeCodeRep = threeCodeRep;
  27. _hotelDataRep = hotelDataRep;
  28. }
  29. #region 车公司资料板块
  30. /// <summary>
  31. /// 车公司信息查询
  32. /// </summary>
  33. /// <returns></returns>
  34. [HttpPost]
  35. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  36. public async Task<IActionResult> QueryCarData(QueryCarDataDto dto)
  37. {
  38. try
  39. {
  40. Result carDada = await _carDataRep.QueryCarData(dto);
  41. if (carDada.Code == 0)
  42. {
  43. return Ok(JsonView(true, "查询成功", carDada.Data));
  44. }
  45. else
  46. {
  47. return Ok(JsonView(false, carDada.Msg));
  48. }
  49. }
  50. catch (Exception ex)
  51. {
  52. return Ok(JsonView(false, "程序错误!"));
  53. throw;
  54. }
  55. }
  56. /// <summary>
  57. /// 车公司资料下拉框数据
  58. /// </summary>
  59. /// <returns></returns>
  60. [HttpPost]
  61. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  62. public async Task<IActionResult> QueryCarSelect()
  63. {
  64. try
  65. {
  66. var CarSelect = _carDataRep.QueryDto<Res_CarData, CarDataSelectView>().ToList();
  67. if (CarSelect.Count == 0)
  68. {
  69. return Ok(JsonView(false, "暂无数据!"));
  70. }
  71. CarSelect.Add(new CarDataSelectView {Id=0, UnitArea = "全部" });
  72. CarSelect = CarSelect.Where((x, i) => CarSelect.FindIndex(z => z.UnitArea == x.UnitArea) == i).ToList();
  73. CarSelect=CarSelect.OrderBy(x=>x.Id).ToList();
  74. return Ok(JsonView(true, "查询成功", CarSelect));
  75. }
  76. catch (Exception)
  77. {
  78. return Ok(JsonView(false, "程序错误!"));
  79. throw;
  80. }
  81. }
  82. /// <summary>
  83. /// 车公司信息添加
  84. /// </summary>
  85. /// <returns></returns>
  86. [HttpPost]
  87. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  88. public async Task<IActionResult> AddCarData(AddCarDataDto dto)
  89. {
  90. try
  91. {
  92. if (dto.UnitArea == "")
  93. {
  94. return Ok(JsonView(false, "请检查单位区域是否填写!"));
  95. }
  96. if (dto.UnitName == "")
  97. {
  98. return Ok(JsonView(false, "请检查单位名称是否填写!"));
  99. }
  100. if (dto.Contact == "")
  101. {
  102. return Ok(JsonView(false, "请检查单位联系人是否填写!"));
  103. }
  104. if (dto.ContactTel == "")
  105. {
  106. return Ok(JsonView(false, "请检查联系方式是否填写正确!"));
  107. }
  108. var carDada = _carDataRep.QueryDto<Res_CarData, CarDataView>(a=>a.UnitArea==dto.UnitArea && a.UnitName==dto.UnitName && a.Contact==dto.Contact && a.ContactTel==dto.ContactTel).ToList();
  109. if (carDada.Count!=0)
  110. {
  111. return Ok(JsonView(false, "该信息已存在,请勿重复添加!"));
  112. }
  113. Res_CarData _CarData = _mapper.Map<Res_CarData>(dto);
  114. int id = await _carDataRep.AddAsyncReturnId(_CarData);
  115. if (id == 0)
  116. {
  117. return Ok(JsonView(false, "添加失败!"));
  118. }
  119. return Ok(JsonView(true, "添加成功", new { Id = id }));
  120. }
  121. catch (Exception ex)
  122. {
  123. return Ok(JsonView(false, "程序错误!"));
  124. throw;
  125. }
  126. }
  127. /// <summary>
  128. /// 车公司信息修改
  129. /// </summary>
  130. /// <returns></returns>
  131. [HttpPost]
  132. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  133. public async Task<IActionResult> UpCarData(UpCarDataDto dto)
  134. {
  135. try
  136. {
  137. if (dto.UnitArea == "")
  138. {
  139. return Ok(JsonView(false, "请检查单位区域是否填写!"));
  140. }
  141. if (dto.UnitName == "")
  142. {
  143. return Ok(JsonView(false, "请检查单位名称是否填写!"));
  144. }
  145. if (dto.Contact == "")
  146. {
  147. return Ok(JsonView(false, "请检查单位联系人是否填写!"));
  148. }
  149. if (dto.ContactTel == "")
  150. {
  151. return Ok(JsonView(false, "请检查联系方式是否填写正确!"));
  152. }
  153. bool res = await _carDataRep.UpdateAsync(a => a.Id == dto.Id, a => new Res_CarData
  154. {
  155. UnitArea = dto.UnitArea,
  156. UnitName = dto.UnitName,
  157. Address = dto.Address,
  158. Contact = dto.Contact,
  159. ContactTel = dto.ContactTel,
  160. ContactEmail = dto.ContactEmail,
  161. ContactFax = dto.ContactFax,
  162. CarDes = dto.CarDes,
  163. CarPicPaths = dto.CarPicPaths,
  164. OtherInfo = dto.OtherInfo,
  165. Score = dto.Score,
  166. QualificationScore = dto.QualificationScore,
  167. CarAgeScore = dto.CarAgeScore,
  168. CleanImgScore = dto.CleanImgScore,
  169. SmellScore = dto.SmellScore,
  170. WaterPaperScore = dto.WaterPaperScore,
  171. HardwareScore = dto.HardwareScore,
  172. TimeScore = dto.TimeScore,
  173. SafetyScore = dto.SafetyScore,
  174. DrivingAgeScore = dto.DrivingAgeScore,
  175. Remark = dto.Remark,
  176. });
  177. if (!res) { return Ok(JsonView(false, "修改失败!")); }
  178. return Ok(JsonView(true, "修改成功"));
  179. }
  180. catch (Exception ex)
  181. {
  182. return Ok(JsonView(false, "程序错误!"));
  183. throw;
  184. }
  185. }
  186. /// <summary>
  187. /// 车公司信息删除
  188. /// </summary>
  189. /// <returns></returns>
  190. [HttpPost]
  191. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  192. public async Task<IActionResult> DelCarData(DelCarDataDto dto)
  193. {
  194. try
  195. {
  196. bool res = await _carDataRep.SoftDeleteByIdAsync<Res_CarData>(dto.Id.ToString(), dto.DeleteUserId);
  197. if (!res) { return Ok(JsonView(false, "删除失败!")); }
  198. return Ok(JsonView(true, "删除成功"));
  199. }
  200. catch (Exception ex)
  201. {
  202. return Ok(JsonView(false, "程序错误!"));
  203. throw;
  204. }
  205. }
  206. #endregion
  207. #region 导游地接资料板块
  208. /// <summary>
  209. /// 导游地接资料查询
  210. /// </summary>
  211. /// <param name="dto"></param>
  212. /// <returns></returns>
  213. [HttpPost]
  214. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  215. public async Task<IActionResult> QueryLocalGuide(QueryLocalGuide dto)
  216. {
  217. try
  218. {
  219. Result LocalGuide = await _localGuideDataRep.QueryLocalGuide(dto);
  220. if (LocalGuide.Code == 0)
  221. {
  222. return Ok(JsonView(true, "查询成功", LocalGuide.Data));
  223. }
  224. else
  225. {
  226. return Ok(JsonView(false, LocalGuide.Msg));
  227. }
  228. }
  229. catch (Exception ex)
  230. {
  231. return Ok(JsonView(false, "程序错误!"));
  232. throw;
  233. }
  234. }
  235. /// <summary>
  236. /// 导游地接资料下拉框数据
  237. /// </summary>
  238. /// <returns></returns>
  239. [HttpPost]
  240. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  241. public async Task<IActionResult> QueryLocalGuideSelect()
  242. {
  243. try
  244. {
  245. var LocalGuide = _carDataRep.QueryDto<Res_LocalGuideData, QueryLocalGuideSelectView>().ToList();
  246. if (LocalGuide.Count == 0)
  247. {
  248. return Ok(JsonView(false, "暂无数据!"));
  249. }
  250. LocalGuide.Add(new QueryLocalGuideSelectView { Id = 0, UnitArea = "全部" });
  251. LocalGuide = LocalGuide.Where((x, i) => LocalGuide.FindIndex(z => z.UnitArea == x.UnitArea) == i).ToList();
  252. LocalGuide = LocalGuide.OrderBy(x => x.Id).ToList();
  253. return Ok(JsonView(true, "查询成功", LocalGuide));
  254. }
  255. catch (Exception)
  256. {
  257. return Ok(JsonView(false, "程序错误!"));
  258. throw;
  259. }
  260. }
  261. /// <summary>
  262. /// 导游地接信息操作(Status:1.新增,2.修改)
  263. /// </summary>
  264. /// <returns></returns>
  265. [HttpPost]
  266. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  267. public async Task<IActionResult> OperationLocalGuide(LocalGuideOperationDto dto)
  268. {
  269. try
  270. {
  271. if (dto.UnitArea == "")
  272. {
  273. return Ok(JsonView(false, "请检查单位区域是否填写!"));
  274. }
  275. if (dto.UnitName == "")
  276. {
  277. return Ok(JsonView(false, "请检查单位名称是否填写!"));
  278. }
  279. if (dto.Contact == "")
  280. {
  281. return Ok(JsonView(false, "请检查单位联系人是否填写!"));
  282. }
  283. if (dto.ContactTel == "")
  284. {
  285. return Ok(JsonView(false, "请检查联系方式是否填写正确!"));
  286. }
  287. Result result = await _localGuideDataRep.LocalGuideOperation(dto);
  288. if (result.Code != 0)
  289. {
  290. return Ok(JsonView(false, result.Msg));
  291. }
  292. return Ok(JsonView(true, result.Msg));
  293. }
  294. catch (Exception ex)
  295. {
  296. return Ok(JsonView(false, "程序错误!"));
  297. throw;
  298. }
  299. }
  300. /// <summary>
  301. /// 导游地接信息操作(删除)
  302. /// </summary>
  303. /// <returns></returns>
  304. [HttpPost]
  305. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  306. public async Task<IActionResult> DelLocalGuide(LocalGuideDelDto dto)
  307. {
  308. try
  309. {
  310. var res = await _localGuideDataRep.SoftDeleteByIdAsync<Res_LocalGuideData>(dto.Id.ToString(),dto.DeleteUserId);
  311. if (!res)
  312. {
  313. return Ok(JsonView(false, "删除失败"));
  314. }
  315. return Ok(JsonView(true,"删除成功!"));
  316. }
  317. catch (Exception ex)
  318. {
  319. return Ok(JsonView(false, "程序错误!"));
  320. throw;
  321. }
  322. }
  323. #endregion
  324. #region 机场三字码信息
  325. /// <summary>
  326. /// 机场三字码查询
  327. /// </summary>
  328. /// <param name="dto"></param>
  329. /// <returns></returns>
  330. [HttpPost]
  331. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  332. public async Task<IActionResult> QueryThreeCode(DtoBase dto)
  333. {
  334. try
  335. {
  336. if (dto.PortType == 1)
  337. {
  338. var ThreeCode = _localGuideDataRep.QueryDto<Res_ThreeCode, ThreeCodeView>().ToList();
  339. if (ThreeCode.Count == 0)
  340. {
  341. return Ok(JsonView(false, "暂无数据!"));
  342. }
  343. ThreeCode = ThreeCode.OrderByDescending(s => s.CreateTime).ToList();
  344. return Ok(JsonView(true, "查询成功", ThreeCode));
  345. }
  346. else if (dto.PortType == 2)
  347. {
  348. //分页写法
  349. if (dto.PageIndex==0 || dto.PageSize==0)
  350. {
  351. return Ok(JsonView(false, "请传入PageIndex和PageSize参数"));
  352. }
  353. JsonView _ThreeCode = await _ThreeCodeRep.QuerThreeCode(dto.PageIndex, dto.PageSize);
  354. if (_ThreeCode.Code != 0)
  355. {
  356. return Ok(JsonView(false, _ThreeCode.Msg));
  357. }
  358. return Ok(_ThreeCode);
  359. }
  360. else
  361. {
  362. return Ok(JsonView(false, "请传入PortType参数!1:Web,2:Android,3:IOS"));
  363. }
  364. }
  365. catch (Exception ex)
  366. {
  367. return Ok(JsonView(false, "程序错误!"));
  368. throw;
  369. }
  370. }
  371. /// <summary>
  372. /// 机场三字码资料操作(Status:1.新增,2.修改)
  373. /// </summary>
  374. /// <param name="dto"></param>
  375. /// <returns></returns>
  376. [HttpPost]
  377. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  378. public async Task<IActionResult> OperationThreeCode(ThreeCodeOperationDto dto)
  379. {
  380. try
  381. {
  382. if (dto.Three == "")
  383. {
  384. return Ok(JsonView(false, "请检查三字码是否填写!"));
  385. }
  386. if (dto.Country == "")
  387. {
  388. return Ok(JsonView(false, "请检查国家是否填写!"));
  389. }
  390. if (dto.City == "")
  391. {
  392. return Ok(JsonView(false, "请检查城市是否填写正确!"));
  393. }
  394. if (dto.AirPort == "")
  395. {
  396. return Ok(JsonView(false, "请检查机场是否填写正确!"));
  397. }
  398. Result result = await _ThreeCodeRep.ThreeCodeOperation(dto);
  399. if (result.Code != 0)
  400. {
  401. return Ok(JsonView(false, result.Msg));
  402. }
  403. return Ok(JsonView(true, result.Msg));
  404. }
  405. catch (Exception ex)
  406. {
  407. return Ok(JsonView(false, "程序错误!"));
  408. throw;
  409. }
  410. }
  411. /// <summary>
  412. /// 机场三字码资料操作(删除)
  413. /// </summary>
  414. /// <returns></returns>
  415. [HttpPost]
  416. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  417. public async Task<IActionResult> DelThreeCode(ThreeCodeDelDto dto)
  418. {
  419. try
  420. {
  421. var res = await _ThreeCodeRep.SoftDeleteByIdAsync<Res_ThreeCode>(dto.Id.ToString(), dto.DeleteUserId);
  422. if (!res)
  423. {
  424. return Ok(JsonView(false, "删除失败"));
  425. }
  426. return Ok(JsonView(true, "删除成功!"));
  427. }
  428. catch (Exception ex)
  429. {
  430. return Ok(JsonView(false, "程序错误!"));
  431. throw;
  432. }
  433. }
  434. #endregion
  435. #region 酒店资料数据
  436. /// <summary>
  437. /// 酒店信息查询
  438. /// </summary>
  439. /// <param name="dto"></param>
  440. /// <returns></returns>
  441. [HttpPost]
  442. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  443. public async Task<IActionResult> QueryHotelData(DtoBase dto)
  444. {
  445. try
  446. {
  447. if (dto.PortType == 1)
  448. {
  449. var HotelData = _localGuideDataRep.QueryDto<Res_HotelData, HotelDataView>().ToList();
  450. if (HotelData.Count == 0)
  451. {
  452. return Ok(JsonView(false, "暂无数据!"));
  453. }
  454. HotelData = HotelData.OrderByDescending(s => s.CreateTime).ToList();
  455. return Ok(JsonView(true, "查询成功", HotelData));
  456. }
  457. else if (dto.PortType == 2)
  458. {
  459. var HotelData = _localGuideDataRep.QueryDto<Res_HotelData, HotelDataView>().ToList();
  460. if (HotelData.Count == 0)
  461. {
  462. return Ok(JsonView(false, "暂无数据!"));
  463. }
  464. HotelData = HotelData.OrderByDescending(s => s.CreateTime).ToList();
  465. return Ok(JsonView(true, "查询成功", HotelData));
  466. }
  467. else
  468. {
  469. return Ok(JsonView(false, "请传入PortType参数!1:Web,2:Android,3:IOS"));
  470. }
  471. }
  472. catch (Exception ex)
  473. {
  474. return Ok(JsonView(false, "程序错误!"));
  475. throw;
  476. }
  477. }
  478. /// <summary>
  479. /// 酒店资料操作(Status:1.新增,2.修改)
  480. /// </summary>
  481. /// <param name="dto"></param>
  482. /// <returns></returns>
  483. [HttpPost]
  484. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  485. public async Task<IActionResult> OperationHotelData(OperationHotelDto dto)
  486. {
  487. try
  488. {
  489. if (dto.City == "")
  490. {
  491. return Ok(JsonView(false, "请检查酒店所在城市是否填写!"));
  492. }
  493. if (dto.Name == "")
  494. {
  495. return Ok(JsonView(false, "请检查酒店名称是否填写!"));
  496. }
  497. if (dto.Address == "")
  498. {
  499. return Ok(JsonView(false, "请检查酒店地址是否填写正确!"));
  500. }
  501. if (dto.Tel == "")
  502. {
  503. return Ok(JsonView(false, "请检查酒店联系方式是否填写正确!"));
  504. }
  505. Result result = await _hotelDataRep.OperationHotelData(dto);
  506. if (result.Code != 0)
  507. {
  508. return Ok(JsonView(false, result.Msg));
  509. }
  510. return Ok(JsonView(true, result.Msg));
  511. }
  512. catch (Exception ex)
  513. {
  514. return Ok(JsonView(false, "程序错误!"));
  515. throw;
  516. }
  517. }
  518. /// <summary>
  519. /// 酒店资料操作(删除)
  520. /// </summary>
  521. /// <returns></returns>
  522. [HttpPost]
  523. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  524. public async Task<IActionResult> DelHotelData(DelHotelDataDto dto)
  525. {
  526. try
  527. {
  528. var res = await _hotelDataRep.SoftDeleteByIdAsync<Res_HotelData>(dto.Id.ToString(), dto.DeleteUserId);
  529. if (!res)
  530. {
  531. return Ok(JsonView(false, "删除失败"));
  532. }
  533. return Ok(JsonView(true, "删除成功!"));
  534. }
  535. catch (Exception ex)
  536. {
  537. return Ok(JsonView(false, "程序错误!"));
  538. throw;
  539. }
  540. }
  541. #endregion
  542. }
  543. }