public GetMonthlys ( string start, string end ) : List |
||
start | string | |
end | string | |
return | List |
public List<Monthly> GetMonthlys(string start, string end)
{
List<Monthly> result = null;
DataTable dt = new DataTable();
string sql = @"SELECT NEWID() ID, DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) MONTH, SUM(COST) COST
FROM DAILY
WHERE DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) BETWEEN @START AND @END
GROUP BY DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE)
ORDER BY DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) ASC";
using (DbCommand cmd = _database.GetSqlStringCommand(sql))
{
_database.AddInParameter(cmd, "@START", DbType.String, start);
_database.AddInParameter(cmd, "@END", DbType.String, end);
using (IDataReader reader = _database.ExecuteReader(cmd))
{
dt.Load(reader);
}
}
if (dt != null && dt.Rows.Count > 0)
{
result = dt.ToList<Monthly>();
}
return result;
}
public List <Monthly> GetMonthlys(string start, string end) { List <Monthly> result = null; try { result = _service.GetMonthlys(start, end); } catch (Exception e) { _log.Error("GetMonthlys(string start, string end)", e); throw new Exception("获取月消费清单出错"); } return(result); }