public SResult Update(ClinicarConsultation ClinicarConsultation) { SResult rst = new SResult(); ClinicarConsultationDao.Update(ClinicarConsultation); rst.success = true; rst.data = ClinicarConsultation; rst.message = "修改成功!"; return(rst); }
public SResult Insert(ClinicarConsultation ClinicarConsultation) { SResult rst = new SResult(); ClinicarConsultationDao.Insert(ClinicarConsultation); rst.success = true; rst.data = ClinicarConsultation; rst.message = "新增成功!"; return(rst); }
/// <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="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarConsultation> FindByPagination(int pageNum, int pageSize, string beginDate, string endDate) { List <object> listParam = new List <object>(); String whereSql = ""; //if (beginDate != null && beginDate.Length > 0 && endDate != null && endDate.Length > 0) //{ // whereSql += " and sechedulDate between ? and ? "; // listParam.Add(beginDate); // listParam.Add(endDate); //} whereSql += " and DATE_FORMAT(applyhospitaldate,'%Y-%m-%d') between ? and ? "; listParam.Add(beginDate); listParam.Add(endDate); SPagintion <ClinicarConsultation> page = ClinicarConsultationDao.FindByPagintion(whereSql, listParam.ToArray(), "applyhospitaldate desc", pageSize, pageNum); return(page); }
/// <summary> /// 按id查询 /// </summary> /// <param name="Id"></param> /// <returns></returns> public ClinicarConsultation FindById(Int32 Id) { return(ClinicarConsultationDao.FindById(Id)); }
public void Delete(Int32 Id) { ClinicarConsultationDao.DeleteById(Id); }
/// <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); }