예제 #1
0
QVector<InternalPaymentItem *> ClinicInternalPayment::selectFromDB(QDate startDate, QDate endDate)
{
    QVector<InternalPaymentItem *> result;
    if(myDB::connectDB())
    {
        QString strClumn = "ChinicReceipt";
        QVector<QString> Receipt = getDistinctFromDB(strClumn , strClinicChargeDetails);

        QSqlQueryModel *sqlModel = new QSqlTableModel;
        for(int i=0;i<Receipt.size();i++)
        {
            InternalPaymentItem *item = new InternalPaymentItem;
            item->m_strName = Receipt.at(i);

            QString startTime = startDate.toString("yyyy-MM-dd") + "T00:00:00";
            QString endTime = endDate.toString("yyyy-MM-dd") + "T23:59:59";
            sqlModel->setQuery("Select * from " + strClinicChargeDetails +
                               " where "+ strClumn + "= \'" + item->m_strName +
                               "\' and chargeid in (select id from cliniccharge where time between \'" +
                               startTime +
                               "\' and \'" +
                               endTime + "\')");
            for(int j = 0;j<sqlModel->rowCount();j++)
            {
                int nCount = sqlModel->record(j).value("ChargeItemCount").toInt();
                double nPrice = sqlModel->record(j).value("ChargeItemPrice").toDouble();
                item->m_dDueIncome += nCount*nPrice;
            }
            result.append(item);
        }
    }

    return result;
}
예제 #2
0
파일: log.cpp 프로젝트: n4ogw/so2sdr
/*!
   qso number sent for last qso in log
 */
