コード例 #1
0
        /// <summary>
        /// UpdateMH
        /// </summary>
        /// <param name="countryId">countryId</param>
        /// <param name="provinceId">provinceId</param>
        /// <param name="countyId">countyId</param>
        /// <param name="cityId">cityId</param>
        /// <param name="mhId">mhId</param>
        /// <param name="originalUsmhAddress">originalUsmhAddress</param>
        /// <param name="newUsmhAddress">newUsmhAddress</param>
        /// <param name="companyId">companyId</param>
        private void UpdateMH(Int64? countryId, Int64? provinceId, Int64? countyId, Int64? cityId, string mhId, string originalAddress, string newAddress, int companyId)
        {
            // Get unchanged data
            // ... mh
            AssetSewerMHGateway assetSewerMHGateway = new AssetSewerMHGateway();
            assetSewerMHGateway.LoadByCountryIdProvinceIdCountyIdCityIdMhId(countryId, provinceId, countyId, cityId, mhId, companyId, "", "", ""); //TODO MH

            // Update mh
            if (assetSewerMHGateway.Table.Rows.Count > 0)
            {
                int originalAssetId = assetSewerMHGateway.GetAssetID(mhId);
                string originalLatitude = assetSewerMHGateway.GetLatitude(mhId);
                string originalLongitude = assetSewerMHGateway.GetLongitude(mhId);
                bool originalDeleted = assetSewerMHGateway.GetDeleted(mhId);
                int originalCompanyId = assetSewerMHGateway.GetCompanyId(mhId);

                string originalManholeShape = assetSewerMHGateway.GetManholeShape(mhId);
                string originalLocation = assetSewerMHGateway.GetLocation(mhId);
                int? originalMaterialID = assetSewerMHGateway.GetMaterialID(mhId);
                string originalTopDiameter = assetSewerMHGateway.GetTopDepth(mhId);
                string originalTopDepth = assetSewerMHGateway.GetTopDepth(mhId);
                string originalTopFloor = assetSewerMHGateway.GetTopFloor(mhId);
                string originalTopCeiling = assetSewerMHGateway.GetTopFloor(mhId);
                string originalTopBenching = assetSewerMHGateway.GetTopBenching(mhId);
                string originalDownDiameter = assetSewerMHGateway.GetDownDiameter(mhId);
                string originalDownDepth = assetSewerMHGateway.GetDownDepth(mhId);
                string originalDownFloor = assetSewerMHGateway.GetDownFloor(mhId);
                string originalDownCeiling = assetSewerMHGateway.GetDownCeiling(mhId);
                string originalDownBenching = assetSewerMHGateway.GetDownBenching(mhId);
                string originalRectangle1LongSide = assetSewerMHGateway.GetRectangle1LongSide(mhId);
                string originalRectangle1ShortSide = assetSewerMHGateway.GetRectangle1ShortSide(mhId);
                string originalRectangle2LongSide = assetSewerMHGateway.GetRectangle2LongSide(mhId);
                string originalRectangle2ShortSide = assetSewerMHGateway.GetRectangle2ShortSide(mhId);
                string originalTopSurfaceArea = assetSewerMHGateway.GetTopSurfaceArea(mhId);
                string originalDownSurfaceArea = assetSewerMHGateway.GetDownSurfaceArea(mhId);
                int? originalManholeRugs = assetSewerMHGateway.GetManholeRugs(mhId);
                string originalTotalDepth = assetSewerMHGateway.GetTotalDepth(mhId);
                string originalTotalSurfaceArea = assetSewerMHGateway.GetTotalSurfaceArea(mhId);

                AssetSewerMH assetSewerMH = new AssetSewerMH(assetSewerMHGateway.Data);
                assetSewerMH.UpdateDirect(originalAssetId, mhId, originalLatitude, originalLongitude, originalAddress, originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, originalDeleted, originalCompanyId, originalAssetId, mhId, originalLatitude, originalLongitude, newAddress,  originalManholeShape, originalLocation, originalMaterialID, originalTopDiameter, originalTopDepth, originalTopFloor, originalTopCeiling, originalTopBenching, originalDownDiameter, originalDownDepth, originalDownFloor, originalDownCeiling, originalDownBenching, originalRectangle1LongSide, originalRectangle1ShortSide, originalRectangle2LongSide, originalRectangle2ShortSide, originalTopSurfaceArea, originalDownSurfaceArea, originalManholeRugs, originalTotalDepth, originalTotalSurfaceArea, originalDeleted, originalCompanyId);
            }
        }