void ContractForm::listRecord() { QSqlQuery query; query.prepare("SELECT employeeid FROM employee WHERE employeename = :name"); query.bindValue(":name",editEmployee->text()); query.exec(); query.next(); ViewListTable listTemp(query.value(0).toString(),"employee",this); listTemp.exec(); if(listTemp.returnValue() != ""){ QSqlQuery query; query.prepare("SELECT employeename FROM employee WHERE employeeid = :id"); query.bindValue(":id",listTemp.returnValue()); query.exec(); query.next(); editEmployee->setText(query.value(0).toString()); } }
bool SHVListTester::TestAll(SHVModuleList& modules, SHVTestBase* self, int ) { bool ok = true; SHVList<SHVString,SHVStringC> list; SHVListIterator<SHVString,SHVStringC> itr(list); SHVListPos pos; int i; list.AddHead(_S("R belong 2 US")); list.AddHead(_S("All your base")); list.AddTail(_S("1")); list.AddTail(_S("2")); list.AddTail(_S("3")); list.AddTail(_S("4")); ok = (ok && (list.GetCount() == 6)); for(i=0, pos = list.GetTailPosition(); pos; list.MovePrev(pos),i++) { switch (i) { case 0: ok = (ok && (list.GetAt(pos) == _S("4")) ); break; case 3: ok = (ok && (list.GetAt(pos) == _S("1")) ); break; case 5: ok = (ok && (list.GetAt(pos) == _S("All your base")) ); break; } } ok = (ok && (i == 6) ); ok = (ok && (pos = list.Find(_S("2"))) ); ok = (ok && (list.GetAt(pos = list.Find(_S("2"))) == _S("2")) ); ok = (ok && (list.FindIndex(1)) ); ok = (ok && (list.GetAt(pos = list.FindIndex(1)) == _S("R belong 2 US")) ); ok = (ok && (!list.FindIndex(6)) ); if (ok) { SHVList<SHVString,SHVStringC> list1; SHVList<SHVString,SHVStringC> listTemp(list.ReleaseBuffer()); list1.AddTail(_S("This is a test")); list1 = listTemp.ReleaseBuffer(); ok = (ok && list1.GetCount() == 6); ok = (ok && listTemp.GetCount() == 0); ok = (ok && list.GetCount() == 0); ok = (ok && (list1.GetAt(pos = list1.Find(_S("2"))) == _S("2")) ); ok = (ok && (list1.FindIndex(1)) ); ok = (ok && (list1.GetAt(pos = list1.FindIndex(1)) == _S("R belong 2 US")) ); list1 += ListTester_GetEntries(); ok = (ok && list1.GetCount() == 10); ok = (ok && (list1.GetAt(pos = list1.Find(_S("2"))) == _S("2")) ); ok = (ok && (list1.GetAt(pos = list1.Find(_S("5"))) == _S("5")) ); if (ok) { list1 += list1.ReleaseBuffer(); i=0; for(SHVListPos pos=NULL; list1.MovePrev(pos);i++); ok = (ok && i == 10); } } self->AddLine(_S("Test result: %s"), self->Success(modules,ok).GetSafeBuffer()); return ok; }