public NewOrderWindow() { InitializeComponent(); dt = DeviceLogic.GetDeviceList(DeviceEnum.None, ""); DeviceList.ItemsSource = dt.DefaultView; Service.ItemsSource = ServiceLogic.GetService(); }
private void FilterName_TextChanged(object sender, TextChangedEventArgs e) { try { dt.Clear(); DeviceEnum deviceEnum = DeviceEnum.None; switch (FilterItem.Text) { case "Названию": deviceEnum = DeviceEnum.Name; break; case "Модели": deviceEnum = DeviceEnum.Model; break; case "Производителю": deviceEnum = DeviceEnum.Manufacturer; break; } string FilterText = FilterName.Text; if (FilterText == "") { deviceEnum = DeviceEnum.None; } dt = DeviceLogic.GetDeviceList(deviceEnum, FilterText); DeviceList.ItemsSource = dt.DefaultView; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 分页获取设备列表 /// </summary> /// <param name="param"></param> /// <returns></returns> public JsonResult AjaxGetDeviceList(LayUIPageParam param) { LayuiPageResult <DeviceAndUser> res = new LayuiPageResult <DeviceAndUser>(); res.data = DeviceLogic.GetDeviceList(AuthUser.UserTypeId.Value, AuthUser.Id, param.page, param.limit); res.count = DeviceLogic.GetDeviceCount(AuthUser.UserTypeId.Value, AuthUser.Id); return(Json(res)); }
/// <summary> /// 监控页面的获取设备列表 /// </summary> /// <param name="pi"></param> /// <param name="pc"></param> /// <returns></returns> public JsonResult AjaxGetMonitorList(int pi, int pc) { List <DeviceAndUser> dus = DeviceLogic.GetDeviceList(AuthUser.UserTypeId.Value, AuthUser.Id, pi, pc); string deviceIds = ""; foreach (var du in dus) { deviceIds += du.APIDeviceId + ","; } deviceIds = deviceIds.TrimEnd(','); DeviceListModel list = DeviceData.GetDeviceList(deviceIds, pi, pc); DeviceListResult res = new DeviceListResult(); res.Items = new List <DeviceInfo>(); if (list.Items.Count > 0) { list.Items.ForEach(p => { DeviceAndUser du = dus.FirstOrDefault(t => t.APIDeviceId == p.Id); if (du != null) { DeviceInfo di = new DeviceInfo(); di.Id = du.DeviceId; di.APIId = du.APIDeviceId ?? 0; di.Battery = p.Battery; di.Icon = du.IconId ?? 0; di.Model = p.Model; di.IMEI = du.Imei; di.Latitude = Convert.ToDecimal(WebHelper.GetLatLngString(p.Latitude)); di.Longitude = Convert.ToDecimal(WebHelper.GetLatLngString(p.Longitude)); di.ServerUtcDate = p.ServerUtcDate.AddHours(8); di.DeviceUtcDate = p.DeviceUtcDate.AddHours(8); di.Type = p.Type; di.Sim = p.Sim; di.Status = p.Status; if (DateTime.Now.AddMinutes(-15) < di.ServerUtcDate) { di.Status = 2; } di.UserId = du.UserId; di.UserName = string.IsNullOrWhiteSpace(du.UserName) ? du.LoginName : du.UserName; di.Sex = du.Sex ?? 2; res.Items.Add(di); } }); } else { res.State = State.Falid; res.Message = list.Message; } return(Json(res)); }
public DeviceListWindow() { try { InitializeComponent(); dt = DeviceLogic.GetDeviceList(DeviceEnum.None, ""); DeviceList.ItemsSource = dt.DefaultView; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void BatchExportReport(int type, string date, string deviceIds = "") { //居民不能批量倒 if (AuthUser.UserTypeId == 4) { return; } var dAndU = DeviceLogic.GetDeviceList(AuthUser.UserTypeId.Value, AuthUser.Id, 1, 10000); if (string.IsNullOrWhiteSpace(deviceIds)) { foreach (var v in dAndU) { deviceIds += v.DeviceId + ","; } deviceIds.TrimEnd(','); } string[] strs = deviceIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); StringBuilder sHtml = new StringBuilder(); //打印表头 sHtml.Append("<table border=\"1\" width=\"90%\">"); sHtml.Append("<tr><td colspan=\"7\" style='font-size:16px;'>时间段:<b>" + date + "</b></td></tr>"); foreach (string str in strs) { int _dId = Convert.ToInt32(str); var _u = dAndU.FirstOrDefault(p => p.DeviceId == _dId); //不在名下不能倒 if (_u == null) { continue; } var _d = DeviceLogic.GetDeviceById(_dId); if (_d == null) { continue; } HealthReportModel _model = getReport(type, date, _d); sHtml.Append("<tr height=\"30\"><td colspan=\"7\" align=\"left\" style='font-size:16px;font-weight:600;'><b>" + (!string.IsNullOrWhiteSpace(_u.UserName) ? _u.UserName : "") + " 设备号:" + _u.Imei + "</b></td></tr>"); sHtml.Append(PrintReport.PrintHealtReport(_model)); } sHtml.Append("</table>"); Response.ContentType = "application/ms-excel"; Response.ContentEncoding = Encoding.UTF8; Response.Charset = "utf-8"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + AuthUser.UserName + " 管辖居民健康报表.xls"); System.IO.StringWriter tw = new System.IO.StringWriter(); // Response.Output.Write(sHtml.ToString()); Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=utf-8\"/>" + sHtml.ToString()); /*乱码BUG修改 20140505*/ //如果采用以上代码导出时出现内容乱码,可将以下所注释的代码覆盖掉上面【System.Web.HttpContext.Current.Response.Output.Write(ExcelContent.ToString());】即可实现。 //System.Web.HttpContext.Current.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=utf-8\"/>" + ExcelContent.ToString()); Response.Flush(); Response.End(); }