WebSVN - OpenInventory - Различия - Редакция 86 и 134


#include "modelforpointers.h"

ModelForPointers::ModelForPointers(QObject *parent) :
    QSqlTableModel(parent)
{
     setEditStrategy(QSqlTableModel::OnManualSubmit);
}

Qt::ItemFlags ModelForPointers::flags(
         const QModelIndex &index) const {
Qt::ItemFlags flags = QSqlTableModel::flags(index);
if ((index.column() != 3) && (index.column() != 0))
     flags |= Qt::ItemIsEditable;
//if (index.column() == 4)
//     flags |= Qt::ItemIsUserCheckable;
else
{
    if ((index.column() == 3) || (index.column() == 0)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà
}
    return flags;
}


bool ModelForPointers::setData(const QModelIndex &index, const QVariant &value, int role) {
  ////  if (index.column()==3) return false; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå
    bool lResult = false;
    QVariant old_value; // ñîõðàíèì ñòàðîå çíà÷åíèå
    old_value = data(index);

    if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ
        QSqlQuery qu;
        QString old_field_name; // ñòàðîå èìÿ ïîëÿ
        QString new_field_name; // íîâîå èìÿ ïîëÿ
        QString query_str;
        QString type_str; // òèï äàííûõ ïîëÿ
        old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ
        new_field_name = value.toString();
        // type_str = data(ModelForPointers::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå
        type_str = tr("CHAR(10)");

        query_str = tr("ALTER TABLE ");
        query_str.append(ModelForPointers::Inctance);
        query_str.append(tr(" CHANGE COLUMN `"));
        query_str.append(old_field_name);
        query_str.append(tr("` `"));
        query_str.append(new_field_name);
        query_str.append(tr("` "));
        query_str.append(type_str);
        query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL"));
        qu.prepare(query_str);
        bool ok;
        ok = qu.exec();
        if (!ok) return false;
    }



    lResult = QSqlTableModel::setData(index, value, role);
    if (lResult) {
        QModelIndex newindex;
        QSqlRecord rec = record(index.row());

        rec.setValue(index.column(), value);
        rec.setGenerated(index.column(), true);


        lResult = updateRowInTable(index.row(), rec);
        emit field_changed();
  ///      QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);


    }
    return lResult;
}



QVariant ModelForPointers::data(const QModelIndex &index, int role) const {

     QVariant value = QSqlTableModel::data(index, role);
  switch (role) {
        case Qt::DisplayRole: {
                if(index.column() == 4){
                QSqlQuery q;
                QString sql_str;
                bool ok;
                sql_str = tr("select * from `ListOfClasses` where `ID` = ");
                sql_str.append(value.toString());

                q.prepare(sql_str);

                ok = q.exec();

                if (ok)  {
                             while(q.next()){
                               QString class_name = q.value(1).toString();
                               if (!class_name.isEmpty()) return class_name;

                                               }


                          }

            }


                return value;
            }



        case Qt::EditRole: return value;
        case Qt::TextColorRole:
            if(index.column() == 1)
                return qVariantFromValue(QColor(Qt::blue));
            else
              return value;
        case Qt::TextAlignmentRole: return value;
        case Qt::FontRole:
           if(index.column() == 1) {
               QFont font = QFont("Helvetica", 16, QFont::Bold);
              return qVariantFromValue(font);
           }else
               return value;

       case Qt::BackgroundColorRole: {
                int a = (index.row() % 2) ? 14 : 0;
                if(index.column() == 2)
                           return qVariantFromValue(QColor(220,240-a,230-a));
                        else if(index.column() == 4)
                            return qVariantFromValue(QColor(200,220-a,255-a));
                        else
                           return value;
                                    }



     case Qt::CheckStateRole: return value;

     case Qt::SizeHintRole:return value;

       }
  return value;
}

void ModelForPointers::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà
    ModelForPointers::Inctance = currInctatce;
}


bool ModelForPointers::onlySetData(const QModelIndex &index, const QVariant &value, int role){
     bool lResult = false;

     QSqlRecord rec = record(index.row());
     rec.setValue(index.column(), value);
     rec.setGenerated(index.column(), true);


     lResult = QSqlTableModel::setData(index, value, role);
     if (lResult) {
     lResult = updateRowInTable(index.row(), rec);
 //    emit field_changed();
///      QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
                 }




 return lResult;

}


 

