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