📄 producedrawmaterialprint.dsr
字号:
Object.Left = 1701
Object.Top = 1800
Object.Width = 1140
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "物料数量"
Alignment = 2
EndProperty
ItemType18 = 3
BeginProperty Item18 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Label21"
Object.Left = 2835
Object.Top = 1800
Object.Width = 1140
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "当前库存"
Alignment = 2
EndProperty
ItemType19 = 3
BeginProperty Item19 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Label23"
Object.Left = 5102
Object.Top = 1800
Object.Width = 1140
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "领取数量"
Alignment = 2
EndProperty
ItemType20 = 3
BeginProperty Item20 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Label8"
Object.Left = 3969
Object.Top = 1800
Object.Width = 1140
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "已领数量"
Alignment = 2
EndProperty
ItemType21 = 6
BeginProperty Item21 {1C13A8E4-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Shape4"
Object.Left = 567
Object.Top = 1800
Object.Width = 5670
Object.Height = 300
EndProperty
ItemType22 = 6
BeginProperty Item22 {1C13A8E4-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Shape5"
Object.Left = 1701
Object.Top = 1800
Object.Width = 3405
Object.Height = 300
EndProperty
ItemType23 = 6
BeginProperty Item23 {1C13A8E4-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Shape6"
Object.Left = 2835
Object.Top = 1800
Object.Width = 1140
Object.Height = 300
EndProperty
EndProperty
SectionCode2 = 4
BeginProperty Section2 {1C13A8E0-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Section1"
Object.Height = 300
NumControls = 8
ItemType0 = 4
BeginProperty Item0 {1C13A8E2-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Text1"
Object.Left = 567
Object.Width = 1134
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Alignment = 2
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
ItemType1 = 4
BeginProperty Item1 {1C13A8E2-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Text2"
Object.Left = 1701
Object.Width = 1134
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Alignment = 2
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
ItemType2 = 4
BeginProperty Item2 {1C13A8E2-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Text3"
Object.Left = 2835
Object.Width = 1134
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Alignment = 2
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
ItemType3 = 4
BeginProperty Item3 {1C13A8E2-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Text5"
Object.Left = 5102
Object.Width = 1140
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Alignment = 2
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
ItemType4 = 4
BeginProperty Item4 {1C13A8E2-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Text4"
Object.Left = 3969
Object.Width = 1125
Object.Height = 270
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Alignment = 2
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
ItemType5 = 6
BeginProperty Item5 {1C13A8E4-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Shape8"
Object.Left = 1701
Object.Width = 3405
Object.Height = 300
EndProperty
ItemType6 = 6
BeginProperty Item6 {1C13A8E4-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Shape9"
Object.Left = 2835
Object.Width = 1125
Object.Height = 300
EndProperty
ItemType7 = 6
BeginProperty Item7 {1C13A8E4-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Shape7"
Object.Left = 567
Object.Width = 5670
Object.Height = 300
EndProperty
EndProperty
SectionCode3 = 7
BeginProperty Section3 {1C13A8E0-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Section3"
NumControls = 0
EndProperty
SectionCode4 = 8
BeginProperty Section4 {1C13A8E0-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Section5"
NumControls = 0
EndProperty
End
Attribute VB_Name = "producedrawmaterialprint"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Attribute VB_Ext_KEY = "RVB_ModelStereotype" ,"DataReport"
'**************************************
'* 模 块 名 称 :应用程序启动窗体
'* 功 能 描 述 :应用程序启动窗体
'* 程序员姓名 : 石春晓
'* 最后修改人 : 陈齐国
'* 最后修改时间:2005/09/17
'**************************************
Option Explicit
Private m_print As producedrawmaterialDAO ' 库位数据库操作类
Private m_recordset As ADODB.Recordset ' 数据操作数据集对象
Private g_recordset As ADODB.Recordset
Private m_produceDAO As ProduceDAO
'**************************************
'* 功 能 描 述 :查找打印数据并与打印控件帮定
'* 输 入 参 数 :operaterType - 1 打印所有
'* 输 出 能 数 :无
'**************************************
Public Function PrintData(producedrawid As String)
Dim ret As Boolean
Dim txt As New Collection
Dim ctl As Object
Dim sum As Double
sum = 0
ret = m_print.FindById(m_recordset, Trim(producedrawid))
Set Me.DataSource = m_recordset
Me.Sections("section2").Controls("Label2").caption = m_recordset.Fields("领料日期")
Me.Sections("section2").Controls("Label11").caption = m_recordset.Fields("员工")
Me.Sections("section2").Controls("Label12").caption = m_recordset.Fields("生产编号")
Me.Sections("section2").Controls("Label13").caption = m_recordset.Fields("原料名称")
Me.Sections("section2").Controls("Label18").caption = m_recordset.Fields("领料日期")
Me.Sections("section2").Controls("Label17").caption = m_recordset.Fields("仓库名称")
Me.Sections("section2").Controls("Label15").caption = m_recordset.Fields("生产数量")
ret = m_produceDAO.producedetailmaterial_serial(g_recordset, Trim(producedrawid))
Set Me.DataSource = g_recordset '显示物料信息
'
' ret = m_positionDAO.position_ouputposition(f_recordset, Trim(m_recordset.Fields("warehouseid")), Trim(g_recordset.Fields("matrialId")))
' Set Me.DataSource = f_recordset '当前物料0库存量
'
'
' ret = m_produceDAO.ProduceDrawMaterial_findtotalnum(n_recordset, Trim(g_recordset.Fields("matrialId")), Trim(g_recordset.Fields("bomid")))
' Set Me.DataSource = n_recordset '物料已领取数量
' If ret Then
' Do While Not n_recordset.EOF
' sum = sum + Trim(n_recordset.Fields("totalNum"))
' n_recordset.MoveNext
' Loop
' End If
Me.Sections("section1").Controls.Item("text1").DataField = Trim(g_recordset.Fields("物料名称").name & " ")
Me.Sections("section1").Controls.Item("text2").DataField = Trim(g_recordset.Fields("物料数量").name & " ")
Me.Sections("section1").Controls.Item("text3").DataField = Trim(g_recordset.Fields("当前库存").name & " ") '当前库存
Me.Sections("section1").Controls.Item("text4").DataField = Trim(g_recordset.Fields("物料总和").name & " ")
Me.Sections("section1").Controls.Item("text5").DataField = Trim(g_recordset.Fields("领取数量").name & " ")
End Function
Private Sub DataReport_Initialize()
Set m_print = New producedrawmaterialDAO
Set m_recordset = New ADODB.Recordset
Set g_recordset = New ADODB.Recordset
Set m_produceDAO = New ProduceDAO
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -