/// <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);
}
