查询统计

 

在查询统计时需要对其指定别名 并且要跟实体的名字一样

 这是查询语句

　　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 ProductID,Mark", conn);

　这是实体

 public class CountSum

    {
        public Guid ProductID { get; private set; }//产品编号
        public int Mark { get; private set; }//出入库标记
        public int CountNum { get; private set; }//出入库的数量
    }