protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
rpj = new RoadProject("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123");
}
if (IsPostBack)
{
rpj = new RoadProject("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
rpj = new RoadProject("Data Source=Localhost;database=RoadCenter;User ID=admin;Password=admin123");
List<RoadProject> list = rpj.Load();
RoadName.Text = list[0].RoadProjectName.ToString().Trim();
Type.Text = list[0].RoadType.ToString();
Grade.Text = list[0].RoadGrade.ToString();
OwnerUnit.Text = list[0].OwnerUnit.ToString();
DesignUnit.Text = list[0].DesignUnit.ToString();
ProjectLocation.Text = list[0].ProjectLocation.ToString();
RoadLength.Text = list[0].RoadLength.ToString();
BeginStake.Text = list[0].BeginStake.ToString();
EndStaeke.Text = list[0].EndStaeke.ToString();
AmountOfExcavation.Text = list[0].AmountOfExcavation.ToString();
AmountOfFill.Text = list[0].AmountOfFill.ToString();
BridgeNumber.Text = list[0].BridgeNumber.ToString();
CulvertNumber.Text = list[0].CulvertNumber.ToString();
TunnelNumber.Text = list[0].TunnelNumber.ToString();
PlaneIntersectionNumber.Text = list[0].PlaneIntersectionNumber.ToString();
HighEmbankmentSlopeNumber.Text = list[0].HighEmbankmentSlopeNumber.ToString();
HighExcavationSlopeNumber.Text = list[0].HighExcavationSlopeNumber.ToString();
Description.Text = list[0].Description.ToString();
if (string.IsNullOrEmpty(list[0].RoadProjectName.ToString().Trim()))
{
Response.Redirect("ProjectSet.aspx", true);
}
string b;
b = rpj.AmountOfExcavation.ToString();
HttpCookie objCookie = new HttpCookie("ProjectName", list[0].RoadProjectName.ToString().Trim());
Response.Cookies.Add(objCookie);
}
}
/// <summary>
///加载道路项目
/// </summary>
public List<RoadProject> Load()
{
List<RoadProject> list = new List<RoadProject>();
string sql = @"select *from RDC_RoadProject";
DataSet ds = DbConnection.GetDataSet(sql);
foreach (DataRow r in ds.Tables[0].Rows)
{
RoadProject rp = new RoadProject();
rp.RoadProjectID = (int)r["RoadProjectID"];
rp.RoadType = r["RoadType"] == DBNull.Value ? 0 : Convert.ToInt32(r["RoadType"]);
rp.RoadGrade = r["RoadGrade"] == DBNull.Value ? 0 : Convert.ToInt32(r["RoadGrade"]);
rp.RoadProjectName = r["RoadProjectName"].ToString();
rp.OwnerUnit = r["OwnerUnit"].ToString();
rp.DesignUnit = r["DesignUnit"].ToString();
rp.ProjectLocation = r["ProjectLocation"].ToString();
rp.RoadLength = r["RoadLength"] == DBNull.Value ? 0 : Convert.ToDouble(r["RoadLength"]);
rp.BeginStake = r["BeginStake"].ToString();
rp.EndStaeke = r["EndStaeke"].ToString();
rp.AmountOfExcavation = r["AmountOfExcavation"] == DBNull.Value ? 0 : Convert.ToDouble(r["AmountOfExcavation"]);
rp.AmountOfFill = r["AmountOfFill"] == DBNull.Value ? 0 : Convert.ToDouble(r["AmountOfFill"]);
rp.BridgeNumber = r["BridgeNumber"] == DBNull.Value ? 0 : Convert.ToInt32(r["BridgeNumber"]);
rp.CulvertNumber = r["CulvertNumber"] == DBNull.Value ? 0 : Convert.ToInt32(r["CulvertNumber"]);
rp.TunnelNumber = r["TunnelNumber"] == DBNull.Value ? 0 : Convert.ToInt32(r["TunnelNumber"]);
rp.PlaneIntersectionNumber = r["PlaneIntersectionNumber"] == DBNull.Value ? 0 : Convert.ToInt32(r["PlaneIntersectionNumber"]);
rp.HighEmbankmentSlopeNumber = r["HighEmbankmentSlopeNumber"] == DBNull.Value ? 0 : Convert.ToInt32(r["HighEmbankmentSlopeNumber"]);
rp.HighExcavationSlopeNumber = r["HighExcavationSlopeNumber"] == DBNull.Value ? 0 : Convert.ToInt32(r["HighExcavationSlopeNumber"]);
rp.Description = r["Description"].ToString();
list.Add(rp);
}
return list;
}