#include "netform.h"
#include "ui_netform.h"

NetForm::NetForm(datebase *db,int ID,QWidget *parent) :
    QDialog(parent),
    ui(new Ui::NetForm)
{
    ui->setupUi(this);
    setWindowFlags(Qt::FramelessWindowHint);
    net_db=db;
    Net_ID=ID;
    GetNetInfo();
}

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

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

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

void NetForm::on_pushButton_OK_clicked()
{
    NetInfo nInfo;
    nInfo.Pass_No=ui->lineEdit_passNo->text();
    nInfo.NetName=ui->lineEdit_name->text();
    nInfo.Address=ui->lineEdit_address->text();
    nInfo.Phone=ui->lineEdit_phone->text();
    nInfo.Person=ui->lineEdit_person->text();
    nInfo.UpSection=ui->lineEdit_section->text();
    nInfo.NetFlag=ui->lineEdit_flag->text();
    net_db->updateNetInfo(net_db->sqlite_db,Net_ID,&nInfo);
    this->close();
}

void NetForm::GetNetInfo()
{
    bool res;
    QString str,pass,name,address,phone,person,section,flag;
    str=QString("select Pass_No,NetName,Address,Phone,Person,UpSection,NetFlag from NetInfo where Id = %1").arg(Net_ID);
    QSqlQuery query(*this->net_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();
        phone=query.value(3).toString();
        person=query.value(4).toString();
        section=query.value(5).toString();
        flag=query.value(6).toString();

        ui->lineEdit_passNo->setText(pass);
        ui->lineEdit_name->setText(name);
        ui->lineEdit_address->setText(address);
        ui->lineEdit_phone->setText(phone);
        ui->lineEdit_person->setText(person);
        ui->lineEdit_section->setText(section);
        ui->lineEdit_flag->setText(flag);
    }
}