<?xml version="1.0" encoding="utf-8" ?>

<sqlMap namespace="DepartmentInfoModel" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  >

  <alias>

    <typeAlias alias="DepartmentInfoModel" type="Dscf.Global.Employee.Model.DepartmentInfoModel,Dscf.Global" />

  </alias>

  <!--门店树 传参-->

  <parameterMaps>

    <parameterMap id="selectMap_Dept_DeptInfo" class="DepartmentInfoModel">

      <parameter property="Idenid" column="Idenid"/>

    </parameterMap>

  </parameterMaps>

  <resultMaps>

    <resultMap id="selectMap_T_DepartmentInfo" class="DepartmentInfoModel">

      <result property="DepId" column="DepId"/>

      <result property="DepName" column="DepName"/>

      <result property="ParentDepId" column="ParentDepId"/>

      <result property="DepCode" column="DepCode"/>

      <result property="CustomerServicePhone" column="CustomerServicePhone"/>

      <result property="RevolvingLoanPhone" column="RevolvingLoanPhone"/>

      <result property="EarlyRepayPhone" column="EarlyRepayPhone"/>

      <result property="Email" column="Email"/>

      <result property="SignAddress" column="SignAddress"/>

      <result property="SignZipCode" column="SignZipCode"/>

      <result property="IsDeleted" column="IsDeleted"/>

      <result property="SignCity" column="SignCity"/>

      <result property="IsEnable" column="IsEnable"/>

      <result property="LastOperateId" column="LastOperateId"/>

      <result property="LastUpdateTime" column="LastUpdateTime"/>

      <result property="CreateTime" column="CreateTime"/>

      <result property="OperateId" column="OperateId"/>

      <result property="IsReceiveEmail" column="IsReceiveEmail"/>

    </resultMap>

    <!--门店树 返回值 -->

    <resultMap id="selectMap_T_DepartmentInfoTree" class="DepartmentInfoModel">

      <result property="DepId" column="DepId"/>

      <result property="SignZipCode" column="SignZipCode"/>

      <result property="IsDeleted" column="IsDeleted"/>

      <result property="SignCity" column="SignCity"/>

      <result property="IsEnable" column="IsEnable"/>

      <result property="LastOperateId" column="LastOperateId"/>

      <result property="LastUpdateTime" column="LastUpdateTime"/>

      <result property="CreateTime" column="CreateTime"/>

      <result property="OperateId" column="OperateId"/>

      <result property="DepName" column="DepName"/>

      <result property="ParentDepId" column="ParentDepId"/>

      <result property="DepCode" column="DepCode"/>

      <result property="CustomerServicePhone" column="CustomerServicePhone"/>

      <result property="RevolvingLoanPhone" column="RevolvingLoanPhone"/>

      <result property="EarlyRepayPhone" column="EarlyRepayPhone"/>

      <result property="Email" column="Email"/>

      <result property="SignAddress" column="SignAddress"/>

      <result property="ParentName" column="ParentName"/>

      <result property="sort" column="sort"/>

      <result property="level" column="level"/>

      <result property="IsReceiveEmail" column="IsReceiveEmail"/>

    </resultMap>

  </resultMaps>

  <statements>

    <!-- 查询  需要后动修改分页时的排序字段 -->

    <select id="select_T_DepartmentInfo" resultMap="selectMap_T_DepartmentInfo"   resultClass="DepartmentInfoModel"      parameterClass="DepartmentInfoModel">

      SELECT

      <isNotNull property="TopNums">

        <![CDATA[ top $TopNums$]]>

      </isNotNull>

      MAX(row_n) over(partition by ) as TotalItems, *

      FROM

      (

      <!-- ********* 必须要修改 order by a.Id ********* -->

      SELECT ROW_NUMBER() OVER ( PARTITION BY  ORDER BY a.DepId) AS row_n,a.DepId,a.DepName,a.ParentDepId,a.DepCode,a.CustomerServicePhone,a.RevolvingLoanPhone,a.EarlyRepayPhone,a.Email,a.SignAddress,a.SignZipCode,a.IsDeleted,a.SignCity,a.IsEnable,a.LastOperateId,a.LastUpdateTime,a.CreateTime,a.OperateId,a.IsReceiveEmail

      FROM  T_DepartmentInfo as a

      <dynamic prepend="where">

        <isNotNull prepend="and" property="DepId">

          <![CDATA[ a.DepId=#DepId#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="IsReceiveEmail">

          <![CDATA[ a.IsReceiveEmail=#IsReceiveEmail#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="DepName">

          <![CDATA[ a.DepName=#DepName#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="ParentDepId">

          <![CDATA[ a.ParentDepId=#ParentDepId#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="DepCode">

          <![CDATA[ a.DepCode=#DepCode#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="CustomerServicePhone">

          <![CDATA[ a.CustomerServicePhone=#CustomerServicePhone#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="RevolvingLoanPhone">

          <![CDATA[ a.RevolvingLoanPhone=#RevolvingLoanPhone#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="EarlyRepayPhone">

          <![CDATA[ a.EarlyRepayPhone=#EarlyRepayPhone#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="Email">

          <![CDATA[ a.Email=#Email#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="SignAddress">

          <![CDATA[ a.SignAddress=#SignAddress#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="SignZipCode">

          <![CDATA[ a.SignZipCode=#SignZipCode#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="IsDeleted">

          <![CDATA[ a.IsDeleted=#IsDeleted#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="SignCity">

          <![CDATA[ a.SignCity=#SignCity#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="IsEnable">

          <![CDATA[ a.IsEnable=#IsEnable#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="LastOperateId">

          <![CDATA[ a.LastOperateId=#LastOperateId#  ]]>

        </isNotNull>

        <isNotNull prepend="and" property="LastUpdateTime_B">

          <![CDATA[ a.LastUpdateTime>=#LastUpdateTime_B# ]]>

        </isNotNull>

        <isNotNull prepend="and" property="LastUpdateTime_E">

          <![CDATA[ a.LastUpdateTime<=#LastUpdateTime_E# ]]>

        </isNotNull>

        <isNotNull prepend="and" property="CreateTime_B">

          <![CDATA[ a.CreateTime>=#CreateTime_B# ]]>

        </isNotNull>

        <isNotNull prepend="and" property="CreateTime_E">

          <![CDATA[ a.CreateTime<=#CreateTime_E# ]]>

        </isNotNull>

        <isNotNull prepend="and" property="OperateId">

          <![CDATA[ a.OperateId=#OperateId#  ]]>

        </isNotNull>

        <!-- 一个例子 -->

        <!--<isNotEmpty prepend="and" property="属性名">

                       字段名 like  #属性名# 

               </isNotEmpty>-->

      </dynamic>

      ) as a

      <dynamic prepend="where">

        <isNotNull property="PrevPageNums">

          <![CDATA[ a.row_n>$PrevPageNums$]]>

        </isNotNull>

      </dynamic>

    </select>

    <!-- 数据分析 树-->

    <procedure id="select_T_DepartmentInfoTree" parameterMap="selectMap_Dept_DeptInfo"  resultMap="selectMap_T_DepartmentInfoTree" >

      Proc_LoanStorDept

    </procedure>

    <!-- 添加 -->

    <insert id="insert_T_DepartmentInfo" parameterClass="DepartmentInfoModel">

      <selectKey property="DepId" type="post" resultClass="int">

        ${selectKey}

      </selectKey>

      INSERT INTO T_DepartmentInfo

      (

      DepName,ParentDepId,DepCode,CustomerServicePhone,RevolvingLoanPhone,EarlyRepayPhone,Email,SignAddress,SignZipCode,IsDeleted,SignCity,IsEnable,LastOperateId,LastUpdateTime,CreateTime,OperateId,IsReceiveEmail

      ) VALUES

      (

      #DepName#,#ParentDepId#,#DepCode#,#CustomerServicePhone#,#RevolvingLoanPhone#,#EarlyRepayPhone#,#Email#,#SignAddress#,#SignZipCode#,#IsDeleted#,#SignCity#,#IsEnable#,#LastOperateId#,#LastUpdateTime#,#CreateTime#,#OperateId#,#IsReceiveEmail#

      )

    </insert>

    <!-- 更新  -->

    <update id="update_T_DepartmentInfo" parameterClass="DepartmentInfoModel">

      UPDATE T_DepartmentInfo SET

      DepName=#DepName#,

      ParentDepId=#ParentDepId#,

      DepCode=#DepCode#,

      CustomerServicePhone=#CustomerServicePhone#,

      RevolvingLoanPhone=#RevolvingLoanPhone#,

      EarlyRepayPhone=#EarlyRepayPhone#,

      Email=#Email#,

      SignAddress=#SignAddress#,

      SignZipCode=#SignZipCode#,

      IsDeleted=#IsDeleted#,

      SignCity=#SignCity#,

      IsEnable=#IsEnable#,

      LastOperateId=#LastOperateId#,

      LastUpdateTime=#LastUpdateTime#,

      CreateTime=#CreateTime#,

      OperateId=#OperateId#,

      IsReceiveEmail=#IsReceiveEmail#

      <!--  -->

      WHERE T_DepartmentInfo.DepId=#DepId#

    </update>

    <!--删除-->

    <delete id="delete_T_DepartmentInfo" parameterClass="DepartmentInfoModel">

      DELETE FROM T_DepartmentInfo where DepId=#DepId#

    </delete>

    <!-- 删除-->

    <delete id="delete_flag_T_DepartmentInfo" parameterClass="DepartmentInfoModel">

      UPDATE  T_DepartmentInfo set IsDeleted =  where DepId=#DepId#

    </delete>

  </statements>

</sqlMap>   

最新文章

  1. Struts2.X——搭建
  2. Oracle索引梳理系列（七）- Oracle唯一索引、普通索引及约束的关系
  3. 在Ubuntu上安装LAMP服务器
  4. POJ 3259 Wormholes （判负环）
  5. 。。。contentType与pageEncoding的区别。。。
  6. GridView中的编辑和删除按钮，执行更新和删除代码之前的更新提示或删除提示
  7. dom4解析xml格式文件实例
  8. Redis API的原子性分析
  9. serversql数据库的查询操作
  10. C# - 什么是事件绑定？
  11. 【论文速读】Multi-Oriented Scene Text Detection via Corner Localization and Region Segmentation[2018-CPVR]
  12. python_01
  13. C++获取数组的长度
  14. [蓝桥杯]PREV-8.历届试题_买不到的数目
  15. Spring Boot 2.0 入门指南
  16. Java中异常发生时代码执行流程
  17. ArcGIS 10.2 链接64位Oracle数据库
  18. 【struts2】预定义拦截器
  19. sql多行合并成一行用逗号隔开，多表联合查询中子查询取名可重复
  20. （二）JNI方法总结

热门文章

  1. [HTMLDOM]删除已有的 HTML 元素
  2. hdu 5444 Elven Postman 二叉树
  3. [MySQL] 两个优化数据库表的简单方法--18.3
  4. c++学习-继承
  5. 张恭庆编《泛函分析讲义》第二章第2节 $Riesz$ 定理及其应用习题解答
  6. Xshell5最新版激活
  7. Python标准库02 时间与日期 (time, datetime包)
  8. 20145305《JAVA程序设计》实验二
  9. MySQL 字符串 转 int/double CAST与CONVERT 函数的用法
  10. T4 assembly