public SM.YuQing.Model.Menu GetModelAndChildren(int ID) { SM.YuQing.Model.Menu menu = dal.GetModel(ID); //加载子菜单 List <SM.YuQing.Model.Menu> list = new List <SM.YuQing.Model.Menu>(); DataTable dt = dal.GetList(0, "ParentID='" + menu.ID + "'", "Sort").Tables[0]; foreach (DataRow row in dt.Rows) { list.Add(GetModelAndChildren(Convert.ToInt32(row["ID"]))); } menu.children = list; //加载操作 string Operation = ""; string sql = "select OperationID,Name from MenuOperation mo " + "inner join Operation o on mo.OperationID = o.ID " + "where mo.MenuID='" + menu.ID + "'"; DataTable dtOpe = DbHelperSQL.Query(sql).Tables[0]; foreach (DataRow row in dtOpe.Rows) { Operation += row["OperationID"] + "^" + row["Name"] + ","; } if (Operation.Length > 0) { Operation = Operation.Substring(0, Operation.Length - 1); } menu.Operation = Operation; return(menu); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SM.YuQing.Model.Menu model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SM.YuQing.Model.Menu model) { return(dal.Add(model)); }