在一笔交易中添加更多商品 [英] Add more Items in one transaction

问题描述

大家好，
我需要帮助，我使用C#Wpf应用程序创建了销售库存系统.我在一次交易中添加更多项目时遇到问题.对于这个项目，我使用了MySql数据库.
我设计了一个salesorder表和salesorderitems表

Hello everyone,
I need help, I created Sales Inventory System using C# Wpf application. I got problem in adding more items in just one transaction. For this project I used MySql Database .
I design a salesorder table and salesorderitems table

 salesorder
 (
  `id_bill` int(11) NOT NULL AUTO_INCREMENT,
  `ref_number` varchar(255) CHARACTER SET utf8 NOT NULL,
  `number` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `from` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `to` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `customer_code` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `DO_num` int(11) DEFAULT NULL,
  `DO_date` date DEFAULT NULL,
  `subtotal` double NOT NULL DEFAULT '0',
  `discount` float NOT NULL DEFAULT '0',
  `total` double NOT NULL DEFAULT '0',
  `paid_amount` double NOT NULL DEFAULT '0',
  `base_paid_amount` double NOT NULL DEFAULT '0',
  `currency` char(3) CHARACTER SET latin1 DEFAULT NULL,
  `base_total` double NOT NULL DEFAULT '0',
  `description` text CHARACTER SET latin1,
  `quote_number` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `invoice_number` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `time` datetime NOT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_bill`)
)

salesorderitems 
  (
  `id_bill_items` int(11) NOT NULL AUTO_INCREMENT,
  `id_bill` int(11) NOT NULL,
  `item_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `item_code` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `warehouse` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `unit` varchar(10) CHARACTER SET utf8 NOT NULL,
  `unit_price` double NOT NULL DEFAULT '0',
  `currency` char(3) CHARACTER SET utf8 NOT NULL,
  `unit_base_price` double NOT NULL DEFAULT '0',
  `quantity` double NOT NULL DEFAULT '0',
  `quantity_unit` varchar(10) CHARACTER SET utf8 NOT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `amount_currency` char(3) CHARACTER SET utf8 NOT NULL,
  `base_amount` double NOT NULL DEFAULT '0',
  `misc` text CHARACTER SET utf8,
  `tax_rate` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_bill_items`)
)

您能帮我解决这个问题吗?


谢谢，
Priya

Can you help me on how to solve this?


Thanks,
Priya

推荐答案

不确定为什么要发布表结构.您需要使用 MySqlTransaction [^ ]类.

Not sure why you posted the table structures. You need to wrap your SQL statement execution in your code inside transaction using MySqlTransaction[^] class.

这篇关于在一笔交易中添加更多商品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！