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