}
fldlst->Add(inf);
mqrA->Next();
} while (!mqrA->Eof);
mqrA->Close();
bool f = ((desc->type == (AnsiString)"T") && (!desc->parentfield.Trim().IsEmpty()));
form->spbTree->Visible = f;
form->dbnPlus->Visible = f;
form->SetTreeMode(f);
TuneFilters();
form->Go();
//---------------------------------------------------------------------------
void __fastcall TfrmUniForm::TuneFromBtn(TbtnAddInfo *lnkinfo, AnsiString linkvalue, AnsiString linktitle, AnsiString parentform)
{
if (!lnk) lnk = new TlnkFromBtn();
form->lnkb = lnk;
lnk->linkform = lnkinfo->linkform;
lnk->linktofield = lnkinfo->linktofield;
lnk->linkfromfield = lnkinfo->linkfromfield;
lnk->linkvalue = linkvalue;
lnk->linktitle = linktitle;
lnk->parentform = parentform;
void __fastcall TfrmUniForm::TuneForLink()
link = true;
slv = new TformDescription();
UploadMetaInfo(slv, lnk->linkform);
form->slv = slv;
form->link = link;
desc->listfield = "add_lnkform_nam";
void __fastcall TfrmUniForm::InitTblAdd()
// инициализация tblAdd
AnsiString str;
str = "select " + slv->listfield + ", " + slv->keyfield + " from " + slv->table;
form->tblAdd->SQL->Clear();
form->tblAdd->SQL->Add(str);
try
form->tblAdd->Close();
form->tblAdd->Open();
} catch(EOracleError &E)
ShowMessage(E.Message + ", запрос: '" + str + "'");
return;
void __fastcall TfrmUniForm::TuneFilters()
if (!parentform) return;
TList* patfrm_fltlst = ((TfrmUniForm*)parentform)->fltlst;
TList* patfrm_fldlst = ((TfrmUniForm*)parentform)->fldlst;
if (patfrm_fltlst)
for (int r=0; r<fltlst->Count; r++)
for (int i=0; i<patfrm_fltlst->Count; i++)
TfltAddInfo* tm_r = ((TfltAddInfo*)(fltlst->Items[r]));
TfltAddInfo* tm_i = ((TfltAddInfo*)(patfrm_fltlst->Items[i]));
if (tm_r->name == tm_i->name)
tm_r->retid = tm_i->retid;
tm_r->rettitle = tm_i->rettitle;
TfrmFilter* src = ((TfrmFilter*)tm_r->pntr);
src->edt->Text = tm_i->rettitle;
// в uid возвращается выбранный код
AnsiString str = tm_r->filtersql;
if (retid.IsEmpty()) str="";
else StrRpl(str, "%1", retid);
form->FilterBy("a" + IntToStr(tm_r->code), str);
if (accept && patfrm_fldlst)
TfrmUniForm* uni = ((TfrmUniForm*)parentform);
if (!uni->form->tblBrowse->IsEmpty())
for (int r=0; r<patfrm_fldlst->Count; r++)
for (int i=0; i<fltlst->Count; i++)
TfieldAddInfo *fl = ((TfieldAddInfo*)patfrm_fldlst->Items[r]);
TfrmeFieldsN *tm_i = ((TfrmeFieldsN*)(fl->form));
TfltAddInfo *tm_r = ((TfltAddInfo*)(fltlst->Items[i]));
if ((fl->type == (AnsiString)"C") && (fl->fieldname == tm_r->name))
if (!uni->form->tblBrowse->FieldByName(fl->fieldname)->IsNull)
tm_r->retid = uni->form->tblBrowse->FieldByName(fl->fieldname)->AsString;
tm_r->rettitle = tm_i->name->Text;
src->edt->Text = tm_i->name->Text;
void __fastcall TfrmUniForm::CommonButtonClick(TObject *Sender)
TbtnAddInfo* tm = ((TbtnAddInfo*)btnlst->Items[((TToolButton*)Sender)->Tag]);
if (form->tblBrowse->IsEmpty()) return;
// обработка настройки дочерней формы по нажатию кнопки контекстного перехода
AnsiString _title = tm->childtitle, _filter = tm->sql;
UseReplaces(_title, _filter);
bool s = (tm->type == (AnsiString)"S"), l = (tm->type == (AnsiString)"L");
if (!s && !l) return;
if (l) frm->TuneForLink();
ShowMessage(E.Message);
void __fastcall TfrmUniForm::CommonFilterChange(TObject *Sender)
// обработка вызова дочерней формы по нажатию кнопки фильтра
TfrmFilter* src = ((TfrmFilter*)Sender);
TfltAddInfo* tm = ((TfltAddInfo*)fltlst->Items[src->Tag]);
int i = CallOtherForm(tm->childform, "", tm->sql, true, true);
if (i == mrOk)
tm->retid = retid;
tm->rettitle = rettitle;
src->edt->Text = rettitle;
AnsiString str = tm->filtersql;
if (retid.IsEmpty()) { CommonFilterClear(Sender); return; }
form->FilterBy("a" + IntToStr(tm->code), str);
void __fastcall TfrmUniForm::CommonFilterClear(TObject *Sender)
tm->retid = "";
src->edt->Text = "";
AnsiString str = "";
if (tm->logic == 1) str = "(1=0)";
void __fastcall TfrmUniForm::CommonFltSlctChange(TObject *Sender)
// обработка вызова дочерней формы по выбору из списка
void __fastcall TfrmUniForm::FormClose(TObject *Sender,
TCloseAction &Action)
Action = caFree;
void __fastcall TfrmUniForm::formbtbtnCancelClick(TObject *Sender)
Close();
void __fastcall TfrmUniForm::formbtbtnOKClick(TObject *Sender)
if (!form->tblBrowse->IsEmpty())
this->uid = form->tblBrowse->FieldByName(desc->keyfield)->AsString;
this->rettitle = form->tblBrowse->FieldByName(desc->listfield)->AsString;
this->ModalResult = mrOk;
void __fastcall TfrmUniForm::TuneForAccept()
if (form) form->TuneForAccept();
accept = true;
if (!desc->accepttitle.IsEmpty()) this->Caption = desc->accepttitle;
if (desc->hideonaccept) this->Width = 500;
void __fastcall TfrmUniForm::FormDestroy(TObject *Sender)
if (desc) delete desc;
if (slv) delete slv;
if (lnk) delete lnk;
for (int r=0; r<btnlst->Count; r++)
delete ((TbtnAddInfo*)(btnlst->Items[r]));
delete btnlst;
delete ((TfltAddInfo*)(fltlst->Items[r]));
delete fltlst;
for (int r=0; r<fldlst->Count; r++)
delete ((TfieldAddInfo*)(fldlst->Items[r]));
delete fldlst;
if (itm) itm->Enabled = true;
void __fastcall TfrmUniForm::UseReplaces(AnsiString &title, AnsiString &filter)
if (!form->tblBrowse->IsEmpty() && !form->tblBrowse->FieldByName(desc->keyfield )->IsNull)
StrRpl(title, "%1", form->tblBrowse->FieldByName(desc->listfield)->AsString);
StrRpl(filter, "%1", form->tblBrowse->FieldByName(desc->keyfield )->AsString);
StrRpl(filter, "<<", "|%%");
StrRpl(filter, ">>", "%%|");
// учтём подстановки полей вида <field>, а также их возможные NULL
filter = TranslateString(filter, FieldValue);
StrRpl(filter, "|%%", "<");
StrRpl(filter, "%%|", ">");
// учтём (ссылки на другие фильтры) подстаноки вида <<flt_value>>, а также их возможные NULL
filter = TranslateString(filter, FilterValue);
StrRpl(filter, "'NULL'", "NULL");
int __fastcall TfrmUniForm::CallOtherForm(AnsiString _form, AnsiString _title, AnsiString _filter,
bool _modal, bool _accept)
int res = 0;
TfrmUniForm *frm = new TfrmUniForm(((_modal)?(TForm*)Owner:(TForm*)frmMain), NULL, _form);
frm->parentform = this;
if (!_filter.Trim().IsEmpty()) frm->form->FilterBy("parent", _filter);
if (_accept) { frm->TuneForAccept(); frm->parentform = this; }
if (!_title.Trim().IsEmpty()) frm->Caption = _title;
frm->Execute();
if (_modal)
frm->FormStyle = fsNormal;
res = frm->ShowModal();
retid = frm->uid;
rettitle = frm->rettitle;
} else
frm->FormStyle = fsMDIChild;
frm->Show();
} catch (Exception &E)
return res;
void __fastcall TfrmUniForm::formdbgBrowseDblClick(TObject *Sender)
if (accept && form->btbtnOK->Visible && form->pnlLCOK->Visible)
formbtbtnOKClick(this);
AnsiString __fastcall TfrmUniForm::FieldValue(AnsiString valname)
AnsiString tmp;
if (!form->tblBrowse->FieldByName(valname.Trim())->IsNull)
tmp= form->tblBrowse->FieldByName(valname.Trim())->AsString;
else
tmp= "NULL";
return tmp;
AnsiString __fastcall TfrmUniForm::FilterValue(AnsiString valname)
// выясним текущее значение указанного фильтра
TfltAddInfo* tm = ((TfltAddInfo*)(fltlst->Items[r]));
if (tm->name == valname.Trim())
if (!tm->retid.IsEmpty())
tmp= tm->retid;
// ф-ция разбора строки
AnsiString __fastcall TfrmUniForm::TranslateString(AnsiString str, TGetValueEvent evt)
AnsiString tmp, filter, _filter = str;
tmp = "";
filter = "";
bool b = false;
for(int r=1; r<=_filter.Length(); r++)
if (_filter[r] == '<' && !b) { b = true; tmp = ""; }
if (_filter[r] == '>' && b && (!tmp.Trim().IsEmpty())) { b = false; filter+=evt(tmp); }
if (_filter[r] != '<' && b) { tmp += _filter[r]; }
if (!b) { filter+= _filter[r]; }
return filter;
void __fastcall TfrmUniForm::FormShow(TObject *Sender)
if (accept) ReorderFilters();
Страницы: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
