/// <summary> /// 更新媒体信息 /// </summary> /// <param name="mediaData"></param> public void UpdateMedia(StudyMediaData mediaData) { SQL sql = CreateSQL("更新媒体信息", "update 影像检查媒体 set 媒体信息=:媒体信息 where 媒体ID=:媒体ID"); sql.AddParameter("媒体ID", DbType.String, mediaData.媒体ID); sql.AddParameter("媒体信息", DbType.String, mediaData.媒体信息.ToString()); sql.ExecuteSql(); }
/// <summary> /// 新增媒体 /// </summary> /// <param name="mediaData"></param> public void NewMedia(StudyMediaData mediaData) { SQL sql = SqlHelper.CreateSQL("插入检查媒体", "Insert into 影像检查媒体(媒体ID,DcmUID,序列ID,申请ID,序号,媒体信息) " + "values(:媒体ID,:DcmUID,:序列ID,:申请ID,:序号,:媒体信息)"); sql.AddParameter("媒体ID", DbType.String, mediaData.媒体ID); sql.AddParameter("DcmUID", DbType.String, mediaData.DcmUID); sql.AddParameter("序列ID", DbType.String, mediaData.序列ID); sql.AddParameter("申请ID", DbType.String, mediaData.申请ID); sql.AddParameter("序号", DbType.String, mediaData.序号); sql.AddParameter("媒体信息", DbType.String, mediaData.媒体信息.ToString()); _dbHelper.ExecuteSQL(sql); }
public void UpdateKeyImageState(string mediaId, bool isKey) { StudyMediaData smd = GetMediaInfoById(mediaId); if (smd == null) { throw new Exception("媒体信息获取失败。"); } smd.媒体信息.是否关键图 = isKey; SQL sql = SqlHelper.CreateSQL("更新媒体关键图标记", "update 影像检查媒体 set 媒体信息=:媒体信息 where 媒体ID=:媒体ID"); sql.AddParameter("媒体ID", DbType.String, mediaId); sql.AddParameter("媒体信息", DbType.String, smd.媒体信息.ToString()); _dbHelper.ExecuteSQL(sql); }
/// <summary> /// 根据媒体ID获取媒体信息 /// </summary> /// <param name="mediaId"></param> /// <returns></returns> public StudyMediaData GetMediaInfoById(string mediaId) { SQL sql = SqlHelper.CreateSQL("根据ID获取检查媒体", "select 媒体ID,序列ID,DcmUID,申请ID,序号,媒体信息,删除标记 from 影像检查媒体 where 媒体ID=:媒体ID and nvl(删除标记, 0)=0 "); sql.AddParameter("媒体ID", DbType.String, mediaId); DataTable dtMedia = _dbHelper.ExecuteSQL(sql); if (dtMedia.Rows.Count <= 0) { return(null); } StudyMediaData smd = new StudyMediaData(); smd.BindRowData(dtMedia.Rows[0]); return(smd); }