int Log::lastNr() const
{
    QSqlQueryModel m;
#if QT_VERSION < 0x050000
    m.setQuery("SELECT * FROM log where valid='true'", db);
#else
    m.setQuery("SELECT * FROM log where valid=1", db);
#endif
    while (m.canFetchMore()) {
        m.fetchMore();
    }
    if (m.rowCount()) {
        QByteArray snt[MAX_EXCH_FIELDS];
        snt[0] = m.record(m.rowCount() - 1).value(SQL_COL_SNT1).toByteArray();
        snt[1] = m.record(m.rowCount() - 1).value(SQL_COL_SNT2).toByteArray();
        snt[2] = m.record(m.rowCount() - 1).value(SQL_COL_SNT3).toByteArray();
        snt[3] = m.record(m.rowCount() - 1).value(SQL_COL_SNT4).toByteArray();
        bool ok = false;
        int  nr = snt[nrField].toInt(&ok, 10);
        if (!ok) nr = 0;
        return(nr);
    } else {
        return(0);
    }
}
예제 #3
0
void Gconsignaciones::CargarDasignar(){
    QSqlQueryModel idunicomodel;
    QString selec="SELECT Id_pro, cantidad, Pconsig FROM Producto where (nombre='"+ui->productocomboBox2->currentText()+"')";
    idunicomodel.setQuery(selec);
    int id_pro=idunicomodel.record(0).value("Id_pro").toInt();
    int cantidad=idunicomodel.record(0).value("cantidad").toInt();
    double precio=idunicomodel.record(0).value("Pconsig").toDouble();
    ui->costo2spinbox->setValue(precio);
    ui->cantidad2->setRange(1, cantidad);
    ui->id2spinbox->setValue(id_pro);
}
void SingleWeatherParamWidget::onAirportChanged(QString apCode, QString pName){
    //清空
    QList<int> keyList = editHash.keys();
    for(int key : keyList){
        QList<QLineEdit *> editList = editHash[key];
        for(QLineEdit *edit : editList){
            edit->setText("");
        }
    }

    //赋值
    currentApCode = apCode;
    currentPName = pName;
    weatherParamSetupList.clear();
    QString queryStr = QString("select * from weatherparamsetup where code = '%1' and planename = '%2' order by paramid")
            .arg(currentApCode)
            .arg(currentPName);
    QSqlQueryModel *plainModel = pgDb->queryModel(queryStr);
    int rowCount = plainModel->rowCount();
    for(int i = 0;i < rowCount;i++){
        WeatherParamSetup weatherParamSetup;
        weatherParamSetup.setCode(plainModel->record(i).value(0).toString());
        weatherParamSetup.setPlaneName(plainModel->record(i).value(1).toString());
        weatherParamSetup.setParamid(plainModel->record(i).value(2).toInt());
        weatherParamSetup.setLimits(plainModel->record(i).value(3).toString());
        bool isExist = false;
        for(WeatherParam weatherParam : weatherParamList){
            if(weatherParam.id() == weatherParamSetup.paramid()){
                isExist = true;
                break;
            }
        }
        if(isExist){
            weatherParamSetupList.append(weatherParamSetup);
        }
    }
    delete plainModel;
    for(WeatherParamSetup weatherParamSetup : weatherParamSetupList){
        int key = weatherParamSetup.paramid();
        QString limitJson = weatherParamSetup.limits();
        QList<QString> valueList = this->getDataFromJson(limitJson);
        QList<QLineEdit *> editList = editHash[key];
        int valueCount = valueList.count();
        int editCount = editList.count();
        for(int i = 0;i < editCount;i++){
            QLineEdit *edit = editList[i];
            if(valueCount != editCount){
                edit->setText("");
            }else{
                edit->setText(valueList[i]);
            }
        }
    }
}
예제 #5
0
void shift_work::init_data()
{
    QString date1 = ui->label_7->text();
    QString date2 = ui->label_8->text();
    QSqlQueryModel model;
    model.setQuery(QString("select count(a.ch_tableno), ifnull(sum(a.int_person), 0)from cey_u_table a , cey_u_checkout_master b where a.ch_payno =b.ch_payno and b.ch_state ='Y' and(b.vch_operID ='%1')and(b.dt_operdate >= '%2' and b.dt_operdate <='%3' )").arg(n_func::gs_operid).arg(date1).arg(date2));
    taishu = model.record(0).value(0).toString();
    renshu = model.record(0).value(1).toString();

    model.clear();
    model.setQuery(QString("Select ifnull(sum(num_cost), 0), ifnull(sum(num_discount), 0), ifnull(sum(num_present), 0), ifnull(sum(num_service), 0), ifnull(sum(num_lowcost), 0), ifnull(sum(num_blotout), 0), ifnull(sum (ifnull( num_free ,0)) , 0 ),ifnull(sum(num_cost), 0 )+ ifnull(sum(num_rate), 0 )- ifnull(sum(num_discount), 0)-ifnull(sum(num_present), 0)+ifnull(sum(num_service), 0)+ ifnull(sum(num_lowcost), 0)-ifnull(sum(num_blotout), 0)-ifnull(sum (ifnull(num_free,0 )) , 0 ),ifnull(sum(num_rate), 0)from cey_u_checkout_master where ch_state ='Y' and(vch_operID ='%1')and(dt_operdate >= '%2' and dt_operdate <= '%3' )").arg(n_func::gs_operid).arg(date1).arg(date2));
    xiaofei = QString().sprintf("%0.2f",model.record(0).value(0).toFloat());
    zhekou = QString().sprintf("%0.2f",model.record(0).value(1).toFloat());
    zengsong = QString().sprintf("%0.2f",model.record(0).value(2).toFloat());
    fuwufei = QString().sprintf("%0.2f",model.record(0).value(3).toFloat());
    dixiao = QString().sprintf("%0.2f",model.record(0).value(4).toFloat());
    moling = QString().sprintf("%0.2f",model.record(0).value(5).toFloat());
    miandan = QString().sprintf("%0.2f",model.record(0).value(6).toFloat());
    yingshou = QString().sprintf("%0.2f",model.record(0).value(7).toFloat());
    shuishou = QString().sprintf("%0.2f",model.record(0).value(8).toFloat());

    //    model.clear();
    //    model.setQuery(QString("Select ifnull(sum(num_deposit), 0) from t_m_deposit where(vch_operID ='%1')and(dt_operdate >= '%2' and dt_operdate <= '%3')").arg(n_func::gs_operid).arg(date1).arg(date2));
    //    kafue = QString().sprintf("%0.2f",model.record(0).value(0).toFloat());//充值金额
    //    qDebug() << model.query().lastQuery();

    //    model.clear();
    //    model.setQuery(QString("Select ifnull(sum(num_realamount), 0) from t_m_deposit where(vch_operID ='%1')and(dt_operdate >= '%2' and dt_operdate <= '%3' )").arg(n_func::gs_operid).arg(date1).arg(date2));
    //    kafue_realamount = QString().sprintf("%0.2f",model.record(0).value(0).toFloat());//充值实收
    //    qDebug() << model.query().lastQuery();
}
예제 #6
0
void shift_work::init_table()
{
    QString date1 = ui->label_7->text();
    QString date2 = ui->label_8->text();
    QSqlQueryModel model;
    QSettings conf(public_sql::settings_ini_dir_file, QSettings::IniFormat);

    model_top = new QStandardItemModel();
    model_rfb = new QStandardItemModel();
    model_top->setHorizontalHeaderLabels(QStringList()<<tr("收款方式")<<tr("收款次数")<<tr("收款金额")<<tr("面额"));
    model_rfb->setHorizontalHeaderLabels(QStringList()<<tr("会员卡操作方式")<<tr("操作次数")<<tr("金额"));
    ui->tableView->setEditTriggers(QAbstractItemView::NoEditTriggers);ui->tableView->setModel(model_top);
    ui->tableView_2->setEditTriggers(QAbstractItemView::NoEditTriggers);ui->tableView_2->setModel(model_rfb);
#if QT_VERSION >= QT_VERSION_CHECK(5,0,0)
    ui->tableView->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
    ui->tableView_2->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch);
#else
    ui->tableView->horizontalHeader()->setResizeMode(QHeaderView::Stretch);
    ui->tableView_2->horizontalHeader()->setResizeMode(QHeaderView::Stretch);
