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