2021-04-05

<resultMap id="CustomerDa" type="com.atguigu.jxc.entity.Customer">              <result column="customer_id" property="customerId" jdbcType="INTEGER"/> 

            <result column="customer_name" property="customerName" jdbcType="VARCHAR"/>

             <result column="contacts" property="contacts" jdbcType="VARCHAR"/> 

             <result column="phone_number" property="phoneNumber" jdbcType="VARCHAR"/>

             <result column="address" property="address" jdbcType="VARCHAR"/> 

             <result column="remarks" property="remarks" jdbcType="VARCHAR"/></resultMap>

<insert id="insertCustomer" useGeneratedKeys="true" keyProperty="customerId" parameterType="com.atguigu.jxc.entity.Customer"> 

 insert into t_customer

(customer_name,contacts,phone_number,address,remarks)

   VALUES(#{customerName},#{contacts},#{phoneNumber},#{address},#{remarks})

</insert>

<delete id="deleteCustomer"> delete

            from t_customer

            where t_customer.customer_id =#{customerId}

</delete>

<update id="updateCustomer" parameterType="com.atguigu.jxc.entity.Customer"> 

             UPDATE t_customer

            <set>   

                         <if test="customerName != '' and customerName != null">            t_customer.customer_name =#{customerName},

                        </if>        

                        <if test="contacts != '' and contacts != null">                                    t_customer.contacts =#{contacts},

                        </if>        

                        <if test="phoneNumber != '' and phoneNumber != null">           

                         t_customer.phone_number =#{phoneNumber},

                        </if>       

                         <if test="address != '' and address != null">            t_customer.address =#{address},

                           </if>        

                            <if test="remarks != '' and remarks != null">            t_customer.remarks =#{remarks},

                            </if>  

                             </set>    WHERE t_customer.customer_id =#{customerId}

 </update>


<select id="getCustomerReturnlist" resultMap="BaseResultMap"> SELECT

t_customer_return_list.customer_return_list_id,

t_customer_return_list.return_number,

t_customer_return_list.return_date,

t_customer_return_list.amount_paid,

t_customer_return_list.amount_payable,

t_customer_return_list.state,

t_customer_return_list.customer_id,

t_customer_return_list.user_id,

t_customer_return_list.remarks,

t_user.true_name,

t_customer.customer_name

    FROM

t_customer_return_list

LEFT JOIN t_user ON t_customer_return_list.user_id = t_user.user_id

LEFT JOIN t_customer ON t_customer_return_list.customer_id = t_customer.customer_id

    <where>        

                    <if test="returnNumber != null and returnNumber != ''">            AND t_customer_return_list.return_number LIKE CONCAT('%',#{returnNumber} ,'%')

                       </if>      

                      <if test="customerId != null">            AND t_customer_return_list.customer_id =#{customerId}

                        </if>        

                        <if test="state != null">            AND t_customer_return_list.state =#{state}

                        </if>      

                        <if test="sTime != null and sTime != ''">            AND t_customer_return_list.return_date &gt;=#{sTime}

                        </if>        

                        <if test="eTime != null and eTime != ''">            AND t_customer_return_list.return_date &lt;=#{eTime}

                        </if>    

</where>

</select>

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容