#endif
    model.setQuery(QString("Select a.ch_paymodeno , count( a.ch_paymodeno), sum( a.num_realamount), sum( a.num_face),IFNULL(c.vch_paymodename,a.ch_paymodeno) , IFNULL(c.ch_faceflag,'N') from cey_u_checkout_detail a , cey_u_checkout_master b ,cey_bt_paymode c where (c.ch_paymodeno =a.ch_paymodeno)and( a.ch_payno =b.ch_payno)and(b.ch_state ='Y') and(b.vch_operID ='%1')and(b.dt_operdate >= '%2' and b.dt_operdate <= '%3')Group by a.ch_paymodeno ,c.vch_paymodename , c.ch_faceflag  having sum( a.num_realamount)> 0 or sum( a.num_payamount)> 0 Order by a.ch_paymodeno ,c.vch_paymodename , c.ch_faceflag").arg(n_func::gs_operid).arg(date1).arg(date2));
    for(int i = 0; i < model.rowCount(); i++)
    {
        int row = model_top->rowCount();
        model_top->setRowCount(row + 1);
        model_top->setItem(row,0,new QStandardItem(model.record(i).value(4).toString()));
        model_top->setItem(row,1,new QStandardItem(model.record(i).value(1).toString()));
        model_top->setItem(row,2,new QStandardItem(QString().sprintf("%0.2f",model.record(i).value(2).toFloat())));
        model_top->setItem(row,3,new QStandardItem(QString().sprintf("%0.2f",model.record(i).value(3).toFloat())));
    }

    model.setQuery(QString("select sum(num_deposit),count(*) from t_m_deposit where ch_deposit_mode='1' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2));
    model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(kafue=model.record(0).value(0).toString()));
    model.setQuery(QString("select sum(num_realamount),count(*) from t_m_deposit where ch_deposit_mode='1' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2));
    model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值实收")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(kafue_realamount=model.record(0).value(0).toString()));
    model.setQuery(QString("select sum(num_deposit),count(*) from t_m_deposit where ch_deposit_mode='8' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2));
    model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("取款")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(card_fetch=model.record(0).value(0).toString()));
    model.setQuery(QString("select sum(num_deposit),count(*) from t_m_deposit where ch_deposit_mode='5' and dt_operdate >= '%1' and dt_operdate <= '%2' ") .arg(date1).arg(date2));
    model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("退卡")<< new QStandardItem(model.record(0).value(1).toString())<< new QStandardItem(card_back=model.record(0).value(0).toString()));

    if(conf.value("w_sys_manage_cloudsync_basedataset/yun_start",false).toBool()){
        w_sys_manage_cloudsync::member_r_f_b_info mrfb=w_sys_manage_cloudsync::get_yun_member_r_f_b(n_func::gs_operid, date1, date2);
        model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值(云)")<< new QStandardItem("")<< new QStandardItem(card_recharge_yun=mrfb.rechargeAmount));
        model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("充值实收(云)")<< new QStandardItem("")<< new QStandardItem(card_recharge_realamount_yun=mrfb.realRechargeAmount));
        model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("取款(云)")<< new QStandardItem("")<< new QStandardItem(card_fetch_yun=mrfb.withdrawalAmount));
        model_rfb->appendRow(QList<QStandardItem *>()<<new QStandardItem("退卡(云)")<< new QStandardItem("")<< new QStandardItem(card_back_yun=mrfb.backCardAmount));
    }
}
예제 #7
0
bool DataBank::checkExists(unsigned int i)
{
    bool bit = false;
    bool ok = false;

    if(!database.open()){
        qDebug()<<"database database is error";
    }else{
        qDebug()<<"database database is ok";
    }

    /*查询数据库中的所有表名*/
    QSqlQueryModel model;
    model.setQuery("select name from sqlite_master where type='table'",database);

    for(int j = 0; j < model.rowCount(); ++j){
        QString name = model.record(j).value("name").toString();
        if((unsigned int)name.mid(5,2).toInt(&ok ,10) == i){
            bit = true;
        }
    }

    database.close();
    return bit;
}
예제 #8
0
//Eventname, der aktiviert wurde, mit remove-pBtn löschen
//inklusive der an diesem Event beteiligten Teilnehmern.
void MainWindow::on_pBtn_remove_Event_clicked()
{

    QSqlQueryModel *model = (QSqlQueryModel*)ui->listView->model();
    QSqlRecord record = model->record(ui->listView->currentIndex().row());
    QSqlField field_ID = record.field("ID");
    QSqlField field_EventName = record.field("EventName");

    QMessageBox msg;
    msg.setText("Achtung es werden auch alle Teilnehmer, \n die zu diesem Event gehören, gelöscht! \n\n Soll das Event: \n \" " +field_EventName.value().toString()+ "\"\n unwiederruflich gelöscht werden?");
    msg.setWindowTitle("Eintrag entfernen");
    msg.setStandardButtons(QMessageBox::Yes | QMessageBox::No);
    msg.setIcon(QMessageBox::Critical);
    msg.setButtonText(QMessageBox::Yes, "Ja");
    msg.setButtonText(QMessageBox::No, "Nein");
    msg.setDefaultButton(QMessageBox::No);

    if (msg.exec() == QMessageBox::Yes)
    {
        DBank a;
        QString ID = field_ID.value().toString();
        a.removeEvent(ID);
        qDebug()<< field_ID.value().toString();
        updateListView();
    }
    else
    {
        qDebug()<<"EventName-Eintrag wird nicht gelöscht.";
    }
}
예제 #9
0
/*! Reimplemented to export the Qt::DecorationRole. */
QVariant MetaListViewPart::ProxyModel::data(const QModelIndex & index, int role) const
{
    if ( index.isValid() and (role == Qt::DecorationRole or role == Qt::DisplayRole) ) {
        QSqlQueryModel *m = qobject_cast<QSqlQueryModel*>(sourceModel());
        Q_ASSERT(m);
        QModelIndex sourceIndex = mapToSource(index);
        Q_ASSERT(sourceIndex.isValid());
        
        switch(role) {
            case Qt::DecorationRole:
            {
                QString icon = m->record(sourceIndex.row()).value("icon").toString();
                return !icon.isEmpty() ? QIcon(icon) : KIcon("wine");
                break;
            }
            case Qt::DisplayRole:
            {
                return ( sourceIndex.row() == m_metaListViewPart->m_defaultRow )
                            ? sourceIndex.data(role).toString().prepend("* ") : sourceIndex.data(role);
                break;
            }
            default:
                Q_ASSERT(false);
        }
    }

    return QSortFilterProxyModel::data(index, role);
}
예제 #10
0
void FrmTarifas::cargarDatosTarifa(QModelIndex indice)
{
    QSqlQueryModel* modelo = (QSqlQueryModel*)ui->listaTarifa->model();
    QString tarifa = modelo->record(indice.row()).value("descripcion").toString();
    QSqlQuery qTarifa(Configuracion_global->groupDB);
    qTarifa.prepare("select * from codigotarifa where descripcion ='"+tarifa+"'");

    if(qTarifa.exec()){
        qTarifa.next();

        ui->txtCodTarifa->setText(qTarifa.record().field("codigo_tarifa").value().toString());
        ui->txtDescTarifa->setText(qTarifa.record().field("descripcion").value().toString());
        ui->txtPais->setText(Configuracion_global->Devolver_pais(qTarifa.record().field("id_pais").value().toInt()));
        ui->txtMoneda->setText(Configuracion_global->Devolver_moneda(qTarifa.record().field("id_monedas").value().toInt()));
        this->id_tarifa = qTarifa.record().field("id").value().toInt();
        this->id_pais = qTarifa.record().field("id_pais").value().toInt();
        this->id_moneda = qTarifa.record().field("id_monedas").value().toInt();
        this->cod_divisa = Configuracion_global->Devolver_codDivisa(this->id_moneda);
        this->codigoTarifa = qTarifa.record().field("codigo_tarifa").value().toString();
        this->margen = ui->spinMargen->value();
        this->pvpDivisa = qTarifa.record().field("pvp").value().toDouble();
        this->margen_min = ui->spinmargen_minimo->value();
        if (Configuracion_global->divisa_local != ui->txtMoneda->text())
            Configuracion_global->getCambio(Configuracion_global->cod_divisa_local,this->cod_divisa);
        else
            asignarcambiodivisa(1);
    }
    calcular_precio(ui->spinMargen->value());

}
예제 #11
0
void pandasoft::Principal()
{
    ui->error->hide();
    ui->error0->hide();
    ui->usuario->setStyleSheet("background-color: none;");
    ui->clave->setStyleSheet("background-color: none;");

    if(ui->usuario->text().isEmpty()||ui->clave->text().isEmpty()){
        if(ui->usuario->text().isEmpty()){
            ui->error->show();
            ui->usuario->setStyleSheet("background-color: red;");
        }
        if(ui->clave->text().isEmpty()){
            ui->error->show();
            ui->clave->setStyleSheet("background-color: red;");
        }
    }
    else {
    QSqlQueryModel model;
    QString consulta="select Nombre, Ap, Am, Rol from Usuario where (Nombre='"+ui->usuario->text()+"' and Contrasena='"+ui->clave->text()+"' )";
    model.setQuery(consulta);

    if(model.record(0).value("Rol").toString()==""){
    ui->error0->show();
    }else{
    QString rol = model.record(0).value("Rol").toString();
    rolusu=rol;
    QString usuario = model.record(0).value("Nombre").toString()+" "+model.record(0).value("Ap").toString()+" "+model.record(0).value("Am").toString();
    this->setWindowTitle("Principal");
    ui->pandasoftstackedWidget->setCurrentIndex(1);
    ui->menubar->show();
    if(rolusu=="1"){
    ui->menuMenu_Gerente->setEnabled(false);
    ui->cabecera->setText("Bienvenido Usuario: "+usuario+"           Rol : Jefe de Almacen");

    }else{
        ui->cabecera->setText("Bienvenido Usuario: "+usuario+"            Rol : Gerente");
    }
    }
    ui->alertalista->setEnabled(false);
    QString alerta="select Nombre from Producto where Cantidad<Lim_stock";
    model.setQuery(alerta);
    ui->alertalista->setText(model.record(0).value("Nombre").toString());

}
}
예제 #12
0
void LazyWord::RestoreConfig_color()			//Get the configuration of color from the database
{
	QSqlQueryModel GetTheLastconfig;
	GetTheLastconfig.setQuery("select * from LastConfig;");
	
    QSqlRecord Lastconfig_Record = GetTheLastconfig.record(0);
    colorselect = Lastconfig_Record.value("Color").toString();
}
void MultiWeatherParamWidget::initData(){
    //初始化DB
    pgDb = new PgDataBase;
    //多要素
    QString queryStr = QString("select * from weatherparam where choose_type = 1 and limit_type <> 0 order by id");
    QSqlQueryModel *plainModel = pgDb->queryModel(queryStr);
    int rowCount = plainModel->rowCount();
    for(int i = 0;i < rowCount;i++){
        WeatherParam weatherParam;
        weatherParam.setId(plainModel->record(i).value(0).toInt());
        weatherParam.setName(plainModel->record(i).value(1).toString());
        weatherParam.setChoose_type(plainModel->record(i).value(2).toInt());
        weatherParam.setLimit_type(plainModel->record(i).value(3).toInt());
        weatherParamList.append(weatherParam);
    }
    delete plainModel;
}
예제 #14
0
void DataBank::tableMake(LONG64 ideep,UNINT32 imaterial,UNINT32 iacreage,UNINT32 ieffect,UNINT32 iry ,UNINT32 iovc,UNINT32 ishape)
{
    bool ok = false;
    QString sql = QString("select * from '%1'");
    QString name = "";
    if(imaterial == 0){
        name = "cust";
    }else{
        name = "crst";
    }
    name.append(QString::number(ishape,10));
    sql.arg(name);

    if(!database.open()){
        qDebug()<<"spark database is error";
    }else{
        qDebug()<<"spark database is ok";
    }

    QSqlQueryModel model;
    model.setQuery(sql,database);

    for(int i = 0; i < model.rowCount(); ++i){
        int id = model.record(i).value("h_area").toInt();
        QString name = model.record(i).value("no").toString();
        qDebug() << id << name;
    }

/*
    QSqlQuery query(database);
    query.prepare("select * from cust0 where h_area > :value1 and l_area < :value2 and cnf = 0");
    query.bindValue(":value1" ,2);
    query.bindValue(":value2" ,2);
    b = query.exec();
    if(!b){
        qDebug()<<"table is error";
    }else{
        qDebug()<<"table is ok";
        while(query.next()){
            qDebug()<<query.value(S_OFS).toString()<<query.value(PP).toString();
        }
    }
*/

    database.close();
}
예제 #15
0
파일: pringkvitok.cpp 프로젝트: haltxz/ds
void PringKvitok::SetDb(db *mdb)
{
    myDB = mdb;
     ui->comboBox_groups->addItem("Выбрать все", "s_all");
    ui->comboBox_groups->addItem("Снять все", "d_all");
    QSqlQueryModel *groups = myDB->Query("SELECT * FROM groups WHERE id > 2");
    for(int i = 0; i < groups->rowCount(); i++){
         ui->comboBox_groups->addItem(groups->record(i).value("name").toString(), groups->record(i).value("id").toString());
    }

    childsCheckBox_map.clear();
   QString sql = "SELECT t0.id, t0.group_id, t0.fio,  t1.name AS group_name, t0.ls FROM childs t0";
    sql += " LEFT OUTER  JOIN groups  t1 ON t0.group_id = t1.id";
    QSqlQueryModel *childs = myDB->Query(sql);
    for(int i = 0; i < childs->rowCount(); i++){
          QString childs_id = childs->record(i).value("id").toString();
          ui->tW->insertRow(ui->tW->rowCount());
          ui->tW->setItem(ui->tW->rowCount() - 1, 1,new QTableWidgetItem(childs->record(i).value("fio").toString()));
          ui->tW->setItem(ui->tW->rowCount() - 1, 2,new QTableWidgetItem(childs->record(i).value("group_name").toString()));
          ui->tW->setItem(ui->tW->rowCount() - 1, 3,new QTableWidgetItem(childs_id));
          ui->tW->setItem(ui->tW->rowCount() - 1, 4,new QTableWidgetItem(childs->record(i).value("group_id").toString()));
          ui->tW->setItem(ui->tW->rowCount() - 1, 5,new QTableWidgetItem(childs->record(i).value("ls").toString()));
          QCheckBox *cb = new QCheckBox();
          cb->setText(childs_id);
          connect(cb , SIGNAL( toggled(bool) ), this, SLOT( on_childs_toggled(bool)) );
          childsCheckBox_map[childs_id] = cb;
          ui->tW->setCellWidget(ui->tW->rowCount() - 1, 0, cb);

     }
    delete groups;
    delete childs;

}
예제 #16
0
WineConfiguration WineConfigurationsModel::configurationByModelRow(int row) const
{
    // we use another model here because the QSqlRelation hides the
    // field "wineinstallation" from the original model
    QSqlQueryModel qmodel;
    qmodel.setQuery("SELECT wineprefix, wineinstallation FROM wine_configurations");
    QSqlRecord record = qmodel.record(row);
    return configurationFromRecord(record);
}
예제 #17
0
void discount_dispose::on_pushButton_13_clicked()//确定
{
    this->close();
    if(n_func::gs_operid != "0000")
    {
        QSqlQueryModel model;
        model.setQuery(QString("Select int_discount from cey_sys_operator where vch_operID ='%1' and ch_flag = 'Y' ").arg(n_func::gs_operid));
        int operdis = model.record(0).value(0).toInt();
        if(operdis > ui->lineEdit->text().toInt())
        {
            if(0==lds_messagebox::warning(this, tr("消息提示"),tr("指定操作员没有该折扣权限!"),tr("确认"),tr("取消")))
            {
                power_oper oper;
                /*oper.exec();*/backheader::static_dialogexec(oper, tr("权限核实"));
                if(oper.btn_t_f == true)
                {
                    if(oper.operid != "0000")
                    {
                        model.clear();
                        model.setQuery(QString("Select int_discount from cey_sys_operator where vch_operID ='%1' and ch_flag = 'Y' ").arg(oper.operid));
                        int zhe = model.record(0).value(0).toInt();
                        if(zhe > ui->lineEdit->text().toInt())
                        {
                            ;
                            lds_messagebox::warning(this, tr("消息提示"),tr("指定操作员没有该折扣权限!"));
                            
                            return;
                        }
                    }
                }
                else
                {
                    return;
                }
            }
            else
            {
                return;
            }
        }
    }
    zhekouzhi = ui->lineEdit->text().toFloat();
    btn_t_f = true;
}
Activity::Activity(QString courseID, QString activityName)
{
  dbManager db;
  QSqlQueryModel* model = db.getActivityInfo(courseID, activityName);
  if (model != NULL)
  {
    activityID = model->record(0).value("activityID").toInt();
  //actName = activityName;
  //actType = model->record(0).value("activityType").toString();
  //dueDate = model->record(0).value("dueDateTime").toString();
  //dueTime = model->record(0).value("dueDateTime").toString();
  //pathToStdSubm = model->record(0).value("dueDateTime").toString();
  //pathToSolnFile = model->record(0).value("dueDateTime").toString();
  //actLanguage = model->record(0).value("dueDateTime").toString();
  //bonusDays = model->record(0).value("dueDateTime").toString();
  //penaltyDays = model->record(0).value("dueDateTime").toString();
  //bonusPercentPerDay = model->record(0).value("dueDateTime").toString();
  //penaltyPercentPerDay = model->record(0).value("dueDateTime").toString();
  //rubric = model->record(0).value("dueDateTime").toString();
    rubricChanged = false;
    delete model;
  }
  model = db.getRubric(QString::number(activityID));
  if (model != NULL)
  {
    //int itemNum;
    //QString itemDescription;
    //int itemGrade;
    rubricItem_t rubricItem;
    rubric.clearRubric();
    int rowcount = model->rowCount();
    for (int i=0; i<rowcount; i++)
    {
      rubricItem.itemDescription = model->record(i).value("rubricItemText").toString();
      rubricItem.itemNum = model->record(i).value("rubricItemNumber").toInt();
      rubricItem.itemGrade = model->record(i).value("rubricItemValue").toInt();
      rubricItem.itemID = model->record(i).value("rubricItemID").toInt();
      rubric.addRubricItem_withID(rubricItem.itemNum,rubricItem.itemDescription, rubricItem.itemGrade, rubricItem.itemID);
    }

  }


}
예제 #19
0
void LazyWord::RestoreConfigall()				//Get the configuration from the database
{
	QSqlQueryModel GetTheLastconfig;
	GetTheLastconfig.setQuery("select * from LastConfig;");
	
    QSqlRecord Lastconfig_Record = GetTheLastconfig.record(0);
    lastlib = Lastconfig_Record.value("LibSelect").toString();
    Shtime = Lastconfig_Record.value("ShowTime").toInt();
    Invertime = Lastconfig_Record.value("IntervalTime").toInt();
}
예제 #20
0
void PrepodMain::on_comboBox_2_currentIndexChanged(int index){
    ui->comboBox->clear();
    QSqlQueryModel model;
    QString s = QString("SELECT * FROM \"forkurator\" WHERE \"studGroupId\" = '%1' AND \"Kurator\"='%2' ").arg(groupIds.at(ui->comboBox_2->currentIndex())).arg(IDD);

    model.setQuery(s);
    studentsFio.clear();
    studentsId.clear();
    for (int i=0;i<model.rowCount();i++){
        studentsFio<<model.record(i).value("FIO").toString();
        studentsId<<model.record(i).value("id").toString();
    }
    if (ui->comboBox->count()!=0)
    {
        ui->comboBox->clear();
    }
    ui->comboBox->addItems(studentsFio);
    qDebug()<<studentsFio;
}
예제 #21
0
void importDialog::selectionChanged(QItemSelection, QItemSelection)
{
    ui->btnImportar->setEnabled(true);
    if(sender()==ui->listViewFP->selectionModel())
    {
        QSqlQueryModel * model = qobject_cast<QSqlQueryModel*>(ui->listViewFP->model());
        _empresaFp = model->record(ui->listViewFP->currentIndex().row());
        _empDir = ui->txtRutaBD->text();
        _empDir.append("/DBF");
        _empDir.append(_empresaFp.value("CODEMP").toString().trimmed());

        _contaDir = ui->txtRutaConta->text();
        //_contaDir.append("/EMP");
        //_contaDir.append(_empresaFp.value("CODEMP").toString().trimmed());
    }
    else
    {

        QSqlQueryModel * model = qobject_cast<QSqlQueryModel*>(ui->listView->model());
        int index = ui->listView->currentIndex().row();
        _grupoMaya = model->record(index);

        QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL","grupo");

        QString bd_name = model->data(model->index(index,2)).toString();
        QString bd_host = model->data(model->index(index,5)).toString();
        QString bd_user = model->data(model->index(index,6)).toString();
        QString bd_pass = model->data(model->index(index,7)).toString();
        int bd_port = model->data(model->index(index,8)).toInt();

        db.setHostName(bd_host);
        db.setUserName(bd_user);
        db.setPassword(bd_pass);
        db.setPort(bd_port);
        db.setDatabaseName(bd_name);
        if(!db.open())
        {
            QMessageBox::critical(this,tr("Error"),tr("No se puede conectar con la base de datos"));
        }
    }
}
예제 #22
0
void So2sdr::populateDupesheet()

