public string GetHorizontalAnalysisTrendline(string tagItems, string trendlineType, string startTime, string endTime)
{
// tagItems 格式：
// OrganizationID（组织机构ID） LevelCode（层次码） Name（名称）
DataTable tagTable = DataGridJsonParser.JsonToDataTable(tagItems.JsonPickArray("rows"), GetTagTable());
DataTable dt = GetElectricityUsage(tagTable, startTime, endTime);
// 获取横坐标（列，时间信息）
IList <string> colNames = new List <string>();
foreach (DataColumn dc in dt.Columns)
{
colNames.Add(dc.ColumnName.ToString());
}
// 获取图例（行，数据信息）
IList <string> rowName = new List <string>();
foreach (DataRow dr in tagTable.Rows)
{
rowName.Add(dr["Name"].ToString());
}
return(EasyUIJsonParser.ChartJsonParser.GetGridChartJsonString(dt, colNames.ToArray(), rowName.ToArray(), "年-月-日-时", "kWh", 1));
}
public string GetWorkingSectionWithDataGridFormat(int productLineId)
{
DataTable dt = WorkingSectionService.GetWorkingTeamByProductLineId(productLineId);
dt.Columns["ID"].ColumnName = "WorkingSectionID";
dt.Columns["Name"].ColumnName = "WorkingSectionName";
return(DataGridJsonParser.DataTableToJson(dt, "WorkingSectionID", "WorkingSectionName"));
}
public string GetModelDatas(string builderId)
{
CustomAnalyseItemService service = new CustomAnalyseItemService();
DataTable dt = service.GetDIYAnalyseModel();
string[] column = { "ID", "Name", "Date", "Builder", "Description", "IsPrivate" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetWorkingSectionDatas()
{
WorkingSectionService service = new WorkingSectionService();
DataTable dt = service.GetWorkingSection();
string[] column = { "ID", "ProductLineID", "Name", "Remarks" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetDataGridDatas()
{
CementTypeConvertCoefficientService servic = new CementTypeConvertCoefficientService();
DataTable dt = servic.GetDatas();
string[] column = { "ID", "CementTypes", "ConvertCoefficient", "Remarks" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetStaffInfoDatas()
{
StaffInfoService service = new StaffInfoService();
DataTable dt = service.GetStaffInfo();
string[] column = { "ID", "Name", "Sex", "PhoneNumber" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetDCSWarningLogData()
{
DCSAlarmService service = new DCSAlarmService();
DataTable dt = service.GetDCSWarningLog();
string[] column = { "WarningTime", "Label", "EndingTime", "Message", "HandleInformation" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetKPIDatas()
{
KPIMaintainService service = new KPIMaintainService();
DataTable dt = service.GetKPI();
string[] column = { "StandardCategory", "Limit_CCS_CCClinker", "Limit_CC_ECClinker", "Limit_CC_ECCement", "Limit_CC_EnCClinker", "Limit_CC_EnCCement", "RawBatch_ElectricityConsumption", "Clinker_CoalConsumption", "Clinker_ElectricityConsumption", "Cement_ElectricityConsumption" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetHaltReasonDatas()
{
MachineHaltReasonService service = new MachineHaltReasonService();
DataTable dt = service.GetMachineHaltReason();
string[] column = { "ID", "Name", "Remarks" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetModelDatasByModelID(string DIYAnalyseModelID)
{
int id = 0;
int.TryParse(DIYAnalyseModelID, out id);
CustomAnalyseItemService service = new CustomAnalyseItemService();
DataTable dt = service.GetModelDatasByDIYAnalyseModelID(id);
string[] column = { "ID", "DIYAnalyseModelID", "ProductLineID", "ProductLineName", "VariableName", "VariableDescription" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetAlarmConfigureDatas(string ProductLineID)
{
int id = 0;
int.TryParse(ProductLineID, out id);
MasterConfigureService service = new MasterConfigureService();
DataTable dt = service.GetAlarmConfigure(id);
string[] column = { "VariableName", "EquipmentName", "Ismaster", "Belong", "IsAlarm", "StopPosition", "AlarmPosition", "AlarmMessage" };
string result = DataGridJsonParser.DataTableToJson(dt, column);
return(result);
}
public string GetWorkingSectionAssignmentWithDataGridFormat(int handoverLogId)
{
DataTable dt = HandoverLogService.GetWorkingSectionAssignmentByHandoverLogId(handoverLogId);
return(DataGridJsonParser.DataTableToJson(dt, "WorkingSectionID", "StaffID", "StaffName", "WorkingSectionName"));
}
public string GetFormulaGroupsPendingExpirationWithDataGridFormat(int factoryId)
{
DataTable formulaGroups = ExpressionService.GetFormulaGroupsPendingExpiration(factoryId);
return(DataGridJsonParser.DataTableToJson(formulaGroups, "KeyID", "Name", "CreateDate", "State", "EffectiveDate", "ExpirationDate"));
}
public string GetHandoverLogWithDataGridFormat()
{
DataTable dt = HandoverLogService.GetHandoverLog();
return(DataGridJsonParser.DataTableToJson(dt, "ID", "ProductLineID", "ProductLineName", "ShiftDate", "Shifts", "WorkingTeamID", "WorkingTeamName", "ChargeManID", "ChargeManName"));
}
public string GetMachineHaltLogWithDataGridFormat(int productLineId)
{
DataTable dt = MachineHaltLogService.GetHaltLog(productLineId);
return(DataGridJsonParser.DataTableToJson(dt, "HaltTime", "Label", "Machine"));
}
public string GetDCSWarningLogWithDataGridFormat(int productLineId)
{
DataTable dt = DCSWarningLogService.GetWarningLog(productLineId);
return(DataGridJsonParser.DataTableToJson(dt, "WarningTime", "Label", "Message"));
}
public string GetFormulaGroupsWithDataGridFormat(int factoryId)
{
DataTable formulaGroups = ExpressionService.GetFormulaGroupsByFactoryId(factoryId);
return(DataGridJsonParser.DataTableToJson(formulaGroups, "KeyID", "Name", "CreateDate", "State"));
}
public static string GetStaffInfoWithDataGridFormat(string organizationId, string searchName, string searchId, string searchTeamName)
{
DataTable dt = StaffInfoService.GetStaffInfo(organizationId, searchName, searchId, searchTeamName);
return(DataGridJsonParser.DataTableToJson(dt));
}