|
etquery.exec("insert into tb_goods values('123456789', 'aaa')"); setquery.exec("insert into tb_goods values('23456789', 'aaeffdda')"); setquery.exec("insert into tb_barcode(barcode,rfid) values('adddaeee', '123456789')"); reflushModel(); } //这里应该问题不是很大 void mysql::on_deleteButton_clicked() { QSqlQuery setquery(QSqlDatabase::database("file", true)); setquery.exec("delete from tb_goods where rfid='123456789'"); reflushModel(); } void mysql::on_updateButton_clicked() { QSqlQuery setquery(QSqlDatabase::database("file", true)); setquery.exec("update tb_goods set name='redddd' where rfid='123456789'"); reflushModel(); } void mysql::reflushModel() { m_goodsmodel.setQuery("select * from tb_goods", QSqlDatabase::database("file", true)); m_barcodemodel.setQuery("select * from tb_barcode", QSqlDatabase::database("file", true)); } void mysql::setAttibutes(QTableView* pView, int nHeaderHeight, int nColumnHeight) { if ( pView == NULL ) { QString strTemp = QStringLiteral("pView== NULL！设置表格属性失败！"); return; } pView->horizontalHeader()->setFixedHeight(nHeaderHeight); //设置表头的高度 pView->horizontalHeader()->setSectionsClickable(false); //设置表头不可点击（默认点击后进行排序） pView->horizontalHeader()->setStretchLastSection(true); //最后一列占满剩余空白 pView->setSelectionBehavior(QAbstractItemView::SelectRows); //设置选择行为时每次选择一行 pView->setEditTriggers(QAbstractItemView::NoEditTriggers); //使表视图只读 pView->verticalHeader()->setDefaultSectionSize(nColumnHeight); //设置行高 pView->setAlternatingRowColors(true); //可以交替颜色显示 pView->setShowGrid(false); //设置不显示格子线 pView->setCornerButtonEnabled(false); //左上角的按钮不可用，此按钮功能，一点击，全选 pView->horizontalScrollBar()->setStyleSheet( "QScrollBar:horizontal{height:10px;background:transparent;background-color:rgb(248, 248, 248);margin:0px,0px,0px,0px;padding-left:10px;padding-right:10px;}" "QScrollBar::handle:horizontal{height:10px;background:lightgray;border-radius:5px;/*min-height:20;*/}" "QScrollBar::handle:horizontal:hover{height:10px;background:gray;border-radius:5px;/*min-height:20;*/}" "QScrollBar::add-line:horizontal{/*height:10px;width:10px;*/border-image:url(:/button/images/button/right.png);/*subcontrol-position:right;*/}" "QScrollBar::sub-line:horizontal{/*height:10px;width:10px;*/border-image:url(:/button/images/button/left.png);/*subcontrol-position:left;*/}" "QScrollBar::add-line:horizontal:hover{/*height:10px;width:10px;*/border-image:url(:/button/images/button/right_mouseDown.png);/*subcontrol-position:right;*/}" "QScrollBar::sub-line:horizontal:hover{/*height:10px;width:10px;*/border-image:url(:/button/images/button/left_mouseDown.png);/*subcontrol-position:left;*/}" "QScrollBar::add-page:horizontal,QScrollBar::sub-page:horizontal{background:transparent;border-radius:5px;}" ); pView->verticalScrollBar()->setStyleSheet( "QScrollBar:vertical{width:10px;background:transparent;background-color:rgb(248, 248, 248);margin:0px,0px,0px,0px;padding-top:10px;padding-bottom:10px;}" "QScrollBar::handle:vertical{width:10px;background:lightgray ;border-radius:5px;min-height:20;}" "QScrollBar::handle:vertical:hover{width:10px;background:gray;border-radius:5px;min-height:20;}" "QScrollBar::add- |