/// <summary> /// 查询是否存在指定队列记录的 /// </summary> /// <param name="iqueueInfo"></param> /// <returns></returns> public override bool Exists(IModel iqueueInfo) { MQueueInfo queueInfo = (MQueueInfo)iqueueInfo; strSql = "select * from " + TableName + " where EXAM_ACCESSION_NUM='" + queueInfo.EXAM_ACCESSION_NUM + "'"; return(recordIsExist(strSql)); }
public void AddQueueInfo(MWorkList mWorklist) { MQueueInfo mQueueInfo = new MQueueInfo(); mQueueInfo.EXAM_ACCESSION_NUM = mWorklist.EXAM_ACCESSION_NUM; mQueueInfo.PATIENT_ID = mWorklist.PATIENT_ID; }
/// <summary> /// 插入一条队列信息记录 /// </summary> /// <param name="iqueueInfo"></param> /// <returns></returns> public override int Add(IModel iqueueInfo) { MQueueInfo queueInfo = (MQueueInfo)iqueueInfo; Hashtable ht = new Hashtable(); ht.Add("EXAM_ACCESSION_NUM", queueInfo.EXAM_ACCESSION_NUM); ht.Add("PATIENT_ID", queueInfo.PATIENT_ID); ht.Add("PATIENT_NAME", queueInfo.PATIENT_NAME); ht.Add("PATIENT_SEX", queueInfo.PATIENT_SEX); ht.Add("CLINIC_LABLE", queueInfo.CLINIC_LABLE); ht.Add("DOCTOR", queueInfo.DOCTOR); ht.Add("SERIAL_NO", queueInfo.SERIAL_NO); ht.Add("VISIT_DATE", queueInfo.VISIT_DATE); ht.Add("DIAG_FLAG", queueInfo.DIAG_FLAG); ht.Add("VISIT_DEPT", queueInfo.VISIT_DEPT); ht.Add("ORDER_NO", queueInfo.ORDER_NO); ht.Add("VISIT_NO", queueInfo.VISIT_NO); ht.Add("REG_DATE", queueInfo.REG_DATE); ht.Add("IS_REDIAG", queueInfo.IS_REDIAG); ht.Add("QUEUE_NAME", queueInfo.QUEUE_NAME); ht.Add("PRINT_NO", queueInfo.PRINT_NO); ht.Add("PASSED", queueInfo.PASSED); return(ExecuteSql(StringConstructor.InsertSql(TableName, ht).ToString())); }
/// <summary> /// 获取指定检查申请号的队列信息 /// </summary> /// <param name="EXAM_ACCESSION_NUM"></param> /// <returns></returns> public override IModel GetModel(string EXAM_ACCESSION_NUM) { strSql = "select * from " + TableName + " where EXAM_ACCESSION_NUM = '" + EXAM_ACCESSION_NUM + "'"; DataTable dt = GetDataTable(strSql); if (dt.Rows.Count == 0) { return(null); } MQueueInfo queueInfo = new MQueueInfo(); queueInfo.EXAM_ACCESSION_NUM = dt.Rows[0]["EXAM_ACCESSION_NUM"].ToString(); queueInfo.PATIENT_ID = dt.Rows[0]["PATIENT_ID"].ToString(); queueInfo.PATIENT_NAME = dt.Rows[0]["PATIENT_NAME"].ToString(); queueInfo.PATIENT_SEX = dt.Rows[0]["PATIENT_SEX"].ToString(); queueInfo.CLINIC_LABLE = dt.Rows[0]["CLINIC_LABLE"].ToString(); queueInfo.DOCTOR = dt.Rows[0]["DOCTOR"].ToString(); if (dt.Rows[0]["SERIAL_NO"].ToString() == "") { queueInfo.SERIAL_NO = null; } else { queueInfo.SERIAL_NO = Convert.ToInt32(dt.Rows[0]["SERIAL_NO"].ToString()); } if (dt.Rows[0]["VISIT_DATE"].ToString() == "") { queueInfo.VISIT_DATE = null; } else { queueInfo.VISIT_DATE = Convert.ToDateTime(dt.Rows[0]["VISIT_DATE"].ToString()); } if (dt.Rows[0]["DIAG_FLAG"].ToString() == "") { queueInfo.DIAG_FLAG = null; } else { queueInfo.DIAG_FLAG = Convert.ToInt32(dt.Rows[0]["DIAG_FLAG"].ToString()); } if (dt.Rows[0]["ORDER_NO"].ToString() == "") { queueInfo.ORDER_NO = null; } else { queueInfo.ORDER_NO = Convert.ToDecimal(dt.Rows[0]["ORDER_NO"].ToString()); } if (dt.Rows[0]["VISIT_NO"].ToString() == "") { queueInfo.VISIT_NO = null; } else { queueInfo.VISIT_NO = Convert.ToInt32(dt.Rows[0]["VISIT_NO"].ToString()); } if (dt.Rows[0]["REG_DATE"].ToString() == "") { queueInfo.REG_DATE = null; } else { queueInfo.REG_DATE = Convert.ToDateTime(dt.Rows[0]["REG_DATE"].ToString()); } if (dt.Rows[0]["PRINT_NO"].ToString() == "") { queueInfo.PRINT_NO = null; } else { queueInfo.PRINT_NO = Convert.ToInt32(dt.Rows[0]["PRINT_NO"].ToString()); } if (dt.Rows[0]["PASSED"].ToString() == "") { queueInfo.PASSED = null; } else { queueInfo.PASSED = Convert.ToInt32(dt.Rows[0]["PASSED"].ToString()); } queueInfo.VISIT_DEPT = dt.Rows[0]["VISIT_DEPT"].ToString(); queueInfo.IS_REDIAG = dt.Rows[0]["IS_REDIAG"].ToString(); queueInfo.QUEUE_NAME = dt.Rows[0]["QUEUE_NAME"].ToString(); return(queueInfo); }