/// <summary> /// 加载控制点 /// </summary> /// <param name="ControlPointGroupID"></param> /// <returns></returns> public List<ControlPoint> Load(int ControlPointGroupID) { List<ControlPoint> list = new List<ControlPoint>(); if (DbConnection == null) return null; DataSet ds = DbConnection.GetDataSet(@"select *from RDC_ControlPoint where ControlPointGroupID='" + ControlPointGroupID + "'"); foreach (DataRow r in ds.Tables[0].Rows) { ControlPoint cp = new ControlPoint(); cp.ControlPointID = (int)(r["ControlPointID"]); cp.ControlPointGroupID = r["ControlPointGroupID"] == DBNull.Value ? 0 : Convert.ToInt32(r["ControlPointGroupID"]); cp.Name = r["Name"].ToString(); cp.X = r["X"] == DBNull.Value ? 0 : Convert.ToDouble(r["X"]); cp.Y = r["Y"] == DBNull.Value ? 0 : Convert.ToDouble(r["Y"]); cp.H = r["H"] == DBNull.Value ? 0 : Convert.ToDouble(r["H"]); cp.Remarks = r["Remarks"].ToString(); list.Add(cp); } return list; }
/// <summary> /// 控制点Csv文件查询结果转换成泛型集合 /// </summary> /// <param name="filePath">文件路径</param> /// <returns>以实体类为元素的泛型集合</returns> public List<ControlPoint> ImportControlPointList(string filePath) { List<ControlPoint> cp = new List<ControlPoint>(); StreamReader fileReader = new StreamReader(filePath, Encoding.Default); try { //列之间的分隔符 char cv = ','; while (fileReader.EndOfStream == false) { ControlPoint t = new ControlPoint(); string line = fileReader.ReadLine(); string[] y = line.Split(cv); t.Name = y[0].Trim().ToString(); t.X = Convert.ToDouble(y[1].Trim().ToString()); t.Y = Convert.ToDouble(y[2].Trim().ToString()); t.H = Convert.ToDouble(y[3].Trim().ToString()); t.Remarks = y[4].Trim().ToString(); cp.Add(t); } } catch (Exception ex) { throw ex; } finally { fileReader.Close(); fileReader.Dispose(); } return cp; }