Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void StoresStock::ConectLiteDatabase()
- {
- m_LiteDb = QSqlDatabase::addDatabase("QSQLITE", "liteconnection");
- m_LiteDb.setDatabaseName("local");
- if (!m_LiteDb.open())
- {
- qDebug() << "Problema na conexao com SQLite local... ";
- return;
- }
- QSqlQuery *q = new QSqlQuery(m_LiteDb);
- q->exec("drop table dsm_stores_stock");
- if( !q->exec("create table dsm_stores_stock (id INTEGER PRIMARY KEY AUTOINCREMENT, name varchar, telefone varchar, endereco varchar, numero varchar, bairro varchar, city varchar, Cod INTEGER, Barcode varchar, sellprice double, fraction double, stock DOUBLE, status INTEGER, originalid INTEGER )"))
- qDebug() << "Error creating dsm_stores_stock (QSQLITE)";
- else
- qDebug() << "Create dsm_stores_stock ... ok";
- qDebug() << "loop .. ";
- for( int i = 0; i < m_selectStore->rowCount(); i++)
- {
- if( !q->exec(QString("insert into dsm_stores_stock( name, telefone, stock, originalid, endereco, numero, bairro, city, status, sellprice, fraction, barcode ) values ('%1','%2', %3, %4, '%5','%6','%7','%8', %9, %10, %11, '%12' )")
- .arg(m_selectStore->record(i).field("razaosocial").value().toString())
- .arg(m_selectStore->record(i).field("telefone").value().toString())
- .arg(0)
- .arg(m_selectStore->record(i).field("ID").value().toString())
- .arg(m_selectStore->record(i).field("endereco").value().toString())
- .arg(m_selectStore->record(i).field("numero").value().toString())
- .arg(m_selectStore->record(i).field("bairro").value().toString())
- .arg(m_selectStore->record(i).field("city").value().toString())
- .arg(0)
- .arg(m_price)
- .arg(m_fraction)
- .arg(m_barcode)
- ))
- {
- qDebug() << q->lastError().text();
- }
- }
- m_StoreStock->setQuery("select * from dsm_stores_stock", m_LiteDb);
- m_StoreStock->setHeaderData(1, Qt::Horizontal, QString::fromUtf8("Empresa"));
- m_StoreStock->setHeaderData(2, Qt::Horizontal, QString::fromUtf8("Telefone"));
- m_StoreStock->setHeaderData(7, Qt::Horizontal, QString::fromUtf8("Código"));
- m_StoreStock->setHeaderData(8, Qt::Horizontal, QString::fromUtf8("Cod. Barras"));
- m_StoreStock->setHeaderData(9, Qt::Horizontal, QString::fromUtf8("Preço R$"));
- m_StoreStock->setHeaderData(10, Qt::Horizontal, QString::fromUtf8("Fração R$"));
- m_StoreStock->setHeaderData(11, Qt::Horizontal, QString::fromUtf8("Estoque"));
- m_StoreStock->setHeaderData(12, Qt::Horizontal, QString::fromUtf8("Estado"));
- m_ui->tableViewStock->setModel(m_StoreStock);
- m_ui->tableViewStock->setItemDelegateForColumn(1, new ColumnObs);
- m_ui->tableViewStock->setItemDelegateForColumn(2, new ColumnPhone);
- m_ui->tableViewStock->setItemDelegateForColumn(7, new ColumnCenter);
- m_ui->tableViewStock->setItemDelegateForColumn(8, new ColumnCenter);
- m_ui->tableViewStock->setItemDelegateForColumn(9, new ColumnMoney);
- m_ui->tableViewStock->setItemDelegateForColumn(10, new ColumnMoney);
- m_ui->tableViewStock->setItemDelegateForColumn(11, new ColumnStock);
- m_ui->tableViewStock->setItemDelegateForColumn(12, new ColumnNetStatus);
- m_ui->tableViewStock->setColumnWidth(1, 220);
- m_ui->tableViewStock->setColumnWidth(2, 100);
- m_ui->tableViewStock->setColumnWidth(7, 80);
- m_ui->tableViewStock->setColumnWidth(8, 100);
- m_ui->tableViewStock->setColumnWidth(9, 80);
- m_ui->tableViewStock->setColumnWidth(10, 80);
- m_ui->tableViewStock->setColumnWidth(11, 80);
- m_ui->tableViewStock->setColumnWidth(12, 80);
- m_ui->tableViewStock->hideColumn(0);
- // m_ui->tableViewStock->hideColumn(1);
- // m_ui->tableViewStock->hideColumn(2);
- m_ui->tableViewStock->hideColumn(3);
- m_ui->tableViewStock->hideColumn(4);
- m_ui->tableViewStock->hideColumn(5);
- m_ui->tableViewStock->hideColumn(6);
- m_ui->tableViewStock->hideColumn(13);
- m_ui->tableViewStock->horizontalHeader()->setStretchLastSection(true);
- delete q;
- }
Add Comment
Please, Sign In to add comment