?? formwxjl.frm
字號:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form FormWXJL
BorderStyle = 1 'Fixed Single
Caption = "Form1"
ClientHeight = 8055
ClientLeft = 45
ClientTop = 435
ClientWidth = 10920
BeginProperty Font
Name = "Tahoma"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 8055
ScaleWidth = 10920
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin VB.PictureBox picLOAD
Appearance = 0 'Flat
BackColor = &H80000005&
ForeColor = &H80000008&
Height = 375
Left = 120
ScaleHeight = 345
ScaleWidth = 2985
TabIndex = 10
Top = 960
Visible = 0 'False
Width = 3015
Begin MSComctlLib.ProgressBar ProgressBar1
Height = 135
Left = 120
TabIndex = 11
Top = 120
Width = 2775
_ExtentX = 4895
_ExtentY = 238
_Version = 393216
Appearance = 0
End
End
Begin MSComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 255
Left = 0
TabIndex = 9
Top = 7800
Width = 10920
_ExtentX = 19262
_ExtentY = 450
_Version = 393216
BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
NumPanels = 1
BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
AutoSize = 1
Object.Width = 19209
EndProperty
EndProperty
End
Begin VB.TextBox txtCZ
Height = 320
Left = 6360
TabIndex = 8
Top = 960
Width = 1455
End
Begin VB.CommandButton cmdXLS
Caption = "導出(&E)"
Height = 340
Left = 9960
TabIndex = 7
Top = 960
Width = 855
End
Begin VB.CommandButton cmdQC
Caption = "清除(&R)"
Height = 340
Left = 9000
TabIndex = 6
Top = 960
Width = 855
End
Begin VB.CommandButton cmdCZ
Caption = "查找(&S)"
Height = 340
Left = 8040
TabIndex = 5
Top = 960
Width = 855
End
Begin VB.ComboBox comXM
Height = 330
Left = 4200
TabIndex = 2
Top = 960
Width = 1575
End
Begin MSComctlLib.ImageList ImageList1
Left = 9960
Top = 240
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 2
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FormWXJL.frx":0000
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FormWXJL.frx":0114
Key = ""
EndProperty
EndProperty
End
Begin MSComctlLib.ListView ListView1
Height = 6375
Left = 0
TabIndex = 1
Top = 1440
Width = 10935
_ExtentX = 19288
_ExtentY = 11245
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
Icons = "ImageList1"
SmallIcons = "ImageList1"
ColHdrIcons = "ImageList1"
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 0
NumItems = 0
End
Begin VB.PictureBox Picture1
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 0 'None
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 855
Left = 0
ScaleHeight = 855
ScaleWidth = 10935
TabIndex = 0
Top = 0
Width = 10935
End
Begin VB.Label Label2
Caption = "查找"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 5880
TabIndex = 4
Top = 1035
Width = 495
End
Begin VB.Label label1
Caption = "項目"
BeginProperty Font
Name = "宋體"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 3720
TabIndex = 3
Top = 1035
Width = 375
End
End
Attribute VB_Name = "FormWXJL"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim addlist1 As ListItem
Private Sub cmdCZ_Click()
ListView1.ListItems.Clear
Call addXX
End Sub
Private Sub cmdQC_Click()
Me.comXM.Text = ""
txtCZ.Text = ""
ListView1.ListItems.Clear
Call addXX
End Sub
Private Sub cmdXLS_Click()
k = 0
picLOAD.Visible = True
Call OpenConn
If comXM.Text = "" Or txtCZ.Text = "" Then
sql = "select * from wxb ORDER BY wgrq"
Else
Dim xmmc As String '項目名稱
If Me.comXM.Text = "維修單號" Then xmmc = "wxid"
If Me.comXM.Text = "報修人" Then xmmc = "bxr"
If Me.comXM.Text = "完工日期" Then xmmc = "wgrq"
If Me.comXM.Text = "服務類型" Then xmmc = "fwlx"
If Me.comXM.Text = "服務方式" Then xmmc = "fwfs"
If Me.comXM.Text = "維修人員" Then xmmc = "wxry"
sql = "select * from wxb where " & xmmc & " like '%" & txtCZ.Text & "%' ORDER BY wgrq"
End If
rs.Open sql, cn, 1, 1
If rs.RecordCount <= 0 Then
MsgBox "沒有可以導出的記錄！", 48, "錯誤提示"
Exit Sub
Else
Call OpenExcel
'添加excel列頭~~~~~~~~~~~~~~~~~~~~~~~
mysheet.Cells(1, 1) = "維修記錄"
mysheet.Cells(2, 1) = "維修單號"
mysheet.Cells(2, 2) = "報修人"
mysheet.Cells(2, 3) = "報修電話"
mysheet.Cells(2, 4) = "報修日期"
mysheet.Cells(2, 5) = "到修日期"
mysheet.Cells(2, 6) = "完工日期"
mysheet.Cells(2, 7) = "服務類型"
mysheet.Cells(2, 8) = "服務方式"
mysheet.Cells(2, 9) = "故障現象"
mysheet.Cells(2, 10) = "解決方法"
mysheet.Cells(2, 11) = "故障件名稱"
mysheet.Cells(2, 12) = "故障件型號"
mysheet.Cells(2, 13) = "更換件名稱"
mysheet.Cells(2, 14) = "更換件型號"
mysheet.Cells(2, 15) = "上門費用"
mysheet.Cells(2, 16) = "維修費用"
mysheet.Cells(2, 17) = "材料費用"
mysheet.Cells(2, 18) = "維修人員"
mysheet.Cells(2, 19) = "服務評價"
mysheet.Cells(2, 20) = "備注"
mysheet.Cells(2, 21) = "用戶編號"
j = 3
Do While Not rs.EOF
For i = 0 To rs.Fields.Count - 1
mysheet.Cells(j, i + 1) = rs.Fields(i).Value
Next i
j = j + 1
rs.MoveNext
k = k + 1
Me.ProgressBar1.Value = Format(k / rs.RecordCount, "0.00") * 100
Loop
End If
picLOAD.Visible = False
ProgressBar1.Value = 0
myexcel.Visible = True
Call CloseConn
Call CloseExcel
End Sub
Private Sub Form_Load()
Me.Icon = FormZY.Icon
Me.Caption = xtmc
Me.Picture1.Picture = LoadPicture(App.Path & "\bg\bg6.bmp")
comXM.AddItem "維修單號"
comXM.AddItem "報修人"
comXM.AddItem "完工日期"
comXM.AddItem "服務類型"
comXM.AddItem "服務方式"
comXM.AddItem "維修人員"
'添加listview1標頭、寬度~~~~~~~~~~~~~~~~~~~~~`
With ListView1
.View = lvwReport
.ColumnHeaders.Add = "維修單號"
.ColumnHeaders.Add = "報修人"
.ColumnHeaders.Add = "報修電話"
.ColumnHeaders.Add = "報修日期"
.ColumnHeaders.Add = "到修日期"
.ColumnHeaders.Add = "完工日期"
.ColumnHeaders.Add = "服務類型"
.ColumnHeaders.Add = "服務方式"
.ColumnHeaders.Add = "維修人員"
.ColumnHeaders.Add = "服務評價"
.ColumnHeaders.Add = "故障現象"
.ColumnHeaders.Add = "" '存放用戶ID
.ColumnHeaders(7).Width = 1000
.ColumnHeaders(8).Width = 1000
.ColumnHeaders(9).Width = 1000
.ColumnHeaders(10).Width = 1000
.ColumnHeaders(11).Width = 3000
.ColumnHeaders(12).Width = 0
End With
'添加listview1數據~~~~~~~~~~~~~~~~~~~~~~
Call addXX
End Sub
Private Sub ListView1_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
With ListView1 '點擊列標頭排序~~~~~~~~~~~~~~~~~~~~~
If (ColumnHeader.Index - 1) = .SortKey Then
.SortOrder = (.SortOrder + 1) Mod 2
Else
.Sorted = False
.SortOrder = 0
.SortKey = ColumnHeader.Index - 1
.Sorted = True
End If
End With
End Sub
Private Sub addXX()
'添加listview1數據~~~~~~~~~~~~~~~~~~~~~~
Call OpenConn
If comXM.Text = "" Or txtCZ.Text = "" Then
sql = "select wxid,bxr,bxdh,bxrq,dxrq,wgrq,fwlx,fwfs,wxry,fwpj,gzxx,wyhid from wxb ORDER BY wgrq"
Else
Dim xmmc As String '項目名稱
If Me.comXM.Text = "維修單號" Then xmmc = "wxid"
If Me.comXM.Text = "報修人" Then xmmc = "bxr"
If Me.comXM.Text = "完工日期" Then xmmc = "wgrq"
If Me.comXM.Text = "服務類型" Then xmmc = "fwlx"
If Me.comXM.Text = "服務方式" Then xmmc = "fwfs"
If Me.comXM.Text = "維修人員" Then xmmc = "wxry"
sql = "select wxid,bxr,bxdh,bxrq,dxrq,wgrq,fwlx,fwfs,wxry,fwpj,gzxx,wyhid from wxb where " & xmmc & " like '%" & txtCZ.Text & "%' ORDER BY wgrq"
End If
rs.Open sql, cn, 1, 1
Do While Not rs.EOF
Set addlist1 = ListView1.ListItems.Add(, , rs.Fields("wxid"), , 1) '將各項數據加入list列表
addlist1.SubItems(1) = IIf(IsNull(rs.Fields("bxr")), "", rs.Fields("bxr"))
addlist1.SubItems(2) = IIf(IsNull(rs.Fields("bxdh")), "", rs.Fields("bxdh"))
addlist1.SubItems(3) = IIf(IsNull(rs.Fields("bxrq")), "", rs.Fields("bxrq"))
addlist1.SubItems(4) = IIf(IsNull(rs.Fields("dxrq")), "", rs.Fields("dxrq"))
addlist1.SubItems(5) = IIf(IsNull(rs.Fields("wgrq")), "", rs.Fields("wgrq"))
addlist1.SubItems(6) = IIf(IsNull(rs.Fields("fwlx")), "", rs.Fields("fwlx"))
addlist1.SubItems(7) = IIf(IsNull(rs.Fields("fwfs")), "", rs.Fields("fwfs"))
addlist1.SubItems(8) = IIf(IsNull(rs.Fields("wxry")), "", rs.Fields("wxry"))
addlist1.SubItems(9) = IIf(IsNull(rs.Fields("fwpj")), "", rs.Fields("fwpj"))
addlist1.SubItems(10) = IIf(IsNull(rs.Fields("gzxx")), "", rs.Fields("gzxx"))
addlist1.SubItems(11) = IIf(IsNull(rs.Fields("wyhid")), "", rs.Fields("wyhid")) '傳遞用戶ID
rs.MoveNext
Loop
Me.StatusBar1.Panels(1) = " 共有 " & rs.RecordCount & " 條記錄被找到！"
Call CloseConn
End Sub
Private Sub ListView1_DblClick()
If ListView1.ListItems.Count <= 0 Then Exit Sub
yhxhcd = ListView1.SelectedItem.SubItems(11)
FormYHXX.Show 1
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -