コード例 #1
0
 private static AddressInfo CreateAddressInfoInstance(GeoMessageAddressInfo table)
 {
     return new AddressInfo()
     {
         BuildingFloor = table.BuildingFloor,
         BuildingName = table.BuildingName,
         BuildingRoom = table.BuildingRoom,
         BuildingZone = table.BuildingZone,
         City = table.City,
         Country = table.Country,
         CountryCode = table.CountryCode,
         County = table.County,
         Crossing1 = table.Crossing1,
         Crossing2 = table.Crossing2,
         District = table.District,
         Extension = table.Extension,
         PhoneNumber = table.PhoneNumber,
         PostalCode = table.PostalCode,
         State = table.State,
         Street = table.Street,
         Url = table.Url
     };
 }
コード例 #2
0
        private static GeoMessageAddressInfo GetGeoMessageAddressInfo(Int32 addressInfoID, SqlConnection connection, SqlTransaction transaction)
        {
            var addressInfo = new GeoMessageAddressInfo();

            SqlCommand cmd = new SqlCommand(
                "select Extension, Street, PostalCode, City, County, State, Country, CountryCode, District, BuildingName, BuildingFloor, BuildingRoom, BuildingZone, Crossing1, Crossing2, Url, PhoneNumber from GeoMessageAddressInfo where GeoMessageAddressInfoID = @addressInfoID",
                connection,
                transaction);
            cmd.Parameters.AddWithValue("@addressInfoID", addressInfoID);
            SqlDataReader reader = cmd.ExecuteReader();

            try
            {
                while (reader.Read())
                {
                    String extension = Convert.ToString(reader[0]);
                    String street = Convert.ToString(reader[1]);
                    String postalCode = Convert.ToString(reader[2]);
                    String city = Convert.ToString(reader[3]);
                    String county = Convert.ToString(reader[4]);
                    String state = Convert.ToString(reader[5]);
                    String country = Convert.ToString(reader[6]);
                    String countryCode = Convert.ToString(reader[7]);
                    String district = Convert.ToString(reader[8]);
                    String buildingName = Convert.ToString(reader[9]);
                    String buildingFloor = Convert.ToString(reader[10]);
                    String buildingRoom = Convert.ToString(reader[11]);
                    String buildingZone = Convert.ToString(reader[12]);
                    String crossing1 = Convert.ToString(reader[13]);
                    String crossing2 = Convert.ToString(reader[14]);
                    String url = Convert.ToString(reader[15]);
                    String phoneNumber = Convert.ToString(reader[16]);

                    addressInfo.BuildingFloor = buildingFloor;
                    addressInfo.BuildingName = buildingName;
                    addressInfo.BuildingRoom = buildingRoom;
                    addressInfo.BuildingZone = buildingZone;
                    addressInfo.City = city;
                    addressInfo.Country = country;
                    addressInfo.CountryCode = countryCode;
                    addressInfo.County = county;
                    addressInfo.Crossing1 = crossing1;
                    addressInfo.Crossing2 = crossing2;
                    addressInfo.District = district;
                    addressInfo.Extension = extension;
                    addressInfo.ID = addressInfoID;
                    addressInfo.PhoneNumber = phoneNumber;
                    addressInfo.PostalCode = postalCode;
                    addressInfo.State = state;
                    addressInfo.Street = street;
                    addressInfo.Url = url;
                }
            }
            finally
            {
                if (reader != null)
                    reader.Close();
            }

            return addressInfo;
        }