/// <summary>
/// 获得前几行数据
/// </summary>
public IList <Wuyiju.Model.Category> GetList(Wuyiju.Model.Category.Query query, int[] limit = null)
{
using (var db = new DataContext())
{
var _dao = this.GetDao(db);
return(_dao.GetList(query, limit));
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public IList <Wuyiju.Model.Category> GetList(Wuyiju.Model.Category.Query filter)
{
StringBuilder sql = new StringBuilder(@"select * from ec_category where 1 = 1 ");
sql.AndEquals("status").AndEquals("parent_id");
DynamicParameters param = new DynamicParameters();
if (filter != null)
{
param.AddDynamicParams(filter);
}
return(db.GetList <Wuyiju.Model.Category>(sql, param));
}
/// <summary>
/// 获得前几行数据
/// </summary>
public IList <Wuyiju.Model.Category> GetList(Wuyiju.Model.Category.Query filter, int[] limit = null)
{
StringBuilder sql = new StringBuilder(@"select * from ec_category where 1 = 1 ");
sql.AndEquals("status").AndEquals("parent_id").AndEquals("is_recommend", "recommend");
if (limit != null)
{
if (limit.Length == 1)
{
sql.Append(" limit @rows ");
}
if (limit.Length == 2)
{
sql.Append(" limit @start,@rows ");
}
}
DynamicParameters param = new DynamicParameters();
if (filter != null)
{
param.AddDynamicParams(filter);
}
if (limit != null)
{
if (limit.Length == 1)
{
param.Add("rows", limit[0]);
}
if (limit.Length == 2)
{
param.Add("start", limit[0]);
param.Add("rows", limit[1]);
}
}
return(db.GetList <Wuyiju.Model.Category>(sql, param));
}
