public IHttpActionResult Patch([FromODataUri] string key, Delta <NURSE_THERMOMETEREntity> patch)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
object id;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
else if (patch.GetChangedPropertyNames().Contains("ID") && patch.TryGetPropertyValue("ID", out id) && (string)id != key)
{
return(BadRequest("The key from the url must match the key of the entity in the body"));
}
try
{
var query = service.GetEntity(key);
patch.Patch(query);
service.UpdateEntity(query);
return(Updated(query));
}
catch (Exception)
{
return(NotFound());
}
}
public object Temperature_Integralentry(string wardcode, string measurement_datetime, string sortBy, string sortType)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var tempdata = service.Temperature_Integralentry(wardcode, measurement_datetime, sortBy, sortType, PersonType.Normal);
return(tempdata);
}
public object TemperatureChartEdit()
{
var draw = HttpContext.Current.Request.Form["draw"];
var patientid = HttpContext.Current.Request.Form["patientid"];
var edittime = HttpContext.Current.Request.Form["edittime"];
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var tempdata = service.SearchByPtIdAndEdTime(patientid, edittime);
// return new ResultObject(false, null);
List <string[]> arrs = new List <string[]>();
foreach (DataRow row in tempdata.Tables["thermometer_record"].Rows)
{
arrs.Add(new string[] {
row["MEASUREMENT_TIME"].ToString(),
row["TEMPERATURE"].ToString(),
row["PULSE"].ToString(),
row["BREATHING"].ToString(),
row["BLOOD_PRESSURE_1"].ToString() + "/" + row["BLOOD_PRESSURE_2"].ToString(),
row["OXYGEN_SATURATION"].ToString(),
row["TYPE_MEASUREMENT"].ToString(),
row["SUPPLEMENTARY_DESCRIPTION"].ToString(),
string.Format("<a href='javascript:TemperatureRecord(\"{0}\");'>{1}</a><a href='javascript:DeleteRecord(\"{0}\");'>{2}</a><a href='#tab3' data-toggle='tab' id='nav3'>{3}</a>"
, row["ID"].ToString(), "编辑", "删除", "导入")
});
}
long count = 0;
return(Json(new TableObject(arrs, int.Parse(draw), count, count)));
}
public ResultObject TemperatureBatchSave(Rootobject rootobject)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var isok = service.TemperatureBatchSave(rootobject.list.list_twd, rootobject.list.list_twjl);
return(new ResultObject(isok, null));
}
public ResultObject GetPtInfo(string patientId)
{
try
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
DataTable tb = service.SearchPtInfoByID(patientId);
return(new ResultObject(true, tb));
}
catch (Exception)
{
return(new ResultObject(false, null));
}
}
public object ThermometerSqueueID(string patientid, string edtime)
{
try
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var tempdata = service.SearchByThermometerSqueueID(patientid, edtime);
return(new ResultObject(true, tempdata));
}
catch (Exception ex)
{
return(new ResultObject(false, null));
}
}
public object TemperatureDataByPtIdAndEdTime(string patientid, string edtime)
{
try
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var tempdata = service.SearchByPtIdAndEdTime(patientid, edtime);
return(new ResultObject(true, tempdata.Tables[0]));
}
catch (Exception ex)
{
return(new ResultObject(false, null));
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public IHttpActionResult Delete([FromODataUri] string key)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
try
{
service.PhysicalDelRecord(key);
return(Ok(true));
}
catch (Exception)
{
return(Ok(false));
}
}
public object TemperatureRecordData(string ID)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var tempdata = service.SearchByID(ID);
try
{
//return Json(tempdata);
return(new ResultObject(true, tempdata));
}
catch (Exception ex)
{
return(new ResultObject(false, null));
}
}
public IHttpActionResult RecordPagination(Pagination pagination)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
try
{
var query = service.RecordPagination(pagination);
var packageEntity = query.PackageEntityPaginations(pagination);
return(Json(packageEntity));
}
catch (Exception)
{
PackageResultEntity <object> packageResultEntity = new PackageResultEntity <object>()
{
list = null,
msg = "failed"
};
return(Json(packageResultEntity));
}
}
public IHttpActionResult RecordQuery(string key)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
try
{
var query = service.GetEntity(key);
var packageEntity = query.PackageResult();
return(Json(packageEntity));
}
catch (Exception)
{
PackageResultEntity <object> packageResultEntity = new PackageResultEntity <object>()
{
list = null,
msg = "failed"
};
return(Json(packageResultEntity));
}
}
public IHttpActionResult Get(ODataQueryOptions <NURSE_THERMOMETEREntity> odataQueryOptions)
{
Expression <Func <NURSE_THERMOMETEREntity, bool> > myfilter = null;
if (odataQueryOptions.Filter != null)
{
myfilter = odataQueryOptions.Filter.ToExpression <NURSE_THERMOMETEREntity>();
}
try
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
var expression = LinqExtensions.True <NURSE_THERMOMETEREntity>();
if (myfilter != null)
{
expression = expression.And(myfilter);
}
var query = service.IQueryRecord(expression).ToList();
return(Ok(query.AsQueryable()));
}
catch (Exception)
{
return(NotFound());
}
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="model"></param>
public void Post(NURSE_THERMOMETEREntity model)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
service.SaveEntity(model.ID, model);
}
/// <summary>
/// 更新数据，幂等
/// </summary>
/// <param name="key"></param>
/// <param name="model"></param>
public void Put([FromODataUri] string key, NURSE_THERMOMETEREntity model)
{
NURSE_THERMOMETERService service = new NURSE_THERMOMETERService();
service.UpdateEntity(model);
}
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
{
}
}