public int classId; //ID protected void Page_Load(object sender, EventArgs e) { chkLoginLevel("editMenuDirectory"); //取得栏目传参 if (int.TryParse(Request.Params["classId"], out classId)) { model = bll.GetModel(classId); if (!Page.IsPostBack) { ShowInfo(); } } else { JscriptMsg(350, 230, "错误提示", "<b>出现错误啦!</b>您要修改类别的编号不明确或参数不正确。", "back", "Error"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Spread.Model.MenuDirectory GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,MenuID,Title,ParentId,ClassList,ClassLayer,ClassOrder,IsShow,IsLock,IsMenu,ImgUrl,LanguageType from [MenuDirectory] "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4)}; parameters[0].Value = Id; Spread.Model.MenuDirectory model = new Spread.Model.MenuDirectory(); 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()); } if (ds.Tables[0].Rows[0]["MenuID"].ToString() != "") { model.MenuID = long.Parse(ds.Tables[0].Rows[0]["MenuID"].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(); model.ImgUrl = ds.Tables[0].Rows[0]["ImgUrl"].ToString(); model.LanguageType = ds.Tables[0].Rows[0]["LanguageType"].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()); } if (ds.Tables[0].Rows[0]["IsShow"].ToString() != "") { model.IsShow = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsShow"].ToString()); } if (ds.Tables[0].Rows[0]["IsLock"].ToString() != "") { model.IsLock = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsLock"].ToString()); } if (ds.Tables[0].Rows[0]["IsMenu"].ToString() != "") { model.IsMenu = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsMenu"].ToString()); } return model; } else { return null; } }