Account.MonthlyManagement.ServiceImplement.MonthlyService.GetMonthlys C# (CSharp) Метод

        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);
        }