public static List <Listener> GetListeners()
{
try
{
List <Listener> ListenerList = new List <Listener>();
List <SqlWrapper> lstSqlWrapper = new List <SqlWrapper>();
SqlWrapper sqlWrapper = new SqlWrapper();
string strSQL = @"Select * from T_Listen";
sqlWrapper.SqlString = strSQL;
DataSet ds = SQLServerHelper.ExecuteQuery(sqlWrapper, QCConnectionType.PrintSystem);
foreach (DataRow row in ds.Tables[0].Rows)
{
Listener listener = new Listener();
listener.ListenIP = row["IP"].ToString().Trim();
listener.ListenPort = Convert.ToInt32(row["Port"].ToString().Trim());
listener.AETitle = row["AETitle"].ToString().Trim();
ListenerList.Add(listener);
}
return(ListenerList);
}
catch (Exception ex)
{
return(null);
}
}
public static List <MonitorClient> GetMonitors()
{
try
{
List <MonitorClient> monitorList = new List <MonitorClient>();
List <SqlWrapper> lstSqlWrapper = new List <SqlWrapper>();
SqlWrapper sqlWrapper = new SqlWrapper();
string strSQL = @"Select * from T_Monitor";
sqlWrapper.SqlString = strSQL;
DataSet ds = SQLServerHelper.ExecuteQuery(sqlWrapper, QCConnectionType.PrintSystem);
foreach (DataRow row in ds.Tables[0].Rows)
{
MonitorClient monitor = new MonitorClient();
monitor.CallingIP = row["CallingIP"].ToString().Trim();
monitor.CallingAETitle = row["CallingAETitle"].ToString().Trim();
monitor.CallingDeviceType = row["CallingDeviceType"].ToString().Trim();
monitor.CallingDeviceName = row["CallingDeviceName"].ToString().Trim();
monitor.MonitorIP = row["MonitorIP"].ToString().Trim();
monitor.MonitorPort = Convert.ToInt32(row["MonitorPort"].ToString().Trim());
monitorList.Add(monitor);
}
return(monitorList);
}
catch (Exception ex)
{
return(null);
}
}
public List <PrintTag> GetPrintTagFromDBByAutoID(string autoID)
{
try
{
List <PrintTag> printTagList = new List <PrintTag>();
List <SqlWrapper> lstSqlWrapper = new List <SqlWrapper>();
SqlWrapper sqlWrapper = new SqlWrapper();
string strSQL = string.Format("Select * from T_PrintTag where AutoID = '{0}' order by ImageUID", autoID);
List <SqlParameter> lstParas = new List <SqlParameter>();
lstParas.Add(new SqlParameter("@AutoID", autoID));
sqlWrapper.SqlString = strSQL;
sqlWrapper.Parameter = lstParas.ToArray();
DataSet ds = SQLServerHelper.ExecuteQuery(sqlWrapper, QCConnectionType.PrintSystem);
foreach (DataRow row in ds.Tables[0].Rows)
{
//DataRow row = ds.Tables[0].Rows[0];
PrintTag printTag = new PrintTag();
printTag.AutoUID = row["AutoID"].ToString().Trim();
printTag.BorderDensity = row["BorderDensity"].ToString().Trim();
printTag.CalledAE = row["CalledAE"].ToString().Trim();
printTag.CallingAE = row["CallingAE"].ToString().Trim();
printTag.CallingIPAddress = IPAddress.Parse(row["CallingIP"].ToString().Trim());
printTag.DicomFilePath = row["FilePath"].ToString().Trim();
printTag.EmptyImageDensity = row["EmptyImageDensity"].ToString().Trim();
printTag.FilmOrienation = row["FilmOrientation"].ToString().Trim();
printTag.FilmSizeID = row["FilmSize"].ToString().Trim();
printTag.ImageBoxPosition = Convert.ToInt32(row["ImageUID"].ToString().Trim());
printTag.ImageDisplayFormat = row["DisplayFormat"].ToString().Trim();
printTag.MagnificationType = row["MagnificationType"].ToString().Trim();
printTag.MaxDensity = Convert.ToUInt16(row["MaxDensity"].ToString().Trim());
printTag.MinDensity = Convert.ToUInt16(row["MinDensity"].ToString().Trim());
printTag.NumberOfCopies = Convert.ToInt32(row["Copies"].ToString().Trim());
printTag.PresentationLut = row["PresentationLUT"].ToString().Trim();
printTag.printUID = row["PrintUID"].ToString().Trim();
//printTag.SamplesPerPixel = row["BorderDensity"].ToString().Trim();
printTag.SmoothingType = row["SmoothingType"].ToString().Trim();
printTag.Trim = row["Trim"].ToString().Trim();
printTagList.Add(printTag);
}
return(printTagList);
}
catch (Exception ex)
{
return(null);
}
}
public static List <MonitorClient> GetMonitorsByCallingSide(IPAddress callingIPAddress, string callingAETitle)
{
try
{
List <MonitorClient> monitorList = new List <MonitorClient>();
List <SqlWrapper> lstSqlWrapper = new List <SqlWrapper>();
SqlWrapper sqlWrapper = new SqlWrapper();
string strSQL = string.Format("Select * from T_Monitor where CallingIP = '{0}' and CallingAETitle = '{1}'", callingIPAddress.ToString(), callingAETitle);
List <SqlParameter> lstParas = new List <SqlParameter>();
lstParas.Add(new SqlParameter("@CallingIP", callingIPAddress.ToString()));
lstParas.Add(new SqlParameter("@CallingAETitle", callingAETitle));
sqlWrapper.SqlString = strSQL;
sqlWrapper.Parameter = lstParas.ToArray();
DataSet ds = SQLServerHelper.ExecuteQuery(sqlWrapper, QCConnectionType.PrintSystem);
foreach (DataRow row in ds.Tables[0].Rows)
{
MonitorClient monitor = new MonitorClient();
monitor.CallingIP = row["CallingIP"].ToString().Trim();
monitor.CallingAETitle = row["CallingAETitle"].ToString().Trim();
monitor.CallingDeviceType = row["CallingDeviceType"].ToString().Trim();
monitor.CallingDeviceName = row["CallingDeviceName"].ToString().Trim();
monitor.MonitorIP = row["MonitorIP"].ToString().Trim();
monitor.MonitorPort = Convert.ToInt32(row["MonitorPort"].ToString().Trim());
monitorList.Add(monitor);
}
return(monitorList);
}
catch (Exception ex)
{
return(null);
}
}