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