<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper
namespace="org.kingc.NationalBureauExpertEvaluatioSystem.dao.EnterPriseInfoDaoB">
<resultMap id="BaseResultMap2"
type="org.kingc.NationalBureauExpertEvaluatioSystem.model.EnterPriseInfoB">
<id column="FGUID" property="fguid" jdbcType="VARCHAR" />
<result column="FName" property="fname" jdbcType="VARCHAR" />
<result column="FPerson" property="fperson" jdbcType="VARCHAR" />
<result column="FExecutivemembership" property="fexecutivemembership"
jdbcType="VARCHAR" />
<result column="FAssetsundership" property="fassetsundership"
jdbcType="VARCHAR" />
<result column="FSecuritymembership" property="fsecuritymembership"
jdbcType="VARCHAR" />
<result column="FRelationTel" property="frelationtel" jdbcType="VARCHAR" />
<result column="FPostalcode" property="fpostalcode" jdbcType="VARCHAR" />
<result column="FAddress" property="faddress" jdbcType="VARCHAR" />
<result column="FLevel" property="flevel" jdbcType="INTEGER" />
<result column="FParent" property="fparent" jdbcType="VARCHAR" />
<result column="FEnterpriseType" property="fenterprisetype"
jdbcType="INTEGER" />
<result column="FIsDeleted" property="fisdeleted" jdbcType="BIT" />
<result column="FModifyTime" property="fmodifytime" jdbcType="TIMESTAMP" />
<result column="FModifyer" property="fmodifyer" jdbcType="VARCHAR" />
<result column="FEnterpriseCategory" property="fenterprisecategory"
jdbcType="INTEGER" />
<result column="FPlace" property="fplace" jdbcType="INTEGER" />
<result column="FCoalMineScale" property="fcoalminescale"
jdbcType="INTEGER" />
<result column="FIsVerify" property="fisverify" jdbcType="BIT" />
<result column="coaltype" property="coaltype" jdbcType="VARCHAR" />
<result column="Fprovince" property="fprovince" jdbcType="VARCHAR" />
<result column="Fcounty" property="fcounty" jdbcType="VARCHAR" />
<result column="Fcity" property="fcity" jdbcType="VARCHAR" />
<result column="FPeriod" property="fperiod" jdbcType="TIMESTAMP" />
<result column="Frank" property="frank" jdbcType="INTEGER" />
<result column="cmddtime" property="cmddtime" jdbcType="TIMESTAMP" />
<result column="taskayear" property="taskayear" jdbcType="INTEGER" />
<result column="cmddreason" property="cmddreason" jdbcType="VARCHAR" />
<result column="cmddrank" property="cmddrank" jdbcType="VARCHAR" />
<result column="cancellation" property="cancellation" jdbcType="VARCHAR" />
<result column="cantime" property="cantime" jdbcType="TIMESTAMP" />
<association property="rminemscore" javaType="org.kingc.NationalBureauExpertEvaluatioSystem.model.EvaluationResults">
<result property="rminemscore" column="rminemscore" jdbcType="FLOAT"/>
</association>
</resultMap>
<sql id="Base_Column_List">
FGUID, FName, FPerson, FExecutivemembership,
FAssetsundership,
FSecuritymembership,
FRelationTel, FPostalcode,
FAddress, FLevel, FParent, FEnterpriseType, FIsDeleted,
FModifyTime,
FModifyer, FEnterpriseCategory, FPlace, FCoalMineScale,
FIsVerify,
coaltype,
Fprovince, Fcounty, Fcity, FPeriod, Frank, cmddtime,
taskayear, cmddreason,
cmddrank,
cancellation, cantime
</sql>
<select id="findEnterPriseInfo" resultMap="BaseResultMap2">
select v.FGUID,v.Fprovince,v.Fcity,v.FName,v.taskayear,v.FModifyTime,c.rminemscore,c.minelevel from t_EnterpriseInfo v, EvaluationResults c where
v.FGUID=c.FGUID
</select>
<update id="updateEnterPriseInfo"
parameterType="org.kingc.NationalBureauExpertEvaluatioSystem.model.EnterPriseInfo" >
UPDATE t_EnterpriseInfo
<set>
<if test=" cmddReason!= null"><!--降级原因 -->
cmddreason = #{cmddReason, jdbcType=VARCHAR},
</if>
<if test=" cmddTime!= null"><!--降级时间 -->
cmddtime = #{cmddTime, jdbcType=VARCHAR},
</if>
<if test=" cmddRank!= null"><!--降级时间 -->
cmddrank = #{cmddRank, jdbcType=VARCHAR},
</if>
</set>
WHERE FGUID = #{fguid,jdbcType=VARCHAR}
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper
namespace="org.kingc.NationalBureauExpertEvaluatioSystem.dao.EnterPriseInfoDaoB">
<resultMap id="BaseResultMap2"
type="org.kingc.NationalBureauExpertEvaluatioSystem.model.EnterPriseInfoB">
<id column="FGUID" property="fguid" jdbcType="VARCHAR" />
<result column="FName" property="fname" jdbcType="VARCHAR" />
<result column="FPerson" property="fperson" jdbcType="VARCHAR" />
<result column="FExecutivemembership" property="fexecutivemembership"
jdbcType="VARCHAR" />
<result column="FAssetsundership" property="fassetsundership"
jdbcType="VARCHAR" />
<result column="FSecuritymembership" property="fsecuritymembership"
jdbcType="VARCHAR" />
<result column="FRelationTel" property="frelationtel" jdbcType="VARCHAR" />
<result column="FPostalcode" property="fpostalcode" jdbcType="VARCHAR" />
<result column="FAddress" property="faddress" jdbcType="VARCHAR" />
<result column="FLevel" property="flevel" jdbcType="INTEGER" />
<result column="FParent" property="fparent" jdbcType="VARCHAR" />
<result column="FEnterpriseType" property="fenterprisetype"
jdbcType="INTEGER" />
<result column="FIsDeleted" property="fisdeleted" jdbcType="BIT" />
<result column="FModifyTime" property="fmodifytime" jdbcType="TIMESTAMP" />
<result column="FModifyer" property="fmodifyer" jdbcType="VARCHAR" />
<result column="FEnterpriseCategory" property="fenterprisecategory"
jdbcType="INTEGER" />
<result column="FPlace" property="fplace" jdbcType="INTEGER" />
<result column="FCoalMineScale" property="fcoalminescale"
jdbcType="INTEGER" />
<result column="FIsVerify" property="fisverify" jdbcType="BIT" />
<result column="coaltype" property="coaltype" jdbcType="VARCHAR" />
<result column="Fprovince" property="fprovince" jdbcType="VARCHAR" />
<result column="Fcounty" property="fcounty" jdbcType="VARCHAR" />
<result column="Fcity" property="fcity" jdbcType="VARCHAR" />
<result column="FPeriod" property="fperiod" jdbcType="TIMESTAMP" />
<result column="Frank" property="frank" jdbcType="INTEGER" />
<result column="cmddtime" property="cmddtime" jdbcType="TIMESTAMP" />
<result column="taskayear" property="taskayear" jdbcType="INTEGER" />
<result column="cmddreason" property="cmddreason" jdbcType="VARCHAR" />
<result column="cmddrank" property="cmddrank" jdbcType="VARCHAR" />
<result column="cancellation" property="cancellation" jdbcType="VARCHAR" />
<result column="cantime" property="cantime" jdbcType="TIMESTAMP" />
<association property="rminemscore" javaType="org.kingc.NationalBureauExpertEvaluatioSystem.model.EvaluationResults">
<result property="rminemscore" column="rminemscore" jdbcType="FLOAT"/>
</association>
</resultMap>
<sql id="Base_Column_List">
FGUID, FName, FPerson, FExecutivemembership,
FAssetsundership,
FSecuritymembership,
FRelationTel, FPostalcode,
FAddress, FLevel, FParent, FEnterpriseType, FIsDeleted,
FModifyTime,
FModifyer, FEnterpriseCategory, FPlace, FCoalMineScale,
FIsVerify,
coaltype,
Fprovince, Fcounty, Fcity, FPeriod, Frank, cmddtime,
taskayear, cmddreason,
cmddrank,
cancellation, cantime
</sql>
<select id="findEnterPriseInfo" resultMap="BaseResultMap2">
select v.FGUID,v.Fprovince,v.Fcity,v.FName,v.taskayear,v.FModifyTime,c.rminemscore,c.minelevel from t_EnterpriseInfo v, EvaluationResults c where
v.FGUID=c.FGUID
</select>
<update id="updateEnterPriseInfo"
parameterType="org.kingc.NationalBureauExpertEvaluatioSystem.model.EnterPriseInfo" >
UPDATE t_EnterpriseInfo
<set>
<if test=" cmddReason!= null"><!--降级原因 -->
cmddreason = #{cmddReason, jdbcType=VARCHAR},
</if>
<if test=" cmddTime!= null"><!--降级时间 -->
cmddtime = #{cmddTime, jdbcType=VARCHAR},
</if>
<if test=" cmddRank!= null"><!--降级时间 -->
cmddrank = #{cmddRank, jdbcType=VARCHAR},
</if>
</set>
WHERE FGUID = #{fguid,jdbcType=VARCHAR}
</update>
</mapper>