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);
return(RedirectToAction("Index", "Diagnosis", new { ID = pat.Id }));
}
else
{
return(View());
}
}
public ActionResult Query()
{
string patname = Request["name"];
string patsex = Request["sex"];
string date = Request["date"];
string diagnosisresult = Request["diagnosis"];
string docID = HttpContext.Request.Cookies["userID"].Value.ToString();
var allpats = from s in DataContainer.PatBasicInforSet.ToList() select s;
var allvisitRecord = from s in DataContainer.VisitRecordSet.ToList() select s;
var patlist = allpats.Where(p => docID == p.DoctorAccountId.ToString()).ToList();
var recordPats = from ps in patlist
from r in allvisitRecord.Where(r => (r.PatBasicInforId == ps.Id)) select ps;
var noRecordPats = patlist.Except(recordPats);
var patinfoList = (from ps in patlist.Where(p => (string.IsNullOrEmpty(patname) ? true : p.Name == patname) && (string.IsNullOrEmpty(patsex) ? true : p.Sex == patsex))
from r in allvisitRecord.Where(r => (r.PatBasicInforId == ps.Id) &&
(string.IsNullOrEmpty(diagnosisresult) ? true : (r.DiagnosisResult1.Contains(diagnosisresult) || r.DiagnosisResult2.Contains(diagnosisresult) || r.DiagnosisResult3.Contains(diagnosisresult))) &&
(string.IsNullOrEmpty(date) ? true : r.VisitDate.Date == DateTime.Parse(date)))
select new
{
Name = ps.Name,
Sex = ps.Sex,
Age = ps.Age,
Date = r.VisitDate,
Id = ps.Id
}).OrderByDescending(x => x.Date).DistinctBy(x => x.Id).ToList();
List <PatBasicInfor> pts = new List <PatBasicInfor>();
foreach (var pat in patinfoList)
{
PatBasicInfor pb = new PatBasicInfor();
pb.Id = pat.Id;
pb.Name = pat.Name;
pb.Sex = pat.Sex;
pb.Age = pat.Age;
pts.Add(pb);
}
if (string.IsNullOrEmpty(diagnosisresult) && string.IsNullOrEmpty(date))
{
var patinfoList2 = (from ps in noRecordPats.Where(p => (string.IsNullOrEmpty(patname) ? true : p.Name == patname) && (string.IsNullOrEmpty(patsex) ? true : p.Sex == patsex))
select new
{
Name = ps.Name,
Sex = ps.Sex,
Age = ps.Age,
Id = ps.Id
}).DistinctBy(x => x.Id).ToList();
foreach (var pat in patinfoList2)
{
PatBasicInfor pb = new PatBasicInfor();
pb.Id = pat.Id;
pb.Name = pat.Name;
pb.Sex = pat.Sex;
pb.Age = pat.Age;
pts.Add(pb);
}
}
/* 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<PatBasicInfor> pts = visitop.GetPatforDoc(query);*/
return(PartialView("PatList", pts));
}