/// <summary>
/// 按部门编码查询
/// </summary>
/// <param name="sn"></param>
/// <returns></returns>
public ClinicarConsultation FindByDptCode(string dptCode)
{
IList <ClinicarConsultation> list = ClinicarConsultationDao.FindByHql(" and deptCode=?", new Object[] { dptCode }, "sechedulDate asc");
ClinicarConsultation ClinicarConsultation = null;
if (list.Count() > 0)
{
ClinicarConsultation = list[0];
}
return(ClinicarConsultation);
}
/// <summary>
/// 按日期查询
/// </summary>
/// <param name="beginDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public IList <ClinicarConsultation> FindbyDate(string hospitalCode, string userName, string deptCode, string beginDate, string endDate, string dateType)
{
IList <ClinicarConsultation> list = ClinicarConsultationDao.FindByHql(" and hospitalcode = ? and consultationtype = ? and username = ? and deptCode = ? and consultationDate>=? and consultationDate<= ?", new Object[] { hospitalCode, dateType, userName, deptCode, beginDate, endDate }, "consultationDate asc");
return(list);
}