| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644 |
- &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
- &ANALYZE-RESUME
- /* Connected Databases
- anadat PROGRESS
- */
- &Scoped-define WINDOW-NAME CURRENT-WINDOW
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin
- /*------------------------------------------------------------------------
- File: adm2\src\browser.w
- Description: SmartDataBrowser Object
- Input Parameters:
- <none>
- Output Parameters:
- <none>
- ------------------------------------------------------------------------*/
- /* This .W file was created with the Progress AppBuilder. */
- /*----------------------------------------------------------------------*/
- /* Create an unnamed pool to store all the widgets created
- by this procedure. This is a good default which assures
- that this procedure's triggers and internal procedures
- will execute in this procedure's storage, and that proper
- cleanup will occur on deletion of the procedure. */
- CREATE WIDGET-POOL.
- /* *************************** Definitions ************************** */
- /* Parameters Definitions --- */
- /* Local Variable Definitions --- */
- DEF VAR lInaktiv AS LOG NO-UNDO.
- DEF VAR hInaktiv AS HANDLE NO-UNDO.
- DEF VAR dMinMarge AS DEC DECIMALS 3 NO-UNDO.
- { incl/tmpbrowser.i }
- {src/adm2/widgetprto.i}
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
- /* ******************** Preprocessor Definitions ******************** */
- &Scoped-define PROCEDURE-TYPE SmartDataBrowser
- &Scoped-define DB-AWARE no
- &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
- /* Include file with RowObject temp-table definition */
- &Scoped-define DATA-FIELD-DEFS "d-artpreis.i"
- /* Name of designated FRAME-NAME and/or first browse and/or first query */
- &Scoped-define FRAME-NAME F-Main
- &Scoped-define BROWSE-NAME br_table
- /* Internal Tables (found by Frame, Query & Browse Queries) */
- &Scoped-define INTERNAL-TABLES rowObject
- /* Definitions for BROWSE br_table */
- &Scoped-define FIELDS-IN-QUERY-br_table rowObject.MinMarge rowObject.ArtID ~
- rowObject.Preis_Grp rowObject.Preisgruppe rowObject.Ab_Datum ~
- rowObject.VK_Netto rowObject.VK_Brutto rowObject.Marge rowObject.AktName
- &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
- &Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
- &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
- &Scoped-define TABLES-IN-QUERY-br_table rowObject
- &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
- /* Definitions for FRAME F-Main */
- /* Standard List Definitions */
- &Scoped-Define ENABLED-OBJECTS RECT-1 br_table
- /* Custom List Definitions */
- /* List-1,List-2,List-3,List-4,List-5,List-6 */
- /* _UIB-PREPROCESSOR-BLOCK-END */
- &ANALYZE-RESUME
- /* ************************ Function Prototypes ********************** */
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin
- FUNCTION setZeilenfarbe RETURNS LOGICAL
- ( ipFarbe AS INT ) FORWARD.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* *********************** Control Definitions ********************** */
- /* Menu Definitions */
- DEFINE MENU POPUP-MENU-br_table
- MENU-ITEM X_INAKTIVE_EINAUS LABEL "inaktive anzeigen ?".
- /* Definitions of the field level widgets */
- DEFINE RECTANGLE RECT-1
- EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
- SIZE 106 BY 10.
- /* Query definitions */
- &ANALYZE-SUSPEND
- DEFINE TEMP-TABLE RowObject NO-UNDO
- {{&DATA-FIELD-DEFS}}
- {src/adm2/robjflds.i}.
- DEFINE QUERY br_table FOR
- rowObject SCROLLING.
- &ANALYZE-RESUME
- /* Browse definitions */
- DEFINE BROWSE br_table
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
- QUERY br_table NO-LOCK DISPLAY
- rowObject.MinMarge FORMAT "->>,>>9.999":U WIDTH .2
- rowObject.ArtID FORMAT "->,>>>,>>9":U WIDTH .2
- rowObject.Preis_Grp COLUMN-LABEL "PGrp" FORMAT "99":U
- rowObject.Preisgruppe FORMAT "x(20)":U
- rowObject.Ab_Datum COLUMN-LABEL "Gültig ab" FORMAT "99.99.9999":U
- rowObject.VK_Netto COLUMN-LABEL "Netto (exkl)" FORMAT "zzz,zz9.9999":U
- rowObject.VK_Brutto COLUMN-LABEL "Brutto (inkl)" FORMAT "zzz,zz9.9999":U
- rowObject.Marge FORMAT "zz9.9999-":U
- rowObject.AktName COLUMN-LABEL "Aktion" FORMAT "x(20)":U
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 104 BY 9.52.
- /* ************************ Frame Definitions *********************** */
- DEFINE FRAME F-Main
- br_table AT ROW 1.48 COL 3 WIDGET-ID 200
- RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
- WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
- SIDE-LABELS NO-UNDERLINE THREE-D
- AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100.
- /* *********************** Procedure Settings ************************ */
- &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
- /* Settings for THIS-PROCEDURE
- Type: SmartDataBrowser
- Data Source: "d-artpreis.w"
- Allow: Basic,Browse
- Frames: 1
- Add Fields to: Neither
- Other Settings: PERSISTENT-ONLY COMPILE
- */
- /* This procedure should always be RUN PERSISTENT. Report the error, */
- /* then cleanup and return. */
- IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
- MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
- VIEW-AS ALERT-BOX ERROR BUTTONS OK.
- RETURN.
- END.
- &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
- /* ************************* Create Window ************************** */
- &ANALYZE-SUSPEND _CREATE-WINDOW
- /* DESIGN Window definition (used by the UIB)
- CREATE WINDOW bTableWin ASSIGN
- HEIGHT = 10.48
- WIDTH = 108.
- /* END WINDOW DEFINITION */
- */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
- /* ************************* Included-Libraries *********************** */
- {src/adm2/browser.i}
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* *********** Runtime Attributes and AppBuilder Settings *********** */
- &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
- /* SETTINGS FOR WINDOW bTableWin
- NOT-VISIBLE,,RUN-PERSISTENT */
- /* SETTINGS FOR FRAME F-Main
- NOT-VISIBLE FRAME-NAME Size-to-Fit */
- /* BROWSE-TAB br_table RECT-1 F-Main */
- ASSIGN
- FRAME F-Main:SCROLLABLE = FALSE
- FRAME F-Main:HIDDEN = TRUE.
- ASSIGN
- br_table:POPUP-MENU IN FRAME F-Main = MENU POPUP-MENU-br_table:HANDLE.
- ASSIGN
- rowObject.MinMarge:VISIBLE IN BROWSE br_table = FALSE
- rowObject.ArtID:VISIBLE IN BROWSE br_table = FALSE.
- /* _RUN-TIME-ATTRIBUTES-END */
- &ANALYZE-RESUME
- /* Setting information for Queries and Browse Widgets fields */
- &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
- /* Query rebuild information for BROWSE br_table
- _TblList = "rowObject"
- _Options = "NO-LOCK INDEXED-REPOSITION"
- _FldNameList[1] > _<SDO>.rowObject.MinMarge
- "rowObject.MinMarge" ? ? "decimal" ? ? ? ? ? ? no "?" no no ".2" no no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[2] > _<SDO>.rowObject.ArtID
- "rowObject.ArtID" ? ? "integer" ? ? ? ? ? ? no "?" no no ".2" no no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[3] > _<SDO>.rowObject.Preis_Grp
- "rowObject.Preis_Grp" "PGrp" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[4] > _<SDO>.rowObject.Preisgruppe
- "rowObject.Preisgruppe" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[5] > _<SDO>.rowObject.Ab_Datum
- "rowObject.Ab_Datum" "Gültig ab" ? "date" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[6] > _<SDO>.rowObject.VK_Netto
- "rowObject.VK_Netto" "Netto (exkl)" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[7] > _<SDO>.rowObject.VK_Brutto
- "rowObject.VK_Brutto" "Brutto (inkl)" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[8] > _<SDO>.rowObject.Marge
- "rowObject.Marge" ? ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _FldNameList[9] > _<SDO>.rowObject.AktName
- "rowObject.AktName" "Aktion" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
- _Query is NOT OPENED
- */ /* BROWSE br_table */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
- /* Query rebuild information for FRAME F-Main
- _Options = "NO-LOCK"
- _Query is NOT OPENED
- */ /* FRAME F-Main */
- &ANALYZE-RESUME
-
- /* ************************ Control Triggers ************************ */
- &Scoped-define BROWSE-NAME br_table
- &Scoped-define SELF-NAME br_table
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON CTRL-END OF br_table IN FRAME F-Main
- DO:
- APPLY "END":U TO BROWSE {&BROWSE-NAME}.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON CTRL-HOME OF br_table IN FRAME F-Main
- DO:
- APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON DEFAULT-ACTION OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brsdefault.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON END OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brsend.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON HOME OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brshome.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
- DO:
- APPLY 'ENTRY' TO {&BROWSE-NAME}.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
- DO:
- IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
- RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
- RETURN NO-APPLY.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON OFF-END OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brsoffnd.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON OFF-HOME OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brsoffhm.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON RETURN OF br_table IN FRAME F-Main
- DO:
- DO WITH FRAME {&FRAME-NAME}:
- IF {&BROWSE-NAME}:NUM-SELECTED-ROWS = 0 THEN RETURN NO-APPLY.
- {&BROWSE-NAME}:FETCH-SELECTED-ROW(1).
- RUN PREISMUTATION ( INTEGER(rowObject.ArtID:SCREEN-VALUE IN BROWSE {&BROWSE-NAME}) ).
- APPLY 'U1' TO hDaten.
- RETURN NO-APPLY.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON ROW-DISPLAY OF br_table IN FRAME F-Main
- DO:
- dMinMarge = rowObject.MinMarge.
- IF dMinMarge = ? THEN dMinMarge = 10.
- IF dMinMarge = 0 THEN dMinMarge = 10.
-
- Farbe = 15.
- IF rowObject.Ab_Datum > TODAY THEN Farbe = 8.
- IF rowObject.Aktion = TRUE THEN Farbe = 14.
- IF rowObject.Aktiv = FALSE THEN Farbe = 12.
- DYNAMIC-FUNCTION('setZeilenFarbe':U, Farbe ).
- DO WITH FRAME {&FRAME-NAME}:
- IF rowObject.Marge < dMinMarge THEN DO:
- rowObject.Marge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 12.
- END.
- END.
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON ROW-ENTRY OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brsentry.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON ROW-LEAVE OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brsleave.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brsscrol.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON START-SEARCH OF br_table IN FRAME F-Main
- DO:
- { incl/brwstartsearch.i }
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
- ON VALUE-CHANGED OF br_table IN FRAME F-Main
- DO:
- {src/adm2/brschnge.i}
- END.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &UNDEFINE SELF-NAME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
- /* *************************** Main Block *************************** */
- { incl/brwmainblock.i }
- { incl/brwinternproc.i }
- &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
- RUN initializeObject.
- &ENDIF
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* ********************** Internal Procedures *********************** */
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin
- PROCEDURE destroyObject :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR hBrowser AS HANDLE NO-UNDO.
- hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
- DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
- INPUT Sektion ) NO-ERROR.
- RUN SUPER.
- /* Code placed here will execute AFTER standard behavior. */
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
- PROCEDURE disable_UI :
- /*------------------------------------------------------------------------------
- Purpose: DISABLE the User Interface
- Parameters: <none>
- Notes: Here we clean-up the user-interface by deleting
- dynamic widgets we have created and/or hide
- frames. This procedure is usually called when
- we are ready to "clean-up" after running.
- ------------------------------------------------------------------------------*/
- /* Hide all frames. */
- HIDE FRAME F-Main.
- IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin
- PROCEDURE ENTRY_BROWSE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
- RETURN NO-APPLY.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE INAKTIVE_EINAUS bTableWin
- PROCEDURE INAKTIVE_EINAUS :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DO WITH FRAME {&FRAME-NAME}:
- lInaktiv = NOT lInaktiv.
- DYNAMIC-FUNCTION('setAnzeigePreisInaktiv':U, lInaktiv) NO-ERROR.
- DYNAMIC-FUNCTION('openQuery':U IN hDaten) NO-ERROR.
- RETURN NO-APPLY.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin
- PROCEDURE initializeObject :
- /*------------------------------------------------------------------------------
- Purpose: Super Override
- Parameters:
- Notes:
- ------------------------------------------------------------------------------*/
- DEF VAR cName AS CHAR NO-UNDO.
- { incl/brwinitialize.i }
- hMenu = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
- hMenu = hMenu:POPUP-MENU NO-ERROR.
- hMenu = hMenu:FIRST-CHILD NO-ERROR.
- DO WHILE VALID-HANDLE (hMenu):
- cName = hMenu:NAME NO-ERROR.
- IF cName <> ? AND
- INDEX(cName, 'inakt') > 0 THEN DO:
- hInaktiv = hMenu.
- LEAVE.
- END.
- hMenu = hMenu:NEXT-SIBLING.
- END.
- lInaktiv = DYNAMIC-FUNCTION('getAnzeigePreisInaktiv':U) NO-ERROR.
- hInaktiv:CHECKED = lInaktiv NO-ERROR.
-
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREISMUTATION bTableWin
- PROCEDURE PREISMUTATION :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEF INPUT PARAMETER ipRecid AS RECID NO-UNDO.
- DEF VAR dNetto AS DEC DECIMALS 4 NO-UNDO.
- DEF VAR dBrutto AS DEC DECIMALS 4 NO-UNDO.
- DEF VAR dMarge AS DEC DECIMALS 4 NO-UNDO.
- DEF VAR AbDatum AS DATE NO-UNDO.
- FIND ArtPreis WHERE RECID(ArtPreis) = ipRecid NO-LOCK NO-ERROR.
- IF NOT AVAILABLE ArtPreis THEN RETURN 'NOT AVAILABLE'.
- IF ArtPreis.Aktion = TRUE THEN RETURN 'AKTION'.
- dNetto = ArtPreis.VK_Netto.
- dBrutto = ArtPreis.VK_Brutto.
- dMarge = ArtPreis.Marge.
- AbDatum = ArtPreis.Ab_Datum.
- RUN 'g-artpreismut.w':U ( INPUT-OUTPUT dNetto ,
- INPUT-OUTPUT dBrutto ,
- INPUT-OUTPUT dMarge ,
- INPUT-OUTPUT AbDatum ).
- DO WHILE TRUE:
- IF dNetto = ? THEN RETURN 'KEINE MUTATION'.
- IF ArtPreis.VK_Netto <> dNetto THEN LEAVE.
- IF ArtPreis.VK_Brutto <> dBrutto THEN LEAVE.
- IF ArtPreis.Marge <> dMarge THEN LEAVE.
- RETURN 'KEINE MUTATION'.
- END.
- REPEAT TRANSACTION:
- FIND ArtPreis WHERE RECID(ArtPreis) = ipRecid.
- ASSIGN ArtPreis.VK_Netto = dNetto
- ArtPreis.VK_Brutto = dBrutto
- ArtPreis.Marge = dMarge.
- RELEASE ArtPreis.
- LEAVE.
- END.
- RUN refreshRow IN hDaten.
- RETURN ''.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- /* ************************ Function Implementations ***************** */
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin
- FUNCTION setZeilenfarbe RETURNS LOGICAL
- ( ipFarbe AS INT ) :
- /*------------------------------------------------------------------------------
- Purpose:
- Notes:
- ------------------------------------------------------------------------------*/
- { incl/brwsetzeilenfarbe.i }
- END FUNCTION.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
|