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