コード例 #1
0
ファイル: DAL.cs プロジェクト: treilly250/HL7Load
        public List <ExplicitMatch> GetExplicitMatchMappings()
        {
            List <ExplicitMatch> explicitMatchList = new List <ExplicitMatch>();

            SqlCommand    cmd = new SqlCommand();
            SqlDataReader reader;

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection  = SqlConnectionMain;

            // Get previously defined patient ID mappings
            cmd.CommandText = "GetExplicitMatchMappings";
            reader          = cmd.ExecuteReader();
            while (reader.Read())
            {
                ExplicitMatch explicitMatch = new ExplicitMatch();
                explicitMatch.DataLoadMismatchTestId = UtilitiesDAL.ToInt(reader["DataLoadMismatchTestID"]);
                explicitMatch.MatchedToUserId        = UtilitiesDAL.ToInt(reader["MatchedToUserID"]);
                explicitMatch.MatchedToTestId        = UtilitiesDAL.ToInt(reader["MatchedToTestID"]);
                explicitMatchList.Add(explicitMatch);
            }
            reader.Close();

            return(explicitMatchList);
        }
コード例 #2
0
ファイル: DAL.cs プロジェクト: treilly250/HL7Load
        public List<ExplicitMatch> GetExplicitMatchMappings()
        {
            List<ExplicitMatch> explicitMatchList = new List<ExplicitMatch>();

            SqlCommand cmd = new SqlCommand();
            SqlDataReader reader;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = SqlConnectionMain;

            // Get previously defined patient ID mappings
            cmd.CommandText = "GetExplicitMatchMappings";
            reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                ExplicitMatch explicitMatch = new ExplicitMatch();
                explicitMatch.DataLoadMismatchTestId = UtilitiesDAL.ToInt(reader["DataLoadMismatchTestID"]);
                explicitMatch.MatchedToUserId = UtilitiesDAL.ToInt(reader["MatchedToUserID"]);
                explicitMatch.MatchedToTestId = UtilitiesDAL.ToInt(reader["MatchedToTestID"]);
                explicitMatchList.Add(explicitMatch);
            }
            reader.Close();

            return explicitMatchList;
        }