From d45c7472dd063b5d05e607e60647f8d6feb60736 Mon Sep 17 00:00:00 2001
From: wumu <mayi@mayi.com>
Date: 星期五, 15 三月 2024 23:33:38 +0800
Subject: [PATCH] 0315
---
internal_system_v1/clientmainwindow.cpp | 190 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 190 insertions(+), 0 deletions(-)
diff --git a/internal_system_v1/clientmainwindow.cpp b/internal_system_v1/clientmainwindow.cpp
index 0105edf..d8897d8 100644
--- a/internal_system_v1/clientmainwindow.cpp
+++ b/internal_system_v1/clientmainwindow.cpp
@@ -481,6 +481,161 @@
for(int i=1;i<ui->tableWidget->rowCount();++i){
qDebug()<<"data:"<<ui->tableWidget->item(i,1)->text()<<" "<<ui->tableWidget->item(i,3)->text();
}
+ // 鍏堝垽鏂叕鍙稿湪涓嶅湪锛屼笉鍦ㄥ垯鏂板锛屽湪鍒欎慨鏀�
+ QString sql = QString("select name from comprehensive_entry_info where name='%1'").arg(ui->comboBox_company->currentText());
+ qDebug()<<"sql select:"<<sql;
+ QSqlQuery query;
+ bool nameExsit = false;
+ if(query.exec(sql))
+ {
+ qDebug()<<QString("select comprehensive_entry_info ok...");
+ while (query.next()) {
+ nameExsit = true;
+ qDebug()<<"鍏徃鍚嶅瓨鍦�:"<<ui->comboBox_company->currentText();
+ break;
+ }
+ }else{
+ qDebug()<<QString("select comprehensive_entry_info fail...")<<query.lastError().text();
+ }
+ if(!nameExsit){
+ qDebug()<<"鍏徃鍚嶄笉瀛樺湪:"<<ui->comboBox_company->currentText();
+ // 鎻掑叆
+ sql = QString("insert into comprehensive_entry_info (name,_030000,_030001,_030100,_030101,_030200,_030210,_030220,_030221,_030222,_030223,_030230,\
+ _030231,\
+ _030232,\
+ _030233,\
+ _030234,\
+ _030240,\
+ _030241,\
+ _030242,\
+ _030243,\
+ _030250,\
+ _030251,\
+ _030252,\
+ _030253,\
+ _030254,\
+ _030255,\
+ _030256,\
+ _030257,\
+ _030258,\
+ _030260,\
+ _030300,\
+ _030301,\
+ _030302,\
+ _030303,\
+ _030304,\
+ _030305,\
+ _030306,\
+ _030307,\
+ _030308,\
+ _030310,\
+ _030400,\
+ _030500,\
+ _030510,\
+ _030520,\
+ _030521,\
+ _030522,\
+ _030523,\
+ _030524,\
+ _030525,\
+ _030526,\
+ _030527,\
+ _030528,\
+ _030600,\
+ _030610,\
+ _030620,\
+ _030621,\
+ _030622,\
+ _030623,\
+ _030624,\
+ _030700,\
+ _030701,\
+ _030702,\
+ _030703,\
+ _030704,\
+ _030705,\
+ _030706,\
+ _030800,\
+ _030801,\
+ _030802,\
+ _030803,\
+ _030804,\
+ _030900,\
+ _030901,\
+ _030902,\
+ _030903,\
+ _031000,\
+ _031001,\
+ company_type\
+ ) values ('%1','%2','%3','%4','%5','%6','%7','%8','%9','%10','%11','%12','%13','%14','%15','%16','%17','%18','%19','%20','%21','%22','%23','%24','%25','%26'"
+ ",'%27','%28','%29','%30','%31','%32','%33','%34','%35','%36','%37','%38','%39','%40','%41','%42','%43','%44','%45','%46','%47','%48','%49','%50','%51'"
+ ",'%52','%53','%54','%55','%56','%57','%58','%59','%60','%61','%62','%63','%64','%65','%66','%67','%68','%69','%70','%71','%72','%73','%74','%75','%76'"
+ ",'%77','%78')").arg(ui->comboBox_company->currentText()).arg(ui->tableWidget->item(1,3)->text())
+ .arg(ui->tableWidget->item(2,3)->text()).arg(ui->tableWidget->item(3,3)->text()).arg(ui->tableWidget->item(4,3)->text()).arg(ui->tableWidget->item(5,3)->text()).arg(ui->tableWidget->item(6,3)->text())
+ .arg(ui->tableWidget->item(7,3)->text()).arg(ui->tableWidget->item(8,3)->text()).arg(ui->tableWidget->item(9,3)->text()).arg(ui->tableWidget->item(10,3)->text()).arg(ui->tableWidget->item(11,3)->text())
+ .arg(ui->tableWidget->item(12,3)->text()).arg(ui->tableWidget->item(13,3)->text()).arg(ui->tableWidget->item(14,3)->text()).arg(ui->tableWidget->item(15,3)->text()).arg(ui->tableWidget->item(16,3)->text())
+ .arg(ui->tableWidget->item(17,3)->text()).arg(ui->tableWidget->item(18,3)->text()).arg(ui->tableWidget->item(19,3)->text()).arg(ui->tableWidget->item(20,3)->text()).arg(ui->tableWidget->item(21,3)->text())
+ .arg(ui->tableWidget->item(22,3)->text()).arg(ui->tableWidget->item(23,3)->text()).arg(ui->tableWidget->item(24,3)->text()).arg(ui->tableWidget->item(25,3)->text()).arg(ui->tableWidget->item(26,3)->text())
+ .arg(ui->tableWidget->item(27,3)->text()).arg(ui->tableWidget->item(28,3)->text()).arg(ui->tableWidget->item(29,3)->text()).arg(ui->tableWidget->item(30,3)->text()).arg(ui->tableWidget->item(31,3)->text())
+ .arg(ui->tableWidget->item(32,3)->text()).arg(ui->tableWidget->item(33,3)->text()).arg(ui->tableWidget->item(34,3)->text()).arg(ui->tableWidget->item(35,3)->text()).arg(ui->tableWidget->item(36,3)->text())
+ .arg(ui->tableWidget->item(37,3)->text()).arg(ui->tableWidget->item(38,3)->text()).arg(ui->tableWidget->item(39,3)->text()).arg(ui->tableWidget->item(40,3)->text()).arg(ui->tableWidget->item(41,3)->text())
+ .arg(ui->tableWidget->item(42,3)->text()).arg(ui->tableWidget->item(43,3)->text()).arg(ui->tableWidget->item(44,3)->text()).arg(ui->tableWidget->item(45,3)->text()).arg(ui->tableWidget->item(46,3)->text())
+ .arg(ui->tableWidget->item(47,3)->text()).arg(ui->tableWidget->item(48,3)->text()).arg(ui->tableWidget->item(49,3)->text()).arg(ui->tableWidget->item(50,3)->text()).arg(ui->tableWidget->item(51,3)->text())
+ .arg(ui->tableWidget->item(52,3)->text()).arg(ui->tableWidget->item(53,3)->text()).arg(ui->tableWidget->item(54,3)->text()).arg(ui->tableWidget->item(55,3)->text()).arg(ui->tableWidget->item(56,3)->text())
+ .arg(ui->tableWidget->item(57,3)->text()).arg(ui->tableWidget->item(58,3)->text()).arg(ui->tableWidget->item(59,3)->text()).arg(ui->tableWidget->item(60,3)->text()).arg(ui->tableWidget->item(61,3)->text())
+ .arg(ui->tableWidget->item(62,3)->text()).arg(ui->tableWidget->item(63,3)->text()).arg(ui->tableWidget->item(64,3)->text()).arg(ui->tableWidget->item(65,3)->text()).arg(ui->tableWidget->item(66,3)->text())
+ .arg(ui->tableWidget->item(67,3)->text()).arg(ui->tableWidget->item(68,3)->text()).arg(ui->tableWidget->item(69,3)->text()).arg(ui->tableWidget->item(70,3)->text()).arg(ui->tableWidget->item(71,3)->text())
+ .arg(ui->tableWidget->item(72,3)->text()).arg(ui->tableWidget->item(73,3)->text()).arg(ui->tableWidget->item(74,3)->text()).arg(ui->tableWidget->item(75,3)->text()).arg(ui->tableWidget->item(76,3)->text())
+ .arg(ui->comboBox->currentText());
+
+ qDebug()<<"comprehensive_entry_info insert sql:"<<sql;
+ if(query.exec(sql)){
+ qDebug()<<"comprehensive_entry_info insert sql ok";
+ QMessageBox::information(this,"鏂版暟鎹綍鍏ユ垚鍔�",QString("鏂板綍鍏ュ叕鍙革細%1 淇℃伅鎴愬姛銆�").arg(ui->comboBox_company->currentText()));
+ }else{
+ qDebug()<<"comprehensive_entry_info insert sql fail:"<<query.lastError().text();
+ QMessageBox::information(this,"鏂版暟鎹綍鍏ュけ璐�",QString("鏂板綍鍏ュ叕鍙革細%1 淇℃伅澶辫触銆�").arg(ui->comboBox_company->currentText()));
+ }
+
+ }else{
+ // 鏇存柊
+
+ sql = QString("update comprehensive_entry_info set _030000='%1',_030001='%2',_030100='%3',_030101='%4',_030200='%5',_030210='%6',_030220='%7',_030221='%8',_030222='%9',_030223='%10',_030230='%11'"
+ ",_030231='%12',_030232='%13',_030233='%14',_030234='%15',_030240='%16',_030241='%17',_030242='%18',_030243='%19',_030250='%20',_030251='%21'"
+ ",_030252='%22',_030253='%23',_030254='%24',_030255='%25',_030256='%26',_030257='%27',_030258='%28',_030260='%29',_030300='%30',_030301='%31'"
+ ",_030302='%32',_030303='%33',_030304='%34',_030305='%35',_030306='%36',_030307='%37',_030308='%38',_030310='%39',_030400='%40',_030500='%41'"
+ ",_030510='%42',_030520='%43',_030521='%44',_030522='%45',_030523='%46',_030524='%47',_030525='%48',_030526='%49',_030527='%50',_030528='%51'"
+ ",_030600='%52',_030610='%53',_030620='%54',_030621='%55',_030622='%56',_030623='%57',_030624='%58',_030700='%59',_030701='%60',_030702='%61'"
+ ",_030703='%62',_030704='%63',_030705='%64',_030706='%65',_030800='%66',_030801='%67',_030802='%68',_030803='%69',_030804='%70',_030900='%71'"
+ ",_030901='%72',_030902='%73',_030903='%74',_031000='%75',_031001='%76',company_type='%77' where name='%78'").arg(ui->tableWidget->item(1,3)->text())
+ .arg(ui->tableWidget->item(2,3)->text()).arg(ui->tableWidget->item(3,3)->text()).arg(ui->tableWidget->item(4,3)->text()).arg(ui->tableWidget->item(5,3)->text()).arg(ui->tableWidget->item(6,3)->text())
+ .arg(ui->tableWidget->item(7,3)->text()).arg(ui->tableWidget->item(8,3)->text()).arg(ui->tableWidget->item(9,3)->text()).arg(ui->tableWidget->item(10,3)->text()).arg(ui->tableWidget->item(11,3)->text())
+ .arg(ui->tableWidget->item(12,3)->text()).arg(ui->tableWidget->item(13,3)->text()).arg(ui->tableWidget->item(14,3)->text()).arg(ui->tableWidget->item(15,3)->text()).arg(ui->tableWidget->item(16,3)->text())
+ .arg(ui->tableWidget->item(17,3)->text()).arg(ui->tableWidget->item(18,3)->text()).arg(ui->tableWidget->item(19,3)->text()).arg(ui->tableWidget->item(20,3)->text()).arg(ui->tableWidget->item(21,3)->text())
+ .arg(ui->tableWidget->item(22,3)->text()).arg(ui->tableWidget->item(23,3)->text()).arg(ui->tableWidget->item(24,3)->text()).arg(ui->tableWidget->item(25,3)->text()).arg(ui->tableWidget->item(26,3)->text())
+ .arg(ui->tableWidget->item(27,3)->text()).arg(ui->tableWidget->item(28,3)->text()).arg(ui->tableWidget->item(29,3)->text()).arg(ui->tableWidget->item(30,3)->text()).arg(ui->tableWidget->item(31,3)->text())
+ .arg(ui->tableWidget->item(32,3)->text()).arg(ui->tableWidget->item(33,3)->text()).arg(ui->tableWidget->item(34,3)->text()).arg(ui->tableWidget->item(35,3)->text()).arg(ui->tableWidget->item(36,3)->text())
+ .arg(ui->tableWidget->item(37,3)->text()).arg(ui->tableWidget->item(38,3)->text()).arg(ui->tableWidget->item(39,3)->text()).arg(ui->tableWidget->item(40,3)->text()).arg(ui->tableWidget->item(41,3)->text())
+ .arg(ui->tableWidget->item(42,3)->text()).arg(ui->tableWidget->item(43,3)->text()).arg(ui->tableWidget->item(44,3)->text()).arg(ui->tableWidget->item(45,3)->text()).arg(ui->tableWidget->item(46,3)->text())
+ .arg(ui->tableWidget->item(47,3)->text()).arg(ui->tableWidget->item(48,3)->text()).arg(ui->tableWidget->item(49,3)->text()).arg(ui->tableWidget->item(50,3)->text()).arg(ui->tableWidget->item(51,3)->text())
+ .arg(ui->tableWidget->item(52,3)->text()).arg(ui->tableWidget->item(53,3)->text()).arg(ui->tableWidget->item(54,3)->text()).arg(ui->tableWidget->item(55,3)->text()).arg(ui->tableWidget->item(56,3)->text())
+ .arg(ui->tableWidget->item(57,3)->text()).arg(ui->tableWidget->item(58,3)->text()).arg(ui->tableWidget->item(59,3)->text()).arg(ui->tableWidget->item(60,3)->text()).arg(ui->tableWidget->item(61,3)->text())
+ .arg(ui->tableWidget->item(62,3)->text()).arg(ui->tableWidget->item(63,3)->text()).arg(ui->tableWidget->item(64,3)->text()).arg(ui->tableWidget->item(65,3)->text()).arg(ui->tableWidget->item(66,3)->text())
+ .arg(ui->tableWidget->item(67,3)->text()).arg(ui->tableWidget->item(68,3)->text()).arg(ui->tableWidget->item(69,3)->text()).arg(ui->tableWidget->item(70,3)->text()).arg(ui->tableWidget->item(71,3)->text())
+ .arg(ui->tableWidget->item(72,3)->text()).arg(ui->tableWidget->item(73,3)->text()).arg(ui->tableWidget->item(74,3)->text()).arg(ui->tableWidget->item(75,3)->text()).arg(ui->tableWidget->item(76,3)->text())
+ .arg(ui->comboBox->currentText()).arg(ui->comboBox_company->currentText());
+
+ qDebug()<<"update sql:"<<sql;
+ if(query.exec(sql)){
+ qDebug()<<"update ok:comprehensive_entry_info";
+ QMessageBox::information(this,"鏇存柊褰曞叆鎴愬姛",QString("褰曞叆鍏徃锛�%1 淇℃伅鎴愬姛銆�").arg(ui->comboBox_company->currentText()));
+ }else{
+ qDebug()<<"update fail:comprehensive_entry_info"<<query.lastError().text();
+ QMessageBox::information(this,"鏇存柊褰曞叆澶辫触",QString("鏂板綍鍏ュ叕鍙革細%1 淇℃伅澶辫触銆�").arg(ui->comboBox_company->currentText()));
+ }
+ }
+
+
}
void ClientMainWindow::on_comboBox_currentIndexChanged(const QString &arg1)
@@ -515,3 +670,38 @@
}
}
+
+void ClientMainWindow::on_pushButton_reset_clicked()
+{
+ // 閲嶇疆鏌愪竴鍒楁暟鎹�
+ QString curText = ui->comboBox_2->currentText();
+ int index = 4;
+ if(curText == "浼佷笟(涓嶅惈閲戣瀺浼佷笟)"){
+ index = 4;
+ }else if(curText == "閲戣瀺浼佷笟"){
+ index = 5;
+ }else if(curText == "鏈哄叧"){
+ index = 6;
+ }else if(curText == "浜嬩笟鍗曚綅"){
+ index = 7;
+ }else if(curText == "鍏朵粬"){
+ index = 8;
+ }
+ qDebug()<<"閲嶇疆鍒楃储寮�:"<<index;
+
+ QMessageBox::StandardButton rb = QMessageBox::question ( \
+ this, "閲嶈鎻愮ず", QString("浣犵‘瀹氳閲嶇疆:%1 褰撳墠鍒楁暟鎹悧").arg(curText), \
+ QMessageBox::Yes | QMessageBox::No, QMessageBox::Yes );
+
+ if ( rb == QMessageBox::Yes ) {
+ for(int i=1;i<ui->tableWidget->rowCount();++i){
+ ui->tableWidget->item(i,index)->setData(Qt::EditRole,"0");
+ }
+ qDebug()<<"閲嶇疆";
+ }else{
+ qDebug()<<"涓嶉噸缃�";
+ }
+
+
+
+}
--
Gitblit v1.8.0