📄 frm_cyxx_temp.frm

📁 可运行的一个医院住院管理系统
💻 FRM
📖 第 1 页 / 共 2 页
字号:
上一页 12
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column08 
         DataField       =   "付款方式"
         Caption         =   "付款方式"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column09 
         DataField       =   "入院时间"
         Caption         =   "入院时间"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column10 
         DataField       =   "主治医师"
         Caption         =   "主治医师"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column11 
         DataField       =   "收入科室"
         Caption         =   "收入科室"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column12 
         DataField       =   "是否出院"
         Caption         =   "是否出院"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column13 
         DataField       =   "出院时间"
         Caption         =   "出院时间"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column14 
         DataField       =   "备注"
         Caption         =   "备注"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      BeginProperty Column15 
         DataField       =   "挂号单号"
         Caption         =   "挂号单号"
         BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED} 
            Type            =   0
            Format          =   ""
            HaveTrueFalseNull=   0
            FirstDayOfWeek  =   0
            FirstWeekOfYear =   0
            LCID            =   2052
            SubFormatType   =   0
         EndProperty
      EndProperty
      SplitCount      =   1
      BeginProperty Split0 
         BeginProperty Column00 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column01 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column02 
            ColumnWidth     =   1365.165
         EndProperty
         BeginProperty Column03 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column04 
            ColumnWidth     =   1094.74
         EndProperty
         BeginProperty Column05 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column06 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column07 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column08 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column09 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column10 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column11 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column12 
            ColumnWidth     =   1275.024
         EndProperty
         BeginProperty Column13 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column14 
            ColumnWidth     =   2085.166
         EndProperty
         BeginProperty Column15 
            ColumnWidth     =   2085.166
         EndProperty
      EndProperty
   End
   Begin VB.TextBox Text1 
      DataField       =   "住院号"
      DataSource      =   "Adodc1"
      Height          =   375
      Left            =   1920
      TabIndex        =   3
      Text            =   "Text1"
      Top             =   1560
      Width           =   1575
   End
End
Attribute VB_Name = "frm_cyxx_temp"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim AA
Private Sub Command1_Click()
Adodc1.RecordSource = "select * from View_cyxx where 住院号='" + Text1.Text + "'"
Adodc1.Refresh
If Adodc1.Recordset.RecordCount > 0 Then
'frm_cygl.Text11.Text = Adodc1.Recordset.Fields("病房号")
frm_cygl.Text1.Text = Adodc1.Recordset.Fields("住院号")
frm_cygl.Text2.Text = Adodc1.Recordset.Fields("姓名")
frm_cygl.Combo1.Text = Adodc1.Recordset.Fields("性别")
frm_cygl.DTPicker1.Value = Adodc1.Recordset.Fields("出生日期")
frm_cygl.Text3.Text = Adodc1.Recordset.Fields("年龄")
frm_cygl.Text4.Text = Adodc1.Recordset.Fields("联系地址")
frm_cygl.Text5.Text = Adodc1.Recordset.Fields("联系电话")
frm_cygl.Text6.Text = Adodc1.Recordset.Fields("主要诊断")
frm_cygl.Text7.Text = Adodc1.Recordset.Fields("主治医师")
frm_cygl.Text10.Text = Adodc1.Recordset.Fields("挂号单号")
frm_cygl.Combo2.Text = Adodc1.Recordset.Fields("付款方式")
frm_cygl.DT2.Value = Adodc1.Recordset.Fields("入院时间")
frm_cygl.Combo3.Text = Adodc1.Recordset.Fields("收入科室")
frm_cygl.Text8.Text = Adodc1.Recordset.Fields("备注")
AA = Adodc1.Recordset.Fields("住院号")
Unload Me
frm_cygl.DT3.SetFocus
Adodc2.RecordSource = "select * from Table_zyxx where 住院号='" + Str(AA) + "'"
Adodc2.Refresh
If Adodc2.Recordset.RecordCount > 0 Then
frm_cygl.Text11.Text = Adodc2.Recordset.Fields("病房号")
Else
End If
Else
Unload Me
End If
End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub DataGrid1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
If Text1.Text = "" Then
Unload Me
Exit Sub
Else
Adodc1.RecordSource = "select * from View_cyxx where 住院号='" + Text1.Text + "'"
Adodc1.Refresh
If Adodc1.Recordset.RecordCount > 0 Then
'frm_cygl.Text11.Text = Adodc1.Recordset.Fields("病房号")
frm_cygl.Text1.Text = Adodc1.Recordset.Fields("住院号")
frm_cygl.Text2.Text = Adodc1.Recordset.Fields("姓名")
frm_cygl.Combo1.Text = Adodc1.Recordset.Fields("性别")
frm_cygl.DTPicker1.Value = Adodc1.Recordset.Fields("出生日期")
frm_cygl.Text3.Text = Adodc1.Recordset.Fields("年龄")
frm_cygl.Text4.Text = Adodc1.Recordset.Fields("联系地址")
frm_cygl.Text5.Text = Adodc1.Recordset.Fields("联系电话")
frm_cygl.Text6.Text = Adodc1.Recordset.Fields("主要诊断")
frm_cygl.Text7.Text = Adodc1.Recordset.Fields("主治医师")
frm_cygl.Text10.Text = Adodc1.Recordset.Fields("挂号单号")
frm_cygl.Combo2.Text = Adodc1.Recordset.Fields("付款方式")
frm_cygl.DT2.Value = Adodc1.Recordset.Fields("入院时间")
frm_cygl.Combo3.Text = Adodc1.Recordset.Fields("收入科室")
frm_cygl.Text8.Text = Adodc1.Recordset.Fields("备注")
AA = Adodc1.Recordset.Fields("住院号")
Adodc2.RecordSource = "select * from Table_zyxx where 住院号='" + Str(AA) + "'"
Adodc2.Refresh
If Adodc2.Recordset.RecordCount > 0 Then
frm_cygl.Text11.Text = Adodc2.Recordset.Fields("病房号")
Else
End If
Unload Me
frm_cygl.DT3.SetFocus
Else
Unload Me
End If
End If
Else
End If
End Sub

Private Sub Form_Load()
Me.Top = 3700
Me.Left = 3020
End Sub
上一页 12
💿 文件大小 2144 K
👤 上传用户 l550253832
📂 所属分类 MySQL数据库
🏷️ 相关标签

#运行 #管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -