/// <summary> /// 导出Excel数据集 /// </summary> /// <returns></returns> public DataTable GetSum(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select COUNT(*) as [Count],ISNULL(SUM(ISNULL(GrossWeight,0)),0) as GrossWeight,ISNULL(SUM(ISNULL(Tare,0)),0) as Tare,ISNULL(SUM(ISNULL(NetWeight,0)),0) as NetWeight,ISNULL(SUM(ISNULL(Amount,0)),0) as Amount from T_Bill "); if (strWhere.Trim() != "") { strSql.Append(" where 1=1 " + strWhere); } return(DbHelperSQL.ExecuteDataTable(CommandType.Text, strSql.ToString(), null)); }