protected void Page_Load(object sender, EventArgs e) { if (!int.TryParse(Request.Params["id"] as string, out this.Id)) { Response.Redirect("~/error.html"); return; } if (!IsPostBack) { modArticle = bllArticle.GetModel(Id); if (modArticle.ClassId>0) { modArticletype=bllArticletype.GetModel(modArticle.ClassId); this.lbmenu.Text = modArticletype.Title; } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Spread.Model.Article_type GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,Title,ParentId,ClassList,ClassLayer,ClassOrder,PageUrl,KindId,Keyword from Article_type "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = Id; Spread.Model.Article_type model = new Spread.Model.Article_type(); DataSet ds = DbHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); if (ds.Tables[0].Rows[0]["ParentId"].ToString() != "") { model.ParentId = int.Parse(ds.Tables[0].Rows[0]["ParentId"].ToString()); } model.ClassList = ds.Tables[0].Rows[0]["ClassList"].ToString(); if (ds.Tables[0].Rows[0]["ClassLayer"].ToString() != "") { model.ClassLayer = int.Parse(ds.Tables[0].Rows[0]["ClassLayer"].ToString()); } if (ds.Tables[0].Rows[0]["ClassOrder"].ToString() != "") { model.ClassOrder = int.Parse(ds.Tables[0].Rows[0]["ClassOrder"].ToString()); } model.PageUrl = ds.Tables[0].Rows[0]["PageUrl"].ToString(); if (ds.Tables[0].Rows[0]["KindId"].ToString() != "") { model.KindId = int.Parse(ds.Tables[0].Rows[0]["KindId"].ToString()); } model.Keyword = ds.Tables[0].Rows[0]["Keyword"].ToString(); return model; } else { return null; } }