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 ShiptoEdit::setId(int pId)
{
if (pId != -1)
{
XSqlQuery shipto( QString( "SELECT shipto_num, shipto_name, shipto_address1, shipto_cust_id "
"FROM shipto "
"WHERE (shipto_id=%1);" )
.arg(pId) );
if (shipto.first())
{
_id = pId;
_valid = TRUE;
setText(shipto.value("shipto_num").toString());
if (shipto.value("shipto_cust_id").toInt() != _custid)
{
_custid = shipto.value("shipto_cust_id").toInt();
emit newCustid(_id);
}
emit newId(_id);
emit valid(_valid);
emit nameChanged(shipto.value("shipto_name").toString());
emit address1Changed(shipto.value("shipto_address1").toString());
}
}
else
{
clear();
_custid = -1;
emit newCustid(_custid);
}
}
void ShiptoEdit::clear()
{
_id = -1;
_valid = FALSE;
setText("");
emit nameChanged("");
emit address1Changed("");
emit newId(_id);
emit valid(_valid);
}
void ShiptoEdit::setId(int pId)
{
if (pId == _id)
return;
VirtualClusterLineEdit::setId(pId);
if (pId != -1)
{
emit nameChanged(_name);
emit address1Changed(_description);
}
else
{
_custid = -1;
_extraClause = " (false) ";
emit newCustid(_custid);
}
}
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;
}
