public string getMonthData(q_Month_Average q) { db0 = getDB0(); var getUserIdCK = Request.Cookies["user_id"]; string getUserId = string.Empty; Apply_User getUserData = null; if (getUserIdCK == null) { getUserData = db0.Apply_User.Where(x => x.USERID == q.user_id).FirstOrDefault(); } else { getUserId = getUserIdCK.Value; getUserData = db0.Apply_User.Where(x => x.USERID == getUserId).FirstOrDefault(); } var getMonthData = db0.Apply_MonthAverage.Where(x => x.equipment_id == q.equipment_id && x.USERID == getUserData.USERID && x.Y == q.Y).FirstOrDefault(); IList<double> n = new List<double>(); if (q.query_use_type == 1) { n.Add((double)getMonthData.temperature_01); n.Add((double)getMonthData.temperature_02); n.Add((double)getMonthData.temperature_03); n.Add((double)getMonthData.temperature_04); n.Add((double)getMonthData.temperature_05); n.Add((double)getMonthData.temperature_06); n.Add((double)getMonthData.temperature_07); n.Add((double)getMonthData.temperature_08); n.Add((double)getMonthData.temperature_09); n.Add((double)getMonthData.temperature_10); n.Add((double)getMonthData.temperature_11); n.Add((double)getMonthData.temperature_12); } if (q.query_use_type == 2) { n.Add((double)getMonthData.oxygen_concentration_01); n.Add((double)getMonthData.oxygen_concentration_02); n.Add((double)getMonthData.oxygen_concentration_03); n.Add((double)getMonthData.oxygen_concentration_04); n.Add((double)getMonthData.oxygen_concentration_05); n.Add((double)getMonthData.oxygen_concentration_06); n.Add((double)getMonthData.oxygen_concentration_07); n.Add((double)getMonthData.oxygen_concentration_08); n.Add((double)getMonthData.oxygen_concentration_09); n.Add((double)getMonthData.oxygen_concentration_10); n.Add((double)getMonthData.oxygen_concentration_11); n.Add((double)getMonthData.oxygen_concentration_12); } db0.Dispose(); return defJSON(n.ToArray()); }
public ActionResult OpenMonthAverage(q_Month_Average q) { db0 = getDB0(); var getUserIdCK = Request.Cookies["user_id"]; string getUserId = string.Empty; Apply_User getUserData = null; if (getUserIdCK == null) { getUserData = db0.Apply_User.Where(x => x.USERID == q.user_id).FirstOrDefault(); } else { getUserId = getUserIdCK.Value; getUserData = db0.Apply_User.Where(x => x.USERID == getUserId).FirstOrDefault(); } var getEquipmet = db0.Equipment.Find(q.equipment_id); MonthHeadInfo md = new MonthHeadInfo(); md.Y = q.Y; md.user_id = q.user_id; md.apply_user_name = getUserData.USERNAME; md.equipment_id = q.equipment_id; md.equipment_sn = getEquipmet.equipment_sn; md.query_use_type = q.query_use_type; if (q.query_use_type == 1) { md.use_type_name = "煙氣出口溫度年平均值"; } if (q.query_use_type == 2) { md.use_type_name = "爐氣含氧體積濃度年平均值"; } return View(md); }
public string getYeartConcentration(q_Month_Average q) { db0 = getDB0(); string getUserId = this.UserId == null ? q.user_id : this.UserId; var getConcentrationData = db0.Apply_Detail.Where(x => x.equipment_id == q.equipment_id && x.USERID == getUserId).Select(x => x.avg_Y_oxygen_concentration).ToList(); ; db0.Dispose(); return defJSON(getConcentrationData); }
public string getYearTemperature(q_Month_Average q) { db0 = getDB0(); string getUserId = this.UserId == null ? q.user_id : this.UserId; var getTemperatureData = db0.Apply_Detail.Where(x => x.equipment_id == q.equipment_id && x.USERID == getUserId).Select(x => x.avg_Y_gas_temperature).ToList(); db0.Dispose(); return defJSON(getTemperatureData); }