sys_accessctrl1_qry.dfm

一个MRPII系统源代码版本

inherited Frm_Sys_AccessCtrl1_Qry: TFrm_Sys_AccessCtrl1_Qry
  Caption = '用户权限列表查询'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '用户权限列表查询'
  end
  inherited Pnl_Head: TPanel
    inherited Lbl_Condition: TLabel
      Width = 24
      Caption = '全部'
    end
    inherited Lbl_Order: TLabel
      Width = 228
      Caption = '部门代码，用户代码，模块代码，菜单代码'
    end
  end
  inherited Pnl_Body: TPanel
    inherited DBGridEh: TDBGridEh
      Columns = <
        Item
          FieldName = 'DeptCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门名称'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门标识'
          Width = 167
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '用户代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '用户名称'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '用户标识'
          Width = 154
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SysMenuID'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '菜单ID'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SysMenuCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '菜单代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SysMenuName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '菜单名称'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SysmoduleB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '模块标识'
          Width = 105
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SysMenuB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '菜单标识'
          Width = 212
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SysModuleCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '模块代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SysmoduleName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '模块名称'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CANAccess'
          PickList.Strings = (
            ''
            '是')
          Title.Alignment = taCenter
          Title.Caption = '权限'
          Width = 27
          KeyList.Strings = (
            '0'
            '1')
        end>
    end
  end
  inherited ActionList: TActionList
    Left = 208
    Top = 168
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=192.168.0.15' +
      '1;Use procedure for Prepare=1;Auto Translate=True;Packet Size=40' +
      '96;Workstation ID=XYB'
    CurSorType = ctStatic
    SQL.Strings = (
      'select Employee.DeptCode,'
      '       Dept.DeptName,'
      '       Employee.DeptCode+'#39' '#39'+Dept.DeptName as DeptB,'#9
      '       SysMenuAccessCtrl.EmployeeCode,'
      '       Employee.EmployeeName,'
      
        '       SysMenuAccessCtrl.EmployeeCode+'#39' '#39'+Employee.EmployeeName ' +
        'as EmployeeB,'
      '       SysMenuAccessCtrl.SysMenuID,'
      '       SysMenu.SysMenuCode,'#9
      '       SysMenu.SysMenuName,'
      '       SysMenu.SysMenuCode+'#39' '#39'+SysMenu.SysMenuName as SysMenuB,'
      '       SysMenu.SysModuleCode,'
      '       Sysmodule.SysmoduleName,'
      
        '       SysMenu.SysModuleCode+'#39' '#39'+Sysmodule.SysmoduleName as Sysm' +
        'oduleB, '
      '       SysMenuAccessCtrl.CANAccess'
      'from  SysMenuAccessCtrl'
      
        'join Employee on SysMenuAccessCtrl.EmployeeCode=Employee.EMPLOYE' +
        'ECode'
      'join Dept on Employee.DeptCode=Dept.DeptCode'
      'join SysMenu on SysMenuAccessCtrl.SysMenuID=SysMenu.SysMenuID'
      'join  Sysmodule on SysMenu.SysModuleCode=Sysmodule.SysModuleCode'
      'Order by Employee.DeptCode,SysMenuAccessCtrl.EmployeeCode')
    Left = 256
    Top = 137
    object AdoQry_MainDeptCode: TStringField
      FieldName = 'DeptCode'
      Origin = 'Employee'
      Size = 8
    end
    object AdoQry_MainDeptName: TStringField
      FieldName = 'DeptName'
      Origin = 'Dept'
      Size = 40
    end
    object AdoQry_MainDeptB: TStringField
      FieldName = 'DeptB'
      ReadOnly = True
      Size = 49
    end
    object AdoQry_MainEmployeeCode: TStringField
      FieldName = 'EmployeeCode'
      Origin = 'SysMenuAccessCtrl'
      Size = 30
    end
    object AdoQry_MainEmployeeName: TStringField
      FieldName = 'EmployeeName'
      Origin = 'Employee'
      Size = 60
    end
    object AdoQry_MainEmployeeB: TStringField
      FieldName = 'EmployeeB'
      ReadOnly = True
      Size = 91
    end
    object AdoQry_MainSysMenuID: TFloatField
      FieldName = 'SysMenuID'
      Origin = 'SysMenuAccessCtrl'
    end
    object AdoQry_MainSysMenuCode: TStringField
      FieldName = 'SysMenuCode'
      Origin = 'SysMenu'
      Size = 14
    end
    object AdoQry_MainSysMenuName: TStringField
      FieldName = 'SysMenuName'
      Origin = 'SysMenu'
      Size = 40
    end
    object AdoQry_MainSysMenuB: TStringField
      FieldName = 'SysMenuB'
      ReadOnly = True
      Size = 55
    end
    object AdoQry_MainSysModuleCode: TStringField
      FieldName = 'SysModuleCode'
      Origin = 'SysMenu'
      Size = 4
    end
    object AdoQry_MainSysmoduleName: TStringField
      FieldName = 'SysmoduleName'
      Origin = 'Sysmodule'
      Size = 40
    end
    object AdoQry_MainSysmoduleB: TStringField
      FieldName = 'SysmoduleB'
      ReadOnly = True
      Size = 45
    end
    object AdoQry_MainCANAccess: TIntegerField
      FieldName = 'CANAccess'
      Origin = 'SysMenuAccessCtrl'
    end
  end
  inherited PopuPmenu: TPopuPmenu
    Left = 288
    Top = 177
  end
end