/// <summary> /// 区域列表 /// </summary> /// <returns></returns> public IEnumerable <AreaEntity> GetList() { var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Area where 1=1 and Layer<>4 and EnabledMark<>0"); sql.Append(" order by CreateDate desc"); var list = Base_Area.Query(sql); return(EntityConvertTools.CopyToList <Base_Area, AreaEntity>(list.ToList())); }
/// <summary> /// 区域列表 /// </summary> /// <param name="parentId">节点Id</param> /// <param name="keyword">关键字查询</param> /// <returns></returns> public IEnumerable <AreaEntity> GetList(string parentId, string keyword) { var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Area where 1=1"); if (!string.IsNullOrEmpty(parentId)) { sql.Append(" and ParentId=@0", parentId); } if (!string.IsNullOrEmpty(keyword)) { sql.Append(" and (charindex(@0,AreaCode)>0 or (charindex(@0,AreaName)>0", keyword); } var list = Base_Area.Query(sql); return(EntityConvertTools.CopyToList <Base_Area, AreaEntity>(list.ToList())); }