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