protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
csc = new CrossSlopeChange("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123");
//调用Databind方法
Databind();
//读取传参
Route.Text = Request.Cookies["RouteID"].Value;
}
if (IsPostBack)
{
csc = new CrossSlopeChange("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123");
}
if (this.CrossSlopeChange.SelectedIndex > -1)
{
// 调用GridView的UpdateRow方法
this.CrossSlopeChange.UpdateRow(this.CrossSlopeChange.SelectedIndex, false);
}
}
/// <summary>
/// 横坡变化Csv文件查询结果转换成泛型集合
/// </summary>
/// <param name="filePath">文件路径</param>
/// <returns>以实体类为元素的泛型集合</returns>
public List<CrossSlopeChange> ImportCrossSlopeChangeList(string filePath)
{
List<CrossSlopeChange> csc = new List<CrossSlopeChange>();
StreamReader fileReader = new StreamReader(filePath, Encoding.Default);
try
{
//列之间的分隔符
char cv = ',';
while (fileReader.EndOfStream == false)
{
CrossSlopeChange t = new CrossSlopeChange();
string line = fileReader.ReadLine();
string[] y = line.Split(cv);
t.Stake = y[0].Trim().ToString();
t.LeftSoilShoulder = Convert.ToDouble(y[1].Trim().ToString());
t.LeftHardShoulder = Convert.ToDouble(y[2].Trim().ToString());
t.LeftCarriageway = Convert.ToDouble(y[3].Trim().ToString());
t.LeftMiddle = Convert.ToDouble(y[4].Trim().ToString());
t.RightMiddle = Convert.ToDouble(y[5].Trim().ToString());
t.RightCarriageway = Convert.ToDouble(y[6].Trim().ToString());
t.RightHardShoulder = Convert.ToDouble(y[7].Trim().ToString());
t.RightSoilShoulder = Convert.ToDouble(y[8].Trim().ToString());
t.Remarks = y[9].Trim().ToString();
csc.Add(t);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
fileReader.Close();
fileReader.Dispose();
}
return csc;
}
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<CrossSlopeChange> csc = new List<CrossSlopeChange>();
CsvFileImport cfi = new CsvFileImport();
csc = cfi.ImportCrossSlopeChangeList(filename);
}
/// <summary>
/// 加载横坡变化
/// </summary>
/// <param name="RouteID"></param>
/// <returns></returns>
public List<CrossSlopeChange> Load(int RouteID)
{
List<CrossSlopeChange> list = new List<CrossSlopeChange>();
if (DbConnection == null) return null;
string sql = @"select *from RDC_CrossSlopeChange where RouteID='" + RouteID + "'";
DataSet ds = DbConnection.GetDataSet(sql);
foreach (DataRow r in ds.Tables[0].Rows)
{
CrossSlopeChange csc = new CrossSlopeChange();
csc.CrossSlopeChangeID = (int)(r["CrossSlopeChangeID"]);
csc.RouteID = r["RouteID"] == DBNull.Value ? 0 : Convert.ToInt32(r["RouteID"]);
csc.SerialNumber = r["SerialNumber"] == DBNull.Value ? 0 : Convert.ToInt32(r["SerialNumber"]);
csc.Stake = r["Stake"].ToString();
csc.LeftSoilShoulder = r["LeftSoilShoulder"] == DBNull.Value ? 0 : Convert.ToDouble(r["LeftSoilShoulder"]);
csc.LeftHardShoulder = r["LeftHardShoulder"] == DBNull.Value ? 0 : Convert.ToDouble(r["LeftHardShoulder"]);
csc.LeftCarriageway = r["LeftCarriageway"] == DBNull.Value ? 0 : Convert.ToDouble(r["LeftCarriageway"]);
csc.LeftMiddle = r["LeftMiddle"] == DBNull.Value ? 0 : Convert.ToDouble(r["LeftMiddle"]);
csc.RightMiddle = r["RightMiddle"] == DBNull.Value ? 0 : Convert.ToDouble(r["RightMiddle"]);
csc.RightCarriageway = r["RightCarriageway"] == DBNull.Value ? 0 : Convert.ToDouble(r["RightCarriageway"]);
csc.RightHardShoulder = r["RightHardShoulder"] == DBNull.Value ? 0 : Convert.ToDouble(r["RightHardShoulder"]);
csc.RightSoilShoulder = r["RightSoilShoulder"] == DBNull.Value ? 0 : Convert.ToDouble(r["RightSoilShoulder"]);
csc.Remarks = r["Remarks"].ToString();
list.Add(csc);
}
return list;
}