【正文】 在軟件的部署上都非常容易，而且性能優(yōu)越。 在 ACCESS 中數(shù)據(jù)庫是一個邏輯上的概念，通過一組系統(tǒng)文件將相互關(guān)聯(lián)的數(shù)據(jù)表及其數(shù)據(jù)庫對象組織起來，成為擴展名為 .mdb 的數(shù)據(jù)庫文件。 數(shù)據(jù)詞典分析 該軟件的數(shù)據(jù)庫由四個數(shù)據(jù)表組成： A．員工基本信息表： ygshuju 系統(tǒng)設(shè)定 員工信息管理 員工工資匯總 圖 系統(tǒng)的數(shù)據(jù)流程圖 B．基礎(chǔ)工資設(shè)定表： gzshuju C．部門表： bumen D．管理員密碼表： denglu （ 1）員工基本信息表： ygshuju 字段名 類型 員工號 數(shù)值型 姓名 字符型 所屬部門 字符型 職位 字符型 基本工資 數(shù)值型 (2)基礎(chǔ)工資設(shè)定表： gzshuju (3)部 門表：bumen 字段名 類型 部門 字符型 管理員注冊表： denglu 字段名 類型 工資號 數(shù)值型 姓名 字符型 底薪 數(shù)值型 補貼 數(shù)值型 獎金 數(shù)值型 加班 數(shù)值型 扣考核 數(shù)值型 房帖 數(shù)值型 房租 數(shù)值型 養(yǎng)老金 數(shù)值型 醫(yī)療保險 數(shù)值型 住房公積金 數(shù)值型 所得稅 數(shù)值型 計法時間 日期型 字段 字段名 類型 1 用戶名 字符型 2 口 令 字符型 第四章 工資管理系統(tǒng)的功能實現(xiàn) 圖 管理模塊編碼設(shè)計 此模塊細分為人員管理和部門管理 。* amp。 Format(Now, yymm) txtItem(0) = (2) End Sub （ 3）“添加”按鈕具體編碼如下： Private Sub cmdSave_Click() Dim intCount As Integer Dim txtSQL As String Dim mrc As Recordset Dim MsgText As String Dim db As Database Dim sMeg As String If Trim(txtItem(0) amp。添加判斷是否有相同的 ID 記錄 txtSQL = select * from gzshuju where 工資號 =39。 Set mrc = (txtSQL) If = False Then MsgBox 已經(jīng)存在該員工在該月的工資記錄！ , vbOKOnly + vbExclamation, 警告 txtItem(13).SetFocus Exit Sub End If txtSQL = select * from gzshuju Set mrc = (txtSQL) (0) = Trim(txtId) (1) = Trim(cboItem(1)) (17) = Trim(cboItem(0)) (15) = Trim(txtItem(13)) For intCount = 0 To 12 (intCount + 2) = txtItem(intCount) Next intCount MsgBox 計發(fā)工資成功！ , vbOKOnly + vbExclamation, 警告 For intCount = 0 To 12 txtItem(intCount) = Next intCount mblChange = False = False End Sub （ 4）“離開”按鈕具體編碼如下： Private Sub cmdExit_Click() If mblChange And Then If MsgBox( 保 存 當 前 記 錄 的 變 化 嗎 ？ , vbOKCancel + vbExclamation, 警告 ) = vbOK Then 39。稅額變化 If Trim(txtItem(9) amp。稅前小計變化 dblTotal = CDbl(txtItem(8)) 39。MsgBox KeyCode 39。非數(shù)字不能輸入 If KeyAscii 57 Or KeyAscii 48 Then txtItem(Index).Locked = True Else txtItem(Index).Locked = False End If 39。 amp。 , yyyymmdd) Case Else .TextMatrix(.Rows 1, i) = (i 1) amp。表頭項居中 .FillStyle = flexFillRepeat .Col = 0 .Row = 0 .RowSel = 1 .ColSel = .Cols 1 .CellAlignment = 4 39。 Trim(Combo1) amp。通過連編將項目資源，如視圖、查詢、表單、報表、 菜單、類、過程這些包含于項目管理器中的文件信息結(jié)合在一起，生成一個擴展名為 .exe 的可執(zhí)行文件。因此，如何使企業(yè)及時掌握本企業(yè)人才的各種信息、第一時間處理好隨時變化的工資管理問題，建立一套符合企業(yè)實際的工資管 理系統(tǒng)就顯得尤為重要。但回過頭再去看有關(guān)的教科書，經(jīng)過一段時間的鉆研，對與這些知識點的相關(guān)的背景，概念和解決方案理解得更透徹了，學(xué)習(xí)起來也越來越有興趣，越來越輕松。這時候，我一般是先自己通過書本，手冊和資料找解決辦法，實在沒轍了才向?qū)＜艺埥?。針對工資管理，還應(yīng)該建立一個有普遍意義的模型，這樣對用戶來說，就比較容易通過修改有關(guān)管理制度來適應(yīng)我們開發(fā)的軟件。 the fly sat upon the axletree of the chariot wheel, and said. What a dust do I raise? So are there some vain persons, that whatsoever goeths indeed! They could tell us something worth hearing, if they only knew how to talk. It39。t know what that is! The journey of the witches on broomsticks is well enough known that journey is taken on St. John39。 for all bravery stands upon parisons. They must needs be violent, to make good their own vaunts. Neithe r can they be secret, and therefore not effectual。 as if a man that negotiates between two princes, to draw them to join in a war against the third, doth extol the forces of either of them above measure, the one to the other: and sometimes, he that deals between man and man, raiseth his own credit with both by pretending greater interest than he hath in either. And in these, and the like kinds, it often falls out that somewhat is produced of nothing: for lies are sufficient to breed opinion, and opinion brings on substance. In military manders and soldiers, vainglory is an essential poin t。 and virtue was never so beholding to human nature, as it received his due at the second hand. Neither had the fame of Cicero, Seneca, Plinius Secundus, borne her age so well, if it had not been joined with some vanity in themselves: like unto varnish, that makes sealings not only shine, but last But all this while, when I speak of vainglory, I m ean not of that property, that Tacitus doth attribute to Mucianus。 In mending another, you do your self right。 the idols of parasites。 for these are the offences which are and have been, and willeve r be, the source of all the aforesaid evils. The greatest of themare excesses and insolences of youth, and are offences against thegre。s goods, neither shall heuse anything which is his neighbour39。 if he be superior, if he be not to be mended, you much less. Glorious men are the scorn of wise men。 which is to be liberal of praise and mendation to others, in that wherein a man\39。 and those mat are of solid and sober natures have more of the ballast, than of the sail. In fame of learning, the flight w ill be slow, without some feathers of ostentation. Q ui de contenm enda gloria libros scribunt, nomen suum inscribunt. Socrates, Aristotle, Galen, were men firil of ostentation. Certainly vainglory helpeth to perpetuate a man\39。 beaucoup de bruit, peu de fruit: much bruit, little fruit Yet certainly there is use of this quality, in civil affairs. Where there is an opinion, and fame to be created, either of virtue, or greatness, these men are good trumpeters. Again, as Titus Livius noteth, in the case of Antiochus, and the Aetolians。 but we have a wild journey, also which is national and modern, and that is the journey to Amack on the night of the New Year. All indifferent poets and poetesses, musicians, newspaper writers, and artistic notabilities, I mean those who are no good, ride in the New Year39。s eve I was reading the book, and had lost myse