From a9d5d7f29fe1ab664c66d87e898ac34a03b044c2 Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期三, 31 一月 2024 23:37:04 +0800 Subject: [PATCH] 0131 --- internal_system_v1/clientmainwindow.cpp | 158 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 157 insertions(+), 1 deletions(-) diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp index fc02ffa..ab58567 100644 --- a/internal_system_v1/clientmainwindow.cpp +++ b/internal_system_v1/clientmainwindow.cpp @@ -1,4 +1,4 @@ -#include "clientmainwindow.h" +锘�#include "clientmainwindow.h" #include "ui_clientmainwindow.h" #include <QDebug> #include <QFileDialog> @@ -18,12 +18,34 @@ ui->dateEdit->setDate(QDate::currentDate()); g_auditDate = QDate::currentDate().toString("yyyy-MM-dd"); + ui->tableWidget->setColumnWidth(0,200); + ui->tableWidget->setColumnWidth(1,80); + ui->tableWidget->setColumnWidth(2,80); + ui->tableWidget->setColumnWidth(4,ui->tableWidget->columnWidth(4)+15); initUi(); + searchComName(); } ClientMainWindow::~ClientMainWindow() { delete ui; +} +void ClientMainWindow::searchComName() +{ + QSqlQuery query; + QString sql = QString("select id,name,code from company_info"); + if(query.exec(sql)){ + qDebug()<<"size:"<<query.numRowsAffected(); + while(query.next()){ + int id = query.value(0).toInt(); + QString name = query.value(1).toString(); + QString code = query.value(2).toString(); + qDebug()<<"com select:"<<id<<name; + m_comInfo[name] = id; + //m_comCode[name] = code; + ui->comboBox_company->addItem(name); + } + } } void ClientMainWindow::initUi() @@ -63,6 +85,10 @@ // 闅愯棌鎺夋煇涓�夐」 ui->tabWidget->removeTab(3); // OK + // 闂鏁存敼鍙拌处 + m_proRecStandingBook = new ProblemRectStandingBook(this); + ui->tabWidget->addTab(m_proRecStandingBook,"闂鏁存敼鍙拌处"); + // 鍏宠仈鍚勪釜鍔熻兘妲� connect(m_coverInfo,SIGNAL(sendComName(QString)),m_searchInfo,SLOT(addComName(QString))); @@ -74,6 +100,10 @@ connect(this,SIGNAL(sendDataToProblemNoMoney(QVariantList)),m_problemNotMon,SLOT(showData(QVariantList))); connect(this,SIGNAL(sendDataToPunish(QVariantList)),m_punish,SLOT(showData(QVariantList))); connect(this,SIGNAL(sendDataToCaseClue(QVariantList)),m_caseClue,SLOT(showData(QVariantList))); + + // 鏂扮増鏈� + m_conInfo2 = new ConverInfo2(this); + ui->tabWidget->addTab(m_conInfo2,"鍩烘湰淇℃伅"); } @@ -286,8 +316,134 @@ } +void ClientMainWindow::calc() +{ + for(int i=1;i<ui->tableWidget->rowCount();++i){ + int sum = 0; + for(int j=4;j<ui->tableWidget->columnCount();++j){ + sum += ui->tableWidget->item(i,j)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(sum))); + + if(i==7){ // 瀛﹀巻 + int val = 0; + for(int j = 8;j<=10;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==11){ // 鑱岀О + int val = 0; + for(int j = 12;j<=15;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==20){ // 鐭ヨ瘑缁撴瀯 + int val = 0; + for(int j = 21;j<=28;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==30){ // 瀹¤椤圭洰 + int val = 0; + for(int j = 31;j<=38;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==41){ // 瀹¤鍙戠幇闂閲戦 + int val = 0; + for(int j = 42;j<=43;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==43){ // 鍚堣鎬ч棶棰橀噾棰� + int val = 0; + for(int j = 44;j<=51;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==52){ // 瀹¤鍙戠幇闂涓暟 + int val = 0; + for(int j = 53;j<=54;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==54){ // 闈為噾棰濈被闂涓暟 + int val = 0; + for(int j = 55;j<=58;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==59){ // 瀹¤鍙戠幇闂鏁存敼(閲戦绫�) + int val = 0; + for(int j = 60;j<=65;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==66){ // 瀹¤鍙戠幇闂鏁存敼(闈為噾棰濈被) + int val = 0; + for(int j = 67;j<=70;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + + if(i==71){ // 澶勫垎 + int val = 0; + for(int j = 72;j<=74;++j){ + val += ui->tableWidget->item(j,3)->text().toInt(); + } + ui->tableWidget->setItem(i,3,new QTableWidgetItem(QString::number(val))); + } + } +} + void ClientMainWindow::on_dateEdit_dateChanged(const QDate &date) { g_auditDate = date.toString("yyyy-MM-dd"); qDebug()<<g_auditDate; } + +void ClientMainWindow::on_tableWidget_activated(const QModelIndex &index) +{ + qDebug()<<__FUNCTION__<<index; +} + +void ClientMainWindow::on_tableWidget_clicked(const QModelIndex &index) +{ + qDebug()<<__FUNCTION__<<index; +} + +void ClientMainWindow::on_tableWidget_itemEntered(QTableWidgetItem *item) +{ + qDebug()<<__FUNCTION__<<item; +} + +void ClientMainWindow::on_tableWidget_cellEntered(int row, int column) +{ + qDebug()<<__FUNCTION__<<row<<column; + calc(); +} + +void ClientMainWindow::on_tableWidget_cellClicked(int row, int column) +{ + qDebug()<<__FUNCTION__<<row<<column; + calc(); +} -- Gitblit v1.8.0