public List<IntersectionPoint> Load(int FlatCurveID) { List<IntersectionPoint> list = new List<IntersectionPoint>(); if (DbConnection == null) return null; string sql = @"select *from RDC_IntersectionPoint where FlatCurveID='" + FlatCurveID + "'"; DataSet ds = DbConnection.GetDataSet(sql); foreach (DataRow b in ds.Tables[0].Rows) { IntersectionPoint ip = new IntersectionPoint(); ip.IntersectionPointID = (int)b["IntersectionPointID"]; ip.FlatCurveID = b["FlatCurveID"] == DBNull.Value ? 0 : Convert.ToInt32(b["FlatCurveID"]); ip.SerialNumber = b["SerialNumber"] == DBNull.Value ? 0 : Convert.ToInt32(b["SerialNumber"]); ip.JDBH = b["JDBH"].ToString(); ip.Stake = b["Stake"].ToString(); ip.X = b["X"] == DBNull.Value ? 0 : Convert.ToDouble(b["X"]); ip.Y = b["Y"] == DBNull.Value ? 0 : Convert.ToDouble(b["Y"]); ip.R = b["R"] == DBNull.Value ? 0 : Convert.ToDouble(b["R"]); ip.Ls1 = b["Ls1"] == DBNull.Value ? 0 : Convert.ToDouble(b["Ls1"]); ip.Ls2 = b["Ls2"] == DBNull.Value ? 0 : Convert.ToDouble(b["Ls2"]); ip.Ls1R = b["Ls1R"] == DBNull.Value ? 0 : Convert.ToDouble(b["Ls1R"]); ip.Ls2R = b["Ls2R"] == DBNull.Value ? 0 : Convert.ToDouble(b["Ls2R"]); list.Add(ip); } return list; }
/// <summary> /// 交点Csv文件查询结果转换成泛型集合 /// </summary> /// <param name="filePath">文件路径</param> /// <returns>以实体类为元素的泛型集合</returns> public List<IntersectionPoint> ImportIntersectionPointList(string filePath) { List<IntersectionPoint> ip = new List<IntersectionPoint>(); StreamReader fileReader = new StreamReader(filePath, Encoding.Default); try { //列之间的分隔符 char cv = ','; while (fileReader.EndOfStream == false) { IntersectionPoint t = new IntersectionPoint(); string line = fileReader.ReadLine(); string[] y = line.Split(cv); t.Stake = y[0].Trim().ToString(); t.X = Convert.ToDouble(y[1].Trim().ToString()); t.Y = Convert.ToDouble(y[2].Trim().ToString()); t.R = Convert.ToDouble(y[3].Trim().ToString()); t.Ls1 = Convert.ToDouble(y[4].Trim().ToString()); t.Ls2 = Convert.ToDouble(y[5].Trim().ToString()); t.Ls1R = Convert.ToDouble(y[6].Trim().ToString()); t.Ls2R = Convert.ToDouble(y[7].Trim().ToString()); ip.Add(t); } } catch (Exception ex) { throw ex; } finally { fileReader.Close(); fileReader.Dispose(); } return ip; }