SystemController.cs 41 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081
  1. using System.Collections;
  2. using static OpenAI.GPT3.ObjectModels.SharedModels.IOpenAiModels;
  3. namespace OASystem.API.Controllers
  4. {
  5. /// <summary>
  6. /// 系统设置
  7. /// </summary>
  8. //[Authorize]
  9. [Route("api/[controller]/[action]")]
  10. public class SystemController : ControllerBase
  11. {
  12. private readonly CompanyRepository _syscomRep;
  13. private readonly DepartmentRepository _sysDepRep;
  14. private readonly UsersRepository _userRep;
  15. private readonly IMapper _mapper;
  16. private readonly SetDataRepository _setDataRepository;
  17. private readonly SystemMenuPermissionRepository _SystemMenuPermissionRepository;
  18. private readonly CompanyRepository _CompanyRepository;
  19. private readonly PageFunctionPermissionRepository _PageFunctionPermissionRepository;
  20. private readonly SystemMenuAndFunctionRepository _SystemMenuAndFunctionRepository;
  21. private readonly JobPostAuthorityRepository _JobPostAuthorityRepository;
  22. private readonly JobPostRepository _jobRep;
  23. private readonly UserAuthorityRepository _UserAuthorityRepository;
  24. public SystemController( CompanyRepository syscom, DepartmentRepository sysDepRep, UsersRepository userRep,
  25. IMapper mapper, SetDataRepository setDataRepository, CompanyRepository companyRepository,
  26. SystemMenuPermissionRepository systemMenuPermissionRepository, PageFunctionPermissionRepository pageFunctionPermissionRepository,
  27. SystemMenuAndFunctionRepository systemMenuAndFunctionRepository, JobPostAuthorityRepository jobPostAuthorityRepository, JobPostRepository jobRep
  28. , UserAuthorityRepository userAuthorityRepository)
  29. {
  30. _syscomRep = syscom;
  31. _sysDepRep = sysDepRep;
  32. _userRep = userRep;
  33. _mapper = mapper;
  34. _setDataRepository = setDataRepository;
  35. _CompanyRepository = companyRepository;
  36. _SystemMenuPermissionRepository = systemMenuPermissionRepository;
  37. _PageFunctionPermissionRepository = pageFunctionPermissionRepository;
  38. _SystemMenuAndFunctionRepository = systemMenuAndFunctionRepository;
  39. _JobPostAuthorityRepository = jobPostAuthorityRepository;
  40. _UserAuthorityRepository = userAuthorityRepository;
  41. _jobRep = jobRep;
  42. }
  43. #region 消息
  44. #endregion
  45. #region 企业操作
  46. /// <summary>
  47. /// 查询企业数据
  48. /// </summary>
  49. /// <param name="dto"></param>
  50. /// <returns></returns>
  51. [HttpPost]
  52. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  53. public async Task<IActionResult> getCompanyList(DtoBase dto)
  54. {
  55. try
  56. {
  57. if (dto.PortType == 1)
  58. {
  59. var CompanyDataResult = _CompanyRepository.GetCompanyData();
  60. if (CompanyDataResult.Code != 0)
  61. {
  62. return Ok(JsonView(CompanyDataResult.Msg));
  63. }
  64. List<CompanyView> companyListView = _mapper.Map<List<CompanyView>>(CompanyDataResult.Data);
  65. for (int i = 0; i < companyListView.Count; i++)
  66. {
  67. if (companyListView[i].ParentCompanyId != 0)
  68. {
  69. companyListView[i].ParentCompanyName = companyListView.Find(x => x.Id == companyListView[i].ParentCompanyId).CompanyName;
  70. }
  71. if (companyListView[i].ContactUserId!=0)
  72. {
  73. var user = _userRep.QueryDto<Sys_Users,UserInfoWebView>(x => x.Id == companyListView[i].ContactUserId).ToList();
  74. if (user.Count!=0)
  75. {
  76. companyListView[i].ContactUserName = user[0].CnName;
  77. }
  78. }
  79. }
  80. return Ok(JsonView(true, "查询成功!", companyListView));
  81. }
  82. else if (dto.PortType == 2)
  83. {
  84. var CompanyDataResult = _CompanyRepository.GetCompanyData();
  85. if (CompanyDataResult.Code != 0)
  86. {
  87. return Ok(JsonView(CompanyDataResult.Msg));
  88. }
  89. return Ok(JsonView(true,"查询成功!", CompanyDataResult.Data));
  90. }
  91. else if (dto.PortType == 3)
  92. {
  93. return Ok(JsonView(false, "暂无数据!"));
  94. }
  95. else
  96. {
  97. return Ok(JsonView(false, "暂无数据!"));
  98. }
  99. }
  100. catch (Exception ex)
  101. {
  102. return Ok(JsonView(false, "程序错误!"));
  103. throw;
  104. }
  105. }
  106. /// <summary>
  107. /// 添加企业数据
  108. /// </summary>
  109. /// <param name="dto"></param>
  110. /// <returns></returns>
  111. [HttpPost]
  112. [ProducesResponseType(typeof(JsonView),StatusCodes.Status200OK)]
  113. public async Task<IActionResult> AddCompany(AddCompanyDto dto)
  114. {
  115. try
  116. {
  117. if (string.IsNullOrWhiteSpace(dto.CompanyName) || dto.CreateUserId == 0 || string.IsNullOrWhiteSpace(dto.CompanyCode))
  118. {
  119. return Ok(JsonView(false, "请检查信息是否输入完整!"));
  120. }
  121. else if (string.IsNullOrWhiteSpace(dto.Tel))
  122. {
  123. return Ok(JsonView(false, "请检查联系方式是否输入正确!"));
  124. }
  125. else
  126. {
  127. Sys_Company _Company = _mapper.Map<Sys_Company>(dto);
  128. int id = await _syscomRep.AddAsyncReturnId(_Company);
  129. if (id == 0)
  130. {
  131. return Ok(JsonView(false, "添加失败!"));
  132. }
  133. return Ok(JsonView(true,"添加成功", new { Id = id }));
  134. }
  135. }
  136. catch (Exception)
  137. {
  138. return Ok(JsonView(false, "程序错误!"));
  139. throw;
  140. }
  141. }
  142. /// <summary>
  143. /// 企业修改
  144. /// </summary>
  145. /// <param name="dto"></param>
  146. /// <returns></returns>
  147. [HttpPost]
  148. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  149. public async Task<IActionResult>EditCompany(EditCompanyDto dto)
  150. {
  151. try
  152. {
  153. if (string.IsNullOrWhiteSpace(dto.CompanyName) || string.IsNullOrWhiteSpace(dto.CompanyCode) || string.IsNullOrWhiteSpace(dto.Address) || dto.ContactUserId == 0)
  154. {
  155. return Ok(JsonView(false, "请检查信息是否输入完整!"));
  156. }
  157. else if (string.IsNullOrWhiteSpace(dto.Tel))
  158. {
  159. return Ok(JsonView(false, "请检查联系方式是否输入正确!"));
  160. }
  161. else
  162. {
  163. bool res = await _syscomRep.UpdateAsync(a => a.Id == dto.Id, a => new Sys_Company
  164. {
  165. CompanyName = dto.CompanyName,
  166. CompanyCode = dto.CompanyCode,
  167. Address = dto.Address,
  168. ParentCompanyId = dto.ParentCompanyId,
  169. Tel = dto.Tel,
  170. ContactUserId = dto.ContactUserId,
  171. Remark=dto.Remark,
  172. });
  173. if (!res) { return Ok(JsonView(false, "修改失败")); }
  174. return Ok(JsonView(true,"修改成功!"));
  175. }
  176. }
  177. catch (Exception)
  178. {
  179. return Ok(JsonView(false, "程序错误!"));
  180. throw;
  181. }
  182. }
  183. /// <summary>
  184. /// 企业删除
  185. /// </summary>
  186. /// <param name="dto"></param>
  187. /// <returns></returns>
  188. [HttpPost]
  189. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  190. public async Task<IActionResult> DelCompany(DelCompanyDto dto)
  191. {
  192. try
  193. {
  194. bool res = await _syscomRep.SoftDeleteAsync<Sys_Company>(dto.Id.ToString());
  195. if (!res) { return Ok(JsonView(false, "删除失败")); }
  196. return Ok(JsonView(true, "删除成功"));
  197. }
  198. catch (Exception)
  199. {
  200. return Ok(JsonView(false, "程序错误!"));
  201. throw;
  202. }
  203. }
  204. #endregion
  205. #region 部门操作
  206. /// <summary>
  207. /// 查询部门数据
  208. /// </summary>
  209. /// <param name="dto"></param>
  210. /// <returns></returns>
  211. [HttpPost]
  212. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  213. public async Task<IActionResult> QueryDepartmentList(DepartmentDto dto)
  214. {
  215. try
  216. {
  217. if (dto.PortType==1)
  218. {
  219. if (dto.CompanyId!=0)
  220. {
  221. var result = _sysDepRep.QueryDto<Sys_Department, DepartmentIView>(s => s.CompanyId == dto.CompanyId).ToList();
  222. if (result.Count == 0)
  223. {
  224. return Ok(JsonView(false, "暂无数据!"));
  225. }
  226. for (int i = 0; i < result.Count; i++)
  227. {
  228. if (result[i].ParentDepId != 0)
  229. {
  230. result[i].ParentDepName = result.Find(x => x.Id == result[i].ParentDepId).ParentDepName;
  231. }
  232. var company = _sysDepRep.QueryDto<Sys_Company, CompanyView>(s => s.Id == result[i].CompanyId).ToList();
  233. if (company.Count != 0)
  234. {
  235. result[i].CompanyName = company[0].CompanyName;
  236. }
  237. return Ok(JsonView(true, "查询成功!", result));
  238. }
  239. }
  240. else
  241. {
  242. var result = _sysDepRep.QueryDto<Sys_Department, DepartmentIView>(s => s.IsDel <=1).ToList();
  243. if (result.Count == 0)
  244. {
  245. return Ok(JsonView(false, "暂无数据!"));
  246. }
  247. for (int i = 0; i < result.Count; i++)
  248. {
  249. if (result[i].ParentDepId != 0)
  250. {
  251. result[i].ParentDepName = result.Find(x => x.Id == result[i].ParentDepId).ParentDepName;
  252. }
  253. var company = _sysDepRep.QueryDto<Sys_Company, CompanyView>(s => s.Id == result[i].CompanyId).ToList();
  254. if (company.Count != 0)
  255. {
  256. result[i].CompanyName = company[0].CompanyName;
  257. }
  258. }
  259. return Ok(JsonView(true, "查询成功!", result));
  260. }
  261. return Ok(JsonView(false, "暂无数据!"));
  262. }
  263. else if (dto.PortType==2)
  264. {
  265. var result = _sysDepRep.QueryDto<Sys_Department, DepartmentIView>(s => s.CompanyId == dto.CompanyId).ToList();
  266. if (result.Count == 0)
  267. {
  268. return Ok(JsonView(false, "暂无数据!"));
  269. }
  270. return Ok(JsonView(true,"查询成功!",result));
  271. }
  272. else if (dto.PortType == 3)
  273. {
  274. return Ok(JsonView(false, "暂无数据!"));
  275. }
  276. else
  277. {
  278. return Ok(JsonView(false, "暂无数据!"));
  279. }
  280. }
  281. catch (Exception ex)
  282. {
  283. return Ok(JsonView(false, "程序错误!"));
  284. throw;
  285. }
  286. }
  287. /// <summary>
  288. /// 部门添加
  289. /// </summary>
  290. /// <param name="dto"></param>
  291. /// <returns></returns>
  292. [HttpPost]
  293. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  294. public async Task<IActionResult> AddDepartment(AddDepartmentDto dto)
  295. {
  296. try
  297. {
  298. if (dto.CreateUserId == 0 || string.IsNullOrWhiteSpace(dto.DepName) || dto.CompanyId == 0 || string.IsNullOrWhiteSpace(dto.DepCode))
  299. {
  300. return Ok(JsonView(false, "请检查信息是否输入完整!"));
  301. }
  302. else
  303. {
  304. Sys_Department _Department = _mapper.Map<Sys_Department>(dto);
  305. int id = await _sysDepRep.AddAsyncReturnId(_Department);
  306. if (id == 0)
  307. {
  308. return Ok(JsonView(false, "添加失败!"));
  309. }
  310. return Ok(JsonView(true, "添加成功!", new { Id = id }));
  311. }
  312. }
  313. catch (Exception)
  314. {
  315. return Ok(JsonView(false, "程序错误!"));
  316. throw;
  317. }
  318. }
  319. /// <summary>
  320. /// 部门修改
  321. /// </summary>
  322. /// <param name="dto"></param>
  323. /// <returns></returns>
  324. [HttpPost]
  325. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  326. public async Task<IActionResult> EditDepartment(EditDepartmentDto dto)
  327. {
  328. try
  329. {
  330. if (dto.Id==0 || string.IsNullOrWhiteSpace(dto.DepName) || dto.CompanyId == 0 || string.IsNullOrWhiteSpace(dto.DepCode))
  331. {
  332. return Ok(JsonView(false, "请检查信息是否输入完整!"));
  333. }
  334. else
  335. {
  336. bool res = await _sysDepRep.UpdateAsync<Sys_Department>(a => a.Id == dto.Id, a => new Sys_Department
  337. {
  338. CompanyId=dto.CompanyId,
  339. DepCode=dto.DepCode,
  340. DepName=dto.DepName,
  341. ParentDepId=dto.ParentDepId,
  342. Remark=dto.Remark,
  343. });
  344. if (!res)
  345. {
  346. return Ok(JsonView(false, "修改失败!"));
  347. }
  348. return Ok(JsonView(true, "修改成功!"));
  349. }
  350. }
  351. catch (Exception)
  352. {
  353. return Ok(JsonView(false, "程序错误!"));
  354. throw;
  355. }
  356. }
  357. /// <summary>
  358. /// 部门删除
  359. /// </summary>
  360. /// <param name="dto"></param>
  361. /// <returns></returns>
  362. [HttpPost]
  363. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  364. public async Task<IActionResult> DelDepartment(DelDepartmentDto dto)
  365. {
  366. try
  367. {
  368. if (dto.Id == 0)
  369. {
  370. return Ok(JsonView(-1, "请检查信息是否输入完整!", null));
  371. }
  372. else
  373. {
  374. bool res =await _sysDepRep.SoftDeleteAsync<Sys_Department>(dto.Id.ToString());
  375. if (!res)
  376. {
  377. return Ok(JsonView(false, "删除失败!"));
  378. }
  379. return Ok(JsonView(true, "删除成功!"));
  380. }
  381. }
  382. catch (Exception)
  383. {
  384. return Ok(JsonView(false, "程序错误!"));
  385. throw;
  386. }
  387. }
  388. #endregion
  389. #region 岗位板块
  390. /// <summary>
  391. /// 岗位查询
  392. /// </summary>
  393. /// <param name="dto"></param>
  394. /// <returns></returns>
  395. [HttpPost]
  396. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  397. public async Task<IActionResult> QueryJobPost(QueryJobPostDto dto)
  398. {
  399. try
  400. {
  401. if (dto.PortType == 1)
  402. {
  403. string sqlWhere = string.Empty;
  404. if (dto.CompanyId != 0)
  405. {
  406. sqlWhere += string.Format(@" And jp.CompanyId={0}", dto.CompanyId);
  407. }
  408. if (dto.DepId != 0)
  409. {
  410. sqlWhere += string.Format(@" And jp.DepId={0}", dto.DepId);
  411. }
  412. if (!string.IsNullOrEmpty(sqlWhere.Trim()))
  413. {
  414. Regex r = new Regex("And");
  415. sqlWhere = r.Replace(sqlWhere, "Where", 1);
  416. }
  417. List<Sys_JobPostI> jobList = await _jobRep.QueryJobPost(sqlWhere);
  418. List<JobPostView> List = _mapper.Map<List<JobPostView>>(jobList);
  419. if (jobList.Count == 0)
  420. {
  421. return Ok(JsonView(false, "暂无数据!"));
  422. }
  423. return Ok(JsonView(true, "查询成功!", jobList));
  424. }
  425. else if (dto.PortType == 2)
  426. {
  427. var result = _jobRep.QueryDto<Sys_JobPost, JobPostView>(s => s.CompanyId == dto.CompanyId && s.DepId==dto.DepId).ToList();
  428. if (result.Count == 0)
  429. {
  430. return Ok(JsonView(false, "暂无数据!"));
  431. }
  432. return Ok(JsonView(true, "查询成功!", result));
  433. }
  434. else if (dto.PortType == 3)
  435. {
  436. return Ok(JsonView(false, "暂无数据!"));
  437. }
  438. else
  439. {
  440. return Ok(JsonView(false, "暂无数据!"));
  441. }
  442. }
  443. catch (Exception ex)
  444. {
  445. return Ok(JsonView(false, "程序错误!"));
  446. throw;
  447. }
  448. }
  449. /// <summary>
  450. /// 添加岗位
  451. /// </summary>
  452. /// <param name="dto"></param>
  453. /// <returns></returns>
  454. [HttpPost]
  455. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  456. public async Task<IActionResult> AddJobPost(AddJobPostDto dto)
  457. {
  458. try
  459. {
  460. Sys_JobPost sys_Job = _mapper.Map<Sys_JobPost>(dto);
  461. int id = await _jobRep.AddAsyncReturnId(sys_Job);
  462. if (id == 0)
  463. {
  464. return Ok(JsonView(false, "添加失败"));
  465. }
  466. return Ok(JsonView(true, "添加成功", new { Id = id }));
  467. }
  468. catch (Exception ex)
  469. {
  470. return Ok(JsonView(false, "程序错误!"));
  471. throw;
  472. }
  473. }
  474. /// <summary>
  475. /// 修改岗位
  476. /// </summary>
  477. /// <param name="dto"></param>
  478. /// <returns></returns>
  479. [HttpPost]
  480. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  481. public async Task<IActionResult> EditJobPost(EditJobPostDto dto)
  482. {
  483. try
  484. {
  485. bool res = await _jobRep.UpdateAsync<Sys_JobPost>(a=>a.Id==dto.Id,a =>new Sys_JobPost
  486. {
  487. CompanyId=dto.CompanyId,
  488. DepId=dto.DepId,
  489. JobName=dto.JobName,
  490. Remark=dto.Remark,
  491. });
  492. if (!res)
  493. {
  494. return Ok(JsonView(false, "修改失败"));
  495. }
  496. return Ok(JsonView(true, "修改成功"));
  497. }
  498. catch (Exception ex)
  499. {
  500. return Ok(JsonView(false, "程序错误!"));
  501. throw;
  502. }
  503. }
  504. /// <summary>
  505. /// 删除岗位
  506. /// </summary>
  507. /// <param name="dto"></param>
  508. /// <returns></returns>
  509. [HttpPost]
  510. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  511. public async Task<IActionResult> DelJobPost(DelJobPostDto dto)
  512. {
  513. try
  514. {
  515. bool res = await _jobRep.SoftDeleteAsync<Sys_JobPost>(dto.Id.ToString());
  516. if (!res)
  517. {
  518. return Ok(JsonView(false, "删除失败!"));
  519. }
  520. return Ok(JsonView(true, "删除成功"));
  521. }
  522. catch (Exception)
  523. {
  524. return Ok(JsonView(false, "程序错误!"));
  525. throw;
  526. }
  527. }
  528. #endregion
  529. #region 用户操作
  530. /// <summary>
  531. /// 查询所有员工(web)
  532. /// </summary>
  533. /// <param name="dto"></param>
  534. /// <returns></returns>
  535. //[OASystemAuthentication]
  536. [HttpPost]
  537. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  538. public async Task<IActionResult> GetUserList(DtoBase dto)
  539. {
  540. try
  541. {
  542. var result = _userRep.GetUserList(dto.PortType, string.Empty);
  543. if (result.Result.Code != 0)
  544. {
  545. return Ok(JsonView(false, "暂无数据!"));
  546. }
  547. return Ok(JsonView(true, "查询成功!", result.Result.Data));
  548. }
  549. catch (Exception)
  550. {
  551. return Ok(JsonView(false, "程序错误!"));
  552. throw;
  553. }
  554. }
  555. /// <summary>
  556. /// 查询用户数据
  557. /// </summary>
  558. /// <param name="dto"></param>
  559. /// <returns></returns>
  560. [HttpPost]
  561. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  562. public async Task<IActionResult> QueryUserList(UserDto dto)
  563. {
  564. try
  565. {
  566. string sqlWhere = string.Empty;
  567. if (dto.CompanyId!=0)
  568. {
  569. sqlWhere += string.Format(@" And su.CompanyId={0}", dto.CompanyId);
  570. }
  571. if (dto.DepId != 0)
  572. {
  573. sqlWhere += string.Format(@" And su.DepId={0}", dto.DepId);
  574. }
  575. if (dto.JobPostId != 0)
  576. {
  577. sqlWhere += string.Format(@" And su.JobPostId={0}", dto.JobPostId);
  578. }
  579. if (!string.IsNullOrEmpty(sqlWhere.Trim()))
  580. {
  581. Regex r = new Regex("And");
  582. sqlWhere = r.Replace(sqlWhere, "Where", 1);
  583. }
  584. string userSqlWhere = string.Format(@"Select sc.CompanyName,sd.DepName,sjp.JobName,su.* From Sys_Users su
  585. Inner Join Sys_Company sc On su.CompanyId = sc.Id
  586. Inner Join Sys_Department sd On su.DepId = sd.Id
  587. Inner Join Sys_JobPost sjp On su.JobPostId = sjp.Id {0}", sqlWhere);
  588. var _userList =_userRep.GetListBySqlWithNolock(userSqlWhere);
  589. if (_userList.Count == 0)
  590. {
  591. return Ok(JsonView(false, "暂无数据!"));
  592. }
  593. List<UserInfoWebView> userList = _mapper.Map<List<UserInfoWebView>>(_userList);
  594. return Ok(JsonView(true,"查询成功!", userList));
  595. }
  596. catch (Exception)
  597. {
  598. return Ok(JsonView(false, "程序错误!"));
  599. throw;
  600. }
  601. }
  602. /// <summary>
  603. /// 修改用户信息(上级修改/分配 公司、部门、岗位、工号等信息)
  604. /// </summary>
  605. /// <param name="dto"></param>
  606. /// <returns></returns>
  607. [HttpPost]
  608. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  609. public async Task<IActionResult> EditUser(EditUserDto dto)
  610. {
  611. try
  612. {
  613. bool res = await _userRep.UpdateAsync<Sys_Users>(a => a.Id == dto.Id, a => new Sys_Users
  614. {
  615. Number = dto.Number,
  616. CompanyId = dto.CompanyId,
  617. DepId = dto.DepId,
  618. JobPostId = dto.JobPostId,
  619. Ext = dto.Ext,
  620. UsePeriod = dto.UsePeriod,
  621. HrAudit = dto.HrAudit
  622. });
  623. if (!res)
  624. {
  625. return Ok(JsonView(false, "修改失败!"));
  626. }
  627. return Ok(JsonView(true, "修改成功!"));
  628. }
  629. catch (Exception)
  630. {
  631. return Ok(JsonView(false, "程序错误!"));
  632. throw;
  633. }
  634. }
  635. /// <summary>
  636. /// 修改用户信息(登录用户修改个人信息)
  637. /// </summary>
  638. /// <param name="dto"></param>
  639. /// <returns></returns>
  640. [HttpPost]
  641. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  642. public async Task<IActionResult> EditMyUser(EditMyUserDto dto)
  643. {
  644. try
  645. {
  646. if (string.IsNullOrWhiteSpace(dto.CnName) || string.IsNullOrWhiteSpace(dto.Address) || string.IsNullOrWhiteSpace(dto.IDCard) || dto.Sex != 0 && dto.Sex != 1 ||
  647. string.IsNullOrWhiteSpace(dto.MaritalStatus) || string.IsNullOrWhiteSpace(dto.HomeAddress)|| dto.Birthday>=DateTime.Now.AddYears(-1))
  648. {
  649. return Ok(JsonView(false, "请完善你的个人信息!"));
  650. }
  651. else if (string.IsNullOrWhiteSpace(dto.GraduateInstitutions) || string.IsNullOrWhiteSpace(dto.Professional) || dto.Education == 0 || string.IsNullOrWhiteSpace(dto.GraduateInstitutions))
  652. {
  653. return Ok(JsonView(false, "请完善你的学历信息!"));
  654. }
  655. else if (string.IsNullOrWhiteSpace(dto.Phone) || string.IsNullOrWhiteSpace(dto.UrgentPhone) || string.IsNullOrWhiteSpace(dto.Email))
  656. {
  657. return Ok(JsonView(false, "请检查联系方式、紧急联系人及邮箱输写是否正确!"));
  658. }
  659. else
  660. {
  661. bool res = await _userRep.UpdateAsync<Sys_Users>(a => a.Id == dto.Id, a => new Sys_Users
  662. {
  663. CnName = dto.CnName,
  664. EnName = dto.EnName,
  665. Sex = dto.Sex,
  666. Phone = dto.Phone,
  667. UrgentPhone = dto.UrgentPhone,
  668. Email = dto.Email,
  669. Address = dto.Address,
  670. Edate = dto.Edate,
  671. Birthday = dto.Birthday,
  672. IDCard = dto.IDCard,
  673. GraduateInstitutions = dto.GraduateInstitutions,
  674. Professional = dto.Professional,
  675. Education = dto.Education,
  676. TheOrAdultEducation = dto.TheOrAdultEducation,
  677. MaritalStatus = dto.MaritalStatus,
  678. HomeAddress = dto.HomeAddress,
  679. WorkExperience = dto.WorkExperience,
  680. Certificate = dto.Certificate
  681. });
  682. if (!res)
  683. {
  684. return Ok(JsonView(false, "修改失败!"));
  685. }
  686. return Ok(JsonView(true, "修改成功!"));
  687. }
  688. }
  689. catch (Exception)
  690. {
  691. return Ok(JsonView(false, "程序错误!"));
  692. throw;
  693. }
  694. }
  695. #endregion
  696. #region 权限模块
  697. /// <summary>
  698. /// 权限数据页面初始化
  699. /// </summary>
  700. /// <param name="dto"></param>
  701. /// <returns></returns>
  702. //[Authorize]
  703. [HttpPost]
  704. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  705. public async Task<IActionResult> GetAuth(AuthDto dto)
  706. {
  707. Result result = new Result();
  708. //模块数据
  709. var setDataResult = await _setDataRepository.GetSySDefultModule(_setDataRepository);
  710. if (setDataResult.Code != 0)
  711. {
  712. return Ok(JsonView(setDataResult.Msg));
  713. }
  714. //操作方式
  715. var PageOperation = _PageFunctionPermissionRepository.QueryDto<Sys_PageFunctionPermission, Sys_PageFunctionPermission>().ToList();
  716. //获取所有关联页面
  717. var Sys_SystemMenuAndFunction = _SystemMenuAndFunctionRepository.QueryDto<Sys_SystemMenuAndFunction, SystemMenuAndFunctionView>().ToList();
  718. //页面数据
  719. var SystemMenuPermissionData = _SystemMenuPermissionRepository.QueryDto<Sys_SystemMenuPermission, SystemMenuPermissionView>(x=>x.Mid == dto.moduleId).ToList();
  720. if (SystemMenuPermissionData == null || SystemMenuPermissionData.Count() == 0)
  721. {
  722. return Ok(JsonView("暂无数据"));
  723. }
  724. ArrayList viewData = new ArrayList();
  725. //组合页面数据
  726. foreach (var item in SystemMenuPermissionData)
  727. {
  728. ArrayList ids = new ArrayList();
  729. foreach (var viewop in PageOperation)
  730. {
  731. var op = Sys_SystemMenuAndFunction.FirstOrDefault(x => x.SmId == item.Id && x.FId == viewop.Id);
  732. if (op != null)
  733. {
  734. ids.Add(viewop.Id);
  735. }
  736. }
  737. viewData.Add(new
  738. {
  739. Id = item.Id,
  740. Mid = item.Mid,
  741. Name = item.Name,
  742. SystemMenuCode = item.SystemMenuCode,
  743. opList = ids,
  744. selList = new string[0]
  745. }) ;
  746. }
  747. //公司数据
  748. var CompanyDataResult = _CompanyRepository.GetCompanyData();
  749. if (CompanyDataResult.Code != 0)
  750. {
  751. return Ok(JsonView(CompanyDataResult.Msg));
  752. }
  753. result.Code = 0;
  754. result.Msg = "成功!";
  755. var Dyresult = new
  756. {
  757. setDataResult = setDataResult.Data,
  758. CompanyDataResult = CompanyDataResult.Data,
  759. SystemMenuPermissionData = viewData,
  760. PageOperation = PageOperation,
  761. };
  762. return Ok(JsonView(200, "成功!", Dyresult));
  763. }
  764. /// <summary>
  765. /// 获取职务权限
  766. /// </summary>
  767. /// <param name="dto"></param>
  768. /// <returns></returns>
  769. [HttpPost]
  770. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  771. public IActionResult QueryJobAuth(QueryJobAuthDto dto)
  772. {
  773. //选中的操作权限
  774. var DBdata = _JobPostAuthorityRepository.QueryDto<Sys_JobPostAuthority, JobPostAuthorityView>(x=>x.JpId == dto.jobid).ToList();
  775. var SystemMenuPermissionData = _SystemMenuPermissionRepository.QueryDto<Sys_SystemMenuPermission, SystemMenuPermissionView>(x => x.Mid == dto.moduleId).ToList();
  776. if (SystemMenuPermissionData == null || SystemMenuPermissionData.Count() == 0)
  777. {
  778. return Ok(JsonView("暂无数据"));
  779. }
  780. //所有操作
  781. var PageOperation = _PageFunctionPermissionRepository.QueryDto<Sys_PageFunctionPermission, Sys_PageFunctionPermission>().ToList();
  782. //获取所有关联页面
  783. var Sys_SystemMenuAndFunction = _SystemMenuAndFunctionRepository.QueryDto<Sys_SystemMenuAndFunction, SystemMenuAndFunctionView>().ToList();
  784. ArrayList viewData = new ArrayList();
  785. //组合页面数据
  786. foreach (var item in SystemMenuPermissionData)
  787. {
  788. ArrayList ids = new ArrayList();
  789. foreach (var viewop in PageOperation)
  790. {
  791. var op = Sys_SystemMenuAndFunction.FirstOrDefault(x => x.SmId == item.Id && x.FId == viewop.Id);
  792. if (op != null)
  793. {
  794. ids.Add(viewop.Id);
  795. }
  796. }
  797. //获取本职务的页面拥有的权限
  798. var DBwhere = DBdata.Where(x => x.SmId == item.Id && x.JpId == dto.jobid).ToList();
  799. viewData.Add(new
  800. {
  801. Id = item.Id,
  802. Mid = item.Mid,
  803. Name = item.Name,
  804. SystemMenuCode = item.SystemMenuCode,
  805. opList = ids,
  806. selList = DBwhere.Select(x => x.FId)
  807. }) ;
  808. }
  809. return Ok(JsonView(200, "成功!", viewData));
  810. }
  811. /// <summary>
  812. /// 保存岗位权限
  813. /// </summary>
  814. /// <param name="dto"></param>
  815. /// <returns></returns>
  816. [HttpPost]
  817. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  818. public async Task<IActionResult> SaveJobAuth(SaveJobDto dto)
  819. {
  820. //获取所有关联页面
  821. var Sys_SystemMenuAndFunction = _SystemMenuAndFunctionRepository.QueryDto<Sys_SystemMenuAndFunction, SystemMenuAndFunctionView>().ToList();
  822. List<Sys_JobPostAuthority> adds = new List<Sys_JobPostAuthority>();
  823. foreach (var item in dto.Savejobs)
  824. {
  825. foreach (var fid in item.FIds)
  826. {
  827. var whereobj = Sys_SystemMenuAndFunction.FirstOrDefault(x => x.FId == fid && x.SmId == item.SmId);
  828. if (whereobj != null)
  829. {
  830. adds.Add(new Sys_JobPostAuthority
  831. {
  832. CreateTime = DateTime.Now,
  833. CreateUserId = 245,
  834. FId = fid,
  835. JpId = dto.Jpid,
  836. SmId = item.SmId
  837. });
  838. }
  839. }
  840. }
  841. _JobPostAuthorityRepository.BeginTran();
  842. try
  843. { //删除岗位
  844. bool isdel = await _JobPostAuthorityRepository.DeleteAsync<Sys_JobPostAuthority>(x => x.JpId == dto.Jpid);
  845. int UpRows = _JobPostAuthorityRepository.Adds<Sys_JobPostAuthority>(adds);
  846. //获取所有职位员工
  847. var jobUserAll = await QueryUserList(new UserDto { PortType = 2, JobPostId = dto.Jpid });
  848. List<UserInfoWebView> users = null;
  849. var QueryUserListApiResult = (((jobUserAll as OkObjectResult).Value) as OASystem.Domain.ViewModels.JsonView);
  850. if (QueryUserListApiResult != null)
  851. {
  852. if (QueryUserListApiResult.Code == 200)
  853. {
  854. users = QueryUserListApiResult.Data as List<UserInfoWebView>;
  855. }
  856. }
  857. if (users != null && users.Count > 0)
  858. {
  859. List<Sys_UserAuthority> userAuth = null;
  860. foreach (var user in users)
  861. {
  862. //删除个人级岗位权限
  863. isdel = await _UserAuthorityRepository.DeleteAsync<Sys_UserAuthority>(x => x.IsTemp == 1 &&
  864. x.UId == user.Id);
  865. userAuth = adds.Select(x=> new Sys_UserAuthority
  866. {
  867. CreateTime = DateTime.Now,
  868. CreateUserId = 235,
  869. FId = x.FId,
  870. SmId = x.SmId,
  871. UId = user.Id,
  872. IsTemp = 1,
  873. }).ToList();
  874. //添加个人级别岗位
  875. int AddRows = _UserAuthorityRepository.Adds<Sys_UserAuthority>(userAuth);
  876. }
  877. }
  878. }
  879. catch (Exception ex)
  880. {
  881. _JobPostAuthorityRepository.RollbackTran();
  882. return Ok(JsonView("系统错误!"));
  883. }
  884. _JobPostAuthorityRepository.CommitTran();
  885. return Ok(JsonView(200, "成功", new { }));
  886. }
  887. /// <summary>
  888. /// 获取员工权限
  889. /// </summary>
  890. /// <param name="dto"></param>
  891. /// <returns></returns>
  892. [HttpPost]
  893. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  894. public IActionResult QueryUserAuth(QueryUserAuthDto dto)
  895. {
  896. //选中的员工操作权限
  897. var DBdata = _UserAuthorityRepository.QueryDto<Sys_UserAuthority, UserAuthorityView>(x => x.UId == dto.Userid).ToList();
  898. var SystemMenuPermissionData = _SystemMenuPermissionRepository.QueryDto<Sys_SystemMenuPermission, SystemMenuPermissionView>(x => x.Mid == dto.moduleId).ToList();
  899. if (SystemMenuPermissionData == null || SystemMenuPermissionData.Count() == 0)
  900. {
  901. return Ok(JsonView("暂无数据"));
  902. }
  903. //所有操作
  904. var PageOperation = _PageFunctionPermissionRepository.QueryDto<Sys_PageFunctionPermission, Sys_PageFunctionPermission>().ToList();
  905. //获取所有关联页面
  906. var Sys_SystemMenuAndFunction = _SystemMenuAndFunctionRepository.QueryDto<Sys_SystemMenuAndFunction, SystemMenuAndFunctionView>().ToList();
  907. ArrayList viewData = new ArrayList();
  908. //组合页面数据
  909. foreach (var item in SystemMenuPermissionData)
  910. {
  911. ArrayList ids = new ArrayList();
  912. foreach (var viewop in PageOperation)
  913. {
  914. var op = Sys_SystemMenuAndFunction.FirstOrDefault(x => x.SmId == item.Id && x.FId == viewop.Id);
  915. if (op != null)
  916. {
  917. ids.Add(viewop.Id);
  918. }
  919. }
  920. //获取本员工拥有的权限
  921. var DBwhere = DBdata.Where(x => x.SmId == item.Id && x.UId == dto.Userid).ToList();
  922. viewData.Add(new
  923. {
  924. Id = item.Id,
  925. Mid = item.Mid,
  926. Name = item.Name,
  927. SystemMenuCode = item.SystemMenuCode,
  928. opList = ids,
  929. selList = DBwhere.Select(x => x.FId)
  930. });
  931. }
  932. return Ok(JsonView(200, "成功!", viewData));
  933. }
  934. /// <summary>
  935. /// 保存员工权限
  936. /// </summary>
  937. /// <param name="dto"></param>
  938. /// <returns></returns>
  939. [HttpPost]
  940. [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
  941. public async Task<IActionResult> SaveUserAuth(SaveUserDto dto)
  942. {
  943. //获取所有关联页面
  944. var Sys_SystemMenuAndFunction = _SystemMenuAndFunctionRepository.QueryDto<Sys_SystemMenuAndFunction, SystemMenuAndFunctionView>().ToList();
  945. List<Sys_UserAuthority> adds = new List<Sys_UserAuthority>();
  946. foreach (var item in dto.Savejobs)
  947. {
  948. foreach (var fid in item.FIds)
  949. {
  950. var whereobj = Sys_SystemMenuAndFunction.FirstOrDefault(x => x.FId == fid && x.SmId == item.SmId);
  951. if (whereobj != null)
  952. {
  953. adds.Add(new Sys_UserAuthority
  954. {
  955. CreateTime = DateTime.Now,
  956. CreateUserId = 235,
  957. FId = fid,
  958. UId = dto.uid,
  959. SmId = item.SmId,
  960. IsTemp = 0
  961. });
  962. }
  963. }
  964. }
  965. _JobPostAuthorityRepository.BeginTran();
  966. try
  967. {
  968. List<Sys_UserAuthority> userAuth = null;
  969. //删除个人级岗位权限
  970. bool isdel = await _UserAuthorityRepository.DeleteAsync<Sys_UserAuthority>(x=> x.UId == dto.uid);
  971. userAuth = adds.Select(x => new Sys_UserAuthority
  972. {
  973. CreateTime = DateTime.Now,
  974. CreateUserId = 235,
  975. FId = x.FId,
  976. SmId = x.SmId,
  977. UId = dto.uid,
  978. IsTemp = 0,
  979. }).ToList();
  980. //添加个人级别岗位
  981. int AddRows = _UserAuthorityRepository.Adds<Sys_UserAuthority>(userAuth);
  982. }
  983. catch (Exception ex)
  984. {
  985. _JobPostAuthorityRepository.RollbackTran();
  986. return Ok(JsonView("系统错误!"));
  987. }
  988. _JobPostAuthorityRepository.CommitTran();
  989. return Ok(JsonView(200, "成功", new { }));
  990. }
  991. #endregion
  992. }
  993. }