frmbasicclientorderinfo.frm

企业ERP系统 采用VB+SQL2000实现。 有客户合约

            Width           =   1035
         End
         Begin VB.Label Label8 
            Caption         =   "客戶編號"
            Height          =   255
            Left            =   120
            TabIndex        =   31
            Top             =   780
            Width           =   1035
         End
         Begin VB.Label Label2 
            Caption         =   "確認價格"
            Height          =   255
            Index           =   2
            Left            =   4500
            TabIndex        =   30
            Top             =   780
            Width           =   1035
         End
         Begin VB.Label Label3 
            Caption         =   "報價"
            Height          =   255
            Index           =   1
            Left            =   120
            TabIndex        =   29
            Top             =   1200
            Width           =   1035
         End
         Begin VB.Label Label7 
            Caption         =   "打印價格"
            Height          =   255
            Left            =   4500
            TabIndex        =   28
            Top             =   1200
            Width           =   1215
         End
         Begin VB.Label Label5 
            Caption         =   "客戶簡稱"
            Height          =   255
            Left            =   4500
            TabIndex        =   27
            Top             =   360
            Width           =   1035
         End
         Begin VB.Label Label3 
            Caption         =   "成品布號"
            Height          =   255
            Index           =   0
            Left            =   120
            TabIndex        =   26
            Top             =   360
            Width           =   1035
         End
         Begin VB.Label Label24 
            Caption         =   "確認整理"
            Height          =   255
            Left            =   4500
            TabIndex        =   25
            Top             =   2100
            Width           =   915
         End
         Begin VB.Label Label25 
            Caption         =   "報價整理"
            Height          =   255
            Left            =   120
            TabIndex        =   24
            Top             =   2580
            Width           =   1035
         End
      End
   End
End
Attribute VB_Name = "frmBasicClientOrderInfo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public newItem As Boolean 'true表示增加
Private Sub ActiveBar21_ToolClick(ByVal Tool As ActiveBar2LibraryCtl.Tool)
    Select Case Tool.Name
            Case "cmdSave":
                 Save newItem
           Case "cmdCancel":
                Unload Me
    End Select
End Sub

Private Sub cmdClose_Click()
    Unload Me
End Sub



Private Sub CmdCustomer_Click()
    frmCustomerSelect.Show vbModal
    GetCustomerInfo frmCustomerSelect.CustomerNo
End Sub
'获得客户信息
Private Sub GetCustomerInfo(CustomerNo As String)
        Dim rs As ADODB.Recordset
    On Error GoTo errLabel
    Set rs = New ADODB.Recordset
    With rs
      .CursorLocation = adUseClient
      .CursorType = adOpenDynamic
      .LockType = adLockOptimistic
      Set .ActiveConnection = Cn
    End With
    rs.Open "select customerNo,CustomerName from tCustomer where customerno=" & objDatabase.FormatSQL(CustomerNo)
        If Not rs.EOF Then
            ClientCode.Text = rs.Fields!CustomerNo
            Client.Text = rs.Fields!CustomerName

        End If
    rs.Close

remClear:
    Set rs = Nothing
    Exit Sub
errLabel:
    objDatabase.DatabaseError
    GoTo remClear
End Sub

Private Sub cmdOk_Click()
    Save newItem
End Sub

Private Sub Form_Load()
    Me.Move (Screen.Width - Me.Width) \ 2, (Screen.Height - Me.Height) \ 2
End Sub
Public Sub InitInfo(strId As String)
If newItem = False Then
    Dim rs As ADODB.Recordset

      SystemExecuteStart Me
     ' On Error GoTo errLabel
      Set rs = New ADODB.Recordset
      With rs
        .CursorLocation = adUseClient
        .CursorType = adOpenDynamic
        .LockType = adLockOptimistic
        Set .ActiveConnection = Cn
      End With
      Dim strSql As String
      strSql = "select * from tBasicClientOrder where id=" & strId
      rs.Open strSql
        If Not rs.EOF Then
        productCode = NullValue(rs.Fields!productCode)
        productCode.Enabled = False
        Client = NullValue(rs.Fields!Client)
        ClientCode = NullValue(rs.Fields!ClientCode)
        ConfirmWidth = NullValue(rs.Fields!ConfirmWidth)
        QuotationWidth = NullValue(rs.Fields!QuotationWidth)
        ConfirmPrice = NullValue(rs.Fields!ConfirmPrice)
        QuotationPrice = NullValue(rs.Fields!QuotationPrice)
        ConfirmPrintPrice = NullValue(rs.Fields!ConfirmPrintPrice)
        QuotationPrintPrice = NullValue(rs.Fields!QuotationPrintPrice)
        ConfirmFinish = NullValue(rs.Fields!ConfirmFinish)
        QuotationFinish = NullValue(rs.Fields!QuotationFinish)
        Remark1 = NullValue(rs.Fields!Remark1)
        Remark2 = NullValue(rs.Fields!Remark2)
        UpdateOperator = NullValue(rs.Fields!UpdateOperator)
        UpdateDate = NullValue(rs.Fields!UpdateDate)
        txtId = NullValue(rs.Fields!ID)
        End If
      rs.Close
      Set rs = Nothing
      SystemExecuteEnd Me
