g-lagereingang.w 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  4. &Scoped-define FRAME-NAME gLagereingaenge
  5. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gLagereingaenge
  6. /*------------------------------------------------------------------------
  7. File:
  8. Description: from cntnrdlg.w - ADM2 SmartDialog Template
  9. Input Parameters:
  10. <none>
  11. Output Parameters:
  12. <none>
  13. Author:
  14. Created:
  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. DEF VAR MaxPage AS INT NO-UNDO.
  28. DEF VAR AktSeite AS INT NO-UNDO.
  29. DEF VAR FMutFlag AS LOG NO-UNDO.
  30. DEF VAR Firma AS CHAR NO-UNDO.
  31. DEF VAR AdFirma AS CHAR NO-UNDO.
  32. /* _UIB-CODE-BLOCK-END */
  33. &ANALYZE-RESUME
  34. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  35. /* ******************** Preprocessor Definitions ******************** */
  36. &Scoped-define PROCEDURE-TYPE SmartDialog
  37. &Scoped-define DB-AWARE no
  38. &Scoped-define ADM-CONTAINER DIALOG-BOX
  39. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  40. /* Name of first Frame and/or Browse and/or first Query */
  41. &Scoped-define FRAME-NAME gLagereingaenge
  42. /* Standard List Definitions */
  43. &Scoped-Define ENABLED-OBJECTS F_VonDatum F_BisDatum Btn_OK Btn_Cancel ~
  44. RECT-3
  45. &Scoped-Define DISPLAYED-OBJECTS F_VonDatum F_BisDatum
  46. /* Custom List Definitions */
  47. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  48. &Scoped-define List-6 F_VonDatum F_BisDatum
  49. /* _UIB-PREPROCESSOR-BLOCK-END */
  50. &ANALYZE-RESUME
  51. /* *********************** Control Definitions ********************** */
  52. /* Define a dialog box */
  53. /* Definitions of the field level widgets */
  54. DEFINE BUTTON Btn_Cancel AUTO-END-KEY
  55. LABEL "Abbrechen"
  56. SIZE 14 BY 1.
  57. DEFINE BUTTON Btn_OK AUTO-GO
  58. LABEL "Start"
  59. SIZE 14 BY 1.
  60. DEFINE VARIABLE F_BisDatum AS DATE FORMAT "99.99.9999":U
  61. LABEL "-"
  62. VIEW-AS FILL-IN NATIVE
  63. SIZE 16 BY 1
  64. BGCOLOR 15 NO-UNDO.
  65. DEFINE VARIABLE F_VonDatum AS DATE FORMAT "99.99.9999":U
  66. LABEL "von - bis Datum"
  67. VIEW-AS FILL-IN NATIVE
  68. SIZE 16 BY 1
  69. BGCOLOR 15 NO-UNDO.
  70. DEFINE RECTANGLE RECT-3
  71. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  72. SIZE 68 BY 4.52.
  73. /* ************************ Frame Definitions *********************** */
  74. DEFINE FRAME gLagereingaenge
  75. F_VonDatum AT ROW 2.1 COL 18 COLON-ALIGNED
  76. F_BisDatum AT ROW 2.1 COL 37 COLON-ALIGNED
  77. Btn_OK AT ROW 4 COL 21
  78. Btn_Cancel AT ROW 4 COL 39.8
  79. RECT-3 AT ROW 1.24 COL 2
  80. SPACE(0.99) SKIP(0.37)
  81. WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER
  82. SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE
  83. TITLE "Lagereingänge"
  84. DEFAULT-BUTTON Btn_OK CANCEL-BUTTON Btn_Cancel.
  85. /* *********************** Procedure Settings ************************ */
  86. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  87. /* Settings for THIS-PROCEDURE
  88. Type: SmartDialog
  89. Allow: Basic,Browse,DB-Fields,Query,Smart
  90. Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  91. Design Page: 1
  92. Other Settings: COMPILE
  93. */
  94. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  95. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gLagereingaenge
  96. /* ************************* Included-Libraries *********************** */
  97. {src/adm2/containr.i}
  98. /* _UIB-CODE-BLOCK-END */
  99. &ANALYZE-RESUME
  100. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  101. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  102. /* SETTINGS FOR DIALOG-BOX gLagereingaenge
  103. Custom */
  104. ASSIGN
  105. FRAME gLagereingaenge:SCROLLABLE = FALSE
  106. FRAME gLagereingaenge:HIDDEN = TRUE.
  107. /* SETTINGS FOR FILL-IN F_BisDatum IN FRAME gLagereingaenge
  108. 6 */
  109. /* SETTINGS FOR FILL-IN F_VonDatum IN FRAME gLagereingaenge
  110. 6 */
  111. /* _RUN-TIME-ATTRIBUTES-END */
  112. &ANALYZE-RESUME
  113. /* Setting information for Queries and Browse Widgets fields */
  114. &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gLagereingaenge
  115. /* Query rebuild information for DIALOG-BOX gLagereingaenge
  116. _Options = "SHARE-LOCK"
  117. _Query is NOT OPENED
  118. */ /* DIALOG-BOX gLagereingaenge */
  119. &ANALYZE-RESUME
  120. /* ************************ Control Triggers ************************ */
  121. &Scoped-define SELF-NAME gLagereingaenge
  122. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gLagereingaenge gLagereingaenge
  123. ON END-ERROR OF FRAME gLagereingaenge /* Lagereingänge */
  124. DO:
  125. RUN ENDE.
  126. RETURN NO-APPLY.
  127. END.
  128. /* _UIB-CODE-BLOCK-END */
  129. &ANALYZE-RESUME
  130. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gLagereingaenge gLagereingaenge
  131. ON GO OF FRAME gLagereingaenge /* Lagereingänge */
  132. DO:
  133. RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR.
  134. END.
  135. /* _UIB-CODE-BLOCK-END */
  136. &ANALYZE-RESUME
  137. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gLagereingaenge gLagereingaenge
  138. ON WINDOW-CLOSE OF FRAME gLagereingaenge /* Lagereingänge */
  139. DO:
  140. RUN ENDE.
  141. RETURN NO-APPLY.
  142. END.
  143. /* _UIB-CODE-BLOCK-END */
  144. &ANALYZE-RESUME
  145. &Scoped-define SELF-NAME Btn_Cancel
  146. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gLagereingaenge
  147. ON CHOOSE OF Btn_Cancel IN FRAME gLagereingaenge /* Abbrechen */
  148. DO:
  149. RUN ENDE.
  150. RETURN NO-APPLY.
  151. END.
  152. /* _UIB-CODE-BLOCK-END */
  153. &ANALYZE-RESUME
  154. &Scoped-define SELF-NAME Btn_OK
  155. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gLagereingaenge
  156. ON CHOOSE OF Btn_OK IN FRAME gLagereingaenge /* Start */
  157. DO:
  158. RUN REPORT.
  159. ENABLE Btn_OK
  160. Btn_Cancel WITH FRAME {&FRAME-NAME}.
  161. RUN ENDE.
  162. RETURN NO-APPLY.
  163. END.
  164. /* _UIB-CODE-BLOCK-END */
  165. &ANALYZE-RESUME
  166. &UNDEFINE SELF-NAME
  167. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gLagereingaenge
  168. /* *************************** Main Block *************************** */
  169. MaxPage = 1.
  170. AktSeite = 1.
  171. SESSION:DATA-ENTRY-RETURN = TRUE.
  172. /* ------------------------------------------------------------------ */
  173. {src/adm2/dialogmn.i}
  174. /* _UIB-CODE-BLOCK-END */
  175. &ANALYZE-RESUME
  176. /* ********************** Internal Procedures *********************** */
  177. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gLagereingaenge _ADM-CREATE-OBJECTS
  178. PROCEDURE adm-create-objects :
  179. /*------------------------------------------------------------------------------
  180. Purpose: Create handles for all SmartObjects used in this procedure.
  181. After SmartObjects are initialized, then SmartLinks are added.
  182. Parameters: <none>
  183. ------------------------------------------------------------------------------*/
  184. END PROCEDURE.
  185. /* _UIB-CODE-BLOCK-END */
  186. &ANALYZE-RESUME
  187. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE changePage gLagereingaenge
  188. PROCEDURE changePage :
  189. /*------------------------------------------------------------------------------
  190. Purpose: Super Override
  191. Parameters:
  192. Notes:
  193. ------------------------------------------------------------------------------*/
  194. /* Code placed here will execute PRIOR to standard behavior. */
  195. RUN SUPER.
  196. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  197. CASE AktSeite:
  198. WHEN 1 THEN DO:
  199. /* RUN addLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
  200. /* RUN addLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
  201. /* RUN ToolbarInit ( INPUT h_d-auftr ). */
  202. RUN ENTRY_CURSOR.
  203. END.
  204. WHEN 2 THEN DO:
  205. RUN ENTRY_CURSOR.
  206. END.
  207. END CASE.
  208. END PROCEDURE.
  209. /* _UIB-CODE-BLOCK-END */
  210. &ANALYZE-RESUME
  211. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gLagereingaenge _DEFAULT-DISABLE
  212. PROCEDURE disable_UI :
  213. /*------------------------------------------------------------------------------
  214. Purpose: DISABLE the User Interface
  215. Parameters: <none>
  216. Notes: Here we clean-up the user-interface by deleting
  217. dynamic widgets we have created and/or hide
  218. frames. This procedure is usually called when
  219. we are ready to "clean-up" after running.
  220. ------------------------------------------------------------------------------*/
  221. /* Hide all frames. */
  222. HIDE FRAME gLagereingaenge.
  223. END PROCEDURE.
  224. /* _UIB-CODE-BLOCK-END */
  225. &ANALYZE-RESUME
  226. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gLagereingaenge
  227. PROCEDURE enableObject :
  228. /*------------------------------------------------------------------------------
  229. Purpose: Super Override
  230. Parameters:
  231. Notes:
  232. ------------------------------------------------------------------------------*/
  233. /* Code placed here will execute PRIOR to standard behavior. */
  234. RUN SUPER.
  235. RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR.
  236. END PROCEDURE.
  237. /* _UIB-CODE-BLOCK-END */
  238. &ANALYZE-RESUME
  239. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gLagereingaenge _DEFAULT-ENABLE
  240. PROCEDURE enable_UI :
  241. /*------------------------------------------------------------------------------
  242. Purpose: ENABLE the User Interface
  243. Parameters: <none>
  244. Notes: Here we display/view/enable the widgets in the
  245. user-interface. In addition, OPEN all queries
  246. associated with each FRAME and BROWSE.
  247. These statements here are based on the "Other
  248. Settings" section of the widget Property Sheets.
  249. ------------------------------------------------------------------------------*/
  250. DISPLAY F_VonDatum F_BisDatum
  251. WITH FRAME gLagereingaenge.
  252. ENABLE F_VonDatum F_BisDatum Btn_OK Btn_Cancel RECT-3
  253. WITH FRAME gLagereingaenge.
  254. VIEW FRAME gLagereingaenge.
  255. {&OPEN-BROWSERS-IN-QUERY-gLagereingaenge}
  256. END PROCEDURE.
  257. /* _UIB-CODE-BLOCK-END */
  258. &ANALYZE-RESUME
  259. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gLagereingaenge
  260. PROCEDURE ENDE :
  261. /*------------------------------------------------------------------------------
  262. Purpose:
  263. Parameters: <none>
  264. Notes:
  265. ------------------------------------------------------------------------------*/
  266. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.
  267. IF AktSeite > 1 THEN DO:
  268. RUN selectPage ( INPUT 1 ).
  269. RETURN NO-APPLY.
  270. END.
  271. RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ).
  272. APPLY 'GO' TO FRAME {&FRAME-NAME}.
  273. RETURN NO-APPLY.
  274. END PROCEDURE.
  275. /* _UIB-CODE-BLOCK-END */
  276. &ANALYZE-RESUME
  277. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_CURSOR gLagereingaenge
  278. PROCEDURE ENTRY_CURSOR :
  279. /*------------------------------------------------------------------------------
  280. Purpose:
  281. Parameters: <none>
  282. Notes:
  283. ------------------------------------------------------------------------------*/
  284. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  285. CASE AktSeite:
  286. /* WHEN 1 THEN RUN applyEntry IN h_v-adresse ( INPUT ? ). */
  287. /* WHEN 2 THEN RUN applyEntry IN h_f-adrkomm ( INPUT ? ). */
  288. /* WHEN 3 THEN RUN applyEntry IN h_b-auftbb ( INPUT ? ). */
  289. /* WHEN 4 THEN RUN applyEntry IN h_b-aufdet ( INPUT ? ). */
  290. /* WHEN 5 THEN RUN applyEntry IN h_b-aufstreu ( INPUT ? ). */
  291. /* WHEN 6 THEN RUN applyEntry IN h_b-auffak ( INPUT ? ). */
  292. /* WHEN 7 THEN RUN applyEntry IN h_b-position ( INPUT ? ). */
  293. END CASE.
  294. RETURN NO-APPLY.
  295. END PROCEDURE.
  296. /* _UIB-CODE-BLOCK-END */
  297. &ANALYZE-RESUME
  298. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gLagereingaenge
  299. PROCEDURE exitObject :
  300. /*------------------------------------------------------------------------------
  301. Purpose: Super Override
  302. Parameters:
  303. Notes:
  304. ------------------------------------------------------------------------------*/
  305. RUN ENDE.
  306. RETURN NO-APPLY.
  307. END PROCEDURE.
  308. /* _UIB-CODE-BLOCK-END */
  309. &ANALYZE-RESUME
  310. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE KOPF gLagereingaenge
  311. PROCEDURE KOPF :
  312. /*------------------------------------------------------------------------------
  313. Purpose:
  314. Parameters: <none>
  315. Notes:
  316. ------------------------------------------------------------------------------*/
  317. DEF INPUT PARAMETER eh AS COM-HANDLE NO-UNDO.
  318. DEF VAR Zelle AS CHAR NO-UNDO.
  319. /*
  320. eh:APPLICATION:RUN('FormatKopf').
  321. */
  322. FIND Steuer USE-INDEX Steuer-k1
  323. WHERE Steuer.Firma = Firma NO-LOCK NO-ERROR.
  324. Zelle = 'A1'.
  325. eh:Range(Zelle):SELECT.
  326. eh:SELECTION:VALUE = Steuer.Firma1.
  327. Zelle = 'F1'.
  328. eh:Range(Zelle):SELECT.
  329. eh:SELECTION:VALUE = 'Lagereingänge'.
  330. Zelle = 'H1'.
  331. eh:Range(Zelle):SELECT.
  332. eh:SELECTION:VALUE = 'Datum : ' + STRING(TODAY,'99.99.9999').
  333. Zelle = 'A2'.
  334. eh:Range(Zelle):SELECT.
  335. eh:SELECTION:VALUE = Steuer.Ort.
  336. Zelle = 'F2'.
  337. eh:Range(Zelle):SELECT.
  338. eh:SELECTION:VALUE = STRING(F_VonDatum,'99.99.9999')
  339. + ' '
  340. + STRING(F_BisDatum,'99.99.9999').
  341. Zelle = 'H2'.
  342. eh:Range(Zelle):SELECT.
  343. eh:SELECTION:VALUE = 'Zeit : ' + STRING(TIME,'HH:MM:SS').
  344. END PROCEDURE.
  345. /* _UIB-CODE-BLOCK-END */
  346. &ANALYZE-RESUME
  347. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPORT gLagereingaenge
  348. PROCEDURE REPORT :
  349. /*------------------------------------------------------------------------------
  350. Purpose:
  351. Parameters: <none>
  352. Notes:
  353. ------------------------------------------------------------------------------*/
  354. DEF VAR excelAppl AS COM-HANDLE NO-UNDO.
  355. DEF VAR DatenName AS CHAR NO-UNDO.
  356. DEF VAR DateiName AS CHAR NO-UNDO.
  357. DEF VAR Zelle AS CHAR NO-UNDO.
  358. DEF VAR xText AS CHAR NO-UNDO.
  359. DEF VAR Ja AS LOG NO-UNDO.
  360. DEF VAR cWoTag AS CHAR NO-UNDO.
  361. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
  362. AdFirma = DYNAMIC-FUNCTION('GETADMANDANT':U) NO-ERROR.
  363. DatenName = 'Lagereingänge.txt'.
  364. DateiName = 'Lagereingänge.xls' + CHR(01) + 'Lagereingänge.xls'.
  365. DO WITH FRAME {&FRAME-NAME}:
  366. ASSIGN {&List-6}.
  367. IF F_VonDatum = ? THEN F_VonDatum = DATE(MONTH(TODAY),01,YEAR(TODAY)).
  368. IF F_BisDatum = ? THEN F_BisDatum = DATE(12,31,YEAR(TODAY)).
  369. DISPLAY {&List-6}.
  370. DISABLE Btn_OK
  371. Btn_Cancel.
  372. DO WHILE TRUE:
  373. excelAppl = DYNAMIC-FUNCTION('CREATEEXCEL':U) NO-ERROR.
  374. IF NOT VALID-HANDLE(excelAppl) THEN DO:
  375. RUN FEHLER ( INPUT 1035 ).
  376. RETURN NO-APPLY.
  377. END.
  378. LEAVE.
  379. END.
  380. DO WHILE TRUE:
  381. RUN CREATEDATEI ( INPUT DateiName ).
  382. IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE.
  383. CASE RETURN-VALUE:
  384. WHEN 'ERROR-PARAMETER' THEN DO:
  385. RUN FEHLER ( INPUT 1036 ).
  386. RETURN NO-APPLY.
  387. END.
  388. WHEN 'ERROR-LOESCHEN' THEN DO:
  389. RUN FEHLER ( INPUT 1037 ).
  390. RETURN NO-APPLY.
  391. END.
  392. WHEN 'ERROR-VORLAGE' THEN DO:
  393. RUN FEHLER ( INPUT 1038 ).
  394. RETURN NO-APPLY.
  395. END.
  396. OTHERWISE DO:
  397. MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR.
  398. RETURN NO-APPLY.
  399. END.
  400. END CASE.
  401. LEAVE.
  402. END.
  403. DateiName = RETURN-VALUE.
  404. DO WHILE TRUE:
  405. RUN CREATEDATEI ( INPUT DatenName ).
  406. IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE.
  407. CASE RETURN-VALUE:
  408. WHEN 'ERROR-PARAMETER' THEN DO:
  409. RUN FEHLER ( INPUT 1036 ).
  410. RETURN NO-APPLY.
  411. END.
  412. WHEN 'ERROR-LOESCHEN' THEN DO:
  413. RUN FEHLER ( INPUT 1037 ).
  414. RETURN NO-APPLY.
  415. END.
  416. WHEN 'ERROR-VORLAGE' THEN DO:
  417. RUN FEHLER ( INPUT 1038 ).
  418. RETURN NO-APPLY.
  419. END.
  420. OTHERWISE DO:
  421. MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR.
  422. RETURN NO-APPLY.
  423. END.
  424. END CASE.
  425. LEAVE.
  426. END.
  427. DatenName = RETURN-VALUE.
  428. OUTPUT TO VALUE(DatenName) APPEND.
  429. FOR EACH Artbw USE-INDEX Artbw-k8
  430. WHERE Artbw.Firma = Firma
  431. AND Artbw.Tr_Art = 11
  432. AND Artbw.Datum >= F_VonDatum
  433. AND Artbw.Datum <= F_BisDatum NO-LOCK
  434. BY Artbw.Datum
  435. BY Artbw.Artnr
  436. BY Artbw.Inhalt
  437. BY Artbw.Jahr :
  438. PUT CONTROL '£'.
  439. PUT CONTROL STRING(Artbw.Datum ,'99.99.9999') '£'
  440. STRING(Artbw.Artnr ,'999999') '£'
  441. STRING(Artbw.Inhalt,'zzzz') '£'
  442. STRING(Artbw.Jahr ,'zzzz') '£'
  443. Artbw.Bez1 ' '
  444. Artbw.Bez2 '£'
  445. STRING(Artbw.Menge ,'->>>>>9') '£'
  446. STRING(Artbw.Preis ,'>>>9.99') CHR(10).
  447. END.
  448. OUTPUT CLOSE.
  449. RUN OPENEXCEL ( INPUT excelAppl,
  450. INPUT DateiName,
  451. INPUT '',
  452. OUTPUT Ja ).
  453. IF NOT Ja THEN DO:
  454. RUN FEHLER ( INPUT 1040 ).
  455. RETURN NO-APPLY.
  456. END.
  457. Zelle = 'A6'.
  458. excelAppl:Range(Zelle):SELECT.
  459. excelAppl:Selection:FormulaR1C1 = 'TEXT;' + DatenName.
  460. excelAppl:Application:RUN ( 'DateiEinfügen' ).
  461. RUN KOPF ( INPUT excelAppl ) NO-ERROR.
  462. Zelle = 'A1'.
  463. excelAppl:Range(Zelle):SELECT.
  464. excelAppl:Selection:ColumnWidth = 0.3.
  465. DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT excelAppl ) NO-ERROR.
  466. END.
  467. END PROCEDURE.
  468. /* _UIB-CODE-BLOCK-END */
  469. &ANALYZE-RESUME
  470. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage gLagereingaenge
  471. PROCEDURE selectPage :
  472. /*------------------------------------------------------------------------------
  473. Purpose: Super Override
  474. Parameters:
  475. Notes:
  476. ------------------------------------------------------------------------------*/
  477. DEF INPUT PARAMETER piPageNum AS INT NO-UNDO.
  478. DEF VAR FMutFlag AS LOG NO-UNDO.
  479. DEF VAR MutProg AS CHAR NO-UNDO.
  480. FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
  481. DO WHILE TRUE:
  482. IF NOT FMutFlag THEN LEAVE.
  483. MutProg = DYNAMIC-FUNCTION('GETMUTPROG':U).
  484. IF MutProg <> THIS-PROCEDURE:FILE-NAME THEN LEAVE.
  485. RETURN NO-APPLY.
  486. END.
  487. CASE piPageNum:
  488. END CASE.
  489. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  490. CASE AktSeite:
  491. WHEN 1 THEN DO:
  492. /* RUN removeLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
  493. /* RUN removeLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
  494. END.
  495. END CASE.
  496. RUN SUPER( INPUT piPageNum).
  497. END PROCEDURE.
  498. /* _UIB-CODE-BLOCK-END */
  499. &ANALYZE-RESUME