public List <int> GetZtslCount()
{
List <string> strlist = new List <string>();
List <int> intlist = new List <int>();
using (Entities db = new Entities())
{
string rootsql = string.Format(@"select fi.unitname as text,fi.unitid,fi.path,fi.seq as id ,fi.parentid
from fi_specialunits fi where fi.parentid=0 order by fi.seq ");
List <FI_CameraUnitsTreeModel> treelist = db.Database.SqlQuery <FI_CameraUnitsTreeModel>(rootsql).Skip(0).Take(6).ToList();
string rootid = "0";
for (int i = 0; i < treelist.Count; i++)
{
int num = 0;
FI_CameraUnitsTreeModel model = treelist[i];
if (model != null)
{
rootid = model.id;
string childsql = string.Format(@"select fi.unitname as text,fi.unitid,fi.path,fi.seq as id ,fi.parentid from fi_specialunits fi where fi.parentid!=0 and fi.parentid={0} order by fi.parentid", rootid);
List <FI_CameraUnitsTreeModel> childList = db.Database.SqlQuery <FI_CameraUnitsTreeModel>(childsql).ToList();
foreach (FI_CameraUnitsTreeModel item in childList)
{
num = num + GetMonitoreTreeChildList(item.unitid).Count();
}
strlist.Add(treelist[i].text);
intlist.Add(num);
}
}
}
string str = JsonConvert.SerializeObject(strlist).ToString() + "|" + JsonConvert.SerializeObject(intlist).ToString();
return(intlist);
}
public List <FI_CameraUnitsTreeModel> GetMonitoreTreeList()
{
using (Entities db = new Entities())
{
string rootsql = string.Format(@"select fi.unitname as text,fi.unitid,fi.path,fi.seq as id ,fi.parentid
from fi_specialunits fi where fi.parentid=0 order by fi.seq ");
List <FI_CameraUnitsTreeModel> treelist = db.Database.SqlQuery <FI_CameraUnitsTreeModel>(rootsql).ToList();
string rootid = "0";
string childsql = "";
TreeMonitorModel root = new TreeMonitorModel();
string rosql = @"select fi.unitname as text,fi.unitid,fi.path,fi.seq as id ,fi.parentid from fi_specialunits fi where fi.parentid is null";
List <FI_CameraUnitsTreeModel> rootList = db.Database.SqlQuery <FI_CameraUnitsTreeModel>(rosql).ToList();
for (int i = 0; i < treelist.Count; i++)
{
FI_CameraUnitsTreeModel model = treelist[i];
if (model != null)
{
rootid = model.id;
childsql = string.Format(@"select fi.unitname as text,fi.unitid,fi.path,fi.seq as id ,fi.parentid from fi_specialunits fi where fi.parentid!=0 and fi.parentid={0} order by fi.parentid", rootid);
List <FI_CameraUnitsTreeModel> childList = db.Database.SqlQuery <FI_CameraUnitsTreeModel>(childsql).ToList();
foreach (FI_CameraUnitsTreeModel item in childList)
{
item.nodes = GetMonitoreTreeChildList(item.unitid);
item.leaf = true;
item.text = item.text;
}
model.nodes = childList;
model.expanded = true;
model.leaf = false;
if (childList.Count == 0)
{
model.leaf = true;
}
}
}
if (rootList.Count > 0)
{
rootList[0].leaf = treelist.Count > 0 ? false : true;
rootList[0].expanded = true;
rootList[0].nodes = treelist;
}
return(rootList);
}
}
/// <summary>
/// 前台监控书列表
/// </summary>
/// <param name="filters"></param>
/// <returns></returns>
public List <FI_CameraUnitsTreeModel> GetTreeMonitorApi(List <Filter> filters)
{
//查询根节点
List <FI_CameraUnitsTreeModel> dataList = dal.GetTreeMonitor(filters)
.Select(a => new FI_CameraUnitsTreeModel
{
text = a.text,
parentid = a.parentid,
id = a.id,
path = a.path,
}).ToList();
List <FI_CameraUnitsTreeModel> dataListChildren = dal.GetTreeMonitorChildren(null)
.Select(a => new FI_CameraUnitsTreeModel
{
text = a.text,
parentid = a.parentid,
id = a.id,
path = a.path,
}).ToList();
List <FI_CameraUnitsTreeModel> list = new List <FI_CameraUnitsTreeModel>();
if (dataList.Count > 0)
{
for (int i = 0; i < dataList.Count; i++)
{
FI_CameraUnitsTreeModel item = dataList[i];
if (item.parentid == null)
{
item = GetUnitChildren(dataListChildren, item, null);
list.Add(item);
}
}
}
return(list);
}
private FI_CameraUnitsTreeModel GetUnitChildren(List <FI_CameraUnitsTreeModel> dataList, FI_CameraUnitsTreeModel item, List <Filter> filters)
{
List <FI_CameraUnitsTreeModel> list = new List <FI_CameraUnitsTreeModel>();
for (int i = 0; i < dataList.Count; i++)
{
FI_CameraUnitsTreeModel childrenItem = dataList[i];
if (childrenItem.parentid != null && childrenItem.parentid == item.id)
{
var cameras = camerasdal.GetCameras(childrenItem.id, filters);
childrenItem = GetUnitChildren(dataList, childrenItem, filters);
foreach (var cam in cameras)
{
childrenItem.nodes.Add(cam);
childrenItem.children = childrenItem.nodes;
}
list.Add(childrenItem);
}
}
item.nodes = list;
item.children = item.nodes;
return(item);
}
