/// <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));
}
}
