protected async Task OnTabChange(int index)
{
try
{
switch (index)
{
case 0:
await TemperatureChart.UpdateData();
break;
case 1:
await HumidityChart.UpdateData();
break;
case 2:
await InsolationChart.UpdateData();
break;
case 3:
await IrrigationChart.UpdateData();
break;
case 4:
await SoilMoistureChart.UpdateData();
break;
}
}
catch (Exception ex)
{
Logger.LogWarning(ex, "Failed to load weather data");
}
}
public ResultObject TemperatureChartData(string patientid, int nw)
{
try
{
#region 数据库表 thermometer、thermometer_record获取体温基础数据体温记录
//var thermometerBll = new ThermometerBll();
//获取体温单yy_nurse_thermometer和体温单记录yy_nurse_thermometer_record数据，返回Dataset和入院时间
string str_inadmittime = "";
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var tempdata = service.SearchByPatientId(patientid, nw, ref str_inadmittime);
var tb_thermometer = tempdata.Tables["thermometer"];
var tb_thermometer_record = tempdata.Tables["thermometer_record"];
#endregion
#region 转换成JSON格式体温表数据
var temperatureChart = new TemperatureChart();
#region 病人基本数据 姓名、年龄、性别、科别，床号、住院号等
System.Reflection.PropertyInfo[] properties = temperatureChart.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);
if (properties.Length <= 0)
{
return(null);
}
foreach (System.Reflection.PropertyInfo item in properties)
{
foreach (DataRow dr in tb_thermometer.Rows)
{
foreach (DataColumn dc in tb_thermometer.Columns)
{
if (dc.ColumnName.ToUpper() == item.Name.ToUpper())
{
item.SetValue(temperatureChart, dr[dc].ToString());
break;
}
}
break;
}
}
#endregion
#region 每日基本数据，入量、出量、身高、体重、小便次数、大便次数、大便方式、尿量
List <TemperatureSerieslist> temperlist = new List <TemperatureSerieslist>();
foreach (DataRow dr in tb_thermometer.Rows)
{
var serieslist = new TemperatureSerieslist();
foreach (System.Reflection.PropertyInfo item in serieslist.GetType().GetProperties())
{
foreach (DataColumn dc in tb_thermometer.Columns)
{
if (dc.ColumnName.ToUpper() == item.Name.ToUpper())
{
item.SetValue(serieslist, dr[dc].ToString());
break;
}
}
}
temperlist.Add(serieslist);
}
#endregion
#region 每日温度、脉搏心率等体温记录
List <Serieslist> serieslists = new List <Serieslist>();
//2：每日基本数据
//血压、入量、出量、身高、体重、小便次数、大便次数、大便方式、尿量
foreach (DataRow dr in tb_thermometer_record.Rows)
{
var serieslist = new Serieslist();
foreach (System.Reflection.PropertyInfo item in serieslist.GetType().GetProperties())
{
foreach (DataColumn dc in tb_thermometer_record.Columns)
{
if (dc.ColumnName.ToUpper() == item.Name.ToUpper())
{
item.SetValue(serieslist, dr[dc].ToString());
break;
}
}
}
serieslists.Add(serieslist);
}
int countTemperature = -1; //横坐标计数
int countNomal = -1; //横坐标计数
List <TemperatureSerieslist> temperatureSerieslist = new List <TemperatureSerieslist>();
//入院开始算第一周，整理每周的数据，1-7天
for (var i = (nw - 1) * 7; i < 7 * nw; i++)
{
DateTime dt_inadmittime = Convert.ToDateTime(str_inadmittime).AddDays(i);
//获取当天最新的一条记录
var temperatureSeriesLast = temperlist.Where(c => Convert.ToDateTime(c.RECORDING_TIME).ToString("yyyyMMdd").
Equals(dt_inadmittime.ToString("yyyyMMdd"))).
OrderByDescending(c => Convert.ToDateTime(c.RECORDING_TIME))
.FirstOrDefault();
if (temperatureSeriesLast != null)
{
temperatureSeriesLast.SORTINDEX = countTemperature == -1 ? 0 : countTemperature / 1440 + 1;
temperatureSerieslist.Add(temperatureSeriesLast);
}
//1分钟一刻度
for (var j = 0; j < 60 * 24; j++)
{
countTemperature++;//坐标计数
var newdatetime = new DateTime();
newdatetime = dt_inadmittime.AddMinutes(j);
var recordList = tb_thermometer_record.
AsEnumerable().
Where(c =>
c.Field <DateTime>("MEASUREMENT_TIME").ToString().
Equals(newdatetime.ToString())
).
ToList();
//3：赋值 温度坐标集合、心率脉搏坐标集合、疼痛强度
serieslists.ForEach(c =>
{
// 温度坐标集合、心率脉搏坐标集合、呼吸次数、疼痛强度、血压1、血压2
List <PlainLevels> LisPlainLevel = new List <PlainLevels>();
List <TemperatureCoordinates> Liscoordinates = new List <TemperatureCoordinates>();
List <PluseCoordinates> LispluseCoordinates = new List <PluseCoordinates>();
if (c.MEASUREMENT_TIME.Equals(newdatetime.ToString()))
{
//体温
var coordinates = new TemperatureCoordinates()
{
x = countTemperature,
y = recordList.FirstOrDefault().Field <string>("TEMPERATURE")
};
Liscoordinates.Add(coordinates);
c.temperatureCoordinates = Liscoordinates.ToArray();
//心率脉搏
var pluseCoordinates = new PluseCoordinates()
{
x = countTemperature,
y = Convert.ToString(recordList.FirstOrDefault().Field <string>("PULSE"))
};
if (pluseCoordinates.y != null)
{
LispluseCoordinates.Add(pluseCoordinates);
c.pluseCoordinates = LispluseCoordinates.ToArray();
}
//疼痛强度
var plainLevel = new PlainLevels()
{
x = countTemperature,
y = Convert.ToString(recordList.FirstOrDefault().Field <string>("PLAINLEVEL"))
};
if (plainLevel.y != null)
{
LisPlainLevel.Add(plainLevel);
c.plainLevels = LisPlainLevel.ToArray();
}
}
});
}
//1天6个刻度
for (var k = 0; k < 6; k++)
{
countNomal++;
var newdatetime = new DateTime();
if (k == 0)
{
newdatetime = dt_inadmittime.AddHours(2);
}
else
{
newdatetime = dt_inadmittime.AddHours(k * 4 + 2);
}
var recordList = tb_thermometer_record.
AsEnumerable().
Where(c =>
c.Field <DateTime>("MEASUREMENT_TIME").ToString().
Equals(newdatetime.ToString())
).
ToList();
serieslists.ForEach(c =>
{
List <Numberofbreaths> Lisbreaths = new List <Numberofbreaths>();
List <BloodPress1> LisBloodPress1 = new List <BloodPress1>();
List <BloodPress2> LisBloodPress2 = new List <BloodPress2>();
List <Spo2> LisSpo2 = new List <Spo2>();
if (c.MEASUREMENT_TIME.Equals(newdatetime.ToString()))
{
//呼吸
var numberofbreaths = new Numberofbreaths()
{
x = countNomal,
y = Convert.ToString(recordList.FirstOrDefault().Field <string>("BREATHING"))
};
if (numberofbreaths.y != null)
{
Lisbreaths.Add(numberofbreaths);
c.numberofbreaths = Lisbreaths.ToArray();
}
//血压1
var bloodpress1 = new BloodPress1()
{
x = countNomal % 2 != 0 ? countNomal - 1 : countNomal,
y = Convert.ToString(recordList.FirstOrDefault().Field <string>("BLOOD_PRESSURE_1"))
};
if (bloodpress1.y != null)
{
LisBloodPress1.Add(bloodpress1);
c.bloodPress1 = LisBloodPress1.ToArray();
}
//血压2
var bloodpress2 = new BloodPress2()
{
x = countNomal % 2 == 0 ? countNomal + 1 : countNomal,
y = Convert.ToString(recordList.FirstOrDefault().Field <string>("BLOOD_PRESSURE_2"))
};
if (bloodpress2.y != null)
{
LisBloodPress2.Add(bloodpress2);
c.bloodPress2 = LisBloodPress2.ToArray();
}
//SPO2
var Spo2 = new Spo2()
{
x = countNomal % 2 == 0 ? countNomal + 1 : countNomal,
y = Convert.ToString(recordList.FirstOrDefault().Field <string>("OXYGEN_SATURATION"))
};
if (Spo2.y != null)
{
LisSpo2.Add(Spo2);
c.spo2 = LisSpo2.ToArray();
}
}
});
}
}
#endregion
temperatureChart.temperatureSerieslists = temperatureSerieslist.ToArray();
temperatureChart.serieslists = serieslists.ToArray();
#endregion
//1：读取病人数据
return(new ResultObject(true, temperatureChart));
}
catch (Exception ex)
{
return(new ResultObject(false, null));
}
finally
{
}
}