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