/// <summary> /// 获取省市地列表 /// </summary> /// <returns></returns> public List <dynamic> GetMdmBasRegionList(MdmBasRegionQuery query) { return(_sqlQuery.Select(@"REGION_NO,REGION_NAME") .Filter("PARENT_REGION_NO", query.PARENT_REGION_NO) .Filter("REGION_LEVEL", query.REGION_LEVEL) .Filter("DEL_FLAG", "1") .OrderBy("REGION_NO") .GetList <dynamic>("MDM_BAS_REGION", Context.Database.GetDbConnection())); }
public ActionResult GetMdmBasRegionList(MdmBasRegionQuery query) { try { var result = _mdmBasRegionRepository.GetMdmBasRegionList(query); return(Success("获取成功", result)); } catch (Exception ex) { return(Fail(ex.Message)); } }