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());
}
