コード例 #1
0
        // JObject here is very very important...
        public ActionResult <string> Post([FromBody] JObject entityObj)
        {
            ORDER_LIST_DETAIL_DICT_NAME postedEntity = entityObj.ToObject <ORDER_LIST_DETAIL_DICT_NAME>();

            // 校验主键
            if (String.IsNullOrEmpty(postedEntity.ORDER_NO))
            {
                return("");
            }

            var orderListEntity = myContext.ORDER_LIST_DETAIL
                                  .Where(d => d.ORDER_NO.Equals(postedEntity.ORDER_NO) && d.BUMP_ID.Equals(postedEntity.BUMP_ID));

            if (orderListEntity.Count() == 0)
            {
                // INSERT
                ORDER_LIST_DETAIL postedEntity1 = new ORDER_LIST_DETAIL();
                postedEntity1.ORDER_NO = postedEntity.ORDER_NO;
                // MAKE BUMP ID
                postedEntity1.BUMP_ID = postedEntity.BUMP_TYPE + "_" + postedEntity.MATERIAL_BUMP;

                postedEntity1.BUMP_NM              = postedEntity.BUMP_NM;
                postedEntity1.BUMP_TYPE            = postedEntity.BUMP_TYPE;
                postedEntity1.NUMBER               = postedEntity.NUMBER;
                postedEntity1.UNIT                 = postedEntity.UNIT;
                postedEntity1.PRICE                = postedEntity.PRICE;
                postedEntity1.AMOUNT               = postedEntity.AMOUNT;
                postedEntity1.BUMP_SERIAL_NO       = postedEntity.BUMP_SERIAL_NO;
                postedEntity1.FLOW                 = postedEntity.FLOW;
                postedEntity1.LIFT                 = postedEntity.LIFT;
                postedEntity1.MATERIAL_BUMP        = postedEntity.MATERIAL_BUMP;
                postedEntity1.MATERIAL_FAN         = postedEntity.MATERIAL_FAN;
                postedEntity1.MATERIAL_ROLLER      = postedEntity.MATERIAL_ROLLER;
                postedEntity1.MOTOR_BRAND          = postedEntity.MOTOR_BRAND;
                postedEntity1.MOTOR_DEMAND         = postedEntity.MOTOR_DEMAND;
                postedEntity1.SEAL_FORM            = postedEntity.SEAL_FORM;
                postedEntity1.SEAL_BRAND           = postedEntity.SEAL_BRAND;
                postedEntity1.ROLLER_BRAND         = postedEntity.ROLLER_BRAND;
                postedEntity1.COUPLING             = postedEntity.COUPLING;
                postedEntity1.SEAL_COOLER          = postedEntity.SEAL_COOLER;
                postedEntity1.CAVITATION_ALLOWANCE = postedEntity.CAVITATION_ALLOWANCE;
                postedEntity1.ACTUAL_BUMP_SPEED    = postedEntity.ACTUAL_BUMP_SPEED;
                postedEntity1.STATION              = postedEntity.STATION;
                postedEntity1.TEMPERATURE          = postedEntity.TEMPERATURE;
                postedEntity1.DENSITY              = postedEntity.DENSITY;
                postedEntity1.IN_PRESSURE          = postedEntity.IN_PRESSURE;
                postedEntity1.MEDIUM               = postedEntity.MEDIUM;
                postedEntity1.VISCOSITY            = postedEntity.VISCOSITY;
                postedEntity1.PARTICULATES         = postedEntity.PARTICULATES;
                postedEntity1.WORKING_PRESSURE     = postedEntity.WORKING_PRESSURE;
                postedEntity1.FLANGES_STANDARD     = postedEntity.FLANGES_STANDARD;
                postedEntity1.FLANGES_LEVEL        = postedEntity.FLANGES_LEVEL;
                postedEntity1.BASE                 = postedEntity.BASE;
                postedEntity1.COUPLING_HOOD        = postedEntity.COUPLING_HOOD;
                postedEntity1.ANCHOR_BOLT          = postedEntity.ANCHOR_BOLT;
                postedEntity1.PAINT                = postedEntity.PAINT;
                postedEntity1.SURFACE_TREATMENT    = postedEntity.SURFACE_TREATMENT;
                postedEntity1.PACKAGE              = postedEntity.PACKAGE;
                postedEntity1.TRANSPORT            = postedEntity.TRANSPORT;
                postedEntity1.SEAL_BRAND_MANUAL    = String.IsNullOrEmpty(postedEntity.SEAL_BRAND_MANUAL) ? "" : postedEntity.SEAL_BRAND_MANUAL;
                myContext.ORDER_LIST_DETAIL.Add(postedEntity1);
                myContext.SaveChanges();
                return("");
            }
            else
            {
                orderListEntity.First().BUMP_NM   = postedEntity.BUMP_NM;
                orderListEntity.First().BUMP_TYPE = postedEntity.BUMP_TYPE;
                orderListEntity.First().NUMBER    = postedEntity.NUMBER;

                orderListEntity.First().UNIT           = postedEntity.UNIT;
                orderListEntity.First().PRICE          = postedEntity.PRICE;
                orderListEntity.First().AMOUNT         = postedEntity.AMOUNT;
                orderListEntity.First().BUMP_SERIAL_NO = postedEntity.BUMP_SERIAL_NO;
                orderListEntity.First().FLOW           = postedEntity.FLOW;
                orderListEntity.First().LIFT           = postedEntity.LIFT;

                orderListEntity.First().MATERIAL_BUMP   = postedEntity.MATERIAL_BUMP;
                orderListEntity.First().MATERIAL_FAN    = postedEntity.MATERIAL_FAN;
                orderListEntity.First().MATERIAL_ROLLER = postedEntity.MATERIAL_ROLLER;
                orderListEntity.First().MOTOR_BRAND     = postedEntity.MOTOR_BRAND;
                orderListEntity.First().MOTOR_DEMAND    = postedEntity.MOTOR_DEMAND;

                orderListEntity.First().SEAL_FORM    = postedEntity.SEAL_FORM;
                orderListEntity.First().SEAL_BRAND   = postedEntity.SEAL_BRAND;
                orderListEntity.First().ROLLER_BRAND = postedEntity.ROLLER_BRAND;
                orderListEntity.First().COUPLING     = postedEntity.COUPLING;
                orderListEntity.First().SEAL_COOLER  = postedEntity.SEAL_COOLER;

                orderListEntity.First().CAVITATION_ALLOWANCE = postedEntity.CAVITATION_ALLOWANCE;
                orderListEntity.First().ACTUAL_BUMP_SPEED    = postedEntity.ACTUAL_BUMP_SPEED;
                orderListEntity.First().STATION     = postedEntity.STATION;
                orderListEntity.First().TEMPERATURE = postedEntity.TEMPERATURE;
                orderListEntity.First().TEMPERATURE = postedEntity.TEMPERATURE;

                orderListEntity.First().IN_PRESSURE      = postedEntity.IN_PRESSURE;
                orderListEntity.First().MEDIUM           = postedEntity.MEDIUM;
                orderListEntity.First().VISCOSITY        = postedEntity.VISCOSITY;
                orderListEntity.First().PARTICULATES     = postedEntity.PARTICULATES;
                orderListEntity.First().WORKING_PRESSURE = postedEntity.WORKING_PRESSURE;

                orderListEntity.First().FLANGES_STANDARD = postedEntity.FLANGES_STANDARD;
                orderListEntity.First().FLANGES_LEVEL    = postedEntity.FLANGES_LEVEL;
                orderListEntity.First().BASE             = postedEntity.BASE;
                orderListEntity.First().COUPLING_HOOD    = postedEntity.COUPLING_HOOD;
                orderListEntity.First().ANCHOR_BOLT      = postedEntity.ANCHOR_BOLT;

                orderListEntity.First().PAINT             = postedEntity.PAINT;
                orderListEntity.First().SURFACE_TREATMENT = postedEntity.SURFACE_TREATMENT;
                orderListEntity.First().PACKAGE           = postedEntity.PACKAGE;
                orderListEntity.First().TRANSPORT         = postedEntity.TRANSPORT;

                orderListEntity.First().SEAL_BRAND_MANUAL = String.IsNullOrEmpty(postedEntity.SEAL_BRAND_MANUAL) ? "" : postedEntity.SEAL_BRAND_MANUAL;
                myContext.SaveChanges();
                return("");
            }
        }
