public int classId; //ID protected void Page_Load(object sender, EventArgs e) { chkLoginLevel("editMenu"); //取得栏目传参 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.Menu GetModelByName(string Name) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,MenuID,Title,ParentId,ClassList,ClassLayer,ClassOrder,IsShow,IsLock,IsMenu from [Menu] "); strSql.Append(" where Title=@Title "); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar,50)}; parameters[0].Value = Name; Spread.Model.Menu model = new Spread.Model.Menu(); 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(); 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; } }
protected void ddlMenu_SelectedIndexChanged(object sender, EventArgs e) { string menu = ddlMenu.SelectedValue; Spread.BLL.Menu cbll = new Spread.BLL.Menu(); Spread.Model.Menu modelMenu = new Spread.Model.Menu(); modelMenu = cbll.GetModelByName(menu); if (modelMenu != null) { PChanelBind(modelMenu.Id.ToString()); PgameBind(model.gameName, menu); } }