sal_enter_saleplanofitem.dfm

一个MRPII系统源代码版本

inherited Frm_Sal_Enter_SalePlanOfItem: TFrm_Sal_Enter_SalePlanOfItem
  Left = 80
  Caption = #20135#21697#38144#21806#35745#21010
  ClientHeight = 539
  ClientWidth = 974
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 974
  end
  inherited Pnl_Title: TPanel
    Width = 974
    Caption = #20135#21697#38144#21806#35745#21010
    inherited Image2: TImage
      Width = 974
    end
  end
  inherited Pnl_Head: TPanel
    Width = 974
    inherited Image1: TImage
      Width = 974
    end
    inherited Lbl_Condition: TLabel
      Left = 72
      Top = 7
      Width = 24
      Caption = #20840#37096
    end
    inherited Lbl_Order: TLabel
      Width = 78
      Caption = #24180#20221'/'#29289#26009#20195#30721
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 514
    Width = 974
    inherited Image4: TImage
      Width = 974
    end
  end
  inherited Pnl_Body: TPanel
    Width = 974
    Height = 421
    inherited Image3: TImage
      Width = 974
      Height = 421
    end
    inherited DBGridEh: TDBGridEh
      Width = 974
      Height = 421
      FrozenCols = 3
      VTitleMargin = 10
      Columns = <
        item
          EditButtons = <>
          FieldName = 'PlanYear'
          Footers = <>
          Width = 45
        end
        item
          EditButtons = <>
          FieldName = 'ItemCode'
          Footers = <>
          Width = 76
        end
        item
          EditButtons = <>
          FieldName = 'ItemName'
          Footers = <>
          Width = 161
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_Year'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_Year'
          Footers = <>
          Width = 65
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_1'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_1'
          Footers = <>
          Width = 78
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_2'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_2'
          Footers = <>
          Width = 76
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_3'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_3'
          Footers = <>
          Width = 78
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_4'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_4'
          Footers = <>
          Width = 78
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_5'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_5'
          Footers = <>
          Width = 77
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_6'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_6'
          Footers = <>
          Width = 84
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_7'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_7'
          Footers = <>
          Width = 81
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_8'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_8'
          Footers = <>
          Width = 79
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_9'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_9'
          Footers = <>
          Width = 78
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_10'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_10'
          Footers = <>
          Width = 79
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_11'
          Footers = <>
          Width = 76
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_11'
          Footers = <>
          Width = 89
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_12'
          Footers = <>
          Width = 80
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_12'
          Footers = <>
          Width = 92
        end
        item
          EditButtons = <>
          FieldName = 'user_Create'
          Footers = <>
          Width = 78
        end
        item
          EditButtons = <>
          FieldName = 'user_CreateName'
          Footers = <>
          Width = 77
        end
        item
          EditButtons = <>
          FieldName = 'datetime_Create'
          Footers = <>
          Width = 70
        end
        item
          EditButtons = <>
          FieldName = 'user_edit'
          Footers = <>
          Width = 82
        end
        item
          EditButtons = <>
          FieldName = 'user_editName'
          Footers = <>
          Width = 82
        end
        item
          EditButtons = <>
          FieldName = 'datetime_Edit'
          Footers = <>
          Width = 70
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 405
    Top = 219
  end
  inherited ActionList: TActionList
    Left = 184
    Top = 160
  end
  inherited AdoQry_Main: TAdoQuery
    SQL.Strings = (
      'select id,'
      '       PlanYear,'
      '       Sal_SalePlan_Item.ItemCode,'
      '       ItemName,'
      '--       Sal_SalePlan_Dept.DeptCode+'#39' '#39'+DeptName as Deptflag,'
      '       Plansum_Year,'
      '       rationsum_Year,'
      '       Plansum_1,'
      '       rationsum_1,'
      '       Plansum_2,'
      '       rationsum_2,'
      '       Plansum_3,'
      '       rationsum_3,'
      '       Plansum_4,'
      '       rationsum_4,'
      '       Plansum_5,'
      '       rationsum_5,'
      '       Plansum_6,'
      '       rationsum_6,'
      '       Plansum_7,'
      '       rationsum_7,'
      '       Plansum_8,'
      '       rationsum_8,'
      '       Plansum_9,'
      '       rationsum_9,'
      '       Plansum_10,'
      '       rationsum_10,'
      '       Plansum_11,'
      '       rationsum_11,'
      '       Plansum_12,'
      '       rationsum_12,'
      '       user_Create,'
      '       e1.EmployeeName as user_CreateName,'
      '--       user_Create+'#39' '#39'+e1.EmployeeName as user_Createflag,'
      '       datetime_Create,'
      '       user_edit,'
      '       e2.EmployeeName as user_editName,'
      '--       user_edit+'#39' '#39'+e2.EmployeeName as user_editflag,'
      '       datetime_Edit'
      'from Sal_SalePlan_Item'
      'left join Item on Sal_SalePlan_Item.ItemCode=Item.ItemCode'
      
        'left join Employee e1 on Sal_SalePlan_Item.user_Create=e1.employ' +
        'eeCode'
      
        'left join Employee e2 on Sal_SalePlan_Item.user_edit=e2.Employee' +
        'Code')
    Left = 280
    Top = 297
    object AdoQry_Mainid: TAutoIncField
      FieldName = 'id'
      ReadOnly = True
    end
    object AdoQry_MaInPlanYear: TIntegerField
      DisplayLabel = #24180#20221
      FieldName = 'PlanYear'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_Year: TFloatField
      DisplayLabel = #24180#35745#21010#39069
      FieldName = 'Plansum_Year'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_Year: TFloatField
      DisplayLabel = #24180#35745#21010#25968#37327
      FieldName = 'rationsum_Year'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_1: TFloatField
      DisplayLabel = #19968#26376#35745#21010#39069
      FieldName = 'Plansum_1'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_1: TFloatField
      DisplayLabel = #19968#26376#35745#21010#25968#37327
      FieldName = 'rationsum_1'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_2: TFloatField
      DisplayLabel = #20108#26376#35745#21010#39069
      FieldName = 'Plansum_2'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_2: TFloatField
      DisplayLabel = #20108#26376#35745#21010#25968#37327
      FieldName = 'rationsum_2'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_3: TFloatField
      DisplayLabel = #19977#26376#35745#21010#39069
      FieldName = 'Plansum_3'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_3: TFloatField
      DisplayLabel = #19977#26376#35745#21010#25968#37327
      FieldName = 'rationsum_3'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_4: TFloatField
      DisplayLabel = #22235#26376#35745#21010#39069
      FieldName = 'Plansum_4'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_4: TFloatField
      DisplayLabel = #22235#26376#35745#21010#25968#37327
      FieldName = 'rationsum_4'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_5: TFloatField
      DisplayLabel = #20116#26376#35745#21010#39069
      FieldName = 'Plansum_5'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_5: TFloatField
      DisplayLabel = #20116#26376#35745#21010#25968#37327
      FieldName = 'rationsum_5'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_6: TFloatField
      DisplayLabel = #20845#26376#35745#21010#39069
      FieldName = 'Plansum_6'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_6: TFloatField
      DisplayLabel = #20845#26376#35745#21010#25968#37327
      FieldName = 'rationsum_6'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_7: TFloatField
      DisplayLabel = #19971#26376#35745#21010#39069
      FieldName = 'Plansum_7'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_7: TFloatField
      DisplayLabel = #19971#26376#35745#21010#25968#37327
      FieldName = 'rationsum_7'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_8: TFloatField
      DisplayLabel = #20843#26376#35745#21010#39069
      FieldName = 'Plansum_8'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_8: TFloatField
      DisplayLabel = #20843#26376#35745#21010#25968#37327
      FieldName = 'rationsum_8'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_9: TFloatField
      DisplayLabel = #20061#26376#35745#21010#39069
      FieldName = 'Plansum_9'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_9: TFloatField
      DisplayLabel = #20061#26376#35745#21010#25968#37327
      FieldName = 'rationsum_9'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_10: TFloatField
      DisplayLabel = #21313#26376#35745#21010#39069
      FieldName = 'Plansum_10'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_10: TFloatField
      DisplayLabel = #21313#26376#35745#21010#25968#37327
      FieldName = 'rationsum_10'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_11: TFloatField
      DisplayLabel = #21313#19968#26376#35745#21010#39069
      FieldName = 'Plansum_11'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_11: TFloatField
      DisplayLabel = #21313#19968#26376#35745#21010#25968#37327
      FieldName = 'rationsum_11'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MaInPlansum_12: TFloatField
      DisplayLabel = #21313#20108#26376#35745#21010#39069
      FieldName = 'Plansum_12'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainrationsum_12: TFloatField
      DisplayLabel = #21313#20108#26376#35745#21010#25968#37327
      FieldName = 'rationsum_12'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainuser_Create: TStringField
      DisplayLabel = #24314#26723#29992#25143#20195#30721
      FieldName = 'user_Create'
      Origin = 'Sal_SalePlan_Item'
      Size = 30
    end
    object AdoQry_Mainuser_CreateName: TStringField
      DisplayLabel = #24314#26723#29992#25143#21517#31216
      FieldName = 'user_CreateName'
      Size = 60
    end
    object AdoQry_Maindatetime_Create: TDateTimeField
      DisplayLabel = #24314#26723#26102#38388
      FieldName = 'datetime_Create'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_Mainuser_edit: TStringField
      DisplayLabel = #25913#26723#29992#25143#20195#30721
      FieldName = 'user_edit'
      Origin = 'Sal_SalePlan_Item'
      Size = 30
    end
    object AdoQry_Mainuser_editName: TStringField
      DisplayLabel = #25913#26723#29992#25143#21517#31216
      FieldName = 'user_editName'
      Size = 60
    end
    object AdoQry_Maindatetime_Edit: TDateTimeField
      DisplayLabel = #25913#26723#26102#38388
      FieldName = 'datetime_Edit'
      Origin = 'Sal_SalePlan_Item'
    end
    object AdoQry_MainItemCode: TStringField
      DisplayLabel = #29289#26009#20195#30721
      FieldName = 'ItemCode'
      Origin = 'Sal_SalePlan_Item'
      Size = 16
    end
    object AdoQry_MainItemName: TStringField
      DisplayLabel = #29289#26009#21517#31216
      FieldName = 'ItemName'
      Origin = 'Item'
      Size = 80
    end
  end
  inherited DataSource: TDataSource
    Left = 320
    Top = 169
  end
end