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));
}