dyDeliver/conf/sqlroot/com/dderp/business/dao/OutAssistDao.dql

-- [queryOutAssistInfo]
select * from $table$;

-- [addOutAssistInfo]
insert into $table$ (id, outAssistName, assistType, workType,
                     workQuality, settleType, contactMan,
                     contactPhone, outAssistCode, province,
                     city, area, address,
                     remark, enable, factorySyncKey,
                     dataBaseAlias, shardingKey, contractUrl, submitOnAllocation, sortIndex,capacity,needPackMaterial,
                     createBy, createTime,
                     updateBy, updateTime ) values ( #{id}, #{outassistname}, #{assisttype}, #{worktype},
                                                                     #{workquality}, #{settletype}, #{contactman},
                                                                     #{contactphone}, #{outassistcode}, #{province},
                                                                     #{city}, #{area}, #{address},
                                                                     #{remark}, #{enable}, #{factorysynckey},
                                                                     #{databasealias}, #{shardingkey}, #{contracturl}, #{submitonallocation}, #{sortindex}, #{capacity}, #{needpackmaterial},
                                                                     #{createby}, #{createtime},
                                                                     #{updateby}, #{updatetime} );

-- [updateOutAssistInfo]
       update $table$ set outAssistName = #{outassistname},assistType = #{assisttype},workType = #{worktype},workQuality = #{workquality},
       settleType = #{settletype},contactMan = #{contactman},contactPhone = #{contactphone},outAssistCode = #{outassistcode},
       province = #{province},city = #{city},area = #{area},address = #{address}, dataBaseAlias = #{databasealias}, shardingKey = #{shardingkey},
       remark = #{remark}, contractUrl = #{contracturl}, submitOnAllocation = #{submitonallocation}, sortIndex = #{sortindex}, capacity = #{capacity},
       needPackMaterial = #{needpackmaterial}, updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};

-- [enableOutAssistInfo]
       update $table$ set enable = #{enable},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};

-- [generateOutAssistSyncKey]
       update $table$ set factorySyncKey = #{factorysynckey},
       updateBy = #{updateby},updateTime = #{updatetime}
       where id = #{id};