VF課程設計報告學生選課管理系統(tǒng)

1、Wuhan intelligent elevator co production workshop and warehouse steel structures at the donghu development zone, Wuhan University Science and Technology Park, Park Road. 1, an area of the steel: production workshop is 7344.00 square meters; finished goods warehouse is 1036.80 square meters. 2, light

2、 steel structure fabrication and installation costs of the project are: 4.35 million Yuan. 3, the project designed by Wuhan Polytechnic Institute, Zhejiang, the light steel structure limited the production and installation of steel structures. 4, the installation period of the project is: 70 days (w

3、orkshop and warehouse were 70 days). 5, the technology requirements for the production and installation of engineering and construction quality, duration control, supervision of contract performance commissioned by the owners corporation and Zhejiang, the Palace to complete steel structure, a QC, an

4、d monitor in real time to ensure the completion of the project according to the quality and quantity. This project by the Zhejiang plant production system to do immediately after the steel structure, organized by the Engineering Department for field installation. Design and production based on insta

5、llation procedure the project by Wuhan Polytechnic Institute of design, Zhejiang, the steel structure, based on intelligent elevator company and Wuhan steel, signed production and installation contract for production of detail design. Quality acceptance code for architectural design of light steel s

6、tructure and construction profiles: 1, GB5009-2001 2, of the structural specification of the building code for seismic design of GB50011-2001 3, GB50017-2003 4, of the code for design of steel structure of the standard specification for cold-formed thin-walled steel structure GB50018-2002 5, the ste

7、el structure project construction quality approval standard GB50205-2001 6, the Specification for construction and acceptance of steel structure design of high-strength bolt connection JGJ82-91 7, the technical specification for steel structure welding JBJ81-2002 8, the technical specification for s

8、teel structure of door-like steel frame light house CECS102-2002 material selecting overview support section: production workshop roof pitch i=5%. Finished products warehouse roof slope of 8%. Roof: a single layer Board + insulation wool + steel wire mesh roof plate with 0.50mm blue HXY-820 color st

9、eel plate aluminum-plating zinc. thick fiberglass insulation cotton with 75mm density 12Kg per cubic metre. Wall surfaces (workshop): double Board + insulation cotton, outer wall surface with 0.50mm white galvanized HXY-840 color steel plate, wall plate white galvanized HXY-900 0.40mm color steel pl

10、ate, uses 50mm fiberglass insulation cotton, density 12Kg per m3. Part of the main structure: steel column correction after his time on column bottom and base top surface gaps without the secondary water shrinkage of fine stone concrete. Steel columns, beams, frames, beams, columns, a wind column, t

11、raffic beam material Q345B. mechanical properties and chemical composition are in line with the GB/T1591-94 provision of the low-alloy structural steel. Brace, knee brace . Surface protection of steel structure paint according to the contract, be dealt with separately. Located ± 0.000 2% NaN02

12、steel surface coating cement weight cement mortar, and C10 concrete packages to 0.15M, package thickness of 100 feet of concrete. Steel structure installation overview: installation and acceptance of steel structure should be carried out according to the GB50205-2001, strict construction quality and

13、 construction of the installation order. Single component production after the immediate classification number should be placed, it is forbidden to place. Structure before installing the widget should be a comprehensive inspection, such as member number, length, perpendicularity, flatness, it meets

14、the design requirements and specifications. Structure lifting and appropriate measures should be taken to prevent excessive torsion deformation of components. Main steel frame installed, grasp the rope should be set up in time, and support system in place before they can remove temporary installatio

15、n and adjustment range Rover wind rope. All round support should finally install regulated tension. All the superstructure must be installed in the lower part of the structural adjustment in place and fix the following. High-strength bolt connections within the contact surface using sandblasting pro

16、cess and components, not brushing paint or defaced.學生選課管理系統(tǒng)東北大學秦皇島分校姓名：劉國鋒學號：3090908指導教師：朱世敏日期： 2011 年 06 月 19 日一、總體說明總體功能介紹在學生選課信息管理系統(tǒng)中，首先輸入用戶名和密碼等登錄信息，進入主界面，有以下模塊“數(shù)據(jù)查詢”、“記錄修改”、“報表”、“密碼安全”。在“數(shù)據(jù)查詢”中，包含“課程查詢”；在“記錄修改”中包含“課程和學生選課修改”和“學生選課”；在“報表”中包含以下兩項子菜單：“學生選課情況”，“可選課程”；在“密碼安全”中有“密碼修改”子菜單。在“可選課程信息”中輸入

17、相應的內(nèi)容，即可顯示相應的結(jié)果。原用戶還可通過密碼修改來不定期修改自己的原始密碼，保證了數(shù)據(jù)的真實性和安全性。用戶還可通過查詢課程信息來實現(xiàn)選課功能。管理員也可通過打印報表來查看學生的選課記錄和學生個人信息。二、功能模塊結(jié)構(gòu)圖 數(shù)據(jù)查詢 ：課程信息查詢（按課程名稱查詢） 可進行課程信息修改 課程和學生選課修改 可進行學生信息修改 主界面 記錄修改 學生選課 （可實現(xiàn)學生的自由選課）密碼登陸 學生選課情況報表 可選課程 密碼安全 （密碼信息修改） 三、變量說明(公有、私有、本地變量)1在登錄系統(tǒng)中，有公有變量i，表示輸入密碼的次數(shù)，i的初值設為0，當i>3時系統(tǒng)將自動退出；公有變量uid，