// populates dupe sheet. Needs to be called when switching bands
// or first turning on the dupesheet
{
    // if only one dupesheet is active, figure out which one it is
    bool oneactive=false;
    int nr=0;
    if (nDupesheet==1) {
        oneactive=true;
        for (int i=0;i<2;i++) {
            if (!dupesheet[i]) continue;
            if (dupesheet[i]->isVisible()) {
                nr=i;
                break;
            }
        }
    }
    for (int id=0;id<2;id++) {
        if (!dupesheet[id]) continue;
        int ib=id;
        if (oneactive) {
            if (nr!=id) continue;
            ib=activeRadio;
        }

        dupesheet[id]->Dupes0->clear();
        dupesheet[id]->Dupes1->clear();
        dupesheet[id]->Dupes2->clear();
        dupesheet[id]->Dupes3->clear();
        dupesheet[id]->Dupes4->clear();
        dupesheet[id]->Dupes5->clear();
        dupesheet[id]->Dupes6->clear();
        dupesheet[id]->Dupes7->clear();
        dupesheet[id]->Dupes8->clear();
        dupesheet[id]->Dupes9->clear();
        for (int i = 0; i < dsColumns; i++) {
            dupeCalls[id][i].clear();
            dupeCallsKey[id][i].clear();
        }
        QSqlQueryModel m;
        m.setQuery("SELECT * FROM log WHERE valid='true' and BAND=" + QString::number(band[ib]), mylog->db);
        while (m.canFetchMore()) {
            m.fetchMore();
        }
        for (int i = 0; i < m.rowCount(); i++) {
            QByteArray tmp = m.record(i).value("call").toString().toAscii();
            updateDupesheet(tmp,id);
        }
        dupesheet[id]->setWindowTitle("Dupesheet " + bandName[band[ib]]);
    }
}
예제 #23
0
PrepodMain::PrepodMain(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::PrepodMain)
{
    ui->setupUi(this);
    ui->label_2->setText(FIO);

//    QUuid uuid;
//    uuid.createUuid().toString();

//    QSqlQuery query1111;
//    QString e1111 = "SELECT * FROM \"StudGroup\"";

    QSqlQueryModel model;
    model.setQuery(QString("SELECT * FROM \"forkurator\" WHERE \"Kurator\"='%1'").arg(IDD));
    groupNames.clear();
    groupIds.clear();
     for (int i=0;i<model.rowCount();i++){
         groupNames<<model.record(i).value("studGroupName").toString();
         groupIds<<model.record(i).value("studGroupId").toString();
     }
     QSet<QString> stringSet = QSet<QString>::fromList(groupNames);
     groupNames = stringSet.toList();
     stringSet = QSet<QString>::fromList(groupIds);
     groupIds = stringSet.toList();
     for (int i=0;i<groupNames.count();i++){
         if (groupNames.at(i)=="none"){
             groupNames.removeAt(i);
             groupIds.removeAt(i);
             break;
         }
     }
if (ui->comboBox_2->count()!=0)
{
    ui->comboBox_2->clear();
}
     ui->comboBox_2->addItems(groupNames);

}
예제 #24
0
QVector<QString> ClinicInternalPayment::getDistinctFromDB(QString strColumn, QString strTable)
{
    QVector<QString> vec;
    QSqlQueryModel *sqlModel = new QSqlTableModel;
    sqlModel->setQuery("SELECT distinct " + strColumn + " FROM " + strTable);

    for(int i = 0; i<sqlModel->rowCount();i++)
    {
        QSqlRecord record = sqlModel->record(i);
        QString strReceipt = record.value(strColumn).toString();
        vec.append(strReceipt);
    }
    return vec;
}
예제 #25
0
void EmployeeDataModel::readAllRecords()
{

    QSqlQueryModel model;
    model.setQuery(QLatin1String("SELECT * FROM employee"));

    int colunmCount = model.columnCount();
    int rowCount = model.rowCount();


    QSqlRecord rec = model.record();
    // int recCount = rec.count();


    for (int i=0; i<rowCount; i++) {
        qDebug() << "Record : " << i;
        rec = model.record(i);
        for (int j=0; j<colunmCount; j++) {
            QString value = rec.value(j).toString();
            qDebug() << "ColumnCount : " << j << " - Value  = " << value;
        }
    }
}
예제 #26
0
void AddPlan::on_pushButton_clicked()
{
    QSqlQueryModel *potModel = new QSqlQueryModel();
    potModel->setQuery("select id_dis from disciplina where n_dis = '" + ui->comboBox->currentText() + "';");
    QString pot = potModel->record(0).field(0).value().toString();


    QString query = "insert into plan (id_spec, id_dis, semes) values ('"
                    + idSpec + "', '"
                    + pot + "', '"
                    + semes
                    + "');";

    emit InsertQuery(query);
    emit closeThisWidget();
}
Activity::Activity(int _activityID)
{
  dbManager db;
  QSqlQueryModel* model = db.getActivityInfo_AID(_activityID);
  if (NULL != model)
  {
    activityID = _activityID;
    actName = model->record(0).value("activityName").toString();
    actType = model->record(0).value("activityType").toString();
    dueDate = model->record(0).value("dueDateTime").toDate();
    dueTime = model->record(0).value("dueDateTime").toTime();
    pathToStdSubm = model->record(0).value("pathToSubmissions").toString();
    pathToSolnFile = model->record(0).value("pathToSolution").toString();
    actLanguage = model->record(0).value("language").toString();
//    bonusDays = model->record(0).value("dueDateTime").toString();
//    penaltyDays = model->record(0).value("dueDateTime").toString();
//    bonusPercentPerDay = model->record(0).value("dueDateTime").toString();
//    penaltyPercentPerDay = model->record(0).value("dueDateTime").toString();
    rubricChanged = false;

    delete model;
    model = db.getRubric(QString::number(activityID));
    if (model != NULL)
    {
      rubricItem_t rubricItem;
      rubric.clearRubric();
      int rowcount = model->rowCount();
      for (int i=0; i<rowcount; i++)
      {
        rubricItem.itemDescription = model->record(i).value("rubricItemText").toString();
        rubricItem.itemNum = model->record(i).value("rubricItemNumber").toInt();
        rubricItem.itemGrade = model->record(i).value("rubricItemValue").toInt();
        rubricItem.itemID = model->record(i).value("rubricItemID").toInt();
        rubric.addRubricItem_withID(rubricItem.itemNum,rubricItem.itemDescription, rubricItem.itemGrade, rubricItem.itemID);
      }
      delete model;
    }
  }
}
예제 #28
0
파일: tab.cpp 프로젝트: DmitriyG/Diplom
void L_TAB::on_pushButton_clicked()
{
    QSqlQueryModel *model = new QSqlQueryModel();
    model->setQuery("SELECT * FROM settings");
    tableView->setFocus();
    QModelIndex index = tableView->currentIndex();
    QSqlRecord record;
    record = model->record(index.row());
    model->setQuery("DELETE FROM settings WHERE table_name = '"
                    +record.value("table_name").toString()
                    +"'");
    model->setQuery("DROP FUNCTION add_to_log_"
                    +record.value("table_name").toString()
                    +"() CASCADE");
    model->setQuery("SELECT * FROM settings");
    tableView->setModel(model);
}
예제 #29
0
//Nach Doppelklick auf einen Event-Eintrag öffnet
//sich ein neues Fenster
//  -a) entweder ohne Teilnehmer-Einträgen oder
//  -b) schon mit bereits eingetragenen Teilnehmern
void MainWindow::on_listView_doubleClicked(const QModelIndex &index)
{
	Q_UNUSED(index);
    //Teilnehmer *Fenster = new Teilnehmer(0, meineId);
    QVariant row = ui->listView->currentIndex().data();
    QSqlQueryModel *model = (QSqlQueryModel*)ui->listView->model();
    QSqlRecord record = model->record(ui->listView->currentIndex().row());
    QSqlField field_ID = record.field("ID");

    QString ID = field_ID.value().toString();

    Teilnehmer teilnehmer(this, ID);
    teilnehmer.setModal(true);
    teilnehmer.setWindowTitle("Event "+row.toString());

    teilnehmer.exec();
}
예제 #30
0
  //Ausleitung als csv-Datei
