C++ (Cpp) VERITABANI_ID示例

示例#1

bool HEADER_DOSYASI_YARAT( QWidget * parent )
{
    SQL_QUERY yonetim_query ( G_YONETIM_DB);
    SQL_QUERY db_query      ( DB          );

    db_query.PREPARE_SELECT     ("sql_db_info","program_id");

    if ( db_query.SELECT () EQ 0 ) {
        exit(88);
    }

    db_query.NEXT();

    int program_id = db_query.VALUE(0).toInt();

    yonetim_query.PREPARE_SELECT("ynt_veritabanlari", "veritabani_ismi","veritabani_id = :veritabani_id");
    yonetim_query.SET_VALUE(":veritabani_id", VERITABANI_ID());
    if ( yonetim_query.SELECT("veritabani_ismi") EQ 0 ) {
        return false;
    }
    yonetim_query.NEXT();
    QString db_name   = yonetim_query.VALUE(0).toString();
    QString file_path = db_name.toLower() + "_db.h";


    QFile header_file ( file_path );
    header_file.open(QIODevice::WriteOnly | QIODevice::Text);

    file_content = "#ifndef " + db_name.toUpper() + "_DB_H\n"
                   "#define " + db_name.toUpper() + "_DB_H\n\n";

    file_content += nl( "ADAK_SQL_STRUCT " + db_name + "_db" +  " = {" );
    file_content += tab (1, nl(QVariant(program_id).toString() + ","));

    TABLOLARI_YAZ ( parent );

    file_content += nl("};");


    file_content +=  "#endif // " + db_name.toUpper() + "_DB_H \n";

    header_file.write ( file_content.toLatin1() );
    header_file.close();

    return true;
}

示例#2

文件： login_utils.cpp 项目： coolixwebgraphics/FRAMEWORK

void YONETIM_007_GIRIS_KAYDI ()
{
    SQL_QUERY sql_query ( G_YONETIM_DB );

    sql_query.PREPARE_SELECT ( "ynt_veritabanlari","veritabani_ismi, veritabani_tanimi","veritabani_id = :veritabani_id");

    sql_query.SET_VALUE      (":veritabani_id",VERITABANI_ID() );

    if ( sql_query.SELECT() EQ 0 ) {
        return;
    }
    sql_query.NEXT();

    QString aciklama = "Giriş yapılan veritabanı: " + sql_query.VALUE(0).toString() + " # Giriş yapılan veritabanı tanımı: "+ sql_query.VALUE(1).toString();

    YONETIM_007_KAYIT ( LOG_PROGRAM, LOG_PROGRAMA_GIRIS, aciklama );
}

示例#3

文件： yonetim_utils.cpp 项目： adakteknoloji/FRAMEWORK

void YONETIM_007_CIKIS_KAYDI ()
{
    G_YONETIM_DB->START_TRANSACTION();

    SQL_QUERY sql_query ( G_YONETIM_DB );

    sql_query.PREPARE_SELECT ( "ynt_veritabanlari","veritabani_ismi, veritabani_tanimi","veritabani_id = :veritabani_id");

    sql_query.SET_VALUE      ( ":veritabani_id",VERITABANI_ID());
    if ( sql_query.SELECT() EQ 0 ) {
        G_YONETIM_DB->CANCEL_TRANSACTION();
        return;
    }
    sql_query.NEXT();
    QString aciklama = QObject::tr("Database Name: ") + sql_query.VALUE(0).toString() + QObject::tr(" # Database Definition: ")+ sql_query.VALUE(1).toString();

    YONETIM_007_KAYIT ( LOG_PROGRAM, LOG_PROGRAMDAN_CIKIS, aciklama );
    G_YONETIM_DB->COMMIT_TRANSACTION ();
}

示例#4

文件： kullanicilar_formu.cpp 项目： adakteknoloji/FRAMEWORK

void    KULLANICILAR_FORMU::SAVER_BUTTON_CLICKED( QAbstractButton * p_button, int p_record_id )
{
    if ( p_button EQ m_ui->pushButton_yetki_ata ) {

        SQL_QUERY query( G_YONETIM_DB );

        QList < int > yetkisi_bulunan_db_ler;

        query.PREPARE_SELECT( "ynt_veritabani_kullanicilari", "veritabani_id", "kullanici_id = :kullanici_id");
        query.SET_VALUE     ( ":kullanici_id", GET_RECORD_ID() );

        if ( query.SELECT() NE 0 ) {
            while ( query.NEXT() EQ true ) {
                yetkisi_bulunan_db_ler << query.VALUE( 0 ).toInt();
            }
        }
        if ( yetkisi_bulunan_db_ler.contains( VERITABANI_ID() ) EQ false ) {
            MSG_WARNING( tr("No work on the user's database <b>%1</b> authority.").arg( VERITABANI_ISMI() ), NULL );//Kullanıcının  <b> %1 </b>  veritabanında çalışma yetkisi yok.
        }
        else {
            M_KULLANICI_YETKILERI_FONK ( p_record_id  ,m_yetkileri_tazele, nativeParentWidget() );
        }
    }
}