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