public JsonResult GetGroupDevice(int groupId)
{
string idlist = GroupService.GetGroupNodeChildren(groupId);
IEnumerable <DeviceGroupModel> Items = DeviceGroupService.GetListByGroupId(idlist);
List <SelectOption> _select = new List <SelectOption>();
if (Items != null && Items.Count() > 0)
{
foreach (var item in Items)
{
SelectOption _option = new SelectOption
{
id = item.Id.ToString(),
name = item.ALIASNAME,
value = item.Id.ToString(),
value1 = item.IO_DEVICE_ID.ToString(),
value2 = item.IO_COMM_ID,
value3 = item.IO_SERVER_ID,
value4 = item.IOPARANAMES,
value5 = item.SerieType,
};
_select.Add(_option);
}
}
string deviceids = "'1'";
foreach (var item in Items)
{
deviceids += ",'" + item.IO_DEVICE_ID + "'";
}
var deviceItems = IO_DeviceServer.GetByWhere(" where IO_DEVICE_ID in (" + deviceids + ")");
foreach (var item in _select)
{
var searchs = deviceItems.Where(x => x.IO_DEVICE_ID.Trim().ToLower() == item.value1.Trim().ToLower());
if (searchs.Count() > 0)
{
var sItem = searchs.First();
if (string.IsNullOrWhiteSpace(sItem.IO_DEVICE_UPDATECYCLE))
{
item.value6 = "120";
}
else
{
item.value6 = sItem.IO_DEVICE_UPDATECYCLE;
}
}
}
return(Json(_select, JsonRequestBehavior.AllowGet));
}
public JsonResult ApiGetDeviceParasGridColumn(string id)
{
if (id == null || id == "")
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
IODeviceModel model = IO_DeviceServer.GetByWhere("where IO_DEVICE_ID='" + id + "'").First();
if (model == null)
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
List <GridColumn> columns = new List <GridColumn>();
if (model != null)
{
IEnumerable <IOParaModel> Items = IO_ParaServer.GetByWhere("where IO_DEVICE_ID='" + model.IO_DEVICE_ID + "'");
string IOPARANAMES = "";
string IOPARATITLES = "";
foreach (var item in Items)
{
string label = item.IO_LABEL == "" ? item.IO_NAME : item.IO_LABEL;
IOPARANAMES += (IOPARANAMES == "" ? item.IO_NAME : "," + item.IO_NAME);
IOPARATITLES += (IOPARATITLES == "" ? label : "," + label);
}
string[] fields = IOPARANAMES.Split(',');
string[] titles = IOPARATITLES.Split(',');
if (fields.Length == titles.Length)
{
for (int i = 0; i < fields.Length; i++)
{
GridColumn _option = new GridColumn
{
field = fields[i],
title = titles[i],
width = "120"
};
columns.Add(_option);
}
}
}
columns.Insert(0, new GridColumn()
{
field = "DateStampTime",
title = "采集时间",
width = "120"
});
return(Json(columns, JsonRequestBehavior.AllowGet));
}
public JsonResult ApiGetDevice(string list = "0")
{
List <SelectOption> _select = new List <SelectOption>();
if (list == null || list == "" || list == "0")
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
IEnumerable <IODeviceModel> Items = IO_DeviceServer.GetByWhere(" where IO_DEVICE_ID in('" + list.Replace(",", "','") + "')");
if (Items != null && Items.Count() > 0)
{
foreach (var item in Items)
{
IEnumerable <IOParaModel> ParaItems = IO_ParaServer.GetByWhere("where IO_DEVICE_ID='" + item.IO_DEVICE_ID + "'");
string IOPARANAMES = "";
string IOPARATITLES = "";
foreach (var para in ParaItems)
{
string label = para.IO_LABEL == "" ? para.IO_NAME : para.IO_LABEL;
IOPARANAMES += (IOPARANAMES == "" ? para.IO_NAME : "," + para.IO_NAME);
IOPARATITLES += (IOPARATITLES == "" ? label : "," + label);
}
SelectOption _option = new SelectOption
{
id = item.IO_DEVICE_ID.ToString(),
name = item.IO_DEVICE_LABLE,
value = item.IO_DEVICE_ID.ToString(),
value1 = item.IO_DEVICE_ID.ToString(),
value2 = item.IO_COMM_ID,
value3 = item.IO_SERVER_ID,
value4 = IOPARANAMES,
value5 = IOPARATITLES,
};
_select.Add(_option);
}
}
return(Json(_select, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDeviceSelect(string serverId, string communicateId)
{
List <SelectOption> _select = new List <SelectOption>();
IEnumerable <IODeviceModel> deviceList = IO_DeviceServer.GetAll("IO_DEVICE_ID,IO_COMM_ID,IO_SERVER_ID,IO_DEVICE_NAME,IO_DEVICE_LABLE ", "").Where(x => x.IO_SERVER_ID == serverId && x.IO_COMM_ID == communicateId);
if (deviceList != null && deviceList.Count() > 0)
{
foreach (var device in deviceList)
{
SelectOption _option = new SelectOption
{
id = device.IO_DEVICE_ID,
name = device.IO_DEVICE_NAME + "[" + device.IO_DEVICE_LABLE + "]",
};
_select.Add(_option);
}
}
return(Json(_select, JsonRequestBehavior.AllowGet));
}
