public ActionResult GetProjectChartPropertyList(int id)
{
KBProject project = iProj.GetKBProjectById(id);
List <ProjectMapping> mappingList = iProjectMapping.GetProjectMappingsById(id);
List <ChartProperty> chartPropertiesList = iProperty.GetChartPropertyList(project.ChartId);
List <ChartPropertyProjectViewModel> chartPropProjList = new List <ChartPropertyProjectViewModel>();
ChartPropertyProjectViewModel chartProperty = null;
ProjectMapping mapping = null;
foreach (ChartProperty item in chartPropertiesList)
{
chartProperty = new ChartPropertyProjectViewModel();
chartProperty.CPId = item.CPId;
chartProperty.CPName = item.CPName;
mapping = mappingList.SingleOrDefault(mp => mp.CPId == item.CPId);
if (mapping != null)
{
chartProperty.Column = mapping.PropertyName;
}
chartPropProjList.Add(chartProperty);
}
var data = JsonConvert.SerializeObject(chartPropProjList, new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(new { total = chartPropProjList.Count, rows = data }, JsonRequestBehavior.AllowGet));
}
public ActionResult Display(string id)
{
string json = string.Empty;
KBProject projData = iProj.GetProjectByURL(id);
DataTable table = iProj.TestSQL(projData.ProjectSQL, projData.ProjectId);
Lazy <C3JSLine> line = null;
Lazy <C3JSBar> bar = null;
switch (projData.Chart.ChartType)
{
case "Line":
ChartProperty chartPtyCatalog =
iChartProperty.GetChartPropertyByCatalog(projData.ChartId);
ChartProperty chartPtyData =
iChartProperty.GetChartPropertyByData(projData.ChartId);
//取得專案設定的Chart對應屬性
List <ProjectMapping> projMappingList =
iProjectMapping.GetProjectMappingsById(projData.ProjectId);
//取得project的catalog col name
ProjectMapping projMappingCatalog =
projMappingList.SingleOrDefault(pm => pm.CPId == chartPtyCatalog.CPId);
//取得project的data col name
ProjectMapping projMappingData =
projMappingList.SingleOrDefault(pm => pm.CPId == chartPtyData.CPId);
line = new Lazy <C3JSLine>(() => new C3JSLine(table, projData.Chart.ChartScript));
json = line.Value.Generate(
projMappingList.Where(pm => pm.CPId == projMappingData.CPId).Select(pmc => pmc.PropertyName).ToArray(),
projMappingCatalog.PropertyName);
break;
case "Bar":
//bar = new Lazy<C3JSBar>(() => new C3JSBar(table, projData.Chart.ChartScript));
//bar.Value.Generate()
break;
default:
break;
}
ViewData["Script"] = json;
return(View());
}
