?? 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 + -