main_jhgl_jyjg.frm
来自「完整的物资管理系统源码」· FRM 代码 · 共 700 行 · 第 1/2 页
FRM
700 行
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column11
DataField = "备注"
Caption = "备注"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column12
DataField = "供货单位"
Caption = "供货单位"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column13
DataField = "经手人"
Caption = "经手人"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column14
DataField = "仓库"
Caption = "仓库"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column15
DataField = "进货票号"
Caption = "进货票号"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column16
DataField = "进货日期"
Caption = "进货日期"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column17
DataField = "送检时间"
Caption = "送检时间"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column18
DataField = "试验报告编号"
Caption = "试验报告编号"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column19
DataField = "试验单位"
Caption = "试验单位"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column20
DataField = "检验和试验结果"
Caption = "检验和试验结果"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column21
DataField = "状态"
Caption = "状态"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
ColumnWidth = 1365.165
EndProperty
BeginProperty Column01
ColumnWidth = 2085.166
EndProperty
BeginProperty Column02
ColumnWidth = 2085.166
EndProperty
BeginProperty Column03
ColumnWidth = 1365.165
EndProperty
BeginProperty Column04
ColumnWidth = 2085.166
EndProperty
BeginProperty Column05
ColumnWidth = 2085.166
EndProperty
BeginProperty Column06
ColumnWidth = 2085.166
EndProperty
BeginProperty Column07
ColumnWidth = 2085.166
EndProperty
BeginProperty Column08
ColumnWidth = 2085.166
EndProperty
BeginProperty Column09
ColumnWidth = 2085.166
EndProperty
BeginProperty Column10
ColumnWidth = 2085.166
EndProperty
BeginProperty Column11
ColumnWidth = 2085.166
EndProperty
BeginProperty Column12
ColumnWidth = 2085.166
EndProperty
BeginProperty Column13
ColumnWidth = 2085.166
EndProperty
BeginProperty Column14
ColumnWidth = 2085.166
EndProperty
BeginProperty Column15
ColumnWidth = 2085.166
EndProperty
BeginProperty Column16
ColumnWidth = 2085.166
EndProperty
BeginProperty Column17
ColumnWidth = 2085.166
EndProperty
BeginProperty Column18
ColumnWidth = 2085.166
EndProperty
BeginProperty Column19
ColumnWidth = 2085.166
EndProperty
BeginProperty Column20
ColumnWidth = 1335.118
EndProperty
BeginProperty Column21
ColumnWidth = 2085.166
EndProperty
EndProperty
End
Begin VB.Frame Frame2
Height = 645
Left = 15
TabIndex = 3
Top = 525
Width = 11490
Begin VB.CheckBox Check1
Height = 270
Index = 1
Left = 120
TabIndex = 6
Top = 240
Width = 255
End
Begin MSComCtl2.DTPicker DTP1
Height = 285
Left = 1245
TabIndex = 4
Top = 225
Width = 3330
_ExtentX = 5874
_ExtentY = 503
_Version = 393216
Format = 53280769
CurrentDate = 38679
End
Begin MSComCtl2.DTPicker DTP2
Height = 285
Left = 5940
TabIndex = 7
Top = 225
Width = 3330
_ExtentX = 5874
_ExtentY = 503
_Version = 393216
Format = 53280769
CurrentDate = 38679
End
Begin VB.Label Label3
Caption = "结束日期"
Height = 210
Left = 4890
TabIndex = 8
Top = 300
Width = 765
End
Begin VB.Label Label2
Caption = "开始日期"
Height = 210
Left = 480
TabIndex = 5
Top = 300
Width = 765
End
End
End
Attribute VB_Name = "main_jhgl_jyjg"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public selectsql As String
Private Sub cmdEnd_Click()
Unload Me
End Sub
Private Sub cmdFind_Click()
selectsql = ""
If Text1(0) <> "" Then
If selectsql <> "" Then
selectsql = "物资编号 like +'" + Text1(0) + "'+'%'and " & selectsql
Else
selectsql = "物资编号 like +'" + Text1(0) + "'+'%'"
End If
End If
If Text1(1) <> "" Then
If selectsql <> "" Then
selectsql = "物资名称 like+ '" + Text1(1) + "'+'%'and " & selectsql
Else
selectsql = "物资名称 like + '" + Text1(1) + "'+'%'"
End If
End If
If Text1(2) <> "" Then
If selectsql <> "" Then
selectsql = "规格型号 like+ '" + Text1(2) + "'+'%'and " & selectsql
Else
selectsql = "规格型号 like+ '" + Text1(2) + "'+'%'"
End If
End If
If Text1(3) <> "" Then
If selectsql <> "" Then
selectsql = "批号或炉号 like +'" + Text1(3) + "'+'%'and " & selectsql
Else
selectsql = "批号或炉号 like + '" + Text1(3) + "'+'%'"
End If
End If
If selectsql <> "" Then
If Check1(0).Value = 1 Then
Adodc1.RecordSource = "select * from tb_rk where " & selectsql & " and 检验和试验结果='无'and 状态='送检'"
Adodc1.Refresh
End If
If Check1(0).Value = 1 And Check1(1).Value = 1 Then
Adodc1.RecordSource = "select * from tb_rk where " & selectsql & " and 送检时间 between '" + Str(DTP1.Value) + "'AND '" + Str(DTP2.Value) + "'and 检验和试验结果='无'and 状态='送检'"
Adodc1.Refresh
End If
Else
If Check1(0).Value = 1 Or Check1(1).Value = 1 Then
Adodc1.RecordSource = "select * from tb_rk where 检验和试验结果='无'and 状态='送检'"
Adodc1.Refresh
End If
If Check1(0).Value = 1 And Check1(1).Value = 1 Then
Adodc1.RecordSource = "select * from tb_rk where 送检时间 between '" + Str(DTP1.Value) + "'AND '" + Str(DTP2.Value) + "'and 检验和试验结果='无'and 状态='送检'"
Adodc1.Refresh
End If
End If
If Check1(1).Value = 1 Then
Adodc1.RecordSource = "select * from tb_rk where 送检时间 between '" + Str(DTP1.Value) + "'AND '" + Str(DTP2.Value) + "'and 检验和试验结果='无'and 状态='送检'"
Adodc1.Refresh
End If
End Sub
Private Sub cmdSend_Click()
If Adodc1.Recordset.RecordCount > 0 Then
Load main_jhgl_jyjg_data
main_jhgl_jyjg_data.Show 1
Else
MsgBox "没有需要检验的物资！", , "提示窗口"
End If
End Sub
Private Sub Form_Load()
Me.Caption = text
cmdFind_Click
End Sub
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?