ndbb.frm
来自「这是一个医院管理系统中的院长查询模块」· FRM 代码 · 共 437 行 · 第 1/2 页
FRM
437 行
dd.Range("N10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S13)
dd.Range("N12").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S14)
dd.Range("N14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S15)
dd.Range("N15").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S16)
dd.Range("N16").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S17)
dd.Range("N17").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S18)
dd.Range("N18").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S19)
dd.Range("N19").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S20)
dd.Range("N21").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S21)
dd.Range("N22").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S22)
dd.Range("N24").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S23)
dd.Range("N25").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S24)
dd.Range("N26").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S25)
TEXT1 = Val(TEXT1) - 1
If Val(Text2) = 1 Then
DATE1 = CDate(TEXT1 + "-01-01")
DATE2 = CDate(TEXT1 + "-03-31")
End If
If Val(Text2) = 2 Then
DATE1 = CDate(TEXT1 + "-04-01")
DATE2 = CDate(TEXT1 + "-06-30")
End If
If Val(Text2) = 3 Then
DATE1 = CDate(TEXT1 + "-07-01")
DATE2 = CDate(TEXT1 + "-09-30")
End If
If Val(Text2) = 4 Then
DATE1 = CDate(TEXT1 + "-10-01")
DATE2 = CDate(TEXT1 + "-12-31")
End If
If Me.Tag = "1" Then
DDS = "BA_NDBB '" + Me.Tag + "','" + CStr(DATE1) + "','" + CStr(DATE2) + "'"
End If
Data1.RecordSource = DDS
Data1.Refresh
dd.Range("F6").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S1)
dd.Range("F14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S2)
dd.Range("F15").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S3)
dd.Range("F16").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S3)
dd.Range("F17").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S4)
dd.Range("F18").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S5)
dd.Range("F19").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S6)
dd.Range("F23").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S7)
dd.Range("F24").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S8)
dd.Range("F25").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S9)
dd.Range("F26").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S10)
dd.Range("F28").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S11)
dd.Range("M8").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S12)
dd.Range("M10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S13)
dd.Range("M12").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S14)
dd.Range("M14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S15)
dd.Range("M15").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S16)
dd.Range("M16").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S17)
dd.Range("M17").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S18)
dd.Range("M18").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S19)
dd.Range("M19").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S20)
dd.Range("M21").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S21)
dd.Range("M22").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S22)
dd.Range("M24").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S23)
dd.Range("M25").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S24)
dd.Range("M26").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S25)
DDSS:
dd.Visible = True
dd.ActiveWorkbook.PrintPreview
dd.ActiveWorkbook.Saved = True
dd.ActiveWorkbook.Close
dd.Quit
End Sub
Sub PRINT_2() '
Dim dd As Excel.Application
Set dd = CreateObject("Excel.Application")
dd.Workbooks.Open ("C:\PP\SB\医院工作报表(季度报表).xls")
dd.Range("T4").Select: dd.ActiveCell.FormulaR1C1 = TEXT1 + " 年 第 " + Text2 + " 季度"
dd.Visible = True
dd.Range("H10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S1)
dd.Range("K10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S2)
dd.Range("S10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S3)
dd.Range("Y10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S4)
dd.Range("AA10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S5)
dd.Range("AG10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S6)
dd.Range("AJ10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S7)
dd.Range("AM10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S8)
dd.Range("AP10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S9)
dd.Range("AS10").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S10)
dd.Range("A14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S11)
dd.Range("E14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S12)
dd.Range("M14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S13)
dd.Range("Q14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S14)
dd.Range("AK14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S15)
dd.Range("AO14").Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset!S16)
DDSS:
dd.Visible = True
dd.ActiveWorkbook.PrintPreview
dd.ActiveWorkbook.Saved = True
dd.ActiveWorkbook.Close
dd.Quit
End Sub
Sub PRINT_3() '
Dim dd As Excel.Application
Set dd = CreateObject("Excel.Application")
dd.Workbooks.Open ("C:\PP\SB\医院管理综合质量统计表")
dd.Range("P2").Select: dd.ActiveCell.FormulaR1C1 = " 统计区间:" + TEXT1 + "-" + Text2 + " 至 " + TEXT1 + "-" + Text3
dd.Range("M19").Select: dd.ActiveCell.FormulaR1C1 = " 制 表:" + Form3.sbar.Panels(2) + " " + CStr(Date) + " " + CStr(Time)
dd.Visible = True
xxx = 7
Do While Not Data1.Recordset.EOF
dd.Range("A" + CStr(xxx) + "").Select: dd.ActiveCell.FormulaR1C1 = Left(CStr(Data1.Recordset!BB_DATE), 7)
For i = 0 To 18
MMKK = Chr(Asc("B") + i) + CStr(xxx)
dd.Range(MMKK).Select: dd.ActiveCell.FormulaR1C1 = DxCStr(Data1.Recordset.Fields(i).Value)
Next i
Data1.Recordset.MoveNext
xxx = xxx + 1
Loop
DDSS:
dd.Visible = True
dd.ActiveWorkbook.PrintPreview
dd.ActiveWorkbook.Saved = True
dd.ActiveWorkbook.Close
dd.Quit
End Sub
Private Sub Command3_Click()
Data1.Refresh
If Data1.Recordset.EOF Then
Exit Sub
End If
If Me.Tag = "1" Then
PRINT_1
End If
If Me.Tag = "2" Then
PRINT_2
End If
If Me.Tag = "3" Then
PRINT_3
End If
End Sub
Private Sub Command1_Click()
Unload Me
End Sub
Private Sub Command2_Click()
If Val(TEXT1) > 2100 Or Val(TEXT1) < 1900 Then
TEXT1.SetFocus
Exit Sub
End If
If Val(Text2) < 1 Or Val(Text2) > 4 Then
Text2.SetFocus
Exit Sub
End If
If Val(Text2) = 1 Then
DATE1 = CDate(TEXT1 + "-01-01")
DATE2 = CDate(TEXT1 + "-03-31")
End If
If Val(Text2) = 2 Then
DATE1 = CDate(TEXT1 + "-04-01")
DATE2 = CDate(TEXT1 + "-06-30")
End If
If Val(Text2) = 3 Then
DATE1 = CDate(TEXT1 + "-07-01")
DATE2 = CDate(TEXT1 + "-09-30")
End If
If Val(Text2) = 4 Then
DATE1 = CDate(TEXT1 + "-10-01")
DATE2 = CDate(TEXT1 + "-12-31")
End If
DDS = "BA_NDBB '" + Me.Tag + "','" + CStr(DATE1) + "','" + CStr(DATE2) + "'"
Data1.RecordSource = DDS
Data1.Refresh
End Sub
Private Sub Form_Activate()
TEXT1.SetFocus
End Sub
Private Sub Form_Load()
Data1.Connect = DxPassWord
Data1.DatabaseName = "207his"
Me.Top = 0
Me.Left = 0
Me.Width = Screen.Width
Me.Height = Screen.Height
TEXT1 = Year(Date)
Text2 = ""
End Sub
Private Sub Form_Resize()
On Error GoTo dde
Me.Top = 0
Me.Left = 0
Me.Width = Screen.Width
Me.Height = Screen.Height
dde:
End Sub
Private Sub Form_Unload(Cancel As Integer)
Form3.Enabled = True
End Sub
Private Sub Text1_GotFocus()
TEXT1.SelStart = 0
TEXT1.SelLength = Len(TEXT1)
End Sub
Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
Text2.SetFocus
End If
End Sub
Private Sub Text2_GotFocus()
Text2.SelStart = 0
Text2.SelLength = Len(Text2)
End Sub
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?