|

楼主 |
发表于 2008-6-10 16:50:22
|
显示全部楼层
在一个文档中定义的
procedure TYSJHGGDDBSH.SheetDocCreate(Sender: TObject);
var
lParam:Business.Model.TBizParam;
lBizURL:TBizURL;
begin
lBizURL := TBizURL.Create;
lBizURL.URL := 'Biz:\YWKJ_FY\LYYWCSZ.PARAMGROUP';
lParam := SystemUtils.TContextUtils.GetParam(self.Context,lBizURL,'DQXW');
lParam.Value := DataSetBrokerLLYSJHSJJ.DataSet.FieldByName('jhbh').AsString;
dialogs.ShowMessage(Variants.VarToStr(lParam.Value));
lBizURL.Free;//释放行为
end;
在流程中定义的
procedure TYSJHGGLC.ProcUnitYSJHGGDDBSPBeforeFlowOut(Sender: TObject; Command: TFlowOutCommand);
var
lParam:Business.Model.TBizParam;
lBizURL:TBizURL;
lQuery :TQuery;
begin
lBizURL := TBizURL.Create;
lBizURL.URL := 'Biz:\YWKJ_FY\LYYWCSZ.PARAMGROUP';
lParam := SystemUtils.TContextUtils.GetParam(self.Context,lBizURL,'DQXW');
MyAction := Variants.VarToStr(lParam.Value);
lBizURL.Free;
lQuery:= TQuery.Create(Self);
lQuery.ConnectionString := 'DATABASEURL=Biz:\YWKJ_FY\SJK.DATABASE';
lQuery.CommandText := 'update LLLYS set SFYX=''计划更改'' where jhbh='''+MyAction+'''';
lQuery.Execute;
lQuery.CommandText := 'update mt_lujhgg set SFGG=''计划更改'' where jhbh='''+MyAction+'''';
lQuery.Execute;
end; |
|