and ${criterion.condition}
and ${criterion.condition} #{criterion.value}
and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
and ${criterion.condition}
#{listItem}
and ${criterion.condition}
and ${criterion.condition} #{criterion.value}
and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
and ${criterion.condition}
#{listItem}
WINDPLANT_NO, MODEL_NO, DATA_TIME, NRMSE, NMAE, BIAS, CORRELATION_COEFF, ACCURACY_RATE,
DATA_COUNT, DATA_FLAG
delete from WF_DA_PF_DAY_DATA
where WINDPLANT_NO = #{windplantNo,jdbcType=DECIMAL}
and MODEL_NO = #{modelNo,jdbcType=DECIMAL}
and DATA_TIME = #{dataTime,jdbcType=TIMESTAMP}
delete from WF_DA_PF_DAY_DATA
insert into WF_DA_PF_DAY_DATA (WINDPLANT_NO, MODEL_NO, DATA_TIME,
NRMSE, NMAE, BIAS, CORRELATION_COEFF,
ACCURACY_RATE, DATA_COUNT, DATA_FLAG
)
values (#{windplantNo,jdbcType=DECIMAL}, #{modelNo,jdbcType=DECIMAL}, #{dataTime,jdbcType=TIMESTAMP},
#{nrmse,jdbcType=FLOAT}, #{nmae,jdbcType=FLOAT}, #{bias,jdbcType=FLOAT}, #{correlationCoeff,jdbcType=FLOAT},
#{accuracyRate,jdbcType=FLOAT}, #{dataCount,jdbcType=DECIMAL}, #{dataFlag,jdbcType=DECIMAL}
)
insert into WF_DA_PF_DAY_DATA
WINDPLANT_NO,
MODEL_NO,
DATA_TIME,
NRMSE,
NMAE,
BIAS,
CORRELATION_COEFF,
ACCURACY_RATE,
DATA_COUNT,
DATA_FLAG,
#{windplantNo,jdbcType=DECIMAL},
#{modelNo,jdbcType=DECIMAL},
#{dataTime,jdbcType=TIMESTAMP},
#{nrmse,jdbcType=FLOAT},
#{nmae,jdbcType=FLOAT},
#{bias,jdbcType=FLOAT},
#{correlationCoeff,jdbcType=FLOAT},
#{accuracyRate,jdbcType=FLOAT},
#{dataCount,jdbcType=DECIMAL},
#{dataFlag,jdbcType=DECIMAL},
update WF_DA_PF_DAY_DATA
WINDPLANT_NO = #{record.windplantNo,jdbcType=DECIMAL},
MODEL_NO = #{record.modelNo,jdbcType=DECIMAL},
DATA_TIME = #{record.dataTime,jdbcType=TIMESTAMP},
NRMSE = #{record.nrmse,jdbcType=FLOAT},
NMAE = #{record.nmae,jdbcType=FLOAT},
BIAS = #{record.bias,jdbcType=FLOAT},
CORRELATION_COEFF = #{record.correlationCoeff,jdbcType=FLOAT},
ACCURACY_RATE = #{record.accuracyRate,jdbcType=FLOAT},
DATA_COUNT = #{record.dataCount,jdbcType=DECIMAL},
DATA_FLAG = #{record.dataFlag,jdbcType=DECIMAL},
update WF_DA_PF_DAY_DATA
set WINDPLANT_NO = #{record.windplantNo,jdbcType=DECIMAL},
MODEL_NO = #{record.modelNo,jdbcType=DECIMAL},
DATA_TIME = #{record.dataTime,jdbcType=TIMESTAMP},
NRMSE = #{record.nrmse,jdbcType=FLOAT},
NMAE = #{record.nmae,jdbcType=FLOAT},
BIAS = #{record.bias,jdbcType=FLOAT},
CORRELATION_COEFF = #{record.correlationCoeff,jdbcType=FLOAT},
ACCURACY_RATE = #{record.accuracyRate,jdbcType=FLOAT},
DATA_COUNT = #{record.dataCount,jdbcType=DECIMAL},
DATA_FLAG = #{record.dataFlag,jdbcType=DECIMAL}
update WF_DA_PF_DAY_DATA
NRMSE = #{nrmse,jdbcType=FLOAT},
NMAE = #{nmae,jdbcType=FLOAT},
BIAS = #{bias,jdbcType=FLOAT},
CORRELATION_COEFF = #{correlationCoeff,jdbcType=FLOAT},
ACCURACY_RATE = #{accuracyRate,jdbcType=FLOAT},
DATA_COUNT = #{dataCount,jdbcType=DECIMAL},
DATA_FLAG = #{dataFlag,jdbcType=DECIMAL},
where WINDPLANT_NO = #{windplantNo,jdbcType=DECIMAL}
and MODEL_NO = #{modelNo,jdbcType=DECIMAL}
and DATA_TIME = #{dataTime,jdbcType=TIMESTAMP}
update WF_DA_PF_DAY_DATA
set NRMSE = #{nrmse,jdbcType=FLOAT},
NMAE = #{nmae,jdbcType=FLOAT},
BIAS = #{bias,jdbcType=FLOAT},
CORRELATION_COEFF = #{correlationCoeff,jdbcType=FLOAT},
ACCURACY_RATE = #{accuracyRate,jdbcType=FLOAT},
DATA_COUNT = #{dataCount,jdbcType=DECIMAL},
DATA_FLAG = #{dataFlag,jdbcType=DECIMAL}
where WINDPLANT_NO = #{windplantNo,jdbcType=DECIMAL}
and MODEL_NO = #{modelNo,jdbcType=DECIMAL}
and DATA_TIME = #{dataTime,jdbcType=TIMESTAMP}