📄 frmcl-a.frm
字号:
AutoSize = -1 'True
Caption = "部门名称"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 210
Left = 120
TabIndex = 36
Top = 240
Width = 900
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "工作日期"
ForeColor = &H000000C0&
Height = 210
Left = 2040
TabIndex = 35
Top = 240
Width = 840
End
End
Begin MSComDlg.CommonDialog Cdlg
Left = 4560
Top = 6120
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin MSDataGridLib.DataGrid DataGrid1
Bindings = "FrmCl-A.frx":5B8C
Height = 6915
Left = 120
TabIndex = 8
Top = 240
Width = 11805
_ExtentX = 20823
_ExtentY = 12197
_Version = 393216
AllowUpdate = 0 'False
AllowArrows = 0 'False
DefColWidth = 57
HeadLines = 1
RowHeight = 15
TabAction = 2
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 2
BeginProperty Column00
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 Column01
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 = 1635.024
EndProperty
BeginProperty Column01
ColumnWidth = 1635.024
EndProperty
EndProperty
End
End
End
End
Attribute VB_Name = "FrmCl01"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim TxtSql As String
Public TjDate As String
Dim Rstmp As ADODB.Recordset
Private Sub Command1_Click()
Dim CmdExe As ADODB.Command
Set CmdExe = New ADODB.Command
CmdExe.CommandTimeout = 0
CmdExe.ActiveConnection = Cw_DataEnvi.DataConnect
If CmbBm1.ListIndex > -1 Then
CmdExe.CommandText = "execute Sc_日产量 '" & CmbBm1.Text & "','" & DTPicker0.Value & "'"
CmdExe.Execute
Else
MsgBox "请选择部门名称!"
Exit Sub
End If
If CmbBm1.Text = "放大镜铣磨" Then '(一级品+料质+留用)/送检
If Option1.Value = False Then
TxtSql = "select 工序名称,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,Bs_产品图号.硝材,sum(领一级) as 领一级,sum(领二级) as 领二级,sum(送检数) as 送检数 ,sum(一级品) as 一级品,(sum(一级品)+sum(留用数)+sum(料质数))/sum(送检数*1)*100 as 正品率,sum(二级品) as 二级品,sum(料质数) as 料质数,sum(返工数) as 返工数,sum(废品数) as 废品数,sum(留用数) as 留用数 from Sc_产量表,Bs_产品图号 where Sc_产量表.图号=Bs_产品图号.图号 group by 部门名称,工序名称,图号,Bs_产品图号.品名,Bs_产品图号.规格,Bs_产品图号.硝材 order by 工序名称,Bs_产品图号.图号"
Set Rstmp = New ADODB.Recordset
Rstmp.Open TxtSql, Cw_DataEnvi.DataConnect, adOpenStatic, adLockPessimistic, adCmdText
Set DataGrid1.DataSource = Rstmp
Else
TxtSql = "select 员工姓名,工序名称,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,硝材,sum(领一级) as 领一级,sum(领二级) as 领二级,sum(送检数) as 送检数 ,sum(一级品) as 一级品,(sum(一级品)+sum(留用数)+sum(料质数))/sum(送检数)*100 as 正品率,sum(二级品) as 二级品,sum(料质数) as 料质数,sum(返工数) as 返工数,sum(废品数) as 废品数,sum(留用数) as 留用数 from Sc_产量表,Bs_产品图号 where Sc_产量表.图号=Bs_产品图号.图号 and 部门名称='" & CmbBm1.Text & "' group by 工序名称,员工姓名,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,硝材 order by 员工姓名,Bs_产品图号.图号"
Set Rstmp = New ADODB.Recordset
Rstmp.Open TxtSql, Cw_DataEnvi.DataConnect, adOpenStatic, adLockPessimistic, adCmdText
Set DataGrid1.DataSource = Rstmp
End If
Else
If Option1.Value = False Then
TxtSql = "select 工序名称,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,Bs_产品图号.硝材,sum(领一级) as 领一级,sum(领二级) as 领二级,sum(送检数) as 送检数 ,sum(一级品) as 一级品,(sum(一级品)+sum(留用数))/sum(送检数*1)*100 as 正品率,sum(二级品) as 二级品,sum(料质数) as 料质数,sum(返工数) as 返工数,sum(废品数) as 废品数,sum(留用数) as 留用数 from Sc_产量表,Bs_产品图号 where Sc_产量表.图号=Bs_产品图号.图号 group by 部门名称,工序名称,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,Bs_产品图号.硝材 order by 工序名称,Bs_产品图号.图号"
Set Rstmp = New ADODB.Recordset
Rstmp.Open TxtSql, Cw_DataEnvi.DataConnect, adOpenStatic, adLockPessimistic, adCmdText
Set DataGrid1.DataSource = Rstmp
Else
TxtSql = "select 员工姓名,工序名称,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,硝材,sum(领一级) as 领一级,sum(领二级) as 领二级,sum(送检数) as 送检数 ,sum(一级品) as 一级品,(sum(一级品)+sum(留用数))/sum(送检数)*100 as 正品率,sum(二级品) as 二级品,sum(料质数) as 料质数,sum(返工数) as 返工数,sum(废品数) as 废品数,sum(留用数) as 留用数 from Sc_产量表,Bs_产品图号 where Sc_产量表.图号=Bs_产品图号.图号 and 部门名称='" & CmbBm1.Text & "' group by 工序名称,员工姓名,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,Bs_产品图号.硝材 order by 员工姓名,Bs_产品图号.图号"
Set Rstmp = New ADODB.Recordset
Rstmp.Open TxtSql, Cw_DataEnvi.DataConnect, adOpenStatic, adLockPessimistic, adCmdText
Set DataGrid1.DataSource = Rstmp
End If
End If
End Sub
Private Sub Command10_Click()
Cdlg.DialogTitle = "另存为Excel文件："
Cdlg.Filter = "Excel文件|*.Xls|所有文件|*.*"
Cdlg.ShowSave
If Cdlg.FileName = "" Then Exit Sub
OutTxt3.Text = Cdlg.FileName
End Sub
Private Sub Command11_Click()
Dim CmdExe As ADODB.Command
Set CmdExe = New ADODB.Command
CmdExe.ActiveConnection = Cw_DataEnvi.DataConnect
CmdExe.CommandTimeout = 0
CmdExe.CommandText = "execute Sc_车间产量 '" & DTPicker3.Value & "','" & DTPicker4.Value & "'"
CmdExe.Execute
TxtSql = "select 部门名称,BS_产品图号.图号,BS_产品图号.品名,BS_产品图号.规格,BS_产品图号.硝材,sum(领一级) as 领一级,sum(领二级) as 领二级品,sum(送检数) as 送检数 ,sum(一级品) as 一级品,sum(二级品) as 二级品,sum(料质数) as 料质数,sum(返工数) as 返工数,sum(废品数) as 废品数,sum(留用数) as 留用数 from Sc_产量表,BS_产品图号 where Sc_产量表.图号=BS_产品图号.图号 and BS_产品图号.品名 like '%" & TxtPm2.Text & "%' and BS_产品图号.规格 like '%" & TxtGg2.Text & "%' and BS_产品图号.图号 like '%" & TxtTh2.Text & "%'and 部门名称 not like '其他' group by BS_产品图号.图号,BS_产品图号.品名,BS_产品图号.规格,BS_产品图号.硝材,部门名称 order by BS_产品图号.图号,部门名称"
Set Rstmp = New ADODB.Recordset
Rstmp.Open TxtSql, Cw_DataEnvi.DataConnect, adOpenStatic, adLockPessimistic, adCmdText
Set DataGrid3.DataSource = Rstmp
End Sub
Private Sub Command2_Click()
On Error GoTo errs
Dim Rs As ADODB.Recordset
Dim ExcelApp As Excel.Application
Dim ExcelBook As Excel.Workbook
Dim ExcelSheet As Excel.Worksheet
Set ExcelApp = New Excel.Application
ExcelApp.Visible = False
Set ExcelBook = ExcelApp.Workbooks.Add
Set ExcelSheet = ExcelBook.Worksheets.Item(1)
Set Rs = New ADODB.Recordset
Rs.Open TxtSql, Cw_DataEnvi.DataConnect, , adLockPessimistic, adCmdText
RecordsetToExcel Rs, ExcelSheet
If OutTxt1.Text = "" Then
MsgBox "请指定输出文件位置和文件名！", 16, "严重错误"
Exit Sub
End If
On Error GoTo ErrSave
ExcelBook.Close True, OutTxt1.Text
MsgBox "输出成功！文件位于" & OutTxt1.Text
Rs.Close
Exit Sub
errs:
MsgBox "Select 语句错误！", 16, "严重错误"
ExcelBook.Close False
Exit Sub
ErrSave:
MsgBox "输出错误！", 16, "严重错误"
End Sub
Private Sub Command3_Click()
Cdlg.DialogTitle = "另存为Excel文件："
Cdlg.Filter = "Excel文件|*.Xls|所有文件|*.*"
Cdlg.ShowSave
If Cdlg.FileName = "" Then Exit Sub
OutTxt1.Text = Cdlg.FileName
End Sub
Private Sub Command4_Click()
Dim CmdExe As ADODB.Command
Set CmdExe = New ADODB.Command
CmdExe.CommandTimeout = 0
CmdExe.ActiveConnection = Cw_DataEnvi.DataConnect
If CmbBm1.ListIndex > -1 Then
CmdExe.CommandText = "execute Sc_日产量 '" & CmbBm1.Text & "','" & DTPicker0.Value & "'"
CmdExe.Execute
Else
MsgBox "请选择部门名称!"
Exit Sub
End If
DataReport1.Orientation = rptOrientLandscape
DataReport2.Orientation = rptOrientLandscape
If CmbBm1.Text = "放大镜铣磨" Then
If Option1.Value = 0 Then
DataReport2.Sections(2).Controls("LableTitle").Caption = "宇迪" & CStr(CmbBm1.Text) & "车间日产量报表"
DataReport2.Sections(2).Controls("LabelDate").Caption = "出表时间：" & CStr(GsdateT)
DataReport2.Sections(2).Controls("Label3").Caption = "统计日期：" & DTPicker0.Value
TxtSql = "select 工序名称,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,Bs_产品图号.硝材,sum(领一级) as 领一级,sum(领二级) as 领二级,sum(送检数) as 送检数 ,sum(一级品) as 一级品,(sum(一级品)+sum(留用数)+sum(料质数))/sum(送检数*1)*100 as 正品率,sum(二级品) as 二级品,sum(料质数) as 料质数,sum(返工数) as 返工数,sum(废品数) as 废品数,sum(留用数) as 留用数 from Sc_产量表,Bs_产品图号 where Sc_产量表.图号=Bs_产品图号.图号 group by 部门名称,工序名称,Bs_产品图号.图号,Bs_产品图号.品名,Bs_产品图号.规格,Bs_产品图号.硝材 order by 工序名称,Bs_产品图号.图号"
Set Mrc = New ADODB.Recordset
Mrc.Open TxtSql, Cw_DataEnvi.DataConnect, adOpenStatic, adLockReadOnly, adCmdText
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -