?? frmoutput.frm

?? 醫(yī)院信息管理系統(tǒng)
?? FRM
?? 第 1 頁 / 共 3 頁
字號(hào):
上一頁 1 23
      BackStyle       =   0  'Transparent
      Caption         =   "調(diào)撥部門"
      Height          =   180
      Left            =   120
      TabIndex        =   40
      Top             =   150
      Width           =   720
   End
End
Attribute VB_Name = "frmoutput"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public jg As Currency
Public shu1 As Integer
Public shuliang As Integer
Public Sub zybdb()
On Error GoTo err1
With Adodc3
    .RecordSource = "select * from zybyf where 編號(hào)='" & Text7.Text & "'"
    .Refresh
    .Recordset.Fields("編號(hào)") = Text7.Text
    .Recordset.Fields("名稱") = Text8.Text
    .Recordset.Fields("規(guī)格") = Text6(2).Text
    .Recordset.Fields("單位") = Text6(3).Text
    .Recordset.Fields("數(shù)量") = .Recordset.Fields("數(shù)量") + Text1.Text
    .Recordset.Fields("零售價(jià)") = Text6(5).Text
    .Recordset.Fields("零售合計(jì)") = .Recordset.Fields("數(shù)量") * Text6(5)
    .Recordset.Fields("產(chǎn)地") = Text6(6).Text
    .Recordset.Fields("批號(hào)") = Text6(7).Text
    rq1 = Text6(8).Text & "-" & Text6(9).Text & "-" & Text6(10).Text
    .Recordset.Fields("失效期") = CDate(rq1)
    .Recordset.Fields("調(diào)撥人") = Text5.Text
    rq2 = Text2.Text & "-" & Text3.Text & "-" & Text4.Text
    .Recordset.Fields("調(diào)入日期") = CDate(rq2)
    .Recordset.Update
End With
Exit Sub
err1:
MsgBox "當(dāng)前數(shù)據(jù)庫不能更新或數(shù)據(jù)庫連接失敗！"
End Sub
Public Sub mzdb()
On Error GoTo err2
With Adodc2
    .RecordSource = "select * from yaofang where 編號(hào)='" & Text7.Text & "'"
    .Refresh
    .Recordset.Fields("編號(hào)") = Text7.Text
    .Recordset.Fields("名稱") = Text8.Text
    .Recordset.Fields("規(guī)格") = Text6(2).Text
    .Recordset.Fields("單位") = Text6(3).Text
    .Recordset.Fields("數(shù)量") = .Recordset.Fields("數(shù)量") + Text1.Text
    .Recordset.Fields("零售價(jià)") = Text6(5).Text
    .Recordset.Fields("零售合計(jì)") = .Recordset.Fields("數(shù)量") * Text6(5)
    .Recordset.Fields("產(chǎn)地") = Text6(6).Text
    .Recordset.Fields("批號(hào)") = Text6(7).Text
    rq1 = Text6(8).Text & "-" & Text6(9).Text & "-" & Text6(10).Text
    .Recordset.Fields("失效期") = CDate(rq1)
    .Recordset.Fields("調(diào)撥人") = Text5.Text
    rq2 = Text2.Text & "-" & Text3.Text & "-" & Text4.Text
    .Recordset.Fields("調(diào)入日期") = CDate(rq2)
    .Recordset.Update
End With
Exit Sub
err2:
MsgBox "當(dāng)前數(shù)據(jù)庫不能更新或數(shù)據(jù)庫連接失敗！"
End Sub
Public Sub dyyp()
On Error GoTo err3
With Adodc4
.RecordSource = "select * from ypdb order by ID"
.Refresh
.Recordset.AddNew
.Recordset.Fields("編號(hào)") = Text7.Text
.Recordset.Fields("名稱") = Text8.Text
.Recordset.Fields("規(guī)格") = Text6(2).Text
.Recordset.Fields("單位") = Text6(3).Text
.Recordset.Fields("數(shù)量") = Text1.Text
.Recordset.Fields("零售價(jià)") = Text6(5).Text
.Recordset.Fields("進(jìn)價(jià)") = jg
.Recordset.Fields("產(chǎn)地") = Text6(6).Text
.Recordset.Fields("批號(hào)") = Text6(7).Text
.Recordset.Fields("調(diào)撥部門") = Combo1.Text
rq3 = Text6(8).Text & "-" & Text6(9).Text & "-" & Text6(10).Text
.Recordset.Fields("失效期") = CDate(rq3)
.Recordset.Fields("調(diào)撥人") = Text5.Text
rq4 = Text2.Text & "-" & Text3.Text & "-" & Text4.Text
.Recordset.Fields("調(diào)撥日期") = CDate(rq4)
.Recordset.Fields("備注") = Text9.Text
.Recordset.Update
End With
With Adodc1
.RecordSource = "select * from kcyp where 編號(hào)='" & Text7.Text & "'"
.Refresh
shu1 = Text6(4) - Text1.Text
.Recordset.Fields("數(shù)量") = shu1
.Recordset.Fields("零售合計(jì)") = .Recordset.Fields("零售價(jià)") * shu1
.Recordset.Fields("進(jìn)價(jià)合計(jì)") = .Recordset.Fields("進(jìn)價(jià)") * shu1
.Recordset.Fields("差額") = .Recordset.Fields("零售合計(jì)") - .Recordset.Fields("進(jìn)價(jià)合計(jì)")
.Recordset.Update
End With
Command1.Enabled = False
Exit Sub
err3:
MsgBox "當(dāng)前數(shù)據(jù)庫不能更新或數(shù)據(jù)庫連接失??！"
End Sub

Private Sub Combo1_Click()
Text7.Enabled = True
Text5.Text = ""
End Sub

Private Sub Command1_Click()
Dim rq1 As String
Dim rq2 As String
Dim rq3 As String
Dim rq4 As String
On Error GoTo err4
If Text1.Text <= shuliang Then
    If Text1.Text = 0 Or Text2.Text = "" Or Text5.Text = "" Or Combo1.Text = "" Then
        MsgBox "調(diào)撥數(shù)量不能為零，調(diào)撥日期和調(diào)撥人必須填寫！"
    Else
        If Combo1.Text = "門診藥房" Then
          With Adodc2
         .RecordSource = "select * from yaofang where 編號(hào)='" & Text7.Text & "'"
         .Refresh
            If .Recordset.AbsolutePosition <> adPosUnknown Then
                 If .Recordset.Fields("數(shù)量") = 0 Then
                     Call mzdb
                     Call dyyp
                 Else
                     If .Recordset.Fields("失效標(biāo)記") = True Then
                         MsgBox "門診藥房中該藥品已經(jīng)失效，清除后才能調(diào)撥！"
                     Else
                         If Trim(.Recordset.Fields("規(guī)格")) <> Trim(CStr(Text6(2).Text)) Or CCur(.Recordset.Fields("零售價(jià)")) <> CCur(Text6(5).Text) Then
                             MsgBox "調(diào)出藥品的規(guī)格或零售價(jià)與藥房中的不一致！"
                         Else
                             Call mzdb
                             Call dyyp
                         End If
                     End If
                  End If
            Else
                 .Recordset.AddNew
                 .Recordset.Fields("編號(hào)") = Text7.Text
                 .Recordset.Fields("名稱") = Text8.Text
                 .Recordset.Fields("規(guī)格") = Text6(2).Text
                 .Recordset.Fields("單位") = Text6(3).Text
                 .Recordset.Fields("數(shù)量") = Text1.Text
                 .Recordset.Fields("零售價(jià)") = Text6(5).Text
                 .Recordset.Fields("零售合計(jì)") = Text1.Text * Text6(5)
                 .Recordset.Fields("產(chǎn)地") = Text6(6).Text
                 .Recordset.Fields("批號(hào)") = Text6(7).Text
                 rq1 = Text6(8).Text & "-" & Text6(9).Text & "-" & Text6(10).Text
                 .Recordset.Fields("失效期") = CDate(rq1)
                 .Recordset.Fields("調(diào)撥人") = Text5.Text
                 rq2 = Text2.Text & "-" & Text3.Text & "-" & Text4.Text
                 .Recordset.Fields("調(diào)入日期") = CDate(rq2)
                 .Recordset.UpdateBatch
                 Call dyyp
            End If
          End With
        End If
        '住院部藥房
        If Combo1.Text = "住院部藥房" Then
          With Adodc3
         .RecordSource = "select * from zybyf where 編號(hào)='" & Text7.Text & "'"
         .Refresh
             If .Recordset.AbsolutePosition <> adPosUnknown Then
                 If .Recordset.Fields("數(shù)量") = 0 Then
                     Call zybdb
                     Call dyyp
                 Else
                     If .Recordset.Fields("失效標(biāo)記") = True Then
                         MsgBox "門診藥房中該藥品已經(jīng)失效，清除后才能調(diào)撥！"
                     Else
                         If Trim(.Recordset.Fields("規(guī)格")) <> Trim(CStr(Text6(2).Text)) Or CCur(.Recordset.Fields("零售價(jià)")) <> CCur(Text6(5).Text) Then
                             MsgBox "調(diào)出藥品的規(guī)格或零售價(jià)與藥房中的不一致！"
                         Else
                             Call zybdb
                             Call dyyp
                         End If
                     End If
                  End If
              Else
                 .Recordset.AddNew
                 .Recordset.Fields("編號(hào)") = Text7.Text
                 .Recordset.Fields("名稱") = Text8.Text
                 .Recordset.Fields("規(guī)格") = Text6(2).Text
                 .Recordset.Fields("單位") = Text6(3).Text
                 .Recordset.Fields("數(shù)量") = Text1.Text
                 .Recordset.Fields("零售價(jià)") = Text6(5).Text
                 .Recordset.Fields("零售合計(jì)") = Text1.Text * Text6(5)
                 .Recordset.Fields("產(chǎn)地") = Text6(6).Text
                 .Recordset.Fields("批號(hào)") = Text6(7).Text
                 rq1 = Text6(8).Text & "-" & Text6(9).Text & "-" & Text6(10).Text
                 .Recordset.Fields("失效期") = CDate(rq1)
                 .Recordset.Fields("調(diào)撥人") = Text5.Text
                 rq2 = Text2.Text & "-" & Text3.Text & "-" & Text4.Text
                 .Recordset.Fields("調(diào)入日期") = CDate(rq2)
                 .Recordset.UpdateBatch
                 Call dyyp
             End If
           End With
        End If
        If Combo1.Text <> "" And Combo1.Text <> "門診藥房" And Combo1.Text <> "住院部藥房" Then
          Call dyyp
        End If
    End If
    Text1.Text = 0
    Text7.Text = ""
    result.Caption = "提示：調(diào)撥登記成功！"
Else
    MsgBox "調(diào)出藥品大于庫存量！當(dāng)前藥品庫存量為：" & Text6(4).Text & Text6(3).Text
    result.Caption = "提示：調(diào)撥登記失?。?quot;
    'Command1.Enabled = False
End If
Exit Sub
err4:
MsgBox "數(shù)據(jù)類型不匹配或庫存數(shù)據(jù)出錯(cuò)！"
End Sub

Private Sub Command3_Click()
Unload Me
End Sub

Private Sub Form_Load()
On Error GoTo err5
frmoutput.Top = (frmmain.Height - frmoutput.Height) / 2 - 500
frmoutput.Left = (frmmain.Width - frmoutput.Width) / 2
Adodc1.ConnectionString = frmlogin.conn
Adodc2.ConnectionString = frmlogin.conn
Adodc3.ConnectionString = frmlogin.conn
Adodc4.ConnectionString = frmlogin.conn
Adodc5.ConnectionString = frmlogin.conn
Command1.Enabled = False
Text7.Enabled = False
Text2.Text = Year(Date)
Text3.Text = Month(Date)
Text4.Text = Day(Date)
With Adodc1
.RecordSource = "select * from kcyp where 失效標(biāo)記=false"
.Refresh
For i = 0 To .Recordset.RecordCount
If Not .Recordset.EOF Then
    If .Recordset.Fields("失效期") <= Date Then
        .Recordset.Fields("失效標(biāo)記") = True
        .Recordset.Update
    Else
        .Recordset.Fields("失效標(biāo)記") = False
        .Recordset.Update
    End If
