public DataTable GetPrePathLongAndLat(string string_0, string string_1, string string_2) { SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@telephone", string_0), new SqlParameter("@BeginTime", string_1), new SqlParameter("@EndTime", string_2) }; string str = "Select Longitude,Latitude from gpsrecerealtime Where telephone=@telephone and gpsTIME>=@BeginTime and gpsTIME<=@EndTime and not Longitude is null and not Latitude is null and Longitude>0.0000001 and Latitude>0.0000001 order by gpsTIME"; SqlDataAccess access = new SqlDataAccess(); return access.getDataBySqlParam(str, parameterArray); }