Хранилища Subversion OpenInventory

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

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

/trunk/source_code/src/slots.cpp
605,7 → 605,7
//Ñîçäàåì òàáëèöó îòäåëîâ
 
 
q.prepare(tr("CREATE TABLE an_db.otdeli ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
q.prepare(tr("CREATE TABLE otdeli ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Íàçâàíèå CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàíî\", "
"Ñïðàâêà CHAR(255) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåò\", "
"PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
617,7 → 617,7
 
q.clear();
q.prepare(tr("CREATE TABLE an_db.sotrydniki ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
q.prepare(tr("CREATE TABLE sotrydniki ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"ÔÈÎ CHAR(80) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàíî\", "
"Èäåíòèôèêàòîð_îòäåëà INTEGER UNSIGNED, "
"PRIMARY KEY ( Èäåíòèôèêàòîð )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
628,7 → 628,7
 
//Ñîçäàåì òàáëèöó ñèñòåìíûõ áëîêîâ
 
q.prepare(tr("CREATE TABLE an_db.system_blocks ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
q.prepare(tr("CREATE TABLE system_blocks ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ñåðèéíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Èíâåíòàðíûé_íîìåð CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå çàäàí\", "
"Äàòà_ïîêóïêè DATE, "
642,7 → 642,7
 
//Ñîçäàåì òàáëèöó ìàòåðèíñêèõ ïëàò
 
q.prepare(tr("CREATE TABLE an_db.matheboards ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
q.prepare(tr("CREATE TABLE matheboards ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
"Ñëîò CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòíî\", "
658,7 → 658,7
 
//Ñîçäàåì òàáëèöó ìîäóëåé ïàìÿòè
 
ok = q.prepare(tr("CREATE TABLE an_db.memory ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
ok = q.prepare(tr("CREATE TABLE memory ( Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
"Òèï ENUM(\"DIM\",\"DDR\",\"DDRII\",\"RIMM\",\"SIMM\") DEFAULT \"DDRII\", "
673,7 → 673,7
 
q.clear();
 
ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_pamyati (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
ok = q.prepare(tr("CREATE TABLE proizvoditeli_pamyati (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
"PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
ok = q.exec();
680,7 → 680,7
 
q.clear();
 
ok = q.prepare(tr("CREATE TABLE an_db.processors (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
ok = q.prepare(tr("CREATE TABLE processors (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
"×àñòîòà INTEGER UNSIGNED, "
694,7 → 694,7
 
q.clear();
 
ok = q.prepare(tr("CREATE TABLE an_db.processor_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
ok = q.prepare(tr("CREATE TABLE processor_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\""
") ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
705,7 → 705,7
 
 
 
ok = q.prepare(tr("CREATE TABLE an_db.harddiscs (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
ok = q.prepare(tr("CREATE TABLE harddiscs (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Èíòåðôåéñ CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Îáúåì INTEGER UNSIGNED, "
720,7 → 720,7
q.clear();
 
 
ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_hdd (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
ok = q.prepare(tr("CREATE TABLE proizvoditeli_hdd (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
"PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
ok = q.exec();
728,7 → 728,7
q.clear();
 
 
ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
ok = q.prepare(tr("CREATE TABLE proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
"PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
ok = q.exec();
738,7 → 738,7
 
 
 
ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_cpu (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
ok = q.prepare(tr("CREATE TABLE proizvoditeli_cpu (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
"PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
ok = q.exec();
749,7 → 749,7
 
 
 
ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
ok = q.prepare(tr("CREATE TABLE proizvoditeli_mb (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
"PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
ok = q.exec();
760,7 → 760,7
 
 
 
ok = q.prepare(tr("CREATE TABLE an_db.proizvoditeli_video (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
ok = q.prepare(tr("CREATE TABLE proizvoditeli_video (Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci NOT NULL, "
"PRIMARY KEY ( Ïðîèçâîäèòåëü )) ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
ok = q.exec();
769,7 → 769,7
 
 
 
ok = q.prepare(tr("CREATE TABLE an_db.video_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
ok = q.prepare(tr("CREATE TABLE video_models (Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòíà\", "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íå èçâåñòåí\""
") ENGINE = MyISAM CHARACTER SET cp1251 COLLATE cp1251_general_ci"));
 
781,7 → 781,7
 
 
 
ok = q.prepare(tr("CREATE TABLE an_db.cd_dvd (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
ok = q.prepare(tr("CREATE TABLE cd_dvd (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Òèï CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ñêîðîñòü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
795,7 → 795,7
q.clear();
 
 
ok = q.prepare(tr("CREATE TABLE an_db.videocards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
ok = q.prepare(tr("CREATE TABLE videocards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
"Èíòåðôåéñ CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
809,7 → 809,7
 
q.clear();
 
ok = q.prepare(tr("CREATE TABLE an_db.soundcards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
ok = q.prepare(tr("CREATE TABLE soundcards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
"Èäåíòèôèêàòîð_ñèñòåìíîãî_áëîêà INTEGER UNSIGNED DEFAULT 1, "
821,7 → 821,7
 
q.clear();
 
ok = q.prepare(tr("CREATE TABLE an_db.lancards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
ok = q.prepare(tr("CREATE TABLE lancards (Èäåíòèôèêàòîð INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, "
"Ïðîèçâîäèòåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåí\", "
"Ìîäåëü CHAR(30) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT \"íåèçâåñòåíà\", "
"Ñêîðîñòü_ïåðåäà÷è_äàííûõ INTEGER UNSIGNED DEFAULT 100, "
834,7 → 834,7
 
q.clear();
 
ok = q.prepare(tr("INSERT INTO an_db.otdeli VALUES( default, \"Ñêëàä\", \"Ñêëàä\")"));
ok = q.prepare(tr("INSERT INTO otdeli VALUES( default, \"Ñêëàä\", \"Ñêëàä\")"));
 
ok = q.exec();
 
/trunk/source_code/src/addmemoryform.cpp
17,11 → 17,11
QString mnfctSqlText, tmp;
QSqlQuery qproiz;
int field_proizvoditel;
mnfctSqlText = tr("select * from an_db.proizvoditeli_pamyati");
mnfctSqlText = tr("select * from proizvoditeli_pamyati");
// QSqlQuery qns(tr("SET NAMES utf8"));
qproiz.prepare(mnfctSqlText);
qproiz.exec();
// QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
// QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
mnfctrlist.clear();
while (qproiz.next()){
39,11 → 39,11
QString mnfctSqlText, tmp;
QSqlQuery qproiz;
int field_proizvoditel;
mnfctSqlText = tr("select * from an_db.proizvoditeli_video");
mnfctSqlText = tr("select * from proizvoditeli_video");
// QSqlQuery qns(tr("SET NAMES utf8"));
qproiz.prepare(mnfctSqlText);
qproiz.exec();
// QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
// QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
mnfctrlist.clear();
while (qproiz.next()){
63,11 → 63,11
QString mnfctSqlText, tmp;
QSqlQuery qproiz;
int field_proizvoditel;
mnfctSqlText = tr("select * from an_db.proizvoditeli_mb");
mnfctSqlText = tr("select * from proizvoditeli_mb");
// QSqlQuery qns(tr("SET NAMES utf8"));
qproiz.prepare(mnfctSqlText);
qproiz.exec();
// QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
// QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
mnfctrlist.clear();
while (qproiz.next()){
85,11 → 85,11
QString mnfctSqlText, tmp;
QSqlQuery qproiz;
int field_proizvoditel;
mnfctSqlText = tr("select * from an_db.proizvoditeli_hdd");
mnfctSqlText = tr("select * from proizvoditeli_hdd");
// QSqlQuery qns(tr("SET NAMES utf8"));
qproiz.prepare(mnfctSqlText);
qproiz.exec();
// QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
// QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
mnfctrlist.clear();
while (qproiz.next()){
106,11 → 106,11
QString mnfctSqlText, tmp;
QSqlQuery qproiz;
int field_proizvoditel;
mnfctSqlText = tr("select * from an_db.proizvoditeli_cpu");
mnfctSqlText = tr("select * from proizvoditeli_cpu");
// QSqlQuery qns(tr("SET NAMES utf8"));
qproiz.prepare(mnfctSqlText);
qproiz.exec();
// QSqlQuery qproiz("SELECT * FROM an_db.Ïðîèçâîäèòåëè_ïàìÿòè");
// QSqlQuery qproiz("SELECT * FROM Ïðîèçâîäèòåëè_ïàìÿòè");
field_proizvoditel = qproiz.record().indexOf(tr("Ïðîèçâîäèòåëü"));
mnfctrlist.clear();
while (qproiz.next()){
129,7 → 129,7
QString SqlText, tmp;
QSqlQuery qmodel;
int field_model;
SqlText = tr("select * from an_db.Ìîäåëè_ìàòåðèíñêèõ_ïëàò where an_db.Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \"");
SqlText = tr("select * from Ìîäåëè_ìàòåðèíñêèõ_ïëàò where Ìîäåëè_ìàòåðèíñêèõ_ïëàò.Ïðîèçâîäèòåëü = \"");
SqlText.append(proizvoditel);
SqlText.append(tr("\""));
qmodel.prepare(SqlText);
152,7 → 152,7
QString SqlText, tmp;
QSqlQuery qmodel;
int field_model;
SqlText = tr("select * from an_db.video_models where an_db.video_models.Ïðîèçâîäèòåëü = \"");
SqlText = tr("select * from video_models where video_models.Ïðîèçâîäèòåëü = \"");
SqlText.append(proizvoditel);
SqlText.append(tr("\""));
qmodel.prepare(SqlText);
175,7 → 175,7
QString SqlText, tmp;
QSqlQuery qmodel;
int field_model;
SqlText = tr("select * from an_db.processor_models where an_db.processor_models.Ïðîèçâîäèòåëü = \"");
SqlText = tr("select * from processor_models where processor_models.Ïðîèçâîäèòåëü = \"");
SqlText.append(proizvoditel);
SqlText.append(tr("\""));
qmodel.prepare(SqlText);
197,7 → 197,7
bool b1, b2;
QString tmp, SerialNum, InventarNum, DataPokypki, SrokGarantii, UserId, Identifikator;
int field_identifikator, field_serial_num, field_inventar_num, field_data_pokypki, field_srok_garantii, field_user_id;
QSqlQuery qysBlockList(tr("select * from an_db.system_blocks"));
QSqlQuery qysBlockList(tr("select * from system_blocks"));
field_serial_num = qysBlockList.record().indexOf(tr("Ñåðèéíûé_íîìåð"));
field_inventar_num = qysBlockList.record().indexOf(tr("Èíâåíòàðíûé_íîìåð"));
field_data_pokypki = qysBlockList.record().indexOf(tr("Äàòà_ïîêóïêè"));
237,7 → 237,7
QString identifikator_polzovatela, fio_polzovatela, identifikator_otdela;
int field_identifikator, field_fio, field_id_otdela;
QSqlQuery qSqlUserInfo;
sqlQueryText = tr("select * from an_db.Ñîòðóäíèêè where Èäåíòèôèêàòîð = ");
sqlQueryText = tr("select * from Ñîòðóäíèêè where Èäåíòèôèêàòîð = ");
sqlQueryText.append(userID);
qSqlUserInfo.prepare(sqlQueryText);
qSqlUserInfo.exec();
266,7 → 266,7
QString otdel, sqlText, tmp;
QSqlQuery query;
int field_name;
sqlText = (tr("select an_db.Îòäåëû.Íàçâàíèå from an_db.Îòäåëû where Èäåíòèôèêàòîð = "));
sqlText = (tr("select Îòäåëû.Íàçâàíèå from Îòäåëû where Èäåíòèôèêàòîð = "));
sqlText.append(otdelID);
query.prepare(sqlText);
query.exec();