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 ExportSmokeDeviceList(string exportType)
{
QF_SmokeDetector filter = JsonConvert.DeserializeObject <QF_SmokeDetector>(this.Request["data"]);
if (filter.CompanySysNo <= 0)
{
if (CurrUser.CompanySysNo > 0)
{
filter.CompanySysNo = CurrUser.CompanySysNo;
}
}
// 1=导出当页，2=导出全部,默认导出当前页
if (exportType == "2")
{
filter.PageIndex = 0;
filter.PageSize = 10000;
}
QueryResult <QR_SmokeDetector> result = SmokeDetectorServices.QuerySmokeDetectorList(filter);
ExcelFileExporter <QR_SmokeDetector> exporter = new ExcelFileExporter <QR_SmokeDetector>();
List <ColumnSetting <QR_SmokeDetector> > columnSettings = new List <ColumnSetting <QR_SmokeDetector> >();
columnSettings.Add(new ColumnSetting <QR_SmokeDetector>()
{
ColumnName = "设备编号", PropertyName = "Code"
});
columnSettings.Add(new ColumnSetting <QR_SmokeDetector>()
{
ColumnName = "设备状态", PropertyName = "UIStatusStr"
});
columnSettings.Add(new ColumnSetting <QR_SmokeDetector>()
{
ColumnName = "位置", PropertyName = "PositionAddress"
});
columnSettings.Add(new ColumnSetting <QR_SmokeDetector>()
{
ColumnName = "ONENET平台编号", PropertyName = "DeviceID"
});
columnSettings.Add(new ColumnSetting <QR_SmokeDetector>()
{
ColumnName = "安装人员", PropertyName = "InstallerName"
});
columnSettings.Add(new ColumnSetting <QR_SmokeDetector>()
{
ColumnName = "绑定客户", PropertyName = "ClientName"
});
columnSettings.Add(new ColumnSetting <QR_SmokeDetector>()
{
ColumnName = "安装时间", PropertyName = "InDateStr"
});
string fileName = exporter.Export(result.data, columnSettings, "烟感设备列表");
fileName = Url.Content(ExcelFileExporterHelper.GetExportFileUrl(fileName));
return(Content(fileName));
}
//public ActionResult InstallSmokedetectorList()
//{
// return View();
//}
public JsonResult QueryInstallList()
{
QF_SmokeDetector filter = JsonConvert.DeserializeObject <QF_SmokeDetector>(this.Request["data"]);
filter.InstallerSysNo = curentUser.UserSysNo;// curentUser.UserSysNo;
filter.PageSize = 7;
filter.SortFields = "InstalledTime desc";
var result = SmokeDetectorServices.QuerySmokeDetectorList(filter);
return(Json(new AjaxResult {
Success = true, Data = result
}));
}
/// <summary>
/// 查询客户烟感器设备列表
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public static QueryResult <QR_SmokeDetector> QuerySmokeDetectorList(QF_SmokeDetector filter)
{
DataCommand cmd = new DataCommand("QuerySmokeDetectorList");
if (filter.Status.HasValue)
{
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;
}
}
string clientWhere = "";
string clientJoin = "LEFT JOIN";
if (!string.IsNullOrWhiteSpace(filter.ClientName))
{
clientWhere = "WHERE c.Name like '%" + cmd.SetSafeParameter(filter.ClientName) + "%'";
clientJoin = "INNER JOIN";
}
cmd.CommandText = cmd.CommandText.Replace("#CLINETSTRWHERE#", clientWhere).Replace("#CLINETJOIN# ", clientJoin);
cmd.QuerySetCondition("sd.Status", ConditionOperation.NotEqual, DbType.Int32, -999);
if (filter.CompanySysNo.HasValue && filter.CompanySysNo.Value > 0)
{
cmd.QuerySetCondition("sd.CompanySysNo", ConditionOperation.Equal, DbType.Int32, filter.CompanySysNo.Value);
}
cmd.QuerySetCondition("sd.InstallerSysNo", ConditionOperation.In, DbType.Int32, filter.InstallSysNos);
cmd.QuerySetCondition("sd.Code", ConditionOperation.Like, DbType.String, filter.Code);
cmd.QuerySetCondition("sd.DeviceID", ConditionOperation.Like, DbType.String, filter.DeviceID);
cmd.QuerySetCondition("sd.AddressCode", ConditionOperation.LikeLeft, DbType.String, filter.AddressCode);
cmd.QuerySetCondition("sd.InstallerSysNo", ConditionOperation.Equal, DbType.Int32, filter.InstallerSysNo);
QueryResult <QR_SmokeDetector> result = cmd.Query <QR_SmokeDetector>(filter, "sd.SysNo DESC ");
return(result);
}
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));
}
public ActionResult QuerySmoke()
{
//CreateDeviceRequest request = new CreateDeviceRequest()
//{
// Desc = "创建测试设备描述",
// IMei = "1354789845",
// IMsi = "1354789845",
// IsOnLine = 1,
// LocationEle = 0,
// LocationLat = 0,
// LocationLon = 0,
// Observe = 1,
// Protocol = "LWM2M",
// Tags = "1354789845,147890123331",
// Title = "创建测试设备名称"
//};
//CreateDeviceResponse create = ONENETService.CreateDevice(request);
//if (create != null && !string.IsNullOrEmpty(create.DeviceId) && create.IsSuccess)
//{
// UpdateDeviceRequest upRequest = new UpdateDeviceRequest()
// {
// Desc = "更新测试设备描述",
// IMei = "1364789845",
// IMsi = "1364789845",
// IsOnLine = 1,
// LocationEle = 1,
// LocationLat = 2,
// LocationLon = 3,
// Observe = 1,
// Protocol = "LWM2M",
// Tags = "1364789845,1364789845",
// Title = "更新测试设备名称",
// DeviceID = create.DeviceId
// };
// UpdateDeviceResponse upResponse = ONENETService.UpdateDevice(upRequest);
// if (upResponse != null && !string.IsNullOrEmpty(upResponse.DeviceId) && upResponse.IsSuccess)
// {
// SendCmdRequest send = new SendCmdRequest()
// {
// StrCmd = "008013870005013D58FF",
// DeviceID = create.DeviceId
// };
// SendCmdResponse sendRes = ONENETService.SendCmd(send);
// if (sendRes != null && !string.IsNullOrEmpty(sendRes.DeviceId) && sendRes.IsSuccess)
// {
// DeleteDeviceRequest delete = new DeleteDeviceRequest()
// {
// DeviceID = sendRes.DeviceId
// };
// DeleteDviceResponse deleteRes = ONENETService.DeleteDevice(delete);
// }
// }
//}
QF_SmokeDetector filter = BuildQueryFilterEntity <QF_SmokeDetector>();
if (CurrUser.CompanySysNo > 0)
{
filter.CompanySysNo = CurrUser.CompanySysNo;
}
var result = SmokeDetectorServices.QuerySmokeDetectorList(filter);
return(AjaxGridJson(result));
}
/// <summary>
/// 查询客户烟感器设备列表
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public static QueryResult <QR_SmokeDetector> QuerySmokeDetectorList(QF_SmokeDetector filter)
{
return(SmokeDetectorDA.QuerySmokeDetectorList(filter));
}
