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 GetAvailableFormulaGroupWithComboboxFormat(int productLineId) { DataTable dt = ElectricPowerCountService.GetAvailableFormulaGroupByProductLineId(productLineId); return(ComboboxJsonParser.DataTableToJson(dt, "Name", "FormulaGroupID")); }