/** * This method was generated by MyBatis Generator. This method corresponds to the database table * `agentaccountlog` * * @mbggenerated */ public String insertSelective(FinalAgentaccountLog record) { SQL sql = new SQL(); sql.INSERT_INTO("`agentaccountlog`"); if (record.getAgentaccountlogid() != null) { sql.VALUES("agentAccountLogId", "#{agentaccountlogid,jdbcType=VARCHAR}"); } if (record.getAgentid() != null) { sql.VALUES("agentId", "#{agentid,jdbcType=INTEGER}"); } if (record.getAgentuserid() != null) { sql.VALUES("agentUserId", "#{agentuserid,jdbcType=INTEGER}"); } if (record.getAgentusername() != null) { sql.VALUES("agentUserName", "#{agentusername,jdbcType=VARCHAR}"); } if (record.getOrderid() != null) { sql.VALUES("orderId", "#{orderid,jdbcType=VARCHAR}"); } if (record.getType() != null) { sql.VALUES("type", "#{type,jdbcType=INTEGER}"); } if (record.getBiztype() != null) { sql.VALUES("bizType", "#{biztype,jdbcType=INTEGER}"); } if (record.getPrice() != null) { sql.VALUES("price", "#{price,jdbcType=INTEGER}"); } if (record.getContent() != null) { sql.VALUES("content", "#{content,jdbcType=VARCHAR}"); } if (record.getComment() != null) { sql.VALUES("comment", "#{comment,jdbcType=VARCHAR}"); } if (record.getTips() != null) { sql.VALUES("tips", "#{tips,jdbcType=VARCHAR}"); } if (record.getBizstatus() != null) { sql.VALUES("bizStatus", "#{bizstatus,jdbcType=INTEGER}"); } if (record.getPaytype() != null) { sql.VALUES("payType", "#{paytype,jdbcType=INTEGER}"); } if (record.getBizcomment() != null) { sql.VALUES("bizComment", "#{bizcomment,jdbcType=VARCHAR}"); } if (record.getUpdatedAt() != null) { sql.VALUES("updated_at", "#{updatedAt,jdbcType=TIMESTAMP}"); } if (record.getCreatedAt() != null) { sql.VALUES("created_at", "#{createdAt,jdbcType=TIMESTAMP}"); } return sql.toString(); }
/** * This method was generated by MyBatis Generator. This method corresponds to the database table * `agentaccountlog` * * @mbggenerated */ public String updateByExampleSelective(Map<String, Object> parameter) { FinalAgentaccountLog record = (FinalAgentaccountLog) parameter.get("record"); FinalAgentaccountLogCriteria example = (FinalAgentaccountLogCriteria) parameter.get("example"); SQL sql = new SQL(); sql.UPDATE("`agentaccountlog`"); if (record.getAgentaccountlogid() != null) { sql.SET("agentAccountLogId = #{record.agentaccountlogid,jdbcType=VARCHAR}"); } if (record.getAgentid() != null) { sql.SET("agentId = #{record.agentid,jdbcType=INTEGER}"); } if (record.getAgentuserid() != null) { sql.SET("agentUserId = #{record.agentuserid,jdbcType=INTEGER}"); } if (record.getAgentusername() != null) { sql.SET("agentUserName = #{record.agentusername,jdbcType=VARCHAR}"); } if (record.getOrderid() != null) { sql.SET("orderId = #{record.orderid,jdbcType=VARCHAR}"); } if (record.getType() != null) { sql.SET("type = #{record.type,jdbcType=INTEGER}"); } if (record.getBiztype() != null) { sql.SET("bizType = #{record.biztype,jdbcType=INTEGER}"); } if (record.getPrice() != null) { sql.SET("price = #{record.price,jdbcType=INTEGER}"); } if (record.getContent() != null) { sql.SET("content = #{record.content,jdbcType=VARCHAR}"); } if (record.getComment() != null) { sql.SET("comment = #{record.comment,jdbcType=VARCHAR}"); } if (record.getTips() != null) { sql.SET("tips = #{record.tips,jdbcType=VARCHAR}"); } if (record.getBizstatus() != null) { sql.SET("bizStatus = #{record.bizstatus,jdbcType=INTEGER}"); } if (record.getPaytype() != null) { sql.SET("payType = #{record.paytype,jdbcType=INTEGER}"); } if (record.getBizcomment() != null) { sql.SET("bizComment = #{record.bizcomment,jdbcType=VARCHAR}"); } if (record.getUpdatedAt() != null) { sql.SET("updated_at = #{record.updatedAt,jdbcType=TIMESTAMP}"); } if (record.getCreatedAt() != null) { sql.SET("created_at = #{record.createdAt,jdbcType=TIMESTAMP}"); } applyWhere(sql, example, true); return sql.toString(); }