From 0af28ca563f556e8d08d03c16a8da8a1741f65d4 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期二, 24 十月 2023 23:33:39 +0800
Subject: [PATCH] 1024
---
internal_system_v1/clientmainwindow.cpp | 158 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 156 insertions(+), 2 deletions(-)
diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp
index ee72cbb..33181fa 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>
@@ -7,6 +7,7 @@
#include <QSqlRecord>
extern int g_comId;
+extern QString g_dataRootPath;
QString g_auditDate;
ClientMainWindow::ClientMainWindow(QWidget *parent) :
@@ -17,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()
@@ -61,6 +84,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)));
@@ -107,7 +134,8 @@
if(comName.isValid()){
if(!readDataFromSQL(comName.toString())){
QMessageBox::information(this,"瀵煎叆涓柇","璇风‘璁ゅ叕鍙稿熀鏈俊鎭凡缁忓瓨鍦�");
- return;
+ break;
+ //return;
}
qDebug()<<comName<<g_comId;
}
@@ -284,8 +312,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