/// <summary> /// 获得前几行数据 /// </summary> public IList <Wuyiju.Model.ProductAttr> GetList(Wuyiju.Model.ProductAttr.Query filter, int?limit = null) { StringBuilder sql = new StringBuilder(@"select * from ec_product_attr where 1 = 1 "); sql.AndEquals("product_id"); if (limit != null) { sql.Append(" limit @rows "); } DynamicParameters param = new DynamicParameters(); if (filter != null) { param.AddDynamicParams(filter); } if (limit != null) { param.Add("rows", limit); } return(db.GetList <Wuyiju.Model.ProductAttr>(sql, param)); }
/// <summary> /// 获得数据列表 /// </summary> public IList <Wuyiju.Model.ProductAttr> GetList(Wuyiju.Model.ProductAttr.Query filter) { StringBuilder sql = new StringBuilder(@"select p.*,a.name as attr_name from ec_product_attr p left join ec_attribute a on a.id = p.attr_id where 1 = 1 "); sql.AndEquals("a.type", "Type"); sql.AndEquals("a.recommend", "recommend"); sql.AndEquals("p.product_id", "product_id"); sql.AndEquals("p.attr_id", "attr_id"); sql.Append(" order by a.sort asc "); DynamicParameters param = new DynamicParameters(); if (filter != null) { param.AddDynamicParams(filter); } return(db.GetList <Wuyiju.Model.ProductAttr>(sql, param)); }
/// <summary> /// 获得数据列表 /// </summary> public IList <Wuyiju.Model.ProductAttr> GetList(Wuyiju.Model.ProductAttr.Query query) { return(dao.GetList(query)); }
/// <summary> /// 获得前几行数据 /// </summary> public IList <Wuyiju.Model.ProductAttr> GetList(Wuyiju.Model.ProductAttr.Query query, int?limit = null) { return(dao.GetList(query, limit)); }