public static string GetFeature(string p_key, int p_size, int p_page) { StringBuilder sb = new StringBuilder(); using (OracleConnection conn = new OracleConnection(OraHelper.str)) { conn.Open(); OracleCommand comm = conn.CreateCommand(); comm.CommandText = string.Format(SQL_SEARCH_STATION_TOTAL, p_size, p_key); object total = comm.ExecuteScalar(); comm.CommandText = string.Format(SQL_SEARCH_STATION, p_key, p_page * p_size, (p_page - 1) * p_size); OracleDataReader rdr = comm.ExecuteReader(); string str = Reader2JSON.ToJSON(rdr); sb.Append("{\"total\":"); sb.Append(total); sb.Append(",\"page\":"); sb.Append(p_page); sb.Append(",\"content\":"); sb.Append(str); sb.Append("}"); conn.Close(); } return(sb.ToString()); }
public static string GetFeature(string p_key, int p_size, int p_page, double p_left, double p_bottom, double p_right, double p_top) { StringBuilder sb = new StringBuilder(); using (OracleConnection conn = new OracleConnection(OraHelper.str)) { conn.Open(); OracleCommand comm = conn.CreateCommand(); comm.CommandText = string.Format(SQL_RECTANGLE_KEYWORD_TOTAL, p_size, p_left, p_right, p_bottom, p_top, p_key); object total = comm.ExecuteScalar(); comm.CommandText = string.Format(SQL_RECTANGLE_KEYWORD, p_key, p_left, p_right, p_bottom, p_top, p_page * p_size, (p_page - 1) * p_size); OracleDataReader rdr = comm.ExecuteReader(); string str = Reader2JSON.ToJSON(rdr); sb.Append("{total:"); sb.Append(total); sb.Append(",page:"); sb.Append(p_page); sb.Append(",content:"); sb.Append(str); sb.Append("}"); conn.Close(); } return(sb.ToString()); }