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