End If
Exit Sub
errLabel:
    SystemExecuteEnd Me
    objDatabase.DatabaseError
End Sub
Private Sub Save(Optional blModi As Boolean)
    Dim strSql As String
    Dim rs As ADODB.Recordset
    
    strSql = "select * from tBasicClientOrder where id=" & txtId
    On Error GoTo errHandle
    Set rs = New ADODB.Recordset
    With rs
      .CursorLocation = adUseClient
      .CursorType = adOpenDynamic
      .LockType = adLockOptimistic
      Set .ActiveConnection = Cn
    End With
    If productCode.Text = "" Then
        MsgBox "產品編號不能為空！", vbCritical, "提示"
        productCode.SetFocus
        Exit Sub
    End If
    If blModi Then
        rs.Open "select * from tBasicClientOrder"
        If MsgBox("是否增加新的客戶報價？", vbQuestion + vbYesNo, "询问") = vbNo Then
            rs.Close
            Set rs = Nothing
            Exit Sub
        End If
                
        rs.AddNew '新建
        rs.Fields!productCode = Trim$(productCode)
        rs.Fields!Client = Trim$(Client)
        rs.Fields!ClientCode = Trim$(ClientCode)
        rs.Fields!ConfirmPrice = Trim$(ConfirmPrice)
        rs.Fields!ConfirmPrintPrice = Trim$(ConfirmPrintPrice)
        rs.Fields!ConfirmWidth = Trim$(ConfirmWidth)
        rs.Fields!QuotationWidth = Trim$(QuotationWidth)
        rs.Fields!ConfirmPrintPrice = Trim$(ConfirmPrintPrice)
        rs.Fields!QuotationPrintPrice = Trim$(QuotationPrintPrice)
        rs.Fields!ConfirmFinish = Trim$(ConfirmFinish)
        rs.Fields!QuotationFinish = Trim$(QuotationFinish)
        rs.Fields!Remark1 = Trim$(Remark1)
        rs.Fields!Remark2 = Trim$(Remark2)
        rs.Fields!UpdateOperator = Trim$(UpdateOperator.Text)
        rs.Fields!UpdateDate = Now
        rs.Update
        MsgBox "新建成功！", vbInformation, "恭喜'"
    Else
        rs.Open strSql
        If MsgBox("是否修改信息？", vbYesNo + vbQuestion, "修改") = vbNo Then
            rs.Close
            Set rs = Nothing
            Exit Sub
        End If
        rs.Fields!productCode = Trim$(productCode)
        rs.Fields!Client = Trim$(Client)
        rs.Fields!ClientCode = Trim$(ClientCode)
        rs.Fields!ConfirmPrice = Trim$(ConfirmPrice)
        rs.Fields!ConfirmPrintPrice = Trim$(ConfirmPrintPrice)
        rs.Fields!ConfirmWidth = Trim$(ConfirmWidth)
        rs.Fields!QuotationWidth = Trim$(QuotationWidth)
        rs.Fields!QuotationPrice = Trim$(QuotationPrice)
        rs.Fields!QuotationPrintPrice = Trim$(QuotationPrintPrice)
        rs.Fields!ConfirmFinish = Trim$(ConfirmFinish)
        rs.Fields!QuotationFinish = Trim$(QuotationFinish)
        rs.Fields!Remark1 = Trim$(Remark1)
        rs.Fields!Remark2 = Trim$(Remark2)
        rs.Fields!UpdateOperator = Trim$(UpdateOperator.Text)
        rs.Fields!UpdateDate = Now
        rs.Update
        MsgBox "修改成功！", vbInformation, "恭喜"
    End If
    rs.Close
    Set rs = Nothing
    productCode.Enabled = True
    frmBasicClientOrder.FillMshf1 ("select * from tBasicClientOrder")
    Unload Me
    Exit Sub
    
errHandle:
    Set rs = Nothing
    objDatabase.DatabaseError
End Sub

Private Sub ProductSelect_Click()
    frmBasicProductionSelect.cType = "client"
    frmBasicProductionSelect.Show
End Sub

Private Sub ViewProduct_Click()
     viewFlag = False
     frmBasicFabric.FillMshf1 ("select * from tBasicProduct where FabricCode='" & productCode & "'")
     frmBasicFabric.Show
End Sub

Private Sub ViewStock_Click()
     frmBasicStock.FillMshf1 ("select * from tBasicStock where ProductCode='" & productCode & "'")
     frmBasicStock.Show
End Sub

Private Sub ViewSupplier_Click()
     frmBasicFabricSuppliers.FillMshf1 ("select * from tBasicFabricSuppliers where ProductCode='" & productCode & "'")
     frmBasicFabricSuppliers.Show
End Sub