|
Создание базы данных |
038 2039 Min% = Height - dH2 + Screen. TwipsPerPixelY2040 If (Min < 0) Then Min = 02041 VScroll. Height = Min2042 2043 Call DrawDiagram2044End Sub20452046Private Sub Image1_Click() 2047 CD. FileName = ""2048 CD. ShowSave2049 If (CD. FileName <> "") Then2050 Call SavePicture(Chart. Image, CD. FileName) 2051 End If2052End Sub20532054Private Sub Image2_Click() 2055 With DiagOptForm2056 ' цвета2057. Frame2(0). BackColor = StartFillColor2058. Frame2(1). BackColor = EndFillColor2059. Frame2(2). BackColor = Chart. ForeColor2060. Frame2(3). BackColor = LineColor2061 ' размеры2062. UpDown1. value = LineWidth2063. UpDown2. value = d3D2064. UpDown3. value = PointRadius2065. UpDown4. value = LineCount2066. UpDown5. value = Round(Ellipce * 100) 2067 2068. UpDown6. Max = Chart. Width2069 If (Chart. Height < Chart. Width) Then. UpDown6. Max = Chart. Width2070. UpDown6. Max = Round(. UpDown6. Max / Screen. TwipsPerPixelX) 2071. UpDown6. value = Round(Radius / Screen. TwipsPerPixelX) 20722073. UpDown7. Max =. UpDown6. Max * 0.92074. UpDown7. value = Round(InRad / Screen. TwipsPerPixelX) 2075 2076 ' цвета и надписи2077. List1. Clear2078 For i% = 1 To ItemCount2079. List1. AddItem (DiagData(i - 1). Text) 2080. List1. ItemData(i - 1) = DiagData(i - 1). Color2081 Next i2082 If (. List1. ListCount > 0) Then. List1. ListIndex = 02083 2084 ' флаги2085. Check1. value = - CInt(UseColorFill) 2086. Check3. value = - CInt(UseCircleLegend) 2087. Check2. value = - CInt(UseLineLeftValues) 2088 2089. Show vbModal2090 If (. res = 1) Then2091 ' цвета2092 StartFillColor =. Frame2(0). BackColor2093 EndFillColor =. Frame2(1). BackColor2094 Chart. ForeColor =. Frame2(2). BackColor2095 LineColor =. Frame2(3). BackColor2096 ' размеры2097 LineWidth =. UpDown1. value2098 d3D =. UpDown2. value2099 PointRadius =. UpDown3. value2100 LineCount =. UpDown4. value2101 Ellipce =. UpDown5. value / 1002102 Radius =. UpDown6. value * Screen. TwipsPerPixelX2103 InRad =. UpDown7. value * Screen. TwipsPerPixelX2104 ' цвета и надписи2105 For i% = 1 To ItemCount2106 DiagData(i - 1). Text =. List1. List(i - 1) 2107 DiagData(i - 1). Color =. List1. ItemData(i - 1) 2108 Next i2109 ' флаги2110 UseColorFill = (. Check1. value = 1) 2111 UseCircleLegend = (. Check3. value = 1) 2112 UseLineLeftValues = (. Check2. value = 1) 2113 Call DrawDiagram2114 End If2115 End With2116End Sub21172118Private Sub Image3_Click() 2119 Hide2120End Sub21212122Private Sub VScroll_Change() 2123 Ellipce = VScroll. value / 1002124 Call DrawDiagram2125End SubФорма: InputForm. frm2126Dim res%21272128Private Sub CancelBut_Click() 2129 Call SoundClick2130 Hide2131End Sub21322133Private Sub Form_Activate() 2134 Text1. SetFocus2135End Sub21362137Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) 2138 Select Case KeyCode2139 Case 13: Call YesBut_Click2140 Case 27: Call CancelBut_Click2141 End Select2142End Sub21432144Private Sub Form_Load() 2145 Call ButEnabled(YesImg, YesBut, True) 2146 Call ButEnabled(CancelImg, CancelBut, True) 2147End Sub21482149Public Function InputVal(str$) As String2150 Label1. Caption = str2151 Text1. Text = ""2152 res = 02153 Me. Show vbModal2154 If (res = 1) Then InputVal = Text1. Text2155 Unload Me2156End Function21572158Private Sub YesBut_Click() 2159 Call SoundClick2160 res = 12161 Hide2162End SubФорма: DiagOpt. frm2163Public res%21642165Private Sub Form_Load() 2166 res = 02167 Call ButEnabled(SelectImg, SelectBut, True) 2168 Call ButEnabled(CancelImg, CancelBut, True) 2169End Sub21702171Private Sub Form_Paint() 2172 Call DiagResForm. ColorFill(Picture1, Frame2(0). BackColor, Frame2(1). BackColor) 2173End Sub21742175Private Sub Frame2_Click(Index As Integer) 2176 ColorDlg. Color = Frame2(Index). BackColor2177 ColorDlg. ShowColor2178 Frame2(Index). BackColor = ColorDlg. Color2179 If (Index < 2) Then Call DiagResForm. ColorFill(Picture1, Frame2(0). BackColor, Frame2(1). BackColor) 2180 If (Index = 4) Then List1. ItemData(List1. ListIndex) = Frame2(4). BackColor2181End Sub21822183Private Sub Label10_Click() 2184 res = 12185 Hide2186End Sub21872188Private Sub Label15_Click() 2189 Hide2190End Sub21912192Private Sub List1_Click() 2193 If (List1. ListIndex > - 1) Then2194 Text1. Text = List1. List(List1. ListIndex) 2195 Frame2(4). BackColor = List1. ItemData(List1. ListIndex) 2196 End If2197End Sub21982199Private Sub List1_KeyPress(KeyAscii As Integer) 2200 Call List1_Click2201End Sub22022203Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer) 2204 If (KeyCode = 13) Then2205 List1. List(List1. ListIndex) = Text1. Text2206 List1. ItemData(List1. ListIndex) = Frame2(4). BackColor2207 End If2208End SubФорма: SplashScreenForm. frm2209Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) 2210 If (KeyCode = 27) Or (KeyCode = 13) Then2211 MainForm. Show2212 Unload Me2213 End If2214End Sub22152216Private Sub Form_Load() 2217 Label2. Caption = "v. " + CStr(App. Major) + ". " + CStr(App. Minor) 2218End Sub22192220Private Sub Picture1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single) 2221 Call MDown(x, y) 2222End Sub22232224Private Sub Picture1_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single) 2225 Call MMove(hwnd, x, y) 2226End Sub22272228Private Sub Picture1_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single) 2229 Call MUp2230End SubФорма: MonthForm. frm2231Public res%22322233Private Sub CancelBut_Click() 2234 Hide2235End Sub22362237Private Sub EditBut_Click() 2238 res = - 12239 Hide2240End Sub22412242Private Sub Form_Load() 2243 Call ButEnabled(YesImg, YesBut, True) 2244 Call ButEnabled(EditImg, EditBut, True) 2245 Call ButEnabled(CancelImg, CancelBut, True) 2246 res = 02247End Sub22482249Private Sub YesBut_Click() 2250 res = 12251 Hide2252End SubМодуль: DBTypes. bas2253'************************************2254' модуль DBTypes. bas2255' вся работа с файлом БД2256'************************************22572258'************************************** Описание типов **************************************22592260' заголовок файла2261Type TDBHeader2262 ' "DBX" - проверка файла2263 Header As String * 32264 ' флаги2265 Flags As Byte2266 ' количество полей2267 ColCount As Long2268 ' количество записей2269 RowCount As Long2270End Type22712272' имеет ли пользователь права на редактирование2273Public UserIsAdmin As Boolean22742275' данные о столбце2276Type TDBElemData2277 ' тип данных2278 Class As Byte2279 ' длина заголовка2280 TitleLen As Byte2281 ' заголовок, длины TitleLen2282 title As String2283 ' значение по-умолчанию2284 DefValue As Variant2285End Type22862287' запись2288Type TDBElem2289 ' поля записи2290 Fields() As Variant2291End Type22922293' элемент в массиве DB2294Type TDBCell2295 Header As TDBHeader2296 Cols() As TDBElemData2297 Rows() As TDBElem2298 Password As String2299End Type23002301'************************************** Описание констант **************************************23022303' контрольный байт2304Public Const ValidateByte As Byte = &H7F23052306'************************************** Описание переменных **************************************23072308' путь к БД2309Public DBPath$2310' флаг изменения БД2311Public DBChanged As Boolean2312' данные таблиц: каждый элемент - это копия некоторой таблицы2313Public DB() As TDBCell23142315'************************************** Процедуры и функции **************************************23162317' удаление поля2318Public Sub DelCol_(DBIndex%, Optional ByVal Index% = - 1, Optional ByVal conf As Boolean = True) 2319 With DB(DBIndex). Header2320 If (. ColCount = 0) Then Exit Sub2321 If (Index = - 1) Then Index =. ColCount - 12322 If (Index >. ColCount - 1) Or (Index < - 1) Then2323 Call MsgForm. ErrorMsg("Ошибка удаления столбца! ") 2324 Exit Sub2325 End If2326 2327 If conf Then2328 If (MsgForm. QuestMsg("Удалить столбец? ") <> resOk) Then Exit Sub2329 End If2330 ' вырезаю из полей2331 For i% = Index To (. ColCount - 2) 2332 DB(DBIndex). Cols(i) = DB(DBIndex). Cols(i + 1) 2333 Next i2334 ' вырезаю из записей2335 For R% = 0 To (. RowCount - 1) 2336 For c% = Index To (. ColCount - 2) 2337 DB(DBIndex). Rows(R). Fields(c) = DB(DBIndex). Rows(R). Fields(c + 1) 2338 Next c2339 Next R2340 2341. ColCount =. ColCount - 12342 ReDim Preserve DB(DBIndex). Cols(. ColCount) 2343 DBChanged = True2344End With2345End Sub23462347' удаление записи2348Public Sub DelRow_(DBIndex%, Optional ByVal Index% = - 1, Optional ByVal conf As Boolean = True) 2349 With DB(DBIndex). Header2350 If (. RowCount = 0) Then Exit Sub2351 If (Index = - 1) Then Index =. RowCount - 12352 If (Index >. RowCount - 1) Then2353 Call MsgForm. ErrorMsg("Ошибка удаления записи! ") 2354 Exit Sub2355 End If2356 2357 If conf Then2358 If (MsgForm. QuestMsg("Удалить запись? ") = resNo) Then Exit Sub2359 End If2360 For i% = Index To (. RowCount - 2) 2361 DB(DBIndex). Rows(i) = DB(DBIndex). Rows(i + 1) 2362 Next i2363. RowCount =. RowCount - 12364 ReDim Preserve DB(DBIndex). Rows(. RowCount) 2365 DBChanged = True2366End With2367End Sub23682369Public Sub TestDBChanged() 2370 If DBChanged Then2371 MainForm. SB. Panels(1). Picture = MainForm. ImageList1. ListImages(2). Picture2372 Else2373 Set MainForm. SB. Panels(1). Picture = Nothing2374 End If2375End Sub23762377' отображение таблицы2378Public Sub ShowTable(DBIndex%) 2379 MainForm. ListView. ListItems. Clear2380 MainForm. ListView. ColumnHeaders. Clear2381 If (DBIndex = - 1) Then2382 DBPath = ""2383 MainForm. SB. Panels(3). Text = ""2384 GoTo exit_2385 End If2386 If (DB(DBIndex). Header. ColCount = 0) Then GoTo exit_2387 For c% = 0 To DB(DBIndex). Header. ColCount - 12388 Call MainForm. ListView. ColumnHeaders. Add(_2389 MainForm. ListView. ColumnHeaders. Count + 1, _2390 "col_key_" + CStr(c), _2391 DB(DBIndex). Cols(c). title, _2392 1440, _2393 lvwColumnLeft, _2394 0 _2395) 23962397 Next c2398 For R% = 0 To DB(DBIndex). Header. RowCount - 12399 With MainForm. ListView. ListItems. Add2400. Key = "row_key_" + CStr(R) 2401. Text = DB(DBIndex). Rows(R). Fields(0) 2402 For i% = 1 To DB(DBIndex). Header. ColCount - 12403. SubItems(i) = DB(DBIndex). Rows(R). Fields(i) 2404 Next i2405 End With2406 Next R2407exit_: 2408 MainForm. TabStrip. Visible = (DBPath <> "") 2409 MainForm. ListView. Visible = MainForm. TabStrip. Visible2410 If (DBIndex <> - 1) Then2411 MainForm. SB. Panels(2). Text = CStr(DB(DBIndex). Header. RowCount) 2412 Else2413 MainForm. SB. Panels(2). Text = ""2414 End If2415 Call TestDBChanged2416End Sub24172418' поиск поля *************************************************2419Public Function ItColAlreadyCreate(QRDBIndex%, title$) As Boolean2420 With DB(QRDBIndex) 2421 For i% = 0 To (DB(QRDBIndex). Header. ColCount - 1) 2422 If (. Cols(i). title = title) Then2423 ItColAlreadyCreate = True2424 Exit Function2425 End If2426 Next i2427 End With2428 ItColAlreadyCreate = False2429End Function24302431' добавление поля *************************************************2432Public Sub AddCol(DBIndex%, ByVal Class%, ByVal title$, ByVal defval, Optional ByVal pos% = - 1) 2433 With DB(DBIndex). Header2434 ReDim Preserve DB(DBIndex). Cols(. ColCount) 2435 If (pos = - 1) Then2436 pos =. ColCount2437 Else2438 For i% = 1 To (. ColCount - pos) 2439 DB(DBIndex). Cols(. ColCount - i + 1) = DB(DBIndex). Cols(. ColCount - i) 2440 Next i2441 End If2442 With DB(DBIndex). Cols(pos) 2443. Class = Class2444. title = title2445. TitleLen = Len(title) 2446. DefValue = defval2447 End With2448 2449 ' увеличиваю размерность записей2450 For R% = 0 To DB(DBIndex). Header. RowCount - 12451 ReDim Preserve DB(DBIndex). Rows(R). Fields(. ColCount) 2452 For i% = 1 To (. ColCount - pos) 2453 DB(DBIndex). Rows(R). Fields(. ColCount - i + 1) = DB(DBIndex). Rows(R). Fields(. ColCount - i) 2454 Next i2455 DB(DBIndex). Rows(R). Fields(pos) = DB(DBIndex). Cols(pos). DefValue2456 Next R2457 2458. ColCount =. ColCount + 12459 2460 DBChanged = True2461 End With2462End Sub24632464' добавление записи *************************************************2465Public Sub AddField(DBIndex%, row) 2466 With DB(DBIndex). Header2467 ReDim Preserve DB(DBIndex). Rows(. RowCount) 2468 DB(DBIndex). Rows(. RowCount). Fields = row2469. RowCount =. RowCount + 12470 DBChanged = True2471 End With
Страницы: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11
|
|
|
© 2003-2013
Рефераты бесплатно, курсовые, рефераты биология, большая бибилиотека рефератов, дипломы, научные работы, рефераты право, рефераты, рефераты скачать, рефераты литература, курсовые работы, реферат, доклады, рефераты медицина, рефераты на тему, сочинения, реферат бесплатно, рефераты авиация, рефераты психология, рефераты математика, рефераты кулинария, рефераты логистика, рефераты анатомия, рефераты маркетинг, рефераты релиния, рефераты социология, рефераты менеджемент. |
|
|