/// <summary> /// 根据'证件号'查询检查历史记录 /// </summary> /// <param name="personNumber"></param> /// <returns></returns> public IList FindByPersonNumber(string personNumber) { string str = " Select * From t_clinicar_check Where deleted=0 and certificate_number = ? Order by check_date desc "; IList list = ClinicarCheckDao.FindBySql(str, new Object[] { personNumber }); return(list); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public SPagintion <ClinicarCheck> FindByPagination(int pageNum, int pageSize, string checkNum, string name, string cardNum) { List <object> listParam = new List <object>(); String whereSql = ""; if (checkNum != null && checkNum.Length > 0) { whereSql += " and check_number like ? "; listParam.Add("%" + checkNum + "%"); } if (name != null && name.Length > 0) { whereSql += " and name like ? "; listParam.Add("%" + name + "%"); } if (cardNum != null && cardNum.Length > 0) { whereSql += " and certificate_number like ? "; listParam.Add("%" + cardNum + "%"); } SPagintion <ClinicarCheck> page = ClinicarCheckDao.FindByPagintion(whereSql, listParam.ToArray(), "check_number desc", pageSize, pageNum); return(page); }
/// <summary> /// 50岁以下就诊人员 /// </summary> /// <param name="from"></param> /// <param name="to"></param> /// <returns></returns> public IList FindCheck50Total(DateTime from, DateTime to) { string str = " Select count(id) From t_clinicar_check Where deleted=0 and check_date between ? and ? and ifnull(age,0) > 50 "; IList list = ClinicarCheckDao.FindBySql(str, new Object[] { from, to }); return(list); }
/// <summary> /// 查询就诊性别人数 /// </summary> /// <param name="from"></param> /// <param name="to"></param> /// <returns></returns> public IList FindCheckFeMaleTotol(DateTime from, DateTime to) { string str = " Select count(id) From t_clinicar_check Where deleted=0 and check_date between ? and ? and gender_code = 2 "; IList list = ClinicarCheckDao.FindBySql(str, new Object[] { from, to }); return(list); }
public SResult Update(ClinicarCheck clinicarCheck) { SResult rst = new SResult(); ClinicarCheckDao.Update(clinicarCheck); rst.success = true; rst.data = clinicarCheck; rst.message = "修改成功!"; return(rst); }
public SResult Insert(ClinicarCheck clinicarCheck) { SResult rst = new SResult(); ClinicarCheckDao.Insert(clinicarCheck); rst.success = true; rst.data = clinicarCheck; rst.message = "新增成功!"; return(rst); }
/// <summary> /// 按检查号进行查询 /// ADD BY CHENKUN 2017-04-09 /// </summary> /// <param name="checkNumber"></param> /// <returns></returns> public ClinicarCheck FindByCheckNumberBar(string checkNumber) { IList <ClinicarCheck> list = ClinicarCheckDao.FindByHql(" and deleted = 0 and check_number = ?", new Object[] { checkNumber }, "check_date,check_number desc limit 1"); ClinicarCheck clinicarCheck = null; if (list.Count() > 0) { clinicarCheck = list[0]; } return(clinicarCheck); }
/// <summary> /// 按id查询 /// </summary> /// <param name="Id"></param> /// <returns></returns> public ClinicarCheck FindById(string Id) { IList <ClinicarCheck> list = ClinicarCheckDao.FindByHql(" and deleted = 0 and id = ?", new Object[] { Id }, ""); ClinicarCheck clinicarCheck = null; if (list.Count() > 0) { clinicarCheck = list[0]; } return(clinicarCheck); }
/// <summary> /// 按id查询 /// </summary> /// <param name="Id"></param> /// <returns></returns> public ClinicarCheck FindById(int Id) { return(ClinicarCheckDao.FindById(Id)); }
public void Delete(int Id) { ClinicarCheckDao.DeleteById(Id); }