public ActionResult GetTrendData(string code, string subCode)
{
try
{
DB_KPI_HISTORY_BLL hBLL = new DB_KPI_HISTORY_BLL();
List <DB_KPI_HISTORY> hList = hBLL.GetTrendData(code, subCode);
if (hList == null || hList.Count == 0)
{
return(Json(new RequestResult(null)));
}
List <string> kpiDates = new List <string>();
List <decimal> kpiValues = new List <decimal>();
List <decimal> kpiTarget = new List <decimal>();
foreach (var h in hList)
{
kpiDates.Add(h.KPI_DATE.ToString("yyyy/MM/dd"));
kpiValues.Add(h.KPI_VALUE);
kpiTarget.Add(h.KPI_TARGET ?? 0);
}
var obj = new
{
kpiDates = kpiDates,
kpiValues = kpiValues,
kpiTarget = kpiTarget
};
return(Json(new RequestResult(obj)));
}
catch (Exception ex)
{
LogHelper.WriteLog("GetTrendData", ex);
return(Json(new RequestResult(false, ex.Message)));
}
}
public ActionResult GetLatestHistory(string kpiGroup)
{
try
{
DB_KPI_HISTORY_BLL hBLL = new DB_KPI_HISTORY_BLL();
List <ExDBKPICode> codeList = hBLL.GetDistinctKPICode(kpiGroup);
List <ExDBKPIHistory> result = hBLL.GetLatestHistory(codeList, kpiGroup);
if (result != null)
{
foreach (var r in result)
{
r.WEEK = DateHelper.GetWeekOfYear(r.KPI_DATE);
r.VALUE_COLOR = GetKPIValueColor(r);
}
}
var obj = new
{
History = result,
Group = codeList
};
return(Json(new RequestResult(obj)));
}
catch (Exception ex)
{
LogHelper.WriteLog("GetLatestHistory", ex);
return(Json(new RequestResult(false, ex.Message)));
}
}
