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