| | |
|---|
| | | QString webSite = ui->lineEdit_webSite->text(); |
|---|
| | | |
|---|
| | | // 单位组织结构情况 |
|---|
| | | QString hasUpLegal = ui->comboBox_hasUpLegal->currentText(); |
|---|
| | | QString upCreditCode = ui->lineEdit_upCreditCode->text(); |
|---|
| | | QString oldCreditCode = ui->lineEdit_oldCreditCode->text(); |
|---|
| | | QString upName = ui->lineEdit_upName->text(); |
|---|
| | | |
|---|
| | | // 总审计师与内审机构基本情况 |
|---|
| | | QString hasChiefDesigner = ui->comboBox_hasChiefDesigner->currentText(); |
|---|
| | | QString ChiefDesignerLevel = ui->comboBox_ChiefDesignerLevel->currentText(); |
|---|
| | | QString employmentMode = ui->comboBox_employmentMode->currentText(); |
|---|
| | | QString hasSetIntervalAudit = ui->comboBox_hasSetIntervalAudit->currentText(); |
|---|
| | | QString internalName = ui->lineEdit_internalName->text(); |
|---|
| | | QString leadingOrganization = ui->comboBox_leadingOrganization->currentText(); |
|---|
| | | QString hasSetSeparateIA = ui->comboBox_hasSetSeparateIA->currentText(); |
|---|
| | | bool financeDepartment = ui->checkBox_financeDepartment->isChecked(); |
|---|
| | | bool legalDepartment = ui->checkBox_legalDepartment->isChecked(); |
|---|
| | | bool internalConDepart = ui->checkBox_internalConDepart->isChecked(); |
|---|
| | | bool disceplineInDepart = ui->checkBox_disceplineInDepart->isChecked(); |
|---|
| | | bool otherDepart = ui->checkBox_otherDepart->isChecked(); |
|---|
| | | QString intavalAuditLeval = ui->comboBox_intavalAuditLeval->currentText(); |
|---|
| | | |
|---|
| | | // 四、内审人员配备基本情况 |
|---|
| | | int organazationNum = ui->lineEdit_organazationNum->text().toInt(); |
|---|
| | | int realNum = ui->lineEdit_realNum->text().toInt(); |
|---|
| | | int professionalNum = ui->lineEdit_professionalNum->text().toInt(); |
|---|
| | | int CIANum = ui->lineEdit_CIANum->text().toInt(); |
|---|
| | | int masterNum = ui->lineEdit_masterNum->text().toInt(); |
|---|
| | | int undergraduatesNum = ui->lineEdit_undergraduatesNum->text().toInt(); |
|---|
| | | int juniorNum = ui->lineEdit_juniorNum->text().toInt(); |
|---|
| | | int seniorNum = ui->lineEdit_seniorNum->text().toInt(); |
|---|
| | | int intermediateNum = ui->lineEdit_intermediateNum->text().toInt(); |
|---|
| | | int primaryNum = ui->lineEdit_primaryNum->text().toInt(); |
|---|
| | | int noTitleNum = ui->lineEdit_noTitleNum->text().toInt(); |
|---|
| | | int upFiftyOldNum = ui->lineEdit_upFiftyOldNum->text().toInt(); |
|---|
| | | int upThirtyOldNum = ui->lineEdit_upThirtyOldNum->text().toInt(); |
|---|
| | | int downThirtyOldNum = ui->lineEdit_downThirtyOldNum->text().toInt(); |
|---|
| | | int auditNum = ui->lineEdit_auditNum->text().toInt(); |
|---|
| | | int accountingNum = ui->lineEdit_accountingNum->text().toInt(); |
|---|
| | | int economyNum = ui->lineEdit_economyNum->text().toInt(); |
|---|
| | | int lawNum = ui->lineEdit_lawNum->text().toInt(); |
|---|
| | | int managerNum = ui->lineEdit_managerNum->text().toInt(); |
|---|
| | | int itNum = ui->lineEdit_itNum->text().toInt(); |
|---|
| | | int engineeringNum = ui->lineEdit_engineeringNum->text().toInt(); |
|---|
| | | int otherNum = ui->lineEdit_otherNum->text().toInt(); |
|---|
| | | |
|---|
| | | // 后面的4个信息 |
|---|
| | | QString statisticalConOfficer = ui->lineEdit_statisticalConOfficer->text(); |
|---|
| | | QString personFilling = ui->lineEdit_personFilling->text(); |
|---|
| | | QString officerTel = ui->lineEdit_officerTel->text(); |
|---|
| | | QString fillingDateTime = ui->lineEdit_fillingDateTime->text(); |
|---|
| | | |
|---|
| | | qDebug()<<"统计负责人"<<statisticalConOfficer; |
|---|
| | | |
|---|
| | | // 更新到map中 |
|---|
| | | auto &curComInfo = m_nameAndComInfos[name]; |
|---|
| | | strcpy(curComInfo.creditCode,creditCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.name,name.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.comType,comType.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.business,business.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.businessCode,businessCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.addr,addr.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.areaCode,areaCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.townCode,townCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.scale,scale.toLocal8Bit().data()); |
|---|
| | | curComInfo.people = people.toInt(); |
|---|
| | | strcpy(curComInfo.representative,representative.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.standardType,standardType.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.trunkCode,trunkCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.fixedTel,fixedTel.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.postCode,postCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.email,email.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.webSite,webSite.toLocal8Bit().data()); |
|---|
| | | |
|---|
| | | // 二 |
|---|
| | | strcpy(curComInfo.hasUpLegal,hasUpLegal.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.upCreditCode,upCreditCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.oldCreditCode,oldCreditCode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.upName,upName.toLocal8Bit().data()); |
|---|
| | | |
|---|
| | | // 三 |
|---|
| | | strcpy(curComInfo.hasChiefDesigner,hasChiefDesigner.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.ChiefDesignerLevel,ChiefDesignerLevel.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.employmentMode,employmentMode.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.hasSetIntervalAudit,hasSetIntervalAudit.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.internalName,internalName.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.leadingOrganization,leadingOrganization.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.hasSetSeparateIA,hasSetSeparateIA.toLocal8Bit().data()); |
|---|
| | | curComInfo.financeDepartment = financeDepartment; |
|---|
| | | curComInfo.legalDepartment = legalDepartment; |
|---|
| | | curComInfo.internalConDepart = internalConDepart; |
|---|
| | | curComInfo.disceplineInDepart = disceplineInDepart; |
|---|
| | | curComInfo.otherDepart = otherDepart; |
|---|
| | | strcpy(curComInfo.intavalAuditLeval,intavalAuditLeval.toLocal8Bit().data()); |
|---|
| | | |
|---|
| | | // 四 |
|---|
| | | curComInfo.organazationNum = organazationNum; |
|---|
| | | curComInfo.realNum = realNum; |
|---|
| | | curComInfo.professionalNum = professionalNum; |
|---|
| | | curComInfo.CIANum = CIANum; |
|---|
| | | curComInfo.masterNum = masterNum; |
|---|
| | | curComInfo.undergraduatesNum = undergraduatesNum; |
|---|
| | | curComInfo.juniorNum = juniorNum; |
|---|
| | | curComInfo.seniorNum = seniorNum; |
|---|
| | | curComInfo.intermediateNum = intermediateNum; |
|---|
| | | curComInfo.primaryNum = primaryNum; |
|---|
| | | curComInfo.noTitleNum = noTitleNum; |
|---|
| | | curComInfo.upFiftyOldNum = upFiftyOldNum; |
|---|
| | | curComInfo.upThirtyOldNum = upThirtyOldNum; |
|---|
| | | curComInfo.downThirtyOldNum = downThirtyOldNum; |
|---|
| | | curComInfo.auditNum = auditNum; |
|---|
| | | curComInfo.accountingNum = accountingNum; |
|---|
| | | curComInfo.economyNum = economyNum; |
|---|
| | | curComInfo.lawNum = lawNum; |
|---|
| | | curComInfo.managerNum = managerNum; |
|---|
| | | curComInfo.itNum = itNum; |
|---|
| | | curComInfo.engineeringNum = engineeringNum; |
|---|
| | | curComInfo.otherNum = otherNum; |
|---|
| | | |
|---|
| | | // 后4个信息 |
|---|
| | | strcpy(curComInfo.statisticalConOfficer,statisticalConOfficer.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.personFilling,personFilling.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.officerTel,officerTel.toLocal8Bit().data()); |
|---|
| | | strcpy(curComInfo.fillingDateTime,fillingDateTime.toLocal8Bit().data()); |
|---|
| | | |
|---|
| | | |
|---|
| | | // 更新到数据库 |
|---|
| | | |
|---|
| | | // 先判断是不是已经存在公司名了，若已存在，则更新，不存在则插入 |
|---|
| | | QString sql = QString("select id,name from all_company_info where name='%1'").arg(name); |
|---|
| | | QSqlQuery query; |
|---|
| | | int rowCnt = 0; |
|---|
| | | if(query.exec(sql)){ |
|---|
| | | qDebug()<<"size:"<<query.size(); |
|---|
| | | |
|---|
| | | while (query.next()) { |
|---|
| | | rowCnt++; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if(rowCnt == 0){ |
|---|
| | | // 不存在，则插入一条新数据 |
|---|
| | | }else{ |
|---|
| | | // 更新 |
|---|
| | | } |
|---|
| | | } |
|---|
