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