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; }