public SResult Update(ClinicarCheckItem clinicarCheckItem)
{
SResult rst = new SResult();
ClinicarCheckItemDao.Update(clinicarCheckItem);
rst.success = true;
rst.data = clinicarCheckItem;
rst.message = "修改成功！";
return(rst);
}
/// <summary>
/// 查询是否存在未完成的项目
/// </summary>
/// <param name="sn"></param>
/// <returns></returns>
public bool ExistUnCompletedItem(int checkId)
{
IList <ClinicarCheckItem> list = ClinicarCheckItemDao.FindByHql(" and deleted = 0 and canceled = 0 and check_id = ? and completed=0", new Object[] { checkId }, "");
if (list.Count() > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 按日期对检查号查询
/// </summary>
/// <param name="sn"></param>
/// <returns></returns>
public ClinicarCheckItem FindByCheckNumber(string checkDate)
{
IList <ClinicarCheckItem> list = ClinicarCheckItemDao.FindByHql(" and check_date >= ?", new Object[] { checkDate }, "check_date,check_number desc limit 1");
ClinicarCheckItem 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 <ClinicarCheckItem> FindByPagination(int pageNum, int pageSize, int checkId)
{
List <object> listParam = new List <object>();
String whereSql = "";
whereSql += " and deleted=0 and check_id = ? ";
listParam.Add(checkId);
SPagintion <ClinicarCheckItem> page = ClinicarCheckItemDao.FindByPagintion(whereSql, listParam.ToArray(), "id desc", pageSize, pageNum);
return(page);
}
/// <summary>
/// 验证用户名是否存在
/// </summary>
/// <param name="username"></param>
/// <param name="id"></param>
/// <returns></returns>
public bool CheckIsExist(int checkId, string itemCode)
{
List <object> _listParam = new List <object>();
String _sql = " and deleted=0 and check_id=? and item_code=? ";
_listParam.Add(checkId);
_listParam.Add(itemCode);
int count = ClinicarCheckItemDao.FindCountByHql(_sql, _listParam.ToArray());
return(count > 0 ? true : false);
}
/// <summary>
/// 查询分检检查项目表中涉及的科室
/// </summary>
/// <param name="pageNum"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public IList FindByCheckId(int checkId)
{
List <object> listParam = new List <object>();
String sql = " Select distinct check_id,dpt_code,dpt_name,completed,summary,ifnull(conclusion,'') as conclusion,ifnull(advice,'') as advice From t_clinicar_check_item ";
sql += " Where deleted=0 and check_id = ? ";
listParam.Add(checkId);
IList list = ClinicarCheckItemDao.FindBySql(sql, listParam.ToArray());
return(list);
}
public SResult Insert(ClinicarCheckItem clinicarCheckItem)
{
SResult rst = new SResult();
if (CheckIsExist(clinicarCheckItem.CheckId, clinicarCheckItem.ItemCode))
{
rst.success = false;
rst.message = "[" + clinicarCheckItem.ItemName + "]已存在！";
}
else
{
ClinicarCheckItemDao.Insert(clinicarCheckItem);
rst.success = true;
rst.data = clinicarCheckItem;
rst.message = "新增成功！";
}
return(rst);
}
public void FakeDelete(int Id)
{
ClinicarCheckItemDao.FakeDeleteById(Id);
}
/// <summary>
/// 查询已完成的项目
/// </summary>
/// <param name="sn"></param>
/// <returns></returns>
public IList <ClinicarCheckItem> FindCompletedItem(int checkId)
{
IList <ClinicarCheckItem> list = ClinicarCheckItemDao.FindByHql(" and deleted = 0 and check_id = ? and completed=1", new Object[] { checkId }, "");
return(list);
}
/// <summary>
/// 按id查询
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ClinicarCheckItem FindById(int Id)
{
return(ClinicarCheckItemDao.FindById(Id));
}
