/// <summary>
/// 获取设备信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ResultDevicePropList GetDevicePropInfo(QueryDevicePropContact query)
{
ExecuteResult resultInfo = new ExecuteResult();
try
{
ResultDevicePropList result = new ResultDevicePropList();
result.DevicePropList = new List<DevicePropInfo>();
result.Page = new Padding();
int total = 0;
//string where = string.Format("and device_itemcode in (select ID from dbo.GetAllChildren({0})) or device_itemcode={1}", query.ItemCodeId, query.ItemCodeId);
result.DevicePropList = GetDevicePropInfoList(query, out total);
result.Page.Current = query.PageCurrent;
result.Page.Total = total;
resultInfo.Success = true;
resultInfo.ExceptionMsg = string.Empty;
result.ResultInfo = resultInfo;
return result;
}
catch (Exception ex)
{
resultInfo.Success = false;
resultInfo.ExceptionMsg = ex.Message;
return new ResultDevicePropList { ResultInfo = resultInfo };
}
}
/*
/// <summary>
/// 设备树(不用）
/// </summary>
/// <param name="devices"></param>
/// <param name="query"></param>
/// <returns></returns>
public string GetDeviceTree(List<TB_DeviceProp> devices, QueryDevicePropContact query)
{
StringBuilder Result = new StringBuilder();
if (devices.Count > 0)
{
Result.Append("[");
Result.Append("{ \"id\": 0, \"name\": \"所有设备\", \"open\": true },");
foreach (var row in devices)
{
Result.Append("{\"id\":" + row.Id + ",\"name\":\"" + row.DeviceName + "\",\"open\":true,\"pId\":0");
if (query.AreaType == 1)
{
Result.Append(string.Format(",\"checked\":{0}", (row.AreaId1 == query.AreaId).ToString().ToLower()));
}
else
{
Result.Append(string.Format(",\"checked\":{0}", (row.AreaId2 == query.AreaId).ToString().ToLower()));
}
Result.Append("},");
}
Result = Result.Remove(Result.Length - 1, 1);
Result.Append("]");
}
return Result.ToString();
}
* */
/// <summary>
/// 获取设备信息列表
/// </summary>
/// <param name="query"></param>
/// <param name="total"></param>
/// <returns></returns>
public List<DevicePropInfo> GetDevicePropInfoList(QueryDevicePropContact query, out int total)
{
List<DevicePropInfo> resultList = new List<DevicePropInfo>();
string where = string.Empty;
if (query.ItemCodeId != 0)
{
where = string.Format("and device_itemcode in (select ID from dbo.GetAllChildren({0})) or device_itemcode={1}", query.ItemCodeId, query.ItemCodeId);
}
if (!string.IsNullOrEmpty(query.DeviceName))
{
where += string.Format(" and exists (select * from becm_device where becm_device.deviceid=deviceprop.deviceid and devicename like '%{0}%')", query.DeviceName.Trim());
}
var devices = devicePropOperator.GetDevicePropInfo(where);
total = devices.Count();
resultList = devices.Select(p => new DevicePropInfo
{
AreaName = "",
DeviceName = p.DeviceName,
ItemCodeName = p.ItemCodeName,
ID = p.Id,
AreaId1 = p.AreaId1,
AreaId2 = p.AreaId2
}).Skip((query.PageCurrent - 1) * query.PageSize).Take(query.PageSize).ToList();
foreach (var item in resultList)
{
item.AreaName = GetAreaName(item.AreaId1, item.AreaId2);
}
return resultList;
}
