public void SaveFormulasWithTreeGridFormat(string groupId, string json)
{
Guid id = new Guid(groupId);
DataTable dt = TreeGridJsonParser.JsonToDataTable(json.ToString());
ExpressionService.SaveFormulas(id, dt);
}
public static string GetMachineHaltReasonsWithTreeGridFormat()
{
DataTable dt = MachineHaltReasonsService.GetMachineHaltReasons();
string json = TreeGridJsonParser.DataTableToJsonByLevelCode(dt, "LevelCode", "MachineHaltReasonID", "ReasonText", "ReasonStatisticsTypeId", "Remarks", "Enabled");
return(json);
}
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 static string GetProcessWithTreeGridFormat(string organizationId)
{
DataTable dt = ProcessService.GetSystemProcessByOrganizationID(organizationId);
return(TreeGridJsonParser.DataTableToJsonByLevelCode(dt, "LevelCode"));
}
public string GetAmmeterLabelsWithTreeGridFormat(int factoryId)
{
DataTable dt = MeterDataDisplayService.GetAmmetersByFactoryId(factoryId);
return(TreeGridJsonParser.DataTableToJson(dt, "ElectricRoom", new string[] { "AmmeterNumber", "AmmeterName" }));
}
public static void SaveMachineHaltReasons(string json)
{
DataTable dt = TreeGridJsonParser.JsonToDataTable(json);
MachineHaltReasonsService.SaveMachineHaltReasons(dt);
}
