| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869 | using System;using System.Collections.Generic;using System.ComponentModel.DataAnnotations;using System.Data;using System.Data.Entity;using System.Data.Entity.Infrastructure;using System.Linq;using System.Net;using System.Net.Http;using System.Web;using System.Web.Http;using System.Web.Http.Description;using System.Web.Http.OData;using iBemsDataService;using iBemsDataService.Model;namespace iBemsDataService.Controllers{    public class FmsBudgetDetailExecutionExController : ODataController    {        private iBemsEntities db = new iBemsEntities();        // GET: odata/FmsEquipmentEx        [Queryable]        public List<FmsBudgetDetailExecutionEx> GetFmsBudgetDetailExecutionEx()        {            // 2019.07.12            Uri uri = Request.RequestUri;            var uriQuery = HttpUtility.ParseQueryString(uri.Query);            int siteId;            if (int.TryParse(uriQuery.Get("SiteId"), out siteId) == false)            {                throw new Exception("Not Found Parameters.");            }            var query = (                from d in db.FmsBudgetDetailExecution.Where(x => x.SiteId == siteId)                group d by new { d.SiteId, d.Year, d.Month } into grp                select new FmsBudgetDetailExecutionEx                {                    SiteId = grp.Key.SiteId,                    Year = grp.Key.Year,                    Month = grp.Key.Month                });           return query.ToList();        }        protected override void Dispose(bool disposing)        {            if (disposing)            {                db.Dispose();            }            base.Dispose(disposing);        }    }    public class FmsBudgetDetailExecutionEx     {        public int SiteId { get; set; }        public int Year { get; set; }        public int Month { get; set; }    }}
 |