示例#1
0
 public IHttpActionResult Get_Pump_Log(postDataViewModel post)
 {
     try
     {
         var tag = post.value_1;
         var list = ScadaRepo.Get_PumpStatus(DateTime.Today, tag);
         var vm = (from x in list
                   select new
                   {
                       timeStamp = x.timeStamp,
                       run = x.run
                   }).ToList();
         return this.Ok(vm);
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine(ex.Message);
         return this.NotFound();
     }
 }
示例#2
0
 public IHttpActionResult Get_WaterQuality_Log(postDataViewModel post)
 {
     try
     {
         DateTime convertDate = DateTime.ParseExact(post.dateTime, "dd-MM-yyyy", new CultureInfo("en-US"));
         var list = (from x in db.water_quality_log1hr
                    where SqlFunctions.DatePart("day", x.LocalCol) == convertDate.Day
                     && SqlFunctions.DatePart("month", x.LocalCol) == convertDate.Month
                     && SqlFunctions.DatePart("year", x.LocalCol) == convertDate.Year
                    orderby x.LocalCol ascending
                    select x).ToList();
         if (list.Count > 0)
             return this.Ok(list);
         else
             return this.NotFound();
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine(ex.Message);
         return this.NotFound();
     }
 }
示例#3
0
 public IHttpActionResult Get_Power_Log(postDataViewModel post)
 {
     try
     {
         DateTime convertDate = DateTime.ParseExact(post.dateTime, "dd-MM-yyyy", new CultureInfo("en-US"));
         var list = ScadaRepo.Get_Power_Log(convertDate);
         return this.Ok(list);
     }
     catch (Exception ex)
     {
         System.Diagnostics.Debug.WriteLine(ex.Message);
         return this.NotFound();
     }
 }