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