<resultMap id="ThirdPartyAccountDetailResultMap" class="Bizcent.Model.MDM.ThirdPartyAccountDetailInfo">
<result property="ThirdPartyCode" column="ThirdPartyCode" />
<result property="ChargeType" column="ChargeType" />
<result property="PaymentModeCode" column="PaymentModeCode" />
<result property="PaymentModeName" column="PaymentName" />
<result property="IsRecordCust" column="IsRecordCust"/>
<result property="CustomerCode" column="CustomerCode" />
<result property="CustomerName" column="CustomerName" />
<result property="GoodsCode" column="GoodsCode" />
<result property="IsInERP" column="IsInERP"/>
</resultMap>
<select id="LoadDetail" parameterClass="hashtable" resultMap="ThirdPartyAccountDetailResultMap">
select p.ThirdPartyCode,p.ChargeType,p.PaymentModeCode,s.PaymentName,p.IsRecordCust,p.CustomerCode,sc.CustomerName,p.GoodsCode,p.IsInERP from "$tablehead$".tbPlatformAccountDetail p
left join "$tablehead$".tbSellPayment s on p.PaymentModeCode=s.PaymentCode
left join "$tablehead$".tbStoreCustomers sc on p.CustomerCode=sc.CustomerCode
where ThirdPartyCode='$ThirdPartyCode$'
order by ChargeType
</select>
sql語句需要對應(yīng)column即數(shù)據(jù)庫中表的列名奠衔，property對應(yīng)的則是實體類（model）的字段沟优，不對應(yīng)的話會報這樣的錯
