QT 新增入库操作并保存至数据库（库存管理系统）

最新推荐文章于 2024-06-14 00:08:27 发布

不想上课的hh

最新推荐文章于 2024-06-14 00:08:27 发布

阅读量358

点赞数 8

分类专栏： Qt从0到1 文章标签： qt 开发语言

本文链接：https://blog.csdn.net/weixin_54253218/article/details/136782827

版权

Qt从0到1 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

点击按钮弹出对话框

// 调用：新增商品对话框
#include "addcommodity.h" //设计师界面类
void MainWidget::on_pushButton_AddGoods_clicked()
{
    AddCommodity *adddlg=new AddCommodity();
    adddlg->show();
}

void AddCommodity::on_pushButton_Add_clicked()
{
    QSqlQuery sqlResult;
    QString strId,strName,strAmount,strUnitPrice,strSupplier,strDirector,strInputTime,strOutputTime,strRemarks;

    strId=ui->lineEdit_Id->text();
    strName=ui->lineEdit_Name->text();
    strAmount=ui->lineEdit_Amount->text();
    strUnitPrice=ui->lineEdit_UnitPrice->text();
    strSupplier=ui->lineEdit_Supplier->text();
    strDirector=ui->lineEdit_Director->text();

    QDateTime datetime=QDateTime::currentDateTime();
    QString strnowinputtime=datetime.toString("yyyy-MM-dd HH:mm:ss");

    strInputTime=strnowinputtime;
    strOutputTime=strnowinputtime;

    strRemarks=ui->textEdit_Remarks->toPlainText();


    if(ui->lineEdit_Id->text().isEmpty())
    {
        
        QMessageBox::critical(this,"Tips","新增商品编号不能为空，请重新输入？");
        ui->lineEdit_Id->setFocus();

        return;
    }

    QString sqlquery=QString("insert into commoditydatatable(StockId,StockName,StockAmount,StockUnitPrice,Supplier,Director,WareHousTime,DeliveryTime,Remarks) "
                             "values('%1','%2','%3','%4','%5','%6','%7','%8','%9')")
            .arg(strId).arg(strName).arg(strAmount).arg(strUnitPrice).arg(strSupplier).arg(strDirector).arg(strInputTime).arg(strOutputTime).arg(strRemarks);

    if(sqlResult.exec(sqlquery))
    {
        QMessageBox::information(this,"Tips","恭喜你，商品记录插入成功？");
    }
    else
    {
        QMessageBox::critical(this,"Tips","对不起商品记录插入失败，请重新检查？");
    }

}