fbwt_module1.bas

扬州升瑞售楼系统2000扬州升瑞售楼系统2000扬州升瑞售楼系统2000扬州升瑞售楼系统2000扬州升瑞售楼系统2000

Attribute VB_Name = "fbwt_Module1"
'Public En As rdoEnvironment
'Public fbwt_Db As New rdoConnection
'Dim CPw As rdoQuery, QSQL As String
Public fbwt_Db As Connection
Public fbwt_ConnectData As String
Public fbwt_House_ToHudongOne
Public fbwt_House_ToHudongTwo
Public fbwt_House_ToHudongThr
Public fbwt_UserQuXian          '记录用户的权限
Public fbwt_UserName
Public fbwt_UserBianHao
Public fbwt_FromPrintCome       '用来标识是否是从打印合同来的
Public fbwt_HavedQianDing As String      '用来标识这个合同已经签定为（1）是已签
Public fbwt_HavedQianDing_Combo1 '用来注册合同中的小区，幢，室号，不用前面fbwt_House_ToHudongOne的是为了防止用户不合法的操作引起系统的误用！
Public fbwt_BianLian_KeHu As String '用来跟踪客户  在签定合同时用到！！！
Public fbwt_KeZongHuTong            '用来跟踪已谈的合同情况！1为有这样一个情况！
Public fbwt_IntJIngDu '用来记录得到数据的进程
Public fbwt_Int_AllQueTian         '用来跟踪在显示所有的洽谈的合同的标识
Public fbwt_Int_AllQianDing         '用来跟踪在显示所有的签定的合同的标识
Public fbwt_StrYixianHutong '标识是从意向合同来得到的新的合同
Public StrLabel18 As String
Public StrQianDingOld As String
Public strFbwtBianhao As String
Public strFbwtXiaoqu As String
Public strFbwtKehu As String
Public strFbwtDongHao As String
Public strFbwtShiHao As String
Public StrFbwt_YiXiang As String
Public strMoney As Double

Public ServerName As String '服务器名称

Public strEditTable As String
Public Enum PrinterOrientationConstants
        OrientPortrait = 1
        OrientLandscape = 2
End Enum
Private Type DEVMODE
        dmDeviceName As String * 32
        dmSpecVersion As Integer
        dmDriverVersion As Integer
        dmSize As Integer
        dmDriverExtra As Integer
        dmFields As Long
        dmOrientation As Integer
        dmPaperSize As Integer
        dmPaperLength As Integer
        dmPaperWidth As Integer
        dmScale As Integer
        dmCopies As Integer
        dmDefaultSource As Integer
        dmPrintQuality As Integer
        dmColor As Integer
        dmDuplex As Integer
        dmYResolution As Integer
        dmTTOption As Integer
        dmCollate As Integer
        dmFormName As String * 32
        dmUnusedPadding As Integer
        dmBitsPerPel As Integer
        dmPelsWidth As Long
        dmPelsHeight As Long
        dmDisplayFlags As Long
        dmDisplayFrequency As Long
End Type
Private Type PRINTER_DEFAULTS
        pDataType As String
        pDevMode As Long
        DesiredAccess As Long
End Type
Private Type PRINTER_INFO_2
        pServerName As Long
        pPrinterName As Long
        pShareName As Long
        pPortName As Long
        pDriverName As Long
        pComment As Long
        pLocation As Long
        pDevMode As Long
        pSepFile As Long
        pPrintProcessor As Long
        pDataType As Long
        pParameters As Long
        pSecurityDescriptor As Long
        Attributes As Long
        Priority As Long
        DefaultPriority As Long
        StartTime As Long
        UntilTime As Long
        Status As Long
        cJobs As Long
        AveragePPM As Long
End Type

Public Const DMPAPER_A5 = 11

Private Const DM_IN_BUFFER As Long = 8
Private Const DM_OUT_BUFFER As Long = 2
Private Const DM_ORIENTATION As Long = &H1
Private Const DM_PAPERSIZE = &H2&

Private Const PRINTER_ACCESS_ADMINISTER As Long = &H4
Private Const PRINTER_ACCESS_USE As Long = &H8
Private Const STANDARD_RIGHTS_REQUIRED As Long = &HF0000
Private Const PRINTER_ALL_ACCESS = (STANDARD_RIGHTS_REQUIRED _
    Or _
    PRINTER_ACCESS_ADMINISTER Or PRINTER_ACCESS_USE)

Private Declare Sub CopyMemory Lib "kernel32" Alias _
    "RtlMoveMemory" _
    (hpvDest As Any, hpvSource As Any, ByVal _
    cbCopy As Long)

Private Declare Function OpenPrinter Lib "winspool.drv" Alias _
        "OpenPrinterA" (ByVal pPrinterName As String, phPrinter As _
        Long, pDefault As Any) As Long

Private Declare Function ClosePrinter Lib "winspool.drv" _
        (ByVal hPrinter As Long) As Long

Private Declare Function DocumentProperties Lib "winspool.drv" _
        Alias "DocumentPropertiesA" (ByVal hWnd As Long, ByVal hPrinter _
    As Long, _
        ByVal pDeviceName As String, pDevModeOutput As _
    Any, _
    pDevModeInput As Any, _
        ByVal fMode As Long) As Long

Private Declare Function GetPrinter Lib "winspool.drv" _
        Alias "GetPrinterA" (ByVal hPrinter As Long, ByVal Level As Long, _
        pPrinter As Any, ByVal cbBuf As Long, pcbNeeded As Long) As _
    Long

