YONGHU-ERP/src/main/resources/sql/erp.sql

#sql("selectBarCode")
    select * from ERP_PRO_BARCODE where wms_mark = 'N'
#end

#sql("updateBarCode")
    update ERP_PRO_BARCODE set wms_mark = 'Y' where BARCODE = #para(barcode)
#end

#sql("selectProType")
    select * from ERP_PRO_TYPE where wms_mark = 'N'
#end

#sql("updateProType")
    update ERP_PRO_TYPE set wms_mark = 'Y' where p_type_id = #para(typeId)
#end

#sql("selectProOb")
    select * from ERP_PRO_OB where wms_mark = 'N'
#end

#sql("updateProOb")
    update ERP_PRO_OB set wms_mark = 'Y' where ima01 = #para(ima01)
#end

#sql("selectOrderList")
    select * from ERP_ORDER_LIST where wms_mark = 'N'
#end

#sql("updateOrderList")
    update ERP_ORDER_LIST set wms_mark = 'Y' where order_no = #para(orderNo) and order_name = #para(orderName)
#end

#sql("updateErpStatus")
    update ERP_ORDER_LIST set ORDER_STATE = #para(orderState)
    where order_no = #para(orderNo) and order_name = #para(orderName)
#end

#sql("insertBarcodeList")
    INSERT INTO [dbo].[ERP_BARCODE_LIST]
    (    [BARCODE]
        ,[ORDER_NAME]
        ,[ORDER_NO]
        ,[QTY]
        ,[ORDER_TYPE]
        ,[IN_OUT]
        ,[STOCKID]
        ,[BOXID]
        ,[ERP_RESULT]
        ,[VALID]
        ,[CREATE_USER]
        ,[CREATE_DATE]
        ,[DB])
    VALUES
        ( #para(barcode)
            , #para(orderName)
            , #para(orderNo)
            , #para(qty)
            , #para(orderType)
            , #para(inout)
            , #para(stockID)
            , #para(boxid)
            , #para(erpResult)
            , #para(valid)
            , #para(createUser)
            , #para(createDate)
            , 'YH'
        )
#end

#sql("updateBarcodeList")
    UPDATE ERP_BARCODE_LIST
        SET `VALID` = #para(valid)
    WHERE ORDER_NO = #para(orderNo)
    AND ORDER_NAME = #para(orderName)
    AND BARCODE = #para(barcode)
#end