工作订单交易。 Visual Studio和SQL服务器 [英] Job order transaction. Visual studio and SQL server

问题描述

我的论文是服务公司的库存管理系统。所以我做了分析和销售订单。我几乎完成了Job Ordering交易，但我似乎无法做到正确。理论上说，材料成本和员工的劳务费应该加到默认服务费上。我已经完成了这些材料，但我似乎无法将服务和人工费加起来。从技术上讲，我非常缺乏编程和完整的新手。我真的需要了解如何对此进行编码，以便将人工费和服务费加起来并显示在数据网格视图中。



什么我试过了：



我尝试使用与添加材料相同的代码，但因为服务费和人工费没有数量，不像材料。它没有用。

My thesis is an Inventory Management System for a service firm. so I have done the profiling and the sales order. I'm almost done with the Job Ordering transaction but I just can't seem to get it right. the theory is that the Materials cost and the employee's labor fee should add to the default service fee. I've finished the materials but I just can't seem to get the Service and the Labor Fee to add up. technically I am very ill equipped with programming and a complete novice. I really need an idea on how I can code this so the Labor fee and the Service fee would add up and appear on the data grid view.

What I have tried:

I tried using the same codes I used for adding the materials but because the service fee and labor fee have no quantity unlike Materials. it's not working.

推荐答案

很难说没有看到你的代码，但也许你可以先在SQL Server Management Studio中创建一个视图，并确保显示正确的总数然后使用该视图作为网格视图的数据源。



使用SUM（）函数的一些示例： SUM（Transact-SQL） [ ^ ]



有趣的例子：计算SQL Server中的简单运行总计 [ ^ ]

Hard to say without seeing your code, but maybe you can first create a view in SQL Server Management Studio and make sure this displays the right totals and then use that view as the data source of your grid view.

Some examples of using the SUM() function: SUM (Transact-SQL)[^]

Interesting example: Calculating simple running totals in SQL Server[^]

这篇关于工作订单交易。 Visual Studio和SQL服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！