formcourseclass.dfm

Delphi数据库编程

object frmCourseClass: TfrmCourseClass
  Left = 285
  Top = 107
  Width = 540
  Height = 450
  Caption = #29677#32423#35838#34920
  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 = 121
    Caption = #29677#32423#20449#24687
    TabOrder = 0
    object dbtClassID: TDBText
      Left = 80
      Top = 24
      Width = 81
      Height = 17
      Color = clBtnHighlight
      DataField = 'ClassID'
      DataSource = dsClassInfo
      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 = 'ClassName'
      DataSource = dsClassInfo
      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 = 'BeginDate'
      DataSource = dsClassInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clHighlight
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentColor = False
      ParentFont = False
    end
    object dbtMaster: TDBText
      Left = 80
      Top = 96
      Width = 81
      Height = 17
      Color = clBtnHighlight
      DataField = 'Master'
      DataSource = dsClassInfo
      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 = 249
      Height = 17
      Color = clBtnHighlight
      DataField = 'DepartName'
      DataSource = dsClassInfo
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clHighlight
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentColor = False
      ParentFont = False
    end
    object dbtDepartHead: TDBText
      Left = 240
      Top = 96
      Width = 89
      Height = 17
      Color = clBtnHighlight
      DataField = 'DepartHead'
      DataSource = dsClassInfo
      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 = #29677#32423#32534#21495
    end
    object Label3: TLabel
      Left = 8
      Top = 48
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #29677#32423#21517#31216
    end
    object Label4: TLabel
      Left = 168
      Top = 24
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #20837#23398#26085#26399
    end
    object Label5: TLabel
      Left = 8
      Top = 96
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #29677#20027#20219
    end
    object Label6: TLabel
      Left = 8
      Top = 72
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #25152#23646#38498#31995
    end
    object Label7: TLabel
      Left = 168
      Top = 96
      Width = 70
      Height = 13
      Alignment = taRightJustify
      AutoSize = False
      Caption = #38498#31995#36127#36131#20154
    end
  end
  object dbgCourseArrange: TDBGrid
    Left = 192
    Top = 136
    Width = 337
    Height = 281
    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 = 'CourseName'
        Title.Alignment = taCenter
        Title.Caption = #35838#31243#21517#31216
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'ClassDate'
        Title.Alignment = taCenter
        Title.Caption = #19978#35838#26102#38388
        Width = 71
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'ClassRoom'
        Title.Alignment = taCenter
        Title.Caption = #19978#35838#25945#23460
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Teacher'
        Title.Alignment = taCenter
        Title.Caption = #20219#35838#32769#24072
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Credit'
        Title.Alignment = taCenter
        Title.Caption = #23398#20998
        Width = 43
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Period'
        Title.Alignment = taCenter
        Title.Caption = #23398#26102#25968
        Width = 44
        Visible = True
      end>
  end
  object btnQuit: TButton
    Left = 112
    Top = 8
    Width = 75
    Height = 25
    Caption = #36864#20986
    TabOrder = 2
    OnClick = btnQuitClick
  end
  object dbgClass: TDBGrid
    Left = 8
    Top = 40
    Width = 177
    Height = 377
    DataSource = dsClass
    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 = 'ClassID'
        Title.Alignment = taCenter
        Title.Caption = #32534#21495
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'ClassName'
        Title.Alignment = taCenter
        Title.Caption = #29677#32423#21517#31216
        Width = 148
        Visible = True
      end>
  end
  object dbnClass: TDBNavigator
    Left = 8
    Top = 8
    Width = 104
    Height = 25
    DataSource = dsClass
    VisibleButtons = [nbFirst, nbPrior, nbNext, nbLast]
    TabOrder = 4
  end
  object tblClass: TTable
    AfterScroll = tblClassAfterScroll
    DatabaseName = 'DBCourse'
    TableName = 'Class'
    Left = 48
    Top = 192
  end
  object qryClassInfo: TQuery
    DatabaseName = 'DBCourse'
    SQL.Strings = (
      
        'SELECT Class.ClassID, Class.ClassName, Class.BeginDate, Class.Ma' +
        'ster, Department.DepartName, Department.DepartHead'
      'FROM Class Class, Department Department'
      'WHERE  Department.DepartID = Class.DepartID'
      '   AND Class.ClassID = :ClassID ')
    Left = 48
    Top = 272
    ParamData = <
      item
        DataType = ftString
        Name = 'ClassID'
        ParamType = ptUnknown
        Value = '010101'
      end>
  end
  object dsClassInfo: TDataSource
    DataSet = qryClassInfo
    Left = 48
    Top = 304
  end
  object qryCourseArrange: TQuery
    DatabaseName = 'DBCourse'
    SQL.Strings = (
      
        'SELECT Courseselect.ClassDate, Courseselect.ClassRoom, Course.Co' +
        'urseName, Course.Credit, Course.Period, Course.Teacher'
      'FROM CourseSelect Courseselect, Course Course'
      'WHERE  (Course.CourseID = Courseselect.CourseID)  '
      '   AND  (Courseselect.ClassID = :ClassID) ')
    Left = 432
    Top = 216
    ParamData = <
      item
        DataType = ftString
        Name = 'ClassID'
        ParamType = ptUnknown
        Value = #39'010101'#39
      end>
  end
  object dsCourseArrange: TDataSource
    DataSet = qryCourseArrange
    Left = 432
    Top = 248
  end
  object dsClass: TDataSource
    DataSet = tblClass
    Left = 48
    Top = 224
  end
end