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