比较2个时间段是否有交集的方法

特容易绕晕，花了好长时间才写出来，郁闷死了

1.         #region 判断时间段是否相交(道路和区域限速)
2.         /// <summary>
3.         /// 比较设置的结束时间
4.         /// </summary>
5.         /// <param name="endTime">设置的结束时间</param>
6.         /// <param name="tableName">表名</param>
7.         /// <param name="uVehicleCheck">控件对象</param>
8.         /// <returns>true：时间相交；false：时间不相交</returns>
9.         private bool compareEndTimeForSpeed(string layerID, string endTime, string tableName, GPS_5_0_Client.CommonControl.VehicleCheck.UVehicleCheck uVehicleCheck)
10.         {
11.             bool resualt = true;
12.             string sqlstr = "";
13.             for (int i = 0; i < uVehicleCheck.VehicleCollection.Count; i++)
14.             {
15.                 vehNo = uVehicleCheck.VehicleCollection[i].Text;
16.                 string sql = "select vehiclekey from vehicleinfo where platenumber='" + uVehicleCheck.VehicleCollection[i].Text + "'";
17.                 int vehID = int.Parse(GPS_5_0_Server.DBUtility.DbHelperOra.GetSingle(sql).ToString());
18.                 if (layerID == "")
19.                 {
20.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID;
21.                 }
22.                 else
23.                 {
24.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID + " and layerid=" + int.Parse(layerID);
25.                 }
26.                 //string sqlstr2 = "select endtime from " + tableName + " where vehiclekey=" + vehID;
27.                 DataSet ds = new DataSet();
28.                 //DataSet ds_Start = new DataSet();
29.                 //DataSet ds_end = new DataSet();
30.                 ds = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr);
31.                 //ds_end = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr2);
32.                 if (ds.Tables[0].Rows.Count > 0)
33.                 {
34.                     for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
35.                     {
36.                         if (endTime.CompareTo(ds.Tables[0].Rows[j]["starttime"].ToString()) > 0 && endTime.CompareTo(ds.Tables[0].Rows[j]["endtime"].ToString()) <= 0)
37.                         {
38.                             resualt = true;
39.                             break;
40.                         }
41.                         else
42.                         {
43.                             resualt = false;
45.                         }
46.                         //break;
47.                     }
48.                 }
49.                 else
50.                 {
51.                     resualt = false;
52.                 }
53.             }
54.             return resualt;
55.         }
56.         /// <summary>
57.         /// 比较设置的开始时间
58.         /// </summary>
59.         /// <param name="startTime">设置的开始时间</param>
60.         /// <param name="tableName">表名</param>
61.         /// <param name="uVehicleCheck">控件对象</param>
62.         /// <returns>true：时间相交；false：时间不相交</returns>
63.         private bool compareStartTimeForSpeed(string layerID, string startTime, string tableName, GPS_5_0_Client.CommonControl.VehicleCheck.UVehicleCheck uVehicleCheck)
64.         {
65.             bool resualt = true;
66.             string sqlstr = "";
67.             for (int i = 0; i < uVehicleCheck.VehicleCollection.Count; i++)
68.             {
69.                 vehNo = uVehicleCheck.VehicleCollection[i].Text;
70.                 string sql = "select vehiclekey from vehicleinfo where platenumber='" + uVehicleCheck.VehicleCollection[i].Text + "'";
71.                 int vehID = int.Parse(GPS_5_0_Server.DBUtility.DbHelperOra.GetSingle(sql).ToString());
72.                 if (layerID == "")
73.                 {
74.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID;
75.                 }
76.                 else
77.                 {
78.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID + " and layerid=" + int.Parse(layerID);
79.                 }
80.                 //string sqlstr2 = "select endtime from " + tableName + " where vehiclekey=" + vehID;
81.                 DataSet ds = new DataSet();
82.                 //DataSet ds_Start = new DataSet();
83.                 //DataSet ds_end = new DataSet();
84.                 ds = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr);
85.                 //ds_end = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr2);
86.                 if (ds.Tables[0].Rows.Count > 0)
87.                 {
88.                     for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
89.                     {
90.                         string s1 = ds.Tables[0].Rows[j]["starttime"].ToString();
91.                         string s2 = ds.Tables[0].Rows[j]["endtime"].ToString();
92.                         if (startTime.CompareTo(ds.Tables[0].Rows[j]["starttime"].ToString()) >= 0 && startTime.CompareTo(ds.Tables[0].Rows[j]["endtime"].ToString()) < 0)
93.                         {
94.                             resualt = true;
95.                             break;
96.                         }
97.                         else
98.                        {
99.                             resualt = false;
100.                         }
101.                         //break;
102.                     }
103.                 }
104.                 else
105.                 {
106.                     resualt = false;
107.                 }
108.             }
109.             return resualt;
110.         }
111.         /// <summary>
112.         /// 同时比较设置的开始时间和结束时间
113.         /// </summary>
114.         /// <param name="startTime">设置的开始时间</param>
115.         /// <param name="endTime">设置的结束时间</param>
116.         /// <param name="tableName">表名</param>
117.         /// <param name="uVehicleCheck">控件对象</param>
118.         /// <returns>true：时间相交；false：时间不相交</returns>
119.         private bool compareStartTimeAndEndTime1ForSpeed(string layerID, string startTime, string endTime, string tableName, GPS_5_0_Client.CommonControl.VehicleCheck.UVehicleCheck uVehicleCheck)
120.         {
121.             bool resualt = true;
122.             string sqlstr = "";
123.             for (int i = 0; i < uVehicleCheck.VehicleCollection.Count; i++)
124.             {
125.                 vehNo = uVehicleCheck.VehicleCollection[i].Text;
126.                 string sql = "select vehiclekey from vehicleinfo where platenumber='" + uVehicleCheck.VehicleCollection[i].Text + "'";
127.                 int vehID = int.Parse(GPS_5_0_Server.DBUtility.DbHelperOra.GetSingle(sql).ToString());
128.                 if (layerID == "")
129.                 {
130.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID;
131.                 }
132.                 else
133.                 {
134.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID + " and layerid=" + int.Parse(layerID);
135.                 }
136.                 //string sqlstr2 = "select endtime from " + tableName + " where vehiclekey=" + vehID;
137.                 DataSet ds = new DataSet();
138.                 //DataSet ds_Start = new DataSet();
139.                 //DataSet ds_end = new DataSet();
140.                 ds = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr);
141.                 //ds_end = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr2);
142.                 if (ds.Tables[0].Rows.Count > 0)
143.                 {
144.                     for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
145.                     {
146.                         if (startTime.CompareTo(ds.Tables[0].Rows[j]["starttime"].ToString()) >= 0 && endTime.CompareTo(ds.Tables[0].Rows[j]["endtime"].ToString()) <= 0)
147.                         {
148.                             resualt = true;
149.                             break;
150.                         }
151.                         else
152.                         {
153.                             resualt = false;
154.                         }
155.                         //break;
156.                     }
157.                 }
158.                 else
159.                 {
160.                     resualt = false;
161.                 }
162.             }
163.             return resualt;
164.         }
165.         /// <summary>
166.         /// 同时比较设置的开始时间和结束时间
167.         /// </summary>
168.         /// <param name="startTime">设置的开始时间</param>
169.         /// <param name="endTime">设置的结束时间</param>
170.         /// <param name="tableName">表名</param>
171.         /// <param name="uVehicleCheck">控件对象</param>
172.         /// <returns>true：时间相交；false：时间不相交</returns>
173.         private bool compareStartTimeAndEndTime2ForSpeed(string layerID, string startTime, string endTime, string tableName, GPS_5_0_Client.CommonControl.VehicleCheck.UVehicleCheck uVehicleCheck)
174.         {
175.             bool resualt = true;
176.             string sqlstr = "";
177.             for (int i = 0; i < uVehicleCheck.VehicleCollection.Count; i++)
178.             {
179.                 vehNo = uVehicleCheck.VehicleCollection[i].Text;
180.                 string sql = "select vehiclekey from vehicleinfo where platenumber='" + uVehicleCheck.VehicleCollection[i].Text + "'";
181.                 int vehID = int.Parse(GPS_5_0_Server.DBUtility.DbHelperOra.GetSingle(sql).ToString());
182.                 if (layerID == "")
183.                 {
184.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID;
185.                 }
186.                 else
187.                 {
188.                     sqlstr = "select starttime,endtime from " + tableName + " where vehicleid=" + vehID + " and layerid=" + int.Parse(layerID);
189.                 }
190.                 //string sqlstr2 = "select endtime from " + tableName + " where vehiclekey=" + vehID;
191.                 DataSet ds = new DataSet();
192.                 //DataSet ds_Start = new DataSet();
193.                 //DataSet ds_end = new DataSet();
194.                 ds = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr);
195.                 //ds_end = GPS_5_0_Server.DBUtility.DbHelperOra.Query(sqlstr2);
196.                 if (ds.Tables[0].Rows.Count > 0)
197.                 {
198.                     for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
199.                     {
200.                         if (startTime.CompareTo(ds.Tables[0].Rows[j]["starttime"].ToString()) <= 0 && endTime.CompareTo(ds.Tables[0].Rows[j]["endtime"].ToString()) >= 0)
201.                         {
202.                             resualt = true;
203.                             break;
204.                         }
205.                         else
206.                         {
207.                             resualt = false;
208.                         }
209.                         //break;
210.                     }
211.                 }
212.                 else
213.                 {
214.                     resualt = false;
215.                 }
216.             }
217.             return resualt;
218.         }
219.         #endregion