#include "boxform.h"
#include "ui_boxform.h"

BoxForm::BoxForm(datebase *db,int ID,QWidget *parent) :
 QDialog(parent),
 ui(new Ui::BoxForm)
{
 ui->setupUi(this);
 setWindowFlags(Qt::FramelessWindowHint);
 box_db=db;
 box_ID=ID;
 getNet();
 GetBoxInfo();
}

BoxForm::~BoxForm()
{
 delete ui;
}


void BoxForm::GetBoxInfo()
{
 bool res;
 QString str,pass,name,address;
 str=QString("select Pass_No,Card_Sn,Net_Address from FeeBox where Id = %1").arg(box_ID);
 QSqlQuery query(*this->box_db->sqlite_db);
 query.clear();
 query.exec(str);
 res=query.next();
 if(res)
 {
 pass=query.value(0).toString();
 name=query.value(1).toString();
 address=query.value(2).toString();

 int m=ui->comboBox_BoxM_Net->findText(address);
 ui->lineEdit_BoxM_Ic->setText(pass);
 ui->lineEdit_BoxM_Id->setText(name);
 ui->comboBox_BoxM_Net->setCurrentIndex(m);

 }
}

void BoxForm::on_pushButton_OK_clicked()
{
 QString pass,card,address;
 pass=ui->lineEdit_BoxM_Id->text().trimmed();
 card=ui->lineEdit_BoxM_Ic->text().trimmed();
 address=ui->comboBox_BoxM_Net->currentText().trimmed();
 box_db->updateBoxInfo(box_db->sqlite_db,box_ID,pass,card,address);
 this->close();
}

void BoxForm::on_pushButton_Quit_clicked()
{
 this->close();
}

void BoxForm::paintEvent(QPaintEvent *)//
{
 QPixmap pix(":/images/Sback.jpg");
 QPainter painter(this);
 int w = width();
 int h = height();
 painter.drawPixmap(0,0,w,h,pix);
}

void BoxForm::getNet()
{
 QSqlQuery query(*this->box_db->sqlite_db);
 QString name;
 QStringList strList;
 ui->comboBox_BoxM_Net->clear();
 query.exec(tr("select NetName from NetInfo order by Id asc"));
 for(int i=0;query.next();i++){
 name=query.value(0).toString();
 strList<<name;
 }
 ui->comboBox_BoxM_Net->addItems(strList);
}