示例#1
0
void GRUP_KERNEL::ADD_PARENT_ITEMS()
{
    SQL_QUERY sql_query ( m_db );

    QString table_name  = "";
    QString column_name = "";
    QString where_name  = "";
    QString order_by    = "";

    CREATE_SELECT_QUERY(&table_name,&column_name,&where_name,&order_by);

    sql_query.PREPARE_SELECT ( table_name,column_name,where_name,"" );

    if ( sql_query.SELECT(order_by) NE 0 ) {
        while ( sql_query.NEXT() EQ true ) {
            //QString id = sql_query.VALUE(0).toString();
            QStringList tree_row_str;
            tree_row_str << sql_query.VALUE(3).toString() << sql_query.VALUE(4).toString() <<
                         sql_query.VALUE(8).toString() << sql_query.VALUE(7).toString() <<
                         sql_query.VALUE(0).toString() << sql_query.VALUE(1).toString() <<
                         sql_query.VALUE(6).toString() << sql_query.VALUE(5).toString();

            ADD_PARENT_ITEM ( tree_row_str , sql_query.VALUE(8).toInt() );
        }
    }
}
示例#2
0
void DMR_GRUP_TREE_SECIMI::FILL_TREE_TABLE()
{
    SQL_QUERY     sql_query          ( DB );

    //parent itemlarimizi query ile buluyoruz.
    sql_query.PREPARE_SELECT ("adak_gruplar" ,"grup_id,grup_parent_id,grup_seviyesi,grup_kodu, "
                              "grup_adi,tam_grup_kodu,grup_son_seviye_mi,gruptaki_kayit_sayisi, "
                              "alt_grup_sayisi","modul_id=:modul_id AND program_id=:program_id" );

    sql_query.SET_VALUE      (":program_id",K9_PROGRAMI);
    sql_query.SET_VALUE      (":modul_id"  ,DEMIRBAS_MODULU);

    if ( sql_query.SELECT() NE 0 ) {

        while ( sql_query.NEXT() EQ true ) {

            int grup_id = sql_query.VALUE(0).toInt();

            QStringList tree_row;
            tree_row << QVariant( grup_id ).toString() << sql_query.VALUE("grup_kodu").toString()
                     << sql_query.VALUE("grup_adi" ).toString() << sql_query.VALUE("alt_grup_sayisi").toString()
                     << sql_query.VALUE("gruptaki_kayit_sayisi").toString();

            //ve bu row u tree ye ekleriz.
            ADD_PARENT_ITEM ( tree_row , sql_query.VALUE("alt_grup_sayisi").toInt());
        }
    }
}
示例#3
0
void XYZ_TREE_ARAMA::SEARCH ()
{
    // Asagidaki sekilde verilerimizi ekleriz her \t de diger column a yazar.
    int num_of_child = 99;

    QString tree_row = "000\t000 Grubu";
    ADD_PARENT_ITEM ( tree_row , num_of_child );
}
示例#4
0
void GRUP_KERNEL::ADD_ITEM (QObject *button, QStringList column_datas )
{
    int item_id = -1;

    if ( button EQ m_ui->push_button_add_alt_grup OR button->metaObject()->className() EQ QAction::staticMetaObject.className()) {
        if (m_ui->tree_widget->topLevelItemCount() EQ 0) {
            MSG_INFO(tr("There are not opened main group. Firstly, you must open a group.") , NULL);//Açılmış olan ana grup bulunmamaktadır.Önce ana grup açmalısınız.
            return;
        }

        if (m_ui->tree_widget->currentItem() EQ NULL) {
            MSG_INFO(tr("You must select a main group for adding sub-group.") , NULL);//Alt grup ekleyebilmek için önce ana grup seçmelisiniz.
            return;
        }

        if ( column_datas.size() EQ 0 ) {
            return;
        }

        item_id = column_datas.at( m_grp_id_column ).toInt();

        F_GRUP_KERNEL_GRUP_FISI ( item_id, ENUM_ALT_GRUP, static_cast< BASE_GRUP_KERNEL *>(this) ,this , m_db );

        if ( m_grup_satir_guncellendi_mi EQ true ) {
            RESET_GUI_UPDATE_VALUES();
        }
        REFRESH_TREE_WIDGET();
    }
    else {
        F_GRUP_KERNEL_GRUP_FISI ( item_id, ENUM_ANA_GRUP, static_cast< BASE_GRUP_KERNEL *>(this) ,this , m_db );

        if ( m_grup_satir_eklendi_mi EQ true ) {
            ADD_PARENT_ITEM ( m_grup_eklenen_kayit, 0 );
            RESET_GUI_UPDATE_VALUES();
        }
        REFRESH_TREE_WIDGET();
    }
}