CodeAreaManage.cs 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. using Central.Control.Domain;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. namespace MES.Production.Service.ServiceImp
  7. {
  8. /// <summary>
  9. /// Service 省市级联处理类
  10. /// add 作者: 季健国 QQ:181589805 by 2016-05-22
  11. /// </summary>
  12. public class CodeAreaManage : RepositoryBase<SYS_CODE_AREA>, IService.ICodeAreaManage
  13. {
  14. /// <summary>
  15. /// 获取所有省份信息
  16. /// </summary>
  17. public IQueryable<SYS_CODE_AREA> LoadProvince()
  18. {
  19. return this.LoadAll(p => p.LEVELS == 1);
  20. }
  21. /// <summary>
  22. /// 根据省份ID获取城市信息
  23. /// </summary>
  24. public IQueryable<SYS_CODE_AREA> LoadCity(string provinceId)
  25. {
  26. return this.LoadAll(p => p.LEVELS == 2 && p.PID == provinceId);
  27. }
  28. /// <summary>
  29. /// 根据城市信息获取所有县级市信息
  30. /// </summary>
  31. public IQueryable<SYS_CODE_AREA> LoadCountry(string cityId)
  32. {
  33. return this.LoadAll(p => p.LEVELS == 3 && p.PID == cityId);
  34. }
  35. /// <summary>
  36. /// 根据县级市ID获取乡镇信息
  37. /// </summary>
  38. public IQueryable<SYS_CODE_AREA> LoadCommunity(string countryId)
  39. {
  40. return this.LoadAll(p => p.LEVELS == 4 && p.PID == countryId);
  41. }
  42. }
  43. }