public ItemSecond(RescueRoomTreatmentRecord target)
{
this.ProductCode = target.ProductCode;
this.ProductName = target.ProductName;
this.GoodsName = target.GoodsName;
this.DosageQuantity = target.DosageQuantity;
this.DosageUnit = target.DosageUnit;
this.PrescriptionTime = target.PrescriptionTime;
this.Usage = target.Usage;
}
/// <summary>
/// 刷新。
/// </summary>
/// <param name="rescueRoomInfoId">归属的抢救室病例ID。</param>
public ActionResult Refresh(Guid rescueRoomInfoId)
{
var db = new EiSDbContext();
var dbTrasen = new TrasenDbContext("TrasenConnection");
var target = db.RescueRoomInfos.Find(rescueRoomInfoId);
if (target == null)
{
return(HttpNotFound());
}
//设置时段起点、结点
DateTime?timeUpperBound;
DateTime?timeLowerBound;
{
timeUpperBound = target.ReceiveTime;
var itemJZJL = dbTrasen.MZYS_JZJL.Where(c => c.JZID == target.JZID).FirstOrDefault();
timeLowerBound = itemJZJL.WCSJ;
}
//==获取指定GHXXID的“处方表”记录。==
var queryCFB = dbTrasen.VI_MZ_CFB.Where(c => c.GHXXID == target.GHXXID);
//设置时段起点
queryCFB = queryCFB.Where(c => timeUpperBound <= c.SFRQ);
//设置时段结点
if (timeLowerBound.HasValue)
{
queryCFB = queryCFB.Where(c => c.SFRQ <= timeLowerBound.Value);//该结点边界特殊，使用闭区间——结束的瞬间可能同时有医嘱。
}
var listCFB = queryCFB.ToList();
foreach (var itemCFB in listCFB)
{
//获取指定CFID的“处方表明细”记录。
var queryCFBMX = dbTrasen.VI_MZ_CFB_MX.Where(c => c.CFID == itemCFB.CFID);
var listCFBMX = queryCFBMX.ToList();
foreach (var itemCFBMX in listCFBMX)
{
if (db.RescueRoomTreatmentRecordDefinitions.Any(c => c.TreatmentCode == itemCFBMX.BM))
{
var rescueRoomTreatmentRecord = db.RescueRoomTreatmentRecords.Where(c => c.CFMXID == itemCFBMX.CFMXID).FirstOrDefault();
if (rescueRoomTreatmentRecord == null)
{
rescueRoomTreatmentRecord = new RescueRoomTreatmentRecord();
rescueRoomTreatmentRecord.RescueRoomTreatmentRecordId = Guid.NewGuid();
rescueRoomTreatmentRecord.RescueRoomInfoId = target.RescueRoomInfoId;
rescueRoomTreatmentRecord.ProductCode = itemCFBMX.BM;
rescueRoomTreatmentRecord.ProductName = itemCFBMX.PM;
rescueRoomTreatmentRecord.GoodsName = itemCFBMX.SPM;
rescueRoomTreatmentRecord.DosageQuantity = itemCFBMX.YL;
rescueRoomTreatmentRecord.DosageUnit = itemCFBMX.YLDW;
rescueRoomTreatmentRecord.PrescriptionTime = itemCFB.SFRQ;
rescueRoomTreatmentRecord.Usage = itemCFBMX.YFMC;
rescueRoomTreatmentRecord.CFMXID = itemCFBMX.CFMXID;
rescueRoomTreatmentRecord.CFID = itemCFBMX.CFID;
rescueRoomTreatmentRecord.UpdateTime = DateTime.Now;
db.RescueRoomTreatmentRecords.Add(rescueRoomTreatmentRecord);
db.SaveChanges();
}
else
{
rescueRoomTreatmentRecord.RescueRoomInfoId = target.RescueRoomInfoId;
rescueRoomTreatmentRecord.ProductCode = itemCFBMX.BM;
rescueRoomTreatmentRecord.ProductName = itemCFBMX.PM;
rescueRoomTreatmentRecord.GoodsName = itemCFBMX.SPM;
rescueRoomTreatmentRecord.DosageQuantity = itemCFBMX.YL;
rescueRoomTreatmentRecord.DosageUnit = itemCFBMX.YLDW;
rescueRoomTreatmentRecord.PrescriptionTime = itemCFB.SFRQ;
rescueRoomTreatmentRecord.Usage = itemCFBMX.YFMC;
rescueRoomTreatmentRecord.CFMXID = itemCFBMX.CFMXID;
rescueRoomTreatmentRecord.CFID = itemCFBMX.CFID;
db.SaveChanges();
}
}
}
}
//删除处方时间早于时段起点的治疗项
if (timeUpperBound.HasValue)
{
var listRescueRoomTreatmentRecord = db.RescueRoomTreatmentRecords.Where(c => c.RescueRoomInfoId == target.RescueRoomInfoId && c.PrescriptionTime < timeUpperBound).ToList();
db.RescueRoomTreatmentRecords.RemoveRange(listRescueRoomTreatmentRecord);
db.SaveChanges();
}
//删除处方时间超过时段结点的治疗项
if (timeLowerBound.HasValue)
{
var listRescueRoomTreatmentRecord = db.RescueRoomTreatmentRecords.Where(c => c.RescueRoomInfoId == target.RescueRoomInfoId && timeLowerBound < c.PrescriptionTime).ToList();//此处用开区间，理由同上
db.RescueRoomTreatmentRecords.RemoveRange(listRescueRoomTreatmentRecord);
db.SaveChanges();
}
//删除编码在定义外的治疗项
if (true)
{
var listRescueRoomTreatmentRecord = db.RescueRoomTreatmentRecords.ToList();
var listRescueRoomTreatmentRecordDefinition = db.RescueRoomTreatmentRecordDefinitions.Where(c => c.GreenPathCode == "Ami").ToList();
foreach (var itemRescueRoomTreatmentRecord in listRescueRoomTreatmentRecord)
{
if (!listRescueRoomTreatmentRecordDefinition.Any(c => c.TreatmentCode == itemRescueRoomTreatmentRecord.ProductCode))
{
db.RescueRoomTreatmentRecords.Remove(itemRescueRoomTreatmentRecord);
}
}
db.SaveChanges();
}
return(RedirectToAction("IndexPartial", new { rescueRoomInfoId }));
}