/// <summary>
/// 按条件查询数据表,返回DataTable类型数据
/// </summary>
/// <param name="whereClause">SQL条件语句(可为空)，不须带"Where"关键字</param>
/// <param name="dataFields">需返回字段(不能为空,为"*"则返回所有字段)</param>
/// <param name="orderBy">SQL排序语句(可为空)，不须带"Order By"关键字</param>
/// <param name="rowsToReturn">返回记录数量</param>
/// <returns>DataTable</returns>
public static DataTable SearchDT(string whereClause, string dataFields, string orderBy, int rowsToReturn)
{
if (dataFields.Trim() == "*")
{
dataFields = C_SP_COLLECTINFO_FIELDS;
}
return(SqlListHepler.Search(ConnectionString, C_TABLE_NAME, dataFields, whereClause, orderBy, rowsToReturn));
}
/// <summary>
/// 按条件查询数据表,返回DataTable类型数据
/// </summary>
/// <param name="whereClause">SQL条件语句(可为空)，不须带"Where"关键字</param>
/// <param name="dataFields">需返回字段(不能为空,为"*"则返回所有字段)</param>
/// <param name="orderBy">SQL排序语句(不能为空)，不须带"Order By"关键字</param>
/// <param name="startRowIndex">记录开始索引，从0开始</param>
/// <param name="maximumRows">返回记录数量</param>
/// <returns>DataTable</returns>
public static DataTable SearchDT(string whereClause, string dataFields, string orderBy, int startRowIndex, int maximumRows)
{
if (dataFields.Trim() == "*")
{
dataFields = C_SP_URL_FIELDS;
}
return(SqlListHepler.Search(ConnectionString, C_TABLE_NAME, dataFields, whereClause, orderBy, startRowIndex, maximumRows));
}
/// <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);
}
/// <summary>
/// 按条件获取记录数量
/// </summary>
/// <param name="whereClause">SQL条件语句(可为空)，不须带"Where"关键字</param>
/// <returns>int整型数据</returns>
public static int SearchCount(string whereClause)
{
return(SqlListHepler.SearchCount(ConnectionString, C_TABLE_NAME, whereClause));
}
