/// <summary>
/// 用户绑定烟感器列表
/// </summary>
/// <param name="clientSysNo"></param>
/// <returns></returns>
public static QueryResult <QR_SmokeDetector> LoadUserSmokeDeletetorList(QF_UserDetector filter)
{
DataCommand cmd = new DataCommand("LoadUserSmokeDeletetorList");
switch (filter.Status)
{
case UISmokeDetectorStatus.FireWarning:
cmd.QuerySetCondition(" AND sd.Status IN (99,100)");
break;
case UISmokeDetectorStatus.LowPowerWarning:
cmd.QuerySetCondition(" AND sd.Status IN (90)");
break;
case UISmokeDetectorStatus.OffLine:
cmd.QuerySetCondition(" AND sd.Status IN (78,79,80)");
break;
case UISmokeDetectorStatus.Online:
cmd.QuerySetCondition(" AND sd.Status IN (0,1,2,3,4,5,6,7,8,90,99,100)");
break;
}
cmd.QuerySetCondition("c.ClientSysNo", ConditionOperation.Equal, DbType.Int32, filter.ClientSysNo);
return(cmd.Query <QR_SmokeDetector>(filter, "sd.Status DESC, sd.InDate DESC"));
}
public ActionResult QueryDeviceList(int pageIndex, UISmokeDetectorStatus?uiStatus)
{
QueryResult <QR_SmokeDetector> list = new QueryResult <QR_SmokeDetector>();
if (curentUser.UserType == UserType.Installer)
{
QF_SmokeDetector filter = new QF_SmokeDetector();
filter.InstallerSysNo = curentUser.ManagerSysNo.Value;
filter.Status = uiStatus;
filter.PageIndex = pageIndex;
filter.PageSize = 10;
filter.SortFields = "status desc,InstalledTime desc";
list = SmokeDetectorServices.QuerySmokeDetectorList(filter);
}
else
{
QF_UserDetector filter = new QF_UserDetector();
filter.PageIndex = pageIndex;
filter.PageSize = 10;
filter.ClientSysNo = curentUser.UserSysNo;
filter.Status = uiStatus;
list = SmokeDetectorServices.LoadUserSmokeDeletetorList(filter);
}
return(PartialView("~/Views/Smoke/_DeviceItem.cshtml", list.data));
}
public ActionResult DeviceList(UISmokeDetectorStatus?uiStatus)
{
ViewBag.status = uiStatus;
DeviceListModel model = new DeviceListModel();
if (curentUser.UserType == UserType.Installer)
{
QF_SmokeDetector filter = new QF_SmokeDetector();
filter.InstallerSysNo = curentUser.ManagerSysNo.Value;
filter.Status = uiStatus;
filter.PageIndex = 0;
filter.PageSize = 10;
filter.SortFields = "InstalledTime desc";
var allsmks = SmokeDetectorServices.LoadSmokeDetectorsByInstaller(curentUser.ManagerSysNo.Value).Where(e => e.Status != SmokeDetectorStatus.Delete).ToList();
model.CountInfo = new SmokeDetectorCount
{
ALLSmokeCount = allsmks.Count,
OfflineCount = (allsmks.Where(e => e.UIStatus == UISmokeDetectorStatus.OffLine) ?? new List <SmokeDetector>()).Count(),
OnlineCount = (allsmks.Where(e => e.UIStatus == UISmokeDetectorStatus.Online) ?? new List <SmokeDetector>()).Count(),
LowPowerCount = (allsmks.Where(e => e.UIStatus == UISmokeDetectorStatus.LowPowerWarning) ?? new List <SmokeDetector>()).Count(),
WarningCount = (allsmks.Where(e => e.UIStatus == UISmokeDetectorStatus.FireWarning) ?? new List <SmokeDetector>()).Count(),
};
//model.CountInfo.OnlineCount = model.CountInfo.ALLSmokeCount - model.CountInfo.OfflineCount;
var result = SmokeDetectorServices.QuerySmokeDetectorList(filter);
model.DeviceList = new QueryResult <QR_SmokeDetector>();
model.DeviceList = result;
}
else
{
QF_UserDetector filter = new QF_UserDetector();
filter.PageIndex = 0;
filter.PageSize = 10;
filter.Status = uiStatus;
filter.ClientSysNo = curentUser.UserSysNo;
model.CountInfo = SmokeDetectorServices.LoadUserSmokeDetectorCount(curentUser.UserSysNo);
QueryResult <QR_SmokeDetector> list = SmokeDetectorServices.LoadUserSmokeDeletetorList(filter);
model.DeviceList = new QueryResult <QR_SmokeDetector>();
model.DeviceList = list;
}
ViewBag.UserType = curentUser.UserType;
return(View(model));
}
/// <summary>
/// 用户绑定烟感器列表
/// </summary>
/// <param name="clientSysNo"></param>
/// <returns></returns>
public static QueryResult <QR_SmokeDetector> LoadUserSmokeDeletetorList(QF_UserDetector filter)
{
return(SmokeDetectorDA.LoadUserSmokeDeletetorList(filter));
}
