project2.frm

数据库资料

   End
   Begin VB.TextBox Text2 
      BackColor       =   &H00FFFFC0&
      DataField       =   "人员分配"
      DataSource      =   "Data1"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   5520
      TabIndex        =   8
      Top             =   2040
      Width           =   1695
   End
   Begin VB.TextBox Text1 
      BackColor       =   &H00FFFFC0&
      DataField       =   "项目编号"
      DataSource      =   "Data1"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   1800
      TabIndex        =   7
      Top             =   360
      Width           =   1695
   End
   Begin VB.Frame Frame1 
      Caption         =   "查询"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   1815
      Left            =   6360
      TabIndex        =   20
      Top             =   4080
      Width           =   3015
      Begin VB.Label Label9 
         Caption         =   "编号"
         BeginProperty Font 
            Name            =   "MS Sans Serif"
            Size            =   13.5
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   240
         TabIndex        =   21
         Top             =   480
         Width           =   735
      End
   End
   Begin VB.Label Label8 
      Caption         =   "项目编号"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   360
      TabIndex        =   6
      Top             =   360
      Width           =   1335
   End
   Begin VB.Label Label7 
      Caption         =   "项目总额"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   3960
      TabIndex        =   5
      Top             =   360
      Width           =   1335
   End
   Begin VB.Label Label6 
      Caption         =   "人员分配"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   4080
      TabIndex        =   4
      Top             =   2040
      Width           =   1335
   End
   Begin VB.Label Label2 
      Caption         =   "项目名称"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   360
      TabIndex        =   3
      Top             =   1200
      Width           =   1335
   End
   Begin VB.Label Label1 
      Caption         =   "项目进度"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   360
      TabIndex        =   2
      Top             =   2880
      Width           =   1335
   End
   Begin VB.Label Label5 
      Caption         =   "报交日期"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   360
      TabIndex        =   1
      Top             =   2040
      Width           =   1335
   End
   Begin VB.Label Label4 
      Caption         =   "使用工时"
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   13.5
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   495
      Left            =   4080
      TabIndex        =   0
      Top             =   1200
      Width           =   1335
   End
End
Attribute VB_Name = "project"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

Private Sub Command1_Click()
If Data1.Recordset.BOF Then
Data1.Recordset.MoveFirst
Else
Data1.Recordset.MovePrevious
If Data1.Recordset.BOF Then
Data1.Recordset.MoveFirst
End If
End If

End Sub

Private Sub Command2_Click()
Unload project

End Sub

Private Sub Command3_Click()
Dim sqlString As String
sqlString = "select * from project where 项目编号='" & Text9.Text & "'"
Data1.RecordSource = sqlString
Data1.Refresh
If Data1.Recordset.EOF Then
MsgBox "无此项目编号！请重新输入", vbOKOnly, "错误"
Text9.Text = ""
Text9.SetFocus
Data1.RecordSource = "select * from project"
Data1.Refresh
End If
End Sub

Private Sub Command4_Click()
Dim msg As Integer
msg = MsgBox("是否要删除？", vbOKCancel, "删除记录")
If msg = 1 Then
Data1.Recordset.Delete
Data1.Recordset.MoveLast
End If
End Sub

Private Sub Command5_Click()

Data1.Recordset.AddNew
Data1.Recordset.Update
Data1.Recordset.MoveLast
MsgBox "增加成功！", vbOKOnly, "增加"


End Sub

Private Sub Command6_Click()
If Data1.Recordset.EOF Then
Data1.Recordset.MoveLast
Else
Data1.Recordset.MoveNext
If Data1.Recordset.EOF Then
Data1.Recordset.MoveLast
End If
End If
End Sub

Private Sub Command7_Click()
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""

Text6.Text = ""
Text5.Text = ""
Text7.Text = ""
Text8.Text = ""
Text9.Text = ""
End Sub

Private Sub Command8_Click()
Data1.Recordset.MoveFirst
End Sub

Private Sub Command9_Click()
Data1.Recordset.MoveLast
End Sub

Private Sub Data1_Validate(Action As Integer, Save As Integer)
Command3.Enabled = False
End Sub

Private Sub Text9_KeyPress(KeyAscii As Integer)
If KeyAscii < 57 And KeyAscii > 48 Then
Command3.Enabled = True
End If


End Sub