/// <summary>
/// 按条件查询数据表,返回 Entity.CollectInfoEntity 数据集
/// </summary>
/// <param name="whereClause">SQL条件语句(可为空)，不须带"Where"关键字</param>
/// <param name="orderBy">SQL排序语句(可为空)，不须带"Order By"关键字</param>
/// <param name="rowsToReturn">返回记录数量</param>
public static List <Entity.CollectInfoEntity> Search(string whereClause, string orderBy, int rowsToReturn)
{
List <Entity.CollectInfoEntity> list = new List <Entity.CollectInfoEntity>();
using (SqlDataReader reader = SqlListHepler.SearchDataReader(ConnectionString, C_TABLE_NAME, C_SP_COLLECTINFO_FIELDS, whereClause, orderBy, rowsToReturn))
{
while (reader.Read())
{
list.Add(ConvertToEntityFromDataReader(reader));
}
}
return(list);
}
/// <summary>
/// 按条件查询数据表,返回 Entity.UrlEntity 数据集
/// </summary>
/// <param name="whereClause">SQL条件语句(可为空)，不须带"Where"关键字</param>
/// <param name="orderBy">SQL排序语句(不能为空)，不须带"Order By"关键字</param>
/// <param name="startRowIndex">记录开始索引，从0开始</param>
/// <param name="maximumRows">返回记录数量</param>
public static List <Entity.UrlEntity> Search(string whereClause, string orderBy, int startRowIndex, int maximumRows)
{
List <Entity.UrlEntity> list = new List <Entity.UrlEntity>();
using (SqlDataReader reader = SqlListHepler.SearchDataReader(ConnectionString, C_TABLE_NAME, C_SP_URL_FIELDS, whereClause, orderBy, startRowIndex, maximumRows))
{
while (reader.Read())
{
list.Add(ConvertToEntityFromDataReader(reader));
}
}
return(list);
}