/// <summary>
/// 删除
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int Delete(BaseEntity p_Entity)
{
try
{
OrderLevel MasterEntity = (OrderLevel)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//删除主表数据
string Sql = "";
Sql = "DELETE FROM Enum_OrderLevel WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID);
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(Sql);
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(Sql);
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E);
}
}
public ItemsBasedOrder(ItemsBasedOrder order)
{
_dateFrom = order._dateFrom;
_dateTo = order._dateTo;
PlacementMode = order.PlacementMode;
OrderLevel = order.OrderLevel;
Listener = order.Listener;
}
public ItemsBasedOrder(DateTime dateFrom, DateTime dateTo, PlacementMode placementMode, OrderLevel orderLevel, IDataLoadEventListener listener)
{
_dateFrom = dateFrom;
_dateTo = dateTo;
PlacementMode = placementMode;
OrderLevel = orderLevel;
Listener = listener;
}
/// <summary>
/// 新增
/// </summary>
/// <param name="p_Entity">实体类</param>
/// <returns>操作影响的记录行数</returns>
public override int AddNew(BaseEntity p_Entity)
{
try
{
OrderLevel MasterEntity = (OrderLevel)p_Entity;
if (MasterEntity.ID == 0)
{
return(0);
}
//新增主表数据
StringBuilder MasterField = new StringBuilder();
StringBuilder MasterValue = new StringBuilder();
MasterField.Append("INSERT INTO Enum_OrderLevel(");
MasterValue.Append(" VALUES(");
MasterField.Append("ID" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ",");
MasterField.Append("Code" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Code) + ",");
MasterField.Append("Name" + ",");
MasterValue.Append(SysString.ToDBString(MasterEntity.Name) + ",");
MasterField.Append("ColorStr" + ")");
MasterValue.Append(SysString.ToDBString(MasterEntity.ColorStr) + ")");
//执行
int AffectedRows = 0;
if (!this.sqlTransFlag)
{
AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
else
{
AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString());
}
return(AffectedRows);
}
catch (BaseException E)
{
throw new BaseException(E.Message, E);
}
catch (Exception E)
{
throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E);
}
}
public static string MakeKeyFilter(string patId, string studyUid, string seriesUid, string sopInstance, OrderLevel orderLevel)
{
switch (orderLevel)
{
case OrderLevel.Patient:
return(patId);
//break;
case OrderLevel.Study:
return(patId + separator + studyUid);
//break;
case OrderLevel.Series:
return(patId + separator + studyUid + separator + seriesUid);
//break;
case OrderLevel.Image:
return(patId + separator + studyUid + separator + seriesUid + separator + sopInstance);
default:
// Listener.OnNotify(this, new NotifyEventArgs(ProgressEventType.Error, "DicomRetriever.getDicomCMoveRequest Attempt to request item at unsupported level: " + orderLevel));
return(null);
}
}
public static string MakeKeyFilter(Item item, OrderLevel orderLevel)
{
return(MakeKeyFilter(item.PatientId, item.StudyInstanceUID, item.SeriesInstanceUID, item.SOPInstanceUID, orderLevel));
}
