问来自mysql的Datagridview :简单库存库存
EN

Stack Overflow用户

提问于 2019-04-04 08:11:47

回答 1查看 41关注 0票数 0

我正在尝试创建一个简单的库存库存，根据mysql的输入和输出，我很难获得剩余的库存。

我真正需要的是减去input.quantity - output.quantity的总量，其中input.material等于output.material，如果total.quantity低于安全库存，那么datagridview将突出显示该行。

conn = New MySqlConnection
 conn.ConnectionString = "server=localhost;userid=root;password=1234;database=inventory"
        Dim searchquery As String = "Select input.DeliveryDate as 'Delivery Date',input.Material, (sum(input.Quantity) - sum(output.Quantity)) as 'Remaining Stocks' where rawmaterialsinput.Material = output.Material, safetystandard.safetystocks from inventory.input, inventory.output, inventory.safetystandard"

        Dim commander As New MySqlCommand(searchquery, conn)
        Dim adapter As New MySqlDataAdapter(commander)

        inventorydata.Clear()

        adapter.Fill(inventorydata)

        inventoryDGV.DataSource = inventorydata

到目前为止，这是我正在尝试的代码，但没有希望。请帮帮忙

我需要有4列数据与交货日期，原材料，剩余库存，安全库存。

vb.net

mysql-workbench

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-04-05 16:04:50

conn.Open()
        conn = New MySqlConnection
        conn.ConnectionString = "server=localhost;userid=root;password=SOUTHEAST;database=reportingsystem"
        Dim searchquery As String = "Select reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials as 'Raw Material', reportingsystem.rawmaterialswarehouseandrawmaterials.safetystocks as 'Safety Stocks', (select sum(reportingsystem.rawmaterialsinput.Quantity) - sum(reportingsystem.rawmaterialsoutput.Quantity) from reportingsystem.rawmaterialsinput, reportingsystem.rawmaterialsoutput where reportingsystem.rawmaterialsinput.RawMaterial = reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials ) as 'Remaining Stocks' from reportingsystem.rawmaterialswarehouseandrawmaterials" ' JOIN reportingsystem.rawmaterialsinput.RawMaterial ON reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials = reportingsystem.rawmaterialsinput.RawMaterial ORDER BY reportingsystem.rawmaterialswarehouseandrawmaterials.Rawmaterials"
        Dim commander As New MySqlCommand(searchquery, conn)
        Dim adapter As New MySqlDataAdapter(commander)

        monitoringdata.Clear()

        adapter.Fill(monitoringdata)

        MonitoringDGV.DataSource = monitoringdata 

conn.close()

在此代码中，仅选择了3列。希望能帮上忙

票数 0

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/55506026

复制

相似问题

问来自mysql的Datagridview :简单库存库存
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问来自mysql的Datagridview :简单库存库存EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问来自mysql的Datagridview :简单库存库存
EN