uquerya1.pas

关于利用DELPHI来进行企业级方案解决的著作的附书源码

unit uQueryA1;

interface

uses
  Windows, Messages, SysUtils, Classes, HTTPApp, WebModu, HTTPProd,
  MidItems, WebForm, WebComp, CompProd, PagItems, SiteProd, WebAdapt,
   DBAdapt;

type
  TQryPageA1 = class(TWebPageModule)
    AdapterPageProducer: TAdapterPageProducer;
    AdapterForm1: TAdapterForm;
    LayoutGroup1: TLayoutGroup;
    AdapterGrid1: TAdapterGrid;
    ColEMPID: TAdapterDisplayColumn;
    ColNAME: TAdapterDisplayColumn;
    ColSEX: TAdapterDisplayColumn;
    ColBIRTHDAY: TAdapterDisplayColumn;
    ColTIMEJOIN: TAdapterDisplayColumn;
    ColTEL: TAdapterDisplayColumn;
    ColDEP: TAdapterDisplayColumn;
    ColMARRIAGE: TAdapterDisplayColumn;
    ColEDUCATION: TAdapterDisplayColumn;
    ColADMJOB: TAdapterDisplayColumn;
    ColTYPEOFEMP: TAdapterDisplayColumn;
    AdapterCommandGroup1: TAdapterCommandGroup;
    CmdPrevPage: TAdapterActionButton;
    CmdGotoPage: TAdapterActionButton;
    CmdNextPage: TAdapterActionButton;
    AdapterCommandColumn1: TAdapterCommandColumn;
    adpQry: TAdapter;
    adaQryName: TAdapterAction;
    adfName: TAdapterField;
    AdapterForm2: TAdapterForm;
    LayoutGroup2: TLayoutGroup;
    AdapterFieldGroup1: TAdapterFieldGroup;
    AdapterCommandGroup2: TAdapterCommandGroup;
    adfEdu: TAdapterField;
    adaQry: TAdapterAction;
    FldadfName: TAdapterDisplayField;
    LayoutGroup3: TLayoutGroup;
    AdapterFieldGroup2: TAdapterFieldGroup;
    AdapterCommandGroup3: TAdapterCommandGroup;
    CmdadaQryName: TAdapterActionButton;
    CmdadaQry: TAdapterActionButton;
    CmdBrowseRow: TAdapterActionButton;
    adfTypeOfEmp: TAdapterField;
    adfCount: TAdapterField;
    LayoutGroup4: TLayoutGroup;
    FldadfEdu: TAdapterDisplayField;
    FldadfTypeOfEmp: TAdapterDisplayField;
    FldadfCount: TAdapterDisplayField;
    procedure adaQryNameExecute(Sender: TObject; Params: TStrings);
    procedure adpQryBeforeExecuteAction(Sender, Action: TObject;
      Params: TStrings; var Handled: Boolean);
    procedure adfNameGetValue(Sender: TObject; var Value: Variant);
    procedure WebPageModuleActivate(Sender: TObject);
    procedure adaQryExecute(Sender: TObject; Params: TStrings);
    procedure adfEduGetValue(Sender: TObject; var Value: Variant);
    procedure adfTypeOfEmpGetValue(Sender: TObject; var Value: Variant);
    procedure adfTypeOfEmpGetDisplayText(Sender: TObject;
      var Value: String);
    procedure adfEduGetDisplayText(Sender: TObject; var Value: String);
    procedure adfCountGetValue(Sender: TObject; var Value: Variant);
    procedure WebPageModuleDeactivate(Sender: TObject);
  private
    FQryName,FEdu,FTypeOfEmp:string;
    FPage:string;
    FCount:integer;
  public
    { Public declarations }
  end;

  function QryPageA1: TQryPageA1;

implementation

{$R *.dfm}  {*.html}

uses WebReq, WebCntxt, WebFact, Variants, wdmDB;

function QryPageA1: TQryPageA1;
begin
  Result := TQryPageA1(WebContext.FindModuleClass(TQryPageA1));
end;

procedure TQryPageA1.adaQryNameExecute(Sender: TObject; Params: TStrings);
var LocateParams:TLocateParams;
begin
  wdm.adtBasicInfo.Filtered:=false;
  LocateParams:=wdm.dsaBasicInfo.LocateParamsList.Add;
  LocateParams.AddParam('Name',FQryName);
  LocateParams.AdapterName:=wdm.dsaBasicInfo.Name;
  if not   wdm.dsaBasicInfo.Locate then
    adpQry.Errors.AddError('找不到'+FQryName+'的资料！');
end;

procedure TQryPageA1.adpQryBeforeExecuteAction(Sender, Action: TObject;
  Params: TStrings; var Handled: Boolean);
begin
  if Assigned(adfName.ActionValue)  then
      FQryName:=adfName.ActionValue.Values[0];
  if Assigned(adfEdu.ActionValue)  then
      FEdu:=adfEdu.ActionValue.Values[0];
  if Assigned(adfTypeOfEmp.ActionValue)  then
      FTypeOfEmp:=adfTypeOfEmp.ActionValue.Values[0];
end;

procedure TQryPageA1.adfNameGetValue(Sender: TObject; var Value: Variant);
begin
  Value:=FQryName;
end;

procedure TQryPageA1.WebPageModuleActivate(Sender: TObject);
begin
  FQryName:='';
  FEdu:='';
  FTypeOfEmp:='';
  FldadfCount.HideOptions:=[hoHideAlways];
end;

procedure TQryPageA1.adaQryExecute(Sender: TObject; Params: TStrings);
var
  LocateParams:TLocateParams;
  strEdu,strTypeOfEmp:string;
begin
   strEdu:='Education='+#39+FEdu+#39;
   strTypeOfEmp:='TypeOfEmp='+#39+FTypeOfEmp+#39;
   wdm.adtBasicInfo.Filter:=strEdu+' and '+strTypeOfEmp;
   wdm.adtBasicInfo.Filtered:=true;
   if not wdm.adtBasicInfo.Active then wdm.adtBasicInfo.Open;
   Fcount:=wdm.adtBasicInfo.recordcount;
   FldadfCount.HideOptions:=[];
end;

procedure TQryPageA1.adfEduGetValue(Sender: TObject; var Value: Variant);
begin
  Value:=FEdu;
end;

procedure TQryPageA1.adfTypeOfEmpGetValue(Sender: TObject;
  var Value: Variant);
begin
  Value:=FTypeOfEmp;
end;

procedure TQryPageA1.adfTypeOfEmpGetDisplayText(Sender: TObject;
  var Value: String);
begin
  Value:=FTypeOfEmp;
end;

procedure TQryPageA1.adfEduGetDisplayText(Sender: TObject;
  var Value: String);
begin
  Value:=FEdu;
end;

procedure TQryPageA1.adfCountGetValue(Sender: TObject; var Value: Variant);
begin
  Value:=FCount;
end;

procedure TQryPageA1.WebPageModuleDeactivate(Sender: TObject);
begin
  wdm.adtBasicInfo.Filtered:=false;
end;

initialization
  if WebRequestHandler <> nil then
    WebRequestHandler.AddWebModuleFactory(TWebPageModuleFactory.Create(TQryPageA1, TWebPageInfo.Create([wpPublished, wpLoginRequired], '.html', '', '决策查询'), crOnDemand, caCache));
end.