void MainWindow::on_pushButton_clicked()
{
    QSqlQueryModel *model = (QSqlQueryModel*)ui->listView->model();
    QSqlRecord record = model->record(ui->listView->currentIndex().row());
    QSqlField field_ID = record.field("ID");

    DBank con;
    con.con_open();

    QSqlQuery query(con.myDB);
    query.prepare("SELECT t.Vorname as Vorname, t.Nachname as Nachname, time(t.Endzeit-e.Startzeit, \"unixepoch\") from TEILNEHMER as t JOIN EVENT as e ON e.ID == t.EVENT_ID where e.ID = '"+field_ID.value().toString()+"' ORDER BY t.Endzeit ASC");

    if(query.exec())
    {
       QSqlQueryModel *model=new QSqlQueryModel();
        model->setQuery(query);

        QString DB_Inhalt;
        int rows=model->rowCount();
        int columns=model->columnCount();

        for (int i = 0; i < rows; i++)
        {
            for (int j = 0; j < columns; j++)
            {
                DB_Inhalt += model->data(model->index(i,j)).toString();
                DB_Inhalt += "; ";
            }
            DB_Inhalt += "\n";
        }

        QString filename = QFileDialog::getSaveFileName(this,"Speichern unter","C://","All files (*.*);;ExcelFile(*.csv)");

        QFile csvfile(filename);
        if(csvfile.open(QIODevice::WriteOnly|QIODevice::Truncate))
        {
            QTextStream out(&csvfile);
            out<<DB_Inhalt;
        }
        csvfile.close();
    }
}