formcoursequery.dfm

Delphi数据库编程

object frmCourseQuery: TfrmCourseQuery
  Left = 285
  Top = 107
  Width = 540
  Height = 450
  Caption = #35838#31243#23433#25490#26597#35810
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poOwnerFormCenter
  OnClose = FormClose
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object GroupBox1: TGroupBox
    Left = 192
    Top = 8
    Width = 337
    Height = 97
    Caption = #35838#31243#20449#24687
    TabOrder = 0
    object dbtClassID: TDBText
      Left = 80
      Top = 24
      Width = 89
      Height = 17
      Color = clBtnHighlight
      DataField = 'CourseID'
      DataSource = dsCourseInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clHighlight
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentColor = False
      ParentFont = False
    end
    object dbtClassName: TDBText
      Left = 80
      Top = 48
      Width = 249
      Height = 17
      Color = clBtnHighlight
      DataField = 'CourseName'
      DataSource = dsCourseInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clHighlight
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentColor = False
      ParentFont = False
    end
    object dbtBeginDate: TDBText
      Left = 240
      Top = 24
      Width = 89
      Height = 17
      Color = clBtnHighlight
      DataField = 'Teacher'
      DataSource = dsCourseInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clHighlight
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentColor = False
      ParentFont = False
    end
    object dbtDepartName: TDBText
      Left = 80
      Top = 72
      Width = 97
      Height = 17
      Color = clBtnHighlight
      DataField = 'Credit'
      DataSource = dsCourseInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clHighlight
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentColor = False
      ParentFont = False
    end
    object Label1: TLabel
      Left = 8
      Top = 24
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #35838#31243#32534#21495
    end
    object Label3: TLabel
      Left = 8
      Top = 48
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #35838#31243#21517#31216
    end
    object Label4: TLabel
      Left = 176
      Top = 24
      Width = 62
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #20219#35838#32769#24072
    end
    object Label6: TLabel
      Left = 8
      Top = 72
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #23398#20998
    end
    object dbtPeriod: TDBText
      Left = 240
      Top = 72
      Width = 89
      Height = 17
      Color = clBtnHighlight
      DataField = 'Period'
      DataSource = dsCourseInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clHighlight
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentColor = False
      ParentFont = False
    end
    object Label8: TLabel
      Left = 184
      Top = 72
      Width = 54
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #23398#26102#25968
    end
  end
  object DBGrid1: TDBGrid
    Left = 192
    Top = 112
    Width = 337
    Height = 305
    DataSource = dsCourseArrange
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'ClassName'
        Title.Alignment = taCenter
        Title.Caption = #29677#32423#21517#31216
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'ClassDate'
        Title.Alignment = taCenter
        Title.Caption = #19978#35838#26102#38388
        Width = 78
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'ClassRoom'
        Title.Alignment = taCenter
        Title.Caption = #19978#35838#25945#23460
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Master'
        Title.Alignment = taCenter
        Title.Caption = #29677#20027#20219
        Visible = True
      end>
  end
  object btnQuit: TButton
    Left = 112
    Top = 8
    Width = 75
    Height = 25
    Caption = #36864#20986
    TabOrder = 2
    OnClick = btnQuitClick
  end
  object dbgCourse: TDBGrid
    Left = 8
    Top = 40
    Width = 177
    Height = 377
    DataSource = dsCourse
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
    TabOrder = 3
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'CourseID'
        Title.Alignment = taCenter
        Title.Caption = #32534#21495
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'CourseName'
        Title.Alignment = taCenter
        Title.Caption = #35838#31243#21517#31216
        Visible = True
      end>
  end
  object dbnCourse: TDBNavigator
    Left = 8
    Top = 8
    Width = 104
    Height = 25
    DataSource = dsCourse
    VisibleButtons = [nbFirst, nbPrior, nbNext, nbLast]
    TabOrder = 4
  end
  object tblCourse: TTable
    AfterScroll = tblCourseAfterScroll
    AutoRefresh = True
    DatabaseName = 'DBCourse'
    TableName = 'Course'
    Left = 40
    Top = 168
  end
  object qryCourseInfo: TQuery
    DatabaseName = 'DBCourse'
    SQL.Strings = (
      'SELECT CourseID, CourseName, Credit, Period, Teacher'
      'FROM Course Course'
      'WHERE  CourseID =  :CourseID ')
    Left = 40
    Top = 256
    ParamData = <
      item
        DataType = ftString
        Name = 'CourseID'
        ParamType = ptUnknown
        Value = '2004000001'
      end>
  end
  object dsCourseInfo: TDataSource
    DataSet = qryCourseInfo
    Left = 40
    Top = 288
  end
  object qryCourseArrange: TQuery
    DatabaseName = 'DBCourse'
    SQL.Strings = (
      
        'SELECT Class.ClassName, Class.Master, Courseselect.ClassRoom, Co' +
        'urseselect.ClassDate'
      'FROM CourseSelect Courseselect, Class Class'
      'WHERE  (Class.ClassID = Courseselect.ClassID)  '
      '   AND  (Courseselect.CourseID = :CourseID ) ')
    Left = 472
    Top = 240
    ParamData = <
      item
        DataType = ftString
        Name = 'CourseID'
        ParamType = ptUnknown
        Value = #39'2004000001'#39
      end>
  end
  object dsCourseArrange: TDataSource
    DataSet = qryCourseArrange
    Left = 472
    Top = 272
  end
  object dsCourse: TDataSource
    DataSet = tblCourse
    Left = 40
    Top = 200
  end
end