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;
}
