//获取系统中未完成的[超声科]房间的检查列表
private List <String> getUltrasoundExamList()
{
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
DataRow[] rows = tbl.Select("RoomID='[超声科]' and IsOver='0'");
if (CSTR.IsRowArrEmpty(rows))
{
return(null);
}
List <String> list = new List <string>();
foreach (DataRow row in rows)
{
String DJLSH = CSTR.ObjectTrim(row["DJLSH"]);
if (CSTR.isEmpty(DJLSH))
{
continue;
}
DJLSH = DJLSH.Replace("'", "");
list.Add(DJLSH);
}
return(list);
}
//根据手环号码获取检查列表(不分状态,全部)--------------------------------------------------
public static DataRow[] JiaohaoTable_Get_All_Exam_By_ringNo(String ringNo)
{
String sql = String.Format("RfidName='{0}'", ringNo);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
return(tbl.Select(sql));
}
//根据手环号码获取检查列表(不分状态,全部)--------------------------------------------------
public static DataRow[] JiaohaoTable_Get_All_Exam_By_DJLSH(String DJLSH)
{
String sql = String.Format("DJLSH='{0}'", DJLSH);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
return(tbl.Select(sql));
}
//获取指定IndexID的JiaohaoTable一条记录(不分状态,全部)--------------------------------------------------
public static DataRow[] JiaohaoTable_Get_One_Item_By_IndexID(String indexID)
{
String sql = String.Format("IndexID='{0}'", indexID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
return(tbl.Select(sql));
}
public static DataRow[] Exam_Get_Unfinished_Exams()
{
//取得本进程对应的ModalityID(room_id)
String strRoomID = CONFIG.system_param["room_id"];
String sql = String.Format("RoomID='{0}' and IsOver='0'", strRoomID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
//order by QueueID
return(tbl.Select(sql, "QueueID"));
}
public static DataRow[] Exam_Get_Doing()
{
//取得本进程对应的ModalityID(room_id)
String strRoomID = CONFIG.system_param["room_id"];
String sql = String.Format("QueueActive='1' and status='1' and IsChecking='1' and IsOver='0' and RoomID='{0}'", strRoomID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
//order by QueueID
return(tbl.Select(sql, "QueueID DESC"));
}
// 获取本房间的当前正在检查的信息(当前的,不呼叫,用于显示正在检查)(对于234室,返回结果可能为多条)
public static DataRow[] Exam_Get_Doing_To_Show()
{
//取得本进程对应的ModalityID(room_id)
String strRoomID = CONFIG.system_param["room_id"];
//IsSaid初始为0,在显示完信息后设置为1
String sql = String.Format("RoomID='{0}' and status='1' and IsChecking='1'", strRoomID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
//order by IsSaid
return(tbl.Select(sql, "IsSaid"));
}
public static DataRow[] Exam_Get_Single_Exam_By_IndexID(String strIndexID)
{
String sql = String.Format("IndexID='{0}'", strIndexID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
DataRow[] sel_rows = tbl.Select(sql);
if (CSTR.IsArrayEmpty(sel_rows))
{
return(null);
}
return(sel_rows);
}
//获取指定房间的过号检查队列总数(过号)
public static int Queue_Length_Count_Specified_Room_Passed_Exam(String roomID)
{
//包含状态字为 1000,1110的检查,即只要QueueActive=1,IsOver=0
String sql = String.Format("QueueActive='0' And status='1' And IsChecking='0' And IsOver='0' And RoomID='{0}'", roomID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(0);
}
DataRow[] sel_rows = tbl.Select(sql);
if (CSTR.IsArrayEmpty(sel_rows))
{
return(0);
}
return(sel_rows.Length);
}
//获取指定房间当前已分配的未完成检查数
#endregion DocBench专属查询---------------------------------------------End
#region 队列数目查询----------------------------------------------------Start
//获取指定房间的Pending的队列总数,忽略QueueActive状态(use case:在新到检时需要知道各个房间的总检查,而非活动检查)
public static int Queue_Length_Count_Specified_Room_Ignore_QueueActive(String roomID)
{
//只要IsOver=0就属于未完成检查
String sql = String.Format("IsOver='0' And RoomID='{0}'", roomID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(0);
}
DataRow[] sel_rows = tbl.Select(sql);
if (CSTR.IsArrayEmpty(sel_rows))
{
return(0);
}
return(sel_rows.Length);
}
/// 获取本房间的相同RFID的信息(不管状态)
public static DataRow[] Exam_Get_All_Exam_Ingone_Status_SameRoom_SameRFID(String strRFID)
{
strRFID = CSTR.trim(strRFID);
if (strRFID.Length <= 0)
{
return(null);
}
//取得本进程对应的room_id
String strRoomID = CONFIG.system_param["room_id"];
String sql = String.Format("RoomID='{0}' AND Rfid='{1}'", strRoomID, strRFID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
return(tbl.Select(sql));
}
public static DataRow[] TJ_Queue_Arrange_Get_Checking_or_Activated_Exam(String DJLSH)
{
DJLSH = CSTR.trim(DJLSH);
if (DJLSH.Length <= 0)
{
return(null);
}
//包括状态串为 1000 与 1110 的检查
String sql = String.Format("QueueActive='1' And DJLSH='{0}'", DJLSH);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
return(tbl.Select(sql));
}
/**
* 获取指定DJLSH的当前活动检查
* 使用:
* FinalCheckWnd.cs在显示检查列表时调用
*
* **/
//获取指定DJLSH的当前活动检查
public static DataRow[] TJ_Queue_Arrange_Get_Activated_Exam(String DJLSH)
{
DJLSH = CSTR.trim(DJLSH);
if (DJLSH.Length <= 0)
{
return(null);
}
String sql = String.Format("QueueActive='1' And status='0' And IsChecking='0' And IsOver='0' " +
"And DJLSH='{0}'", DJLSH);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
return(tbl.Select(sql));
}
public static DataRow Exam_Get_Pending_First_One()
{
//取得本进程对应的ModalityID(room_id)
String strRoomID = CONFIG.system_param["room_id"];
String sql = String.Format("QueueActive='1' and RoomID='{0}' and status='0' and IsChecking='0' and IsOver='0'", strRoomID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
//order by QueueID
DataRow[] rows = tbl.Select(sql, "QueueID");
if (CSTR.IsArrayEmpty(rows))
{
return(null);
}
return(rows[0]);
}
public static String Exam_Get_RingNo_By_RfidNo(String strRFID)
{
strRFID = CSTR.trim(strRFID);
if (strRFID.Length <= 0)
{
return(null);
}
String sql = String.Format("Rfid='{0}' ", strRFID);
DataTable tbl = DatabaseCache.DB_Get_JiaohaoTable_table();
if (CSTR.IsTableEmpty(tbl))
{
return(null);
}
DataRow[] sel_rows = tbl.Select(sql);
if (CSTR.IsArrayEmpty(sel_rows))
{
return(null);
}
return(CSTR.ObjectTrim(sel_rows[0]["RfidName"]));
}
