摘要:
在查询统计时需要对其指定别名 并且要跟实体的名字一样这是查询语句 cmd = new System.Data.SqlClient.SqlCommand(@"select ProductID,Mark,sum(StockNum) as CountNum from Stock_StockInnfo where StockDataTime>( select max(InventoryTime) from Stock_InventoryInfo )and AuditStatus=1 and Mark=1 and WarehouseCode=@WarehouseCode group by 阅读全文