/// <summary> /// 新增序列 /// </summary> /// <param name="serialData"></param> public void NewSerial(StudySerialData serialData) { SQL sql = SqlHelper.CreateSQL("插入检查序列", "Insert into 影像检查序列(序列ID,DcmUID,申请ID,存储ID,房间ID,设备ID,序号,序列信息) " + "values(:序列ID,:DcmUID,:申请ID,:存储ID,:房间ID,:设备ID,:序号,:序列信息)"); sql.AddParameter("序列ID", DbType.String, serialData.序列ID); sql.AddParameter("DcmUID", DbType.String, serialData.DcmUID); sql.AddParameter("申请ID", DbType.String, serialData.申请ID); sql.AddParameter("存储ID", DbType.String, serialData.存储ID); sql.AddParameter("房间ID", DbType.String, serialData.房间ID); sql.AddParameter("设备ID", DbType.String, serialData.设备ID); sql.AddParameter("序号", DbType.String, serialData.序号); sql.AddParameter("序列信息", DbType.String, serialData.序列信息.ToString()); _dbHelper.ExecuteSQL(sql); }
/// <summary> /// 根据序列ID获取序列信息 /// </summary> /// <param name="serialId"></param> /// <returns></returns> public StudySerialData GetApplySerialInfoById(string serialId) { SQL sql = SqlHelper.CreateSQL("根据ID获取检查序列", "select 序列ID,DcmUID,申请ID,存储ID,房间ID,设备ID, 序号,序列信息,删除标记 from 影像检查序列 where 序列ID=:序列ID and nvl(删除标记, 0)=0 "); sql.AddParameter("序列ID", DbType.String, serialId); DataTable dtSerial = _dbHelper.ExecuteSQL(sql); if (dtSerial.Rows.Count <= 0) { return(null); } StudySerialData ssd = new StudySerialData(); ssd.BindRowData(dtSerial.Rows[0]); return(ssd); }
public StudySerialData GetApplySerialInfoByRoom(string applyId, string roomId, string deviceId) { SQL sql = SqlHelper.CreateSQL("根据房间设备获取检查序列", "select 序列ID,DcmUID,申请ID,存储ID,房间ID,设备ID, 序号,序列信息,删除标记 " + " from 影像检查序列 " + " where 申请ID=:申请ID and 房间ID=:房间ID and 设备ID=:设备ID and nvl(删除标记, 0)=0 "); sql.AddParameter("申请ID", applyId); sql.AddParameter("房间ID", roomId); sql.AddParameter("设备ID", deviceId); DataTable dtSerial = _dbHelper.ExecuteSQL(sql); if (dtSerial.Rows.Count <= 0) { return(null); } StudySerialData ssd = new StudySerialData(); ssd.BindRowData(dtSerial.Rows[0]); return(ssd); }