/// <summary> /// 获得前几行数据 /// </summary> public IList <Wuyiju.Model.Attribute> GetList(Wuyiju.Model.Attribute.Query filter, int?limit = null) { StringBuilder sql = new StringBuilder(@"select * from ec_attribute where 1 = 1 "); sql.AndEquals("pid") .AndEquals("level") .AndEquals("status") .AndEquals("recommend") .AndEquals("input"); sql.Append(" order by sort "); 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.Attribute>(sql, param)); }
/// <summary> /// 获得数据列表 /// </summary> public IList <Wuyiju.Model.Attribute> GetList(Wuyiju.Model.Attribute.Query query) { using (var db = new DataContext()) { var _dao = this.GetDao(db); return(_dao.GetList(query)); } }
/// <summary> /// 获得数据列表 /// </summary> public IList <Wuyiju.Model.Attribute> GetList(Wuyiju.Model.Attribute.Query filter) { StringBuilder sql = new StringBuilder(@"select * from ec_attribute where (1 = 1)"); DynamicParameters param = new DynamicParameters(); sql.AndEquals("pid") .AndEquals("level") .AndEquals("recommend") .AndEquals("status"); if (filter != null) { param.AddDynamicParams(filter); } return(db.GetList <Wuyiju.Model.Attribute>(sql, param)); }