/// <summary> /// 添加系统菜单 /// </summary> /// <param name="menu"> /// 菜单对象 /// </param> /// <returns> /// 菜单编号 /// </returns> public int AddMenu(System_Menu menu) { return this.systemMenuDA.Insert(menu); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="menu"> /// 菜单对象 /// </param> /// <exception cref="ArgumentNullException"> /// 参数为空异常 /// </exception> /// <exception cref="Exception"> /// 数据库操作异常 /// </exception> public void Update(System_Menu menu) { if (menu == null) { throw new ArgumentNullException("menu"); } var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "ID", SqlDbType.Int, menu.ID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "PermissionID", SqlDbType.Int, menu.PermissionID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ParentID", SqlDbType.Int, menu.ParentID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Layer", SqlDbType.Int, menu.Layer, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, menu.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "URL", SqlDbType.VarChar, menu.URL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Sorting", SqlDbType.Int, menu.Sorting, ParameterDirection.Input) }; try { this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_System_Menu_Update", parameters, null); } catch (Exception exception) { throw new Exception("Exception - SystemMenuDA - Update", exception); } }
/// <summary> /// 修改系统菜单 /// </summary> /// <param name="menu"> /// 菜单对象 /// </param> public void ModifyMenu(System_Menu menu) { this.systemMenuDA.Update(menu); }
/// <summary> /// 添加菜单 /// </summary> /// <param name="menu"> /// 菜单对象 /// </param> /// <returns> /// 主键编号 /// </returns> /// <exception cref="ArgumentNullException"> /// 参数为空异常 /// </exception> /// <exception cref="Exception"> /// 数据库操作异常 /// </exception> public int Insert(System_Menu menu) { if (menu == null) { throw new ArgumentNullException("menu"); } int id; var parameters = new List<SqlParameter> { this.SqlServer.CreateSqlParameter( "PermissionID", SqlDbType.Int, menu.PermissionID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ParentID", SqlDbType.Int, menu.ParentID, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Layer", SqlDbType.Int, menu.Layer, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Name", SqlDbType.NVarChar, menu.Name, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "URL", SqlDbType.VarChar, menu.URL, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "Sorting", SqlDbType.Int, menu.Sorting, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "CreateTime", SqlDbType.DateTime, menu.CreateTime, ParameterDirection.Input), this.SqlServer.CreateSqlParameter( "ReferenceID", SqlDbType.Int, null, ParameterDirection.Output) }; try { this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_System_Menu_Insert", parameters, null); id = (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value; } catch (Exception exception) { throw new Exception("Exception - SystemMenuDA - Insert", exception); } return id; }