| | |
| | | <if test="shopId != null and shopId !='' "> |
| | | SHOP_ID = #{shopId}, |
| | | </if> |
| | | <if test="isDelete != null and isDelete !='' "> |
| | | IS_DELETE = #{isDelete}, |
| | | </if> |
| | | <if test="passWord != null and passWord !='' "> |
| | | PASSWORD = #{passWord}, |
| | | </if> |
| | |
| | | <if test="record.shopId != null and record.shopId !='' "> |
| | | and a.SHOP_ID = #{record.shopId} |
| | | </if> |
| | | <if test="record.isDelete != null and record.isDelete !='' "> |
| | | and a.IS_DELETE = #{record.isDelete} |
| | | </if> |
| | | <if test="record.passWord != null and record.passWord !='' "> |
| | | and a.PASSWORD = #{record.passWord} |
| | | </if> |
| | |
| | | |
| | | |
| | | <sql id="where1"> |
| | | where 1=1 |
| | | where a.IS_DELETE = 'N' |
| | | <if test="record!=null"> |
| | | <if test="record.id != null and record.id !='' "> |
| | | and a.ID = #{record.id} |
| | |
| | | </if> |
| | | <if test="record.shopId != null and record.shopId !='' "> |
| | | and a.SHOP_ID = #{record.shopId} |
| | | </if> |
| | | <if test="record.isDelete != null and record.isDelete !='' "> |
| | | and a.IS_DELETE = #{record.isDelete} |
| | | </if> |
| | | <if test="record.passWord != null and record.passWord !='' "> |
| | | and a.PASSWORD = #{record.passWord} |