-
Notifications
You must be signed in to change notification settings - Fork 1
/
frmZNDI1.frm
249 lines (228 loc) · 6.91 KB
/
frmZNDI1.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
VERSION 5.00
Object = "{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0"; "MSHFLXGD.OCX"
Begin VB.Form frmZNDI
BorderStyle = 1 'Fixed Single
Caption = "Ñòàòèñòèêà ïî ÍIJ"
ClientHeight = 5115
ClientLeft = 45
ClientTop = 435
ClientWidth = 6360
Icon = "frmZNDI1.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 5115
ScaleWidth = 6360
Begin VB.CheckBox Check1
Caption = "Áåç âðàõóâàííÿ ³íñïåêòîðà"
Height = 255
Left = 480
TabIndex = 8
Top = 4560
Width = 2775
End
Begin VB.CommandButton cmd_Form
Caption = "Ôîðìóâàòè"
BeginProperty Font
Name = "Tahoma"
Size = 9
Charset = 204
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 3360
TabIndex = 7
Top = 4440
Width = 2535
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid Grid1
Height = 3015
Left = 480
TabIndex = 6
Top = 1200
Width = 5415
_ExtentX = 9551
_ExtentY = 5318
_Version = 393216
FixedCols = 0
BackColorFixed = 12582912
ForeColorFixed = -2147483634
AllowBigSelection= 0 'False
HighLight = 2
ScrollBars = 2
SelectionMode = 1
AllowUserResizing= 1
BeginProperty FontFixed {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 204
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_NumberOfBands = 1
_Band(0).BandIndent= 1
_Band(0).Cols = 2
_Band(0).GridLinesBand= 1
_Band(0).TextStyleBand= 0
_Band(0).TextStyleHeader= 0
End
Begin VB.ComboBox cmbYear1
Height = 315
Left = 1680
TabIndex = 3
Text = "2010"
Top = 720
Width = 1095
End
Begin VB.ComboBox cmbMonth1
Height = 315
ItemData = "frmZNDI1.frx":000C
Left = 480
List = "frmZNDI1.frx":000E
TabIndex = 2
Text = "1"
Top = 720
Width = 975
End
Begin VB.ComboBox cmbYear2
Height = 315
Left = 4800
TabIndex = 1
Text = "2010"
Top = 720
Width = 1095
End
Begin VB.ComboBox cmbMonth2
Height = 315
Left = 3600
TabIndex = 0
Text = "1"
Top = 720
Width = 975
End
Begin VB.Label Label2
Alignment = 2 'Center
Caption = "ʳíöåâà äàòà (ì³ñÿöü, ð³ê)"
BeginProperty Font
Name = "Tahoma"
Size = 8.25
Charset = 204
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 3480
TabIndex = 5
Top = 360
Width = 2415
End
Begin VB.Label Label1
Alignment = 2 'Center
Caption = "Ïî÷àòêîâà äàòà (ì³ñÿöü, ð³ê)"
BeginProperty Font
Name = "Tahoma"
Size = 8.25
Charset = 204
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 255
Left = 360
TabIndex = 4
Top = 360
Width = 2775
End
End
Attribute VB_Name = "frmZNDI"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public myFrmMain As frmMain
Private Sub Check1_Click()
With Grid1
If Check1.Value = 0 Then
.Clear
.Rows = 2
.Cols = 3
.FormatString = "Çâ³òíà äàòà | ʳëüê³ñòü | ²íñïåêòîð "
.ColWidth(0) = 1200
.ColWidth(1) = 1000
.ColWidth(2) = 1000
Else
.Clear
.Rows = 2
.Cols = 2
.FormatString = "Çâ³òíà äàòà | ʳëüê³ñòü"
.ColWidth(0) = 1200
.ColWidth(1) = 1000
End If
End With
End Sub
Private Sub cmd_Form_Click()
Dim SelNdiKol, kolgroup As String
If Len(cmbMonth1) = 1 Then cmbMonth1 = "0" & cmbMonth1
If Len(cmbMonth2) = 1 Then cmbMonth2 = "0" & cmbMonth2
SelNdiKol = "SELECT convert(varchar(6), ndi_date, 112) as [Çâ³òíà äàòà], SUM(ndi_kol) As [ʳëüê³ñòü] " & _
"FROM [SSPZ].[dbo].[ndi] WHERE convert (varchar(6), ndi_date, 112) BETWEEN " & cmbYear1 & cmbMonth1 & " AND " & cmbYear2 & cmbMonth2 & _
"GROUP BY convert(varchar(6), ndi_date, 112) "
kolgroup = "SELECT convert(varchar(6), ndi_date, 112) as [Çâ³òíà äàòà], SUM(ndi_kol) As [ʳëüê³ñòü], ndi_prog as [²íñïåêòîð] " & _
"FROM [SSPZ].[dbo].[ndi] WHERE convert (varchar(6), ndi_date, 112) BETWEEN " & cmbYear1 & cmbMonth1 & " AND " & cmbYear2 & cmbMonth2 & _
" GROUP BY convert(varchar(6), ndi_date, 112), ndi_prog ORDER BY convert(varchar(6), ndi_date, 112)"
ConnectToDataBase
If Check1.Value = 1 Then
myRS.Open SelNdiKol, myADO, adOpenStatic
Else
myRS.Open kolgroup, myADO, adOpenStatic
'MsgBox kolgroup
End If
If myRS.RecordCount >= 1 Then
Set Grid1.Recordset = myRS
Else
MsgBox "Çà âêàçàíèé ïåð³îä äàí³ â³äñóòí³.", vbInformation, "Ïõå"
End If
End Sub
Private Sub Form_Load()
Dim iMonth As Integer, iYear As Integer
For iMonth = 1 To 12
cmbMonth1.AddItem iMonth
cmbMonth2.AddItem iMonth
Next
For iYear = 2010 To Year(Date) + 1
cmbYear1.AddItem iYear
cmbYear2.AddItem iYear
Next
cmbMonth1 = Month(Date)
If cmbMonth1 = 12 Then
cmbMonth2 = 1
cmbYear2 = Year(Date) + 1
Else
cmbMonth2 = cmbMonth1 + 1
cmbYear2 = Year(Date)
End If
cmbYear1 = Year(Date)
'With Grid1
' .Rows = 2
' .Cols = 2
' .FormatString = "Çâ³òíà äàòà | ʳëüê³ñòü"
' .ColWidth(0) = 1200
' .ColWidth(1) = 1000
'End With
Check1.Value = 1
End Sub
Private Sub Form_Unload(Cancel As Integer)
myFrmMain.zndi.Enabled = True
End Sub