public GetYearlys ( string start, string end ) : IEnumerable |
||
start | string | |
end | string | |
리턴 | IEnumerable |
public IEnumerable<Yearly> GetYearlys(string start, string end)
{
string sql = @"SELECT NEWID() ID, DATENAME(YEAR, DATE) YEAR, SUM(COST) COST
FROM DAILY
WHERE DATENAME(YEAR, DATE) BETWEEN @START AND @END
GROUP BY DATENAME(YEAR, DATE)
ORDER BY DATENAME(YEAR, DATE) ASC";
Dictionary<string, object> parameters = new Dictionary<string, object>()
{
{"START", start },
{ "END", end}
};
return _database.GetList<Yearly>(sql, parameters);
}
YearlyDAL::GetYearlys ( string start, string end, int pageIndex, int pageSize, int &count ) : IEnumerable |