Esempio n. 1
0
        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public IList <Wuyiju.Model.Title> GetList(Wuyiju.Model.Title.Query filter, int?limit = null)
        {
            StringBuilder sql = new StringBuilder(@"select * from ec_title where 1 = 1 ");

            sql.AndEquals("parent_id")
            .AndEquals("status")
            .AndEquals("recommend")
            .AndEquals("show_in_nav")
            .AndEquals("type")
            .AndEquals("is_hots")
            .AndEquals("url_type");

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