pset.frm

检定证书的管理打印程序VB6+ace

VERSION 5.00
Begin VB.Form priset 
   ClientHeight    =   1770
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5595
   LinkTopic       =   "Form1"
   ScaleHeight     =   1770
   ScaleWidth      =   5595
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command3 
      Caption         =   "打印背面"
      Height          =   375
      Left            =   3960
      TabIndex        =   4
      Top             =   1080
      Width           =   1335
   End
   Begin VB.CommandButton Command2 
      Caption         =   "打印正面"
      Height          =   375
      Left            =   2160
      TabIndex        =   3
      Top             =   1080
      Width           =   1215
   End
   Begin VB.CommandButton Command1 
      Caption         =   "设置打印机"
      Height          =   375
      Left            =   360
      TabIndex        =   2
      Top             =   1080
      Width           =   1215
   End
   Begin VB.ComboBox Combo1 
      Height          =   300
      Left            =   1440
      TabIndex        =   0
      Top             =   240
      Width           =   3975
   End
   Begin VB.Label Label1 
      Caption         =   "选择打印机"
      Height          =   255
      Left            =   360
      TabIndex        =   1
      Top             =   240
      Width           =   975
   End
End
Attribute VB_Name = "priset"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Combo1_Click()
On Error GoTo err1
conn.BeginTrans
strsql1 = "UPDATE dyjwz set wz80 ='" & 0 & "' WHERE wz80= " & 1
strsql2 = "UPDATE dyjwz set wz80 ='" & 1 & "' WHERE dyjm= '" & Combo1.Text & "'"
conn.Execute strsql1
conn.Execute strsql2
conn.CommitTrans
err1:
End Sub

Private Sub Command1_Click()
setp.Show 1
End Sub

Private Sub Command2_Click()
If Len(Combo1.Text) = 0 Then
    an = MsgBox("请选择要用的打印机", vbYes, "提示!!!!!!!")



Else
    strsql = "select * from  dyjwz where  dyjm='" & Trim(Combo1.Text) & "'"
    grs.Open strsql, conn, adOpenKeyset, adLockReadOnly, adCmdText
    If grs.RecordCount = 0 Then
       an = MsgBox("要用的打印机没维护,请从新选择或维护", vbYes, "提示!!!!!!!")
    Else
         priint
        
         For i = 0 To 11
            pril(i).X = pril(i).X + grs.Fields(4 * i + 1)
            pril(i).Y = pril(i).Y + grs.Fields(4 * i + 2)
            pril(i).l = pril(i).l + grs.Fields(4 * i + 3)
            pril(i).h = pril(i).h + grs.Fields(4 * i + 4)
         Next i
        
        
    End If
    grs.Close
    prijdzs
End If
End Sub

Private Sub Command3_Click()
If Len(Combo1.Text) = 0 Then
    an = MsgBox("请选择要用的打印机", vbYes, "提示!!!!!!!")



Else
    strsql = "select * from  dyjwz where  dyjm='" & Trim(Combo1.Text) & "'"
    grs.Open strsql, conn, adOpenKeyset, adLockReadOnly, adCmdText
    If grs.RecordCount = 0 Then
       an = MsgBox("要用的打印机没维护,请从新选择或维护", vbYes, "提示!!!!!!!")
    Else
       
         intb
          For i = 0 To 3
            pjlqj(i).X = pjlqj(i).X + grs.Fields(4 * (13 + i) + 1)
            pjlqj(i).Y = pjlqj(i).Y + grs.Fields(4 * (13 + i) + 2)
            pjlqj(i).l = pjlqj(i).l + grs.Fields(4 * (13 + i) + 3)
            pjlqj(i).h = pjlqj(i).h + grs.Fields(4 * (13 + i) + 4)
         Next i
         For i = 12 To 14
            pril(i).X = pril(i).X + grs.Fields(4 * (i + 4) + 1)
            pril(i).Y = pril(i).Y + grs.Fields(4 * (i + 4) + 2)
            pril(i).l = pril(i).l + grs.Fields(4 * (i + 4) + 3)
            pril(i).h = pril(i).h + grs.Fields(4 * (i + 4) + 4)
         Next i
            pjdjg.X = pjdjg.X + grs.Fields(4 * 19 + 1)
            pjdjg.Y = pjdjg.Y + grs.Fields(4 * 19 + 2)
            pjdjg.h = pjdjg.h + grs.Fields(4 * 19 + 3)
            pjdjg.l = pjdjg.l + grs.Fields(4 * 19 + 4)
        
    End If
    grs.Close
    pjdzsb
End If
End Sub

Private Sub Form_Load()
Me.Move (main.Width - Me.Width) / 2, (main.Height - Me.Height) / 2
strsql = "select wz80,dyjm from  dyjwz"
grs.Open strsql, conn, adOpenKeyset, adLockReadOnly, adCmdText
fillcombo Combo1, grs
If grs.BOF And grs.EOF Then
Else
  grs.MoveFirst
  For i = 0 To grs.RecordCount - 1
      If grs.Fields(0) = 1 Then
         Combo1.Text = grs.Fields(1)
      End If
      grs.MoveNext
  Next i
  
End If
grs.Close
End Sub