代码如下:数据集:dlfxxx,cxtj 自定义数据集里我定义了两个字段,年份、高级管理人才
unit DLFXXX;
interface
uses
Business.System, Business.Model, Business.Data;
type
TDLFXXX = class(TInfo)
DataSetDLSJJ: TSQLDataSet;
DataSetCSJJ: TSQLDataSet;
DataSetCXTJ: TUserDataSet;
FIELD_CXTJ_GJGLRY: TUserDataField;
FIELD_CXTJ_NF: TUserDataField;
procedure Queryorder(Sender: TObject);
private
{private declarations}
public
{public declarations}
end;
implementation
procedure TDLFXXX.QueryOrder(Sender: TObject);
var
sFilter: String;
begin
sFilter := '';
if Length(DataSetCXTJ.FieldByName('gjglry').AsString)>0 then
sFilter := sFilter + ' AND (gjglry LIKE '''+DataSetCXTJ.FieldByName('gjglry').AsString+'%'')';
DataSetCXTJ.UserFilter := StringUtils.Copy(sFilter, 5, 10000);
end;
end.
unit XGDJSXX;
interface
uses
Business.System, Business.Model, Business.Forms, Business.Data;
type
TXGDJSXX = class(TFormDoc)
InfoBroker: TInfoBroker;
nf: TDataLabel;
DataLabel2: TDataLabel;
DataSetBroker1: TDataSetBroker;
DataEdit1: TDataEdit;
DataEdit2: TDataEdit;
Button1: TButton;
procedure Button1Click(Sender: TObject);
private
{private declarations}
public
{public declarations}
end;
implementation
procedure TXGDJSXX.Button1Click(Sender: TObject);
var tt:TDLFXXX;
begin
tt.QueryOrder(InfoBroker.Info);
end;
end. |