/// <summary>
/// 新增排队
/// </summary>
/// <param name="lineupInfo"></param>
/// <returns></returns>
public bool NewLinuUp(LineUpData lineupInfo)
{
SQL sql = CreateSQL("新增排队信息", "insert into " +
" 影像排队信息(排队ID,申请ID,患者ID, 队列ID,科室ID, 排队日期, 队列名称, 科室名称,检查房间,患者姓名,排队号码,排队序号,号码前缀,附加信息,排队状态) " +
" values " +
" (:排队ID, :申请ID, :患者ID, :队列ID,:科室ID,:排队日期, :队列名称, :科室名称, :检查房间, :患者姓名, :排队号码, :排队序号, :号码前缀, :附加信息, :排队状态)");
lineupInfo.附加信息.最后更新日期 = GetServerDate();
sql.AddParameter("排队ID", lineupInfo.排队ID);
sql.AddParameter("申请ID", lineupInfo.申请ID);
sql.AddParameter("患者ID", lineupInfo.患者ID);
sql.AddParameter("队列ID", lineupInfo.队列ID);
sql.AddParameter("科室ID", lineupInfo.科室ID);
sql.AddDateTimePar("排队日期", lineupInfo.排队日期);
sql.AddParameter("队列名称", lineupInfo.队列名称);
sql.AddParameter("科室名称", lineupInfo.科室名称);
sql.AddParameter("检查房间", lineupInfo.检查房间);
sql.AddParameter("患者姓名", lineupInfo.患者姓名);
sql.AddParameter("排队号码", lineupInfo.排队号码);
sql.AddParameter("排队序号", lineupInfo.排队序号);
sql.AddParameter("号码前缀", lineupInfo.号码前缀);
sql.AddInt32Par("排队状态", (int)lineupInfo.排队状态);
sql.AddParameter("附加信息", lineupInfo.附加信息.ToString());
sql.ExecuteSql();
return(true);
}
public bool UpdateLineupInfo(LineUpData lineupInfo)
{
SQL sql = CreateSQL("更新排队信息", "Update 影像排队信息 " +
" Set 排队日期=:排队日期, 检查房间=:检查房间, 患者姓名=:患者姓名, 排队状态=:排队状态, 排队号码=:排队号码, 排队序号=:排队序号,附加信息=:附加信息 where 排队ID=:排队ID");
lineupInfo.附加信息.最后更新日期 = GetServerDate();
sql.AddDateTimePar("排队日期", lineupInfo.排队日期);
sql.AddParameter("检查房间", lineupInfo.检查房间);
sql.AddParameter("患者姓名", lineupInfo.患者姓名);
sql.AddInt32Par("排队状态", (int)lineupInfo.排队状态);
sql.AddParameter("排队号码", lineupInfo.排队号码);
sql.AddParameter("排队序号", lineupInfo.排队序号);
sql.AddParameter("附加信息", lineupInfo.附加信息.ToString());
sql.AddParameter("排队ID", lineupInfo.排队ID);
sql.ExecuteSql();
return(true);
}
/// <summary>
/// 返回排队信息
/// </summary>
/// <param name="queueID"></param>
/// <returns></returns>
public LineUpData GetLineupInfo(string lineupId)
{
SQL sql = CreateSQL("查询排队信息", "select 排队ID,申请ID,患者ID,队列ID,科室ID,排队日期,队列名称,科室名称,检查房间,患者姓名,排队号码,排队序号,号码前缀,附加信息,排队状态"
+ " from 影像排队信息"
+ " where 排队ID=:排队ID ");
sql.AddParameter("排队ID", lineupId);
DataTable dtLinuup = sql.ExecuteSql();
if (dtLinuup == null || dtLinuup.Rows.Count <= 0)
{
return(null);
}
LineUpData lineupInfo = new LineUpData();
lineupInfo.BindRowData(dtLinuup.Rows[0]);
return(lineupInfo);
}
public LineUpData HasApply(string applyId, string departmentId)
{
SQL sql = CreateSQL("查询申请是否已经存在", "Select 排队ID,申请ID,患者ID,队列ID,科室ID,排队日期,队列名称,科室名称,检查房间,患者姓名,排队号码,排队序号,号码前缀,附加信息,排队状态 "
+ " From 影像排队信息 Where 申请ID=:申请ID And 科室ID=:科室ID");
sql.AddParameter("申请ID", applyId);
sql.AddParameter("科室ID", departmentId);
DataTable dtData = sql.ExecuteSql();
if (dtData == null || dtData.Rows.Count <= 0)
{
return(null);
}
LineUpData lineupInfo = new LineUpData();
lineupInfo.BindRowData(dtData.Rows[0]);
return(lineupInfo);
}
/// <summary>
/// 返回顺呼的排队信息
/// </summary>
/// <param name="queueID"></param>
/// <returns></returns>
public LineUpData GetOrderCallLineup(string queueID)
{
SQL sql = CreateSQL("查询待呼叫排队信息", "select 排队ID,申请ID,患者ID,队列ID,科室ID,排队日期,队列名称,科室名称,检查房间,患者姓名,排队号码,排队序号,号码前缀,附加信息,排队状态"
+ " from 影像排队信息 a, "
+ " (select nvl(min(排队序号), 0) as 最小序号 from 影像排队信息 where 队列ID=:队列ID and 排队日期=Trunc(sysdate) and 排队状态=0) b"
+ " where a.队列ID=:队列ID and a.排队日期=TRUNC(sysdate) and a.排队状态= 0 and a.排队序号=b.最小序号 ");
sql.AddParameter("队列ID", queueID);
DataTable dtLinuup = sql.ExecuteSql();
if (dtLinuup == null || dtLinuup.Rows.Count <= 0)
{
return(null);
}
LineUpData lineupInfo = new LineUpData();
lineupInfo.BindRowData(dtLinuup.Rows[0]);
return(lineupInfo);
}
