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