-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathIMPRIMIR.FRM
430 lines (407 loc) · 14.5 KB
/
IMPRIMIR.FRM
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
VERSION 5.00
Begin VB.Form frmImprimir
BorderStyle = 3 'Fixed Dialog
Caption = "Imprimir"
ClientHeight = 4935
ClientLeft = 2445
ClientTop = 2565
ClientWidth = 7485
Icon = "Imprimir.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 329
ScaleMode = 3 'Pixel
ScaleWidth = 499
ShowInTaskbar = 0 'False
Begin VB.PictureBox picDraw
Appearance = 0 'Flat
AutoRedraw = -1 'True
BackColor = &H80000005&
ForeColor = &H00C0FFFF&
Height = 4935
Left = 0
ScaleHeight = 327
ScaleMode = 3 'Pixel
ScaleWidth = 22
TabIndex = 25
Top = 0
Width = 360
End
Begin VB.CommandButton cmdAccion
Caption = "&Salir"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Index = 1
Left = 4035
TabIndex = 24
Top = 4470
Width = 1245
End
Begin VB.CommandButton cmdAccion
Caption = "&Imprimir"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Index = 0
Left = 2355
TabIndex = 23
Top = 4470
Width = 1245
End
Begin VB.Frame fra
Caption = "Parámetros de Impresión"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 4275
Left = 435
TabIndex = 0
Top = 90
Width = 6975
Begin VB.CheckBox chkLineas
Caption = "Imprimir lineas consulta"
Height = 255
Left = 150
TabIndex = 22
Top = 3870
Width = 2565
End
Begin VB.Frame fraMargenes
Caption = "Márgenes"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 1185
Left = 150
TabIndex = 13
Top = 2640
Width = 6675
Begin VB.TextBox txtDer
Alignment = 1 'Right Justify
Height = 315
Left = 3840
TabIndex = 21
Text = "1"
Top = 750
Width = 1005
End
Begin VB.TextBox txtIzq
Alignment = 1 'Right Justify
Height = 315
Left = 3840
TabIndex = 19
Text = "1"
Top = 330
Width = 1005
End
Begin VB.TextBox txtAbajo
Alignment = 1 'Right Justify
Height = 315
Left = 1890
TabIndex = 17
Text = "1"
Top = 750
Width = 1005
End
Begin VB.TextBox txtArriba
Alignment = 1 'Right Justify
Height = 315
Left = 1890
TabIndex = 15
Text = "1"
Top = 330
Width = 1005
End
Begin VB.Label Label9
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Derecha"
ForeColor = &H80000008&
Height = 195
Left = 3150
TabIndex = 20
Top = 780
Width = 615
End
Begin VB.Label Label8
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Izquierda"
ForeColor = &H80000008&
Height = 195
Left = 3150
TabIndex = 18
Top = 420
Width = 645
End
Begin VB.Label Label7
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Abajo"
ForeColor = &H80000008&
Height = 195
Left = 1200
TabIndex = 16
Top = 780
Width = 405
End
Begin VB.Label Label6
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Arriba"
ForeColor = &H80000008&
Height = 195
Left = 1200
TabIndex = 14
Top = 360
Width = 405
End
End
Begin VB.ComboBox cboOrientacion
Height = 315
Left = 1050
Style = 2 'Dropdown List
TabIndex = 12
Top = 2280
Width = 5775
End
Begin VB.Frame fraPaginas
Caption = "Rango de Páginas"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 855
Left = 105
TabIndex = 6
Top = 1395
Width = 6735
Begin VB.TextBox txtHasta
Alignment = 1 'Right Justify
Height = 315
Left = 2940
TabIndex = 10
Text = "1"
Top = 390
Width = 1005
End
Begin VB.TextBox txtDesde
Alignment = 1 'Right Justify
Height = 315
Left = 930
TabIndex = 8
Text = "1"
Top = 390
Width = 1005
End
Begin VB.Label Label2
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Hasta"
ForeColor = &H80000008&
Height = 195
Left = 2250
TabIndex = 9
Top = 450
Width = 420
End
Begin VB.Label Label1
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Desde"
ForeColor = &H80000008&
Height = 195
Left = 240
TabIndex = 7
Top = 420
Width = 465
End
End
Begin VB.Frame fraEncabezados
Caption = "Encabezados"
BeginProperty Font
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 1125
Left = 120
TabIndex = 1
Top = 240
Width = 6765
Begin VB.TextBox txtPie
Height = 315
Left = 1170
TabIndex = 5
Top = 600
Width = 5505
End
Begin VB.TextBox txtCabezera
Height = 315
Left = 1170
TabIndex = 4
Top = 240
Width = 5505
End
Begin VB.Label Label4
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Pie de Página"
ForeColor = &H80000008&
Height = 195
Left = 120
TabIndex = 3
Top = 600
Width = 990
End
Begin VB.Label Label3
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Cabezera"
ForeColor = &H80000008&
Height = 195
Left = 120
TabIndex = 2
Top = 270
Width = 675
End
End
Begin VB.Label Label5
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BackStyle = 0 'Transparent
Caption = "Orientacion"
ForeColor = &H80000008&
Height = 195
Left = 120
TabIndex = 11
Top = 2310
Width = 810
End
End
End
Attribute VB_Name = "frmImprimir"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private mGradient As New clsGradient
Private Sub Imprimir()
On Local Error GoTo ErrorImprimir
Call Hourglass(hwnd, True)
If Not frmPreview.Estructura Then
frmMain.ActiveForm.griQuery.PrintHeader = txtCabezera.Text
frmMain.ActiveForm.griQuery.PrintFooter = txtPie.Text
frmMain.ActiveForm.griQuery.PrintPageStart = Val(txtDesde.Text)
frmMain.ActiveForm.griQuery.PrintPageEnd = Val(txtHasta.Text)
frmMain.ActiveForm.griQuery.PrintOrientation = cboOrientacion.ListIndex
frmMain.ActiveForm.griQuery.PrintMarginTop = Val(txtArriba.Text)
frmMain.ActiveForm.griQuery.PrintMarginBottom = Val(txtAbajo.Text)
frmMain.ActiveForm.griQuery.PrintMarginLeft = Val(txtIzq.Text)
frmMain.ActiveForm.griQuery.PrintMarginRight = Val(txtDer.Text)
frmMain.ActiveForm.griQuery.PrintGrid = chkLineas.Value
frmMain.ActiveForm.griQuery.PrintSmartPrint = True
frmMain.ActiveForm.griQuery.Action = 32
Else
frmVerTabla.fpTabla.PrintHeader = txtCabezera.Text
frmVerTabla.fpTabla.PrintFooter = txtPie.Text
frmVerTabla.fpTabla.PrintPageStart = Val(txtDesde.Text)
frmVerTabla.fpTabla.PrintPageEnd = Val(txtHasta.Text)
frmVerTabla.fpTabla.PrintOrientation = cboOrientacion.ListIndex
frmVerTabla.fpTabla.PrintMarginTop = Val(txtArriba.Text)
frmVerTabla.fpTabla.PrintMarginBottom = Val(txtAbajo.Text)
frmVerTabla.fpTabla.PrintMarginLeft = Val(txtIzq.Text)
frmVerTabla.fpTabla.PrintMarginRight = Val(txtDer.Text)
frmVerTabla.fpTabla.PrintGrid = chkLineas.Value
frmVerTabla.fpTabla.PrintSmartPrint = True
frmVerTabla.fpTabla.Action = 32
End If
MsgBox "Impresión realizada.", vbInformation
GoTo SalirImprimir
ErrorImprimir:
MsgBox "Imprimir : " & Err & " " & Error$, vbCritical
Resume SalirImprimir
SalirImprimir:
Call Hourglass(hwnd, False)
Err = 0
End Sub
Private Sub cmdAccion_Click(Index As Integer)
Select Case Index
Case 0
Call Imprimir
Case 1
Unload Me
End Select
End Sub
Private Sub Form_Load()
cboOrientacion.AddItem "DEFAULT"
cboOrientacion.AddItem "PORTRAIT"
cboOrientacion.AddItem "LANDSCAPE"
With mGradient
.Angle = 90 '.Angle
.Color1 = 16744448
.Color2 = 0
.Draw picDraw
End With
Call FontStuff(picDraw, "Imprimir")
picDraw.Refresh
End Sub
Private Sub Form_Unload(Cancel As Integer)
Set frmImprimir = Nothing
Set mGradient = Nothing
End Sub