public IList <User> GetList(User.Query filter, int?limit = null) { StringBuilder sql = new StringBuilder(@"select * from ec_user 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 <User>(sql, param)); }
public IList <User> GetList(User.Query filter) { DynamicParameters param = new DynamicParameters(); StringBuilder sql = new StringBuilder(@"select * from ec_user where 1 = 1 "); sql.AndEquals("mobile"); sql.AndEquals("id"); sql.AndDateBetween("add_time", "startdate", "enddate"); sql.AndEquals("introducer"); if (filter != null) { param.AddDynamicParams(filter); } //sql.AndIn("status","p_status"); //sql.AndIn("status", filter.Status, ref param); return(db.GetList <User>(sql, param)); }
public IList <User> GetList(User.Query query, int?limit = null) { return(dao.GetList(query, limit)); }
public IList <User> GetList(User.Query query) { return(dao.GetList(query)); }
/// <summary> /// Searches the server for results matching the values set on the query. /// The query can be null to search for all User documents. /// </summary> public TypedArray <User> GetUsers(User.Query query = null) { return(Request <User>(query)); }
/// <summary> /// Searches the server for results matching the values set on the query. /// The QueryOptions controls paging of results. /// </summary> public TypedArray <User> GetUsers(QueryOptions options, User.Query query) { return(Request <User>(options, query)); }