SQL错乱 返回

.net core 中更新和查询时，SQL错乱！业务量大的时候，把动态SQL，映射成表处理

UPDATE  (SELECT MO.IMO_ID, MO.SO_ID, MO.BC_ID, MO.IMD_CODE, MO.IMD_LINE_ID, MO.IMD_LINE_CODE, MO.IMD_LINE_STATE, MO.IMD_TYPE, MO.IMD_TYPE_ID, MO.IMD_TYPE_NAME, BS.BC_CODE,MO.IMD_CUSTOMER_ID, MO.

                        IMD_CUSTOMER_NAME, MO.IMD_SHIPMENT, MO.IMD_PROVINCE, MO.IMD_CITY, MO.IMD_LOCATION_ID, MO.IMD_LOCATION_DESC, MO.IMD_SALE_ORDER, MO.IMD_SALE_ORDER_LINE, MO.IMD_SALE_QTY, MO.

                        IMD_SALE_SHIPPED_QTY, MO.IMD_MI_ITEM_ID, MO.IMD_MI_CODE, MO.IMD_MI_NAME, MO.IMD_WH_FROM, MO.IMD_II_FROM, MO.IMD_WH_TO, MO.IMD_II_TO, MO.IMD_REQUEST_QTY, MO.IMD_DELIVERED_QTY, 

                        MO.IMD_REQUIRED_DATE, MO.IMD_OLD_ITEM_CODE, MO.IMD_CREATER, MO.IMD_CREAT_TIME, MO.IMD_LAST_UPDATER, MO.IMD_LAST_UPDATE_TIME, MO.IMD_TAKE_COUNT, MO.IMD_STATE, MO.IMD_OUT_TIME, 

                        MO.IMD_OPERATOR_ID, MO.IMD_OPERATOR_NAME, MO.SYNC_TIME, MO.UPLOAD_TIME, MO.UPLOAD_STATE, MO.UPLOADER, MO.ISDEL, MO.CREATOR_ID, MO.CREATOR_NAME, MO.LAST_UPDATE_TIME, MO.

                        LAST_UPDATER, MO.REMARK, MO.BMI_ID, MO.UPLOAD_MSG,MO.IMD_REL_ORDER_NUM , (

                        SELECT

                        NVL (

                        SUM (INVQ.ONHAND_QUANTITY),

                        0

                        )

                        FROM

                        CUX_ONHAND_QUANTITIES_V INVQ

                        WHERE

                        MO.IMD_MI_ITEM_ID = INVQ.INVENTORY_ITEM_ID

                        AND INVQ.ORGANIZATION_ID = MO.SO_ID

                        ) INVQTY, 0 ONROADQTY ,

                        ( SELECT NVL(SUM(IPD.IPD_SUGGEST_QTY), 0) 

                        FROM INV_PACKING_DTL IPD WHERE IPD.IPD_MIID = MO.BMI_ID 

                        AND IPD.ISDEL = 0 

                        AND IPD.IPD_OUT_STATE < 3 

                        AND IPD.UPLOAD_STATE < 3 ) WAITQTY 

                        FROM INV_MOVE_ORDER MO 

                        LEFT JOIN SYS_ROLE_ORG SRO 

                        ON MO.SO_ID = SRO.SO_ID 

                        LEFT JOIN BASE_CUSTOM BS 

                        ON MO.IMD_CUSTOMER_ID = BS.BC_ID 

                        LEFT JOIN SYS_USER_ROLE SUR 

                        ON SRO.SR_ID = SUR.SR_ID 

                        LEFT JOIN CUX_ONHAND_QUANTITIES_V INVQ 

                        ON MO.IMD_MI_ITEM_ID = INVQ.INVENTORY_ITEM_ID 

                        AND INVQ.ORGANIZATION_ID = MO.SO_ID 

                        WHERE MO.ISDEL = 0  AND SUR.SU_ID = 3934 AND MO.IMD_LINE_STATE in( 3,7) AND MO.IMD_STATE = 3 AND MO.IMD_TYPE = 1 GROUP BY MO.IMO_ID, MO.SO_ID, MO.BC_ID, MO.IMD_CODE, MO.IMD_LINE_ID, MO.IMD_LINE_CODE, MO.IMD_LINE_STATE, MO.IMD_TYPE, MO.IMD_TYPE_ID, MO.IMD_TYPE_NAME,BS.BC_CODE, MO.IMD_CUSTOMER_ID, MO.

                    IMD_CUSTOMER_NAME, MO.IMD_SHIPMENT, MO.IMD_PROVINCE, MO.IMD_CITY, MO.IMD_LOCATION_ID, MO.IMD_LOCATION_DESC, MO.IMD_SALE_ORDER, MO.IMD_SALE_ORDER_LINE, MO.IMD_SALE_QTY, MO.

                    IMD_SALE_SHIPPED_QTY, MO.IMD_MI_ITEM_ID, MO.IMD_MI_CODE, MO.IMD_MI_NAME, MO.IMD_WH_FROM, MO.IMD_II_FROM, MO.IMD_WH_TO, MO.IMD_II_TO, MO.IMD_REQUEST_QTY, MO.IMD_DELIVERED_QTY, 

                    MO.IMD_REQUIRED_DATE, MO.IMD_OLD_ITEM_CODE, MO.IMD_CREATER, MO.IMD_CREAT_TIME, MO.IMD_LAST_UPDATER, MO.IMD_LAST_UPDATE_TIME, MO.IMD_TAKE_COUNT, MO.IMD_STATE, MO.IMD_OUT_TIME, 

                    MO.IMD_OPERATOR_ID, MO.IMD_OPERATOR_NAME, MO.SYNC_TIME, MO.UPLOAD_TIME, MO.UPLOAD_STATE, MO.UPLOADER, MO.ISDEL, MO.CREATOR_ID, MO.CREATOR_NAME, MO.LAST_UPDATE_TIME, MO.

                    LAST_UPDATER, MO.REMARK, MO.BMI_ID, MO.UPLOAD_MSG,MO.IMD_REL_ORDER_NUM  ORDER BY MO.IMO_ID DESC ) t  SET "BC_ID"=N'113643',"BMI_ID"=N'315697',"SO_ID"=N'123',"CREATOR_ID"=N'0',"CREATOR_NAME"=N'ADMIN',"IMD_CITY"=N'郑州市',"IMD_CODE"=N'553709',"IMD_CREATER"=N'WUMF',"IMD_CREAT_TIME"=to_date('2019-03-22 10:03:53', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_CUSTOMER_ID"=N'113643',"IMD_CUSTOMER_NAME"=N'东风汽车有限公司东风启辰汽车公司',"IMD_CUSTOMER_MICODE"=N'165542FL0B',"IMD_DELIVERED_QTY"=NULL,"IMD_II_FROM"=NULL,"IMD_II_TO"=NULL,"IMD_LAST_UPDATER"=N'LOG_AUT',"IMD_LAST_UPDATE_TIME"=to_date('2019-03-22 10:06:25', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_LINE_CODE"=N'1.1',"IMD_LINE_ID"=N'816306',"IMD_LINE_STATE"=N'7',"IMD_LOCATION_DESC"=N'郑州市经济开发区第八大街369号东风日产乘用车公司郑州工厂国产件仓库',"IMD_LOCATION_ID"=N'14884',"IMD_MI_CODE"=N'A540039301',"IMD_MI_ITEM_ID"=N'137208',"IMD_MI_NAME"=N'进气管2.0L总成(带包装)',"IMD_OLD_ITEM_CODE"=NULL,"IMD_OPERATOR_ID"=N'3934',"IMD_OPERATOR_NAME"=N'武汉成品库-熊昌华',"IMD_OUT_TIME"=to_date('2019-03-25 11:56:22', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_PROVINCE"=N'河南',"IMD_REQUEST_QTY"=N'36',"IMD_REQUIRED_DATE"=to_date('2019-03-30 23:59:00', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_SALE_ORDER"=N'211003065',"IMD_SALE_ORDER_LINE"=N'14',"IMD_SALE_QTY"=N'36',"IMD_SALE_SHIPPED_QTY"=NULL,"IMD_SHIPMENT"=N'客户自提',"IMD_STATE"=N'3',"IMD_TAKE_COUNT"=N'36',"IMD_TYPE"=N'1',"IMD_TYPE_ID"=N'3',"IMD_TYPE_NAME"=N'挑库通知',"IMD_WH_FROM"=N'586',"IMD_WH_TO"=N'585',"ISDEL"=N'0',"LAST_UPDATER"=N'XIONGCH',"LAST_UPDATE_TIME"=to_date('2019-03-25 11:56:22', 'YYYY-MM-DD HH24:MI:SS') ,"REMARK"=NULL,"SYNC_TIME"=to_date('2019-03-22 10:07:27', 'YYYY-MM-DD HH24:MI:SS') ,"UPLOADER"=NULL,"UPLOAD_STATE"=N'0',"UPLOAD_TIME"=NULL,"UPLOAD_MSG"=NULL,"IMD_REL_ORDER_NUM"=NULL WHERE  "IMO_ID"=N'2853385';

UPDATE  (SELECT MO.IMO_ID, MO.SO_ID, MO.BC_ID, MO.IMD_CODE, MO.IMD_LINE_ID, MO.IMD_LINE_CODE, MO.IMD_LINE_STATE, MO.IMD_TYPE, MO.IMD_TYPE_ID, MO.IMD_TYPE_NAME, BS.BC_CODE,MO.IMD_CUSTOMER_ID, MO.

                        IMD_CUSTOMER_NAME, MO.IMD_SHIPMENT, MO.IMD_PROVINCE, MO.IMD_CITY, MO.IMD_LOCATION_ID, MO.IMD_LOCATION_DESC, MO.IMD_SALE_ORDER, MO.IMD_SALE_ORDER_LINE, MO.IMD_SALE_QTY, MO.

                        IMD_SALE_SHIPPED_QTY, MO.IMD_MI_ITEM_ID, MO.IMD_MI_CODE, MO.IMD_MI_NAME, MO.IMD_WH_FROM, MO.IMD_II_FROM, MO.IMD_WH_TO, MO.IMD_II_TO, MO.IMD_REQUEST_QTY, MO.IMD_DELIVERED_QTY, 

                        MO.IMD_REQUIRED_DATE, MO.IMD_OLD_ITEM_CODE, MO.IMD_CREATER, MO.IMD_CREAT_TIME, MO.IMD_LAST_UPDATER, MO.IMD_LAST_UPDATE_TIME, MO.IMD_TAKE_COUNT, MO.IMD_STATE, MO.IMD_OUT_TIME, 

                        MO.IMD_OPERATOR_ID, MO.IMD_OPERATOR_NAME, MO.SYNC_TIME, MO.UPLOAD_TIME, MO.UPLOAD_STATE, MO.UPLOADER, MO.ISDEL, MO.CREATOR_ID, MO.CREATOR_NAME, MO.LAST_UPDATE_TIME, MO.

                        LAST_UPDATER, MO.REMARK, MO.BMI_ID, MO.UPLOAD_MSG,MO.IMD_REL_ORDER_NUM , (

                        SELECT

                        NVL (

                        SUM (INVQ.ONHAND_QUANTITY),

                        0

                        )

                        FROM

                        CUX_ONHAND_QUANTITIES_V INVQ

                        WHERE

                        MO.IMD_MI_ITEM_ID = INVQ.INVENTORY_ITEM_ID

                        AND INVQ.ORGANIZATION_ID = MO.SO_ID

                        ) INVQTY, 0 ONROADQTY ,

                        ( SELECT NVL(SUM(IPD.IPD_SUGGEST_QTY), 0) 

                        FROM INV_PACKING_DTL IPD WHERE IPD.IPD_MIID = MO.BMI_ID 

                        AND IPD.ISDEL = 0 

                        AND IPD.IPD_OUT_STATE < 3 

                        AND IPD.UPLOAD_STATE < 3 ) WAITQTY 

                        FROM INV_MOVE_ORDER MO 

                        LEFT JOIN SYS_ROLE_ORG SRO 

                        ON MO.SO_ID = SRO.SO_ID 

                        LEFT JOIN BASE_CUSTOM BS 

                        ON MO.IMD_CUSTOMER_ID = BS.BC_ID 

                        LEFT JOIN SYS_USER_ROLE SUR 

                        ON SRO.SR_ID = SUR.SR_ID 

                        LEFT JOIN CUX_ONHAND_QUANTITIES_V INVQ 

                        ON MO.IMD_MI_ITEM_ID = INVQ.INVENTORY_ITEM_ID 

                        AND INVQ.ORGANIZATION_ID = MO.SO_ID 

                        WHERE MO.ISDEL = 0  AND SUR.SU_ID = 3934 AND MO.IMD_LINE_STATE in( 3,7) AND MO.IMD_STATE = 3 AND MO.IMD_TYPE = 1 GROUP BY MO.IMO_ID, MO.SO_ID, MO.BC_ID, MO.IMD_CODE, MO.IMD_LINE_ID, MO.IMD_LINE_CODE, MO.IMD_LINE_STATE, MO.IMD_TYPE, MO.IMD_TYPE_ID, MO.IMD_TYPE_NAME,BS.BC_CODE, MO.IMD_CUSTOMER_ID, MO.

                    IMD_CUSTOMER_NAME, MO.IMD_SHIPMENT, MO.IMD_PROVINCE, MO.IMD_CITY, MO.IMD_LOCATION_ID, MO.IMD_LOCATION_DESC, MO.IMD_SALE_ORDER, MO.IMD_SALE_ORDER_LINE, MO.IMD_SALE_QTY, MO.

                    IMD_SALE_SHIPPED_QTY, MO.IMD_MI_ITEM_ID, MO.IMD_MI_CODE, MO.IMD_MI_NAME, MO.IMD_WH_FROM, MO.IMD_II_FROM, MO.IMD_WH_TO, MO.IMD_II_TO, MO.IMD_REQUEST_QTY, MO.IMD_DELIVERED_QTY, 

                    MO.IMD_REQUIRED_DATE, MO.IMD_OLD_ITEM_CODE, MO.IMD_CREATER, MO.IMD_CREAT_TIME, MO.IMD_LAST_UPDATER, MO.IMD_LAST_UPDATE_TIME, MO.IMD_TAKE_COUNT, MO.IMD_STATE, MO.IMD_OUT_TIME, 

                    MO.IMD_OPERATOR_ID, MO.IMD_OPERATOR_NAME, MO.SYNC_TIME, MO.UPLOAD_TIME, MO.UPLOAD_STATE, MO.UPLOADER, MO.ISDEL, MO.CREATOR_ID, MO.CREATOR_NAME, MO.LAST_UPDATE_TIME, MO.

                    LAST_UPDATER, MO.REMARK, MO.BMI_ID, MO.UPLOAD_MSG,MO.IMD_REL_ORDER_NUM  ORDER BY MO.IMO_ID DESC ) t  SET "BC_ID"=N'113643',"BMI_ID"=N'315697',"SO_ID"=N'123',"CREATOR_ID"=N'0',"CREATOR_NAME"=N'ADMIN',"IMD_CITY"=N'郑州市',"IMD_CODE"=N'553709',"IMD_CREATER"=N'WUMF',"IMD_CREAT_TIME"=to_date('2019-03-22 10:03:53', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_CUSTOMER_ID"=N'113643',"IMD_CUSTOMER_NAME"=N'东风汽车有限公司东风启辰汽车公司',"IMD_CUSTOMER_MICODE"=N'165542FL0B',"IMD_DELIVERED_QTY"=NULL,"IMD_II_FROM"=NULL,"IMD_II_TO"=NULL,"IMD_LAST_UPDATER"=N'LOG_AUT',"IMD_LAST_UPDATE_TIME"=to_date('2019-03-22 10:06:25', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_LINE_CODE"=N'2.1',"IMD_LINE_ID"=N'816307',"IMD_LINE_STATE"=N'7',"IMD_LOCATION_DESC"=N'郑州市经济开发区第八大街369号东风日产乘用车公司郑州工厂国产件仓库',"IMD_LOCATION_ID"=N'14884',"IMD_MI_CODE"=N'A540039301',"IMD_MI_ITEM_ID"=N'137208',"IMD_MI_NAME"=N'进气管2.0L总成(带包装)',"IMD_OLD_ITEM_CODE"=NULL,"IMD_OPERATOR_ID"=N'3934',"IMD_OPERATOR_NAME"=N'武汉成品库-熊昌华',"IMD_OUT_TIME"=to_date('2019-03-25 11:56:22', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_PROVINCE"=N'河南',"IMD_REQUEST_QTY"=N'36',"IMD_REQUIRED_DATE"=to_date('2019-03-30 23:59:00', 'YYYY-MM-DD HH24:MI:SS') ,"IMD_SALE_ORDER"=N'211003065',"IMD_SALE_ORDER_LINE"=N'15',"IMD_SALE_QTY"=N'36',"IMD_SALE_SHIPPED_QTY"=NULL,"IMD_SHIPMENT"=N'客户自提',"IMD_STATE"=N'3',"IMD_TAKE_COUNT"=N'36',"IMD_TYPE"=N'1',"IMD_TYPE_ID"=N'3',"IMD_TYPE_NAME"=N'挑库通知',"IMD_WH_FROM"=N'586',"IMD_WH_TO"=N'585',"ISDEL"=N'0',"LAST_UPDATER"=N'XIONGCH',"LAST_UPDATE_TIME"=to_date('2019-03-25 11:56:22', 'YYYY-MM-DD HH24:MI:SS') ,"REMARK"=NULL,"SYNC_TIME"=to_date('2019-03-22 10:07:27', 'YYYY-MM-DD HH24:MI:SS') ,"UPLOADER"=NULL,"UPLOAD_STATE"=N'0',"UPLOAD_TIME"=NULL,"UPLOAD_MSG"=NULL,"IMD_REL_ORDER_NUM"=NULL WHERE  "IMO_ID"=N'2853384';