/// <summary>
/// 桥梁Csv文件查询结果转换成泛型集合
/// </summary>
/// <param name="filePath">文件路径</param>
/// <returns>以实体类为元素的泛型集合</returns>
public List<Bridge> ImportBridgeList(string filePath)
{
List<Bridge> b = new List<Bridge>();
StreamReader fileReader = new StreamReader(filePath, Encoding.Default);
try
{
//列之间的分隔符
char cv = ',';
while (fileReader.EndOfStream == false)
{
Bridge t = new Bridge();
string line = fileReader.ReadLine();
string[] y = line.Split(cv);
t.Stake = y[0].Trim().ToString();
t.StartStake = y[1].Trim().ToString();
t.EndStake = y[2].Trim().ToString();
t.Type = Convert.ToInt32(y[3].Trim().ToString());
t.Name = y[4].Trim().ToString();
t.Angle = Convert.ToDouble(y[5].Trim().ToString());
t.LeftWidth = Convert.ToDouble(y[6].Trim().ToString());
t.RightWidth = Convert.ToDouble(y[7].Trim().ToString());
t.SpanDescription = y[8].Trim().ToString();
b.Add(t);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
fileReader.Close();
fileReader.Dispose();
}
return b;
}
/// <summary>
/// 加载桥梁
/// </summary>
/// <param name="RouteID"></param>
/// <returns></returns>
public List<Bridge> Load(int RouteID)
{
List<Bridge> list = new List<Bridge>();
if (DbConnection == null) return null;
string sql = @"select * from RDC_Bridge where RouteID='" + RouteID + "'";
DataSet ds = DbConnection.GetDataSet(sql);
foreach (DataRow r in ds.Tables[0].Rows)
{
Bridge b = new Bridge();
b.BridgeID = r["BridgeID"] == DBNull.Value ? 0 : Convert.ToInt32(r["BridgeID"]);
b.RouteID = r["RouteID"] == DBNull.Value ? 0 : Convert.ToInt32(r["RouteID"]);
b.Stake = r["Stake"].ToString();
b.StartStake = r["StartStake"].ToString();
b.EndStake = r["EndStake"].ToString();
b.Type = r["Type"] == DBNull.Value ? 0 : Convert.ToInt32(r["Type"]);
b.Name = r["Name"].ToString();
b.Angle = r["Angle"] == DBNull.Value ? 0 : Convert.ToDouble(r["Angle"]);
b.LeftWidth = r["LeftWidth"] == DBNull.Value ? 0 : Convert.ToDouble(r["LeftWidth"]);
b.RightWidth = r["RightWidth"] == DBNull.Value ? 0 : Convert.ToDouble(r["RightWidth"]);
b.SpanDescription = r["SpanDescription"].ToString();
list.Add(b);
}
return list;
}