Хранилища Subversion OpenInventory

Сравнить редакции

Не учитывать пробелы Редакция 37 → Редакция 38

/trunk/ClassEditor/classeditor.cpp
10,16 → 10,21
settdialog.show();
sql.setDatabaseName(tr("an_db"));
field = new TableField(tr("Ñîòðóäíèêè"), this);
// field->setNotNull(true);
field->setNotNull(true);
field->setDefaultValue(tr("ñîòðóäíèê"));
ui->lineEdit->insert(field->sqlString());
//delete field;
 
table = new SqlTable (tr("NewTable"), this);
table->setName(tr("NewTable"));
ui->label_2->setText(table->name());
ui->label->setText(table->fields().at(0)->sqlString());
 
 
}
 
ClassEditor::~ClassEditor()
{
delete ui;
// delete field;
// delete settdialog;
}
 
/trunk/ClassEditor/sqltable.h
8,22 → 8,27
 
class SqlTable : public QObject
{
Q_OBJECT
Q_OBJECT
public:
explicit SqlTable(QString tname, QObject *parent = 0);
 
 
void setName(QString tname);
void setName(QString tname); // ôóíêöèÿ ïðèñâàèâàåò èìÿ òàáëèöå, èìå ïåðåäàåòñÿ â ïàðàìåòðå ôóíêöèè tname
QString name(); // ôóíêöèÿ áåç ïàðàìåòðîâ âîçâðàùàåò èìÿ òàáëèöû
QList<TableField*> fields(); // âîçâðàùàåò ñïèñîê óêàçàòåëåé íà ïîëÿ òàáëèöû
 
 
 
private:
QString tableName; // èìÿ òàáëèöû
QString SqlString; // ñòðîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ òàáëèöû â áàçå äàííûõ
QList<TableField*> fields; // â ýòîì ñïèñêå íàõîäòñÿ âñå ïîëÿ òàáëèöû
//TableField *field_tmp;
QString tableName; // èìÿ òàáëèöû
QString SqlString; // ñòðîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ òàáëèöû â áàçå äàííûõ
QString characterSet; // ïåðåìåííàÿ ñîäåðæèò êîäèðîâêó, â êîòîðîé õðàíÿòüñÿ òåêñòîâûå äàííûå
QString primaryKey; // èìÿ ïîëÿ, ÿâëÿþùåãîñÿ ïåðâè÷íûì êëþ÷îì òàáëèöû
int primaryKeyIndex; // ïîðÿäêîâûé íîìåð ïîëÿ (â ñïèñêå ïîëåé fields), êîòîðîå ÿâëÿåòñÿ ïåðâè÷íûì êëþ÷îì òàáëèöû
QList<TableField*> tableFields; // â ýòîì ñïèñêå íàõîäòñÿ âñå ïîëÿ òàáëèöû
TableField *field_tmp;
protected:
 
 
 
};
 
#endif // SQLTABLE_H
/trunk/ClassEditor/tablefield.h
28,8 → 28,7
***********************************************************************************************/
 
 
/////explicit
TableField(QString fname = "ID", QObject *parent = 0, QString ftype = "CHAR(30)", QString fdefaultValue = "NULL");
explicit TableField(QString fname = "ID", QObject *parent = 0, QString ftype = "CHAR(30)", QString fdefaultValue = "NULL");
 
signals:
 
/trunk/ClassEditor/classeditor.h
3,9 → 3,9
 
#include <QMainWindow>
#include "mysql.h"
#include "settingsdialog.h"
#include "tablefield.h"
 
 
 
namespace Ui {
class ClassEditor;
}
24,6 → 24,7
MySql sql;
SettingsDialog settdialog;
TableField *field;
SqlTable *table;
};
 
#endif // CLASSEDITOR_H
/trunk/ClassEditor/classeditor.ui
14,16 → 14,32
<string>ClassEditor</string>
</property>
<widget class="QWidget" name="centralWidget">
<widget class="QLineEdit" name="lineEdit">
<widget class="QLabel" name="label">
<property name="geometry">
<rect>
<x>20</x>
<y>30</y>
<width>571</width>
<height>32</height>
<x>10</x>
<y>40</y>
<width>581</width>
<height>21</height>
</rect>
</property>
<property name="text">
<string>TextLabel</string>
</property>
</widget>
<widget class="QLabel" name="label_2">
<property name="geometry">
<rect>
<x>10</x>
<y>70</y>
<width>581</width>
<height>21</height>
</rect>
</property>
<property name="text">
<string>TextLabel</string>
</property>
</widget>
</widget>
<widget class="QMenuBar" name="menuBar">
<property name="geometry">
31,7 → 47,7
<x>0</x>
<y>0</y>
<width>600</width>
<height>28</height>
<height>27</height>
</rect>
</property>
</widget>
/trunk/ClassEditor/sqltable.cpp
1,18 → 1,48
#include "sqltable.h"
 
SqlTable::SqlTable(QString tname, QObject *parent):
SqlTable::SqlTable(QString tname, QObject *parent) :
QObject(parent)
{
TableField field_tmp;
 
tableName = tname;
//field_tmp = new TableField(tr("ID")); // ïðè ñîçäàíèè òàáëèöû äîáàâèì ïîëå "ID" (ñ÷åò÷èê)
field_tmp.setType(tr("INT(10)"));
fields.append(&field_tmp);
field_tmp = new TableField("ID", this); // ïðè ñîçäàíèè òàáëèöû äîáàâèì ïîëå "ID" (ñ÷åò÷èê)
field_tmp->setType(tr("INT(10)"));
tableFields.append(field_tmp); // äîáàâëÿåì íîâîå ïîëå (óêàçàòåëü) â ñïèñîê (óêàçàòåëåé) ïîëåé
primaryKey = field_tmp->name(); // äåëàåì íàøå åäèíñòâåííîå ïîëå ïåðâè÷íûì êëþ÷îì
//delete field_tmp;
}
 
/***************************************************************************************
** ôóíêöèÿ ïðèñâàèâàåò èìÿ òàáëèöå, íîâîå èìÿ ïåðåäàåòñÿ â ïàðàìåòðå ôóíêöèè tname
**
**
***************************************************************************************/
 
 
void SqlTable::setName(QString tname){
SqlTable::tableName = tname;
}
 
/***************************************************************************************
** ôóíêöèÿ âîçâðàùàåò èìÿ òàáëèöû
**
**
***************************************************************************************/
 
 
QString SqlTable::name(){
 
return SqlTable::tableName;
}
 
 
/***************************************************************************************
** ôóíêöèÿ âîçâðàùàåò ñïèñîê óêàçàòåëåé íà ïîëÿ òàáëèöû
**
**
***************************************************************************************/
 
QList<TableField*> SqlTable::fields(){
 
return SqlTable::tableFields;
}
/trunk/ClassEditor/mysql.h
13,6 → 13,10
#ifndef MYSQL_H
#define MYSQL_H
 
#include "settingsdialog.h"
#include "tablefield.h"
#include "sqltable.h"
 
#include <QObject>
#include <QtGui>
#include <QMainWindow>