<statements>
    <select id="SelectAllPerson" parameterClass="int" resultMap="SelectAllResult" >
     
      <![CDATA[ select f_id, f_title, f_keyword, f_brief, f_mid, f_cid, f_type,  (case f_del when 0 then '启用' else '禁用' end) f_del, f_time from TS_WEB_S_T_Article_Main ]]>
      <dynamic prepend="WHERE">
        <isNotEmpty prepend=" and" property="f_title">
          f_title like '%$f_title$%'  
        </isNotEmpty>
        <isNotEmpty prepend=" and" property="f_id">
          f_id = #f_id#
        </isNotEmpty>
        <isGreaterThan prepend=" and" property="StartTime"  compareValue="1900-1-1">
          <![CDATA[
          f_time >= #StartTime#
          ]]>

        </isGreaterThan>
        <isGreaterThan prepend=" and" property="EndTime"  compareValue="1900-1-1">
          <![CDATA[
          f_time <= #EndTime#
           ]]>
        </isGreaterThan>
      </dynamic>
    </select>

    <insert  id="GetAppealByMul" parameterClass="Domain.personlist" resultClass="int">
      　       insert into TS_WEB_S_T_Article_Main( f_title, f_keyword, f_brief, f_time) values( #f_title#, #f_keyword#, f_brief#, #f_time#) 　
    </insert >
    <!--删除-->
    <delete id="DeleteOne" resultMap="SelectAllResult">
      Delete TS_WEB_S_T_Article_Main Where f_id = #f_id#
    </delete>
    
    
  </statements> 



public int InsertQuery(TS_WEB_S_T_Article_Main ts)
        {
            ISqlMapper mapper = Mapper.Instance();
            int result = (int)mapper.Insert("GetAppealByMul", ts);
            return result;
        }