/// <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 string GetMaxQueueNo(string queueID, DateTime queueDate)
{
SQL sql = CreateSQL("查询排队最大号码", "select nvl(max(排队号码), 0) as 号码 "
+ " from 影像排队信息 "
+ " where 队列ID=:队列ID and 排队日期=trunc(:排队日期)");
sql.AddParameter("队列ID", queueID);
sql.AddDateTimePar("排队日期", queueDate);
object value = sql.ExecuteSqlOneOutput();
return((value == null) ? "" : value.ToString());
}
/// <summary>
/// 判断号码是否存在
/// </summary>
/// <param name="queueNo"></param>
/// <param name="queueName"></param>
/// <param name="queueDate"></param>
/// <returns></returns>
public bool HasNo(int queueNo, string queueID, DateTime queueDate)
{
SQL sql = CreateSQL("查询排队号是否存在", "select 排队号码 from 影像排队信息 "
+ " where 队列ID=:队列ID and 排队日期=:排队日期 and 排队号码=:排队号码");
sql.AddParameter("队列ID", queueID);
sql.AddDateTimePar("排队日期", queueDate);
sql.AddInt32Par("排队号码", queueNo);
DataTable dtNo = sql.ExecuteSql();
return((dtNo.Rows.Count > 0) ? true : false);
}
/// <summary>
/// 获取排队中的数量
/// </summary>
/// <param name="queueId"></param>
/// <param name="queueDate"></param>
/// <returns></returns>
public int GetLineupCount(string queueId, DateTime queueDate)
{
SQL sql = CreateSQL("查询排队数量", "select count(1) as 数量 from 影像排队信息 where 队列ID=:队列ID and 排队日期=trunc(:排队日期) and 排队状态=0");
sql.AddParameter("队列ID", queueId);
sql.AddDateTimePar("排队日期", queueDate);
DataTable dtCount = sql.ExecuteSql();
if (dtCount == null || dtCount.Rows.Count <= 0)
{
return(0);
}
return(Convert.ToInt32(dtCount.Rows[0]["数量"]));
}
public DataTable GetLineupInfos(string queueID, bool isQueueing, DateTime dtQueue = default(DateTime))
{
DateTime filterDatetime = dtQueue;
if (filterDatetime == default(DateTime))
{
filterDatetime = GetServerDate();
}
SQL sql = CreateSQL("查询队列排队信息", "select 排队ID,申请ID,患者ID,队列ID,科室ID,排队日期,队列名称,科室名称,检查房间,患者姓名,排队号码,排队序号,号码前缀,附加信息,排队状态"
+ " from 影像排队信息 "
+ " where 队列ID=:队列ID and 排队日期=TRUNC(:排队日期) " + ((isQueueing)?" and 排队状态=0": "")
+ " order by 排队序号 ");
sql.AddParameter("队列ID", queueID);
sql.AddDateTimePar("排队日期", filterDatetime);
return(sql.ExecuteSql());
}
/// <summary>
/// 查询科室下的所有队列的排队状态信息
/// </summary>
/// <param name="departmentId"></param>
/// <param name="queueDate"></param>
/// <returns></returns>
public DataTable GetLineupCountByDepartmentId(string departmentId, DateTime queueDate = default(DateTime))
{
DateTime curQueueDate = queueDate;
if (curQueueDate == default(DateTime))
{
curQueueDate = GetServerDate();
}
SQL sql = CreateSQL("获取指定科室中的排队状态", "Select a.队列ID,a.队列名称, sum(decode(b.排队状态, 0, 1, 0)) as 数量"
+ " From 影像队列管理 a, 影像排队信息 b "
+ " Where a.队列ID=b.队列ID(+) and a.科室ID=:科室ID and b.排队日期(+)=trunc(:排队日期)"
+ " Group By a.队列ID, a.队列名称");
sql.AddParameter("科室ID", departmentId);
sql.AddDateTimePar("排队日期", curQueueDate);
return(sql.ExecuteSql());
}
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="callInfo"></param>
/// <returns></returns>
public bool NewCall(LineCallData callInfo)
{
SQL sql = CreateSQL("新增呼叫信息", "insert into " +
" 影像排队呼叫(呼叫ID,排队ID,队列ID,生成日期, 呼叫站点, 呼叫信息) " +
" values " +
" (:呼叫ID,:排队ID,:队列ID,:生成日期, :呼叫站点, :呼叫信息)");
sql.AddParameter("呼叫ID", callInfo.呼叫ID);
sql.AddParameter("排队ID", callInfo.排队ID);
sql.AddParameter("队列ID", callInfo.队列ID);
sql.AddDateTimePar("生成日期", callInfo.生成日期);
sql.AddParameter("呼叫站点", callInfo.呼叫站点);
sql.AddParameter("呼叫信息", callInfo.呼叫信息.ToString());
sql.ExecuteSql();
return(true);
}
