public List <Package> GetPackageItems(String RegisterNo, int PackageID) { //0 检查科室 1 检验科室 2 功能科室 String[] Names = new String[] { "医生检查项目", "抽血及其它化验项目", "功能检查项目" }; GroupResultBusiness GroupResult = new GroupResultBusiness(); DepartmentBusiness Department = new DepartmentBusiness(); var q = from a in GroupResult.GetGroupResults(RegisterNo) join b in Department.GetDepartments() on a.DeptID equals b.DeptID group b by b.DeptKind into g select new Package { RegisterNo = RegisterNo, GroupID = Convert.ToInt32(g.Key), PackageName = Names[Convert.ToInt32(g.Key)] + g.Count() + "项" }; //return q.ToList(); //Added by pyf 2015-02-26 按23医院要求排序(化验项目 医生检查项目 功能项目) List <Package> Groups = q.ToList(); List <Package> Result = new List <Package>(); List <Package> Temps = Groups.Where(p => p.GroupID == 1).ToList(); if (Temps.Count > 0) { Result.AddRange(Temps); } Temps = Groups.Where(p => (p.GroupID == 0 || p.GroupID == 2)).ToList(); Result.AddRange(Temps); //End of added return(Result); }
/// <summary> /// 数据绑定 /// </summary> public override void DataBind() { if (txtsRegisterNo.Text.Trim() != "") { RegistrationViewEntity en = m_Regist.GetRegistration(txtsRegisterNo.Text.Trim()); if (en != null && en.IsCheckOver) { ShowMessage("此登记号已经体检完毕。"); return; } } String RegisterNo = txtsRegisterNo.Text.Trim(); ItemResultRepeater.DataSource = m_GroupResut.GetGroupResults(RegisterNo); base.DataBind(); }
public List <GroupItem> GetGroupItems(String RegisterNo, int PackageID) { ItemGroupBusiness ItemGroup = new ItemGroupBusiness(); GroupResultBusiness GroupResult = new GroupResultBusiness(); DepartmentBusiness Department = new DepartmentBusiness(); var q = from a in GroupResult.GetGroupResults(RegisterNo) join b in ItemGroup.GetItemGroups() on a.ID.GroupID equals b.GroupID join c in Department.GetDepartments() on a.DeptID equals c.DeptID select new GroupItem { RegisterNo = RegisterNo, GroupID = Convert.ToInt32(c.DeptKind), GroupName = a.GroupName, Clinical = b.Clinical, Notice = b.Notice, Price = b.Price.Value }; q = q.OrderBy(p => p.GroupID); return(q.ToList()); }