erp.h
void loadChequePurchieVouchers(QComboBox *combo, QString paymeth)
    {
        combo->clear();
        combo->addItem("Select", QVariant(0));
        QString sql = " select voucherid from tblinvoicepaymentdetail where paymeth=:paymeth and status in ('0','1') " ;
        QSqlQuery qry;
        qry.prepare(sql);
        qry.bindValue(":paymeth", paymeth);
        qry.exec();
        while(qry.next())
        {
                QString vno = qry.value("voucherid").toString();
                combo->addItem(vno, QVariant(vno));
        }
    }
/************************************  LOAD VOUCHERS FOR CHEQUE/PURCHIE ENCASHED  ****************************************************/
LOAD VOUCHERS FOR CHEQUE/PURCHIE ENCASHED
LOAD VOUCHERS FOR CHEQUE / PURCHIE ENCASHED
void loadChequePurchieVouchers(QComboBox *combo, QString paymeth)
    {
        combo->clear();
        combo->addItem("Select", QVariant(0));
        QString sql = " select voucherid from tblinvoicepaymentdetail where paymeth=:paymeth and status in ('0','1') " ;
        QSqlQuery qry;
        qry.prepare(sql);
        qry.bindValue(":paymeth", paymeth);
        qry.exec();
        while(qry.next())
        {
                QString vno = qry.value("voucherid").toString();
                combo->addItem(vno, QVariant(vno));
        }
    }
void loadChequePurchieVouchers ( QComboBox * combo , QString paymeth ) { combo -> clear ( ) ; combo -> addItem ( " " , QVariant ( 0 ) ) ; QString sql = " " ; QSqlQuery qry ; qry . prepare ( sql ) ; qry . bindValue ( " " , paymeth ) ; qry . exec ( ) ; while ( qry . next ( ) ) { QString vno = qry . value ( " " ) . toString ( ) ; combo -> addItem ( vno , QVariant ( vno ) ) ; } }
LOAD VOUCHERS FOR CHEQUE/PURCHIE ENCASHED
LOAD VOUCHERS FOR CHEQUE / PURCHIE ENCASHED