unit EZXX;
interface
uses
Business.System, Business.Model, Business.Data;
type
TEZXX = class(TInfo)
DataSetAQHD: TSQLDataSet;
DataSetAQHDFJ: TSQLDataSet;
DataSetLCGZ: TSQLDataSet;
DataSetPXJL: TSQLDataSet;
FIELD_AQHD_ZB: TUserDataField;
FIELD_PXJL_ZB: TUserDataField;
DataSetGZJH: TSQLDataSet;
FIELD_GZJH_ZB: TUserDataField;
FIELD_GZJH_LB: TUserDataField;
DataSetZZXX: TSQLDataSet;
FIELD_ZZXX_ZB: TUserDataField;
FIELD_ZZXX_LB: TUserDataField;
procedure savefileAQHDFJ(afilename:string);
procedure openfileAQHDFJ(afilename:string);
procedure DataSetAQHDBeforeDelete(DataSet: TDataSet);
procedure DataSetPXJLBeforeDelete(DataSet: TDataSet);
procedure DataSetZZXXBeforeDelete(DataSet: TDataSet);
private
{private declarations}
public
procedure openLCGZ(ID:string);
{public declarations}
end;
implementation
procedure TEZXX.savefileAQHDFJ(afilename:string);
var
IOldSQL: String;
begin
DataSetAQHDFJ.Close;
IOldSQL:=DataSetAQHDFJ.SQL.Text;
DataSetAQHDFJ.SQL.Text:='select * from FJ where ID is null';
DataSetAQHDFJ.Open;
DataSetAQHDFJ.Edit;
Tblobfield(DataSetAQHDFJ.FieldByName('FJ')).LoadFromFile(afilename);
DataSetAQHDFJ.FieldByName('FJM').asstring:=Business.System.SysUtils.ExtractFileName(afilename);
DataSetAQHDFJ.ApplyUpdates;
DataSetAQHDFJ.SQL.Text:=IOldSQL;
DataSetAQHDFJ.refresh;
end;
procedure TEZXX.openfileAQHDFJ(afilename:string);
var
ITempFileName: string;
begin
ITempFileName := JSSysUtils.GetSystemTempPath + DataSetAQHDFJ.FieldByName('FJM').AsString;
if SysUtils.FileExists(ITempFileName) then SysUtils.DeleteFile(ITempFileName);
Tblobfield(DataSetAQHDFJ.FieldByName('FJ')).SaveToFile(ITempFileName);
Borland.Delphi.ShellAPI.ShellExecute(0, 'open',PChar(ITempFileName), '', '', Borland.Delphi.Windows.SW_SHOW);
end;
procedure TEZXX.openLCGZ(ID:string);
var
LCGZ: TLCGZ;
begin
LCGZ := TLCGZ.Create(self.context);;
DataSetLCGZ.Close;
DataSetLCGZ.SQLfilter := 'TFLOWID.FID='''+ID+'''';
DataSetLCGZ.SQLFiltered := True;
DataSetLCGZ.Open;
LCGZ.ShowModal;
end;
procedure TEZXX.DataSetAQHDBeforeDelete(DataSet: TDataSet);
var
queryFLOWID : Tquery;
begin
queryFLOWID:= TQuery.Create(self);
with queryFLOWID do
queryFLOWID.ConnectionString := 'DATABASEURL=Biz:\SYSTEM\SYSTEM.Database';
queryFLOWID.CommandText := 'delete from TFLOWID where TFLOWID.FID=:ID';
queryFLOWID.Params.ParamByName('ID').AsString :=DataSetAQHD.FieldByName('ID').AsString;
queryFLOWID.Execute;
end;
procedure TEZXX.DataSetPXJLBeforeDelete(DataSet: TDataSet);
var
queryFLOWID : Tquery;
begin
queryFLOWID:= TQuery.Create(self);
with queryFLOWID do
queryFLOWID.ConnectionString := 'DATABASEURL=Biz:\SYSTEM\SYSTEM.Database';
queryFLOWID.CommandText := 'delete from TFLOWID where TFLOWID.FID=:ID';
queryFLOWID.Params.ParamByName('ID').AsString :=DataSetPXJL.FieldByName('ID').AsString;
queryFLOWID.Execute;
end;
procedure TEZXX.DataSetZZXXBeforeDelete(DataSet: TDataSet);
var
queryFLOWID : Tquery;
begin
queryFLOWID:= TQuery.Create(self);
with queryFLOWID do
queryFLOWID.ConnectionString := 'DATABASEURL=Biz:\SYSTEM\SYSTEM.Database';
queryFLOWID.CommandText := 'delete from TFLOWID where TFLOWID.FID=:ID';
queryFLOWID.Params.ParamByName('ID').AsString :=DataSetZZXX.FieldByName('ID').AsString;
queryFLOWID.Execute;
end;
end. |