コード例 #2
0
        public ActionResult <string> Post([FromBody] JObject postObj)
        {
            // FROM WEB PAGE
            ORDER_LIST_DETAIL_DICT_NAME     orderListDetailPostEntity          = postObj.GetValue("orderListDetailTableModel").ToObject <ORDER_LIST_DETAIL_DICT_NAME>();
            INNER_ORDER_BASIC_SEAL_MST      innerOrderBasicSealPostEntity      = postObj.GetValue("basicAndSealModel").ToObject <INNER_ORDER_BASIC_SEAL_MST>();
            INNER_ORDER_OTHER_COMPONENT_MST innerOrderOtherComponentPostEntity = postObj.GetValue("otherComponentModel").ToObject <INNER_ORDER_OTHER_COMPONENT_MST>();

            IList innerOrderBOMItemStandard = new ArrayList();
            IList innerOrderBOMItemBase     = new ArrayList();

            if (postObj.GetValue("componentListTableData") != null)
            {
                innerOrderBOMItemStandard = postObj.GetValue("componentListTableData").ToList();
            }

            if (postObj.GetValue("basicPartListTableData") != null)
            {
                innerOrderBOMItemBase = postObj.GetValue("basicPartListTableData").ToList();
            }

            // 校验主键
            if (String.IsNullOrEmpty(orderListDetailPostEntity.ORDER_NO) || String.IsNullOrEmpty(orderListDetailPostEntity.BUMP_ID))
            {
                return("");
            }

            // FROM DB
            // 登录BOM的GRID部分,先用SQL删除对应ID项目,之后批量插入
            myContext.Database.ExecuteSqlCommand("DELETE FROM \"INNER_ORDER_BOM_ITEM_BASE\" WHERE \"ORDER_NO\" = @ORDER_NO AND \"BUMP_ID\" = @BUMP_ID",
                                                 new NpgsqlParameter("@ORDER_NO", orderListDetailPostEntity.ORDER_NO), new NpgsqlParameter("@BUMP_ID", orderListDetailPostEntity.BUMP_ID));
            myContext.Database.ExecuteSqlCommand("DELETE FROM \"INNER_ORDER_BOM_ITEM_STANDARD\" WHERE \"ORDER_NO\" = @ORDER_NO AND \"BUMP_ID\" = @BUMP_ID",
                                                 new NpgsqlParameter("@ORDER_NO", orderListDetailPostEntity.ORDER_NO), new NpgsqlParameter("@BUMP_ID", orderListDetailPostEntity.BUMP_ID));
            foreach (JObject item in innerOrderBOMItemStandard)
            {
                INNER_ORDER_BOM_ITEM_STANDARD itemEntity = item.ToObject <INNER_ORDER_BOM_ITEM_STANDARD>();
                itemEntity.ORDER_NO = orderListDetailPostEntity.ORDER_NO;
                itemEntity.BUMP_ID  = orderListDetailPostEntity.BUMP_ID;
                myContext.INNER_ORDER_BOM_ITEM_STANDARD.AddAsync(itemEntity);
            }
            foreach (JObject item in innerOrderBOMItemBase)
            {
                INNER_ORDER_BOM_ITEM_BASE itemEntity = item.ToObject <INNER_ORDER_BOM_ITEM_BASE>();
                itemEntity.ORDER_NO = orderListDetailPostEntity.ORDER_NO;
                itemEntity.BUMP_ID  = orderListDetailPostEntity.BUMP_ID;
                myContext.INNER_ORDER_BOM_ITEM_BASE.AddAsync(itemEntity);
            }
            myContext.SaveChanges();

            var innerOrderbBasicSealMstEntity = myContext.INNER_ORDER_BASIC_SEAL_MST
                                                .Where(d => d.ORDER_NO.Equals(orderListDetailPostEntity.ORDER_NO) && d.BUMP_ID.Equals(orderListDetailPostEntity.BUMP_ID));

            var innerOrderOtherComponentMstEntity = myContext.INNER_ORDER_OTHER_COMPONENT_MST
                                                    .Where(d => d.ORDER_NO.Equals(orderListDetailPostEntity.ORDER_NO) && d.BUMP_ID.Equals(orderListDetailPostEntity.BUMP_ID));

            if (innerOrderbBasicSealMstEntity.Count() == 0 && innerOrderOtherComponentMstEntity.Count() == 0)
            {
                // 补充项目
                innerOrderBasicSealPostEntity.ORDER_NO             = orderListDetailPostEntity.ORDER_NO;
                innerOrderBasicSealPostEntity.BUMP_ID              = orderListDetailPostEntity.BUMP_ID;
                innerOrderBasicSealPostEntity.BUMP_TYPE            = orderListDetailPostEntity.BUMP_TYPE;
                innerOrderBasicSealPostEntity.BUMP_SERIAL_NO       = orderListDetailPostEntity.BUMP_SERIAL_NO;
                innerOrderBasicSealPostEntity.NUMBER               = orderListDetailPostEntity.NUMBER;
                innerOrderBasicSealPostEntity.FLOW                 = orderListDetailPostEntity.FLOW;
                innerOrderBasicSealPostEntity.LIFT                 = orderListDetailPostEntity.LIFT;
                innerOrderBasicSealPostEntity.STATION              = orderListDetailPostEntity.STATION;
                innerOrderBasicSealPostEntity.MATERIAL_BUMP        = orderListDetailPostEntity.MATERIAL_BUMP;
                innerOrderBasicSealPostEntity.MATERIAL_FAN         = orderListDetailPostEntity.MATERIAL_FAN;
                innerOrderBasicSealPostEntity.MATERIAL_ROLLER      = orderListDetailPostEntity.MATERIAL_ROLLER;
                innerOrderBasicSealPostEntity.SEAL_FORM            = orderListDetailPostEntity.SEAL_FORM_NAME;
                innerOrderBasicSealPostEntity.SEAL_BRAND           = orderListDetailPostEntity.SEAL_BRAND_NAME;
                innerOrderBasicSealPostEntity.SEAL_BRAND_MANUAL    = orderListDetailPostEntity.SEAL_BRAND_MANUAL;
                innerOrderBasicSealPostEntity.NPSH                 = orderListDetailPostEntity.CAVITATION_ALLOWANCE;
                innerOrderBasicSealPostEntity.BUMP_SPEED           = orderListDetailPostEntity.ACTUAL_BUMP_SPEED;
                innerOrderBasicSealPostEntity.TEMPERATURE          = orderListDetailPostEntity.TEMPERATURE;
                innerOrderBasicSealPostEntity.DENSITY              = orderListDetailPostEntity.DENSITY;
                innerOrderBasicSealPostEntity.INLET_PRESSURE       = orderListDetailPostEntity.IN_PRESSURE;
                innerOrderBasicSealPostEntity.MEDIA                = orderListDetailPostEntity.MEDIUM;
                innerOrderBasicSealPostEntity.VISCOSITY            = orderListDetailPostEntity.VISCOSITY;
                innerOrderBasicSealPostEntity.PARTICULATES         = orderListDetailPostEntity.PARTICULATES;
                innerOrderBasicSealPostEntity.WORKING_PRESSURE     = orderListDetailPostEntity.WORKING_PRESSURE;
                innerOrderBasicSealPostEntity.FLANGE_STANDARD      = orderListDetailPostEntity.FLANGES_STANDARD_NAME;
                innerOrderBasicSealPostEntity.FLANGE_LEVEL         = orderListDetailPostEntity.FLANGES_LEVEL_NAME;
                innerOrderBasicSealPostEntity.BEARING_BRAND        = orderListDetailPostEntity.ROLLER_BRAND_NAME;
                innerOrderBasicSealPostEntity.NEED_SEAL_COOLER_FLG = orderListDetailPostEntity.SEAL_COOLER_NAME;


                innerOrderOtherComponentPostEntity.ORDER_NO = orderListDetailPostEntity.ORDER_NO;
                innerOrderOtherComponentPostEntity.BUMP_ID  = orderListDetailPostEntity.BUMP_ID;

                innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_TYPE = orderListDetailPostEntity.MOTOR_BRAND_NAME;
                innerOrderOtherComponentPostEntity.COUPLING_TYPE       = orderListDetailPostEntity.COUPLING_NAME;
                innerOrderOtherComponentPostEntity.BASE_TYPE           = orderListDetailPostEntity.BASE_NAME;
                innerOrderOtherComponentPostEntity.COUPLING_HOOD_TYPE  = orderListDetailPostEntity.COUPLING_HOOD_NAME;
                innerOrderOtherComponentPostEntity.ANCHOR_BOLT_TYPE    = orderListDetailPostEntity.ANCHOR_BOLT_NAME;
                innerOrderOtherComponentPostEntity.COLOR_TYPE          = orderListDetailPostEntity.PAINT_NAME;
                innerOrderOtherComponentPostEntity.SURFACE_TREAT_TYPE  = orderListDetailPostEntity.SURFACE_TREATMENT_NAME;
                innerOrderOtherComponentPostEntity.PACKAGING_TYPE      = orderListDetailPostEntity.PACKAGE_NAME;
                innerOrderOtherComponentPostEntity.TRANSPORT_TYPE      = orderListDetailPostEntity.TRANSPORT_NAME;

                // TODO

                myContext.INNER_ORDER_OTHER_COMPONENT_MST.Add(innerOrderOtherComponentPostEntity);
                myContext.INNER_ORDER_BASIC_SEAL_MST.Add(innerOrderBasicSealPostEntity);
                myContext.SaveChanges();
                return("");
            }
            else
            {
                // 补充项目
                innerOrderbBasicSealMstEntity.First().BUMP_TYPE            = orderListDetailPostEntity.BUMP_TYPE;
                innerOrderbBasicSealMstEntity.First().BUMP_SERIAL_NO       = orderListDetailPostEntity.BUMP_SERIAL_NO;
                innerOrderbBasicSealMstEntity.First().NUMBER               = orderListDetailPostEntity.NUMBER;
                innerOrderbBasicSealMstEntity.First().FLOW                 = orderListDetailPostEntity.FLOW;
                innerOrderbBasicSealMstEntity.First().LIFT                 = orderListDetailPostEntity.LIFT;
                innerOrderbBasicSealMstEntity.First().STATION              = orderListDetailPostEntity.STATION;
                innerOrderbBasicSealMstEntity.First().MATERIAL_BUMP        = orderListDetailPostEntity.MATERIAL_BUMP;
                innerOrderbBasicSealMstEntity.First().MATERIAL_FAN         = orderListDetailPostEntity.MATERIAL_FAN;
                innerOrderbBasicSealMstEntity.First().MATERIAL_ROLLER      = orderListDetailPostEntity.MATERIAL_ROLLER;
                innerOrderbBasicSealMstEntity.First().SEAL_FORM            = orderListDetailPostEntity.SEAL_FORM_NAME;
                innerOrderbBasicSealMstEntity.First().SEAL_BRAND           = orderListDetailPostEntity.SEAL_BRAND_NAME;
                innerOrderbBasicSealMstEntity.First().SEAL_BRAND_MANUAL    = orderListDetailPostEntity.SEAL_BRAND_MANUAL;
                innerOrderbBasicSealMstEntity.First().NPSH                 = orderListDetailPostEntity.CAVITATION_ALLOWANCE;
                innerOrderbBasicSealMstEntity.First().BUMP_SPEED           = orderListDetailPostEntity.ACTUAL_BUMP_SPEED;
                innerOrderbBasicSealMstEntity.First().TEMPERATURE          = orderListDetailPostEntity.TEMPERATURE;
                innerOrderbBasicSealMstEntity.First().DENSITY              = orderListDetailPostEntity.DENSITY;
                innerOrderbBasicSealMstEntity.First().INLET_PRESSURE       = orderListDetailPostEntity.IN_PRESSURE;
                innerOrderbBasicSealMstEntity.First().MEDIA                = orderListDetailPostEntity.MEDIUM;
                innerOrderbBasicSealMstEntity.First().VISCOSITY            = orderListDetailPostEntity.VISCOSITY;
                innerOrderbBasicSealMstEntity.First().PARTICULATES         = orderListDetailPostEntity.PARTICULATES;
                innerOrderbBasicSealMstEntity.First().WORKING_PRESSURE     = orderListDetailPostEntity.WORKING_PRESSURE;
                innerOrderbBasicSealMstEntity.First().FLANGE_STANDARD      = orderListDetailPostEntity.FLANGES_STANDARD_NAME;
                innerOrderbBasicSealMstEntity.First().FLANGE_LEVEL         = orderListDetailPostEntity.FLANGES_LEVEL_NAME;
                innerOrderbBasicSealMstEntity.First().BEARING_BRAND        = orderListDetailPostEntity.ROLLER_BRAND_NAME;
                innerOrderbBasicSealMstEntity.First().NEED_SEAL_COOLER_FLG = orderListDetailPostEntity.SEAL_COOLER_NAME;

                innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_TYPE = orderListDetailPostEntity.MOTOR_BRAND_NAME;
                innerOrderOtherComponentMstEntity.First().COUPLING_TYPE       = orderListDetailPostEntity.COUPLING_NAME;
                innerOrderOtherComponentMstEntity.First().BASE_TYPE           = orderListDetailPostEntity.BASE_NAME;
                innerOrderOtherComponentMstEntity.First().COUPLING_HOOD_TYPE  = orderListDetailPostEntity.COUPLING_HOOD_NAME;
                innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_TYPE    = orderListDetailPostEntity.ANCHOR_BOLT_NAME;
                innerOrderOtherComponentMstEntity.First().COLOR_TYPE          = orderListDetailPostEntity.PAINT_NAME;
                innerOrderOtherComponentMstEntity.First().SURFACE_TREAT_TYPE  = orderListDetailPostEntity.SURFACE_TREATMENT_NAME;
                innerOrderOtherComponentMstEntity.First().PACKAGING_TYPE      = orderListDetailPostEntity.PACKAGE_NAME;
                innerOrderOtherComponentMstEntity.First().TRANSPORT_TYPE      = orderListDetailPostEntity.TRANSPORT_NAME;

                // 其他项目

                innerOrderbBasicSealMstEntity.First().TEST_PRESSURE        = innerOrderBasicSealPostEntity.TEST_PRESSURE;
                innerOrderbBasicSealMstEntity.First().SUPPRESS_PRESSURE    = innerOrderBasicSealPostEntity.SUPPRESS_PRESSURE;
                innerOrderbBasicSealMstEntity.First().SEAL_TYPE            = innerOrderBasicSealPostEntity.SEAL_TYPE;
                innerOrderbBasicSealMstEntity.First().SEAL_MODEL           = innerOrderBasicSealPostEntity.SEAL_MODEL;
                innerOrderbBasicSealMstEntity.First().SEAL_MATERIAL        = innerOrderBasicSealPostEntity.SEAL_MATERIAL;
                innerOrderbBasicSealMstEntity.First().ABD_SEAL_INFO        = innerOrderBasicSealPostEntity.ABD_SEAL_INFO;
                innerOrderbBasicSealMstEntity.First().OTHER_SEAL_PROVIDER  = innerOrderBasicSealPostEntity.OTHER_SEAL_PROVIDER;
                innerOrderbBasicSealMstEntity.First().OTHER_SEAL_INFO      = innerOrderBasicSealPostEntity.OTHER_SEAL_INFO;
                innerOrderbBasicSealMstEntity.First().OTHER_SEAL_MODEL     = innerOrderBasicSealPostEntity.OTHER_SEAL_MODEL;
                innerOrderbBasicSealMstEntity.First().NEED_SEAL_COOLER_FLG = innerOrderBasicSealPostEntity.NEED_SEAL_COOLER_FLG;
                innerOrderbBasicSealMstEntity.First().SEAL_COOLER_MODEL    = innerOrderBasicSealPostEntity.SEAL_COOLER_MODEL;
                innerOrderbBasicSealMstEntity.First().BEARING_BRAND        = innerOrderBasicSealPostEntity.BEARING_BRAND;
                innerOrderbBasicSealMstEntity.First().BEARING_OTHER_INFO   = innerOrderBasicSealPostEntity.BEARING_OTHER_INFO;
                innerOrderbBasicSealMstEntity.First().INSTALL_DIRECTION    = innerOrderBasicSealPostEntity.INSTALL_DIRECTION;
                innerOrderbBasicSealMstEntity.First().DOUBLE_SEAL_PRESSURE = innerOrderBasicSealPostEntity.DOUBLE_SEAL_PRESSURE;
                innerOrderbBasicSealMstEntity.First().SERIES                    = innerOrderBasicSealPostEntity.SERIES;
                innerOrderbBasicSealMstEntity.First().MAIN_SHAFT_FORM           = innerOrderBasicSealPostEntity.MAIN_SHAFT_FORM;
                innerOrderbBasicSealMstEntity.First().PUMP_STEERING             = innerOrderBasicSealPostEntity.PUMP_STEERING;
                innerOrderbBasicSealMstEntity.First().ASSEMBLE_DIRECTION        = innerOrderBasicSealPostEntity.ASSEMBLE_DIRECTION;
                innerOrderbBasicSealMstEntity.First().LINE_LOCATION_DESCRIPTION = innerOrderBasicSealPostEntity.LINE_LOCATION_DESCRIPTION;
                innerOrderbBasicSealMstEntity.First().DRAWING_CONFIRM           = innerOrderBasicSealPostEntity.DRAWING_CONFIRM;
                innerOrderbBasicSealMstEntity.First().LUBRICATING_FORM          = innerOrderBasicSealPostEntity.LUBRICATING_FORM;

                innerOrderOtherComponentMstEntity.First().BASE_TYPE                    = innerOrderOtherComponentPostEntity.BASE_TYPE;
                innerOrderOtherComponentMstEntity.First().BASE_SPEC                    = innerOrderOtherComponentPostEntity.BASE_SPEC;
                innerOrderOtherComponentMstEntity.First().SPECIAL_BASE_DETAIL          = innerOrderOtherComponentPostEntity.SPECIAL_BASE_DETAIL;
                innerOrderOtherComponentMstEntity.First().COUPLING_HOOD_TYPE           = innerOrderOtherComponentPostEntity.COUPLING_HOOD_TYPE;
                innerOrderOtherComponentMstEntity.First().COUPLING_HOOD_SPEC           = innerOrderOtherComponentPostEntity.COUPLING_HOOD_SPEC;
                innerOrderOtherComponentMstEntity.First().SPECIAL_HOOD_TYPE_DETAIL     = innerOrderOtherComponentPostEntity.SPECIAL_HOOD_TYPE_DETAIL;
                innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_TYPE             = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_TYPE;
                innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_SPEC             = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_SPEC;
                innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_MATERIAL         = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_MATERIAL;
                innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_EXTRA_NUT_SPEC   = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_EXTRA_NUT_SPEC;
                innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_EXTRA_PAD_SPEC   = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_EXTRA_PAD_SPEC;
                innerOrderOtherComponentMstEntity.First().ANCHOR_BOLT_NUM              = innerOrderOtherComponentPostEntity.ANCHOR_BOLT_NUM;
                innerOrderOtherComponentMstEntity.First().COUPLING_TYPE                = innerOrderOtherComponentPostEntity.COUPLING_TYPE;
                innerOrderOtherComponentMstEntity.First().COUPLING_BUMP_COUPLET        = innerOrderOtherComponentPostEntity.COUPLING_BUMP_COUPLET;
                innerOrderOtherComponentMstEntity.First().COUPLING_ELECTRIC_COUPLET    = innerOrderOtherComponentPostEntity.COUPLING_ELECTRIC_COUPLET;
                innerOrderOtherComponentMstEntity.First().COUPLING_PIN                 = innerOrderOtherComponentPostEntity.COUPLING_PIN;
                innerOrderOtherComponentMstEntity.First().COUPLING_JUMP_RING           = innerOrderOtherComponentPostEntity.COUPLING_JUMP_RING;
                innerOrderOtherComponentMstEntity.First().COUPLING_PROVIDER            = innerOrderOtherComponentPostEntity.COUPLING_PROVIDER;
                innerOrderOtherComponentMstEntity.First().COUPLING_SPEC                = innerOrderOtherComponentPostEntity.COUPLING_SPEC;
                innerOrderOtherComponentMstEntity.First().COUPLING_NUM                 = innerOrderOtherComponentPostEntity.COUPLING_NUM;
                innerOrderOtherComponentMstEntity.First().SPECIAL_COUPLING_TYPE_DETAIL = innerOrderOtherComponentPostEntity.SPECIAL_COUPLING_TYPE_DETAIL;
                innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_TYPE          = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_TYPE;
                innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_PROVIDER      = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_PROVIDER;
                innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_POWER         = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_POWER;
                innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_SPEED         = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_SPEED;
                innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_PFV           = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_PFV;
                innerOrderOtherComponentMstEntity.First().ELECTRIC_MOTER_EXTRA_INFO    = innerOrderOtherComponentPostEntity.ELECTRIC_MOTER_EXTRA_INFO;
                innerOrderOtherComponentMstEntity.First().COLOR_TYPE                   = innerOrderOtherComponentPostEntity.COLOR_TYPE;
                innerOrderOtherComponentMstEntity.First().SPECIAL_COLOR_DETAIL         = innerOrderOtherComponentPostEntity.SPECIAL_COLOR_DETAIL;
                innerOrderOtherComponentMstEntity.First().SURFACE_TREAT_TYPE           = innerOrderOtherComponentPostEntity.SURFACE_TREAT_TYPE;
                innerOrderOtherComponentMstEntity.First().SURFACE_TREAT_EXTRA_INFO     = innerOrderOtherComponentPostEntity.SURFACE_TREAT_EXTRA_INFO;
                innerOrderOtherComponentMstEntity.First().TRANSPORT_TYPE               = innerOrderOtherComponentPostEntity.TRANSPORT_TYPE;
                innerOrderOtherComponentMstEntity.First().TRANSPORT_PLACE              = innerOrderOtherComponentPostEntity.TRANSPORT_PLACE;
                innerOrderOtherComponentMstEntity.First().PACKAGING_TYPE               = innerOrderOtherComponentPostEntity.PACKAGING_TYPE;
                innerOrderOtherComponentMstEntity.First().SPECIAL_PACK_DETAIL          = innerOrderOtherComponentPostEntity.SPECIAL_PACK_DETAIL;
                innerOrderOtherComponentMstEntity.First().NEED_FUME_CERTIFICATE        = innerOrderOtherComponentPostEntity.NEED_FUME_CERTIFICATE;
                innerOrderOtherComponentMstEntity.First().ADDRESS_INFO                 = innerOrderOtherComponentPostEntity.ADDRESS_INFO;
                innerOrderOtherComponentMstEntity.First().REMARK = innerOrderOtherComponentPostEntity.REMARK;

                myContext.SaveChanges();
                return("");
            }
        }