sal_enter_shiporderh.dfm

一个MRPII系统源代码版本

inherited Frm_Sal_Enter_ShipOrderH: TFrm_Sal_Enter_ShipOrderH
  Left = 68
  Top = 124
  Caption = '销售发货'
  ClientHeight = 385
  ClientWidth = 681
  Windowstate = wsMaximized
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 681
  end
  inherited Pnl_Title: TPanel
    Width = 681
    Caption = '销售发货'
    inherited Image2: TImage
      Width = 681
    end
  end
  inherited Pnl_Head: TPanel
    Width = 681
    inherited Image1: TImage
      Width = 681
    end
    inherited Lbl_Condition: TLabel
      Width = 72
      Caption = '未审核发货单'
    end
    inherited Lbl_Order: TLabel
      Width = 180
      Caption = '客户代码/发货日期/销售发货单号'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 376
    Width = 681
    inherited Image4: TImage
      Width = 681
    end
  end
  inherited Pnl_Body: TPanel
    Width = 681
    Height = 279
    inherited Image3: TImage
      Width = 681
      Height = 279
    end
    inherited DBGridEh: TDBGridEh
      Width = 681
      Height = 279
      FrozenCols = 4
      Columns = <
        Item
          FieldName = 'CUSTOMERCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '客户代码'
          Width = 77
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CustomerName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '客户名称'
          Width = 215
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CustomerFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售客户标识'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货日期'
          Width = 73
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售发货单号'
          Width = 79
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BillTypeCode'
          PickList.Strings = (
            '材料销售发货'
            '产品销售发货')
          Title.Caption = '单据类型'
          Width = 88
          KeyList.Strings = (
            '0205'
            '0206')
        end
        Item
          FieldName = 'SaleType'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售类型代码'
          Width = 77
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleTypeName'
          PickList.Strings = ()
          Title.Caption = '销售类型名称'
          Width = 100
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售部门代码'
          Width = 79
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售部门名称'
          Width = 115
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售部门标识'
          Width = 216
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleEmployeeCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售人员代码'
          Width = 80
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售人员名称'
          Width = 95
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售人员标识'
          Width = 81
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CURRENCYCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币代码'
          Width = 59
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币名称'
          Width = 59
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币标识'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBilltaxrate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '销售税率'
          Width = 56
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PayTermCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '付款条款代码'
          Width = 79
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleTermName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '付款条款名称'
          Width = 211
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleTermFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '付款条款标识'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillWHCHCK'
          PickList.Strings = (
            '0 未审核'
            '1 已审核')
          Title.Alignment = taCenter
          Title.Caption = '仓库审核否'
          Width = 65
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'Sal_EmployeeCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '制单人员代码'
          Width = 76
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CreateEmployeeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '制单人员名称'
          Width = 76
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeFalg1'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '制单人员标识'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipModeCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货方式代码'
          Width = 78
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipModeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货方式名称'
          Width = 201
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipModeFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货方式标识'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipAddresSCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货地址代码'
          Width = 78
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipAddressName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货地址名称'
          Width = 167
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipAddressFalg'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '发货地址标识'
          Width = 222
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'RemArk'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '备注'
          Width = 208
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 573
    Top = 195
  end
  inherited ActionList: TActionList
    Left = 176
    Top = 200
  end
  inherited AdoQry_Head: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_kelong;Data Source=192.168' +
      '.0.100;Use procedure for Prepare=1;Auto Translate=True;Packet Si' +
      'ze=4096;Workstation ID=XYB'
    CurSorType = ctStatic
    SQL.Strings = (
      ' Select InvOutBill.*,CustomerName,SaleType.SaleTypeName,'
      
        '                       InvOutBill.CustomerCode+'#39' '#39'+ CustomerName' +
        ' as CustomerFalg,'
      '                       DeptName,'
      
        '                       InvOutBill.DeptCode+'#39' '#39'+DeptName As DeptF' +
        'alg, '
      '                       Warehouse.WhName,'
      '                       WhPosition.WhPositionName,'
      '                       Employee.EmployeeName, '
      
        '                       SaleEmployeeCode+'#39' '#39'+Employee.EmployeeNam' +
        'e  As EmployeeFalg, '
      '                       CurrencyName,'
      
        '                       InvOutBill.CurrencyCode+'#39' '#39'+CurrencyName ' +
        'As CurrencyFalg, '
      '                       InvOutBill.InvBillTaxRate,  '
      '                       PayTerm.PayTermName  as SaleTermName,   '
      
        '                       InvOutBill.PayTermCode+'#39' '#39'+PayTermName As' +
        ' SaleTermFalg,'
      '                       tt.EmployeeName as CreateEmployeeName, '
      
        '                       InvOutBill.Sal_EmployeeCode+'#39' '#39'+tt.Employ' +
        'eeName As EmployeeFalg1, '
      '                       ShipModeName,'
      
        '                       InvOutBill.ShipModeCode+'#39' '#39'+ShipModeName ' +
        ' As ShipModeFalg,'
      '                       ShipAddressName, '
      
        '                       InvOutBill.ShipAddresSCode+'#39' '#39'+ShipAddres' +
        'sName As ShipAddressFalg'
      '                 From InvOutBill left outer  Join Customer '
      
        '                     On InvOutBill.CustomerCode=Customer.Custome' +
        'rCode '
      '                     left outer Join Dept     '
      '                     On InvOutBill.DeptCode=Dept.DeptCode    '
      
        '                     left Join Warehouse on InvOutBill.WhCode=Wa' +
        'reHouse.WhCode '
      
        '                     left Join WhPosition on (InvOutBill.WhCode=' +
        'WhPosition.WhCode and InvOutBill.WhPositionCode=WhPosition.WhPos' +
        'itionCode) '
      '                     left Join Employee       '
      
        '                     On InvOutBill.SaleEmployeeCode=Employee.Emp' +