main_jhgl_shrk.frm
来自「完整的物资管理系统源码」· FRM 代码 · 共 698 行 · 第 1/2 页
FRM
698 行
LCID = 2052
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 = 870.236
EndProperty
BeginProperty Column01
ColumnWidth = 2085.166
EndProperty
BeginProperty Column02
ColumnWidth = 1289.764
EndProperty
BeginProperty Column03
ColumnWidth = 780.095
EndProperty
BeginProperty Column04
ColumnWidth = 464.882
EndProperty
BeginProperty Column05
ColumnWidth = 524.976
EndProperty
BeginProperty Column06
ColumnWidth = 659.906
EndProperty
BeginProperty Column07
ColumnWidth = 675.213
EndProperty
BeginProperty Column08
ColumnWidth = 1035.213
EndProperty
BeginProperty Column09
ColumnWidth = 870.236
EndProperty
BeginProperty Column10
ColumnWidth = 1184.882
EndProperty
BeginProperty Column11
ColumnWidth = 14.74
EndProperty
BeginProperty Column12
ColumnWidth = 780.095
EndProperty
BeginProperty Column13
ColumnWidth = 569.764
EndProperty
BeginProperty Column14
ColumnWidth = 14.74
EndProperty
BeginProperty Column15
ColumnWidth = 14.74
EndProperty
BeginProperty Column16
ColumnWidth = 1425.26
EndProperty
BeginProperty Column17
ColumnWidth = 840.189
EndProperty
BeginProperty Column18
ColumnWidth = 1154.835
EndProperty
BeginProperty Column19
ColumnWidth = 824.882
EndProperty
BeginProperty Column20
ColumnWidth = 14.74
EndProperty
BeginProperty Column21
ColumnWidth = 14.74
EndProperty
EndProperty
End
Begin VB.Frame Frame2
Height = 645
Left = 15
TabIndex = 12
Top = 525
Width = 11490
Begin VB.CheckBox Check1
Height = 270
Index = 1
Left = 120
TabIndex = 16
Top = 240
Width = 255
End
Begin MSComCtl2.DTPicker DTP1
Height = 285
Left = 1245
TabIndex = 13
Top = 225
Width = 3330
_ExtentX = 5874
_ExtentY = 503
_Version = 393216
Format = 19726337
CurrentDate = 38679
End
Begin MSComCtl2.DTPicker DTP2
Height = 285
Left = 5940
TabIndex = 17
Top = 225
Width = 3330
_ExtentX = 5874
_ExtentY = 503
_Version = 393216
Format = 19726337
CurrentDate = 38679
End
Begin VB.Label Label3
Caption = "结束日期"
Height = 210
Left = 4845
TabIndex = 18
Top = 285
Width = 765
End
Begin VB.Label Label2
Caption = "开始日期"
Height = 210
Left = 480
TabIndex = 14
Top = 300
Width = 765
End
End
End
Attribute VB_Name = "main_jhgl_shrk"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public selectsql As String
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 cmdRk_Click()
cmdFind_Click
If Adodc1.Recordset.RecordCount > 0 Then
Adodc1.Recordset.MoveFirst
Do While Adodc1.Recordset.EOF = False
cnn.Execute ("update tb_kc set 数量=数量+" + DataGrid1.Columns(5) + ",单价=" + DataGrid1.Columns(6) + ",仓库='" + DataGrid1.Columns(14) + "' where 物资编号='" + DataGrid1.Columns(0) + "'and 物资名称='" + DataGrid1.Columns(1) + "'and 规格型号='" + DataGrid1.Columns(2) + "'")
cnn.Execute ("update tb_rk set 审核人='" + czy + "',审核日期='" + Str(Date) + "',状态='已审核'where 物资编号='" + DataGrid1.Columns(0) + "'and 物资名称='" + DataGrid1.Columns(1) + "'and 规格型号='" + DataGrid1.Columns(2) + "'")
Adodc1.Recordset.MoveNext
Loop
End If
End Sub
Private Sub Form_Load()
Me.Caption = text
cmdFind_Click
End Sub
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?