Private Declare Function SetPrinter Lib "winspool.drv" _
        Alias "SetPrinterA" (ByVal hPrinter As Long, ByVal Level As Long, _
        pPrinter As Any, ByVal Command As Long) As Long
Function fbwt_DataConnect()
'Private Conn As String
'Set En = rdoEnvironments(0)
'Conn = "uid=sa;pwd=sa;server=fbwt;driver={SQL Server};database=房产发展管理系统;DSN='';"
'Set fbwt_Db = En.OpenConnection(dsName:="", Prompt:=rdDriverNoPrompt, Connect:=Conn)
fbwt_ConnectData = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=房产发展管理系统;Data Source='" & ServerName & "'"
End Function


Function KeyA(KeyAscii As Integer)
 If KeyAscii > 47 And KeyAscii < 58 Or KeyAscii = 8 Or KeyAscii = 46 Then
 Else
 MsgBox ("请输入数据字"), vbInformation, "提醒"
 KeyAscii = "1"
 Exit Function
 End If
End Function
Function Nkey(KeyAscii As Integer)
KeyAscii = 0
End Function




Function SetDefaultPrinterOrientation(ByVal eOrientation As _
    PrinterOrientationConstants) As Boolean

        Dim bDevMode() As Byte
        Dim bPrinterInfo2() As Byte
        Dim hPrinter As Long
        Dim lResult As Long
        Dim nSize As Long
        Dim sPrnName As String
        Dim dm As DEVMODE
        Dim pd As PRINTER_DEFAULTS
        Dim pi2 As PRINTER_INFO_2

        ' 获取默认打印机的设备名称
        sPrnName = Printer.DeviceName
        ' 由于要调用SetPrinter，所以
        ' 如果是在NT下就要求PRINTER_ALL_ACCESS
        pd.DesiredAccess = PRINTER_ALL_ACCESS

        ' 获取打印机句柄
        If OpenPrinter(sPrnName, hPrinter, pd) Then
                ' 获取PRINTER_INFO_2结构要求的字节数

               Call GetPrinter(hPrinter, 2&, 0&, 0&, nSize)
                ReDim bPrinterInfo2(1 To nSize) As Byte
                lResult = GetPrinter(hPrinter, 2, bPrinterInfo2(1), nSize, nSize)
                Call CopyMemory(pi2, bPrinterInfo2(1), Len(pi2))
                nSize = DocumentProperties(0&, hPrinter, sPrnName, 0&, 0&, 0)
                      ReDim bDevMode(1 To nSize)
                If pi2.pDevMode Then
                        Call CopyMemory(bDevMode(1), ByVal pi2.pDevMode, Len(dm))
                Else
                        Call DocumentProperties(0&, hPrinter, sPrnName, bDevMode(1), 0&, DM_OUT_BUFFER)
                End If

                Call CopyMemory(dm, bDevMode(1), Len(dm))
                With dm
                        ' 设置新的走向
                        .dmOrientation = eOrientation
                        .dmFields = DM_ORIENTATION
                        '.dmPaperSize = DMPAPER_A5 将纸张大小设为A5，请自行更改所需大小
                        '.dmFields = DM_PAPERSIZE  必须，否则无法设置纸张大小
                End With
                Call CopyMemory(bDevMode(1), dm, Len(dm))

                Call DocumentProperties(0&, hPrinter, sPrnName, _
                        bDevMode(1), bDevMode(1), DM_IN_BUFFER Or _
                        DM_OUT_BUFFER)

                pi2.pDevMode = VarPtr(bDevMode(1))

                lResult = SetPrinter(hPrinter, 2, pi2, 0&)

                Call ClosePrinter(hPrinter)
                SetDefaultPrinterOrientation = True
        Else
                SetDefaultPrinterOrientation = False
        End If

End Function


Function DropYiXiang(Biao As Integer, BianHaoOne)
Dim fbwt_Rs As Recordset
Dim fbwt_str As String
Dim i As Integer
Set fbwt_Db = New Connection
Set fbwt_Rs = New Recordset
Call fbwt_DataConnect

fbwt_Db.CursorLocation = adUseClient
fbwt_Db.Open fbwt_ConnectData
For i = 0 To Biao
fbwt_Db.Execute "delete * from yi" & i & " where bianhao='" & BianHaoOne & "'"
Next
End Function

Function DropHutong()
     Dim fbwt_Rs As Recordset
     Dim fbwt_StrOne As String
     Set fbwt_Rs = New Recordset
     Set fbwt_Db = New Connection
     fbwt_StrOne = " "
     Call fbwt_DataConnect
     fbwt_Db.CursorLocation = adUseClient
     fbwt_Db.Open fbwt_ConnectData
     fbwt_Rs.Open "select * from qi0 where hutongbianhao not in(select hutongbianhao from qi20)", fbwt_Db, adOpenStatic
     If fbwt_Rs.BOF And fbwt_Rs.EOF Then
     Else
         For i = 0 To 19
         fbwt_Db.Execute "delete * from qi" & i & " where hutongbianhao not in(select hutongbianhao from qi20)"
         Next

         fbwt_Db.Execute "delete * from qi22 where hutongbianhao not in(select hutongbianhao from qi20)"
         fbwt_Db.Execute "delete * from qi23 where hutongbianhao not in(select hutongbianhao from qi20)"
     End If
     
     
End Function