b-besze.w 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. /* Connected Databases
  4. anadat PROGRESS
  5. */
  6. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  7. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin
  8. /*------------------------------------------------------------------------
  9. File: adm2\src\browser.w
  10. Description: SmartDataBrowser Object
  11. Input Parameters:
  12. <none>
  13. Output Parameters:
  14. <none>
  15. ------------------------------------------------------------------------*/
  16. /* This .W file was created with the Progress AppBuilder. */
  17. /*----------------------------------------------------------------------*/
  18. /* Create an unnamed pool to store all the widgets created
  19. by this procedure. This is a good default which assures
  20. that this procedure's triggers and internal procedures
  21. will execute in this procedure's storage, and that proper
  22. cleanup will occur on deletion of the procedure. */
  23. CREATE WIDGET-POOL.
  24. /* *************************** Definitions ************************** */
  25. /* Parameters Definitions --- */
  26. /* Local Variable Definitions --- */
  27. DEFINE VARIABLE iStatus AS INTEGER NO-UNDO.
  28. { incl/tmpbrowser.i }
  29. {src/adm2/widgetprto.i}
  30. /* _UIB-CODE-BLOCK-END */
  31. &ANALYZE-RESUME
  32. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  33. /* ******************** Preprocessor Definitions ******************** */
  34. &Scoped-define PROCEDURE-TYPE SmartDataBrowser
  35. &Scoped-define DB-AWARE no
  36. &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
  37. /* Include file with RowObject temp-table definition */
  38. &Scoped-define DATA-FIELD-DEFS "d-besze.i"
  39. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  40. &Scoped-define FRAME-NAME F-Main
  41. &Scoped-define BROWSE-NAME br_table
  42. /* Internal Tables (found by Frame, Query & Browse Queries) */
  43. &Scoped-define INTERNAL-TABLES rowObject
  44. /* Definitions for BROWSE br_table */
  45. &Scoped-define FIELDS-IN-QUERY-br_table rowObject.Artnr rowObject.Inhalt ~
  46. rowObject.Jahr rowObject.Bezeichnung rowObject.Lager rowObject.MBest ~
  47. rowObject.MGeli rowObject.Eingang rowObject.S_Artnr rowObject.SeineBez ~
  48. rowObject.S_Preis rowObject.L_EP rowObject.Bestand rowObject.Pos
  49. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  50. &Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
  51. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  52. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  53. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  54. /* Definitions for FRAME F-Main */
  55. /* Standard List Definitions */
  56. &Scoped-Define ENABLED-OBJECTS RECT-1 br_table
  57. /* Custom List Definitions */
  58. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  59. /* _UIB-PREPROCESSOR-BLOCK-END */
  60. &ANALYZE-RESUME
  61. /* ************************ Function Prototypes ********************** */
  62. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin
  63. FUNCTION setZeilenfarbe RETURNS LOGICAL
  64. ( ipFarbe AS INT ) FORWARD.
  65. /* _UIB-CODE-BLOCK-END */
  66. &ANALYZE-RESUME
  67. /* *********************** Control Definitions ********************** */
  68. /* Menu Definitions */
  69. DEFINE MENU POPUP-MENU-br_table
  70. MENU-ITEM X_EingangGanzeBestellung LABEL "Ganze Bestellung als Eingang".
  71. /* Definitions of the field level widgets */
  72. DEFINE RECTANGLE RECT-1
  73. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  74. SIZE 204 BY 7.14.
  75. /* Query definitions */
  76. &ANALYZE-SUSPEND
  77. DEFINE TEMP-TABLE RowObject NO-UNDO
  78. {{&DATA-FIELD-DEFS}}
  79. {src/adm2/robjflds.i}.
  80. DEFINE QUERY br_table FOR
  81. rowObject SCROLLING.
  82. &ANALYZE-RESUME
  83. /* Browse definitions */
  84. DEFINE BROWSE br_table
  85. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  86. QUERY br_table NO-LOCK DISPLAY
  87. rowObject.Artnr FORMAT "999999":U
  88. rowObject.Inhalt FORMAT "9999":U
  89. rowObject.Jahr FORMAT "9999":U
  90. rowObject.Bezeichnung FORMAT "x(50)":U WIDTH 40
  91. rowObject.Lager FORMAT "99":U
  92. rowObject.MBest COLUMN-LABEL "Bestellt" FORMAT "zzzz9.99-":U
  93. rowObject.MGeli COLUMN-LABEL "Geliefert" FORMAT "zzzz9.99-":U
  94. rowObject.Eingang FORMAT "zzzz9.99-":U
  95. rowObject.S_Artnr COLUMN-LABEL "Seine Artnr" FORMAT "x(12)":U
  96. rowObject.SeineBez FORMAT "x(50)":U WIDTH 45
  97. rowObject.S_Preis COLUMN-LABEL "Sein Preis" FORMAT "zzz,zz9.9999":U
  98. rowObject.L_EP COLUMN-LABEL "Letzt. EP" FORMAT "zzz,zz9.9999":U
  99. rowObject.Bestand FORMAT "zzz,zzz,zz9.99-":U
  100. rowObject.Pos FORMAT "9999":U
  101. /* _UIB-CODE-BLOCK-END */
  102. &ANALYZE-RESUME
  103. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 202 BY 6.67.
  104. /* ************************ Frame Definitions *********************** */
  105. DEFINE FRAME F-Main
  106. br_table AT ROW 1.48 COL 3 WIDGET-ID 200
  107. RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
  108. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  109. SIDE-LABELS NO-UNDERLINE THREE-D
  110. AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100.
  111. /* *********************** Procedure Settings ************************ */
  112. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  113. /* Settings for THIS-PROCEDURE
  114. Type: SmartDataBrowser
  115. Data Source: "d-besze.w"
  116. Allow: Basic,Browse
  117. Frames: 1
  118. Add Fields to: Neither
  119. Other Settings: PERSISTENT-ONLY COMPILE
  120. */
  121. /* This procedure should always be RUN PERSISTENT. Report the error, */
  122. /* then cleanup and return. */
  123. IF NOT THIS-PROCEDURE:PERSISTENT THEN
  124. DO:
  125. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  126. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  127. RETURN.
  128. END.
  129. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  130. /* ************************* Create Window ************************** */
  131. &ANALYZE-SUSPEND _CREATE-WINDOW
  132. /* DESIGN Window definition (used by the UIB)
  133. CREATE WINDOW bTableWin ASSIGN
  134. HEIGHT = 7.62
  135. WIDTH = 206.
  136. /* END WINDOW DEFINITION */
  137. */
  138. &ANALYZE-RESUME
  139. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  140. /* ************************* Included-Libraries *********************** */
  141. {src/adm2/browser.i}
  142. /* _UIB-CODE-BLOCK-END */
  143. &ANALYZE-RESUME
  144. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  145. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  146. /* SETTINGS FOR WINDOW bTableWin
  147. NOT-VISIBLE,,RUN-PERSISTENT */
  148. /* SETTINGS FOR FRAME F-Main
  149. NOT-VISIBLE FRAME-NAME Size-to-Fit */
  150. /* BROWSE-TAB br_table RECT-1 F-Main */
  151. ASSIGN
  152. FRAME F-Main:SCROLLABLE = FALSE
  153. FRAME F-Main:HIDDEN = TRUE.
  154. ASSIGN
  155. br_table:POPUP-MENU IN FRAME F-Main = MENU POPUP-MENU-br_table:HANDLE.
  156. /* _RUN-TIME-ATTRIBUTES-END */
  157. &ANALYZE-RESUME
  158. /* Setting information for Queries and Browse Widgets fields */
  159. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  160. /* Query rebuild information for BROWSE br_table
  161. _TblList = "rowObject"
  162. _Options = "NO-LOCK INDEXED-REPOSITION"
  163. _FldNameList[1] > _<SDO>.rowObject.Artnr
  164. "rowObject.Artnr" ? ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  165. _FldNameList[2] = _<SDO>.rowObject.Inhalt
  166. _FldNameList[3] = _<SDO>.rowObject.Jahr
  167. _FldNameList[4] > _<SDO>.rowObject.Bezeichnung
  168. "rowObject.Bezeichnung" ? ? "character" ? ? ? ? ? ? no "?" no no "40" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  169. _FldNameList[5] = _<SDO>.rowObject.Lager
  170. _FldNameList[6] > _<SDO>.rowObject.MBest
  171. "rowObject.MBest" "Bestellt" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  172. _FldNameList[7] > _<SDO>.rowObject.MGeli
  173. "rowObject.MGeli" "Geliefert" ? "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  174. _FldNameList[8] = _<SDO>.rowObject.Eingang
  175. _FldNameList[9] > _<SDO>.rowObject.S_Artnr
  176. "rowObject.S_Artnr" "Seine Artnr" ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  177. _FldNameList[10] > _<SDO>.rowObject.SeineBez
  178. "rowObject.SeineBez" ? ? "character" ? ? ? ? ? ? no "?" no no "45" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  179. _FldNameList[11] > _<SDO>.rowObject.S_Preis
  180. "rowObject.S_Preis" "Sein Preis" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  181. _FldNameList[12] > _<SDO>.rowObject.L_EP
  182. "rowObject.L_EP" "Letzt. EP" ? "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  183. _FldNameList[13] = _<SDO>.rowObject.Bestand
  184. _FldNameList[14] = _<SDO>.rowObject.Pos
  185. _Query is NOT OPENED
  186. */ /* BROWSE br_table */
  187. &ANALYZE-RESUME
  188. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  189. /* Query rebuild information for FRAME F-Main
  190. _Options = "NO-LOCK"
  191. _Query is NOT OPENED
  192. */ /* FRAME F-Main */
  193. &ANALYZE-RESUME
  194. /* ************************ Control Triggers ************************ */
  195. &Scoped-define BROWSE-NAME br_table
  196. &Scoped-define SELF-NAME br_table
  197. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  198. ON CTRL-END OF br_table IN FRAME F-Main
  199. DO:
  200. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  201. END.
  202. /* _UIB-CODE-BLOCK-END */
  203. &ANALYZE-RESUME
  204. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  205. ON CTRL-HOME OF br_table IN FRAME F-Main
  206. DO:
  207. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  208. END.
  209. /* _UIB-CODE-BLOCK-END */
  210. &ANALYZE-RESUME
  211. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  212. ON DEFAULT-ACTION OF br_table IN FRAME F-Main
  213. DO:
  214. {src/adm2/brsdefault.i}
  215. END.
  216. /* _UIB-CODE-BLOCK-END */
  217. &ANALYZE-RESUME
  218. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  219. ON END OF br_table IN FRAME F-Main
  220. DO:
  221. {src/adm2/brsend.i}
  222. END.
  223. /* _UIB-CODE-BLOCK-END */
  224. &ANALYZE-RESUME
  225. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  226. ON F5 OF br_table IN FRAME F-Main
  227. DO:
  228. DEFINE VARIABLE iRecid AS RECID NO-UNDO.
  229. DEFINE VARIABLE cRowid AS CHARACTER NO-UNDO.
  230. iRecid = DYNAMIC-FUNCTION ('getCurrentRecid':U IN hDaten) NO-ERROR.
  231. IF iRecid <> ? AND
  232. iRecid <> 0 THEN
  233. DO:
  234. FIND Besze NO-LOCK WHERE RECID(Besze) = iRecid.
  235. cRowid = STRING(ROWID(Besze)).
  236. RELEASE Besze.
  237. END.
  238. DYNAMIC-FUNCTION ('openQuery':U IN hDaten) NO-ERROR.
  239. IF cRowid <> '' THEN DYNAMIC-FUNCTION ('fetchRowIdent':U IN hDaten, cRowid, ? ).
  240. END.
  241. /* _UIB-CODE-BLOCK-END */
  242. &ANALYZE-RESUME
  243. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  244. ON HOME OF br_table IN FRAME F-Main
  245. DO:
  246. {src/adm2/brshome.i}
  247. END.
  248. /* _UIB-CODE-BLOCK-END */
  249. &ANALYZE-RESUME
  250. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  251. ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
  252. DO:
  253. APPLY 'ENTRY' TO {&BROWSE-NAME}.
  254. END.
  255. /* _UIB-CODE-BLOCK-END */
  256. &ANALYZE-RESUME
  257. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  258. ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
  259. DO:
  260. IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
  261. RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
  262. RETURN NO-APPLY.
  263. END.
  264. /* _UIB-CODE-BLOCK-END */
  265. &ANALYZE-RESUME
  266. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  267. ON OFF-END OF br_table IN FRAME F-Main
  268. DO:
  269. {src/adm2/brsoffnd.i}
  270. END.
  271. /* _UIB-CODE-BLOCK-END */
  272. &ANALYZE-RESUME
  273. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  274. ON OFF-HOME OF br_table IN FRAME F-Main
  275. DO:
  276. {src/adm2/brsoffhm.i}
  277. END.
  278. /* _UIB-CODE-BLOCK-END */
  279. &ANALYZE-RESUME
  280. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  281. ON RETURN OF br_table IN FRAME F-Main
  282. DO:
  283. RUN TOOLBAR IN hFenster ( 'UPDATE' ) NO-ERROR.
  284. RETURN NO-APPLY.
  285. END.
  286. /* _UIB-CODE-BLOCK-END */
  287. &ANALYZE-RESUME
  288. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  289. ON ROW-DISPLAY OF br_table IN FRAME F-Main
  290. DO:
  291. IF rowObject.LagerOrt = '' THEN DYNAMIC-FUNCTION ('setZeilenfarbe':U, 14).
  292. ELSE DYNAMIC-FUNCTION ('setZeilenfarbe':U, 15).
  293. END.
  294. /* _UIB-CODE-BLOCK-END */
  295. &ANALYZE-RESUME
  296. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  297. ON ROW-ENTRY OF br_table IN FRAME F-Main
  298. DO:
  299. {src/adm2/brsentry.i}
  300. END.
  301. /* _UIB-CODE-BLOCK-END */
  302. &ANALYZE-RESUME
  303. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  304. ON ROW-LEAVE OF br_table IN FRAME F-Main
  305. DO:
  306. {src/adm2/brsleave.i}
  307. END.
  308. /* _UIB-CODE-BLOCK-END */
  309. &ANALYZE-RESUME
  310. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  311. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  312. DO:
  313. {src/adm2/brsscrol.i}
  314. END.
  315. /* _UIB-CODE-BLOCK-END */
  316. &ANALYZE-RESUME
  317. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  318. ON START-SEARCH OF br_table IN FRAME F-Main
  319. DO:
  320. { incl/brwstartsearch.i }
  321. END.
  322. /* _UIB-CODE-BLOCK-END */
  323. &ANALYZE-RESUME
  324. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  325. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  326. DO:
  327. DEFINE VARIABLE rBesze AS RECID NO-UNDO.
  328. DEFINE BUFFER bBesze FOR Besze.
  329. rBesze = DYNAMIC-FUNCTION ('getCurrentRecid':U IN hDaten) NO-ERROR.
  330. FIND bBesze NO-LOCK WHERE RECID(bBesze) = rBesze.
  331. PUBLISH 'BESTELLVORSCHLAG' ( bBesze.Artnr, bBesze.Inhalt, bBesze.Jahr ).
  332. RELEASE bBesze.
  333. {src/adm2/brschnge.i}
  334. END.
  335. /* _UIB-CODE-BLOCK-END */
  336. &ANALYZE-RESUME
  337. &UNDEFINE SELF-NAME
  338. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  339. /* *************************** Main Block *************************** */
  340. { incl/brwmainblock.i }
  341. { incl/brwinternproc.i }
  342. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  343. RUN initializeObject.
  344. &ENDIF
  345. /* _UIB-CODE-BLOCK-END */
  346. &ANALYZE-RESUME
  347. /* ********************** Internal Procedures *********************** */
  348. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin
  349. PROCEDURE destroyObject :
  350. /*------------------------------------------------------------------------------*/
  351. /* Purpose: Super Override */
  352. /* Parameters: */
  353. /* Notes: */
  354. /*------------------------------------------------------------------------------*/
  355. DEF VAR hBrowser AS HANDLE NO-UNDO.
  356. hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
  357. DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
  358. INPUT Sektion ) NO-ERROR.
  359. RUN SUPER.
  360. /* Code placed here will execute AFTER standard behavior. */
  361. END PROCEDURE.
  362. /* _UIB-CODE-BLOCK-END */
  363. &ANALYZE-RESUME
  364. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  365. PROCEDURE disable_UI :
  366. /*------------------------------------------------------------------------------
  367. Purpose: DISABLE the User Interface
  368. Parameters: <none>
  369. Notes: Here we clean-up the user-interface by deleting
  370. dynamic widgets we have created and/or hide
  371. frames. This procedure is usually called when
  372. we are ready to "clean-up" after running.
  373. ------------------------------------------------------------------------------*/
  374. /* Hide all frames. */
  375. HIDE FRAME F-Main.
  376. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  377. END PROCEDURE.
  378. /* _UIB-CODE-BLOCK-END */
  379. &ANALYZE-RESUME
  380. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE EINGANGGANZEBESTELLUNG bTableWin
  381. PROCEDURE EINGANGGANZEBESTELLUNG :
  382. /*------------------------------------------------------------------------------*/
  383. /* Purpose: Super Override */
  384. /* Parameters: */
  385. /* Notes: */
  386. /*------------------------------------------------------------------------------*/
  387. DEFINE VARIABLE iSubPos AS INTEGER NO-UNDO.
  388. IF iStatus <> 2 THEN
  389. DO:
  390. DYNAMIC-FUNCTION ('fehlerMeldung':U, 1108, '' ) NO-ERROR.
  391. RETURN NO-APPLY.
  392. END.
  393. DEFINE VARIABLE iBesnr AS INTEGER NO-UNDO.
  394. DEFINE VARIABLE iRecid AS RECID NO-UNDO.
  395. DEFINE VARIABLE dDatum AS DATE FORMAT '99.99.9999'.
  396. DEFINE BUFFER bBesko FOR Besko.
  397. DEFINE BUFFER bBesze FOR Besze.
  398. iRecid = DYNAMIC-FUNCTION ('getCurrentRecid':U IN hDaten) NO-ERROR.
  399. IF iRecid = ? OR
  400. iRecid = 0 THEN RETURN.
  401. FIND bBesze NO-LOCK WHERE RECID (bBesze) = iRecid.
  402. iBesnr = bBesze.Besnr.
  403. RELEASE bBesze.
  404. RUN g-einlesen-Datum.w ('Eingabe Eingangsdatum', 'Eingangsdatum', INPUT-OUTPUT dDatum) NO-ERROR.
  405. IF dDatum = ? THEN RETURN NO-APPLY.
  406. REPEAT TRANSACTION ON ERROR UNDO, LEAVE:
  407. FOR EACH bBesze
  408. WHERE bBesze.Firma = Firma
  409. AND bBesze.Besnr = iBesnr:
  410. IF bBesze.Artnr = 0 THEN
  411. DO:
  412. DELETE bBesze.
  413. NEXT.
  414. END.
  415. IF bBesze.MRuek = 0 THEN NEXT.
  416. FIND LAST BesEing
  417. WHERE BesEing.Firma = bBesze.Firma
  418. AND BesEing.Besnr = bBesze.Besnr
  419. AND BesEing.Pos = bBesze.Pos
  420. AND BesEing.Eingang = 0 NO-ERROR.
  421. IF AVAILABLE BesEing THEN iSubPos = BesEing.SubPos + 10.
  422. ELSE iSubPos = 10.
  423. CREATE BesEing.
  424. BUFFER-COPY bBesze
  425. USING Firma Besnr Pos Artnr Inhalt Jahr lVerfall lLotnr Lager
  426. KGeb_Cd KGebKto VGeb_Cd VGebKto GGeb_Cd GGebKto
  427. TO BesEing
  428. ASSIGN
  429. BesEing.SubPos = iSubPos
  430. BesEing.Eingang = bBesze.MRuek
  431. BesEing.GGeb_EG = bBesze.GGeb_Me - bBesze.GGeb_EG
  432. BesEing.VGeb_EG = bBesze.VGeb_Me - bBesze.VGeb_EG
  433. BesEing.KGeb_EG = bBesze.KGeb_Me - bBesze.KGeb_EG
  434. BesEing.Eing_Dat = dDatum
  435. BesEing.Verfall = (IF bBesze.lVerfall THEN ? ELSE dDatum)
  436. BesEing.Barcode = ''
  437. BesEing.Lotnr = ''
  438. .
  439. END.
  440. LEAVE.
  441. END.
  442. END PROCEDURE.
  443. /* _UIB-CODE-BLOCK-END */
  444. &ANALYZE-RESUME
  445. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin
  446. PROCEDURE ENTRY_BROWSE :
  447. /*------------------------------------------------------------------------------*/
  448. /* Purpose: Super Override */
  449. /* Parameters: */
  450. /* Notes: */
  451. /*------------------------------------------------------------------------------*/
  452. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
  453. RETURN NO-APPLY.
  454. END PROCEDURE.
  455. /* _UIB-CODE-BLOCK-END */
  456. &ANALYZE-RESUME
  457. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin
  458. PROCEDURE initializeObject :
  459. /*------------------------------------------------------------------------------*/
  460. /* Purpose: Super Override */
  461. /* Parameters: */
  462. /* Notes: */
  463. /*------------------------------------------------------------------------------*/
  464. { incl/brwinitialize.i }
  465. iStatus = DYNAMIC-FUNCTION ('getStatus':U IN hFenster ) NO-ERROR.
  466. END PROCEDURE.
  467. /* _UIB-CODE-BLOCK-END */
  468. &ANALYZE-RESUME
  469. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE viewObject bTableWin
  470. PROCEDURE viewObject :
  471. /*------------------------------------------------------------------------------*/
  472. /* Purpose: Super Override */
  473. /* Parameters: */
  474. /* Notes: */
  475. /*------------------------------------------------------------------------------*/
  476. DEFINE VARIABLE iRecid AS RECID NO-UNDO.
  477. DEFINE VARIABLE cRowid AS CHARACTER NO-UNDO.
  478. DEFINE BUFFER bBesze FOR Besze.
  479. iStatus = DYNAMIC-FUNCTION ('getStatus':U IN hFenster ) NO-ERROR.
  480. iRecid = DYNAMIC-FUNCTION ('getCurrentRecid':U IN hDaten) NO-ERROR.
  481. RUN SUPER.
  482. DYNAMIC-FUNCTION ('openQuery':U IN hDaten) NO-ERROR.
  483. IF iRecid = ? OR
  484. iRecid = 0 THEN RETURN.
  485. FIND bBesze WHERE RECID(bBesze) = iRecid.
  486. cRowid = STRING (ROWID(bBesze)).
  487. DYNAMIC-FUNCTION ('fetchRowIdent':U IN hDaten, cRowid, ?) NO-ERROR.
  488. END PROCEDURE.
  489. /* _UIB-CODE-BLOCK-END */
  490. &ANALYZE-RESUME
  491. /* ************************ Function Implementations ***************** */
  492. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin
  493. FUNCTION setZeilenfarbe RETURNS LOGICAL
  494. ( ipFarbe AS INT ) :
  495. /*------------------------------------------------------------------------------*/
  496. /* Purpose: Super Override */
  497. /* Parameters: */
  498. /* Notes: */
  499. /*------------------------------------------------------------------------------*/
  500. { incl/brwsetzeilenfarbe.i }
  501. END FUNCTION.
  502. /* _UIB-CODE-BLOCK-END */
  503. &ANALYZE-RESUME