Редакция 86	Редакция 134
1	#include "modelforpointers.h"	1	#include "modelforpointers.h"
2		2
3	ModelForPointers::ModelForPointers(QObject *parent) :	3	ModelForPointers::ModelForPointers(QObject *parent) :
4	QSqlTableModel(parent)	4	QSqlTableModel(parent)
5	{	5	{
6	setEditStrategy(QSqlTableModel::OnManualSubmit);	6	setEditStrategy(QSqlTableModel::OnManualSubmit);
7	}	7	}
8		8
9	Qt::ItemFlags ModelForPointers::flags(	9	Qt::ItemFlags ModelForPointers::flags(
10	const QModelIndex &index) const {	10	const QModelIndex &index) const {
11	Qt::ItemFlags flags = QSqlTableModel::flags(index);	11	Qt::ItemFlags flags = QSqlTableModel::flags(index);
12	if ((index.column() != 3) && (index.column() != 0))	12	if ((index.column() != 3) && (index.column() != 0))
13	flags \|= Qt::ItemIsEditable;	13	flags \|= Qt::ItemIsEditable;
14	//if (index.column() == 4)	14	//if (index.column() == 4)
15	// flags \|= Qt::ItemIsUserCheckable;	15	// flags \|= Qt::ItemIsUserCheckable;
16	else	16	else
17	{	17	{
18	if ((index.column() == 3) \|\| (index.column() == 0)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà	18	if ((index.column() == 3) \|\| (index.column() == 0)) flags &= ~Qt::ItemIsEditable; // çàïðåùàåì ðåäàêòèðîâàíèå òðåòüåãî ñòîëáöà
19	}	19	}
20	return flags;	20	return flags;
21	}	21	}
22		22
23		23
24	bool ModelForPointers::setData(const QModelIndex &index, const QVariant &value, int role) {	24	bool ModelForPointers::setData(const QModelIndex &index, const QVariant &value, int role) {
25	//// if (index.column()==3) return false; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå	25	//// if (index.column()==3) return false; // â òðåòüåé êîëîíêå íå äàåì ïîìåíÿòü çíà÷åíèå
26	bool lResult = false;	26	bool lResult = false;
27	QVariant old_value; // ñîõðàíèì ñòàðîå çíà÷åíèå	27	QVariant old_value; // ñîõðàíèì ñòàðîå çíà÷åíèå
28	old_value = data(index);	28	old_value = data(index);
29		29
30	if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ	30	if (index.column()==1){ // åñëè ïîìåíÿëîñü èìÿ ïîëÿ
31	QSqlQuery qu;	31	QSqlQuery qu;
32	QString old_field_name; // ñòàðîå èìÿ ïîëÿ	32	QString old_field_name; // ñòàðîå èìÿ ïîëÿ
33	QString new_field_name; // íîâîå èìÿ ïîëÿ	33	QString new_field_name; // íîâîå èìÿ ïîëÿ
34	QString query_str;	34	QString query_str;
35	QString type_str; // òèï äàííûõ ïîëÿ	35	QString type_str; // òèï äàííûõ ïîëÿ
36	old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ	36	old_field_name = old_value.toString(); // îïðåäåëèì òåêóùåå (êîòîðîå íóæíî ïîìåíÿòü) èìÿ ïîëÿ
37	new_field_name = value.toString();	37	new_field_name = value.toString();
38	// type_str = data(ModelForPointers::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå	38	// type_str = data(ModelForPointers::index(index.row(), 3)).toString(); // òèï ïîëÿ õðàíèòüñÿ â 3 ñòîëáöå, ñ÷èòûâàåì åãî çíà÷åíèå
39	type_str = tr("CHAR(10)");	39	type_str = tr("CHAR(10)");
40		40
41	query_str = tr("ALTER TABLE ");	41	query_str = tr("ALTER TABLE ");
42	query_str.append(ModelForPointers::Inctance);	42	query_str.append(ModelForPointers::Inctance);
43	query_str.append(tr(" CHANGE COLUMN `"));	43	query_str.append(tr(" CHANGE COLUMN `"));
44	query_str.append(old_field_name);	44	query_str.append(old_field_name);
45	query_str.append(tr("` `"));	45	query_str.append(tr("` `"));
46	query_str.append(new_field_name);	46	query_str.append(new_field_name);
47	query_str.append(tr("` "));	47	query_str.append(tr("` "));
48	query_str.append(type_str);	48	query_str.append(type_str);
49	query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL"));	49	query_str.append(tr(" CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL"));
50	qu.prepare(query_str);	50	qu.prepare(query_str);
51	bool ok;	51	bool ok;
52	ok = qu.exec();	52	ok = qu.exec();
53	if (!ok) return false;	53	if (!ok) return false;
54	}	54	}
55		55
56		56
57		57
58	lResult = QSqlTableModel::setData(index, value, role);	58	lResult = QSqlTableModel::setData(index, value, role);
59	if (lResult) {	59	if (lResult) {
60	QModelIndex newindex;	60	QModelIndex newindex;
61	QSqlRecord rec = record(index.row());	61	QSqlRecord rec = record(index.row());
62		62
63	rec.setValue(index.column(), value);	63	rec.setValue(index.column(), value);
64	rec.setGenerated(index.column(), true);	64	rec.setGenerated(index.column(), true);
65		65
66		66
67	lResult = updateRowInTable(index.row(), rec);	67	lResult = updateRowInTable(index.row(), rec);
68	emit field_changed();	68	emit field_changed();
69	/// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);	69	/// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
70		70
71		71
72	}	72	}
73	return lResult;	73	return lResult;
74	}	74	}
75		75
76		76
77		77
78	QVariant ModelForPointers::data(const QModelIndex &index, int role) const {	78	QVariant ModelForPointers::data(const QModelIndex &index, int role) const {
79		79
80	QVariant value = QSqlTableModel::data(index, role);	80	QVariant value = QSqlTableModel::data(index, role);
81	switch (role) {	81	switch (role) {
82	case Qt::DisplayRole: return value;	82	case Qt::DisplayRole: {
-		83	if(index.column() == 4){
-		84	QSqlQuery q;
-		85	QString sql_str;
-		86	bool ok;
-		87	sql_str = tr("select * from `ListOfClasses` where `ID` = ");
-		88	sql_str.append(value.toString());
-		89
-		90	q.prepare(sql_str);
-		91
-		92	ok = q.exec();
-		93
-		94	if (ok) {
-		95	while(q.next()){
-		96	QString class_name = q.value(1).toString();
-		97	if (!class_name.isEmpty()) return class_name;
-		98
-		99	}
-		100
-		101
-		102	}
-		103
-		104	}
-		105
-		106
-		107	return value;
-		108	}
-		109
-		110
-		111
83	case Qt::EditRole: return value;	112	case Qt::EditRole: return value;
84	case Qt::TextColorRole:	113	case Qt::TextColorRole:
85	if(index.column() == 1)	114	if(index.column() == 1)
86	return qVariantFromValue(QColor(Qt::blue));	115	return qVariantFromValue(QColor(Qt::blue));
87	else	116	else
88	return value;	117	return value;
89	case Qt::TextAlignmentRole: return value;	118	case Qt::TextAlignmentRole: return value;
90	case Qt::FontRole:	119	case Qt::FontRole:
91	if(index.column() == 1) {	120	if(index.column() == 1) {
92	QFont font = QFont("Helvetica", 16, QFont::Bold);	121	QFont font = QFont("Helvetica", 16, QFont::Bold);
93	return qVariantFromValue(font);	122	return qVariantFromValue(font);
94	}else	123	}else
95	return value;	124	return value;
96		125
97	case Qt::BackgroundColorRole: {	126	case Qt::BackgroundColorRole: {
98	int a = (index.row() % 2) ? 14 : 0;	127	int a = (index.row() % 2) ? 14 : 0;
99	if(index.column() == 2)	128	if(index.column() == 2)
100	return qVariantFromValue(QColor(220,240-a,230-a));	129	return qVariantFromValue(QColor(220,240-a,230-a));
101	else if(index.column() == 4)	130	else if(index.column() == 4)
102	return qVariantFromValue(QColor(200,220-a,255-a));	131	return qVariantFromValue(QColor(200,220-a,255-a));
103	else	132	else
104	return value;	133	return value;
105	}	134	}
106		135
107		136
108		137
109	case Qt::CheckStateRole: return value;	138	case Qt::CheckStateRole: return value;
110		139
111	case Qt::SizeHintRole:return value;	140	case Qt::SizeHintRole:return value;
112		141
113	}	142	}
114	return value;	143	return value;
115	}	144	}
116		145
117	void ModelForPointers::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà	146	void ModelForPointers::setInctance(QString currInctatce){ // ïåðåäàåì èìÿ òåêóùåé òàáëèöû-õðàíèëèùà
118	ModelForPointers::Inctance = currInctatce;	147	ModelForPointers::Inctance = currInctatce;
119	}	148	}
120		149
121		150
122	bool ModelForPointers::onlySetData(const QModelIndex &index, const QVariant &value, int role){	151	bool ModelForPointers::onlySetData(const QModelIndex &index, const QVariant &value, int role){
123	bool lResult = false;	152	bool lResult = false;
124		153
125	QSqlRecord rec = record(index.row());	154	QSqlRecord rec = record(index.row());
126	rec.setValue(index.column(), value);	155	rec.setValue(index.column(), value);
127	rec.setGenerated(index.column(), true);	156	rec.setGenerated(index.column(), true);
128		157
129		158
130	lResult = QSqlTableModel::setData(index, value, role);	159	lResult = QSqlTableModel::setData(index, value, role);
131	if (lResult) {	160	if (lResult) {
132	lResult = updateRowInTable(index.row(), rec);	161	lResult = updateRowInTable(index.row(), rec);
133	// emit field_changed();	162	// emit field_changed();
134	/// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);	163	/// QSqlTableModel::setData(newindex, QVariant(str_tmp), Qt::EditRole);
135	}	164	}
136		165
137		166
138		167
139		168
140	return lResult;	169	return lResult;
141		170
142	}	171	}
143		172
144		173
145		174

Хранилища Subversion OpenInventory

(root)/trunk/ClassEditor/modelforpointers.cpp - Редакция 86 → 134