frmpiceccalc.dfm

一个鞋塑企业的计件工资系统.开发目录为：D:PieceRate

object PicecCalcForm: TPicecCalcForm
  Left = 263
  Top = 114
  Width = 811
  Height = 538
  Caption = #20462#36793#24037#36164#35797#31639
  Color = clBtnFace
  Font.Charset = GB2312_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = #23435#20307
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 12
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 803
    Height = 43
    Align = alTop
    BevelInner = bvRaised
    BevelOuter = bvLowered
    TabOrder = 0
    object Label3: TLabel
      Left = 163
      Top = 16
      Width = 24
      Height = 12
      Caption = #26085#26399
      Transparent = True
    end
    object Label4: TLabel
      Left = 289
      Top = 16
      Width = 12
      Height = 12
      Caption = #21040
    end
    object Label1: TLabel
      Left = 20
      Top = 16
      Width = 24
      Height = 12
      Caption = #21592#24037
    end
    object edtPersonID: TdxButtonEdit
      Tag = 1
      Left = 51
      Top = 11
      Width = 87
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -12
      Font.Name = #23435#20307
      Font.Style = []
      ParentFont = False
      Style.BorderStyle = xbsFlat
      Style.ButtonStyle = btsFlat
      TabOrder = 0
      Buttons = <
        item
          Default = True
        end>
      OnButtonClick = edtPersonIDButtonClick
      ExistButtons = True
    end
    object edtFirstDate: TDateTimePicker
      Left = 196
      Top = 11
      Width = 85
      Height = 20
      BevelInner = bvLowered
      BevelOuter = bvRaised
      CalAlignment = dtaLeft
      Date = 37488
      Time = 37488
      DateFormat = dfShort
      DateMode = dmComboBox
      Font.Charset = GB2312_CHARSET
      Font.Color = clBlack
      Font.Height = -12
      Font.Name = #23435#20307
      Font.Style = []
      Kind = dtkDate
      ParseInput = False
      ParentFont = False
      TabOrder = 1
    end
    object edtEndDate: TDateTimePicker
      Left = 310
      Top = 11
      Width = 85
      Height = 20
      BevelInner = bvLowered
      BevelOuter = bvRaised
      CalAlignment = dtaLeft
      Date = 37488
      Time = 37488
      DateFormat = dfShort
      DateMode = dmComboBox
      Font.Charset = GB2312_CHARSET
      Font.Color = clBlack
      Font.Height = -12
      Font.Name = #23435#20307
      Font.Style = []
      Kind = dtkDate
      ParseInput = False
      ParentFont = False
      TabOrder = 2
    end
    object BitBtn1: TBitBtn
      Left = 468
      Top = 9
      Width = 66
      Height = 27
      Caption = '&T.'#32479#35745
      TabOrder = 3
      OnClick = BitBtn1Click
      Glyph.Data = {
        DE010000424DDE01000000000000760000002800000024000000120000000100
        0400000000006801000000000000000000001000000000000000000000000000
        80000080000000808000800000008000800080800000C0C0C000808080000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
        3333333333333333333333330000333333333333333333333333F33333333333
        00003333344333333333333333388F3333333333000033334224333333333333
        338338F3333333330000333422224333333333333833338F3333333300003342
        222224333333333383333338F3333333000034222A22224333333338F338F333
        8F33333300003222A3A2224333333338F3838F338F33333300003A2A333A2224
        33333338F83338F338F33333000033A33333A222433333338333338F338F3333
        0000333333333A222433333333333338F338F33300003333333333A222433333
        333333338F338F33000033333333333A222433333333333338F338F300003333
        33333333A222433333333333338F338F00003333333333333A22433333333333
        3338F38F000033333333333333A223333333333333338F830000333333333333
        333A333333333333333338330000333333333333333333333333333333333333
        0000}
      NumGlyphs = 2
    end
    object BitBtn2: TBitBtn
      Left = 677
      Top = 8
      Width = 68
      Height = 28
      Caption = '&E.'#36820#22238
      TabOrder = 5
      Kind = bkAbort
    end
    object BitBtn3: TBitBtn
      Left = 537
      Top = 9
      Width = 66
      Height = 27
      Caption = '&P.'#39044#35272
      TabOrder = 4
      Glyph.Data = {
        F6000000424DF600000000000000760000002800000010000000100000000100
        0400000000008000000000000000000000001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00888888888888
        888F8800000000000888808888888880808800000000000008080888888BBB88
        0008088888877788080800000000000008800888888888808080800000000008
        0800880FFFFFFFF080808880F00000F000088880FFFFFFFF088888880F00000F
        088888880FFFFFFFF08888888000000000888888888888888888}
    end
    object BitBtn4: TBitBtn
      Left = 606
      Top = 8
      Width = 69
      Height = 28
      Caption = '&O.'#23548#20986
      TabOrder = 6
      OnClick = BitBtn4Click
      Glyph.Data = {
        42010000424D4201000000000000760000002800000012000000110000000100
        040000000000CC000000C40E0000C40E00001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00FFFFFFFFFFFF
        FFFFFF000000FFFFFFFFFFFFFFFFFF000000FFFFFFFFFFFFFFFFFF000000FFFF
        FFFFFFFFFFFFFF000000FFFFFFFFFFFFFFFFFF000000FFFFCFFFFFCFFFFFFF00
        0000FFFFCCFFFFCCFFFFFF000000FFFFCCCFFFCCCFFFFF000000FFFFCCCCFFCC
        CCFFFF000000FFFFCCCFFFCCCFFFFF000000FFFFCCFFFFCCFFFFFF000000FFFF
        CFFFFFCFFFFFFF000000FFFFFFFFFFFFFFFFFF000000FFFFFFFFFFFFFFFFFF00
        0000FFFFFFFFFFFFFFFFFF000000FFFFFFFFFFFFFFFFFF000000FFFFFFFFFFFF
        FFFFFF000000}
      Spacing = 0
    end
  end
  object StatusBar1: TStatusBar
    Left = 0
    Top = 492
    Width = 803
    Height = 19
    Panels = <
      item
        Width = 50
      end>
    SimplePanel = False
  end
  object grdPicecCalcTotal: TdxDBGrid
    Left = 0
    Top = 43
    Width = 803
    Height = 449
    Bands = <
      item
      end>
    DefaultLayout = True
    HeaderPanelRowCount = 1
    KeyField = 'picecid'
    SummaryGroups = <>
    SummarySeparator = ', '
    Align = alClient
    TabOrder = 2
    DataSource = dsPicecCalc
    Filter.Criteria = {00000000}
    OptionsBehavior = [edgoAutoSort, edgoDragScroll, edgoEnterShowEditor, edgoExtMultiSelect, edgoImmediateEditor, edgoMultiSelect, edgoTabThrough, edgoVertThrough]
    OptionsDB = [edgoCancelOnExit, edgoCanNavigation, edgoLoadAllRecords, edgoUseBookmarks]
    object grdPicecCalcTotalPicecID: TdxDBGridMaskColumn
      Caption = #20462#36793#24037#21495
      Width = 71
      BandIndex = 0
      RowIndex = 0
      FieldName = 'PicecID'
    end
    object grdPicecCalcTotalPicecName: TdxDBGridMaskColumn
      Caption = #20462#36793#24037#22995#21517
      Width = 87
      BandIndex = 0
      RowIndex = 0
      FieldName = 'PicecName'
    end
    object grdPicecCalcTotalModelID: TdxDBGridMaskColumn
      Caption = #27169#20855#22411#21495
      Width = 79
      BandIndex = 0
      RowIndex = 0
      FieldName = 'ModelID'
    end
    object grdPicecCalcTotalColor: TdxDBGridMaskColumn
      Caption = #33394#21035
      Width = 40
      BandIndex = 0
      RowIndex = 0
      FieldName = 'Color'
    end
    object grdPicecCalcTotalShoesize: TdxDBGridMaskColumn
      Caption = #21495#30721
      Width = 46
      BandIndex = 0
      RowIndex = 0
      FieldName = 'Shoesize'
    end
    object grdPicecCalcTotalANum: TdxDBGridMaskColumn
      Caption = 'A'#20135#21697#25968#37327
      Width = 82
      BandIndex = 0
      RowIndex = 0
      FieldName = 'ANum'
    end
    object grdPicecCalcTotalPicecARate: TdxDBGridCurrencyColumn
      Caption = 'A'#20135#21697#24037#20215
      Width = 74
      BandIndex = 0
      RowIndex = 0
      FieldName = 'PicecARate'
      DisplayFormat = #65509',0.000;-'#65509',0.000'
      Nullable = False
    end
    object grdPicecCalcTotalAPicec: TdxDBGridCurrencyColumn
      Caption = #37329#39069
      Width = 73
      BandIndex = 0
      RowIndex = 0
      FieldName = 'APicec'
      DisplayFormat = #65509',0.000;-'#65509',0.000'
      Nullable = False
    end
    object grdPicecCalcTotalBNum: TdxDBGridMaskColumn
      Caption = 'B'#20135#21697#25968#37327
      Width = 76
      BandIndex = 0
      RowIndex = 0
      FieldName = 'BNum'
    end
    object grdPicecCalcTotalPicecBRate: TdxDBGridCurrencyColumn
      Caption = 'B'#20135#21697#24037#20215
      Width = 76
      BandIndex = 0
      RowIndex = 0
      FieldName = 'PicecBRate'
      DisplayFormat = #65509',0.000;-'#65509',0.000'
      Nullable = False
    end
    object grdPicecCalcTotalBPicec: TdxDBGridCurrencyColumn
      Caption = #37329#39069
      Width = 70
      BandIndex = 0
      RowIndex = 0
      FieldName = 'BPicec'
      DisplayFormat = #65509',0.000;-'#65509',0.000'
      Nullable = False
    end
  end
  object spPicecCalc: TADOStoredProc
    Connection = DmData.ADOConnection1
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    ProcedureName = 'PicecCalc;1'
    Parameters = <
      item
        Name = '@RETURN_VALUE'
        DataType = ftInteger
        Direction = pdReturnValue
        Precision = 10
        Value = 0
      end
      item
        Name = '@BeginDate'
        Attributes = [paNullable]
        DataType = ftDateTime
        Value = 37622d
      end
      item
        Name = '@EndDate'
        Attributes = [paNullable]
        DataType = ftDateTime
        Value = 37652d
      end
      item
        Name = '@RateID'
        Attributes = [paNullable]
        DataType = ftString
        Size = 6
        Value = ''
      end>
    Left = 72
    Top = 96
    object spPicecCalcPicecID: TStringField
      FieldName = 'PicecID'
      Size = 6
    end
    object spPicecCalcPicecName: TStringField
      FieldName = 'PicecName'
      Size = 8
    end
    object spPicecCalcModelID: TStringField
      FieldName = 'ModelID'
      Size = 15
    end
    object spPicecCalcColor: TStringField
      FieldName = 'Color'
      Size = 4
    end
    object spPicecCalcShoesize: TStringField
      FieldName = 'Shoesize'
      Size = 2
    end
    object spPicecCalcANum: TIntegerField
      FieldName = 'ANum'
    end
    object spPicecCalcPicecARate: TBCDField
      FieldName = 'PicecARate'
      Precision = 10
    end
    object spPicecCalcAPicec: TBCDField
      FieldName = 'APicec'
      Precision = 10
    end
    object spPicecCalcBNum: TIntegerField
      FieldName = 'BNum'
    end
    object spPicecCalcPicecBRate: TBCDField
      FieldName = 'PicecBRate'
      Precision = 10
    end
    object spPicecCalcBPicec: TBCDField
      FieldName = 'BPicec'
      Precision = 10
    end
  end
  object dsPicecCalc: TDataSource
    DataSet = spPicecCalc
    Left = 112
    Top = 96
  end
  object rmpPicecCalc: TRMReport
    Dataset = RMDBDataSet1
    InitialZoom = pzDefault
    PreviewButtons = [pbZoom, pbLoad, pbSave, pbPrint, pbFind, pbPageSetup, pbExit]
    Left = 72
    Top = 144
    ReportForm = {28000000}
  end
  object RMDBDataSet1: TRMDBDataSet
    DataSet = spPicecCalc
    Left = 112
    Top = 144
  end
  object SaveDialog: TSaveDialog
    DefaultExt = 'xls'
    Filter = 'Excle '#25991#20214'(*.xls)|*.xls'
    Left = 632
    Top = 32
  end
end