sal_qry_totalsaleorder5.dfm

一个MRPII系统源代码版本

inherited Frm_Sal_Qry_TotalSaleOrder5: TFrm_Sal_Qry_TotalSaleOrder5
  Left = 79
  Top = 90
  Caption = '销售订单统计-按约定交货日'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '销售订单统计-按约定交货日'
  end
  inherited Pnl_Head: TPanel
    inherited Lbl_Order: TLabel
      Left = 77
      Width = 180
      Caption = '约定交货日/下单日期/销售订单号'
    end
  end
  inherited Pnl_Hint: TPanel
    object Label1: TLabel
      Left = 12
      Top = 9
      Width = 72
      Height = 12
      Caption = '约定交货日：'
    end
    object DBText1: TDBText
      Left = 85
      Top = 9
      Width = 172
      Height = 17
      DataField = 'slolinedate'
      DataSource = DataSource
    end
  end
  inherited Pnl_Body: TPanel
    inherited DBGridEh: TDBGridEh
      OnDblClick = Act_LookExecute
      FrozenCols = 3
      Columns = <
        Item
          FieldName = 'slolinedate'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CreateDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '下单日期'
          Width = 70
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SloNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售订单号'
          Width = 67
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CustomerFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售客户标识'
          Width = 132
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SloQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '订单数量'
          Width = 58
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '已发货量'
          Width = 54
          KeyList.Strings = ()
        end
        Item
          FieldName = 'NoTaxAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未税金额'
          Width = 57
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TaxAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '含税金额'
          Width = 55
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleTypeFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售类型标识'
          Width = 109
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleDeptFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售部门标识'
          Width = 154
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PayTermFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '付款条款标识'
          Width = 111
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleEmployeeFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '营销业务员标识'
          Width = 99
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TaxRate_Percent'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售税率'
          Width = 63
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipModeFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货方式标识'
          Width = 88
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CustomerShipAddressFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货地址标识'
          Width = 135
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 477
    Top = 43
  end
  inherited ActionList: TActionList
    Left = 200
    Top = 112
    inherited Act_Look: TAction
      Enabled = True
      Visible = True
      OnExecute = Act_LookExecute
    end
  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.1' +
      '68.0.151;Use procedure for Prepare=1;Auto Translate=True;Packet ' +
      'Size=4096;Workstation ID=XYB'
    CurSorType = ctStatic
    SQL.Strings = (
      
        'Select convert(varchAr,slolinedate,102) as slolinedate From sa_S' +
        'aleOrderline')
    Left = 232
    Top = 249
    object AdoQry_MainCustomerFalg: TStringField
      FieldName = 'CustomerFalg'
      Origin = '#TotalSaleOrder5'
      Size = 73
    end
    object AdoQry_MainCreateDate: TStringField
      FieldName = 'CreateDate'
      Origin = '#TotalSaleOrder5'
      Size = 120
    end
    object AdoQry_MainSloNo: TStringField
      FieldName = 'SloNo'
      Origin = '#TotalSaleOrder5'
      Size = 16
    end
    object AdoQry_MainSloQty: TFloatField
      FieldName = 'SloQty'
      Origin = '#TotalSaleOrder5'
    end
    object AdoQry_MainShipQty: TFloatField
      FieldName = 'ShipQty'
      Origin = '#TotalSaleOrder5'
    end
    object AdoQry_MainNoTaxAmount: TFloatField
      FieldName = 'NoTaxAmount'
      Origin = '#TotalSaleOrder5'
    end
    object AdoQry_MainTaxAmount: TFloatField
      FieldName = 'TaxAmount'
      Origin = '#TotalSaleOrder5'
    end
    object AdoQry_MainSaleTypeFalg: TStringField
      FieldName = 'SaleTypeFalg'
      Origin = '#TotalSaleOrder5'
      Size = 37
    end
    object AdoQry_MainSaleDeptFalg: TStringField
      FieldName = 'SaleDeptFalg'
      Origin = '#TotalSaleOrder5'
      Size = 49
    end
    object AdoQry_MainSaleEmployeeFalg: TStringField
      FieldName = 'SaleEmployeeFalg'
      Origin = '#TotalSaleOrder5'
      Size = 91
    end
    object AdoQry_MainTaxRate_Percent: TFloatField
      FieldName = 'TaxRate_Percent'
      Origin = '#TotalSaleOrder5'
    end
    object AdoQry_MainPayTermFalg: TStringField
      FieldName = 'PayTermFalg'
      Origin = '#TotalSaleOrder5'
      Size = 34
    end
    object AdoQry_MainShipModeFalg: TStringField
      FieldName = 'ShipModeFalg'
      Origin = '#TotalSaleOrder5'
      Size = 127
    end
    object AdoQry_MainCustomerShipAddressFalg: TStringField
      FieldName = 'CustomerShipAddressFalg'
      Origin = '#TotalSaleOrder5'
      Size = 67
    end
    object AdoQry_Mainfalg: TIntegerField
      FieldName = 'falg'
      Origin = '#TotalSaleOrder5'
    end
    object AdoQry_Mainslolinedate: TStringField
      DisplayLabel = '约定交货日'
      FieldName = 'slolinedate'
      ReadOnly = True
      Size = 30
    end
  end
  inherited DataSource: TDataSource
    Left = 392
    Top = 153
  end
  inherited PopuPmenu: TPopuPmenu
    Left = 232
    Top = 169
  end
end