public SResult Insert(ClinicarCheckResult clinicarCheckResult)
{
SResult rst = new SResult();
ClinicarCheckResultDao.Insert(clinicarCheckResult);
rst.success = true;
rst.data = clinicarCheckResult;
rst.message = "新增成功！";
return(rst);
}
public SResult Update(ClinicarCheckResult clinicarCheckResult)
{
SResult rst = new SResult();
ClinicarCheckResultDao.Update(clinicarCheckResult);
rst.success = true;
rst.data = clinicarCheckResult;
rst.message = "修改成功！";
return(rst);
}
/// <summary>
/// 子表数据分页查询
/// </summary>
/// <param name="pageNum"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public SPagintion <ClinicarCheckResult> FindByPagination(int pageNum, int pageSize, string checkNum)
{
List <object> listParam = new List <object>();
String whereSql = "";
whereSql += " and deleted=0 and check_number = ? ";
listParam.Add(checkNum);
SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "item_code asc", pageSize, pageNum);
return(page);
}
/// <summary>
/// 按日期对检查号查询
/// </summary>
/// <param name="sn"></param>
/// <returns></returns>
public ClinicarCheckResult FindByCheckNumber(string checkDate)
{
IList <ClinicarCheckResult> list = ClinicarCheckResultDao.FindByHql(" and check_date >= ?", new Object[] { checkDate }, "check_date,check_number desc limit 1");
ClinicarCheckResult clinicarCheck = null;
if (list.Count() > 0)
{
clinicarCheck = list[0];
}
return(clinicarCheck);
}
/// <summary>
/// 子表数据分页查询
/// </summary>
/// <param name="pageNum"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public SPagintion <ClinicarCheckResult> FindByPagination(int pageNum, int pageSize, string checkNum, string itemCode)
{
List <object> listParam = new List <object>();
String whereSql = "";
whereSql += " and IFNULL(item_detail_name,'') not in ('Ref Group','Blood Mode','Take Mode') and deleted=0 and check_number = ? and item_code = ? ";
listParam.Add(checkNum);
listParam.Add(itemCode);
SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "create_time desc", pageSize, pageNum);
return(page);
}
/// <summary>
/// 验证用户名是否存在
/// </summary>
/// <param name="username"></param>
/// <param name="id"></param>
/// <returns></returns>
public bool CheckIsExist(string code, Int32?id)
{
List <object> _listParam = new List <object>();
String _sql = " and name=?";
_listParam.Add(code);
if (id != null)
{
_sql += " and id<>?";
_listParam.Add(id);
}
int count = ClinicarCheckResultDao.FindCountByHql(_sql, _listParam.ToArray());
return(count > 0 ? true : false);
}
/// <summary>
/// 根据检查号和项目编号分页查询
/// </summary>
/// <param name="pageNum"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public SPagintion <ClinicarCheckResult> FindByNumAndItem(int pageNum, int pageSize, string checkNum, string itemCode)
{
List <object> listParam = new List <object>();
String whereSql = "";
if (!string.IsNullOrWhiteSpace(checkNum))
{
whereSql += " and check_number = ? ";
listParam.Add(checkNum);
}
whereSql += " and deleted=0 and item_code = ? ";
listParam.Add(itemCode);
SPagintion <ClinicarCheckResult> page = ClinicarCheckResultDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum);
return(page);
}
public void FakeDelete(int Id)
{
ClinicarCheckResultDao.FakeDeleteById(Id);
}
/// <summary>
///
/// </summary>
/// <param name="checkNumber"></param>
/// <param name="itemCode"></param>
/// <returns></returns>
public IList <ClinicarCheckResult> FindEntity(string checkNumber, string itemCode)
{
IList <ClinicarCheckResult> list = ClinicarCheckResultDao.FindByHql(" and deleted = 0 and check_number = ? and item_code = ? order by create_time desc", new Object[] { checkNumber, itemCode }, "");
return(list);
}
/// <summary>
/// 查询项目数
/// </summary>
/// <returns></returns>
public IList FindItemCount(string checkNumber)
{
string _sql = string.Format("select distinct item_code,item_name from t_clinicar_check_result where ifnull(deleted,0) =0 and check_number = ? ");
return(ClinicarCheckResultDao.FindBySql(_sql, new object[] { checkNumber }));
}
/// <summary>
/// 根据检查号获取检查结果
/// </summary>
/// <param name="sn"></param>
/// <returns></returns>
public IList <ClinicarCheckResult> FindEntity(string checkNumber)
{
IList <ClinicarCheckResult> list = ClinicarCheckResultDao.FindByHql(" and deleted = 0 and check_number = ?", new Object[] { checkNumber }, "");
return(list);
}
/// <summary>
/// 按id查询
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ClinicarCheckResult FindById(int Id)
{
return(ClinicarCheckResultDao.FindById(Id));
}
