/**
* 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();
}