frmprintbig.frm

此为我2001年为东莞建发楦头开发的企业管理软件他们使用至今,望斑竹指教! 其他会员最好不要随意下载,需经斑竹同意或我本人同意,谢谢!

VERSION 5.00
Begin VB.Form Frmbig 
   BackColor       =   &H000000FF&
   BorderStyle     =   3  'Fixed Dialog
   ClientHeight    =   2055
   ClientLeft      =   2145
   ClientTop       =   1080
   ClientWidth     =   1560
   ControlBox      =   0   'False
   KeyPreview      =   -1  'True
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2055
   ScaleWidth      =   1560
   ShowInTaskbar   =   0   'False
   Begin VB.CommandButton Cmd4 
      Caption         =   "打印特殊"
      Height          =   375
      Left            =   120
      TabIndex        =   3
      Top             =   1080
      Width           =   1215
   End
   Begin VB.CommandButton Cmd3 
      Caption         =   "退出打印"
      Height          =   375
      Left            =   120
      TabIndex        =   2
      Top             =   1560
      Width           =   1215
   End
   Begin VB.CommandButton Cmd2 
      Caption         =   "打印大货"
      Height          =   375
      Left            =   120
      TabIndex        =   1
      Top             =   600
      Width           =   1215
   End
   Begin VB.CommandButton Cmd1 
      Caption         =   "打印本板"
      Height          =   375
      Left            =   120
      TabIndex        =   0
      Top             =   120
      Width           =   1215
   End
End
Attribute VB_Name = "Frmbig"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Cmd1_Click()
  On Error Resume Next
  Call pprint1(ARTi, "ti")
End Sub

Private Sub Cmd2_Click()
 
    Dim value
    Dim destb As Recordset
    Dim i As Integer
    
    db.Execute "delete  from ti_print"
    db.Execute "INSERT INTO ti_print (tino,model,model_shape,unit,qty,price,Number1,number2,number3," & _
     "Number4,number5,number6,Number7,number8,number9,Number10,number11,number12,Number13,number14,number15,Number16," & _
     "Qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10,qty11,qty12,qty13,qty14,qty15,qty16) " & _
     " SELECT tino,model,model_shape,unit,qty,price,Number1,number2,number3," & _
     "Number4,number5,number6,Number7,number8,number9,Number10,number11,number12,Number13,number14,number15,Number16," & _
     "Qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10,qty11,qty12,qty13,qty14,qty15,qty16 " & _
     " FROM ti_detail  where tino=" & "'" & frmtimas.txtFields(0).Text & "'"
        
    
    db.Execute "update ti_print set total=price*qty"
    
    Set destb = New Recordset
    destb.Open "select * from ti_print ", db, adOpenStatic, adLockOptimistic
    If destb.RecordCount <> 0 Then destb.MoveLast
    For i = 1 To (1 - (destb.RecordCount Mod 1))
        destb.AddNew
        destb!kk = "1"
        destb.UpdateBatch adAffectAllChapters
    Next
    
    db.Execute "update ti_print set qty=null where qty=0"
    db.Execute "update ti_print set price=null where price=0"
    db.Execute "update ti_print set total=null where total=0"
    
    
    ARTibig.DAO.ConnectionString = SqlConn
    ARTibig.DAO.Source = "select * from ti_print  order by model desc"
    
    
    ARTibig.lblclient.Caption = frmtimas.lblclient.Caption
    ARTibig.lbldate.Caption = frmtimas.txtFields(2).Text
    value = MsgBox("是否输出到打印?", vbQuestion + vbYesNo, MSG2)
    If value = 6 Then
        ARTibig.PrintReport False
        Unload ARTibig
    Else
        ARTibig.Show 1
    End If
    Unload Frmbig
End Sub

Private Sub Cmd3_Click()
  Unload Me
End Sub


