qt 图书管理系统

/* * SqlCommand.cpp * * Created on: 2009-8-24 * Author: Administrator */ #include "SqlCommand.h" #include "GlobalDefine.h" SqlCommand::SqlCommand(QObject *parent) : QObject(parent) { qRegisterMetaType<MANAGEINFO> ("MANAGEINFO"); // TODO Auto-generated constructor stub } SqlCommand::~SqlCommand() { // TODO Auto-generated destructor stub } //////////////////////////////////////////////////////////////////// //////////////////////////////////BOOKMANAGE//////////////////////// //////////////////////////////////////////////////////////////////// void SqlCommand::RecvBookInfo(QDataStream &in, MANAGEINFO &recvInfo) { BOOKINFO bookInfo; switch (recvInfo.dwSubType) { case BOOK_ADD: GetBookInfo(in, bookInfo); BookAddInfo(bookInfo); break; case BOOK_DELETE: GetBookInfo(in, bookInfo); BookDelInfo(bookInfo); break; case BOOK_LIST: BookListInfo(bookInfo); break; case BOOK_QUERY: GetBookInfo(in, bookInfo); BookQueryInfo(bookInfo); break; case BOOK_RESPONSE: BookResponse(); break; case BOOK_UPDATE: GetBookInfo(in, bookInfo); BookUpdateInfo(bookInfo); break; default: return; } } void SqlCommand::GetBookInfo(QDataStream &in, BOOKINFO &bookInfo) { in >> bookInfo.sID; in >> bookInfo.sName; in >> bookInfo.sAuthor; in >> bookInfo.sType; in >> bookInfo.sPress; in >> bookInfo.sPressDate; in >> bookInfo.dwPageNum; in >> bookInfo.fPrice; in >> bookInfo.sAddDate; in >> bookInfo.dwLendTimes; in >> bookInfo.dwStatus; } void SqlCommand::BookAddInfo(BOOKINFO &bookInfo) { QString sSql; MANAGEINFO tmpInfo; BOOKLOGINFO bookLogInfo; sSql = "SELECT name, author, type, press, " "pressdate, pagenum, price, adddate, lendtimes, " "status, bookID FROM tbl_book WHERE bookID = '" + bookInfo.sID + "'"; if (!IsExist(sSql)) { sSql = "INSERT INTO tbl_book(name, author, type, press, " "pressdate, pagenum, price, adddate, lendtimes, " "status, bookID) VALUES('" + bookInfo.sName + "','" + bookInfo.sAuthor + "','" + bookInfo.sType + "','" + bookInfo.sPress + "','" + bookInfo.sPressDate + "','" + QString("%1").arg(bookInfo.dwPageNum) + "','" + QString("%1").arg(bookInfo.fPrice) + "','" + bookInfo.sAddDate + "','" + QString("%1").arg( bookInfo.dwLendTimes) + "','" + QString("%1").arg( bookInfo.dwStatus) + "','" + bookInfo.sID + "')"; bookLogInfo.sBookID = bookInfo.sID; bookLogInfo.sBookName = bookInfo.sName; bookLogInfo.dwOperation = BOOK_ADD; bookLogInfo.sType = bookInfo.sType; bookLogInfo.sIP = gUserLogInfo.sIP; bookLogInfo.sOperator = gUserLogInfo.sOperator; bookLogInfo.sDateTime = dateTime.currentDateTime().toString(DATETIME); if (ExcuteSqlCmd(sSql)) { bookLogInfo.dwResult = SUCCESS; bookLogInfo.sDescription = tr("Add book<<") + bookInfo.sName + tr( ">>successfully!"); } else { bookLogInfo.dwResult = FAILURE; bookLogInfo.sDescription = tr("DB ERROR"); } } else { bookLogInfo.dwResult = FAILURE; bookLogInfo.sDescription = tr("Book<<") + bookInfo.sID + tr( ">>have exist"); } ExcuteBookLogAdd(bookLogInfo); tmpInfo.dwType = RESULT; tmpInfo.dwSubType = BOOK; tmpInfo.bookLogInfo = bookLogInfo; Information(tmpInfo); } void SqlCommand::BookDelInfo(BOOKINFO &bookInfo) { MANAGEINFO tmpInfo; BOOKLOGINFO bookLogInfo; QString sSql; bookLogInfo.sBookID = bookInfo.sID; bookLogInfo.sBookName = bookInfo.sName; bookLogInfo.dwOperation = BOOK_DELETE; bookLogInfo.sType = bookInfo.sType; bookLogInfo.sIP = gUserLogInfo.sIP; bookLogInfo.sOperator = gUserLogInfo.sOperator; bookLogInfo.sDateTime = dateTime.currentDateTime().toString(DATETIME); sSql = "SELECT name, author, type, press, " "pressdate, pagenum, price, adddate, lendtimes, " "status, bookID FROM tbl_book WHERE bookID = '" + bookInfo.sID + "'"; if (IsExist(sSql)) { sSql = "DELETE FROM tbl_book where bookID = '" + bookInfo.sID + "'"; if (ExcuteSqlCmd(sSql)) { bookLogInfo.dwResult = SUCCESS; bookLogInfo.sDescription = tr("Delete book<<") + bookInfo.sName + tr(">>successfully!"); } else { bookLogInfo.dwResult = FAILURE; bookLogInfo.sDescription = tr("DB ERROR"); } } else { bookLogInfo.dwResult = FAILURE; bookLogInfo.sDescription = tr("Delete book<<") + bookInfo.sName + tr( ">>failed,No such book!"); } ExcuteBookLogAdd(bookLogInfo); tmpInfo.dwType = RESULT; tmpInfo.dwSubType = BOOK; tmpInfo.bookLogInfo = bookLogInfo; emit Information(tmpInfo); } void SqlCommand::BookListInfo(BOOKINFO &bookInfo) { MANAGEINFO tmpInfo; QString sSql = "SELECT name, author, type, press, " "pressdate, pagenum, price, adddate, lendtimes, " "status, bookID FROM tbl_book"; if (ExcuteSqlCmd(sSql)) { if (GetNextBook(tmpInfo.bookInfo)) { tmpInfo.dwSubType = BOOK_RESPONSE; } else { tmpInfo.dwSubType = SUCCESS; } } tmpInfo.dwType = BOOK; emit Information(tmpInfo); } void SqlCommand::BookResponse() { MANAGEINFO tmpInfo; if (GetNextBook(tmpInfo.bookInfo)) { tmpInfo.dwSubType = BOOK_RESPONSE; } else { tmpInfo.dwSubType = SUCCESS; } tmpInfo.dwType = BOOK; emit Information(tmpInfo); } void SqlCommand::BookQueryInfo(BOOKINFO &bookInfo) { MANAGEINFO tmpInfo; QString sSql = "SELECT name, author, type, press, " "pressdate, pagenum, price, adddate, lendtimes, " "status, bookID FROM tbl_book WHERE name like '%" + bookInfo.sName + "%'and bookID like'%" + bookInfo.sID + "%'and type like'%" + bookInfo.sType + "%'"; if (ExcuteSqlCmd(sSql)) { if (GetNextBook(tmpInfo.bookInfo)) { tmpInfo.dwSubType = BOOK_RESPONSE; } else { tmpInfo.dwSubType = SUCCESS; } } tmpInfo.dwType = BOOK; emit Information(tmpInfo); } void SqlCommand::BookUpdateInfo(BOOKINFO &bookInfo) { MANAGEINFO tmpInfo; BOOKLOGINFO bookLogInfo; bookLogInfo.sBookID = bookInfo.sID; bookLogInfo.sBookName = bookInfo.sName; bookLogInfo.dwOperation = BOOK_UPDATE; bookLogInfo.sType = bookInfo.sType; bookLogInfo.sIP = gUserLogInfo.sIP; bookLogInfo.sOperator = gUserLogInfo.sOperator; bookLogInfo.sDateTime = dateTime.currentDateTime().toString(DATETIME); QString sSql = "UPDATE tbl_book SET name='" + bookInfo.sName + "', author='" + bookInfo.sAuthor + "', type='" + bookInfo.sType + "', press='" + bookInfo.sPress + "', pressdate='" + bookInfo.sPressDate + "', pagenum='" + QString("%1").arg( bookInfo.dwPageNum) + "', price='" + QString("%1").arg( bookInfo.fPrice) + "', status='" + QString("%1").arg( bookInfo.dwStatus) + "'WHERE bookID='" + bookInfo.sID + "'"; if (ExcuteSqlCmd(sSql)) { bookLogInfo.dwResult = SUCCESS; bookLogInfo.sDescription = tr("Update book<<") + bookInfo.sName + tr( ">>successfully!"); } else { bookLogInfo.dwResult = FAILURE; bookLogInfo.sDescription = tr("DB ERROR"); } ExcuteBookLogAdd(bookLogInfo); tmpInfo.dwType = RESULT; tmpInfo.dwSubType = BOOK; tmpInfo.bookLogInfo = bookLogInfo; emit Information(tmpInfo); } bool SqlCommand::GetNextBook(BOOKINFO &bookInfo) { if (sqlQuery.isSelect() && sqlQuery.next()) { bookInfo.sName = sqlQuery.value(0).toString(); bookInfo.sAuthor = sqlQuery.value(1).toString(); bookInfo.sType = sqlQuery.value(2).toString(); bookInfo.sPress = sqlQuery.value(3).toString(); bookInfo.sPressDate = sqlQuery.value(4).toString(); bookInfo.dwPageNum = sqlQuery.value(5).toInt(&ok); bookInfo.fPrice = sqlQuery.value(6).toDouble(&ok); bookInfo.sAddDate = sqlQuery.value(7).toString(); bookInfo.dwLendTimes = sqlQuery.value(8).toInt(&ok); bookInfo.dwStatus = sqlQuery.value(9).toInt(&ok); bookInfo.sID = sqlQuery.value(10).toString(); return true; } else { sqlQuery.clear(); return false; } } void SqlCommand::SendBookInfo(QDataStream &out, MANAGEINFO &send