18、用戶名。2.私有變量：pwd：記錄登錄時的用戶密碼。四、數(shù)據(jù)庫、表的設計及描述1.數(shù)據(jù)庫：為最后程序的連編提供數(shù)據(jù)源。2.（1）管理員表：為登錄系統(tǒng)提供賬號和相應的密碼（2）學生基本信息表：可以學生基本信息，對其添加、刪除；為查詢學生基本信息提供數(shù)據(jù)源。（3）課程表：對其添加、刪除，為查詢提供數(shù)據(jù)源（4）學生成績表：可以查詢學生成績，對其添加、刪除、修改（5）密碼表：記錄用戶的登錄密碼五、操作說明本系統(tǒng)適合廣大用戶操作使用，其操作過程簡單明了。該系統(tǒng)擁有“學生基本信息查詢”、“學生成績查詢”、“課程查詢”、“打印報表”等功能。操作步驟如下：1、單機登陸界面進入用戶名和密碼登錄界面，輸入用戶名和

19、密碼之后單擊“確定”按鈕即可進入系統(tǒng)。若用戶名和密碼輸入錯誤，則退出本系統(tǒng)。選擇“退出按鈕則離開本系統(tǒng)。本系統(tǒng)的初始密碼為“學號”2用戶進入系統(tǒng)后，便直接到達此界面。在此界面中，用戶可以選擇數(shù)據(jù)修改、數(shù)據(jù)查詢、選課功能。單擊“退出”按鈕，退出該頁面。3在“記錄修改”菜單欄下，可以對一些列的表進行添加、刪除、編輯操作。4選擇“數(shù)據(jù)查詢”子菜單下的“學生成績查詢”則可對該學生的各科成績進行查詢。在此，查詢中，用戶可選擇“按學號查詢”和“按姓名查詢”兩種方式輸入查詢信息。系統(tǒng)則會快速的調(diào)出該學生的成績。5選擇“數(shù)據(jù)查詢”子菜單下的“課程查詢”，則可查詢學生的選課信息6選擇“報表”子菜單下的“學生選課

20、情況可以對學生選課的信息以報表的形式查詢，此外還可以從報表上的個人的選課情況按照學號和系別進行區(qū)分；通過可選課程可以查詢并打印所有的課程信息；7選擇菜單欄上的“密碼修改“可以對用戶的密碼進行修改以維護給人的信息部被別人修改，以確保個人信息的安全和完整性。六、各模塊代碼及結(jié)果圖密碼登錄：1、確定的click事件uid=alltrim(thisform.text1.value)pwd=alltrim(thisform.text2.value)locate for 用戶=uidif not found()messagebox("無此用戶",0,"學生選課管理系統(tǒng)&quo

21、t;)thisform.text1.selstart=0thisform.text1.sellength=len(thisform.text1.text)thisform.text1.setfocusreturnendifif alltrim(密碼)=pwdthisform.releasedo form 主程序.scxi=i+1elseif i>=3messagebox("三次密碼輸入不對，系統(tǒng)將退出")thisform.releaseelsemessagebox("密碼不正確，請重新輸入")thisform.text1.selstart=0thi

22、sform.text1.sellength=len(thisform.text1.text)endifendif3、取消登錄的click事件thisform.release()表單11、combol1Rowsource：管理員表.用戶名2.、text1passwordchar：*value ：a3、確定（command1）：click事件i=i+1select 管理員表locate all for 用戶名=alltrim(bo1.value)if found () and 密碼=alltrim(thisform.text1.value) do form bd1release thisforme

23、lse if i<3 =messagebox("管理員密碼錯誤！"+chr(13)+"再試一次！",48,"警告") thisform.text1.value="a" thisform.text1.setfocuselse =messagebox("對不起，已經(jīng)錯3次了！"+chr(13)+"非法用戶，請退出系統(tǒng)",48,"嚴重警告") thisform.release endifendif4、退出（command2）：click事件thisform

24、.release學生成績查詢：1、option1 gotfocus事件thisform.label6.caption="姓 名"2 、option2 gotfocus事件thisform.label6.caption="學 號"3close alla1=alltrim(thisform.text1.value)if thisform.optiongroup1.option1.value=1 do case case val(left(a1,7)>=3080801 and val(left(a1,7)<=3080827 select * fro

25、m 學生綜合成績表 where alltrim(學號)=a1 into cursor w if alltrim(學號)=a1 thisform.text4.value=姓名 thisform.text5.value=總成績 thisform.text6.value=經(jīng)濟法 thisform.text7.value=概率 thisform.text8.value=英語 thisform.text9.value=參加活動 thisform.text10.value=運籌學 thisform.text11.value=企業(yè)管理 thisform.text12.value=平均成績 else messagebox("不存在該學生,請核對后再查!") endif case a1="" messagebox("您還沒有輸入查詢信息！") otherwise messagebox("本校不存在該學生,請核對后再查!") endcase close allelse use 學生綜合成績表 locate for