コード例 #1
0
ファイル: Alarm.cs プロジェクト: lexzh/Myproject
 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);
 }