public string GetLabelsWithTreeGridFormat(int productLineId) { try { DataTable labelTable = ProductLineService.GetLabelsByProductLineId(productLineId); return(TreeGridJsonParser.DataTableToJson(labelTable, "ViewName", new string[] { "VariableName", "FieldName" })); } catch { return("[]"); } }
public string GetCoalConsumptionAlarmSettingsWithTreeGridFormat(int productLineId) { DataTable dt = EnergyConsumptionService.GetCoalConsumptionAlarmSettingsByFactoryId(productLineId); DataColumn parentIdColumn = new DataColumn("ParentID"); dt.Columns.Add(parentIdColumn); foreach (DataRow row in dt.Rows) { row["ParentID"] = ""; } return(TreeGridJsonParser.DataTableToJson(dt, "Name", "ParentID", "StandardValue", "AlarmValue")); }
public string GetElectricityConsumptionAlarmSettingsWithTreeGridFormat(int productLineId) { DataTable dt = EnergyConsumptionService.GetElectricityConsumptionAlarmSettingsByFactoryId(productLineId); DataColumn parentIdColumn = new DataColumn("ParentID"); dt.Columns.Add(parentIdColumn); foreach (DataRow row in dt.Rows) { string levelcode = row["LevelCode"].ToString().Trim(); if (levelcode.Length > 3) { row["ParentID"] = levelcode.Substring(0, levelcode.Length - 2); } } return(TreeGridJsonParser.DataTableToJson(dt, "LevelCode", "ParentID", "Name", "StandardValue", "AlarmValue")); }
public string GetFormulasWithTreeGridFormat(string groupId) { Guid id = new Guid(groupId); DataTable formulas = ExpressionService.GetFormulasByGroupId(id); DataColumn parentIdColumn = new DataColumn("ParentID"); formulas.Columns.Add(parentIdColumn); foreach (DataRow row in formulas.Rows) { string levelcode = row["LevelCode"].ToString().Trim(); if (levelcode.Length > 3) { row["ParentID"] = levelcode.Substring(0, levelcode.Length - 2); } } return(TreeGridJsonParser.DataTableToJson(formulas, "LevelCode", "ParentID", "Name", "Formula")); }
public string GetElectricPowerCountWithTreeGridFormat(int productLineId, string formulaGroupId) { Guid _formulaGroupId = new Guid(formulaGroupId); DataTable dt = ElectricPowerCountService.GetElectricPowerCount(productLineId, _formulaGroupId); DataColumn parentIdColumn = new DataColumn("ParentID"); dt.Columns.Add(parentIdColumn); foreach (DataRow row in dt.Rows) { string levelcode = row["LevelCode"].ToString().Trim(); if (levelcode.Length > 3) { row["ParentID"] = levelcode.Substring(0, levelcode.Length - 2); } } return(TreeGridJsonParser.DataTableToJson(dt, "LevelCode", "ParentID", "ProcessName", "PeakPower", "PeakCost", "ValleyPower", "ValleyCost", "FlatPower", "FlatCost", "TotalPower", "TotalCost")); }
public string GetAmmeterLabelsWithTreeGridFormat(int factoryId) { DataTable dt = MeterDataDisplayService.GetAmmetersByFactoryId(factoryId); return(TreeGridJsonParser.DataTableToJson(dt, "ElectricRoom", new string[] { "AmmeterNumber", "AmmeterName" })); }