예제 #1
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public IList <Wuyiju.Model.Links> GetList(Wuyiju.Model.Links.Query filter)
        {
            StringBuilder     sql   = new StringBuilder(@"select * from ec_links where 1 = 1 ");
            DynamicParameters param = new DynamicParameters();

            sql.AndEquals("status").AndEquals("recommend");

            if (filter != null)
            {
                param.AddDynamicParams(filter);
            }
            return(db.GetList <Wuyiju.Model.Links>(sql, param));
        }
예제 #2
0
        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public IList <Wuyiju.Model.Links> GetList(Wuyiju.Model.Links.Query filter, int?limit = null)
        {
            StringBuilder sql = new StringBuilder(@"select * from ec_links where 1 = 1 ");

            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.Links>(sql, param));
        }
예제 #3
0
 /// <summary>
 /// 获得前几行数据
 /// </summary>
 public IList <Wuyiju.Model.Links> GetList(Wuyiju.Model.Links.Query query, int?limit = null)
 {
     return(dao.GetList(query, limit));
 }
예제 #4
0
 /// <summary>
 /// 获得数据列表
 /// </summary>
 public IList <Wuyiju.Model.Links> GetList(Wuyiju.Model.Links.Query query)
 {
     return(dao.GetList(query));
 }