public ActionResult Query()
{
string patname = Request["name"];
string patsex = Request["sex"];
string date = Request["date"];
string diagnosisresult = Request["diagnosis"];
List<string> query = new List<string>();
query.Add(patname);
query.Add(patsex);
query.Add(date);
query.Add(diagnosisresult);
VisitDataOperation visitop = new VisitDataOperation();
List<PatBasicInfor> pts = visitop.GetPat(query);
return PartialView("PatList", pts);
}
public ActionResult Query()
{
string patname = Request["name"];
string patsex = Request["sex"];
string date = Request["date"];
string diagnosisresult = Request["diagnosis"];
string user = HttpContext.Request.Cookies["username"].Value.ToString();
List<string> query = new List<string>();
query.Add(patname);
query.Add(patsex);
query.Add(date);
query.Add(diagnosisresult);
query.Add(user);
VisitDataOperation visitop = new VisitDataOperation();
List<mPatInfo> pts = visitop.GetPat(query);
return PartialView("PatList", pts);
}
public ActionResult Index(PatBasicInfor pat)
{
PatOperation pto = new PatOperation();
string PID = Request.Form["门诊号"];
if (string.IsNullOrEmpty(pat.Name) || string.IsNullOrEmpty(pat.Sex) || string.IsNullOrEmpty(pat.Age) || string.IsNullOrEmpty(pat.Phone))
{
ModelState.AddModelError("", "带*的输入项不能为空");
}
else
{
Regex reg = new Regex("^[0-9]+$");
Match ma1 = reg.Match(pat.Age);
Match ma2 = reg.Match(pat.Phone);
if (ma1.Success && ma2.Success)
{
}
else
{
ModelState.AddModelError("", "手机和年龄必须为数字");
}
}
if (ModelState.IsValid)
{
string user;
user = HttpContext.Request.Cookies["username"].Value.ToString();
//pto.InsertPat(pat, PID, user);
VisitDataOperation vr = new VisitDataOperation();
mPatInfo p =new mPatInfo();
p.Name=pat.Name;
p.Sex=pat.Sex;
p.Age=pat.Age;
p.Phone=pat.Phone;
p.Address = pat.Address;
p.Education = pat.Education;
p.Height = pat.Height;
p.Weight = pat.Weight;
p.Job = pat.Job;
string pid=vr.InsertPat(p,user);
return RedirectToAction("Index", "Diagnosis", new { ID = pid});
}
else
{
return View();
}
}
//2014530
public bool DeletePat(string PatID)
{
try
{
var patient = from p in context.PatBasicInforSet.ToList()
where (p.Id == PatID)
select p;
PatBasicInfor ptfor = patient.First();
VisitDataOperation visitop = new VisitDataOperation();
//删除viewrecord
if (ptfor.VisitRecord.Count != 0)
{
var vr = from v in context.VisitRecordSet.ToList() where (v.PatBasicInforId == PatID) select v;
foreach (var r in vr)
{
//不能调用 VisitDataOperation的删除就诊记录方法，因为两次savechange 操作会让删除病人时报“存储区更新、插入或删除语句影响到了意外的行数(0)。实体在加载后可能被修改或删除。刷新 ObjectStateManager 项。”错误
/* var recordId = r.Id.ToString();
* visitop.DeleteRecord(PatID, recordId);
*/
if (r.PrimaryHeadachaOverView != null)
{
while (r.PrimaryHeadachaOverView.HeadachePlace.Count != 0)
{
context.HeadachePlaceSet.Remove(r.PrimaryHeadachaOverView.HeadachePlace.First());
}
while (r.PrimaryHeadachaOverView.HeadacheAccompany.Count != 0)
{
context.HeadacheAccompanySet.Remove(r.PrimaryHeadachaOverView.HeadacheAccompany.First());
}
while (r.PrimaryHeadachaOverView.HeadacheProdrome.Count != 0)
{
context.HeadacheProdromeSet.Remove(r.PrimaryHeadachaOverView.HeadacheProdrome.First());
}
while (r.PrimaryHeadachaOverView.PrecipitatingFactor.Count != 0)
{
context.PrecipitatingFactorSet.Remove(r.PrimaryHeadachaOverView.PrecipitatingFactor.First());
}
while (r.PrimaryHeadachaOverView.MitigatingFactors.Count != 0)
{
context.MitigatingFactorsSet.Remove(r.PrimaryHeadachaOverView.MitigatingFactors.First());
}
while (r.PrimaryHeadachaOverView.PremonitorySymptom.Count != 0)
{
context.PremonitorySymptom集.Remove(r.PrimaryHeadachaOverView.PremonitorySymptom.First());
}
context.PrimaryHeadacheOverViewSet.Remove(r.PrimaryHeadachaOverView);
}
while (r.MedicationAdvice.Count != 0)
{
context.MedicationAdviceSet.Remove(r.MedicationAdvice.FirstOrDefault());
}
while (r.SecondaryHeadacheSymptom.Count != 0)
{
context.SecondaryHeadacheSymptomSet.Remove(r.SecondaryHeadacheSymptom.FirstOrDefault());
}
//add 2013/7/23
if (r.GADQuestionaire != null)
{
context.GADQuestionaireSet.Remove(r.GADQuestionaire);
}
if (r.GADQuestionaire != null)
{
context.GADQuestionaireSet.Remove(r.GADQuestionaire);
}
if (r.PHQuestionaire != null)
{
context.PHQuestionaireSet.Remove(r.PHQuestionaire);
}
if (r.SleepStatus != null)
{
context.SleepStatusSet.Remove(r.SleepStatus);
}
if (r.DisabilityEvaluation != null)
{
context.DisabilityEvaluationSet.Remove(r.DisabilityEvaluation);
}
// visitrecord 内容删除
context.VisitRecordSet.Remove(r);
}
}
//头痛日志
while (ptfor.HeadacheDiary.Count() != 0)
{
context.HeadacheDiarySet.Remove(ptfor.HeadacheDiary.First());
}
//删除患有头痛家族成员
while (ptfor.HeadacheFamilyMember.Count != 0)
{
context.HeadacheFamilyMemberSet.Remove(ptfor.HeadacheFamilyMember.First());
}
while (ptfor.Lifestyle != null)
{
context.LifestyleSet.Remove(ptfor.Lifestyle);//是不是一对一的删不了？
//context.Entry(ptfor.Lifestyle).State = System.Data.EntityState.Deleted;
}
while (ptfor.OtherFamilyDisease.Count != 0)
{
context.OtherFamilyDiseaseSet.Remove(ptfor.OtherFamilyDisease.First());
}
while (ptfor.PreviousDrug.Count != 0)
{
context.PreviousDrugSet.Remove(ptfor.PreviousDrug.First());
}
while (ptfor.PreviousExam.Count != 0)
{
context.PreviousExamSet.Remove(ptfor.PreviousExam.First());
}
//医生推送建议表
while (ptfor.DocSuggestionSet.Count != 0)
{
context.DocSuggestionSet.Remove(ptfor.DocSuggestionSet.First());
}
context.PatBasicInforSet.Remove(ptfor);
//context.Entry(ptfor).State = System.Data.EntityState.Deleted;
context.SaveChanges();
return(true);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
return(false);
}
}
