摘要: 在查询统计时需要对其指定别名 并且要跟实体的名字一样这是查询语句 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 阅读全文
posted @ 2013-05-25 16:06 txbauo 阅读(127) 评论(0) 推荐(0) 编辑