Dim cmd As New SQLCommand
cmd.C
cmd.CommandText="sel ect FItemID,FStockID,sum(FQty) as 数量 from ICInventory group by FItemID,FStockID HAVING sum(FQty) > 0 and FStockID < 739"
Dim dt As DataTable = cmd.ExecuteReader
对K3即时库存进行条件取数后获得了一个 数据表 dt
如何 对dt表的 FItemID 进行 数量求和 并将数据写入 tb 表中。
"sel ect FItemID,FStockID,sum(FQty) as 数量 from ICInventory group by FItemID,FStockID HAVING sum(FQty) > 0 and FStockID < 739"
这个语句能修改一下 直接对 FItemID 的 FQty 求和不,条件是 FStockID < 739 即对原数据表中的部份数据进行分组求和。