Private Sub Cmd4_Click()
  Dim value
    Dim destb As Recordset
    Dim i As Integer
    
    db.Execute "delete  from ti_print"
    db.Execute "INSERT INTO ti_print (tino,model,model_shape,unit,qty,price,Number1,number2,number3," & _
     "Number4,number5,number6,Number7,number8,number9,Number10,number11,number12,Number13,number14,number15,Number16," & _
     "Qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10,qty11,qty12,qty13,qty14,qty15,qty16) " & _
     " SELECT tino,model,model_shape,unit,qty,price,Number1,number2,number3," & _
     "Number4,number5,number6,Number7,number8,number9,Number10,number11,number12,Number13,number14,number15,Number16," & _
     "Qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10,qty11,qty12,qty13,qty14,qty15,qty16 " & _
     " FROM ti_detail  where tino=" & "'" & frmtimas.txtFields(0).Text & "'"
        
    
    db.Execute "update ti_print set total=price*qty"
    
    Set destb = New Recordset
    destb.Open "select * from ti_print ", db, adOpenStatic, adLockOptimistic
    If destb.RecordCount <> 0 Then destb.MoveLast
    For i = 1 To (1 - (destb.RecordCount Mod 1))
        destb.AddNew
        destb!kk = "1"
        destb.UpdateBatch adAffectAllChapters
    Next
    
    db.Execute "update ti_print set qty=null where qty=0"
    db.Execute "update ti_print set price=null where price=0"
    db.Execute "update ti_print set total=null where total=0"
    
    
    ARTibig1.DAO.ConnectionString = SqlConn
    ARTibig1.DAO.Source = "select * from ti_print  order by model desc"
    
    
    ARTibig1.lblclient.Caption = frmtimas.lblclient.Caption
    ARTibig1.lbldate.Caption = frmtimas.txtFields(2).Text
    value = MsgBox("是否输出到打印?", vbQuestion + vbYesNo, MSG2)
    If value = 6 Then
        ARTibig1.PrintReport False
        Unload ARTibig1
    Else
        ARTibig1.Show 1
    End If
    Unload Frmbig
End Sub

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = vbKeyEscape Then Unload Me
End Sub

Private Sub pprint1(name As ActiveReport, mchoice As String)
   
    Dim value
    Dim destb As Recordset
    Dim i As Integer
    
    db.Execute "delete  from ti_print"
    db.Execute "INSERT INTO ti_print (tino,model,model_shape,unit,qty,price,Number1,number2,number3," & _
     "Number4,number5,number6,Number7,number8,number9,Number10,number11,number12,Number13,number14,number15,Number16," & _
     "Qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10,qty11,qty12,qty13,qty14,qty15,qty16) " & _
     " SELECT tino,model,model_shape,unit,qty,price,Number1,number2,number3," & _
     "Number4,number5,number6,Number7,number8,number9,Number10,number11,number12,Number13,number14,number15,Number16," & _
     "Qty1,qty2,qty3,qty4,qty5,qty6,qty7,qty8,qty9,qty10,qty11,qty12,qty13,qty14,qty15,qty16 " & _
     " FROM ti_detail  where tino=" & "'" & frmtimas.txtFields(0).Text & "'"
        
    
    db.Execute "update ti_print set total=price*qty"
    
    Set destb = New Recordset
    destb.Open "select * from ti_print ", db, adOpenStatic, adLockOptimistic
    If destb.RecordCount <> 0 Then destb.MoveLast
    If destb.RecordCount <> 6 Then
        For i = 1 To (6 - (destb.RecordCount Mod 6))
            destb.AddNew
            destb!kk = "1"
            destb.UpdateBatch adAffectAllChapters
        Next
    End If
    
    db.Execute "update ti_print set qty=null where qty=0"
    db.Execute "update ti_print set price=null where price=0"
    db.Execute "update ti_print set total=null where total=0"
    
    
    name.DAO.ConnectionString = SqlConn
    name.DAO.Source = "select * from ti_print  order by model desc"
    
    
    name.lblclient.Caption = frmtimas.lblclient.Caption
    name.lbldate.Caption = frmtimas.txtFields(2).Text
    value = MsgBox("是否输出到打印?", vbQuestion + vbYesNo, MSG2)
    If value = 6 Then
        name.PrintReport False
        Unload name
    Else
       Select Case mchoice
       Case "ti"
          ARTi.Show 1
       Case "tibig"
          ARTibig.Show 1
       Case "tibig1"
          ARTibig1.Show 1
       End Select
    End If
   Unload Frmbig
End Sub

Private Sub Form_Resize()
'On Error Resume Next
'Me.Top = 0
'Me.Left = 50
End Sub