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