在查询统计时需要对其指定别名 并且要跟实体的名字一样
这是查询语句
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; }//出入库的数量
}