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