EquipmentVisualService.cs
1.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
using Hh.Mes.Common.Request;
using Hh.Mes.POJO.Entity;
using Hh.Mes.POJO.Response;
using Hh.Mes.Service.Repository;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Data;
using System.Security.Claims;
using System.Text;
namespace Hh.Mes.Service.WebService.Equipment
{
/// <summary>
/// 设备可视化参数
/// </summary>
public class EquipmentVisualService : RepositorySqlSugar<base_equipment>
{
/// <summary>
/// 设备文件、设备报警记录
/// </summary>
public Response GetEquipmentFileList(base_equipment model)
{
var result = new Response();
var stringBuilder = new StringBuilder();
stringBuilder.AppendLine($@" select * from sys_File
where targetId=@targetId and targetTableName='base_equipment'
union all
select * from sys_File
where targetId=@targetId2 and targetTableName='base_equipment_type';
select * from daq_equipment_alarm_record t1 with (nolock)
where t1.IsHandled =0 and t1.EquipmentCode=@EquipmentCode
order by t1.CreateTime desc");
var dt = base.Context.Ado.GetDataSetAll(stringBuilder.ToString(), new List<SugarParameter>(){
new SugarParameter("@targetId", model.equipmentCode),
new SugarParameter("@targetId2", model.equipmentTypeCode),
new SugarParameter("@EquipmentCode", model.equipmentCode),
});
result.Result = new {
fileList = dt.Tables[0],
alarmList = dt.Tables[1],
};
result.Count = 1;
return result;
}
}
}