//获取系统中未完成的[超声科]房间的检查列表 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"])); }