.Recordset.MoveNext
End If
Next
End With
With Adodc2
.RecordSource = "select * from yaofang where 失效標(biāo)記=false"
.Refresh
For i = 0 To .Recordset.RecordCount
If Not .Recordset.EOF Then
    If .Recordset.Fields("失效期") <= Date Then
        .Recordset.Fields("失效標(biāo)記") = True
        .Recordset.Update
    Else
        .Recordset.Fields("失效標(biāo)記") = False
        .Recordset.Update
    End If
.Recordset.MoveNext
End If
Next
End With
With Adodc3
.RecordSource = "select * from zybyf where 失效標(biāo)記=false"
.Refresh
For i = 0 To .Recordset.RecordCount
If Not .Recordset.EOF Then
    If .Recordset.Fields("失效期") <= Date Then
        .Recordset.Fields("失效標(biāo)記") = True
        .Recordset.Update
    Else
        .Recordset.Fields("失效標(biāo)記") = False
        .Recordset.Update
    End If
.Recordset.MoveNext
End If
Next
End With
Text9.Text = "無"
Text1.Text = 0
Exit Sub
err5:
MsgBox "數(shù)據(jù)庫連接失敗！"
End Sub

Private Sub Text7_Change()
'庫存為零時(shí)不能調(diào)撥藥品
On Error GoTo err6
With Adodc1
.RecordSource = "select * from kcyp where 編號(hào)='" & Text7.Text & "' and 失效標(biāo)記=false"
.Refresh
If .Recordset.AbsolutePosition <> adPosUnknown Then
Text8.Text = .Recordset.Fields("名稱")
Text6(2).Text = .Recordset.Fields("規(guī)格")
Text6(3).Text = .Recordset.Fields("單位")
Text6(4).Text = .Recordset.Fields("數(shù)量")
jg = .Recordset.Fields("進(jìn)價(jià)")
Text6(5).Text = .Recordset.Fields("零售價(jià)")
Text6(6).Text = .Recordset.Fields("產(chǎn)地")
Text6(7).Text = .Recordset.Fields("批號(hào)")
Text6(8).Text = Year(.Recordset.Fields("失效期"))
Text6(9).Text = Month(.Recordset.Fields("失效期"))
Text6(10).Text = Day(.Recordset.Fields("失效期"))
Command1.Enabled = True
result.Caption = ""
If Text6(4).Text = 0 Then
MsgBox "該藥品庫存已空，不能調(diào)撥！"
Text1.Text = ""
Command1.Enabled = False
Else
shuliang = Text6(4).Text
Command1.Enabled = True
End If
Else
result.Caption = "提示：沒有編號(hào)為“" & Text7.Text & "”的藥品或該藥已失效！"
Command1.Enabled = False
Text8.Text = ""
For i = 2 To 10
Text6(i) = ""
Next
End If
End With
Exit Sub
err6:
MsgBox "數(shù)據(jù)庫連接失??！"
End Sub
Private Sub Form_Unload(Cancel As Integer)
frmmain.StatusBar1.Panels(2) = "目前沒有窗口被激活"
End Sub
Private Sub Form_Activate()
frmmain.StatusBar1.Panels(2) = "活動(dòng)窗口：" & frmoutput.Caption
End Sub
Private Sub Text1_GotFocus()
Text1.SelStart = 0
Text1.SelLength = Len(Text1.Text)
End Sub
Private Sub Text7_GotFocus()
Text7.SelStart = 0
Text7.SelLength = Len(Text7.Text)
End Sub
Private Sub Text5_Change()
On Error GoTo err0
With Adodc5
.RecordSource = "select 姓名,代碼 from dotcode where 代碼='" & Text5.Text & "'"
.Refresh
If .Recordset.AbsolutePosition <> adPosUnknown Then
Text5.Text = .Recordset.Fields("姓名")
End If
End With
Exit Sub
err0:
MsgBox "數(shù)據(jù)庫連接失??！"
End Sub
上一頁 1 23
?? 文件大小 1167 K
?? 上傳用戶 xuhuizi
?? 所屬分類醫(yī)藥行業(yè)
??? 相關(guān)標(biāo)簽

#信息管理系統(tǒng)
?? 快捷鍵說明

復(fù)制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號(hào) Ctrl + =
減小字號(hào) Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? frmoutput.frm

?? 快捷鍵說明
