void VendorLineEdit::setId(int pId)
{
if (pId != -1)
{
QString sql( "SELECT vend_number, vend_name,"
" vend_address1, vend_address2, vend_address3,"
" vend_city, vend_state, vend_zip, vend_country "
"FROM vend "
"WHERE ( (vend_id=:vend_id)" );
if (_type == __activeVendors)
sql += " AND (vend_active) ";
sql += ");";
XSqlQuery vend;
vend.prepare(sql);
vend.bindValue(":vend_id", pId);
vend.exec();
if (vend.first())
{
_id = pId;
_valid = TRUE;
setText(vend.value("vend_number").toString());
_parsed = TRUE;
emit nameChanged(vend.value("vend_name").toString());
emit address1Changed(vend.value("vend_address1").toString());
emit address2Changed(vend.value("vend_address2").toString());
emit address3Changed(vend.value("vend_address3").toString());
emit cityChanged(vend.value("vend_city").toString());
emit stateChanged(vend.value("vend_state").toString());
emit zipCodeChanged(vend.value("vend_zip").toString());
emit countryChanged(vend.value("vend_country").toString());
emit newId(_id);
emit valid(TRUE);
return;
}
}
_id = -1;
_valid = FALSE;
setText("");
emit nameChanged("");
emit address1Changed("");
emit address2Changed("");
emit address3Changed("");
emit cityChanged("");
emit stateChanged("");
emit zipCodeChanged("");
emit countryChanged("");
emit newId(-1);
emit valid(FALSE);
_parsed = TRUE;
}
void VendorLineEdit::setId(int pId)
{
if (pId != -1)
{
QString sql( "SELECT vend_number, vend_name,"
" vend_address1, vend_address2, vend_address3,"
" vend_city, vend_state, vend_zip, vend_country "
"FROM vend "
"WHERE ( (vend_id=:vend_id)" );
if (_type == __activeVendors)
sql += " AND (vend_active) ";
sql += ");";
XSqlQuery vend;
vend.prepare(sql);
vend.bindValue(":vend_id", pId);
vend.exec();
if (vend.first())
{
_id = pId;
_valid = TRUE;
setText(vend.value("vend_number").toString());
emit nameChanged(vend.value("vend_name").toString());
emit address1Changed(vend.value("vend_address1").toString());
emit address2Changed(vend.value("vend_address2").toString());
emit address3Changed(vend.value("vend_address3").toString());
emit cityChanged(vend.value("vend_city").toString());
emit stateChanged(vend.value("vend_state").toString());
emit zipCodeChanged(vend.value("vend_zip").toString());
emit countryChanged(vend.value("vend_country").toString());
emit newId(_id);
emit valid(TRUE);
}
}
else
{
_id = -1;
_valid = FALSE;
setText("");
emit nameChanged("");
emit address1Changed("");
emit address2Changed("");
emit address3Changed("");
emit cityChanged("");
emit stateChanged("");
emit zipCodeChanged("");
emit countryChanged("");
emit newId(-1);
emit valid(FALSE);
}
if (_mapper->model() &&
_mapper->model()->data(_mapper->model()->index(_mapper->currentIndex(),_mapper->mappedSection(this))).toString() != text())
_mapper->model()->setData(_mapper->model()->index(_mapper->currentIndex(),_mapper->mappedSection(this)), text());
_parsed = TRUE;
}