窗口表事件
窗口与控件事件
物料信息_Button1_Click
Dim ljh As
WinForm.TextBox = e.Form.Controls("零件号")
Dim ljzwmc As
WinForm.TextBox = e.Form.Controls("零件中文名称")
Dim gysdm As
WinForm.TextBox = e.Form.Controls("供应商代码")
Dim wljhy As
WinForm.TextBox = e.Form.Controls("物料计划员")
Tables("物料信息表").Filter="零件号
like '*"& ljh.Text & "*'"
物料信息_Button2_Click
Dim ljh As
WinForm.TextBox = e.Form.Controls("零件号")
Dim ljzwmc As
WinForm.TextBox = e.Form.Controls("零件中文名称")
Dim gysdm As
WinForm.TextBox = e.Form.Controls("供应商代码")
Dim wljhy As
WinForm.TextBox = e.Form.Controls("物料计划员")
Tables("物料信息表").Filter="零件中文名称
like '*"& ljzwmc.Text & "*'"
物料信息_Button3_Click
Dim ljh As
WinForm.TextBox = e.Form.Controls("零件号")
Dim ljzwmc As
WinForm.TextBox = e.Form.Controls("零件中文名称")
Dim gysdm As
WinForm.TextBox = e.Form.Controls("供应商代码")
Dim wljhy As
WinForm.TextBox = e.Form.Controls("物料计划员")
Tables("物料信息表").Filter="供应商代码
like '*"& gysdm.Text & "*'"
物料信息_Button4_Click
Dim ljh As
WinForm.TextBox = e.Form.Controls("零件号")
Dim ljzwmc As
WinForm.TextBox = e.Form.Controls("零件中文名称")
Dim gysdm As
WinForm.TextBox = e.Form.Controls("供应商代码")
Dim wljhy As
WinForm.TextBox = e.Form.Controls("物料计划员")
Tables("物料信息表").Filter="物料计划员
like '*"& wljhy.Text & "*'"
物料信息_Button5_Click
Forms("欢迎窗口").Open
物料信息_导出_Click
Dim Book As New
XLS.Book(ProjectPath & "Attachments\物料信息导出模板.xls")
Dim fl As String =
ProjectPath & "Reports\物料信息导出模板.xls"
Book.Build() '生成细节区
Book.Save(fl) '保存工作簿
Dim Proc As New
Process '打开工作簿
Proc.File = fl
Proc.Start()
物料信息_全部_Click
Dim ljh As
WinForm.TextBox = e.Form.Controls("零件号")
Dim ljzwmc As
WinForm.TextBox = e.Form.Controls("零件中文名称")
Dim gysdm As
WinForm.TextBox = e.Form.Controls("供应商代码")
Dim wljhy As
WinForm.TextBox = e.Form.Controls("物料计划员")
ljh.Text ="
"
ljzwmc.Text
=" "
gysdm.Text ="
"
wljhy.Text ="
"
Tables("物料信息表").Filter
=" "
物料信息窗口全部代码