formcoursearrange.dfm

Delphi数据库编程

object frmCourseArrange: TfrmCourseArrange
  Left = 285
  Top = 107
  Width = 600
  Height = 540
  Caption = #35838#31243#23433#25490
  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 Label2: TLabel
    Left = 408
    Top = 136
    Width = 78
    Height = 13
    AutoSize = False
    Caption = #19978#35838#26102#38388
  end
  object Label8: TLabel
    Left = 416
    Top = 184
    Width = 78
    Height = 13
    AutoSize = False
    Caption = #19978#35838#25945#23460
  end
  object Label9: TLabel
    Left = 248
    Top = 136
    Width = 78
    Height = 13
    AutoSize = False
    Caption = #35838#31243#21517#31216
  end
  object gpbClass: TGroupBox
    Left = 248
    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 = 8
    Top = 336
    Width = 577
    Height = 169
    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 = 91
        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 = 512
    Top = 280
    Width = 73
    Height = 25
    Caption = #36864#20986
    TabOrder = 2
    OnClick = btnQuitClick
  end
  object dbgClass: TDBGrid
    Left = 8
    Top = 8
    Width = 233
    Height = 321
    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
        Width = 45
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'ClassName'
        Title.Alignment = taCenter
        Title.Caption = #29677#32423#21517#31216
        Width = 148
        Visible = True
      end>
  end
  object dbnCourseSelect: TDBNavigator
    Left = 416
    Top = 224
    Width = 168
    Height = 25
    DataSource = dsCourseSelect
    VisibleButtons = [nbInsert, nbDelete, nbEdit, nbPost, nbCancel, nbRefresh]
    ConfirmDelete = False
    TabOrder = 4
    OnClick = dbnCourseSelectClick
  end
  object dbeClassDate: TDBEdit
    Left = 424
    Top = 152
    Width = 161
    Height = 21
    DataField = 'ClassDate'
    DataSource = dsCourseSelect
    TabOrder = 5
  end
  object dbeClassRoom: TDBEdit
    Left = 424
    Top = 200
    Width = 161
    Height = 21
    DataField = 'ClassRoom'
    DataSource = dsCourseSelect
    TabOrder = 6
  end
  object dbllCourseName: TDBLookupListBox
    Left = 248
    Top = 160
    Width = 161
    Height = 173
    DataField = 'CourseID'
    DataSource = dsCourseSelect
    KeyField = 'CourseID'
    ListField = 'CourseName'
    ListSource = dsCourse
    TabOrder = 7
  end
  object tblClass: TTable
    Active = True
    AfterOpen = tblClassAfterOpen
    AfterScroll = tblClassAfterScroll
    DatabaseName = 'DBCourse'
    TableName = 'Class'
    Left = 24
    Top = 144
  end
  object qryClassInfo: TQuery
    Active = True
    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 = 232
    Top = 64
    ParamData = <
      item
        DataType = ftString
        Name = 'ClassID'
        ParamType = ptUnknown
        Value = '010101'
      end>
  end
  object dsClassInfo: TDataSource
    DataSet = qryClassInfo
    Left = 232
    Top = 96
  end
  object qryCourseArrange: TQuery
    Active = True
    AfterOpen = qryCourseArrangeAfterOpen
    AfterScroll = qryCourseArrangeAfterScroll
    DatabaseName = 'DBCourse'
    SQL.Strings = (
      
        'SELECT Courseselect.ID, Courseselect.CourseID, Courseselect.Clas' +
        'sDate, Courseselect.ClassRoom, Course.CourseName, Course.Credit,' +
        ' Course.Period, Course.Teacher'
      'FROM CourseSelect Courseselect, Course Course'
      'WHERE  (Course.CourseID = Courseselect.CourseID)  '
      '   AND  (Courseselect.ClassID = :ClassID) ')
    Left = 40
    Top = 392
    ParamData = <
      item
        DataType = ftString
        Name = 'ClassID'
        ParamType = ptUnknown
        Value = #39'010101'#39
      end>
  end
  object dsCourseArrange: TDataSource
    DataSet = qryCourseArrange
    Left = 40
    Top = 424
  end
  object dsClass: TDataSource
    DataSet = tblClass
    Left = 24
    Top = 176
  end
  object tblCourseSelect: TTable
    Active = True
    AfterOpen = tblCourseSelectAfterOpen
    BeforePost = tblCourseSelectBeforePost
    AfterPost = tblCourseSelectAfterPost
    BeforeDelete = tblCourseSelectBeforeDelete
    AfterDelete = tblCourseSelectAfterDelete
    AfterScroll = tblCourseSelectAfterScroll
    DatabaseName = 'DBCourse'
    TableName = 'CourseSelect'
    Left = 432
    Top = 296
  end
  object dsCourseSelect: TDataSource
    DataSet = tblCourseSelect
    Left = 472
    Top = 296
  end
  object tblCourse: TTable
    Active = True
    DatabaseName = 'DBCourse'
    TableName = 'Course'
    Left = 256
    Top = 240
  end
  object dsCourse: TDataSource
    DataSet = tblCourse
    Left = 256
    Top = 272
  end
end