select count(*) AS count from rpt_jiayouzhouqibiao where KehuID=#{KehuID}
UPDATE rpt_jiayouzhouqibiao SET
KehuName = #{KehuName},
Yewuyuan = #{Yewuyuan},
Chanpin = #{Chanpin},
LastTankDate = #{LastTankDate},
BeforeLastTankDate = #{BeforeLastTankDate},
Shuliang = #{Shuliang},
Pingjunshuliang = #{Pingjunshuliang},
NextTankDate = #{NextTankDate},
TankPeroid = #{TankPeroid},
UpdateTime = getDate()
WHERE KehuID = #{KehuID}
INSERT INTO rpt_jiayouzhouqibiao(
KehuID,
KehuName,
Yewuyuan,
Chanpin,
LastTankDate,
BeforeLastTankDate,
Shuliang,
Pingjunshuliang,
NextTankDate,
TankPeroid,
CreateTime
) VALUES (
#{KehuID},
#{KehuName},
#{Yewuyuan},
#{Chanpin},
#{LastTankDate},
#{BeforeLastTankDate},
#{Shuliang},
#{Pingjunshuliang},
#{NextTankDate},
#{TankPeroid},
getDate()
)