xymzzjinquerym.dfm

本文重点研究的是医院西药药房管理系统

      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000BDBDBD0000000000BDBDBD000000
      0000000000000000FF0000000000000000000000FF0000000000000000000000
      00000000000000000000BDBDBD00000000004AE7180042DE7B00A5E7180042D6
      7B001800000000000000EF4A940084FFFF004200000000000000000000000000
      0000214A3900E708520094EF4A00394A520008AD4A0000C642004A8C4A00296B
      5200E7AD4A004A6B420094EF4A009CEF4A00318C520000E74A0031CE42004A6B
      4200298C5A007BCE420031294A0018AD4200E7CE42004ACE4A0021CE4200086B
      5200A5CE290029085A0029080000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000BDBDBD00000000000000
      000000000000000000000000FF0000000000000000000000FF00000000000000
      000000000000BDBDBD0000000000BDBDBD000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000BDBDBD00000000000000000000FF
      FF000000000000000000000000000000FF000000000000000000000000000000
      0000BDBDBD0000000000BDBDBD0000000000E7AD4A004A6B420094EF4A009CEF
      4A00318C520000E74A0031CE42004A6B4200298C5A007BCE420031294A0018AD
      4200E7EF4A009C29420073A54200C6AD42000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      000000000000000000000000000000000000000000000000000000FFFF0000FF
      FF0000FFFF000000000000000000000000000000FF000000000000000000BDBD
      BD0000000000BDBDBD0000000000BDBDBD000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000422100000000000010000000000000004AB57B008CFF
      FF004AE7180042DE7B00F7E7180042D67B00BDBDBD000000000000FFFF0000FF
      FF000000000000FFFF0000000000000000000000000000000000BDBDBD000000
      0000BDBDBD0000000000BDBDBD00000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      0000000000000000000000000000000000000000000000000000000000000000
      00000000000000000000000000000000000000000000BDBDBD00000000000000
      000000FFFF0000FFFF0000FFFF000000000000000000BDBDBD0000000000BDBD
      BD0000000000BDBDBD0000000000BDBDBD00FFFFFF00FFFFFF00FFFFFF00FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFFFF00FFFF
      FF00FFFFFF00FFFFFF00FFFFFF00FFFFFF000000000000000000422100000000
      0000180000000000000029316B008CFFFF004AE7180008DE7B008CE7180042D6
      7B000800000000000000EF4A940084FFFF004200000000000000000000000000
      0000184A3900E708520094EF4A00394A520008AD4A0000C642004A8C4A00296B
      5200E76B4A004ACE4A00396B52007BCE4200BDBDBD0000000000BDBDBD000000
      000000FFFF0000FFFF000000000000000000BDBDBD0000000000BDBDBD000000
      0000BDBDBD0000000000BDBDBD0000000000BDBDBD00FFFFFF00BDBDBD00FFFF
      FF00BDBDBD007B7B7B007B7B7B007B7B7B000000000000FFFF000000FF0000FF
      FF000000FF0000FFFF0000000000FFFFFF00FFFFFF00BDBDBD007B7B7B007B7B
      7B007B7B7B007B7B7B007B7B7B007B7B7B007B7B7B000000000000FFFF000000
      FF0000FFFF0000000000FFFFFF00BDBDBD00BDBDBD007B7B7B007B7B7B007B7B
      7B007B7B7B007B7B7B007B7B7B007B7B7B007B7B7B007B7B7B00000000000000
      000000000000FFFFFF00BDBDBD00FFFFFF0000000000BDBDBD0000000000BDBD
      BD00000000000000000000000000BDBDBD0000000000BDBDBD0000000000BDBD
      BD0000000000BDBDBD0000000000BDBDBD00BDBDBD00FFFFFF00BDBDBD00FFFF
      FF00000000000000FF00FFFFFF00FFFFFF000000FF00FFFFFF00FFFFFF000000
      000000000000FFFFFF00BDBDBD00FFFFFF00FFFFFF00BDBDBD00FFFFFF00BDBD
      BD00FFFFFF0000000000FFFFFF000000FF00FFFFFF00FFFFFF00000000000000
      FF0000FFFF0000000000FFFFFF00BDBDBD00BDBDBD00FFFFFF00BDBDBD00FFFF
      FF00BDBDBD00FFFFFF0000000000FFFFFF00FFFFFF00000000000000FF0000FF
      FF000000FF0000FFFF0000000000FFFFFF00424D3E000000000000003E000000
      2800000040000000100000000100010000000000800000000000000000000000
      000000000000000000000000FFFFFF00FFFFE0FF0000FFFFAAAA0000E0FFE0FF
      0005F7BDFFFFF7BD8002F7BDFFFFF7BD5001E0FFE0FF0000AA00F7BD00000000
      5581FFFFF7BDFFFFAAC2FFFFF7BDFFFF5365E0FF0000FFFFADAAFFFFF7BD0000
      46D5F7BDFFFFF7BD832AF7BDFFFFF7BD01550000FFFFF7BD80AAF7BDFFFFF7BD
      4155000000000000A2AA6E200000000000000000000000000000000000000000
      000000000000}
  end
  object YpClassQuery2: TADOQuery
    Connection = DataMzf.XyMzValiConnection
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'select yp_class,'
      '       class_name'
      'from XyClass')
    Left = 48
    Top = 292
  end
  object YpClassSource2: TDataSource
    DataSet = YpClassQuery2
    Left = 126
    Top = 292
  end
  object YpClassaQuery2: TADOQuery
    Connection = DataMzf.XyMzValiConnection
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'select yp_classa,'
      '       classa_name'
      'from XyClassa')
    Left = 208
    Top = 292
  end
  object YpClassaSource2: TDataSource
    DataSet = YpClassaQuery2
    Left = 291
    Top = 292
  end
  object YpQuery3: TADOStoredProc
    Connection = DataMzf.XyMzValiConnection
    LockType = ltBatchOptimistic
    ProcedureName = 'Wh_YpQuery;1'
    Parameters = <
      item
        Name = 'RETURN_VALUE'
        DataType = ftInteger
        Direction = pdReturnValue
        Precision = 10
        Value = 0
      end
      item
        Name = '@YpCode'
        Attributes = [paNullable]
        DataType = ftString
        Size = 12
        Value = ''
      end>
    Left = 368
    Top = 288
    object StringField10: TStringField
      DisplayWidth = 18
      FieldName = 'yp_name'
      FixedChar = True
      Size = 24
    end
    object StringField11: TStringField
      DisplayWidth = 12
      FieldName = 'yp_spec'
      FixedChar = True
    end
    object StringField12: TStringField
      DisplayWidth = 4
      FieldName = 'yp_unit'
      FixedChar = True
      Size = 4
    end
    object SmallintField2: TSmallintField
      FieldName = 'yp_id'
      ReadOnly = True
    end
  end
  object YpSource3: TDataSource
    DataSet = YpQuery3
    Left = 424
    Top = 286
  end
  object ZjHzQuery: TADOStoredProc
    Connection = DataMzf.XyMzValiConnection
    ProcedureName = 'Wh_XyMzZjInHzQuery;1'
    Parameters = <
      item
        Name = 'RETURN_VALUE'
        DataType = ftInteger
        Direction = pdReturnValue
        Precision = 10
        Value = 0
      end
      item
        Name = '@Sdate'
        Attributes = [paNullable]
        DataType = ftDateTime
        Value = 0d
      end
      item
        Name = '@Edate'
        Attributes = [paNullable]
        DataType = ftDateTime
        Value = 0d
      end
      item
        Name = '@MinYpClass'
        Attributes = [paNullable]
        DataType = ftSmallint
        Precision = 5
        Value = 0
      end
      item
        Name = '@MaxYpClass'
        Attributes = [paNullable]
        DataType = ftSmallint
        Precision = 5
        Value = 0
      end
      item
        Name = '@MinYpClassa'
        Attributes = [paNullable]
        DataType = ftSmallint
        Precision = 5
        Value = 0
      end
      item
        Name = '@MaxYpClassa'
        Attributes = [paNullable]
        DataType = ftSmallint
        Precision = 5
        Value = 0
      end
      item
        Name = '@MinYpId'
        Attributes = [paNullable]
        DataType = ftInteger
        Precision = 5
        Value = 0
      end
      item
        Name = '@MaxYpId'
        Attributes = [paNullable]
        DataType = ftInteger
        Precision = 5
        Value = 0
      end>
    Left = 50
    Top = 242
    object ZjHzQueryypid: TSmallintField
      FieldName = 'ypid'
      ReadOnly = True
    end
    object ZjHzQueryypname: TStringField
      FieldName = 'ypname'
      ReadOnly = True
      Size = 24
    end
    object ZjHzQueryypspec: TStringField
      FieldName = 'ypspec'
      FixedChar = True
    end
    object ZjHzQueryypunit: TStringField
      FieldName = 'ypunit'
      FixedChar = True
      Size = 4
    end
    object ZjHzQueryinamou: TIntegerField
      FieldName = 'inamou'
      ReadOnly = True
    end
    object ZjHzQueryinmoney: TBCDField
      FieldName = 'inmoney'
      ReadOnly = True
      DisplayFormat = '###########0.00###'
      Precision = 32
      Size = 5
    end
  end
  object ZjHzSource: TDataSource
    DataSet = ZjHzQuery
    Left = 108
    Top = 242
  end
  object ZjQuery: TADOQuery
    Connection = DataMzf.XyMzValiConnection
    LockType = ltBatchOptimistic
    DataSource = ZjHzSource
    Parameters = <
      item
        Name = 'YpId'
        Attributes = [paSigned]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end
      item
        Name = 'SDate'
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end
      item
        Name = 'Edate'
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end>
    SQL.Strings = (
      'select XyMzZjIn.my_id,'
      '       XyMzZjIn.ls_price,'
      '       in_amou,'
      '       in_date,'
      '       XyMzZjIn.in_man,'
      '       XyMzZjIn.qr_man'
      'from XyMzZjIn,XyDkInId,XyId '
      'where XyDkInId.yp_id=XyId.yp_id and'
      '      XyDkInId.in_id=XyMzZjIn.in_id and '
      '      XyDkInId.yp_id=:YpId and'
      '      XyMzZjIn.qr_man is not null and '
      '      XyMzZjIn.in_date>=:SDate and '
      '      XyMzZjIn.in_date<=:Edate'
      '')
    Left = 164
    Top = 242
    object ZjQuerymy_id: TAutoIncField
      FieldName = 'my_id'
      ReadOnly = True
    end
    object ZjQueryls_price: TBCDField
      DefaultExpression = '###########0.00###'
      FieldName = 'ls_price'
      Precision = 18
      Size = 5
    end
    object ZjQueryin_amou: TIntegerField
      FieldName = 'in_amou'
    end
    object ZjQueryin_date: TDateTimeField
      FieldName = 'in_date'
    end
    object ZjQueryin_man: TStringField
      FieldName = 'in_man'
      FixedChar = True
      Size = 8
    end
    object ZjQueryqr_man: TStringField
      FieldName = 'qr_man'
      FixedChar = True
      Size = 8
    end
  end
  object ZjSource: TDataSource
    DataSet = ZjQuery
    Left = 212
    Top = 242
  end
end