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 InvoiceLineEdit::setId(const int pId)
{
XSqlQuery query;
query.prepare( "SELECT cohead_id, invchead_cust_id, invchead_invcnumber "
"FROM invchead LEFT OUTER JOIN cohead ON (invchead_ordernumber=cohead_number) "
"WHERE (invchead_id=:id);" );
query.bindValue(":id", pId);
query.exec();
if (query.first())
{
_custid = query.value("invchead_cust_id").toInt();
_coheadid = query.value("cohead_id").toInt();
_invoiceNumber = query.value("invchead_invcnumber").toString();
_id = pId;
_valid = true;
setText(_invoiceNumber);
}
else
{
_custid = -1;
_coheadid = -1;
_invoiceNumber = "";
_id = -1;
_valid = false;
setText("");
}
emit newCustid(_custid);
emit newCoheadid(_coheadid);
emit newInvoiceNumber(_invoiceNumber);
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 ShiptoEdit::setCustid(int pCustid)
{
if (pCustid != _custid)
{
clear();
_custid = pCustid;
emit newCustid(pCustid);
if (_custid == -1)
{
setEnabled(FALSE);
emit disableList(TRUE);
}
else
{
setEnabled(TRUE);
emit disableList(FALSE);
}
}
}
void ShiptoEdit::setCustid(int pCustid)
{
if (pCustid == _custid)
return;
clear();
_custid = pCustid;
if (_custid != -1)
{
_extraClause = QString(" (shipto_cust_id=%1) ").arg(_custid);
setNewPriv("MaintainShiptos");
}
else
{
_extraClause = " (false) ";
setNewPriv("");
}
sUpdateMenu();
emit newCustid(pCustid);
emit disableList(_custid == -1);
}
