/// <summary> /// 变坡点Csv文件查询结果转换成泛型集合 /// </summary> /// <param name="filePath">文件路径</param> /// <returns>以实体类为元素的泛型集合</returns> public List<GradeChangePoint> ImportGradeChangePointList(string filePath) { List<GradeChangePoint> gcp = new List<GradeChangePoint>(); StreamReader fileReader = new StreamReader(filePath, Encoding.Default); try { //列之间的分隔符 char cv = ','; while (fileReader.EndOfStream == false) { string line = fileReader.ReadLine(); string[] y = line.Split(cv); GradeChangePoint t = new GradeChangePoint(); t.Stake = y[0].Trim().ToString(); t.H = Convert.ToDouble(y[1].Trim().ToString()); t.R = Convert.ToDouble(y[2].Trim().ToString()); t.i1 = Convert.ToDouble(y[3].Trim().ToString()); t.i2 = Convert.ToDouble(y[4].Trim().ToString()); gcp.Add(t); } } catch (Exception ex) { throw ex; } finally { fileReader.Close(); fileReader.Dispose(); } return gcp; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { gcp = new GradeChangePoint("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123"); //调用Databind方法 Databind(); //读取传参 Route.Text = Request.Cookies["RouteID"].Value; } if (IsPostBack) { gcp = new GradeChangePoint("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123"); } if (this.GradeChangePoint.SelectedIndex > -1) { // 调用GridView的UpdateRow方法 this.GradeChangePoint.UpdateRow(this.GradeChangePoint.SelectedIndex, false); } }
protected void import_Click(object sender, EventArgs e) { if (file.HasFile == false)// 判断fileupload是否有指定文件 { Response.Write("<script>alert('请您选择Excel文件')</script>"); return;//当无文件时,返回 } string filename = file.PostedFile.FileName; List<GradeChangePoint> gcp = new List<GradeChangePoint>(); CsvFileImport cfi = new CsvFileImport(); gcp = cfi.ImportGradeChangePointList(filename); }
/// <summary> /// 加载变坡点 /// </summary> /// <param name="RouteID"></param> /// <returns></returns> public List<GradeChangePoint> Load(int VerticalCurveID) { if (DbConnection == null) return null; List<GradeChangePoint> list = new List<GradeChangePoint>(); string sql = @"select * from RDC_GradeChangePoint where VerticalCurveID='" + VerticalCurveID + "'"; DataSet ds= DbConnection.GetDataSet(sql); foreach (DataRow g in ds.Tables[0].Rows) { GradeChangePoint gcp = new GradeChangePoint(); gcp.GradeChangePointID = (int)g["GradeChangePointID"]; gcp.VerticalCurveID =g["VerticalCurveID"] == DBNull.Value ? 0 : Convert.ToInt32(g["VerticalCurveID"]); gcp.SerialNumber = g["SerialNumber"] == DBNull.Value ? 0 : (int)(g["SerialNumber"]); gcp.Stake = g["Stake"].ToString(); gcp.H = g["H"] == DBNull.Value ? 0 : Convert.ToDouble(g["H"]); gcp.R = g["R"] == DBNull.Value ? 0 : Convert.ToDouble(g["R"]); gcp.i1 = g["i1"] == DBNull.Value ? 0 : Convert.ToDouble(g["i1"]); gcp.i2 = g["i2"] == DBNull.Value ? 0 : Convert.ToDouble(g["i2"]); list.Add(gcp); } return list; }