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