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)); }