sal_enter_saleplanofsaler.dfm

一个MRPII系统源代码版本

inherited Frm_Sal_Enter_SalePlanOfSaler: TFrm_Sal_Enter_SalePlanOfSaler
  Left = 161
  Top = 103
  Caption = #33829#38144#19994#21153#21592#38144#21806#35745#21010
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = #33829#38144#19994#21153#21592#38144#21806#35745#21010
  end
  inherited Pnl_Head: TPanel
    Height = 42
    inherited Image1: TImage
      Height = 42
    end
    inherited Lbl_Condition: TLabel
      Left = 72
      Top = 8
      Width = 24
      Caption = #20840#37096
    end
    inherited Lbl_ConditionTitle: TLabel
      Top = 8
    end
    inherited Lbl_OrderTitle: TLabel
      Top = 23
    end
    inherited Lbl_Order: TLabel
      Top = 23
      Width = 114
      Caption = #24180#20221'/'#33829#38144#19994#21153#21592#20195#30721
    end
  end
  inherited Pnl_Body: TPanel
    Top = 97
    Height = 451
    inherited Image3: TImage
      Height = 451
    end
    inherited DBGridEh: TDBGridEh
      Height = 451
      FrozenCols = 3
      Columns = <
        item
          EditButtons = <>
          FieldName = 'PlanYear'
          Footers = <>
          Width = 52
        end
        item
          EditButtons = <>
          FieldName = 'SaleEmployeeCode'
          Footers = <>
          Width = 56
        end
        item
          EditButtons = <>
          FieldName = 'EmployeeName'
          Footers = <>
          Width = 63
        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 = 76
        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 = 78
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_7'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_7'
          Footers = <>
          Width = 76
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_8'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_8'
          Footers = <>
          Width = 77
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_9'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_9'
          Footers = <>
          Width = 77
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_10'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_10'
          Footers = <>
          Width = 77
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_11'
          Footers = <>
          Width = 76
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_11'
          Footers = <>
          Width = 88
        end
        item
          EditButtons = <>
          FieldName = 'Plansum_12'
          Footers = <>
          Width = 77
        end
        item
          EditButtons = <>
          FieldName = 'rationsum_12'
          Footers = <>
          Width = 88
        end
        item
          EditButtons = <>
          FieldName = 'user_Create'
          Footers = <>
          Width = 52
        end
        item
          EditButtons = <>
          FieldName = 'user_CreateName'
          Footers = <>
          Width = 54
        end
        item
          EditButtons = <>
          FieldName = 'datetime_Create'
          Footers = <>
          Width = 70
        end
        item
          EditButtons = <>
          FieldName = 'user_edit'
          Footers = <>
          Width = 60
        end
        item
          EditButtons = <>
          FieldName = 'user_editName'
          Footers = <>
          Width = 59
        end
        item
          EditButtons = <>
          FieldName = 'datetime_Edit'
          Footers = <>
          Width = 70
        end>
    end
  end
  inherited AdoQry_Tmp: TADOQuery
    Left = 373
    Top = 267
  end
  inherited ActionList: TActionList
    Left = 184
    Top = 160
  end
  inherited AdoQry_Main: TADOQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_Standard;Data Source=192' +
      '.168.0.151;Use procedure for Prepare=1;Auto Translate=True;Packe' +
      't Size=4096;Workstation ID=XYB'
    SQL.Strings = (
      'select id,'
      '       PlanYear,'
      '       Sal_SalePlan_Saler.SaleEmployeeCode,'
      '       e3.EmployeeName,'
      '--       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_Saler'
      
        'left join Employee e3 on Sal_SalePlan_Saler.SaleEmployeeCode=e3.' +
        'EmployeeCode'
      
        'left join Employee e1 on Sal_SalePlan_Saler.user_Create=e1.emplo' +
        'yeeCode'
      
        'left join Employee e2 on Sal_SalePlan_Saler.user_edit=e2.employe' +
        'eCode')
    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_Saler'
    end
    object AdoQry_MaInPlansum_Year: TFloatField
      DisplayLabel = #24180#35745#21010#39069
      FieldName = 'Plansum_Year'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_Year: TFloatField
      DisplayLabel = #24180#38144#21806#23450#39069
      FieldName = 'rationsum_Year'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_1: TFloatField
      DisplayLabel = #19968#26376#35745#21010#39069
      FieldName = 'Plansum_1'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_1: TFloatField
      DisplayLabel = #19968#26376#38144#21806#23450#39069
      FieldName = 'rationsum_1'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_2: TFloatField
      DisplayLabel = #20108#26376#35745#21010#39069
      FieldName = 'Plansum_2'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_2: TFloatField
      DisplayLabel = #20108#26376#38144#21806#23450#39069
      FieldName = 'rationsum_2'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_3: TFloatField
      DisplayLabel = #19977#26376#35745#21010#39069
      FieldName = 'Plansum_3'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_3: TFloatField
      DisplayLabel = #19977#26376#38144#21806#23450#39069
      FieldName = 'rationsum_3'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_4: TFloatField
      DisplayLabel = #22235#26376#35745#21010#39069
      FieldName = 'Plansum_4'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_4: TFloatField
      DisplayLabel = #22235#26376#38144#21806#23450#39069
      FieldName = 'rationsum_4'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_5: TFloatField
      DisplayLabel = #20116#26376#35745#21010#39069
      FieldName = 'Plansum_5'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_5: TFloatField
      DisplayLabel = #20116#26376#38144#21806#23450#39069
      FieldName = 'rationsum_5'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_6: TFloatField
      DisplayLabel = #20845#26376#35745#21010#39069
      FieldName = 'Plansum_6'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_6: TFloatField
      DisplayLabel = #20845#26376#38144#21806#23450#39069
      FieldName = 'rationsum_6'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_7: TFloatField
      DisplayLabel = #19971#26376#35745#21010#39069
      FieldName = 'Plansum_7'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_7: TFloatField
      DisplayLabel = #19971#26376#38144#21806#23450#39069
      FieldName = 'rationsum_7'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_8: TFloatField
      DisplayLabel = #20843#26376#35745#21010#39069
      FieldName = 'Plansum_8'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_8: TFloatField
      DisplayLabel = #20843#26376#38144#21806#23450#39069
      FieldName = 'rationsum_8'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_9: TFloatField
      DisplayLabel = #20061#26376#35745#21010#39069
      FieldName = 'Plansum_9'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_9: TFloatField
      DisplayLabel = #20061#26376#38144#21806#23450#39069
      FieldName = 'rationsum_9'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_10: TFloatField
      DisplayLabel = #21313#26376#35745#21010#39069
      FieldName = 'Plansum_10'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_10: TFloatField
      DisplayLabel = #21313#26376#38144#21806#23450#39069
      FieldName = 'rationsum_10'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_11: TFloatField
      DisplayLabel = #21313#19968#26376#35745#21010#39069
      FieldName = 'Plansum_11'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_11: TFloatField
      DisplayLabel = #21313#19968#26376#38144#21806#23450#39069
      FieldName = 'rationsum_11'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_MaInPlansum_12: TFloatField
      DisplayLabel = #21313#20108#26376#35745#21010#39069
      FieldName = 'Plansum_12'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainrationsum_12: TFloatField
      DisplayLabel = #21313#20108#26376#38144#21806#23450#39069
      FieldName = 'rationsum_12'
      Origin = 'Sal_SalePlan_Saler'
    end
    object AdoQry_Mainuser_Create: TStringField
      DisplayLabel = #24314#26723#29992#25143#20195#30721
      FieldName = 'user_Create'
      Origin = 'Sal_SalePlan_Saler'
      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_Saler'
    end
    object AdoQry_Mainuser_edit: TStringField
      DisplayLabel = #25913#26723#29992#25143#20195#30721
      FieldName = 'user_edit'
      Origin = 'Sal_SalePlan_Saler'
      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_Saler'
    end
    object AdoQry_MainSaleEmployeeCode: TStringField
      DisplayLabel = #33829#38144#19994#21153#21592#20195#30721
      FieldName = 'SaleEmployeeCode'
      Origin = 'Sal_SalePlan_Saler'
      Size = 30
    end
    object AdoQry_MainEmployeeName: TStringField
      DisplayLabel = #33829#38144#19994#21153#21592#21517#31216
      FieldName = 'EmployeeName'
      Origin = 'Employee'
      Size = 60
    end
  end
  inherited DataSource: TDataSource
    Left = 320
    Top = 169
  end
end